<?xml version="1.0" encoding="UTF-8"?>
<!--
    $Author: WHT  
    $Date: 2011-7-28 上午09:42:06  
    $Revision: 1.0  
    $Purpose: 
-->
<ns1:model xmlns:ns1="http://www.leaf-framework.org/schema/bm" alias="t1" extend="zjwfl.zj_wfl_users_v" extendMode="reference" needAccessControl="false">
    <ns1:fields>
        <ns1:field name="user_id"/>
        <ns1:field name="user_name" databaseType="VARCHAR2" datatype="java.lang.String" forDisplay="true" forQuery="true" prompt="用户代码"/>
        <ns1:field name="employee_id"/>
        <ns1:field name="employee_name" databaseType="VARCHAR2" datatype="java.lang.String" forDisplay="true" forQuery="true" prompt="用户姓名"/>
        <ns1:field name="email" forDisplay="true" prompt="邮箱"/>
        <ns1:field name="mobil" forDisplay="true" prompt="号码"/>
        <ns1:field name="role_admin_amount" expression="(select count(1) from SYS_USER_ROLE_GROUPS_VL t where t.enabled_flag = &apos;Y&apos; and t.role_code in (&apos;0017&apos;,&apos;HAND&apos;) and t.user_id = t1.user_id and t.role_id = ${/session/@role_id})"/>
    </ns1:fields>
    <ns1:query-fields>
        <ns1:query-field field="user_name" queryOperator="like"/>
        <ns1:query-field field="employee_name" queryOperator="like"/>
        <ns1:query-field field="user_id" queryOperator="="/>
        <ns1:query-field field="employee_id" queryOperator="="/>
    </ns1:query-fields>
</ns1:model>
