; overflow:hidden; padding:1px; line-height:200%" class="artile-bodycont">
实现ECSHOP商品详情页面显示购买记录
有些ECSHOP模板开发时候没有带这个商品购买记录,所以需要自己增加下:
在goods.php加入 代码
$smarty->assign('sale_history', getsales_history($goods_id));
function getsales_history($goods_id){
$sql ='select f.consignee, f.order_sn, f.address, g.goods_number,f.add_time FROM '. $GLOBALS['ecs']->table('order_goods') .' as g,'. $GLOBALS['ecs']->table('order_info') .' as f where g.order_id = f.order_id and g.goods_id='.$goods_id;
$res = $GLOBALS['db']->getAll($sql);
$sales_history = array();
foreach ($res AS $idx => $row){
$sales_history[$idx]['name'] = $row['consignee'];
$sales_history[$idx]['order_sn'] = $row['order_sn'];
$sales_history[$idx]['address'] = $row['address'];
$sales_history[$idx]['number'] = $row['goods_number'];
$sales_history[$idx]['add_time'] = local_date($GLOBALS['_CFG']['time_format'], $row['add_time']);
}
return $sales_history;
}
在goods.dwt中加入 代码
<table width="100%" cellpadding="5" cellspacing="1">
<td align="center">{$saleitem.address}
<td align="center">{$saleitem.number}
<td align="center">{$saleitem.add_time}