From ca3737b6e1b379bd2a68c8b2d97996c5a03eb96a Mon Sep 17 00:00:00 2001
From: king <18310653075@163.com>
Date: 星期一, 31 三月 2025 16:45:47 +0800
Subject: [PATCH] 2025-03-31

---
 src/utils/utils-custom.js |   55 +++++++++++++++++++++++++++++++++++++++++++++----------
 1 files changed, 45 insertions(+), 10 deletions(-)

diff --git a/src/utils/utils-custom.js b/src/utils/utils-custom.js
index dc7f0de..93edd21 100644
--- a/src/utils/utils-custom.js
+++ b/src/utils/utils-custom.js
@@ -1983,15 +1983,20 @@
 
       if (cell.OpenType === 'form' && cell.formType === 'count_line') return
      
-      if (cell.intertype === 'system') {
-        // if (cell.Ot === 'notRequired' && cell.verify && cell.verify.voucher && cell.verify.voucher.enabled) {
-        //   errors.push({ level: 0, detail: `鎸夐挳鈥�${cell.label}鈥濅娇鐢ㄤ簡鍒涘缓鍑瘉鍑芥暟锛岄渶瑕侀�夋嫨琛岋紒`})
-        // }
-      } else if (cell.intertype === 'custom' || cell.intertype === 'outer') {
-        if (cell.callbackType === 'script' && (!cell.verify || !cell.verify.cbScripts || cell.verify.cbScripts.filter(item => item.status !== 'false').length === 0)) {
-          errors.push({ level: 0, detail: `鎸夐挳鈥�${cell.label}鈥濅娇鐢ㄤ簡鑷畾涔夎剼鏈洖璋冿紝鍥炶皟鑴氭湰涓嶅彲涓虹┖锛乣})
-        // } else if (cell.procMode === 'system' && cell.Ot === 'notRequired' && cell.verify && cell.verify.voucher && cell.verify.voucher.enabled) {
-        //   errors.push({ level: 0, detail: `鎸夐挳鈥�${cell.label}鈥濅娇鐢ㄤ簡鍒涘缓鍑瘉鍑芥暟锛岄渶瑕侀�夋嫨琛岋紒`})
+      // if (cell.intertype === 'system') {
+      //   // if (cell.Ot === 'notRequired' && cell.verify && cell.verify.voucher && cell.verify.voucher.enabled) {
+      //   //   errors.push({ level: 0, detail: `鎸夐挳鈥�${cell.label}鈥濅娇鐢ㄤ簡鍒涘缓鍑瘉鍑芥暟锛岄渶瑕侀�夋嫨琛岋紒`})
+      //   // }
+      // } else if (cell.intertype === 'custom' || cell.intertype === 'outer') {
+      //   if (cell.callbackType === 'script' && (!cell.verify || !cell.verify.cbScripts || cell.verify.cbScripts.filter(item => item.status !== 'false').length === 0)) {
+      //     errors.push({ level: 0, detail: `鎸夐挳鈥�${cell.label}鈥濅娇鐢ㄤ簡鑷畾涔夎剼鏈洖璋冿紝鍥炶皟鑴氭湰涓嶅彲涓虹┖锛乣})
+      //   // } else if (cell.procMode === 'system' && cell.Ot === 'notRequired' && cell.verify && cell.verify.voucher && cell.verify.voucher.enabled) {
+      //   //   errors.push({ level: 0, detail: `鎸夐挳鈥�${cell.label}鈥濅娇鐢ㄤ簡鍒涘缓鍑瘉鍑芥暟锛岄渶瑕侀�夋嫨琛岋紒`})
+      //   }
+      // }
+      if ((cell.intertype === 'custom' || cell.intertype === 'outer') && cell.callbackType === 'script') {
+        if (!cell.verify || !cell.verify.cbScripts) {
+          errors.push({ level: 0, detail: `鎸夐挳鈥�${cell.label}鈥濅娇鐢ㄤ簡鑷畾涔夎剼鏈洖璋冿紝璇疯缃獙璇佷俊鎭紒`})
         }
       }
     } else if (cell.OpenType === 'funcbutton') {
@@ -3928,6 +3933,30 @@
   
     // 鍞竴鎬ч獙璇侊紝蹇呴』瀛樺湪琛ㄥ崟锛堣〃鍗曞瓨鍦ㄦ椂锛屼富閿潎涓哄崟鍊硷級,蹇呴』濉啓鏁版嵁婧愶紝澶氳鎷兼帴鏃朵笉鍙敤
     if (formdata && verify.uniques && verify.uniques.length > 0 && btn.Ot !== 'requiredOnce') {
+      let nFields = []
+      let dataFields = []
+      formdata.forEach(form => {
+        let _key = form.key.toLowerCase()
+        if (form.type === 'number' || form.type === 'rate') {
+          nFields.push(_key)
+        } else if (form.type === 'date') {
+          dataFields.push(_key)
+        }
+      })
+      if (columns && columns.length > 0 && btn.Ot !== 'notRequired') {
+        columns.forEach(col => {
+          let _key = col.field.toLowerCase()
+          if (col.type === 'number') {
+            if (!nFields.includes(_key)) {
+              nFields.push(_key)
+            }
+          } else if (/^date/ig.test(col.datatype)) {
+            if (!dataFields.includes(_key)) {
+              dataFields.push(_key)
+            }
+          }
+        })
+      }
       verify.uniques.forEach(item => {
         let _fieldValue = []                     // 琛ㄥ崟閿�煎field=value
         let _value = []                          // 琛ㄥ崟鍊硷紝鐢ㄤ簬閿欒鎻愮ず
@@ -3953,7 +3982,13 @@
             _val2 = `' + ${BID} + '`
           } else {
             // _val2 = `@mk_${_key}_mk@`
-            _val2 = `' + @${_field} + '`
+            if (nFields.includes(_key)) {
+              _val2 = `' + cast (@${_field} as nvarchar(50)) + '`
+            } else if (dataFields.includes(_key)) {
+              _val2 = `' + CONVERT(nvarchar(50), @${_field}, 23) + '`
+            } else {
+              _val2 = `' + @${_field} + '`
+            }
           }
 
           _value.push(`${_labels[index] || ''}锛�${_val2}`)

--
Gitblit v1.8.0