From 3140b58a56be4b1693766121dacb83fe6f6f21df Mon Sep 17 00:00:00 2001 From: king <18310653075@163.com> Date: 星期二, 26 九月 2023 14:48:30 +0800 Subject: [PATCH] 2023-09-26 --- src/utils/utils.js | 1310 ++++++++++++++++++++++------------------------------------- 1 files changed, 494 insertions(+), 816 deletions(-) diff --git a/src/utils/utils.js b/src/utils/utils.js index af68c88..f7bd5ee 100644 --- a/src/utils/utils.js +++ b/src/utils/utils.js @@ -1,6 +1,5 @@ import moment from 'moment' import md5 from 'md5' -import options from '@/store/options.js' const formatKeys = [ { key: 'select', value: ' msltk ' }, @@ -34,30 +33,11 @@ { key: 'TRAN', value: ' mtrnk ' }, { key: 'goto', value: ' mgtk ' }, { key: 'set', value: ' mstk ' }, - { key: 'ROLLBACK', value: ' mrlbkk ' } + { key: 'ROLLBACK', value: ' mrlbkk ' }, + { key: 'drop', value: ' mdrpk ' }, ] export default class Utils { - /** - * @description 鑾峰彇浼氬憳绛夌骇 - * @return {String} level - */ - static getMemberLevel () { - let _level = 10 - let _Mlevel = sessionStorage.getItem('Member_Level') - - if (_Mlevel) { - if (_Mlevel === md5('mksoft' + window.GLOB.appkey + new Date().getFullYear() + new Date().getMonth() + 10)) { - _level = 10 - } else if (_Mlevel === md5('mksoft' + window.GLOB.appkey + new Date().getFullYear() + new Date().getMonth() + 20)) { - _level = 20 - } else if (_Mlevel === md5('mksoft' + window.GLOB.appkey + new Date().getFullYear() + new Date().getMonth() + 30)) { - _level = 30 - } - } - return _level - } - /** * @description 鑾峰彇鍥捐〃楂樺害 */ @@ -75,20 +55,6 @@ } return parseInt(val || 400) - 30 - } - - /** - * @description 鏁版嵁婧愬悕绉帮紝鐢ㄤ簬缁熶竴鏌ヨ - * @return {String} name - */ - static getdataName () { - let name = [] - let _options = 'abcdefghigklmnopqrstuvwxyz' - for (let i = 0; i < 6; i++) { - name.push(_options.substr(Math.floor(Math.random() * 26), 1)) - } - name.splice(3, 0, new Date().getTime()) - return name.join('') } /** @@ -156,23 +122,23 @@ static verifySql (sql, type) { if (!sql) return '' let chars = [ - {key: 'create', reg: /(^|\s)create\s/ig}, - {key: 'insert', reg: /(^|\s)insert\s/ig}, - {key: 'delete', reg: /(^|\s)delete\s/ig}, - {key: 'update', reg: /(^|\s)update\s/ig}, - {key: 'set', reg: /(^|\s)set\s/ig}, - {key: 'drop', reg: /(^|\s)drop\s/ig}, - {key: 'alter', reg: /(^|\s)alter\s/ig}, - {key: 'truncate', reg: /(^|\s)truncate\s/ig}, - {key: 'if', reg: /(^|\s)if\s/ig}, - {key: 'exec', reg: /(^|\s)exec(\s|\()/ig}, - {key: 'OBJECT', reg: /(^|\s)object(\s|\()/ig}, - {key: 'sys.', reg: /(^|\s)sys\./ig}, - {key: 'kill', reg: /(^|\s)kill\s/ig} + {key: 'create', reg: /(^|\s|\(|\))create\s/ig}, + {key: 'insert', reg: /(^|\s|\(|\))insert\s/ig}, + {key: 'delete', reg: /(^|\s|\(|\))delete\s/ig}, + {key: 'update', reg: /(^|\s|\(|\))update\s/ig}, + {key: 'set', reg: /(^|\s|\(|\))set\s/ig}, + {key: 'drop', reg: /(^|\s|\(|\))drop\s/ig}, + {key: 'alter', reg: /(^|\s|\(|\))alter\s/ig}, + {key: 'truncate', reg: /(^|\s|\(|\))truncate\s/ig}, + {key: 'if', reg: /(^|\s|\(|\))if\s/ig}, + {key: 'exec', reg: /(^|\s|\(|\))exec(\s|\()/ig}, + {key: 'OBJECT', reg: /(^|\s|\(|\))object(\s|\()/ig}, + {key: 'sys.', reg: /(^|\s|\(|\))sys\./ig}, + {key: 'kill', reg: /(^|\s|\(|\))kill\s/ig} ] if (type === 'customscript') { - chars = chars.filter(char => !['insert', 'delete', 'update', 'set', 'if', 'exec'].includes(char.key)) + chars = chars.filter(char => !['create', 'insert', 'delete', 'update', 'set', 'drop', 'if', 'exec'].includes(char.key)) } let error = '' @@ -219,6 +185,29 @@ return value } + + // /** + // * @description sql瑙e瘑 + // * @return {String} value + // */ + // static unFormatOptions (value) { + // if (!value) return '' + + // value = window.atob(value) + // value = value.replace('minKe', '') + // value = window.decodeURIComponent(window.atob(value)) + // value = value.replace(/ mpercent /ig, '%') + + // // 鏇挎崲鍏抽敭瀛� + // formatKeys.forEach(item => { + // let reg = new RegExp('(\\s)?' + item.value.replace(/\s/g, '') + '(\\s)?', 'ig') + // value = value.replace(reg, ' ' + item.key + ' ') + // }) + + // value = value.replace(/ \n /ig, '\n') + + // return value + // } /** * @description sPC_TableData_InUpDe sql鍔犲瘑 @@ -277,12 +266,21 @@ * @description 鍒濆鍖栨悳绱㈡潯浠跺垵濮嬪�� * @param {Array} searches 鎼滅储鏉′欢 */ - static initSearchVal (searches) { - if (!searches) return [] + static initSearchVal (config) { + if (!config.search) { + config.search = [] + return + } let roleId = sessionStorage.getItem('role_id') || '' + let required = false + let keys = [] + let values = null + if (config.wrap && config.wrap.cacheSearch === 'true') { + values = window.GLOB.SearchBox.get(config.$searchId + 'cache') + } - return searches.map(item => { + config.search = config.search.map(item => { item.hidden = item.Hide === 'true' item.required = !item.hidden && item.required === 'true' item.advanced = item.advanced === 'true' @@ -321,6 +319,8 @@ item.initval = [moment().startOf('week').format(format), moment().endOf('week').format(format)].join(',') } else if (item.initval === 'month') { item.initval = [moment().startOf('month').format(format), moment().endOf('month').format(format)].join(',') + } else if (item.initval === 'lastMonth') { + item.initval = [moment().subtract(1, 'months').startOf('month').format(format), moment().subtract(1, 'months').endOf('month').format(format)].join(',') } else if (item.initval) { try { let _initval = JSON.parse(item.initval) @@ -391,6 +391,10 @@ item.oriInitval = item.initval + if (values) { + item.initval = values[item.field] || '' + } + if (item.blacklist && item.blacklist.length > 0 && !item.hidden) { if (item.blacklist.filter(v => roleId.indexOf(v) > -1).length > 0) { item.hidden = true @@ -398,8 +402,32 @@ } } + if (item.required) { + required = true + } + + if (item.type === 'text' || item.type === 'select') { + if (/@username@|@fullName@/ig.test(item.initval)) { + item.initval = item.initval.replace(/@username@/ig, sessionStorage.getItem('User_Name') || '').replace(/@fullName@/ig, sessionStorage.getItem('Full_Name') || '') + item.oriInitval = item.initval + } + if (/,/.test(item.field)) { + item.field.split(',').forEach(field => { + keys.push(field.toLowerCase()) + }) + } else { + keys.push(item.field.toLowerCase()) + } + } else if (item.type === 'group') { + keys.push(item.field.toLowerCase()) + keys.push(item.datefield.toLowerCase()) + } + return item }) + + config.$s_keys = keys + config.$s_req = required } /** @@ -522,8 +550,16 @@ } } - newsearches[item.key] = _startval - newsearches[item.key + '1'] = _endval + let _skey = item.key + let _ekey = item.key + '1' + + if (/,/.test(item.key)) { + _skey = item.key.split(',')[0] + _ekey = item.key.split(',')[1] + } + + newsearches[_skey] = _startval + newsearches[_ekey] = _endval } else if (item.type === 'text' || item.type === 'select') { item.key.split(',').forEach(field => { // 缁煎悎鎼滅储锛屾墍瀛楁鎷兼帴 newsearches[field] = item.value @@ -614,7 +650,15 @@ _endval = val[1] + '.000' } - searchText.push('(' + item.key + ' >= \'' + _startval + '\' AND ' + item.key + ' < \'' + _endval + '\')') + let _skey = item.key + let _ekey = item.key + + if (/,/.test(item.key)) { + _skey = item.key.split(',')[0] + _ekey = item.key.split(',')[1] + } + + searchText.push('(' + _skey + ' >= \'' + _startval + '\' AND ' + _ekey + ' < \'' + _endval + '\')') } else if (item.type === 'range') { let val = item.value.split(',') @@ -762,8 +806,8 @@ let baseurl = '' - if (options.cloudServiceApi) { - baseurl = options.cloudServiceApi.replace(/webapi(.*)$/, '') + if (window.GLOB.cloudServiceApi) { + baseurl = window.GLOB.cloudServiceApi.replace(/webapi(.*)$/, '') } else { baseurl = window.GLOB.baseurl } @@ -783,6 +827,10 @@ arrfield.push(item.cardValField) if (item.urlField) { arrfield.push(item.urlField) + } else if (item.colorField) { + arrfield.push(item.colorField) + } else if (item.parentField) { + arrfield.push(item.parentField) } } @@ -790,6 +838,8 @@ arrfield.push(item.linkField) } if (['select', 'radio', 'link', 'checkcard'].includes(item.type) && item.linkSubField && item.linkSubField.length > 0) { + arrfield.push(...item.linkSubField) + } else if (item.type === 'text' && item.editType === 'select' && item.linkSubField && item.linkSubField.length > 0) { // 鍙紪杈戣〃 arrfield.push(...item.linkSubField) } if (item.disableField) { @@ -814,10 +864,9 @@ } if (sessionStorage.getItem('dataM') === 'true') { // 鏁版嵁鏉冮檺 - sql = sql.replace(/\$@/ig, '/*') - sql = sql.replace(/@\$/ig, '*/') + sql = sql.replace(/\$@/ig, '/*').replace(/@\$/ig, '*/').replace(/@datam@/ig, '\'Y\'') } else { - sql = sql.replace(/@\$|\$@/ig, '') + sql = sql.replace(/@\$|\$@/ig, '').replace(/@datam@/ig, '\'\'') } // 澶栬仈鏁版嵁搴撴浛鎹� @@ -825,7 +874,9 @@ sql = sql.replace(/@db@/ig, window.GLOB.externalDatabase) } + sql = sql.replace(/@LoginUID@/ig, `'${sessionStorage.getItem('LoginUID') || ''}'`) sql = sql.replace(/@SessionUid@/ig, `'${localStorage.getItem('SessionUid') || ''}'`) + sql = sql.replace(/@UserID@/ig, `'${sessionStorage.getItem('UserID') || ''}'`) sql = sql.replace(/@Appkey@/ig, `'${window.GLOB.appkey || ''}'`) return { @@ -839,10 +890,9 @@ * @description 鑾峰彇excel瀵煎叆鍙傛暟 * @return {Object} item 鎸夐挳淇℃伅 * @return {Array} data excel鏁版嵁 - * @return {Object} dict 瀛楀吀椤� * @return {String} BID 涓婄骇Id */ -export function getExcelInSql (item, data, dict, BID) { +export function getExcelInSql (item, data, BID, primaryId) { let btn = item.verify let keys = ['delete', 'drop', 'insert', 'truncate', 'update'] let userName = sessionStorage.getItem('User_Name') || '' @@ -857,11 +907,6 @@ let district = sessionStorage.getItem('district') || '' let address = sessionStorage.getItem('address') || '' let _sheet = item.sheet - - if (sessionStorage.getItem('isEditState') === 'true') { - userName = sessionStorage.getItem('CloudUserName') || '' - fullName = sessionStorage.getItem('CloudFullName') || '' - } if (window.GLOB.externalDatabase !== null) { _sheet = _sheet.replace(/@db@/ig, window.GLOB.externalDatabase) @@ -887,35 +932,6 @@ let _topline = btn.range || 0 let upId = getuuid() - let _initCustomScript = '' // 鍒濆鍖栬剼鏈� - let _prevCustomScript = '' // 榛樿sql鍓嶆墽琛岃剼鏈� - let _backCustomScript = '' // 榛樿sql鍚庢墽琛岃剼鏈� - - if (btn.scripts) { - btn.scripts.forEach(script => { - if (script.status === 'false') return - - if (script.position === 'init') { - _initCustomScript += ` - /* 鑷畾涔夎剼鏈� */ - ${script.sql} - ` - } else if (script.position === 'front') { - _prevCustomScript += ` - /* 鑷畾涔夎剼鏈� */ - ${script.sql} - ` - } else { - _backCustomScript += ` - /* 鑷畾涔夎剼鏈� */ - ${script.sql} - ` - } - }) - } - - // 鎺у埗鍙版墦鍗版暟鎹� - let conLtext = [] let cols = ['A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M', 'N', 'O', 'P', 'Q', 'R', 'S', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z'] for (let i = 0; i < 26; i++) { cols.push('A' + cols[i]) @@ -923,93 +939,84 @@ let _Ltext = data.map((item, lindex) => { let vals = [] - let convals = [] btn.columns.forEach((col, cindex) => { if (col.import === 'false') return let val = item[col.Column] !== undefined ? item[col.Column] : '' let _colindex = cols[cindex] || (cindex + 1) - let _position = (_topline + lindex + 1) + dict['main.excel.line'] + ' ' + _colindex + dict['main.excel.column'] + ' ' + let _position = (_topline + lindex + 1) + '琛� ' + _colindex + '鍒� ' - if (/^Nvarchar/ig.test(col.type)) { - if (typeof(val) === 'number') { - val = val.toString() + if (col.import === 'init') { + if (/^Nvarchar/ig.test(col.type)) { + val = '' + } else if (/^Decimal/ig.test(col.type) || /^int/ig.test(col.type)) { + val = 0 + } else if (col.type === 'date') { + val = '1949-10-01' + } else if (col.type === 'datetime') { + val = '1949-10-01 00:00:00' + } + } else if (/^Nvarchar/ig.test(col.type)) { + val = val + '' + + if (/'/.test(val)) { + val = val.replace(/'/ig, '"') } - val = val.replace(/(^\s*$)|\t*|\v*|'*/ig, '') + val = val.replace(/(^\s+$)|\t+|\v+/ig, '') if (!val && col.required === 'true') { // 蹇呭~鏍¢獙 - errors.push(_position + dict['main.excel.content.emptyerror']) + errors.push(_position + '鍐呭涓嶅彲涓虹┖') } else if (col.limit && val.length > col.limit) { // 闀垮害鏍¢獙 - errors.push(_position + dict['main.excel.content.maxlimit']) + errors.push(_position + '鍐呭瓒呴暱') } else { // 鍏抽敭瀛楁牎楠� keys.forEach(key => { let _patten = new RegExp('(^' + key + '\\s+)|(\\s+' + key + '\\s+)', 'ig') if (_patten.test(val)) { - errors.push(_position + dict['main.excel.includekey'] + key) + errors.push(_position + '鍚湁鍏抽敭瀛�' + key) } }) } - } else if (/^int/ig.test(col.type)) { + } else if (/^Decimal/ig.test(col.type) || /^int/ig.test(col.type)) { if (!val && val !== 0) { - errors.push(_position + dict['main.excel.content.emptyerror']) - } else { - let _val = val + '' - - if (!/^(([^0][0-9]+|0)$)|^(([1-9]+)$)/.test(_val)) { // 妫�楠屾槸鍚︿负鏁存暟 - errors.push(_position + dict['main.excel.content.interror']) - } else if ((col.min || col.min === 0) && val < col.min) { // 鏈�灏忓�兼楠� - errors.push(_position + dict['main.excel.content.limitmin']) - } else if ((col.max || col.max === 0) && val > col.max) { // 鏈�澶у�兼楠� - errors.push(_position + dict['main.excel.content.limitmax']) - } + errors.push(_position + '鍐呭涓嶅彲涓虹┖') + } else if (isNaN(val)) { // 妫�楠屾槸鍚︿负鏁板�� + errors.push(_position + '鍐呭搴斾负鏁板��') + } else if ((col.min || col.min === 0) && val < col.min) { // 鏈�灏忓�兼楠� + errors.push(_position + '灏忎簬鏈�灏忓��') + } else if ((col.max || col.max === 0) && val > col.max) { // 鏈�澶у�兼楠� + errors.push(_position + '澶т簬鏈�澶у��') } - } else if (/^Decimal/ig.test(col.type)) { - if (!val && val !== 0) { - errors.push(_position + dict['main.excel.content.emptyerror']) - } else { - let _val = val + '' - let _vals = _val.split('.') - - if (!/^(([^0][0-9]+|0)\.([0-9]+)$)|^(([^0][0-9]+|0)$)|^(([1-9]+)\.([0-9]+)$)|^(([1-9]+)$)/.test(_val)) { // 妫�楠屾槸鍚︿负娴偣鏁� - errors.push(_position + dict['main.excel.content.floaterror']) - } else if (_vals[0].length > 18) { // 妫�楠屾暣鏁颁綅 - errors.push(_position + dict['main.excel.content.floatIntover']) - } else if (_vals[1] && _vals[1].length > col.limit) { // 鏈�灏忓�兼楠� - errors.push(_position + dict['main.excel.content.floatPointover']) - } else if ((col.min || col.min === 0) && val < col.min) { // 鏈�灏忓�兼楠� - errors.push(_position + dict['main.excel.content.limitmin']) - } else if ((col.max || col.max === 0) && val > col.max) { // 鏈�澶у�兼楠� - errors.push(_position + dict['main.excel.content.limitmax']) - } - } - } else if (col.type === 'date') { + } else if (col.type === 'date' || col.type === 'datetime') { if (typeof(val) === 'number') { if (val > 2958465 || val <= 0) { // 鏃堕棿杩囧ぇ鎴栧皬浜庣瓑浜�0 - errors.push(_position + dict['main.excel.content.date.over']) + errors.push(_position + '鏃堕棿涓鸿礋鍊兼垨澶ぇ') } else { // 鏃堕棿鏍煎紡鍖� if (val < 60) { // 1900-2-29锛宔xcel涓瓨鍦紝瀹為檯涓嶅瓨鍦� val++ } - val = moment('19000101', 'YYYYMMDD').add(Math.floor(val - 2), 'days').format('YYYY-MM-DD') + if (col.type === 'datetime') { + val = val - 2 + let day = Math.floor(val) + let seconds = Math.round((val - day) * 24 * 60 * 60) + val = moment('19000101', 'YYYYMMDD').add(day, 'days').add(seconds, 'seconds').format('YYYY-MM-DD HH:mm:ss') + } else { + val = moment('19000101', 'YYYYMMDD').add(Math.floor(val - 2), 'days').format('YYYY-MM-DD') + } } } else if (typeof(val) === 'string') { - val = val.replace(/(^\s*$)|\t*|\v*/ig, '') + val = val.replace(/(^\s+$)|\t+|\v+/ig, '') if (!val && col.required === 'true') { // 鏃堕棿蹇呭~鏍¢獙 - errors.push(_position + dict['main.excel.content.emptyerror']) + errors.push(_position + '鍐呭涓嶅彲涓虹┖') } else if (val && !/^[1-9][0-9]{3}/.test(val)) { // 鏃堕棿姝e垯鏍¢獙 - errors.push(_position + dict['main.excel.content.date.formatError']) + errors.push(_position + '鏃堕棿鏍煎紡閿欒') } } else { // 鏃堕棿鏍煎紡閿欒 - errors.push(_position + dict['main.excel.content.date.formatError']) + errors.push(_position + '鏃堕棿鏍煎紡閿欒') } } vals.push(`'${val}'`) - - if (lindex < 40) { - convals.push(`'${val}' as ${col.Column}`) - } }) let _lineIndex = '0000' + (lindex + 1) + '0' @@ -1017,44 +1024,83 @@ vals.push(`'${upId + _lineIndex}'`) vals.push(`'${BID}'`) - - if (lindex < 40) { - convals.push(`'${upId + _lineIndex}' as jskey`) - convals.push(`'${BID}' as BID`) - conLtext.push(`Select ${convals.join(',')}`) - } return `Select ${vals.join(',')}` }) let result = [] - for(let i = 0; i < _Ltext.length; i += 20) { - result.push(_Ltext.slice(i, i + 20)) - } - - let _sql = '' - let _sqlInsert = '' - let _sqlBottom = '' - + let sql = '' + if (item.intertype === 'system') { + let _initCustomScript = '' // 鍒濆鍖栬剼鏈� + let _prevCustomScript = '' // 榛樿sql鍓嶆墽琛岃剼鏈� + let _backCustomScript = '' // 榛樿sql鍚庢墽琛岃剼鏈� + let isDM = sessionStorage.getItem('dataM') === 'true' + let regs = [ + {reg: new RegExp('(^|\\s)@' + sheet + '(\\s|$)', 'ig'), value: ` #${sheet} `}, + {reg: new RegExp('(^|\\s)@' + sheet + '\\(', 'ig'), value: ` #${sheet}(`}, + {reg: new RegExp('(^|\\s)@' + sheet + '\\)', 'ig'), value: ` #${sheet})`}, + {reg: /@ID@/ig, value: `'${primaryId || ''}'`}, + {reg: /@BID@/ig, value: `'${BID}'`}, + {reg: /@LoginUID@/ig, value: `'${sessionStorage.getItem('LoginUID') || ''}'`}, + {reg: /@SessionUid@/ig, value: `'${localStorage.getItem('SessionUid') || ''}'`}, + {reg: /@UserID@/ig, value: `'${sessionStorage.getItem('UserID') || ''}'`}, + {reg: /@Appkey@/ig, value: `'${window.GLOB.appkey || ''}'`}, + {reg: /@typename@/ig, value: `'admin'`}, + {reg: /\$@/ig, value: isDM ? '/*' : ''}, + {reg: /@\$/ig, value: isDM ? '*/' : ''}, + {reg: /@datam@/ig, value: isDM ? `'Y'` : `''`}, + ] + + if (window.GLOB.externalDatabase !== null) { + regs.push({reg: /@db@/ig, value: window.GLOB.externalDatabase}) + } + + btn.scripts && btn.scripts.forEach(script => { + if (script.status === 'false') return + + let _sql = script.sql + + regs.forEach(item => { + _sql = _sql.replace(item.reg, item.value) + }) + + if (script.position === 'init') { + _initCustomScript += ` + /* 鑷畾涔夎剼鏈� */ + ${_sql} + ` + } else if (script.position === 'front') { + _prevCustomScript += ` + /* 鑷畾涔夎剼鏈� */ + ${_sql} + ` + } else { + _backCustomScript += ` + /* 鑷畾涔夎剼鏈� */ + ${_sql} + ` + } + }) + let _uniquesql = '' if (btn.uniques && btn.uniques.length > 0) { btn.uniques.forEach(unique => { - if (unique.status === 'false') return + if (unique.status === 'false' || !unique.verifyType) return let _fields = unique.field.split(',') let _fields_ = _fields.map(_field => `a.${_field}=b.${_field}`) let _afields = _fields.map(_field => `a.${_field}`) _fields_ = _fields_.join(' and ') - if (unique.verifyType !== 'physical') { + if (unique.verifyType === 'logic' || unique.verifyType === 'logic_temp') { _fields_ += ' and b.deleted=0' } _uniquesql += ` /* 閲嶅鎬ч獙璇� */ Set @tbid='' - Select top 1 @tbid=${_fields.join('+\' \'+')} from (select 1 as n,${unique.field} from @${sheet} ) a group by ${unique.field} having sum(n)>1 + Select top 1 @tbid=${_fields.join('+\' \'+')} from (select 1 as n,${unique.field} from #${sheet} ) a group by ${unique.field} having sum(n)>1 If @tbid!='' Begin @@ -1062,14 +1108,14 @@ goto aaa end - Set @tbid='' - Select top 1 @tbid=${_afields.join('+\' \'+')} from @${sheet} a Inner join ${sheet} b on ${_fields_} + ${unique.verifyType.indexOf('temp') === -1 ? `Set @tbid='' + Select top 1 @tbid=${_afields.join('+\' \'+')} from #${sheet} a Inner join ${sheet} b on ${_fields_} If @tbid!='' Begin select @ErrorCode='${unique.errorCode}',@retmsg=@tbid+' 涓庡凡鏈夋暟鎹噸澶�' goto aaa - end + end` : ''} ` }) } @@ -1095,64 +1141,51 @@ _insert = ` /* 榛樿sql */ Insert into ${database}${sheet} (${fields},createuserid,createuser,createstaff,bid) - Select ${fields},@userid@,@username,@fullname,@BID@ From @${sheet} + Select ${fields},'${sessionStorage.getItem('UserID') || ''}',@username,@fullname,'${BID}' From #${sheet} ` } - _sql = ` + sql = ` /* 绯荤粺鐢熸垚 */ - declare @${sheet} table (${declarefields.join(',')},jskey nvarchar(50),BID nvarchar(50) ) + create table #${sheet} (${declarefields.join(',')},jskey nvarchar(50),BID nvarchar(50) ) Declare @UserName nvarchar(50),@FullName nvarchar(50),@RoleID nvarchar(512),@mk_departmentcode nvarchar(512),@mk_organization nvarchar(512),@mk_user_type nvarchar(20),@mk_nation nvarchar(50),@mk_province nvarchar(50),@mk_city nvarchar(50),@mk_district nvarchar(50),@mk_address nvarchar(100),@ErrorCode nvarchar(50),@retmsg nvarchar(4000),@tbid Nvarchar(512) Select @ErrorCode='', @retmsg='', @UserName='${userName}', @FullName='${fullName}', @RoleID='${RoleID}', @mk_departmentcode='${departmentcode}', @mk_organization='${organization}', @mk_user_type='${mk_user_type}', @mk_nation='${nation}', @mk_province='${province}', @mk_city='${city}', @mk_district='${district}', @mk_address='${address}' ${_initCustomScript} - ` - _sqlInsert = `Insert into @${sheet} (${fields},jskey,BID)` - _sqlBottom = ` - /* 榛樿sql */ - delete tmp_excel_in where upid=@upid@ - delete tmp_excel_in where datediff(day,createdate,getdate())>15 + Insert into #${sheet} (${fields},jskey,BID) + + /* excel鏁版嵁*/ + ${_Ltext.join(' Union all ')} + ${_uniquesql} ${_prevCustomScript} ${_insert} ${_backCustomScript} - Delete @${sheet} + + drop table #${sheet} aaa: select @ErrorCode as ErrorCode,@retmsg as retmsg` - if (window.GLOB.debugger === true || (window.debugger === true && options.sysType !== 'cloud')) { - let fsql = ` - ${_sql} - ${_sqlInsert} - - /* excel鏁版嵁锛堝墠40鏉★級 */ - ${conLtext.join(' Union all ')} - ${_sqlBottom} - ` - fsql = fsql.replace(/\n\s{8}/ig, '\n') - console.info(fsql) + sql = sql.replace(/\n\s{6}/ig, '\n') + + if (window.GLOB.debugger === true) { + console.info(sql) } - } else { // s_sDataDictb_excelIn 浜戠瀵嗛挜楠岃瘉鍙傛暟 - _sql = ` - /* 绯荤粺鐢熸垚 */ - declare @${sheet} table (jskey nvarchar(50)) - Declare @UserName nvarchar(50),@FullName nvarchar(50),@RoleID nvarchar(512),@mk_departmentcode nvarchar(512),@mk_organization nvarchar(512),@mk_user_type nvarchar(20),@mk_nation nvarchar(50),@mk_province nvarchar(50),@mk_city nvarchar(50),@mk_district nvarchar(50),@mk_address nvarchar(100),@ErrorCode nvarchar(50),@retmsg nvarchar(4000),@tbid Nvarchar(512) - - Select @ErrorCode='', @retmsg='', @UserName='${userName}', @FullName='${fullName}', @RoleID='${RoleID}', @mk_departmentcode='${departmentcode}', @mk_organization='${organization}', @mk_user_type='${mk_user_type}', @mk_nation='${nation}', @mk_province='${province}', @mk_city='${city}', @mk_district='${district}', @mk_address='${address}' - ` + } else { + for(let i = 0; i < _Ltext.length; i += 20) { + result.push(_Ltext.slice(i, i + 20)) + } } return { - sql: _sql, + sql: sql, lines: result.map((list, index) => { return { Ltext: window.btoa(window.encodeURIComponent(list.join(' Union all '))), Sort: (index + 1) * 10 } }), - insert: _sqlInsert, - bottom: _sqlBottom, errors: errors.join('; ') } } @@ -1179,11 +1212,6 @@ let _sheet = btn.sheet let BID = data[0].$$BID || '' - if (sessionStorage.getItem('isEditState') === 'true') { - userName = sessionStorage.getItem('CloudUserName') || '' - fullName = sessionStorage.getItem('CloudFullName') || '' - } - if (window.GLOB.externalDatabase !== null) { _sheet = _sheet.replace(/@db@/ig, window.GLOB.externalDatabase) } @@ -1193,44 +1221,12 @@ database = database ? (database[0] || '') : '' - let _initCustomScript = '' // 鍒濆鍖栬剼鏈� - let _prevCustomScript = '' // 榛樿sql鍓嶆墽琛岃剼鏈� - let _backCustomScript = '' // 榛樿sql鍚庢墽琛岃剼鏈� - - if (btn.scripts && btn.intertype === 'system') { - btn.scripts.forEach(script => { - if (script.status === 'false') return - - if (script.position === 'init') { - _initCustomScript += ` - /* 鑷畾涔夎剼鏈� */ - ${script.sql} - ` - } else if (script.position === 'front') { - _prevCustomScript += ` - /* 鑷畾涔夎剼鏈� */ - ${script.sql} - ` - } else { - _backCustomScript += ` - /* 鑷畾涔夎剼鏈� */ - ${script.sql} - ` - } - }) - } - - // 鎺у埗鍙版墦鍗版暟鎹� - let conLtext = [] - let _Ltext = data.map(item => { let vals = [] - let convals = [] columns.forEach(col => { let val = item[col.field] vals.push(`'${val}'`) - convals.push(`'${val}' as ${col.field}`) }) let key = item.$$uuid @@ -1240,42 +1236,81 @@ vals.push(`'${type}'`) vals.push(`'${BID}'`) - convals.push(`'${key}' as jskey`) - convals.push(`'${type}' as data_type`) - convals.push(`'${BID}' as BID`) - conLtext.push(`Select ${convals.join(',')}`) - return `Select ${vals.join(',')}` }) let result = [] - for(let i = 0; i < _Ltext.length; i += 20) { - result.push(_Ltext.slice(i, i + 20)) - } - - let _sql = '' - let _sqlInsert = '' - let _sqlBottom = '' + let sql = '' if (btn.intertype === 'system') { + let _initCustomScript = '' // 鍒濆鍖栬剼鏈� + let _prevCustomScript = '' // 榛樿sql鍓嶆墽琛岃剼鏈� + let _backCustomScript = '' // 榛樿sql鍚庢墽琛岃剼鏈� + let isDM = sessionStorage.getItem('dataM') === 'true' + let regs = [ + {reg: new RegExp('(^|\\s)@' + sheet + '(\\s|$)', 'ig'), value: ` #${sheet} `}, + {reg: new RegExp('(^|\\s)@' + sheet + '\\(', 'ig'), value: ` #${sheet}(`}, + {reg: new RegExp('(^|\\s)@' + sheet + '\\)', 'ig'), value: ` #${sheet})`}, + {reg: /@BID@/ig, value: `'${BID}'`}, + {reg: /@LoginUID@/ig, value: `'${sessionStorage.getItem('LoginUID') || ''}'`}, + {reg: /@SessionUid@/ig, value: `'${localStorage.getItem('SessionUid') || ''}'`}, + {reg: /@UserID@/ig, value: `'${sessionStorage.getItem('UserID') || ''}'`}, + {reg: /@Appkey@/ig, value: `'${window.GLOB.appkey || ''}'`}, + {reg: /@typename@/ig, value: `'admin'`}, + {reg: /\$@/ig, value: isDM ? '/*' : ''}, + {reg: /@\$/ig, value: isDM ? '*/' : ''}, + {reg: /@datam@/ig, value: isDM ? `'Y'` : `''`}, + ] + + if (window.GLOB.externalDatabase !== null) { + regs.push({reg: /@db@/ig, value: window.GLOB.externalDatabase}) + } + + btn.scripts && btn.scripts.forEach(script => { + if (script.status === 'false') return + + let _sql = script.sql + + regs.forEach(item => { + _sql = _sql.replace(item.reg, item.value) + }) + + if (script.position === 'init') { + _initCustomScript += ` + /* 鑷畾涔夎剼鏈� */ + ${_sql} + ` + } else if (script.position === 'front') { + _prevCustomScript += ` + /* 鑷畾涔夎剼鏈� */ + ${_sql} + ` + } else { + _backCustomScript += ` + /* 鑷畾涔夎剼鏈� */ + ${_sql} + ` + } + }) + let _uniquesql = '' if (btn.uniques && btn.uniques.length > 0) { btn.uniques.forEach(unique => { - if (unique.status === 'false') return + if (unique.status === 'false' || !unique.verifyType) return let _fields = unique.field.split(',') let _fields_ = _fields.map(_field => `a.${_field}=b.${_field}`) let _afields = _fields.map(_field => `a.${_field}`) _fields_ = _fields_.join(' and ') - if (unique.verifyType !== 'physical') { + if (unique.verifyType === 'logic' || unique.verifyType === 'logic_temp') { _fields_ += ' and b.deleted=0' } _uniquesql += ` /* 閲嶅鎬ч獙璇� */ Set @tbid='' - Select top 1 @tbid=${_fields.join('+\' \'+')} from (select 1 as n,${unique.field} from @${sheet} ) a group by ${unique.field} having sum(n)>1 + Select top 1 @tbid=${_fields.join('+\' \'+')} from (select 1 as n,${unique.field} from #${sheet} ) a group by ${unique.field} having sum(n)>1 If @tbid!='' Begin @@ -1283,14 +1318,14 @@ goto aaa end - Set @tbid='' - Select top 1 @tbid=${_afields.join('+\' \'+')} from @${sheet} a Inner join ${sheet} b on ${_fields_} + ${unique.verifyType.indexOf('temp') === -1 ? `Set @tbid='' + Select top 1 @tbid=${_afields.join('+\' \'+')} from #${sheet} a Inner join ${sheet} b on ${_fields_} If @tbid!='' Begin select @ErrorCode='${unique.errorCode}',@retmsg=@tbid+' 涓庡凡鏈夋暟鎹噸澶�' goto aaa - end + end` : ''} ` }) } @@ -1313,64 +1348,50 @@ _insert = ` /* 榛樿sql */ Insert into ${database}${sheet} (${fields},createuserid,createuser,createstaff,bid) - Select ${fields},@userid@,@username,@fullname,@BID@ From @${sheet} + Select ${fields},'${sessionStorage.getItem('UserID') || ''}',@username,@fullname,'${BID}' From #${sheet} ` } - _sql = ` + sql = ` /* 绯荤粺鐢熸垚 */ - declare @${sheet} table (${declarefields.join(',')},jskey nvarchar(50),data_type nvarchar(50),BID nvarchar(50) ) + create table #${sheet} (${declarefields.join(',')},jskey nvarchar(50),data_type nvarchar(50),BID nvarchar(50) ) Declare @UserName nvarchar(50),@FullName nvarchar(50),@RoleID nvarchar(512),@mk_departmentcode nvarchar(512),@mk_organization nvarchar(512),@mk_user_type nvarchar(20),@mk_nation nvarchar(50),@mk_province nvarchar(50),@mk_city nvarchar(50),@mk_district nvarchar(50),@mk_address nvarchar(100),@ErrorCode nvarchar(50),@retmsg nvarchar(4000),@tbid Nvarchar(512) Select @ErrorCode='', @retmsg='', @UserName='${userName}', @FullName='${fullName}', @RoleID='${RoleID}', @mk_departmentcode='${departmentcode}', @mk_organization='${organization}', @mk_user_type='${mk_user_type}', @mk_nation='${nation}', @mk_province='${province}', @mk_city='${city}', @mk_district='${district}', @mk_address='${address}' ${_initCustomScript} - ` - _sqlInsert = `Insert into @${sheet} (${fields},jskey,data_type,BID)` - _sqlBottom = ` - /* 榛樿sql */ - delete tmp_excel_in where upid=@upid@ - - delete tmp_excel_in where datediff(day,createdate,getdate())>15 + Insert into #${sheet} (${fields},jskey,data_type,BID) + + /* excel鏁版嵁*/ + ${_Ltext.join(' Union all ')} + ${_uniquesql} ${_prevCustomScript} ${_insert} ${_backCustomScript} - Delete @${sheet} + + drop table #${sheet} aaa: select @ErrorCode as ErrorCode,@retmsg as retmsg` - if (window.GLOB.debugger === true || (window.debugger === true && options.sysType !== 'cloud')) { - let fsql = ` - ${_sql} - ${_sqlInsert} - - /* table鏁版嵁 */ - ${conLtext.join(' Union all \n')} - ${_sqlBottom} - ` - fsql = fsql.replace(/\n\s{8}/ig, '\n') - console.info(fsql) + sql = sql.replace(/\n\s{6}/ig, '\n') + + if (window.GLOB.debugger === true) { + console.info(sql) } - } else { // s_sDataDictb_excelIn 浜戠瀵嗛挜楠岃瘉鍙傛暟 - _sql = ` - /* 绯荤粺鐢熸垚 */ - declare @${sheet} table (jskey nvarchar(50)) - Declare @UserName nvarchar(50),@FullName nvarchar(50),@RoleID nvarchar(512),@mk_departmentcode nvarchar(512),@mk_organization nvarchar(512),@mk_user_type nvarchar(20),@mk_nation nvarchar(50),@mk_province nvarchar(50),@mk_city nvarchar(50),@mk_district nvarchar(50),@mk_address nvarchar(100),@ErrorCode nvarchar(50),@retmsg nvarchar(4000),@tbid Nvarchar(512) - - Select @ErrorCode='', @retmsg='', @UserName='${userName}', @FullName='${fullName}', @RoleID='${RoleID}', @mk_departmentcode='${departmentcode}', @mk_organization='${organization}', @mk_user_type='${mk_user_type}', @mk_nation='${nation}', @mk_province='${province}', @mk_city='${city}', @mk_district='${district}', @mk_address='${address}' - ` + } else { + for(let i = 0; i < _Ltext.length; i += 20) { + result.push(_Ltext.slice(i, i + 20)) + } } return { - sql: _sql, + sql: sql, lines: result.map((list, index) => { return { Ltext: window.btoa(window.encodeURIComponent(list.join(' Union all '))), Sort: (index + 1) * 10 } - }), - insert: _sqlInsert, - bottom: _sqlBottom + }) } } @@ -1423,7 +1444,7 @@ }) // 闇�瑕佸0鏄庣殑鍙橀噺闆� - let _vars = ['tbid', 'errorcode', 'retmsg', 'billcode', 'bvoucher', 'fibvoucherdate', 'fiyear', 'username', 'fullname', 'modulardetailcode', 'roleid', 'mk_departmentcode', 'mk_organization', 'mk_user_type', 'mk_nation', 'mk_province', 'mk_city', 'mk_district', 'mk_address', 'bid'] + let _vars = ['tbid', 'errorcode', 'retmsg', 'billcode', 'bvoucher', 'fibvoucherdate', 'fiyear', 'username', 'fullname', 'modulardetailcode', 'roleid', 'mk_departmentcode', 'mk_organization', 'mk_user_type', 'mk_nation', 'mk_province', 'mk_city', 'mk_district', 'mk_address', 'mk_deleted', 'bid'] // 涓婚敭瀛楁 let primaryKey = setting.primaryKey || 'id' @@ -1443,24 +1464,31 @@ if (!_initvars.includes(_key)) { _initvars.push(_key) + let val = form.value if (form.type === 'number' || form.type === 'rate') { - let val = form.value if (isNaN(val)) { val = 0 } _initFormfields.push(`@${_key}=${val}`) } else if (['date', 'datemonth'].includes(form.type)) { - _initFormfields.push(`@${_key}='${form.value || '1949-10-01'}'`) + _initFormfields.push(`@${_key}='${val || '1949-10-01'}'`) } else { - _initFormfields.push(`@${_key}='${form.value}'`) + if (/'/.test(val)) { + val = val.replace(/'/ig, '"') + } + if (form.isconst) { + _initFormfields.push(`@${_key}=N'${val}'`) + } else { + _initFormfields.push(`@${_key}='${val}'`) + } } } if (!_vars.includes(_key)) { _vars.push(_key) - if (form.fieldlen && form.fieldlen > 2048) { + if (form.fieldlen && form.fieldlen > 4000) { form.fieldlen = 'max' } @@ -1478,15 +1506,16 @@ } }) + let _data = {} if (data) { Object.keys(data).forEach(key => { - data[key.toLowerCase()] = data[key] + _data[key.toLowerCase()] = data[key] }) } // 娣诲姞鏁版嵁涓瓧娈碉紝琛ㄥ崟鍊间紭鍏�(鎸夐挳涓嶉�夎鎴栧琛屾嫾鎺ユ椂璺宠繃) - if (data && btn.Ot !== 'notRequired' && btn.Ot !== 'requiredOnce' && columns && columns.length > 0) { - datavars = {...data, ...datavars} + if (data && btn.Ot !== 'notRequired' && columns && columns.length > 0) { + datavars = {..._data, ...datavars} const setField = (col) => { if (!col.field) return @@ -1499,6 +1528,10 @@ _val = '1949-10-01' } + if (/'/.test(_val)) { + _val = _val.replace(/'/ig, '"') + } + _initvars.push(_key) _initColfields.push(`@${_key}='${_val}'`) } @@ -1509,7 +1542,7 @@ if (col.datatype) { _declarefields.push(`@${_key} ${col.datatype}`) } else { - if (col.fieldlength && col.fieldlength > 2048) { + if (col.fieldlength && col.fieldlength > 4000) { col.fieldlength = 'max' } @@ -1544,7 +1577,7 @@ _declarefields = ',' + _declarefields } _sql = `/* 绯荤粺鐢熸垚 */ - Declare @tbid nvarchar(50),@ErrorCode nvarchar(50),@retmsg nvarchar(4000),@BillCode nvarchar(50),@BVoucher nvarchar(50),@FIBVoucherDate nvarchar(50), @FiYear nvarchar(50),@ModularDetailCode nvarchar(50), @UserName nvarchar(50),@FullName nvarchar(50),@RoleID nvarchar(512),@mk_departmentcode nvarchar(512),@mk_organization nvarchar(512),@mk_user_type nvarchar(20),@mk_nation nvarchar(50),@mk_province nvarchar(50),@mk_city nvarchar(50),@mk_district nvarchar(50),@mk_address nvarchar(100),@bid nvarchar(50)${_declarefields} + Declare @tbid nvarchar(50),@ErrorCode nvarchar(50),@retmsg nvarchar(4000),@BillCode nvarchar(50),@BVoucher nvarchar(50),@FIBVoucherDate nvarchar(50), @FiYear nvarchar(50),@ModularDetailCode nvarchar(50), @UserName nvarchar(50),@FullName nvarchar(50),@RoleID nvarchar(512),@mk_departmentcode nvarchar(512),@mk_organization nvarchar(512),@mk_user_type nvarchar(20),@mk_nation nvarchar(50),@mk_province nvarchar(50),@mk_city nvarchar(50),@mk_district nvarchar(50),@mk_address nvarchar(100),@mk_deleted int,@bid nvarchar(50)${_declarefields} ` let userName = sessionStorage.getItem('User_Name') || '' @@ -1559,15 +1592,10 @@ let district = sessionStorage.getItem('district') || '' let address = sessionStorage.getItem('address') || '' - if (sessionStorage.getItem('isEditState') === 'true') { - userName = sessionStorage.getItem('CloudUserName') || '' - fullName = sessionStorage.getItem('CloudFullName') || '' - } - // 鍒濆鍖栧嚟璇佸強鐢ㄦ埛淇℃伅瀛楁 _sql += ` /* 鍑瘉鍙婄敤鎴蜂俊鎭垵濮嬪寲璧嬪�� */ - select @BVoucher='',@FIBVoucherDate='',@FiYear='',@ErrorCode='',@retmsg='',@UserName='${userName}', @FullName='${fullName}', @RoleID='${RoleID}', @mk_departmentcode='${departmentcode}', @mk_organization='${organization}', @mk_user_type='${mk_user_type}', @mk_nation='${nation}', @mk_province='${province}', @mk_city='${city}', @mk_district='${district}', @mk_address='${address}', @bid='${BID}', @BillCode='', @ModularDetailCode='' + select @BVoucher='',@FIBVoucherDate='',@FiYear='',@ErrorCode='',@retmsg='',@UserName='${userName}', @FullName='${fullName}', @RoleID='${RoleID}', @mk_departmentcode='${departmentcode}', @mk_organization='${organization}', @mk_user_type='${mk_user_type}', @mk_nation='${nation}', @mk_province='${province}', @mk_city='${city}', @mk_district='${district}', @mk_address='${address}', @mk_deleted=1, @bid='${BID}', @BillCode='', @ModularDetailCode='' ` // 琛ㄥ崟鍙橀噺璧嬪�� @@ -1681,7 +1709,7 @@ /* 澶辨晥楠岃瘉 */ select @tbid='', @ErrorCode='',@retmsg='' select @tbid='X' from ${datasource} right join (select ID from dbo.SplitComma(@ID@)) sp - on tb.id =sp.id where tb.id is null + on tb.${primaryKey} =sp.id where tb.${primaryKey} is null If @tbid!='' Begin @@ -1755,8 +1783,8 @@ let _val = '' if (_linkKey === 'bid' && BID) { // 鏇挎崲bid _val = BID - } else if (data && data.hasOwnProperty(_linkKey)) { - _val = data[_linkKey] + } else if (_data.hasOwnProperty(_linkKey)) { + _val = _data[_linkKey] } _ModularDetailCode = `'${item.TypeCharOne + _val}'` } else { @@ -1885,7 +1913,7 @@ _sql += ` /* 鍒涘缓鍑瘉 */ exec s_BVoucher_Create - @Bill ='${data[_voucher.linkField.toLowerCase()]}', + @Bill ='${_data[_voucher.linkField.toLowerCase()]}', @BVoucherType ='${_voucher.BVoucherType}', @VoucherTypeOne ='${_voucher.VoucherTypeOne}', @VoucherTypeTwo ='${_voucher.VoucherTypeTwo}', @@ -2040,17 +2068,16 @@ _sql += ` /* 榛樿sql */ - update ${btn.sql} set deleted=1,modifydate=getdate(),modifyuser=@username,modifyuserid=@userid@ where ${primaryKey}${_ID};` + update ${btn.sql} set deleted=@mk_deleted,modifydate=getdate(),modifyuser=@username,modifystaff=@fullname,modifyuserid=@userid@ where ${primaryKey}${_ID};` } else if (_actionType === 'delete') { // 鐗╃悊鍒犻櫎 let _msg = '' - if (data && columns && columns.length > 0) { + if (data && columns && columns.length > 0 && btn.Ot !== 'notRequired') { let _index = 0 columns.forEach(col => { - if (col.Hide !== 'true' && col.type !== 'colspan' && col.type !== 'old_colspan' && _index < 4) { - _msg += col.label + '=' + data[col.field] + ',' - _index++ - } + if (!col.field || col.Hide === 'true' || _index >= 4) return + _msg += col.label + '=' + data[col.field] + ',' + _index++ }) } @@ -2078,6 +2105,135 @@ ${_updatesql} end ` + } + + if (btn.$process && verify.workFlow === 'true' && window.GLOB.UserCacheMap.has(btn.$flowId)) { + let flow = window.GLOB.UserCacheMap.get(btn.$flowId) + let node = null + let line = null + let target = null + let status = 0 + let statusName = '' + let detailId = '' + + if (verify.flowType === 'start') { + target = flow.cells.filter(cell => cell.mknode === 'start')[0] + + if (target) { + detailId = target.id + status = target.mkdata.status + statusName = target.mkdata.statusName + } + } else if (_data.works_flow_param) { + node = JSON.parse(window.decodeURIComponent(window.atob(_data.works_flow_param))) + + if (node) { + let lines = flow.cells.filter(cell => cell.shape === 'edge' && cell.source.cell === node.id) + if (verify.flowType === 'reject') { + line = lines.filter(cell => cell.mkdata.flowType === 'reject')[0] + } else { + line = lines.filter(cell => cell.mkdata.flowType !== 'reject')[0] + } + } + + if (line) { + detailId = line.id + status = line.mkdata.status + statusName = line.mkdata.statusName + target = flow.cells.filter(cell => cell.id === line.target.cell)[0] + } + } + + if (verify.flowSql === 'true' && target) { + if (verify.flowType === 'start') { + _sql += ` + /* 宸ヤ綔娴侀粯璁ql */ + insert into s_my_works_flow (works_flow_id,works_flow_code,works_flow_name,works_flow_param,status,statusname,work_group,works_flow_detail_id,work_grade,bid,createuserid,CreateUser,CreateStaff,upid) + select @ID@,@works_flow_code@,@works_flow_name@,@works_flow_param@,@status@,@statusname@,@work_group@,@works_flow_detail_id@,@work_grade@,@bid@,@UserID@,@UserName,@FullName,@time_id@ + insert into s_my_works_flow_log (works_flow_id,works_flow_code,works_flow_name,works_flow_param,status,statusname,works_flow_detail_id,work_group,work_grade,upid) + select @ID@,@works_flow_code@,@works_flow_name@ ,@works_flow_param@,@status@,@statusname@,@works_flow_detail_id@,@work_group@,@work_grade@,@time_id@ + insert into s_my_works_flow_notice (works_flow_id,works_flow_code,works_flow_detail_id,userid,notice_type,createuserid,CreateUser,CreateStaff,upid) + select @ID@,@works_flow_code@,@works_flow_detail_id@,@userid@,@start_type@,@userid@,@UserName,@FullName,@time_id@ + ` + } else { + _sql += ` + /* 宸ヤ綔娴侀粯璁ql */ + update s_my_works_flow set status=@status@,statusname=@statusname@,modifydate=getdate(),modifyuserid=@userid@,modifyuser=@username,modifystaff=@fullname + where works_flow_id=@ID@ and works_flow_code=@works_flow_code@ and deleted=0 + insert into s_my_works_flow_log (works_flow_id,works_flow_code,works_flow_name,works_flow_param,status,statusname,works_flow_detail_id,work_group,work_grade,upid) + select @ID@,@works_flow_code@,@works_flow_name@ ,@works_flow_param@,@status@,@statusname@,@works_flow_detail_id@,@work_group@,@work_grade@,@time_id@ + if @check_userids@ != '' + begin + delete s_my_works_flow_role where works_flow_id=@ID@ and works_flow_code=@works_flow_code@ and deleted=0 + insert into s_my_works_flow_role (works_flow_id,works_flow_code,userid,works_flow_detail_id,createuserid,CreateUser,CreateStaff,upid) + select @ID@,@works_flow_code@,ID,@works_flow_detail_id@,@userid@,@UserName,@FullName,@time_id@ from dbo.SplitComma(@check_userids@) + insert into s_my_works_flow_notice (works_flow_id,works_flow_code,works_flow_detail_id,userid,notice_type,createuserid,CreateUser,CreateStaff,upid) + select @ID@,@works_flow_code@,@works_flow_detail_id@,ID,@check_type@,@userid@,@UserName,@FullName,@time_id@ from dbo.SplitComma(@check_userids@) + end + if @notice_userids@ != '' + begin + delete n + from (select * from s_my_works_flow_notice where works_flow_id=@ID@ and works_flow_code=@works_flow_code@ and deleted=0) n + inner join (select ID from dbo.SplitComma(@notice_userids@)) s + on n.userid = s.id + insert into s_my_works_flow_notice (works_flow_id,works_flow_code,works_flow_detail_id,userid,notice_type,createuserid,CreateUser,CreateStaff,upid) + select @ID@,@works_flow_code@,@works_flow_detail_id@,ID,@notice_type@,@userid@,@UserName,@FullName,@time_id@ from dbo.SplitComma(@notice_userids@) + end + ` + } + } else if (verify.flowSql === 'true') { + target = flow.cells.filter(cell => cell.mknode === 'start')[0] + + if (target) { + detailId = target.id + } + + status = 0 + statusName = '寮傚父' + _sql += ` + /* 宸ヤ綔娴佸紓甯竤ql */ + update s_my_works_flow set status=@status@,statusname=@statusname@,modifydate=getdate(),modifyuserid=@userid@,modifyuser=@username,modifystaff=@fullname + where works_flow_id=@ID@ and works_flow_code=@works_flow_code@ and deleted=0 + insert into s_my_works_flow_log (works_flow_id,works_flow_code,works_flow_name,works_flow_param,status,statusname,works_flow_detail_id,work_group,work_grade,upid) + select @ID@,@works_flow_code@,@works_flow_name@ ,@works_flow_param@,@status@,@statusname@,@works_flow_detail_id@,@work_group@,@work_grade@,@time_id@ + ` + } + + if (verify.flowType !== 'start') { + if (line) { + let checkIds = [] + let noticeIds = [] + line.mkdata.members && line.mkdata.members.forEach(item => { + checkIds.push(item.worker_id) + }) + line.mkdata.copys && line.mkdata.copys.forEach(item => { + noticeIds.push(item.worker_id) + }) + _sql = _sql.replace(/@check_userids@/ig, `'${checkIds.join(',')}'`) + _sql = _sql.replace(/@notice_userids@/ig, `'${noticeIds.join(',')}'`) + } else { + _sql = _sql.replace(/@check_userids@/ig, `''`) + _sql = _sql.replace(/@notice_userids@/ig, `''`) + } + } + + _sql = _sql.replace(/@start_type@/ig, `'寮�濮�'`) + _sql = _sql.replace(/@check_type@/ig, verify.flowType === 'reject' ? `'椹冲洖'` : `'瀹℃牳'`) + _sql = _sql.replace(/@notice_type@/ig, `'鎶勯��'`) + + _sql = _sql.replace(/@works_flow_code@/ig, `'${flow.flow_code}'`) + _sql = _sql.replace(/@works_flow_name@/ig, `'${flow.flow_name}'`) + if (target) { + let msg = {...target.mkdata, id: target.id} + _sql = _sql.replace(/@works_flow_param@/ig, `'${window.btoa(window.encodeURIComponent(JSON.stringify(msg)))}'`) + } else { + _sql = _sql.replace(/@works_flow_param@/ig, `''`) + } + _sql = _sql.replace(/@works_flow_detail_id@/ig, `'${detailId}'`) + _sql = _sql.replace(/@status@/ig, `'${status}'`) + _sql = _sql.replace(/@statusname@/ig, `'${statusName}'`) + _sql = _sql.replace(/@work_group@/ig, `'${sessionStorage.getItem('work_group') || ''}'`) + _sql = _sql.replace(/@work_grade@/ig, `'${sessionStorage.getItem('work_grade') || 0}'`) } if (_backCustomScript) { @@ -2118,19 +2274,18 @@ _sql = _sql.replace(/@Appkey@/ig, `'${window.GLOB.appkey || ''}'`) _sql = _sql.replace(/@typename@/ig, `'admin'`) - if (window.GLOB.debugger === true || (window.debugger === true && options.sysType !== 'cloud')) { + if (sessionStorage.getItem('dataM') === 'true') { // 鏁版嵁鏉冮檺 + _sql = _sql.replace(/\$@/ig, '/*').replace(/@\$/ig, '*/').replace(/@datam@/ig, `'Y'`) + } else { + _sql = _sql.replace(/@\$|\$@/ig, '').replace(/@datam@/ig, `''`) + } + + if (window.GLOB.debugger === true) { // _sql = _sql.replace(/\n\s{8}/ig, '\n') console.info(_sql) } if (retmsg) { - _callbacksql = _callbacksql.replace(/@ID@/ig, `'${primaryId || ''}'`) - _callbacksql = _callbacksql.replace(/@BID@/ig, `'${BID}'`) - _callbacksql = _callbacksql.replace(/@LoginUID@/ig, `'${sessionStorage.getItem('LoginUID') || ''}'`) - _callbacksql = _callbacksql.replace(/@SessionUid@/ig, `'${localStorage.getItem('SessionUid') || ''}'`) - _callbacksql = _callbacksql.replace(/@UserID@/ig, `'${sessionStorage.getItem('UserID') || ''}'`) - _callbacksql = _callbacksql.replace(/@Appkey@/ig, `'${window.GLOB.appkey || ''}'`) - return { sql: _sql, callbacksql: _callbacksql @@ -2147,6 +2302,7 @@ let icon = null let innerStyle = null let position = null + let signType = '' style = JSON.parse(JSON.stringify(style)) marks.some(mark => { @@ -2184,8 +2340,9 @@ if (type === 'font') { style.color = mark.color innerStyle = {color: mark.color} + signType = ' sign-font' } else if (type === 'background') { - style.background = mark.color + style.backgroundColor = mark.color if (mark.fontColor) { style.color = mark.fontColor innerStyle = {color: mark.fontColor} @@ -2215,7 +2372,8 @@ style, icon, innerStyle, - position + position, + signType } } @@ -2224,501 +2382,21 @@ */ export function setGLOBFuncs () { window.GLOB.funcs = [] - if (!window.GLOB.WebSql && !window.GLOB.IndexDB) { + if (!window.GLOB.IndexDB) { return } - if (window.GLOB.WebSql) { - window.GLOB.WebSql.transaction(tx => { - tx.executeSql("SELECT * FROM FUNCS", [], (tx, results) => { - let rows = results.rows - if (!rows || rows.length === 0) return - for (let i = 0; i < rows.length; i++) { - window.GLOB.funcs.push({ - func_code: rows[i].func_code, - key_sql: window.decodeURIComponent(window.atob(rows[i].key_sql)) - }) - } + let objectStore = window.GLOB.IndexDB.transaction('funcs').objectStore('funcs') + + objectStore.openCursor().onsuccess = (event) => { + let cursor = event.target.result + + if (cursor) { + window.GLOB.funcs.push({ + func_code: cursor.value.func_code, + key_sql: window.decodeURIComponent(window.atob(cursor.value.key_sql)) }) - }) - } else { - let objectStore = window.GLOB.IndexDB.transaction('funcs').objectStore('funcs') - - objectStore.openCursor().onsuccess = (event) => { - let cursor = event.target.result - - if (cursor) { - window.GLOB.funcs.push({ - func_code: cursor.value.func_code, - key_sql: window.decodeURIComponent(window.atob(cursor.value.key_sql)) - }) - cursor.continue() - } + cursor.continue() } - } -} - -/** - * @description 鍒涘缓瀛樺偍杩囩▼绫� - */ -export class FuncUtils { - /** - * @description 鍒犻櫎瀛樺偍杩囩▼sql - * @return {String} name 瀛樺偍杩囩▼鍚嶇О - */ - static dropfunc (name) { - return `IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID('${name}') AND type in (N'P', N'PC')) mdrpk PROCEDURE ${name}` - } - - /** - * @description 鍒涘缓椤甸潰瀛樺偍杩囩▼ - * @return {String} - */ - static getTableFunc (param, menu, config) { - let form = '' - let formParam = '' - let _vars = ['bid', 'pageindex', 'pagesize', 'ordercol', 'ordertype', 'exceltype', 'septmenuno', 'lang', 'debug', 'loginuid', 'sessionuid', 'userid', 'errorcode', 'retmsg'] - let _columns = [] - let primaryKey = config.setting.primaryKey || 'ID' - - if (!_vars.includes(primaryKey.toLowerCase())) { - _vars.push(primaryKey.toLowerCase()) - formParam = `mchr13k@${primaryKey} nvarchar(50)='',` - } - - if (config.search && config.search.length > 0) { - let _fields = new Map() - config.search.forEach(item => { - if (item.field) { - let type = '' - - if (item.type.match(/date/ig)) { - type = 'datetime=null' - } else { - type = 'nvarchar(50)=\'\'' - } - - item.field.split(',').forEach(cell => { - let _f = cell - if (_fields.has(cell)) { - _f = _f + '1' - } - - _fields.set(cell, true) - - if (!_vars.includes(_f.toLowerCase())) { - _vars.push(_f.toLowerCase()) - formParam = formParam + `mchr13k@${_f} ${type},` - } - }) - } - }) - } - - if (config.columns && config.columns.length > 0) { - config.columns.forEach(item => { - if (item.field) { - _columns.push(`${item.field} as ${item.label}`) - } - }) - - form = ` - declare @dc table (${_columns.join(',')}) - - @tableid ='${menu.MenuID}' - ` - } - - let Ltext = `create proc ${param.innerFunc} - ( /*${menu.MenuName}*/ - @appkey nvarchar(50)='', - @BID nvarchar(50)='',${formParam} - @PageIndex nvarchar(50)='', - @PageSize nvarchar(50)='', - @OrderCol nvarchar(50)='', - @OrderType nvarchar(50)='', - @exceltype nvarchar(50)='', - @sEPTMenuNo nvarchar(50)='${menu.MenuNo}', - @lang nvarchar(50)='', - @debug nvarchar(50)='', - @LoginUID nvarchar(50)='', - @SessionUid nvarchar(50)='', - @UserID nvarchar(50), - @ErrorCode nvarchar(50) out, - @retmsg nvarchar(4000) out - ) - as - begin - declare @BegindateTest datetime,@EnddateTest datetime - select @BegindateTest=getdate() - set @ErrorCode='' - set @retmsg='' - BEGIN TRY - /*浜嬪姟鎿嶄綔*/ - BEGIN TRAN - /*鍏蜂綋涓氬姟鎿嶄綔*/ - - /* - select top 10 * from sProcExcep order by id desc - - declare @UserName nvarchar(50),@FullName nvarchar(50) - - select @UserName=UserName,@FullName=FullName from SUsers where UID=@UserID - ${form} - if 1=2 - begin - set @ErrorCode='E' - set @retmsg='鍦ㄦ鍐欐姤閿�' - goto GOTO_RETURN - end - - insert into sNote (remark,createuserid,CreateUser,CreateStaff) - select '鍦ㄦ鍐欐棩蹇�',@UserID,@UserName,@FullName - */ - - 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, /*-- Message text.*/ - @ErrorSeverity, /*-- Severity.*/ - @ErrorState /*-- State.*/ - ); - END CATCH - - GOTO_RETURN: - ROLLBACK TRAN - - END` - - Ltext = Ltext.replace(/\n\s{4}/ig, 'mchr13k') - - return Ltext - } - - /** - * @description 鍒涘缓瀛樺偍杩囩▼ - * @return {String} - */ - static getfunc (param, btn, menu, config) { - let form = '' - let formParam = '' - let _vars = ['bid', 'septmenuno', 'lang', 'debug', 'loginuid', 'sessionuid', 'userid', 'errorcode', 'retmsg'] - let columns = config.columns - let primaryKey = config.setting.primaryKey || 'ID' - - if (!_vars.includes(primaryKey.toLowerCase())) { - _vars.push(primaryKey.toLowerCase()) - let _type = '50' - if (btn.Ot === 'requiredOnce') { // 澶氳鎷兼帴鏃讹紝涓婚敭璁句负max - _type = 'max' - } - formParam = `mchr13k@${primaryKey} nvarchar(${_type})='',` - } - - if (param.fields && param.fields.length > 0) { - let _fields = [] - param.fields.forEach(item => { - if (item.field) { - let type = '' - if (item.type.match(/date/ig)) { - type = 'datetime=null' - } else if (item.type === 'number') { - type = `decimal(18,${item.decimal})=0` - } else if (item.type === 'rate') { - type = `decimal(18,2)=0` - } else { - type = 'nvarchar(50)=\'\'' - } - - if (!_vars.includes(item.field.toLowerCase())) { - _vars.push(item.field.toLowerCase()) - formParam = formParam + `mchr13k@${item.field} ${type},` - } - - _fields.push(item.field) - } - }) - - let field1 = _fields.join(',') - let field2 = _fields.join(',@') - let field3 = _fields.map(cell => { - return cell + '=@' + cell - }) - - field2 = field2 ? '@' + field2 : '' - field3 = field3.join(',') - - form = ` - insert into ${param.name} (${field1},createuserid) select ${field2},@UserID - - update ${param.name} set ${field3},modifydate=getdate(),modifyuser=@username,modifyuserid=@UserID - ` - } else if (btn.OpenType === 'prompt' || btn.OpenType === 'exec') { - form = ` - update ${param.name} set ModifyDate=getdate(),ModifyUserID=@UserID where ${primaryKey}=@${primaryKey} - ` - } - - if (columns) { - let _col = [] - let _field = [] - columns.forEach(col => { - if (col.field) { - if (col.type === 'number') { - _col.push(col.field + ' decimal(18,2)') - } else { - _col.push(col.field + ' nvarchar(50)') - } - _field.push(col.field) - } - }) - _col = _col.join(',') - _field = _field.join(',') - - form = form + ` - declare @dc table (${_col}) - - insert into @dc (${_field}) - - @tableid ='${menu.MenuID}' - ` - } - - // 鎵撳嵃鑷畾涔夋ā鏉垮瓧娈垫彁绀� - let _printRemark = '' - if (btn.funcType === 'print') { - _printRemark = '/* 鑷畾涔夋暟鎹墦鍗版ā鏉挎椂锛岃浣跨敤TemplateID瀛楁 */' - } - - let Ltext = `create proc ${param.funcName} - ( /*${menu.MenuName} ${btn.label}*/ - @appkey nvarchar(50)='', - @BID nvarchar(50)='',${formParam} - @sEPTMenuNo nvarchar(50)='${param.menuNo}', - @lang nvarchar(50)='', - @debug nvarchar(50)='', - @LoginUID nvarchar(50)='', - @SessionUid nvarchar(50)='', - @UserID nvarchar(50), - @ErrorCode nvarchar(50) out, - @retmsg nvarchar(4000) out - ) - as - begin - declare @BegindateTest datetime,@EnddateTest datetime - select @BegindateTest=getdate() - set @ErrorCode='' - set @retmsg='' - BEGIN TRY - /*浜嬪姟鎿嶄綔*/ - BEGIN TRAN - /*鍏蜂綋涓氬姟鎿嶄綔*/ - ${_printRemark} - /* - select top 10 * from sProcExcep order by id desc - - declare @UserName nvarchar(50),@FullName nvarchar(50) - - select @UserName=UserName,@FullName=FullName from SUsers where UID=@UserID - ${form} - if 1=2 - begin - set @ErrorCode='E' - set @retmsg='鍦ㄦ鍐欐姤閿�' - goto GOTO_RETURN - end - - insert into sNote (remark,createuserid,CreateUser,CreateStaff) - select '鍦ㄦ鍐欐棩蹇�',@UserID,@UserName,@FullName - */ - - 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, /*-- Message text.*/ - @ErrorSeverity, /*-- Severity.*/ - @ErrorState /*-- State.*/ - ); - END CATCH - - GOTO_RETURN: - ROLLBACK TRAN - - END` - - Ltext = Ltext.replace(/\n\s{4}/ig, 'mchr13k') - - return Ltext - } - - /** - * @description 鍒涘缓瀵煎叆瀛樺偍杩囩▼ - * @return {String} - */ - static getexcelInfunc (param, btn, menu) { - let _verify = btn.verify - - let _uniquesql = '' - if (_verify.uniques && _verify.uniques.length > 0) { - _verify.uniques.forEach(unique => { - if (unique.status === 'false') return - - let _fields = unique.field.split(',') - let _fields_ = _fields.map(_field => { - return `a.${_field}=b.${_field}` - }) - _fields_ = _fields_.join(' and ') - - if (unique.verifyType !== 'physical') { - _fields_ += ' and b.deleted=0' - } - - _uniquesql += ` - Set @tbid='' - Select top 1 @tbid=${_fields.join('+\' \'+')} from (select 1 as n,${unique.field} from @${btn.sheet} ) a group by ${unique.field} having sum(n)>1 - - If @tbid!='' - Begin - select @ErrorCode='${unique.errorCode}',@retmsg=@tbid+' 閲嶅' - goto aaa - end - - Set @tbid='' - Select top 1 @tbid=${_fields.join('+\' \'+')} from @${btn.sheet} a - Inner join ${btn.sheet} b on ${_fields_} - - If @tbid!='' - Begin - select @ErrorCode='${unique.errorCode}',@retmsg=@tbid+' 涓庡凡鏈夋暟鎹噸澶�' - goto aaa - end - ` - }) - - if (_uniquesql) { - _uniquesql = ` - Declare @tbid Nvarchar(512) - ${_uniquesql}` - } - } - - let declarefields = [] - let fields = [] - - _verify.columns.forEach(col => { - declarefields.push(`${col.Column} ${col.type}`) - fields.push(col.Column) - }) - - fields = fields.join(',') - - let _sql = `declare @${btn.sheet} table (${declarefields.join(',')},jskey nvarchar(50)) - Declare @UserName nvarchar(50),@FullName nvarchar(50) - - select @UserName=UserName,@FullName=FullName from SUsers where UID=@UserID - - Insert into @${btn.sheet} (${fields},jskey) - - exec s_KeyWords_Replace - @LText=@LText, @BID=@BID,@LoginUID=@LoginUID,@SessionUid=@SessionUid,@UserID=@UserID,@ID=@ID - ${_uniquesql} - Insert into ${btn.sheet} (${fields},createuserid,createuser,createstaff,bid) - Select ${fields},@userid,@username,@fullname,@BID From @${btn.sheet} - - Delete @${btn.sheet}` - - let Ltext = `create proc ${param.funcName} - ( /*${menu.MenuName} ${btn.label}*/ - @appkey nvarchar(50)='', - @ID nvarchar(50)='', - @BID nvarchar(50)='', - @Ltext nvarchar(max)='', - @sEPTMenuNo nvarchar(50)='${param.menuNo}', - @secretkey nvarchar(50)='', - @timestamp nvarchar(50)='', - @lang nvarchar(50)='', - @LoginUID nvarchar(50)='', - @SessionUid nvarchar(50)='', - @UserID nvarchar(50), - @ErrorCode nvarchar(50) out, - @retmsg nvarchar(4000) out - ) - as - begin - declare @BegindateTest datetime,@EnddateTest datetime - select @BegindateTest=getdate() - set @ErrorCode='' - set @retmsg='' - BEGIN TRY - /*浜嬪姟鎿嶄綔*/ - BEGIN TRAN - /*鍏蜂綋涓氬姟鎿嶄綔*/ - - /* - ${_sql} - */ - - 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, /*-- Message text.*/ - @ErrorSeverity, /*-- Severity.*/ - @ErrorState /*-- State.*/ - ); - END CATCH - - GOTO_RETURN: - ROLLBACK TRAN - - END` - - Ltext = Ltext.replace(/\n\s{4}/ig, 'mchr13k') - - return Ltext } } \ No newline at end of file -- Gitblit v1.8.0