From 24842b40de5cd60700bf69dfd38a0332f5431e36 Mon Sep 17 00:00:00 2001 From: king <18310653075@163.com> Date: 星期五, 23 五月 2025 10:55:07 +0800 Subject: [PATCH] Merge branch 'master' into positec --- src/menu/datasource/verifycard/utils.jsx | 235 +++++++++++++++++++++++++++++----------------------------- 1 files changed, 118 insertions(+), 117 deletions(-) diff --git a/src/menu/datasource/verifycard/utils.jsx b/src/menu/datasource/verifycard/utils.jsx index b04140c..c679a71 100644 --- a/src/menu/datasource/verifycard/utils.jsx +++ b/src/menu/datasource/verifycard/utils.jsx @@ -1,4 +1,7 @@ +import md5 from 'md5' +import { getSearchRegs, joinMainSearchkey } from '@/utils/utils-custom.js' + export default class SettingUtils { /** * @description 鐢熸垚椤甸潰鏌ヨ璇彞 @@ -7,7 +10,7 @@ * @return {Object} setting 椤甸潰璁剧疆 * @return {Array} columns 鏄剧ず瀛楁 */ - static getDebugSql (setting, scripts, columns, searches = [], defSearch, type, timestamp) { + static getDebugSql (setting, scripts, columns, searches = [], type, hasExtend) { let sql = '' let error = '' let _dataresource = '' @@ -34,58 +37,67 @@ if (setting.interType === 'system' && setting.execute !== 'false') { _dataresource = setting.dataresource || '' } - - if (/\s/.test(_dataresource)) { - _dataresource = '(' + _dataresource + ') tb' - } - if (window.GLOB.funcs && window.GLOB.funcs.length > 0) { - window.GLOB.funcs.forEach(item => { - let reg = new RegExp('\\$ex@' + item.func_code + '@ex\\$', 'ig') - _dataresource = _dataresource.replace(reg, `/*$ex@${item.func_code}-begin*/\n${item.key_sql}\n/*@ex$-end*/`) - _customScript = _customScript.replace(reg, `/*$ex@${item.func_code}-begin*/\n${item.key_sql}\n/*@ex$-end*/`) - }) + // if (window.GLOB.funcs && window.GLOB.funcs.length > 0) { + // window.GLOB.funcs.forEach(item => { + // let reg = new RegExp('\\$ex@' + item.func_code + '@ex\\$', 'ig') + // _dataresource = _dataresource.replace(reg, `/*$ex@${item.func_code}-begin*/\n${item.key_sql}\n/*@ex$-end*/`) + // _customScript = _customScript.replace(reg, `/*$ex@${item.func_code}-begin*/\n${item.key_sql}\n/*@ex$-end*/`) + // }) + // } + + let regs = [ + // {reg: /@time_id@/ig, value: `'${getuuid()}'`}, // 璁$畻md5鍚庢浛鎹� + // {reg: /@BID@/ig, value: `'${getuuid()}'`}, + // {reg: /@upid@/ig, value: `'${getuuid()}'`}, + {reg: /@typename@/ig, value: `'debug'`}, + {reg: /@datam@/ig, value: `''`}, + {reg: /@LoginUID@/ig, value: `'${sessionStorage.getItem('LoginUID')}'`}, + {reg: /@SessionUid@/ig, value: `'${localStorage.getItem('SessionUid')}'`}, + {reg: /@UserID@/ig, value: `'${sessionStorage.getItem('UserID')}'`}, + {reg: /@Appkey@/ig, value: `'${window.GLOB.appkey}'`}, + {reg: /@lang@/ig, value: `'${sessionStorage.getItem('lang')}'`}, + {reg: /@\$|\$@/ig, value: ''}, + // {reg: /@select\$|\$select@/ig, value: ''}, + // {reg: /@sum\$|\$sum@/ig, value: ''}, + ] + + if (window.GLOB.process && type !== 'invoice') { + regs.push({reg: /@works_flow_code@/ig, value: `'mk_flow_code'`}) } - _dataresource = _dataresource.replace(/@(BID|LoginUID|SessionUid|UserID|Appkey|time_id|datam|upid|typename)@/ig, `'${timestamp}'`) - _customScript = _customScript.replace(/@(BID|LoginUID|SessionUid|UserID|Appkey|time_id|datam|upid|typename)@/ig, `'${timestamp}'`) - _tailScript = _tailScript.replace(/@(BID|LoginUID|SessionUid|UserID|Appkey|time_id|datam|upid|typename)@/ig, `'${timestamp}'`) - - _dataresource = _dataresource.replace(/@\$|\$@/ig, '') - _customScript = _customScript.replace(/@\$|\$@/ig, '') - _tailScript = _tailScript.replace(/@\$|\$@/ig, '') - - if (window.GLOB.process) { - _dataresource = _dataresource.replace(/@works_flow_code@/ig, `'${timestamp}'`) - _customScript = _customScript.replace(/@works_flow_code@/ig, `'${timestamp}'`) - _tailScript = _tailScript.replace(/@works_flow_code@/ig, `'${timestamp}'`) + if (hasExtend) { + regs.push({reg: /@mk_time@/ig, value: `'2024-04-29 17:20:00'`}) } - - _dataresource = _dataresource.replace(/@select\$|\$select@/ig, '') - _customScript = _customScript.replace(/@select\$|\$select@/ig, '') - _customScript = _customScript.replace(/@sum\$|\$sum@/ig, '') - _dataresource = _dataresource.replace(/\$sum@/ig, '/*') - _dataresource = _dataresource.replace(/@sum\$/ig, '*/') - if (type === 'calendar') { - _dataresource = _dataresource.replace(/@mk_year@/ig, '') - _customScript = _customScript.replace(/@mk_year@/ig, '') + regs.push({reg: /@mk_year@/ig, value: `'2024'`}) } - - if (_customScript) { - _customScript = `declare @ErrorCode nvarchar(50),@retmsg nvarchar(4000),@UserName nvarchar(50),@FullName nvarchar(50),@RoleID nvarchar(512),@mk_departmentcode nvarchar(512),@mk_organization nvarchar(512),@mk_user_type nvarchar(20),@mk_nation nvarchar(50),@mk_province nvarchar(50),@mk_city nvarchar(50),@mk_district nvarchar(50),@mk_address nvarchar(100) select @ErrorCode='',@retmsg ='' - ${_customScript} - ` + if (window.GLOB.getLocation) { + regs.push( + {reg: /@mk_longitude@/ig, value: 0}, + {reg: /@mk_latitude@/ig, value: 0} + ) } // 澶栬仈鏁版嵁搴撴浛鎹� if (window.GLOB.externalDatabase !== null) { - _dataresource = _dataresource.replace(/@db@/ig, window.GLOB.externalDatabase) - _customScript = _customScript.replace(/@db@/ig, window.GLOB.externalDatabase) - _tailScript = _tailScript.replace(/@db@/ig, window.GLOB.externalDatabase) + regs.push({reg: /@db@/ig, value: window.GLOB.externalDatabase}) } - if (window.GLOB.urlFields) { + regs.forEach(item => { + _dataresource = _dataresource.replace(item.reg, item.value) + _customScript = _customScript.replace(item.reg, item.value) + _tailScript = _tailScript.replace(item.reg, item.value) + }) + + if (_customScript) { + _customScript = `declare @ErrorCode nvarchar(50),@retmsg nvarchar(4000),@UserName nvarchar(50),@FullName nvarchar(50),@RoleID nvarchar(512),@mk_departmentcode nvarchar(512),@mk_organization nvarchar(512),@mk_user_type nvarchar(20),@mk_nation nvarchar(50),@mk_province nvarchar(50),@mk_city nvarchar(50),@mk_district nvarchar(50),@mk_address nvarchar(100) + select @ErrorCode='',@retmsg ='',@UserName='', @FullName='', @RoleID='', @mk_departmentcode='', @mk_organization='', @mk_user_type='', @mk_nation='', @mk_province='', @mk_city='', @mk_district='', @mk_address='' + ${_customScript} + ` + } + + if (window.GLOB.urlFields && type !== 'invoice') { window.GLOB.urlFields.forEach(field => { let reg = new RegExp('@' + field + '@', 'ig') _dataresource = _dataresource.replace(reg, `'0'`) @@ -94,79 +106,45 @@ }) } - // 姝e垯鏇挎崲 - let _regoptions = [] - let _fields = [] - let custompage = /@pageSize@|@orderBy@/i.test(_dataresource + _customScript) + let custompage = false - searches.forEach(item => { - if (!item.field) return - if (item.datefield) { - _regoptions.push({ - var: new RegExp('@' + item.datefield, 'ig'), - reg: new RegExp('@' + item.datefield + '@', 'ig') - }) - _regoptions.push({ - var: new RegExp('@' + item.datefield + '1', 'ig'), - reg: new RegExp('@' + item.datefield + '1@', 'ig') - }) - } - if (['dateweek', 'datemonth', 'daterange', 'range'].includes(item.type)) { - _regoptions.push({ - var: new RegExp('@' + item.field, 'ig'), - reg: new RegExp('@' + item.field + '@', 'ig') - }) - _regoptions.push({ - var: new RegExp('@' + item.field + '1', 'ig'), - reg: new RegExp('@' + item.field + '1@', 'ig') - }) - } else if (item.type === 'date') { - if (_fields.includes(item.field)) { - _regoptions.push({ - var: new RegExp('@' + item.field + '1', 'ig'), - reg: new RegExp('@' + item.field + '1@', 'ig') - }) - } else { - _fields.push(item.field) - _regoptions.push({ - var: new RegExp('@' + item.field, 'ig'), - reg: new RegExp('@' + item.field + '@', 'ig') - }) - } - } else if (item.type === 'text' || item.type === 'select') { - item.field.split(',').forEach(field => { - _regoptions.push({ - var: new RegExp('@' + field, 'ig'), - reg: new RegExp('@' + field + '@', 'ig') - }) - }) - } else { - _regoptions.push({ - var: new RegExp('@' + item.field, 'ig'), - reg: new RegExp('@' + item.field + '@', 'ig') - }) - } - }) + if (/order\s+by\s+sort_id\s*$/i.test(_dataresource)) { + custompage = true + } else if (/@pageSize@|@orderBy@|@mk_total/i.test(_dataresource + _customScript)) { + custompage = true + } + + if (/\s/.test(_dataresource)) { + _dataresource = '(' + _dataresource + ') tb' + } + + // 姝e垯鏇挎崲 + let _regoptions = getSearchRegs(searches) + + let _search = joinMainSearchkey(searches) _regoptions.push({ + reg: new RegExp('@userName@', 'ig'), + value: `'mk'` + }, { + reg: new RegExp('@fullName@', 'ig'), + value: `'mk'` + }, { reg: new RegExp('@orderBy@', 'ig'), - }, { - reg: new RegExp('@UserName@', 'ig'), - }, { - reg: new RegExp('@FullName@', 'ig'), + value: setting.order || '' }, { reg: new RegExp('@pageSize@', 'ig'), + value: 9999 }, { reg: new RegExp('@pageIndex@', 'ig'), + value: 1 }) _regoptions.forEach(item => { - _dataresource = _dataresource.replace(item.reg, '0') - _customScript = _customScript.replace(item.reg, '0') - _tailScript = _tailScript.replace(item.reg, '0') + _dataresource = _dataresource.replace(item.reg, item.value || '0') + _customScript = _customScript.replace(item.reg, item.value || '0') + _tailScript = _tailScript.replace(item.reg, item.value || '0') }) - - let _search = defSearch if (setting.queryType === 'statistics') { _search = '' @@ -176,39 +154,60 @@ if (_dataresource) { if (custompage) { _dataresource = `/*system_query*/select ${arr_field} from ${_dataresource} ${_search}` + } else if (setting.laypage === 'true' && setting.order) { + _dataresource = `/*system_query*/select top 10 ${arr_field} from (select ${arr_field} ,ROW_NUMBER() over(order by ${setting.order}) as rows from ${_dataresource} ${_search}) tmptable where rows > 0 order by tmptable.rows` } else if (setting.order) { - _dataresource = `/*system_query*/select${setting.laypage === 'true' ? ' top 10' : ''} ${arr_field} from (select ${arr_field} ,ROW_NUMBER() over(order by ${setting.order}) as rows from ${_dataresource} ${_search}) tmptable ${setting.laypage === 'true' ? 'where rows > 0' : ''} order by tmptable.rows` + _dataresource = `/*system_query*/select ${arr_field} from (select ${arr_field} ,ROW_NUMBER() over(order by ${setting.order}) as rows from ${_dataresource} ${_search}) tmptable order by tmptable.rows` } else { _dataresource = `/*system_query*/select ${arr_field} from ${_dataresource} ${_search}` } } if (_customScript) { - sql = `/* sql 楠岃瘉 */ - ${_customScript} + sql = `${_customScript} ${_dataresource} ${_tailScript} aaa: if @ErrorCode!='' - insert into tmp_err_retmsg (ID, ErrorCode, retmsg, CreateUserID) select '${timestamp}',@ErrorCode, @retmsg,'${timestamp}' + insert into tmp_err_retmsg (ID, ErrorCode, retmsg, CreateUserID) select @time_id@,@ErrorCode, @retmsg,'1949-10-01 15:00:00' ` } else if (_tailScript) { - sql = `/* sql 楠岃瘉 */ - declare @ErrorCode nvarchar(50),@retmsg nvarchar(4000),@UserName nvarchar(50),@FullName nvarchar(50),@RoleID nvarchar(512),@mk_departmentcode nvarchar(512),@mk_organization nvarchar(512),@mk_user_type nvarchar(20),@mk_nation nvarchar(50),@mk_province nvarchar(50),@mk_city nvarchar(50),@mk_district nvarchar(50),@mk_address nvarchar(100) select @ErrorCode='',@retmsg ='' + sql = `declare @ErrorCode nvarchar(50),@retmsg nvarchar(4000),@UserName nvarchar(50),@FullName nvarchar(50),@RoleID nvarchar(512),@mk_departmentcode nvarchar(512),@mk_organization nvarchar(512),@mk_user_type nvarchar(20),@mk_nation nvarchar(50),@mk_province nvarchar(50),@mk_city nvarchar(50),@mk_district nvarchar(50),@mk_address nvarchar(100) + select @ErrorCode='',@retmsg ='',@UserName='', @FullName='', @RoleID='', @mk_departmentcode='', @mk_organization='', @mk_user_type='', @mk_nation='', @mk_province='', @mk_city='', @mk_district='', @mk_address='' ${_dataresource} ${_tailScript} aaa: if @ErrorCode!='' - insert into tmp_err_retmsg (ID, ErrorCode, retmsg, CreateUserID) select '${timestamp}',@ErrorCode, @retmsg,'${timestamp}' + insert into tmp_err_retmsg (ID, ErrorCode, retmsg, CreateUserID) select @time_id@,@ErrorCode, @retmsg,'1949-10-01 15:00:00' ` } else { - sql = `/* sql 楠岃瘉 */ - declare @ErrorCode nvarchar(50),@retmsg nvarchar(4000),@UserName nvarchar(50),@FullName nvarchar(50),@RoleID nvarchar(512),@mk_departmentcode nvarchar(512),@mk_organization nvarchar(512),@mk_user_type nvarchar(20),@mk_nation nvarchar(50),@mk_province nvarchar(50),@mk_city nvarchar(50),@mk_district nvarchar(50),@mk_address nvarchar(100) select @ErrorCode='',@retmsg ='' + sql = `declare @ErrorCode nvarchar(50),@retmsg nvarchar(4000),@UserName nvarchar(50),@FullName nvarchar(50),@RoleID nvarchar(512),@mk_departmentcode nvarchar(512),@mk_organization nvarchar(512),@mk_user_type nvarchar(20),@mk_nation nvarchar(50),@mk_province nvarchar(50),@mk_city nvarchar(50),@mk_district nvarchar(50),@mk_address nvarchar(100) + select @ErrorCode='',@retmsg ='',@UserName='', @FullName='', @RoleID='', @mk_departmentcode='', @mk_organization='', @mk_user_type='', @mk_nation='', @mk_province='', @mk_city='', @mk_district='', @mk_address='' ${_dataresource}` } - sql = sql.replace(/\n\s{8}/ig, '\n') - console.info(sql) + let debugId = md5(sql + window.GLOB.appkey) + + let getuuid = () => { + let uuid = [] + let timestamp = new Date().getTime() + let _options = '0123456789abcdefghigklmnopqrstuv' + for (let i = 0; i < 19; i++) { + uuid.push(_options.substr(Math.floor(Math.random() * 0x20), 1)) + } + uuid = timestamp + uuid.join('') + return uuid + } + + let _regs = [ + {reg: /@time_id@/ig, value: `'${getuuid()}'`}, + {reg: /@BID@/ig, value: `'${getuuid()}'`}, + {reg: /@upid@/ig, value: `'${getuuid()}'`}, + ] + + _regs.forEach(item => { + sql = sql.replace(item.reg, item.value) + }) let errors = [] @@ -248,14 +247,16 @@ } _scripts.forEach(script => { if (reg.test(script.sql)) { - errors.push(`鑷畾涔夎剼鏈�(${script.$index || ''})瀛樺湪鏈浛鎹㈠��${item}`) + if (script.$index) { + errors.push(`鑷畾涔夎剼鏈�(${script.$index})瀛樺湪鏈浛鎹㈠��${item}`) + } else { + errors.push(`鑷畾涔夎剼鏈腑瀛樺湪鏈浛鎹㈠��${item}`) + } } }) }) } - sql = sql.replace(/\n/g, ' ') - - return { error, sql, errors: errors.join('锛�') } + return { error, sql, errors: errors.join('锛�'), custompage, debugId } } } \ No newline at end of file -- Gitblit v1.8.0