<?xml version="1.0" encoding="UTF-8"?>
<!--
$Author: Eugene Song
$Date: 2018年10月15日09:34:43
$Revision: 1.0
$Purpose: 代理商垫款入账起案发起功能
-->
<a:screen xmlns:a="http://www.leaf-framework.org/application" customizationEnabled="true" trace="true">
<a:init-procedure>
<a:model-query defaultWhereClause="t1.enabled_flag='Y'" fetchAll="true"
model="basic.csh_payment_method_for_lov" rootPath="payment_method_path"/>
<a:model-query fetchAll="true" model="gld.gld_currency_vl" rootPath="currency"/>
<!-- <a:model-query defaultWhereClause="t.code = 'CSH511_TRANSACTION_TYPE' and t.code_value in ('RECEIPT','ADVANCE_RECEIPT')" fetchAll="true" model="sys.sys_code_values_v" rootPath="transaction_type"/> -->
<a:model-query model="basic.hls_sys_time_default_value" rootPath="sys_time_default_value_path"/>
<a:model-query
defaultWhereClause="v.code='CSH511_TRANSACTION_TYPE' and v.code_value in ('PAYMENT','RECEIPT','ADVANCE_RECEIPT','DEPOSIT')"
fetchAll="true" model="basic.sys_code_default_value" rootPath="transaction_type"/>
</a:init-procedure>
<a:view>
<a:link id="sys_service_welcome_link" url="${/request/@context_path}/welcome.lview"/>
<a:link id="csh_transaction_receipt_return_maintain_link"
url="${/request/@context_path}/modules/csh/CSH301/csh_transaction_receipt_detail_query.lview"/>
<a:link id="csh_transaction_returned_detail_link"
url="${/request/@context_path}/modules/csh/CSH301/csh_transaction_returned_detail_query.lview"/>
<a:link id="csh_write_off_detail_link"
url="${/request/@context_path}/modules/csh/CSH311/csh_advances_transaction_receipt_write_off_detail_query.lview"/>
<a:link id="csh_write_off_detail_link1"
url="${/request/@context_path}/modules/csh/CSH311/csh_transaction_write_off_detail1.lview"/>
<a:link id="csh_transaction_returned_list_link"
url="${/request/@context_path}/modules/csh/CSH515/csh_transaction_returned_list.lview"/>
<a:link id="csh_transaction_payment_detail_link"
url="${/request/@context_path}/modules/csh/CSH301/csh_payment_req_pay_detail.lview"/>
<a:link id="get_xml" model="csh.CSH311.csh_tranction_Initiate_case" modelaction="execute"/>
<script type="text/javascript"><![CDATA[
function dateValidator(record, name, value) { //日期校验方法
if (name == 'transaction_date_from' || name == 'transaction_date_to') {
var start_date = Leaf.formatDate(record.get('transaction_date_from'));
var end_date = Leaf.formatDate(record.get('transaction_date_to'));
if (!!end_date) { //由于结束日期非必填，只有在结束日期填了才进行比较
if (!compareDate(start_date, end_date)) {
return '${l:CSH510.CSH_RECEIPT_DATE_CHECK}'; //校验不通过返回字符串
}
}
return true; //校验通过返回true
}
}
function compareDate(start, end) {
if (start > end) {
return false;
}
return true;
}
function csh510_receipt_query() {
var record = $('csh_transaction_query_ds').getAt(0);
var dirty_flag = 'N';
for (var name in record.data) {
var value = record.get(name);
if (value != 'undefined' && value != null && value != '') {
dirty_flag = 'Y';
}
}
if (dirty_flag == 'N') {
Leaf.showConfirm('${l:PROMPT}', '${l:CSH510.CSH_RECEIPT_QUERY_INFORMATION}', function () {
return;
}, function () {
$('csh_transaction_result_ds').query();
}, null, null);
} else {
$('csh_transaction_result_ds').query();
}
}
function csh510_receipt_reset() {
$('csh_transaction_query_ds').reset();
}
function csh510_receipt_back() {
history.go(-1);
}
function csh510_receipt_forward() {
history.go(1);
}
function csh510_receipt_quit() {
location.href = $('sys_service_welcome_link').getUrl();
parent.shMenu('show');
}
function seedetail_transaction_num(value, record, name) {
if (record.get('transaction_id')) {
var url;
if (record.get('transaction_type') == 'RECEIPT' && record.get('returned_flag') != 'RETURN') {
url = $('csh_transaction_receipt_return_maintain_link').getUrl() + '?transaction_id=' + record.get('transaction_id');
return '<a href="javascript:openWindow(\'' + url + '\');">' + value + '</a>';
} else if (record.get('transaction_type') == 'RECEIPT' && record.get('returned_flag') == 'RETURN') {
url = $('csh_transaction_returned_detail_link').getUrl() + '?transaction_id=' + record.get('transaction_id');
return '<a href="javascript:RETURN_openWindow(\'' + url + '\');">' + value + '</a>';
} else if (record.get('transaction_type') == 'PAYMENT') {
url = $('csh_transaction_payment_detail_link').getUrl() + '?transaction_id=' + record.get('transaction_id');
return '<a href="javascript:payment_openWindow(\'' + url + '\');">' + value + '</a>';
} else {
return value;
}
}
}
function openWindow(url) {
new Leaf.Window({
id: 'csh_transaction_receipt_link_winid',
params: {
winId: 'csh_transaction_receipt_link_winid'
},
url: url,
title: '${l:CSH510.CSH_RECEIPT_UPDATE}',
fullScreen: true
});
}
function RETURN_openWindow(url) {
new Leaf.Window({
id: 'csh_transaction_returned_detail_link_winid',
params: {
winId: 'csh_transaction_returned_detail_link_winid'
},
url: url,
title: '${l:CSH515.CSH_REFUND_DETAILS}',
fullScreen: true
});
}
function payment_openWindow(url) {
new Leaf.Window({
id: 'csh_transaction_payment_link_winid',
params: {
winId: 'csh_transaction_payment_link_winid'
},
url: url,
title: '付款明细',
fullScreen: true
});
}
function construct_from_to() {
var config = ['transaction_num', 'bank_slip_num', 'transaction_amount', 'currency_code', 'bank_account_code', 'bp_id', 'bp_name', 'transaction_date'];
var pattern = ['_from', '_to'];
var obj = {};
for (var i = 0,
j = config.length; i < j; i++) {
for (var m = 0,
n = pattern.length; m < n; m++) {
obj[config[i] + pattern[m]] = config[i] + pattern[n - 1 - m];
}
}
return obj;
}
function csh510_receipt_maintain_update(ds, record, name, value, oldvalue) {
var from_to = construct_from_to();
var opposite_name = from_to[name];
if (!Ext.isEmpty(opposite_name)) {
var opposite_value = record.get(opposite_name);
if (!Ext.isEmpty(value) && Ext.isEmpty(opposite_value)) {
record.set(opposite_name, value);
}
}
}
function csh510_receipt_remove() {
var records = $('csh_transaction_result_ds').getSelected();
if (!records.length) {
Leaf.showMessage('${l:HLS.PROMPT}', '${l:HLS.SELECT_RECORD}');
return;
}
var saveData = [];
for (var i = 0; i < records.length; i++) {
records[i].set('_status', 'delete');
saveData.push(records[i].data);
}
Leaf.showConfirm('${l:PROMPT}', '${l:HLS.DELETE_CONFIRM}', function () {
Leaf.Masker.mask(Ext.getBody(), '${l:HLS.DELETING}');
Leaf.request({
url: '${/request/@context_path}/autocrud/csh.CSH510.csh_transaction_delete/batch_update',
para: saveData,
success: function () {
Leaf.SideBar.show({
msg: '${l:HLS.SUBMIT_SUCCESS}',
duration: 2000
});
csh510_delete_remove(records);
Leaf.Masker.unmask(Ext.getBody());
},
failure: function () {
Leaf.Masker.unmask(Ext.getBody());
},
error: function () {
Leaf.Masker.unmask(Ext.getBody());
},
scope: this
});
}, function () {
return;
}, null, null);
}
function csh510_delete_remove(records) {
while (records[0]) {
$('csh_transaction_result_ds').removeLocal(records[0]);
}
}
function seedetail_write_off(value, record, name) {
var url;
url = $('csh_write_off_detail_link').getUrl() + '?transaction_id=' + record.get('transaction_id') + '&transaction_type=' + record.get('transaction_type');
var return_value = value || 0;
return '<a href="javascript:openWindow_writeoff(\'' + url + '\');">' + Leaf.formatMoney(return_value) + '</a>';
}
function seedetail_write_off1(value, record, name) {
var url;
url = $('csh_write_off_detail_link1').getUrl() + '?transaction_id=' + record.get('transaction_id') + '&transaction_type=' + record.get('transaction_type');
var return_value = value || 0;
return '<a href="javascript:openWindow_writeoff1(\'' + url + '\');">' + Leaf.formatMoney(return_value) + '</a>';
}
function openWindow_writeoff(url) {
new Leaf.Window({
id: 'csh_write_off_reverse_detail_link_winid',
params: {
winId: 'csh_write_off_reverse_detail_link_winid'
},
url: url,
title: '${l:CSH301.CSH_WRITE_OFF_DETAIL}',
fullScreen: true
});
}
function openWindow_writeoff1(url) {
new Leaf.Window({
id: 'csh_write_off_reverse_detail_link_winid',
params: {
winId: 'csh_write_off_reverse_detail_link_winid'
},
url: url,
title: '${l:CSH301.CSH_WRITE_OFF_DETAIL}',
fullScreen: true
});
}
function seedetail_return_list(value, record, name) {
if (value) {
var url;
url = $('csh_transaction_returned_list_link').getUrl() + '?return_from_csh_trx_id=' + record.get('transaction_id');
return '<a href="javascript:openWindow_return(\'' + url + '\');">' + Leaf.formatMoney(value) + '</a>';
}
}
function openWindow_return(url) {
new Leaf.Window({
id: 'csh_transaction_returned_list_window',
url: url,
params: {
winId: 'csh_transaction_returned_list_window'
},
title: '${l:CSH515.CSH_REFUND_DETAILS}',
fullScreen: true
});
}
function csh_transaction_grid_clear() {
$('csh_transaction_grid_ds').clear();
}
function summaryRenderer(datas, name) {
var sum = 0;
var sum1 = 0;
var sum2 = 0;
var sum3 = 0;
if (name == "returned_flag_desc") {
return '<font color="red">合计:</font>';
}
if (name == "transaction_amount") {
for (var i = 0; i < datas.length; i++) {
var record = datas[i];
var payment_amount_vl = record.get("transaction_amount");
var payment_amount = parseFloat(payment_amount_vl);
if (!isNaN(payment_amount)) {
sum += payment_amount;
}
}
return '<font color="red">' + Leaf.formatNumber(sum, 2) + '</font>';
}
if (name == "returned_amount") {
for (var j = 0; j < datas.length; j++) {
var record1 = datas[j];
var payment_amount_vl1 = record1.get("returned_amount");
var payment_amount1 = parseFloat(payment_amount_vl1);
if (!isNaN(payment_amount1)) {
sum1 += payment_amount1;
}
}
return '<font color="red">' + Leaf.formatNumber(sum1, 2) + '</font>';
}
if (name == "write_off_amount") {
for (var k = 0; k < datas.length; k++) {
var record2 = datas[k];
var payment_amount_vl2 = record2.get("write_off_amount");
var payment_amount2 = parseFloat(payment_amount_vl2);
if (!isNaN(payment_amount2)) {
sum2 += payment_amount2;
}
}
return '<font color="red">' + Leaf.formatNumber(sum2, 2) + '</font>';
}
if (name == "unwrite_off_amount") {
for (var l = 0; l < datas.length; l++) {
var record3 = datas[l];
var payment_amount_vl3 = record3.get("unwrite_off_amount");
var payment_amount3 = parseFloat(payment_amount_vl3);
if (!isNaN(payment_amount3)) {
sum3 += payment_amount3;
}
}
return '<font color="red">' + Leaf.formatNumber(sum3, 2) + '</font>';
}
}
function getXml() {
var req_record = $('csh_transaction_result_ds').getCurrentRecord();
var transaction_id = req_record.data.transaction_id;
Leaf.request({
url: $('get_xml').getUrl(),
para: {
transaction_id: transaction_id,
interface_name : 'CFL-0DA1EC2D-1096-4160-A307-43FAA150966C'
},
success: function(res) {
getUrl(res.result.xml)
window['${/parameter/@bp_seq}${/parameter/@layout_code}_unlock_layout_dynamic_window']();
},
failure: function() {
window['${/parameter/@bp_seq}${/parameter/@layout_code}_unlock_layout_dynamic_window']();
},
error: function() {
window['${/parameter/@bp_seq}${/parameter/@layout_code}_unlock_layout_dynamic_window']();
},
scope: this
});
}
function getUrl(xml) {
Leaf.request({
url: '${/request/@context_path}/doodream/post/url',
para: {
xml: xml
},
success: function(res) {
window.open(res.message, "", "width=940, height=650, scrollbars=yes, toolbar=no, location=no, status=no, menubar=no");
Leaf.SideBar.show({
msg: '${l:HLS.SUBMIT_SUCCESS}',
duration: 2000
});
},
failure: function() {
Leaf.SideBar.show({
msg: 'failure',
duration: 2000
});
},
error: function() {
Leaf.SideBar.show({
msg: 'error',
duration: 2000
});
},
scope: this
});
}
]]></script>
<a:dataSets>
<a:dataSet id="payment_method_ds">
<a:datas dataSource="/model/payment_method_path"/>
</a:dataSet>
<a:dataSet id="bp_category_ds" lookupCode="BP_CATEGORY"/>
<a:dataSet id="write_off_flag_ds" lookupCode="CON_WRITE_OFF_FLAG"/>
<a:dataSet id="currency_ds">
<a:datas dataSource="/model/currency"/>
</a:dataSet>
<a:dataSet id="transaction_type_ds">
<a:datas dataSource="/model/transaction_type"/>
</a:dataSet>
<a:dataSet id="receipt_type_ds" lookupCode="RECEIPT_TYPE"/>
<!-- <a:dataSet id="transaction_type_ds" lookupCode="CSH511_TRANSACTION_TYPE"/> -->
<a:dataSet id="posted_flag_ds" lookupCode="CSH510_POST_SELECT"/>
<a:dataSet id="returned_flag_ds" lookupCode="CSH510_RETURN_SELECT"/>
<a:dataSet id="reversed_flag_ds" lookupCode="CSH510_REVERSE_SELECT"/>
<a:dataSet id="csh_transaction_query_ds" autoCreate="true" model="csh.CSH301.get_sum_transaction_amount">
<a:fields>
<a:field name="payment_method_display" displayField="description" options="payment_method_ds"
returnField="payment_method_id" valueField="payment_method_id"/>
<a:field name="bp_name" lovGridHeight="350" lovHeight="500"
lovService="basic.hls_bp_master_v_for_lov" lovWidth="500" title="HLS.BP_TITLE">
<a:mapping>
<a:map from="bp_id" to="bp_id"/>
<a:map from="bp_name" to="bp_name"/>
</a:mapping>
</a:field>
<a:field name="bp_name_to" lovGridHeight="350" lovHeight="500"
lovService="basic.hls_bp_master_v_for_lov" lovWidth="500" title="HLS.BP_TITLE">
<a:mapping>
<a:map from="bp_id" to="bp_id_to"/>
<a:map from="bp_name" to="bp_name_to"/>
</a:mapping>
</a:field>
<a:field name="bp_id"/>
<a:field name="transaction_num_from"/>
<a:field name="transaction_num_to"/>
<a:field name="bank_slip_num_from"/>
<a:field name="bank_slip_num_to"/>
<a:field name="transaction_date_from" validator="dateValidator"/>
<a:field name="transaction_date_to" validator="dateValidator"/>
<a:field name="bank_account_code_from" autoCompleteField="bank_account_num" lovGridHeight="350"
lovHeight="550" lovLabelWidth="90" lovService="csh.CSH101.csh_bank_account_lov"
lovWidth="850" title="CSH511.BANK_ACCOUNT_CODE">
<a:mapping>
<a:map from="bank_account_code" to="bank_account_code_from"/>
</a:mapping>
</a:field>
<a:field name="bank_account_from_id"/>
<a:field name="bank_account_code" autoComplete="true" autoCompleteField="bank_account_num"
lovGridHeight="350" lovHeight="550" lovLabelWidth="90"
lovService="csh.CSH101.csh_bank_account_lov" lovWidth="580"
title="CSH511.BANK_ACCOUNT_CODE">
<a:mapping>
<a:map from="bank_account_code" to="bank_account_code"/>
</a:mapping>
</a:field>
<a:field name="transaction_amount_from"/>
<a:field name="transaction_amount_to"/>
<a:field name="posted_flag_display" displayField="code_value_name" options="posted_flag_ds"
returnField="posted_flag" valueField="code_value"/>
<a:field name="posted_flag"/>
<a:field name="returned_flag_display" displayField="code_value_name" options="returned_flag_ds"
returnField="returned_flag" valueField="code_value"/>
<a:field name="reversed_flag_display" displayField="code_value_name" options="reversed_flag_ds"
returnField="reversed_flag" valueField="code_value"/>
<a:field name="period_name"
defaultValue="${/model/sys_time_default_value_path/record/@now_period_name}"
lovGridHeight="300" lovHeight="500" lovService="gld.gld_period_lov" lovWidth="500"
title="GLD_PERIODS.PERIOD_NAME">
<a:mapping>
<a:map from="period_name" to="period_name"/>
</a:mapping>
</a:field>
<a:field name="user_desc" autoComplete="true" lovGridHeight="300" lovHeight="450"
lovService="basic.sys_user_for_lov" lovWidth="500" prompt="AUT_TRX_USER_AUTHORIZE.USER_ID"
title="员工选择">
<a:mapping>
<a:map from="description" to="user_desc"/>
<a:map from="user_id" to="user_id"/>
</a:mapping>
</a:field>
<a:field name="write_off_flag_n" displayField="code_value_name" options="write_off_flag_ds"
returnField="write_off_flag" valueField="code_value"/>
<a:field name="bp_category_n" displayField="code_value_name" options="bp_category_ds"
returnField="bp_category" valueField="code_value"/>
<a:field name="transaction_type_display" displayField="code_value_name"
options="transaction_type_ds" returnField="transaction_type" valueField="code_value"/>
<a:field name="receipt_type_des" displayField="code_value_name" options="receipt_type_ds"
returnField="receipt_type" valueField="code_value"/>
<a:field name="currency_name_from_display" displayField="currency_name" options="currency_ds"
returnField="currency_code_from" valueField="currency_code"/>
<a:field name="currency_code_from"/>
<a:field name="currency_name_to_display" displayField="currency_name" options="currency_ds"
returnField="currency_code_to" valueField="currency_code"/>
<a:field name="currency_code_to"/>
<a:field name="transaction_category" defaultValue="BUSINESS"/>
<a:field name="description"/>
</a:fields>
<a:events>
<a:event name="update" handler="csh510_receipt_maintain_update"/>
</a:events>
</a:dataSet>
<a:dataSet id="csh_transaction_result_ds" autoPageSize="true" autoQuery="true"
model="csh.CSH301.csh_transaction_query" queryDataSet="csh_transaction_query_ds"
selectable="true" selectionModel="single"/>
</a:dataSets>
<a:screenBody>
<a:screenTopToolbar>
<a:screenTitle/>
<a:gridButton click="csh510_receipt_query" text="HLS.QUERY"/>
<a:gridButton click="csh510_receipt_reset" text="HLS.RESET"/>
<a:gridButton click="getXml" text="起案发起"/>
</a:screenTopToolbar>
<a:form bindTarget="csh_transaction_query_ds" column="4" labelWidth="130" marginWidth="80" title="现金事务查询">
<a:comboBox name="transaction_type_display" bindTarget="csh_transaction_query_ds"
prompt="HLS.TRANSACTION_TYPE"/>
<a:lov name="period_name" bindTarget="csh_transaction_query_ds" prompt="GLD_PERIODS.PERIOD_NAME"/>
<a:datePicker name="transaction_date_from" bindTarget="csh_transaction_query_ds"
prompt="HLS.TRANSACTION_DATE_FROM"/>
<a:datePicker name="transaction_date_to" bindTarget="csh_transaction_query_ds"
prompt="HLS.TRANSACTION_DATE_TO"/>
<a:lov name="bp_name" bindTarget="csh_transaction_query_ds" prompt="对象名称"/>
<a:comboBox name="bp_category_n" bindTarget="csh_transaction_query_ds" prompt="对象类别"/>
<a:comboBox name="receipt_type_des" bindTarget="csh_transaction_query_ds" prompt="收款类型"/>
<a:textField name="transaction_num_from" bindTarget="csh_transaction_query_ds"
prompt="CSH515.CSH_TRANSACTION_NUM_FROM"/>
<a:textField name="transaction_num_to" bindTarget="csh_transaction_query_ds"
prompt="CSH515.CSH_TRANSACTION_NUM_TO"/>
<a:comboBox name="write_off_flag_n" bindTarget="csh_transaction_query_ds" prompt="核销标志"/>
<a:lov name="bank_account_code" bindTarget="csh_transaction_query_ds" prompt="银行账号"/>
<a:numberField name="transaction_amount_from" bindTarget="csh_transaction_query_ds"
prompt="CSH510.CSH_TRANSACTION.TRANSACTION_AMOUNT_FROM"/>
<a:numberField name="transaction_amount_to" bindTarget="csh_transaction_query_ds"
prompt="CSH510.CSH_TRANSACTION.TRANSACTION_AMOUNT_TO"/>
<a:comboBox name="payment_method_display" bindTarget="csh_transaction_query_ds" prompt="收款方式"/>
<a:textField name="sum_transaction_amount" bindTarget="csh_transaction_query_ds" prompt="交易总额"/>
<a:comboBox name="returned_flag_display" bindTarget="csh_transaction_query_ds"
prompt="CSH510.CSH_TRANSACTION.RETURNED_FLAG_CHOOSE"/>
<a:comboBox name="reversed_flag_display" bindTarget="csh_transaction_query_ds"
prompt="CSH510.CSH_TRANSACTION.REVERSED_FLAG_CHOOSE"/>
<a:textField name="description" bindTarget="csh_transaction_query_ds" prompt="备注"/>
</a:form>
<a:grid id="csh_transaction_grid_ds" bindTarget="csh_transaction_result_ds" marginHeight="295"
marginWidth="80" navBar="true" navBarType="simple">
<a:toolBar>
<a:button prompt="PROMPT.EXPORT_EXCEL" type="excel"/>
</a:toolBar>
<a:columns>
<a:column name="transaction_num" prompt="CSH515.CSH_TRANSACTION_NUM"
renderer="seedetail_transaction_num" width="100"/>
<a:column name="transaction_date" prompt="HLS.TRANSACTION_DATE" renderer="Leaf.formatDate"
width="80"/>
<a:column name="bank_slip_num" prompt="银行凭证号" width="120"/>
<a:column name="transaction_type_desc" align="center" prompt="HLS.TRANSACTION_TYPE" width="55"/>
<a:column name="receipt_type_des" align="center" prompt="收款类型" width="64"/>
<a:column name="returned_flag_desc" align="center" footerRenderer="summaryRenderer"
prompt="CSH510.CSH_TRANSACTION.RETURNED_FLAG_CHOOSE" width="64"/>
<a:column name="write_off_flag_n" align="center" prompt="核销标志"/>
<a:column name="transaction_amount" align="right" footerRenderer="summaryRenderer"
prompt="CSH301.TRANSACTION_AMOUNT" renderer="Leaf.formatMoney" width="80"/>
<a:column name="returned_amount" align="right" footerRenderer="summaryRenderer"
prompt="HLS.RETURNED_AMOUNT" renderer="seedetail_return_list" width="80"/>
<a:column name="money_advanced" align="right" footerRenderer="summaryRenderer"
prompt="已垫款金额" renderer="seedetail_write_off" width="80"/>
<a:column name="unwrite_off_amount" align="right" footerRenderer="summaryRenderer" prompt="未核销金额"
renderer="Leaf.formatMoney" width="80"/>
<a:column name="write_off_amount" align="right" footerRenderer="summaryRenderer"
prompt="HLS.WRITEOFF_AMOUNT" renderer="seedetail_write_off1" width="80"/>
<a:column name="repay_debt_flag" align="center" prompt="抵账新增" width="65"/>
<a:column name="bp_name" align="center" prompt="HLS.OBJECT_NAME" width="190"/>
<a:column name="reversed_flag_n" align="center" prompt="反冲标志" width="65"/>
<a:column name="description" prompt="收款备注" width="200"/>
<a:column name="v_cash_status" prompt="审批状态" width="200"/>
<a:column name="cash_amount" prompt="审批金额" width="200"/>
</a:columns>
</a:grid>
</a:screenBody>
</a:view>
</a:screen>