From a7c6bffc152da5eeb780cca98fe73b7d90becf04 Mon Sep 17 00:00:00 2001
From: king <18310653075@163.com>
Date: 星期三, 30 十月 2024 16:22:19 +0800
Subject: [PATCH] Merge branch 'master' into positec

---
 src/menu/datasource/index.jsx                              |   11 ++++-
 src/api/index.js                                           |    4 +
 src/menu/components/card/cardcellcomponent/index.jsx       |   10 +++++
 src/utils/utils-custom.js                                  |   22 +++++-----
 src/menu/components/search/main-search/dragsearch/card.jsx |    2 
 src/utils/utils.js                                         |    2 
 src/menu/components/share/actioncomponent/index.jsx        |   10 +++++
 7 files changed, 44 insertions(+), 17 deletions(-)

diff --git a/src/api/index.js b/src/api/index.js
index 7747b40..b18ae3e 100644
--- a/src/api/index.js
+++ b/src/api/index.js
@@ -469,7 +469,7 @@
             CacheUtils.delIndexDBConfig(list)
             this.delCacheConfig('all')
 
-            if (reHome) {
+            if (reHome && reload !== 'home_page_id') {
               MKEmitter.emit('reloadMenuView', 'home_page_id')
             }
           }
@@ -753,6 +753,7 @@
               window.mkInfo(n)
             })
           }
+          delete res.mksqls
           if (res.ErrCode === 'version_error') {
             res.ErrCode = '-2'
             MKEmitter.emit('reloadTabs')
@@ -1071,6 +1072,7 @@
               window.mkInfo(n)
             })
           }
