<?php
require_once("dbcontroller.php");
$db_handle = new DBController();

$query ="
SELECT 
	t.*,
	IF (r.`rating` IS NULL, 0 , r.`rating`) AS `rating`,
	(SELECT COUNT(id) FROM `rating` WHERE tutorial_id = t.id GROUP BY tutorial_id) AS `count`,
	(SELECT SUMM(rating) FROM `rating` WHERE tutorial_id = t.id GROUP BY tutorial_id) AS `summa`,
	IF (r.`count`= 0, 0 , `summa`/`count`) AS `average`
FROM 
	`tutorial` AS t
LEFT JOIN
	`rating` AS r ON r.tutorial_id = t.id AND r.user_id = ".(int)$Info['id']."
";
$result = $db_handle->runQuery($query);
if(count($result)) {
	foreach ($result as $value) {
	 
		$stars = '';
		for($i=1;$i<=5;$i++) {
			$selected = (!empty($value["rating"]) && $i<=$value["rating"]) ? 'class="selected"' : '';
			$stars .= '<li '.$selected.' onmouseover=\'highlightStar(this,'.$value["id"].');\' onmouseout=\'removeHighlight('.$value["id"].');\' onClick=\'addRating(this,'.echo $value["id"].');\'>*</li>'; 
		}
		
		$rating = '';
		if (!empty($value["count"]))
			$rating = '	
			<div>
				Проголосовало : <b>'.$value["count"].'</b><br>
				Всего : <b>'.$value["summa"].'</b> голосов<br>
				Среднее : <b>'.$value["average"].'</b>
			</div>
			';
		
		echo '
		<tr>
			<td valign="top">
				<div class="feed_title">'.$value["title"].'</div>
				<div id="tutorial-'.$value["id"].'>
					<input type="hidden" name="rating" id="rating" value="'.$value["rating"].'">
					<ul onMouseOut="resetRating('.$value["id"].')">'.$stars.'<ul>
				</div>
				'.$rating.'
				<div>'.$value["description"].'</div>
			</td>
		</tr>
		';
	}
}