<?php

namespace App\Jobs;

use App\Models\News;
use Illuminate\Support\Carbon;
use Illuminate\Support\Facades\Log;

/**
 * Update status attribute reading its
 * publish_at and unpublish_at attributes.
 */
class NewsStatusUpdate
{
    /**
     * Called when the job will be executed.
     *
     * @return void
     */
    public function handle()
    {
        /** @var \Illuminate\Database\Eloquent\Collection<array-key, \App\Models\News> */
        $newsListToPublish = News::query()->where('publish_at', '<=', Carbon::now()->toDateTime())
            ->where('status', false)->get();
        Log::debug(__CLASS__ . " news to publish " . $newsListToPublish->count());
        foreach ($newsListToPublish as $news) {
            $news->status = true;
            $news->saveOrFail();
        }
        /** @var \Illuminate\Database\Eloquent\Collection<array-key, \App\Models\News> */
        $newsListToUnPublish = News::query()->where('unpublish_at', '<=', Carbon::now()->toDateTime())
            ->where('status', true)->get();
        Log::debug(__CLASS__ . " news to unpublish " . $newsListToPublish->count());
        foreach ($newsListToUnPublish as $news) {
            $news->status = false;
            $news->saveOrFail();
        }
    }
}