Magento获得一个类别的制造商

Question

I currently can get a list of manufacturers and each of their first product with the code below:

    $attribute = Mage::getModel('eav/entity_attribute')
                    ->loadByCode('catalog_product', 'manufacturer');

    $valuesCollection = Mage::getResourceModel('eav/entity_attribute_option_collection')
                ->setAttributeFilter($attribute->getData('attribute_id'))
                ->setStoreFilter(0, false);

    $preparedManufacturers = array();            
    foreach($valuesCollection as $value) {
        $preparedManufacturers[$value->getOptionId()] = $value->getValue();
    }   

    $prefs = array();        

    if (count($preparedManufacturers)) {
        foreach ($preparedManufacturers as $optionId => $value) {
            $manufacturerItem = array();
            $manufacturerItem['manufacturerID'] = $optionId;
            $manufacturerItem['manufacturerName'] = $value; 

            $firstProductId=Mage::getModel('catalog/product')->getCollection()
                ->addStoreFilter(0)
                ->addAttributeToFilter('manufacturer',$optionId)->getFirstItem()->getId();              

            $product = Mage::getModel('catalog/product')->load($firstProductId);
            $manufacturerItem['productImageURL'] = (string)Mage::helper('catalog/image')->init($product, 'thumbnail')->resize(100);;
            $prefs['manufacturer'][] = $manufacturerItem;
        }

        $mainBlock = $this->getLayout()->createBlock(
                                       'Mage_Core_Block_Template',
                                       'mainContentProducts',
                     array(
                         'template' => 'page/manufacturer.phtml'
                     )
            ) // NOTE - Custom Variables Below
            ->setData('prefs', $prefs);

        $this->getLayout()->getBlock('content')->append($mainBlock);            
    } 

If I have a category ID how do a get a list of manufacturers and their first product?

Answer 1

I believe this accomplishes what you want.

$category = Mage::getModel('catalog/category')->load(**Id Goes Here**);

$productCollection = Mage::getModel('catalog/product')->getCollection()
    ->addCategoryFilter($category)
    ->addAttributeToSelect('manufacturer')
    ->addAttributeToSort('entity_id','ASC')
    ->groupByAttribute('manufacturer');

Then you can loop through the collection and it'll have the first product for each manufacturer.