/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

5 votes371 views2 answers
Check session in blade laravel
PHP Laravel
2 votes416 views1 answer
Command to delete storage logs in laravel
PHP Laravel
2 votes387 views2 answers
In PackageManifest.php line 131: Undefined index: name laravel 7
PHP Laravel
0 vote366 views2 answers
Laravel 8 query builder, Left Join / Right Join Clause
PHP Laravel
1 vote420 views1 answer
Laravel gates
PHP Laravel
6 votes372 views2 answers
How to set tinyint default 0 laravel migration
PHP Laravel
2 votes361 views1 answer
How to run multiple laravel projects at same time
PHP Laravel
50 votes487 views6 answers
Laravel migration add column to existing table
PHP Laravel
12 votes360 views6 answers
Laravel validate date
PHP Laravel
0 vote356 views1 answer
Laravel mixed content error
PHP Laravel