Query builder : simulate switch using when

[pildit]

Hi,
did anyone managed to simulate a switch on QueryBuilder using when and having a default case (executed if no when matched ) ?

Given the code

        $opportunitiesCreated = Opportunity::query()
            ->when($adminIdUser, function ($query, $adminIdUser) {
                return $query->where('adminIdUser', $adminIdUser);
            })
            ->when($companyId, function ($query, $companyId) {
                return $query->Company($companyId);
            })
            ->DontBelongsToCompany($excludeCompanyId)
            ->get();

I want to have DontBelongsToCompany executed if neither of the when branches are matched.

[teikun-86]

Put the ->DontBelongsToCompany() as the third parameter on ->when() like:

...
->when($companyId, function ($query, $companyId) {
    return $query->Company($companyId);
}, function ($query) use ($excludeCompanyId) {
    return $query->DontBelongsToCompany($excludeCompanyId);
})
...

[pildit]

Thanks