Laravel Query/ Relational database query

Question

I have two data tables vehicles and trips, which have a one to many relationship and allow for multiple trips per vehicle. route is a column in the trips table. I want to see the vehicle list for a specific route, so I ran the following query.

$trips = Trip::with('vehicle')
     ->where('route', $route)
     ->get()->pluck('vehicle');

It work's fine, returns a vehicle collection. Now that I have the vehicle collection I want the active trip information with every vehicle model. I tried the following query.

$trips = Trip::with('vehicle', ['vehicle.activeTrip' => function ($query) {
            $query->where('status', 0);
        }])
        ->where('route', $route)
        ->get()->pluck('vehicle');

status = 0 indicates an active trip. But it is unsuccessful anyway. I got an error with the message Method name must be a string. Can anyone assist me in resolving my problem?

Actually same table but different relationship, for active trip I use one to one relationship. — Shah Foyez
– Shah Foyez, Commented Nov 16, 2022 at 20:22

Ramil Huseynov · Accepted Answer · 2022-11-16 20:02:12Z

2

Would you use this syntax


$trips = Trip::with(['vehicle','vehicle.activeTrip' => function ($query) {
            $query->where('status', 0);
        }])
        ->where('route', $route)
        ->get()->pluck('vehicle');

answered Nov 16, 2022 at 20:02

Ramil Huseynov

3714 silver badges10 bronze badges

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

2 Comments

Shah Foyez Over a year ago

Yeah, it's working, I made that silly mistake.

Ramil Huseynov Over a year ago

@ShahFoyez oh nice, please rate the answer :)

Shah Foyez · Accepted Answer · 2022-11-16 20:29:54Z

1

I just came across another solution. To retrieve the active trip data, we could use the Laravel ofMany method inside the Trip model.

public function activeTrip(){
return $this->hasOne(Trip::class, 'vid')->ofMany([], function ($query) {
    $query->where('status', 0);
});}

answered Nov 16, 2022 at 20:29

Shah Foyez

297 bronze badges

Collectives™ on Stack Overflow

Laravel Query/ Relational database query

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related