From cb9ade2afd2a367ad767bc605ab7086c695dd010 Mon Sep 17 00:00:00 2001
From: king <18310653075@163.com>
Date: 星期五, 09 十二月 2022 15:53:32 +0800
Subject: [PATCH] 2022-12-09

---
 src/utils/utils-custom.js |  694 ++++++++++++++++++++++++++++++++++++++-------------------
 1 files changed, 464 insertions(+), 230 deletions(-)

diff --git a/src/utils/utils-custom.js b/src/utils/utils-custom.js
index 0d109b5..a7a4398 100644
--- a/src/utils/utils-custom.js
+++ b/src/utils/utils-custom.js
@@ -3,16 +3,94 @@
    * @description 鑾峰彇涓嬬骇妯″潡
    * @return {String}  selfId  褰撳墠缁勪欢id
    */
-  static getSubModules (components, selfId) {
+  static getSubModules (components, selfId, supId) {
+    let modules = []
+    components.forEach(item => {
+      if (item.uuid === selfId || item.type === 'navbar') {
+        return
+      } else if (item.format) { // 鏁版嵁鏍煎紡锛屽瓨鍦ㄦ暟鎹簮
+        modules.push({
+          value: item.uuid,
+          label: item.name,
+          disabled: supId === item.uuid
+        })
+      } else if (item.type === 'tabs') {
+        if (item.subtype === 'tabletabs') {
+          item.subtabs.forEach(tab => {
+            modules.push({
+              value: tab.components[0].uuid,
+              label: tab.label,
+              disabled: supId === tab.components[0].uuid
+            })
+          })
+        } else {
+          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, supId)
+              }
+  
+              if (subItem.children.length === 0) {
+                return {children: null}
+              }
+              return subItem
+            })
+          }
+  
+          _item.children = _item.children.filter(t => t.children !== null)
+  
+          if (_item.children.length > 0) {
+            modules.push(_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,
+                disabled: supId === f_tab.uuid
+              }
+            }
+            return {
+              children: null
+            }
+          })
+        }
+
+        _item.children = _item.children.filter(t => t.children !== null)
+
+        if (_item.children.length > 0) {
+          modules.push(_item)
+        }
+      }
+    })
+
+    return modules
+  }
+
+  /**
+   * @description 鑾峰彇涓嬬骇妯″潡
+   * @return {String}  selfId  褰撳墠缁勪欢id
+   */
+  static getAnchors (components, selfId) {
     let modules = components.map(item => {
       if (item.uuid === selfId) {
         return {
           children: null
-        }
-      } else if (item.format) { // 鏁版嵁鏍煎紡锛屽瓨鍦ㄦ暟鎹簮
-        return {
-          value: item.uuid,
-          label: item.name
         }
       } else if (item.type === 'tabs') {
         let _item = {
@@ -69,6 +147,11 @@
         }
 
         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
@@ -88,12 +171,11 @@
    * @description 鑾峰彇涓婄骇妯″潡
    * @return {String}  selfId  褰撳墠缁勪欢id
    */
-  static getSupModules (components, selfId) {
-    let modules = components.map(item => {
+  static getSupModules (components, selfId, interfaces) {
+    let modules = []
+    components.forEach(item => {
       if (item.uuid === selfId) {
-        return {
-          children: null
-        }
+
       } else if (item.switchable) { // 鏁版嵁鍙垏鎹�
         let disabled = false
         if (item.type === 'card') {
@@ -101,41 +183,51 @@
         } else if (item.type === 'table') {
           disabled = item.wrap.tableType === ''
         }
-        return {
+        modules.push({
           value: item.uuid,
           label: item.name,
           disabled: disabled
-        }
+        })
       } else if (item.type === 'form') { // 鏁版嵁鏍煎紡锛屽瓨鍦ㄦ暟鎹簮
-        return {
+        modules.push({
           value: item.uuid,
           label: item.name
-        }
+        })
       } else if (item.type === 'tabs') {
-        let _item = {
-          value: item.uuid,
-          label: item.name,
-          children: item.subtabs.map(f_tab => {
-            let subItem = {
-              value: f_tab.uuid,
-              label: f_tab.label,
-              children: this.getSupModules(f_tab.components, selfId)
-            }
+        if (item.subtype === 'tabletabs') {
+          item.subtabs.forEach(tab => {
+            if (tab.components[0].uuid === selfId) return
 
-            if (!subItem.children || subItem.children.length === 0) {
-              return {children: null}
-            }
-            return subItem
+            modules.push({
+              value: tab.components[0].uuid,
+              label: tab.label,
+              disabled: tab.components[0].wrap.tableType === ''
+            })
           })
+        } else {
+          let _item = {
+            value: item.uuid,
+            label: item.name,
+            children: item.subtabs.map(f_tab => {
+              let subItem = {
+                value: f_tab.uuid,
+                label: f_tab.label,
+                children: this.getSupModules(f_tab.components, selfId)
+              }
+  
+              if (subItem.children.length === 0) {
+                return {children: null}
+              }
+              return subItem
+            })
+          }
+  
+          _item.children = _item.children.filter(t => t.children !== null)
+  
+          if (_item.children.length > 0) {
+            modules.push(_item)
+          }
         }
-
-        _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,
@@ -146,9 +238,16 @@
                 children: null
               }
             } else if (f_tab.switchable) {
+              let disabled = false
+              if (f_tab.type === 'card') {
+                disabled = f_tab.wrap.cardType === ''
+              } else if (f_tab.type === 'table') {
+                disabled = f_tab.wrap.tableType === ''
+              }
               return {
                 value: f_tab.uuid,
-                label: f_tab.name
+                label: f_tab.name,
+                disabled: disabled
               }
             }
             return {
@@ -159,24 +258,47 @@
 
         _item.children = _item.children.filter(t => t.children !== null)
 
-        if (_item.children.length === 0) {
-          return {children: null}
-        }
-
-        return _item
-      } else {
-        return {
-          children: null
+        if (_item.children.length > 0) {
+          modules.push(_item)
         }
       }
     })
 
-    modules = modules.filter(mod => mod.children !== null)
-
-    if (modules.length === 0) {
-      return null
+    if (interfaces && interfaces.length > 0) {
+      interfaces.forEach(item => {
+        modules.push({
+          value: item.uuid,
+          label: item.name
+        })
+      })
     }
+
     return modules
+  }
+
+  /**
+   * @description 鑾峰彇涓婄骇妯″潡
+   * @return {String}  selfId  褰撳墠缁勪欢id
+   */
+  static checkSupModules (modules, supId) {
+    let has = false
+
+    let check = (list) => {
+      list.forEach(m => {
+        if (has) return
+        if (supId === m.value) {
+          has = true
+          return
+        }
+        if (m.children) {
+          check(m.children)
+        }
+      })
+    }
+
+    check(modules)
+   
+    return has
   }
 
   /**
@@ -254,73 +376,6 @@
   }
 
   /**
-   * @description 鑾峰彇鍒犻櫎鎸夐挳Id
-   * @return {String}  name
-   */
-  static getDelButtonIds (card) {
-    let appType = sessionStorage.getItem('appType')
-    let uuids = []
-
-    if (appType === 'mob') return uuids
-
-    const getUuids = (item) => {
-      if (item.type === 'tabs') {
-        item.subtabs.forEach(tab => {
-          tab.components.forEach(c => {
-            getUuids(c)
-          })
-        })
-      } else if (item.type === 'group') {
-        item.components.forEach(c => {
-          getUuids(c)
-        })
-      } else {
-        item.action && item.action.forEach(act => {
-          if (act.origin || (appType === 'pc' && act.OpenType !== 'popview')) return
-
-          uuids.push(act.uuid)
-        })
-
-        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
-  
-              uuids.push(cell.uuid)
-            })
-            _card.backElements && _card.backElements.forEach(cell => {
-              if (cell.eleType !== 'button') return
-              if (appType === 'pc' && cell.OpenType !== 'popview') return
-  
-              uuids.push(cell.uuid)
-            })
-          })
-        } 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
-  
-              uuids.push(cell.uuid)
-            })
-          })
-        } else if (item.type === 'balcony') {
-          item.elements && item.elements.forEach(cell => {
-            if (appType === 'pc' && cell.OpenType !== 'popview') return
-
-            uuids.push(cell.uuid)
-          })
-        }
-      }
-    }
-
-    getUuids(card)
-
-    return uuids
-  }
-
-  /**
    * @description 鐢熸垚32浣島uid string + 鏃堕棿
    * @return {String}  uuid
    */
@@ -345,6 +400,10 @@
         return item
       }
 
