/**
* 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;
}
