/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

1 vote132 views1 answer
Php check if query returns results
PHP
18 votes132 views4 answers
Laravel create model controller and migration on line
PHP
2 votes136 views2 answers
Php check if folder exists
PHP
12 votes211 views4 answers
Laravel return redirect to named route
PHP Laravel
1 vote132 views1 answer
Fixuphost
PHP
0 vote194 views1 answer
Query builder laravel getmedia undefined method
PHP Laravel
13 votes129 views3 answers
Laravel string
PHP Laravel
1 vote139 views1 answer
Php foiz
PHP
1 vote242 views1 answer
Migration create symfony
PHP Symfony
2 votes161 views1 answer
How to return chunk data laravel
PHP Laravel