public static function getRating($id)
{
$rating_sum = RatingsModel::model()->select("sum(`rating`) as `sum_rating`")->where("`movie_id` = '{$id}'")->findAll();
$rating_count = RatingsModel::getRatingCount($id);
if ($rating_count == 0) {
$rating = 0;
} else {
$rating = round($rating_sum[0]->sum_rating / $rating_count, 2);
}
return $rating;
}
public function addMovieRatingItem()
{
$model = new RatingsModel();
$model->movie_id = $_POST['movie_id'];
$model->rating = $_POST['rating'];
$model->user_id = $_SESSION['user']['id'];
$model->user_ip = $_SERVER['REMOTE_ADDR'];
$issetItem = RatingsModel::model()->where("`user_id` = '{$model->user_id}' AND `movie_id`='{$model->movie_id}'")->findRow();
if (empty($issetItem->id) && $model->user_id != "") {
$model->save();
$rating = RatingsModel::getRating($_POST['movie_id']);
$rating_count = RatingsModel::getRatingCount($_POST['movie_id']);
echo $rating . '{~}' . $rating_count;
} else {
echo 'error';
}
}
public function actionSerial()
{
$id = 12;
$rating = RatingsModel::getRating($id);
$rating_count = RatingsModel::getRatingCount($id);
$this->view("serial", array("rating" => $rating, "movie_id" => $id, "rating_count" => $rating_count), false);
}
