<?php
declare(strict_types=1);

use Phinx\Migration\AbstractMigration;

final class Task2309121636 extends AbstractMigration
{
    public function up(): void
    {
        $this->execute(<<<SQL
            INSERT INTO sistema.acao  (
                ds_label, 
                ds_module, 
                ds_controller, 
                ds_action, 
                ds_param, 
                id_parent, 
                ds_image, 
                ds_descricao, 
                fl_tipo, 
                id
            ) VALUES (
                'Ajuste de Comercialização em Lote', 
                'comercializacao', 
                'comercializacao', 
                'ajustecomercializacaolote', 
                '', 
                49, 
                '', 
                'Ajuste de Comercialização em Lote', 
                'M', 
                nextval('sistema.acao_id_seq'::regclass)
            );

            INSERT INTO sistema.roles_acao (id_role, id_acao) VALUES (4, currval('sistema.acao_id_seq'::regclass));
            INSERT INTO sistema.roles_acao (id_role, id_acao) VALUES (12, currval('sistema.acao_id_seq'::regclass));
            INSERT INTO sistema.roles_acao (id_role, id_acao) VALUES (19, currval('sistema.acao_id_seq'::regclass));
            INSERT INTO sistema.roles_acao (id_role, id_acao) VALUES (20, currval('sistema.acao_id_seq'::regclass));
            INSERT INTO sistema.roles_acao (id_role, id_acao) VALUES (26, currval('sistema.acao_id_seq'::regclass));
SQL
);
    }

    public function down(): void
    {
        $this->execute(<<<SQL
            DELETE FROM sistema.roles_acao WHERE id_acao IN (
                SELECT ID FROM sistema.acao WHERE ds_action = 'ajustecomercializacaolote' AND ds_module = 'comercializacao' AND ds_controller = 'comercializacao'
            );
            DELETE FROM sistema.acao WHERE ds_action = 'ajustecomercializacaolote' AND ds_module = 'comercializacao' AND ds_controller = 'comercializacao';
SQL
);
    }
}