/** * Creates data provider instance with search query applied * @return ActiveDataProvider */ public function search($params) { $query = Setting::find(); //$query->andFilterWhere(['language' => Yii::$app->language]); $dataProvider = new ActiveDataProvider(['query' => $query, 'pagination' => ['pageSize' => 50]]); // Join the entity model as a relation $query->joinWith(['category']); // A normal user is only allowed to view the 'user-defined' settings if (!Yii::$app->user->can('Superadmin')) { $query->andFilterWhere(['type' => Setting::TYPE_USER_DEFINED]); } // enable sorting for the label attribute $dataProvider->sort->attributes['label'] = ['asc' => ['label' => SORT_ASC], 'desc' => ['label' => SORT_DESC]]; // enable sorting for the related column $dataProvider->sort->attributes['category.name'] = ['asc' => ['settings_categories.name' => SORT_ASC], 'desc' => ['settings_categories.name' => SORT_DESC]]; $dataProvider->sort->defaultOrder = ['category.name' => SORT_ASC, 'label' => SORT_ASC]; if (!($this->load($params) && $this->validate())) { return $dataProvider; } $query->andFilterWhere(['key' => $this->key]); $query->andFilterWhere(['like', 'label', $this->label])->andFilterWhere(['LIKE', 'settings_categories.name', $this->getAttribute('category.name')]); return $dataProvider; }