以下在V8中试验可行
SELECT a.* ,B.BOOK_CODE,B.BANK_CODE_XY
FROM LMCONFIG.T_BANK_BRANCH_INFO A
LEFT JOIN LMCONFIG.T_BANK_INFO B
ON A.BANK_ID = B.BANK_ID
WHERE A.BANK_BRANCH_ID={?I_BANK_BRANCH_ID?}
app.run("{call LMCONFIG.P_LM108150_A({?ENTITY_ID?},{?BUSI_DATE?},{?DEPT_ID?},{?ORDERDATE?},{?CONTRACT_ID?},{?CONTRACT_CODE?},{?CONTRACT_TYPE?},{?CONTRACT_NAME?},{?CONTRACT_DESC?},{?FUND_ID?},{?BUSI_SUM?},{?MONEY_TYPE?},{?RECEIVE_ACCOUNT_ID?},{?RECEIVE_ACCOUNT_CODE?},{?RECEIVE_ACCOUNT_BANK?},{?RECEIVE_ACCOUNT_NAME?},{?RESERVE_AMOUNT?},{?RESERVE_PURPOSE?},{?PROCESS_ID?},{?I_HANDLE_STATUS?},{?SOURCE_CODE?},{?COMMENT_TEXT?},{?sys.username?},{?REPAY_DATE?},{?ASS_ID?},{?EVENT_ID?},{?PK_ID?},{?@O_RETURN_MSG?},{?@O_RETURN_CODE?})}");
Ext.Msg.show({
title:'大额资金预约事项待处理',
icon:Ext.Msg.INFO,
msg:'test',
buttons: Ext.Msg.OKCANCEL,
modal:false,
fn:function(id){
if ( id == 'ok'){
Wb.open({url:'m?xwl=liquidity_fxgl/capital_transfer/LM108150',inframe:true,title:'大额资金预约'});
}
}
});
{#sys.username#}
Wb.request({
url: 'm?xwl=liquidity_fxgl/account_management/bank_account/P_LM403500_Q/branch_bank_name',
params: {
I_BANK_BRANCH_ID: newValue
},
success: function(resp) {
var row = Wb.decode(resp.responseText).rows[0];
if (row)
Wb.setValue(app.addWin, {
I_BANK_BRANCH_PHONE_NO: row.BANK_BRANCH_PHONE_NO,
I_BANK_BRANCH_CONTACT_INFO: row.BANK_BRANCH_CONTACT_INFO,
I_LARGE_PAYMENT_NO: row.LARGE_PAYMENT_NO
});
}
});
// 每5分钟提示一次有大额资金预约事项待处理
var task = {
run: function() {
Wb.request({
url: 'm?xwl=liquidity_fxgl/capital_transfer/LM108150/select_task',
params: {
I_USER_ID: '{#sys.username#}'
},
showMask: false,
success: function(resp) {
var data = Wb.decode(resp.responseText);
if (data.total > 0) {
Ext.Msg.show({
title:'大额资金预约事项待处理',
icon:Ext.Msg.INFO,
msg:'<div style="font-size:14px;line-height:20px; letter-spacing:2px; padding:4px 0 4px 5px;">' + data.rows[0].NAME + "您有大额资金预约事项待处理!",
buttons: Ext.Msg.OKCANCEL,
modal:false,
fn:function(id){
if ( id == 'ok'){
Wb.open({url:'m?xwl=liquidity_fxgl/capital_transfer/LM108150',inframe:true,title:'大额资金预约'});
}
}
});
// Ext.Msg.setXY([Ext.Element.getViewportWidth() - 360,Ext.Element.getViewportHeight() - 150]);
}
}
});
},
interval: 1000 * 60 * 5 //5分钟定时执行一次
};
var taskRunner = new Ext.util.TaskRunner();
taskRunner.start(task);
加载数据有回调
var rec, recs = app.dataGrid.getSelection();
Cs.info(recs);
if (recs.length != 1) {
app.dataStore1.load({params:{
I_BEGIN_DATE:Wb.getVal(app.panel1,'I_BEGIN_DATE'),
I_END_DATE:Wb.getVal(app.panel1,'I_END_DATE'),
I_ACCOUNT_CODE:''
},
callback:function(records,operation,success){
var data = {};
data.params1 = Wb.getData(app.dataGrid1);
Wb.mask(null, '处理中,请稍候...');
Wb.getExcel(data, 'dx_export/银行存款收益明细导出.xlsx', '', ' 银行存款收益明细');
setTimeout(function() {
Wb.unmask(null, '处理中,请稍候...');
}, 3000);
}
});
}
grad点击效果
修改 renderer
if (record.data.IS_EXIST == '1')
return '<button type="button" method="hrefMethod" onclick="Wb.invoke(this,\'' + record.data.PK_ID + '\');">划拨</a>';
else
return '';
[["a","b"],["c","d"]]
计划任务
Packages.cn.hutool.http.HttpUtil.createPost("http://10.xxx.xxx.xxx:8080/ks/m?xwl=xxx/sms_task").charset("UTF-8").execute();
非空字段校验
if(Wb.verify(app.addWin)){
// 。。。逻辑部分
}
最后于 2023-10-26
被admin编辑
,原因: 增加非空校验