西部数码主机 | 阿里云主机| 虚拟主机 | 服务器 | 返回乐道官网
当前位置: 主页 > php教程 > ecshop教程 >

在Ecshop后台打印订单页面将商品按货号排序

时间:2011-02-27 18:44来源:未知 作者:好模板 点击:次
ECSHOP后台管理里的打印订单 页面里的商品排序有点乱，现在想改成按序号来排序，修改方法如下 下面是在2.7.2基础上做的修改 打开 admin/order.php文件 找到(大约在311行左右) $sql = SELECT

 ECSHOP后台管理里的“打印订单" 页面里的商品排序有点乱，现在想改成按序号来排序，修改方法如下

下面是在2.7.2基础上做的修改

打开 admin/order.php  文件

找到(大约在311行左右)

$sql = "SELECT o.*, IF(o.product_id > 0, p.product_number, g.goods_number) AS storage, o.goods_attr, g.suppliers_id, IFNULL(b.brand_name, '') AS brand_name, p.product_sn
            FROM " . $ecs->table('order_goods') . " AS o
                LEFT JOIN " . $ecs->table('products') . " AS p
                    ON p.product_id = o.product_id
                LEFT JOIN " . $ecs->table('goods') . " AS g
                    ON o.goods_id = g.goods_id
                LEFT JOIN " . $ecs->table('brand') . " AS b
                    ON g.brand_id = b.brand_id
            WHERE o.order_id = '$order[order_id]'";


修改为

$sql = "SELECT o.*, IF(o.product_id > 0, p.product_number, g.goods_number) AS storage, o.goods_attr, g.suppliers_id, IFNULL(b.brand_name, '') AS brand_name, p.product_sn
            FROM " . $ecs->table('order_goods') . " AS o
                LEFT JOIN " . $ecs->table('products') . " AS p
                    ON p.product_id = o.product_id
                LEFT JOIN " . $ecs->table('goods') . " AS g
                    ON o.goods_id = g.goods_id
                LEFT JOIN " . $ecs->table('brand') . " AS b
                    ON g.brand_id = b.brand_id
            WHERE o.order_id = '$order[order_id]'order by g.goods_sn";
这样修改以后就可以按照商品序号进行排序了

 

(责任编辑：好模板)
顶一下
(0)
0%
踩一下
(0)
0%
------分隔线----------------------------
栏目列表
热点内容
随机内容
随机模板
CopyRight © 2010-2023 乐道主机 All Rights Reserved.