From f4b9504cad034ddcdef21c2081d14a4984fcd2d3 Mon Sep 17 00:00:00 2001
From: king <18310653075@163.com>
Date: 星期一, 15 七月 2024 17:14:48 +0800
Subject: [PATCH] 2024-07-15

---
 src/menu/datasource/verifycard/utils.jsx |   65 +++++++++++++++++++++-----------
 1 files changed, 43 insertions(+), 22 deletions(-)

diff --git a/src/menu/datasource/verifycard/utils.jsx b/src/menu/datasource/verifycard/utils.jsx
index b443500..da4c71d 100644
--- a/src/menu/datasource/verifycard/utils.jsx
+++ b/src/menu/datasource/verifycard/utils.jsx
@@ -1,4 +1,5 @@
 
+import md5 from 'md5'
 import { getSearchRegs, joinMainSearchkey } from '@/utils/utils-custom.js'
 
 export default class SettingUtils {
@@ -9,7 +10,7 @@
    * @return {Object}  setting       椤甸潰璁剧疆
    * @return {Array}   columns       鏄剧ず瀛楁
    */
-  static getDebugSql (setting, scripts, columns, searches = [], type) {
+  static getDebugSql (setting, scripts, columns, searches = [], type, hasExtend) {
     let sql = ''
     let error = ''
     let _dataresource = ''
@@ -49,38 +50,37 @@
       })
     }
 
-    let getuuid = () => {
-      let uuid = []
-      let timestamp = new Date().getTime()
-      let _options = '0123456789abcdefghigklmnopqrstuv'
-      for (let i = 0; i < 19; i++) {
-        uuid.push(_options.substr(Math.floor(Math.random() * 0x20), 1))
-      }
-      uuid = timestamp + uuid.join('')
-      return uuid
-    }
-
     let regs = [
-      {reg: /@time_id@/ig, value: `'${getuuid()}'`},
-      {reg: /@BID@/ig, value: `'${getuuid()}'`},
-      {reg: /@upid@/ig, value: `'${getuuid()}'`},
+      // {reg: /@time_id@/ig, value: `'${getuuid()}'`}, // 璁$畻md5鍚庢浛鎹�
+      // {reg: /@BID@/ig, value: `'${getuuid()}'`},
+      // {reg: /@upid@/ig, value: `'${getuuid()}'`},
       {reg: /@typename@/ig, value: `'debug'`},
       {reg: /@datam@/ig, value: `''`},
       {reg: /@LoginUID@/ig, value: `'${sessionStorage.getItem('LoginUID')}'`},
       {reg: /@SessionUid@/ig, value: `'${localStorage.getItem('SessionUid')}'`},
       {reg: /@UserID@/ig, value: `'${sessionStorage.getItem('UserID')}'`},
       {reg: /@Appkey@/ig, value: `'${window.GLOB.appkey}'`},
+      {reg: /@lang@/ig, value: `'${sessionStorage.getItem('lang')}'`},
       {reg: /@\$|\$@/ig, value: ''},
       {reg: /@select\$|\$select@/ig, value: ''},
       {reg: /@sum\$|\$sum@/ig, value: ''},
     ]
 
-    if (window.GLOB.process) {
-      regs.push({reg: /@works_flow_code@/ig, value: `'${getuuid()}'`})
+    if (window.GLOB.process && type !== 'invoice') {
+      regs.push({reg: /@works_flow_code@/ig, value: `'mk_flow_code'`})
     }
 
+    if (hasExtend) {
+      regs.push({reg: /@mk_time@/ig, value: '2024-04-29 17:20:00'})
+    }
     if (type === 'calendar') {
       regs.push({reg: /@mk_year@/ig, value: '2024'})
+    }
+    if (window.GLOB.getLocation) {
+      regs.push(
+        {reg: /@mk_longitude@/ig, value: 0},
+        {reg: /@mk_latitude@/ig, value: 0}
+      )
     }
 
     // 澶栬仈鏁版嵁搴撴浛鎹�
@@ -101,7 +101,7 @@
       `
     }
 
-    if (window.GLOB.urlFields) {
+    if (window.GLOB.urlFields && type !== 'invoice') {
       window.GLOB.urlFields.forEach(field => {
         let reg = new RegExp('@' + field + '@', 'ig')
         _dataresource = _dataresource.replace(reg, `'0'`)
@@ -111,7 +111,7 @@
     }
 
     // 姝e垯鏇挎崲
-    let custompage = /@pageSize@|@orderBy@/i.test(_dataresource + _customScript)
+    let custompage = /@pageSize@|@orderBy@|@mk_total/i.test(_dataresource + _customScript)
     let _regoptions = getSearchRegs(searches)
 
     let _search = joinMainSearchkey(searches)
@@ -179,6 +179,29 @@
         ${_dataresource}`
     }
 
+    let debugId = md5(sql + window.GLOB.appkey)
+
+    let getuuid = () => {
+      let uuid = []
+      let timestamp = new Date().getTime()
+      let _options = '0123456789abcdefghigklmnopqrstuv'
+      for (let i = 0; i < 19; i++) {
+        uuid.push(_options.substr(Math.floor(Math.random() * 0x20), 1))
+      }
+      uuid = timestamp + uuid.join('')
+      return uuid
+    }
+
+    let _regs = [
+      {reg: /@time_id@/ig, value: `'${getuuid()}'`},
+      {reg: /@BID@/ig, value: `'${getuuid()}'`},
+      {reg: /@upid@/ig, value: `'${getuuid()}'`},
+    ]
+
+    _regs.forEach(item => {
+      sql = sql.replace(item.reg, item.value)
+    })
+
     let errors = []
 
     if (/@[0-9a-zA-Z_]+@/ig.test(sql)) {
@@ -211,8 +234,6 @@
       })
 
       arr.forEach(item => {
-        if (/@time_id@/ig.test(item)) return
-
         let reg = new RegExp(item, 'i')
         if (reg.test(_dataresource)) {
           errors.push(`鏁版嵁婧愪腑瀛樺湪鏈浛鎹㈠��${item}`)
@@ -229,6 +250,6 @@
       })
     }
 
-    return { error, sql, errors: errors.join('锛�'), custompage }
+    return { error, sql, errors: errors.join('锛�'), custompage, debugId }
   }
 }
\ No newline at end of file

--
Gitblit v1.8.0