1
2
3
4
5
6
7
8
9
10
11
12
13
14
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
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
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
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
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
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
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
<?xml version="1.0" encoding="UTF-8"?>
<!--
$Author: Clocc
$Date: 2015-7-30 下午3:09:16
$Revision: 1.0
$Purpose:
-->
<a:screen xmlns:a="http://www.leaf-framework.org/application">
<a:init-procedure>
<a:model-query model="cus.CUS100.cus_default_values" rootPath="cus_default_value"/>
</a:init-procedure>
<a:view>
<a:link id="con643_submit_link" model="cus.CUS312.cus_rpt_cus312_submit_rpt" modelaction="execute"/>
<a:link id="con643_get_control_id_link" model="db.rpt_report_control_pkg.checkin_rpt" modelaction="execute"/>
<a:link id="con643_refresh_link" model="db.rpt_report_control_pkg.refresh_rpt" modelaction="execute"/>
<script type="text/javascript"><![CDATA[
function eg_rpt100_status_find(control_id){
Leaf.request({
url: $('con643_refresh_link').getUrl(),
para: {'control_id':control_id},
success: function(res) {
if (res.result.job_stauts == 'FINISH') {
var result_ds = $('cus312_result_ds');
var record = $('cus312_head_ds').getCurrentRecord();
record.set('status', res.result.job_stauts);
result_ds.setQueryParameter('control_id', control_id);
result_ds.query();
} else {
eg_rpt100_head_query();
}
},
failure: function() {
cus312_unlock_current_window();
},
error: function() {
cus312_unlock_current_window();
},
scope: this
});
}
function cus312_lock_current_window() {
Leaf.Masker.mask(Ext.getBody(), '${l:HLS.EXECUTING}');
}
function cus312_unlock_current_window() {
Leaf.Masker.unmask(Ext.getBody());
}
function cus312_load(ds) {
result_load_flag = 'Y';
unlock_window_after_load();
}
function cus312_query() {
var record = $('cus312_status_ds').getCurrentRecord();
if (record && record.get('calc_date')) {
eg_rpt100_head_query();
} else {
Leaf.showMessage('${l:HLS.PROMPT}', '请输入计算日期！');
return;
}
}
function on_cus312_head_ds_load(ds) {
head_load_flag = 'Y';
if (from_update_flag == 'N') {
var record = $('cus312_head_ds').getCurrentRecord();
var control_id = null,
status = null;
if (record) {
control_id = record.get('control_id');
status = record.get('status');
}
if (status == 'FINISH') {
var result_ds = $('cus312_result_ds');
record.set('status', status);
result_ds.setQueryParameter('control_id', control_id);
result_ds.query();
} else {
eg_rpt100_status_find(control_id);
}
} else {
from_update_flag = 'N';
unlock_window_after_load();
}
}
function cus312_submit(){
var record = $('cus312_head_ds').getCurrentRecord(),
status_record = $('cus312_status_ds').getCurrentRecord();
var control_id = record.get('control_id');
var calc_date = status_record.get('calc_date');
if (status_record && calc_date) {
Leaf.showConfirm('${l:PROMPT}', '计算将清除上次运行结果，并且执行时间较长，是否确认提交？', function() {
$('cus312_result_ds').removeAll();
Leaf.request({
url: $('con643_submit_link').getUrl(),
para: {'control_id':control_id,
'check_company_id' : ${/session/@company_id},
'calc_date':calc_date},
success: function(res) {
eg_rpt100_head_query();
},
failure: function() {
cus312_unlock_current_window();
},
error: function() {
cus312_unlock_current_window();
},
scope: this
});
});
} else {
Leaf.showMessage('${l:HLS.PROMPT}', '请输入计算日期！');
return;
}
}
function eg_rpt100_head_query(){
$('cus312_head_ds').query();
}
function cus312_red_fun(value,record,name){
return '<font style="color:red;bold:true">'+value+'</font>';
}
function cus312_excel(){
$('cus312_result_grid_ds')._export('xls','excel_report');
}
function unlock_window_after_load() {
if (head_load_flag == 'Y' && result_load_flag == 'Y') {
head_load_flag = 'N';
result_load_flag = 'N';
cus312_unlock_current_window();
}
}
var head_load_flag = 'N';
var result_load_flag = 'N';
var from_update_flag = 'N';
function cus312_update(ds,record,name,value,oldvalue){
if (value){
var date = Leaf.formatDate(value);
date = date.substring(0,7).replace(/-/g,"");
cus312_lock_current_window();
Leaf.request({
url: $('con643_get_control_id_link').getUrl(),
para: {'report_name':'CUS312',
'check_company_id' : ${/session/@company_id},
// 'check_date':value,
'check_period':date},
success: function(res) {
from_update_flag = 'Y';
var head_ds = $('cus312_head_ds');
var result_ds = $('cus312_result_ds');
if (res.result.control_id) {
head_ds.setQueryParameter('control_id', res.result.control_id);
result_ds.setQueryParameter('control_id', res.result.control_id);
head_ds.query();
result_ds.query();
} else {
cus312_unlock_current_window();
}
},
failure: function() {
cus312_unlock_current_window();
},
error: function() {
cus312_unlock_current_window();
},
scope: this
});
}
}
function cus312_reset() {
$('cus312_query_ds').reset();
}
]]></script>
<a:dataSets>
<a:dataSet id="lease_channel_desc_ds" fetchAll="true" loadData="true" model="basic.hls_lease_channel_for_lov"/>
<a:dataSet id="cus312_head_ds" model="cus.CUS312.cus_rpt_report_control">
<a:events>
<a:event name="load" handler="on_cus312_head_ds_load"/>
</a:events>
</a:dataSet>
<a:dataSet id="cus312_status_ds" autoCreate="true">
<a:events>
<a:event name="update" handler="cus312_update"/>
</a:events>
</a:dataSet>
<a:dataSet id="cus312_query_ds">
<a:fields>
<a:field name="bp_id_tenant_n"/>
<a:field name="search_term_1"/>
<a:field name="contract_number"/>
<a:field name="period_name"/>
<a:field name="lease_channel_n" displayField="description" options="lease_channel_desc_ds" returnField="lease_channel" valueField="lease_channel"/>
</a:fields>
</a:dataSet>
<a:dataSet id="cus312_result_ds" autoPageSize="true" autoQuery="true" model="cus.CUS312.cus_rpt_cus312_o" queryDataSet="cus312_query_ds">
<a:events>
<a:event name="load" handler="cus312_load"/>
</a:events>
</a:dataSet>
</a:dataSets>
<a:screenBody>
<a:screenTopToolbar>
<a:screenTitle/>
<a:toolbarButton click="cus312_query" text="查询"/>
<a:toolbarButton click="cus312_submit" text="计算"/>
<a:toolbarButton click="cus312_reset" text="重置"/>
<a:toolbarButton click="cus312_excel" text="导出"/>
</a:screenTopToolbar>
<a:form column="4" marginWidth="100" title="数据刷新状态">
<a:datePicker name="calc_date" bindTarget="cus312_status_ds" prompt="计算时间"/>
<a:label name="last_submit_date" bindTarget="cus312_head_ds" prompt="最后刷新时间" renderer="cus312_red_fun"/>
<a:label name="last_submitted_by" bindTarget="cus312_head_ds" prompt="最后刷新人" renderer="cus312_red_fun"/>
<a:label name="status" bindTarget="cus312_head_ds" prompt="状态" renderer="cus312_red_fun"/>
</a:form>
<a:form column="5" marginWidth="100" title="查询条件">
<a:textField name="search_term_1" bindTarget="cus312_query_ds" prompt="合同号"/>
<a:textField name="contract_number" bindTarget="cus312_query_ds" prompt="合同序号"/>
<a:textField name="period_name" bindTarget="cus312_query_ds" prompt="会计期间"/>
<a:textField name="bp_id_tenant_n" bindTarget="cus312_query_ds" prompt="承租人"/>
<a:comboBox name="lease_channel_n" bindTarget="cus312_query_ds" prompt="HLS.LEASE_CHANNEL"/>
</a:form>
<a:grid id="cus312_result_grid_ds" bindTarget="cus312_result_ds" marginHeight="230" marginWidth="80" navBar="true">
<!-- <a:toolBar>
<a:button type="excel"/>
</a:toolBar> -->
<a:columns>
<a:column name="search_term_1" align="left" prompt="合同号" width="100"/>
<a:column name="contract_number" align="left" prompt="合同序号" width="100"/>
<a:column name="bp_id_tenant_n" align="left" prompt="客户名称" width="100"/>
<a:column name="period_name" align="center" prompt="会计期间" width="100"/>
<a:column name="inception_of_lease" align="center" prompt="起租日" renderer="Leaf.formatDate" width="100"/>
<a:column name="vat_flag" align="right" prompt="增值税合同" width="100"/>
<a:column name="received_date" align="center" prompt="付款日期" renderer="Leaf.formatDate" width="100"/>
<a:column name="division_n" align="center" prompt="产品线" width="100"/>
<a:column name="lease_channel_n" align="center" prompt="商业模式" width="100"/>
<a:column name="specification" align="left" prompt="设备型号" width="100"/>
<a:column name="serial_number" align="left" prompt="设备编号" width="100"/>
<a:column name="bp_id_vender_n" align="left" prompt="供应商" width="100"/>
<a:column name="branch_company_n" align="left" prompt="分公司"/>
<a:column name="province_id_n" align="left" prompt="省份" width="100"/>
<a:column name="lease_item_amount" align="right" prompt="整机价格" renderer="Leaf.formatMoney" width="100"/>
<a:column name="insurance_fee" align="right" prompt="保险费" renderer="Leaf.formatMoney" width="100"/>
<a:column name="csa" align="right" prompt="CSA" renderer="Leaf.formatMoney" width="100"/>
<a:column name="payment_others" align="right" prompt="应付其他" renderer="Leaf.formatMoney" width="100"/>
<a:column name="payment_amount" align="right" prompt="应付账款" renderer="Leaf.formatMoney" width="100"/>
<a:column name="operation_fee" align="right" prompt="管理费" renderer="Leaf.formatMoney" width="100"/>
<a:column name="residual_value" align="right" prompt="抵押金" renderer="Leaf.formatMoney" width="100"/>
<a:column name="deposit" align="right" prompt="保证金" renderer="Leaf.formatMoney" width="100"/>
<!-- <a:column name="operation_fee_three" align="right" prompt="第三方管理费" renderer="Leaf.formatMoney" width="100"/> -->
<a:column name="down_payment" align="right" prompt="DOWNPAYMENT" renderer="Leaf.formatMoney" width="100"/>
<a:column name="down_payment_1" align="right" prompt="首期付款" renderer="Leaf.formatMoney" width="100"/>
<a:column name="reschedule_flag" align="right" prompt="是否支付日调整" width="100"/>
<a:column name="et_flag" align="right" prompt="是否提前结清" width="100"/>
<a:column name="cashflow_change_flag" align="right" prompt="是否租金计划变更" width="100"/>
<a:column name="change_req_date" align="right" prompt="变更时间" renderer="Leaf.formatDate" width="100"/>
<a:column name="ccr_fee" align="right" prompt="变更手续费" renderer="Leaf.formatMoney" width="100"/>
<a:column name="actual_finance_amount" align="right" prompt="净融资额" renderer="Leaf.formatMoney" width="100"/>
<a:column name="total_interest" align="right" prompt="利息总额" renderer="Leaf.formatMoney" width="100"/>
<a:column name="gross" align="right" prompt="应收未收余额" renderer="Leaf.formatMoney" width="100"/>
<a:column name="net_fin" align="right" prompt="净投资额" renderer="Leaf.formatMoney" width="100"/>
<a:column name="unearned_income_fin" align="right" prompt="未实现利息余额" renderer="Leaf.formatMoney" width="100"/>
<a:column name="total_rental" align="right" prompt="月租金总和" renderer="Leaf.formatMoney" width="100"/>
<a:column name="due_amount" align="right" prompt="租金总和" renderer="Leaf.formatMoney" width="100"/>
<a:column name="int_rate" align="right" prompt="名义利率" width="100"/>
<a:column name="collected_times" align="right" prompt="已付租期" width="100"/>
<a:column name="uncollected_times" align="right" prompt="未付租期" width="100"/>
<a:column name="overdue_times" align="right" prompt="逾期(月)" width="100"/>
<a:column name="lease_times" align="right" prompt="总租期" width="100"/>
<a:column name="received_amount" align="right" prompt="当月收到租金" renderer="Leaf.formatMoney" width="100"/>
<a:column name="penalty" align="right" prompt="延迟履行金" renderer="Leaf.formatMoney" width="100"/>
<a:column name="interest_current" align="right" prompt="本月确认利息" renderer="Leaf.formatMoney" width="100"/>
<a:column name="huichong" align="right" prompt="逾期3期以上收入回冲" renderer="Leaf.formatMoney" width="100"/>
<a:column name="interest_straight" align="right" prompt="直线法每期利息" renderer="Leaf.formatMoney" width="100"/>
<a:column name="uncollected_interest_straight" align="right" prompt="未到期直线法利息" renderer="Leaf.formatMoney" width="100"/>
<a:column name="collected_rental" align="right" prompt="累计已收租金" renderer="Leaf.formatMoney" width="100"/>
<a:column name="principal_implicit_next_12" align="right" prompt="次12个月剩余本金" renderer="Leaf.formatMoney" width="100"/>
<a:column name="principal_implicit_next_12_p" align="right" prompt="次12个月后剩余本金" renderer="Leaf.formatMoney" width="100"/>
<a:column name="contract_status_n" align="center" prompt="合同状态" width="100"/>
<a:column name="legal_status_n" align="center" prompt="法务状态" width="100"/>
<a:column name="lawsuit_status_n" align="center" prompt="诉讼状态" width="100"/>
<a:column name="all_file_confirm_status_n" align="right" prompt="付款状态" width="100"/>
<a:column name="document_type" align="center" prompt="租赁类型" width="100"/>
<a:column name="company_id_n" align="right" prompt="公司名称" width="100"/>
</a:columns>
</a:grid>
</a:screenBody>
</a:view>
</a:screen>