Схема
public mixed
getProductSearchTotal (
$data = array() )
Аргументы
| Аргумент |
Возможный тип |
Описание |
| $data = array() |
— |
— |
Описание
Метод пока еще не документирован.
Исходный код
$sql = "
SELECT COUNT(*) AS product_total
FROM " . DB_PREFIX . "product p
LEFT JOIN " . DB_PREFIX . "amazon_product_search aps ON p.product_id = aps.product_id AND aps.marketplace = '" . $this->db->escape($data['filter_marketplace']) . "'
LEFT JOIN " . DB_PREFIX . "amazon_product_link apl ON p.product_id = apl.product_id
LEFT JOIN " . DB_PREFIX . "amazon_product ap ON p.product_id = ap.product_id
WHERE apl.product_id IS NULL AND ap.product_id IS NULL ";
if (!empty($data['status'])) {
$sql .= " AND aps.status = '" . $this->db->escape($data['status']) . "'";
}
return $this->db->query($sql)->row['product_total'];
