/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

0 vote181 views1 answer
Laravel handle queryexception
PHP
13 votes166 views1 answer
Create contoller with model and migration
PHP
0 vote151 views1 answer
PHP Warning: PHP Startup: Unable to load dynamic library 'openssl' window
PHP
11 votes154 views6 answers
Get day from date php
PHP
0 vote227 views1 answer
Set custome table laravel eloquent
PHP Laravel
1 vote209 views1 answer
How to display user id from a function on a wordpress page
PHP Wordpress
0 vote197 views2 answers
Php mb_convert_encoding utf8 extended
PHP
0 vote187 views1 answer
Stopping On First Validation Failure
PHP
53 votes537 views6 answers
Laravel join
PHP Laravel
11 votes164 views4 answers
Php convert timestamp to datetime
PHP