Laravel 5.5 - Nested query and model relation

Question

I have 4 models.

User
Shipment
Status
Status history

User.php

public function shipments() {
   return $this->hasMany('App\Shipment', 'from_user_id');
}

Shipment.php

public function statuses() {
   return $this->hasMany('App\StatusHistory', 'model_id');
}

A User has many Shipment. A Shipment has many Status instances through StatusHistory.

How can I get with an Eloquent relationship all the Shipment values for an User, that have a specific id value in the StatusHistory model?

There isn't enough information in your question to write an actual query. So I'd suggest looking at using whereHas when querying $user->shipments()->whereHas(...). — fubar
– fubar, Commented Feb 19, 2018 at 23:34
I just added some more information. So if I have $user->shipments, how can add extra query to that? — Felipe Peña
– Felipe Peña, Commented Feb 20, 2018 at 0:07

Prince Lionel N'zi · Accepted Answer · 2018-02-20 00:23:34Z

2

You can do

$user = User:find($id);
$shipments = $user->shipments()->whereHas('statuses', function ($query) {
    //Select all the shipments for this user where `StatusHistory` id is 1
    $query->where('id', 1);
})->get();

answered Feb 20, 2018 at 0:23

Prince Lionel N'zi

2,5882 gold badges14 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Laravel 5.5 - Nested query and model relation

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related