国产探花免费观看_亚洲丰满少妇自慰呻吟_97日韩有码在线_资源在线日韩欧美_一区二区精品毛片,辰东完美世界有声小说,欢乐颂第一季,yy玄幻小说排行榜完本

首頁 > 網(wǎng)站 > 建站經(jīng)驗 > 正文

ECSHOP商品列表頁顯示每個商品的評論等級和評論

2024-04-25 20:32:05
字體:
供稿:網(wǎng)友

第一步:

首先修改category.php 文件,定位到 category_get_goods() 函數(shù)部分

找到

$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.sop_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.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) AScomment_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";

然后繼續(xù)找到

$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'];

第二步:

修改 htemes/default/library/goods_list.lbi 文件

找到<a href="javascript:collect({$goods.goods_id});" class="f6">{$lang.btn_collect}</a>

在它上面增加

<img src="images/stars{$goods.comment_rank}.gif"style="width:78px;height:15px;" /><br>

評論數(shù):{$goods.comment_count}<br

若想列表頁能即時體現(xiàn)評論數(shù)量的變化。只需繼續(xù)進行下面修改即可把 category.php 文件的 $smarty->caching = true;

修改為

$smarty->caching = false;

發(fā)表評論 共有條評論
用戶名: 密碼:
驗證碼: 匿名發(fā)表
主站蜘蛛池模板: 西充县| 滕州市| 通榆县| 台江县| 日土县| 永济市| 涡阳县| 淳化县| 桃园市| 桦川县| 东辽县| 磐石市| 阿勒泰市| 通山县| 大埔区| 长乐市| 邹平县| 靖西县| 当阳市| 和龙市| 元谋县| 天全县| 图们市| 沂南县| 秭归县| 三亚市| 弥勒县| 黄浦区| 繁峙县| 玉田县| 中阳县| 灵武市| 宿迁市| 赣榆县| 华安县| 石泉县| 宁强县| 当雄县| 庄河市| 安溪县| 奈曼旗|