Hope you will get the idea…
public function scopeSearchBy($query, $request)
{
if ($request->get(‘purchase_order_no’)) {
$query->where(‘purchase_order_no’, $request->get(‘purchase_order_no’));
} else {
if ($request->get(‘end_date’)) {
$query->whereDate(‘created_at’, ‘<=’, $request->get(‘end_date’));
}
if ($request->get(‘start_date’)) {
$query->whereDate(‘created_at’, ‘>=’, $request->get(‘start_date’));
}
if ($request->get(‘status’) && $request->get(‘status’) != ‘all’) {
$query->where(‘status’, $request->get(‘status’));
}
}
return $query;
}
Question and answer is powered by AnsPress.io