How to paginate and sort results in Laravel?

Question

I need to paginate the results and sort them using sortBy(), without losing the pagination links. I also need to use a resource to return the results.

$sorted = Model::paginate(10)->sortBy('name');

$results = \App\Http\Resources\MyResource::collection($sorted);

Doing this breaks the pagination links (I get only the data part).

$paginated = Model::paginate(10);

$results = \App\Http\Resources\MyResource::collection($paginated);

return $results->sortBy('name');

This also doesn't work. Any ideas?

Answer 1

Using the getCollection() and setCollection() method in the paginator class, You can update the pagination result without losing the meta data.

$result = Post::orderBy('another_key')->paginate();
$sortedResult = $result->getCollection()->sortBy('key_name')->values();
$result->setCollection($sortedResult);

return $result;