Magento – How to Create Admin grid value type of multiselect and Drop down

gridmagento-1.9

i am creating admin side grid. in that grid few value i am getting from table. but few value need to select by Admin.
as seen below figure.
enter image description here

here, column Time sheet value type will be MultiSelect,so that Admin can Select any one or more.

if select one value then beside it in column of MEAL it will create one dropdown. with two value 1) Before 2) After.

if select two value then beside it in column of MEAL it will create two dropdown. with two value 1) Before 2) After.

how to create it friend?

Please if you know help me.

Edit: I do not want in Filter. i want it in value row.

Best Answer

You need to use a 'renderer' to generate your column data. This allows you to render out HTML (or anything else) as you column data so you can build things like dropdowns and multiselects. If you use that and want to search by that column, you will probably also want to look at the 'filter_condition_callback'. This allows you to call a custom method when searching by a column.

This seems to be a reasonable, quick summary of the subject.

Related Solutions

Magento – Custom Filter Function for Catalog Grid

The $this->addColumn(...) should get another attribute in the array

$this->addColumn('product_color',
    array(
        'header'=> Mage::helper('catalog')->__('Color'),
        'renderer'  => 'Mage_Adminhtml_Block_Catalog_Product_Renderer_Colors',
        'index' => 'ssp_color',
        'width' => '100px',
        'type'  => 'options',
        'options' => $colorValues,
        'filter_condition_callback' => array($this, '_colorFilter'),
));

This will make the function _colorFilter() the filter function for this column.

The function has to be created now:

protected function _colorFilter($collection, $column) {
    if (!$value = $column->getFilter()->getValue()) {
        return $this;
    }
    $field = $column->getFilterIndex() ? $column->getFilterIndex() : $column->getIndex();
    $cond = $column->getFilter()->getCondition();
    $this->getCollection()->addFieldToFilter($field, array('finset' => $cond["eq"]));
    return $this;
}

This will return all products which have at least one appereance of the attribute you filtered for in them, but can contain even more.

Magento – How to create an admin grid with non auto increment field

To add an edit action and pass some value along with that action, you can use the below code

public function getRowUrl($row)
{
    return $this->getUrl('*/*/edit', array(
        'store'=>$this->getRequest()->getParam('store'),
        'id'=>$row->getId())
    );
}

This will attach a row url to js event handlers and thus when you click on a grid item, it will trigger editAction in your controller file. You can get those parameters like this.

<?php
class [Namespace]_[Module]_[Some]Controller extends Mage_Adminhtml_Controller_Action
{

    public function editAction()
    {
         $id = (int) $this->getRequest()->getParam('id');
    }
}

Best Answer

Related Solutions

Magento – Custom Filter Function for Catalog Grid

Magento – How to create an admin grid with non auto increment field

Related Topic