How to use if condition in whereIn Clause

You can use when

$query->when(!in_array('All',$region->toArray()), function ($q) {
    $q->whereIn('store_region',$region);
})->latest()->get();

@sinnbeck I tried using when keyword I am getting an error

in_array() expects parameter 3 to be bool, object given", exception: "ErrorException"

Oops forgot a closing )

Answer has been updated

@sinnbeck I don't know whether I am doing it correct or not for this code

 $claim = Claim::whereIn('brand_id',$brands)
                ->where(function($query) use($region) {
                    $query->when(!in_array('All',$region->toArray()),function($q){
                        $q->whereIn('store_region',$region);
                    });
                })->latest()->get();

I am getting error {message: "Undefined variable: region", exception: "ErrorException",…}

$claim = Claim::whereIn('brand_id',$brands)
                ->when(!in_array('All',$region->toArray()),function($q){
                        $q->whereIn('store_region',$region);
                })->latest()->get();

@sinnbeck thanks for helping. But is not working

Could you say a bit more? How is it not working? An error? Wrong data?

@sinnbeck I am not getting any error. But I am getting empty DATA

Ok. And you have rows in the database that has both matches on brand_id and store_region?

You can use telescope, debugbar or clockwork to check your query.

@sinnbeck the problem is I am getting data if regions not have All. If regions contains All I am not getting data based on only brands names it is returning empty rows.

for better understanding

if brands = 'ABC' and region='South' I should get data based on 2 condition brands and region. (this is working fine)

if brands = 'ABC' and region='All' I should get data based on only brands.

Try this and paste the outcome (while region=All)

$claim = Claim::whereIn('brand_id',$brands)
                ->when(!in_array('All',$region->toArray()),function($q){
                        $q->whereIn('store_region',$region);
                })->latest()->toSql();
dd($claim);

@sinnbeck I got this query

"select * from `claims` where `brand_id` in (?) and `store_region` in (?) and `claims`.`deleted_at` is null order by `created_at` desc"

So the in_array returns false (true).

Post the output of

dd(in_array('All',$region->toArray(), $region->toArray());

Try it like this

$claims = Claim::when(! in_array('All', $region->toArray()), function ($query) use ($brands, $region) {
    return $query->whereIn('brand_id', $brands)->whereIn('store_region', $region);
}, function ($query) use ($brands) {
    return $query->whereIn('brand_id', $brands);
})->latest()->get();

@sinnbeck

false
array:1 [▼
 0 => array:1 [▼
   "region_name" => "All"
 ]
]

$claims = Claim::when(! $region->contains('region_name', 'All')), function ($query) use ($brands, $region) {
    return $query->whereIn('brand_id', $brands)->whereIn('store_region', $region->pluck('region_name'));
}, function ($query) use ($brands) {
    return $query->whereIn('brand_id', $brands);
})->latest()->get();

@michaloravec I tried your code. I am returning same empty rows

Use dd() to check each thing like I just showed you.

For instance

dd($region->contains('region_name', 'All'));

$claim = Claim::whereIn('brand_id',$brands)
                ->when(!in_array('All',$region->flatten()->toArray()),function($q){
                        $q->whereIn('store_region',$region);
                })->latest()->get();

@michaloravec Hey thanks for your help the 2nd code is working and I am able to get the exact result . But I don't know how the code is working. But thank you very very much

Read the documentation

https://laravel.com/docs/8.x/collections#method-contains

https://laravel.com/docs/8.x/collections#method-pluck

and

https://laravel.com/docs/8.x/queries#conditional-clauses

@sinnbeck Thanks very very much for helping. You are the best. I don't remember how many things I have learned from you.

@michaloravec Thanks for links surely I will go through that thank you so much.

@shariff Don't forget to mark it as solved. Thanks.

@shariff Always happy to help :)

@shariff Next time I will ignore you.

@michaloravec hey what happened?