Produit pas en stock sur certains résultats de recherche et en stock sur d'autre

'.$filter->filter_namekey.$i.'_2.product_quantity==NULL

if($filter->filter_type=='instockcheckbox' && $infoGet[0]=='in_stock'){ $filters[]=' b.product_quantity!=0'; $on.=' LEFT JOIN #__hikashop_product_related AS '.$filter->filter_namekey.$i.' ON '.$filter->filter_namekey.$i.'.product_id=b.product_id AND '.$filter->filter_namekey.$i.'.product_related_type = \'bundle\' LEFT JOIN #__hikashop_product AS '.$filter->filter_namekey.$i.'_2 ON '.$filter->filter_namekey.$i.'_2.product_id = '.$filter->filter_namekey.$i.'.product_related_id'; $filters[]=' ('.$filter->filter_namekey.$i.'_2.product_quantity = NULL OR '.$filter->filter_namekey.$i.'_2.product_quantity!=0 )'; return true; }

$query = 'SELECT pr.product_id'. ' FROM '.hikashop_table('product_related').' AS pr '. ' INNER JOIN '.hikashop_table('product').' AS p ON pr.product_related_id = p.product_id '. ' WHERE pr.product_related_type = ' . $this->db->Quote('bundle') . ' AND (p.product_quantity = 0 OR p.product_quantity < pr.product_related_quantity)'; $database->setQuery($query); $out_of_stock_bundled_products = $database->loadObjectList('product_id'); if(!empty($out_of_stock_bundled_products) && count($out_of_stock_bundled_products)) { $filters[]=' b.product_id NOT IN ('.implode(',', array_keys($out_of_stock_bundled_products)).')'; }