<?php
declare(strict_types=1);

use Phinx\Migration\AbstractMigration;

final class Task2112271830 extends AbstractMigration
{
    public function up(): void
    {
        $this->execute("DELETE FROM sinistro.auxiliar_liquidacao_cebola_qualidade_i");

        $table = $this->table('sinistro.auxiliar_liquidacao_cebola_qualidade_i');
        $rows = [
                   ['id_usuario_criacao' => 2068, 'dt_criacao' => 'NOW()', 'vl_percent_perdas_min' =>  0.00, 'vl_percent_perdas_max' =>  10.99, 'vl_percent_correcao' =>  0.00],
                   ['id_usuario_criacao' => 2068, 'dt_criacao' => 'NOW()', 'vl_percent_perdas_min' => 11.00, 'vl_percent_perdas_max' =>  13.99, 'vl_percent_correcao' =>  2.00],
                   ['id_usuario_criacao' => 2068, 'dt_criacao' => 'NOW()', 'vl_percent_perdas_min' => 14.00, 'vl_percent_perdas_max' =>  15.99, 'vl_percent_correcao' =>  3.00],
                   ['id_usuario_criacao' => 2068, 'dt_criacao' => 'NOW()', 'vl_percent_perdas_min' => 16.00, 'vl_percent_perdas_max' =>  24.99, 'vl_percent_correcao' =>  4.00],
                   ['id_usuario_criacao' => 2068, 'dt_criacao' => 'NOW()', 'vl_percent_perdas_min' => 25.00, 'vl_percent_perdas_max' =>  29.99, 'vl_percent_correcao' =>  5.00],
                   ['id_usuario_criacao' => 2068, 'dt_criacao' => 'NOW()', 'vl_percent_perdas_min' => 30.00, 'vl_percent_perdas_max' =>  32.99, 'vl_percent_correcao' =>  6.00],
                   ['id_usuario_criacao' => 2068, 'dt_criacao' => 'NOW()', 'vl_percent_perdas_min' => 33.00, 'vl_percent_perdas_max' =>  36.99, 'vl_percent_correcao' =>  7.00],
                   ['id_usuario_criacao' => 2068, 'dt_criacao' => 'NOW()', 'vl_percent_perdas_min' => 37.00, 'vl_percent_perdas_max' =>  39.99, 'vl_percent_correcao' =>  9.00],
                   ['id_usuario_criacao' => 2068, 'dt_criacao' => 'NOW()', 'vl_percent_perdas_min' => 40.00, 'vl_percent_perdas_max' =>  45.99, 'vl_percent_correcao' => 10.00],
                   ['id_usuario_criacao' => 2068, 'dt_criacao' => 'NOW()', 'vl_percent_perdas_min' => 46.00, 'vl_percent_perdas_max' =>  51.99, 'vl_percent_correcao' => 12.00],
                   ['id_usuario_criacao' => 2068, 'dt_criacao' => 'NOW()', 'vl_percent_perdas_min' => 52.00, 'vl_percent_perdas_max' =>  53.99, 'vl_percent_correcao' => 14.00],
                   ['id_usuario_criacao' => 2068, 'dt_criacao' => 'NOW()', 'vl_percent_perdas_min' => 54.00, 'vl_percent_perdas_max' =>  57.99, 'vl_percent_correcao' => 15.00],
                   ['id_usuario_criacao' => 2068, 'dt_criacao' => 'NOW()', 'vl_percent_perdas_min' => 58.00, 'vl_percent_perdas_max' =>  72.99, 'vl_percent_correcao' => 16.00],
                   ['id_usuario_criacao' => 2068, 'dt_criacao' => 'NOW()', 'vl_percent_perdas_min' => 73.00, 'vl_percent_perdas_max' =>  76.99, 'vl_percent_correcao' => 17.00],
                   ['id_usuario_criacao' => 2068, 'dt_criacao' => 'NOW()', 'vl_percent_perdas_min' => 77.00, 'vl_percent_perdas_max' =>  78.99, 'vl_percent_correcao' => 16.00],
                   ['id_usuario_criacao' => 2068, 'dt_criacao' => 'NOW()', 'vl_percent_perdas_min' => 79.00, 'vl_percent_perdas_max' =>  80.99, 'vl_percent_correcao' => 15.00],
                   ['id_usuario_criacao' => 2068, 'dt_criacao' => 'NOW()', 'vl_percent_perdas_min' => 81.00, 'vl_percent_perdas_max' =>  82.99, 'vl_percent_correcao' => 14.00],
                   ['id_usuario_criacao' => 2068, 'dt_criacao' => 'NOW()', 'vl_percent_perdas_min' => 83.00, 'vl_percent_perdas_max' =>  83.99, 'vl_percent_correcao' => 13.00],
                   ['id_usuario_criacao' => 2068, 'dt_criacao' => 'NOW()', 'vl_percent_perdas_min' => 84.00, 'vl_percent_perdas_max' =>  84.99, 'vl_percent_correcao' => 12.00],
                   ['id_usuario_criacao' => 2068, 'dt_criacao' => 'NOW()', 'vl_percent_perdas_min' => 85.00, 'vl_percent_perdas_max' =>  86.99, 'vl_percent_correcao' => 11.00],
                   ['id_usuario_criacao' => 2068, 'dt_criacao' => 'NOW()', 'vl_percent_perdas_min' => 87.00, 'vl_percent_perdas_max' =>  87.99, 'vl_percent_correcao' => 10.00],
                   ['id_usuario_criacao' => 2068, 'dt_criacao' => 'NOW()', 'vl_percent_perdas_min' => 88.00, 'vl_percent_perdas_max' =>  88.99, 'vl_percent_correcao' =>  9.00],
                   ['id_usuario_criacao' => 2068, 'dt_criacao' => 'NOW()', 'vl_percent_perdas_min' => 89.00, 'vl_percent_perdas_max' =>  90.99, 'vl_percent_correcao' =>  8.00],
                   ['id_usuario_criacao' => 2068, 'dt_criacao' => 'NOW()', 'vl_percent_perdas_min' => 91.00, 'vl_percent_perdas_max' =>  91.99, 'vl_percent_correcao' =>  7.00],
                   ['id_usuario_criacao' => 2068, 'dt_criacao' => 'NOW()', 'vl_percent_perdas_min' => 92.00, 'vl_percent_perdas_max' =>  92.99, 'vl_percent_correcao' =>  6.00],
                   ['id_usuario_criacao' => 2068, 'dt_criacao' => 'NOW()', 'vl_percent_perdas_min' => 93.00, 'vl_percent_perdas_max' =>  94.99, 'vl_percent_correcao' =>  5.00],
                   ['id_usuario_criacao' => 2068, 'dt_criacao' => 'NOW()', 'vl_percent_perdas_min' => 95.00, 'vl_percent_perdas_max' =>  95.99, 'vl_percent_correcao' =>  4.00],
                   ['id_usuario_criacao' => 2068, 'dt_criacao' => 'NOW()', 'vl_percent_perdas_min' => 96.00, 'vl_percent_perdas_max' =>  96.99, 'vl_percent_correcao' =>  3.00],
                   ['id_usuario_criacao' => 2068, 'dt_criacao' => 'NOW()', 'vl_percent_perdas_min' => 97.00, 'vl_percent_perdas_max' =>  97.99, 'vl_percent_correcao' =>  2.00],
                   ['id_usuario_criacao' => 2068, 'dt_criacao' => 'NOW()', 'vl_percent_perdas_min' => 98.00, 'vl_percent_perdas_max' =>  98.99, 'vl_percent_correcao' =>  1.00],
                   ['id_usuario_criacao' => 2068, 'dt_criacao' => 'NOW()', 'vl_percent_perdas_min' => 99.00, 'vl_percent_perdas_max' => 100.00, 'vl_percent_correcao' =>  0.00]
        ];
        $table->insert($rows)
              ->save();
    }

