From c7aece35a62b6e91fd98a625bf0e53f64bfbd18d Mon Sep 17 00:00:00 2001 From: king <18310653075@163.com> Date: 星期四, 17 八月 2023 16:22:15 +0800 Subject: [PATCH] 2023-08-17 --- src/utils/utils.js | 84 ++++++++++++++++++++++++++--------------- 1 files changed, 53 insertions(+), 31 deletions(-) diff --git a/src/utils/utils.js b/src/utils/utils.js index b9878c6..566ced2 100644 --- a/src/utils/utils.js +++ b/src/utils/utils.js @@ -1,6 +1,5 @@ import moment from 'moment' import md5 from 'md5' -import options from '@/store/options.js' const formatKeys = [ { key: 'select', value: ' msltk ' }, @@ -798,8 +797,8 @@ let baseurl = '' - if (options.cloudServiceApi) { - baseurl = options.cloudServiceApi.replace(/webapi(.*)$/, '') + if (window.GLOB.cloudServiceApi) { + baseurl = window.GLOB.cloudServiceApi.replace(/webapi(.*)$/, '') } else { baseurl = window.GLOB.baseurl } @@ -898,11 +897,6 @@ let address = sessionStorage.getItem('address') || '' let _sheet = item.sheet - if (window.GLOB.mkHS) { - userName = sessionStorage.getItem('CloudUserName') || '' - fullName = sessionStorage.getItem('CloudFullName') || '' - } - if (window.GLOB.externalDatabase !== null) { _sheet = _sheet.replace(/@db@/ig, window.GLOB.externalDatabase) } @@ -936,14 +930,6 @@ if (script.status === 'false') return let _sql = script.sql - - _sql = _sql.replace(/@ID@/ig, `'${primaryId || ''}'`) - _sql = _sql.replace(/@BID@/ig, `'${BID}'`) - _sql = _sql.replace(/@LoginUID@/ig, `'${sessionStorage.getItem('LoginUID') || ''}'`) - _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 (script.position === 'init') { _initCustomScript += ` @@ -988,7 +974,7 @@ val = val.replace(/'/ig, '"') } - val = val.replace(/(^\s*$)|\t*|\v*/ig, '') + val = val.replace(/(^\s+$)|\t+|\v+/ig, '') if (!val && col.required === 'true') { // 蹇呭~鏍¢獙 errors.push(_position + '鍐呭涓嶅彲涓虹┖') @@ -1023,7 +1009,7 @@ val = moment('19000101', 'YYYYMMDD').add(Math.floor(val - 2), 'days').format('YYYY-MM-DD') } } else if (typeof(val) === 'string') { - val = val.replace(/(^\s*$)|\t*|\v*/ig, '') + val = val.replace(/(^\s+$)|\t+|\v+/ig, '') if (!val && col.required === 'true') { // 鏃堕棿蹇呭~鏍¢獙 errors.push(_position + '鍐呭涓嶅彲涓虹┖') } else if (val && !/^[1-9][0-9]{3}/.test(val)) { // 鏃堕棿姝e垯鏍¢獙 @@ -1150,7 +1136,31 @@ aaa: select @ErrorCode as ErrorCode,@retmsg as retmsg` - if (window.GLOB.debugger === true || (window.debugger === true && options.sysType !== 'cloud')) { + _sql = _sql.replace(/@ID@/ig, `'${primaryId || ''}'`) + _sql = _sql.replace(/@BID@/ig, `'${BID}'`) + _sql = _sql.replace(/@LoginUID@/ig, `'${sessionStorage.getItem('LoginUID') || ''}'`) + _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'`) + + _sqlBottom = _sqlBottom.replace(/@ID@/ig, `'${primaryId || ''}'`) + _sqlBottom = _sqlBottom.replace(/@BID@/ig, `'${BID}'`) + _sqlBottom = _sqlBottom.replace(/@LoginUID@/ig, `'${sessionStorage.getItem('LoginUID') || ''}'`) + _sqlBottom = _sqlBottom.replace(/@SessionUid@/ig, `'${localStorage.getItem('SessionUid') || ''}'`) + _sqlBottom = _sqlBottom.replace(/@UserID@/ig, `'${sessionStorage.getItem('UserID') || ''}'`) + _sqlBottom = _sqlBottom.replace(/@Appkey@/ig, `'${window.GLOB.appkey || ''}'`) + _sqlBottom = _sqlBottom.replace(/@typename@/ig, `'admin'`) + + if (sessionStorage.getItem('dataM') === 'true') { // 鏁版嵁鏉冮檺 + _sql = _sql.replace(/\$@/ig, '/*').replace(/@\$/ig, '*/').replace(/@datam@/ig, '\'Y\'') + _sqlBottom = _sqlBottom.replace(/\$@/ig, '/*').replace(/@\$/ig, '*/').replace(/@datam@/ig, '\'Y\'') + } else { + _sql = _sql.replace(/@\$|\$@/ig, '').replace(/@datam@/ig, '\'\'') + _sqlBottom = _sqlBottom.replace(/@\$|\$@/ig, '').replace(/@datam@/ig, '\'\'') + } + + if (window.GLOB.debugger === true) { let fsql = ` ${_sql} ${_sqlInsert} @@ -1207,11 +1217,6 @@ let _sheet = btn.sheet let BID = data[0].$$BID || '' - - if (window.GLOB.mkHS) { - userName = sessionStorage.getItem('CloudUserName') || '' - fullName = sessionStorage.getItem('CloudFullName') || '' - } if (window.GLOB.externalDatabase !== null) { _sheet = _sheet.replace(/@db@/ig, window.GLOB.externalDatabase) @@ -1368,7 +1373,29 @@ aaa: select @ErrorCode as ErrorCode,@retmsg as retmsg` - if (window.GLOB.debugger === true || (window.debugger === true && options.sysType !== 'cloud')) { + _sql = _sql.replace(/@BID@/ig, `'${BID}'`) + _sql = _sql.replace(/@LoginUID@/ig, `'${sessionStorage.getItem('LoginUID') || ''}'`) + _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'`) + + _sqlBottom = _sqlBottom.replace(/@BID@/ig, `'${BID}'`) + _sqlBottom = _sqlBottom.replace(/@LoginUID@/ig, `'${sessionStorage.getItem('LoginUID') || ''}'`) + _sqlBottom = _sqlBottom.replace(/@SessionUid@/ig, `'${localStorage.getItem('SessionUid') || ''}'`) + _sqlBottom = _sqlBottom.replace(/@UserID@/ig, `'${sessionStorage.getItem('UserID') || ''}'`) + _sqlBottom = _sqlBottom.replace(/@Appkey@/ig, `'${window.GLOB.appkey || ''}'`) + _sqlBottom = _sqlBottom.replace(/@typename@/ig, `'admin'`) + + if (sessionStorage.getItem('dataM') === 'true') { // 鏁版嵁鏉冮檺 + _sql = _sql.replace(/\$@/ig, '/*').replace(/@\$/ig, '*/').replace(/@datam@/ig, '\'Y\'') + _sqlBottom = _sqlBottom.replace(/\$@/ig, '/*').replace(/@\$/ig, '*/').replace(/@datam@/ig, '\'Y\'') + } else { + _sql = _sql.replace(/@\$|\$@/ig, '').replace(/@datam@/ig, '\'\'') + _sqlBottom = _sqlBottom.replace(/@\$|\$@/ig, '').replace(/@datam@/ig, '\'\'') + } + + if (window.GLOB.debugger === true) { let fsql = ` ${_sql} ${_sqlInsert} @@ -1599,11 +1626,6 @@ let city = sessionStorage.getItem('city') || '' let district = sessionStorage.getItem('district') || '' let address = sessionStorage.getItem('address') || '' - - if (window.GLOB.mkHS) { - userName = sessionStorage.getItem('CloudUserName') || '' - fullName = sessionStorage.getItem('CloudFullName') || '' - } // 鍒濆鍖栧嚟璇佸強鐢ㄦ埛淇℃伅瀛楁 _sql += ` @@ -2164,7 +2186,7 @@ _sql = _sql.replace(/@datam@/ig, '\'\'') } - if (window.GLOB.debugger === true || (window.debugger === true && options.sysType !== 'cloud')) { + if (window.GLOB.debugger === true) { // _sql = _sql.replace(/\n\s{8}/ig, '\n') console.info(_sql) } -- Gitblit v1.8.0