Magento后台订单列表添加Shipping Address（送货地址）

最新推荐文章于 2019-09-06 11:47:00 发布

学习笔记666

最新推荐文章于 2019-09-06 11:47:00 发布

阅读量1.1k

点赞数

CC 4.0 BY-SA版权

分类专栏： Magento

本文链接：https://blog.csdn.net/github_26672553/article/details/45823685

Magento 专栏收录该内容

133 篇文章

订阅专栏

本文介绍如何在Magento的订单列表中增加显示收货地址的功能。通过修改Grid.php文件中的_prepareCollection()方法，实现从数据库中获取并展示每个订单对应的收货地址信息。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1.找到app/code/core/Mage/Adminhtml/Block/Sales/Order/Grid.php

中的_prepareCollection()方法，大约57行

修改为：

  protected function _prepareCollection()
    {
        $collection = Mage::getResourceModel($this->_getCollectionClass());
        $collection->getSelect()->joinLeft('sales_flat_order_address', 'main_table.entity_id = sales_flat_order_address.parent_id',array('ShippingAddress'=>new Zend_Db_Expr('CONCAT_WS(", ",sales_flat_order_address.street,sales_flat_order_address.city,sales_flat_order_address.region,sales_flat_order_address.postcode,sales_flat_order_address.telephone)')) );
        $collection->getSelect()->where('sales_flat_order_address.address_type="shipping"');//address_type="shipping"
        //echo $collection->getSelectSql(true);
        $this->setCollection($collection);
        return parent::_prepareCollection();
    }

2.在_prepareColumns()方法里添加如下：

 /*Shipping Address*/
        $this->addColumn('Shipping Address', array(
            'header' => Mage::helper('Sales')->__('Shipping Address'),
            'index' => 'ShippingAddress',
        ));