以UTF-8编码,bigsalev2.7模板以例:
一、新建,goods_buy.lbi 文件
加入如下代码
[code]
| {$goods_buy_num} | |||
| 会员ID | 客户地址 | 订购数量 | 订购时间 |
|---|---|---|---|
| {$goodsbuy.consignee} | {$goodsbuy.address} | {$goodsbuy.goods_number} | {$goodsbuy.add_time} |
[/code]
二、修改goods.PHP文件,两处
1、在文件尾加入两个函数
[code]
/**
* 取得跟商品关联前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);
}
[/code]
2、查找 $smarty->assign(‘goods’, $goods);
在其下一行加入
[code]
//获取商品销售记录
$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);
[/code]
三、修改模板(themes\BigSale\goods.dwt)
查找
[code]
{$lang.shopman_comment}
[/code]
在其下加入
[code]
{$lang.goods_buy}
[/code]
查找
在最后一个标记之后
[code]
[/code]
原文
http://bbs.ecshop.com/viewthread.php?tid=103350&extra=&page=1
RSS Feed
Twitter