/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 vote143 views1 answer
Count column eloquent laravel
PHP Laravel
0 vote131 views2 answers
Laravel permission to vuejs
PHP Laravel
1 vote136 views3 answers
Convert date to timestamp in laravel builder
PHP Laravel
13 votes136 views3 answers
Laravel password encryption
PHP Laravel
0 vote154 views1 answer
How to pass parameters to relationships laravel
PHP Laravel
5 votes131 views2 answers
Laravel print exception message
PHP Laravel
0 vote132 views1 answer
Laravel - Query Builder Raw Query selectRaw
PHP Laravel
5 votes126 views3 answers
Laravel grouping where
PHP Laravel
1 vote133 views1 answer
Clear bootstrap cache laravel
PHP Laravel
28 votes140 views6 answers
Laravel make model with migration
PHP Laravel