<?php

class DataSPI2023TambahanMigration_480 extends \Phalcon\Mvc\Model\Migration {
    public function up()
    {
        $this->down();

        //Internal
        $sql = file_get_contents(__DIR__ . DIRECTORY_SEPARATOR . 'insert_spi_internal_tambahan_2023.sql');
        self::$connection->execute($sql);

        //External
        $sql = file_get_contents(__DIR__ . DIRECTORY_SEPARATOR . 'insert_spi_external_tambahan_2023.sql');
        self::$connection->execute($sql);

        //Expert
        $sql = file_get_contents(__DIR__ . DIRECTORY_SEPARATOR . 'insert_spi_expert_tambahan_2023.sql');
        self::$connection->execute($sql);
    }

    public function down()
    {
        self::$connection->execute("
            DELETE FROM jaga.spi_internal_eksternal_detail WHERE kode IN ('EXP.404','EXP.409','EXP.410','EXP.601','EXP.602','EXP.502');
            SELECT setval(pg_get_serial_sequence('spi_internal_eksternal_detail', 'id'), coalesce(max(id),0) + 1, false) FROM jaga.spi_internal_eksternal_detail;
        ");

        self::$connection->execute("
            DELETE FROM jaga.spi_internal_eksternal_detail WHERE kode IN ('EXT.401','EXT.402','EXT.403','EXT.404','EXT.405A','EXT.405B','EXT.406','EXT.407A','EXT.407B','EXT.407C','EXT.501','EXT.502','EXT.505A');
            SELECT setval(pg_get_serial_sequence('spi_internal_eksternal_detail', 'id'), coalesce(max(id),0) + 1, false) FROM jaga.spi_internal_eksternal_detail;
        ");

        self::$connection->execute("
            DELETE FROM jaga.spi_internal_eksternal_detail WHERE kode IN ('INT.401A','INT.401B','INT.403B','INT.404A','INT.404B','INT.501B','INT.501C1','INT.501C2','INT.501C3','INT.501C4','INT.501C5','INT.502A','INT.503C','INT.504A','INT.504B','INT.602C','INT.701','INT.706A','INT.706B');
            SELECT setval(pg_get_serial_sequence('spi_internal_eksternal_detail', 'id'), coalesce(max(id),0) + 1, false) FROM jaga.spi_internal_eksternal_detail;
        ");
    }
}