shop.balmet.com

Unnamed repository; edit this file 'description' to name the repository.
Log | Files | Refs | README

map.php (725B)

      1 <?php
      2 class ModelExtensionDashboardMap extends Model {
      3 	public function getTotalOrdersByCountry() {
      4 		$implode = array();
      5 		
      6 		if (is_array($this->config->get('config_complete_status'))) {
      7 			foreach ($this->config->get('config_complete_status') as $order_status_id) {
      8 				$implode[] = (int)$order_status_id;
      9 			}
     10 		}
     11 		
     12 		if ($implode) {
     13 			$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");
     14 
     15 			return $query->rows;
     16 		} else {
     17 			return array();
     18 		}
     19 	}
     20 }