Laravel Polymorphic Relationships with order by

Question

Laravel version 7.2.5.

I am using Polymorphic Relationships to store the access logs (login, logout) for multi-role application.

The data storing part is working completely fine. Now, I need to show the list of records in desc format with pagination. But, It's loading the data in the asc format

SomeModel.php

class SomeModel extends Model
{
    /**
     * Polymorphic Relationships
     */
    public function loginLog()
    {
        return $this->morphMany(LoginLog::class, 'employable');
    }

    public function show($token)
    {
        return self::where([
            'token' => $token,
        ])->with([
            'loginLog:employable_id,ip,created_at,updated_at'
        ])->first() ?? null;
    }
}

I did find the solution. But, somehow it doesn't feel the appropriate way to solve this issue.

Here is the link Laravel order results by column on polymorphic table

Thanks @KamleshPaul, its working. I'll put the final code to make it easy for others. Thanks again :) — Mr.Singh, Sep 03 '20 at 13:11

score 1 · Accepted Answer · answered Sep 03 '20 at 15:21

1

Try this

class SomeModel extends Model
{
    /**
     * Polymorphic Relationships
     */
    public function loginLog()
    {
        return $this
            ->morphMany(LoginLog::class, 'employable')
            ->latest();
    }
}

answered Sep 03 '20 at 15:21

Kamlesh Paul

11,778
2
20
33

Mr.Singh · Answer 2 · 2020-09-03T18:57:16.233

I found another way to solve this issue...

class SomeModel extends Model
{
    /**
     * Polymorphic Relationships
     */
    public function loginLog()
    {
        return $this->morphMany(LoginLog::class, 'employable');
    }

    public function show($token, $pagination = 0)
    {
        return self::where([
            'token' => $token,
        ])->with([
            'loginLog' => function ($query) use ($pagination) {
                return $query->select([
                    'employable_id',
                    'ip',
                    'created_at',
                    'updated_at',
                ])
                ->skip($pagination)
                ->take(\Common::paginationLimit())
                ->orderBy('id', 'DESC');
            }
        ])
        ->orderBy('id', 'DESC')
        ->first('id') ?? null;
    }
}

Since I do not need the base table's parameters, therefore, I am fetching only id from it.

Also, with this way I am able to use the pagination too (I am using loadmore pagination).

Laravel Polymorphic Relationships with order by

2 Answers2