From d2392435048a5d75f2d10b4d88a2c8ac29a254f1 Mon Sep 17 00:00:00 2001
From: king <18310653075@163.com>
Date: 星期三, 18 六月 2025 22:34:05 +0800
Subject: [PATCH] 2025-06-18

---
 src/utils/utils.js |   26 ++++++++++++++++----------
 1 files changed, 16 insertions(+), 10 deletions(-)

diff --git a/src/utils/utils.js b/src/utils/utils.js
index cc06e69..1c6771e 100644
--- a/src/utils/utils.js
+++ b/src/utils/utils.js
@@ -569,8 +569,8 @@
       } else if (item.type === 'range') {
         let val = item.value.split(',')
 
-        newsearches[item.key] = val[0] || -999999999
-        newsearches[item.key + '1'] = val[1] || 999999999
+        newsearches[item.key] = val[0] || -99999999
+        newsearches[item.key + '1'] = val[1] || 99999999
       } else if (item.type === 'dateweek') {
         let _startval = ''
         let _endval = ''
@@ -718,7 +718,7 @@
       } else if (item.type === 'range') {
         let val = item.value.split(',')
 
-        searchText.push('(' + item.key + ' >= ' + (val[0] || -999999999) + ' AND ' + item.key + ' <= ' + (val[1] || 999999999) + ')')
+        searchText.push('(' + item.key + ' >= ' + (val[0] || -99999999) + ' AND ' + item.key + ' <= ' + (val[1] || 99999999) + ')')
       } else {
         searchText.push('(' + item.key + ' ' + item.match + ' \'' + item.value + '\')')
       }
@@ -859,12 +859,12 @@
           key: item.key,
           match: '>=',
           type: 'text',
-          value: val[0] || -999999999
+          value: val[0] || -99999999
         }, {
           key: item.key,
           match: '<=',
           type: 'text',
-          value: val[1] || 999999999
+          value: val[1] || 99999999
         })
       } else {
         searchText.push(cell)
@@ -945,9 +945,9 @@
 
         let copy = JSON.parse(JSON.stringify(item))
         copy.key = copy.key + '1'
-        copy.value = val[1] || 999999999
+        copy.value = val[1] || 99999999
         
-        item.value = val[0] || -999999999
+        item.value = val[0] || -99999999
 
         options.push(item)
         options.push(copy)
@@ -1187,6 +1187,10 @@
         }
 
         val = val.replace(/(^\s+$)|\t+|\v+/ig, '')
+
+        if (col.interception !== 'false') {
+          val = val.replace(/^\s+|\s+$/g, '')
+        }
 
         if (!val && col.required === 'true') {            // 蹇呭～鏍￠獙
           errors.push(_position + '鍐呭涓嶅彲涓虹┖')
@@ -1877,6 +1881,7 @@
   let _initColfields = []
   let _declarefields = []
   let verifyValSql = ''
+  let datavars = {}
 
   // 鑾峰彇瀛楁閿�煎
   formdata && formdata.forEach(form => {
@@ -1891,6 +1896,7 @@
     }
 
     let _key = form.key.toLowerCase()
+    datavars[_key] = form.value
 
     if (!_initvars.includes(_key)) {
       _initvars.push(_key)
@@ -1945,6 +1951,8 @@
 
   // 娣诲姞鏁版嵁涓瓧娈碉紝琛ㄥ崟鍊间紭鍏�(鎸夐挳涓嶉�夎鎴栧琛屾嫾鎺ユ椂璺宠繃)
   if (data && btn.Ot !== 'notRequired' && columns && columns.length > 0) {
+    datavars = {..._data, ...datavars}
+
     const setField = (col) => {
       if (!col.field) return
       let _key = col.field.toLowerCase()
@@ -2239,7 +2247,7 @@
       item.field.split(',').forEach((_field, index) => {
         let _key = _field.toLowerCase()
         let _val = ''
-        let _val2 = ''
+        let _val2 = datavars[_key] !== undefined ? datavars[_key] : ''
 
         arr.push(_key)
         if (_key === 'bid') {
@@ -2250,8 +2258,6 @@
         
         if (_key === 'bid') {
           _val2 = BID
-        } else {
-          _val2 = `' + @${_field} + '`
         }
         
         _fieldValue.push(`${_key}=${_val}`)

--
Gitblit v1.8.0