Схема
public mixed
getTotalCoupons (
$data = array() )
Аргументы
| Аргумент |
Возможный тип |
Описание |
| $data = array() |
— |
— |
Описание
Метод пока еще не документирован.
Исходный код
$sql = "SELECT COUNT(DISTINCT coupon_id) AS total FROM `" . DB_PREFIX . "coupon_history`";
$implode = array();
if (!empty($data['filter_date_start'])) {
$implode[] = "DATE(date_added) >= '" . $this->db->escape($data['filter_date_start']) . "'";
}
if (!empty($data['filter_date_end'])) {
$implode[] = "DATE(date_added) <= '" . $this->db->escape($data['filter_date_end']) . "'";
}
if ($implode) {
$sql .= " WHERE " . implode(" AND ", $implode);
}
$query = $this->db->query($sql);
return $query->row['total'];
