From bfbd5a28cacbde2c5d69df79c817c1218da41dde Mon Sep 17 00:00:00 2001
From: king <18310653075@163.com>
Date: 星期三, 11 九月 2024 18:21:54 +0800
Subject: [PATCH] 2024-09-11

---
 src/utils/utils-custom.js |   40 +++++++++++++++++++++++++++-------------
 1 files changed, 27 insertions(+), 13 deletions(-)

diff --git a/src/utils/utils-custom.js b/src/utils/utils-custom.js
index 893d8aa..501e159 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})
           }
@@ -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