예제 #1
0
    /**
     * Creates data provider instance with search query applied
     *
     * @param array $params
     *
     * @return ActiveDataProvider
     */
    public function search($params)
    {
        $query = MigratedAlumni::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([
            'id' => $this->id,
            'migalu_year_graduated' => $this->migalu_year_graduated,
        ]);

        $query->andFilterWhere(['like', 'migalu_id', $this->migalu_id])
            ->andFilterWhere(['like', 'migalu_lastname', $this->migalu_lastname])
            ->andFilterWhere(['like', 'migalu_firstname', $this->migalu_firstname])
            ->andFilterWhere(['like', 'migalu_midinit', $this->migalu_midinit])
            ->andFilterWhere(['like', 'migalu_address', $this->migalu_address])
            ->andFilterWhere(['like', 'migalu_gender', $this->migalu_gender])
            ->andFilterWhere(['like', 'migalu_school', $this->migalu_school])
            ->andFilterWhere(['like', 'migalu_course', $this->migalu_course])
            ->andFilterWhere(['like', 'migalu_email', $this->migalu_email])
            ->andFilterWhere(['like', 'migalu_contactno', $this->migalu_contactno])
            ->andFilterWhere(['like', 'migalu_remarks', $this->migalu_remarks])
            ->andFilterWhere(['like', 'migalu_area', $this->migalu_area])
            ->andFilterWhere(['like', 'migalu_office_local_no', $this->migalu_office_local_no])
            ->andFilterWhere(['like', 'migalu_status', $this->migalu_status])
            ->andFilterWhere(['like', 'migalu_cur_work', $this->migalu_cur_work])
            ->andFilterWhere(['like', 'migalu_prev_work', $this->migalu_prev_work])
            ->andFilterWhere(['like', 'migalu_achievements', $this->migalu_achievements])
            ->andFilterWhere(['like', 'migalu_company', $this->migalu_company])
            ->andFilterWhere(['like', 'migalu_legends', $this->migalu_legends]);

        return $dataProvider;
    }