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
<?xml version="1.0" encoding="UTF-8"?>
<a:screen xmlns:a="http://www.leaf-framework.org/application" trace="true">
<a:init-procedure>
<a:model-query model="basic.get_sys_default_time" rootPath="sys_default_time"/>
</a:init-procedure>
<a:view>
<script type="text/javascript"><![CDATA[
function month_finance_query() {
$('month_finance_grid_ds').query();
}
function month_finance_reset(){
$('month_finance_form_ds').reset();
}
function month_finance_export() {
$('source_to_grid')._export(null,'到期款明细');
}
]]></script>
<a:dataSets>
<a:dataSet id="month_finance_form_ds">
<a:fields>
<a:field name="select_year" defaultValue="${/model/sys_default_time/record/@now_year}"/>
<a:field name="__async__" defaultValue="Y" prompt="异步导出"/>
</a:fields>
</a:dataSet>
<a:dataSet id="month_finance_grid_ds" autoQuery="false"
model="cont.CON1280.con_maturity_query"
queryDataSet="month_finance_form_ds" selectable="true" selectionModel="single">
</a:dataSet>
</a:dataSets>
<a:screenBody>
<a:screenTopToolbar>
<a:screenTitle/>
<a:gridButton click="month_finance_query" text="查询"/>
<a:gridButton click="month_finance_reset" text="重置"/>
<a:gridButton click="month_finance_export" text="导出"/>
</a:screenTopToolbar>
<a:form column="4" marginWidth="100" title="查询条件">
<a:textField name="contract_number" bindTarget="month_finance_form_ds" prompt="合同编号" />
<a:textField name="bp_agent_name" bindTarget="month_finance_form_ds" prompt="代理商名称" />
<a:datePicker name="lease_execution_date_from" bindTarget="month_finance_form_ds" prompt="执行日期从" />
<a:datePicker name="lease_execution_date_to" bindTarget="month_finance_form_ds" prompt="执行日期到" />
<a:numberField allowDecimals="false" name="select_year" bindTarget="month_finance_form_ds" prompt="查询年度" />
</a:form>
<a:grid id="source_to_grid" bindTarget="month_finance_grid_ds" navBar="true" height="400" marginWidth="100">
<a:columns>
<a:column name="contract_number" prompt="合同编号" width="120"/>
<a:column name="bp_code" prompt="客户编号" width="120"/>
<a:column name="bp_name" prompt="客户名称" width="120"/>
<a:column name="bp_agent_code" prompt="代理商编号" width="100" />
<a:column name="bp_agent_name" prompt="代理商名称" />
<a:column name="division_n" prompt="产品线" />
<a:column name="lease_channel_n" prompt="商业模式" width="80" renderer="Leaf.formatDate"/>
<a:column name="business_type_n" prompt="租赁类型" width="100" renderer="Leaf.formatDate"/>
<a:column name="pattern" prompt="机型" width="100" />
<a:column name="machine_number" prompt="机号" width="100" />
<a:column name="equipment_number" prompt="装备号" width="100" />
<a:column prompt="01月">
<a:column name="january_principal" prompt="本金" width="100" renderer="Leaf.formatMoney"/>
<a:column name="january_interest" prompt="利息" width="100" renderer="Leaf.formatMoney"/>
<a:column name="january_due_amount" prompt="合计" width="100" renderer="Leaf.formatMoney"/>
</a:column>
<a:column prompt="02月">
<a:column name="february_principal" prompt="本金" width="100" renderer="Leaf.formatMoney"/>
<a:column name="february_interest" prompt="利息" width="100" renderer="Leaf.formatMoney"/>
<a:column name="february_due_amount" prompt="合计" width="100" renderer="Leaf.formatMoney"/>
</a:column>
<a:column prompt="03月">
<a:column name="march_principal" prompt="本金" width="100" renderer="Leaf.formatMoney"/>
<a:column name="march_interest" prompt="利息" width="100" renderer="Leaf.formatMoney"/>
<a:column name="march_due_amount" prompt="合计" width="100" renderer="Leaf.formatMoney"/>
</a:column>
<a:column prompt="04月">
<a:column name="april_principal" prompt="本金" width="100" renderer="Leaf.formatMoney"/>
<a:column name="april_interest" prompt="利息" width="100" renderer="Leaf.formatMoney"/>
<a:column name="april_due_amount" prompt="合计" width="100" renderer="Leaf.formatMoney"/>
</a:column>
<a:column prompt="05月">
<a:column name="may_principal" prompt="本金" width="100" renderer="Leaf.formatMoney"/>
<a:column name="may_interest" prompt="利息" width="100" renderer="Leaf.formatMoney"/>
<a:column name="may_due_amount" prompt="合计" width="100" renderer="Leaf.formatMoney"/>
</a:column>
<a:column prompt="06月">
<a:column name="june_principal" prompt="本金" width="100" renderer="Leaf.formatMoney"/>
<a:column name="june_interest" prompt="利息" width="100" renderer="Leaf.formatMoney"/>
<a:column name="june_due_amount" prompt="合计" width="100" renderer="Leaf.formatMoney"/>
</a:column>
<a:column prompt="07月">
<a:column name="july_principal" prompt="本金" width="100" renderer="Leaf.formatMoney"/>
<a:column name="july_interest" prompt="利息" width="100" renderer="Leaf.formatMoney"/>
<a:column name="july_due_amount" prompt="合计" width="100" renderer="Leaf.formatMoney"/>
</a:column>
<a:column prompt="08月">
<a:column name="august_principal" prompt="本金" width="100" renderer="Leaf.formatMoney"/>
<a:column name="august_interest" prompt="利息" width="100" renderer="Leaf.formatMoney"/>
<a:column name="august_due_amount" prompt="合计" width="100" renderer="Leaf.formatMoney"/>
</a:column>
<a:column prompt="09月">
<a:column name="september_principal" prompt="本金" width="100" renderer="Leaf.formatMoney"/>
<a:column name="september_interest" prompt="利息" width="100" renderer="Leaf.formatMoney"/>
<a:column name="september_due_amount" prompt="合计" width="100" renderer="Leaf.formatMoney"/>
</a:column>
<a:column prompt="10月">
<a:column name="october_principal" prompt="本金" width="100" renderer="Leaf.formatMoney"/>
<a:column name="october_interest" prompt="利息" width="100" renderer="Leaf.formatMoney"/>
<a:column name="october_due_amount" prompt="合计" width="100" renderer="Leaf.formatMoney"/>
</a:column>
<a:column prompt="11月">
<a:column name="november_principal" prompt="本金" width="100" renderer="Leaf.formatMoney"/>
<a:column name="november_interest" prompt="利息" width="100" renderer="Leaf.formatMoney"/>
<a:column name="november_due_amount" prompt="合计" width="100" renderer="Leaf.formatMoney"/>
</a:column>
<a:column prompt="12月">
<a:column name="december_principal" prompt="本金" width="100" renderer="Leaf.formatMoney"/>
<a:column name="december_interest" prompt="利息" width="100" renderer="Leaf.formatMoney"/>
<a:column name="december_due_amount" prompt="合计" width="100" renderer="Leaf.formatMoney"/>
</a:column>
<a:column prompt="查询年度第二年">
<a:column name="second_years_principal" prompt="本金" width="100" renderer="Leaf.formatMoney"/>
<a:column name="second_years_interest" prompt="利息" width="100" renderer="Leaf.formatMoney"/>
<a:column name="second_years_due_amount" prompt="合计" width="100" renderer="Leaf.formatMoney"/>
</a:column>
<a:column prompt="查询年度第三年">
<a:column name="third_years_principal" prompt="本金" width="100" renderer="Leaf.formatMoney"/>
<a:column name="third_years_interest" prompt="利息" width="100" renderer="Leaf.formatMoney"/>
<a:column name="third_years_due_amount" prompt="合计" width="100" renderer="Leaf.formatMoney"/>
</a:column>
<a:column prompt="查询年度第四年">
<a:column name="fourth_years_principal" prompt="本金" width="100" renderer="Leaf.formatMoney"/>
<a:column name="fourth_years_interest" prompt="利息" width="100" renderer="Leaf.formatMoney"/>
<a:column name="fourth_years_due_amount" prompt="合计" width="100" renderer="Leaf.formatMoney"/>
</a:column>
<a:column prompt="查询年度第五年">
<a:column name="fifth_years_principal" prompt="本金" width="100" renderer="Leaf.formatMoney"/>
<a:column name="fifth_years_interest" prompt="利息" width="100" renderer="Leaf.formatMoney"/>
<a:column name="fifth_years_due_amount" prompt="合计" width="100" renderer="Leaf.formatMoney"/>
</a:column>
<a:column prompt="查询年度五年以后">
<a:column name="after_fifth_years_principal" prompt="本金" width="100" renderer="Leaf.formatMoney"/>
<a:column name="after_fifth_years_interest" prompt="利息" width="100" renderer="Leaf.formatMoney"/>
<a:column name="after_fifth_years_due_amount" prompt="合计" width="100" renderer="Leaf.formatMoney"/>
</a:column>
</a:columns>
</a:grid>
</a:screenBody>
</a:view>
</a:screen>