<?xml version="1.0" encoding="UTF-8"?>
<!--
    $Author: wangwei  
    $Date: 2016-1-6 上午10:41:07  
    $Revision: 1.0  
    $Purpose: 
-->
<bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm">
    <bm:operations>
        <bm:operation name="query">
            <bm:query-sql><![CDATA[
            select
   su.employee_id,
ee.name employee_id_n,
ea.unit_id,
ea.unit_name unit_id_n,
(select ea1.employee_id from exp_emp_assign_e_v ea1 where ea1.position_id=p.parent_position_id) EMPLOYEE_ID_OF_MANAGER,
(select ea1.employee_name from exp_emp_assign_e_v ea1 where ea1.position_id=p.parent_position_id
) EMPLOYEE_ID_OF_MANAGER_n
 from sys_user su,exp_employees ee,
 exp_emp_assign_e_v ea,
 exp_org_position p
 where su.frozen_flag='N'
 and ee.employee_id=su.employee_id
 and ee.employee_id=ea.employee_id
 and ea.primary_position_flag='Y'
 and p.position_id=ea.position_id
 and p.enabled_flag='Y'
 and su.user_id=${/session/@user_id}
 ]]></bm:query-sql>
        </bm:operation>
    </bm:operations>
</bm:model>
