<?php
declare(strict_types=1);

use Phinx\Migration\AbstractMigration;

final class TaskSr47316V2 extends AbstractMigration
{
    public function up(): void
    {
        $row = $this->fetchRow('SELECT id FROM seguro.propostas WHERE id = 927983');
        if ($row['id']) {
            $this->execute("CREATE TABLE manutencao.sr_47316_propostas_status AS SELECT * FROM seguro.propostas_status WHERE id_proposta IN (924924, 925330, 925460, 925683, 926170, 926203, 926270, 926360, 927750, 927756, 927983) AND id IN (1676818, 1676842, 1676868, 1676905, 1676623, 1676633, 1676651, 1676954, 1677036, 1677034, 1676986)");

            $this->execute("DELETE FROM seguro.propostas_status WHERE id_proposta = 924924 AND id = 1676818");
            $this->execute("DELETE FROM seguro.propostas_status WHERE id_proposta = 925330 AND id = 1676842");
            $this->execute("DELETE FROM seguro.propostas_status WHERE id_proposta = 925460 AND id = 1676868");
            $this->execute("DELETE FROM seguro.propostas_status WHERE id_proposta = 925683 AND id = 1676905");
            $this->execute("DELETE FROM seguro.propostas_status WHERE id_proposta = 926170 AND id = 1676623");
            $this->execute("DELETE FROM seguro.propostas_status WHERE id_proposta = 926203 AND id = 1676633");
            $this->execute("DELETE FROM seguro.propostas_status WHERE id_proposta = 926270 AND id = 1676651");
            $this->execute("DELETE FROM seguro.propostas_status WHERE id_proposta = 926360 AND id = 1676954");
            $this->execute("DELETE FROM seguro.propostas_status WHERE id_proposta = 927750 AND id = 1677036");
            $this->execute("DELETE FROM seguro.propostas_status WHERE id_proposta = 927756 AND id = 1677034");
            $this->execute("DELETE FROM seguro.propostas_status WHERE id_proposta = 927983 AND id = 1676986");
        }
    }

    public function down(): void
    {
        $table = $this->table('seguro.propostas_status');
        $rows = [
                   [ 'id_usuario_criacao' => 1033, 'dt_criacao' => '2024-06-14 08:30:20-03', 'id_proposta' => 924924, 'id_status' => 8, 'id' => 1676818],
                   [ 'id_usuario_criacao' => 1033, 'dt_criacao' => '2024-06-14 08:32:11-03', 'id_proposta' => 925330, 'id_status' => 8, 'id' => 1676842],
                   [ 'id_usuario_criacao' => 1033, 'dt_criacao' => '2024-06-14 08:34:24-03', 'id_proposta' => 925460, 'id_status' => 8, 'id' => 1676868],
                   [ 'id_usuario_criacao' => 1033, 'dt_criacao' => '2024-06-14 08:37:27-03', 'id_proposta' => 925683, 'id_status' => 8, 'id' => 1676905],
                   [ 'id_usuario_criacao' => 1033, 'dt_criacao' => '2024-06-14 08:16:52-03', 'id_proposta' => 926170, 'id_status' => 8, 'id' => 1676623],
                   [ 'id_usuario_criacao' => 1033, 'dt_criacao' => '2024-06-14 08:17:27-03', 'id_proposta' => 926203, 'id_status' => 8, 'id' => 1676633],
                   [ 'id_usuario_criacao' => 1033, 'dt_criacao' => '2024-06-14 08:18:29-03', 'id_proposta' => 926270, 'id_status' => 8, 'id' => 1676651],
                   [ 'id_usuario_criacao' => 1033, 'dt_criacao' => '2024-06-14 08:41:10-03', 'id_proposta' => 926360, 'id_status' => 8, 'id' => 1676954],
                   [ 'id_usuario_criacao' => 1033, 'dt_criacao' => '2024-06-14 08:50:27-03', 'id_proposta' => 927750, 'id_status' => 8, 'id' => 1677036],
                   [ 'id_usuario_criacao' => 1033, 'dt_criacao' => '2024-06-14 08:50:19-03', 'id_proposta' => 927756, 'id_status' => 8, 'id' => 1677034],
                   [ 'id_usuario_criacao' => 1033, 'dt_criacao' => '2024-06-14 08:45:53-03', 'id_proposta' => 927983, 'id_status' => 8, 'id' => 1676986]
        ];
        $table->insert($rows)
              ->save();
    }
}