From aa41be24e83653077d85860cb70882551912af24 Mon Sep 17 00:00:00 2001 From: king <18310653075@163.com> Date: 星期五, 28 十月 2022 12:53:25 +0800 Subject: [PATCH] 2022-10-28 --- src/utils/utils.js | 17 +++++++++++++---- 1 files changed, 13 insertions(+), 4 deletions(-) diff --git a/src/utils/utils.js b/src/utils/utils.js index 208c78a..a829fa6 100644 --- a/src/utils/utils.js +++ b/src/utils/utils.js @@ -1369,17 +1369,16 @@ * @return {Object} param 璇锋眰鍙傛暟 * @return {Array} data 鍒楄〃琛屾暟鎹� * @return {Array} columns 鏄剧ず鍒� - * @return {Object} tab 鏍囩淇℃伅 * @return {Boolean} retmsg 鏄惁闇�瑕佹暟鎹繑鍥� */ -export function getSysDefaultSql (btn, setting, formdata, param, data, columns, tab, retmsg = false, moduleParams, getOptions) { +export function getSysDefaultSql (btn, setting, formdata, param, data, columns, retmsg = false, moduleParams, getOptions) { let primaryId = param.ID let BID = param.BID || '' let verify = btn.verify || {} let datavars = {} // 澹版槑鐨勫彉閲忥紝琛ㄥ崟鍙婃樉绀哄垪 let _actionType = null let _callbacksql = '' - let foreignKey = tab && tab.foreignKey ? tab.foreignKey.toLowerCase() : '' + let foreignKey = setting.foreignKey ? setting.foreignKey.toLowerCase() : '' if (verify.default !== 'false') { // 鍒ゆ柇鏄惁浣跨敤榛樿sql _actionType = btn.sqlType @@ -1932,6 +1931,11 @@ values.push('@BID@') } + if (!keys.includes('typename')) { + keys.push('typename') + values.push('@typename@') + } + keys = keys.join(',') values = values.join(',') _insertsql = `insert into ${btn.sql} (${keys}) select ${values};` @@ -1989,6 +1993,9 @@ _form.push('FiYear=@FiYear') } } + if (!_arr.includes('typename')) { + _form.push('typename=@typename@') + } _form = _form.join(',') let _ID = '=@ID@' @@ -2041,7 +2048,7 @@ _sql += ` /* 榛樿sql */ - insert into snote (remark,createuserid,CreateUser,CreateStaff) select left('鍒犻櫎琛�:${btn.sql} 鏁版嵁: ${_msg}${primaryKey}='+@ID@,200),@userid@,@username,@fullname + insert into snote (remark,createuserid,CreateUser,CreateStaff,typename) select left('鍒犻櫎琛�:${btn.sql} 鏁版嵁: ${_msg}${primaryKey}='+@ID@,200),@userid@,@username,@fullname,@typename@ delete ${btn.sql} where ${primaryKey}${_ID};` } else if (_actionType === 'insertOrUpdate') { _sql += ` @@ -2096,6 +2103,7 @@ _sql = _sql.replace(/@SessionUid@/ig, `'${localStorage.getItem('SessionUid') || ''}'`) _sql = _sql.replace(/@UserID@/ig, `'${sessionStorage.getItem('UserID') || ''}'`) _sql = _sql.replace(/@Appkey@/ig, `'${window.GLOB.appkey || ''}'`) + _sql = _sql.replace(/@typename@/ig, `'admin'`) if (window.GLOB.debugger === true || (window.debugger === true && options.sysType !== 'cloud')) { // _sql = _sql.replace(/\n\s{8}/ig, '\n') @@ -2135,6 +2143,7 @@ if (mark.field[1] === 'static') { contrastVal = mark.contrastValue + originVal = originVal + '' } else { contrastVal = record[mark.field[2]] } -- Gitblit v1.8.0