问题描述：2 O7 ]9 e" L' a# j+ }
我想让商品列表页（category.php）的每个商品的下面显示该商品的评论数量以及评论等级，该如何操作呢？？
) P8 M! L( I7 V+ Y" K
& n) f. v! s+ o* k* z效果图示：
3 ^5 j& N& y5 e6 F3 O/ ?; G
! z9 ~9 t. C, |# q8 g
) T; J! S. v% O7 i. `解决方法：- K, Q3 T) f* w/ U
第一步：
/ ?4 h( U, q- p首先修改category.php 文件，定位到 category_get_goods() 函数部分; d0 h+ h- Q2 `5 n# [# \
找到 $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, ' ., |( N% U# L6 i$ |* K/ J' P! ?
"IFNULL(mp.user_price, g.shop_price * '$_SESSION[discount]') AS shop_price, g.promote_price, g.goods_type, " .
! `2 r& y# \) C 'g.promote_start_date, g.promote_end_date, g.goods_brief, g.goods_thumb , g.goods_img ' .
# l, u' f+ q+ [, z) A4 \& R 'FROM ' . $GLOBALS['ecs']->table('goods') . ' AS g ' .: U1 I4 {# f1 X6 a
'LEFT JOIN ' . $GLOBALS['ecs']->table('member_price') . ' AS mp ' .( x& l% m9 ?& C( i, k1 R' K
"ON mp.goods_id = g.goods_id AND mp.user_rank = '$_SESSION[user_rank]' " .$ T+ g! Z- ~9 ~+ g
"WHERE $where $ext ORDER BY $sort $order"; |
! k2 E- H4 {: R
将之修改为$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, ' .
% c3 y1 D, _! R; l$ O2 d7 H- n "IFNULL(mp.user_price, g.shop_price * '$_SESSION[discount]') AS shop_price, g.promote_price, g.goods_type, " .
1 V0 ~& H0 a5 a " IFNULL(AVG(r.comment_rank),0) AS comment_rank,IF(r.comment_rank,count(*),0) AS comment_count, ".0 U* M& E3 l' d/ F, _
'g.promote_start_date, g.promote_end_date, g.goods_brief, g.goods_thumb , g.goods_img ' .7 \. _; s8 H. }* y* e
'FROM ' . $GLOBALS['ecs']->table('goods') . ' AS g ' .
+ M! E, I. Y, t4 Q 'LEFT JOIN ' . $GLOBALS['ecs']->table('member_price') . ' AS mp ' .
% x! k# n5 Q' a6 w3 J "ON mp.goods_id = g.goods_id AND mp.user_rank = '$_SESSION[user_rank]' " .3 z" r5 b+ i& F0 E9 }! l/ o
' LEFT JOIN '. $GLOBALS['ecs']->table('comment') .' AS r '.
; E) i; K0 Z' C f* W) I 'ON r.id_value = g.goods_id AND comment_type = 0 AND r.parent_id = 0 AND r.status = 1 ' .! t" [# H( @; E1 I, A' f. D
"WHERE $where $ext group by g.goods_id ORDER BY $sort $order"; |
5 I/ v/ v4 Y- p8 G/ `, R$ ]
然后继续找到| $arr[$row['goods_id']]['url'] = build_uri('goods', array('gid'=>$row['goods_id']), $row['goods_name']); |
! ?- j5 k& I4 B8 ]* }: |
在它下面增加几行代码$row['comment_rank'] = ceil($row['comment_rank']) == 0 ? 5 : ceil($row['comment_rank']);
4 M7 e2 _0 C- e# v7 b: m$arr[$row['goods_id']]['comment_rank']=$row['comment_rank'];
, c0 Q9 l4 c# p6 v0 O$arr[$row['goods_id']]['comment_count']=$row['comment_count']; |
' @# m) t) i+ ^% o% j* |第二步(以官方默认模板为例)：& D X, i. R. ?9 m( j' J
修改 htemes/default/library/goods_list.lbi 文件
' l6 K9 t1 m: r6 M找到* v! G- O4 B# N) I6 O0 F
| <a href="javascript:collect({$goods.goods_id});" class="f6">{$lang.btn_collect}</a> |
; i. r! R9 K- f( \# h! v在它上面增加8 y, i2 D* y$ J+ w, y& E
<img src="images/stars{$goods.comment_rank}.gif" style="width:78px;height:15px;" /><br> 6 Q4 f2 O8 i( O3 v4 o4 [) L2 h
评论数：{$goods.comment_count}<br> |
9 e# o5 ^/ ~7 B- _& ]" R: p
结束语：
6 _( _8 \/ w% s7 J8 R% C, D e+ T大家都知道ECSHOP系统有缓存机制，如果某个商品有了新的评论，列表页的评论数量不会立马随着更新。得等到下次更新缓存的时候才会更新。
+ ?# r) b% K9 R Y: T" _% d0 U( \0 \; T
如果您想列表页能即时体现评论数量的变化。只需继续进行下面修改即可* i; y5 `, ^5 c* `
------------------------------------------------------------------------------------------------4 j. z( [3 ], @6 y
把 category.php 文件的
' s; o i" U3 I( V' W' ^5 `$ h1 O& }$smarty->caching = true;
2 A% O* g2 B* g) ~修改为% e r0 v- _) _8 a, ?5 Y
$smarty->caching = false; G7 W0 ]$ m) [7 }& {% j' @& u
-----------------------------------------------------------------
+ g& s) U% ?6 P5 w) N6 R, s |
28444
0
©2015-2022 tuyuanma.com 版权所有 Sitemap.xml
开发工具
站长平台
IDC服务商
注册交易
SEO及安全
开放平台
CDN及SSL
源码资源
自媒体平台
图片工具
小程序平台
投资理财
常用工具
友情链接
网络硬盘
赣公网安备36112102000036号
赣ICP备17001544号-10