'integer', ]; public function scopeCheckdate($query, $start_date, $end_date) { $query->where(function($query)use($start_date){ $query->whereDate('from','<=', $start_date)->whereDate('to', '>=', $start_date); })->orWhere(function($query)use($end_date){ $query->whereDate('from','<=', $end_date)->whereDate('to', '>=', $end_date); }); } }