<?php
declare(strict_types=1);

use Phinx\Migration\AbstractMigration;

final class TaskInc53215 extends AbstractMigration
{
    public function up(): void
    {
        $row = $this->fetchRow('SELECT id FROM seguro.propostas WHERE id = 992837');
        if ($row['id']) {
            $builder = $this->getQueryBuilder();
            $builder->update('seguro.propostas_coberturas')
                    ->set('vl_premio', 4091.41)
                    ->where(['id_proposta' => 992837, 'fl_principal' => 'TRUE'])
                    ->execute();

            $builder = $this->getQueryBuilder();
            $builder->update('seguro.propostas_parcelas')
                    ->set('vl_total', 3769.44)
                    ->set('vl_subvencao_federal', 1507.77)
                    ->set('vl_segurado', 2261.67)
                    ->where(['id_proposta' => 992837, 'nr_parcela' => 2])
                    ->execute();

            
            $builder = $this->getQueryBuilder();
            $builder->update('seguro.proposta_boletos')
                    ->set('vl_total', 3769.44)
                    ->set('vl_subvencao_federal', 1507.77)
                    ->set('vl_segurado', 2261.67)
                    ->where(['id_proposta' => 992837, 'nr_parcela' => 2])
                    ->execute();
        }
    }

    public function down(): void
    {
        $row = $this->fetchRow('SELECT id FROM seguro.propostas WHERE id = 992837');
        if ($row['id']) {
            $builder = $this->getQueryBuilder();
            $builder->update('seguro.propostas_coberturas')
                    ->set('vl_premio', 4193.22)
                    ->where(['id_proposta' => 992837, 'fl_principal' => 'TRUE'])
                    ->execute();

            $builder = $this->getQueryBuilder();
            $builder->update('seguro.propostas_parcelas')
                    ->set('vl_total', 3871.25)
                    ->set('vl_subvencao_federal', 1548.50)
                    ->set('vl_segurado', 2322.75)
                    ->where(['id_proposta' => 992837, 'nr_parcela' => 2])
                    ->execute();

            
            $builder = $this->getQueryBuilder();
            $builder->update('seguro.proposta_boletos')
                    ->set('vl_total', 3871.25)
                    ->set('vl_subvencao_federal', 1548.50)
                    ->set('vl_segurado', 2322.75)
                    ->where(['id_proposta' => 992837, 'nr_parcela' => 2])
                    ->execute();
        }
    }
}