laravel when query with array requests

Question

I have colors request in array $colors = collect($request->colors);

i am trying when query builder for make request when its not empty

$products = Product::when($colors, function ($query, $colors) {
   return $query->whereHas('colors', function (Builder $query) use ($colors) {
     $query->whereIn('slug',  $colors->toArray());
    });
 })

it should not be trigger color query

when i try

when(!$colors->isEmpty(), function ($query, $colors)

its trigger when there is array data in colors request but inside query its return boolean instead of original array data

help!

The first parameter will always be the one to be evaluated as true or false, so if you do !$colors->isEmpty() that transforms automatically into a boolean and that is what $colors will be, so you have to use first code, not second. So, what is your problem with the first one ? — matiaslauriti
– matiaslauriti, Commented Jul 10, 2021 at 22:10
@matiaslauriti the problem with the first one is that an object is always true — lagbox
– lagbox, Commented Jul 10, 2021 at 22:18
One solution is as the user @lagbox shared (the best one), other solution but really not clean is do this: $colors->isNotEmpty() ? $colors : false. — matiaslauriti
– matiaslauriti, Commented Jul 10, 2021 at 23:26

lagbox · Accepted Answer · 2021-07-10 22:28:50Z

2

If you really want to use the when method there with that Collection you can scope in the $colors variable:

Product::when($colors->isNotEmpty(), function ($query) use ($colors) {
    ...
})...

answered Jul 10, 2021 at 22:28

lagbox

50.7k8 gold badges76 silver badges85 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

sid heart Over a year ago

$colors->isNotEmpty() ? $colors : false this fix my code

Collectives™ on Stack Overflow

laravel when query with array requests

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related