Conditional multiple if in query

I think you could do that afterwards instead of during the query.

$user = User::with('address')->get()->map(function ($user) {
    if ($user->address->type == 'A') {
        $user->something = "somethingA";
    }
    
    return $user;
});

Or maybe I'm misunderstanding what you actually need :)

You can try something like this.

$user = DB::table('address as a')
                ->select(DB::raw('CASE 
                                  WHEN a.type == 'A' THEN  something_1 
                              WHEN a.type == 'B' THEN something_2  
                                               ELSE default END'))```

#ftiersch, thank you. I think your solution is a good way. In my condition, I would add an other eager loading relationship like this

   $user = User::with('address')->get()->map(function ($user)
    {
        if ($user->address->type == 'A') 
        {
            $user->with('relationship_A');
        }
        if ($user->address->type == 'B') 
        {
            $user->with('relationship_B');
        }

        return $user;
    });

How can I do to add by exemple with('relationship_A') inside map ?

#somnathsah, thank you but I can't use your solution on a sql query ->select(DB::raw because in my condition, I need to add eager loading relationship who are not of the same database (mysql and oracle), so I need use functions in models.

In that case you can't really use with() because with gets used during the execution of the query. You would have to use each() instead of map() and then use load() instead of with(). But that would actually remove all the purpose of eager loading because you would execute another query for every user which is exactly the problem eager loading tries to avoid.

Thank you very much ftiersch for you explainations. it's a good temporary solution for me.

$user = User::with('address')->get();

if ($user->address->type == 'A') {
    $user->load('relationship_A');
}

https://laravel.com/docs/5.8/eloquent-relationships#lazy-eager-loading

#cronix , thank you,

Regarding :

if ($user->address->type == 'A') { $user->load('relationship_A'); }

it's ok with User::with('address')->first () but not with User::with('address')->get() which is a collection. I always need to execute query for every user if I have a collection.

The example of official laravel website on Eager Loading is with an external condition, I think it's more difficult in my situation where the condition come from my query.

$withs = ['address'];

if ($user->address->type == 'A') {
    $withs[] = 'relationship_A';
}

$user = User::with($withs)->get();

?

Could be a good use case for a polymorphic relationship

http://novate.co.uk/using-laravel-polymorphic-relationships-for-different-user-profiles/

#Snapey. Polymorphic relationship is a good idea but In my projet, one of my table I need is from an proprietary external software database (I can't add or modify column), so I can't add xxxxxx_id and xxxxxx_type columns.