<?php

use Phalcon\Mvc\Model\Migration;

class KeluhanPendidikanMigration_578 extends Migration
{
    public function up()
    {
        self::$connection->execute("
            INSERT INTO jaga.topik_diskusi_bansos (deskripsi, type, view_order, subtype, deskripsi_en) VALUES ('Pendidikan Dasar dan Menengah - BOS', 'PENDIDIKAN', 1, NULL, 'Pendidikan Dasar dan Menengah - BOS');
            INSERT INTO jaga.topik_diskusi_bansos (deskripsi, type, view_order, subtype, deskripsi_en) VALUES ('Pendidikan Dasar dan Menengah - PIP', 'PENDIDIKAN', 2, NULL, 'Pendidikan Dasar dan Menengah - PIP');
            INSERT INTO jaga.topik_diskusi_bansos (deskripsi, type, view_order, subtype, deskripsi_en) VALUES ('Pendidikan Dasar dan Menengah - Sekolah', 'PENDIDIKAN', 3, NULL, 'Pendidikan Dasar dan Menengah - Sekolah');
            
            INSERT INTO jaga.roles(name, label, description) VALUES ('admin_keluhan_pendidikan_klop', 'Administrator KLOP Keluhan Pendidikan', 'Administrator KLOP Keluhan Pendidikan');
            INSERT INTO jaga.scopes(name, label, description) VALUES ('keluhan.pendidikan.follow_up', 'Melakukan followup keluhan Pendidikan', 'Melakukan followup keluhan Pendidikan');

            INSERT INTO jaga.roles_scopes(role_id, scope_id) values(
				(select id from jaga.roles where name = 'admin_keluhan_pendidikan_klop'), (select id from jaga.scopes where name = 'keluhan.pendidikan.follow_up') 
            );
            INSERT INTO jaga.roles_scopes(role_id, scope_id) values(
				(select id from jaga.roles where name = 'admin_keluhan_pendidikan_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_pendidikan_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_pendidikan_klop'), (select id from jaga.scopes where name = 'report.create') 
            );

            
        ");
    }

    public function down()
    {
        self::$connection->execute("
            DELETE FROM jaga.topik_diskusi_bansos WHERE deskripsi = 'Pendidikan Dasar dan Menengah - BOS' AND type = 'PENDIDIKAN';
            DELETE FROM jaga.topik_diskusi_bansos WHERE deskripsi = 'Pendidikan Dasar dan Menengah - PIP' AND type = 'PENDIDIKAN';
            DELETE FROM jaga.topik_diskusi_bansos WHERE deskripsi = 'Pendidikan Dasar dan Menengah - Sekolah' AND type = 'PENDIDIKAN';

            DELETE FROM jaga.users_roles WHERE role_id = (select id from jaga.roles where name = 'admin_keluhan_pendidikan_klop');

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

            DELETE FROM jaga.scopes WHERE name = 'keluhan.pendidikan.follow_up';
            DELETE FROM jaga.roles WHERE name = 'admin_keluhan_pendidikan_klop';
        ");
    }
}