<?php

use Phalcon\Mvc\Model\Migration;

class PerguruanTinggiMigration_374 extends Migration
{
    public function up() {
        self::$connection->execute("
            SELECT setval('jaga.instansi_id_seq', COALESCE((SELECT MAX(id)+1 FROM jaga.instansi), 1), false);
        ");

        self::$connection->execute("
            INSERT INTO jaga.topik_diskusi_bansos (deskripsi, type, view_order) VALUES ('Kampus - Penerimaan Mahasiswa Baru', 'KAMPUS', 1);
            INSERT INTO jaga.topik_diskusi_bansos (deskripsi, type, view_order) VALUES ('Kampus - Program Indonesia Pintar', 'KAMPUS', 2);
            INSERT INTO jaga.topik_diskusi_bansos (deskripsi, type, view_order) VALUES ('Kampus - Dugaan Korupsi di Perguruan Tinggi', 'KAMPUS', 3);
            INSERT INTO jaga.topik_diskusi_bansos (deskripsi, type, view_order) VALUES ('Kampus - Lainnya', 'KAMPUS', 4);
            INSERT INTO jaga.instansi_tipe (nama, stranas_filter) VALUES ('Perguruan Tinggi', false);
        ");

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

    public function down() {
        self::$connection->execute("
            DELETE FROM jaga.topik_diskusi_bansos WHERE type = 'KAMPUS';
            SELECT setval('jaga.topik_diskusi_bansos_id_seq', COALESCE((SELECT MAX(id)+1 FROM jaga.topik_diskusi_bansos), 1), false);

            DELETE FROM jaga.instansi WHERE id_tipe = (SELECT id FROM jaga.instansi_tipe WHERE nama = 'Perguruan Tinggi');
            SELECT setval('jaga.instansi_id_seq', COALESCE((SELECT MAX(id)+1 FROM jaga.instansi), 1), false);

            DELETE FROM jaga.instansi_tipe WHERE nama = 'Perguruan Tinggi';
            SELECT setval('jaga.instansi_tipe_id_seq', COALESCE((SELECT MAX(id)+1 FROM jaga.instansi_tipe), 1), false);
        ");
    }
}