Yii2 Model Search

Yii2-model-serach

    public function search($params)
    {
        $query = ShippingRulesModel::find();

        $query->joinWith(['country']);

        $dataProvider = new ActiveDataProvider([
            'query' => $query,
        ]);

        $this->load($params);

        if (!$this->validate()) {
            return $dataProvider;
        }

        $query->andFilterWhere([
            'id'           => $this->id,
            'flat_rate'    => $this->flat_rate,
            'country.data' => $this->country_id,
            'position'     => $this->position,
            'active'       => $this->active,
        ]);

        $dataProvider->sort->attributes['country'] = [
            'asc'  => ['country.data' => SORT_ASC],
            'desc' => ['country.data' => SORT_DESC],
        ];

        $query->andFilterWhere(['like', 'service_name', $this->service_name]);

        return $dataProvider;
    }