common/models/UserSearch.php
/**
     * Creates data provider instance with search query applied
     *
     * @param array $params
     *
     * @return ActiveDataProvider
     */
Creates data provider instance with search query applied
@param array $params


Creates data provider instance with search query applied @param array $params
public function search($params)
    {
        $query = User::find();
        $dataProvider = new ActiveDataProvider([
            'query' => $query,
        ]);
        $this->load($params);
        if (!$this->validate()) {
            return $dataProvider;
        }
        $query->andFilterWhere([
            'id' => $this->id,
            'status' => $this->status,
            'created_at' => $this->created_at,
            'updated_at' => $this->updated_at,
        ]);
        $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])
            ->andFilterWhere(['like', 'email', $this->email])
            ->andFilterWhere(['like', 'verification_token', $this->verification_token])
            ->andFilterWhere([ 'phone_number'=>$this->phone_number]);
        return $dataProvider;
    }
public function search ( $ params ) { $ query = User :: find ( ) ; $ dataProvider = new ActiveDataProvider ( [ 'query' => $ query , ] ) ; $ this -> load ( $ params ) ; if ( ! $ this -> validate ( ) ) { return $ dataProvider ; } $ query -> andFilterWhere ( [ 'id' => $ this -> id , 'status' => $ this -> status , 'created_at' => $ this -> created_at , 'updated_at' => $ this -> updated_at , ] ) ; $ 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 ] ) -> andFilterWhere ( [ 'like' , 'email' , $ this -> email ] ) -> andFilterWhere ( [ 'like' , 'verification_token' , $ this -> verification_token ] ) -> andFilterWhere ( [ 'phone_number' => $ this -> phone_number ] ) ; return $ dataProvider ; }
Creates data provider instance with search query applied
 @param array $params
Creates data provider instance with search query applied @param array $params
// add conditions that should always apply here // uncomment the following line if you do not want to return any records when validation fails //  $query->where('0=1'); // grid filtering conditions