Laravel - with relation condition

Question

Trying to integrate "if condition" inside model relation. But It doesnt work.

    $customer_index = Customer::where('firm_id', $firm_id)
    ->with(['company', 'tires', 'vehicles'])
    ->withCount(['tires', 'vehicles'])
    ->orderBy('id', 'desc');

my Customer.php model

public function vehicles()
{
    if(isset($this->company->is_fleet)){
        return $this->hasMany('App\Models\CustomerVehicle', 'fleet_id', 'company_id');
    }
    return $this->hasMany('App\Models\CustomerVehicle');
}

you cant do that with eager loading as the relation method is called on a new instance (that has no attributes) — lagbox
– lagbox, Commented Nov 27, 2020 at 15:34
Does this answer your question? How to setup conditional relationship on Eloquent — miken32
– miken32, Commented Nov 27, 2020 at 15:50

Donkarnash · Accepted Answer · 2020-11-27 16:42:13Z

1

Can't do that sort of conditional with eager loading.

To maintain all benefits of eloquent you should separate the relations

public function company_vehicles()
{
    return $this->hasMany(CustomerVehicle::class, 'fleet_id', 'company_id');
}

public function customer_vehicles()
{
    return $this->hasMany(CustomerVehicle::class);
}

//A scope to tuck away the eager loads
public function scopeVehicles($query)
{
   return $query->with(['company_vehicles', 'customer_vehicles']);
}

You asked in the comment to club the relations in one key vehicles. This is how you can try


User::vehicles()->get()->map(function($user){

    if(!empty($user->customer_vehicles)){
      
      $user->vehicles = $user->customer_vehicles;
      unset($user->customer_vehicles);
      unset($user->company_vehicles);
      
    } else if(!empty($user->company_vehicles)) {
      
      $user->vehicles = $user->company_vehicles;
      unset($user->customer_vehicles);
      unset($user->company_vehicles);
      
    }
  
  return $user;
});

edited Nov 27, 2020 at 16:42

answered Nov 27, 2020 at 15:56

Donkarnash

12.9k5 gold badges30 silver badges43 bronze badges

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

8 Comments

TCS Over a year ago

Thank you. but It gives: Call to undefined method Illuminate\Database\Eloquent\Builder::getRelated() error.

Donkarnash Over a year ago

For which line does it give the error can you find in the stacktrace. Are you importing the use statement for the CustomerVehicle

TCS Over a year ago

Call to undefined method Illuminate\Database\Eloquent\Builder::getRelated(); vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:50

Donkarnash Over a year ago

What I mean is look in the stacktrace to find which line of your written code the error occurs not the framework components in the stack

TCS Over a year ago

ok it returns 2 list. customer_vehicles and company_vehicles. isn't there anyway to return them on same key? example: vehicles: [{ bla bla bla}]. now, it gives like customer_vehicles: [{bla bla}], company_vehicles: [{ bla bla}]

|

Collectives™ on Stack Overflow

Laravel - with relation condition

1 Answer 1

8 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

8 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related