From ca788834ea15d6dd43bf0923757ca1d46d00ebc4 Mon Sep 17 00:00:00 2001
From: king <18310653075@163.com>
Date: 星期一, 12 七月 2021 23:17:26 +0800
Subject: [PATCH] 2021-07-12

---
 src/utils/utils.js |   17 ++++++++++++++---
 1 files changed, 14 insertions(+), 3 deletions(-)

diff --git a/src/utils/utils.js b/src/utils/utils.js
index 8be2c14..09de0d1 100644
--- a/src/utils/utils.js
+++ b/src/utils/utils.js
@@ -500,6 +500,10 @@
         let _endval = moment(val[1], 'YYYY-MM-DD').add(1, 'days').format('YYYY-MM-DD') + ' 00:00:00.000'
 
         searchText += '(' + item.key + ' >= \'' + _startval + '\' AND ' + item.key + ' < \'' + _endval + '\')'
+      } else if (item.type === 'range') {
+        let val = item.value.split(',')
+
+        searchText += '(' + item.key + ' >= \'' + val[0] + '\' AND ' + item.key + ' < \'' + val[1] + '\')'
       } else {
         searchText += '(' + item.key + ' ' + item.match + ' \'' + item.value + '\')'
       }
@@ -762,14 +766,21 @@
   let userName = sessionStorage.getItem('User_Name') || ''
   let fullName = sessionStorage.getItem('Full_Name') || ''
   let city = sessionStorage.getItem('city') || ''
+  let _sheet = item.sheet
 
   if (sessionStorage.getItem('isEditState') === 'true') {
     userName = sessionStorage.getItem('CloudUserName') || ''
     fullName = sessionStorage.getItem('CloudFullName') || ''
   }
 
-  let database = item.sheet.match(/(.*)\.(.*)\./ig) || ''
-  let sheet = item.sheet.replace(/(.*)\.(.*)\./ig, '')
+  if (window.GLOB.externalDatabase !== null) {
+    _sheet = _sheet.replace(/@db@/ig, window.GLOB.externalDatabase)
+  }
+
+  let database = _sheet.match(/(.*)\.(.*)\./ig)
+  let sheet = _sheet.replace(/(.*)\.(.*)\./ig, '')
+  
+  database = database ? (database[0] || '') : ''
 
   let getuuid = () => {
     let uuid = []
@@ -829,7 +840,7 @@
           val = val.toString()
         }
 
-        val = val.replace(/(^\s*$)|\t*|\v*/ig, '')
+        val = val.replace(/(^\s*$)|\t*|\v*|'*/ig, '')
 
         if (!val && col.required === 'true') {            // 蹇呭~鏍¢獙
           errors.push(_position + dict['main.excel.content.emptyerror'])

--
Gitblit v1.8.0