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
<?xml version="1.0" encoding="UTF-8"?>
<!--
$Author: gaoyang
$Date: 2013-12-16 下午01:16:33
$Revision: 1.0
$Purpose: 借款合同查询
-->
<a:screen xmlns:a="http://www.leaf-framework.org/application" customizationEnabled="true" trace="true">
<a:init-procedure>
<!-- <a:model-query fetchAll="true" model="basic.hls_business_type_for_lov" rootPath="business_type"/> -->
<a:model-query defaultWhereClause="exists ( select 1 from hls_doc_category_biz_type b where b.business_type = t1.business_type and b.document_category = 'LOAN_CONTRACT')" fetchAll="true" model="basic.hls_business_type_for_lov" rootPath="business_type"/>
</a:init-procedure>
<a:view>
<a:link id="tre_loan_contract_close_link_id" model="tre.TRE509.tre_loan_contract_close" modelaction="update"/>
<a:link id="tre_working_capital_loan_readonly_link_id" url="${/request/@context_path}/modules/tre/TRE311/tre_working_capital_loan_readonly.lview"/>
<a:link id="tre_factoring_contract_readonly_link_id" url="${/request/@context_path}/modules/tre/TRE311/tre_factoring_contract_readonly.lview"/>
<a:link id="tre_entrustment_loan_contract_readonly_link_id" url="${/request/@context_path}/modules/tre/TRE311/tre_entrustment_loan_contract_readonly.lview"/>
<a:link id="tre_other_contract_readonly_link_id" url="${/request/@context_path}/modules/tre/TRE311/tre_other_contract_readonly.lview"/>
<script type="text/javascript"><![CDATA[
var loanConTypeLink = {
//流动资金借款合同
'WORKING_CAPITAL_LOAN': $('tre_working_capital_loan_readonly_link_id').getUrl() + '?loan_contract_id=',
//公开型无追索权保理合同
'FACTORING': $('tre_factoring_contract_readonly_link_id').getUrl() + '?business_type=FACTORING&loan_contract_id=',
//委托债权合同
'ENTRUSTMENT_LOAN': $('tre_entrustment_loan_contract_readonly_link_id').getUrl() + '?loan_contract_id=',
//其它合同
'OTHERS': $('tre_other_contract_readonly_link_id').getUrl() + '?loan_contract_id='
};
function tre503_loan_query() {
$('loan_contract_ds').query();
}
function tre503_loan_reset() {
$('loan_contract_query_ds').reset();
}
function loanConRender(value, record, name) {
return '<a href="' + loanConTypeLink[record.get('business_type')] + record.get('loan_contract_id') + '">' + value + '</a>';
}
function intPayableRender(value, record, name) {
return '<a href="#">' + Leaf.formatMoney(value) + '</a>';
}
function on_bank_account_focus(object) {
var display_name = object.binder.name,
record = object.record;
if (!Ext.isEmpty(record.get('bank_branch_id'))) {
record.getField(display_name).setLovPara('bank_branch_id', record.get('bank_branch_id'));
} else {
record.getField(display_name).setLovPara('bank_branch_id', '');
}
}
]]></script>
<a:dataSets>
<a:dataSet id="loan_contract_status_ds" lookupCode="TRE_LOAN_CONTRACT_STATUS"/>
<a:dataSet id="business_type_ds">
<a:datas dataSource="/model/business_type"/>
</a:dataSet>
<a:dataSet id="other_loan_amount_type_ds" lookupCode="TRE502_OTHER_LOAN_AMOUNT_TYPE"/>
<a:dataSet id="loan_contract_query_ds" autoCreate="true">
<a:fields>
<a:field name="bank_branch_name" lovGridHeight="350" lovHeight="510" lovLabelWidth="90" lovService="basic.csh_bank_branch_for_lov" lovWidth="580" prompt="HLS.BANK_CODE" title="HLS.BANK_CODE">
<a:mapping>
<a:map from="bank_branch_id" to="bank_branch_id"/>
<a:map from="bank_branch_code" to="bank_branch_code"/>
<a:map from="bank_branch_name" to="bank_branch_name"/>
</a:mapping>
</a:field>
<a:field name="withdraw_account_code" lovGridHeight="350" lovHeight="510" lovLabelWidth="90" lovService="csh.CSH101.csh_bank_account_lov" lovWidth="580" title="CSH511.BANK_ACCOUNT_CODE">
<a:mapping>
<a:map from="bank_account_id" to="withdraw_account_id"/>
<a:map from="bank_account_code" to="withdraw_account_code"/>
<a:map from="bank_account_num" to="withdraw_account_num"/>
<a:map from="currency_code" to="currency"/>
<a:map from="currency_name" to="currency_desc"/>
</a:mapping>
</a:field>
<a:field name="bank_account_code" lovGridHeight="350" lovHeight="510" lovLabelWidth="90" lovService="csh.CSH101.csh_bank_account_lov" lovWidth="580" title="CSH511.BANK_ACCOUNT_CODE">
<a:mapping>
<a:map from="bank_account_id" to="bank_account_id"/>
<a:map from="bank_account_code" to="bank_account_code"/>
<a:map from="bank_account_num" to="bank_account_num"/>
<a:map from="currency_code" to="currency"/>
<a:map from="currency_name" to="currency_desc"/>
</a:mapping>
</a:field>
<a:field name="business_type_desc" displayField="description" options="business_type_ds" returnField="business_type" valueField="business_type"/>
<a:field name="loan_contract_status_desc" displayField="code_value_name" options="loan_contract_status_ds" returnField="loan_contract_status" valueField="code_value"/>
</a:fields>
</a:dataSet>
<a:dataSet id="loan_contract_ds" autoPageSize="true" autoQuery="true" model="tre.tre503.tre_loan_contract_overview" queryDataSet="loan_contract_query_ds" selectable="true" selectionModel="single">
<a:fields>
<a:field name="business_type_desc" displayField="description" options="business_type_ds" returnField="business_type" valueField="business_type"/>
<a:field name="loan_amount_type_desc" displayField="code_value_name" options="other_loan_amount_type_ds" returnField="loan_amount_type" valueField="code_value"/>
</a:fields>
</a:dataSet>
</a:dataSets>
<a:screenBody>
<a:screenTopToolbar>
<a:screenTitle/>
<a:gridButton click="tre503_loan_query" text="HLS.QUERY"/>
<a:gridButton click="tre503_loan_reset" text="HLS.RESET"/>
</a:screenTopToolbar>
<a:form column="4" labelWidth="110" title="HLS.QUERY_TITLE">
<a:textField name="credit_contract_number" bindTarget="loan_contract_query_ds" prompt="TRE501.TRE_BANK_CREDIT_CONTRACT.CREDIT_CONTRACT_NUMBER"/>
<a:textField name="loan_contract_number" bindTarget="loan_contract_query_ds" prompt="TRE_LOAN_CONTRACT.LOAN_CONTRACT_NUMBER"/>
<a:datePicker name="loan_date_from" bindTarget="loan_contract_query_ds" prompt="TRE_LOAN_CONTRACT.LOAN_DATE_FROM"/>
<a:datePicker name="loan_date_to" bindTarget="loan_contract_query_ds" prompt="TRE_LOAN_CONTRACT.LOAN_DATE_TO"/>
<a:lov name="bank_branch_name" bindTarget="loan_contract_query_ds" prompt="HLS.BANK_NAME"/>
<a:comboBox name="business_type_desc" bindTarget="loan_contract_query_ds" prompt="TRE_LOAN_CONTRACT.LOAN_CONTRACT_TYPE"/>
<a:lov name="bank_account_code" bindTarget="loan_contract_query_ds" prompt="TRE502.REPAYMENT_ACCOUNT_CODE">
<a:events>
<a:event name="focus" handler="on_bank_account_focus"/>
</a:events>
</a:lov>
<a:lov name="withdraw_account_code" bindTarget="loan_contract_query_ds" prompt="TRE502.WITHDRAW_ACCOUNT_CODE">
<a:events>
<a:event name="focus" handler="on_bank_account_focus"/>
</a:events>
</a:lov>
<a:comboBox name="loan_contract_status_desc" bindTarget="loan_contract_query_ds" prompt="HLS.STATUS"/>
</a:form>
<a:grid id="review_loan_contract_grid_id" bindTarget="loan_contract_ds" marginHeight="161" marginWidth="30" navBar="true">
<a:columns>
<a:column name="loan_contract_number" prompt="TRE_LOAN_CONTRACT.LOAN_CONTRACT_NUMBER" renderer="loanConRender" width="180"/>
<a:column name="bank_branch_name" prompt="HLS.BANK_BRANCH_NAME" width="200"/>
<a:column name="business_type_desc" prompt="TRE503.BUSINESS_TYPE" width="130"/>
<a:column name="loan_amount" align="right" prompt="TRE_LOAN_CONTRACT.LOAN_AMOUNT" renderer="Leaf.formatMoney" width="110"/>
<a:column name="withdraw_amount" align="right" prompt="TRE502.WITHDRAWAL_AMOUNT" renderer="Leaf.formatMoney"/>
<a:column name="loan_accrued_interest" align="right" prompt="TRE502.LOAN_ACCRUED_INTEREST" renderer="Leaf.formatMoney"/>
<a:column name="repayment_principal" align="right" prompt="TRE502.REPAYMENT_PRINCIPAL" renderer="Leaf.formatMoney"/>
<a:column name="repayment_interest" align="right" prompt="TRE502.REPAYMENT_INTEREST" renderer="Leaf.formatMoney"/>
<a:column name="remaining_amount" align="right" prompt="TRE502.REMAINING_AMOUNT" renderer="Leaf.formatMoney"/>
<a:column name="loan_amount_type_desc" prompt="TRE_LOAN_CONTRACT.AMOUNT_TYPE"/>
<a:column name="loan_contract_status_display" align="center" prompt="HLS.STATUS"/>
<a:column name="loan_date_from" align="center" prompt="TRE_LOAN_CONTRACT.LOAN_DATE_FROM" renderer="Leaf.formatDate"/>
<a:column name="loan_date_to" align="center" prompt="TRE_LOAN_CONTRACT.LOAN_DATE_TO" renderer="Leaf.formatDate"/>
</a:columns>
</a:grid>
</a:screenBody>
</a:view>
</a:screen>