<?php

use Phalcon\Mvc\Model\Migration;

class RoleScopeMigration_278 extends Migration
{

    public function up()
    {
        self::$connection->execute("
            INSERT INTO jaga.roles (name, label, description)
                VALUES ('observer_bansos_klop', 'Observer Bansos', 'Pengamat untuk Bansos') ON CONFLICT DO NOTHING;

            INSERT INTO jaga.scopes (name, label, description)
                VALUES ('bansos.follow_up_view', 'Melakukan followup data bansos', 'Melakukan followup data bansos') ON CONFLICT DO NOTHING;

            INSERT INTO jaga.roles_scopes (role_id, scope_id)
                SELECT r.id, s.id
                FROM jaga.roles r
                JOIN jaga.scopes s ON r.name = 'observer_bansos_klop' and s.name = 'bansos.follow_up_view' ON CONFLICT DO NOTHING;

            INSERT INTO jaga.roles_scopes (role_id, scope_id)
                SELECT r.id, s.id
                FROM jaga.roles r
                JOIN jaga.scopes s ON r.name = 'admin_bansos_klop' and s.name = 'bansos.follow_up_view' ON CONFLICT DO NOTHING;
        ");
    }

    /**
     * Reverse the migrations
     *
     * @return void
     */
    public function down()
    {
    }
}