Magento: How to merge multiple fields in a colum in Magento admin panel grid?

May 3, 2012 | In: Magento, mysql, php, web development

Magento provides lot of inbuild functionalities. Using “protected function _prepareColumns()” function we can create or add new column to the grid.

Like:

	protected function _prepareColumns()
	{
		$this->addColumn('first_name', array(
			'header'	=>	Mage::helper('custommodule')->__('First Name'),
			'align'		=>	'left',
			'width'		=>	'50px',
			'index'		=>	'first_name',
		));
 
		$this->addColumn('last_name', array(
			'header'	=>	Mage::helper('custommodule')->__('Last Name'),
			'align'		=>	'left',
			'width'		=>	'50px',
			'index'		=>	'last_name',
		));
  	}

But sometimes we have lot of columns for our custom module and we need to merge two columns to single column. So what we have to do?
I explain you how can we do this by programmatically: We can use ‘Renderer’ terms to combine two columns.

	Mage_Adminhtml_Block_Widget_Grid_Column_Renderer_Abstract

Step1: Firstly, create a new folder ‘Renderer’ inside the Block/Adminhtml folder of your custom plugin.
Step2: Make a new file called ‘CustomerName.php’ with the below contents:

	class Company_Custommodule_Block_Adminhtml_Renderer_CustomerName extends Mage_Adminhtml_Block_Widget_Grid_Column_Renderer_Abstract {
 
    public function render(Varien_Object $row) {
                if ($row->getData('first_name') != NULL || $row->getData('last_name') != NULL) {
			$firstName = $row->getData('first_name');
	                $lastName = $row->getData('last_name');
			if ($lastName != NULL) {
				return $firstName . ' ' . $lastName;
	                } else {
				return $firstName;
			}
	        } else {
        		return Mage::helper('dailydeal')->__('NO NAME ASSIGNED');
	        }
    }
}

Step3: Then, in the grid, make a new column with calling above rendrerer file:

	protected function _prepareColumns()
	{
		$this->addColumn('first_name', array(
			'header'	=>	Mage::helper('custommodule')->__('First Name'),
			'align'		=>	'left',
			'width'		=>	'100px',
			'index'		=>	'first_name',
			'renderer'      =>      new Company_Custommodule_Block_Adminhtml_Renderer_CustomerName(),
		));  
	}

I hope it will work for you too…. :)

You may also like these related posts

  • Đỗ Văn Minh

    it’s very nice !
    thanks your post

Categories

By Google