Search code examples
laraveleloquenteager-loading

Multiple Eager Loading With Pagination in laravel


I want to return paginated data of the eager loaded relations so as I can display them using pagination in my view template

public function show(Group $group)
{
    $data = ['members', 'assets', 'liabilities', 'loans','shares'];

    $group = $group->load($data);

    return view('admin.groups.show', compact('group'));
}

This is my Group Model

<?php

namespace App;

class Group extends BaseModel
{   
    use Enumable;

    public function constitution()
    {
        return $this->hasOne(Constitution::class);
    }

    public function members()
    {
        return $this->hasMany(Member::class);
    }


    public function assets()
    {
        return $this->hasManyThrough(Asset::class, Meeting::class)
        ->orderByDesc('meeting_id')
        ->orderBy('member_id');
    }

    public function loans()
    {
        return $this->hasManyThrough(Loan::class, Member::class)
        ->orderByDesc('meeting_id')
        ->orderBy('member_id');
    }

    public function shares()
    {
        return $this->hasManyThrough(Share::class, Member::class)
        ->orderByDesc('meeting_id')
        ->orderBy('member_id');
    }

    public function liabilities()
    {
        return $this->hasOne(Liability::class)->latest();
    }
}

I need to paginate $data array


Solution

  • Use setRelations():

    public function show(Group $group)
    {
        $group->setRelations([
            'members', $group->members()->paginate(5),
            'assets', $group->assets()->paginate(5),
            'liability', $group->liability()->paginate(5),
            'loans', $group->loans()->paginate(5)
        ]);
    
        return view('admin.groups.show', compact('group'));
    }