/PHP/Laravel - Add conditional where clause in query

Laravel - Add conditional where clause in query

$user_to_mail = User::where('store_id', $item->store_id)
                    ->when($store->notification_role_id > 0, function ($q) use ($store) {
                        return $q->where('role_id', $store->notification_role_id);
                    })
                    ->get();

Similar codes

0 vote155 views1 answer
Phpspreadsheet middle align
PHP
4 votes186 views4 answers
Laravel sum relationship column
PHP Laravel
1 vote144 views1 answer
Composer update no limit
PHP
0 vote163 views1 answer
Set Countries To Appear At The Top Of The Caldera Forms Phone Field List
PHP
0 vote189 views1 answer
Laravel validation mimes always fails
PHP Laravel
14 votes155 views2 answers
Laravel change value to intger
PHP
2 votes187 views1 answer
Laravel schema default string length
PHP Laravel
20 votes148 views6 answers
Php sort array by key
PHP
0 vote276 views1 answer
Users not having any role laravel spatie
PHP Laravel
6 votes169 views2 answers
Php multiple line string
PHP