From c59272a71754865503c6a3ddeabc6c6da3ed47ce Mon Sep 17 00:00:00 2001
From: king <18310653075@163.com>
Date: 星期五, 13 九月 2024 18:03:07 +0800
Subject: [PATCH] 2024-09-13

---
 src/utils/utils-custom.js |   46 ++++++++++++++++++++++++++++++----------------
 1 files changed, 30 insertions(+), 16 deletions(-)

diff --git a/src/utils/utils-custom.js b/src/utils/utils-custom.js
index 893d8aa..734009d 100644
--- a/src/utils/utils-custom.js
+++ b/src/utils/utils-custom.js
@@ -3129,7 +3129,7 @@
   
           if (item.subtype === 'editable' && item.submit.intertype === 'system') {
             item.submit.logLabel = item.$menuname + '-鎻愪氦'
-            let msg = getEditTableSql(item.submit, item.cols, item.columns)
+            let msg = getEditTableSql(item.submit, item.cols, item.columns, item.setting)
 
             sqls.push({uuid: 'submit_' + item.uuid, type: 'editable', ...msg})
           }
@@ -3214,8 +3214,8 @@
           // 鏁版嵁婧恠ql璇彞锛岄澶勭悊锛屾潈闄愰粦鍚嶅崟瀛楁璁剧疆涓洪殣钘忚〃鍗�
           if (['select', 'link', 'multiselect', 'radio', 'checkbox', 'checkcard'].includes(form.type) && form.resourceType === '1') {
             let msg = getFormSql(form, '琛ㄥ崟')
-  
-            sqls.push({uuid: form.uuid, type: 'form', ...msg})
+
+            sqls.push({uuid: md5(cell.uuid + form.uuid), type: 'form', ...msg})
           } else if (form.type === 'popSelect') {
             let msg = getPopSelectSql(form)
         
@@ -3248,7 +3248,7 @@
             if (['select', 'link', 'multiselect', 'radio', 'checkbox', 'checkcard'].includes(form.type) && form.resourceType === '1') {
               let msg = getFormSql(form, '琛ㄥ崟')
     
-              sqls.push({uuid: form.uuid, type: 'form', ...msg})
+              sqls.push({uuid: md5(cell.uuid + form.uuid), type: 'form', ...msg})
             } else if (form.type === 'popSelect') {
               let msg = getPopSelectSql(form)
           
@@ -5149,7 +5149,7 @@
     return {LText: sql, md5: md5(sql), reps}
   }
 
-  let getEditTableSql = (btn, cols, columns) => {
+  let getEditTableSql = (btn, cols, columns, setting) => {
     let sheet = btn.sheet.replace(/@db@/ig, '')
     let database = ''
     if (/@db@/ig.test(btn.sheet)) {
@@ -5157,28 +5157,42 @@
     }
   
     let forms = []
-    let _fields = {}
-
-    columns.forEach(col => {
-      _fields[col.field] = col.datatype
-    })
+    let _forms = {}
+    let index = 0
 
     let getColumns = (cols) => {
       cols.forEach(item => {
         if (item.type === 'colspan') {
           getColumns(item.subcols)
         } else if (item.editable === 'true') {
-          forms.push({
-            field: item.field,
-            type: item.type,
-            datatype: _fields[item.field] || 'nvarchar(50)'
-          })
+          item.$sort = index
+          _forms[item.field] = item
+          index++
         }
       })
     }
 
     getColumns(cols)
-  
+
+    columns.forEach(item => {
+      if (item.field === setting.primaryKey) return
+
+      if (_forms[item.field]) {
+        let _item = {..._forms[item.field]}
+        if (_item.editType === 'date') {
+          _item.datatype = _item.declareType || 'datetime'
+        } else {
+          _item.datatype = item.datatype
+        }
+
+        forms.push(_item)
+      } else {
+        forms.push({...item, $sort: 999})
+      }
+    })
+
+    forms.sort((a, b) => a.$sort - b.$sort)
+
     let sql = ''
   
     let _initCustomScript = '' // 鍒濆鍖栬剼鏈�

--
Gitblit v1.8.0