如何在ecshop显示商品销售记录 商品已销售数量

以UTF-8编码，bigsalev2.7模板以例：
一、新建，goods_buy.lbi 文件
加入如下代码

<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<!-- {if $goods_buy} -->
    <table width="80%" border="0" align="center" cellpadding="5" cellspacing="1" bgcolor="#cccccc">
<tr>
             <td colspan="4" align="right" bgcolor="#ffffff">{$goods_buy_num}</td>
</tr>
        <tr>
            <th bgcolor="#ffffff">会员ID</th>
            <th bgcolor="#ffffff">客户地址</th>
            <th bgcolor="#ffffff">订购数量</th>
            <th bgcolor="#ffffff">订购时间</th>
        </tr>

   <!-- {foreach from=$goods_buy item=goodsbuy} 购买记录 -->
        <tr>
            <td bgcolor="#ffffff">{$goodsbuy.consignee}</td>
            <td bgcolor="#ffffff">{$goodsbuy.address}</td>
            <td bgcolor="#ffffff">{$goodsbuy.goods_number}</td>
            <td bgcolor="#ffffff">{$goodsbuy.add_time}</td>
        </tr>
      <!-- {/foreach} -->
     </table>
<!-- {/if} -->

二、修改goods.PHP文件，两处
1、在文件尾加入两个函数

/**
* 取得跟商品关联前10条订购记录
*
* @param   string $goods_id    商品编号
*
* @return 订购记录
*/
function get_goods_buy_list($goods_id)
{
    $sql = "SELECT g.goods_id,o.consignee,o.add_time,g.goods_number,g.order_id,o.address".
           " FROM " . $GLOBALS['ecs']->table('order_goods') . " AS g".
           " LEFT JOIN " . $GLOBALS['ecs']->table('order_info') . " AS o on o.order_id=g.order_id".
           " WHERE g.goods_id = " . $goods_id . " and o.order_status=1" .
           " ORDER BY o.add_time LIMIT 10 ";
    $res = $GLOBALS['db']->query($sql);
    $arr = array();
    while ($row = $GLOBALS['db']->fetchRow($res))
    {
$row['add_time'] = local_date('Y-m-d H:i:s',$row['add_time']);
$row['address']     =   sub_str($row['address'],6);
        $arr[] = $row;
    }
    return $arr;
}
/**
* 取得跟商品关联前10条订购记录
*
* @param   string $goods_id    商品编号
*
* @return 订购记录
*/
function get_goods_buy_num($goods_id)
{
    $sql = "SELECT count(g.rec_id) as num".
           " FROM " . $GLOBALS['ecs']->table('order_goods') . " AS g".
           " LEFT JOIN " . $GLOBALS['ecs']->table('order_info') . " AS o on o.order_id=g.order_id".
           " WHERE g.goods_id = " . $goods_id . " and o.shipping_status=1";

return $GLOBALS['db']->getOne($sql);
}
/**
* 取得商品销售总量
*
* @param   string $goods_id    商品编号
*
* @return 订购量
*/
function get_goods_buy_sum($goods_id)
{
    $sql = "SELECT sum(g.goods_number) as num".
           " FROM " . $GLOBALS['ecs']->table('order_goods') . " AS g".
           " WHERE g.goods_id = " . $goods_id . " " ;
    return $GLOBALS['db']->getOne($sql);
}

2、查找 $smarty->assign('goods', $goods);
在其下一行加入

//获取商品销售记录
        $smarty->assign('goods_buy',          get_goods_buy_list($goods_id));
$buy_num = get_goods_buy_num($goods_id);
if ($buy_num!= 0 )
   sprintf("[%s]位顾客购买过", $buy_num);
        $smarty->assign('goods_buy_num',      $buy_num);

三、修改模板
查找

<h2 class="h2bg"><span class="L"></span><span class="R"></span>{$lang.shopman_comment}</h2>

在其下加入

<h2 class="h2bg"><span class="L"></span><span class="R"></span>{$lang.goods_buy}</h2>

查找</blockquote>在最后一个标记之后

<!-- {/foreach} -->
</blockquote>
<!-- {/if} -->

在其下加入


<blockquote>
<!-- #BeginLibraryItem "/library/goods_buy.lbi" --><!-- #EndLibraryItem -->
</blockquote>