$listCat = implode(',', $listCat);
$sql = 'SELECT COUNT(cp.`id_product`) AS total, cp.`id_category`
FROM `' . _DB_PREFIX_ . 'product` p
' . Shop::addSqlAssociation('product', 'p') . '
LEFT JOIN `' . _DB_PREFIX_ . 'category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (' . $listCat . ')' . ' AND product_shop.`visibility` IN ("both", "catalog")' . ' AND product_shop.`active` = 1' . ' GROUP BY cp.`id_category`';
$cat = Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS($sql);
if ($cat) {
$result['cat'] = $cat;
}
}
if ($leoProCdown) {
$leoProCdown = explode(',', $leoProCdown);
$leoProCdown = array_unique($leoProCdown);
$leoProCdown = implode(',', $leoProCdown);
$result['pro_cdown'] = $leoProductInfo->hookProductCdown($leoProCdown);
}
if ($leoProColor) {
$leoProColor = explode(',', $leoProColor);
$leoProColor = array_unique($leoProColor);
$leoProColor = implode(',', $leoProColor);
$result['pro_color'] = $leoProductInfo->hookProductColor($leoProColor);
}
if ($leoProInfo) {
$leoProInfo = explode(',', $leoProInfo);
$leoProInfo = array_unique($leoProInfo);
$leoProInfo = implode(',', $leoProInfo);
# $leocustomajax = new Leocustomajax();
$result['pro_info'] = $leoProductInfo->hookProductMoreImg($leoProInfo);
}
if ($leoProAdd) {
$listCat = implode(",", $listCat);
$sql = 'SELECT COUNT(cp.`id_product`) AS total, cp.`id_category`
FROM `' . _DB_PREFIX_ . 'product` p
' . Shop::addSqlAssociation('product', 'p') . '
LEFT JOIN `' . _DB_PREFIX_ . 'category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (' . $listCat . ')' . ' AND product_shop.`visibility` IN ("both", "catalog")' . ' AND product_shop.`active` = 1' . ' GROUP BY cp.`id_category`';
$cat = Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS($sql);
if ($cat) {
$result["cat"] = $cat;
}
}
if ($leoProCdown) {
$leoProCdown = explode(",", $leoProCdown);
$leoProCdown = array_unique($leoProCdown);
$leoProCdown = implode(",", $leoProCdown);
$result["pro_cdown"] = $leoProductInfo->hookProductCdown($leoProCdown);
}
if ($leoProColor) {
$leoProColor = explode(",", $leoProColor);
$leoProColor = array_unique($leoProColor);
$leoProColor = implode(",", $leoProColor);
$result["pro_color"] = $leoProductInfo->hookProductColor($leoProColor);
}
if ($leoProInfo) {
$leoProInfo = explode(",", $leoProInfo);
$leoProInfo = array_unique($leoProInfo);
$leoProInfo = implode(",", $leoProInfo);
//$leocustomajax = new Leocustomajax();
$result["pro_info"] = $leoProductInfo->hookProductMoreImg($leoProInfo);
}
if ($leoProAdd) {
