{query:name=order_goods as og join= join order as o on og.order_id eq o.id left join goods as lg on lg.id eq og.goods_id AND lg.is_del eq 0 fields= DISTINCT lg.name,format(lg.sell_price,2) as price,lg.small_img,lg.id where= o.user_id in ($shop_goods) AND lg.id is not null order = o.completion_time desc limit=5}
{query:name=commend_goods as cg join= left join goods as lg on lg.id eq cg.goods_id fields=lg.name,lg.sell_price,lg.small_img,lg.id where=commend_id eq 3 AND lg.is_del eq 0 AND lg.id is not null order=lg.sort asc,lg.id desc limit=5}
{query:name=comment as c join=left join goods as lg on c.goods_id eq lg.id AND lg.is_del eq 0 left join user as u on u.id eq c.user_id fields=c.time,u.head_ico,c.comment_time,c.contents,c.point,lg.id as gid,c.user_id where=c.goods_id eq $id and c.status eq 1 order=c.comment_time desc id=$quer_com page=1}
{query:name=user as u join=left join member as m on m.user_id eq u.id fields=u.username,m.group_id where=u.id eq $item[user_id] item=$va}
{if:$va['username']}{$va['username']}{/if}
{query:name=user_group fields=group_name where=id eq $va[group_id] item=$it}
{if:$it['group_name']}
{query:name=order_goods as og join=left join order as o on og.order_id eq o.id fields=o.user_id,og.product_id,og.goods_price,og.goods_nums,o.completion_time where=og.goods_id eq $id and o.status eq 5 and (to_days(now())-to_days(o.completion_time)) l 31 order=o.completion_time desc id=$quer page=1}
{query:name=user_group as ug join=left join member as m on m.group_id eq ug.id fields=group_name where=m.user_id eq $item[user_id] item=$va}
{$va['group_name']}
{/query}
{query:name=refer as r join=left join user as u on r.user_id eq u.id fields=u.username,u.head_ico,r.user_id,r.time as rtime,r.question,r.reply_time,r.answer where=r.goods_id eq $id order=r.time desc id=$ref page=1}
{$item['username']}
{query:name=user_group as ug join=left join member as m on m.group_id eq ug.id fields=group_name where=m.user_id eq $item[user_id] item=$va}
{if:$va['group_name']}
{query:name=discussion as d join=left join user as u on d.user_id eq u.id fields=u.username,d.user_id,d.time as rtime,d.contents where=d.goods_id eq $id order=d.time desc id=$disp page=1}
{query:name=user_group as ug join=left join member as m on m.group_id eq ug.id fields=group_name where=m.user_id eq $item[user_id] item=$va}
{if:$va['group_name']}{$va['group_name']}:{/if}
{/query}
{$item['username']}
({$it['group_name']})
{/if} {/query} {/query}{set:$wid = 14*$item['point']}
评分:{$item['time']}
评价:{$item['contents']}
{/query} {$quer_com->getPageBar("javascript:void(0);",'onclick="comment_ajax([page])"')}