get_current_seq.lwm 1.03 KB
Newer Older
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26
<?xml version="1.0" encoding="UTF-8"?>
<!--
    $Author: Feng  
    $Date: 2013-9-24 下午2:19:04  
    $Revision: 1.0  
    $Purpose: 
-->
<bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm" needAccessControl="false">
    <bm:operations>
        <bm:operation name="query">
            <bm:query-sql><![CDATA[
            SELECT (select count(1)
                      from exp_org_position_vl ep, exp_employee_assigns ea
                     where ea.employee_id = t.employee_id
                       and ea.position_id = ep.POSITION_ID
                       and ep.POSITION_CODE = '012') position_012_flag,
                   (select zi.current_seq
                      from zj_wfl_workflow_instance zi, csh_transaction_return cr
                     where zi.instance_id = cr.wfl_instance_id
                       and cr.return_id =${/parameter/@return_id}) current_seq
              FROM sys_user t
             where t.user_id = ${/session/@user_id}
            ]]></bm:query-sql>
        </bm:operation>
    </bm:operations>
</bm:model>