从自定义类别属性获取值

Question

I am trying to get the value from a custom category attribute in Magento. The attribute is a select field and is been made with the install script below:

$this->startSetup();

$this->addAttribute('catalog_category', 'category_categorycolor', array(
    'group'         => 'General Information',
    'input'         => 'select',
    'type'          => 'varchar',
    'label'         => 'Categorie kleur',
    'backend'       => '',
    'visible'       => 1,
    'required'      => 0,
    'user_defined'  => 1,
    'option'            => array (
                                    'value' => array('yellow' => array('Geel'),
                                                     'purple' => array('Paars'),
                                                     'blue' => array('Blauw'),
                                                     'red' => array('Rood'),
                                                     'orange' => array('Oranje'),
                                                     'green' => array('Groen'),
                                                     'darkblue' => array('Donkerblauw'),
                                                     'lightgreen' => array('Lichtgroen'),                                               
                                                )
                                ),
    'global'        => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_GLOBAL,
));

$this->endSetup();

Unfortunately only getting numbers and not text value. I use this line to retrieve the value:

<?php $_category_categorycolor = $_category->getData('category_categorycolor'); if($_category_categorycolor): ?> <?php echo $_category_categorycolor; ?> <?php endif; ?>

Can someone help me?

Answer 1

The sollution is pretty messy (the only one I know of).

$opt = array(); // will contain all options in a $key => $value manner
$attribute = Mage::getSingleton('eav/config')->getAttribute('catalog_category', 'category_categorycolor');
    if ($attribute->usesSource()) {
        $options = $attribute->getSource()->getAllOptions(false);
        foreach ($options as $o) {
            $opt[$o['value']] = $o['label'];
        }
    }

$categoryColorId = $_category->getData('category_categorycolor');
$categoryColorLabel = $opt[$categoryColorId];

// if you have problems, do a Zend_Debug::dump($opt); 
// - it should contain an array of all the options you added

Didn't test it out, let me know if it works or not.

PS: can't reply to your comment, not sure why. What does $opt contain ?