From 8f394e7ef20cc0abba3f47c23a63b069e9dd0e45 Mon Sep 17 00:00:00 2001
From: king <18310653075@163.com>
Date: 星期三, 19 十月 2022 15:09:30 +0800
Subject: [PATCH] 2022-10-19
---
src/utils/utils-custom.js | 718 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++---
1 files changed, 674 insertions(+), 44 deletions(-)
diff --git a/src/utils/utils-custom.js b/src/utils/utils-custom.js
index 058d369..cbd1923 100644
--- a/src/utils/utils-custom.js
+++ b/src/utils/utils-custom.js
@@ -3,23 +3,26 @@
* @description 鑾峰彇涓嬬骇妯″潡
* @return {String} selfId 褰撳墠缁勪欢id
*/
- static getSubModules (components, selfId) {
+ static getSubModules (components, selfId, supId) {
let modules = components.map(item => {
- if (item.uuid === selfId) {
+ if (item.uuid === selfId || item.type === 'navbar') {
return {
children: null
}
} else if (item.format) { // 鏁版嵁鏍煎紡锛屽瓨鍦ㄦ暟鎹簮
return {
value: item.uuid,
- label: item.name
+ label: item.name,
+ disabled: supId === item.uuid
}
} else if (item.type === 'tabs') {
let _item = {
+ type: 'tabs',
value: item.uuid,
label: item.name,
children: item.subtabs.map(f_tab => {
let subItem = {
+ type: 'tab',
value: f_tab.uuid,
label: f_tab.label,
children: this.getSubModules(f_tab.components, selfId)
@@ -83,6 +86,91 @@
}
/**
+ * @description 鑾峰彇涓嬬骇妯″潡
+ * @return {String} selfId 褰撳墠缁勪欢id
+ */
+ static getAnchors (components, selfId) {
+ let modules = components.map(item => {
+ if (item.uuid === selfId) {
+ return {
+ children: null
+ }
+ } else if (item.type === 'tabs') {
+ let _item = {
+ type: 'tabs',
+ value: item.uuid,
+ label: item.name,
+ children: item.subtabs.map(f_tab => {
+ let subItem = {
+ type: 'tab',
+ value: f_tab.uuid,
+ label: f_tab.label,
+ children: this.getSubModules(f_tab.components, selfId)
+ }
+
+ if (!subItem.children || subItem.children.length === 0) {
+ return {children: null}
+ }
+ return subItem
+ })
+ }
+
+ _item.children = _item.children.filter(t => t.children !== null)
+
+ if (_item.children.length === 0) {
+ return {children: null}
+ }
+
+ return _item
+ } else if (item.type === 'group') {
+ let _item = {
+ value: item.uuid,
+ label: item.name,
+ children: item.components.map(f_tab => {
+ if (f_tab.uuid === selfId) {
+ return {
+ children: null
+ }
+ } else if (f_tab.format) {
+ return {
+ value: f_tab.uuid,
+ label: f_tab.name
+ }
+ }
+ return {
+ children: null
+ }
+ })
+ }
+
+ _item.children = _item.children.filter(t => t.children !== null)
+
+ if (_item.children.length === 0) {
+ return {children: null}
+ }
+
+ return _item
+ } else if (!['login', 'navbar', 'topbar', 'tabs', 'search', 'group', 'balcony'].includes(item.type)) { // 鏁版嵁鏍煎紡锛屽瓨鍦ㄦ暟鎹簮
+ return {
+ value: item.uuid,
+ label: item.name
+ }
+ } else {
+ return {
+ children: null
+ }
+ }
+ })
+
+ modules = modules.filter(mod => mod.children !== null)
+
+ if (modules.length === 0) {
+ return null
+ }
+ return modules
+ }
+
+ /**
* @description 鑾峰彇涓婄骇妯″潡
* @return {String} selfId 褰撳墠缁勪欢id
*/
@@ -93,6 +181,18 @@
children: null
}
} else if (item.switchable) { // 鏁版嵁鍙垏鎹�
+ let disabled = false
+ if (item.type === 'card') {
+ disabled = item.wrap.cardType === ''
+ } else if (item.type === 'table') {
+ disabled = item.wrap.tableType === ''
+ }
+ return {
+ value: item.uuid,
+ label: item.name,
+ disabled: disabled
+ }
+ } else if (item.type === 'form') { // 鏁版嵁鏍煎紡锛屽瓨鍦ㄦ暟鎹簮
return {
value: item.uuid,
label: item.name
@@ -267,8 +367,8 @@
uuids.push(act.uuid)
})
- if (card.type === 'card' || item.type === 'carousel' || (card.type === 'table' && card.subtype === 'tablecard')) {
- card.subcards.forEach(_card => {
+ if (['card', 'carousel', 'timeline'].includes(item.type) || (item.type === 'table' && item.subtype === 'tablecard')) {
+ item.subcards.forEach(_card => {
_card.elements && _card.elements.forEach(cell => {
if (cell.eleType !== 'button') return
if (appType === 'pc' && cell.OpenType !== 'popview') return
@@ -282,8 +382,8 @@
uuids.push(cell.uuid)
})
})
- } else if (card.type === 'table' && card.subtype === 'normaltable') {
- card.cols && card.cols.forEach(col => {
+ } else if (item.type === 'table' && (item.subtype === 'normaltable' || item.subtype === 'editable')) {
+ item.cols && item.cols.forEach(col => {
if (col.type !== 'action') return
col.elements && col.elements.forEach(cell => {
if (appType === 'pc' && cell.OpenType !== 'popview') return
@@ -291,8 +391,8 @@
uuids.push(cell.uuid)
})
})
- } else if (card.type === 'balcony') {
- card.elements && card.elements.forEach(cell => {
+ } else if (item.type === 'balcony') {
+ item.elements && item.elements.forEach(cell => {
if (appType === 'pc' && cell.OpenType !== 'popview') return
uuids.push(cell.uuid)
@@ -322,57 +422,97 @@
}
/**
- * @description 閲嶇疆鑿滃崟閰嶇疆
+ * @description 閲嶇疆鑿滃崟閰嶇疆锛岄〉闈㈡暣浣撳鍒�
* @return {String} components 閰嶇疆淇℃伅
*/
- static resetConfig = (components) => {
+ static resetConfig = (components, uuids = {}, clear = false) => {
return components.map(item => {
if (item.type === 'navbar') {
return item
}
- item.uuid = this.getuuid()
+ uuids[item.uuid] = this.getuuid()
+ item.uuid = uuids[item.uuid]
if (item.type === 'tabs') {
item.subtabs.forEach(tab => {
- tab.uuid = this.getuuid()
- tab.parentId = item.uuid
-
- tab.components = tab.components.map(cell => {
- cell.tabId = tab.uuid
- cell.parentId = item.uuid
- return cell
- })
- tab.components = this.resetConfig(tab.components)
+ uuids[tab.uuid] = this.getuuid()
+ tab.uuid = uuids[tab.uuid]
+
+ tab.components = this.resetConfig(tab.components, uuids, clear)
})
} else if (item.type === 'group') {
- item.components = item.components.map(cell => {
- cell.parentId = item.uuid
- return cell
- })
- item.components = this.resetConfig(item.components)
+ item.components = this.resetConfig(item.components, uuids, clear)
} else if (item.type === 'menubar') {
item.subMenus = item.subMenus.map(cell => {
cell.uuid = this.getuuid()
+ if (clear && cell.setting.type === 'linkmenu') {
+ cell.setting.type = 'menu'
+ cell.setting.linkMenuId = ''
+ }
return cell
})
- } else if (item.type === 'card' || item.type === 'carousel' || (item.type === 'table' && item.subtype === 'tablecard')) {
+ } else if (['card', 'carousel', 'timeline'].includes(item.type) || (item.type === 'table' && item.subtype === 'tablecard')) {
+ if (item.wrap.datatype === 'public' && uuids[item.wrap.publicId]) {
+ item.wrap.publicId = uuids[item.wrap.publicId]
+ }
+
item.subcards.forEach(card => {
card.uuid = this.getuuid()
+
+ if (clear) {
+ if (card.setting.click === 'menu') {
+ card.setting.click = ''
+ card.setting.menu = ''
+ } else if (card.setting.click === 'menus') {
+ card.setting.click = ''
+ card.setting.menuType = ''
+ delete card.menus
+ }
+ }
+
if (card.elements) {
card.elements = card.elements.map(cell => {
cell.uuid = this.getuuid()
+
+ if (clear && cell.eleType === 'button' && cell.pageTemplate === 'linkpage' && cell.linkmenu) {
+ cell.pageTemplate = ''
+ cell.linkmenu = ''
+ }
+
return cell
})
}
if (card.backElements) {
card.backElements = card.backElements.map(cell => {
cell.uuid = this.getuuid()
+
+ if (clear && cell.eleType === 'button' && cell.pageTemplate === 'linkpage' && cell.linkmenu) {
+ cell.pageTemplate = ''
+ cell.linkmenu = ''
+ }
+
return cell
})
}
})
- } else if (item.type === 'table' && item.subtype === 'normaltable' && item.cols) {
+ } else if (item.type === 'balcony') {
+ if (item.wrap.datatype === 'public' && uuids[item.wrap.publicId]) {
+ item.wrap.publicId = uuids[item.wrap.publicId]
+ }
+ if (item.elements) {
+ item.elements = item.elements.map(cell => {
+ cell.uuid = this.getuuid()
+
+ if (clear && cell.eleType === 'button' && cell.pageTemplate === 'linkpage' && cell.linkmenu) {
+ cell.pageTemplate = ''
+ cell.linkmenu = ''
+ }
+
+ return cell
+ })
+ }
+ } else if (item.type === 'table' && (item.subtype === 'normaltable' || item.subtype === 'editable') && item.cols) {
let loopCol = (col) => {
col.subcols = col.subcols.map(c => {
c.uuid = this.getuuid()
@@ -382,11 +522,18 @@
} else if (c.type === 'custom' && c.elements) {
c.elements = c.elements.map(cell => {
cell.uuid = this.getuuid()
+
return cell
})
} else if (c.type === 'action' && c.elements) {
c.elements = c.elements.map(cell => {
cell.uuid = this.getuuid()
+
+ if (clear && cell.pageTemplate === 'linkpage' && cell.linkmenu) {
+ cell.pageTemplate = ''
+ cell.linkmenu = ''
+ }
+
return cell
})
}
@@ -395,9 +542,12 @@
return col
}
-
+ let _uuids = {}
item.cols = item.cols.map(col => {
- col.uuid = this.getuuid()
+ let uuid = this.getuuid()
+
+ _uuids[col.uuid] = uuid
+ col.uuid = uuid
if (col.type === 'colspan' && col.subcols) {
col = loopCol(col)
@@ -414,19 +564,69 @@
}
return col
})
- }
-
- if (item.btnlog) {
- item.btnlog = []
- }
-
- if (item.action) {
- item.action = item.action.map(cell => {
+
+ if (item.subtype === 'editable') {
+ item.cols = item.cols.map(col => {
+ if (col.editable === 'true' && col.enter && _uuids[col.enter]) {
+ col.enter = _uuids[col.enter]
+ }
+ return col
+ })
+ }
+ } else if (item.type === 'form') {
+ item.subcards = item.subcards.map(cell => {
cell.uuid = this.getuuid()
+
+ cell.fields = cell.fields.map(m => {
+ m.uuid = this.getuuid()
+
+ return m
+ })
return cell
})
}
- if (item.search) {
+
+ if (item.btnlog) {
+ item.btnlog = null
+ }
+
+ let oriUids = {}
+ if (item.action) {
+ item.action = item.action.map(cell => {
+ let _uuid = this.getuuid()
+
+ oriUids[cell.uuid] = _uuid
+ cell.uuid = _uuid
+
+ if (clear && cell.pageTemplate === 'linkpage' && cell.linkmenu) {
+ cell.pageTemplate = ''
+ cell.linkmenu = ''
+ }
+
+ return cell
+ })
+ }
+ if (item.type === 'topbar') {
+ if (item.search && item.search.fields) {
+ item.search.fields = item.search.fields.map(cell => {
+ cell.uuid = this.getuuid()
+ return cell
+ })
+ }
+ if (item.search && item.search.groups) {
+ item.search.groups = item.search.groups.map(cell => {
+ cell.uuid = this.getuuid()
+ cell.fields = cell.fields.map(m => {
+ m.uuid = this.getuuid()
+ return m
+ })
+ return cell
+ })
+ }
+ if (clear && item.wrap.menus) {
+ item.wrap.menus = []
+ }
+ } else if (item.search) {
item.search = item.search.map(cell => {
cell.uuid = this.getuuid()
return cell
@@ -438,9 +638,275 @@
return cell
})
}
+
+ if (item.setting && item.setting.supModule && item.setting.supModule[0] !== 'empty') {
+ let em = false
+ item.setting.supModule = item.setting.supModule.map(c => {
+ if (!uuids[c]) {
+ em = true
+ }
+ return uuids[c] || ''
+ })
+ if (em) {
+ item.setting.supModule = ''
+ }
+ }
+
+ if (item.wrap && item.wrap.doubleClick) {
+ item.wrap.doubleClick = oriUids[item.wrap.doubleClick] || ''
+ }
return item
})
+ }
+
+ /**
+ * @description 缁勪欢鍚嶅姞鍚庣紑
+ */
+ static getSignName () {
+ let name = []
+ let _options = 'abcdefghigklmnopqrstuvwxyz'
+ for (let i = 0; i < 3; i++) {
+ name.push(_options.substr(Math.floor(Math.random() * 26), 1))
+ }
+ return (Math.floor(Math.random()*10) + name.join('')).toUpperCase()
+ }
+
+ /**
+ * @description 閲嶇疆缁勪欢閰嶇疆
+ * @return {String} item 缁勪欢淇℃伅
+ */
+ static resetComponentConfig = (item, copyBtns, uuids = {}) => {
+ if (item.type === 'navbar') {
+ return item
+ }
+
+ let _uuid = this.getuuid()
+
+ uuids[item.uuid] = _uuid
+
+ item.uuid = _uuid
+
+ // 閲嶇疆缁勪欢鍚嶇О
+ let sign = this.getSignName()
+ if (item.plot) { // 鍥捐〃
+ item.plot.name = item.plot.name + sign
+ item.name = item.plot.name
+ } else if (item.wrap) { // 閫氱敤
+ item.wrap.name = item.wrap.name + sign
+ item.name = item.wrap.name
+ } else if (item.setting) { // 鍒嗙粍銆佹爣绛鹃〉绛�
+ item.setting.name = item.setting.name + sign
+ item.name = item.setting.name
+ }
+
+ if (item.type === 'menubar') {
+ item.subMenus = item.subMenus.map(cell => {
+ cell.uuid = this.getuuid()
+ return cell
+ })
+ } else if (['card', 'carousel', 'timeline'].includes(item.type) || (item.type === 'table' && item.subtype === 'tablecard')) {
+ item.subcards.forEach(card => {
+ card.uuid = this.getuuid()
+ if (card.elements) {
+ if (sessionStorage.getItem('editMenuType') === 'popview') {
+ card.elements = card.elements.filter(b => b.OpenType !== 'popview' && b.OpenType !== 'funcbutton')
+ }
+ card.elements = card.elements.map(cell => {
+ let _uuid = this.getuuid()
+ if (cell.OpenType === 'popview' && copyBtns) {
+ let _cell = JSON.parse(JSON.stringify(cell))
+ _cell.$originUuid = _cell.uuid
+ _cell.uuid = _uuid
+ copyBtns.set(_uuid, _cell)
+ }
+ cell.uuid = _uuid
+ return cell
+ })
+ }
+ if (card.backElements) {
+ if (sessionStorage.getItem('editMenuType') === 'popview') {
+ card.elements = card.elements.filter(b => b.OpenType !== 'popview' && b.OpenType !== 'funcbutton')
+ }
+ card.backElements = card.backElements.map(cell => {
+ let _uuid = this.getuuid()
+ if (cell.OpenType === 'popview' && copyBtns) {
+ let _cell = JSON.parse(JSON.stringify(cell))
+ _cell.$originUuid = _cell.uuid
+ _cell.uuid = _uuid
+ copyBtns.set(_uuid, _cell)
+ }
+ cell.uuid = _uuid
+ return cell
+ })
+ }
+ })
+ } else if (item.type === 'balcony') {
+ if (item.elements) {
+ if (sessionStorage.getItem('editMenuType') === 'popview') {
+ item.elements = item.elements.filter(b => b.OpenType !== 'popview' && b.OpenType !== 'funcbutton')
+ }
+ item.elements = item.elements.map(cell => {
+ let _uuid = this.getuuid()
+ if (cell.OpenType === 'popview' && copyBtns) {
+ let _cell = JSON.parse(JSON.stringify(cell))
+ _cell.$originUuid = _cell.uuid
+ _cell.uuid = _uuid
+ copyBtns.set(_uuid, _cell)
+ }
+ cell.uuid = _uuid
+ return cell
+ })
+ }
+ } else if (item.type === 'table' && (item.subtype === 'normaltable' || item.subtype === 'editable') && item.cols) {
+ let loopCol = (col) => {
+ col.subcols = col.subcols.map(c => {
+ c.uuid = this.getuuid()
+
+ if (c.type === 'colspan' && c.subcols) {
+ c = loopCol(c)
+ } else if (c.type === 'custom' && c.elements) {
+ c.elements = c.elements.map(cell => {
+ cell.uuid = this.getuuid()
+ return cell
+ })
+ }
+ return c
+ })
+
+ return col
+ }
+
+ let _uuids = {}
+ item.cols = item.cols.map(col => {
+ let uuid = this.getuuid()
+
+ _uuids[col.uuid] = uuid
+ col.uuid = uuid
+
+ if (col.type === 'colspan' && col.subcols) {
+ col = loopCol(col)
+ } else if (col.type === 'custom' && col.elements) {
+ col.elements = col.elements.map(cell => {
+ cell.uuid = this.getuuid()
+ return cell
+ })
+ } else if (col.type === 'action' && col.elements) {
+ if (sessionStorage.getItem('editMenuType') === 'popview') {
+ col.elements = col.elements.filter(c => c.OpenType !== 'popview' && c.OpenType !== 'funcbutton')
+ }
+ col.elements = col.elements.map(cell => {
+ let _uuid = this.getuuid()
+ if (cell.OpenType === 'popview' && copyBtns) {
+ let _cell = JSON.parse(JSON.stringify(cell))
+ _cell.$originUuid = _cell.uuid
+ _cell.uuid = _uuid
+ copyBtns.set(_uuid, _cell)
+ }
+ cell.uuid = _uuid
+ return cell
+ })
+ }
+ return col
+ })
+
+ if (item.subtype === 'editable') {
+ item.cols = item.cols.map(col => {
+ if (col.editable === 'true' && col.enter && _uuids[col.enter]) {
+ col.enter = _uuids[col.enter]
+ }
+ return col
+ })
+ }
+ } else if (item.type === 'form') {
+ item.subcards = item.subcards.map(cell => {
+ cell.uuid = this.getuuid()
+
+ cell.fields = cell.fields.map(m => {
+ m.uuid = this.getuuid()
+
+ return m
+ })
+ return cell
+ })
+ }
+
+ if (item.btnlog) {
+ item.btnlog = null
+ }
+
+ let oriUids = {}
+ if (item.action) {
+ if (sessionStorage.getItem('editMenuType') === 'popview') {
+ item.action = item.action.filter(c => c.OpenType !== 'popview' && c.OpenType !== 'funcbutton')
+ }
+ item.action = item.action.map(cell => {
+ let _uuid = this.getuuid()
+
+ oriUids[cell.uuid] = _uuid
+
+ if (cell.OpenType === 'popview' && copyBtns) {
+ let _cell = JSON.parse(JSON.stringify(cell))
+ _cell.$originUuid = _cell.uuid
+ _cell.uuid = _uuid
+ copyBtns.set(_uuid, _cell)
+ }
+
+ cell.uuid = _uuid
+
+ return cell
+ })
+ }
+ if (item.type === 'topbar') {
+ item.wrap.name = ''
+ item.name = ''
+ if (item.search && item.search.fields) {
+ item.search.fields = item.search.fields.map(cell => {
+ cell.uuid = this.getuuid()
+ return cell
+ })
+ }
+ if (item.search && item.search.groups) {
+ item.search.groups = item.search.groups.map(cell => {
+ cell.uuid = this.getuuid()
+ cell.fields = cell.fields.map(m => {
+ m.uuid = this.getuuid()
+ return m
+ })
+ return cell
+ })
+ }
+ } else if (item.search) {
+ item.search = item.search.map(cell => {
+ cell.uuid = this.getuuid()
+ return cell
+ })
+ }
+ if (item.columns) {
+ item.columns = item.columns.map(cell => {
+ cell.uuid = this.getuuid()
+ return cell
+ })
+ }
+
+ if (item.setting && item.setting.supModule && item.setting.supModule[0] !== 'empty') {
+ let em = false
+ item.setting.supModule = item.setting.supModule.map(c => {
+ if (!uuids[c]) {
+ em = true
+ }
+ return uuids[c] || ''
+ })
+ if (em) {
+ item.setting.supModule = ''
+ }
+ }
+
+ if (item.wrap && item.wrap.doubleClick) {
+ item.wrap.doubleClick = oriUids[item.wrap.doubleClick] || ''
+ }
+
+ return item
}
}
@@ -450,9 +916,11 @@
*/
export function resetStyle (style) {
if (!style) return {}
- if (sessionStorage.getItem('appType') === 'mob') {
- let _style = JSON.stringify(style)
+ let _style = JSON.stringify(style)
+ _style = _style.replace(/@mywebsite@\//ig, window.GLOB.baseurl)
+
+ if (sessionStorage.getItem('appType') === 'mob') {
// scaleview
_style = _style.replace(/\d+vw/ig, (word) => {
return parseFloat(word) * (window.GLOB.winWidth || 420) / 100 + 'px'
@@ -461,8 +929,170 @@
return parseFloat(word) * (window.GLOB.winHeight || 738) / 100 + 'px'
// return parseFloat(word) * 615 / 100 + 'px'
})
-
- return JSON.parse(_style)
}
- return JSON.parse(JSON.stringify(style))
+
+ return JSON.parse(_style)
+}
+
+/**
+ * @description 鑾峰彇琛ㄥ悕
+ */
+export function getTables (config) {
+ let tables = []
+ let cuts = []
+ let cutreg = /(from|update|insert\s+into)\s+(@db@)?[a-z_]+/ig
+ let trimreg = /(from|update|insert\s+into)\s+(@db@)?/ig
+
+ if (!config.wrap || !config.wrap.datatype || config.wrap.datatype === 'dynamic') {
+ if (config.setting.interType === 'system') {
+ if (config.setting.execute !== 'false') {
+ let tbs = config.setting.dataresource.match(cutreg)
+ tbs && cuts.push(...tbs)
+ }
+ config.scripts && config.scripts.forEach(script => {
+ if (script.status === 'false') return
+ let tbs = script.sql.match(cutreg)
+ tbs && cuts.push(...tbs)
+ })
+ } else {
+ let tb = config.setting.tableName.replace(/@db@|\s+/ig, '')
+ if (/[a-z_]+/ig.test(tb)) {
+ tables.push(tb)
+ }
+ }
+ }
+
+ let action = []
+
+ if (config.type === 'form') {
+ config.subcards.forEach(item => {
+ action.push(item.subButton)
+ })
+ } else if (config.subcards) {
+ config.subcards.forEach(item => {
+ item.elements.forEach(cell => {
+ if (cell.eleType === 'button' && ['form', 'pop', 'prompt', 'exec', 'excelIn', 'excelOut'].includes(cell.OpenType)) {
+ action.push(cell)
+ }
+ })
+
+ if (item.backElements && item.setting.type === 'multi') {
+ item.backElements.forEach(cell => {
+ if (cell.eleType === 'button' && ['form', 'pop', 'prompt', 'exec', 'excelIn', 'excelOut'].includes(cell.OpenType)) {
+ action.push(cell)
+ }
+ })
+ }
+ })
+ }
+ config.cols && config.cols.forEach(col => {
+ if (col.type === 'action') {
+ col.elements.forEach(cell => {
+ if (['form', 'pop', 'prompt', 'exec', 'excelIn', 'excelOut'].includes(cell.OpenType)) {
+ action.push(cell)
+ }
+ })
+ }
+ })
+
+ config.elements && config.elements.forEach(cell => {
+ if (cell.eleType === 'button' && ['form', 'pop', 'prompt', 'exec', 'excelIn', 'excelOut'].includes(cell.OpenType)) {
+ action.push(cell)
+ }
+ })
+
+ config.action && config.action.forEach(cell => {
+ if (['pop', 'prompt', 'exec', 'excelIn', 'excelOut'].includes(cell.OpenType)) {
+ action.push(cell)
+ }
+ })
+
+ action.forEach(btn => {
+ if (btn.OpenType === 'excelIn') {
+ if (!btn.verify) return
+ if (btn.intertype !== 'system' || btn.verify.default !== 'false') {
+ let tb = btn.sheet.replace(/@db@|\s+/ig, '')
+ if (/[a-z_]+/ig.test(tb)) {
+ tables.push(tb)
+ }
+ }
+ if (btn.intertype === 'system' && btn.verify.scripts) {
+ btn.verify.scripts.forEach(script => {
+ if (script.status === 'false') return
+ let tbs = script.sql.match(cutreg)
+ tbs && cuts.push(...tbs)
+ })
+ }
+ } else if (btn.OpenType === 'excelOut') {
+ if (btn.intertype !== 'system' || !btn.verify) return
+ if (btn.verify.dataType === 'custom') {
+ if (btn.verify.defaultSql !== 'false') {
+ let tbs = btn.verify.dataresource.match(cutreg)
+ tbs && cuts.push(...tbs)
+ }
+ btn.verify.scripts && btn.verify.scripts.forEach(script => {
+ if (script.status === 'false') return
+ let tbs = script.sql.match(cutreg)
+ tbs && cuts.push(...tbs)
+ })
+ }
+ if (btn.verify.enable === 'true' && btn.verify.script) {
+ let tbs = btn.verify.script.match(cutreg)
+ tbs && cuts.push(...tbs)
+ }
+ } else {
+ if (btn.intertype === 'inner') return
+ if (btn.intertype === 'outer' || btn.intertype === 'custom') {
+ if (btn.procMode === 'system' && btn.verify) {
+ if (btn.verify.default !== 'false' && btn.sql) {
+ let tb = btn.sql.replace(/@db@|\s+/ig, '')
+ if (/[a-z_]+/ig.test(tb)) {
+ tables.push(tb)
+ }
+ }
+ btn.verify.customverifys && btn.verify.customverifys.forEach(script => {
+ if (script.status === 'false') return
+ let tbs = script.sql.match(cutreg)
+ tbs && cuts.push(...tbs)
+ })
+ btn.verify.scripts && btn.verify.scripts.forEach(script => {
+ if (script.status === 'false') return
+ let tbs = script.sql.match(cutreg)
+ tbs && cuts.push(...tbs)
+ })
+ }
+ if (btn.callbackType === 'script' && btn.verify) {
+ btn.verify.cbScripts && btn.verify.cbScripts.forEach(script => {
+ if (script.status === 'false') return
+ let tbs = script.sql.match(cutreg)
+ tbs && cuts.push(...tbs)
+ })
+ }
+ } else if (btn.verify) {
+ if (btn.verify.default !== 'false' && btn.sql) {
+ let tb = btn.sql.replace(/@db@|\s+/ig, '')
+ if (/[a-z_]+/ig.test(tb)) {
+ tables.push(tb)
+ }
+ }
+ btn.verify.customverifys && btn.verify.customverifys.forEach(script => {
+ if (script.status === 'false') return
+ let tbs = script.sql.match(cutreg)
+ tbs && cuts.push(...tbs)
+ })
+ btn.verify.scripts && btn.verify.scripts.forEach(script => {
+ if (script.status === 'false') return
+ let tbs = script.sql.match(cutreg)
+ tbs && cuts.push(...tbs)
+ })
+ }
+ }
+ })
+
+ cuts = cuts.map(item => item.replace(trimreg, ''))
+ tables.push(...cuts)
+ tables = tables.filter(Boolean)
+ tables = Array.from(new Set(tables))
+
+ return tables
}
\ No newline at end of file
--
Gitblit v1.8.0