OpenCart 🇺🇦

$sql = "
	SELECT COUNT(*) AS `profile_count`
	FROM `" . DB_PREFIX . "order_recurring` `or`
	JOIN `" . DB_PREFIX . "order` o USING(order_id)
	WHERE 1 = 1";

if (!empty($data['filter_order_recurring_id'])) {
	$sql .= " AND or.order_recurring_id = " . (int)$data['filter_order_recurring_id'];
}

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

if (!empty($data['filter_payment_reference'])) {
	$sql .= " AND or.profile_reference LIKE '" . $this->db->escape($data['filter_payment_reference']) . "%'";
}

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

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

if (!empty($data['filter_status'])) {
	$sql .= " AND or.status = " . (int)$data['filter_status'];
}

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

return $result->row['profile_count'];