/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

-1 vote154 views1 answer
Laravel list of tables
PHP Laravel
0 vote224 views2 answers
New static laravel
PHP Laravel
46 votes209 views6 answers
Laravel make controller with model
PHP Laravel
1 vote194 views1 answer
Laravel @canany
PHP Laravel
0 vote173 views1 answer
Laravel create pivot migration
PHP Laravel
0 vote177 views1 answer
Required_unless laravel
PHP Laravel
0 vote180 views1 answer
Laravel capsule schema datatime CURRENT_TIMESTAMP
PHP Laravel
8 votes161 views1 answer
Laravel store link
PHP Laravel
0 vote160 views1 answer
Optimize clear laravel not working
PHP Laravel
18 votes212 views6 answers
Laravel model
PHP Laravel