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); }