如果我们在ecshop的商品列表页可以看到每个商品的评论等级、评论数量、点击量和销售量，就会显得网站更充气和专业，更可以一眼就看到商城中某个商品更火热，如果再加上评论等级、评论数量、点击量和销售量的点击排序就更完美了，貌似淘宝商城里面的这些项目都显示了吧，看起来就很充实，好了，下面夏日博客就来教下大家如何在ecshop商品列表页显示单个商品的评论等级、评论数量、点击量和销售量等。

第一步：首先修改category.php 文件，定位到 category_get_goods() 函数部分,找到:

$sql = 'SELECT g.goods_id, g.goods_name, g.goods_name_style, g.market_price, g.is_new, g.is_best, g.is_hot, g.shop_price AS org_price, ' .
"IFNULL(mp.user_price, g.shop_price * '$_SESSION[discount]') AS shop_price, g.promote_price, g.goods_type, " .
'g.promote_start_date, g.promote_end_date, g.goods_brief, g.goods_thumb , g.goods_img ' .
'FROM ' . $GLOBALS['ecs']->table('goods') . ' AS g ' .
'LEFT JOIN ' . $GLOBALS['ecs']->table('member_price') . ' AS mp ' .
"ON mp.goods_id = g.goods_id AND mp.user_rank = '$_SESSION[user_rank]' " .
"WHERE $where $ext ORDER BY $sort $order";

将之修改为:

$sql = 'SELECT g.goods_id, g.goods_name, g.goods_name_style, g.market_price,g.click_count, g.is_new, g.is_best, g.is_hot, g.shop_price AS org_price, ' .
"IFNULL(mp.user_price, g.shop_price * '$_SESSION[discount]') AS shop_price, g.promote_price, g.goods_type, " .
" IFNULL(AVG(r.comment_rank),0) AS comment_rank,IF(r.comment_rank,count(*),0) AS comment_count, ".
'g.promote_start_date, g.promote_end_date, g.goods_brief, g.goods_thumb , g.goods_img ' .
'FROM ' . $GLOBALS['ecs']->table('goods') . ' AS g ' .
'LEFT JOIN ' . $GLOBALS['ecs']->table('member_price') . ' AS mp ' .
"ON mp.goods_id = g.goods_id AND mp.user_rank = '$_SESSION[user_rank]' " .
' LEFT JOIN '. $GLOBALS['ecs']->table('comment') .' AS r '.
'ON r.id_value = g.goods_id AND comment_type = 0 AND r.parent_id = 0 AND r.status = 1 ' .
"WHERE $where $ext group by g.goods_id ORDER BY $sort $order";

然后继续找到:

$arr[$row['goods_id']]['url'] = build_uri('goods', array('gid'=>$row['goods_id']), $row['goods_name']);

在它下面增加几行代码:

$row['comment_rank'] = ceil($row['comment_rank']) == 0 ? 5 : ceil($row['comment_rank']);
$arr[$row['goods_id']]['comment_rank']=$row['comment_rank'];
$arr[$row['goods_id']]['comment_count']=$row['comment_count'];

$arr[$row['goods_id']]['buy_num'] = get_buy_sum($row['goods_id']);
$arr[$row['goods_id']]['click_count'] = $row['click_count'];

第二步:

第1步：打开文件 includes/lib_goods.php,在该文件的末尾添加如下代码片段

function get_buy_sum($goods_id)
{
$sql = "select sum(goods_number) from " . $GLOBALS['ecs']->table('order_goods') . " AS g ,".$GLOBALS['ecs']->table('order_info') . " AS o WHERE o.order_id=g.order_id and g.goods_id = " . $goods_id ;
return $GLOBALS['db']->getOne($sql);
}

第三步(以官方默认模板为例)：

修改 themes/default/library/goods_list.lbi 文件,找到对应的位置修改:

<img src="images/stars{$goods.comment_rank}.gif" style="width:78px;height:15px;" /><br> 
评论数：{$goods.comment_count}<br>
点击量：{$goods.click_count}<br>
销售量：{if $goods.buy_num}{$goods.buy_num}{else}0{/if}

至于站点的模板，自己DIY吧，在对应的位置中进行调用相应的标签即可。