Filter Collection by Multiple Values from Multiselect Attribute in Magento

backendcollection-filteringcollection;multistore

I am currently developing a banner manager module that allows the admin to upload banners and select which store views those banners will appear on. I have everything working fine when a single store view is selected using a multi select attribute, however when you select multiple store views Magento seems to look for the selected store ID's as a string rather than individually.

For example for a banner I have 3 store views selected. Magento returns '1,3,4' as the value. Rather than looking for each number individually Magento looks for the string'1,3,4'. See the function I am using below:

   function getHomePageBanners() {

    $storeId = Mage::app()->getStore()->getStoreId();
    $customerId = Mage::getSingleton('customer/session')->getCustomerGroupId();

    $collection = Mage::getModel("homepagebanner/homepagebanner")->getCollection()
            ->addFieldToFilter('status', array('eq' => 0))
            ->addFieldToFilter('store_view_id', array('in' => array(0,$storeId)))
            ->addFieldToFilter('customer_group_id', array('in' => array($customerId)))
            ->setOrder('position', 'ASC')
            ->toArray();

    return $collection['items'];
   }

The same applies when I am filtering via customer group as well.

Would anyone know how I can get Magento to check each value individually in the string rather than as a whole?

Best Answer

I managed to get this to work using Marius advice and using the answer from the post below:

Collection with FIND_IN_SET on multiselect attributes, but some has only one value

My code now reads

    function getHomePageBanners() {

    $storeId = Mage::app()->getStore()->getStoreId();
    $customerId = Mage::getSingleton('customer/session')->getCustomerGroupId();

    $collection = Mage::getModel("homepagebanner/homepagebanner")->getCollection()
            ->addFieldToFilter('status', array('eq' => 0))
            ->addFieldToFilter('store_view_id',
                array(
                    array('finset'=> array('0')),
                    array('finset'=> array($storeId)),
                )
            )
            ->addFieldToFilter('customer_group_id',array('finset'=>array($customerId)))
            ->setOrder('position', 'ASC')
            ->toArray();

    return $collection['items'];
}

Related Solutions

Magento – How to filter product collection by attribute’s admin option values

Like all of Magento, the answer's in the source — all you need to do is go digging (or hop to then end of this post).

First, find the class for the attribute source

$source = Mage::getResourceModel('catalog/product')
->getAttribute('color')
->getSource();        
var_dump(get_class($source));
exit;

In modern versions of Magento, this should point to the class Mage_Eav_Model_Entity_Attribute_Source_Table, which is located at

#File: app/code/core/Mage/Eav/Model/Entity/Attribute/Source/Table.php
class Mage_Eav_Model_Entity_Attribute_Source_Table extends Mage_Eav_Model_Entity_Attribute_Source_Abstract
{
    //...
}

Next, we'll look for the definition of the getOptionId method on this class and/or it's parent classes. We'll find it in the Mage_Eav_Model_Entity_Attribute_Source_Abstract class

#File: app/code/core/Mage/Eav/Model/Entity/Attribute/Source/Abstract.php
public function getOptionId($value)
{
    foreach ($this->getAllOptions() as $option) {
        if (strcasecmp($option['label'], $value)==0 || $option['value'] == $value) {
            return $option['value'];
        }
    }
    return null;
}

Examining this method, we can see if works by foreaching over a list of options from the getAllOptions method. So let's look at this method's definition.

#File: app/code/core/Mage/Eav/Model/Entity/Attribute/Source/Table.php
public function getAllOptions($withEmpty = true, $defaultValues = false)
{
    $storeId = $this->getAttribute()->getStoreId();
    if (!is_array($this->_options)) {
        $this->_options = array();
    }
    if (!is_array($this->_optionsDefault)) {
        $this->_optionsDefault = array();
    }
    if (!isset($this->_options[$storeId])) {
        $collection = Mage::getResourceModel('eav/entity_attribute_option_collection')
            ->setPositionOrder('asc')
            ->setAttributeFilter($this->getAttribute()->getId())
            ->setStoreFilter($this->getAttribute()->getStoreId())
            ->load();
        $this->_options[$storeId]        = $collection->toOptionArray();
        $this->_optionsDefault[$storeId] = $collection->toOptionArray('default_value');
    }
    $options = ($defaultValues ? $this->_optionsDefault[$storeId] : $this->_options[$storeId]);
    if ($withEmpty) {
        array_unshift($options, array('label' => '', 'value' => ''));
    }

    return $options;
}

Ah ha! Now we're on to something. This appears to be the method that loads all the option information. Specifically, we're interested in

$storeId = $this->getAttribute()->getStoreId();

So, Magento gets the store ID for the options to load from the attribute. This means you should be able to do something like the following (replacing color and red with your own variables, of course)

    //get the attribute
    $attribute = Mage::getResourceModel('catalog/product')
    ->getAttribute('color');

    //set the store id on the attribute
    $attribute->setStoreId(Mage_Core_Model_App::ADMIN_STORE_ID);

    //get the source
    $source = $attribute->getSource();

    //get the id
    $id = $source->getOptionId('red');

Magento 1.8 – Filter Product Collection by Multiple Price Ranges

Got solution... Hurreee...:-)

->addFieldToFilter('diy_kit_price', 
     array(array('from'=>'0','to'=>'5000'), 
     array('from'=>'15000','to'=>'20000'))
 )

Best Answer

Related Solutions

Magento – How to filter product collection by attribute’s admin option values

Magento 1.8 – Filter Product Collection by Multiple Price Ranges

Related Topic