<?php
declare(strict_types=1);

use Phinx\Migration\AbstractMigration;

final class Task2102191337V2 extends AbstractMigration
{
    public function up(): void
    {
        // PROPOSTA 464638
        $delete = $this->getQueryBuilder();
        $delete->delete('sistema.vistorias_agendamentos')
               ->where(['id_vistoria' => 195278, 'id_agendamento' => 178904])
               ->execute();

        $delete = $this->getQueryBuilder();
        $delete->delete('sistema.agendamentos_funcionarios')
               ->where(['id_agendamento' => 178904])
               ->execute();

        $delete = $this->getQueryBuilder();
        $delete->delete('sistema.agendamentos')
               ->where(['id' => 178904])
               ->execute();

        // PROPOSTA 428179
        $delete = $this->getQueryBuilder();
        $delete->delete('sistema.vistorias_agendamentos')
               ->where(['id_vistoria' => 193454, 'id_agendamento' => 176749])
               ->execute();

        $delete = $this->getQueryBuilder();
        $delete->delete('sistema.agendamentos_funcionarios')
               ->where(['id_agendamento' => 176749])
               ->execute();

        $delete = $this->getQueryBuilder();
        $delete->delete('sistema.agendamentos')
               ->where(['id' => 176749])
               ->execute();
    }

    public function down(): void
    {
        // PROPOSTA 464638
        $table = $this->table('sistema.agendamentos');
        $singleRow = [
                       'id_usuario_criacao' => 1826
                     , 'dt_criacao'         => '2020-11-16 20:17:42-03'
                     , 'fl_ativo'           => 'TRUE'
                     , 'fl_del'             => 'FALSE'
                     , 'id'                 => 178904
                     , 'ds_turno'           => 'M'
                     , 'dt_agendamento'     => '2020-11-22'
                     , 'id_status'          => 202
        ];
        $table->insert($singleRow)
              ->saveData();

        $table = $this->table('sistema.agendamentos_funcionarios');
        $singleRow = [
                       'id_usuario_criacao' => 1826
                     , 'dt_criacao'         => '2020-11-16 20:17:42-03'
                     , 'fl_ativo'           => 'TRUE'
                     , 'fl_del'             => 'FALSE'
                     , 'id_agendamento'     => 178904
                     , 'id_funcionario'     => 617
        ];
        $table->insert($singleRow)
              ->saveData();

        $table = $this->table('sistema.vistorias_agendamentos');
        $singleRow = [
                       'id_usuario_criacao' => 1826
                     , 'dt_criacao'         => '2020-11-16 20:17:42-03'
                     , 'fl_ativo'           => 'TRUE'
                     , 'fl_del'             => 'FALSE'
                     , 'id_vistoria'        => 195278
                     , 'id_agendamento'     => 178904
        ];
        $table->insert($singleRow)
              ->saveData();

        // PROPOSTA 428179
        $table = $this->table('sistema.agendamentos');
        $singleRow = [
                       'id_usuario_criacao' => 1531
                     , 'dt_criacao'         => '2020-11-06 17:03:43-03'
                     , 'fl_ativo'           => 'TRUE'
                     , 'fl_del'             => 'FALSE'
                     , 'id'                 => 176749
                     , 'ds_turno'           => 'M'
                     , 'dt_agendamento'     => '2020-12-01'
                     , 'id_status'          => 202
        ];
        $table->insert($singleRow)
              ->saveData();

        $table = $this->table('sistema.agendamentos_funcionarios');
        $singleRow = [
                       'id_usuario_criacao' => 1531
                     , 'dt_criacao'         => '2020-11-06 17:03:43-03'
                     , 'fl_ativo'           => 'TRUE'
                     , 'fl_del'             => 'FALSE'
                     , 'id_agendamento'     => 176749
                     , 'id_funcionario'     => 772
        ];
        $table->insert($singleRow)
              ->saveData();

        $table = $this->table('sistema.vistorias_agendamentos');
        $singleRow = [
                       'id_usuario_criacao' => 1531
                     , 'dt_criacao'         => '2020-11-06 17:03:43-03'
                     , 'fl_ativo'           => 'TRUE'
                     , 'fl_del'             => 'FALSE'
                     , 'id_vistoria'        => 193454
                     , 'id_agendamento'     => 176749
        ];
        $table->insert($singleRow)
              ->saveData();
    }
}