Пример #1
0
 /**
  * Define the application's command schedule.
  *
  * @param  \Illuminate\Console\Scheduling\Schedule  $schedule
  * @return void
  */
 protected function schedule(Schedule $schedule)
 {
     /*$schedule->command('inspire')
       ->everyMinute();*/
     $schedule->call(function () {
         $reservas = Ticket::whereNotNull('reserve')->get();
         foreach ($reservas as $reserva) {
             $reserve_date = strtotime($reserva->created_at);
             $reserve_hours = DB::table('business')->where('id', 1)->first()->reserve_time;
             if ($reserve_date + 3600 * $reserve_hours <= time()) {
                 if ($reserva->event->place->rows != null) {
                     DB::table('slot_presentation')->where('sale_id', $reserva->id)->update(['status' => config('constants.seat_free')]);
                 } else {
                     DB::table('zone_presentation')->where('zone_id', $reserva->zone_id)->increment('slots_availables', $reserva->quantity);
                 }
                 $reserva->delete();
             }
         }
     })->everyMinute();
     $schedule->call(function () {
         $destacados = Highlight::where('start_date', '<=', Carbon::now())->get();
         if ($destacados && !empty($destacados)) {
             foreach ($destacados as $destacado) {
                 $tiempo = strtotime($destacado->start_date) + $destacado->days_active * 3600 * 24;
                 if ($tiempo > time()) {
                     $destacado->active = 1;
                     $destacado->save();
                 }
             }
         }
         $noDestacados = Highlight::where('active', '1')->get();
         if ($noDestacados && !empty($noDestacados)) {
             foreach ($noDestacados as $noDestacado) {
                 $tiempo = strtotime($noDestacado->start_date) + $noDestacado->days_active * 3600 * 24;
                 if ($tiempo <= time()) {
                     $noDestacado->active = 0;
                     $noDestacado->save();
                 }
             }
         }
     })->everyMinute();
 }
Пример #2
0
 public function home()
 {
     $destacados = Highlight::where('active', '1')->get();
     $upcoming = Event::where('selling_date', '>', strtotime(Carbon::now()))->where('publication_date', '>', strtotime(Carbon::now()))->get();
     return view('external.home', array('destacados' => $destacados, 'upcoming' => $upcoming));
 }