rpt5012_repory_query.lview

<?xml version="1.0" encoding="UTF-8"?>
<!--
    $Author: WangYu  
    $Date: 2014-4-25 上午09:31:11  
    $Revision: 1.0  
    $Purpose: 
-->
<a:screen xmlns:a="http://www.leaf-framework.org/application" trace="true">
    <a:init-procedure>
        <a:model-query fetchAll="true" model="prj.PRJ500D.user_agent_description" rootPath="user_agent_description"/>
    </a:init-procedure>
    <a:view>
<!--        <a:link id="con_cashflow_pre_query_id" model="cont.CON930.con_contract_cashflow_monthly" modelaction="update"/>-->
        <script><![CDATA[
        //页面加载事件
        // Leaf.onReady(function() {
        //     var bp_code='${/model/user_agent_description/record/@bp_code}';
        //
        //     if (!Ext.isEmpty(bp_code)&&bp_code!== 'C00010168'){
        //         $('con_contract_rental_result_grid').hideColumn('branch_code_n');
        //         $('con_contract_rental_result_grid').hideColumn('branch_code');
        //
        //         $('con_contract_cashflow_rental_result_grid').hideColumn('branch_code_n');
        //         $('con_contract_cashflow_rental_result_grid').hideColumn('branch_code');
        //     }
        //     if (!Ext.isEmpty(bp_code)) {
        //         if (bp_code == 'C00010168' || bp_code == 'C00010198' || bp_code == 'C00010170') {
        //             $('con_contract_rental_result_grid').showColumn('large_balance_n');
        //             $('con_contract_rental_result_grid').showColumn('large_balance');
        //
        //             $('con_contract_cashflow_rental_result_grid').showColumn('large_balance_n');
        //             $('con_contract_cashflow_rental_result_grid').showColumn('large_balance');
        //         }else {
        //             $('con_contract_rental_result_grid').hideColumn('large_balance_n');
        //             $('con_contract_rental_result_grid').hideColumn('large_balance');
        //
        //             $('con_contract_cashflow_rental_result_grid').hideColumn('large_balance_n');
        //             $('con_contract_cashflow_rental_result_grid').hideColumn('large_balance');
        //         }
        //     }




            if (!Ext.isEmpty(bp_code)&&bp_code!== 'D00010001'&&bp_code!=='D00000009') {
                $('con_contract_rental_result_grid').hideColumn('branch_code_n');
                $('con_contract_rental_result_grid').hideColumn('branch_code');

                $('con_contract_cashflow_rental_result_grid').hideColumn('branch_code_n');
                $('con_contract_cashflow_rental_result_grid').hideColumn('branch_code');
            }
            if (!Ext.isEmpty(bp_code)) {
                if (bp_code == 'D00000041' || bp_code == 'D00010001' || bp_code == 'D00000026') {
                    $('con_contract_rental_result_grid').showColumn('large_balance_n');
                    $('con_contract_rental_result_grid').showColumn('large_balance');

                    $('con_contract_cashflow_rental_result_grid').showColumn('large_balance_n');
                    $('con_contract_cashflow_rental_result_grid').showColumn('large_balance');
                }else {
                    $('con_contract_rental_result_grid').hideColumn('large_balance_n');
                    $('con_contract_rental_result_grid').hideColumn('large_balance');

                    $('con_contract_cashflow_rental_result_grid').hideColumn('large_balance_n');
                    $('con_contract_cashflow_rental_result_grid').hideColumn('large_balance');
                }
            }
        });
        ]]></script>
        <a:dataSets>
            <a:dataSet id="con_contract_rental_result_ds" pageSize="13"  autoQuery="true" model="rpt.RPT5012.rpt5012_result_query"  queryUrl="${/request/@context_path}/autocrud/rpt.RPT5012.rpt5012_result_query/query?month=${/parameter/@month}&amp;cur_begin=${/parameter/@cur_begin}&amp;cur_end=${/parameter/@cur_end}&amp;before_begin=${/parameter/@before_begin}&amp;before_end=${/parameter/@before_end}" autoPageSize="true"/>
            <a:dataSet id="con_contract_cashflow_rental_result_ds" pageSize="13"  autoQuery="true" model="rpt.RPT5012.rpt5012_csh_result_query" queryUrl="${/request/@context_path}/autocrud/rpt.RPT5012.rpt5012_csh_result_query/query?month=${/parameter/@month}&amp;cur_begin=${/parameter/@cur_begin}&amp;cur_end=${/parameter/@cur_end}&amp;before_begin=${/parameter/@before_begin}&amp;before_end=${/parameter/@before_end}" autoPageSize="true"/>
        </a:dataSets>
        <a:screenBody>
