X-Cart forums

[tony_sologubov]

You should definitely decorate XLite\Module\XC\ProductFilter\View\Filter\Attribut eList or its parent \XLite\Module\XC\ProductFilter\View\Filter\AFilter

As for category ID, since you are on category pages for sure, you can call it like this:
$this->getCategory()->getCategoryId();

I would be happy to help you with this mod in details, but cannot afford it right now. I will do my best to look into it next week.

Tony.

[JannieB]

Thank you Tony, that's very helpful ....
.. I'll have a go and let you know how I get on.

Jan

[JannieB]

I seem to have managed to get this working .... possibly not in the most elegant way but this is what I did:

I decorated the class
\XLite\Module\XC\ProductFilter\View\FormField\Sele ct\Attribute

and added this function

protected function getFilteredOptions()
    {
		
 // get attribute options - only include those options with products in currently selected category
				
   $list = array();
	$categoryId  =	$this->getCategory()->getCategoryId();
        
	foreach ($this->getParam(self::PARAM_ATTRIBUTE)->getAttributeOptions() as $option) {
		$attributeValueId = $option->getId();
		$qb = \XLite\Core\Database::getRepo('XLite\Model\Product')->createQueryBuilder('p')
			->linkInner('p.categoryProducts')
			->linkInner('categoryProducts.category')
			->linkInner('p.attributeValueS')
			->andWhere('category.category_id = :categoryId AND attributeValueS.attribute_option = :attributeValueId')
			->setParameter('categoryId', $categoryId)
			->setParameter('attributeValueId', $attributeValueId);
		
		$prodCount = count($qb->getResult());			
			
		if ($prodCount > 0) {   		 
	    	$list[$option->getId()] = $option->getName();
		}
        }
	// sort attributes alphabetically by name
	if (is_array($list)) {	asort($list); }
     return $list;
 }
	

The I amended the tpl /skin..../modules/XC/ProductFilter/form_field/select/checkbox_list/select.tpl to use my function getFilteredOptions instead of getOptions.

I created a new function in case the getOptions function was used elsewhere ... this way I can choose which to use.

No doubt there is a more sophisticated way of doing this, but it seems to work so I will leave it alone now!

Thanks for your help ... I have been grappling with this for days!!

Jan

[tony_sologubov]

Good job, Jan!