/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = SimpelUser::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(['user_id' => $this->user_id, 'unit_id' => $this->unit_id]); $query->andFilterWhere(['like', 'username', $this->username])->andFilterWhere(['like', 'auth_key', $this->auth_key])->andFilterWhere(['like', 'password_hash', $this->password_hash])->andFilterWhere(['like', 'password_reset_token', $this->password_reset_token]); return $dataProvider; }
public function actionSearchUser($search) { $sumber = SimpelUser::find()->andWhere('(username like \'%' . $search . '%\' or unit_id like \'%' . $search . '%\')'); $dataUser = new ActiveDataProvider(['query' => $sumber, 'pagination' => ['pageSize' => 10]]); return $this->renderAjax('@backend/views/simpel-user/_search', ['dataUser' => $dataUser]); }