/PHP/Laravel/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 vote203 views1 answer
Multipart json test laravel
PHP Laravel
1 vote190 views1 answer
Publishing laravel module package
PHP Laravel
0 vote177 views1 answer
Laravel sanctum Protecting routes
PHP Laravel
1 vote192 views1 answer
Laravel redirect external url
PHP Laravel
1 vote206 views1 answer
Get data based on date in laravel
PHP Laravel
15 votes212 views6 answers
Laravel db transaction
PHP Laravel
0 vote220 views1 answer
How to wirte laravel dd function in php
PHP Laravel
7 votes207 views2 answers
Laravel check sql query
PHP Laravel
0 vote220 views1 answer
Laravel validation get failed rules
PHP Laravel
-1 vote196 views2 answers
Laravel eloquent update multiple records
PHP Laravel