<?php

namespace App\Console\Commands;

use Symfony\Component\Console\Output\ConsoleOutput;
use Symfony\Component\Console\Helper\ProgressBar;

use Illuminate\Console\Command;
use App\Modules\Cadastro\Models\Cadastro;
use App\Services\GeralService;
use Illuminate\Support\Facades\Log;
use DB;

class AtualizaCodigoCliente extends Command
{
    /**
     * The name and signature of the console command.
     *
     * @var string
     */
    protected $signature = 'atualiza_codigo_cliente';

    /**
     * The console command description.
     *
     * @var string
     */
    protected $description = 'Atualiza Código Único Clientes';

    /**
     * Create a new command instance.
     *
     * @return void
     */
    public function __construct()
    {
        parent::__construct();
        $this->output = new ConsoleOutput;
    }

    /**
     * Execute the console command.
     *
     * @return mixed
     */
    public function handle()
    {
        $this->info(date('d/m/Y H:i:s') . " - START");

        $clientes = $query = Cadastro::select('id')->whereRaw('codigo_cliente IS NULL')->get();
        $total    = count($clientes);
        $this->updateCodigoCliente(1, $total);

        $this->info(date('d/m/Y H:i:s') . " - DONE");
    }

    public function updateCodigoCliente($lote, $total){

        $limit = 1000;
        $query = Cadastro::select('id')->whereRaw('codigo_cliente IS NULL');
        $lotes = $total / $limit;
        $lotes = (int) ($lotes + 1);

        $listaClientes = $query->limit($limit)->orderBy('id', 'asc')->get();
        $progressBar   = new ProgressBar($this->output, count($listaClientes));

        if(count($listaClientes) > 0){

            $this->info("\nLOTE {$lote}/{$lotes}");

            foreach ($listaClientes as $cliente) {
                try {
                    $codigo = GeralService::gerarCodigoAleatorio();
                    $sql = "UPDATE cadastro SET codigo_cliente = '{$codigo}' WHERE id = {$cliente->id}";
                    DB::update(DB::raw($sql));
                    $progressBar->advance();
                } catch (Exception $e) {
                    Log::info("Código Repetido: {$codigo}");
                    $progressBar->advance();
                    continue;
                }
            }
            $progressBar->finish();
            $lote++;
            $this->updateCodigoCliente($lote, $total);
        }else{
            return false;
        }
    }
}