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
<?xml version="1.0" encoding="UTF-8"?>
<!--
$Author: zhangyu
$Date: 2016-10-19 下午17:01:32
$Revision: 1.0
$Purpose:
-->
<a:screen xmlns:a="http://www.leaf-framework.org/application" trace="true">
<a:init-procedure/>
<a:view>
<script type="text/javascript"><![CDATA[
function hn2020_region_detail_close(){
$('${/parameter/@winid}').close();
}
function region_sum_foot(data, name) {
if (name == 'ref_v05_n') {
return '<font color=red>' + '合计' + '</font>';
} else if (name == 'region_sum_principal') {
return region_colum_caculateTotal(data, name);
} else if (name == 'region_rec_principal') {
return region_colum_caculateTotal(data, name);
}
}
function region_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 color=red>' + Leaf.formatMoney(total) + '</font>';
}
]]></script>
<a:dataSets>
<a:dataSet id="hn2020_region_query_ds" autoCreate="true">
<a:fields>
<a:field name="calc_date" defaultValue="${/parameter/@calc_date}" readOnly="true"/>
</a:fields>
</a:dataSet>
<a:dataSet id="hn2020_region_result_ds" autoPageSize="true" autoQuery="true" model="hn.HN2020.hn_rpt2020_region_detail"/>
</a:dataSets>
<a:screenBody>
<a:screenTopToolbar>
<a:screenTitle/>
<a:gridButton click="hn2020_region_detail_close" text="退出"/>
<a:gridButton bind="hn2020_region_detail_grid_id" type="excel"/>
</a:screenTopToolbar>
<a:form column="4" labelSeparator=" " labelWidth="120" marginWidth="30" title="查询条件">
<a:datePicker name="calc_date" bindTarget="hn2020_region_query_ds" prompt="统计截止日"/>
</a:form>
<a:grid id="hn2020_region_detail_grid_id" bindTarget="hn2020_region_result_ds" marginHeight="180" marginWidth="30" navBar="true" showRowNumber="true">
<a:columns>
<a:column name="ref_v05_n" footerRenderer="region_sum_foot" prompt="区域" width="260"/>
<a:column name="region_sum_principal" align="right" footerRenderer="region_sum_foot" prompt="融资本金总额" renderer="Leaf.formatMoney" width="140"/>
<a:column name="region_sum_prin_percent" align="right" prompt="融资本金总额占比" width="120"/>
<a:column name="region_rec_principal" align="right" footerRenderer="region_sum_foot" prompt="剩余本金总额" renderer="Leaf.formatMoney" width="140"/>
<a:column name="region_rec_prin_percent" align="right" prompt="剩余本金总额占比" width="120"/>
</a:columns>
</a:grid>
</a:screenBody>
</a:view>
</a:screen>