diff options
Diffstat (limited to 'public/admin/model/extension/dashboard/map.php')
| -rw-r--r-- | public/admin/model/extension/dashboard/map.php | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/public/admin/model/extension/dashboard/map.php b/public/admin/model/extension/dashboard/map.php new file mode 100644 index 0000000..b108156 --- /dev/null +++ b/public/admin/model/extension/dashboard/map.php @@ -0,0 +1,20 @@ +<?php +class ModelExtensionDashboardMap extends Model { + public function getTotalOrdersByCountry() { + $implode = array(); + + if (is_array($this->config->get('config_complete_status'))) { + foreach ($this->config->get('config_complete_status') as $order_status_id) { + $implode[] = (int)$order_status_id; + } + } + + if ($implode) { + $query = $this->db->query("SELECT COUNT(*) AS total, SUM(o.total) AS amount, c.iso_code_2 FROM `" . DB_PREFIX . "order` o LEFT JOIN `" . DB_PREFIX . "country` c ON (o.payment_country_id = c.country_id) WHERE o.order_status_id IN('" . (int)implode(',', $implode) . "') GROUP BY o.payment_country_id"); + + return $query->rows; + } else { + return array(); + } + } +}
\ No newline at end of file |