<?php

use Phalcon\Mvc\Model\Migration;

/**
 * Class StranasViewTargetMigration_308
 */
class StranasViewTargetMigration_308 extends Migration
{
    public function up()
    {
        self::$connection->execute(
            "
            create or replace view jaga.stranas_target_instansi as 
            select a.*, b.instansi 
            from jaga.str_target a
                join (select id_target, 
                        string_agg(b.nama, ', ') as instansi
                    from jaga.str_target_master a 
                        join jaga.instansi b on b.id=a.id_instansi 
                    group by id_target
            ) b on b.id_target = a.id;
        "
        );
    }

    public function down()
    {
        self::$connection->execute("");
    }
}