<?php
declare(strict_types=1);

use Phinx\Migration\AbstractMigration;

final class Task2104291318 extends AbstractMigration
{
    public function up(): void
    {
        // 482936
        $delete = $this->getQueryBuilder();
        $delete->delete('sistema.agendamentos_funcionarios')
               ->where(['id_agendamento' => 191182])
               ->execute();
        $delete = $this->getQueryBuilder();
        $delete->delete('sistema.vistorias_agendamentos')
               ->where(['id_agendamento' => 191182, 'id_vistoria' => 206334])
               ->execute();
        $delete = $this->getQueryBuilder();
        $delete->delete('sistema.agendamentos')
               ->where(['id' => 191182])
               ->execute();

        // 478922
        $delete = $this->getQueryBuilder();
        $delete->delete('sistema.agendamentos_funcionarios')
               ->where(['id_agendamento' => 193604])
               ->execute();
        $delete = $this->getQueryBuilder();
        $delete->delete('sistema.vistorias_agendamentos')
               ->where(['id_agendamento' => 193604, 'id_vistoria' => 204663])
               ->execute();
        $delete = $this->getQueryBuilder();
        $delete->delete('sistema.agendamentos')
               ->where(['id' => 193604])
               ->execute();


        // REMOVER AGENDAMENTO DA PROPOSTA 485705 - PERITO anderson.trevisan
        $delete = $this->getQueryBuilder();
        $delete->delete('sistema.vistorias_agendamentos')
               ->where(['id_vistoria' => 207365])
               ->execute();
        $delete = $this->getQueryBuilder();
        $delete->delete('sistema.agendamentos_funcionarios')
               ->where(['id_agendamento' => 194900])
               ->execute();
        $delete = $this->getQueryBuilder();
        $delete->delete('sistema.agendamentos')
               ->where(['id' => 194900])
               ->execute();
    }

    public function down(): void
    {
        // 482936
        $table = $this->table('sistema.agendamentos');
        $singleRow = [
                       'id_usuario_criacao' => 1955
                     , 'dt_criacao'         => '2021-03-29 11:18:42-03'
                     , 'fl_ativo'           => 'TRUE'
                     , 'fl_del'             => 'FALSE'
                     , 'id'                 => 191182
                     , 'ds_turno'           => 'M'
                     , 'dt_agendamento'     => '2021-04-05'
                     , 'id_status'          => 202
        ];
        $table->insert($singleRow)
              ->saveData();

        $table = $this->table('sistema.agendamentos_funcionarios');
        $singleRow = [
                       'id_usuario_criacao' => 1955
                     , 'dt_criacao'         => '2021-03-29 11:18:42-03'
                     , 'fl_ativo'           => 'TRUE'
                     , 'fl_del'             => 'FALSE'
                     , 'id_agendamento'     => 191182
                     , 'id_funcionario'     => 697
        ];
        $table->insert($singleRow)
              ->saveData();
        
        $table = $this->table('sistema.vistorias_agendamentos');
        $singleRow = [
                       'id_usuario_criacao' => 1955
                     , 'dt_criacao'         => '2021-03-29 11:18:42-03'
                     , 'fl_ativo'           => 'TRUE'
                     , 'fl_del'             => 'FALSE'
                     , 'id_vistoria'        => 206334
                     , 'id_agendamento'     => 191182
        ];
        $table->insert($singleRow)
              ->saveData();
        
        // 478922
        $table = $this->table('sistema.agendamentos');
        $singleRow = [
                       'id_usuario_criacao' => 2761
                     , 'dt_criacao'         => '2021-04-19 11:59:03-03'
                     , 'fl_ativo'           => 'TRUE'
                     , 'fl_del'             => 'FALSE'
                     , 'id'                 => 193604
                     , 'ds_turno'           => 'M'
                     , 'dt_agendamento'     => '2021-04-21'
                     , 'id_status'          => 202
        ];
        $table->insert($singleRow)
              ->saveData();

        $table = $this->table('sistema.agendamentos_funcionarios');
        $singleRow = [
                       'id_usuario_criacao' => 2761
                     , 'dt_criacao'         => '2021-04-19 11:59:03-03'
                     , 'fl_ativo'           => 'TRUE'
                     , 'fl_del'             => 'FALSE'
                     , 'id_agendamento'     => 193604
                     , 'id_funcionario'     => 903
        ];
        $table->insert($singleRow)
              ->saveData();

        $table = $this->table('sistema.vistorias_agendamentos');
        $singleRow = [
                       'id_usuario_criacao' => 2761
                     , 'dt_criacao'         => '2021-04-19 11:59:03-03'
                     , 'fl_ativo'           => 'TRUE'
                     , 'fl_del'             => 'FALSE'
                     , 'id_vistoria'        => 204663
                     , 'id_agendamento'     => 193604
        ];
        $table->insert($singleRow)
              ->saveData();

        // REMOVER AGENDAMENTO DA PROPOSTA 485705
        $table = $this->table('sistema.agendamentos');
        $singleRow = [
                       'id_usuario_criacao' => 3411
                     , 'dt_criacao'         => '2021-04-29 09:26:47-03'
                     , 'fl_ativo'           => 'TRUE'
                     , 'fl_del'             => 'FALSE'
                     , 'id'                 => 194900
                     , 'ds_turno'           => 'M'
                     , 'dt_agendamento'     => '2021-04-29'
                     , 'id_status'          => 202
        ];
        $table->insert($singleRow)
              ->saveData();

        $table = $this->table('sistema.agendamentos_funcionarios');
        $singleRow = [
                       'id_usuario_criacao' => 3411
                     , 'dt_criacao'         => '2021-04-29 09:26:47-03'
                     , 'fl_ativo'           => 'TRUE'
                     , 'fl_del'             => 'FALSE'
                     , 'id_agendamento'     => 194900
                     , 'id_funcionario'     => 1059
        ];
        $table->insert($singleRow)
              ->saveData();

        $table = $this->table('sistema.vistorias_agendamentos');
        $singleRow = [
                       'id_usuario_criacao' => 3411
                     , 'dt_criacao'         => '2021-04-29 09:26:47-03'
                     , 'fl_ativo'           => 'TRUE'
                     , 'fl_del'             => 'FALSE'
                     , 'id_vistoria'        => 207365
                     , 'id_agendamento'     => 194900
        ];
        $table->insert($singleRow)
              ->saveData();        
    }
}