How to paginate over two models' search results

I have two models: one for products the other one is for collections (collection of products) I want to make a search on both of them after the search completes, I concatenate the result to a single variable called items to be displayed in the view by foreach statement I have a problem with pagination as it's not supported for laravel collections I'm using livewire component

$totalItemsCollection = $collections->concat($products);

PovilasKorop

3 years ago

Level 11

One of the ways to solve this is to transform the results into identical structure and merge into one collection, from there you can call pagination methods on it.

$products = Product::where('...')->get()->map(fn($product) => [
  'id' => $product->id,
  'name' => $product->name
]);
 
$collections = ProductCollection::where('...')->get()->map(fn($collection) => [
  'id' => $collection->id,
  'name' => $collection->name
]);
  
$results = collect()->merge($products)->merge($collections);

1 like

Ahmed Alaa

3 years ago

Level 3

@PovilasKorop Firstly thank you for your reply to my question and thank you for your amazing series "laravel daily", I'm a big fan of it. I tried this way but I got an error when I used ->paginate() because it's not present as a method in laravel collection

PovilasKorop

3 years ago

Best Answer

Level 11

@Ahmed Alaa Thanks for the kind words! And yes, it's not that easy. Found an earlier Laracasts forum thread about it.

1 like

krekas

3 years ago

Level 25

@PovilasKorop you forgot https://www.youtube.com/watch?v=trzwyMAmzE0 :)

1 like

PovilasKorop

3 years ago

Level 11

@krekas oh right, forgot indeed :)

Please or to participate in this conversation.