OpenCart 🇺🇦

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

$implode = array();

if (!empty($data['filter_return_id'])) {
	$implode[] = "r.return_id = '" . (int)$data['filter_return_id'] . "'";
}

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

if (!empty($data['filter_order_id'])) {
	$implode[] = "r.order_id = '" . $this->db->escape($data['filter_order_id']) . "'";
}

if (!empty($data['filter_product'])) {
	$implode[] = "r.product = '" . $this->db->escape($data['filter_product']) . "'";
}	

if (!empty($data['filter_model'])) {
	$implode[] = "r.model = '" . $this->db->escape($data['filter_model']) . "'";
}	

if (!empty($data['filter_return_status_id'])) {
	$implode[] = "r.return_status_id = '" . (int)$data['filter_return_status_id'] . "'";
}	

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

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

if ($implode) {
	$sql .= " WHERE " . implode(" AND ", $implode);
}

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

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