Laravel conditional clause when for filtering value

Question

I have a event table with status o or 1.

I have to filter the event with status 1,0 or ALL.

I tried with laravel when conditional clause,its not working with value zero,other conditionals are working.

$status    = Input::get('status');
$events    = DB::table('events')
          ->select('events.*')
          ->when($status, function ($query) use ($status) {
           return $query->where("events.status",$status);
           })
          ->get();

Try $status = Input::get('status') ? 1 : 0;. The status parameter is probably a string and you only want two options 1 and 0 (a user can change the status parameters) — Thijs
– Thijs, Commented Oct 12, 2018 at 7:17
Have you read the documentation at laravel.com/docs/master/queries? It states that "The when method only executes the given Closure when the first parameter is true. If the first parameter is false, the Closure will not be executed." — Daniel Protopopov
– Daniel Protopopov, Commented Oct 12, 2018 at 7:18

Jignesh Joisar · Accepted Answer · 2018-10-12 08:25:30Z

3

in_array function used in when method try this one

because 0(zero) means(false) by default understand so try to use inner function in when method

if didn't pass status then set default value as 2 or any number but not 0,1 and null

$status  = Input::has('status') ? Input::get('status') : 2;

$events  = DB::table('events')->select('events.*')
          ->when(in_array($status,[0,1]), function ($query) use ($status) {
                return $query->where("events.status",$status);
           })->get();

second way create a new function

   function checkStatus($status,$array) {
       if(isset($status)) {
           return in_array($status,$array);
      }

      return false;
    }



$events  = DB::table('events')->select('events.*')
                  ->when(checkStatus($status,[0,1]), function ($query) use ($status) {
                        return $query->where("events.status",$status);
                   })->get();

edited Oct 12, 2018 at 8:25

answered Oct 12, 2018 at 7:21

Jignesh Joisar

15.4k6 gold badges69 silver badges61 bronze badges

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

3 Comments

Rp9 Over a year ago

select events.* from events where events.status is null; got this when i didnt pass the value

Rp9 Over a year ago

am using this in a filter section,if am not passing status then the query should work without where condition,other wise with 0 or 1

Jignesh Joisar Over a year ago

@Rp9 also used in second way by create new function and check

Gul Muhammad · Accepted Answer · 2023-01-25 06:19:07Z

0

For any future reader using 0 and 1

we can use when in the following way

->when($request->has('status'),
fn ($query) => $query->where("status", $request->status)
)->get();

we are getting the user requested status using has method in Laravel to deal with it.

answered Jan 25, 2023 at 6:19

Gul Muhammad

1861 silver badge13 bronze badges

Collectives™ on Stack Overflow

Laravel conditional clause when for filtering value

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related