Eloquent multiple relationship with condition

Are you sure that $this->society is always 'A' or 'B' and there are no other values like 'a', 'b' or null?

Thanks for your response.

Yes, just 'A' or 'B'

I have found a tempory solution, but I think it's not good, with a MySql View wich regroup the 2 tables Program_society_A and Program_society_B.

I've tried this before but had the same problem you were having, so instead (although not the most desirable solution) I made it into an accessor on the model.

I think it couldn't work this way, as the data aren't loaded when Eloquent is reading your relations.

It is not better to have 3 Tables Quiz User Program ('id', 'user_id', 'society_id')

and if needed a Society table.

Therefore your relation in user model is just

public function program()
{
        return $this->hasOne('\App\Models\Program');
}

@wilk_randall Can you explain to me "accessor on the model" ?

I had a notification model that could apply to three different models: Property, Rental, or Service.

public function getItemAttribute()
{
    switch ($this->type) {
        case 'property':
            return Property::where('id', $this->item_id)->firstOrNew([], ['title' => 'Property']);
        // Same thing for other two
    }
}

// to use it
$notification->item->title;

Looking back at it, I probably could of done it with a Polymorphic relationship, but I didn't think of it at the time.

@Vilfago ok for your first phrase. After, I can't change my MySql DB, it's at my work.

And I know it will be best as you explain.

@wilk_randall thanks, I will see that

@wilk_randall , I have test with an accessor and I's not work.

I think it's impossible, as @Vilfago said, the data are not loaded when Eloquent is reading my relation :(

@sane79 - It isn't actually a relation, it's an accessor, so you should have access to the model's data. Can you show your code of how you did it?

when I have an new object User created, it's ok, the accessor work. But I want to have access to the data when I do the relation with the function with('user.program')

I would say that

 if ($this->society == 'A') {

Could not be interpreted as I guess that when you wrote :

$quizList = QUIZ::with('user.program')->get();

$this->society does not exist.

So I think @wilk_randall is right, you have to use polymorphic. https://laravel.com/docs/5.6/eloquent-relationships#polymorphic-relations

I let you read, because as you cannot change the database, you will have to update your model, but also add a relationship "morph map" in the boot function of one of your provider.

I will see polymorph

you can also load the result first before accessing the prop

public function program()
{
    $this->refresh(); // this will fetch the record from DB

    if ($this->society == 'A') {
        return $this->hasOne('\App\Models\A\Program');
    } elseif ($this->society == 'B') {
        return $this->hasOne('\App\Models\B\Program');
    }
}