第一步:在/includes/lib_goods.php页末添加:
/*首页显示已售出件数*/
functionget_buy_sum($goods_id)
{
$sql="selectsum(goods_number)from".$GLOBALS[‘ecs’]->table(‘order_goods’)."ASg,".$GLOBALS[‘ecs’]->table(‘order_info’)."ASoWHEREo.order_status>1ando.order_id=g.order_idandg.goods_id=".$goods_id;/*注意订单状态*/
return$GLOBALS[‘db’]->getOne($sql);
}
首页精品、新品、热销版块显示“累计售出”:
在$goods[$idx][‘brand_name’]=isset($goods_data[‘brand’][$row[‘goods_id’]])?$goods_data[‘brand’][$row[‘goods_id’]]:”;
下添加:$goods[$idx][‘buy_num’]=get_buy_sum($row[‘goods_id’]);/*首页调用已售出件数*/
首页分类产品版块显示“累计售出”(这块注意找准位置"获得指定分类下的商品"):
在$goods[$idx][‘url’]=build_uri(‘goods’,array(‘gid’=>$row[‘goods_id’]),$row[‘goods_name’]);
下添加:$goods[$idx][‘buy_num’]=get_buy_sum($row[‘goods_id’]);/*首页分类下的产品调用已售出件数*/
程序部分就OK了,然后将其调用模板显示:
…best/hot/new.lbiandcat_goods.lbi中添加如下:
<span>已售出:
{if$goods.buy_num}
<font>
{else}
<font>
{/if}件</span>
/*首页显示已售出件数*/functionget_buy_sum($goods_id){$sql="selectsum(goods_number)from".$GLOBALS[‘ecs’]->table(‘order_goods’)."ASg,".$GLOBALS[‘ecs’]->table(‘order_info’)."ASoWHEREo.order_status>1ando.order_id=g.order_idandg.goods_id=".$goods_id;return$GLOBALS[‘db’]->getOne($sql);}可以一个人,可以几个人,一起放松那劳累的心情或者劳累自己的身体,