rpt5012_repory_query.lview 17 KB
Newer Older
1 2 3 4 5 6 7 8
<?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">
9 10 11
    <a:init-procedure>
        <a:model-query fetchAll="true" model="prj.PRJ500D.user_agent_description" rootPath="user_agent_description"/>
    </a:init-procedure>
12 13 14
    <a:view>
<!--        <a:link id="con_cashflow_pre_query_id" model="cont.CON930.con_contract_cashflow_monthly" modelaction="update"/>-->
        <script><![CDATA[
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
        //页面加载事件
        // 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');
        //         }
        //     }
41

42 43


44
        /*
45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66
            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');
                }
            }
67
        });*/
68 69 70 71
        ]]></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"/>
72
            <a:dataSet id="con_contract_cashflow_rental_result_after_ds" pageSize="13"  autoQuery="true" model="rpt.RPT5012.rpt5012_csh_result_after_query" queryUrl="${/request/@context_path}/autocrud/rpt.RPT5012.rpt5012_csh_result_after_query/query" autoPageSize="true"/>
73 74 75 76 77 78 79 80
        </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>
81
            <a:tab prompt="租金余额表(保证金前)" width="150">
82 83 84 85 86 87
            <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"/>
88 89
                    <a:column name="branch_code_n" align="center" prompt="分公司"  width="100"/>
                    <a:column name="large_balance_n" align="center" prompt="大额尾款"  width="100"/>
90
                    <a:column name="is_buyout_n" align="center" prompt="是否买断机"  width="100"/>
91 92
                    <a:column name="modelcd" align="center" prompt=" 机型" width="180"/>
                    <a:column name="machine_number" align="center" prompt="机器号码"  width="80"/>
93
                    <a:column name="int_rate_display" exportDataFormat="" align="center" prompt="利率"  width="80"/>
94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113
                    <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>
114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147
                <a:tab prompt="租金余额表(保证金后)" width="150">
                    <a:grid id="con_contract_rental_result_after_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" exportDataFormat="" 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_after" align="center" prompt="当月末应收款余额(合计)" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="month_due_principal_after" align="center" prompt="当月末本金余额(合计)" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="month_interest_after" 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_after" align="center" prompt="逾期期数"  width="80"/>
                            <a:column name="business_due_amount_after" 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="180">
148 149 150 151 152 153
                <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"/>
154 155
                        <a:column name="branch_code_n" align="center" prompt="分公司"  width="100"/>
                        <a:column name="large_balance_n" align="center" prompt="大额尾款"  width="100"/>
156
                        <a:column name="is_buyout_n" align="center" prompt="是否买断机"  width="100"/>
157 158
                        <a:column name="modelcd" align="center" prompt=" 机型" width="180"/>
                        <a:column name="machine_number" align="center" prompt="机器号码"  width="80"/>
159
                        <!--<a:column name="int_rate_display" align="center" prompt="利率"  width="80"/>-->
160 161 162 163 164 165 166
                        <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"/>
167
                        <a:column name="rent_type" align="center" prompt="租金类型"  width="100"/>
168 169 170
                    </a:columns>
                </a:grid>
            </a:tab>
171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193
                <a:tab prompt="回收逾期明细表(保证金后)" width="180">
                    <a:grid id="con_contract_cashflow_rental_result_after_grid" bindTarget="con_contract_cashflow_rental_result_after_ds" marginHeight="115" navBar="true" marginWidth="30">
                        <a:columns>
                            <a:column name="agent_extra_name_af" align="center" prompt="代理店" width="120"/>
                            <a:column name="bp_tenant_name_af" align="center" prompt="客户名称" width="120"/>
                            <a:column name="contract_number_af" align="center" prompt="合同编号" width="100"/>
                            <a:column name="lease_start_date_af" align="center" prompt="租赁期开始日" width="80"/>
                            <a:column name="branch_code_af" align="center" prompt="分公司"  width="100"/>
                            <a:column name="large_balance_af" align="center" prompt="大额尾款"  width="100"/>
                            <a:column name="is_buyout_af" align="center" prompt="是否买断机"  width="100"/>
                            <a:column name="modelcd_af" align="center" prompt=" 机型" width="180"/>
                            <a:column name="machine_number_af" align="center" prompt="机器号码"  width="80"/>
                            <a:column name="times_af" align="center" prompt="回数"  width="80"/>
                            <a:column name="due_date_af" align="center" prompt="支付预定日" width="80"/>
                            <a:column name="due_amount_af" align="center" prompt="应收款金额" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="received_amount_af" align="center" prompt="已收款金额" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="unreceived_amount_af" align="center" prompt="未收金额" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="overdue_days_af" align="center" prompt="逾期天数"  width="80"/>
                            <a:column name="deposit_amount_af" align="center" prompt="保证金" renderer="Leaf.formatMoney" width="80"/>
                            <a:column name="rent_type" align="center" prompt="租金类型"  width="100"/>
                        </a:columns>
                    </a:grid>
                </a:tab>
194 195 196 197 198
            </a:tabs>
            </a:tabPanel>
        </a:screenBody>
    </a:view>
</a:screen>