<?php
declare(strict_types=1);

use Phinx\Migration\AbstractMigration;

final class Task2307262001 extends AbstractMigration
{
    public function up(): void
    {
        $this->execute(<<<SQL
            -- AGENDADA
            UPDATE seguro.propostas_vistorias_previas_historico SET id_status = 202
            WHERE 
                id_status = 71
                AND dt_criacao >= '2023-07-17 00:00:00-03'
                AND ds_motivo like 'Agendamento para o dia%';

            -- ENCAMINHADA
            UPDATE seguro.propostas_vistorias_previas_historico pvph1 SET id_status = 66
            FROM (
                SELECT
                    id, min(dt_criacao)
                FROM 
                    seguro.propostas_vistorias_previas_historico
                WHERE 
                    id_status = 71
                    AND dt_criacao >= '2023-07-17 00:00:00-03'
                GROUP BY 
                    id_proposta_vistoria,
                    id
            ) AS pvph2
            WHERE 
                pvph2.id = pvph1.id
SQL
);
    }

    public function down(): void
    {
    }
}
