<?php

use Phalcon\Mvc\Model\Migration;

class KeluhanKampusMigration_377 extends Migration
{
    public function up() {
        self::$connection->execute("
            UPDATE jaga.instansi SET nama = 'Inspektorat Jenderal Kemendikbudristek' WHERE nama = 'Irjen Kemendikbudristek RI';
            INSERT INTO jaga.instansi (nama, show_to_public, is_stranas, id_tipe, flag_dana_desa, flag_pak) VALUES ('Ditjen Pendidikan Tinggi dan Ristek', 1, 0, 3, 0, false);

            INSERT INTO jaga.scopes(name, label, description) VALUES ('keluhan.kampus.follow_up', 'Melakukan followup keluhan Kampus', 'Melakukan followup keluhan Kampus');
            INSERT INTO jaga.scopes(name, label, description) VALUES ('keluhan.kampus.monitoring', 'Melakukan monitoring keluhan Kampus', 'Melakukan monitoring keluhan Kampus');

            INSERT INTO jaga.roles(name, label, description) VALUES ('admin_keluhan_kampus_klop', 'Administrator KLOP Keluhan Kampus', 'Administrator KLOP Keluhan Kampus');
            INSERT INTO jaga.roles(name, label, description) VALUES ('observer_keluhan_kampus_klop', 'Observer KLOP Keluhan Kampus', 'Observer KLOP Keluhan Kampus');

            INSERT INTO jaga.roles_scopes(role_id, scope_id) values(
				(select id from jaga.roles where name = 'admin_keluhan_kampus_klop'), (select id from jaga.scopes where name = 'keluhan.kampus.follow_up') 
            );
            INSERT INTO jaga.roles_scopes(role_id, scope_id) values(
				(select id from jaga.roles where name = 'admin_keluhan_kampus_klop'), (select id from jaga.scopes where name = 'discussion.create') 
            );
            INSERT INTO jaga.roles_scopes(role_id, scope_id) values(
				(select id from jaga.roles where name = 'admin_keluhan_kampus_klop'), (select id from jaga.scopes where name = 'discussion.react') 
            );
            INSERT INTO jaga.roles_scopes(role_id, scope_id) values(
				(select id from jaga.roles where name = 'admin_keluhan_kampus_klop'), (select id from jaga.scopes where name = 'report.create') 
            );

            INSERT INTO jaga.roles_scopes(role_id, scope_id) values(
				(select id from jaga.roles where name = 'observer_keluhan_kampus_klop'), (select id from jaga.scopes where name = 'keluhan.kampus.monitoring') 
            );
            INSERT INTO jaga.roles_scopes(role_id, scope_id) values(
				(select id from jaga.roles where name = 'observer_keluhan_kampus_klop'), (select id from jaga.scopes where name = 'discussion.create') 
            );
            INSERT INTO jaga.roles_scopes(role_id, scope_id) values(
				(select id from jaga.roles where name = 'observer_keluhan_kampus_klop'), (select id from jaga.scopes where name = 'discussion.react') 
            );
        ");
    }

    public function down() {
        self::$connection->execute("
            UPDATE jaga.instansi SET nama = 'Irjen Kemendikbudristek RI' WHERE nama = 'Inspektorat Jenderal Kemendikbudristek';
            DELETE FROM jaga.instansi WHERE nama = 'Ditjen Pendidikan Tinggi dan Ristek';

            DELETE FROM jaga.roles_scopes WHERE 
            role_id = (select id from jaga.roles where name = 'admin_keluhan_kampus_klop');
            DELETE FROM jaga.roles_scopes WHERE 
            role_id = (select id from jaga.roles where name = 'observer_keluhan_kampus_klop');  

            DELETE FROM jaga.scopes WHERE name = 'keluhan.kampus.follow_up';
            DELETE FROM jaga.scopes WHERE name = 'keluhan.kampus.monitoring';

            DELETE FROM jaga.roles WHERE name = 'admin_keluhan_kampus_klop';
            DELETE FROM jaga.roles WHERE name = 'observer_keluhan_kampus_klop';
        ");
    }
}