From 27eb6c35533be910488869c393e2c89e3c0a5b20 Mon Sep 17 00:00:00 2001
From: king <18310653075@163.com>
Date: 星期一, 07 九月 2020 23:33:23 +0800
Subject: [PATCH] 2020-09-07

---
 src/templates/zshare/createinterface/index.jsx |   17 ++++++++++++++++-
 1 files changed, 16 insertions(+), 1 deletions(-)

diff --git a/src/templates/zshare/createinterface/index.jsx b/src/templates/zshare/createinterface/index.jsx
index 222a936..fb2458b 100644
--- a/src/templates/zshare/createinterface/index.jsx
+++ b/src/templates/zshare/createinterface/index.jsx
@@ -110,6 +110,21 @@
       }
     })
 
+    let _customScript = ''
+    config.setting.scripts && config.setting.scripts.forEach(script => {
+      if (script.status !== 'false') {
+        _customScript += `
+        ${script.sql}
+        `
+      }
+    })
+
+    if (_customScript) {
+      _customScript = `declare @ErrorCode nvarchar(50),@retmsg nvarchar(4000) select @ErrorCode='',@retmsg =''
+        ${_customScript}
+      `
+    }
+
     let param = {
       func: 's_get_para_for_out',
       Menuid: menu.MenuID,
@@ -119,7 +134,7 @@
       Ltextsearchparam: _search.join(' union all '),
       AppendWhere: config.setting.queryType === 'query' ? searchText.join(' AND ') : '',
       WhereType: config.setting.queryType === 'statistics' ? 'Statistics' : 'query',
-      custom_script: config.setting.customScript || '',
+      custom_script: _customScript,
       default_sql: config.setting.default || 'true',
       OrderCol: config.setting.order
     }

--
Gitblit v1.8.0