<?php

namespace App\Modules\Network\Commands;

use Log;
use Illuminate\Support\Facades\DB;
use Carbon\Carbon;

// Creatia Core
use App\Models\Asns;

// Module Specifics
use App\Modules\Network\Models\Prefixes;
use App\Modules\Network\Models\Mitigation\PrefixMitigation;
use App\Modules\Network\Models\Mitigation\MitigationRulesets;
use App\Modules\Network\Models\Mitigation\MitigationSensitivities;

class MitigationPort extends \App\Console\Commands\BaseCommand
{
    /**
     * The name and signature of the console command.
     *
     * @var string
     */
    protected $signature = 'mitigation:port';

    /**
     * The console command description.
     *
     * @var string
     */
    protected $description = 'Ports mitigation information from a JSON file that is laid out of the form IP:{SENSE,RULESETS}';

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

    /**
     * Execute the console command.
     *
     * @return int
     */
    public function handle()
    {
        $file = json_decode(file_get_contents(storage_path('mitigation-import.json')), true);
        $senses = MitigationSensitivities::all()->keyBy('system_identifier');
        $rulesets = MitigationRulesets::all()->keyBy('system_identifier');

        foreach($file as $prefix => $data) {
            [$address, $mask] = explode('/', $prefix);

            // Get sensitivity...
            $sense = $data['sense'] == 0 ? null : $senses[$data['sense']]->id;
            $rules = $data['rules'] == 0 ? null : $rulesets[$data['rules']]->id;

            PrefixMitigation::leftJoin('prefixes', 'prefixes.id', '=', 'prefix_id')->where([['address', '=', $address], ['mask', '=', $mask]])->update([
                'ruleset_ids' => $rules,
                'sensitivity_id' => $sense,
                'origin' => 'port',
                'last_source' => 'port',
                'sent' => null,
                'synced_at' => Carbon::now(),
                'in_sync' => 1,
            ]);  
        }
        
        return 0;
    }
}