+      if (item.subtype === 'tablecard') { // 鍏煎
+        item.type = 'card'
+      }
+
       uuids[item.uuid] = this.getuuid()
       item.uuid = uuids[item.uuid]
 
@@ -352,20 +411,10 @@
         item.subtabs.forEach(tab => {
           uuids[tab.uuid] = this.getuuid()
           tab.uuid = uuids[tab.uuid]
-          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, clear)
         })
       } else if (item.type === 'group') {
-        item.components = item.components.map(cell => {
-          cell.parentId = item.uuid
-          return cell
-        })
         item.components = this.resetConfig(item.components, uuids, clear)
       } else if (item.type === 'menubar') {
         item.subMenus = item.subMenus.map(cell => {
@@ -376,7 +425,11 @@
           }
           return cell
         })
-      } else if (['card', 'carousel', 'timeline'].includes(item.type) || (item.type === 'table' && item.subtype === 'tablecard')) {
+      } else if (['card', 'carousel', 'timeline'].includes(item.type)) {
+        if (item.wrap.datatype === 'public' && uuids[item.wrap.publicId]) {
+          item.wrap.publicId = uuids[item.wrap.publicId]
+        }
+        
         item.subcards.forEach(card => {
           card.uuid = this.getuuid()
 
@@ -417,6 +470,9 @@
           }
         })
       } 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()
