<?php

use Phalcon\Mvc\Model\Migration;

class UpdateSPIMDDMigration_491 extends Migration {
    public function up()
    {
        self::$connection->execute("
            UPDATE jaga.spi_hasil_klpd SET code_klpd = '20407' WHERE code_klpd = '20069';
            UPDATE jaga.spi_hasil_klpd SET code_klpd = '20408' WHERE code_klpd = '20070';
            UPDATE jaga.spi_hasil_klpd SET code_klpd = '20409' WHERE code_klpd = '20084';

            UPDATE jaga.spi_internal_eksternal SET id_instansi = '20407' WHERE id_instansi = '20069';
            UPDATE jaga.spi_internal_eksternal SET id_instansi = '20408' WHERE id_instansi = '20070';
            UPDATE jaga.spi_internal_eksternal SET id_instansi = '20409' WHERE id_instansi = '20084';

            UPDATE jaga.spi_internal_eksternal_header SET id_instansi = '20407' WHERE id_instansi = '20069';
            UPDATE jaga.spi_internal_eksternal_header SET id_instansi = '20408' WHERE id_instansi = '20070';
            UPDATE jaga.spi_internal_eksternal_header SET id_instansi = '20409' WHERE id_instansi = '20084';

            UPDATE jaga.spi_internal_eksternal_detail SET id_instansi = '20407' WHERE id_instansi = '20069';
            UPDATE jaga.spi_internal_eksternal_detail SET id_instansi = '20408' WHERE id_instansi = '20070';
            UPDATE jaga.spi_internal_eksternal_detail SET id_instansi = '20409' WHERE id_instansi = '20084';

            UPDATE jaga.spi_internal_eksternal_opd_header SET id_instansi = '20407' WHERE id_instansi = '20069';
            UPDATE jaga.spi_internal_eksternal_opd_header SET id_instansi = '20408' WHERE id_instansi = '20070';
            UPDATE jaga.spi_internal_eksternal_opd_header SET id_instansi = '20409' WHERE id_instansi = '20084';

            UPDATE jaga.spi_internal_opd_detail SET id_instansi = '20407' WHERE id_instansi = '20069';
            UPDATE jaga.spi_internal_opd_detail SET id_instansi = '20408' WHERE id_instansi = '20070';
            UPDATE jaga.spi_internal_opd_detail SET id_instansi = '20409' WHERE id_instansi = '20084';

            UPDATE jaga.spi_external_opd_detail SET id_instansi = '20407' WHERE id_instansi = '20069';
            UPDATE jaga.spi_external_opd_detail SET id_instansi = '20408' WHERE id_instansi = '20070';
            UPDATE jaga.spi_external_opd_detail SET id_instansi = '20409' WHERE id_instansi = '20084';

            UPDATE jaga.spi_expert_opd_detail SET id_instansi = '20407' WHERE id_instansi = '20069';
            UPDATE jaga.spi_expert_opd_detail SET id_instansi = '20408' WHERE id_instansi = '20070';
            UPDATE jaga.spi_expert_opd_detail SET id_instansi = '20409' WHERE id_instansi = '20084';

            UPDATE jaga.spi_bidang_expert SET id_instansi = '20407' WHERE id_instansi = '20069';
            UPDATE jaga.spi_bidang_expert SET id_instansi = '20408' WHERE id_instansi = '20070';
            UPDATE jaga.spi_bidang_expert SET id_instansi = '20409' WHERE id_instansi = '20084';

            UPDATE jaga.spi_internal_eksternal_opd_header SET opd = 'LAINNYA' WHERE id_instansi = 20103 AND opd ILIKE '%http%';

            UPDATE jaga.spi_hasil_klpd SET code_klpd = '20410' WHERE code_klpd = '20044' AND tahun = '2021';
            UPDATE jaga.spi_hasil_klpd SET nama_klpd = 'Kementerian Riset dan Teknologi' WHERE code_klpd = '20033' AND tahun = '2021';
            UPDATE jaga.spi_hasil_klpd SET code_klpd = '20044', nama_klpd = 'Badan Riset dan Inovasi Nasional' WHERE code_klpd = '20033' AND (tahun = '2022' OR tahun = '2023');

            UPDATE jaga.spi_internal_eksternal SET id_instansi = 20410 WHERE id_instansi = 20044 AND tahun = '2021';
            UPDATE jaga.spi_internal_eksternal SET nama_instansi = 'Kementerian Riset dan Teknologi' WHERE id_instansi = 20033 AND tahun = '2021';
            UPDATE jaga.spi_internal_eksternal SET id_instansi = 20044, nama_instansi = 'Badan Riset dan Inovasi Nasional' WHERE id_instansi = 20033 AND (tahun = '2022' OR tahun = '2023');

            UPDATE jaga.spi_internal_eksternal_header SET nama_instansi = 'Kementerian Riset dan Teknologi' WHERE id_instansi = 20033 AND tahun = '2021';
            UPDATE jaga.spi_internal_eksternal_header SET id_instansi = 20044, nama_instansi = 'Badan Riset dan Inovasi Nasional' WHERE id_instansi = 20033 AND (tahun = '2022' OR tahun = '2023');

            UPDATE jaga.spi_internal_eksternal_detail SET id_instansi = 20044 WHERE id_instansi = 20033;
            UPDATE jaga.spi_internal_eksternal_detail SET nama_instansi = 'BADAN RISET DAN INOVASI NASIONAL' WHERE id_instansi = 20044;

            UPDATE jaga.spi_internal_eksternal_opd_header SET id_instansi = 20044, nama_instansi = 'BADAN RISET DAN INOVASI NASIONAL' WHERE id_instansi = 20033;

            UPDATE jaga.spi_internal_opd_detail SET id_instansi = 20044, nama_instansi = 'BADAN RISET DAN INOVASI NASIONAL' WHERE id_instansi = 20033;
            UPDATE jaga.spi_external_opd_detail SET id_instansi = 20044, nama_instansi = 'BADAN RISET DAN INOVASI NASIONAL' WHERE id_instansi = 20033;
            UPDATE jaga.spi_expert_opd_detail SET id_instansi = 20044, nama_instansi = 'BADAN RISET DAN INOVASI NASIONAL' WHERE id_instansi = 20033;

            UPDATE jaga.spi_bidang_expert SET id_instansi = 20044, nama_instansi = 'BADAN RISET DAN INOVASI NASIONAL' WHERE id_instansi = 20033;

            UPDATE jaga.instansi SET kelompok_anggaran = 'C', nama_kelompok_anggaran = 'Anggaran Kecil, Jumlah Pegawai Kecil' WHERE id = 20410;
            UPDATE jaga.instansi SET kelompok_anggaran = 'C', nama_kelompok_anggaran = 'Anggaran Kecil, Jumlah Pegawai Kecil' WHERE id = 20407;
            UPDATE jaga.instansi SET kelompok_anggaran = 'B', nama_kelompok_anggaran = 'Anggaran Sedang, Jumlah Pegawai Sedang' WHERE id = 20408;
            UPDATE jaga.instansi SET kelompok_anggaran = 'C', nama_kelompok_anggaran = 'Anggaran Kecil, Jumlah Pegawai Kecil' WHERE id = 20409;
            
        ");
    }

    public function down()
    {
        self::$connection->execute("
            UPDATE jaga.spi_hasil_klpd SET code_klpd = '20069' WHERE code_klpd = '20407';
            UPDATE jaga.spi_hasil_klpd SET code_klpd = '20070' WHERE code_klpd = '20408';
            UPDATE jaga.spi_hasil_klpd SET code_klpd = '20084' WHERE code_klpd = '20409';

            UPDATE jaga.spi_internal_eksternal SET id_instansi = '20069' WHERE id_instansi = '20407';
            UPDATE jaga.spi_internal_eksternal SET id_instansi = '20070' WHERE id_instansi = '20408';
            UPDATE jaga.spi_internal_eksternal SET id_instansi = '20084' WHERE id_instansi = '20409';

            UPDATE jaga.spi_internal_eksternal_header SET id_instansi = '20069' WHERE id_instansi = '20407';
            UPDATE jaga.spi_internal_eksternal_header SET id_instansi = '20070' WHERE id_instansi = '20408';
            UPDATE jaga.spi_internal_eksternal_header SET id_instansi = '20084' WHERE id_instansi = '20409';

            UPDATE jaga.spi_internal_eksternal_detail SET id_instansi = '20069' WHERE id_instansi = '20407';
            UPDATE jaga.spi_internal_eksternal_detail SET id_instansi = '20070' WHERE id_instansi = '20408';
            UPDATE jaga.spi_internal_eksternal_detail SET id_instansi = '20084' WHERE id_instansi = '20409';

            UPDATE jaga.spi_internal_eksternal_opd_header SET id_instansi = '20069' WHERE id_instansi = '20407';
            UPDATE jaga.spi_internal_eksternal_opd_header SET id_instansi = '20070' WHERE id_instansi = '20408';
            UPDATE jaga.spi_internal_eksternal_opd_header SET id_instansi = '20084' WHERE id_instansi = '20409';

            UPDATE jaga.spi_internal_opd_detail SET id_instansi = '20069' WHERE id_instansi = '20407';
            UPDATE jaga.spi_internal_opd_detail SET id_instansi = '20070' WHERE id_instansi = '20408';
            UPDATE jaga.spi_internal_opd_detail SET id_instansi = '20084' WHERE id_instansi = '20409';

            UPDATE jaga.spi_external_opd_detail SET id_instansi = '20069' WHERE id_instansi = '20407';
            UPDATE jaga.spi_external_opd_detail SET id_instansi = '20070' WHERE id_instansi = '20408';
            UPDATE jaga.spi_external_opd_detail SET id_instansi = '20084' WHERE id_instansi = '20409';

            UPDATE jaga.spi_expert_opd_detail SET id_instansi = '20069' WHERE id_instansi = '20407';
            UPDATE jaga.spi_expert_opd_detail SET id_instansi = '20070' WHERE id_instansi = '20408';
            UPDATE jaga.spi_expert_opd_detail SET id_instansi = '20084' WHERE id_instansi = '20409';

            UPDATE jaga.spi_bidang_expert SET id_instansi = '20069' WHERE id_instansi = '20407';
            UPDATE jaga.spi_bidang_expert SET id_instansi = '20070' WHERE id_instansi = '20408';
            UPDATE jaga.spi_bidang_expert SET id_instansi = '20084' WHERE id_instansi = '20409';

            UPDATE jaga.spi_hasil_klpd SET code_klpd = '20044' WHERE code_klpd = '20410' AND tahun = '2021';
            UPDATE jaga.spi_hasil_klpd SET nama_klpd = 'Kementerian Riset dan Teknologi/BRIN' WHERE code_klpd = '20033' AND tahun = '2021';
            UPDATE jaga.spi_hasil_klpd SET code_klpd = '20033', nama_klpd = 'Kementerian Riset dan Teknologi (BRIN)' WHERE code_klpd = '20044' AND (tahun = '2022' OR tahun = '2023');

            UPDATE jaga.spi_internal_eksternal SET id_instansi = 20044 WHERE id_instansi = 20410 AND tahun = '2021';
            UPDATE jaga.spi_internal_eksternal SET nama_instansi = 'Kementerian Riset dan Teknologi (BRIN)' WHERE id_instansi = 20033 AND tahun = '2021';
            UPDATE jaga.spi_internal_eksternal SET id_instansi = 20033, nama_instansi = 'Kementerian Riset dan Teknologi (BRIN)' WHERE id_instansi = 20044 AND (tahun = '2022' OR tahun = '2023');

            UPDATE jaga.spi_internal_eksternal_header SET nama_instansi = 'Kementerian Riset dan Teknologi (BRIN)' WHERE id_instansi = 20033 AND tahun = '2021';
            UPDATE jaga.spi_internal_eksternal_header SET id_instansi = 20033, nama_instansi = 'Kementerian Riset dan Teknologi (BRIN)' WHERE id_instansi = 20044 AND (tahun = '2022' OR tahun = '2023');
        ");
    }
}