Display Data in Custom Column in Magento 1.9 Admin – How To

adminadminhtmlcustomgridmagento-1.9

I've already asked a question about that here:How to Fetch / Add a Custom Column in Product List Grid In Admin
Unfortunately, I didn't see that due to this solution my products name don't appear anymore.

I changed my code, and now, the collection fetch the data correctly (I printed the query and executed it in the mysql console directly), but the data aren't displayed inside the custom column for I don't know which reason.

Here's my module code:

app/code/local/Mypackage/Customgrid/etc/Config.xml:

<?xml version="1.0"?>
<config>
    <modules>
        <Mypackage_Customgrid>
            <version>0.4.0</version>
        </Mypackage_Customgrid>
    </modules>

    <global>
       <blocks>
            <adminhtml>
                <rewrite>
                     <catalog_product_grid>Mypackage_Customgrid_Block_Adminhtml_Catalog_Product_Grid</catalog_product_grid>
                </rewrite>
            </adminhtml>
        </blocks>
    </global>
</config>

app/code/local/Mypackage/Customgrid/Block/Adminhtml/Catalog/Product/Grid.php:

class Mypackage_Customgrid_Block_Adminhtml_Catalog_Product_Grid extends Mage_Adminhtml_Block_Catalog_Product_Grid {

    protected function _prepareCollection() {
        parent::_prepareCollection();
        $collection = $this->getCollection();

        $resource = Mage::getSingleton('core/resource');
        $collection->getSelect()
        ->join(
            array('v' => $resource->getTableName('udropship/vendor')),
            'e.entity_id = v.vendor_id',
            array('vendor_name')
        );

        $collection->printLogQuery(true);

        $this->setCollection($collection);
        $this->getCollection()->addWebsiteNamesToResult();

        return $this;
    }

    protected function _prepareColumns() {

        $this->addColumnAfter('vendor_name', array(
                'header'    => Mage::helper('catalog')->__('Vendor'),
                'index'     => 'vendor_name',
                'type'      => 'text',
            ), 'visibility');

        return parent::_prepareColumns();
    }
}

Any idea on what's happening here ? Thank you !

Best Answer

I've finally did it that way:

app/code/local/Mypackage/Customgrid/etc/Config.xml:

<?xml version="1.0"?>
<config>
    <modules>
        <Mypackage_Customgrid>
            <version>0.4.0</version>
        </Mypackage_Customgrid>
    </modules>

    <global>
        <blocks>
            <adminhtml>
                <rewrite>
                    <catalog_product_grid>Mypackage_Customgrid_Block_Adminhtml_Catalog_Product_Grid</catalog_product_grid>
                </rewrite>
            </adminhtml>
        </blocks>
    </global>
</config>

app/code/local/Mypackage/Customgrid/Block/Adminhtml/Catalog/Product/Grid.php:

class Mypackage_Customgrid_Block_Adminhtml_Catalog_Product_Grid extends Mage_Adminhtml_Block_Catalog_Product_Grid
{
    protected function _prepareCollection()
    {
        parent::_prepareCollection();
        $collection = $this->getCollection();

        $collection->addAttributeToSelect('udropship_vendor');

        $this->setCollection($collection);
        $this->getCollection()->addWebsiteNamesToResult();

        return $this;
    }

    protected function _prepareColumns()
    {
        $attributeId = Mage::getResourceModel('eav/entity_attribute')->getIdByCode('catalog_product','udropship_vendor');
        $attribute = Mage::getModel('catalog/resource_eav_attribute')->load($attributeId);
        $attributeData = $attribute->getData();
        $attributeOptions = $attribute->getSource()->getAllOptions();

        $attributeOptions2 = array();
        foreach ($attributeOptions as $value) {
            if(!empty($value['value'])) {
                $attributeOptions2[$value['value']] = $value['label'];
            }
        }

        $this->addColumnAfter('udropship_vendor',
            array(
                'header'=> Mage::helper('catalog')->__('Vendor Name'),
                'width' => '150px',
                'index' => 'udropship_vendor',
                'type'  => 'options',
                'options' => $attributeOptions2,
        ), 'price');

        return parent::_prepareColumns();
    }
}

Related Solutions

Unserialize Data from Sales_Flat_Order_Payment to Display in Custom Grid

This issue you can solve by customizing the renderer file. You can fetch the format from database by custom query as well.

For eg. Prodid.php

<?php
class Mage_Adminhtml_Block_Sales_Order_Renderer_Prodid extendsMage_Adminhtml_Block_Widget_Grid_Column_Renderer_Abstract
{

    public function render(Varien_Object $row){
        $url = $this->getUrl('*/*/edit', array(
            'store'=>$this->getRequest()->getParam('store'),
            'id'=>$row->getId())
        );
        $exploding = explode('sales_order/edit/id/',$url);
        //print_r($exploding);
        $id = explode('/',$exploding[1]);
        //print_r($id);
        $myId = $id[0];
        //echo $myId;
        $write = Mage::getSingleton('core/resource')->getConnection('core_write');

        // now $write is an instance of Zend_Db_Adapter_Abstract
        $readresult=$write->query("SELECT product_id FROM `sales_flat_order_item` WHERE `order_id` =$myId "); 
        while ($row = $readresult->fetch() ) {
            $productid = $row['product_id'];
             $myprodid .= $productid.',';

        }
        $myprodid2 = substr($myprodid,0,-1);
            return $myprodid2;
    }

}
?>

This will give you the desired result in my case it was product id

Then calling it in the grid file would be like

$this->addColumn('ids', array(
        'header'    => Mage::helper('sales')->__('Product ID'),
        'width'     => '100px',
        'index'     => 'ids',
        'type'      => 'text',
        'filter'    => false,
        'sortable'  => false,
        'renderer'  => 'Mage_Adminhtml_Block_Sales_Order_Renderer_Prodid'
    ));

The filter=false and sortable false will remove the a href from the headers and will only show you the data.

If you want to make them sortable, then you will need to pass the corresponding unique index id.

Please share if anything is unclear here.

Magento – How to filter grid by custom column -magento2

I have found solution as below : To add custom filtration, I have created method _renderFiltersBefore and written join sql query in /Model/Resource/Items/collection as below :

protected function _renderFiltersBefore()
    {
        $this->getSelect()->join(......);
        return parent::_renderFiltersBefore();
    }

but there was some issue with alias in sql so I have added : $this->addFilterToMap('entity_id', 'main_table.entity_id'); Now it works perfectly.

Best Answer

Related Solutions

Unserialize Data from Sales_Flat_Order_Payment to Display in Custom Grid

Magento – How to filter grid by custom column -magento2

Related Topic