<?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 DispatchVacancyLiftJobCommand extends Command
  {
      protected $signature ='vacancy:dispatch';
  
      public function handle()
      {

          $now = now()->timezone('Europe/Moscow')->format('H:i');

          $employersAutoLift = EmployerAutoliftOption::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(

              $employersAutoLift->whereNotNull('time_send_first')->pluck('employer_id')->toArray(),

          );

          $employersSendTelegramm = EmployerAutoliftOption::query()

              ->where('time_send_tg', $now)

              ->get();

          SendVacancyToTelegramJob::dispatch(

              $employersSendTelegramm->whereNotNull('time_send_tg')->pluck('employer_id')->toArray()

          );
  
          return Command::SUCCESS;
      }
  }