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
<?xml version="1.0" encoding="UTF-8"?>
<!--
$Author: nyl
$Date: 2015-3-13 上午10:30:25
$Revision: 1.0
$Purpose:
-->
<a:screen xmlns:a="http://www.leaf-framework.org/application" customizationEnabled="true" trace="true">
<a:init-procedure>
<a:model-query model="cus.CUS100.cus_default_values" rootPath="default_value"/>
<a:model-query defaultWhereClause="t1.function_code = 'CUS310'" model="cus.CUS100.cus_default_function_name" rootPath="default_function_name"/>
</a:init-procedure>
<a:view>
<a:link id="con_contract_update_link_id" url="${/request/@context_path}/modules/cont/CON501N/con_contract_modify.lview"/>
<a:link id="con_contract_get_layout_code_link_id" model="cont.CON500.con_contract_get_layout_code" modelaction="update"/>
<script type="text/javascript"><![CDATA[
var period_name;
function cus310_con_contract_return() {
history.go(-1);
}
function cus310_con_contract_query() {
var record = $('cus310_contract_query_ds').getCurrentRecord();
var year = record.get('period_date').getFullYear().toString();
var month = record.get('period_date').getMonth().toString();
if (month.length == 1) {
month = '0' + month;
}
period_name = year + '-' + month;
$('cus310_contract_result_ds').query();
}
function cus310_con_contract_reset() {
$('cus310_contract_query_ds').reset();
}
function cus310_con_contract_export() {
// $('con501_con_contract_grid_ds')._export('xls','${/model/default_function_name/record/@function_name}(${/model/default_value/record/@current_month})');
$('con501_con_contract_grid_ds')._export('xls', '${/model/default_function_name/record/@function_name}(' + period_name + ')');
}
]]></script>
<a:screen-include screen="modules/cont/CON500/con_contract_get_layout_code.lview"/>
<!-- <a:screen-include screen="modules/cont/CON500/con_contract_authority_list_validate.lview?document_category=CONTRACT&function_code=cus310"/> -->
<a:dataSets>
<a:dataSet id="cus310_contract_query_ds">
<a:fields>
<a:field name="period_date" required="true"/>
<a:field name="bp_id_tenant_c" autoComplete="true" lovGridHeight="350" lovHeight="500" lovService="basic.hls_bp_master_v_for_lov?bp_category=TENANT" lovWidth="500" title="HLS.BP_TITLE">
<a:mapping>
<a:map from="bp_code" to="bp_id_tenant_c"/>
<a:map from="bp_name" to="bp_id_tenant_n"/>
<a:map from="bp_id" to="bp_id_tenant"/>
</a:mapping>
</a:field>
<a:field name="bp_id_tenant"/>
<a:field name="bp_id_tenant_n"/>
</a:fields>
</a:dataSet>
<a:dataSet id="cus310_contract_result_ds" autoPageSize="true" model="cus.CUS310.cus_con_finance_income_lv" queryDataSet="cus310_contract_query_ds" selectable="true">
<!-- <a:events>
<a:event name="query" handler="aut_authority_list_validate_query"/>
</a:events> --><![CDATA[
]]></a:dataSet>
</a:dataSets>
<a:screenBody>
<a:screenTopToolbar>
<a:screenTitle/>
<a:gridButton click="cus310_con_contract_return" text="HLS.RETURN"/>
<a:gridButton click="cus310_con_contract_query" text="HLS.QUERY"/>
<a:gridButton click="cus310_con_contract_reset" text="HLS.RESET"/>
<a:gridButton click="cus310_con_contract_export" text="导出"/>
</a:screenTopToolbar>
<a:form column="4" labelSeparator=" " labelWidth="100" marginWidth="30" title="CON301.CONTRACT_QUERY">
<a:datePicker name="period_date" bindTarget="cus310_contract_query_ds" prompt="截止日期"/>
<a:lov name="bp_id_tenant_c" bindTarget="cus310_contract_query_ds" prompt="客户编码">
<!-- <a:events>
<a:event name="focus" handler="function(object){on_std_focus(object,'BP')}"/>
</a:events> --><![CDATA[
]]></a:lov>
<a:textField name="bp_id_tenant_n" bindTarget="cus310_contract_query_ds" prompt="客户名称"/>
</a:form>
<a:grid id="con501_con_contract_grid_ds" bindTarget="cus310_contract_result_ds" marginHeight="200" marginWidth="30" navBar="true">
<a:columns>
<a:column name="bp_id_tenant_c" prompt="客户编码" width="100"/>
<a:column name="bp_id_tenant_n" prompt="客户名称" width="150"/>
<a:column prompt="截止至上期金额累计">
<a:column name="total_rental" align="right" prompt="收入确认" renderer="Leaf.formatMoney" width="100"/>
<a:column name="penalty" align="right" prompt="滞纳金收入" renderer="Leaf.formatMoney" width="100"/>
<a:column name="residual_value" align="right" prompt="留购价款" renderer="Leaf.formatMoney" width="100"/>
<a:column name="lease_charge" align="right" prompt="手续费" renderer="Leaf.formatMoney" width="100"/>
<a:column name="lease_mgt_fee" align="right" prompt="管理费" renderer="Leaf.formatMoney" width="100"/>
<a:column name="overdue_interest" align="right" prompt="逾期利息红冲" renderer="Leaf.formatMoney" width="100"/>
</a:column>
<a:column prompt="本月发生">
<a:column name="total_rental_c" align="right" prompt="收入确认" renderer="Leaf.formatMoney" width="100"/>
<a:column name="penalty_c" align="right" prompt="滞纳金收入" renderer="Leaf.formatMoney" width="100"/>
<a:column name="residual_value_c" align="right" prompt="留购价款" renderer="Leaf.formatMoney" width="100"/>
<a:column name="lease_charge_c" align="right" prompt="手续费" renderer="Leaf.formatMoney" width="100"/>
<a:column name="lease_mgt_fee_c" align="right" prompt="管理费" renderer="Leaf.formatMoney" width="100"/>
<a:column name="overdue_interest_c" align="right" prompt="逾期利息红冲" renderer="Leaf.formatMoney" width="100"/>
</a:column>
<a:column prompt="截止至本月累计">
<a:column name="total_rental_b" align="right" prompt="收入确认" renderer="Leaf.formatMoney" width="100"/>
<a:column name="penalty_b" align="right" prompt="滞纳金收入" renderer="Leaf.formatMoney" width="100"/>
<a:column name="residual_value_b" align="right" prompt="留购价款" renderer="Leaf.formatMoney" width="100"/>
<a:column name="lease_charge_b" align="right" prompt="手续费" renderer="Leaf.formatMoney" width="100"/>
<a:column name="lease_mgt_fee_b" align="right" prompt="管理费" renderer="Leaf.formatMoney" width="100"/>
<a:column name="overdue_interest_b" align="right" prompt="逾期利息红冲" renderer="Leaf.formatMoney" width="100"/>
</a:column>
</a:columns>
</a:grid>
</a:screenBody>
</a:view>
</a:screen>