public static function getComments($user_id, $type, $limit, $contentId, $contentType) { if ($contentId) { $date = (new Query())->select('date_time')->from('comments_' . $contentType)->where(['id' => $contentId])->scalar(); } if ($type == 'user') { $articles_id = false; $photos_id = false; $club_photos_id = false; } else { $articles_id = Blog::getAllArticlesIdByAuthor($user_id); $photos_id = Photo::getAllPhotosIdByAuthor($user_id); $club_photos_id = ClubPhoto::getAllClubPhotosIdByAuthor($user_id); } $comment_blog_query = CommentsBlog::getCommentsQuery($user_id, $type, $articles_id); $comment_photo_query = CommentsPhoto::getCommentsQuery($user_id, $type, $photos_id); $comment_club_query = CommentsClub::getCommentsQuery($user_id, $type, $club_photos_id); $all_comments = $comment_blog_query->union($comment_photo_query, true)->union($comment_club_query, true); $sql = (new Query())->from(['ac' => $all_comments])->limit($limit)->orderBy('comment_date_time desc'); if ($contentId) { $sql->andWhere(['<', 'comment_date_time', $date]); } $all_comments = $sql->all(); foreach ($all_comments as &$comment) { self::DateCommentsInCorrectFormat($comment); } return $all_comments; }
public function actionPhoto($photo_id) { $photo = ClubPhoto::getAllPhotoInfo($photo_id); $club_id = $photo['club_id']; $this->getClubInfo($club_id, $club, $role, $potentialMembers, $isOpen); if (!$club['club_id']) { throw new \yii\web\HttpException(404); } if (!$isOpen) { return $this->redirect("/club{$club_id}"); } View::viewPhotoClub($photo_id); $model = new CommentsClub(); $from = "comments_club"; $comments = Comments::getCommentsNew($photo_id, $from); $request = Yii::$app->request; if (!$club['is_closed_comments'] && $request->isAjax && $model->load($request->post()) && $model->validate()) { Yii::$app->response->format = Response::FORMAT_JSON; $model->date_time = date('Y-m-d H:i:s'); $model->id_user = Yii::$app->user->getId(); $model->text = htmlspecialchars($model->text); //визначення чи це простий комент чи це ре-комент $text = explode(":", $model->text); //перевіряємо чи введено коректне ім'я користувача якому дана відповідь $true_name = 0; foreach ($comments as $key) { if ($key['name'] == $text[0]) { $true_name = 1; } } if (!$true_name) { $model->answer_id = 0; } if ($model->save()) { ClubPhoto::updateComments($photo_id, 1); $latest_id = $model->id; $user = User::find()->select('avatar, name')->where(["id" => $model->id_user])->one(); echo json_encode(['text' => $model->text, 'id_user' => $model->id_user, 'name' => $user[name], 'avatar' => $user[avatar], 'id_comment' => $latest_id]); die; } else { echo 0; } } return $this->render('photo_page', ['club' => $club, 'photo' => $photo, 'comments' => $comments, 'model' => $model]); }