Pagination

I have a method on my Supplier model that looks like:

public function getAllDiariesAttribute()
    {
        $products = $this->products();
        $weeks = $products->with('weeks.diary.latestWeek')->get()->pluck('weeks')->collapse()->pluck('diary');

        return $weeks->merge($products->with('diaries.latestWeek')->get()->pluck('diaries'))->flatten()->unique('id');
    }

Products are attached to the diary itself or to the weeks(which are attached to the diary)

Any thoughts on how you could make this an eloquent query to be able to do pagination on the results?

jlrdw

5 years ago

Level 75

Have a look at https://laravel.com/docs/7.x/pagination#paginating-eloquent-results

datarecall

5 years ago

Level 15

@jlrdw the problem is I can't figure out how to turn that method into an eloquent query right now this is just a collection which you can't paginate cleanly

jlrdw

5 years ago

Level 75

You could paginate your collection if you want to, https://laracasts.com/discuss/channels/guides/paginate-collection-simple-example-guide Second example.

MichalOravec

5 years ago

Level 75

When you add this macro to your AppServiceProvider

use Illuminate\Pagination\LengthAwarePaginator;
use Illuminate\Support\Collection;

Collection::macro('paginate', function ($perPage, $total = null, $page = null, $pageName = 'page') {
    $page = $page ?: LengthAwarePaginator::resolveCurrentPage($pageName);

    return new LengthAwarePaginator($this->forPage($page, $perPage), $total ?: $this->count(), $perPage, $page, [
        'path' => LengthAwarePaginator::resolveCurrentPath(),
        'pageName' => $pageName,
    ]);
});

Then you can paginate on the collection.

Please or to participate in this conversation.