<?php
declare(strict_types=1);

use Phinx\Migration\AbstractMigration;

final class Task2209281126 extends AbstractMigration
{
    public function up(): void
    {
        $this->execute(<<<SQL
INSERT INTO sinistro.avisos_log_mudanca_status
     SELECT 3379 as id_usuario_criacao,
            null as id_usuario_alteracao,
            now() as dt_criacao,
            null as dt_alteracao,
            't' as fl_ativo,
            'f' as fl_del,
            nextval('sinistro.avisos_log_mudanca_status_id_seq'::regclass) as id,
            id as id_aviso,
            'Cancelamento a pedido do corretor.' as ds_motivo,
            id_status as id_status_antigo,
            168 as id_status_novo
      FROM sinistro.avisos
     WHERE id in(120084, 120600, 121326, 120819);

UPDATE sinistro.avisos
   SET id_status = 168
 WHERE id in(120084, 120600, 121326, 120819);
SQL
);
    }

    public function down(): void
    {
        $this->execute(<<<SQL
DELETE FROM sinistro.avisos_log_mudanca_status WHERE id_aviso in(120084, 120600, 121326, 120819) AND id_status_novo = 168;
UPDATE sinistro.avisos
   SET id_status = 27
 WHERE id in(120084, 120600, 121326, 120819);
SQL
);
    }
}