OpenCart 🇺🇦

$sql = "SELECT COUNT(*) AS `total` FROM `" . DB_PREFIX . "order`";

if (isset($data['filter_order_status_id']) && !is_null($data['filter_order_status_id'])) {
	$sql .= " WHERE `order_status_id` = '" . (int)$data['filter_order_status_id'] . "'";
} else {
	$sql .= " WHERE `order_status_id` > '0'";
}

if (!empty($data['filter_order_id'])) {
	$sql .= " AND `order_id` = '" . (int)$data['filter_order_id'] . "'";
}

if (!empty($data['filter_customer'])) {
	$sql .= " AND CONCAT(`firstname`, ' ', `lastname`) LIKE '%" . $this->db->escape($data['filter_customer']) . "%'";
}

if (!empty($data['filter_date_added'])) {
	$sql .= " AND DATE(`date_added`) = DATE('" . $this->db->escape($data['filter_date_added']) . "')";
}

$query = $this->db->query($sql);

return $query->row['total'];