按区域获取订单总数

Question

在管理面板opencart有一个世界地图，并按国家显示总订单。我可以改变地图由国家，并需要获得地区的总订单，但标准获得国家的订单。如何改变？

​

public function getTotalOrdersByCountry() {
		$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 > '0' GROUP BY o.payment_country_id");

		return $query->rows;
	}

​

它的代码来自控制器

Answer 1

$query = $this->db->query("SELECT COUNT(*) AS total, SUM(o.total) AS amount, z.code as iso_code_2 
                           FROM `" . DB_PREFIX . "order` o 
                           LEFT JOIN `" . DB_PREFIX . "zone` z ON (o.payment_zone_id = z.zone_id) 
                           WHERE o.order_status_id > '0' GROUP BY o.payment_zone_id");