public function actionUserProfile() { if (!empty(Auth::getUser()['id'])) { $user = UsersModel::model()->where("`id`='" . Auth::getUser()['id'] . "'")->findRow(); $linkCards = LinkingUserProfileModel::model()->where("`type`='1' AND `user_id`='" . Auth::getUser()['id'] . "'")->findAll(); $LinkGifts = LinkingUserProfileModel::model()->where("`type`='2' AND `user_id`=" . Auth::getUser()['id'])->findAll(); $rating = $this->declension($user->experience, array("очко", "очка", "очков")); $viewed_series = UserSeriesViewedModel::model()->where("user_id=" . Auth::getUser()['id'])->findAll(); $userId = Auth::getUser()['id']; $favors = FavoritesModel::model()->where("`user_id`='{$userId}'")->findAll(); $in = "("; foreach ($favors as $favor) { $in .= "'{$favor->video_id}'" . ", "; } $in = substr($in, 0, -2); $in .= ")"; if ($in == ")") { $movies = array(); } else { $movies_count = MoviesModel::model()->where("`id` IN {$in}")->countAll(); } $dicts = DictModel::model()->where("`user_id`='" . Auth::getUser()['id'] . "'")->countAll(); $this->view("profile/user_profile/show", array("user" => $user, "movies_count" => $movies_count, "dicts" => $dicts, "viewed_series" => $viewed_series, "gifts" => $LinkGifts, "cards" => $linkCards, "rating" => $rating), false); } else { $error = Lang::get("not_registered"); $this->view("profile/user_profile/show", array("not_registered" => $error), false); } }
private function getUserPrisent($userId) { $links = LinkingUserProfileModel::model()->where(" `type` = '2' AND `user_id` = '{$userId}' ")->findAll(); $num = 0; $in = ""; foreach ($links as $link) { if ($num == 0) { $in .= " AND id NOT IN ("; } if ($num != 0) { $in .= ","; } $in .= $link->idPresent; $num++; } if ($num > 0) { $in .= ")"; } return $in; }