Get zones instead of countries for dashboard map

Code: Select all

$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(" . implode(',', $implode) . ") GROUP BY o.payment_country_id");

Code: Select all

$query = $this->db->query("SELECT COUNT(*) AS total, SUM(o.total) AS amount, z.code FROM `" . DB_PREFIX . "order` o LEFT JOIN `" . DB_PREFIX . "zone` z ON (o.payment_zone_id = z.zone_id) LEFT JOIN `" . DB_PREFIX . "country` c ON (z.country_id=c.country_id) WHERE o.order_status_id IN(" . implode(',', $implode) . ") AND c.name='Sweden' GROUP BY o.payment_zone_id");

Code: Select all

$json[strtolower($result['code'])] = array(
	'total'  => $result['total'],
	'amount' => $this->currency->format($result['amount'], $this->config->get('config_currency'))
);

Code: Select all

<script type="text/javascript" src="view/javascript/jquery/jqvmap/maps/{your_jqvmap.js}"></script>