<?php

use Phalcon\Mvc\Model\Migration;

class AlterKorsupgahTemplateMigration_429 extends Migration {
    public function up()
    {
        self::$connection->execute("
            ALTER TABLE jaga.korsupgah_template ADD COLUMN IF NOT EXISTS view_order INTEGER;
            ALTER TABLE jaga.korsupgah_template ADD COLUMN IF NOT EXISTS is_dana_desa BOOLEAN DEFAULT false;
            UPDATE jaga.korsupgah_template SET view_order = (100 - id);

            INSERT INTO jaga.scopes(name, label, description) VALUES ('pad.answer', 'Mengisi PAD Korsupgah', 'Mengisi PAD Korsupgah');
            INSERT INTO jaga.roles(name, label, description) VALUES ('admin_klop_pad', 'Administrator KLOP untuk PAD', 'Administrator KLOP untuk PAD');
            INSERT INTO jaga.roles_scopes(role_id, scope_id) values(
				(select id from jaga.roles where name = 'admin_klop_pad'), (select id from jaga.scopes where name = 'pad.answer') 
            );

            INSERT INTO jaga.scopes(name, label, description) VALUES ('aset.answer', 'Mengisi Aset Korsupgah', 'Mengisi Aset Korsupgah');
            INSERT INTO jaga.roles(name, label, description) VALUES ('admin_klop_aset', 'Administrator KLOP untuk Aset', 'Administrator KLOP untuk Aset');
            INSERT INTO jaga.roles_scopes(role_id, scope_id) values(
				(select id from jaga.roles where name = 'admin_klop_aset'), (select id from jaga.scopes where name = 'aset.answer') 
            );
        ");
    }

    public function down()
    {
        self::$connection->execute("
            ALTER TABLE jaga.korsupgah_template DROP COLUMN IF EXISTS view_order;
            ALTER TABLE jaga.korsupgah_template DROP COLUMN IF EXISTS is_dana_desa;
            DELETE FROM jaga.roles_scopes WHERE role_id = (select id from jaga.roles where name = 'admin_klop_pad');  
            DELETE FROM jaga.scopes WHERE name = 'pad.answer';
            DELETE FROM jaga.roles WHERE name = 'admin_klop_pad';
            DELETE FROM jaga.roles_scopes WHERE role_id = (select id from jaga.roles where name = 'admin_klop_aset');  
            DELETE FROM jaga.scopes WHERE name = 'aset.answer';
            DELETE FROM jaga.roles WHERE name = 'admin_klop_aset';
        ");
    }
}