/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

26 votes212 views3 answers
SQLSTATE[42000]: Syntax error or access violation: 1071
PHP
0 vote248 views1 answer
Php var_dump more readable
PHP
4 votes223 views2 answers
Laravel collection count
PHP
0 vote216 views2 answers
Php rearrange array
PHP
2 votes215 views2 answers
Prevent form submit on page refresh php\
PHP
0 vote226 views1 answer
Laravel session has message
PHP Laravel
0 vote271 views2 answers
Get http host laravel
PHP Laravel
6 votes197 views2 answers
Laravel migration make column nullable
PHP Laravel
1 vote207 views1 answer
Write test case in react native
PHP
2 votes244 views2 answers
Laravel validation unique email except self
PHP