ecshop商品详情页面显示商品购买记录方法

时间： 2024-02-25 10:43 阅读：次作者：素材无忧网

实现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("Y-m-d", $row['add_time']);
$sales_history[$idx]['add_time'] = local_date($GLOBALS['_CFG']['time_format'], $row['add_time']);
}
return $sales_history;}
在goods.dwt中加入代码
历史购买记录名字订单号地址数量日期
{$saleitem.name} {$saleitem.order_sn}

{$saleitem.address}

{$saleitem.number}

{$saleitem.add_time}

转载请注明： ecshop商品详情页面显示商品购买记录方法

上一篇：ecshop品牌列表页实现分页的方法

下一篇：ecshop会员注册自动发送邮件欢迎信息修改方法

标签： ecshop商品详情