OpenCart 🇺🇦

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

$implode = array();

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

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

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'];