From c10fc10d5fd307a7b334bcde6af5c1175aaa0410 Mon Sep 17 00:00:00 2001
From: king <18310653075@163.com>
Date: 星期三, 28 八月 2024 17:47:28 +0800
Subject: [PATCH] 2024-08-28
---
src/utils/utils-custom.js | 500 +++++++++++++++++++++++++++++++++++++++++++-----------
1 files changed, 393 insertions(+), 107 deletions(-)
diff --git a/src/utils/utils-custom.js b/src/utils/utils-custom.js
index 01210e4..2d86e2d 100644
--- a/src/utils/utils-custom.js
+++ b/src/utils/utils-custom.js
@@ -1985,10 +1985,18 @@
let _quot = sql.match(/'{1}/g)
let _lparen = sql.match(/\({1}/g)
let _rparen = sql.match(/\){1}/g)
+ let _ch_b = sql.match(/\$check@/ig)
+ let _ch_d = sql.match(/@check\$/ig)
+ let _m_b = sql.match(/\$@/ig)
+ let _m_d = sql.match(/@\$/ig)
_quot = _quot ? _quot.length : 0
_lparen = _lparen ? _lparen.length : 0
_rparen = _rparen ? _rparen.length : 0
+ _ch_b = _ch_b ? _ch_b.length : 0
+ _ch_d = _ch_d ? _ch_d.length : 0
+ _m_b = _m_b ? _m_b.length : 0
+ _m_d = _m_d ? _m_d.length : 0
if (_quot % 2 !== 0) {
notification.warning({
@@ -2001,6 +2009,20 @@
notification.warning({
top: 92,
message: 'sql涓�()蹇呴』鎴愬鍑虹幇',
+ duration: 5
+ })
+ return false
+ } else if (_ch_b !== _ch_d) {
+ notification.warning({
+ top: 92,
+ message: 'sql涓� $check@ 涓� @check$ 蹇呴』鎴愬鍑虹幇',
+ duration: 5
+ })
+ return false
+ } else if (_m_b !== _m_d) {
+ notification.warning({
+ top: 92,
+ message: 'sql涓� $@ 涓� @$ 蹇呴』鎴愬鍑虹幇',
duration: 5
})
return false
@@ -2855,14 +2877,22 @@
/**
* @description 鑾峰彇鎵ц鑴氭湰
*/
-export function getAllSqls (config) {
+export function getAllSqls (conf) {
+ let config = fromJS(conf).toJS()
+
let sqls = []
let urlFields = config.urlFields
let appType = sessionStorage.getItem('appType')
let process = config.process === 'true'
+ if (urlFields) {
+ urlFields = urlFields.map(n => n.toLowerCase())
+ }
+
let filterComponent = (components, mainSearch) => {
components.forEach(item => {
+ item.$menuname = (config.MenuName || '') + '-' + (item.name || '')
+
if (item.type === 'tabs') {
item.subtabs.forEach(tab => {
let _mainSearch = mainSearch || []
@@ -2888,6 +2918,15 @@
if (appType === 'mob' && item.type !== 'search' && item.type !== 'topbar' && item.search && item.search.length > 0) {
item.search = []
}
+ if (appType !== 'mob' && item.search && item.search.length > 0) {
+ item.search.forEach(cell => {
+ if (['select', 'link', 'multiselect', 'checkcard', 'radio'].includes(cell.type) && cell.resourceType === '1' && cell.dataSource) {
+ let msg = getFormSql(cell)
+
+ sqls.push({uuid: cell.uuid, type: 'sForm', ...msg})
+ }
+ })
+ }
if (item.subtype === 'tablecard') { // 鍏煎
item.type = 'card'
@@ -2901,7 +2940,7 @@
let msg = getDataSource(item, mainSearch)
- sqls.push({uuid: item.uuid, ...msg})
+ sqls.push({uuid: item.uuid, type: 'datasource', ...msg})
} else if (item.setting && item.setting.useMSearch === 'true') {
let searches = item.search || []
if (mainSearch.length > 0) {
@@ -2930,6 +2969,24 @@
resetButton(item, cell)
})
+ } else if (item.subtype === 'editable' && col.editable === 'true') {
+ if (col.editType === 'select' && col.resourceType === '1') {
+ let msg = getFormSql(col)
+
+ sqls.push({uuid: col.uuid, type: 'tbForm', ...msg})
+ } else if (col.editType === 'popSelect') {
+ if (col.pops) {
+ col.pops.forEach(n => {
+ let msg = getPopSelectSql(n)
+
+ sqls.push({uuid: n.uuid, type: 'popSource', ...msg})
+ })
+ } else {
+ let msg = getPopSelectSql(col)
+
+ sqls.push({uuid: col.uuid, type: 'popSource', ...msg})
+ }
+ }
}
})
}
@@ -2939,7 +2996,7 @@
if (item.subtype === 'editable' && item.submit.intertype === 'system') {
let msg = getEditTableSql(item.submit, item.cols, item.columns)
- sqls.push({uuid: 'submit_' + item.uuid, ...msg})
+ sqls.push({uuid: 'submit_' + item.uuid, type: 'editable', ...msg})
}
} else if (item.type === 'card' || item.type === 'carousel' || item.type === 'timeline') {
item.subcards && item.subcards.forEach(card => {
@@ -2991,11 +3048,11 @@
let msg = getSysDefaultSql(cell, _item)
- sqls.push({uuid: cell.uuid, ...msg})
+ sqls.push({uuid: cell.uuid, type: 'button', ...msg})
} else {
let msg = getSysDefaultSql(cell, item)
- sqls.push({uuid: cell.uuid, ...msg})
+ sqls.push({uuid: cell.uuid, type: 'button', ...msg})
}
}
if (cell.callbackType === 'script' && cell.verify && cell.verify.cbScripts) {
@@ -3005,42 +3062,70 @@
let msg = getSysBackSql(cell, _item)
- sqls.push({uuid: 'back_' + cell.uuid, ...msg})
+ sqls.push({uuid: 'back_' + cell.uuid, type: 'btnCallBack', ...msg})
} else {
let msg = getSysBackSql(cell, item)
- sqls.push({uuid: 'back_' + cell.uuid, ...msg})
+ sqls.push({uuid: 'back_' + cell.uuid, type: 'btnCallBack', ...msg})
}
+ }
+ if (['pop', 'formSubmit'].includes(cell.OpenType) && cell.modal && cell.modal.fields) {
+ cell.modal.fields.forEach(form => {
+ // 鏁版嵁婧恠ql璇彞锛岄澶勭悊锛屾潈闄愰粦鍚嶅崟瀛楁璁剧疆涓洪殣钘忚〃鍗�
+ if (['select', 'link', 'multiselect', 'radio', 'checkbox', 'checkcard'].includes(form.type) && form.resourceType === '1') {
+ let msg = getFormSql(form)
+
+ sqls.push({uuid: form.uuid, type: 'form', ...msg})
+ } else if (form.type === 'popSelect') {
+ let msg = getPopSelectSql(form)
+
+ sqls.push({uuid: form.uuid, type: 'popSource', ...msg})
+ }
+ })
}
} else if (cell.OpenType === 'excelIn') {
if (cell.intertype === 'system') {
let msg = getExcelInSql(cell)
- sqls.push({uuid: cell.uuid, ...msg})
+ sqls.push({uuid: cell.uuid, type: 'excelIn', ...msg})
}
} else if (cell.OpenType === 'excelOut') {
if (cell.intertype === 'system' && cell.verify && cell.verify.dataType === 'custom') {
let msg = getExcelOutSql(cell, item)
- sqls.push({uuid: cell.uuid, ...msg})
+ sqls.push({uuid: cell.uuid, type: 'excelOut', ...msg})
}
} else if (cell.OpenType === 'funcbutton') {
if (cell.funcType === 'print') {
if (cell.intertype === 'system' && cell.verify && cell.verify.dataType === 'custom') {
let msg = getPrintSql(cell)
- sqls.push({uuid: cell.uuid, ...msg})
+ sqls.push({uuid: cell.uuid, type: 'print', ...msg})
+ }
+ if (cell.execMode === 'pop' && cell.modal && cell.modal.fields) {
+ cell.modal.fields.forEach(form => {
+ // 鏁版嵁婧恠ql璇彞锛岄澶勭悊锛屾潈闄愰粦鍚嶅崟瀛楁璁剧疆涓洪殣钘忚〃鍗�
+ if (['select', 'link', 'multiselect', 'radio', 'checkbox', 'checkcard'].includes(form.type) && form.resourceType === '1') {
+ let msg = getFormSql(form)
+
+ sqls.push({uuid: form.uuid, type: 'form', ...msg})
+ } else if (form.type === 'popSelect') {
+ let msg = getPopSelectSql(form)
+
+ sqls.push({uuid: form.uuid, type: 'popSource', ...msg})
+ }
+ })
}
} else if ((cell.funcType === 'refund' || cell.funcType === 'pay') && cell.payMode === 'system') {
let msg = getPaySql(cell, item)
- sqls.push({uuid: cell.uuid, ...msg})
+ sqls.push({uuid: cell.uuid, type: 'pay', ...msg})
}
} else if (cell.OpenType === 'innerpage' || cell.OpenType === 'outerpage') {
if (cell.pageTemplate === 'pay' && cell.payMode === 'system') {
let msg = getPaySql(cell, item)
- sqls.push({uuid: cell.uuid, ...msg})
+ sqls.push({uuid: cell.uuid, type: 'pay', ...msg})
}
} else if (cell.OpenType === 'popview') {
if (cell.config && cell.config.components) {
@@ -3074,7 +3159,6 @@
let getSearches = (searches) => {
let sFields = []
- let query = false
searches.forEach(item => {
if (!item.field) return
@@ -3116,13 +3200,9 @@
} else {
sFields.push(item.field)
}
-
- if (query) return
-
- query = item.query !== 'false'
})
- return { sFields, query }
+ return sFields
}
let getSysDefaultSql = (btn, component) => {
@@ -3148,6 +3228,11 @@
verify.invalid = 'false'
} else if (btn.Ot === 'notRequired') {
verify.invalid = 'false'
+ }
+ }
+ if (verify.uniques && verify.uniques.length > 0 && btn.Ot === 'requiredOnce') {
+ if (component.wrap && (component.wrap.datatype === 'static' || component.wrap.datatype === 'public')) {
+ verify.uniques = []
}
}
@@ -4011,6 +4096,9 @@
_sql = _sql.replace(/\$check@/ig, '@mk_check_begin@').replace(/@check\$/ig, '@mk_check_end@')
reps.push('mk_check_begin', 'mk_check_end')
}
+ if (/@db@/ig.test(_sql)) {
+ reps.push('db')
+ }
reps = Array.from(new Set([...reps, ...colreps]))
@@ -4261,6 +4349,9 @@
_sql = _sql.replace(/\$@/ig, '@datam_begin@').replace(/@\$/ig, '@datam_end@')
reps.push('datam_begin', 'datam_end')
}
+ if (/@db@/ig.test(_sql)) {
+ reps.push('db')
+ }
reps = Array.from(new Set([...reps, ...colreps]))
@@ -4270,13 +4361,12 @@
let getDataSource = (item, mainSearch = []) => {
if (!item.setting || item.setting.interType !== 'system') return
- item.setting.primaryKey = item.setting.primaryKey || 'ID'
let searches = item.search || []
if (item.setting.useMSearch === 'true' && mainSearch.length > 0) {
searches = [...searches, ...mainSearch]
}
item.$searches = fromJS(searches).toJS()
- let { sFields, query } = getSearches(searches)
+ let sFields = getSearches(searches)
let _columns = []
if (item.subtype === 'dualdatacard') {
@@ -4303,8 +4393,18 @@
}
})
+ if (_customScript || _tailScript) {
+ _tailScript += `${_tailScript}
+ aaa:
+ if @ErrorCode!=''
+ insert into tmp_err_retmsg (ID, ErrorCode, retmsg, CreateUserID) select @time_id@,@ErrorCode, @retmsg,@UserID@
+ `
+ }
+
+ let _search = ''
if (item.setting.execute !== 'false') {
_dataresource = item.setting.dataresource || ''
+ _search = '@mk_search@'
}
if (/\s/.test(_dataresource)) {
@@ -4313,11 +4413,6 @@
item.setting.dataresource = _dataresource
item.setting.customScript = _customScript
-
- let _search = '@search@'
- if (item.setting.queryType === 'statistics' || !query) {
- _search = ''
- }
let testSql = _dataresource + _customScript + _tailScript
@@ -4325,9 +4420,6 @@
let secSql = [`@ErrorCode='',@retmsg =''`]
let reps = []
- if (_customScript || _tailScript) {
- reps.push('UserID', 'time_id')
- }
let syses = ['UserName', 'FullName', 'RoleID', 'mk_departmentcode', 'mk_organization', 'mk_user_type', 'mk_nation', 'mk_province', 'mk_city', 'mk_district', 'mk_address']
syses.forEach(s => {
@@ -4348,7 +4440,7 @@
select ${secSql.join(',')}`
// 涓嶉渶瑕佸崟寮曞彿锛歰rderBy銆乸ageSize銆乸ageIndex銆乨b
- let regs = [...sFields, 'orderBy', 'pageSize', 'pageIndex', 'typename', 'datam', 'ID', 'BID', 'time_id', 'LoginUID', 'SessionUid', 'UserID', 'Appkey', 'lang', 'typename']
+ let regs = [...sFields, 'orderBy', 'pageSize', 'pageIndex', 'ID', 'BID', 'time_id', 'LoginUID', 'SessionUid', 'UserID', 'Appkey', 'lang', 'datam', 'typename']
if (item.hasExtend) {
regs.push('mk_time')
@@ -4375,105 +4467,83 @@
let LText = ''
let DateCount = ''
if (_dataresource) {
+ /*system_query*/
if (/@pageSize@|@orderBy@|@mk_total/i.test(testSql)) {
- LText = `/*system_query*/select ${arr_field} from ${_dataresource} ${_search} `
+ LText = `select ${arr_field} from ${_dataresource} ${_search} `
} else if (item.setting.laypage === 'true' && item.setting.order) {
- LText = `/*system_query*/select top @pageSize@ ${arr_field} from (select ${arr_field} ,ROW_NUMBER() over(order by @orderBy@) as rows from ${_dataresource} ${_search}) tmptable where rows > @mk_rows_begin@ order by tmptable.rows `
- reps.push('pageSize', 'orderBy', 'mk_rows_begin')
+ LText = `select top @pageSize@ ${arr_field} from (select ${arr_field} ,ROW_NUMBER() over(order by @orderBy@) as rows from ${_dataresource} ${_search}) tmptable where rows > @pageSize@ * (@pageIndex@ - 1) order by tmptable.rows `
+ reps.push('pageSize', 'orderBy', 'pageIndex')
if (item.subtype === 'dualdatacard') {
- DateCount = `/*system_query*/select count(1) as total from (select distinct ${item.setting.primaryKey} from ${_dataresource} ${_search})a`
+ DateCount = `select count(1) as total from (select distinct ${item.setting.primaryKey || 'ID'} from ${_dataresource} ${_search})a`
} else {
- DateCount = `/*system_query*/select count(1) as total from ${_dataresource} ${_search}`
+ DateCount = `select count(1) as total from ${_dataresource} ${_search}`
}
} else if (item.setting.$top) {
if (item.setting.order) {
- LText = `/*system_query*/select top 1 ${arr_field} from ${_dataresource} ${_search} order by @orderBy@ `
+ LText = `select top 1 ${arr_field} from ${_dataresource} ${_search} order by @orderBy@ `
reps.push('orderBy')
} else {
- LText = `/*system_query*/select top 1 ${arr_field} from ${_dataresource} ${_search} `
+ LText = `select top 1 ${arr_field} from ${_dataresource} ${_search} `
}
} else if (item.setting.order) {
- LText = `/*system_query*/select ${arr_field} from ${_dataresource} ${_search} order by @orderBy@ `
+ LText = `select ${arr_field} from ${_dataresource} ${_search} order by @orderBy@ `
reps.push('orderBy')
} else {
- LText = `/*system_query*/select ${arr_field} from ${_dataresource} ${_search} `
+ LText = `select ${arr_field} from ${_dataresource} ${_search} `
}
- }
-
- if (_customScript) {
- _customScript = `${decSql}
- ${_customScript}
- `
- if (DateCount) {
- DateCount = `${DateCount}
- ${_tailScript}
- aaa:
- if @ErrorCode!=''
- insert into tmp_err_retmsg (ID, ErrorCode, retmsg, CreateUserID) select @time_id@,@ErrorCode,@retmsg,@UserID@
- `
- } else if (LText) {
- LText = `${LText}
- ${_tailScript}
- aaa:
- if @ErrorCode!=''
- insert into tmp_err_retmsg (ID, ErrorCode, retmsg, CreateUserID) select @time_id@,@ErrorCode,@retmsg,@UserID@
- `
- } else {
- _customScript = `${_customScript}
- ${_tailScript}
- aaa:
- if @ErrorCode!=''
- insert into tmp_err_retmsg (ID, ErrorCode, retmsg, CreateUserID) select @time_id@,@ErrorCode, @retmsg,@UserID@
- `
- }
- } else if (_tailScript && DateCount) {
- LText = `${decSql}
- ${LText}
- `
- DateCount = `${DateCount}
- ${_tailScript}
- aaa:
- if @ErrorCode!=''
- insert into tmp_err_retmsg (ID, ErrorCode, retmsg, CreateUserID) select @time_id@,@ErrorCode, @retmsg,@UserID@
- `
- } else if (_tailScript) {
- LText = `${decSql}
- ${LText}
- ${_tailScript}
- aaa:
- if @ErrorCode!=''
- insert into tmp_err_retmsg (ID, ErrorCode, retmsg, CreateUserID) select @time_id@,@ErrorCode, @retmsg,@UserID@
- `
- } else {
- LText = `${decSql}
- ${LText}
- `
}
reps = Array.from(new Set(reps))
- LText = LText.replace(/\n\s{6,8}/g, '\n')
- DateCount = DateCount.replace(/\n\s{6,8}/g, '\n')
- _customScript = _customScript.replace(/\n\s{6,8}/g, '\n')
- LText = LText.replace(/\n\s+\/\*/g, `\n/*`)
- DateCount = DateCount.replace(/\n\s+\/\*/g, `\n/*`)
- _customScript = _customScript.replace(/\n\s+\/\*/g, `\n/*`)
+ let sub_name = ''
+ let tabid = ''
+ let parid = ''
+ let sub_field = ''
+
+ if (item.subtype === 'dualdatacard') {
+ arr_field = item.columns.map(col => col.field).join(',')
+ sub_name = item.setting.subdata
+ tabid = item.setting.primaryKey || ''
+ parid = item.setting.subBID || ''
+ sub_field = item.subColumns.map(col => col.field).join(',')
+ }
+
+ let sql = `SELECT obj_name='@mk_obj_name@',prm_field='',str_field='',
+ arr_field='${arr_field}',tabid='${tabid}',parid='${parid}',sub_name='${sub_name}',sub_field='${sub_field}'
+ `
+
+ if (DateCount) {
+ sql += `UNION ALL
+ SELECT obj_name='DateCount',prm_field='total',str_field='',
+ arr_field='',tabid='',parid='',sub_name='',sub_field=''
+ `
+ }
+
+ sql += `
+ ${decSql}
+ ${_customScript}
+ ${LText}
+ ${DateCount}
+ ${_tailScript}
+ `
reps.forEach(n => {
- if (['orderBy', 'pageSize', 'pageIndex', 'mk_rows_begin'].includes(n)) return
+ if (['orderBy', 'pageSize', 'pageIndex'].includes(n)) return
- LText = LText.replace(new RegExp('@' + n + '@', 'ig'), `'@${n}@'`)
- DateCount = DateCount.replace(new RegExp('@' + n + '@', 'ig'), `'@${n}@'`)
- _customScript = _customScript.replace(new RegExp('@' + n + '@', 'ig'), `'@${n}@'`)
+ sql = sql.replace(new RegExp('@' + n + '@', 'ig'), `'@${n}@'`)
})
- if (/\$@/ig.test(testSql)) {
- LText = LText.replace(/\$@/ig, '@datam_begin@').replace(/@\$/ig, '@datam_end@')
- DateCount = DateCount.replace(/\$@/ig, '@datam_begin@').replace(/@\$/ig, '@datam_end@')
- _customScript = _customScript.replace(/\$@/ig, '@datam_begin@').replace(/@\$/ig, '@datam_end@')
+ if (/\$@/ig.test(sql)) {
+ sql = sql.replace(/\$@/ig, '@datam_begin@').replace(/@\$/ig, '@datam_end@')
reps.push('datam_begin', 'datam_end')
}
-
- return {LText, DateCount, customScript: _customScript, reps}
+ if (/@db@/ig.test(sql)) {
+ reps.push('db')
+ }
+ reps.push('mk_obj_name')
+
+ sql = sql.replace(/\n\x20{6,8}/g, '\n').replace(/\n{3,}/g, '\n\n').replace(/^\s+|\s+$/g, '')
+
+ return {LText: sql, reps}
}
let getExcelInSql = (item) => {
@@ -4727,6 +4797,9 @@
sql = sql.replace(/\$@/ig, '@datam_begin@').replace(/@\$/ig, '@datam_end@')
reps.push('datam_begin', 'datam_end')
}
+ if (/@db@/ig.test(sql)) {
+ reps.push('db')
+ }
return {LText: sql, reps}
}
@@ -4958,6 +5031,9 @@
sql = sql.replace(/\$@/ig, '@datam_begin@').replace(/@\$/ig, '@datam_end@')
reps.push('datam_begin', 'datam_end')
}
+ if (/@db@/ig.test(sql)) {
+ reps.push('db')
+ }
return {LText: sql, reps}
}
@@ -4979,7 +5055,6 @@
item.setting.interType = 'system'
item.setting.execute = btn.verify.defaultSql || 'true'
item.setting.dataresource = btn.verify.dataresource || ''
- item.setting.primaryKey = btn.verify.primaryKey || ''
item.setting.queryType = btn.verify.queryType
item.setting.laypage = btn.pagination
item.setting.order = btn.verify.order || ''
@@ -5001,7 +5076,6 @@
item.setting.interType = 'system'
item.setting.execute = btn.verify.setting.defaultSql || 'true'
item.setting.dataresource = btn.verify.setting.dataresource || ''
- item.setting.primaryKey = ''
item.setting.queryType = btn.verify.setting.queryType
item.setting.laypage = 'false'
item.setting.order = btn.verify.setting.order || ''
@@ -5100,8 +5174,210 @@
_sql = _sql.replace(/\$@/ig, '@datam_begin@').replace(/@\$/ig, '@datam_end@')
reps.push('datam_begin', 'datam_end')
}
+ if (/@db@/ig.test(_sql)) {
+ reps.push('db')
+ }
return {LText: _sql, reps}
+ }
+
+ let getFormSql = (item) => {
+ let arrfield = [item.valueField, item.valueText]
+
+ if (item.type === 'checkcard') {
+ arrfield = item.fields ? item.fields.map(f => f.field) : []
+ arrfield.push(item.cardValField)
+ if (item.urlField) {
+ arrfield.push(item.urlField)
+ } else if (item.colorField) {
+ arrfield.push(item.colorField)
+ } else if (item.parentField) {
+ arrfield.push(item.parentField)
+ }
+ }
+
+ if (item.linkField) {
+ arrfield.push(item.linkField)
+ }
+ if (['select', 'radio', 'link', 'checkcard'].includes(item.type) && item.linkSubField && item.linkSubField.length > 0) {
+ arrfield.push(...item.linkSubField)
+ } else if (item.type === 'text' && item.editType === 'select' && item.linkSubField && item.linkSubField.length > 0) { // 鍙紪杈戣〃
+ arrfield.push(...item.linkSubField)
+ }
+ if (item.disableField) {
+ arrfield.push(item.disableField)
+ }
+
+ arrfield = Array.from(new Set(arrfield))
+
+ let _datasource = item.dataSource
+ let sql = ''
+
+ if (/\s/.test(_datasource)) { // 鎷兼帴鍒悕
+ _datasource = '(' + _datasource + ') tb'
+ }
+
+ arrfield = arrfield.join(',')
+
+ if (item.orderBy) {
+ sql = `select distinct ${arrfield},${item.orderBy} as orderfield from ${_datasource} order by orderfield ${item.orderType}`
+ } else {
+ sql = `select distinct ${arrfield} from ${_datasource}`
+ }
+
+ let reps = []
+
+ let decSql = []
+ let secSql = []
+
+ let syses = ['mk_departmentcode', 'mk_organization', 'mk_user_type']
+ syses.forEach(s => {
+ if (new RegExp('@' + s + '[^0-9a-z_]', 'ig').test(sql)) {
+ if (['mk_departmentcode', 'mk_organization'].includes(s)) {
+ decSql.push(`@${s} nvarchar(512)`)
+ } else {
+ decSql.push(`@${s} nvarchar(20)`)
+ }
+ secSql.push(`@${s}=@${s}@`)
+ reps.push(s)
+ }
+ })
+
+ decSql = decSql.join(',')
+ secSql = secSql.join(',')
+
+ if (decSql) {
+ sql = `Declare ${decSql} select ${secSql}
+ ${sql}
+ `
+ }
+
+ let regs = ['ID', 'BID', 'datam', 'LoginUID', 'SessionUid', 'UserID', 'Appkey', 'lang']
+
+ regs.forEach(s => {
+ if (new RegExp('@' + s + '@', 'ig').test(sql)) {
+ reps.push(s)
+ }
+ })
+
+ reps.forEach(n => {
+ sql = sql.replace(new RegExp('@' + n + '@', 'ig'), `'@${n}@'`)
+ })
+
+ if (/\$@/ig.test(sql)) {
+ sql = sql.replace(/\$@/ig, '@datam_begin@').replace(/@\$/ig, '@datam_end@')
+ reps.push('datam_begin', 'datam_end')
+ }
+ if (/@db@/ig.test(sql)) {
+ reps.push('db')
+ }
+
+ return {LText: sql, reps}
+ }
+
+ let getPopSelectSql = (item) => {
+ let arrfield = item.columns.map(f => f.field)
+
+ if (item.linkSubField && item.linkSubField.length > 0) {
+ item.linkSubField.forEach(n => {
+ if (!arrfield.includes(n)) {
+ arrfield.push(n)
+ }
+ })
+ }
+
+ arrfield = arrfield.join(',')
+ if (/\s/.test(item.dataSource)) { // 鎷兼帴鍒悕
+ item.dataSource = '(' + item.dataSource + ') tb'
+ }
+
+ let LText = ''
+ let DateCount = ''
+ let _search = ''
+ let reps = []
+ let sFields = []
+
+ if (item.searchKey) {
+ _search = '@mk_search@'
+ sFields = item.searchKey.split(',')
+ }
+
+ // 涓嶉渶瑕佸崟寮曞彿锛歰rderBy銆乸ageSize銆乸ageIndex銆乨b
+ let regs = [...sFields, 'orderBy', 'pageSize', 'pageIndex', 'ID', 'BID', 'time_id', 'LoginUID', 'SessionUid', 'UserID', 'Appkey', 'lang', 'datam']
+
+ regs.forEach(s => {
+ if (new RegExp('@' + s + '@', 'ig').test(item.dataSource)) {
+ reps.push(s)
+ }
+ })
+
+ let decSql = []
+ let secSql = []
+
+ let syses = ['mk_departmentcode', 'mk_organization', 'mk_user_type']
+ syses.forEach(s => {
+ if (new RegExp('@' + s + '[^0-9a-z_]', 'ig').test(item.dataSource)) {
+ if (['mk_departmentcode', 'mk_organization'].includes(s)) {
+ decSql.push(`@${s} nvarchar(512)`)
+ } else {
+ decSql.push(`@${s} nvarchar(20)`)
+ }
+ secSql.push(`@${s}=@${s}@`)
+ reps.push(s)
+ }
+ })
+
+ decSql = decSql.join(',')
+ secSql = secSql.join(',')
+
+ if (decSql) {
+ decSql = `Declare ${decSql} select ${secSql}`
+ }
+
+ if (item.laypage === 'true') {
+ /*system_query*/
+ LText = `select top @pageSize@ ${arrfield} from (select ${arrfield} ,ROW_NUMBER() over(order by @orderBy@) as rows from ${item.dataSource} ${_search}) tmptable where rows > @pageSize@ * (@pageIndex@ - 1) order by tmptable.rows `
+ DateCount = `select count(1) as total from ${item.dataSource} ${_search}`
+
+ reps.push('pageSize', 'orderBy', 'pageIndex')
+ } else {
+ LText = `select ${arrfield} from ${item.dataSource} ${_search} order by @orderBy@ `
+ reps.push('orderBy')
+ }
+
+ let sql = `SELECT obj_name='data',prm_field='',str_field='',
+ arr_field='${arrfield}',tabid='',parid='',sub_name='',sub_field=''
+ `
+
+ if (DateCount) {
+ sql += `UNION ALL
+ SELECT obj_name='DateCount',prm_field='total',str_field='',
+ arr_field='',tabid='',parid='',sub_name='',sub_field=''
+ `
+ }
+
+ sql += `
+ ${decSql}
+ ${LText}
+ ${DateCount}
+ `
+
+ reps.forEach(n => {
+ if (['orderBy', 'pageSize', 'pageIndex'].includes(n)) return
+
+ sql = sql.replace(new RegExp('@' + n + '@', 'ig'), `'@${n}@'`)
+ })
+ if (/\$@/ig.test(sql)) {
+ sql = sql.replace(/\$@/ig, '@datam_begin@').replace(/@\$/ig, '@datam_end@')
+ reps.push('datam_begin', 'datam_end')
+ }
+ if (/@db@/ig.test(sql)) {
+ reps.push('db')
+ }
+
+ sql = sql.replace(/\n\x20{6,8}/g, '\n').replace(/\n{3,}/g, '\n\n').replace(/^\s+|\s+$/g, '')
+
+ return {LText: sql, reps}
}
let _mainSearch = []
@@ -5138,6 +5414,16 @@
}
search.push(...group.fields)
})
+
+ if (search.length > 0) {
+ search.forEach(cell => {
+ if (['select', 'link', 'multiselect', 'checkcard', 'radio'].includes(cell.type) && cell.resourceType === '1' && cell.dataSource) {
+ let msg = getFormSql(cell)
+
+ sqls.push({uuid: cell.uuid, type: 'sForm', ...msg})
+ }
+ })
+ }
}
if (search.length > 0) {
@@ -5160,7 +5446,7 @@
let msg = getDataSource(m, _mainSearch)
- sqls.push({uuid: m.uuid, ...msg})
+ sqls.push({uuid: m.uuid, type: 'interface', ...msg})
})
}
--
Gitblit v1.8.0