<?php
declare(strict_types=1);

use Phinx\Migration\AbstractMigration;

final class TaskSr48050 extends AbstractMigration
{
    public function up(): void
    {
        $row = $this->fetchRow('SELECT id FROM seguro.propostas WHERE id = 961944;');
        if ($row['id']) {
            $this->execute("SELECT manutencao.atualizar_status (943692, 8, 943692, NULL, FALSE, 1000111247428, NULL)");
            $this->execute("SELECT manutencao.atualizar_status (943751, 8, 943751, NULL, FALSE, 1000111247427, NULL)");
            $this->execute("SELECT manutencao.atualizar_status (943790, 8, 943790, NULL, FALSE, 1000111247425, NULL)");
            $this->execute("SELECT manutencao.atualizar_status (943846, 8, 943846, NULL, FALSE, 1000111247429, NULL)");
            $this->execute("SELECT manutencao.atualizar_status (943902, 8, 943902, NULL, FALSE, 1000111247426, NULL)");
            $this->execute("SELECT manutencao.atualizar_status (946701, 8, 946701, NULL, FALSE, 1000111247794, NULL)");
            $this->execute("SELECT manutencao.atualizar_status (948290, 8, 948290, NULL, FALSE, 1000111247797, NULL)");
            $this->execute("SELECT manutencao.atualizar_status (948649, 8, 948649, NULL, FALSE, 1000111247795, NULL)");
            $this->execute("SELECT manutencao.atualizar_status (949239, 8, 949239, NULL, FALSE, 1000111247798, NULL)");
            $this->execute("SELECT manutencao.atualizar_status (961944, 8, 961944, NULL, FALSE, 1000111247434, NULL)");
        
            $this->execute("UPDATE seguro.propostas_status SET dt_criacao = '2024-08-09 16:00:00' WHERE id_proposta = 943692 AND id_usuario_criacao = 2068 AND dt_criacao > '2024-08-09'");
            $this->execute("UPDATE seguro.propostas_status SET dt_criacao = '2024-08-09 16:00:00' WHERE id_proposta = 943751 AND id_usuario_criacao = 2068 AND dt_criacao > '2024-08-09'");
            $this->execute("UPDATE seguro.propostas_status SET dt_criacao = '2024-08-09 16:00:00' WHERE id_proposta = 943790 AND id_usuario_criacao = 2068 AND dt_criacao > '2024-08-09' AND dt_criacao < '2024-08-29'");
            $this->execute("UPDATE seguro.propostas_status SET dt_criacao = '2024-08-09 16:00:00' WHERE id_proposta = 943846 AND id_usuario_criacao = 2068 AND dt_criacao > '2024-08-09'");
            $this->execute("UPDATE seguro.propostas_status SET dt_criacao = '2024-08-09 16:10:00' WHERE id_proposta = 943902 AND id_usuario_criacao = 2068 AND dt_criacao > '2024-08-09'");
            $this->execute("UPDATE seguro.propostas_status SET dt_criacao = '2024-08-13 16:20:00' WHERE id_proposta = 946701 AND id_usuario_criacao = 2068 AND dt_criacao > '2024-08-13'");
            $this->execute("UPDATE seguro.propostas_status SET dt_criacao = '2024-08-13 16:30:00' WHERE id_proposta = 948290 AND id_usuario_criacao = 2068 AND dt_criacao > '2024-08-13'");
            $this->execute("UPDATE seguro.propostas_status SET dt_criacao = '2024-08-13 15:10:00' WHERE id_proposta = 948649 AND id_usuario_criacao = 2068 AND dt_criacao > '2024-08-13'");
            $this->execute("UPDATE seguro.propostas_status SET dt_criacao = '2024-08-13 15:10:00' WHERE id_proposta = 949239 AND id_usuario_criacao = 2068 AND dt_criacao > '2024-08-13'");
            $this->execute("UPDATE seguro.propostas_status SET dt_criacao = '2024-08-09 10:10:00' WHERE id_proposta = 961944 AND id_usuario_criacao = 2068 AND dt_criacao > '2024-08-09'");
        }
    }
        
