private function advertiseAvailability($type, $reserve) { $advertises = Advertise::select([DB::raw('DATE(expired_at) AS date'), DB::raw('COUNT(id) AS count')])->where('status', 1)->where('type', $type[1])->whereBetween('expired_at', [Carbon::now(), Carbon::now()->addDays($reserve)])->groupBy('date')->orderBy('date', 'ASC')->get(); return $advertises; }