<?php

use Phalcon\Mvc\Model\Migration;

class RoleScopeMigration_325 extends Migration
{

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

            INSERT INTO jaga.roles (name, label, description)
                VALUES ('reporter_bpkad', 'Reporter BPKAD', 'Pelapor untuk BPKAD') ON CONFLICT DO NOTHING;

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

            INSERT INTO jaga.scopes (name, label, description)
                VALUES ('bpkad.submit', 'Melakukan submit data bpkad', 'Melakukan submit data bpkad') 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_bpkad' and s.name = 'bpkad.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 = 'reporter_bpkad' and s.name = 'bpkad.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 = 'reporter_bpkad' and s.name = 'bpkad.submit' ON CONFLICT DO NOTHING;
        ");
    }

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