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']) . "')";
}

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

if (!empty($data['filter_total'])) {
	$sql .= " AND total = '" . (float)$data['filter_total'] . "'";
}

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

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