<?php
declare(strict_types=1);

use Phinx\Migration\AbstractMigration;

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

            $builder = $this->getQueryBuilder();
            $builder->update('seguro.propostas_parcelas')
                    ->set('vl_total', 1033.08)
                    ->set('vl_subvencao_federal', 413.24)
                    ->set('vl_segurado', 619.84)
                    ->where(['id_proposta' => 985770, 'nr_parcela' => 5])
                    ->execute();

            
            $builder = $this->getQueryBuilder();
            $builder->update('seguro.proposta_boletos')
                    ->set('vl_total', 1033.08)
                    ->set('vl_subvencao_federal', 413.24)
                    ->set('vl_segurado', 619.84)
                    ->where(['id_proposta' => 985770, 'nr_parcela' => 5])
                    ->execute();
        }
    }

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

            $builder = $this->getQueryBuilder();
            $builder->update('seguro.propostas_parcelas')
                    ->set('vl_total', 1356.97)
                    ->set('vl_subvencao_federal', 542.79)
                    ->set('vl_segurado', 814.18)
                    ->where(['id_proposta' => 985770, 'nr_parcela' => 5])
                    ->execute();

            
            $builder = $this->getQueryBuilder();
            $builder->update('seguro.proposta_boletos')
                    ->set('vl_total', 1356.97)
                    ->set('vl_subvencao_federal', 542.79)
                    ->set('vl_segurado', 814.18)
                    ->where(['id_proposta' => 985770, 'nr_parcela' => 5])
                    ->execute();
        }
    }
}