How to filter between two date only if they are not empty or null

Hello , I am trying to make filter.I am trying to filter between two date only if they are not null or empty.In my case if $from and $to variable are empty it is filtering with today date.So how to make filter only if $from and to and are not empty ?

$from = "2020-12-01" ?? ''; // date coming from filter
$to = "2020-12-27" ?? '';  // date coming filter

	$order=Order::where('status','delivered')
		 ->where('delivery_date','>=' ,Carbon::parse($from))
                ->where('delivery_date','<=' ,Carbon::parse($to))
		->get();

MichalOravec

5 years ago

Best Answer

Level 75

$orders = Order::where('status', 'delivered')
    ->when($request->from && $request->to, function ($query) use ($request) {
        return $query->whereDate('delivery_date', '>=', $request->from)
            ->whereDate('delivery_date', '<=', $request->to);
    })->get();

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

2 likes

coder72

5 years ago

Level 1

it worked thanks

Sergiu17

5 years ago

Level 60

$query = Order::query(); // you can create a Builder instance

if ( $from !== '') { $query->where('delivery_date','>=' ,Carbon::parse($from)); }
if ( $to !== '') { $query->where('delivery_date','<=' ,Carbon::parse($to)); }

$orders = $query->where('status', 'delivered')->get();

1 like

Please or to participate in this conversation.