    public function down(): void
    {
        $this->execute("DELETE FROM sinistro.auxiliar_liquidacao_cebola_qualidade_i");

        $table = $this->table('sinistro.auxiliar_liquidacao_cebola_qualidade_i');
        $rows = [
                   ['id_usuario_criacao' => 2068, 'dt_criacao' => 'NOW()', 'vl_percent_perdas_min' =>  0.00, 'vl_percent_perdas_max' =>   4.99, 'vl_percent_correcao' =>  0.00],
                   ['id_usuario_criacao' => 2068, 'dt_criacao' => 'NOW()', 'vl_percent_perdas_min' =>  5.00, 'vl_percent_perdas_max' =>   9.99, 'vl_percent_correcao' =>  7.00],
                   ['id_usuario_criacao' => 2068, 'dt_criacao' => 'NOW()', 'vl_percent_perdas_min' => 10.00, 'vl_percent_perdas_max' =>  19.99, 'vl_percent_correcao' => 14.00],
                   ['id_usuario_criacao' => 2068, 'dt_criacao' => 'NOW()', 'vl_percent_perdas_min' => 20.00, 'vl_percent_perdas_max' =>  29.99, 'vl_percent_correcao' => 20.00],
                   ['id_usuario_criacao' => 2068, 'dt_criacao' => 'NOW()', 'vl_percent_perdas_min' => 30.00, 'vl_percent_perdas_max' =>  39.99, 'vl_percent_correcao' => 25.00],
                   ['id_usuario_criacao' => 2068, 'dt_criacao' => 'NOW()', 'vl_percent_perdas_min' => 40.00, 'vl_percent_perdas_max' =>  49.99, 'vl_percent_correcao' => 30.00],
                   ['id_usuario_criacao' => 2068, 'dt_criacao' => 'NOW()', 'vl_percent_perdas_min' => 50.00, 'vl_percent_perdas_max' =>  59.99, 'vl_percent_correcao' => 25.00],
                   ['id_usuario_criacao' => 2068, 'dt_criacao' => 'NOW()', 'vl_percent_perdas_min' => 60.00, 'vl_percent_perdas_max' =>  69.99, 'vl_percent_correcao' => 20.00],
                   ['id_usuario_criacao' => 2068, 'dt_criacao' => 'NOW()', 'vl_percent_perdas_min' => 70.00, 'vl_percent_perdas_max' =>  79.99, 'vl_percent_correcao' => 15.00],
                   ['id_usuario_criacao' => 2068, 'dt_criacao' => 'NOW()', 'vl_percent_perdas_min' => 80.00, 'vl_percent_perdas_max' =>  88.99, 'vl_percent_correcao' => 11.00],
                   ['id_usuario_criacao' => 2068, 'dt_criacao' => 'NOW()', 'vl_percent_perdas_min' => 89.00, 'vl_percent_perdas_max' => 100.00, 'vl_percent_correcao' =>  0.00]
        ];
        $table->insert($rows)
              ->save();
    }
}