Magento – how to get attribute values (select type) from a product collection

attributesdropdown-attributemagento-1

I need to retrieve all values of an attribute (multi-option select type) from a filtered collection of products.

First i want to get a collection of products, then filter this collection based on certain category and certain attribute.For remaining products in the collection, I want to retrieve the values (unique) of my multi-option select attribute.

So far I have some code that doesn't work

$attributeCode = 'compatible_printers';
$ctname=$_GET['ctn'];

$collection = Mage::getModel('catalog/product')->getCollection();

$collection->addAttributeToSelect('name'); 
$collection->addAttributeToSelect('manufacturer');
$collection->addAttributeToSelect('ink_type');
$collection->addAttributeToSelect($attributeCode); // this is the required attribute

$collection->addFieldToFilter(array(
array('attribute'=>'manufacturer','eq'=>$ctname), 
 )); 


$collection->addFieldToFilter(array(
array('attribute'=>'ink_type','eq'=>'Laserjet Toner'), 
 )); 
$collection->addAttributeToFilter($attributeCode, array('notnull' => true));
    $collection->addAttributeToFilter($attributeCode, array('neq' => ''));

// i m trying to get the attribute values in the following array
$usedAttributeValues = array_unique($collection->getColumnValues($attributeCode));

I have looked for similar questions and found some anwsers but they don't work for me. Can someone advice how to make the above code work?

Best Answer

You'll need to get a collection of the desired products and iterate through it to get the attribute values. Like this..

$attributeCode = 'compatible_printers';
$ctname = $_GET['ctn'];
$usedAttributeValues = array();

$collection = Mage::getModel('catalog/product')->getCollection()
    ->addAttributeToSelect(array('name', 'manufacturer', 'ink_type', $attributeCode))
    ->addAttributeToFilter('manufacturer', $ctname)
    ->addAttributeToFilter('ink_type', 'Laserjet Toner')
    ->addAttributeToFilter($attributeCode, array('notnull' => true))
    ->addAttributeToFilter($attributeCode, array('neq' => ''));

foreach ($collection as $product) {
    $usedAttributeValues[] = $product->getData($attributeCode);
}

$usedAttributeValues = array_unique($usedAttributeValues);

Related Solutions

Magento – Create a sortable and filterable custom attribute to stand-alone entity

When adding the product attribute, set used_in_product_listing, used_for_sort_by and filterable to true.

You can do that with the following update script:

$installer = Mage::getResourceModel('catalog/setup', 'catalog_setup');
$installer->startSetup();
$installer->updateAttribute('catalog_product', 'product_type', 'used_in_product_listing', 1);
$installer->updateAttribute('catalog_product', 'product_type', 'used_for_sort_by', 1);
$installer->updateAttribute('catalog_product', 'product_type', 'is_filterable', 1);
$installer->endSetup();

Thats all, if if you are NOT using the flat catalog.

If you enable the flat catalog product feature, then you need to ensure that your custom source model implements the methods getFlatColums(), getFlatIndexes() and getFlatUpdateSelect().
If they are missing, your attribute won't be included in the generated flat tables, even if used_in_product_listing is enabled.
Have a look at the class Mage_Eav_Model_Entity_Attribute_Source_Boolean for an example. You can probably copy over the methods with minimal adjustments into your custom source model from there. Otherwise, please ask a new question.

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');

Best Answer

Related Solutions

Magento – Create a sortable and filterable custom attribute to stand-alone entity

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

Related Topic