<?php
declare(strict_types=1);

use Phinx\Migration\AbstractMigration;

final class TaskInc67297 extends AbstractMigration
{
    public function up(): void
    {
        $row = $this->fetchRow('SELECT id FROM sinistro.avisos_encerramento WHERE id = 110652');
        if ($row['id']) {           
            $builder = $this->getQueryBuilder();
            $builder->update('sinistro.processos')
                    ->set('id_proposta', 1096771)
                    ->where(['id_proposta' => 1064455, 'id' => 116914])
                    ->execute();

            $builder = $this->getQueryBuilder();
            $builder->update('sinistro.avisos')
                    ->set('id_proposta', 1096771)
                    ->where(['id_proposta' => 1064455])
                    ->whereInList('id', [155326, 156058])
                    ->execute();

            $builder = $this->getQueryBuilder();
            $builder->update('sinistro.avisos_inicio')
                    ->set('id_proposta', 1096771)
                    ->where(['id_proposta' => 1064455, "id" => 91921])
                    ->execute();

            $builder = $this->getQueryBuilder();
            $builder->update('sinistro.avisos_encerramento')
                    ->set('id_proposta', 1096771)
                    ->where(['id_proposta' => 1064455, "id" => 110652])
                    ->execute();
        }
    }

    public function down(): void
    {
        $row = $this->fetchRow('SELECT id FROM sinistro.avisos_encerramento WHERE id = 110652');
        if ($row['id']) {           
            $builder = $this->getQueryBuilder();
            $builder->update('sinistro.processos')
                    ->set('id_proposta', 1064455)
                    ->where(['id_proposta' => 1096771, 'id' => 116914])
                    ->execute();

            $builder = $this->getQueryBuilder();
            $builder->update('sinistro.avisos')
                    ->set('id_proposta', 1064455)
                    ->where(['id_proposta' => 1096771])
                    ->whereInList('id', [155326, 156058])
                    ->execute();

            $builder = $this->getQueryBuilder();
            $builder->update('sinistro.avisos_inicio')
                    ->set('id_proposta', 1064455)
                    ->where(['id_proposta' => 1096771, "id" => 91921])
                    ->execute();

            $builder = $this->getQueryBuilder();
            $builder->update('sinistro.avisos_encerramento')
                    ->set('id_proposta', 1064455)
                    ->where(['id_proposta' => 1096771, "id" => 110652])
                    ->execute();
        }
    }
}