Yii2 - 多次使用dataProvider进行不同的排序

Question

So I have a dataprovider which is created in a controller like this:

$modelSearch = new SearchModel();
$data_provider = $modelSearch->search(Yii::$app->request->queryParams); // returns the data provider

Then I use the $data_provider in a view like this:

GridView::widget([
    'dataProvider' => $data_provider,
    'export'       => false,
    'columns'      => [
        ...
    ],
...

But now I'd like to use the same data from the $data_provider but without pagination and other sorting specifications.

Tried this but doesn't work:

$data_provider->sort = ['defaultOrder'=> ['column_a' => SORT_ASC, 'column_b' => SORT_DESC]]
$data_provider->pagination = false;

I think that's because the data is already retrieved with the ->search() method. Do I need to create a whole new search model class? just to get a different sorting?

Thanks in advance!

Answer 1

Before I asked the question I didn't know the dataProvider already retrieved the data on creation. So altering properties of the dataProvider doesn't do another search, it does different sorting but with the same data it already retrieved.

Answer: I ended up making a new method in the searchModel class like this:

public function searchByCreatedAt() {
    $query = Model::find()->orderBy(['created_at' => SORT_ASC]);

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

    ...
}