Magento 1.8 – How to Add Column in Customer Grid with Dropdown Values

magento-1.8

I've added a custom attribute for customers to choose from during registration. For simplicity sake lets say this is their favorite color (color_customer). Values are pulled from a dropdown list. Everything works fine in both front- and backend. I added this custom attribute to the customer grid by overwriting the grid file. I then tried to get the values of the color attribute before the _prepareColumns function. I'm not so sure this is the right way to go and I'm hoping someone could shed some light on this matter.

    <?php
    class Company_Module_Block_Adminhtml_Customer_Grid extends      Mage_Adminhtml_Block_Customer_Grid{

    protected function _prepareCollection(){
    $collection = Mage::getResourceModel('customer/customer_collection')
        ->addNameToSelect()
        ->addAttributeToSelect('email')
        ->addAttributeToSelect('created_at')
        ->addAttributeToSelect('group_id')
        ->addAttributeToSelect('color_customer')
        ->joinAttribute('billing_postcode', 'customer_address/postcode', 'default_billing', null, 'left')
        ->joinAttribute('billing_city', 'customer_address/city', 'default_billing', null, 'left')
        ->joinAttribute('billing_telephone', 'customer_address/telephone', 'default_billing', null, 'left')
        ->joinAttribute('billing_region', 'customer_address/region', 'default_billing', null, 'left')
        ->joinAttribute('billing_country_id', 'customer_address/country_id', 'default_billing', null, 'left');

    $this->setCollection($collection);

    if ($this->getCollection()) {

        $this->_preparePage();

        $columnId = $this->getParam($this->getVarNameSort(), $this->_defaultSort);
        $dir      = $this->getParam($this->getVarNameDir(), $this->_defaultDir);
        $filter   = $this->getParam($this->getVarNameFilter(), null);

        if (is_null($filter)) {
            $filter = $this->_defaultFilter;
        }

        if (is_string($filter)) {
            $data = $this->helper('adminhtml')->prepareFilterString($filter);
            $this->_setFilterValues($data);
        }
        else if ($filter && is_array($filter)) {
            $this->_setFilterValues($filter);
        }
        else if(0 !== sizeof($this->_defaultFilter)) {
            $this->_setFilterValues($this->_defaultFilter);
        }

        if (isset($this->_columns[$columnId]) && $this->_columns[$columnId]->getIndex()) {
            $dir = (strtolower($dir)=='desc') ? 'desc' : 'asc';
            $this->_columns[$columnId]->setDir($dir);
            $this->_setCollectionOrder($this->_columns[$columnId]);
        }

        if (!$this->_isExport) {
            $this->getCollection()->load();
            $this->_afterLoadCollection();
        }
    }

    return $this;
     }
     }


protected function _prepareColumns(){
   $color = Mage::getModel('eav/config')->getAttribute('customer', 'color_customer');
   $options = $color->getSource()->getAllOptions(false);
   $colors = array();
   foreach ($options as $option)
   {
       $colors[$option['value']] = $option['label'];
   }
    $this->addColumnAfter('color_customer', array(
        'header'    => Mage::helper('customer')->__('Fav Color'),
        'width'     => '80px',
        'index'     => 'color_customer',
        'type'      => 'options',
        'options'   => $colors
    ),'email');
    return parent::_prepareColumns();
  }

Best Answer

You can get the options like this:

$color = Mage::getModel('eav/config')->getAttribute('customer', 'color_customer');
$options = $color->getSource()->getAllOptions(false);

You seam to have it figured out for the rest of it.

Related Solutions

Magento 1.8 – Add a Filtering Column in Admin Grid

The value of your column is not joined automatically to the collection listed in the grid.
The collection listed in the grid is an instance of Mage_Review_Model_Resource_Review_Product_Collection.
You need to modify the method _joinFields in that class. (For test purposes of course. When you are sure it works do it the proper Magento way by rewriting the class.).

By default the fields are joined this way:

$this->getSelect()
        ->join(array('rt' => $reviewTable),
            'rt.entity_pk_value = e.entity_id',
            array('rt.review_id', 'review_created_at'=> 'rt.created_at', 'rt.entity_pk_value', 'rt.status_id'))
        ->join(array('rdt' => $reviewDetailTable),
            'rdt.review_id = rt.review_id',
            array('rdt.title','rdt.nickname', 'rdt.detail', 'rdt.customer_id', 'rdt.store_id'));

If you added your column in the review_detail table you need to add it in the second join. Make the code above look like this:

$this->getSelect()
        ->join(array('rt' => $reviewTable),
            'rt.entity_pk_value = e.entity_id',
            array('rt.review_id', 'review_created_at'=> 'rt.created_at', 'rt.entity_pk_value', 'rt.status_id'))
        ->join(array('rdt' => $reviewDetailTable),
            'rdt.review_id = rt.review_id',
            array('rdt.title','rdt.nickname', 'rdt.detail', 'rdt.customer_id', 'rdt.store_id', 'rdt.view_type'));

The code above will let you see the values in your custom column.

In order to make sorting to work you need to modify the method setOrder in the same class Mage_Review_Model_Resource_Review_Product_Collection.

Change this:

        case 'rt.review_id':
        case 'rt.created_at':
        case 'rt.status_id':
        case 'rdt.title':
        case 'rdt.nickname':
        case 'rdt.detail':
            $this->getSelect()->order($attribute . ' ' . $dir);
            break;

to this:

        case 'rt.review_id':
        case 'rt.created_at':
        case 'rt.status_id':
        case 'rdt.title':
        case 'rdt.nickname':
        case 'rdt.detail':
        case 'rdt.view_type': //you need to add this 'case'
            $this->getSelect()->order($attribute . ' ' . $dir);
            break;

For filtering modify addAttributeToFilter in the same class. Change this

        case 'rt.review_id':
        case 'rt.created_at':
        case 'rt.status_id':
        case 'rdt.title':
        case 'rdt.nickname':
        case 'rdt.detail':
            $conditionSql = $this->_getConditionSql($attribute, $condition);
            $this->getSelect()->where($conditionSql);
            break;

To this:

        case 'rt.review_id':
        case 'rt.created_at':
        case 'rt.status_id':
        case 'rdt.title':
        case 'rdt.nickname':
        case 'rdt.detail':
        case 'rdt.view_type': //you need to add this 'case'
            $conditionSql = $this->_getConditionSql($attribute, $condition);
            $this->getSelect()->where($conditionSql);
            break;

Damn...a lot of work for a simple column. I hope this gets re-factored in 2.0.

[EDIT]

To add your new column as an options column declare it like this:

$this->addColumn('view_type', array(
    'header'        => Mage::helper('review')->__('View type'),
    'align'         => 'left',
    'width'         => '100px',
    'filter_index'  => 'rdt.view_type',
    'index'         => 'view_type',
    'type'      => 'options',
    'options'   => array(
        0 => Mage::helper('review')->__('Show in home page'),
        1 => Mage::helper('review')->__('Show in product details page')
    ),
));

Magento – Fetch Values in Dropdown in Custom Admin Module

Mage::getModel('frame')->toOptionArray() is model class object but you have define the value at block class Block/Adminhtml/Frame so,it not works .

So you need to call function toOptionArray() using class of block class call

YouModuleNameSpace_YouModuleName_Block_Adminhtml_Frame::toOptionArray()

instead of

Mage::getModel('frame')->toOptionArray()

Best Answer

Related Solutions

Magento 1.8 – Add a Filtering Column in Admin Grid

Magento – Fetch Values in Dropdown in Custom Admin Module

Related Topic