select: 
        select m.pravrepid, m.menuid, m.username, m.r, m.w, m.i, m.d, m.c, 
        m.exp, m.imp, m.settable, m.cutpast, m.enable, m.magazinsid, m.del,
        m.active, m.createuser, m.createdate, m.updateuser, m.updatedate, m.order_ins,
        m.roleid, r.rolename from k2admin_menus_prava m

        left join k2roles r
        on m.roleid = r.roleid
               
table: k2admin_menus_prava
sortname: pravrepid
typeid: 1
                
height: 590
                
where: " WHERE (menuid='{masterid}') "
getmaster: true  
masterid: menuid
                
sortorder: asc
caption: Права
fields:
    pravrepid:
        field: pravrepid
        alias: m.pravrepid
        caption: ID
        width: 40
        readonly: true
        align: left
        hidden: true
        primary_key: true

    roleid:                
        field: roleid
        alias: m.roleid
        caption: ID ролі
        width: 200
        readonly: false
        align: left
        type_field: DropDown
        multy: false
        hidden: true
        sql: 
            select roleid as k, rolename as v
            from k2roles
            order by rolename

    rolename:
        field: rolename
        caption: Права
        alias: r.rolename

    username:                
        field: username
        alias: m.username
        caption: Пользователь
        width: 150
        readonly: false
        align: left
                    
    r:    
        field: r
        alias: m.r
        caption: Чтение
        width: 50
        readonly: false
        align: center
        type_field: checkbox
        def_value: 1
                    
    w:    
        field: w
        alias: m.w
        caption: Запись
        width: 50
        readonly: false
        align: center
        type_field: checkbox
        def_value: 1
                    
    i:    
        field: i
        alias: m.i
        caption: Вставка
        width: 50
        readonly: false
        align: center
        type_field: checkbox
        def_value: 1
                    
    d:    
        field: d
        alias: m.d
        caption: Удаление
        width: 50
        readonly: false
        align: center
        type_field: checkbox
        def_value: 1
                    
    c:    
        field: c
        alias: m.c
        caption: Копирование
        width: 50
        readonly: false
        align: center
        type_field: checkbox
        def_value: 0
                    
    exp:    
        field: exp
        alias: m.exp
        caption: Экспорт
        width: 50
        readonly: false
        align: center
        type_field: checkbox
        def_value: 0
                    
    imp:    
        field: imp
        alias: m.imp
        caption: Импорт
        width: 50
        readonly: false
        align: center
        type_field: checkbox
        def_value: 0
                    
    settable:    
        field: settable
        alias: m.settable
        caption: "Настройка<br>таблиц"
        width: 50
        readonly: false
        align: center
        type_field: checkbox
        def_value: 1
                    
    cutpast:    
        field: cutpast
        alias: m.cutpast
        caption: "Копирование<br>в буфер"
        width: 50
        readonly: false
        align: center
        type_field: checkbox
        def_value: 1
                    
    enable:    
        field: enable
        alias: m.enable
        caption: "Активность<br>элементов"
        width: 50
        readonly: false
        align: center
        type_field: checkbox
        def_value: 1
                    
    active:    
        field: active
        alias: m.active
        caption: Акт.
        width: 50
        readonly: false
        align: left
        type_field: checkbox
        def_value: 1
                    
    del:    
        field: del
        alias: m.del
        caption: Удал.
        width: 50
        readonly: false
        align: left
        type_field: checkbox
        def_value: 0
        hidden: true