상품의 전체 별 평점을 가져온다. > 정보공유

<?php
// 영카트 상품의 전체 별 평점 을 가져옴.
$sql = " select COUNT(*) as cnt, 
			AVG(is_score) as avg,
			COUNT(CASE WHEN is_score=1 THEN 1 END) as score1, 
			COUNT(CASE WHEN is_score=2 THEN 1 END) as score2, 
			COUNT(CASE WHEN is_score=3 THEN 1 END) as score3, 
			COUNT(CASE WHEN is_score=4 THEN 1 END) as score4, 
			COUNT(CASE WHEN is_score=5 THEN 1 END) as score5 
		from {$g5['g5_shop_item_use_table']} where it_id = '{$item['it_id']}' and is_confirm = '1' ";
$row = sql_fetch($sql);
$total_count = $row['cnt'];

$score1 = $row['score1'];
$score2 = $row['score2'];
$score3 = $row['score3'];
$score4 = $row['score4'];
$score5 = $row['score5'];

$score1_percent = ($total_count > 0) ? number_format($score1 / $total_count * 100) : 0;
$score2_percent = ($total_count > 0) ? number_format($score2 / $total_count * 100) : 0;
$score3_percent = ($total_count > 0) ? number_format($score3 / $total_count * 100) : 0;
$score4_percent = ($total_count > 0) ? number_format($score4 / $total_count * 100) : 0;
$score5_percent = ($total_count > 0) ? number_format($score5 / $total_count * 100) : 0;
$re_count = $total_count - $score1 - $score2;
$total_percent = ($total_count > 0) ? number_format($re_count / $total_count * 100) : 0;
?>

쿼리의 결과는 아래와 같은 형태로 출력된다.