Product Filters

[Omar_one]

Hello,
I just check this again today ,,
so the issue with qtpro is the filter module check attributes from products_attributes and the join query
with (products_stock ) not working as it show the products which has attributes in products_attributes
so I think the issue some where here

Code: Select all

if ( class_exists('pi_qtpro_options')) {
		    $select .= ', poa.products_options_values_id, poa.products_options_values_name, ov2po.products_options_id';
            $join .= ' LEFT JOIN products_attributes pa2 ON p.products_id = pa2.products_id LEFT JOIN products_stock qtps ON pa2.products_id = qtps.products_id AND qtps.products_stock_quantity > 0 LEFT JOIN products_options_values poa ON pa2.options_values_id = poa.products_options_values_id AND poa.language_id = ' . (int)$_SESSION['languages_id'] . ' LEFT JOIN products_options_values_to_products_options ov2po ON poa.products_options_values_id = ov2po.products_options_values_id AND ov2po.products_options_id IN (' . implode(', ', $attribute_filters) . ')';		
	        $group_by[] = 'poa.products_options_values_id';