public function actionAddComment() { if (\Yii::$app->request->isAjax) { $model = new Comment(); if (\Yii::$app->user->isGuest) { $model->scenario = 'isGuest'; } $data = ['error' => true]; if ($model->load(\Yii::$app->request->post())) { $parentID = \Yii::$app->request->post('parent_id'); $root = $model->makeRootIfNotExist(); if (!$parentID) { $model->appendTo($root); } else { $parent = Comment::find()->where(['id' => $parentID])->one(); $model->appendTo($parent); } $articleModel = Article::findOne($model->model_id); $data = ['replaces' => [['what' => '#comments', 'data' => $this->renderAjax('@app/themes/basic/modules/article/views/default/_comments', ['model' => $articleModel])]]]; } return Json::encode($data); } else { throw new NotFoundHttpException(\Yii::t('app', 'Page not found')); } }
/** * * @param int $data * @return \yii\data\ActiveDataProvider */ public static function findComments($data = array()) { if (!isset($data['limit'])) { $data['limit'] = 10; } $model = new Comment(); $dataProvider = new ActiveDataProvider(['query' => $model->find()->Where('is_public=:isp and top_id=0 and c_type="article" ', [':isp' => $data['is_public']])->orderBy(" id desc ")->limit($data['limit']), 'pagination' => ['pagesize' => $data['limit']]]); return $dataProvider; }
public function actionComment($id) { $model = new Comment(); $model->load(Yii::$app->request->post()); $model->article_id = $id; if ($model->validate()) { $model->save(); Yii::$app->session->setFlash("success", "Ок"); } $this->redirect(["article/view", "id" => $id]); }
public function actionView($slug) { $commentForm = new Comment(); if ($commentForm->load(Yii::$app->request->post())) { if ($commentForm->save()) { Yii::$app->session->setFlash('success', '评论发表成功'); } else { Yii::$app->session->setFlash('error', '评论发表失败'); } } return $this->render('view', ['article' => Page::getInstance()->getBySlug($slug), 'commentForm' => $commentForm]); }
/** * Displays homepage. * * @return mixed */ public function actionIndex() { $model = new Comment(); if ($model->load(Yii::$app->request->post())) { $model->is_active = 0; $model->created_at = date('Y-m-d H:i:s'); $model->updated_at = date('Y-m-d H:i:s'); $model->save(); Yii::$app->session->setFlash('success', 'Thank you! Your comment has been added successfully. It will be available after moderation ;)'); return $this->redirect('/'); } return $this->render('comments', ['model' => $model]); }
public function actionAddComment() { $productId = Yii::$app->request->post('productId'); $rank = Yii::$app->request->post('rank'); $content = Yii::$app->request->post('content'); $comment = new Comment(); $comment->attributes = ['product_id' => $productId, 'user_id' => Yii::$app->user->identity->id, 'rank' => $rank, 'content' => $content]; if ($comment->save(true)) { return ['status' => true, 'message' => '成功']; } else { return ['status' => false, 'message' => '失败: ' . Html::errorSummary($comment)]; } }
/** * 保存商品 */ public function save() { $newComent = new Comment(); $newComent->setAttributes($this->attributes); $newComent->setAttribute('c_type', 'article'); $newComent->setAttribute("c_addtime", date('Y-m-d H:i:s')); if ($newComent->save()) { $logisct_id = \Yii::$app->db->lastInsertID; return $logisct_id; } else { return FALSE; } }
/** * Displays a single Post model. * @param integer $id * @return mixed */ public function actionView($id) { $list_comment = new ActiveDataProvider(['query' => Comment::find()->where(['post_id' => $id, 'status' => 1])]); $model_comment = new Comment(); if ($model_comment->load(Yii::$app->request->post())) { $model_comment->post_id = $id; $model_comment->status = 0; if ($model_comment->save()) { Yii::$app->session->setFlash('success', 'Ваш комментарий был отправлен администраторам сайта и будет опубликован после проверки..'); } else { Yii::$app->session->setFlash('error', 'Ваш комментарий не был отправлен по техническим причинам. Попробуйте ещё раз.'); } } return $this->render('view', ['model' => $this->findModel($id), 'list_comment' => $list_comment, 'model_comment' => $model_comment]); }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Comment::find(); $commentTable = Comment::tableName(); $user = Yii::$app->getModule("user")->model("User"); // set up query with relation to `user.username` $userTable = $user::tableName(); $query->joinWith(['user' => function ($query) use($userTable) { $query->from(['user' => $userTable]); }]); $profileTable = \common\modules\user\models\Profile::tableName(); $query->joinWith(['profile' => function ($query) use($profileTable) { $query->from(['profile' => $profileTable]); }]); $dataProvider = new ActiveDataProvider(['query' => $query]); // enable sorting for the related columns $addSortAttributes = ["user.username", 'profile.full_name']; foreach ($addSortAttributes as $addSortAttribute) { $dataProvider->sort->attributes[$addSortAttribute] = ['asc' => [$addSortAttribute => SORT_ASC], 'desc' => [$addSortAttribute => SORT_DESC]]; } if (!($this->load($params) && $this->validate())) { return $dataProvider; } $createdTime = strtotime($this->created_at); $startDay = date("Y-m-d 00:00:00", $createdTime); $endDay = date("Y-m-d 00:00:00", $createdTime + 60 * 60 * 24); if ($this->created_at) { $query->andFilterWhere(['between', 'created_at', $startDay, $endDay]); } $query->andFilterWhere(["{$commentTable}.id" => $this->id, "{$commentTable}.user_id" => $this->user_id, 'parent_id' => $this->parent_id]); $query->andFilterWhere(['like', 'content', $this->content])->andFilterWhere(['like', 'user.username', $this->getAttribute('user.username')])->andFilterWhere(['like', 'profile.full_name', $this->getAttribute('profile.full_name')]); return $dataProvider; }
public function run() { $commentModel = new Comment(); if (\Yii::$app->user->isGuest) { $commentModel->scenario = 'isGuest'; } $commentModel->model_name = $this->model->formName(); $commentModel->model_id = $this->model->id; $root = $commentModel->getRoot(); if ($root) { $commentModels = $root->getChildren(); } else { $commentModels = []; } return $this->render('default', ['commentModel' => $commentModel, 'model' => $this->model, 'commentModels' => $commentModels]); }
/** * 显示一个文章的信息 * @return type */ public function actionArticle() { $id = \Yii::$app->request->get('id'); $idTrue = true; if (empty($id)) { $idTrue = FALSE; } if ($idTrue) { $articleInfo = Comment::find()->where('id=:id', [':id' => $id])->one(); if (!$articleInfo) { $idTrue = FALSE; } else { if ($articleInfo->is_public === 0 && \Yii::$app->user->getId() !== $articleInfo->to_user_id && \Yii::$app->user->getId() !== $articleInfo->user_id) { $idTrue = FALSE; } } } if (!$idTrue) { $error = '当前评论不存在或者已经被禁止显示'; $notices = array('type' => 2, 'msgtitle' => '错误的访问', 'message' => $error, 'backurl' => Url::toRoute('/say/index'), 'backtitle' => '返回'); Yii::$app->getSession()->setFlash('wechat_fail', array($notices)); $this->redirect(Url::toRoute('/public/notices')); } return $this->render('article', ['articleInfo' => $articleInfo]); }
public function actionIndex() { $page = $this->helpGquery('page', 1); $size = 9; $offset = ($page - 1) * $size; $comment = new Comment(); $values = $comment->getComments(null, $offset, $size, null); $comments = $values['list']; array_walk($comments, function (&$value, $key) { $value['addtime'] = date('Y-m-d H:i', $value['addtime']); }); $total = $values['total']; $pageHTML = $this->getPageHTML($page, $size, $total); $params = ['comments' => $comments, 'pageHTML' => $pageHTML]; return $this->render('index', $params); }
/** * Возвращает комментарий. * @param int $id идентификатор комментария * @throws NotFoundHttpException * @return Comment */ public function getComment($id) { if (($model = Comment::findOne($id)) !== null && $model->isPublished()) { return $model; } else { throw new NotFoundHttpException('The requested post does not exist.'); } }
public function actionIndex($id) { $user = User::findIdentity($id); $comments = Comment::getRecentComments(); $sidebarCategories = Category::getSidebarCategories(); $tags = Tag::getTagList(); return $this->render('index', ['user' => $user, 'comments' => $comments, 'sidebarCategories' => $sidebarCategories, 'tags' => $tags]); }
public function actionView($slug) { $post = Post::findOne(['slug' => $slug]); $comment = new Comment(); $comment->name = ''; $comment->email = ''; $comment->body = ''; if ($comment->load(Yii::$app->request->post())) { $comment->status = 0; if ($comment->save()) { Yii::$app->session->setFlash('success', ['type' => 'success', 'duration' => 12000, 'icon' => 'fa fa-chat', 'message' => 'You\'re comment successfully stored and will shown after approval.', 'title' => 'Saving Comment']); } else { Yii::$app->session->setFlash('error', ['type' => 'danger', 'duration' => 12000, 'icon' => 'fa fa-chat', 'message' => 'Sorry but we couldn\'t store your comment.', 'title' => 'Saving Comment']); } } return $this->render('view', ['post' => $post, 'comment' => $comment]); }
/** * Finds the Comment model based on its primary key value. * If the model is not found, a 404 HTTP exception will be thrown. * @param integer $id * @return Comment the loaded model * @throws NotFoundHttpException if the model cannot be found */ protected function findModel($id) { if (($model = Comment::findOne($id)) !== null) { return $model; } else { throw new NotFoundHttpException('The requested page does not exist.'); } }
/** * @return array * Добавление комментария */ public function actionAddComment() { if (\Yii::$app->request->isAjax) { \Yii::$app->response->format = Response::FORMAT_JSON; $model = new Comment(); $model->user_id = \Yii::$app->user->identity->id; $model->event_id = $_POST['event_id']; $model->message = $_POST['message']; $model->created = time(); if ($model->save()) { if (isset($_POST['notify_all']) && $_POST['notify_all'] == 'true') { EventForm::commenatAllNotification($_POST['event_id'], $_POST['message']); } return ['item' => $model, 'user' => $model->user]; } } }
public function beforeSave($insert) { if ($this->checked != 1) { $this->checked = 1; } return parent::beforeSave($insert); // TODO: Change the autogenerated stub }
public function save() { $comment = Comment::findOne($this->commentID); $comment->setAttributes(['author' => $this->author, 'text' => $this->text, 'email' => $this->email, 'published' => $this->published, 'deleted' => $this->deleted]); if ($comment->save(false)) { \Yii::$app->session->setFlash('saved', 'Комментарий сохранён!'); } else { \Yii::$app->session->setFlash('error', 'Комментарий не сохранён!'); } }
/** * Displays a single Suggestion model. * @param integer $id * @return mixed */ public function actionView($id) { $comment = new Comment(); if (Yii::$app->request->post()) { $comment->sugg_id = $id; $comment->part_id = strval(Yii::$app->user->id); $comment->content = Yii::$app->request->post('Comment')['content']; if ($comment->save()) { Yii::$app->session->setFlash('success', '评论成功'); return $this->redirect(['view', 'id' => $id]); } else { error_log(print_r($comment->errors, true)); Yii::$app->session->setFlash('error', '评论失败'); return $this->redirect(['view', 'id' => $id]); } } $commentsProvider = new ActiveDataProvider(['query' => Comment::find()->where(['sugg_id' => $id])->orderBy('created_at DESC'), 'pagination' => ['pageSize' => 20]]); return $this->render('view', ['model' => $this->findModel($id), 'comment' => $comment, 'commentsProvider' => $commentsProvider]); }
/** * Displays homepage. * * @return mixed */ public function actionIndex() { $query = Page::find()->where(['live' => 1]); $pagination = new Pagination(['defaultPageSize' => 2, 'totalCount' => $query->count()]); $pages = $query->offset($pagination->offset)->limit($pagination->limit)->all(); $comments = Comment::getRecentComments(); $sidebarCategories = Category::getSidebarCategories(); $tags = Tag::getTagList(); return $this->render('index', ['pages' => $pages, 'pagination' => $pagination, 'comments' => $comments, 'sidebarCategories' => $sidebarCategories, 'tags' => $tags]); }
public function actionDetail($id) { $postModel = new Comment(); if ($postModel->load(Yii::$app->request->post())) { $postModel->status = Comment::STATUS_INACTIVE; $postModel->post_id = $id; if ($postModel->save()) { $this->added = 1; } } $tags = Tag::findTagWeights(); $cateModel = new Cate(); $cateDataProvider = $cateModel->getCates(); $postData = new Post(); $postDataProvider = $postData->findRecentPosts(); $commentModel = new Comment(); $commentDataProvider = $commentModel->findRecentComments(); return $this->render('detail', ['tags' => $tags, 'added' => $this->added, 'postModel' => $postModel, 'model' => $this->findModel($id), 'postDataProvider' => $postDataProvider, 'cateDataProvider' => $cateDataProvider, 'commentDataProvider' => $commentDataProvider]); }
/** * @inheritdoc */ public function afterDelete() { Tagging::deleteAll(['taggable_type' => Tagging::TAGGABLE_ALBUM, 'taggable_id' => $this->id]); Relation::deleteAll(['relationable_type' => Relation::RELATIONABLE_ALBUM, 'relationable_id' => $this->id]); Comment::deleteAll(['commentable_type' => Comment::COMMENTABLE_ALBUM, 'commentable_id' => $this->id]); CommentCount::deleteAll(['commentable_type' => CommentCount::COMMENTABLE_ALBUM, 'commentable_id' => $this->id]); $assets = Asset::find()->where(['assetable_type' => Asset::ASSETABLE_ALBUM, 'assetable_id' => $this->id])->all(); foreach ($assets as $asset) { $asset->delete(); } }
public function run() { $query = Comment::find(); if ($this->entity == Comment::ENTITY_ITEM || $this->entity == Comment::ENTITY_EVENT || $this->entity == Comment::ENTITY_SCHOOL) { $query = $query->andWhere(['entity' => $this->entity, 'entity_id' => $this->entity_id])->orderBy('date_create DESC'); } $commentsAll = $query->all(); $commentIds = []; $comments = []; $commentsParent = []; $commentsLink = []; /** @var Comment[] $commentsAll */ foreach ($commentsAll as $comment) { if ($comment->parent_id == 0) { // Главный комментарий $commentsLink[$comment->id] = true; $commentIds[] = $comment->id; if ($comment->deleted == 0) { $comments[] = $comment; } } else { // Ответ на комментарий $commentsLink[$comment->id] = $comment->parent_id; } } foreach ($commentsAll as $comment) { if ($comment->deleted == 0) { $commentId = $comment->parent_id; while (isset($commentsLink[$commentId])) { if ($commentsLink[$commentId] === true) { break; } else { if ($commentsLink[$commentId] != $commentId) { $commentId = $commentsLink[$commentId]; } else { $commentId = null; } } } if (!empty($commentId)) { $commentsParent[$commentId][] = $comment; $commentIds[] = $comment->id; } } } $thisUser = User::thisUser(); /** @var Vote[] $voteItemsAll */ $voteItemsAll = !empty($thisUser) ? $thisUser->getVotesByEntity(Vote::ENTITY_COMMENT, $commentIds) : []; $voteItems = []; foreach ($voteItemsAll as $voteItem) { $voteItems[$voteItem->entity_id] = $voteItem; } return $this->render('commentsWidget/list', ['comments' => $comments, 'voteItems' => $voteItems, 'commentsParent' => $commentsParent, 'entity' => $this->entity, 'entity_id' => $this->entity_id, 'showDialog' => $this->showDialog]); }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Comment::find(); $query->orderBy(['created_at' => SORT_DESC]); $dataProvider = new ActiveDataProvider(['query' => $query]); if ($this->load($params) && !$this->validate()) { return $dataProvider; } $query->andFilterWhere(['id' => $this->id, 'user_id' => $this->user_id, 'product_id' => $this->product_id, 'order_id' => $this->order_id, 'star' => $this->star, 'point' => $this->point, 'up' => $this->up, 'status' => $this->status, 'created_at' => $this->created_at, 'updated_at' => $this->updated_at, 'created_by' => $this->created_by, 'updated_by' => $this->updated_by]); $query->andFilterWhere(['like', 'username', $this->username])->andFilterWhere(['like', 'content', $this->content]); return $dataProvider; }
public function actionAlarm() { $id = Yii::$app->request->post('id'); $msg = Yii::$app->request->post('msg'); $comment = Comment::findOne($id); if ($comment && !empty($msg)) { if (Alarm::addAlarm(Alarm::ENTITY_COMMENT, $comment->id, $msg)) { return json_encode(['content' => \frontend\widgets\CommentsWidget::widget(['entity' => $comment->entity, 'entity_id' => $comment->entity_id, 'showDialog' => false]), 'anchor' => $comment->id]); } else { return json_encode(['content' => '', 'anchor' => '']); } } }
public function actionDeletePost() { $selection = (array) Yii::$app->request->post('selection'); foreach ($selection as $id) { Post::deleteAll(['id' => $id]); Like::deleteAll(['post_id' => $id]); Comment::deleteAll(['post_id' => $id]); PostTag::deleteAll(['post_id' => $id]); PostNotification::deleteAll(['post_id' => $id]); PostProtected::deleteAll(['post_id' => $id]); } return $this->render('post-manage'); }
public function actionView($slug) { $commentForm = new Comment(); $article = Content::find()->where(['slug' => $slug, 'type' => Content::TYPE_ARTICLE, 'status' => Content::STATUS_ACTIVE])->with(['createdBy', 'category', 'tags'])->one(); if (empty($article)) { throw new NotFoundHttpException('没有找到相应文章。。。'); } if ($commentForm->load(Yii::$app->request->post())) { $commentForm->content_id = $article['id']; if ($commentForm->save()) { Yii::$app->session->setFlash('success', '评论发表成功'); return $this->refresh(); } else { Yii::$app->session->setFlash('error', '评论发表失败'); } } $article->updateCounters(['view_total' => 1]); $model = Comment::find()->where(['content_id' => $article['id'], 'status' => Comment::STATUS_ACTIVE]); $countModel = clone $model; $commentsPagination = new Pagination(['totalCount' => $countModel->count('id')]); $comments = $model->orderBy('created_at')->select(['id', 'ip', 'url', 'text', 'created_at', 'email', 'nickname', 'parent_id'])->asArray()->all(); return $this->render('view', ['article' => $article, 'commentForm' => $commentForm, 'comments' => $comments, 'commentsPagination' => $commentsPagination]); }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Comment::find(); $dataProvider = new ActiveDataProvider(['query' => $query]); $this->load($params); if (!$this->validate()) { // uncomment the following line if you do not want to return any records when validation fails // $query->where('0=1'); return $dataProvider; } $query->andFilterWhere(['id' => $this->id, 'status' => $this->status, 'create_time' => $this->create_time, 'post_id' => $this->post_id]); $query->andFilterWhere(['like', 'content', $this->content])->andFilterWhere(['like', 'user_id', $this->user_id])->andFilterWhere(['like', 'email', $this->email])->andFilterWhere(['like', 'url', $this->url]); return $dataProvider; }
public function up() { $comments = new \yii\db\Query(); $comments = $comments->from(\Yii::$app->params['oldDb'] . '.joom_jcomments'); $commentsCount = $comments->count(); echo " > migrating comments... Almost have {$commentsCount} comments...\r\n"; echo " > prepare comments...\r\n"; $i = 0; $prepared = []; foreach ($comments->each() as $comment) { $i++; echo " > comment {$i} from {$commentsCount}... \r\n"; $commentModel = new Comment(['newsID' => $comment['object_id'], 'author' => $comment['name'], 'email' => $comment['email'], 'text' => $comment['comment'], 'date' => strtotime($comment['date']), 'isGood' => $comment['isgood'], 'isBad' => $comment['ispoor'], 'published' => $comment['published'], 'deleted' => $comment['deleted'], 'id' => $comment['id']]); $commentModel->setIp($comment['ip']); if (!empty($commentModel->ip) && mb_strlen($commentModel->author, 'utf8') < 64 && $commentModel->date > 0 && $commentModel->date < time() + 86400) { $prepared[] = $commentModel->attributes; } if (count($prepared) >= 100 || $commentsCount - $i == 0) { $this->batchInsert(Comment::tableName(), array_keys($prepared[0]), $prepared); $prepared = []; } } }