/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

2 votes112 views1 answer
Laravel pivot table model
PHP Laravel
8 votes109 views3 answers
Laravel log query for model
PHP Laravel
5 votes111 views3 answers
Delete all rows in table laravel foreign key
PHP Laravel
0 vote111 views3 answers
Laravel query builder get last insert id
PHP Laravel
0 vote127 views1 answer
Confirm password in codeigniter
PHP CodeIgniter
0 vote115 views1 answer
Laravel make view command
PHP Laravel
4 votes97 views2 answers
Date_default_timezone_set for india in php
PHP
3 votes100 views2 answers
How to remove duplicates in a sorted array
PHP
0 vote95 views1 answer
Phpspreadsheet
PHP
0 vote89 views1 answer
Evaluate home tilde ~ in php
PHP