ecshop商品详情页增加已售商品数量和评论数量的方法

muban大师

   

1.打开 goods.php 文件，在此文件最下面加入如下两个函数 function get_buy_sum($goods_id) { $sql = 'SELECT INULLSUM(g.goods_number)] 0) ' . 'FROM ' . $GLOBALS['ecs',->table('order_info') . ' AS o, ' . $GLOBALS['ecs',->table('order_goods') . ' AS g ' . "WHERE o.order_id = g.order_id " . "AND o.order_status = '" . OS_CONFIRMED . "' " . "AND o.shipping_status " . db_create_in(array(SS_SHIPPED, SS_RECEIVED)) . " AND o.pay_status " . db_create_in(array(PS_PAYED, PS_PAYING)) . " AND g.goods_id = '$goods_id'"; return $GLOBALS['db',->getOne($sql); } function get_comment_num($goods_id) { $sql= "sel ect count(*) from ".$GLOBALS['ecs',->table('comment')." where id_value='".$goods_id."' AND status = 1"; return $GLOBALS['db',->getOne($sql); } 2.继续修改 goods.php 文件 找到 $smarty->display('goods.dwt', $cache_id); 在此代码前面添加 $smarty->assign('buy_num',get_buy_sum($goods_id)); $smarty->assign('comment_num',get_comment_num($goods_id)); 3.打开 /themes/模板...

   

内容已隐藏,请关注公众号输入验证码查看

               
验证码 

  

本帖支持关注公众号查看

【无套路  无套路  无套路 扫描二维码关注公众号发送【验证码】收到验证码 在上面输入点击提交查看即可显示隐藏内容】