<?php

use Phalcon\Mvc\Model\Migration;

class ViewSysUserMigration_296 extends Migration
{
    public function up()
    {
        $this->down(); 

        self::$connection->execute("
            CREATE OR REPLACE VIEW web.view_sys_users
            AS
            SELECT sys_users.user_id,
                um_user.um_user_name AS user_username,
                um_user.um_user_password AS user_password,
                um_user.nama AS user_fullname,
                sys_users.user_image_path,
                sys_users.user_is_partner,
                sys_users.user_access_id,
                sys_accesses.access_name AS user_access_name,
                sys_users.user_status,
                sys_accesses.access_status AS user_access_status
            FROM web.sys_users
                JOIN web.sys_accesses ON sys_accesses.access_id = sys_users.user_access_id AND sys_accesses.access_log_id IS NULL
                JOIN jaga.um_user ON jaga.um_user.um_id = sys_users.user_um_id
            WHERE sys_users.user_log_id IS NULL;
        ");
    }

    public function down()
    {
        
    }
}