<?php

namespace App\Jobs\Command;

use Illuminate\Bus\Queueable;
use Illuminate\Contracts\Queue\ShouldBeUnique;
use Illuminate\Contracts\Queue\ShouldQueue;
use Illuminate\Foundation\Bus\Dispatchable;
use Illuminate\Queue\InteractsWithQueue;
use Illuminate\Queue\SerializesModels;

use App\Models\Search;
use Carbon\Carbon;

class ProcessSearchRemovePastDate implements ShouldQueue
{
    use Dispatchable, InteractsWithQueue, Queueable, SerializesModels;

    /**
     * Create a new job instance.
     *
     * @return void
     */
    public function __construct()
    {
        //
    }

    /**
     * Execute the job.
     *
     * @return void
     */
    public function handle()
    {

        $dateToCheck = Carbon::now()->format('Y-m-d'); //get the worker who's contract is finished yesterday
        $garbageData = Search::where('date_to', '<' ,$dateToCheck)->limit(100)->get();

        if(!$garbageData->isEmpty()){
            foreach ($garbageData as $searchData) {
                Search::where('id', $searchData->id)->delete();
            }
        }

    }
}