<?php
  
  namespace App\Console\Commands;
  
  use App\Jobs\LiftVacancyJob;
  use App\Jobs\SendVacancyToTelegramJob;
  use App\Models\EmployerAutoliftOption;
  use App\Models\WorkerAutoliftOption;
  use Illuminate\Console\Command;
  
  class DispatchResumeLiftJobCommand extends Command
  {
      protected $signature ='resume:dispatch';
  
      public function handle()
      {
          $now = now()->timezone('Europe/Moscow')->format('H:i');

          $workers = WorkerAutoliftOption::query()

              ->where(function ($query) use ($now) {
                  $query->where('times_per_day', 1)
                      ->where('time_send_first', $now);
              })
              ->orWhere(function ($query) use ($now) {
                  $query->where('times_per_day', 2)

                      ->where(function ($query) use ($now) {
                          $query->where('time_send_first', $now)
                              ->orWhere('time_send_second', $now);
                      });

              })
              ->orWhere(function ($query) use ($now) {
                  $query->where('times_per_day', 3)

                      ->where(function ($query) use ($now) {
                          $query->where('time_send_first', $now)
                              ->orWhere('time_send_second', $now)
                              ->orWhere('time_send_third', $now);
                      });

              })
              ->get();

          LiftVacancyJob::dispatch($workers->pluck('worker_id')->toArray());

  
          return Command::SUCCESS;
      }
  }