Example #1
0
 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;
 }