/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = KefuSelfservice::find(); $dataProvider = new ActiveDataProvider(['query' => $query]); if (!($this->load($params) && $this->validate())) { return $dataProvider; } $query->andFilterWhere(['id' => $this->id, 'category_id' => $this->category_id, 'game_server' => $this->game_server, 'user_id' => $this->user_id, 'created_at' => $this->created_at, 'updated_at' => $this->updated_at, 'status' => $this->status]); $query->andFilterWhere(['like', 'sn', $this->sn])->andFilterWhere(['like', 'game_role', $this->game_role])->andFilterWhere(['like', 'email', $this->email])->andFilterWhere(['like', 'phone', $this->phone])->andFilterWhere(['like', 'result', $this->result])->andFilterWhere(['like', 'content', $this->content]); return $dataProvider; }
public function actionSelfserviceResult() { $userId = \Yii::$app->user->getId(); if ($userId != null) { $dataProvider = new ActiveDataProvider(['query' => KefuSelfservice::find()->where(['user_id' => $userId])->orderBy('id desc'), 'pagination' => ['pageSize' => 10]]); return $this->render('selfservice-result', ['dataProvider' => $dataProvider]); } return $this->render('selfservice-result'); }