/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

7 votes203 views4 answers
Laravel error messages
PHP Laravel
0 vote194 views3 answers
SQLSTATE[42S02]: Base table or view not found: 1146 Table many to many in laravel
PHP Laravel
0 vote188 views1 answer
Laravel enable extensions on Ubuntu
PHP Laravel
9 votes198 views5 answers
Return view with variable laravel
PHP Laravel
0 vote214 views1 answer
Create or update laravel 5.8 stackoverflow
PHP Laravel
0 vote286 views1 answer
Laravel Mix npm run production error
PHP Laravel
4 votes193 views1 answer
Disable register laravel
PHP Laravel
5 votes222 views2 answers
How to get the index in foreach loop in laravel
PHP Laravel
0 vote206 views1 answer
A facade root has not been set laravel 7
PHP Laravel
0 vote200 views1 answer
Using laravel passport with mongodb
PHP Laravel