广州传奇网络

地址:广州市天河区东圃大马路富华楼C座

电话:13808825895

邮箱:gz020wbs@163.com

QQ:1564443073

网址:http://www.020wbs.com/

首页 > 二次开发Ecshop二次开发 > 商品销售记录

二次开发Ecshop二次开发

二次开发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 DESC 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['consignee'] = sub_str($row['consignee'],1); //调用系统函数 显示结果为李...

$row['address'] = sub_str($row['address'],6); //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);

三、修改模板(themes\BigSale\goods.dwt)
查找

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