orderBy(['sort'=>SORT_ASC, 'id'=>SORT_DESC]); $dataProvider = Yii::createObject([ 'class' => ActiveDataProvider::className(), 'query' => $query, 'sort' => [ 'defaultOrder' => [ 'sort' => SORT_ASC, 'id' => SORT_DESC, ] ] ]); /** @var $dataProvider ActiveDataProvider */ $this->load($params); if (! $this->validate()) { return $dataProvider; } $query->andFilterWhere(['like', 'name', $this->name]) ->andFilterWhere(['status' => $this->status]) ->andFilterWhere(['like', 'url', $this->url]); if ($this->image == Constants::YesNo_Yes) { $query->andWhere(['<>', 'image', '']); } else { if ($this->image === '0') { $query->andWhere(['image' => '']); } } $this->trigger(SearchEvent::BEFORE_SEARCH, Yii::createObject(['class' => SearchEvent::className(), 'query'=>$query])); return $dataProvider; } }