/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

4 votes245 views2 answers
Codeigniter 3 limit
PHP
0 vote197 views1 answer
Deleting a row from databse using php
PHP
0 vote187 views1 answer
Auth log out laravel
PHP
9 votes279 views3 answers
Image validate in laravel validater
PHP
0 vote309 views1 answer
Laravel where 2 column
PHP Laravel
17 votes192 views6 answers
Php sha256
PHP
61 votes216 views6 answers
Php delete item from array
PHP
1 vote174 views4 answers
Undefined array key php
PHP
0 vote215 views1 answer
Laravel array search blade
PHP Laravel
13 votes205 views6 answers
Route group in laravel
PHP Laravel