Get last records from relationship in Laravel

Question

I have a one to many relation between Person and Visit tables like this:

public function visits()
{
    return $this->hasMany('App\Models\Visit');
}

And want to get the persons who has a sickness_id of 1 in the relation like this:

$persons = Person::whereHas('visits', function ($query) {
    $query->where('sickness_id',  1);
})->get();

And it works fine but I want to search just last visit of each person.

I mean if a person has two visits, one with sickness_id of 1 and other with sickness_id of 2, do not return this person because last visit is sickness_id of 2.

I guess you are looking for this https://stackoverflow.com/a/50831563/853360 or this https://stackoverflow.com/a/63530199/853360 — M Khalid Junaid, Jan 17 '21 at 08:05

score 1 · Answer 1 · answered Jan 17 '21 at 07:58

1

you can use hasOne relation for that:

public function lastVisit()
{
    return $this->hasOne('App\Models\Visit')->latest();
}

then you can load it:

$persons = Person::whereHas('lastVisit', function ($query) {
    $query->where('sickness_id',  1);
})->get();

answered Jan 17 '21 at 07:58

OMR

11,736
5
20
35

1

I already tried this solution but not working as expected – Arman Jan 17 '21 at 08:03

score 0 · Answer 2 · answered Jan 17 '21 at 08:36

0

I think the above answer is gonna work. Using addSelect, this might also work:

Person::addSelect('last_visit_id', Visit::select('id')
    ->whereColumn('person_id', 'persons.id')
    ->latest()
    ->limit(1)
)
->where('last_visit_id', 1)
->get();

answered Jan 17 '21 at 08:36

Kevin Bui

2,754
1
14
15

score -1 · Answer 3 · edited Jan 17 '21 at 12:35

-1

$person = modelname::query()
     ->where(['sickness_id' => '1' ])
     ->select('visits')
     ->orderBy('id', 'DESC')
     ->first();

edited Jan 17 '21 at 12:35

Moshiur

659
6
22

answered Jan 17 '21 at 10:35

MIPro

1
2

Get last records from relationship in Laravel

3 Answers3