<!--            <a:screenTopToolbar>-->
<!--&lt;!&ndash;                <a:gridButton click="CON321_con_contract_query" text="HLS.QUERY"/>&ndash;&gt;-->
<!--&lt;!&ndash;                <a:gridButton click="CON321_con_contract_reset" text="HLS.RESET"/>&ndash;&gt;-->
<!--            </a:screenTopToolbar>-->
            <a:tabPanel marginHeight="25" marginWidth="20">
            <a:tabs>
            <a:tab prompt="租金余额表" width="110">
            <a:grid id="con_contract_rental_result_grid" bindTarget="con_contract_rental_result_ds" marginHeight="115" navBar="true" marginWidth="30">
                <a:columns>
                    <a:column name="agent_extra_name" align="center" prompt="代理店" width="120"/>
                    <a:column name="bp_tenant_name" align="center" prompt="客户名称" width="120"/>
                    <a:column name="contract_number" align="center" prompt="合同编号" width="100"/>
                    <a:column name="lease_start_date" align="center" prompt="租赁期开始日" width="80"/>
                    <a:column name="branch_code_n" align="center" prompt="分公司"  width="100"/>
                    <a:column name="large_balance_n" align="center" prompt="大额尾款"  width="100"/>
                    <a:column name="is_buyout_n" align="center" prompt="是否买断机"  width="100"/>
                    <a:column name="modelcd" align="center" prompt=" 机型" width="180"/>
                    <a:column name="machine_number" align="center" prompt="机器号码"  width="80"/>
                    <a:column name="int_rate_display" align="center" prompt="利率"  width="80"/>
                    <a:column name="int_rate_display" align="center" prompt="基准利率"  width="80"/>
                    <a:column name="lease_times" align="center" prompt="租赁期间"  width="80"/>
                    <a:column name="down_payment_ratio" align="center" prompt="首付款比率" width="80"/>
                    <a:column name="lease_item_amount" align="center" prompt="代理店销售金额" renderer="Leaf.formatMoney" width="80"/>
                    <a:column name="residual_amount" align="center" prompt="留购价格" renderer="Leaf.formatMoney" width="80"/>
                    <a:column name="contract_amount" align="center" prompt="合同总金额" renderer="Leaf.formatMoney" width="80"/>
                    <a:column name="down_payment" align="center" prompt="首付款" renderer="Leaf.formatMoney" width="80"/>
                    <a:column name="month_due_amount" align="center" prompt="当月末应收款余额（合计）" renderer="Leaf.formatMoney" width="80"/>
                    <a:column name="month_due_principal" align="center" prompt="当月末本金余额（合计）" renderer="Leaf.formatMoney" width="80"/>
                    <a:column name="month_interest" align="center" prompt="当月末利息余额（合计）" renderer="Leaf.formatMoney" width="80"/>
                    <a:column name="month_residual" align="center" prompt="当月末留购金余额" renderer="Leaf.formatMoney" width="80"/>
                    <a:column name="business_due_times" align="center" prompt="逾期期数"  width="80"/>
                    <a:column name="business_due_amount" align="center" prompt="当月末逾期金额（合计）" renderer="Leaf.formatMoney" width="80"/>
                    <a:column name="deposit_amount" align="center" prompt="保证金" renderer="Leaf.formatMoney" width="80"/>
                    <a:column name="contract_status_n" align="center" prompt="合同状态"  width="80"/>
                    <a:column name="residual_date" align="center" prompt="合同终了"  width="80"/>
                    <a:column name="terminate_date" align="center" prompt="结清年月"  width="80"/>
                </a:columns>
            </a:grid>
            </a:tab>
            <a:tab prompt="回收逾期明细表" width="110">
                <a:grid id="con_contract_cashflow_rental_result_grid" bindTarget="con_contract_cashflow_rental_result_ds" marginHeight="115" navBar="true" marginWidth="30">
                    <a:columns>
                        <a:column name="agent_extra_name" align="center" prompt="代理店" width="120"/>
                        <a:column name="bp_tenant_name" align="center" prompt="客户名称" width="120"/>
                        <a:column name="contract_number" align="center" prompt="合同编号" width="100"/>
                        <a:column name="lease_start_date" align="center" prompt="租赁期开始日" width="80"/>
                        <a:column name="branch_code_n" align="center" prompt="分公司"  width="100"/>
                        <a:column name="large_balance_n" align="center" prompt="大额尾款"  width="100"/>
                        <a:column name="is_buyout_n" align="center" prompt="是否买断机"  width="100"/>
                        <a:column name="modelcd" align="center" prompt=" 机型" width="180"/>
                        <a:column name="machine_number" align="center" prompt="机器号码"  width="80"/>
                        <a:column name="int_rate_display" align="center" prompt="利率"  width="80"/>
                        <a:column name="times" align="center" prompt="回数"  width="80"/>
                        <a:column name="due_date" align="center" prompt="支付预定日" width="80"/>
                        <a:column name="due_amount" align="center" prompt="应收款金额" renderer="Leaf.formatMoney" width="80"/>
                        <a:column name="received_amount" align="center" prompt="已收款金额" renderer="Leaf.formatMoney" width="80"/>
                        <a:column name="unreceived_amount" align="center" prompt="未收金额" renderer="Leaf.formatMoney" width="80"/>
                        <a:column name="overdue_days" align="center" prompt="逾期天数"  width="80"/>
                        <a:column name="deposit_amount" align="center" prompt="保证金" renderer="Leaf.formatMoney" width="80"/>
                    </a:columns>
                </a:grid>
            </a:tab>
            </a:tabs>
            </a:tabPanel>
        </a:screenBody>
    </a:view>
</a:screen>