@@ -429,7 +485,7 @@
             return cell
           })
         }
-      } else if (item.type === 'table' && (item.subtype === 'normaltable' || item.subtype === 'editable') && item.cols) {
+      } else if (item.type === 'table' && item.cols) {
         let loopCol = (col) => {
           col.subcols = col.subcols.map(c => {
             c.uuid = this.getuuid()
@@ -490,10 +546,21 @@
             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 = []
+        item.btnlog = null
       }
   
       let oriUids = {}
@@ -556,6 +623,9 @@
         if (em) {
           item.setting.supModule = ''
         }
+        if (item.wrap && item.wrap.supModule) {
+          item.wrap.supModule = item.setting.supModule
+        }
       }
 
       if (item.wrap && item.wrap.doubleClick) {
@@ -567,55 +637,28 @@
   }
 
   /**
-   * @description 閲嶇疆鑿滃崟閰嶇疆锛岄〉闈㈡暣浣撳鍒�
-   * @return {String}  components 閰嶇疆淇℃伅
+   * @description 缁勪欢鍚嶅姞鍚庣紑
    */
-  static getFloor = (id) => {
-    let floor = 1
-    let finish = false
-
-    let reCheck = (components, f) => {
-      components.forEach(item => {
-        if (finish) return
-        if (item.type === 'tabs') {
-          if (item.uuid === id) {
-            floor = f
-            finish = true
-          } else {
-            item.subtabs.forEach(tab => {
-              reCheck(tab.components, f + 1)
-            })
-          }
-        }
-      })
-    }
-
-    reCheck(window.GLOB.customMenu.components, 1)
-
-    return floor
-  }
-
-  /**
-   * @description 鏁版嵁婧愬悕绉帮紝鐢ㄤ簬缁熶竴鏌ヨ
-   * @return {String}  name
-   */
-  static getdataName () {
+  static getSignName () {
     let name = []
     let _options = 'abcdefghigklmnopqrstuvwxyz'
-    for (let i = 0; i < 6; i++) {
+    for (let i = 0; i < 3; i++) {
       name.push(_options.substr(Math.floor(Math.random() * 26), 1))
     }
-    name.splice(3, 0, new Date().getTime())
-    return name.join('')
+    return (Math.floor(Math.random()*10) + name.join('')).toUpperCase()
   }
 
   /**
   * @description 閲嶇疆缁勪欢閰嶇疆
   * @return {String}  item 缁勪欢淇℃伅
   */
-  static resetComponentConfig = (item, copyBtns, uuids = {}) => {
+  static resetComponentConfig = (item, uuids = {}) => {
     if (item.type === 'navbar') {
       return item
+    }
+
+    if (item.subtype === 'tablecard') { // 鍏煎
+      item.type = 'card'
     }
 
     let _uuid = this.getuuid()
@@ -624,12 +667,8 @@
 
     item.uuid = _uuid
 
-    if (item.dataName) {
-      item.dataName = this.getdataName()
-    }
-
     // 閲嶇疆缁勪欢鍚嶇О
-    let sign = this.getdataName().toUpperCase().substr(-4)
+    let sign = this.getSignName()
     if (item.plot) { // 鍥捐〃
       item.plot.name = item.plot.name + sign
       item.name = item.plot.name
@@ -646,7 +685,7 @@
         cell.uuid = this.getuuid()
         return cell
       })
-    } else if (['card', 'carousel', 'timeline'].includes(item.type) || (item.type === 'table' && item.subtype === 'tablecard')) {
+    } else if (['card', 'carousel', 'timeline'].includes(item.type)) {
       item.subcards.forEach(card => {
         card.uuid = this.getuuid()
         if (card.elements) {
@@ -654,14 +693,7 @@
             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
+            cell.uuid = this.getuuid()
             return cell
           })
         }
@@ -670,14 +702,7 @@
             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
+            cell.uuid = this.getuuid()
             return cell
           })
         }
@@ -688,18 +713,11 @@
           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
+          cell.uuid = this.getuuid()
           return cell
         })
       }