+          delete res.mksqls
           if (!res.status) {
             if (res.ErrCode === 'version_error') {
               res.ErrCode = '-2'
diff --git a/src/menu/components/card/cardcellcomponent/index.jsx b/src/menu/components/card/cardcellcomponent/index.jsx
index d6fa1a5..89008dd 100644
--- a/src/menu/components/card/cardcellcomponent/index.jsx
+++ b/src/menu/components/card/cardcellcomponent/index.jsx
@@ -600,6 +600,16 @@
     const { elements, card } = this.state
 
     this.verifyRef.handleConfirm().then(res => {
+      res.customverifys && res.customverifys.forEach(item => {
+        item.sql = item.sql.replace(/\t+|\v+/g, ' ')
+      })
+      res.scripts && res.scripts.forEach(item => {
+        item.sql = item.sql.replace(/\t+|\v+/g, ' ')
+      })
+      res.cbScripts && res.cbScripts.forEach(item => {
+        item.sql = item.sql.replace(/\t+|\v+/g, ' ')
+      })
+      
       let _elements = elements.map(cell => {
         if (cell.uuid === card.uuid) {
           cell.verify = res
diff --git a/src/menu/components/search/main-search/dragsearch/card.jsx b/src/menu/components/search/main-search/dragsearch/card.jsx
index 72462e7..03f5b65 100644
--- a/src/menu/components/search/main-search/dragsearch/card.jsx
+++ b/src/menu/components/search/main-search/dragsearch/card.jsx
@@ -146,7 +146,7 @@
       </div>
     } trigger="hover">
       <div className={'page-card ' + (card.labelShow === 'false' ? 'label-hide ' : '') + card.type + (card.advanced === 'true' ? ' advanced' : '') + (card.query === 'false' ? ' no-query' : '')} style={{ opacity: opacity}}>
-        <div ref={node => drag(drop(node))}>
+        <div ref={node => drag(drop(node))} onDoubleClick={() => editCard(id)}>
           <Form.Item
             labelCol={{style: {width: labelwidth + '%'}}}
             wrapperCol={{style: {width: (100 - labelwidth) + '%'}}}
diff --git a/src/menu/components/share/actioncomponent/index.jsx b/src/menu/components/share/actioncomponent/index.jsx
index e565fa3..e71e10d 100644
--- a/src/menu/components/share/actioncomponent/index.jsx
+++ b/src/menu/components/share/actioncomponent/index.jsx
@@ -530,6 +530,16 @@
       let _actionlist = fromJS(this.state.actionlist).toJS()
       _actionlist = _actionlist.filter(item => !item.origin || item.uuid === card.uuid)
 
+      res.customverifys && res.customverifys.forEach(item => {
+        item.sql = item.sql.replace(/\t+|\v+/g, ' ')
+      })
+      res.scripts && res.scripts.forEach(item => {
+        item.sql = item.sql.replace(/\t+|\v+/g, ' ')
+      })
+      res.cbScripts && res.cbScripts.forEach(item => {
+        item.sql = item.sql.replace(/\t+|\v+/g, ' ')
+      })
+      
       _actionlist = _actionlist.map(item => {
         if (item.uuid === card.uuid) {
           item.verify = res
diff --git a/src/menu/datasource/index.jsx b/src/menu/datasource/index.jsx
index f264a81..dd54aa7 100644
--- a/src/menu/datasource/index.jsx
+++ b/src/menu/datasource/index.jsx
@@ -245,15 +245,20 @@
       //   })
       // }
 
-      if (res.setting.interType === 'system' && res.setting.dataresource && res.setting.execute !== 'false' && sFields) {
-        if (new RegExp(`@(${sFields})@`, 'ig').test(res.setting.dataresource)) {
-          maxScript = 1000
+      if (res.setting.interType === 'system' && res.setting.dataresource && res.setting.execute !== 'false') {
+        res.setting.dataresource = res.setting.dataresource.replace(/\t+|\v+/g, ' ')
+        if (sFields) {
+          if (new RegExp(`@(${sFields})@`, 'ig').test(res.setting.dataresource)) {
+            maxScript = 1000
+          }
         }
       }
 
       res.scripts.forEach(item => {
         if (item.status === 'false') return
 
+        item.sql = item.sql.replace(/\t+|\v+/g, ' ')
+
         if (/exec\s/ig.test(item.sql)) {
           useExec = true
           maxScript = 1000
diff --git a/src/utils/utils-custom.js b/src/utils/utils-custom.js
index 59a8add..e34c81f 100644
--- a/src/utils/utils-custom.js
+++ b/src/utils/utils-custom.js
@@ -4205,7 +4205,7 @@
 
               if @works_begin_branch@ = 'Y'
               begin
-                  update s_my_works_flow_role set deleted=0,modifydate=getdate(),upid=@time_id@,modifyuserid=@userid@,modifyuser=@username,modifystaff=@fullname
+                  update s_my_works_flow_role set deleted=0,modifydate=getdate(),upid=@time_id@,modifyuserid=@userid@,modifyuser=@username,modifystaff=@fullname,works_flow_detail_id=@works_flow_detail_id@
                   where works_flow_id=@ID@ and works_flow_code=@works_flow_code@ and typecharone='begin'
               end
               else
@@ -4414,7 +4414,7 @@
       reps.push('db')
     }
 
-    _sql = _sql.replace(/\n\x20{8,10}/g, '\n').replace(/\n{3,}/g, '\n\n').replace(/^\s+|\s+$/g, '').replace(/\t+|\v+/g, '')
+    _sql = _sql.replace(/\n\x20{8,10}/g, '\n').replace(/\n{3,}/g, '\n\n').replace(/^\s+|\s+$/g, '').replace(/\t+|\v+/g, ' ')
 
     reps = reps.filter(n => {
       if (sysVars.includes(n.toLowerCase())) {
@@ -4714,7 +4714,7 @@
       reps.push('db')
     }
 
-    _sql = _sql.replace(/\n\x20{8,10}/g, '\n').replace(/\n{3,}/g, '\n\n').replace(/^\s+|\s+$/g, '').replace(/\t+|\v+/g, '')
+    _sql = _sql.replace(/\n\x20{8,10}/g, '\n').replace(/\n{3,}/g, '\n\n').replace(/^\s+|\s+$/g, '').replace(/\t+|\v+/g, ' ')
 
     reps = reps.filter(n => {
       if (sysVars.includes(n.toLowerCase())) {
@@ -4991,7 +4991,7 @@
     }
     reps.push('mk_obj_name')
 
-    sql = sql.replace(/\n\x20{6,8}/g, '\n').replace(/\n{3,}/g, '\n\n').replace(/^\s+|\s+$/g, '').replace(/\t+|\v+/g, '')
+    sql = sql.replace(/\n\x20{6,8}/g, '\n').replace(/\n{3,}/g, '\n\n').replace(/^\s+|\s+$/g, '').replace(/\t+|\v+/g, ' ')
 
     reps = reps.filter(n => {
       if (sysVars.includes(n.toLowerCase())) {
@@ -5296,7 +5296,7 @@
       reps.push('db')
     }
 
-    sql = sql.replace(/\n\x20{6,10}/g, '\n').replace(/\n{3,}/g, '\n\n').replace(/^\s+|\s+$/g, '').replace(/\t+|\v+/g, '')
+    sql = sql.replace(/\n\x20{6,10}/g, '\n').replace(/\n{3,}/g, '\n\n').replace(/^\s+|\s+$/g, '').replace(/\t+|\v+/g, ' ')
 
     reps = reps.filter(n => {
       if (sysVars.includes(n.toLowerCase())) {
@@ -5568,7 +5568,7 @@
       reps.push('db')
     }
 
-    sql = sql.replace(/\n\x20{6,10}/g, '\n').replace(/\n{3,}/g, '\n\n').replace(/^\s+|\s+$/g, '').replace(/\t+|\v+/g, '')
+    sql = sql.replace(/\n\x20{6,10}/g, '\n').replace(/\n{3,}/g, '\n\n').replace(/^\s+|\s+$/g, '').replace(/\t+|\v+/g, ' ')
 
     reps = reps.filter(n => {
       if (sysVars.includes(n.toLowerCase())) {
@@ -5852,7 +5852,7 @@
       reps.push('db')
     }
 
-    _sql = _sql.replace(/\n\x20{6,8}/g, '\n').replace(/\n{3,}/g, '\n\n').replace(/^\s+|\s+$/g, '').replace(/\t+|\v+/g, '')
+    _sql = _sql.replace(/\n\x20{6,8}/g, '\n').replace(/\n{3,}/g, '\n\n').replace(/^\s+|\s+$/g, '').replace(/\t+|\v+/g, ' ')
 
     reps = reps.filter(n => {
       if (sysVars.includes(n.toLowerCase())) {
@@ -5967,7 +5967,7 @@
 
     // reps.push('mk_obj_name')
 
-    sql = sql.replace(/\n\x20{6,8}/g, '\n').replace(/\n{3,}/g, '\n\n').replace(/^\s+|\s+$/g, '').replace(/\t+|\v+/g, '')
+    sql = sql.replace(/\n\x20{6,8}/g, '\n').replace(/\n{3,}/g, '\n\n').replace(/^\s+|\s+$/g, '').replace(/\t+|\v+/g, ' ')
 
     reps = reps.filter(n => {
       if (sysVars.includes(n.toLowerCase())) {
@@ -6091,7 +6091,7 @@
       reps.push('db')
     }
 
-    sql = sql.replace(/\n\x20{6,8}/g, '\n').replace(/\n{3,}/g, '\n\n').replace(/^\s+|\s+$/g, '').replace(/\t+|\v+/g, '')
+    sql = sql.replace(/\n\x20{6,8}/g, '\n').replace(/\n{3,}/g, '\n\n').replace(/^\s+|\s+$/g, '').replace(/\t+|\v+/g, ' ')
 
     reps = reps.filter(n => {
       if (sysVars.includes(n.toLowerCase())) {
@@ -6198,7 +6198,7 @@
       return true
     })
 
-    sql = sql.replace(/\n\x20{6,8}/g, '\n').replace(/\n{3,}/g, '\n\n').replace(/^\s+|\s+$/g, '').replace(/\t+|\v+/g, '')
+    sql = sql.replace(/\n\x20{6,8}/g, '\n').replace(/\n{3,}/g, '\n\n').replace(/^\s+|\s+$/g, '').replace(/\t+|\v+/g, ' ')
 
     return {LText: sql, md5: md5(sql), reps}
   }
@@ -6294,7 +6294,7 @@
       ${callback}
       `
 
-    _sql = _sql.replace(/\n\x20{6,8}/g, '\n').replace(/\n{3,}/g, '\n\n').replace(/^\s+|\s+$/g, '').replace(/\t+|\v+/g, '')
+    _sql = _sql.replace(/\n\x20{6,8}/g, '\n').replace(/\n{3,}/g, '\n\n').replace(/^\s+|\s+$/g, '').replace(/\t+|\v+/g, ' ')
 
     reps = reps.filter(n => {
       if (sysVars.includes(n.toLowerCase())) {
diff --git a/src/utils/utils.js b/src/utils/utils.js
index 0699bca..a93c540 100644
--- a/src/utils/utils.js
+++ b/src/utils/utils.js
@@ -2811,7 +2811,7 @@
       update s_my_works_flow_role set deleted=10,modifydate=getdate(),upid=@time_id@,modifyuserid=@userid@,modifyuser=@username,modifystaff=@fullname 
       where works_flow_id=@ID@ and works_flow_code=@works_flow_code@ and deleted=0
 
-      ${line.mknode === 'startEdge' ? `update s_my_works_flow_role set deleted=0,modifydate=getdate(),upid=@time_id@,modifyuserid=@userid@,modifyuser=@username,modifystaff=@fullname 
+      ${line.mknode === 'startEdge' ? `update s_my_works_flow_role set deleted=0,modifydate=getdate(),upid=@time_id@,modifyuserid=@userid@,modifyuser=@username,modifystaff=@fullname,works_flow_detail_id=@works_flow_detail_id@ 
       where works_flow_id=@ID@ and works_flow_code=@works_flow_code@ and typecharone='begin'` : ''}
 
       if @check_userids@ != ''

--
Gitblit v1.8.0