<?xml version="1.0" encoding="UTF-8"?>
<!--
    $Author: weiwuzhen  
    $Date: 2016-5-5 下午4:17:45  
    $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 prf.project_id,
       prf.issue,--事项
       to_char(prf.amount,'999,999,990.99') amount,--金额(万元)
       prf.ratio||'%' ratio,--占比(%)
       (to_char(prf.loan_start_date,'yyyy')||'/'||to_char(prf.loan_start_date,'mm')||'/'||to_char(prf.loan_start_date,'dd'))||'至'||
       (to_char(prf.loan_end_date,'yyyy')||'/'||to_char(prf.loan_end_date,'mm')||'/'||to_char(prf.loan_end_date,'dd') ) loan_start_and_end_date, --贷款（或租赁）起止日期  
       prf.loan_int_rate||'%' loan_int_rate,--贷款（或租赁）利率
       prf.commitment_description--承诺到位情况
from  PRJ_RELATE_PROJECT_FINANCE_LV prf
where prf.project_id=${/parameter/@project_id}
]]></bm:query-sql>
        </bm:operation>
    </bm:operations>
</bm:model>
