models/CustomersSearch.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 = Customers::find();
        $dataProvider = new ActiveDataProvider([
            'query' => $query,
        ]);
        $this->load($params);
        if (!$this->validate()) {
            return $dataProvider;
        }
        $query->andFilterWhere([
            'CustomerID' => $this->CustomerID,
            'DateOfBirth' => $this->DateOfBirth,
            'GenderID' => $this->GenderID,
            'CTelephone' => $this->CTelephone,
            'UserID' => $this->UserID,
            'CityID' => $this->CityID,
        ]);
        $query->andFilterWhere(['like', 'CFirstName', $this->CFirstName])
            ->andFilterWhere(['like', 'CLastName', $this->CLastName])
            ->andFilterWhere(['like', 'CEmail', $this->CEmail])
            ->andFilterWhere(['like', 'StreetAddress', $this->StreetAddress]);
        return $dataProvider;
    }
public function search ( $ params ) { $ query = Customers :: find ( ) ; $ dataProvider = new ActiveDataProvider ( [ 'query' => $ query , ] ) ; $ this -> load ( $ params ) ; if ( ! $ this -> validate ( ) ) { return $ dataProvider ; } $ query -> andFilterWhere ( [ 'CustomerID' => $ this -> CustomerID , 'DateOfBirth' => $ this -> DateOfBirth , 'GenderID' => $ this -> GenderID , 'CTelephone' => $ this -> CTelephone , 'UserID' => $ this -> UserID , 'CityID' => $ this -> CityID , ] ) ; $ query -> andFilterWhere ( [ 'like' , 'CFirstName' , $ this -> CFirstName ] ) -> andFilterWhere ( [ 'like' , 'CLastName' , $ this -> CLastName ] ) -> andFilterWhere ( [ 'like' , 'CEmail' , $ this -> CEmail ] ) -> andFilterWhere ( [ 'like' , 'StreetAddress' , $ this -> StreetAddress ] ) ; 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