/** * 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(['like', '_id', $this->_id])->andFilterWhere(['like', 'user_id', $this->user_id])->andFilterWhere(['like', 'post_id', $this->post_id])->andFilterWhere(['like', 'comment', $this->comment])->andFilterWhere(['like', 'status', $this->status])->andFilterWhere(['like', 'created_at', $this->created_at]); return $dataProvider; }
/** * 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, 'waktu' => $this->waktu, 'post_id' => $this->post_id]); $query->andFilterWhere(['like', 'nama', $this->nama])->andFilterWhere(['like', 'isi', $this->isi]); return $dataProvider; }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Comment::find(); // add conditions that should always apply here $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; } // grid filtering conditions $query->andFilterWhere(['id' => $this->id, 'user_id' => $this->user_id, 'created_at' => $this->created_at]); $query->andFilterWhere(['like', 'text', $this->text]); return $dataProvider; }
/** * Displays a single Post model. * @param integer $id * @return mixed */ public function actionView($id) { Yii::$app->session['post_id'] = $id; $querykomen = Comment::find()->where(['post_id' => $id]); $hitungkomen = clone $querykomen; $page = new Pagination(['totalCount' => $hitungkomen->count()]); $komen = $querykomen->offset($page->offset)->limit($page->limit)->all(); $namaKomen = ""; foreach ($komen as $komens) { $namaKomen = $komens->nama; } $nama = $this->findModel($id)->nama; $usr = new \common\models\User(); $fotoPost = $usr->find()->where(['nama' => $nama])->all(); $fotoKomen = $usr->find()->where(['nama' => $namaKomen])->all(); return $this->render('view', ['model' => $this->findModel($id), 'komen' => $komen, 'fotoPost' => $fotoPost, 'fotoKomen' => $fotoKomen, 'page' => $page]); }
/** * Displays a single Post model. * @param integer $id * @return mixed */ public function actionView($id) { $model = Post::find()->where(['id' => $id])->one(); $model->views++; $model->save(); $com = Comment::find()->all(); Yii::$app->view->registerMetaTag(['name' => 'description', 'content' => $model->description]); Yii::$app->view->registerMetaTag(['name' => 'keywords', 'content' => $model->seo_keywords]); $model_com = new Comment(); if ($model_com->load(Yii::$app->request->post()) && $model_com->save()) { //return $this->redirect(['view', 'id' => $model->id]); } else { /*return $this->render('create', [ 'model' => $model, ]);*/ } return $this->render('view', ['model' => $this->findModel($id), 'com' => $com, 'model_com' => $model_com]); }
/** * Displays page where one can edit comment chosen by id * @param $id * @return string */ public function actionEdit($id) { $id = Yii::$app->request->get('id'); // Checking if line with this id exists $check_id = Comment::find()->select(['comment_writer'])->where(['comment_id' => $id])->one(); if ($check_id != null) { $comment = new Comment(); $comment_to_update = $comment->findModel($id); $commentForm = new CommentUpdateForm($id, $comment_to_update); if ($commentForm->load(Yii::$app->request->post()) && $commentForm->updateComment($id)) { Yii::$app->session->setFlash('messageUpdated'); $this->redirect(Yii::$app->getUrlManager()->createUrl('comment/view')); } else { return $this->render('edit', ['commentForm' => $commentForm]); } } else { $this->redirect(Yii::$app->getUrlManager()->createUrl('comment/view')); } }
/** * Gets model to further update * @param $id * @return array|null|ActiveRecord */ public function findModel($id) { return $comment = Comment::find()->where(['comment_id' => $id])->asArray()->one(); }
public function findByIdCom($orderDetailId) { $comment = Comment::find()->where(['typeId' => $orderDetailId])->one(); if (!$comment) { return false; } return $comment; }
/** * @inheritdoc */ public function getAllComment() { $comments = Comment::find(); return $comments; }