<?php
declare(strict_types=1);

use Phinx\Migration\AbstractMigration;

final class Task2307191732 extends AbstractMigration
{
    public function up(): void
    {
        $this->execute(<<<SQL
            INSERT INTO sistema.acao (ds_label, ds_module, ds_controller, ds_action, id_parent, ds_descricao, fl_tipo, dt_criacao, id_usuario_criacao) 
                VALUES ('Habilitar nova vistoria para essa quadra', 'seguro', 'vistoriapreviaempresa', 'habilitarnovavistoriaquadra', 571, 'Habilitar nova vistoria para essa quadra', 'A', now(), 3379);

            INSERT INTO sistema.usuarios_acao (id_usuario_criacao, dt_criacao, id_usuario, id_acao)
                VALUES (2068, now(), (SELECT id FROM sistema.usuarios WHERE ds_nome_usuario = 'karina.silva'), (SELECT id FROM sistema.acao WHERE ds_controller = 'vistoriapreviaempresa' AND ds_action = 'habilitarnovavistoriaquadra')),
                       (2068, now(), (SELECT id FROM sistema.usuarios WHERE ds_nome_usuario = 'karina.figueiro'), (SELECT id FROM sistema.acao WHERE ds_controller = 'vistoriapreviaempresa' AND ds_action = 'habilitarnovavistoriaquadra')),
                       (2068, now(), (SELECT id FROM sistema.usuarios WHERE ds_nome_usuario = 'luana.beck'), (SELECT id FROM sistema.acao WHERE ds_controller = 'vistoriapreviaempresa' AND ds_action = 'habilitarnovavistoriaquadra')),
                       (2068, now(), (SELECT id FROM sistema.usuarios WHERE ds_nome_usuario = 'danielle.goncalves'), (SELECT id FROM sistema.acao WHERE ds_controller = 'vistoriapreviaempresa' AND ds_action = 'habilitarnovavistoriaquadra')),
                       (2068, now(), (SELECT id FROM sistema.usuarios WHERE ds_nome_usuario = 'angelo.silva'), (SELECT id FROM sistema.acao WHERE ds_controller = 'vistoriapreviaempresa' AND ds_action = 'habilitarnovavistoriaquadra')),
                       (2068, now(), (SELECT id FROM sistema.usuarios WHERE ds_nome_usuario = 'aimee.malfatti'), (SELECT id FROM sistema.acao WHERE ds_controller = 'vistoriapreviaempresa' AND ds_action = 'habilitarnovavistoriaquadra'));


            INSERT INTO sistema.acao (ds_label, ds_module, ds_controller, ds_action, id_parent, ds_descricao, fl_tipo, dt_criacao, id_usuario_criacao) 
                VALUES ('Alterar Status de Análise na listagem', 'seguro', 'vistoriapreviaempresa', 'alterarstatusanaliselist', 571, 'Alterar Status de Análise na listagem', 'A', now(), 3379);
                
            INSERT INTO sistema.usuarios_acao (id_usuario_criacao, dt_criacao, id_usuario, id_acao)
                VALUES (2068, now(), (SELECT id FROM sistema.usuarios WHERE ds_nome_usuario = 'karina.silva'), (SELECT id FROM sistema.acao WHERE ds_controller = 'vistoriapreviaempresa' AND ds_action = 'alterarstatusanaliselist')), 
                       (2068, now(), (SELECT id FROM sistema.usuarios WHERE ds_nome_usuario = 'luana.beck'), (SELECT id FROM sistema.acao WHERE ds_controller = 'vistoriapreviaempresa' AND ds_action = 'alterarstatusanaliselist')), 
                       (2068, now(), (SELECT id FROM sistema.usuarios WHERE ds_nome_usuario = 'karina.figueiro'), (SELECT id FROM sistema.acao WHERE ds_controller = 'vistoriapreviaempresa' AND ds_action = 'alterarstatusanaliselist')), 
                       (2068, now(), (SELECT id FROM sistema.usuarios WHERE ds_nome_usuario = 'danielle.goncalves'), (SELECT id FROM sistema.acao WHERE ds_controller = 'vistoriapreviaempresa' AND ds_action = 'alterarstatusanaliselist')), 
                       (2068, now(), (SELECT id FROM sistema.usuarios WHERE ds_nome_usuario = 'angelo.silva'), (SELECT id FROM sistema.acao WHERE ds_controller = 'vistoriapreviaempresa' AND ds_action = 'alterarstatusanaliselist')), 
                       (2068, now(), (SELECT id FROM sistema.usuarios WHERE ds_nome_usuario = 'aimee.malfatti'), (SELECT id FROM sistema.acao WHERE ds_controller = 'vistoriapreviaempresa' AND ds_action = 'alterarstatusanaliselist'));
SQL
        );
    }

    public function down(): void
    {
        $this->execute(<<<SQL

        DELETE FROM sistema.usuarios_acao WHERE id_acao = (SELECT id FROM sistema.acao WHERE ds_controller = 'vistoriapreviaempresa' AND ds_action = 'alterarstatusanaliselist');
        DELETE FROM sistema.acao WHERE ds_controller = 'vistoriapreviaempresa' AND ds_action = 'alterarstatusanaliselist';

        DELETE FROM sistema.usuarios_acao WHERE id_acao = (SELECT id FROM sistema.acao WHERE ds_controller = 'vistoriapreviaempresa' AND ds_action = 'habilitarnovavistoriaquadra');
        DELETE FROM sistema.acao WHERE ds_controller = 'vistoriapreviaempresa' AND ds_action = 'habilitarnovavistoriaquadra';
SQL
        );
    }
}