广州传奇网络

地址:广州市天河区东圃大马路富华楼C座

电话:13808825895

邮箱:gz020wbs@163.com

QQ:1564443073

网址:http://www.020wbs.com/

首页 > 二次开发Ecshop二次开发 > Ecshop中根据评论等级不同计算出百分比!

二次开发Ecshop二次开发

二次开发Ecshop二次开发

Ecshop中根据评论等级不同计算出百分比!

 

 

说一下原理:
后台:计算各个类型的评论总和和全部评论。
后台函数代码:
/*统计评论*/
function getcccount($goods_id){
$sql="SELECT count(id_value) FROM ". $GLOBALS['ecs']->table('comment') ." WHERE id_value = $goods_id AND comment_rank!=0  and select_type=0 and parent_id=0";
$count = $GLOBALS['db']->getOne($sql);
if(empty($count)){
return '没有评论';
}
else
{
$sql="SELECT count(id_value) FROM ". $GLOBALS['ecs']->table('comment') ." WHERE id_value = $goods_id AND comment_rank =5 and select_type=0 and parent_id=0";
$count5 = $GLOBALS['db']->getOne($sql);

$sql="SELECT count(id_value) FROM ". $GLOBALS['ecs']->table('comment') ." WHERE id_value = $goods_id AND comment_rank =1 and select_type=0 and parent_id=0";

$count1 = $GLOBALS['db']->getOne($sql);

$sql="SELECT count(id_value) FROM ". $GLOBALS['ecs']->table('comment') ." WHERE id_value = $goods_id  and select_type=0 and parent_id=0 AND comment_rank BETWEEN 2 AND 4";
$count3 = $GLOBALS['db']->getOne($sql);

$hb =percent($count5,$count);
$zb =percent( $count3,$count);
$cb =percent($count1,$count);
$arr=array();
$arr['all']=$count;   //统计全部评论
$arr['hao']=$count5;  //统计好评个数
$arr['zhong']=$count3;  //统计中评个数
$arr['cha']=$count1 ;  //统计差评个数
$arr['hb']=$hb; //好评百分比
$arr['zb']=$zb; //中评百分比
$arr['cb']=$cb; //差评百分比
return $arr;
}
}

/*百分比计算函数
*$p 被除数
*$t 总个数
*/
function percent($p,$t){
return sprintf('%.2f%%',$p/$t*100);
}