/**
* 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]);
}
