1

I want to get fullname of customers in magento back-end server.

enter image description here

I already brought the first name in index "NAME" and i want to join the lastname after first name.

protected function _prepareCollection()

protected function _prepareCollection()
{
    $collection = Mage::getResourceModel('customer/customer_collection')
        ->addNameToSelect()
        ->addAttributeToSelect('name')
        ->addAttributeToSelect('firstname')
        ->addAttributeToSelect('lastname')
        ->addAttributeToSelect('email')
        ->addAttributeToSelect('created_at')
        ->addAttributeToSelect('group_id')
        ->addAttributeToSelect('company')
        ->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);

    return parent::_prepareCollection();
}

protected function _prepareColumns()

$this->addColumn('name', array(
        'header'    => Mage::helper('customer')->__('Name'),
        'index'     => 'firstname'
    ));

How can i combine the first name and last name? Could you let me know. Thank you

  • **Beginner solution **- By adding 'renderer' attr, you can merge the text! – 3CE Jan 27 '17 at 17:13
2

User renderer

$this->addColumn('name', array(
        'header'    => Mage::helper('customer')->__('Name'),
        'index'     => 'firstname',
        'renderer'  => 'Namespace_Modulename_Block_Renderer_Name',
    ));

In you renderer block

<?php class Namespace_Modulename_Block_Renderer_Name extends Mage_Adminhtml_Block_Widget_Grid_Column_Renderer_Abstract 
             { 

                 public function render(Varien_Object $row) { 

                     return $row->getFirstname.' '.$row->getLastname;

                 }

             }
?>
  • it is totallllllly work thank you!!!!!!!! – 3CE Feb 7 '17 at 19:54
  • 1
    @3CE if it is working kindly mark as accepted solution so it can help other fellow community user – Qaisar Satti Feb 8 '17 at 4:36

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.