<?xml version="1.0" encoding="UTF-8"?>
<!--
    $Author: wangwei  
    $Date: 2016-1-19 上午11:33:21  
    $Revision: 1.0  
    $Purpose: 
-->
<a:screen xmlns:a="http://www.leaf-framework.org/application" customizationEnabled="true" trace="true">
    <a:init-procedure>
        <a:model-query defaultWhereClause="t1.enabled_flag=&apos;Y&apos;" fetchAll="true" model="basic.gld_currency_v" rootPath="currency_path"/>
    </a:init-procedure>
    <a:view>
        <a:link id="con_contract_get_layout_code_link_id" model="cont.CON500.con_contract_get_layout_code" modelaction="update"/>
        <a:link id="tre_factoring_contract_modify_detail_link_id" url="${/request/@context_path}/modules/tre/tre503/tre_factoring_contract_add.lview"/>
        <a:link id="tre_loan_contract_withdraw_query_detail_link_id" url="${/request/@context_path}/modules/tre/TRE312/tre_loan_contract_widthdraw_query_detail.lview"/>
        <script type="text/javascript"><![CDATA[
            function tre630_loan_contract_number(id) {
            
                var loan_contract_ds_id = 'tre630_finance_standing_book_result_ds';
                var record = $(loan_contract_ds_id).findById(id);
                var param = {};
                param['loan_contract_id'] = record.get('loan_contract_id');
                param['function_code'] = 'TRE503D_QUERY';
                param['function_usage'] = 'QUERY';
                param['cond_para2'] = record.get('way_of_increasing_trust');
                param['document_category'] = record.get('document_category');
                param['document_type'] = record.get('document_type');
                param['document_type_2nd'] = record.get('document_type');
                param['url_title'] = '借款明细';
                param['winid'] = 'tre503d_tre_loan_contract_modify_winid';
                hls_doc_get_layout_code('con_contract_get_layout_code_link_id', param, 'tre_factoring_contract_modify_detail_link_id', loan_contract_ds_id);
            }
            
            function tre630_withdraw_link(id) {
            
                var loan_contract_ds_id = 'tre630_finance_standing_book_result_ds';
                var record = $(loan_contract_ds_id).findById(id);
                var param = {};
                param['loan_contract_id'] = record.get('loan_contract_id');
                param['function_code'] = 'TRE630D';
                param['layout_debugger_flag'] = 'Y';
                param['function_usage'] = 'QUERY';
                param['winid'] = 'tre505_loan_contract_withdraw_review_win_link_id';
                param['url_title'] = '提款查询';
                hls_doc_get_layout_code('con_contract_get_layout_code_link_id', param, 'tre_loan_contract_withdraw_query_detail_link_id', loan_contract_ds_id);
            }
            
            //超链接渲染
            
            function tre630_renderer(value, record, name) {
                if (name == 'loan_contract_number' && !record.isNew) {
                    return '<a href="javascript:tre630_loan_contract_number(' + record.id + ');">' + value + '</a>';
                } else if (name == 'loan_contract_id' && !record.isNew) {
                    return '<a href="javascript:tre630_withdraw_link(' + record.id + ');">提款信息</a>';
                }
            }
             function foot_sum(data,name){
                if(name=='loan_contract_number'){
                    return '<font color=red>' + '合计:' + '</font>';
                }
                    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 >' + Leaf.formatMoney(total) + '</font>';
            }
            
            function tre630_export() {
                $('tre630_finance_standing_book_gird')._export();
            
            }
            function tre630_query(){
                $('tre630_finance_standing_book_result_ds').query();
            }
            function tre630_reset(){
                $('tre630_finance_standing_book_query_ds').reset();
            }
        ]]></script>
        <a:screen-include screen="modules/cont/CON500/con_contract_get_layout_code.lview"/>
        <a:dataSets>
            <a:dataSet id="tre630_loan_con_bp_ds">
                <a:datas dataSource="/model/loan_con_bp_path"/>
            </a:dataSet>
            <a:dataSet id="tre630_currency_ds">
                <a:datas dataSource="/model/currency_path"/>
            </a:dataSet>
            <a:dataSet id="tre630_loan_con_fin_way_ds" lookupCode="LOAN_CON_FIN_WAY"/>
            <a:dataSet id="tre630_hls500_pay_isbefore_type_ds" lookupCode="HLS500_PAY_ISBEFORE_TYPE"/>
            <a:dataSet id="tre630_sdic_loan_con_terms_ds" lookupCode="SDIC_LOAN_CON_TERMS"/>
            <a:dataSet id="tre630_loan_amount_status_ds">
                <a:datas>
                    <a:record value="已结清"/>
                    <a:record value="使用"/>
                </a:datas>
            </a:dataSet>
            <a:dataSet id="tre630_finance_standing_book_query_ds" autoCreate="true">
                <a:fields>
                    <a:field name="loan_con_bp_n" lovHeight="500" lovLabelWidth="120" lovService="basic.hls_bp_master_v_all_lov?status_check_flag=Y" lovWidth="600">
                        <a:mapping>
                            <a:map from="bp_id" to="loan_con_bp"/>
                            <a:map from="bp_name" to="loan_con_bp_n"/>
                        </a:mapping>
                    </a:field>
                    <a:field name="loan_con_terms_n" displayField="code_value_name" options="tre630_sdic_loan_con_terms_ds" returnField="loan_con_terms" valueField="code_value"/>
                    <a:field name="loan_amount_status_n" displayField="value" options="tre630_loan_amount_status_ds" returnField="loan_amount_status" valueField="value"/>
                    <a:field name="within_the_group_n" displayField="code_value_name" options="tre630_hls500_pay_isbefore_type_ds" returnField="within_the_group" valueField="code_value"/>
                    <a:field name="loan_con_type_detail_n" displayField="code_value_name" options="tre630_loan_con_fin_way_ds" returnField="loan_con_type_detail" valueField="code_value"/>
                    <a:field name="currency_n" displayField="currency_name" options="tre630_currency_ds" returnField="currency" valueField="currency_code"/>
                </a:fields>
            </a:dataSet>
            <a:dataSet id="tre630_finance_standing_book_result_ds" autoPageSize="true" autoQuery="true" model="tre.TRE630.finance_standing_book" queryDataSet="tre630_finance_standing_book_query_ds" selectable="true" selectionModel="single"/>
        </a:dataSets>
        <a:screenBody>
            <a:screenTopToolbar>
                <a:screenTitle/>
                <a:gridButton click="tre630_query" text="查询"/>
                <a:gridButton click="tre630_reset" text="重置"/>
                <a:gridButton click="tre630_export" text="导出"/>
            </a:screenTopToolbar>
            <a:form column="4" marginWidth="30" title="查询条件">
                <a:textField name="loan_contract_number" bindTarget="tre630_finance_standing_book_query_ds" prompt="合同编号" width="180"/>
                <a:textField name="original_con_num" bindTarget="tre630_finance_standing_book_query_ds" prompt="原始合同号" width="180"/>
                <a:lov name="loan_con_bp_n" bindTarget="tre630_finance_standing_book_query_ds" prompt="债权人" width="180"/>
                <a:comboBox name="within_the_group_n" bindTarget="tre630_finance_standing_book_query_ds" prompt="是否集团内" width="180"/>
                <a:comboBox name="loan_con_type_detail_n" bindTarget="tre630_finance_standing_book_query_ds" prompt="融资方式" width="180"/>
                <a:comboBox name="loan_amount_status_n" bindTarget="tre630_finance_standing_book_query_ds" prompt="状态" width="180"/>
                <a:comboBox name="loan_con_terms_n" bindTarget="tre630_finance_standing_book_query_ds" prompt="期限" width="180"/>
                <a:comboBox name="currency_n" bindTarget="tre630_finance_standing_book_query_ds" prompt="币种" width="180"/>
                <a:datePicker name="end_date" bindTarget="tre630_finance_standing_book_query_ds" prompt="截止日期" width="180"/>
            </a:form>
            <a:grid id="tre630_finance_standing_book_gird" bindTarget="tre630_finance_standing_book_result_ds" marginHeight="200" marginWidth="30" navBar="true">
                <a:columns>
                    <a:column name="loan_contract_number" footerRenderer="foot_sum" prompt="合同编号"/>
                    <a:column name="loan_con_bp_n" prompt="债权人"/>
                    <a:column name="original_con_num" prompt="原始合同号"/>
                    <a:column name="loan_amount_type_n" prompt="借款合同类型"/>
                    <a:column name="currency_n" prompt="币种" width="80"/>
                    <a:column name="loan_amount" align="right" footerRenderer="foot_sum" prompt="合同金额" renderer="Leaf.formatMoney" width="150"/>
                    <a:column name="withdraw_amount" align="right" footerRenderer="foot_sum" prompt="已提款金额" renderer="Leaf.formatMoney" width="150"/>
                    <a:column name="remaining_amount" align="right" footerRenderer="foot_sum" prompt="待提款金额" renderer="Leaf.formatMoney" width="150"/>
                    <a:column name="received_principal" align="right" footerRenderer="foot_sum" prompt="已还金额" renderer="Leaf.formatMoney" width="150"/>
                    <a:column name="no_received_principal" align="right" footerRenderer="foot_sum" prompt="借款余额" renderer="Leaf.formatMoney" width="150"/>
                    <a:column name="first_withdraw_date" align="right" prompt="首次提款日" renderer="Leaf.formatDate"/>
                    <a:column name="loan_con_terms_n" prompt="期限"/>
                    <a:column name="specific_loan_terms" prompt="具体期限"/>
                    <a:column name="interest_desc" prompt="利率"/>
                    <a:column name="loan_amount_status" prompt="状态"/>
                    <a:column name="loan_con_type_detail_n" prompt="融资方式"/>
                    <a:column name="within_the_group_n" prompt="是否集团内"/>
                    <a:column name="way_of_increasing_trust_n" prompt="增信方式"/>
                    <a:column name="loan_contract_id" prompt="提款信息" renderer="tre630_renderer"/>
                </a:columns>
            </a:grid>
        </a:screenBody>
    </a:view>
</a:screen>