[Yii2] ActiveDataProvider

public function search($params)
{
$query = Categorie::find()
->leftJoin("categorie as master","master.id = categorie.id_master")
->where("categorie.id_master > 0")
;
$dataProvider = new ActiveDataProvider([
'query' => $query,
'pagination' => [
'pageSize' => 30
],
'sort' => [
'attributes' => [
'id_master' => [
'asc' => [
'master.ordine' => SORT_ASC,
'master.nome' => SORT_ASC,
'categorie.ordine' => SORT_ASC,
'categorie.nome' => SORT_ASC,
],
'desc'=> [
'master.ordine' => SORT_DESC,
'master.nome' => SORT_DESC,
'categorie.ordine' => SORT_ASC,
'categorie.nome' => SORT_ASC,
],
]
],
'defaultOrder' => ['id_master'=>SORT_ASC]
]
]);
$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([
'categorie.id' => $this->id,
'categorie.id_master' => $this->id_master,
'categorie.ordine' => $this->ordine,
'categorie.evidenza' => $this->evidenza,
]);
$query->andFilterWhere(['like', 'categorie.nome', $this->nome])
->andFilterWhere(['like', 'categorie.slug', $this->slug])
->andFilterWhere(['like', 'categorie.stato', $this->stato]);
return $dataProvider;
}