-    } else if (item.type === 'table' && (item.subtype === 'normaltable' || item.subtype === 'editable') && item.cols) {
+    } else if (item.type === 'table' && item.cols) {
       let loopCol = (col) => {
         col.subcols = col.subcols.map(c => {
           c.uuid = this.getuuid()
@@ -737,14 +755,7 @@
             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
+            cell.uuid = this.getuuid()
             return cell
           })
         }
@@ -772,9 +783,7 @@
       })
     }
 
-    if (item.btnlog) {
-      item.btnlog = []
-    }
+    delete item.btnlog
 
     let oriUids = {}
     if (item.action) {
@@ -785,13 +794,6 @@
         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
 
@@ -831,16 +833,10 @@
     }
 
     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 = ''
-      }
+      item.setting.supModule = ''
+    }
+    if (item.wrap && item.wrap.supModule) {
+      item.wrap.supModule = ''
     }
 
     if (item.wrap && item.wrap.doubleClick) {
@@ -857,9 +853,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'
@@ -868,8 +866,244 @@
       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 getHeight (val) {
+  if (typeof(val) === 'string') {
+    if (val.indexOf('px') > -1) {
+      val = parseFloat(val)
+    } else if (val.indexOf('vw') > -1) {
+      val = parseFloat(val)
+      val = document.body.clientWidth * val / 100
+    } else if (val.indexOf('vh') > -1) {
+      val = parseFloat(val)
+      val = document.body.clientHeight * val / 100
+    }
+  }
+
+  return parseInt(val || 400) - 30
+}
+
+/**
+ * @description 鑾峰彇琛ㄥ悕
+ */
+export function getTables (config, pops) {
+  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.setting && (!config.wrap || !config.wrap.datatype || config.wrap.datatype === 'dynamic')) {
+    if (config.setting.interType === 'system') {
+      if (config.setting.execute !== 'false' && config.setting.dataresource) {
+        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 if (config.setting.tableName) {
+      let tb = config.setting.tableName.replace(/@db@|\s+/ig, '')
+      if (/[a-z_]+/ig.test(tb)) {
+        tables.push(tb)
+      }
+    }
+  }
+
+  config.search && config.search.forEach(cell => {
+    if (cell.resourceType === '1' && cell.dataSource) {
+      let tbs = cell.dataSource.match(cutreg)
+      tbs && cuts.push(...tbs)
+    }
+  })
+
+  let action = []
+
+  if (config.type === 'form') {
+    config.subcards.forEach(item => {
+      action.push(item.subButton)
+      item.fields && item.fields.forEach(cell => {
+        if (cell.resourceType === '1' && cell.dataSource) {
+          let tbs = cell.dataSource.match(cutreg)
+          tbs && cuts.push(...tbs)
+        }
+      })
+    })
+  } else if (config.subcards) {
+    config.subcards.forEach(item => {
+      item.elements.forEach(cell => {
+        if (cell.eleType !== 'button') return
+        if (['form', 'pop', 'prompt', 'exec', 'excelIn', 'excelOut'].includes(cell.OpenType)) {
+          action.push(cell)
+        } else if (cell.OpenType === 'popview') {
+          if (pops) {
+            pops.push({...cell, parentId: config.uuid})
+          } else if (cell.config && cell.config.$tables) {
+            tables.push(...cell.config.$tables)
+          }
+        }
+      })
+  
+      if (item.backElements && item.setting.type === 'multi') {
+        item.backElements.forEach(cell => {
+          if (cell.eleType !== 'button') return
+          if (['form', 'pop', 'prompt', 'exec', 'excelIn', 'excelOut'].includes(cell.OpenType)) {
+            action.push(cell)
+          } else if (cell.OpenType === 'popview') {
+            if (pops) {
+              pops.push({...cell, parentId: config.uuid})
+            } else if (cell.config && cell.config.$tables) {
+              tables.push(...cell.config.$tables)
+            }
+          }
+        })
+      }
+    })
+  }
+
+  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)
+        } else if (cell.OpenType === 'popview') {
+          if (pops) {
+            pops.push({...cell, parentId: config.uuid})
+          } else if (cell.config && cell.config.$tables) {
+            tables.push(...cell.config.$tables)
+          }
+        }
+      })
+    }
+  })
+
+  config.elements && config.elements.forEach(cell => {
+    if (cell.eleType !== 'button') return
+    if (['form', 'pop', 'prompt', 'exec', 'excelIn', 'excelOut'].includes(cell.OpenType)) {
+      action.push(cell)
+    } else if (cell.OpenType === 'popview') {
+      if (pops) {
+        pops.push({...cell, parentId: config.uuid})
+      } else if (cell.config && cell.config.$tables) {
+        tables.push(...cell.config.$tables)
+      }
+    }
+  })
+
+  config.action && config.action.forEach(cell => {
+    if (['pop', 'prompt', 'exec', 'excelIn', 'excelOut'].includes(cell.OpenType)) {
+      action.push(cell)
+    } else if (cell.OpenType === 'popview') {
+      if (pops) {
+        pops.push({...cell, parentId: config.uuid})
+      } else if (cell.config && cell.config.$tables) {
+        tables.push(...cell.config.$tables)
+      }
+    }
+  })
+
+  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.OpenType === 'pop' && btn.modal && btn.modal.fields) {
+        btn.modal.fields.forEach(cell => {
+          if (cell.resourceType === '1' && cell.dataSource) {
+            let tbs = cell.dataSource.match(cutreg)
+            tbs && cuts.push(...tbs)
+          }
+        })
+      }
+      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