rpt5012_repory_query.lview 21.7 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
	<a:init-procedure>
10 11
        <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 72
        ]]></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"/>
73
            <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"/>
74
		</a:dataSets>
75 76 77 78 79 80 81
        <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>
82
            <a:tab prompt="租金余额表(保证金前)" width="150">
83 84 85 86 87 88
            <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"/>
89 90
					<a:column name="branch_code_n" align="center" prompt="分公司"  width="100"/>
                     <!--<a:column name="large_balance_n" align="center" prompt="大额尾款"  width="100"/>-->
91
                    <a:column name="is_buyout_n" align="center" prompt="是否买断机"  width="100"/>
92 93
                    <a:column name="modelcd" align="center" prompt=" 机型" width="180"/>
                    <a:column name="machine_number" align="center" prompt="机器号码"  width="80"/>
94
                    <a:column name="int_rate_display" align="center" prompt="利率"  width="80"/>
95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114
                    <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>
115
			<a:tab prompt="租金余额表(保证金后)" width="150">
116 117 118 119 120 121 122
                    <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"/>
123
                             <!--<a:column name="large_balance_n" align="center" prompt="大额尾款"  width="100"/>-->
124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148
                            <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">
149 150 151 152 153 154
                <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"/>
155 156
						<a:column name="branch_code_n" align="center" prompt="分公司"  width="100"/>
                         <!--<a:column name="large_balance_n" align="center" prompt="大额尾款"  width="100"/>-->
157
                        <a:column name="is_buyout_n" align="center" prompt="是否买断机"  width="100"/>
158 159
                        <a:column name="modelcd" align="center" prompt=" 机型" width="180"/>
                        <a:column name="machine_number" align="center" prompt="机器号码"  width="80"/>
160
                        <!--<a:column name="int_rate_display" align="center" prompt="利率"  width="80"/>-->
161 162 163 164 165 166 167
                        <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"/>
168
						<a:column name="rent_type" align="center" prompt="租金类型"  width="100"/>
169 170 171
                    </a:columns>
                </a:grid>
            </a:tab>
172
			<a:tab prompt="回收逾期明细表(保证金后)" width="180">
173 174 175 176 177 178 179
                    <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"/>
180
                             <!--<a:column name="large_balance_n" align="center" prompt="大额尾款"  width="100"/>-->
181 182 183 184 185 186 187 188 189 190
                            <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"/>
191
							<a:column name="rent_type" align="center" prompt="租金类型"  width="100"/>
192 193 194
                        </a:columns>
                    </a:grid>
                </a:tab>
195

lizhe's avatar
lizhe committed
196
                <a:tab prompt="租金余额表(日立返还金筛选用)" width="210">
197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233
                    <a:grid id="con_contract_rental_result_add_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:column name="bp_class_n" align="center" prompt="商业伙伴分类"  width="80"/>
                            <a:column name="business_type_n" align="center" prompt="业务类型"  width="80"/>
                            <a:column name="division_n" align="center" prompt="租赁物"  width="80"/>
                            <a:column name="secondary_lease_n" align="center" prompt="二次租赁"  width="80"/>
                            <a:column name="tenant_change_flag_n" align="center" prompt="承租人变更"  width="80"/>
                            <a:column name="rental_12_pay_flag" align="center" prompt="是否已履约12期及以上"  width="160"/>
                            <a:column name="cf_9_exists_flag" align="center" prompt="是否有违约金记录产生"  width="160"/>
                            <a:column name="cf_9_notfirsttime_exists_flag" align="center" prompt="除第1期外是否有违约金记录产生"  width="160"/>
lizhe's avatar
lizhe committed
234
                            <a:column name="rl_flag_n" align="center" prompt="是否日立返还金"  width="100"/>
235 236 237
                        </a:columns>
                    </a:grid>
                </a:tab>
238 239 240 241 242
            </a:tabs>
            </a:tabPanel>
        </a:screenBody>
    </a:view>
</a:screen>