From 49f09cc6f8ff8c30a75ed1a9d6f510b69b73962a Mon Sep 17 00:00:00 2001
From: king <18310653075@163.com>
Date: 星期二, 12 十二月 2023 21:05:37 +0800
Subject: [PATCH] 2023-12-12

---
 src/templates/sharecomponent/actioncomponent/verifyexcelout/utils.jsx |   16 ++++------------
 1 files changed, 4 insertions(+), 12 deletions(-)

diff --git a/src/templates/sharecomponent/actioncomponent/verifyexcelout/utils.jsx b/src/templates/sharecomponent/actioncomponent/verifyexcelout/utils.jsx
index e3b1342..710956c 100644
--- a/src/templates/sharecomponent/actioncomponent/verifyexcelout/utils.jsx
+++ b/src/templates/sharecomponent/actioncomponent/verifyexcelout/utils.jsx
@@ -12,7 +12,6 @@
     let regoptions = getSearchRegs(_search)
 
     _search = joinMainSearchkey(_search)
-    _search = _search ? 'where ' + _search : ''
 
     let arr_field = []
     verify.columns.forEach(item => {
@@ -68,14 +67,7 @@
     let custompage = /@pageSize@|@orderBy@/i.test(_dataresource + _customScript)
     
     // 姝e垯鏇挎崲
-    let _regoptions = regoptions.map(item => {
-      return {
-        reg: new RegExp('@' + item.key + '@', 'ig'),
-        value: `'0'`
-      }
-    })
-
-    _regoptions.push({
+    regoptions.push({
       reg: new RegExp('@orderBy@', 'ig'),
       value: verify.order
     }, {
@@ -86,7 +78,7 @@
       value: 1
     })
 
-    _regoptions.forEach(item => {
+    regoptions.forEach(item => {
       _dataresource = _dataresource.replace(item.reg, item.value)
       _customScript = _customScript.replace(item.reg, item.value)
       _tailScript = _tailScript.replace(item.reg, item.value)
@@ -112,7 +104,7 @@
         ${_tailScript}
         aaa:
         if @ErrorCode!=''
-          insert into tmp_err_retmsg (ID, ErrorCode, retmsg, CreateUserID) select '1949-10-01 15:00:00',@ErrorCode, @retmsg,'1949-10-01 15:00:00'
+          insert into tmp_err_retmsg (ID, ErrorCode, retmsg, CreateUserID) select @time_id@,@ErrorCode, @retmsg,'1949-10-01 15:00:00'
       `
     } else if (_tailScript) {
       sql = `${declare}
@@ -120,7 +112,7 @@
         ${_tailScript}
         aaa:
         if @ErrorCode!=''
-          insert into tmp_err_retmsg (ID, ErrorCode, retmsg, CreateUserID) select '1949-10-01 15:00:00',@ErrorCode, @retmsg,'1949-10-01 15:00:00' 
+          insert into tmp_err_retmsg (ID, ErrorCode, retmsg, CreateUserID) select @time_id@,@ErrorCode, @retmsg,'1949-10-01 15:00:00' 
       `
     } else {
       sql = `${declare}

--
Gitblit v1.8.0