Myujth

I have two different querys that I merge to return a collection

$combinados = $histMe->merge($hist)->sortByDesc('created_at');

And I return them this way:

$final = $combinados->all();

But this prints all the collection, how can I paginate this? The paginate() laravel method doesn't work with collections. And how can I controll it from the view?

Thanks!

You can use this code that I wrote a long time ago:

You must use Length aware paginator:

use IlluminatePaginationLengthAwarePaginator;


public function paginate($items, $perPage,$setDefaultOption = true, $options = )
 
 if($setDefaultOption)
 $options = ['path' => request()->url(), 'query' => request()->query()];
 
 $page = Input::get('page', 1); // Get the current page or default to 1


 $items = $items instanceof Collection ? $items : Collection::make($items);

 return new LengthAwarePaginator($items->forPage($page, $perPage), $items->count(), $perPage, $page, $options);
 

The api has changed slightly in newer versions. To paginate a collection you now need to use forPage.

The method forPage takes two parameters:

forPage(int $page, int $perPage)

So you can do something like this in your controller:

...
public function index(Request $request)

 $combinados = $histMe->merge($hist)->sortByDesc('created_at');

 $combinados->forPage($request->get('page'), 25);

...