<?xml version="1.0" encoding="UTF-8"?>
<bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm">
    <bm:operations>
        <bm:operation name="query">
            <bm:query-sql><![CDATA[
                SELECT
                    t1.description,
                    t1.user_id
                FROM
                    (select su.user_id,su.user_name,su.description
					from zj_wfl_workflow zw,
					     zj_wfl_workflow_node zwn,
					     zj_wfl_workflow_assign_rule zwr,
					     cfl_wfl_approver_group cg,
					     cfl_wf_approver_relation cr,
					     sys_user su
					where zw.workflow_code='WFL_PRJ'
					and   zw.enabled_flag='Y'
					and   zwn.workflow_id=zw.workflow_id
					and   zwn.sequence_num=10
					and   zwr.assign_source_id=zwn.node_id
					and   zwr.company_id=1
					and   cg.approver_group_code=zwr.parameter_value_code1
					and   cg.enabled_flag='Y'
					and   cr.approver_group_id=cg.approver_group_id
					and   cr.enabled_flag='Y'
					and   su.employee_id=cr.approver_employee_id
                    ) t1 #WHERE_CLAUSE#
            ]]></bm:query-sql>
        </bm:operation>
    </bm:operations>
    <bm:fields>
        <bm:field name="user_id" databaseType="number" datatype="java.lang.Long" displayWidth="200" forDisplay="true" forQuery="true" physicalName="user_id" prompt="用户ID"/>
        <bm:field name="description" databaseType="VARCHAR2" datatype="java.lang.String" displayWidth="200" forDisplay="true" forQuery="true" physicalName="description" prompt="描述"/>
    </bm:fields>
    <bm:query-fields>
        <bm:query-field field="user_id" queryOperator="like"/>
        <bm:query-field field="description" queryOperator="like"/>
    </bm:query-fields>
</bm:model>
