DispatchVacancyLiftJobCommand.php 1.82 KB
<?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()
            ->orWhere('time_send_tg', $now)
            ->get();

        SendVacancyToTelegramJob::dispatch(
            $employersSendTelegramm->whereNotNull('time_send_tg')->pluck('employer_id')->toArray()
        );

        return Command::SUCCESS;
    }
}