ECShop2.7.0 打印定单时添加缩略图功能

最新推荐文章于 2024-09-15 18:25:31 发布

螺丝刀2000

最新推荐文章于 2024-09-15 18:25:31 发布

阅读量663

点赞数

分类专栏： ECShop 文章标签： join list sql

本文链接：https://blog.csdn.net/luosidao/article/details/4766533

版权

ECShop 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

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}" />

订单列表里打印时会出现商品缩略图了。