project_wfl_info.lwm 1.47 KB
Newer Older
Spencer Chang's avatar
Spencer Chang committed
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 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43
<?xml version="1.0" encoding="UTF-8"?>
<!--
    $Author: WangYu  
    $Date: 2015-5-7 下午04:19:55  
    $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 pp.project_number,--项目编号
            pp.project_id,
            pp.document_category,
            pp.document_type,
            pp.company_id,
            pp.number_of_tenant,
            pp.number_of_guarantor,
            pp.number_of_actual_controller,
            pp.cdd_list_id,
            pp.declare_flag,
pp.project_name,--项目名称
pp.business_type,
pp.business_type_n,--项目类型
pp.bp_name,--承租人名称
pp.Lease_Item_Short_Name, --租赁物
pp.company_nature_n, --公司简称
pp.employee_id_n,--项目经理
pp.lease_organization_n,--业务部
pp.annual_pay_times_n,--支付频率
pp.lease_times,--支付期数
pp.finance_amount,--融资额
pp.currency_n,--币种
pp.creation_date,--立项时间
pp.submit_date, --报审时间
(select ee.name from exp_employees ee where ee.employee_id = (select su.employee_id from sys_user su where su.user_id = ${/session/@user_id})) examinant --审查人
 from prj_project_lv pp
 #WHERE_CLAUSE#]]></bm:query-sql>
        </bm:operation>
    </bm:operations>
    <bm:query-fields>
        <bm:query-field name="project_id" queryExpression="pp.project_id=${@project_id}"/>
    </bm:query-fields>
</bm:model>