From 6257816acce548a113081578140058cd99e83160 Mon Sep 17 00:00:00 2001
From: king <18310653075@163.com>
Date: 星期一, 05 十月 2020 10:01:16 +0800
Subject: [PATCH] 2020-10-05

---
 src/menu/actioncomponent/verifyexcelin/customscript/index.jsx |    5 ++++-
 1 files changed, 4 insertions(+), 1 deletions(-)

diff --git a/src/menu/actioncomponent/verifyexcelin/customscript/index.jsx b/src/menu/actioncomponent/verifyexcelin/customscript/index.jsx
index b35f4da..108bc1d 100644
--- a/src/menu/actioncomponent/verifyexcelin/customscript/index.jsx
+++ b/src/menu/actioncomponent/verifyexcelin/customscript/index.jsx
@@ -202,7 +202,10 @@
         fields = fields + ','
       }
 
-      _value = `Insert into ${btn.sheet} (${fields}createuserid,createuser,createstaff,bid)\nSelect ${fields}@userid@,@username,@fullname,@BID@ From @${btn.sheet}`
+      let database = btn.sheet.match(/(.*)\.(.*)\./ig) || ''
+      let sheet = btn.sheet.replace(/(.*)\.(.*)\./ig, '')
+
+      _value = `Insert into ${database}${sheet} (${fields}createuserid,createuser,createstaff,bid)\nSelect ${fields}@userid@,@username,@fullname,@BID@ From @${sheet}`
     } else {
       _value = value
     }

--
Gitblit v1.8.0