<?php

namespace App\Console\Commands;

use App\Models\Notam;
use Illuminate\Console\Command;

class MassResponseUpdate extends Command
{

    /**
     * The name and signature of the console command.
     *
     * @var string
     */
    protected $signature = 'notam:update_responses';

    /**
     * The console command description.
     *
     * @var string
     */
    protected $description = 'Mass change string to array in NOTAMS';

    /**
     * Create a new command instance.
     *
     * @return void
     */
    public function __construct()
    {
        parent::__construct();
    }

    /**
     * Execute the console command.
     *
     * @return int
     */
    public function handle()
    {
        $sectionToUpdate = 'E_Line';
        $objectToUpdate = 'Airways';
        $subObjectToUpdate = 'AWY_Segments';
        $fieldToUpdate = 'Direction';
        $allNotams = Notam::query()->get();
        $notamsUpdated = 0;
        foreach ($allNotams as $notam) {
            if ($notam->correct_response) {
                $response = json_decode($notam->correct_response);
                if (!empty($response) && property_exists($response, $sectionToUpdate)
                    && $response->$sectionToUpdate
                    && property_exists($response->$sectionToUpdate, $objectToUpdate)) {
                        foreach ($response->$sectionToUpdate->$objectToUpdate as $key => $airway) {
                            if (property_exists($airway, $subObjectToUpdate)) {
                                foreach ($airway->$subObjectToUpdate as $key2 => $subObject) {
                                    if (property_exists($subObject, $fieldToUpdate)
                                        && is_array($subObject->$fieldToUpdate)) {
                                        $response->$sectionToUpdate->$objectToUpdate[$key]->$subObjectToUpdate[$key2]->$fieldToUpdate =
                                            $subObject->$fieldToUpdate[0];
                                        $notam->correct_response = json_encode($response);
                                        $notam->save();
                                        $notamsUpdated++;
                                    }
                                }
                            }


                        }
                }
            }
        }
        echo 'Updated ' . $notamsUpdated . ' fields' . PHP_EOL;
    }
}