OpenCart 🇺🇦

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

$implode = array();

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

if (!empty($data['filter_email'])) {
	$implode[] = "email LIKE '" . $this->db->escape($data['filter_email']) . "%'";
}

if (isset($data['filter_newsletter']) && !is_null($data['filter_newsletter'])) {
	$implode[] = "newsletter = '" . (int)$data['filter_newsletter'] . "'";
}

if (!empty($data['filter_customer_group_id'])) {
	$implode[] = "customer_group_id = '" . (int)$data['filter_customer_group_id'] . "'";
}	

if (!empty($data['filter_ip'])) {
	$implode[] = "customer_id IN (SELECT customer_id FROM " . DB_PREFIX . "customer_ip WHERE ip = '" . $this->db->escape($data['filter_ip']) . "')";
}	

if (isset($data['filter_status']) && !is_null($data['filter_status'])) {
	$implode[] = "status = '" . (int)$data['filter_status'] . "'";
}			

if (isset($data['filter_approved']) && !is_null($data['filter_approved'])) {
	$implode[] = "approved = '" . (int)$data['filter_approved'] . "'";
}		

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

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

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

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