Magento - 自定义管理网格问题


Magento - custom admin grid issue

我一直在为 magento 后端编写一个自定义的缺货模块,我有大量操作、导出等工作。但是,当我执行任何类型的搜索功能(例如在产品名称字段中放置某些内容)并且确实尝试更改为下一页(或在字段中输入特定页面)或页面上显示的产品数量时。它会立即将我重定向到仪表板。

谁能指出我处理此功能的代码的正确方向?我将假设它是控制器的一部分,但我一直在寻找最后一个小时,现在是时候寻求帮助了!!

感谢您提供的任何帮助!

准备列功能:

protected function _prepareColumns()
{
    $this->addColumn('sku',
        array(
            'header'=> Mage::helper('catalog')->__('SKU'),
            'width' => '80px',
            'index' => 'sku',
    ));
    $sets = Mage::getResourceModel('eav/entity_attribute_set_collection')
        ->setEntityTypeFilter(Mage::getModel('catalog/product')->getResource()->getTypeId())
        ->load()
        ->toOptionHash();
    $this->addColumn('set_name',
        array(
            'header'=> Mage::helper('catalog')->__('Attrib. Set Name'),
            'width' => '60px',
            'index' => 'attribute_set_id',
            'type'  => 'options',
            'options' => $sets,
    ));
    $store = $this->_getStore();
    if ($store->getId()) {
        $this->addColumn('custom_name',
            array(
                'header'=> Mage::helper('catalog')->__('Name in %s', $store->getName()),
                'index' => 'custom_name',
        ));
    }
    $this->addColumn('name',
        array(
            'header'=> Mage::helper('catalog')->__('Name'),
            'index' => 'name',
    ));
    $this->addColumn('stock_status',
        array(
            'header'=> 'Availability',
            'width' => '60px',
            'index' => 'stock_status',
            'type'  => 'options',
            'options' => array('1'=>'In stock','0'=>'Out of stock'),
    )); 
    $this->addColumn('custom_stock_status',
    array(
        'header' => 'Custom Stock Status',
        'width' => '60px',
        'index' => 'custom_stock_status',
        'type' => 'options',
        'editable' => 'true',));
     $this->addColumn('eol',
     array(
        'header'=> Mage::helper('catalog')->__('EoL'),
        'width' => '20px',
        'type'  => 'checkbox',
        'index' => 'eol',
        'onclick'   => 'this.value = this.checked ? 1 : 0;',
        'values'    => array('1','2'),
        'editable' => 'true',
    ));
    $store = $this->_getStore();
    $this->addColumn('qty',
        array(
            'header'=> Mage::helper('catalog')->__('Qty'),
            'width' => '25px',
            'type'  => 'number',
            'index' => 'qty',
    ));
    $this->addColumn('status',
        array(
            'header'=> Mage::helper('catalog')->__('Status'),
            'width' => '70px',
            'index' => 'status',
            'type'  => 'options',
            'options' => Mage::getSingleton('catalog/product_status')->getOptionArray(),
    ));
    $this->addColumn('action',
        array(
            'header'    => Mage::helper('catalog')->__('Action'),
            'width'     => '90px',
            'type'      => 'action',
            'getter'     => 'getId',
            'actions'   => array(
                array(
                    'caption' => Mage::helper('catalog')->__('Edit Product'),
                    'url'     => array(
                        'base'=>'store_admin/catalog_product/edit',
                        'params'=>array('store'=>$this->getRequest()->getParam('store'))
                    ),
                    'field'   => 'id'
                )
            ),
            'filter'    => false,
            'sortable'  => false,
            'index'     => 'stores',
    ));
    $this->addRssList('rss/catalog/notifystock', Mage::helper('catalog')->__('Notify Low Stock RSS'));
    return parent::_prepareColumns();
}

此外,我正在尝试按属性过滤,我需要过滤相同的属性两次才能输出 null 和 no 属性,但不是 yes。有没有办法这样做?

->addAttributeToFilter('eol', array('null' => true), 'left')
->addAttributeToFilter('eol', array('No' => true));

这就是我目前正在尝试做的事情,但是,它丝毫不起作用。两者都可以单独工作!

Mage_Adminhtml_Block_Widget_Grid  

有一个方法

_addColumnFilterToCollection($column)

可以重写它以实现自定义网格的筛选逻辑。

对于 CE 1.6.2,这对我有用:

1) 将app/code/core/Mage/Adminhtml/Block/Catalog/Product/Grid.php复制到app/code/local/Mage/Adminhtml/Block/Catalog/Product/Grid.php

2)从app/code/local/Mage/Adminhtml/Block/Catalog/Product/Grid.php内/下添加以下代码_prepareCollection()

->addAttributeToSelect('type_id');之后和if (Mage::helper('catalog')->isModuleEnabled('Mage_CatalogInventory')) {之前

法典:

$collection->joinTable( 'cataloginventory/stock_item',
'product_id=entity_id', array("stock_status" => "is_in_stock") )
->addAttributeToSelect('stock_status');

3)在第180行之后添加以下内容 'index' => 'price', ));

法典:

$this->addColumn('stock_status',
    array(
        'header'=> 'Stock Status', // this is the title of the column
        'width' => '60px',         // this is the width of the column
        'index' => 'stock_status',
        'type'  => 'options',
        'options' => array('1'=>'In Stock','0'=>'Out Of Stock'),
    )
);