<?php

namespace App\Console\Commands;

use App\Models\EmployerAutoliftOption;
use App\Models\WorkerAutoliftOption;
use Illuminate\Console\Command;

class DeleteExpiredAutoliftOptions extends Command
{
    protected $signature = 'vacancy:delete_expired';

    protected $description = 'Command description';

    public function handle()
    {
        EmployerAutoliftOption::query()
            ->whereRaw('`updated_at` < DATE_SUB(NOW(), INTERVAL `days_repeat` DAY)')
            ->delete();
        WorkerAutoliftOption::query()
            ->whereRaw('`updated_at` < DATE_SUB(NOW(), INTERVAL `days_repeat` DAY)')
            ->delete();
        return Command::SUCCESS;
    }
}