<?xml version="1.0" encoding="UTF-8"?>
<!--
    $Author: zhangyu  
    $Date: 2017-3-6 下午19:24:22  
    $Revision: 1.0  
    $Purpose: ABS项目统计表支付表明细
-->
<a:screen xmlns:a="http://www.leaf-framework.org/application" trace="true">
    <a:init-procedure/>
    <a:view>
        <script type="text/javascript"><![CDATA[
        	function rpt6090_project_list_query(){
        	    $('rpt6090_abs_contract_ds').query();
        	}
        	
        	function sum_foot(data, name) {
                if (name == 'contract_number') {
                    return '<font color=red>' + '合计' + '</font>';
                } else if (name == 'con_due_amount') {
                    return colum_caculateTotal(data, name);
                } else if (name == 'con_receive_amount') {
                    return colum_caculateTotal(data, name);
                } else if (name == 'remain_amount') {
                    return colum_caculateTotal(data, name);
                } else if (name == 'partial_receive_amount') {
                    return colum_caculateTotal(data, name);
                } else if (name == 'ninety_remain_amount') {
                    return colum_caculateTotal(data, name);
                } else if (name == 'over_short_amount') {
                    return colum_caculateTotal(data, name);
                } 
            
            }
            
            function colum_caculateTotal(data, name) {
                var total = 0;
                var length = data.length;
                var value = 0;
                for (var i = 0;i < length;i++) {
                    if (Ext.isEmpty(data[i].get(name))) {
                        value = 0;
                    } else {
                        value = data[i].get(name);
                    }
                    total = plus(total, value);
                }
                return '<font color=red>' + Leaf.formatMoney(total) + '</font>';
            }
            
		]]></script>
        <a:dataSets>
            <a:dataSet id="rpt6090_abs_contract_query_ds" autoCreate="true">
                <a:fields>
                    <a:field name="repayment_plan_id" defaultValue="${/parameter/@repayment_plan_id}"/>
                </a:fields>
            </a:dataSet>
            <a:dataSet id="rpt6090_abs_contract_ds" autoQuery="true" fetchAll="true" model="rpt.rpt6090.rpt6090_abs_contract" queryDataSet="rpt6090_abs_contract_query_ds" selectable="true" selectionModel="single"/>
        </a:dataSets>
        <a:screenBody>
            <a:screenTopToolbar>
                <a:screenTitle/>
            </a:screenTopToolbar>
            <a:form/>
            <a:grid id="rpt6090_abs_contract_grid_id" bindTarget="rpt6090_abs_contract_ds" marginHeight="180" marginWidth="50" navBar="true">
                <a:columns>
                    <a:column name="contract_number" align="center" prompt="支付表编号" width="120"/>
                    <a:column name="project_name" prompt="项目名称" width="240"/>
                    <a:column name="bp_name" align="center" prompt="主承租人" width="240"/>
                    <a:column name="hn_industry_classification_n" align="center" prompt="行业分类" width="120"/>
                    <a:column name="binary_classification_n" align="center" prompt="二级分类" width="120"/>
                    <a:column name="con_due_amount" align="right" footerRenderer="sum_foot" prompt="应收租金" renderer="Leaf.formatMoney" width="140"/>
                    <a:column name="con_receive_amount" align="right" footerRenderer="sum_foot" prompt="到期已偿付租金" renderer="Leaf.formatMoney" width="140"/>
                    <a:column name="over_short_amount" align="right" footerRenderer="sum_foot" prompt="差额" renderer="Leaf.formatMoney" width="100"/>
                    <a:column name="remain_amount" align="right" footerRenderer="sum_foot" prompt="到期未支付租金" renderer="Leaf.formatMoney" width="140"/>
                    <a:column name="partial_receive_amount" align="right" footerRenderer="sum_foot" prompt="违约时相应回收款" renderer="Leaf.formatMoney" width="140"/>
                    <a:column name="ninety_remain_amount" align="right" footerRenderer="sum_foot" prompt="逾期超90天未支付租金" renderer="Leaf.formatMoney" width="140"/>
                    <a:column name="employee_name" align="center" prompt="业务部门" width="100"/>
                    <a:column name="lease_organization_n" align="center" prompt="业务经理" width="100"/>
                </a:columns>
            </a:grid>
        </a:screenBody>
    </a:view>
</a:screen>