CODEWITHSUNDEEP
laraveleloquenteager-loading
Theodory Faustine
Theodory Faustine

Reputation: 462

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

Upvotes: 0

Views: 322

Answers (1)

Jonas Staudenmeir
Jonas Staudenmeir

Reputation: 25916

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'));
}

Upvotes: 2

Related Questions