ECShop2.7.0 打印定单时添加缩略图功能
找admin/order.php
文件的和307行
/* 取得订单商品 */
$goods_list = array();
$goods_attr = array();
$sql = "SELECT o.*, g.goods_number AS storage, o.goods_attr, IFNULL(b.brand_name, '') AS
brand_name " .
"FROM " . $ecs->table('order_goods') . " AS o ".
"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]' ";
在第311行里添加
g.goods_thumb AS goods_thumb
添加后文件内容为:
/* 取得订单商品 */
$goods_list = array();
$goods_attr = array();
$sql = "SELECT o.*, g.goods_number AS storage, o.goods_attr, IFNULL(b.brand_name, '') AS
brand_name, g.goods_thumb AS goods_thumb " .
"FROM " . $ecs->table('order_goods') . " AS o ".
"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]' ";
然后,进入ECSHOP的后台---》订单管理---》打印订单
要在显示商品缩略图的地方添加如下代码:
<img height="60" alt="" width="60" src="../{$goods.goods_thumb}" />
订单列表里打印时会出现商品缩略图了。