首页 > 代码库 > 在Ecshop后台打印订单页面将商品按货号排序
在Ecshop后台打印订单页面将商品按货号排序
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"; |
在Ecshop后台打印订单页面将商品按货号排序
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。