問題描述

在 magento 中，我有一個名為 cl_designer 的屬性，它是一個下拉選項.我想過濾產品集合，如下所示:

In magento, I have an attribute called cl_designer, which is a select drop-down option. I want to filter the products collection on it, like this:

$collection = Mage::getModel('catalog/product')->getCollection();
$collection->addAttributeToFilter('cl_designer', array('like' => $filter));

但它不起作用！當我使用 $collection->getselect() 打印查詢時，我看到它正在將 $filter 與 catalog_product_entity_int.value 進行比較.但這是錯誤的，因為對于選擇選項，catalog_product_entity_int.value 是 option_id，而不是值.那么如何讓它過濾實際的選項值呢?

But it doesn't work! When I print out the query with $collection->getselect(), I see that it is comparing $filter to catalog_product_entity_int.value. But this is wrong, because for select options, catalog_product_entity_int.value is the option_id, NOT the value. So how do I make it filter on the actual option value?

推薦答案

假設一個名為 size 的下拉屬性示例包含以下選項:

Assuming an example drop-down attribute named size contains the following options:

id    value
22    'small'
23    'medium'
24    'large'

并且您想通過 'medium' 選項過濾您的收藏:

and you want to filter your collection by 'medium' options:

要按產品(自定義)下拉屬性的選項值過濾產品集合:

To filter a product collection by option value of a product's (custom) drop-down attribute:

$sAttributeName = 'size';
$mOptionValue = 'medium';
$collection = Mage::getModel('catalog/product')->getCollection()
    ->addAttributeToSelect('*')
    ->addFieldToFilter(
        $sAttributeName,
        array(
            'eq' => Mage::getResourceModel('catalog/product')
                        ->getAttribute($sAttributeName)
                        ->getSource()
                        ->getOptionId($mOptionValue)
        )
    );

按下拉選項 ID 過濾

要通過產品(自定義)下拉屬性的選項 ID 過濾產品集合:

Filter by drop-down option id

To filter a product collection by a option id of a product's (custom) drop-down attribute:

$sAttributeName = 'size';
$mOptionId = 23;
$collection = Mage::getModel('catalog/product')->getCollection()
    ->addAttributeToSelect('*')
    ->addFieldToFilter(
        $sAttributeName,
        array('eq' => $mOptionId)
    );

這篇關于如何通過選擇下拉屬性過濾 magento 集合?的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網！