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";

這樣修改以后就可以按照商品序號進行排序了