Payment Method Sales/Order grid - Magento 1.9

Question

We load the following code to show the payment method inside the Sales/Order grid.

But this displays the payment code and we want to display the payment title.

How can we change our current code to show the title?

CODE:

$select->joinLeft(array('payment' => $collection->getTable('sales/order_payment')), 'payment.parent_id=main_table.entity_id', array('payment_method' => 'method'));

CODE filterPaymentMethod:

public function filterPaymentMethod($collection, $column)
{
    if (!$value = $column->getFilter()->getValue()) {
        return $this;
    }

    $collection->getSelect()->having(
        "group_concat(`sales_flat_order_item`.sku SEPARATOR ', ') like ?", "%$value%");

    return;
}

Answer 1

Try below way

you can use like this to get the payment method in your custom module or override core files /app/code/core/Mage/Adminhtml/Block/Sales/Order/Grid.php

protected function _prepareCollection()
    {
         $collection = Mage::getResourceModel($this->_getCollectionClass());
         $collection->join(array('payment'=>'sales/order_payment'),'main_table.entity_id=parent_id','method');
         $this->setCollection($collection);
         return Mage_Adminhtml_Block_Widget_Grid::_prepareCollection();
         // end here //
    }

and in grid

 protected function _prepareColumns()
    {

 $payments = Mage::getSingleton('payment/config')->getActiveMethods();

        $methods = array();
        foreach ($payments as $paymentCode=>$paymentModel)
        {
                $paymentTitle = Mage::getStoreConfig('payment/'.$paymentCode.'/title');
                $methods[$paymentCode] = $paymentTitle;
        }

        $this->addColumn('method', array(
                'header' => Mage::helper('sales')->__('Payment Method'),
                        'index' => 'method',
                        'filter_index' => 'payment.method',
                        'type'  => 'options',
                        'width' => '70px',
                        'options' => $methods,
                ));
        // End here
    }

hope this will work for you

Answer 2

You need column renderer functionality, here is just basic idea how you can do it, (this code is not tested) -

in your module you need to use renderer param in file extendedgrid.xml like below --

<action method="addColumnAfter">
         <columnId>payment_method</columnId>
         <arguments>
            <header>Payment Method</header>
            <index>payment_method</index>
            <filter_index>payment.method</filter_index>
            <renderer>Atwix_ExtendedGrid_Block_Adminhtml_Sales_Order_Grid_Renderer</renderer>
            <type>text</type>
         </arguments>
        <after>shipping_name</after>
</action>

and create file 'Renderer.php' at path Atwix/ExtendedGrid/Block/Adminhtml/Sales/Order/Grid

<?php

    class Atwix_ExtendedGrid_Block_Adminhtml_Sales_Order_Grid_Renderer extends Mage_Adminhtml_Block_Widget_Grid_Column_Renderer_Abstract
   {    
       public function render(Varien_Object $row)
       {
          $paymentMethodCode =  $row->getData($this->getColumn()->getIndex());
         /* $payments = Mage::getSingleton('payment/config')->getActiveMethods(); // will get all active payment method*/

          $payments = Mage::getModel('payment/config')->getAllMethods();  // get all available payment method

        
          $paymentTitle = '';
          foreach ($payments as $paymentCode=>$paymentModel)
          {
              if($paymentMethodCode == $paymentCode)
              {
                 $paymentTitle =Mage::getStoreConfig('payment/'.$paymentCode.'/title');
              
              }
              
           }

           return $paymentTitle;
        }
    } 

Reference link for renderer functionality :-

http://www.justwebdevelopment.com/blog/add-custom-column-and-get-custom-renderer-value-in-magento-grid/

http://magento.ikantam.com/qa/how-add-custom-renderer-magento-grid

EDIT:- in case if you use block file instead of layout file for column in grid, use below function to apply filter on renderer column.

public function filterPaymentMethod($collection, $column)
    {
        if (!$value = $column->getFilter()->getValue()) {
            return $this;
        }
    
        $collection->getSelect()->join(
                    'sales_flat_order_payment',           
                    'main_table.entity_id = sales_flat_order_payment.parent_id',
                    array('method'))
                 ->where("sales_flat_order_payment.method like ?", "%$value%");

        return $collection;
    }
 

Edit2:- replace your function filterPaymentMethod in observer.php file with below code --

public function filterPaymentMethod($collection, $column)
    {
        if (!$value = $column->getFilter()->getValue()) {
            return $this;
        }

        $payments =  Mage::getSingleton('payment/config')->getAllMethods();

        $codeToFilter ='';
        foreach ($payments as $paymentCode=>$paymentModel) {
            $paymentTitle = Mage::getStoreConfig('payment/'.$paymentCode.'/title');
            
            if (stripos($paymentTitle, $value) !== false && !$codeTomatch) {
                $codeTomatch = $paymentCode;
            }
        }
 
        $collection->getSelect()->join(
                    'sales_flat_order_payment',           
                    'main_table.entity_id = sales_flat_order_payment.parent_id',
                    array('method'))
                 ->where("sales_flat_order_payment.method like ?", "%$codeToFilter%");

        return $collection;
    }