From daf42d3c347be272b436f08ff25dfa37f0952852 Mon Sep 17 00:00:00 2001
From: king <18310653075@163.com>
Date: 星期日, 19 一月 2020 11:36:56 +0800
Subject: [PATCH] 2020-01-19

---
 src/tabviews/subtabtable/index.jsx |   16 +++++++++++++---
 1 files changed, 13 insertions(+), 3 deletions(-)

diff --git a/src/tabviews/subtabtable/index.jsx b/src/tabviews/subtabtable/index.jsx
index cb71290..20c3383 100644
--- a/src/tabviews/subtabtable/index.jsx
+++ b/src/tabviews/subtabtable/index.jsx
@@ -335,7 +335,7 @@
 
     if (setting.queryType === 'statistics') { // 缁熻鏁版嵁婧愶紝鍐呭鏇挎崲
       let fieldmap = new Map()
-      search.forEach(item => {
+      let options = search.map(item => {
         let _field = item.key
 
         if (fieldmap.has(_field)) {
@@ -344,9 +344,19 @@
 
         fieldmap.set(item.key, true)
 
-        let reg = new RegExp('@' + _field, 'ig')
-        _dataresource = _dataresource.replace(reg, `'${item.value}'`)
+        return {
+          reg: new RegExp('@' + _field, 'ig'),
+          value: item.value
+        }
       })
+
+      options.reverse()
+
+      options.forEach(item => {
+        _dataresource = _dataresource.replace(item.reg, `'${item.value}'`)
+      })
+
+      _search = ''
     }
 
     let LText = `select top ${pageSize} ${arr_field} from (select ${arr_field} ,ROW_NUMBER() over(order by ${orderBy}) as rows from ${_dataresource} ${_search}) tmptable where rows > ${pageSize * (pageIndex - 1)} order by tmptable.rows`

--
Gitblit v1.8.0