From 4d6b9f8a2d7b316633e43b489eae9ada949c07b5 Mon Sep 17 00:00:00 2001
From: king <18310653075@163.com>
Date: 星期二, 10 九月 2024 10:18:08 +0800
Subject: [PATCH] Merge branch 'master' into positec
---
src/utils/utils-custom.js | 950 +++++++++++++++++++++++++++++++++++++++++++++-------------
1 files changed, 735 insertions(+), 215 deletions(-)
diff --git a/src/utils/utils-custom.js b/src/utils/utils-custom.js
index 6556d9f..893d8aa 100644
--- a/src/utils/utils-custom.js
+++ b/src/utils/utils-custom.js
@@ -1745,6 +1745,115 @@
}
/**
+ * @description 鑾峰彇鍙戦�佸閮ㄦ秷鎭�
+ */
+export function getOutMessage (config) {
+ let message = 'false'
+
+ let filterBtn = (cell) => {
+ if (['pop', 'exec', 'form', 'prompt', 'formSubmit'].includes(cell.OpenType) && cell.verify) {
+ if (cell.verify.noteEnable === 'true' || cell.verify.wxNote === 'true' || cell.verify.emailEnable === 'true') {
+ message = 'true'
+ }
+ }
+ }
+
+ let traversal = (components) => {
+ if (!components || message === 'true') return
+
+ components.forEach(item => {
+ if (item.type === 'tabs') {
+ item.subtabs.forEach(tab => {
+ traversal(tab.components)
+ })
+ } else if (item.type === 'group') {
+ traversal(item.components)
+ } else {
+ if (item.action) {
+ item.action.forEach(cell => {
+ if (cell.OpenType === 'popview') {
+ if (cell.config) {
+ traversal(cell.config.components)
+ }
+ } else {
+ filterBtn(cell)
+ }
+ })
+ }
+
+ if (item.type === 'card' || item.type === 'carousel' || item.type === 'timeline') {
+ item.subcards.forEach(card => {
+ card.elements && card.elements.forEach(cell => {
+ if (cell.eleType !== 'button') return
+
+ if (cell.OpenType === 'popview') {
+ if (cell.config) {
+ traversal(cell.config.components)
+ }
+ } else {
+ filterBtn(cell)
+ }
+ })
+ card.backElements && card.backElements.forEach(cell => {
+ if (cell.eleType !== 'button') return
+
+ if (cell.OpenType === 'popview') {
+ if (cell.config) {
+ traversal(cell.config.components)
+ }
+ } else {
+ filterBtn(cell)
+ }
+ })
+ })
+ } else if (item.type === 'balcony') {
+ item.elements && item.elements.forEach(cell => {
+ if (cell.eleType !== 'button') return
+
+ if (cell.OpenType === 'popview') {
+ if (cell.config) {
+ traversal(cell.config.components)
+ }
+ } else {
+ filterBtn(cell)
+ }
+ })
+ } else if (item.type === 'table') {
+ let loopCol = (cols) => {
+ cols.forEach(col => {
+ if (col.type === 'colspan') {
+ loopCol(col.subcols)
+ } else if (col.type === 'custom') {
+ col.elements.forEach(cell => {
+ if (cell.eleType !== 'button') return
+
+ if (cell.OpenType === 'popview') {
+ if (cell.config) {
+ traversal(cell.config.components)
+ }
+ } else {
+ filterBtn(cell)
+ }
+ })
+ }
+ })
+ }
+ loopCol(item.cols)
+ } else if (item.type === 'form') {
+ item.subcards.forEach(group => {
+ filterBtn(group.subButton)
+ })
+ }
+ }
+ })
+ }
+
+ traversal(config.components)
+
+ return message
+}
+
+/**
* @description 妫�娴嬬粍浠跺唴瀹�
*/
export function checkComponent (card) {
@@ -1985,10 +2094,18 @@
let _quot = sql.match(/'{1}/g)
let _lparen = sql.match(/\({1}/g)
let _rparen = sql.match(/\){1}/g)
+ let _ch_b = sql.match(/\$check@/ig)
+ let _ch_d = sql.match(/@check\$/ig)
+ let _m_b = sql.match(/\$@/ig)
+ let _m_d = sql.match(/@\$/ig)
_quot = _quot ? _quot.length : 0
_lparen = _lparen ? _lparen.length : 0
_rparen = _rparen ? _rparen.length : 0
+ _ch_b = _ch_b ? _ch_b.length : 0
+ _ch_d = _ch_d ? _ch_d.length : 0
+ _m_b = _m_b ? _m_b.length : 0
+ _m_d = _m_d ? _m_d.length : 0
if (_quot % 2 !== 0) {
notification.warning({
@@ -2001,6 +2118,20 @@
notification.warning({
top: 92,
message: 'sql涓�()蹇呴』鎴愬鍑虹幇',
+ duration: 5
+ })
+ return false
+ } else if (_ch_b !== _ch_d) {
+ notification.warning({
+ top: 92,
+ message: 'sql涓� $check@ 涓� @check$ 蹇呴』鎴愬鍑虹幇',
+ duration: 5
+ })
+ return false
+ } else if (_m_b !== _m_d) {
+ notification.warning({
+ top: 92,
+ message: 'sql涓� $@ 涓� @$ 蹇呴』鎴愬鍑虹幇',
duration: 5
})
return false
@@ -2862,13 +2993,39 @@
let urlFields = config.urlFields
let appType = sessionStorage.getItem('appType')
let process = config.process === 'true'
+ let sysVars = ['loginuid', 'sessionuid', 'userid', 'appkey', 'lang', 'username', 'fullname', 'menuname']
if (urlFields) {
urlFields = urlFields.map(n => n.toLowerCase())
}
- let filterComponent = (components, mainSearch) => {
+let callback = `
+COMMIT TRAN
+set NOCOUNT ON
+RETURN
+END TRY
+BEGIN CATCH
+ ROLLBACK TRAN
+ DECLARE @ErrorMessage NVARCHAR(4000);
+ DECLARE @ErrorSeverity INT;
+ DECLARE @ErrorState INT;
+
+ set @ErrorCode=cast(ERROR_NUMBER() as nvarchar(50))
+ set @retmsg=ERROR_MESSAGE();
+ select @ErrorMessage=ERROR_MESSAGE(), @ErrorSeverity=ERROR_SEVERITY(), @ErrorState=ERROR_STATE();
+
+ RAISERROR(@ErrorMessage, @ErrorSeverity, @ErrorState);
+END CATCH
+
+aaa:
+select @ErrorCode as ErrorCode,@retmsg as retmsg
+GOTO_RETURN:
+ ROLLBACK TRAN`
+
+ let filterComponent = (components, mainSearch, label = '') => {
components.forEach(item => {
+ item.$menuname = (config.MenuName || '') + label + '-' + (item.name || '')
+
if (item.type === 'tabs') {
item.subtabs.forEach(tab => {
let _mainSearch = mainSearch || []
@@ -2880,10 +3037,10 @@
_mainSearch = com.search || []
})
}
- filterComponent(tab.components, _mainSearch)
+ filterComponent(tab.components, _mainSearch, label)
})
} else if (item.type === 'group') {
- filterComponent(item.components, mainSearch)
+ filterComponent(item.components, mainSearch, label)
} else {
if (item.wrap && item.setting) {
if (item.wrap.datatype === 'public' || item.wrap.datatype === 'static') {
@@ -2897,7 +3054,7 @@
if (appType !== 'mob' && item.search && item.search.length > 0) {
item.search.forEach(cell => {
if (['select', 'link', 'multiselect', 'checkcard', 'radio'].includes(cell.type) && cell.resourceType === '1' && cell.dataSource) {
- let msg = getFormSql(cell)
+ let msg = getFormSql(cell, '鎼滅储')
sqls.push({uuid: cell.uuid, type: 'sForm', ...msg})
}
@@ -2913,6 +3070,7 @@
item.setting.laypage = 'false'
item.setting.$top = true
}
+ item.setting.$name = item.$menuname || ''
let msg = getDataSource(item, mainSearch)
@@ -2947,7 +3105,7 @@
})
} else if (item.subtype === 'editable' && col.editable === 'true') {
if (col.editType === 'select' && col.resourceType === '1') {
- let msg = getFormSql(col)
+ let msg = getFormSql(col, '琛ㄥ崟')
sqls.push({uuid: col.uuid, type: 'tbForm', ...msg})
} else if (col.editType === 'popSelect') {
@@ -2970,6 +3128,7 @@
getCols(item.cols)
if (item.subtype === 'editable' && item.submit.intertype === 'system') {
+ item.submit.logLabel = item.$menuname + '-鎻愪氦'
let msg = getEditTableSql(item.submit, item.cols, item.columns)
sqls.push({uuid: 'submit_' + item.uuid, type: 'editable', ...msg})
@@ -3015,8 +3174,13 @@
}
let resetButton = (item, cell, isback) => {
+ cell.logLabel = item.$menuname + '-' + cell.label
+
if (['exec', 'prompt', 'pop', 'form', 'formSubmit'].includes(cell.OpenType)) {
if (cell.intertype === 'system' || cell.procMode === 'system') { // 绯荤粺鎺ュ彛
+ if (cell.verify && cell.verify.linkEnable === 'true' && /@/.test(cell.verify.linkUrl)) {
+ cell.returnValue = 'true'
+ }
if (item.subtype === 'dualdatacard' && isback) {
let _item = fromJS(item).toJS()
_item.columns = _item.subColumns || []
@@ -3049,7 +3213,7 @@
cell.modal.fields.forEach(form => {
// 鏁版嵁婧恠ql璇彞锛岄澶勭悊锛屾潈闄愰粦鍚嶅崟瀛楁璁剧疆涓洪殣钘忚〃鍗�
if (['select', 'link', 'multiselect', 'radio', 'checkbox', 'checkcard'].includes(form.type) && form.resourceType === '1') {
- let msg = getFormSql(form)
+ let msg = getFormSql(form, '琛ㄥ崟')
sqls.push({uuid: form.uuid, type: 'form', ...msg})
} else if (form.type === 'popSelect') {
@@ -3074,7 +3238,7 @@
} else if (cell.OpenType === 'funcbutton') {
if (cell.funcType === 'print') {
if (cell.intertype === 'system' && cell.verify && cell.verify.dataType === 'custom') {
- let msg = getPrintSql(cell)
+ let msg = getPrintSql(cell, item)
sqls.push({uuid: cell.uuid, type: 'print', ...msg})
}
@@ -3082,7 +3246,7 @@
cell.modal.fields.forEach(form => {
// 鏁版嵁婧恠ql璇彞锛岄澶勭悊锛屾潈闄愰粦鍚嶅崟瀛楁璁剧疆涓洪殣钘忚〃鍗�
if (['select', 'link', 'multiselect', 'radio', 'checkbox', 'checkcard'].includes(form.type) && form.resourceType === '1') {
- let msg = getFormSql(form)
+ let msg = getFormSql(form, '琛ㄥ崟')
sqls.push({uuid: form.uuid, type: 'form', ...msg})
} else if (form.type === 'popSelect') {
@@ -3128,14 +3292,13 @@
})
}
- filterComponent(cell.config.components, _mainSearch)
+ filterComponent(cell.config.components, _mainSearch, '-' + cell.label)
}
}
}
let getSearches = (searches) => {
let sFields = []
- let query = false
searches.forEach(item => {
if (!item.field) return
@@ -3177,13 +3340,9 @@
} else {
sFields.push(item.field)
}
-
- if (query) return
-
- query = item.query !== 'false'
})
- return { sFields, query }
+ return sFields
}
let getSysDefaultSql = (btn, component) => {
@@ -3962,35 +4121,65 @@
if (verify.workFlow === 'true' && process) {
if (verify.flowType === 'start') {
+ _sql = _sql.replace(/@start_type@/ig, `'寮�濮�'`)
// works_flow_error 娴佺▼閿欒
- let worksReFields = ['works_flow_error', 'works_flow_code', 'works_flow_name', 'works_flow_param', 'works_flow_detail_id', 'status', 'statusname', 'work_group', 'work_grade', 'start_type']
+ let worksReFields = ['works_flow_error', 'works_flow_code', 'works_flow_name', 'works_flow_param', 'works_flow_detail_id', 'status', 'statusname', 'work_group', 'work_grade']
worksReFields.forEach(n => {
_sql = _sql.replace(new RegExp('@' + n + '@', 'ig'), `'@${n}@'`)
})
} else {
+ _sql = _sql.replace(/@check_type@/ig, verify.flowType === 'reject' ? `'椹冲洖'` : `'瀹℃牳'`)
+ _sql = _sql.replace(/@notice_type@/ig, `'鎶勯��'`)
// works_flow_error 娴佺▼閿欒
// works_flow_countersign 浼氱/鎴栫鏍囪 浼氱涓� Y
// works_begin_branch 椹冲洖鑷冲紑濮嬪垎鏀紙line.mknode === 'startEdge'锛�
// works_flow_sign_field 浼氱 鏍囪瀛楁 statuscharone/statuschartwo/statuscharthree/statuscharfour/statuscharfive
// works_flow_sign_label 浼氱 鏍囪鍊� ***/***/宸插鏍�
// works_flow_sign_values 浼氱鏍囪鎷兼帴鍊硷紙闄ゆ湰浜哄锛�
- let worksReFields = ['works_flow_error', 'works_flow_countersign', 'works_flow_sign_values', 'works_begin_branch', 'works_flow_sign_label', 'works_flow_code', 'works_flow_name', 'works_flow_param', 'works_flow_detail_id', 'status', 'statusname', 'work_group', 'work_grade', 'check_type', 'notice_type', 'check_userids', 'notice_userids', 'works_flow_sign']
+ let worksReFields = ['works_flow_error', 'works_flow_countersign', 'works_flow_sign_values', 'works_begin_branch', 'works_flow_sign_label', 'works_flow_code', 'works_flow_name', 'works_flow_param', 'works_flow_detail_id', 'status', 'statusname', 'work_group', 'work_grade', 'check_userids', 'notice_userids', 'works_flow_sign']
worksReFields.forEach(n => {
_sql = _sql.replace(new RegExp('@' + n + '@', 'ig'), `'@${n}@'`)
})
}
}
- if (btn.procMode === 'system') {
+ // if (btn.procMode === 'system' || btn.returnValue === 'true') {
+ // _sql += `
+ // aaa: if @ErrorCode!=''
+ // insert into tmp_err_retmsg (ID, ErrorCode, retmsg, CreateUserID) select @time_id@,@ErrorCode, @retmsg,@UserID@`
+ // } else if (btn.output) {
+ // _sql += `
+ // aaa: select @ErrorCode as ErrorCode,@retmsg as retmsg,${btn.output} as mk_b_id`
+ // } else {
+ // _sql += `
+ // aaa: select @ErrorCode as ErrorCode,@retmsg as retmsg`
+ // }
+
+ if (/@ErrorCode='(ENT|NNT|FNT|NMNT|CNT|-2NT)'/ig.test(_sql)) {
+ _sql = _sql.replace(/@ErrorCode='(ENT|NNT|FNT|NMNT|CNT|-2NT)'[\S\s]+\sgoto\s+aaa($|\s)/ig, (word) => {
+ return word.replace(/goto aaa/, 'goto mk_ent')
+ })
_sql += `
- aaa: if @ErrorCode!=''
- insert into tmp_err_retmsg (ID, ErrorCode, retmsg, CreateUserID) select @time_id@,@ErrorCode, @retmsg,@UserID@`
+ if 1=2
+ begin
+ mk_ent:
+ set @ErrorCode=left(@ErrorCode,1)
+ end
+ `
+ }
+
+ if (btn.procMode === 'system' || btn.returnValue === 'true') {
+ _sql += callback
} else if (btn.output) {
_sql += `
- aaa: select @ErrorCode as ErrorCode,@retmsg as retmsg,${btn.output} as mk_b_id`
+ select @ErrorCode as ErrorCode,@retmsg as retmsg,${btn.output} as mk_b_id
+ ${callback}
+ `
} else {
_sql += `
- aaa: select @ErrorCode as ErrorCode,@retmsg as retmsg`
+ select @ErrorCode as ErrorCode,@retmsg as retmsg
+ ${callback}
+ `
}
let syses = ['UserName', 'FullName', 'RoleID', 'mk_departmentcode', 'mk_organization', 'mk_user_type', 'mk_nation', 'mk_province', 'mk_city', 'mk_district', 'mk_address']
@@ -4030,7 +4219,7 @@
let reps = []
let decSql = [`@tbid nvarchar(50),@ErrorCode nvarchar(50),@retmsg nvarchar(4000),@BillCode nvarchar(50),@BVoucher nvarchar(50),@FIBVoucherDate nvarchar(50), @FiYear nvarchar(50),@ModularDetailCode nvarchar(50),@mk_deleted int,@bid nvarchar(50)`]
- let secSql = [`@ErrorCode='',@retmsg='', @BillCode='',@BVoucher='',@FIBVoucherDate='',@FiYear='',@ModularDetailCode='', @mk_deleted=1, @bid=@BID@`]
+ let secSql = [`@ErrorCode='S',@retmsg='', @BillCode='',@BVoucher='',@FIBVoucherDate='',@FiYear='',@ModularDetailCode='', @mk_deleted=1, @bid=@BID@`]
syses.forEach(s => {
if (new RegExp('@' + s + '[^0-9a-z_]', 'ig').test(_sql)) {
@@ -4048,20 +4237,36 @@
decSql = [...decSql, ..._declares]
- _sql = `Declare ${decSql.join(',')}
+ // INSERT INTO s_paas_api_log (appkey,api_name,api_count,menuname,createuserid,createuser,createstaff,cdefine1,cdefine2)
+ // SELECT @appkey@,'sPC_TableData_InUpDe',1,@menuname@,@UserID@,@username@,@fullname@,@SessionUid@,@LoginUID@
+ _sql = `/* ${btn.logLabel} */
+ BEGIN TRY
+ begin TRAN
+
+ Declare ${decSql.join(',')}
/* 鍑瘉鍙婄敤鎴蜂俊鎭垵濮嬪寲璧嬪�� */
select ${secSql.join(',')}
${_sql}
`
- _sql = _sql.replace(/\n\s{8,10}/g, '\n')
- _sql = _sql.replace(/\n\s+\/\*/g, `\n/*`)
- let regs = ['ID', 'BID', 'time_id', 'datam', 'LoginUID', 'SessionUid', 'UserID', 'Appkey', 'lang', 'typename']
+ let regs = ['ID', 'BID', 'time_id', 'datam', 'typename']
regs.forEach(s => {
if (new RegExp('@' + s + '@', 'ig').test(_sql)) {
reps.push(s)
}
+ })
+
+ let map = new Map()
+ reps.push(...sysVars)
+ reps = reps.filter(n => {
+ if (map.has(n.toLowerCase())) {
+ return false
+ }
+
+ map.set(n.toLowerCase(), true)
+
+ return true
})
reps.forEach(n => {
@@ -4072,18 +4277,33 @@
_sql = _sql.replace(/\$@/ig, '@datam_begin@').replace(/@\$/ig, '@datam_end@')
reps.push('datam_begin', 'datam_end')
}
-
- if (/\$check@|@check\$/ig.test(_sql)) {
- _sql = _sql.replace(/\$check@/ig, '@mk_check_begin@').replace(/@check\$/ig, '@mk_check_end@')
- reps.push('mk_check_begin', 'mk_check_end')
+ if (btn.procMode === 'system') {
+ if (/\$check@|@check\$/ig.test(_sql)) {
+ _sql = _sql.replace(/\$check@|@check\$/ig, '')
+ }
+ } else {
+ if (/\$check@|@check\$/ig.test(_sql)) {
+ _sql = _sql.replace(/\$check@/ig, '@mk_check_begin@').replace(/@check\$/ig, '@mk_check_end@')
+ reps.push('mk_check_begin', 'mk_check_end')
+ }
}
if (/@db@/ig.test(_sql)) {
reps.push('db')
}
- reps = Array.from(new Set([...reps, ...colreps]))
+ _sql = _sql.replace(/\n\x20{8,10}/g, '\n').replace(/\n{3,}/g, '\n\n').replace(/^\s+|\s+$/g, '').replace(/\t+|\v+/g, '')
+
+ reps = reps.filter(n => {
+ if (sysVars.includes(n.toLowerCase())) {
+ return false
+ }
+
+ return true
+ })
+
+ reps = [...reps, ...colreps]
- return { LText: _sql, reps }
+ return { LText: _sql, md5: md5(_sql), reps }
}
let getSysBackSql = (btn, component) => {
@@ -4261,23 +4481,46 @@
}
_sql += `
- ${_prev}
- /* 澶栭儴鎺ュ彛鍏ュ弬 */
- @mk_outer_params@
- ${_back}
- `
+ ${_prev}
+ /* 澶栭儴鎺ュ彛鍏ュ弬 */
+ @mk_outer_params@
+ ${_back}
+ `
+ // if (btn.output) {
+ // _sql += `
+ // aaa: select @ErrorCode as ErrorCode,@retmsg as retmsg,${btn.output} as mk_b_id`
+ // } else {
+ // _sql += `
+ // aaa: select @ErrorCode as ErrorCode,@retmsg as retmsg`
+ // }
+ if (/@ErrorCode='(ENT|NNT|FNT|NMNT|CNT|-2NT)'/ig.test(_sql)) {
+ _sql = _sql.replace(/@ErrorCode='(ENT|NNT|FNT|NMNT|CNT|-2NT)'[\S\s]+\sgoto\s+aaa($|\s)/ig, (word) => {
+ return word.replace(/goto aaa/, 'goto mk_ent')
+ })
+ _sql += `
+ if 1=2
+ begin
+ mk_ent:
+ set @ErrorCode=left(@ErrorCode,1)
+ end
+ `
+ }
if (btn.output) {
_sql += `
- aaa: select @ErrorCode as ErrorCode,@retmsg as retmsg,${btn.output} as mk_b_id`
+ select @ErrorCode as ErrorCode,@retmsg as retmsg,${btn.output} as mk_b_id
+ ${callback}
+ `
} else {
_sql += `
- aaa: select @ErrorCode as ErrorCode,@retmsg as retmsg`
+ select @ErrorCode as ErrorCode,@retmsg as retmsg
+ ${callback}
+ `
}
let syses = ['tbid', 'BillCode', 'BVoucher', 'FIBVoucherDate', 'FiYear', 'ModularDetailCode', 'mk_deleted', 'bid', 'UserName', 'FullName', 'RoleID', 'mk_departmentcode', 'mk_organization', 'mk_user_type', 'mk_nation', 'mk_province', 'mk_city', 'mk_district', 'mk_address']
let decSql = [`@ErrorCode nvarchar(50),@retmsg nvarchar(4000)`]
- let secSql = [`@ErrorCode='',@retmsg=''`]
+ let secSql = [`@ErrorCode='S',@retmsg=''`]
syses.forEach(s => {
if (new RegExp('@' + s + '[^0-9a-z_]', 'ig').test(_sql)) {
@@ -4305,21 +4548,34 @@
decSql = [...decSql, ..._declares]
- _sql = `Declare ${decSql.join(',')}
+ _sql = `/* ${btn.logLabel}(鍥炶皟) */
+ BEGIN TRY
+ begin TRAN
+
+ Declare ${decSql.join(',')}
/* 鍒濆鍖栬祴鍊� */
select ${secSql.join(',')}
${_sql}
`
- _sql = _sql.replace(/\n\s{8,10}/g, '\n')
- _sql = _sql.replace(/\n\s+\/\*/g, `\n/*`)
-
- let regs = ['ID', 'BID', 'time_id', 'datam', 'LoginUID', 'SessionUid', 'UserID', 'Appkey', 'lang', 'typename']
+ let regs = ['ID', 'BID', 'time_id', 'datam', 'typename']
regs.forEach(s => {
if (new RegExp('@' + s + '@', 'ig').test(_sql)) {
reps.push(s)
}
+ })
+
+ let map = new Map()
+ reps.push(...sysVars)
+ reps = reps.filter(n => {
+ if (map.has(n.toLowerCase())) {
+ return false
+ }
+
+ map.set(n.toLowerCase(), true)
+
+ return true
})
reps.forEach(n => {
@@ -4334,12 +4590,22 @@
reps.push('db')
}
- reps = Array.from(new Set([...reps, ...colreps]))
+ _sql = _sql.replace(/\n\x20{8,10}/g, '\n').replace(/\n{3,}/g, '\n\n').replace(/^\s+|\s+$/g, '').replace(/\t+|\v+/g, '')
- return { LText: _sql, reps, tbs: tables }
+ reps = reps.filter(n => {
+ if (sysVars.includes(n.toLowerCase())) {
+ return false
+ }
+
+ return true
+ })
+
+ reps = [...reps, ...colreps]
+
+ return { LText: _sql, md5: md5(_sql), reps, tbs: tables }
}
- let getDataSource = (item, mainSearch = []) => {
+ let getDataSource = (item, mainSearch = [], type) => {
if (!item.setting || item.setting.interType !== 'system') return
let searches = item.search || []
@@ -4347,7 +4613,7 @@
searches = [...searches, ...mainSearch]
}
item.$searches = fromJS(searches).toJS()
- let { sFields, query } = getSearches(searches)
+ let sFields = getSearches(searches)
let _columns = []
if (item.subtype === 'dualdatacard') {
@@ -4374,8 +4640,22 @@
}
})
+ // if (_customScript || _tailScript) {
+ // _tailScript += `${_tailScript}
+ // aaa:
+ // if @ErrorCode!=''
+ // insert into tmp_err_retmsg (ID, ErrorCode, retmsg, CreateUserID) select @time_id@,@ErrorCode, @retmsg,@UserID@
+ // `
+ // }
+
+ let _search = ''
if (item.setting.execute !== 'false') {
_dataresource = item.setting.dataresource || ''
+ _search = '@mk_search@'
+ }
+
+ if (type === 'print') {
+ _search = ''
}
if (/\s/.test(_dataresource)) {
@@ -4384,21 +4664,13 @@
item.setting.dataresource = _dataresource
item.setting.customScript = _customScript
-
- let _search = '@search@'
- if (item.setting.queryType === 'statistics' || !query) {
- _search = ''
- }
let testSql = _dataresource + _customScript + _tailScript
let decSql = [`@ErrorCode nvarchar(50),@retmsg nvarchar(4000)`]
- let secSql = [`@ErrorCode='',@retmsg =''`]
+ let secSql = [`@ErrorCode='S',@retmsg =''`]
let reps = []
- if (_customScript || _tailScript) {
- reps.push('UserID', 'time_id')
- }
let syses = ['UserName', 'FullName', 'RoleID', 'mk_departmentcode', 'mk_organization', 'mk_user_type', 'mk_nation', 'mk_province', 'mk_city', 'mk_district', 'mk_address']
syses.forEach(s => {
@@ -4415,11 +4687,11 @@
}
})
- decSql = `declare ${decSql.join(',')}
- select ${secSql.join(',')}`
+ decSql = `declare ${decSql.join(',')}${type === 'print' ? '@mk_print_declare@' : ''}
+ select ${secSql.join(',')}${type === 'print' ? '@mk_print_select@' : ''}`
// 涓嶉渶瑕佸崟寮曞彿锛歰rderBy銆乸ageSize銆乸ageIndex銆乨b
- let regs = [...sFields, 'orderBy', 'pageSize', 'pageIndex', 'ID', 'BID', 'time_id', 'LoginUID', 'SessionUid', 'UserID', 'Appkey', 'lang', 'datam', 'typename']
+ let regs = [...sFields, 'orderBy', 'pageSize', 'pageIndex', 'ID', 'BID', 'time_id', 'datam', 'typename']
if (item.hasExtend) {
regs.push('mk_time')
@@ -4446,134 +4718,130 @@
let LText = ''
let DateCount = ''
if (_dataresource) {
+ /*system_query*/
if (/@pageSize@|@orderBy@|@mk_total/i.test(testSql)) {
- LText = `/*system_query*/select ${arr_field} from ${_dataresource} ${_search} `
+ LText = `select ${arr_field} from ${_dataresource} ${_search} `
} else if (item.setting.laypage === 'true' && item.setting.order) {
- LText = `/*system_query*/select top @pageSize@ ${arr_field} from (select ${arr_field} ,ROW_NUMBER() over(order by @orderBy@) as rows from ${_dataresource} ${_search}) tmptable where rows > @pageSize@ * (@pageIndex@ - 1) order by tmptable.rows `
+ LText = `select top @pageSize@ ${arr_field} from (select ${arr_field} ,ROW_NUMBER() over(order by @orderBy@) as rows from ${_dataresource} ${_search}) tmptable where rows > @pageSize@ * (@pageIndex@ - 1) order by tmptable.rows `
reps.push('pageSize', 'orderBy', 'pageIndex')
if (item.subtype === 'dualdatacard') {
- DateCount = `/*system_query*/select count(1) as total from (select distinct ${item.setting.primaryKey || 'ID'} from ${_dataresource} ${_search})a`
+ DateCount = `select count(1) as total from (select distinct ${item.setting.primaryKey || 'ID'} from ${_dataresource} ${_search})a`
} else {
- DateCount = `/*system_query*/select count(1) as total from ${_dataresource} ${_search}`
+ DateCount = `select count(1) as total from ${_dataresource} ${_search}`
}
} else if (item.setting.$top) {
if (item.setting.order) {
- LText = `/*system_query*/select top 1 ${arr_field} from ${_dataresource} ${_search} order by @orderBy@ `
+ LText = `select top 1 ${arr_field} from ${_dataresource} ${_search} order by @orderBy@ `
reps.push('orderBy')
} else {
- LText = `/*system_query*/select top 1 ${arr_field} from ${_dataresource} ${_search} `
+ LText = `select top 1 ${arr_field} from ${_dataresource} ${_search} `
}
+ } else if (item.setting.$fixOrder) {
+ LText = `select ${arr_field} from ${_dataresource} ${_search} order by ${item.setting.order} `
} else if (item.setting.order) {
- LText = `/*system_query*/select ${arr_field} from ${_dataresource} ${_search} order by @orderBy@ `
+ LText = `select ${arr_field} from ${_dataresource} ${_search} order by @orderBy@ `
reps.push('orderBy')
} else {
- LText = `/*system_query*/select ${arr_field} from ${_dataresource} ${_search} `
+ LText = `select ${arr_field} from ${_dataresource} ${_search} `
}
}
- if (_customScript) {
- _customScript = `${decSql}
- ${_customScript}
+ let sub_name = ''
+ let tabid = ''
+ let parid = ''
+ let sub_field = ''
+
+ if (item.subtype === 'dualdatacard') {
+ arr_field = item.columns.map(col => col.field).join(',')
+ sub_name = item.setting.subdata
+ tabid = item.setting.primaryKey || ''
+ parid = item.setting.subBID || ''
+ sub_field = item.subColumns.map(col => col.field).join(',')
+ }
+
+ // INSERT INTO s_paas_api_log (appkey,api_name,api_count,menuname,createuserid,createuser,createstaff,cdefine1,cdefine2)
+ // SELECT @appkey@,'sPC_Get_TableData',1,@menuname@,@UserID@,@username@,@fullname@,@SessionUid@,@LoginUID@
+ let sql = ''
+
+ if (item.setting.transact === 'true') {
+ sql = `/* ${item.setting.$name} */
+ BEGIN TRY
+ begin TRAN
+
+ SELECT obj_name='@mk_obj_name@',prm_field='',str_field='',
+ arr_field='${arr_field}',tabid='${tabid}',parid='${parid}',sub_name='${sub_name}',sub_field='${sub_field}'
`
- if (DateCount) {
- DateCount = `${DateCount}
- ${_tailScript}
- aaa:
- if @ErrorCode!=''
- insert into tmp_err_retmsg (ID, ErrorCode, retmsg, CreateUserID) select @time_id@,@ErrorCode,@retmsg,@UserID@
- `
- } else if (LText) {
- LText = `${LText}
- ${_tailScript}
- aaa:
- if @ErrorCode!=''
- insert into tmp_err_retmsg (ID, ErrorCode, retmsg, CreateUserID) select @time_id@,@ErrorCode,@retmsg,@UserID@
- `
- } else {
- _customScript = `${_customScript}
- ${_tailScript}
- aaa:
- if @ErrorCode!=''
- insert into tmp_err_retmsg (ID, ErrorCode, retmsg, CreateUserID) select @time_id@,@ErrorCode, @retmsg,@UserID@
- `
- }
- } else if (_tailScript && DateCount) {
- LText = `${decSql}
- ${LText}
- `
- DateCount = `${DateCount}
- ${_tailScript}
- aaa:
- if @ErrorCode!=''
- insert into tmp_err_retmsg (ID, ErrorCode, retmsg, CreateUserID) select @time_id@,@ErrorCode, @retmsg,@UserID@
- `
- } else if (_tailScript) {
- LText = `${decSql}
- ${LText}
- ${_tailScript}
- aaa:
- if @ErrorCode!=''
- insert into tmp_err_retmsg (ID, ErrorCode, retmsg, CreateUserID) select @time_id@,@ErrorCode, @retmsg,@UserID@
+
+ _tailScript += `${_tailScript}
+ select @ErrorCode as ErrorCode,@retmsg as retmsg
+ ${callback}
`
} else {
- LText = `${decSql}
- ${LText}
+ sql = `/* ${item.setting.$name} */
+ SELECT obj_name='@mk_obj_name@',prm_field='',str_field='',
+ arr_field='${arr_field}',tabid='${tabid}',parid='${parid}',sub_name='${sub_name}',sub_field='${sub_field}'
+ `
+
+ _tailScript += `${_tailScript}
+ select @ErrorCode as ErrorCode,@retmsg as retmsg
`
}
- reps = Array.from(new Set(reps))
+ if (DateCount) {
+ sql += `UNION ALL
+ SELECT obj_name='DateCount',prm_field='total',str_field='',
+ arr_field='',tabid='',parid='',sub_name='',sub_field=''
+ `
+ }
+ // sql += `UNION ALL
+ // SELECT obj_name='mk_error_code',prm_field='ErrorCode,retmsg',str_field='',
+ // arr_field='',tabid='',parid='',sub_name='',sub_field=''
+ // `
+ sql += `
+ ${decSql}
+ ${_customScript}
+ ${LText}
+ ${DateCount}
+ ${_tailScript}
+ `
- // LText = LText.replace(/\n\s{6,8}/g, '\n')
- // DateCount = DateCount.replace(/\n\s{6,8}/g, '\n')
- // _customScript = _customScript.replace(/\n\s{6,8}/g, '\n')
- // LText = LText.replace(/\n\s+\/\*/g, `\n/*`)
- // DateCount = DateCount.replace(/\n\s+\/\*/g, `\n/*`)
- // _customScript = _customScript.replace(/\n\s+\/\*/g, `\n/*`)
+ let map = new Map()
+ reps.push(...sysVars)
+ reps = reps.filter(n => {
+ if (map.has(n.toLowerCase())) {
+ return false
+ }
+ map.set(n.toLowerCase(), true)
+
+ return true
+ })
+
reps.forEach(n => {
if (['orderBy', 'pageSize', 'pageIndex'].includes(n)) return
- LText = LText.replace(new RegExp('@' + n + '@', 'ig'), `'@${n}@'`)
- DateCount = DateCount.replace(new RegExp('@' + n + '@', 'ig'), `'@${n}@'`)
- _customScript = _customScript.replace(new RegExp('@' + n + '@', 'ig'), `'@${n}@'`)
+ sql = sql.replace(new RegExp('@' + n + '@', 'ig'), `'@${n}@'`)
})
- if (/\$@/ig.test(testSql)) {
- LText = LText.replace(/\$@/ig, '@datam_begin@').replace(/@\$/ig, '@datam_end@')
- DateCount = DateCount.replace(/\$@/ig, '@datam_begin@').replace(/@\$/ig, '@datam_end@')
- _customScript = _customScript.replace(/\$@/ig, '@datam_begin@').replace(/@\$/ig, '@datam_end@')
+ if (/\$@/ig.test(sql)) {
+ sql = sql.replace(/\$@/ig, '@datam_begin@').replace(/@\$/ig, '@datam_end@')
reps.push('datam_begin', 'datam_end')
}
- if (/@db@/ig.test(testSql)) {
+ if (/@db@/ig.test(sql)) {
reps.push('db')
}
+ reps.push('mk_obj_name')
- // let sql = ''
- // let sub_name = ''
- // let tabid = ''
- // let parid = ''
- // let sub_field = ''
+ sql = sql.replace(/\n\x20{6,8}/g, '\n').replace(/\n{3,}/g, '\n\n').replace(/^\s+|\s+$/g, '').replace(/\t+|\v+/g, '')
- // if (item.subtype === 'dualdatacard') {
- // arr_field = item.columns.map(col => col.field).join(',')
- // sub_name = item.setting.subdata
- // tabid = item.setting.primaryKey || ''
- // parid = item.setting.subBID || ''
- // sub_field = item.subColumns.map(col => col.field).join(',')
- // }
+ reps = reps.filter(n => {
+ if (sysVars.includes(n.toLowerCase())) {
+ return false
+ }
- // sql += `
- // SELECT obj_name='data',prm_field='',str_field='',
- // arr_field='${arr_field}',tabid='${tabid}',parid='${parid}',sub_name='${sub_name}',sub_field='${sub_field}'
- // `
+ return true
+ })
- // if (DateCount) {
- // sql += `UNION ALL
- // SELECT obj_name='DateCount',prm_field='total',str_field='',
- // arr_field='',tabid='',parid='',sub_name='',sub_field=''
- // `
- // }
-
- return {LText, DateCount, customScript: _customScript, reps}
+ return {LText: sql, md5: md5(sql), reps, luser: /@userid@/ig.test(testSql)}
}
let getExcelInSql = (item) => {
@@ -4721,10 +4989,14 @@
`
}
- sql = `create table #${sheet} (${declarefields.join(',')},jskey nvarchar(50),BID nvarchar(50))
+ sql = `/* ${item.logLabel} */
+ BEGIN TRY
+ begin TRAN
+
+ create table #${sheet} (${declarefields.join(',')},jskey nvarchar(50),BID nvarchar(50))
Declare @ErrorCode nvarchar(50),@retmsg nvarchar(4000),@tbid Nvarchar(512)@mk_init_declare@
- Select @ErrorCode='',@retmsg=''@mk_init_select@
+ Select @ErrorCode='S',@retmsg=''@mk_init_select@
${_initCustomScript}
Insert into #${sheet} (${fields},jskey,BID)
@@ -4735,6 +5007,17 @@
${_uniquesql}
${_prevCustomScript}
${_insert}`
+
+ let mk_ent = ''
+ if (/@ErrorCode='(ENT|NNT|FNT|NMNT|CNT|-2NT)'/ig.test(sql + _backCustomScript)) {
+ mk_ent = `
+ if 1=2
+ begin
+ mk_ent:
+ set @ErrorCode=left(@ErrorCode,1)
+ end
+ `
+ }
if (btn.workFlow === 'true' && process) {
if (btn.flowSql === 'true') {
@@ -4766,11 +5049,13 @@
${_backCustomScript}
drop table #${sheet}
+ ${mk_ent}
+ select @ErrorCode as ErrorCode,@retmsg as retmsg
+ ${callback}`
- aaa: select @ErrorCode as ErrorCode,@retmsg as retmsg`
-
+ sql = sql.replace(/@start_type@/ig, `'寮�濮�'`)
// works_flow_error 娴佺▼閿欒
- let worksReFields = ['works_flow_error', 'works_flow_code', 'works_flow_name', 'works_flow_param', 'works_flow_detail_id', 'status', 'statusname', 'work_group', 'work_grade', 'start_type']
+ let worksReFields = ['works_flow_error', 'works_flow_code', 'works_flow_name', 'works_flow_param', 'works_flow_detail_id', 'status', 'statusname', 'work_group', 'work_grade']
worksReFields.forEach(n => {
sql = sql.replace(new RegExp('@' + n + '@', 'ig'), `'@${n}@'`)
})
@@ -4779,8 +5064,15 @@
${_backCustomScript}
drop table #${sheet}
+ ${mk_ent}
+ select @ErrorCode as ErrorCode,@retmsg as retmsg
+ ${callback}`
+ }
- aaa: select @ErrorCode as ErrorCode,@retmsg as retmsg`
+ if (/@ErrorCode='(ENT|NNT|FNT|NMNT|CNT|-2NT)'/ig.test(sql)) {
+ sql = sql.replace(/@ErrorCode='(ENT|NNT|FNT|NMNT|CNT|-2NT)'[\S\s]+\sgoto\s+aaa($|\s)/ig, (word) => {
+ return word.replace(/goto aaa/, 'goto mk_ent')
+ })
}
let reps = []
@@ -4808,7 +5100,7 @@
sql = sql.replace(/@mk_init_declare@/ig, decSql)
sql = sql.replace(/@mk_init_select@/ig, secSql)
- let regs = ['ID', 'BID', 'time_id', 'datam', 'LoginUID', 'SessionUid', 'UserID', 'Appkey', 'lang', 'typename']
+ let regs = ['ID', 'BID', 'time_id', 'datam', 'typename']
regs.forEach(s => {
if (new RegExp('@' + s + '@', 'ig').test(sql)) {
@@ -4816,22 +5108,45 @@
}
})
+ let map = new Map()
+ reps.push(...sysVars)
+ reps = reps.filter(n => {
+ if (map.has(n.toLowerCase())) {
+ return false
+ }
+
+ map.set(n.toLowerCase(), true)
+
+ return true
+ })
+
reps.forEach(n => {
sql = sql.replace(new RegExp('@' + n + '@', 'ig'), `'@${n}@'`)
})
-
- sql = sql.replace(/\n\s{6,10}/g, '\n')
- sql = sql.replace(/\n\s+\/\*/g, `\n/*`)
if (/\$@/ig.test(sql)) {
sql = sql.replace(/\$@/ig, '@datam_begin@').replace(/@\$/ig, '@datam_end@')
reps.push('datam_begin', 'datam_end')
}
+ if (/\$check@|@check\$/ig.test(sql)) {
+ sql = sql.replace(/\$check@/ig, '@mk_check_begin@').replace(/@check\$/ig, '@mk_check_end@')
+ reps.push('mk_check_begin', 'mk_check_end')
+ }
if (/@db@/ig.test(sql)) {
reps.push('db')
}
- return {LText: sql, reps}
+ sql = sql.replace(/\n\x20{6,10}/g, '\n').replace(/\n{3,}/g, '\n\n').replace(/^\s+|\s+$/g, '').replace(/\t+|\v+/g, '')
+
+ reps = reps.filter(n => {
+ if (sysVars.includes(n.toLowerCase())) {
+ return false
+ }
+
+ return true
+ })
+
+ return {LText: sql, md5: md5(sql), reps}
}
let getEditTableSql = (btn, cols, columns) => {
@@ -4998,9 +5313,13 @@
`
}
- sql = `create table #${sheet} (${declarefields.join(',')},jskey nvarchar(50),data_type nvarchar(50),BID nvarchar(256))
+ sql = `/* ${btn.logLabel} */
+ BEGIN TRY
+ begin TRAN
+
+ create table #${sheet} (${declarefields.join(',')},jskey nvarchar(50),data_type nvarchar(50),BID nvarchar(256))
Declare @ErrorCode nvarchar(50),@retmsg nvarchar(4000),@tbid Nvarchar(512)@mk_init_declare@
- Select @ErrorCode='',@retmsg=''@mk_init_select@
+ Select @ErrorCode='S',@retmsg=''@mk_init_select@
${_initCustomScript}
Insert into #${sheet} (${fields},jskey,data_type,BID)
@@ -5015,7 +5334,8 @@
drop table #${sheet}
- aaa: select @ErrorCode as ErrorCode,@retmsg as retmsg`
+ select @ErrorCode as ErrorCode,@retmsg as retmsg
+ ${callback}`
let reps = []
let decSql = []
@@ -5042,7 +5362,7 @@
sql = sql.replace(/@mk_init_declare@/ig, decSql)
sql = sql.replace(/@mk_init_select@/ig, secSql)
- let regs = ['BID', 'time_id', 'datam', 'LoginUID', 'SessionUid', 'UserID', 'Appkey', 'lang', 'typename']
+ let regs = ['BID', 'time_id', 'datam', 'typename']
regs.forEach(s => {
if (new RegExp('@' + s + '@', 'ig').test(sql)) {
@@ -5050,12 +5370,21 @@
}
})
+ let map = new Map()
+ reps.push(...sysVars)
+ reps = reps.filter(n => {
+ if (map.has(n.toLowerCase())) {
+ return false
+ }
+
+ map.set(n.toLowerCase(), true)
+
+ return true
+ })
+
reps.forEach(n => {
sql = sql.replace(new RegExp('@' + n + '@', 'ig'), `'@${n}@'`)
})
-
- sql = sql.replace(/\n\s{6,10}/g, '\n')
- sql = sql.replace(/\n\s+\/\*/g, `\n/*`)
if (/\$@/ig.test(sql)) {
sql = sql.replace(/\$@/ig, '@datam_begin@').replace(/@\$/ig, '@datam_end@')
@@ -5065,7 +5394,17 @@
reps.push('db')
}
- return {LText: sql, reps}
+ sql = sql.replace(/\n\x20{6,10}/g, '\n').replace(/\n{3,}/g, '\n\n').replace(/^\s+|\s+$/g, '').replace(/\t+|\v+/g, '')
+
+ reps = reps.filter(n => {
+ if (sysVars.includes(n.toLowerCase())) {
+ return false
+ }
+
+ return true
+ })
+
+ return {LText: sql, md5: md5(sql), reps}
}
let getExcelOutSql = (btn, component) => {
@@ -5088,6 +5427,7 @@
item.setting.queryType = btn.verify.queryType
item.setting.laypage = btn.pagination
item.setting.order = btn.verify.order || ''
+ item.setting.$name = btn.logLabel || ''
if (btn.Ot === 'requiredOnce') {
item.setting.primaryKey = btn.verify.primaryKey || component.setting.primaryKey || 'ID'
@@ -5100,7 +5440,7 @@
return msg
}
- let getPrintSql = (btn) => {
+ let getPrintSql = (btn, component) => {
let item = {setting: {}, columns: btn.verify.columns || [], search: [], useMSearch: 'false'}
item.setting.interType = 'system'
@@ -5109,18 +5449,121 @@
item.setting.queryType = btn.verify.setting.queryType
item.setting.laypage = 'false'
item.setting.order = btn.verify.setting.order || ''
+ item.setting.$name = btn.logLabel || ''
+ item.setting.transact = 'true'
+ item.setting.$fixOrder = true
item.scripts = btn.verify.scripts || []
- let msg = getDataSource(item, [])
+ let msg = getDataSource(item, [], 'print')
+
+ msg.LText = msg.LText.replace(/@mk_obj_name@/ig, 'data')
+ msg.reps = msg.reps.filter(n => n !== 'mk_obj_name')
+
+ let formkeys = []
+ let colreps = []
+ let _declares = []
+ let _init = []
+ if (btn.execMode === 'pop' && btn.modal && btn.modal.fields) {
+ btn.modal.fields.forEach(item => {
+ if (!item.field) return
+ let _key = item.field.toLowerCase()
+
+ if (!new RegExp('@' + _key + '[^0-9a-z_]', 'ig').test(msg.LText)) return
+
+ formkeys.push(_key)
+ colreps.push(item.field)
+
+ let _item = {
+ key: item.field,
+ fieldlen: item.fieldlength || 50,
+ writein: item.writein !== 'false',
+ type: item.type,
+ isconst: item.constant === 'true'
+ }
+
+ if (_item.type === 'datemonth') {
+ _item.type = 'text'
+ } else if (_item.type === 'number' || _item.type === 'rate') {
+ _item.fieldlen = item.decimal || 0
+ } else if (_item.type === 'date') {
+ _item.type = item.declareType === 'nvarchar(50)' ? 'text' : 'date'
+ } else if (_item.type === 'datetime') {
+ _item.type = 'date'
+ } else if (item.declare === 'decimal') {
+ _item.type = 'number'
+ _item.fieldlen = item.decimal || 0
+ }
+
+ if (_item.type === 'number' || _item.type === 'rate') {
+ _init.push(`@${_key}=@mk_${_key}_mk@`)
+ } else if (_item.type === 'date') {
+ _init.push(`@${_key}='@mk_${_key}_mk@'`)
+ } else if (_item.type === 'select' || _item.type === 'link' || _item.type === 'radio') {
+ _init.push(`@${_key}='@mk_${_key}_mk@'`)
+ } else if (_item.isconst) {
+ _init.push(`@${_key}=N'@mk_${_key}_mk@'`)
+ } else {
+ _init.push(`@${_key}='@mk_${_key}_mk@'`)
+ }
+
+ if (_item.fieldlen && _item.fieldlen > 4000) {
+ _item.fieldlen = 'max'
+ }
+
+ let _type = `nvarchar(${_item.fieldlen})`
+
+ if (_item.type.match(/date/ig)) {
+ _type = 'datetime'
+ } else if (_item.type === 'number') {
+ _type = `decimal(18,${_item.fieldlen})`
+ } else if (_item.type === 'rate') {
+ _type = `decimal(18,2)`
+ }
+
+ _declares.push(`@${_key} ${_type}`)
+ })
+ }
+
+ // 娣诲姞鏁版嵁涓瓧娈碉紝琛ㄥ崟鍊间紭鍏�(鎸夐挳涓嶉�夎鎴栧琛屾嫾鎺ユ椂璺宠繃)
+ if (btn.Ot !== 'notRequired' && component.columns.length > 0) {
+ component.columns.forEach(col => {
+ let _key = col.field.toLowerCase()
+
+ if (formkeys.includes(_key) || !new RegExp('@' + _key + '[^0-9a-z_]', 'ig').test(msg.LText)) return
+ if (_key === 'id' && !/@id[^0-9a-z_@]/ig.test(msg.LText)) return
+
+ colreps.push(col.field)
+
+ if (col.type === 'number') {
+ _init.push(`@${_key}=@mk_${_key}_mk@`)
+ } else {
+ _init.push(`@${_key}='@mk_${_key}_mk@'`)
+ }
+
+ _declares.push(`@${_key} ${col.datatype || 'nvarchar(50)'}`)
+ })
+ }
+
+ _declares = _declares.length ? ',' + _declares.join(',') : ''
+ _init = _init.length ? ',' + _init.join(',') : ''
+
+ msg.LText = msg.LText.replace('@mk_print_declare@', _declares)
+ msg.LText = msg.LText.replace('@mk_print_select@', _init)
+
+ msg.reps = [...msg.reps, ...colreps]
return msg
}
let getPaySql = (btn, component) => {
- let _sql = `Declare @ErrorCode nvarchar(50),@retmsg nvarchar(4000),@tbid nvarchar(50)@mk_init_declare@
- Select @ErrorCode='',@retmsg=''@mk_init_select@
- `
+ let _sql = `/* ${btn.logLabel} */
+ BEGIN TRY
+ begin TRAN
+
+ Declare @ErrorCode nvarchar(50),@retmsg nvarchar(4000),@tbid nvarchar(50)@mk_init_declare@
+ Select @ErrorCode='S',@retmsg=''@mk_init_select@
+ `
btn.verify.scripts.forEach(item => {
if (item.status === 'false') return
@@ -5132,10 +5575,12 @@
if (btn.output) {
_sql += `
- aaa: select @ErrorCode as ErrorCode,@retmsg as retmsg,${btn.output} as mk_b_id`
+ select @ErrorCode as ErrorCode,@retmsg as retmsg,${btn.output} as mk_b_id
+ ${callback}`
} else {
_sql += `
- aaa: select @ErrorCode as ErrorCode,@retmsg as retmsg`
+ select @ErrorCode as ErrorCode,@retmsg as retmsg
+ ${callback}`
}
let reps = []
@@ -5157,7 +5602,7 @@
}
})
- let regs = ['ID', 'time_id', 'datam', 'LoginUID', 'SessionUid', 'UserID', 'Appkey', 'lang', 'typename']
+ let regs = ['ID', 'time_id', 'datam', 'typename']
regs.forEach(s => {
if (new RegExp('@' + s + '@', 'ig').test(_sql)) {
@@ -5192,13 +5637,21 @@
_sql = _sql.replace(/@mk_init_declare@/ig, decSql)
_sql = _sql.replace(/@mk_init_select@/ig, secSql)
+ let map = new Map()
+ reps.push(...sysVars)
+ reps = reps.filter(n => {
+ if (map.has(n.toLowerCase())) {
+ return false
+ }
+
+ map.set(n.toLowerCase(), true)
+
+ return true
+ })
+
reps.forEach(n => {
_sql = _sql.replace(new RegExp('@' + n + '@', 'ig'), `'@${n}@'`)
})
-
- reps = [...reps, ...colreps]
-
- _sql = _sql.replace(/\n\s{6,8}/g, '\n')
if (/\$@/ig.test(_sql)) {
_sql = _sql.replace(/\$@/ig, '@datam_begin@').replace(/@\$/ig, '@datam_end@')
@@ -5208,10 +5661,22 @@
reps.push('db')
}
- return {LText: _sql, reps}
+ _sql = _sql.replace(/\n\x20{6,8}/g, '\n').replace(/\n{3,}/g, '\n\n').replace(/^\s+|\s+$/g, '').replace(/\t+|\v+/g, '')
+
+ reps = reps.filter(n => {
+ if (sysVars.includes(n.toLowerCase())) {
+ return false
+ }
+
+ return true
+ })
+
+ reps = [...reps, ...colreps]
+
+ return {LText: _sql, md5: md5(_sql), reps}
}
- let getFormSql = (item) => {
+ let getFormSql = (item, tname) => {
let arrfield = [item.valueField, item.valueText]
if (item.type === 'checkcard') {
@@ -5275,20 +5740,27 @@
decSql = decSql.join(',')
secSql = secSql.join(',')
+ decSql = decSql ? `Declare ${decSql} select ${secSql}` : ''
- if (decSql) {
- sql = `Declare ${decSql} select ${secSql}
- ${sql}
- `
- }
+ sql = `/* ${item.label}锛�${tname}锛� */
+ SELECT obj_name='${item.field}',prm_field='',str_field='',
+ arr_field='${arrfield}',tabid='',parid='',sub_name='',sub_field=''
- let regs = ['ID', 'BID', 'datam', 'LoginUID', 'SessionUid', 'UserID', 'Appkey', 'lang']
+ ${decSql}
+ ${sql}
+
+ select 'S' as ErrorCode,'' as retmsg
+ `
+
+ let regs = ['ID', 'BID', 'datam']
regs.forEach(s => {
if (new RegExp('@' + s + '@', 'ig').test(sql)) {
reps.push(s)
}
})
+
+ reps.push(...sysVars)
reps.forEach(n => {
sql = sql.replace(new RegExp('@' + n + '@', 'ig'), `'@${n}@'`)
@@ -5302,7 +5774,19 @@
reps.push('db')
}
- return {LText: sql, reps}
+ // reps.push('mk_obj_name')
+
+ sql = sql.replace(/\n\x20{6,8}/g, '\n').replace(/\n{3,}/g, '\n\n').replace(/^\s+|\s+$/g, '').replace(/\t+|\v+/g, '')
+
+ reps = reps.filter(n => {
+ if (sysVars.includes(n.toLowerCase())) {
+ return false
+ }
+
+ return true
+ })
+
+ return {LText: sql, md5: md5(sql), reps}
}
let getPopSelectSql = (item) => {
@@ -5321,19 +5805,19 @@
item.dataSource = '(' + item.dataSource + ') tb'
}
- let sql = ''
+ let LText = ''
let DateCount = ''
let _search = ''
let reps = []
let sFields = []
if (item.searchKey) {
- _search = '@search@'
+ _search = '@mk_search@'
sFields = item.searchKey.split(',')
}
// 涓嶉渶瑕佸崟寮曞彿锛歰rderBy銆乸ageSize銆乸ageIndex銆乨b
- let regs = [...sFields, 'orderBy', 'pageSize', 'pageIndex', 'ID', 'BID', 'time_id', 'LoginUID', 'SessionUid', 'UserID', 'Appkey', 'lang', 'datam']
+ let regs = [...sFields, 'orderBy', 'pageSize', 'pageIndex', 'ID', 'BID', 'time_id', 'datam']
regs.forEach(s => {
if (new RegExp('@' + s + '@', 'ig').test(item.dataSource)) {
@@ -5341,22 +5825,12 @@
}
})
- if (item.laypage === 'true') {
- sql = `/*system_query*/select top @pageSize@ ${arrfield} from (select ${arrfield} ,ROW_NUMBER() over(order by @orderBy@) as rows from ${item.dataSource} ${_search}) tmptable where rows > @pageSize@ * (@pageIndex@ - 1) order by tmptable.rows `
- DateCount = `/*system_query*/select count(1) as total from ${item.dataSource} ${_search}`
-
- reps.push('pageSize', 'orderBy', 'pageIndex')
- } else {
- sql = `/*system_query*/select ${arrfield} from ${item.dataSource} ${_search} order by @orderBy@ `
- reps.push('orderBy')
- }
-
let decSql = []
let secSql = []
let syses = ['mk_departmentcode', 'mk_organization', 'mk_user_type']
syses.forEach(s => {
- if (new RegExp('@' + s + '[^0-9a-z_]', 'ig').test(sql)) {
+ if (new RegExp('@' + s + '[^0-9a-z_]', 'ig').test(item.dataSource)) {
if (['mk_departmentcode', 'mk_organization'].includes(s)) {
decSql.push(`@${s} nvarchar(512)`)
} else {
@@ -5369,29 +5843,74 @@
decSql = decSql.join(',')
secSql = secSql.join(',')
+ decSql = decSql ? `Declare ${decSql} select ${secSql}` : ''
- if (decSql) {
- sql = `Declare ${decSql} select ${secSql}
- ${sql}
+ if (item.laypage === 'true') {
+ /*system_query*/
+ LText = `select top @pageSize@ ${arrfield} from (select ${arrfield} ,ROW_NUMBER() over(order by @orderBy@) as rows from ${item.dataSource} ${_search}) tmptable where rows > @pageSize@ * (@pageIndex@ - 1) order by tmptable.rows `
+ DateCount = `select count(1) as total from ${item.dataSource} ${_search}`
+
+ reps.push('pageSize', 'orderBy', 'pageIndex')
+ } else {
+ LText = `select ${arrfield} from ${item.dataSource} ${_search} order by @orderBy@ `
+ reps.push('orderBy')
+ }
+
+ let sql = `SELECT obj_name='data',prm_field='',str_field='',
+ arr_field='${arrfield}',tabid='',parid='',sub_name='',sub_field=''
+ `
+
+ if (DateCount) {
+ sql += `UNION ALL
+ SELECT obj_name='DateCount',prm_field='total',str_field='',
+ arr_field='',tabid='',parid='',sub_name='',sub_field=''
`
}
+
+ sql += `
+ ${decSql}
+ ${LText}
+ ${DateCount}
+
+ select 'S' as ErrorCode,'' as retmsg
+ `
+
+ let map = new Map()
+ reps.push(...sysVars)
+ reps = reps.filter(n => {
+ if (map.has(n.toLowerCase())) {
+ return false
+ }
+
+ map.set(n.toLowerCase(), true)
+
+ return true
+ })
reps.forEach(n => {
if (['orderBy', 'pageSize', 'pageIndex'].includes(n)) return
sql = sql.replace(new RegExp('@' + n + '@', 'ig'), `'@${n}@'`)
- DateCount = DateCount.replace(new RegExp('@' + n + '@', 'ig'), `'@${n}@'`)
})
if (/\$@/ig.test(sql)) {
sql = sql.replace(/\$@/ig, '@datam_begin@').replace(/@\$/ig, '@datam_end@')
- DateCount = DateCount.replace(/\$@/ig, '@datam_begin@').replace(/@\$/ig, '@datam_end@')
reps.push('datam_begin', 'datam_end')
}
if (/@db@/ig.test(sql)) {
reps.push('db')
}
-
- return {LText: sql, DateCount, reps}
+
+ sql = sql.replace(/\n\x20{6,8}/g, '\n').replace(/\n{3,}/g, '\n\n').replace(/^\s+|\s+$/g, '').replace(/\t+|\v+/g, '')
+
+ reps = reps.filter(n => {
+ if (sysVars.includes(n.toLowerCase())) {
+ return false
+ }
+
+ return true
+ })
+
+ return {LText: sql, md5: md5(sql), reps}
}
let _mainSearch = []
@@ -5432,7 +5951,7 @@
if (search.length > 0) {
search.forEach(cell => {
if (['select', 'link', 'multiselect', 'checkcard', 'radio'].includes(cell.type) && cell.resourceType === '1' && cell.dataSource) {
- let msg = getFormSql(cell)
+ let msg = getFormSql(cell, '鎼滅储')
sqls.push({uuid: cell.uuid, type: 'sForm', ...msg})
}
@@ -5457,6 +5976,7 @@
m.setting.laypage = 'false'
m.setting.$top = true
+ m.setting.$name = (config.MenuName || '') + '-' + (m.name || '')
let msg = getDataSource(m, _mainSearch)
--
Gitblit v1.8.0