php 将列添加到 Magento 管理目录 > 管理产品

Add column to Magento admin catolog > manage products

提问by Graham Barnes

Hi I want to add a column to the catolg > manage products section (not the product but the list of products), this column needs to list any related products the product has identified with it - maybe by sku or name - no preferance there.

嗨，我想在 catolg > 管理产品部分添加一列（不是产品，而是产品列表），该列需要列出产品已标识的任何相关产品 - 可能是按 sku 或名称 - 没有偏好。

I added a column for manufacturer but forgot where i obtained the code from.

我为制造商添加了一个列，但忘记了从哪里获得代码。

thanks

谢谢

回答by clockworkgeek

I recently (yesterday in fact) had to add a column to the same grid. Partly because it is poor practice and mostly because another module had already used it's own override, I didn't want to replace or override the class completely. Instead here is a clean way to modify the product's grid via events.

我最近（实际上是昨天）不得不在同一个网格中添加一列。部分是因为这是不好的做法，主要是因为另一个模块已经使用了它自己的覆盖，我不想完全替换或覆盖该类。相反，这里提供了一种通过事件修改产品网格的简洁方法。

app/code/local/My/Module/etc/config.xml

app/code/local/My/Module/etc/config.xml

<config>
    <adminhtml>
        <events>
            <adminhtml_block_html_before>
                <observers>
                    <mymodule>
                        <!-- Add column to catalog product grid -->
                        <class>mymodule/adminhtml_observer</class>
                        <method>onBlockHtmlBefore</method>
                    </mymodule>
                </observers>
            </adminhtml_block_html_before>
            <eav_collection_abstract_load_before>
                <observers>
                    <mymodule>
                        <!-- Add column to product list -->
                        <class>mymodule/adminhtml_observer</class>
                        <method>onEavLoadBefore</method>
                    </mymodule>
                </observers>
            </eav_collection_abstract_load_before>
        </events>
    </adminhtml>
</config>

app/code/local/My/Module/Model/Adminhtml/Observer

app/code/local/My/Module/Model/Adminhtml/Observer

class My_Module_Model_Adminhtml_Observer
{

    public function onBlockHtmlBefore(Varien_Event_Observer $observer) {
        $block = $observer->getBlock();
        if (!isset($block)) return;

        switch ($block->getType()) {
            case 'adminhtml/catalog_product_grid':
                /* @var $block Mage_Adminhtml_Block_Catalog_Product_Grid */
                $block->addColumn('COLUMN_ID', array(
                    'header' => Mage::helper('mymodule')->__('COLUMN HEADER'),
                    'index'  => 'COLUMN_ID',
                ));
                break;
        }
    }

    public function onEavLoadBefore(Varien_Event_Observer $observer) {
        $collection = $observer->getCollection();
        if (!isset($collection)) return;

        if (is_a($collection, 'Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection')) {
            /* @var $collection Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection */
            // Manipulate $collection here to add a COLUMN_ID column
            $collection->addExpressionAttributeToSelect('COLUMN_ID', '...Some SQL goes here...');
        }
    }

}

回答by Mondane

To improve on answer https://stackoverflow.com/a/5994209/1025437by clockworkgeek:

通过clockworkgeek改进答案https://stackoverflow.com/a/5994209/1025437：

I decided not to use the observers, in my opinion those events are too global and lead to our observer being called many times. Using the following rewrite in your own module config.xml:

我决定不使用观察者，在我看来，这些事件过于全球化，导致我们的观察者被多次调用。在您自己的模块 config.xml 中使用以下重写：

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

With the following file in

使用以下文件

app/code/local/Myname/Catalogextended/Block/Adminhtml/Catalog/Product/Grid.php

containing something like:

包含以下内容：

<?php

class Myname_Catalogextended_Block_Adminhtml_Catalog_Product_Grid extends Mage_Adminhtml_Block_Catalog_Product_Grid
{
    /* Overwritten to be able to add custom columns to the product grid. Normally
     * one would overwrite the function _prepareCollection, but it won't work because
     * you have to call parent::_prepareCollection() first to get the collection.
     *
     * But since parent::_prepareCollection() also finishes the collection, the
     * joins and attributes to select added in the overwritten _prepareCollection()
     * are 'forgotten'.
     *
     * By overwriting setCollection (which is called in parent::_prepareCollection()),
     * we are able to add the join and/or attribute select in a proper way.
     *
     */
    public function setCollection($collection)
    {
        /* @var $collection Mage_Catalog_Model_Resource_Product_Collection */

        $store = $this->_getStore();

        if ($store->getId() && !isset($this->_joinAttributes['special_price'])) {
            $collection->joinAttribute(
                'special_price',
                'catalog_product/special_price',
                'entity_id',
                null,
                'left',
                $store->getId()
            );
        }
        else {
            $collection->addAttributeToSelect('special_price');
        }

        parent::setCollection($collection);
    }

    protected function _prepareColumns()
    {
        $store = $this->_getStore();
        $this->addColumnAfter('special_price',
            array(
                'header'=> Mage::helper('catalog')->__('special_price'),
                'type'  => 'price',
                'currency_code' => $store->getBaseCurrency()->getCode(),
                'index' => 'special_price',
            ),
            'price'
         );

        return parent::_prepareColumns();
    }
}

In this example, an attribute named special_priceis added after column price. Since this attribute has a store scope, the check for store is added.

在此示例中，special_price在 column 之后添加了一个名为的属性price。由于此属性具有存储范围，因此添加了对存储的检查。