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