    public function down(): void
        {
        $row = $this->fetchRow('SELECT id FROM seguro.propostas WHERE id = 961944;');
        if ($row['id']) {
            $this->execute("SELECT manutencao.atualizar_status (943692, 62, 943692, NULL, FALSE, NULL, NULL)");
            $this->execute("SELECT manutencao.atualizar_status (943751, 62, 943751, NULL, FALSE, NULL, NULL)");
            $this->execute("SELECT manutencao.atualizar_status (943790, 62, 943790, NULL, FALSE, NULL, NULL)");
            $this->execute("SELECT manutencao.atualizar_status (943846, 62, 943846, NULL, FALSE, NULL, NULL)");
            $this->execute("SELECT manutencao.atualizar_status (943902, 62, 943902, NULL, FALSE, NULL, NULL)");
            $this->execute("SELECT manutencao.atualizar_status (946701, 62, 946701, NULL, FALSE, NULL, NULL)");
            $this->execute("SELECT manutencao.atualizar_status (948290, 62, 948290, NULL, FALSE, NULL, NULL)");
            $this->execute("SELECT manutencao.atualizar_status (948649, 62, 948649, NULL, FALSE, NULL, NULL)");
            $this->execute("SELECT manutencao.atualizar_status (949239, 62, 949239, NULL, FALSE, NULL, NULL)");
            $this->execute("SELECT manutencao.atualizar_status (961944, 62, 961944, NULL, FALSE, NULL, NULL)");
        
            $this->execute("UPDATE seguro.propostas SET nr_apolice = NULL WHERE id = 943692");
            $this->execute("UPDATE seguro.propostas SET nr_apolice = NULL WHERE id = 943751");
            $this->execute("UPDATE seguro.propostas SET nr_apolice = NULL WHERE id = 943790");
            $this->execute("UPDATE seguro.propostas SET nr_apolice = NULL WHERE id = 943846");
            $this->execute("UPDATE seguro.propostas SET nr_apolice = NULL WHERE id = 943902");
            $this->execute("UPDATE seguro.propostas SET nr_apolice = NULL WHERE id = 946701");
            $this->execute("UPDATE seguro.propostas SET nr_apolice = NULL WHERE id = 948290");
            $this->execute("UPDATE seguro.propostas SET nr_apolice = NULL WHERE id = 948649");
            $this->execute("UPDATE seguro.propostas SET nr_apolice = NULL WHERE id = 949239");
            $this->execute("UPDATE seguro.propostas SET nr_apolice = NULL WHERE id = 961944");
        
            $this->execute("DELETE FROM seguro.propostas_status WHERE dt_criacao = '2024-08-09 16:00:00' AND id_proposta = 943692 AND id_usuario_criacao = 2068");
            $this->execute("DELETE FROM seguro.propostas_status WHERE dt_criacao = '2024-08-09 16:00:00' AND id_proposta = 943751 AND id_usuario_criacao = 2068");
            $this->execute("DELETE FROM seguro.propostas_status WHERE dt_criacao = '2024-08-09 16:00:00' AND id_proposta = 943790 AND id_usuario_criacao = 2068");
            $this->execute("DELETE FROM seguro.propostas_status WHERE dt_criacao = '2024-08-09 16:00:00' AND id_proposta = 943846 AND id_usuario_criacao = 2068");
            $this->execute("DELETE FROM seguro.propostas_status WHERE dt_criacao = '2024-08-09 16:10:00' AND id_proposta = 943902 AND id_usuario_criacao = 2068");
            $this->execute("DELETE FROM seguro.propostas_status WHERE dt_criacao = '2024-08-13 16:20:00' AND id_proposta = 946701 AND id_usuario_criacao = 2068");
            $this->execute("DELETE FROM seguro.propostas_status WHERE dt_criacao = '2024-08-13 16:30:00' AND id_proposta = 948290 AND id_usuario_criacao = 2068");
            $this->execute("DELETE FROM seguro.propostas_status WHERE dt_criacao = '2024-08-13 15:10:00' AND id_proposta = 948649 AND id_usuario_criacao = 2068");
            $this->execute("DELETE FROM seguro.propostas_status WHERE dt_criacao = '2024-08-13 15:10:00' AND id_proposta = 949239 AND id_usuario_criacao = 2068");
            $this->execute("DELETE FROM seguro.propostas_status WHERE dt_criacao = '2024-08-09 10:10:00' AND id_proposta = 961944 AND id_usuario_criacao = 2068");
        }
    }
}