blob: 6228c0822e4e1049c036a6c0acabbdf174dd590b (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
|
<?php
class ModelAccountCustomerGroup extends Model {
public function getCustomerGroup($customer_group_id) {
$query = $this->db->query("SELECT DISTINCT * FROM " . DB_PREFIX . "customer_group cg LEFT JOIN " . DB_PREFIX . "customer_group_description cgd ON (cg.customer_group_id = cgd.customer_group_id) WHERE cg.customer_group_id = '" . (int)$customer_group_id . "' AND cgd.language_id = '" . (int)$this->config->get('config_language_id') . "'");
return $query->row;
}
public function getCustomerGroups() {
$query = $this->db->query("SELECT * FROM " . DB_PREFIX . "customer_group cg LEFT JOIN " . DB_PREFIX . "customer_group_description cgd ON (cg.customer_group_id = cgd.customer_group_id) WHERE cgd.language_id = '" . (int)$this->config->get('config_language_id') . "' ORDER BY cg.sort_order ASC, cgd.name ASC");
return $query->rows;
}
}
|
