import md5 from 'md5'
|
import { fromJS } from 'immutable'
|
import { notification } from 'antd'
|
|
export default class MenuUtils {
|
/**
|
* @description 获取下级模块
|
* @return {String} selfId 当前组件id
|
*/
|
static getSubModules (components, selfId, supId, interfaces) {
|
let modules = []
|
components.forEach(item => {
|
if (item.uuid === selfId || item.type === 'navbar') {
|
return
|
} else if (item.format) { // 数据格式，存在数据源
|
modules.push({
|
value: item.uuid,
|
label: item.name,
|
disabled: supId === item.uuid
|
})
|
|
if (item.type === 'form' && item.subtype === 'simpleform' && item.wrap.refocus && supId !== item.uuid) {
|
modules.push({
|
value: item.uuid + '$focus-refresh',
|
label: item.name + '（刷新-聚焦）',
|
})
|
modules.push({
|
value: item.uuid + '$focus-nofresh',
|
label: item.name + '（不刷新-聚焦）',
|
})
|
}
|
} else if (item.type === 'tabs') {
|
if (item.subtype === 'tabletabs') {
|
item.subtabs.forEach(tab => {
|
if (tab.components[0].uuid === selfId) return
|
|
modules.push({
|
value: tab.components[0].uuid,
|
label: tab.label,
|
disabled: supId === tab.components[0].uuid
|
})
|
})
|
} else {
|
let _item = {
|
type: 'tabs',
|
value: item.uuid,
|
label: item.name,
|
children: item.subtabs.map(f_tab => {
|
let subItem = {
|
type: 'tab',
|
value: f_tab.uuid,
|
label: f_tab.label,
|
children: this.getSubModules(f_tab.components, selfId, supId)
|
}
|
|
if (subItem.children.length === 0) {
|
return {children: null}
|
}
|
return subItem
|
})
|
}
|
|
_item.children = _item.children.filter(t => t.children !== null)
|
|
if (_item.children.length > 0) {
|
modules.push(_item)
|
}
|
}
|
} else if (item.type === 'group') {
|
let _item = {
|
value: item.uuid,
|
label: item.name,
|
children: item.components.map(f_tab => {
|
if (f_tab.uuid === selfId) {
|
return {
|
children: null
|
}
|
} else if (f_tab.format) {
|
return {
|
value: f_tab.uuid,
|
label: f_tab.name,
|
disabled: supId === f_tab.uuid
|
}
|
}
|
return {
|
children: null
|
}
|
})
|
}
|
|
_item.children = _item.children.filter(t => t.children !== null)
|
|
if (_item.children.length > 0) {
|
modules.push(_item)
|
}
|
}
|
})
|
|
if (interfaces && interfaces.length > 0) {
|
interfaces.forEach(item => {
|
modules.push({
|
value: item.uuid,
|
label: item.name
|
})
|
})
|
}
|
|
return modules
|
}
|
|
/**
|
* @description 获取下级模块
|
* @return {String} selfId 当前组件id
|
*/
|
static getAnchors (components, selfId) {
|
let modules = components.map(item => {
|
if (item.uuid === selfId) {
|
return {
|
children: null
|
}
|
} else if (item.type === 'tabs') {
|
let _item = {
|
type: 'tabs',
|
value: item.uuid,
|
label: item.name,
|
children: item.subtabs.map(f_tab => {
|
let subItem = {
|
type: 'tab',
|
value: f_tab.uuid,
|
label: f_tab.label,
|
children: this.getSubModules(f_tab.components, selfId)
|
}
|
|
if (!subItem.children || subItem.children.length === 0) {
|
return {children: null}
|
}
|
return subItem
|
})
|
}
|
|
_item.children = _item.children.filter(t => t.children !== null)
|
|
if (_item.children.length === 0) {
|
return {children: null}
|
}
|
|
return _item
|
} else if (item.type === 'group') {
|
let _item = {
|
value: item.uuid,
|
label: item.name,
|
children: item.components.map(f_tab => {
|
if (f_tab.uuid === selfId) {
|
return {
|
children: null
|
}
|
} else if (f_tab.format) {
|
return {
|
value: f_tab.uuid,
|
label: f_tab.name
|
}
|
}
|
return {
|
children: null
|
}
|
})
|
}
|
|
_item.children = _item.children.filter(t => t.children !== null)
|
|
if (_item.children.length === 0) {
|
return {children: null}
|
}
|
|
return _item
|
} else if (!['login', 'navbar', 'topbar', 'tabs', 'search', 'group', 'balcony'].includes(item.type)) { // 数据格式，存在数据源
|
return {
|
value: item.uuid,
|
label: item.name
|
}
|
} else {
|
return {
|
children: null
|
}
|
}
|
})
|
|
modules = modules.filter(mod => mod.children !== null)
|
|
if (modules.length === 0) {
|
return null
|
}
|
return modules
|
}
|
|
/**
|
* @description 获取指定组件
|
* @return {String} 组件id
|
*/
|
static getComponent (Id) {
|
let interfaces = window.GLOB.customMenu.interfaces
|
let components = window.GLOB.customMenu.components
|
let cell = null
|
|
let mapComponents = (components = []) => {
|
components.forEach(item => {
|
if (item.uuid === Id) {
|
cell = item
|
}else if (item.type === 'tabs') {
|
item.subtabs.forEach(f_tab => {
|
mapComponents(f_tab.components)
|
})
|
} else if (item.type === 'group') {
|
mapComponents(item.components)
|
}
|
})
|
}
|
|
mapComponents(components)
|
|
if (!cell && interfaces) {
|
interfaces.forEach(m => {
|
if (m.uuid === Id && m.status === 'true') {
|
cell = m
|
}
|
})
|
}
|
|
return cell
|
}
|
|
/**
|
* @description 获取上级模块
|
* @return {String} selfId 当前组件id
|
*/
|
static getSupModules (components, selfId, interfaces) {
|
let modules = []
|
components.forEach(item => {
|
if (item.uuid === selfId) {
|
|
} else if (item.switchable) { // 数据可切换
|
let disabled = false
|
if (item.type === 'card') {
|
disabled = item.wrap.cardType === ''
|
} else if (item.type === 'table') {
|
disabled = item.wrap.tableType === ''
|
}
|
modules.push({
|
value: item.uuid,
|
label: item.name,
|
disabled: disabled
|
})
|
} else if (item.type === 'form') { // 数据格式，存在数据源
|
modules.push({
|
value: item.uuid,
|
label: item.name
|
})
|
} else if (item.type === 'tabs') {
|
if (item.subtype === 'tabletabs') {
|
item.subtabs.forEach(tab => {
|
if (tab.components[0].uuid === selfId) return
|
|
modules.push({
|
value: tab.components[0].uuid,
|
label: tab.label,
|
disabled: tab.components[0].wrap.tableType === ''
|
})
|
})
|
} else {
|
let _item = {
|
value: item.uuid,
|
label: item.name,
|
children: item.subtabs.map(f_tab => {
|
let subItem = {
|
value: f_tab.uuid,
|
label: f_tab.label,
|
children: this.getSupModules(f_tab.components, selfId)
|
}
|
|
if (subItem.children.length === 0) {
|
return {children: null}
|
}
|
return subItem
|
})
|
}
|
|
_item.children = _item.children.filter(t => t.children !== null)
|
|
if (_item.children.length > 0) {
|
modules.push(_item)
|
}
|
}
|
} else if (item.type === 'group') {
|
let _item = {
|
value: item.uuid,
|
label: item.name,
|
children: item.components.map(f_tab => {
|
if (f_tab.uuid === selfId) {
|
return {
|
children: null
|
}
|
} else if (f_tab.switchable) {
|
let disabled = false
|
if (f_tab.type === 'card') {
|
disabled = f_tab.wrap.cardType === ''
|
} else if (f_tab.type === 'table') {
|
disabled = f_tab.wrap.tableType === ''
|
}
|
return {
|
value: f_tab.uuid,
|
label: f_tab.name,
|
disabled: disabled
|
}
|
}
|
return {
|
children: null
|
}
|
})
|
}
|
|
_item.children = _item.children.filter(t => t.children !== null)
|
|
if (_item.children.length > 0) {
|
modules.push(_item)
|
}
|
}
|
})
|
|
if (interfaces && interfaces.length > 0) {
|
interfaces.forEach(item => {
|
if (item.uuid === selfId) return
|
modules.push({
|
value: item.uuid,
|
label: item.name
|
})
|
})
|
}
|
|
return modules
|
}
|
|
/**
|
* @description 获取上级模块
|
* @return {String} selfId 当前组件id
|
*/
|
static checkSupModules (modules, supId) {
|
let has = false
|
|
let check = (list) => {
|
list.forEach(m => {
|
if (has) return
|
if (supId === m.value) {
|
has = true
|
return
|
}
|
if (m.children) {
|
check(m.children)
|
}
|
})
|
}
|
|
check(modules)
|
|
return has
|
}
|
|
/**
|
* @description 生成32位uuid string + 时间
|
* @return {String} uuid
|
*/
|
static getuuid () {
|
let uuid = []
|
let timestamp = new Date().getTime()
|
let _options = '0123456789abcdefghigklmnopqrstuv'
|
for (let i = 0; i < 19; i++) {
|
uuid.push(_options.substr(Math.floor(Math.random() * 0x20), 1))
|
}
|
uuid = timestamp + uuid.join('')
|
return uuid
|
}
|
|
/**
|
* @description 重置菜单配置，页面整体复制
|
* @return {String} components 配置信息
|
*/
|
static resetConfig = (components, commonId, clear = false) => {
|
return components.map(item => {
|
if (item.type === 'navbar') {
|
return item
|
}
|
|
if (item.subtype === 'tablecard') { // 兼容
|
item.type = 'card'
|
}
|
|
item.uuid = md5(commonId + item.uuid)
|
|
if (item.type === 'tabs') {
|
item.subtabs.forEach(tab => {
|
tab.uuid = md5(commonId + tab.uuid)
|
|
tab.components = this.resetConfig(tab.components, commonId, clear)
|
})
|
} else if (item.type === 'group') {
|
item.components = this.resetConfig(item.components, commonId, clear)
|
} else if (item.type === 'menubar') {
|
item.subMenus = item.subMenus.map(cell => {
|
cell.uuid = this.getuuid()
|
if (clear && cell.setting.type === 'linkmenu') {
|
cell.setting.type = 'menu'
|
cell.setting.linkMenuId = ''
|
}
|
return cell
|
})
|
} else if (['card', 'carousel', 'timeline'].includes(item.type)) {
|
if (item.wrap.datatype === 'public' && item.wrap.publicId) {
|
item.wrap.publicId = md5(commonId + item.wrap.publicId)
|
}
|
if (item.wrap.autoExec) {
|
item.wrap.autoExec = md5(commonId + item.wrap.autoExec)
|
}
|
|
if (item.supNodes && item.supNodes.length > 0) {
|
item.supNodes = item.supNodes.map(cell => {
|
cell.nodes = cell.nodes.map(n => md5(commonId + n))
|
cell.componentId = cell.nodes[cell.nodes.length - 1]
|
|
return cell
|
})
|
}
|
|
item.subcards.forEach(card => {
|
card.uuid = this.getuuid()
|
|
if (clear) {
|
if (card.setting.click === 'menu') {
|
card.setting.click = ''
|
card.setting.menu = ''
|
} else if (card.setting.click === 'menus') {
|
card.setting.click = ''
|
card.setting.menuType = ''
|
delete card.menus
|
}
|
}
|
|
if (card.setting.click === 'button' && card.setting.linkbtn) {
|
card.setting.linkbtn = md5(commonId + card.setting.linkbtn)
|
}
|
|
if (card.elements) {
|
card.elements = card.elements.map(cell => {
|
if (cell.eleType === 'button') {
|
cell.uuid = md5(commonId + cell.uuid)
|
this.resetBtn(cell, commonId, clear)
|
} else {
|
cell.uuid = this.getuuid()
|
}
|
|
return cell
|
})
|
}
|
if (card.backElements) {
|
card.backElements = card.backElements.map(cell => {
|
if (cell.eleType === 'button') {
|
cell.uuid = md5(commonId + cell.uuid)
|
this.resetBtn(cell, commonId, clear)
|
} else {
|
cell.uuid = this.getuuid()
|
}
|
|
return cell
|
})
|
}
|
})
|
} else if (item.type === 'balcony') {
|
if (item.wrap.datatype === 'public' && item.wrap.publicId) {
|
item.wrap.publicId = md5(commonId + item.wrap.publicId)
|
}
|
if (item.wrap.linkbtn) {
|
item.wrap.linkbtn = md5(commonId + item.wrap.linkbtn)
|
}
|
if (item.elements) {
|
item.elements = item.elements.map(cell => {
|
if (cell.eleType === 'button') {
|
cell.uuid = md5(commonId + cell.uuid)
|
this.resetBtn(cell, commonId, clear)
|
} else {
|
cell.uuid = this.getuuid()
|
}
|
|
return cell
|
})
|
}
|
} else if (item.type === 'table') {
|
if (item.supNodes && item.supNodes.length > 0) {
|
item.supNodes = item.supNodes.map(cell => {
|
cell.nodes = cell.nodes.map(n => md5(commonId + n))
|
cell.componentId = cell.nodes[cell.nodes.length - 1]
|
|
return cell
|
})
|
}
|
|
let loopCol = (cols) => {
|
return cols.map(col => {
|
if (col.type === 'action') {
|
col.type = 'custom'
|
}
|
|
col.uuid = md5(commonId + col.uuid)
|
|
if (col.type === 'colspan' && col.subcols) {
|
col.subcols = loopCol(col.subcols)
|
} else if (col.type === 'custom' && col.elements) {
|
col.elements = col.elements.map(cell => {
|
cell.uuid = md5(commonId + cell.uuid)
|
|
if (cell.eleType === 'button') {
|
this.resetBtn(cell, commonId, clear)
|
}
|
|
return cell
|
})
|
} else if (col.editable === 'true' && col.enter && col.enter !== '$next' && col.enter !== '$sub') {
|
if (/\$next_/.test(col.enter)) {
|
col.enter = '$next_' + md5(commonId + col.enter.split('_')[1])
|
} else {
|
col.enter = md5(commonId + col.enter)
|
}
|
}
|
|
return col
|
})
|
}
|
|
item.cols = loopCol(item.cols || [])
|
|
if (item.colsCtrls) {
|
item.colsCtrls = item.colsCtrls.map(col => {
|
col.cols = col.cols.map(f => md5(commonId + f))
|
return col
|
})
|
}
|
} else if (item.type === 'form') {
|
if (item.wrap.datatype === 'public' && item.wrap.publicId) {
|
item.wrap.publicId = md5(commonId + item.wrap.publicId)
|
}
|
item.subcards = item.subcards.map(cell => {
|
cell.uuid = this.getuuid()
|
|
cell.fields = cell.fields.map(m => {
|
m.uuid = this.getuuid()
|
|
return m
|
})
|
|
if (cell.subButton) {
|
this.resetBtn(cell.subButton, commonId, clear)
|
}
|
|
return cell
|
})
|
} else if (item.type === 'login') {
|
if (clear) {
|
item.wrap.linkmenu = ''
|
}
|
}
|
|
if (item.btnlog) {
|
item.btnlog = null
|
}
|
|
if (item.action) {
|
item.action = item.action.map(cell => {
|
cell.uuid = md5(commonId + cell.uuid)
|
|
this.resetBtn(cell, commonId, clear)
|
|
return cell
|
})
|
}
|
if (item.type === 'topbar') {
|
if (item.search && item.search.fields) {
|
item.search.fields = item.search.fields.map(cell => {
|
cell.uuid = this.getuuid()
|
return cell
|
})
|
}
|
if (item.search && item.search.groups) {
|
item.search.groups = item.search.groups.map(cell => {
|
cell.uuid = this.getuuid()
|
cell.fields = cell.fields.map(m => {
|
m.uuid = this.getuuid()
|
return m
|
})
|
return cell
|
})
|
}
|
if (clear && item.wrap.menus) {
|
item.wrap.menus = []
|
}
|
} else if (item.search) {
|
item.search = item.search.map(cell => {
|
cell.uuid = this.getuuid()
|
return cell
|
})
|
}
|
if (item.columns) {
|
item.columns = item.columns.map(cell => {
|
cell.uuid = this.getuuid()
|
return cell
|
})
|
}
|
|
if (item.setting && item.setting.supModule && item.setting.supModule[0] !== 'empty' && item.setting.supModule[0] !== 'preview') {
|
item.setting.supModule = item.setting.supModule.map(c => {
|
return md5(commonId + c)
|
})
|
if (item.wrap && item.wrap.supModule) {
|
item.wrap.supModule = item.setting.supModule
|
}
|
}
|
|
if (item.wrap && item.wrap.doubleClick) {
|
item.wrap.doubleClick = md5(commonId + item.wrap.doubleClick)
|
}
|
|
return item
|
})
|
}
|
|
/**
|
* @description 按钮重置
|
*/
|
static resetBtn (btn, commonId, clear = false) {
|
if (btn.OpenType === 'pop' || (btn.OpenType === 'funcbutton' && btn.execMode === 'pop')) {
|
if (btn.modal && btn.modal.fields && btn.modal.fields.length > 0) {
|
btn.modal.fields = btn.modal.fields.map(m => {
|
m.uuid = this.getuuid()
|
return m
|
})
|
}
|
}
|
|
if (clear) {
|
if (btn.pageTemplate === 'linkpage') {
|
btn.pageTemplate = ''
|
}
|
delete btn.linkmenu
|
delete btn.openmenu
|
delete btn.refreshTab
|
}
|
|
if (btn.switchTab && btn.switchTab.length > 0) {
|
btn.switchTab = btn.switchTab.map(m => md5(commonId + m))
|
}
|
if (btn.anchors && btn.anchors.length > 0) {
|
btn.anchors = btn.anchors.map(m => md5(commonId + m))
|
}
|
if (btn.syncComponent && btn.syncComponent[0] === 'multiComponent' && btn.syncComponents) {
|
if (btn.syncComponents[0] && Array.isArray(btn.syncComponents[0])) {
|
btn.syncComponents = btn.syncComponents.map((item, i) => {
|
return {
|
syncComId: item,
|
label: '',
|
uuid: 'fixed' + i
|
}
|
})
|
}
|
btn.syncComponents = btn.syncComponents.map(m => {
|
m.syncComId = m.syncComId.map(n => {
|
if (/\$focus/.test(n)) {
|
return md5(commonId + n.split('$')[0]) + '$' + n.split('$')[1]
|
}
|
|
return md5(commonId + n)
|
})
|
return m
|
})
|
} else if (btn.syncComponent && btn.syncComponent.length > 0) {
|
btn.syncComponent = btn.syncComponent.map(m => {
|
if (/\$focus/.test(m)) {
|
return md5(commonId + m.split('$')[0]) + '$' + m.split('$')[1]
|
}
|
|
return md5(commonId + m)
|
})
|
}
|
|
if (btn.OpenType === 'popview' && btn.config && btn.config.components) {
|
btn.config.components = this.resetConfig(btn.config.components, commonId)
|
}
|
}
|
|
/**
|
* @description 组件名加后缀
|
*/
|
static getSignName () {
|
let name = []
|
let _options = 'abcdefghigklmnopqrstuvwxyz'
|
for (let i = 0; i < 3; i++) {
|
name.push(_options.substr(Math.floor(Math.random() * 26), 1))
|
}
|
return (Math.floor(Math.random()*10) + name.join('')).toUpperCase()
|
}
|
|
/**
|
* @description 重置组件配置
|
* @return {String} item 组件信息
|
*/
|
static resetComponentConfig = (item, appType, commonId) => {
|
if (item.subtype === 'tablecard') { // 兼容
|
item.type = 'card'
|
}
|
|
// 重置组件名称
|
let sign = this.getSignName()
|
if (item.plot) { // 图表
|
item.plot.name = (item.plot.name || '') + sign
|
item.name = item.plot.name
|
} else if (item.wrap) { // 通用
|
item.wrap.name = (item.wrap.name || '') + sign
|
item.name = item.wrap.name
|
} else if (item.setting) { // 分组、标签页等
|
item.setting.name = (item.setting.name || '') + sign
|
item.name = item.setting.name
|
}
|
|
if (item.columns) {
|
item.columns = item.columns.map(cell => {
|
cell.uuid = this.getuuid()
|
return cell
|
})
|
}
|
|
if (item.type === 'navbar') {
|
if (appType === 'mob') {
|
item.menus.forEach(menu => {
|
menu.MenuID = this.getuuid()
|
})
|
item.wrap.MenuNo = item.wrap.MenuNo + sign
|
}
|
return item
|
} else if (item.type === 'menubar') {
|
item.subMenus = item.subMenus.map(cell => {
|
cell.uuid = this.getuuid()
|
return cell
|
})
|
} else if (['card', 'carousel', 'timeline'].includes(item.type)) {
|
if (item.wrap.autoExec) {
|
item.wrap.autoExec = md5(commonId + item.wrap.autoExec)
|
}
|
|
if (appType !== 'mob') {
|
if (item.wrap.pagestyle === 'slide') {
|
item.wrap.pagestyle = 'page'
|
}
|
} else {
|
if (item.wrap.pagestyle === 'switch') {
|
item.wrap.pagestyle = 'page'
|
}
|
}
|
|
item.subcards.forEach(card => {
|
card.uuid = this.getuuid()
|
|
if (card.setting.click === 'button' && card.setting.linkbtn) {
|
card.setting.linkbtn = md5(commonId + card.setting.linkbtn)
|
}
|
|
if (card.elements) {
|
if (sessionStorage.getItem('editMenuType') === 'popview') {
|
card.elements = card.elements.filter(b => b.OpenType !== 'popview' && b.OpenType !== 'funcbutton')
|
}
|
card.elements = card.elements.map(cell => {
|
if (cell.eleType === 'button') {
|
cell.uuid = md5(commonId + cell.uuid)
|
|
this.resetBtn(cell, commonId)
|
} else {
|
cell.uuid = this.getuuid()
|
}
|
return cell
|
})
|
}
|
if (card.backElements) {
|
if (sessionStorage.getItem('editMenuType') === 'popview') {
|
card.elements = card.elements.filter(b => b.OpenType !== 'popview' && b.OpenType !== 'funcbutton')
|
}
|
card.backElements = card.backElements.map(cell => {
|
if (cell.eleType === 'button') {
|
cell.uuid = md5(commonId + cell.uuid)
|
|
this.resetBtn(cell, commonId)
|
} else {
|
cell.uuid = this.getuuid()
|
}
|
return cell
|
})
|
}
|
})
|
} else if (item.type === 'balcony') {
|
if (item.elements) {
|
if (sessionStorage.getItem('editMenuType') === 'popview') {
|
item.elements = item.elements.filter(b => b.OpenType !== 'popview' && b.OpenType !== 'funcbutton')
|
}
|
if (item.wrap.linkbtn) {
|
item.wrap.linkbtn = md5(commonId + item.wrap.linkbtn)
|
}
|
item.elements = item.elements.map(cell => {
|
if (cell.eleType === 'button') {
|
cell.uuid = md5(commonId + cell.uuid)
|
|
this.resetBtn(cell, commonId)
|
} else {
|
cell.uuid = this.getuuid()
|
}
|
return cell
|
})
|
}
|
} else if (item.type === 'table') {
|
let loopCol = (cols) => {
|
return cols.map(col => {
|
if (col.type === 'action') {
|
col.type = 'custom'
|
}
|
|
col.uuid = md5(commonId + col.uuid)
|
|
if (col.type === 'colspan' && col.subcols) {
|
col.subcols = loopCol(col.subcols)
|
} else if (col.type === 'custom' && col.elements) {
|
if (sessionStorage.getItem('editMenuType') === 'popview') {
|
col.elements = col.elements.filter(c => c.eleType !== 'button' || (c.OpenType !== 'popview' && c.OpenType !== 'funcbutton'))
|
}
|
col.elements = col.elements.map(cell => {
|
cell.uuid = md5(commonId + cell.uuid)
|
if (cell.eleType === 'button') {
|
this.resetBtn(cell, commonId)
|
}
|
return cell
|
})
|
} else if (col.editable === 'true' && col.enter && col.enter !== '$next' && col.enter !== '$sub') { // 可编辑表
|
if (/\$next_/.test(col.enter)) {
|
col.enter = '$next_' + md5(commonId + col.enter.split('_')[1])
|
} else {
|
col.enter = md5(commonId + col.enter)
|
}
|
}
|
|
return col
|
})
|
}
|
|
item.cols = loopCol(item.cols || [])
|
|
if (item.colsCtrls) {
|
item.colsCtrls = item.colsCtrls.map(col => {
|
col.cols = col.cols.map(f => md5(commonId + f))
|
return col
|
})
|
}
|
} else if (item.type === 'form') {
|
item.subcards = item.subcards.map(cell => {
|
cell.uuid = this.getuuid()
|
|
cell.fields = cell.fields.map(m => {
|
m.uuid = this.getuuid()
|
|
return m
|
})
|
return cell
|
})
|
}
|
|
delete item.btnlog
|
|
if (item.action) {
|
if (sessionStorage.getItem('editMenuType') === 'popview') {
|
item.action = item.action.filter(c => c.OpenType !== 'popview' && c.OpenType !== 'funcbutton')
|
}
|
item.action = item.action.map(cell => {
|
cell.uuid = md5(commonId + cell.uuid)
|
this.resetBtn(cell, commonId)
|
|
return cell
|
})
|
}
|
if (item.type === 'topbar') {
|
item.wrap.name = ''
|
item.name = ''
|
if (item.search && item.search.fields) {
|
item.search.fields = item.search.fields.map(cell => {
|
cell.uuid = this.getuuid()
|
return cell
|
})
|
}
|
if (item.search && item.search.groups) {
|
item.search.groups = item.search.groups.map(cell => {
|
cell.uuid = this.getuuid()
|
cell.fields = cell.fields.map(m => {
|
m.uuid = this.getuuid()
|
return m
|
})
|
return cell
|
})
|
}
|
} else if (item.search) {
|
item.search = item.search.map(cell => {
|
cell.uuid = this.getuuid()
|
return cell
|
})
|
}
|
|
if (item.wrap && item.wrap.doubleClick) {
|
item.wrap.doubleClick = md5(commonId + item.wrap.doubleClick)
|
}
|
|
return item
|
}
|
}
|
|
/**
|
* @description 获取可关联模块
|
*/
|
export function getLinkModules (components) {
|
let modules = components.map(item => {
|
if ((item.type === 'card' && item.subtype === 'datacard') || (item.type === 'table' && item.subtype === 'normaltable')) {
|
return {
|
value: item.uuid,
|
label: item.name
|
}
|
} else if (item.type === 'tabs') {
|
let _item = {
|
value: item.uuid,
|
label: item.name,
|
children: item.subtabs.map(f_tab => {
|
let subItem = {
|
value: f_tab.uuid,
|
label: f_tab.label,
|
children: getLinkModules(f_tab.components)
|
}
|
|
if (!subItem.children || subItem.children.length === 0) {
|
return {children: null}
|
}
|
return subItem
|
})
|
}
|
|
_item.children = _item.children.filter(t => t.children !== null)
|
|
if (_item.children.length === 0) {
|
return {children: null}
|
}
|
|
return _item
|
} else if (item.type === 'group') {
|
let _item = {
|
value: item.uuid,
|
label: item.name,
|
children: item.components.map(f_tab => {
|
if ((f_tab.type === 'card' && f_tab.subtype === 'datacard') || (f_tab.type === 'table' && f_tab.subtype === 'normaltable')) {
|
return {
|
value: f_tab.uuid,
|
label: f_tab.name
|
}
|
}
|
return {
|
children: null
|
}
|
})
|
}
|
|
_item.children = _item.children.filter(t => t.children !== null)
|
|
if (_item.children.length === 0) {
|
return {children: null}
|
}
|
|
return _item
|
} else {
|
return {
|
children: null
|
}
|
}
|
})
|
|
modules = modules.filter(mod => mod.children !== null)
|
|
if (modules.length === 0) {
|
return null
|
}
|
return modules
|
}
|
|
/**
|
* @description 获取公共数据源
|
*/
|
export function getInterfaces () {
|
let menu = window.GLOB.customMenu
|
|
let interfaces = []
|
if (menu.interfaces) {
|
menu.interfaces.forEach(item => {
|
if (item.status === 'true') {
|
interfaces.push({
|
value: item.uuid,
|
label: item.name,
|
columns: JSON.parse(JSON.stringify(item.columns))
|
})
|
}
|
})
|
}
|
|
let mapComponents = (components = []) => {
|
components.forEach(item => {
|
if (item.type === 'card' && item.subtype === 'datacard') {
|
interfaces.push({
|
value: item.uuid,
|
label: item.name + '（数据卡）',
|
columns: JSON.parse(JSON.stringify(item.columns))
|
})
|
} else if (item.type === 'table' && item.subtype === 'normaltable') {
|
interfaces.push({
|
value: item.uuid,
|
label: item.name + '（常用表）',
|
columns: JSON.parse(JSON.stringify(item.columns))
|
})
|
} else if (item.type === 'tabs') {
|
item.subtabs.forEach(f_tab => {
|
mapComponents(f_tab.components)
|
})
|
} else if (item.type === 'group') {
|
mapComponents(item.components)
|
}
|
})
|
}
|
|
mapComponents(menu.components)
|
|
return interfaces
|
}
|
|
/**
|
* @description 格式化搜索条件
|
*/
|
export function formatSearch (searches) {
|
if (!searches) return []
|
|
let newsearches = []
|
searches.forEach(item => {
|
if (!item.field) return
|
|
if (item.type === 'group') {
|
newsearches.push({
|
key: item.field,
|
match: '',
|
type: item.type,
|
value: 'customized',
|
forbid: true
|
}, {
|
key: item.datefield,
|
match: 'between',
|
type: 'daterange',
|
value: '1949-10-01 00:00:00.000,1949-10-02 00:00:00.000',
|
forbid: item.query === 'false'
|
})
|
} else {
|
let value = '0'
|
let type = item.type
|
|
if (item.type === 'date') {
|
value = '1949-10-01 00:00:00.000'
|
} else if (item.type === 'datemonth') {
|
if (item.match === '=') {
|
value = '1949-10'
|
} else {
|
value = '1949-10-01 00:00:00.000,1949-10-02 00:00:00.000'
|
}
|
} else if (item.type === 'dateweek') {
|
value = '1949-10-01 00:00:00.000,1949-10-02 00:00:00.000'
|
} else if (item.type === 'daterange') {
|
value = '1949-10-01 00:00:00.000,1949-10-02 00:00:00.000'
|
} else if (item.type === 'range') {
|
value = item.initval || `${item.minValue || '-999999999'},${item.maxValue || '999999999'}`
|
} else if (item.type === 'multiselect' || (item.type === 'checkcard' && item.multiple === 'true')) {
|
type = 'multi'
|
} else {
|
value = item.initval || '0'
|
}
|
|
newsearches.push({
|
key: item.field,
|
match: item.match,
|
type: type,
|
value: value,
|
precision: item.precision || 'day',
|
forbid: item.query === 'false'
|
})
|
}
|
})
|
|
return newsearches
|
}
|
|
/**
|
* @description 拼接where条件
|
*/
|
export function joinMainSearchkey (searches) {
|
if (!searches || searches.length === 0) return ''
|
|
let searchText = []
|
searches.forEach(item => {
|
if (item.forbid) return
|
|
if (item.type === 'text' || item.type === 'select') { // 综合搜索，文本或下拉，所有字段拼接
|
let str = item.match === 'like' || item.match === 'not like' ? '%' : ''
|
let fields = item.key.split(',').map(field => {
|
return field + ' ' + item.match + ' \'' + str + item.value + str + '\''
|
})
|
|
searchText.push('(' + fields.join(' OR ') + ')')
|
} else if (item.type === 'checkcard') {
|
let str = item.match === 'like' || item.match === 'not like' ? '%' : ''
|
|
searchText.push('(' + item.key + ' ' + item.match + ' \'' + str + item.value + str + '\')')
|
} else if (item.type === 'multi') {
|
searchText.push(`('${item.value}' ${item.match} '%'+${item.key}+'%')`)
|
} else if (item.type === 'date') {
|
searchText.push('(' + item.key + ' ' + item.match + ' \'' + item.value + '\')')
|
} else if (item.type === 'dateweek') {
|
let val = item.value.split(',')
|
searchText.push('(' + item.key + ' >= \'' + val[0] + '\' AND ' + item.key + ' < \'' + val[1] + '\')')
|
} else if (item.type === 'range') {
|
let val = item.value.split(',')
|
searchText.push('(' + item.key + ' >= ' + (val[0] || -999999999) + ' AND ' + item.key + ' <= ' + (val[1] || 999999999) + ')')
|
} else if (item.type === 'datemonth') {
|
if (item.match === '=') {
|
searchText.push('(' + item.key + ' = \'' + item.value + '\')')
|
} else {
|
let val = item.value.split(',')
|
searchText.push('(' + item.key + ' >= \'' + val[0] + '\' AND ' + item.key + ' < \'' + val[1] + '\')')
|
}
|
} else if (item.type === 'daterange') {
|
let val = item.value.split(',')
|
|
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 + ' >= \'' + val[0] + '\' AND ' + _ekey + ' < \'' + val[1] + '\')')
|
} else {
|
searchText.push('(' + item.key + ' ' + item.match + ' \'' + item.value + '\')')
|
}
|
})
|
|
return searchText.length > 0 ? 'where ' + searchText.join(' AND ') : ''
|
}
|
|
/**
|
* @description 获取搜索正则替换
|
*/
|
export function getSearchRegs (searches) {
|
if (!searches) return []
|
|
let options = []
|
let fieldmap = new Map()
|
searches.forEach(item => {
|
if (item.type === 'date') {
|
if (fieldmap.has(item.key)) {
|
options.push({
|
reg: new RegExp('@' + item.key + '1@', 'ig'),
|
value: `'${item.value}'`
|
})
|
} else {
|
fieldmap.set(item.key, true)
|
options.push({
|
reg: new RegExp('@' + item.key + '@', 'ig'),
|
value: `'${item.value}'`
|
})
|
}
|
|
} else if (item.type === 'dateweek') {
|
let val = item.value.split(',')
|
options.push({
|
reg: new RegExp('@' + item.key + '@', 'ig'),
|
value: `'${val[0]}'`
|
}, {
|
reg: new RegExp('@' + item.key + '1@', 'ig'),
|
value: `'${val[1]}'`
|
})
|
} else if (item.type === 'range') {
|
let val = item.value.split(',')
|
options.push({
|
reg: new RegExp('@' + item.key + '@', 'ig'),
|
value: `${val[0] || -999999999}`
|
}, {
|
reg: new RegExp('@' + item.key + '1@', 'ig'),
|
value: `${val[1] || 999999999}`
|
})
|
} else if (item.type === 'datemonth') {
|
if (item.match === '=') {
|
options.push({
|
reg: new RegExp('@' + item.key + '@', 'ig'),
|
value: `'${item.value}'`
|
})
|
} else {
|
let val = item.value.split(',')
|
options.push({
|
reg: new RegExp('@' + item.key + '@', 'ig'),
|
value: `'${val[0]}'`
|
}, {
|
reg: new RegExp('@' + item.key + '1@', 'ig'),
|
value: `'${val[1]}'`
|
})
|
}
|
} else if (item.type === 'daterange') {
|
let val = item.value.split(',')
|
let _skey = item.key
|
let _ekey = item.key + '1'
|
|
if (/,/.test(item.key)) {
|
_skey = item.key.split(',')[0]
|
_ekey = item.key.split(',')[1]
|
}
|
|
options.push({
|
reg: new RegExp('@' + _skey + '@', 'ig'),
|
value: `'${val[0]}'`
|
}, {
|
reg: new RegExp('@' + _ekey + '@', 'ig'),
|
value: `'${val[1]}'`
|
})
|
} else if (item.type === 'text' || item.type === 'select') {
|
item.key.split(',').forEach(field => {
|
options.push({
|
reg: new RegExp('@' + field + '@', 'ig'),
|
value: `'${item.value}'`
|
})
|
})
|
} else {
|
options.push({
|
reg: new RegExp('@' + item.key + '@', 'ig'),
|
value: `'${item.value}'`
|
})
|
}
|
})
|
|
return options
|
}
|
|
/**
|
* @description 获取搜索字段
|
*/
|
export function getSearchFields (searches) {
|
if (!searches) return ''
|
|
let _usefulFields = []
|
searches.forEach(item => {
|
let key = item.key || item.field
|
|
if (!key) return
|
|
if (item.type === 'group') {
|
_usefulFields.push(key)
|
if (item.datefield) {
|
_usefulFields.push(item.datefield)
|
_usefulFields.push(item.datefield + '1')
|
}
|
} else if (item.type === 'dateweek') {
|
_usefulFields.push(key)
|
_usefulFields.push(key + '1')
|
} else if (item.type === 'datemonth') {
|
if (item.match === '=') {
|
_usefulFields.push(key)
|
} else {
|
_usefulFields.push(key)
|
_usefulFields.push(key + '1')
|
}
|
} else if (item.type === 'range') {
|
_usefulFields.push(key)
|
_usefulFields.push(key + '1')
|
} else if (item.type === 'daterange') {
|
let _skey = key
|
let _ekey = key + '1'
|
|
if (/,/.test(key)) {
|
_skey = key.split(',')[0]
|
_ekey = key.split(',')[1]
|
}
|
_usefulFields.push(_skey)
|
_usefulFields.push(_ekey)
|
} else if (item.type === 'date' && _usefulFields.includes(key)) {
|
_usefulFields.push(key + '1')
|
} else {
|
_usefulFields.push(key)
|
}
|
})
|
|
return _usefulFields.join(', ')
|
}
|
|
/**
|
* @description 重置移动端style
|
* @return {Object} style
|
*/
|
export function resetStyle (style) {
|
if (!style) return {}
|
|
let _style = JSON.stringify(style)
|
_style = _style.replace(/@mywebsite@\//ig, window.GLOB.baseurl)
|
|
if (sessionStorage.getItem('appType') === 'mob') {
|
// scaleview
|
_style = _style.replace(/\d+vw/ig, (word) => {
|
return parseFloat(word) * (window.GLOB.winWidth || 420) / 100 + 'px'
|
// return parseFloat(word) * 350 / 100 + 'px'
|
}).replace(/\d+vh/ig, (word) => {
|
return parseFloat(word) * (window.GLOB.winHeight || 738) / 100 + 'px'
|
// return parseFloat(word) * 615 / 100 + 'px'
|
})
|
}
|
|
return JSON.parse(_style)
|
}
|
|
/**
|
* @description 获取图表高度
|
*/
|
export function getHeight (val) {
|
if (typeof(val) === 'string') {
|
if (val.indexOf('px') > -1) {
|
val = parseFloat(val)
|
} else if (val.indexOf('vw') > -1) {
|
val = parseFloat(val)
|
val = document.body.clientWidth * val / 100
|
} else if (val.indexOf('vh') > -1) {
|
val = parseFloat(val)
|
val = document.body.clientHeight * val / 100
|
}
|
}
|
|
return parseInt(val || 400) - 30
|
}
|
|
/**
|
* @description 获取表名
|
*/
|
export function getTables (config, pops) {
|
let tables = []
|
let cuts = []
|
let cutreg = /(from|update|insert\s+into)\s+(@db@)?[a-z0-9_]+/ig
|
let trimreg = /(from|update|insert\s+into)\s+(@db@)?/ig
|
|
if (config.setting && (!config.wrap || !config.wrap.datatype || config.wrap.datatype === 'dynamic')) {
|
if (config.setting.interType === 'system') {
|
if (config.setting.execute !== 'false' && config.setting.dataresource) {
|
let tbs = config.setting.dataresource.match(cutreg)
|
tbs && cuts.push(...tbs)
|
}
|
config.scripts && config.scripts.forEach(script => {
|
if (script.status === 'false') return
|
let tbs = script.sql.match(cutreg)
|
tbs && cuts.push(...tbs)
|
})
|
} else if (config.setting.tableName) {
|
let tb = config.setting.tableName.replace(/@db@|\s+/ig, '')
|
if (/[a-z_]+/ig.test(tb)) {
|
tables.push(tb)
|
}
|
}
|
}
|
|
config.search && config.search.forEach(cell => {
|
if (cell.resourceType === '1' && cell.dataSource) {
|
let tbs = cell.dataSource.match(cutreg)
|
tbs && cuts.push(...tbs)
|
}
|
})
|
|
let action = []
|
|
if (config.type === 'form') {
|
config.subcards.forEach(item => {
|
action.push(item.subButton)
|
item.fields && item.fields.forEach(cell => {
|
if (cell.resourceType === '1' && cell.dataSource) {
|
let tbs = cell.dataSource.match(cutreg)
|
tbs && cuts.push(...tbs)
|
}
|
})
|
})
|
} else if (config.subcards) {
|
config.subcards.forEach(item => {
|
item.elements.forEach(cell => {
|
if (cell.eleType !== 'button') return
|
if (['form', 'pop', 'prompt', 'exec', 'excelIn', 'excelOut'].includes(cell.OpenType)) {
|
action.push(cell)
|
} else if (cell.OpenType === 'funcbutton' && cell.funcType === 'print' && cell.verify) {
|
action.push(cell)
|
} else if (cell.OpenType === 'popview') {
|
if (pops) {
|
pops.push({...cell, parentId: config.uuid})
|
} else if (cell.config && cell.config.$tables) {
|
tables.push(...cell.config.$tables)
|
}
|
}
|
})
|
|
if (item.backElements && item.setting.type === 'multi') {
|
item.backElements.forEach(cell => {
|
if (cell.eleType !== 'button') return
|
if (['form', 'pop', 'prompt', 'exec', 'excelIn', 'excelOut'].includes(cell.OpenType)) {
|
action.push(cell)
|
} else if (cell.OpenType === 'funcbutton' && cell.funcType === 'print' && cell.verify) {
|
action.push(cell)
|
} else if (cell.OpenType === 'popview') {
|
if (pops) {
|
pops.push({...cell, parentId: config.uuid})
|
} else if (cell.config && cell.config.$tables) {
|
tables.push(...cell.config.$tables)
|
}
|
}
|
})
|
}
|
})
|
}
|
|
if (config.cols) {
|
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 (['form', 'pop', 'prompt', 'exec', 'excelIn', 'excelOut'].includes(cell.OpenType)) {
|
action.push(cell)
|
} else if (cell.OpenType === 'funcbutton' && cell.funcType === 'print' && cell.verify) {
|
action.push(cell)
|
} else if (cell.OpenType === 'popview') {
|
if (pops) {
|
pops.push({...cell, parentId: config.uuid})
|
} else if (cell.config && cell.config.$tables) {
|
tables.push(...cell.config.$tables)
|
}
|
}
|
})
|
}
|
})
|
}
|
loopCol(config.cols)
|
}
|
|
config.elements && config.elements.forEach(cell => {
|
if (cell.eleType !== 'button') return
|
if (['form', 'pop', 'prompt', 'exec', 'excelIn', 'excelOut'].includes(cell.OpenType)) {
|
action.push(cell)
|
} else if (cell.OpenType === 'funcbutton' && cell.funcType === 'print' && cell.verify) {
|
action.push(cell)
|
} else if (cell.OpenType === 'popview') {
|
if (pops) {
|
pops.push({...cell, parentId: config.uuid})
|
} else if (cell.config && cell.config.$tables) {
|
tables.push(...cell.config.$tables)
|
}
|
}
|
})
|
|
config.action && config.action.forEach(cell => {
|
if (['pop', 'prompt', 'exec', 'excelIn', 'excelOut'].includes(cell.OpenType)) {
|
action.push(cell)
|
} else if (cell.OpenType === 'funcbutton' && cell.funcType === 'print' && cell.verify) {
|
action.push(cell)
|
} else if (cell.OpenType === 'popview') {
|
if (pops) {
|
pops.push({...cell, parentId: config.uuid})
|
} else if (cell.config && cell.config.$tables) {
|
tables.push(...cell.config.$tables)
|
}
|
}
|
})
|
|
action.forEach(btn => {
|
if (btn.OpenType === 'excelIn') {
|
if (!btn.verify) return
|
if (btn.intertype !== 'system' || btn.verify.default !== 'false') {
|
let tb = btn.sheet.replace(/@db@|\s+/ig, '')
|
if (/[a-z_]+/ig.test(tb)) {
|
tables.push(tb)
|
}
|
}
|
if (btn.intertype === 'system' && btn.verify.scripts) {
|
btn.verify.scripts.forEach(script => {
|
if (script.status === 'false') return
|
let tbs = script.sql.match(cutreg)
|
tbs && cuts.push(...tbs)
|
})
|
}
|
} else if (btn.OpenType === 'funcbutton') {
|
if (btn.intertype !== 'system' || !btn.verify || !btn.verify.setting) return
|
if (btn.verify.dataType === 'custom') {
|
if (btn.verify.setting.defaultSql !== 'false') {
|
let tbs = btn.verify.setting.dataresource.match(cutreg)
|
tbs && cuts.push(...tbs)
|
}
|
btn.verify.scripts && btn.verify.scripts.forEach(script => {
|
if (script.status === 'false') return
|
let tbs = script.sql.match(cutreg)
|
tbs && cuts.push(...tbs)
|
})
|
}
|
} else if (btn.OpenType === 'excelOut') {
|
if (btn.intertype !== 'system' || !btn.verify) return
|
if (btn.verify.dataType === 'custom') {
|
if (btn.verify.defaultSql !== 'false') {
|
let tbs = btn.verify.dataresource.match(cutreg)
|
tbs && cuts.push(...tbs)
|
}
|
btn.verify.scripts && btn.verify.scripts.forEach(script => {
|
if (script.status === 'false') return
|
let tbs = script.sql.match(cutreg)
|
tbs && cuts.push(...tbs)
|
})
|
}
|
if (btn.verify.enable === 'true' && btn.verify.script) {
|
let tbs = btn.verify.script.match(cutreg)
|
tbs && cuts.push(...tbs)
|
}
|
} else {
|
if (btn.OpenType === 'pop' && btn.modal && btn.modal.fields) {
|
btn.modal.fields.forEach(cell => {
|
if (cell.resourceType === '1' && cell.dataSource) {
|
let tbs = cell.dataSource.match(cutreg)
|
tbs && cuts.push(...tbs)
|
}
|
})
|
}
|
if (btn.intertype === 'inner') return
|
if (btn.intertype === 'outer' || btn.intertype === 'custom') {
|
if (btn.procMode === 'system' && btn.verify) {
|
if (btn.verify.default !== 'false' && btn.sql) {
|
let tb = btn.sql.replace(/@db@|\s+/ig, '')
|
if (/[a-z_]+/ig.test(tb)) {
|
tables.push(tb)
|
}
|
}
|
btn.verify.customverifys && btn.verify.customverifys.forEach(script => {
|
if (script.status === 'false') return
|
let tbs = script.sql.match(cutreg)
|
tbs && cuts.push(...tbs)
|
})
|
btn.verify.scripts && btn.verify.scripts.forEach(script => {
|
if (script.status === 'false') return
|
let tbs = script.sql.match(cutreg)
|
tbs && cuts.push(...tbs)
|
})
|
}
|
if (btn.callbackType === 'script' && btn.verify) {
|
btn.verify.cbScripts && btn.verify.cbScripts.forEach(script => {
|
if (script.status === 'false') return
|
let tbs = script.sql.match(cutreg)
|
tbs && cuts.push(...tbs)
|
})
|
}
|
} else if (btn.verify) {
|
if (btn.verify.default !== 'false' && btn.sql) {
|
let tb = btn.sql.replace(/@db@|\s+/ig, '')
|
if (/[a-z_]+/ig.test(tb)) {
|
tables.push(tb)
|
}
|
}
|
btn.verify.customverifys && btn.verify.customverifys.forEach(script => {
|
if (script.status === 'false') return
|
let tbs = script.sql.match(cutreg)
|
tbs && cuts.push(...tbs)
|
})
|
btn.verify.scripts && btn.verify.scripts.forEach(script => {
|
if (script.status === 'false') return
|
let tbs = script.sql.match(cutreg)
|
tbs && cuts.push(...tbs)
|
})
|
}
|
}
|
})
|
|
cuts = cuts.map(item => item.replace(trimreg, ''))
|
tables.push(...cuts)
|
tables = tables.filter(tb => tb && tb !== 'dbo' && tb.length > 1)
|
tables = Array.from(new Set(tables))
|
|
return tables
|
}
|
|
/**
|
* @description 获取接口及函数
|
*/
|
export function getFuncsAndInters (config) {
|
let inters = 'false'
|
|
let filterBtn = (cell) => {
|
if ((cell.intertype === 'outer' && cell.sysInterface !== 'true') || cell.intertype === 'custom') {
|
inters = 'true'
|
}
|
}
|
|
let traversal = (components) => {
|
if (!components || inters === '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.setting && item.setting.interType === 'outer' && item.setting.sysInterface !== 'true') {
|
inters = 'true'
|
}
|
|
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)
|
})
|
}
|
}
|
})
|
}
|
|
if (config.interfaces) {
|
config.interfaces.forEach(item => {
|
if (item.status !== 'true') return
|
if (item.setting && item.setting.interType === 'outer' && item.setting.sysInterface !== 'true') {
|
inters = 'true'
|
}
|
})
|
}
|
|
traversal(config.components)
|
|
return inters
|
}
|
|
/**
|
* @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) {
|
let errors = []
|
let columns = []
|
|
if (card.$c_ds) {
|
columns = card.columns.map(c => c.field)
|
|
if (card.setting.primaryKey && !columns.includes(card.setting.primaryKey)) {
|
let key = card.setting.primaryKey.toLowerCase()
|
columns.forEach(f => {
|
if (f.toLowerCase() === key) {
|
card.setting.primaryKey = f
|
}
|
})
|
}
|
|
if (card.setting.interType === 'system' && card.setting.execute !== 'false' && !card.setting.dataresource) {
|
errors.push({ level: 0, detail: '未设置数据源！'})
|
} else if (card.setting.interType === 'system' && card.setting.execute === 'false' && card.scripts.filter(script => script.status !== 'false').length === 0) {
|
errors.push({ level: 0, detail: '数据源中无可用脚本！'})
|
} else if (!card.setting.primaryKey) {
|
errors.push({ level: 0, detail: '未设置主键！'})
|
} else if (!columns.includes(card.setting.primaryKey)) {
|
errors.push({ level: 0, detail: '主键已失效！'})
|
} else if (card.subtype === 'dualdatacard') { // 双重卡
|
if (!card.setting.subKey) {
|
errors.push({ level: 0, detail: '未设置子表主键！'})
|
} else if (!card.setting.subBID) {
|
errors.push({ level: 0, detail: '未设置子表BID！'})
|
} else if (!card.setting.supModule) {
|
errors.push({ level: 0, detail: '未设置上级组件！'})
|
}
|
} else if ((card.type === 'card' && card.subtype === 'datacard') || card.subtype === 'normaltable') { // 数据卡、table，可能有多上级
|
if (card.wrap.supType !== 'multi' && !card.setting.supModule) {
|
errors.push({ level: 0, detail: '未设置上级组件！'})
|
}
|
} else if (card.type !== 'balcony' && !card.setting.supModule) { // 悬浮框上级组件需单独设置
|
errors.push({ level: 0, detail: '未设置上级组件！'})
|
}
|
if (card.subtype === 'dualdatacard' && card.subColumns) {
|
card.subColumns.forEach(col => {
|
columns.push(col.field)
|
})
|
}
|
} else if ((card.type === 'balcony' || card.type === 'card') && card.wrap.datatype === 'public') {
|
columns = card.columns.map(c => c.field)
|
}
|
|
let doubleClick = ''
|
if (card.type === 'table') {
|
doubleClick = card.wrap.doubleClick || ''
|
}
|
|
let checkBtn = (cell) => {
|
if (cell.OpenType === 'pop' || (cell.OpenType === 'funcbutton' && cell.execMode === 'pop')) {
|
if (!cell.modal || cell.modal.fields.length === 0) {
|
errors.push({ level: 0, detail: `按钮“${cell.label}”中表单尚未添加`})
|
} else if (cell.OpenType === 'pop') {
|
let forms = []
|
cell.modal.fields.forEach(n => {
|
if (n.type === 'funcvar' && n.field) {
|
forms.push(n.field)
|
}
|
})
|
if (cell.verify && cell.verify.billcodes && cell.verify.billcodes.length > 0) {
|
let bills = cell.verify.billcodes.filter(item => item.status !== 'false').map(item => item.field)
|
bills.forEach(n => {
|
if (!forms.includes(n)) {
|
errors.push({ level: 0, detail: `按钮“${cell.label}”中单号生成的函数变量“${n}”不存在`})
|
}
|
})
|
forms = forms.filter(n => !bills.includes(n))
|
}
|
if (forms.length) {
|
errors.push({ level: 0, detail: `按钮“${cell.label}”中函数变量表单“${forms.join(',')}”尚未使用`})
|
}
|
}
|
} else if (cell.OpenType === 'excelIn') {
|
if (!cell.verify || !cell.verify.sheet || !cell.verify.columns || cell.verify.columns.length === 0) {
|
errors.push({ level: 0, detail: `按钮“${cell.label}”中导入列未设置！`})
|
}
|
} else if (cell.OpenType === 'excelOut') {
|
if (!cell.verify || !cell.verify.columns || cell.verify.columns.length === 0) {
|
errors.push({ level: 0, detail: `按钮“${cell.label}”中导出列未设置！`})
|
} else if (cell.intertype === 'system' && cell.verify.dataType !== 'custom') {
|
if (!card.setting || card.setting.interType !== 'system') {
|
errors.push({ level: 0, detail: `按钮“${cell.label}”需自定义导出数据源！`})
|
} else if (card.type === 'balcony' || card.subtype === 'propcard') {
|
errors.push({ level: 0, detail: `按钮“${cell.label}”需自定义导出数据源！`})
|
} else if (card.$c_ds && columns.length > 0) {
|
let cols = []
|
cell.verify.columns.forEach(col => {
|
if (col.output === 'false' || col.Column === '$Index') return
|
if (!columns.includes(col.Column)) {
|
cols.push(col.Column)
|
}
|
})
|
if (cols.length) {
|
errors.push({ level: 0, detail: `按钮“${cell.label}”中导出列（${cols.join('、')}）在字段集中不存在！`})
|
}
|
}
|
}
|
}
|
|
if (['pop', 'prompt', 'exec'].includes(cell.OpenType) && cell.verify && !cell.output) {
|
if (cell.verify.noteEnable === 'true') {
|
errors.push({ level: 0, detail: `按钮“${cell.label}”未设置返回值短信发送无效！`})
|
} else if (cell.verify.wxNote === 'true') {
|
errors.push({ level: 0, detail: `按钮“${cell.label}”未设置返回值公众号消息无效！`})
|
} else if (cell.verify.emailEnable === 'true') {
|
errors.push({ level: 0, detail: `按钮“${cell.label}”未设置返回值邮件发送无效！`})
|
} else if (cell.verify.DeepSeekable === 'true') {
|
errors.push({ level: 0, detail: `按钮“${cell.label}”未设置返回值DeekSeek无效！`})
|
}
|
}
|
|
if (['exec', 'prompt', 'pop', 'form', 'formSubmit'].includes(cell.OpenType)) {
|
if (cell.Ot !== 'requiredOnce' && ['pop', 'form'].includes(cell.OpenType) && cell.verify && cell.verify.uniques && cell.verify.uniques.length > 0) {
|
let forms = ['BID']
|
|
if (cell.OpenType === 'form') {
|
forms.push(cell.field)
|
} else if (cell.modal && cell.modal.fields.length > 0) {
|
cell.modal.fields.forEach(n => {
|
if (!n.field) return
|
forms.push(n.field)
|
})
|
}
|
let emptys = []
|
if (cell.Ot !== 'notRequired') {
|
forms.push(...columns)
|
}
|
|
cell.verify.uniques.forEach(m => {
|
if (m.status === 'false') return
|
|
m.field.split(',').forEach(n => {
|
if (!forms.includes(n)) {
|
emptys.push(n)
|
}
|
})
|
})
|
|
if (emptys.length) {
|
if (cell.Ot === 'notRequired') {
|
errors.push({ level: 0, detail: `按钮“${cell.label}”唯一性验证字段${emptys.join('、')}，在表单中不存在！`})
|
} else {
|
errors.push({ level: 0, detail: `按钮“${cell.label}”唯一性验证字段${emptys.join('、')}，在表单与字段集中不存在！`})
|
}
|
}
|
}
|
|
if (cell.OpenType === 'form' && cell.formType === 'count_line') return
|
|
// if (cell.intertype === 'system') {
|
// // if (cell.Ot === 'notRequired' && cell.verify && cell.verify.voucher && cell.verify.voucher.enabled) {
|
// // errors.push({ level: 0, detail: `按钮“${cell.label}”使用了创建凭证函数，需要选择行！`})
|
// // }
|
// } else if (cell.intertype === 'custom' || cell.intertype === 'outer') {
|
// if (cell.callbackType === 'script' && (!cell.verify || !cell.verify.cbScripts || cell.verify.cbScripts.filter(item => item.status !== 'false').length === 0)) {
|
// errors.push({ level: 0, detail: `按钮“${cell.label}”使用了自定义脚本回调，回调脚本不可为空！`})
|
// // } else if (cell.procMode === 'system' && cell.Ot === 'notRequired' && cell.verify && cell.verify.voucher && cell.verify.voucher.enabled) {
|
// // errors.push({ level: 0, detail: `按钮“${cell.label}”使用了创建凭证函数，需要选择行！`})
|
// }
|
// }
|
if ((cell.intertype === 'custom' || cell.intertype === 'outer') && cell.callbackType === 'script') {
|
if (!cell.verify || !cell.verify.cbScripts) {
|
errors.push({ level: 0, detail: `按钮“${cell.label}”使用了自定义脚本回调，请设置验证信息！`})
|
}
|
}
|
} else if (cell.OpenType === 'funcbutton') {
|
if (cell.funcType === 'print') {
|
if (!cell.verify || !cell.verify.printMode) {
|
errors.push({ level: 0, detail: `按钮“${cell.label}”请完善验证信息！`})
|
} else if (cell.intertype === 'system' && cell.verify.dataType === 'custom' && (!cell.verify.setting || cell.verify.columns.length === 0)) {
|
errors.push({ level: 0, detail: `按钮“${cell.label}”使用了自定义打印数据，请设置数据源！`})
|
}
|
} else if ((cell.funcType === 'refund' || cell.funcType === 'pay') && cell.payMode === 'system' && (!cell.verify || !cell.verify.scripts || cell.verify.scripts.filter(item => item.status !== 'false').length === 0)) {
|
errors.push({ level: 0, detail: `按钮“${cell.label}”需添加自定义脚本！`})
|
}
|
} else if (cell.OpenType === 'innerpage' || cell.OpenType === 'outerpage') {
|
if (!cell.pageTemplate) {
|
errors.push({ level: 0, detail: `按钮“${cell.label}”页面类型设置错误！`})
|
} else if (cell.pageTemplate === 'pay' && cell.payMode === 'system' && (!cell.verify || !cell.verify.scripts || cell.verify.scripts.filter(item => item.status !== 'false').length === 0)) {
|
errors.push({ level: 0, detail: `按钮“${cell.label}”需添加自定义脚本！`})
|
}
|
}
|
}
|
|
if (card.$c_ac) {
|
card.action.forEach(cell => {
|
if (cell.hidden === 'true' || cell.origin) return
|
// if (cell.OpenType === 'popview') {
|
// if (!cell.config) {
|
// errors.push({ level: 0, detail: `按钮“${cell.label}”中弹窗标签尚未设置`})
|
// } else if (!cell.config.enabled) {
|
// errors.push({ level: 0, detail: `按钮“${cell.label}”中弹窗标签未启用`})
|
// }
|
// }
|
checkBtn(cell)
|
if (doubleClick === cell.uuid) {
|
doubleClick = ''
|
}
|
})
|
}
|
|
if (card.$c_sc) {
|
card.subcards.forEach((item, i) => {
|
let linkbtn = item.setting.linkbtn || ''
|
item.elements.forEach(cell => {
|
if (cell.eleType === 'button') {
|
if (cell.hidden === 'true') return
|
checkBtn(cell)
|
if (linkbtn && linkbtn === cell.uuid) {
|
linkbtn = ''
|
}
|
} else if (cell.datatype === 'dynamic' && cell.field && !columns.includes(cell.field)) {
|
errors.push({ level: 1, detail: `卡片中动态字段“${cell.field}”无效`})
|
}
|
})
|
|
if (card.subtype === 'dualdatacard' || (item.setting.type === 'multi' && item.backElements && sessionStorage.getItem('appType') !== 'mob')) {
|
item.backElements.forEach(cell => {
|
if (cell.eleType === 'button') {
|
if (cell.hidden === 'true') return
|
checkBtn(cell)
|
if (linkbtn && linkbtn === cell.uuid) {
|
linkbtn = ''
|
}
|
} else if (cell.datatype === 'dynamic' && cell.field && !columns.includes(cell.field)) {
|
errors.push({ level: 1, detail: `卡片中动态字段“${cell.field}”无效`})
|
}
|
})
|
}
|
|
if (linkbtn) {
|
errors.push({ level: 1, detail: `第${i + 1}张卡片中绑定按钮已删除`})
|
}
|
})
|
|
if (card.subcards.length === 0) {
|
errors.push({ level: 0, detail: '卡片不可为空！'})
|
}
|
}
|
|
if (card.$c_el) {
|
card.elements.forEach(cell => {
|
if (cell.eleType === 'button') {
|
if (cell.hidden === 'true') return
|
checkBtn(cell)
|
} else if (cell.datatype === 'dynamic' && cell.field && !columns.includes(cell.field)) {
|
errors.push({ level: 1, detail: `卡片中动态字段“${cell.field}”无效`})
|
}
|
})
|
}
|
|
if (card.$c_cl) {
|
card.cols.forEach(col => {
|
if (col.type === 'custom') {
|
col.elements.forEach(cell => {
|
if (cell.eleType === 'button') {
|
if (cell.hidden === 'true') return
|
|
checkBtn(cell)
|
|
if (doubleClick === cell.uuid) {
|
doubleClick = ''
|
}
|
} else {
|
if (cell.datatype === 'dynamic' && cell.field && !columns.includes(cell.field)) {
|
errors.push({ level: 1, detail: `显示列“${col.label}”中动态字段“${cell.field}”无效`})
|
}
|
}
|
})
|
} else if (col.field && !columns.includes(col.field)) {
|
errors.push({ level: 1, detail: `显示列“${col.label}”中字段“${col.field}”无效`})
|
}
|
})
|
|
if (doubleClick) {
|
errors.push({ level: 1, detail: `绑定的双击按钮已删除`})
|
}
|
}
|
|
if (card.$c_fc) {
|
let idCtrl = false
|
let supModule = ''
|
|
if (card.wrap.datatype === 'dynamic') {
|
supModule = card.setting.supModule ? card.setting.supModule[card.setting.supModule.length - 1] || '' : ''
|
if (supModule === 'empty') {
|
supModule = ''
|
}
|
} else {
|
if (card.wrap.datatype === 'static') {
|
supModule = card.wrap.supModule ? card.wrap.supModule[card.wrap.supModule.length - 1] : ''
|
} else {
|
supModule = null
|
}
|
}
|
|
card.subcards.forEach(item => {
|
if (item.subButton.intertype === 'system' && !item.subButton.sqlType) {
|
errors.push({ level: 0, detail: `${item.subButton.label} 按钮请设置操作类型`})
|
}
|
if (item.subButton.Ot === 'requiredSgl' && card.wrap.datatype === 'static') {
|
errors.push({ level: 0, detail: `${item.subButton.label} 按钮选行时不可使用静态数据源`})
|
}
|
if (item.subButton.verify && !item.subButton.output) {
|
if (item.subButton.verify.noteEnable === 'true') {
|
errors.push({ level: 0, detail: `${item.subButton.label} 按钮未设置返回值短信发送无效！`})
|
} else if (item.subButton.verify.wxNote === 'true') {
|
errors.push({ level: 0, detail: `${item.subButton.label} 按钮未设置返回值公众号消息无效！`})
|
} else if (item.subButton.verify.emailEnable === 'true') {
|
errors.push({ level: 0, detail: `${item.subButton.label} 按钮未设置返回值邮件发送无效！`})
|
} else if (item.subButton.verify.DeepSeekable === 'true') {
|
errors.push({ level: 0, detail: `${item.subButton.label} 按钮未设置返回值DeekSeek无效！`})
|
}
|
}
|
|
let forms = []
|
item.fields.forEach(m => {
|
if (m.type === 'funcvar' && m.field) {
|
forms.push(m.field)
|
}
|
if (m.dataSource && /@ID@/ig.test(m.dataSource)) {
|
idCtrl = true
|
}
|
if (m.type === 'linkMain' && !supModule && supModule !== null) {
|
if (item.setting && item.setting.title) {
|
errors.push({ level: 1, detail: `请检查分组“${item.setting.title}”中关联主表“${m.label}”是否有效`})
|
} else {
|
errors.push({ level: 1, detail: `请检查关联主表“${m.label}”是否有效`})
|
}
|
}
|
})
|
|
if (item.subButton.verify && item.subButton.verify.billcodes && item.subButton.verify.billcodes.length > 0) {
|
let bills = item.subButton.verify.billcodes.filter(item => item.status !== 'false').map(item => item.field)
|
bills.forEach(n => {
|
if (!forms.includes(n)) {
|
errors.push({ level: 0, detail: `按钮“${item.subButton.label}”中单号生成的函数变量“${n}”不存在`})
|
}
|
})
|
forms = forms.filter(n => !bills.includes(n))
|
}
|
if (forms.length) {
|
if (item.setting && item.setting.title) {
|
errors.push({ level: 0, detail: `分组“${item.setting.title}”中函数变量表单“${forms.join(',')}”尚未使用`})
|
} else {
|
errors.push({ level: 0, detail: `函数变量表单“${forms.join(',')}”尚未使用`})
|
}
|
}
|
})
|
|
card.idCtrl = idCtrl
|
}
|
|
return errors
|
}
|
|
/**
|
* @description 检测sql
|
*/
|
export function checkSQL(sql, type) {
|
if (!sql) return true
|
|
let label = '数据源中'
|
if (type === 'customscript') {
|
label = '自定义sql语句中'
|
}
|
|
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)
|
let caseErr = false
|
|
_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 (/case\s+when\s+[\s\S]+\send(\s|\n|$)/ig.test(sql)) {
|
sql.match(/case\s+when\s+[\s\S]+\send(\s|\n|$)/ig).forEach(line => {
|
if (!/\selse\s/ig.test(line)) {
|
caseErr = true
|
}
|
})
|
}
|
|
if (_quot % 2 !== 0) {
|
notification.warning({
|
top: 92,
|
message: 'sql中\'必须成对出现',
|
duration: 5
|
})
|
return false
|
} else if (_lparen !== _rparen) {
|
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
|
} else if (/--/ig.test(sql)) {
|
let lines = []
|
sql.split(/\n/).forEach((s, i) => {
|
if (/--/ig.test(s)) {
|
lines.push(i + 1)
|
}
|
})
|
|
lines = lines.join('、')
|
lines = lines ? '(第' + lines + '行)' : ''
|
|
notification.warning({
|
top: 92,
|
message: label + `${lines}，不可出现字符 -- ，注释请用 /*内容*/`,
|
duration: 5
|
})
|
return false
|
} else if (/,,/ig.test(sql)) {
|
let lines = []
|
sql.split(/\n/).forEach((s, i) => {
|
if (/,,/ig.test(s)) {
|
lines.push(i + 1)
|
}
|
})
|
|
lines = lines.join('、')
|
lines = lines ? '(第' + lines + '行)' : ''
|
|
notification.warning({
|
top: 92,
|
message: label + `${lines}，不可出现连续的英文逗号,,`,
|
duration: 5
|
})
|
return false
|
} else if (/‘|’/ig.test(sql)) {
|
let lines = []
|
sql.split(/\n/).forEach((s, i) => {
|
if (/‘|’/ig.test(s)) {
|
lines.push(i + 1)
|
}
|
})
|
|
lines = lines.join('、')
|
lines = lines ? '(第' + lines + '行)' : ''
|
|
notification.warning({
|
top: 92,
|
message: label + `${lines}，不可出现中文单引号`,
|
duration: 5
|
})
|
return false
|
} else if (/\send\s+begin\s/ig.test(sql)) {
|
notification.warning({
|
top: 92,
|
message: `end 后不可紧跟 begin。`,
|
duration: 5
|
})
|
return false
|
} else if (/\sdecimal\(8,/ig.test(sql)) {
|
let lines = ''
|
sql.split(/\n/).forEach((s, i) => {
|
if (/(^|\s)decimal\(8,/ig.test(s)) {
|
lines = '第' + (i + 1) + '行中'
|
}
|
})
|
|
notification.warning({
|
top: 92,
|
message: `${lines}不可使用 decimal(8`,
|
duration: 5
|
})
|
return false
|
} else if (caseErr) {
|
notification.warning({
|
top: 92,
|
message: 'case when 语句需要有 else',
|
duration: 5
|
})
|
return false
|
} else if (type === 'customscript' && /\son\s+[a-z0-9_]+\.[a-z0-9_]+\s*=\s*[a-z0-9_]+\.[a-z0-9_]+/ig.test(sql)) {
|
let list = sql.match(/\son\s+[a-z0-9_]+\.[a-z0-9_]+\s*=\s*[a-z0-9_]+\.[a-z0-9_]+/ig)
|
let errors = []
|
list.forEach(str => {
|
str = str.replace(/^\s/, '')
|
let strs = str.match(/(\s|=)[a-z0-9_]+\./ig)
|
if (strs.length === 2 && (strs[0].replace(/\s|\.|=/g, '') === strs[1].replace(/\s|\.|=/g, ''))) {
|
errors.push(str)
|
}
|
})
|
|
if (errors.length > 0) {
|
notification.warning({
|
top: 92,
|
message: '不可使用同一个表字段进行关联：' + errors.join('、'),
|
duration: 5
|
})
|
return false
|
}
|
}
|
|
let error = ''
|
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}
|
]
|
|
if (type === 'customscript') {
|
chars = chars.filter(char => !['create', 'insert', 'delete', 'update', 'set', 'drop', 'if', 'exec'].includes(char.key))
|
}
|
|
sql = sql.replace(/sys\.fn_/ig, '') // 跳过sys.fn_验证
|
|
chars.forEach(char => {
|
if (!error && char.reg.test(sql)) {
|
error = char.key
|
}
|
})
|
|
if (error) {
|
notification.warning({
|
top: 92,
|
message: 'sql中不可使用' + error,
|
duration: 5
|
})
|
return false
|
} else if (/,\./ig.test(sql)) {
|
let lines = []
|
sql.split(/\n/).forEach((s, i) => {
|
if (/,\./ig.test(s)) {
|
lines.push(i + 1)
|
}
|
})
|
|
lines = lines.join('、')
|
lines = lines ? '(第' + lines + '行)' : ''
|
|
notification.warning({
|
top: 92,
|
message: label + `${lines}，不可出现英文逗号,.`,
|
duration: 5
|
})
|
} else if (/\.,/ig.test(sql)) {
|
let lines = []
|
sql.split(/\n/).forEach((s, i) => {
|
if (/\.,/ig.test(s)) {
|
lines.push(i + 1)
|
}
|
})
|
|
lines = lines.join('、')
|
lines = lines ? '(第' + lines + '行)' : ''
|
|
notification.warning({
|
top: 92,
|
message: label + `${lines}，不可出现英文逗号.,`,
|
duration: 5
|
})
|
}
|
|
return true
|
}
|
|
/**
|
* @description 获取语言转换信息
|
*/
|
export function getLangTrans (config) {
|
if (sessionStorage.getItem('lang') !== 'zh-CN') return ''
|
|
let langList = sessionStorage.getItem('langList')
|
let appType = sessionStorage.getItem('appType')
|
|
if (appType === 'mob' || appType === 'pc') {
|
langList = sessionStorage.getItem('applangList')
|
}
|
|
if (!langList) return ''
|
|
try {
|
langList = JSON.parse(langList)
|
} catch (e) {
|
langList = ''
|
}
|
|
if (!langList) return ''
|
|
langList = langList.filter(n => n !== 'zh-CN')
|
|
if (langList.length === 0) return ''
|
|
let sql = []
|
let btn = []
|
let ops = []
|
let text = []
|
let menu = []
|
|
let filterElement = (card) => {
|
if (card.datatype === 'static' && card.eleType === 'text' && !/@.+@/g.test(card.value)) {
|
sql.push(card.value)
|
}
|
if (card.prefix) {
|
sql.push(card.prefix)
|
}
|
if (card.postfix) {
|
sql.push(card.postfix)
|
}
|
}
|
|
let filterSql = (sl) => {
|
if (!sl) return
|
|
let _sl = sl.replace(/\/\*[^*/]+\*\//g, '')
|
let cutreg = /[\u4E00-\u9FA5。！，、]+/ig
|
let tbs = _sl.match(cutreg)
|
|
if (!tbs) return
|
|
text.push(...tbs)
|
}
|
|
let filterBtn = (btn) => {
|
if (!btn.verify) return
|
|
btn.verify.columns && btn.verify.columns.forEach(col => {
|
if (col.Text) {
|
sql.push(col.Text)
|
}
|
})
|
|
btn.verify.customverifys && btn.verify.customverifys.forEach(script => {
|
filterSql(script.sql)
|
|
if (script.errmsg) {
|
sql.push(script.errmsg)
|
}
|
})
|
btn.verify.scripts && btn.verify.scripts.forEach(script => {
|
filterSql(script.sql)
|
})
|
btn.verify.cbScripts && btn.verify.cbScripts.forEach(script => {
|
filterSql(script.sql)
|
})
|
|
if (btn.OpenType === 'funcbutton') {
|
if (btn.intertype === 'system' && btn.verify.dataType === 'custom' && btn.verify.setting) {
|
filterSql(btn.verify.setting.dataresource)
|
}
|
} else if (btn.OpenType === 'excelOut') {
|
filterSql(btn.verify.dataresource)
|
}
|
}
|
|
let filterForm = (n) => {
|
sql.push(n.label)
|
if (n.resourceType === '1') {
|
filterSql(n.dataSource)
|
} else if (n.options) {
|
n.options.forEach(o => {
|
ops.push(o.Text)
|
})
|
}
|
}
|
|
let traversal = (components) => {
|
if (!components) return
|
|
components.forEach(item => {
|
if (item.type === 'tabs') {
|
item.subtabs.forEach(tab => {
|
sql.push(tab.label)
|
traversal(tab.components)
|
})
|
} else if (item.type === 'group') {
|
traversal(item.components)
|
} else {
|
if (item.wrap && item.wrap.title) {
|
sql.push(item.wrap.title)
|
}
|
if (item.plot && item.plot.title) {
|
sql.push(item.plot.title)
|
}
|
|
if (item.setting && (!item.wrap || !item.wrap.datatype || item.wrap.datatype === 'dynamic')) {
|
if (item.setting.interType === 'system') {
|
filterSql(item.setting.dataresource)
|
item.scripts && item.scripts.forEach(script => {
|
filterSql(script.sql)
|
})
|
}
|
}
|
|
if (item.columns) {
|
item.columns.forEach(cell => {
|
sql.push(cell.label)
|
})
|
}
|
if (item.search) {
|
if (item.type === 'topbar') {
|
if (item.search.fields) {
|
item.search.fields.forEach(cell => {
|
filterForm(cell)
|
})
|
}
|
if (item.search.groups) {
|
item.search.groups.forEach(group => {
|
if (group.fields) {
|
group.fields.forEach(cell => {
|
filterForm(cell)
|
})
|
}
|
})
|
}
|
} else {
|
item.search.forEach(cell => {
|
filterForm(cell)
|
})
|
}
|
}
|
if (item.action) {
|
item.action.forEach(cell => {
|
btn.push(cell.label)
|
filterBtn(cell)
|
if (cell.OpenType === 'popview' && cell.config) {
|
traversal(cell.config.components)
|
} else if (cell.OpenType === 'pop') {
|
if (cell.modal && cell.modal.fields.length) {
|
cell.modal.fields.forEach(n => {
|
filterForm(n)
|
})
|
}
|
}
|
})
|
}
|
|
if (item.type === 'navbar') {
|
if (item.menus) {
|
item.menus.forEach(first => {
|
menu.push(first.name)
|
if (first.sublist) {
|
first.sublist.forEach(sec => {
|
menu.push(sec.name)
|
if (sec.sublist) {
|
sec.sublist.forEach(thd => {
|
menu.push(thd.name)
|
})
|
}
|
})
|
}
|
})
|
}
|
} else if (item.type === 'menubar') {
|
item.subMenus.forEach(cell => {
|
if (cell.setting.name) {
|
menu.push(cell.setting.name)
|
}
|
})
|
} else if (item.type === 'card' || item.type === 'carousel' || item.type === 'timeline') {
|
item.subcards.forEach(card => {
|
card.elements && card.elements.forEach(cell => {
|
if (cell.eleType === 'button') {
|
btn.push(cell.label)
|
filterBtn(cell)
|
if (cell.OpenType === 'popview' && cell.config) {
|
traversal(cell.config.components)
|
} else if (cell.OpenType === 'pop') {
|
if (cell.modal && cell.modal.fields.length) {
|
cell.modal.fields.forEach(n => {
|
filterForm(n)
|
})
|
}
|
}
|
} else {
|
filterElement(cell)
|
}
|
})
|
card.backElements && card.backElements.forEach(cell => {
|
if (cell.eleType === 'button') {
|
btn.push(cell.label)
|
filterBtn(cell)
|
if (cell.OpenType === 'popview' && cell.config) {
|
traversal(cell.config.components)
|
} else if (cell.OpenType === 'pop') {
|
if (cell.modal && cell.modal.fields.length) {
|
cell.modal.fields.forEach(n => {
|
filterForm(n)
|
})
|
}
|
}
|
} else {
|
filterElement(cell)
|
}
|
})
|
})
|
} else if (item.type === 'balcony') {
|
item.elements && item.elements.forEach(cell => {
|
if (cell.eleType === 'button') {
|
btn.push(cell.label)
|
filterBtn(cell)
|
if (cell.OpenType === 'popview' && cell.config) {
|
traversal(cell.config.components)
|
} else if (cell.OpenType === 'pop') {
|
if (cell.modal && cell.modal.fields.length) {
|
cell.modal.fields.forEach(n => {
|
filterForm(n)
|
})
|
}
|
}
|
} else {
|
filterElement(cell)
|
}
|
})
|
} else if (item.type === 'table') {
|
let loopCol = (cols) => {
|
cols.forEach(col => {
|
sql.push(col.label)
|
if (col.prefix) {
|
sql.push(col.prefix)
|
}
|
if (col.postfix) {
|
sql.push(col.postfix)
|
}
|
if (col.type === 'colspan') {
|
loopCol(col.subcols)
|
} else if (col.type === 'custom') {
|
col.elements.forEach(cell => {
|
if (cell.eleType === 'button') {
|
btn.push(cell.label)
|
filterBtn(cell)
|
if (cell.OpenType === 'popview' && cell.config) {
|
traversal(cell.config.components)
|
} else if (cell.OpenType === 'pop') {
|
if (cell.modal && cell.modal.fields.length) {
|
cell.modal.fields.forEach(n => {
|
filterForm(n)
|
})
|
}
|
}
|
} else {
|
filterElement(cell)
|
}
|
})
|
}
|
})
|
}
|
loopCol(item.cols)
|
} else if (item.type === 'form') {
|
item.subcards.forEach(cell => {
|
filterBtn(cell.subButton)
|
cell.fields.forEach(n => {
|
filterForm(n)
|
})
|
})
|
}
|
}
|
})
|
}
|
|
if (config.interfaces) {
|
config.interfaces.forEach(item => {
|
if (item.setting.interType === 'system') {
|
filterSql(item.setting.dataresource)
|
item.scripts && item.scripts.forEach(script => {
|
filterSql(script.sql)
|
})
|
}
|
})
|
}
|
|
traversal(config.components)
|
|
if (config.MenuName) {
|
menu.push(config.MenuName)
|
}
|
|
if (config.fstMenuId && config.parentId && config.fstMenuId !== 'BillPrintTemp') {
|
let menulist = sessionStorage.getItem('fstMenuList')
|
try {
|
menulist = JSON.parse(menulist)
|
} catch(e) {
|
menulist = []
|
}
|
|
menulist.forEach(item => {
|
if (item.MenuID !== config.fstMenuId) return
|
menu.push(item.MenuName)
|
item.children.forEach(cell => {
|
if (cell.MenuID !== config.parentId) return
|
menu.push(cell.MenuName)
|
})
|
})
|
}
|
|
sql = sql.filter(Boolean)
|
btn = btn.filter(Boolean)
|
ops = ops.filter(Boolean)
|
text = text.filter(Boolean)
|
menu = menu.filter(Boolean)
|
|
sql = sql.map(n => n.replace(/(:|：)$/g, ''))
|
|
sql = Array.from(new Set(sql))
|
btn = Array.from(new Set(btn))
|
ops = Array.from(new Set(ops))
|
text = Array.from(new Set(text))
|
menu = Array.from(new Set(menu))
|
|
sql = sql.map(l => `'${l}','title'`)
|
btn = btn.map(l => `'${l}','button'`)
|
ops = ops.map(l => `'${l}','list'`)
|
text = text.map(l => `'${l}','text'`)
|
menu = menu.map(l => `'${l}','menu'`)
|
|
let list = [...menu, ...btn, ...sql, ...ops, ...text]
|
|
let result = []
|
|
langList.forEach(lan => {
|
list.forEach(n => {
|
result.push(`'${lan}',${n}`)
|
})
|
})
|
|
config.trans = true
|
|
return result.join(';')
|
}
|
|
/**
|
* @description 语言转换
|
*/
|
export function setLangTrans (config, btnDict, titDict, lisDict, menuDict, regs, tail) {
|
let filterElement = (card) => {
|
if (card.datatype === 'static' && card.eleType === 'text' && !/@.+@/g.test(card.value)) {
|
if (card.value) {
|
card.value = replaceTitle(card.value)
|
}
|
}
|
if (card.prefix) {
|
card.prefix = replaceTitle(card.prefix)
|
}
|
if (card.postfix) {
|
card.postfix = replaceTitle(card.postfix)
|
}
|
}
|
|
let replaceTitle = (val) => {
|
if (/(:|：)$/g.test(val)) {
|
let _val = val.replace(/(:|：)$/g, '')
|
if (titDict[_val]) {
|
val = titDict[_val] + val.substr(-1)
|
} else if (titDict[val]) {
|
val = titDict[val]
|
}
|
} else if (titDict[val]) {
|
val = titDict[val]
|
}
|
|
return val
|
}
|
|
let getuuid = () => {
|
let uuid = []
|
let _options = '0123456789abcdefghigklmnopqrstuv'
|
for (let i = 0; i < 19; i++) {
|
uuid.push(_options.substr(Math.floor(Math.random() * 0x20), 1))
|
}
|
return uuid.join('')
|
}
|
|
let filterSql = (sl) => {
|
if (!sl) return
|
|
let arr = []
|
|
sl = sl.replace(/\/\*[^*/]+\*\//g, (word) => {
|
let uuid = getuuid()
|
arr.push({id: `/*${uuid}*/`, value: word})
|
return `/*${uuid}*/`
|
})
|
|
regs.forEach(item => {
|
sl = sl.replace(item.reg, item.value)
|
})
|
|
arr.forEach(item => {
|
sl = sl.replace(item.id, item.value)
|
})
|
|
return sl
|
}
|
|
let filterBtn = (btn) => {
|
if (btn.label && btnDict[btn.label]) {
|
btn.label = btnDict[btn.label]
|
}
|
|
if (btn.OpenType === 'tab' && btn.linkmenu) {
|
if (btn.linkmenu[0] === 'multiMenu') {
|
btn.multiMenus.forEach(menu => {
|
menu.menuId = menu.menuId.map(c => {
|
if (c.length <= 24) {
|
return md5(window.GLOB.appkey + c + sessionStorage.getItem('lang')).toLowerCase()
|
} else {
|
return c.slice(0, 24) + tail
|
}
|
})
|
|
menu.MenuID = menu.menuId[menu.menuId.length - 1]
|
})
|
} else {
|
btn.linkmenu = btn.linkmenu.map(c => {
|
if (c.length <= 24) {
|
return md5(window.GLOB.appkey + c + sessionStorage.getItem('lang')).toLowerCase()
|
} else {
|
return c.slice(0, 24) + tail
|
}
|
})
|
btn.MenuID = btn.linkmenu[btn.linkmenu.length - 1]
|
}
|
} else {
|
if (btn.refreshTab && btn.refreshTab.length > 0) {
|
btn.refreshTab = btn.refreshTab.map(c => {
|
if (c.length <= 24) {
|
return md5(window.GLOB.appkey + c + sessionStorage.getItem('lang')).toLowerCase()
|
} else {
|
return c.slice(0, 24) + tail
|
}
|
})
|
}
|
if (btn.openmenu && Array.isArray(btn.openmenu) && btn.openmenu.length > 0) {
|
btn.openmenu = btn.openmenu.map(c => {
|
if (c.length <= 24) {
|
return md5(window.GLOB.appkey + c + sessionStorage.getItem('lang')).toLowerCase()
|
} else {
|
return c.slice(0, 24) + tail
|
}
|
})
|
btn.MenuID = btn.openmenu[btn.openmenu.length - 1]
|
} else if (btn.openmenu && typeof(btn.openmenu) === 'string' && btn.openmenu !== 'goback') {
|
btn.openmenu = btn.openmenu.slice(0, 24) + tail
|
}
|
|
if (btn.pageTemplate === 'linkpage' && btn.linkmenu && typeof(btn.linkmenu) === 'string') {
|
btn.linkmenu = btn.linkmenu.slice(0, 24) + tail
|
}
|
}
|
|
if (!btn.verify) return
|
|
btn.verify.columns && btn.verify.columns.forEach(col => {
|
if (col.Text) {
|
col.Text = replaceTitle(col.Text)
|
}
|
})
|
|
btn.verify.uniques && btn.verify.uniques.forEach(col => {
|
if (col.fieldlabel) {
|
col.fieldlabel = col.fieldlabel.split(',').map(n => replaceTitle(n)).join(',')
|
}
|
})
|
|
btn.verify.customverifys && btn.verify.customverifys.forEach(script => {
|
script.sql = filterSql(script.sql)
|
|
if (script.errmsg) {
|
script.errmsg = replaceTitle(script.errmsg)
|
}
|
})
|
btn.verify.scripts && btn.verify.scripts.forEach(script => {
|
script.sql = filterSql(script.sql)
|
})
|
btn.verify.cbScripts && btn.verify.cbScripts.forEach(script => {
|
script.sql = filterSql(script.sql)
|
})
|
|
if (btn.OpenType === 'funcbutton') {
|
if (btn.intertype === 'system' && btn.verify.dataType === 'custom' && btn.verify.setting) {
|
btn.verify.setting.dataresource = filterSql(btn.verify.setting.dataresource)
|
}
|
} else if (btn.OpenType === 'excelOut' && btn.verify.dataresource) {
|
btn.verify.dataresource = filterSql(btn.verify.dataresource)
|
}
|
}
|
|
let filterForm = (n) => {
|
if (n.label) {
|
n.label = replaceTitle(n.label)
|
}
|
if (n.resourceType === '1') {
|
n.dataSource = filterSql(n.dataSource)
|
} else if (n.options) {
|
n.options.forEach(o => {
|
if (o.Text && lisDict[o.Text]) {
|
o.Text = lisDict[o.Text]
|
}
|
})
|
}
|
}
|
|
let resetMenu = (wrap) => {
|
if (!wrap.menu) return
|
|
if (typeof(wrap.menu) === 'string') {
|
wrap.menu = wrap.menu.slice(0, 24) + tail
|
if (wrap.MenuID) {
|
wrap.MenuID = wrap.menu
|
}
|
} else {
|
wrap.menu = wrap.menu.map(c => {
|
if (c.length <= 24) {
|
return md5(window.GLOB.appkey + c + sessionStorage.getItem('lang')).toLowerCase()
|
} else {
|
return c.slice(0, 24) + tail
|
}
|
})
|
if (wrap.MenuID) {
|
wrap.MenuID = wrap.menu[wrap.menu.length - 1]
|
}
|
}
|
}
|
let resetMenus = (wrap) => {
|
if (!wrap.menus) return
|
|
wrap.menus.forEach(m => {
|
if (typeof(m.menu) === 'string') {
|
m.menu = m.menu.slice(0, 24) + tail
|
} else {
|
m.menu = m.menu.map(c => {
|
if (c.length <= 24) {
|
return md5(window.GLOB.appkey + c + sessionStorage.getItem('lang')).toLowerCase()
|
} else {
|
return c.slice(0, 24) + tail
|
}
|
})
|
if (m.MenuID) {
|
m.MenuID = m.menu[m.menu.length - 1]
|
}
|
}
|
})
|
}
|
|
let traversal = (components) => {
|
if (!components) return
|
|
components.forEach(item => {
|
if (item.type === 'tabs') {
|
item.subtabs.forEach(tab => {
|
if (tab.label) {
|
tab.label = replaceTitle(tab.label)
|
}
|
traversal(tab.components)
|
})
|
} else if (item.type === 'group') {
|
traversal(item.components)
|
} else {
|
if (item.wrap && item.wrap.title) {
|
item.wrap.title = replaceTitle(item.wrap.title)
|
}
|
if (item.plot && item.plot.title) {
|
item.plot.title = replaceTitle(item.plot.title)
|
}
|
if (item.wrap && (item.wrap.click === 'menu' || item.wrap.click === 'menus')) {
|
if (item.wrap.click === 'menu') {
|
resetMenu(item.wrap)
|
} else if (item.wrap.click === 'menus') {
|
resetMenus(item.wrap)
|
}
|
} else if (item.plot && (item.plot.click === 'menu' || item.plot.click === 'menus')) {
|
if (item.plot.click === 'menu') {
|
resetMenu(item.plot)
|
} else if (item.plot.click === 'menus') {
|
resetMenus(item.plot)
|
}
|
}
|
if (item.setting && (!item.wrap || !item.wrap.datatype || item.wrap.datatype === 'dynamic')) {
|
if (item.setting.interType === 'system') {
|
item.setting.dataresource = filterSql(item.setting.dataresource)
|
item.scripts && item.scripts.forEach(script => {
|
script.sql = filterSql(script.sql)
|
})
|
}
|
}
|
|
if (item.columns) {
|
item.columns.forEach(cell => {
|
if (cell.label) {
|
cell.label = replaceTitle(cell.label)
|
}
|
})
|
}
|
if (item.search) {
|
if (item.type === 'topbar') {
|
if (item.search.fields) {
|
item.search.fields.forEach(cell => {
|
filterForm(cell)
|
})
|
}
|
if (item.search.groups) {
|
item.search.groups.forEach(group => {
|
if (group.fields) {
|
group.fields.forEach(cell => {
|
filterForm(cell)
|
})
|
}
|
})
|
}
|
} else {
|
item.search.forEach(cell => {
|
filterForm(cell)
|
})
|
}
|
}
|
if (item.action) {
|
item.action.forEach(cell => {
|
filterBtn(cell)
|
if (cell.OpenType === 'popview' && cell.config) {
|
traversal(cell.config.components)
|
} else if (cell.OpenType === 'pop') {
|
if (cell.modal && cell.modal.fields.length) {
|
cell.modal.fields.forEach(n => {
|
filterForm(n)
|
})
|
}
|
}
|
})
|
}
|
|
if (item.type === 'navbar') {
|
item.uuid = item.uuid.slice(0, 24) + tail
|
} else if (item.type === 'login') {
|
item.wrap.linkmenu = item.wrap.linkmenu.slice(0, 24) + tail
|
} else if (item.type === 'menubar') {
|
item.subMenus = item.subMenus.map(cell => {
|
if (cell.setting.name && menuDict[cell.setting.name]) {
|
cell.setting.name = menuDict[cell.setting.name]
|
}
|
if (cell.setting.type === 'linkmenu') {
|
cell.setting.linkMenuId = cell.setting.linkMenuId.slice(0, 24) + tail
|
}
|
return cell
|
})
|
} else if (item.type === 'topbar') {
|
if (item.wrap.menus) {
|
resetMenus(item.wrap)
|
}
|
} else if (item.type === 'card' || item.type === 'carousel' || item.type === 'timeline') {
|
item.subcards.forEach(card => {
|
if (card.setting.click === 'menus') {
|
resetMenus(card)
|
} else if (card.setting.click === 'menu') {
|
resetMenu(card.setting)
|
}
|
card.elements && card.elements.forEach(cell => {
|
if (cell.eleType === 'button') {
|
filterBtn(cell)
|
if (cell.OpenType === 'popview' && cell.config) {
|
traversal(cell.config.components)
|
} else if (cell.OpenType === 'pop') {
|
if (cell.modal && cell.modal.fields.length) {
|
cell.modal.fields.forEach(n => {
|
filterForm(n)
|
})
|
}
|
}
|
} else {
|
filterElement(cell)
|
}
|
})
|
card.backElements && card.backElements.forEach(cell => {
|
if (cell.eleType === 'button') {
|
filterBtn(cell)
|
if (cell.OpenType === 'popview' && cell.config) {
|
traversal(cell.config.components)
|
} else if (cell.OpenType === 'pop') {
|
if (cell.modal && cell.modal.fields.length) {
|
cell.modal.fields.forEach(n => {
|
filterForm(n)
|
})
|
}
|
}
|
} else {
|
filterElement(cell)
|
}
|
})
|
})
|
} else if (item.type === 'balcony') {
|
item.elements && item.elements.forEach(cell => {
|
if (cell.eleType === 'button') {
|
filterBtn(cell)
|
if (cell.OpenType === 'popview' && cell.config) {
|
traversal(cell.config.components)
|
} else if (cell.OpenType === 'pop') {
|
if (cell.modal && cell.modal.fields.length) {
|
cell.modal.fields.forEach(n => {
|
filterForm(n)
|
})
|
}
|
}
|
} else {
|
filterElement(cell)
|
}
|
})
|
} else if (item.type === 'table') {
|
let loopCol = (cols) => {
|
cols.forEach(col => {
|
if (col.label) {
|
col.label = replaceTitle(col.label)
|
}
|
if (col.prefix) {
|
col.prefix = replaceTitle(col.prefix)
|
}
|
if (col.postfix) {
|
col.postfix = replaceTitle(col.postfix)
|
}
|
if (col.type === 'colspan') {
|
loopCol(col.subcols)
|
} else if (col.type === 'custom') {
|
col.elements.forEach(cell => {
|
if (cell.eleType === 'button') {
|
filterBtn(cell)
|
if (cell.OpenType === 'popview' && cell.config) {
|
traversal(cell.config.components)
|
} else if (cell.OpenType === 'pop') {
|
if (cell.modal && cell.modal.fields.length) {
|
cell.modal.fields.forEach(n => {
|
filterForm(n)
|
})
|
}
|
}
|
} else {
|
filterElement(cell)
|
}
|
})
|
}
|
})
|
}
|
loopCol(item.cols)
|
} else if (item.type === 'form') {
|
item.subcards.forEach(cell => {
|
filterBtn(cell.subButton)
|
cell.fields.forEach(n => {
|
filterForm(n)
|
})
|
})
|
}
|
}
|
})
|
}
|
|
if (config.interfaces) {
|
config.interfaces.forEach(item => {
|
if (item.setting.interType === 'system') {
|
item.setting.dataresource = filterSql(item.setting.dataresource)
|
item.scripts && item.scripts.forEach(script => {
|
script.sql = filterSql(script.sql)
|
})
|
}
|
})
|
}
|
|
traversal(config.components)
|
}
|
|
/**
|
* @description 语言转换
|
*/
|
export function setLangSingleTrans (config, btnDict, titDict, lisDict, menuDict, regs) {
|
let filterElement = (card) => {
|
if (card.datatype === 'static' && card.eleType === 'text' && !/@.+@/g.test(card.value)) {
|
if (card.value) {
|
card.value = replaceTitle(card.value)
|
}
|
}
|
if (card.prefix) {
|
card.prefix = replaceTitle(card.prefix)
|
}
|
if (card.postfix) {
|
card.postfix = replaceTitle(card.postfix)
|
}
|
}
|
|
let replaceTitle = (val) => {
|
if (/(:|：)$/g.test(val)) {
|
let _val = val.replace(/(:|：)$/g, '')
|
if (titDict[_val]) {
|
val = titDict[_val] + val.substr(-1)
|
} else if (titDict[val]) {
|
val = titDict[val]
|
}
|
} else if (titDict[val]) {
|
val = titDict[val]
|
}
|
|
return val
|
}
|
|
let getuuid = () => {
|
let uuid = []
|
let _options = '0123456789abcdefghigklmnopqrstuv'
|
for (let i = 0; i < 19; i++) {
|
uuid.push(_options.substr(Math.floor(Math.random() * 0x20), 1))
|
}
|
return uuid.join('')
|
}
|
|
let filterSql = (sl) => {
|
if (!sl) return
|
|
let arr = []
|
|
sl = sl.replace(/\/\*[^*/]+\*\//g, (word) => {
|
let uuid = getuuid()
|
arr.push({id: `/*${uuid}*/`, value: word})
|
return `/*${uuid}*/`
|
})
|
|
regs.forEach(item => {
|
sl = sl.replace(item.reg, item.value)
|
})
|
|
arr.forEach(item => {
|
sl = sl.replace(item.id, item.value)
|
})
|
|
return sl
|
}
|
|
let filterBtn = (btn) => {
|
if (btn.label && btnDict[btn.label]) {
|
btn.label = btnDict[btn.label]
|
}
|
|
if (!btn.verify) return
|
|
btn.verify.columns && btn.verify.columns.forEach(col => {
|
if (col.Text) {
|
col.Text = replaceTitle(col.Text)
|
}
|
})
|
|
btn.verify.uniques && btn.verify.uniques.forEach(col => {
|
if (col.fieldlabel) {
|
col.fieldlabel = col.fieldlabel.split(',').map(n => replaceTitle(n)).join(',')
|
}
|
})
|
|
btn.verify.customverifys && btn.verify.customverifys.forEach(script => {
|
script.sql = filterSql(script.sql)
|
|
if (script.errmsg) {
|
script.errmsg = replaceTitle(script.errmsg)
|
}
|
})
|
btn.verify.scripts && btn.verify.scripts.forEach(script => {
|
script.sql = filterSql(script.sql)
|
})
|
btn.verify.cbScripts && btn.verify.cbScripts.forEach(script => {
|
script.sql = filterSql(script.sql)
|
})
|
|
if (btn.OpenType === 'funcbutton') {
|
if (btn.intertype === 'system' && btn.verify.dataType === 'custom' && btn.verify.setting) {
|
btn.verify.setting.dataresource = filterSql(btn.verify.setting.dataresource)
|
}
|
} else if (btn.OpenType === 'excelOut' && btn.verify.dataresource) {
|
btn.verify.dataresource = filterSql(btn.verify.dataresource)
|
}
|
}
|
|
let filterForm = (n) => {
|
if (n.label) {
|
n.label = replaceTitle(n.label)
|
}
|
if (n.resourceType === '1') {
|
n.dataSource = filterSql(n.dataSource)
|
} else if (n.options) {
|
n.options.forEach(o => {
|
if (o.Text && lisDict[o.Text]) {
|
o.Text = lisDict[o.Text]
|
}
|
})
|
}
|
}
|
|
let traversal = (components) => {
|
if (!components) return
|
|
components.forEach(item => {
|
if (item.type === 'tabs') {
|
item.subtabs.forEach(tab => {
|
if (tab.label) {
|
tab.label = replaceTitle(tab.label)
|
}
|
traversal(tab.components)
|
})
|
} else if (item.type === 'group') {
|
traversal(item.components)
|
} else {
|
if (item.wrap && item.wrap.title) {
|
item.wrap.title = replaceTitle(item.wrap.title)
|
}
|
if (item.plot && item.plot.title) {
|
item.plot.title = replaceTitle(item.plot.title)
|
}
|
if (item.setting && (!item.wrap || !item.wrap.datatype || item.wrap.datatype === 'dynamic')) {
|
if (item.setting.interType === 'system') {
|
item.setting.dataresource = filterSql(item.setting.dataresource)
|
item.scripts && item.scripts.forEach(script => {
|
script.sql = filterSql(script.sql)
|
})
|
}
|
}
|
|
if (item.columns) {
|
item.columns.forEach(cell => {
|
if (cell.label) {
|
cell.label = replaceTitle(cell.label)
|
}
|
})
|
}
|
if (item.search) {
|
if (item.type === 'topbar') {
|
if (item.search.fields) {
|
item.search.fields.forEach(cell => {
|
filterForm(cell)
|
})
|
}
|
if (item.search.groups) {
|
item.search.groups.forEach(group => {
|
if (group.fields) {
|
group.fields.forEach(cell => {
|
filterForm(cell)
|
})
|
}
|
})
|
}
|
} else {
|
item.search.forEach(cell => {
|
filterForm(cell)
|
})
|
}
|
}
|
if (item.action) {
|
item.action.forEach(cell => {
|
filterBtn(cell)
|
if (cell.OpenType === 'popview' && cell.config) {
|
traversal(cell.config.components)
|
} else if (cell.OpenType === 'pop') {
|
if (cell.modal && cell.modal.fields.length) {
|
cell.modal.fields.forEach(n => {
|
filterForm(n)
|
})
|
}
|
}
|
})
|
}
|
|
if (item.type === 'menubar') {
|
item.subMenus = item.subMenus.map(cell => {
|
if (cell.setting.name && menuDict[cell.setting.name]) {
|
cell.setting.name = menuDict[cell.setting.name]
|
}
|
return cell
|
})
|
} else if (item.type === 'card' || item.type === 'carousel' || item.type === 'timeline') {
|
item.subcards.forEach(card => {
|
card.elements && card.elements.forEach(cell => {
|
if (cell.eleType === 'button') {
|
filterBtn(cell)
|
if (cell.OpenType === 'popview' && cell.config) {
|
traversal(cell.config.components)
|
} else if (cell.OpenType === 'pop') {
|
if (cell.modal && cell.modal.fields.length) {
|
cell.modal.fields.forEach(n => {
|
filterForm(n)
|
})
|
}
|
}
|
} else {
|
filterElement(cell)
|
}
|
})
|
card.backElements && card.backElements.forEach(cell => {
|
if (cell.eleType === 'button') {
|
filterBtn(cell)
|
if (cell.OpenType === 'popview' && cell.config) {
|
traversal(cell.config.components)
|
} else if (cell.OpenType === 'pop') {
|
if (cell.modal && cell.modal.fields.length) {
|
cell.modal.fields.forEach(n => {
|
filterForm(n)
|
})
|
}
|
}
|
} else {
|
filterElement(cell)
|
}
|
})
|
})
|
} else if (item.type === 'balcony') {
|
item.elements && item.elements.forEach(cell => {
|
if (cell.eleType === 'button') {
|
filterBtn(cell)
|
if (cell.OpenType === 'popview' && cell.config) {
|
traversal(cell.config.components)
|
} else if (cell.OpenType === 'pop') {
|
if (cell.modal && cell.modal.fields.length) {
|
cell.modal.fields.forEach(n => {
|
filterForm(n)
|
})
|
}
|
}
|
} else {
|
filterElement(cell)
|
}
|
})
|
} else if (item.type === 'table') {
|
let loopCol = (cols) => {
|
cols.forEach(col => {
|
if (col.label) {
|
col.label = replaceTitle(col.label)
|
}
|
if (col.prefix) {
|
col.prefix = replaceTitle(col.prefix)
|
}
|
if (col.postfix) {
|
col.postfix = replaceTitle(col.postfix)
|
}
|
if (col.type === 'colspan') {
|
loopCol(col.subcols)
|
} else if (col.type === 'custom') {
|
col.elements.forEach(cell => {
|
if (cell.eleType === 'button') {
|
filterBtn(cell)
|
if (cell.OpenType === 'popview' && cell.config) {
|
traversal(cell.config.components)
|
} else if (cell.OpenType === 'pop') {
|
if (cell.modal && cell.modal.fields.length) {
|
cell.modal.fields.forEach(n => {
|
filterForm(n)
|
})
|
}
|
}
|
} else {
|
filterElement(cell)
|
}
|
})
|
}
|
})
|
}
|
loopCol(item.cols)
|
} else if (item.type === 'form') {
|
item.subcards.forEach(cell => {
|
filterBtn(cell.subButton)
|
cell.fields.forEach(n => {
|
filterForm(n)
|
})
|
})
|
}
|
}
|
})
|
}
|
|
if (config.interfaces) {
|
config.interfaces.forEach(item => {
|
if (item.setting.interType === 'system') {
|
item.setting.dataresource = filterSql(item.setting.dataresource)
|
item.scripts && item.scripts.forEach(script => {
|
script.sql = filterSql(script.sql)
|
})
|
}
|
})
|
}
|
|
traversal(config.components)
|
}
|
|
/**
|
* @description 获取执行脚本
|
*/
|
export function getAllSqls (conf) {
|
let config = fromJS(conf).toJS()
|
|
let sqls = []
|
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 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 = '', ispop) => {
|
components.forEach(item => {
|
item.$menuname = (config.MenuName || '') + label + '-' + (item.name || '')
|
|
if (item.type === 'tabs') {
|
if (config.Template === 'BaseTable') {
|
item.subtabs.forEach(tab => {
|
if (tab.permission !== 'true' && tab.components[0] && tab.components[0].wrap) {
|
tab.components[0].wrap.permission = 'false'
|
}
|
})
|
}
|
item.subtabs.forEach(tab => {
|
let _mainSearch = mainSearch || []
|
|
if (appType !== 'mob') {
|
tab.components.forEach(com => {
|
if (com.type !== 'search') return
|
|
_mainSearch = com.search || []
|
})
|
}
|
|
filterComponent(tab.components, _mainSearch, label, ispop)
|
})
|
} else if (item.type === 'group') {
|
filterComponent(item.components, mainSearch, label, ispop)
|
} else {
|
if (item.wrap && item.setting) {
|
if (item.wrap.datatype === 'public' || item.wrap.datatype === 'static') {
|
item.setting.interType = 'other'
|
}
|
}
|
|
if (appType === 'mob' && item.type !== 'search' && item.type !== 'topbar' && item.search && item.search.length > 0) {
|
item.search = []
|
}
|
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, '搜索')
|
|
sqls.push({uuid: md5(item.uuid + cell.uuid), type: 'sForm', ...msg})
|
}
|
})
|
}
|
|
if (item.subtype === 'tablecard') { // 兼容
|
item.type = 'card'
|
}
|
|
if (item.setting && item.setting.interType === 'system') {
|
if (item.format === 'object') {
|
item.setting.laypage = 'false'
|
item.setting.$top = true
|
}
|
item.setting.$name = item.$menuname || ''
|
|
let msg = getDataSource(item, mainSearch)
|
let roleId = config.uuid
|
if (item.wrap && item.wrap.permission === 'false') {
|
roleId = ''
|
} else if (item.setting.database === 'sso') {
|
roleId = ''
|
} else if (ispop) {
|
roleId = ''
|
}
|
|
sqls.push({uuid: item.uuid, roleId: roleId, type: 'datasource', ...msg})
|
} else if (item.setting && item.setting.useMSearch === 'true') {
|
let searches = item.search || []
|
if (mainSearch.length > 0) {
|
searches = [...searches, ...mainSearch]
|
}
|
item.$searches = fromJS(searches).toJS()
|
}
|
|
item.action && item.action.forEach(cell => {
|
if (cell.hidden === 'true') return false
|
|
resetButton(item, cell, false, ispop)
|
})
|
|
if (item.type === 'table') {
|
let getCols = (cols) => {
|
cols.forEach(col => {
|
if (col.type === 'action') {
|
col.type = 'custom'
|
}
|
if (col.type === 'colspan') {
|
getCols(col.subcols || [])
|
} else if (col.type === 'custom') {
|
col.elements.forEach(cell => {
|
if (cell.eleType !== 'button' || cell.hidden === 'true') return
|
|
resetButton(item, cell, false, ispop)
|
})
|
} else if (item.subtype === 'editable' && col.editable === 'true') {
|
if (col.editType === 'select' && col.resourceType === '1') {
|
let msg = getFormSql(col, '表单')
|
|
sqls.push({uuid: col.uuid, type: 'tbForm', ...msg})
|
} else if (col.editType === 'popSelect') {
|
if (col.pops) {
|
col.pops.forEach(n => {
|
let msg = getPopSelectSql(n)
|
|
sqls.push({uuid: n.uuid, type: 'popSource', ...msg})
|
})
|
} else {
|
let msg = getPopSelectSql(col)
|
|
sqls.push({uuid: col.uuid, type: 'popSource', ...msg})
|
}
|
}
|
}
|
})
|
}
|
|
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, item.setting)
|
|
sqls.push({uuid: 'submit_' + item.uuid, type: 'editable', ...msg})
|
}
|
} else if (item.type === 'card' || item.type === 'carousel' || item.type === 'timeline') {
|
item.subcards && item.subcards.forEach(card => {
|
card.elements && card.elements.forEach(cell => {
|
if (cell.eleType !== 'button' || cell.hidden === 'true') return
|
|
resetButton(item, cell, false, ispop)
|
})
|
|
if (!card.backElements || card.backElements.length === 0) return
|
|
card.backElements.forEach(cell => {
|
if (cell.eleType !== 'button' || cell.hidden === 'true') return
|
|
resetButton(item, cell, true, ispop)
|
})
|
})
|
} else if (item.type === 'balcony') {
|
item.elements.forEach(cell => {
|
if (cell.eleType !== 'button' || cell.hidden === 'true') return
|
|
resetButton(item, cell, false, ispop)
|
})
|
} else if (item.type === 'form') {
|
item.subcards.forEach(group => {
|
group.subButton.OpenType = 'formSubmit'
|
if (!group.subButton.Ot) {
|
group.subButton.Ot = item.wrap.datatype === 'static' ? 'notRequired' : 'requiredSgl'
|
}
|
group.subButton.uuid = group.uuid
|
group.subButton.modal = {
|
fields: group.fields
|
}
|
|
resetButton(item, group.subButton, false, ispop)
|
})
|
} else if (item.type === 'module' && item.subtype === 'invoice') {
|
if (item.buyer.setting && item.buyer.setting.interType === 'system') {
|
let msg = getDataSource(item.buyer, [])
|
|
sqls.push({uuid: item.uuid + 'buyer', type: 'datasource', ...msg})
|
}
|
|
if (item.detail.setting && item.detail.setting.interType === 'system') {
|
let _msg = getDataSource(item.detail, [])
|
|
sqls.push({uuid: item.uuid + 'detail', type: 'datasource', ..._msg})
|
}
|
|
let btnmsg = getInvoicePreSql(item.billSaveBtn, item.$menuname + '-' + item.billSaveBtn.label)
|
|
sqls.push({uuid: item.uuid + item.billSaveBtn.type, type: 'button', ...btnmsg})
|
|
let _btnmsg = getInvoicePreSql(item.billOutBtn, item.$menuname + '-' + item.billOutBtn.label)
|
|
sqls.push({uuid: item.uuid + item.billOutBtn.type, type: 'button', ..._btnmsg})
|
|
let backmsg = getInvoiceSysBackSql(item.billOutBtn, item.$menuname + '-' + item.billOutBtn.label + '(回调)')
|
|
sqls.push({uuid: item.uuid + 'billback', type: 'btnCallBack', ...backmsg})
|
}
|
}
|
})
|
}
|
|
let resetButton = (item, cell, isback, ispop) => {
|
cell.logLabel = item.$menuname + '-' + cell.label
|
let roleId = cell.uuid
|
if (item.wrap && item.wrap.permission === 'false') {
|
roleId = ''
|
} else if (cell.hidden === 'true' || cell.permission === 'false') {
|
roleId = ''
|
} else if (cell.database === 'sso') {
|
roleId = ''
|
} else if (ispop) {
|
roleId = ''
|
}
|
|
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 || []
|
_item.setting.primaryKey = _item.setting.subKey
|
|
let msg = getSysDefaultSql(cell, _item)
|
|
sqls.push({uuid: cell.uuid, roleId: roleId, type: 'button', ...msg})
|
} else {
|
let msg = getSysDefaultSql(cell, item)
|
|
sqls.push({uuid: cell.uuid, roleId: roleId, type: 'button', ...msg})
|
}
|
}
|
if (cell.callbackType === 'script' && cell.verify && cell.verify.cbScripts) {
|
if (item.subtype === 'dualdatacard' && isback) {
|
let _item = fromJS(item).toJS()
|
_item.columns = _item.subColumns || []
|
|
let msg = getSysBackSql(cell, _item)
|
|
sqls.push({uuid: 'back_' + cell.uuid, type: 'btnCallBack', ...msg})
|
} else {
|
let msg = getSysBackSql(cell, item)
|
|
sqls.push({uuid: 'back_' + cell.uuid, type: 'btnCallBack', ...msg})
|
}
|
}
|
if (['pop', 'formSubmit'].includes(cell.OpenType) && cell.modal && cell.modal.fields) {
|
cell.modal.fields.forEach(form => {
|
// 数据源sql语句，预处理，权限黑名单字段设置为隐藏表单
|
if (['select', 'link', 'multiselect', 'radio', 'checkbox', 'checkcard'].includes(form.type) && form.resourceType === '1') {
|
let msg = getFormSql(form, '表单')
|
|
sqls.push({uuid: md5(cell.uuid + form.uuid), type: 'form', ...msg})
|
} else if (form.type === 'popSelect') {
|
let msg = getPopSelectSql(form)
|
|
sqls.push({uuid: md5(cell.uuid + form.uuid), type: 'popSource', ...msg})
|
}
|
})
|
}
|
} else if (cell.OpenType === 'excelIn') {
|
if (cell.intertype === 'system') {
|
let msg = getExcelInSql(cell)
|
|
sqls.push({uuid: cell.uuid, roleId: roleId, type: 'excelIn', ...msg})
|
}
|
} else if (cell.OpenType === 'excelOut') {
|
if (cell.intertype === 'system' && cell.verify && cell.verify.dataType === 'custom') {
|
let msg = getExcelOutSql(cell, item)
|
|
sqls.push({uuid: cell.uuid, roleId: roleId, type: 'excelOut', ...msg})
|
} else if (cell.intertype === 'system' && cell.verify && item.setting && item.setting.interType === 'system') {
|
if (appType === 'mob') {
|
cell.pagination = 'false'
|
}
|
if (item.subtype === 'dualdatacard' || item.setting.laypage !== cell.pagination) {
|
let msg = getDoubleExcelOutSql(cell, item)
|
|
sqls.push({uuid: cell.uuid, roleId: roleId, type: 'excelOut', ...msg})
|
}
|
}
|
|
} else if (cell.OpenType === 'funcbutton') {
|
if (cell.funcType === 'print') {
|
if (cell.intertype === 'system' && cell.verify && cell.verify.dataType === 'custom') {
|
let msg = getPrintSql(cell, item)
|
|
sqls.push({uuid: cell.uuid, roleId: roleId, type: 'print', ...msg})
|
}
|
if (cell.execMode === 'pop' && cell.modal && cell.modal.fields) {
|
cell.modal.fields.forEach(form => {
|
// 数据源sql语句，预处理，权限黑名单字段设置为隐藏表单
|
if (['select', 'link', 'multiselect', 'radio', 'checkbox', 'checkcard'].includes(form.type) && form.resourceType === '1') {
|
let msg = getFormSql(form, '表单')
|
|
sqls.push({uuid: md5(cell.uuid + form.uuid), type: 'form', ...msg})
|
} else if (form.type === 'popSelect') {
|
let msg = getPopSelectSql(form)
|
|
sqls.push({uuid: md5(cell.uuid + form.uuid), type: 'popSource', ...msg})
|
}
|
})
|
}
|
} else if ((cell.funcType === 'refund' || cell.funcType === 'pay') && cell.payMode === 'system') {
|
let msg = getPaySql(cell, item)
|
|
sqls.push({uuid: cell.uuid, roleId: roleId, type: 'pay', ...msg})
|
}
|
} else if (cell.OpenType === 'innerpage' || cell.OpenType === 'outerpage') {
|
if (cell.pageTemplate === 'pay' && cell.payMode === 'system') {
|
let msg = getPaySql(cell, item)
|
|
sqls.push({uuid: cell.uuid, roleId: roleId, type: 'pay', ...msg})
|
}
|
} else if (cell.OpenType === 'popview') {
|
if (cell.config && cell.config.components && cell.config.enabled) {
|
let _mainSearch = []
|
|
if (appType === 'mob') {
|
cell.config.components.forEach(item => {
|
if (item.type === 'search' && item.wrap.field) {
|
_mainSearch.push({
|
type: 'text',
|
label: item.wrap.label,
|
field: item.wrap.field,
|
match: item.wrap.match,
|
required: item.wrap.required,
|
value: item.wrap.initval || ''
|
})
|
}
|
})
|
} else {
|
cell.config.components.forEach(component => {
|
if (component.type !== 'search') return
|
|
_mainSearch = component.search || []
|
})
|
}
|
|
let label = (item.name ? '-' + item.name : '') + '-' + cell.label
|
|
filterComponent(cell.config.components, _mainSearch, label, true)
|
}
|
}
|
}
|
|
let getSearches = (searches) => {
|
let sFields = []
|
searches.forEach(item => {
|
if (!item.field) return
|
|
if (item.type === 'group') {
|
sFields.push(item.field)
|
sFields.push(item.datefield)
|
sFields.push(item.datefield + '1')
|
} else if (item.type === 'date') {
|
if (sFields.includes(item.field)) {
|
sFields.push(item.field + '1')
|
} else {
|
sFields.push(item.field)
|
}
|
} else if (item.type === 'dateweek') {
|
sFields.push(item.field)
|
sFields.push(item.field + '1')
|
} else if (item.type === 'range') {
|
sFields.push(item.field)
|
sFields.push(item.field + '1')
|
} else if (item.type === 'datemonth') {
|
if (item.match === '=') {
|
sFields.push(item.field)
|
} else {
|
sFields.push(item.field)
|
sFields.push(item.field + '1')
|
}
|
} else if (item.type === 'daterange') {
|
if (/,/.test(item.field)) {
|
sFields.push(item.field.split(',')[0])
|
sFields.push(item.field.split(',')[1])
|
} else {
|
sFields.push(item.field)
|
sFields.push(item.field + '1')
|
}
|
} else if (item.type === 'text' || item.type === 'select') {
|
item.field.split(',').forEach(field => {
|
sFields.push(field)
|
})
|
} else {
|
sFields.push(item.field)
|
}
|
})
|
|
return sFields
|
}
|
|
let getSysDefaultSql = (btn, component) => {
|
let primaryId = '@ID@'
|
let BID = '@BID@'
|
let verify = btn.verify || {}
|
let _actionType = null
|
let setting = component.setting || {}
|
let columns = component.columns || []
|
let primaryKey = setting.primaryKey || 'id'
|
let colreps = [] // 待替换变量集
|
|
if (verify.invalid === 'true') {
|
if (component.wrap && (component.wrap.datatype === 'static' || component.wrap.datatype === 'public')) {
|
verify.invalid = 'false'
|
} else if (setting.maxScript && setting.maxScript >= 300) {
|
verify.invalid = 'false'
|
} else if (!setting.dataresource) {
|
verify.invalid = 'false'
|
} else if (btn.intertype !== 'system' && btn.procMode !== 'system') {
|
verify.invalid = 'false'
|
} else if (btn.sqlType === 'insert') {
|
verify.invalid = 'false'
|
} else if (btn.Ot === 'notRequired') {
|
verify.invalid = 'false'
|
}
|
}
|
if (verify.uniques && verify.uniques.length > 0 && btn.Ot === 'requiredOnce') {
|
if (component.wrap && (component.wrap.datatype === 'static' || component.wrap.datatype === 'public')) {
|
verify.uniques = []
|
}
|
}
|
|
if (verify.default !== 'false') { // 判断是否使用默认sql
|
_actionType = btn.sqlType
|
}
|
|
let _initCustomScript = '' // 初始化脚本
|
let _prevCustomScript = '' // 默认sql前执行脚本
|
let _backCustomScript = '' // 默认sql后执行脚本
|
|
verify.scripts && verify.scripts.forEach(item => {
|
if (item.status === 'false') return
|
|
if (item.position === 'init') {
|
_initCustomScript += `
|
/* 自定义脚本 */
|
${item.sql}
|
`
|
} else if (item.position === 'front') {
|
_prevCustomScript += `
|
/* 自定义脚本 */
|
${item.sql}
|
`
|
} else {
|
_backCustomScript += `
|
/* 自定义脚本 */
|
${item.sql}
|
`
|
}
|
})
|
|
// 需要声明的变量集
|
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 _sql = ''
|
|
let _initFormfields = []
|
let _declares = []
|
|
let formdata = null
|
let formkeys = []
|
if (btn.OpenType === 'pop' || btn.OpenType === 'formSubmit') {
|
formdata = []
|
if (btn.modal && btn.modal.fields) {
|
btn.modal.fields.forEach(item => {
|
if (!item.field) return
|
|
let _item = {
|
key: item.field,
|
fieldlen: item.fieldlength || 50,
|
writein: item.writein !== 'false',
|
type: item.type,
|
isconst: item.constant === 'true'
|
}
|
|
if (item.type === 'linkMain' && item.verifyVal === 'true') {
|
_item.$verify = true
|
_item.label = item.label
|
}
|
|
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
|
}
|
|
formdata.push(_item)
|
})
|
}
|
} else if (btn.OpenType === 'form') {
|
formdata = []
|
|
let item = {
|
type: 'text',
|
readin: true,
|
writein: true,
|
fieldlen: 50,
|
key: btn.field
|
}
|
if (btn.formType === 'counter') {
|
item.type = 'number'
|
item.fieldlen = 0
|
} else if (btn.formType === 'switch' || btn.formType === 'radio') {
|
if (typeof(btn.openVal) === 'number') {
|
item.type = 'number'
|
item.fieldlen = 0
|
}
|
}
|
formdata.push(item)
|
}
|
|
let verifyValSql = ''
|
// 获取字段键值对
|
formdata && formdata.forEach(form => {
|
if (form.$verify) {
|
verifyValSql += `
|
if @${form.key}=${form.type === 'number' ? 0 : `''`}
|
begin
|
select @errorcode='E',@retmsg='${form.label}，关联主表失效'
|
goto aaa
|
end
|
`
|
}
|
|
let _key = form.key.toLowerCase()
|
|
if (!formkeys.includes(_key)) {
|
formkeys.push(_key)
|
if (form.type === 'number' || form.type === 'rate') {
|
_initFormfields.push(`@${_key}=@mk_${_key}_mk@`)
|
} else if (form.type === 'date') {
|
_initFormfields.push(`@${_key}='@mk_${_key}_mk@'`)
|
} else if (form.type === 'select' || form.type === 'link' || form.type === 'radio') {
|
_initFormfields.push(`@${_key}='@mk_${_key}_mk@'`)
|
} else if (form.isconst) {
|
_initFormfields.push(`@${_key}=N'@mk_${_key}_mk@'`)
|
} else {
|
_initFormfields.push(`@${_key}='@mk_${_key}_mk@'`)
|
}
|
}
|
|
if (!_vars.includes(_key)) {
|
_vars.push(_key)
|
|
if (form.fieldlen && form.fieldlen > 4000) {
|
form.fieldlen = 'max'
|
}
|
|
let _type = `nvarchar(${form.fieldlen})`
|
|
if (form.type.match(/date/ig)) {
|
_type = 'datetime'
|
} else if (form.type === 'number') {
|
_type = `decimal(18,${form.fieldlen})`
|
} else if (form.type === 'rate') {
|
_type = `decimal(18,2)`
|
}
|
|
_declares.push(`@${_key} ${_type}`)
|
}
|
})
|
|
// 表单变量赋值
|
if (_initFormfields.length > 0) {
|
_sql += `
|
/* 表单变量赋值 */
|
select ${_initFormfields.join(',')}
|
`
|
}
|
if (btn.Ot !== 'notRequired' && columns.length > 0) {
|
_sql += '@mk_cols_values@'
|
}
|
|
// 去除禁用的验证
|
if (verify.contrasts) {
|
verify.contrasts = verify.contrasts.filter(item => item.status !== 'false')
|
}
|
if (verify.uniques) {
|
verify.uniques = verify.uniques.filter(item => item.status !== 'false')
|
}
|
if (verify.customverifys) {
|
verify.customverifys = verify.customverifys.filter(item => item.status !== 'false')
|
}
|
if (verify.billcodes) {
|
verify.billcodes = verify.billcodes.filter(item => item.status !== 'false')
|
}
|
|
if (_initCustomScript) {
|
_sql += _initCustomScript
|
}
|
|
// 启用账期验证
|
if (verify.accountdate === 'true') {
|
let orgcode = `''`
|
let date = `''`
|
if (verify.accountfield) {
|
orgcode = '@' + verify.accountfield
|
}
|
if (verify.voucherdate) {
|
date = '@' + verify.voucherdate
|
}
|
|
_sql += `
|
/* 账期验证 */
|
exec s_FIBVoucherDateCheck @OrgCode=${orgcode},@FIBVoucherDate=${date},@ErrorCode=@ErrorCode OUTPUT,@retmsg=@retmsg OUTPUT
|
if @ErrorCode!=''
|
GOTO aaa
|
`
|
}
|
|
// 失效验证，添加数据时不用
|
if (verify.invalid === 'true') {
|
let datasource = setting.dataresource
|
let customScript = setting.customScript || ''
|
|
let regoptions = [{
|
reg: new RegExp('@orderBy@', 'ig'),
|
value: setting.order || primaryKey
|
}, {
|
reg: new RegExp('@pageSize@', 'ig'),
|
value: 1
|
}, {
|
reg: new RegExp('@pageIndex@', 'ig'),
|
value: 1
|
}]
|
|
regoptions.forEach(item => {
|
datasource = datasource.replace(item.reg, item.value)
|
customScript = customScript.replace(item.reg, item.value)
|
})
|
|
if (customScript) {
|
_sql += `
|
/* 数据源自定义脚本，请注意变量定义是否重复 */
|
${customScript}
|
`
|
}
|
|
if (btn.Ot === 'requiredOnce') {
|
_sql += `
|
/* 失效验证 */
|
select @tbid='', @ErrorCode='',@retmsg=''
|
select @tbid='X' from ${datasource} right join (select ID from dbo.SplitComma(@ID@)) sp
|
on tb.${primaryKey} =sp.id where tb.${primaryKey} is null
|
|
If @tbid!=''
|
Begin
|
select @ErrorCode='E',@retmsg='数据已失效'
|
goto aaa
|
end
|
`
|
} else {
|
_sql += `
|
/* 失效验证 */
|
select @tbid='', @ErrorCode='',@retmsg=''
|
select @tbid=${primaryKey} from ${datasource} where ${primaryKey}=@ID@
|
If @tbid=''
|
Begin
|
select @ErrorCode='E',@retmsg='数据已失效'
|
goto aaa
|
end
|
`
|
}
|
}
|
|
// 比较验证
|
if (verify.contrasts && verify.contrasts.length > 0) {
|
verify.contrasts.forEach(item => {
|
_sql += `
|
/* 比较验证 */
|
If ${item.frontfield} ${item.operator} ${item.backfield}
|
Begin
|
select @ErrorCode='${item.errorCode}',@retmsg='${item.errmsg}'
|
goto aaa
|
end
|
`
|
})
|
}
|
|
// 自定义验证
|
verify.customverifys && verify.customverifys.forEach(item => {
|
_sql += `
|
/* 自定义验证 */
|
select @tbid='', @ErrorCode='',@retmsg=''
|
select top 1 @tbid='X' from (${item.sql}) a
|
If @tbid ${item.result === 'true' ? '!=' : '='}''
|
Begin
|
select @ErrorCode='${item.errorCode}',@retmsg='${item.errmsg}'
|
goto aaa
|
end
|
`
|
})
|
|
// 单号生成，使用上级id（BID）或列表数据，声明变量（检验）
|
let _billcodesSql = ''
|
if (formdata && verify.billcodes && verify.billcodes.length > 0) {
|
verify.billcodes.forEach(item => {
|
let _key = item.field.toLowerCase()
|
|
if (!formkeys.includes(_key)) return // 表单中不含单号生成字段
|
|
let _lpline = ''
|
if (item.TypeCharOne === 'Lp') {
|
if (/^BID$/ig.test(item.linkField)) {
|
_lpline = `set @ModularDetailCode= 'Lp'+ right('${item.mark || btn.uuid}'+@BID@,48)`
|
} else {
|
_lpline = `set @ModularDetailCode= 'Lp'+ right('${item.mark || btn.uuid}'+@${item.linkField},48)`
|
}
|
} else if (item.TypeCharOne === 'BN') {
|
if (/^BID$/ig.test(item.linkField)) {
|
_lpline = `set @ModularDetailCode= 'BN'+ right(@BID@,48)`
|
} else {
|
_lpline = `set @ModularDetailCode= 'BN'+ right(@${item.linkField},48)`
|
}
|
} else {
|
_lpline = `set @ModularDetailCode= right('${item.ModularDetailCode}',50)`
|
}
|
|
_billcodesSql += `
|
/* 单号生成 */
|
select @BillCode='', @${_key}='', @ModularDetailCode=''
|
${_lpline}
|
exec s_get_BillCode
|
@ModularDetailCode=@ModularDetailCode,
|
@Type=${item.Type},
|
@TypeCharOne='${item.TypeCharOne}',
|
@TypeCharTwo ='${item.TypeCharTwo}',
|
@BillCode =@BillCode output,
|
@ErrorCode =@ErrorCode output,
|
@retmsg=@retmsg output
|
if @ErrorCode!=''
|
goto aaa
|
set @${_key}=@BillCode
|
`
|
})
|
|
if (_actionType !== 'insertOrUpdate') {
|
_sql += _billcodesSql
|
}
|
}
|
|
// 唯一性验证，必须存在表单（表单存在时，主键均为单值）,必须填写数据源，多行拼接时不可用
|
if (formdata && verify.uniques && verify.uniques.length > 0 && btn.Ot !== 'requiredOnce') {
|
let nFields = []
|
let dataFields = []
|
formdata.forEach(form => {
|
let _key = form.key.toLowerCase()
|
if (form.type === 'number' || form.type === 'rate') {
|
nFields.push(_key)
|
} else if (form.type === 'date') {
|
dataFields.push(_key)
|
}
|
})
|
if (columns && columns.length > 0 && btn.Ot !== 'notRequired') {
|
columns.forEach(col => {
|
let _key = col.field.toLowerCase()
|
if (col.type === 'number') {
|
if (!nFields.includes(_key)) {
|
nFields.push(_key)
|
}
|
} else if (/^date/ig.test(col.datatype)) {
|
if (!dataFields.includes(_key)) {
|
dataFields.push(_key)
|
}
|
}
|
})
|
}
|
verify.uniques.forEach(item => {
|
let _fieldValue = [] // 表单键值对field=value
|
let _value = [] // 表单值，用于错误提示
|
let _labels = item.fieldlabel.split(',') // 表单提示文字
|
let arr = [] // 验证主键
|
|
item.field.split(',').forEach((_field, index) => {
|
let _key = _field.toLowerCase()
|
let _val = ''
|
let _val2 = ''
|
|
arr.push(_key)
|
if (_key === 'bid') {
|
_val = BID
|
} else {
|
// _val = `'@mk_${_key}_mk@'`
|
_val = `@${_field}`
|
}
|
|
_fieldValue.push(`${_key}=${_val}`)
|
|
if (_key === 'bid') {
|
_val2 = `' + ${BID} + '`
|
} else {
|
// _val2 = `@mk_${_key}_mk@`
|
if (nFields.includes(_key)) {
|
_val2 = `' + cast (@${_field} as nvarchar(50)) + '`
|
} else if (dataFields.includes(_key)) {
|
_val2 = `' + CONVERT(nvarchar(50), @${_field}, 23) + '`
|
} else {
|
_val2 = `' + @${_field} + '`
|
}
|
}
|
|
_value.push(`${_labels[index] || ''}：${_val2}`)
|
})
|
|
if (!arr.includes(primaryKey.toLowerCase()) && btn.Ot !== 'notRequired') {
|
_fieldValue.push(`${primaryKey} !=${primaryId}`)
|
}
|
|
_sql += `
|
/* 唯一性验证 */
|
select @tbid='', @ErrorCode='',@retmsg=''
|
select @tbid='X' from ${btn.sql} where ${_fieldValue.join(' and ')}${item.verifyType === 'logic' ? ' and deleted=0' : ''}
|
If @tbid!=''
|
Begin
|
select @ErrorCode='${item.errorCode}',@retmsg='${_value.join(', ')} 已存在'
|
goto aaa
|
end
|
`
|
})
|
} else if (verify.uniques && verify.uniques.length > 0 && btn.Ot === 'requiredOnce' && setting.dataresource) {
|
let datasource = setting.dataresource
|
if (/\s/.test(datasource)) { // 拼接别名
|
if (!/tb$/.test(datasource)) {
|
datasource = '(' + datasource + ') tb'
|
}
|
} else {
|
datasource = datasource + ' tb'
|
}
|
|
if (setting.customScript) {
|
_sql += `
|
/* 数据源自定义脚本，请注意变量定义是否重复 */
|
${setting.customScript}
|
`
|
}
|
|
verify.uniques.forEach(item => {
|
_sql += `
|
/* 同类数据验证 */
|
Set @tbid=''
|
|
Select top 1 @tbid='X' from (select distinct ${item.field},1 as n from ${datasource} inner join (select ID from dbo.SplitComma(@ID@)) sp on tb.${primaryKey}=sp.ID ) a having sum(n)>1
|
|
If @tbid!=''
|
Begin
|
Set @ErrorCode='E' Set @retmsg='${item.fieldlabel} 值不唯一'
|
goto aaa
|
end
|
`
|
})
|
}
|
|
let hasvoucher = false
|
|
// 凭证-显示列中选取,必须选行
|
if (verify.voucher && verify.voucher.enabled) {
|
let _voucher = verify.voucher
|
let linkField = `@${_voucher.linkField}`
|
|
if (/^BID$/ig.test(_voucher.linkField)) {
|
linkField = BID
|
}
|
|
hasvoucher = true
|
|
_sql += `
|
/* 创建凭证 */
|
exec s_BVoucher_Create
|
@Bill = ${linkField},
|
@BVoucherType ='${_voucher.BVoucherType}',
|
@VoucherTypeOne ='${_voucher.VoucherTypeOne}',
|
@VoucherTypeTwo ='${_voucher.VoucherTypeTwo}',
|
@Type =${_voucher.Type},
|
@UserID=@UserID@,
|
@Username=@Username,
|
@FullName=@FullName,
|
@BVoucher =@BVoucher OUTPUT ,
|
@FIBVoucherDate =@FIBVoucherDate OUTPUT ,
|
@FiYear =@FiYear OUTPUT ,
|
@ErrorCode =@ErrorCode OUTPUT,
|
@retmsg=@retmsg OUTPUT
|
if @ErrorCode!=''
|
GOTO aaa
|
`
|
}
|
|
let _insertsql = ''
|
if (_actionType === 'insert' || _actionType === 'insertOrUpdate') { // 添加语句
|
let keys = []
|
let values = []
|
|
formdata.forEach(item => {
|
if (item.writein === false) return
|
let _key = item.key.toLowerCase()
|
|
keys.push(_key)
|
values.push('@' + _key)
|
})
|
|
if (!keys.includes(primaryKey.toLowerCase())) {
|
keys.push(primaryKey.toLowerCase())
|
values.push(primaryId)
|
}
|
if (!keys.includes('createuserid')) {
|
keys.push('createuserid')
|
values.push('@userid@')
|
}
|
if (!keys.includes('createuser')) {
|
keys.push('createuser')
|
values.push('@username')
|
}
|
if (!keys.includes('createstaff')) {
|
keys.push('createstaff')
|
values.push('@fullname')
|
}
|
if (!keys.includes('bid')) {
|
keys.push('bid')
|
values.push('@BID@')
|
}
|
|
if (!keys.includes('typename')) {
|
keys.push('typename')
|
values.push('@typename@')
|
}
|
|
keys = keys.join(',')
|
values = values.join(',')
|
_insertsql = `insert into ${btn.sql} (${keys}) select ${values};`
|
}
|
|
let _updatesql = ''
|
if (_actionType === 'update' || _actionType === 'audit' || _actionType === 'insertOrUpdate') { // 修改语句
|
let _form = []
|
let _arr = []
|
|
formdata.forEach(item => {
|
if (item.writein === false) return
|
let _key = item.key.toLowerCase()
|
|
_arr.push(_key)
|
_form.push(_key + '=@' + _key)
|
})
|
|
if (_actionType === 'audit') {
|
if (!_arr.includes('submitdate')) {
|
_form.push('submitdate=getdate()')
|
}
|
if (!_arr.includes('submituser')) {
|
_form.push('submituser=@username')
|
}
|
if (!_arr.includes('submitstaff')) {
|
_form.push('submitstaff=@fullname')
|
}
|
if (!_arr.includes('submituserid')) {
|
_form.push('submituserid=@userid@')
|
}
|
} else {
|
if (!_arr.includes('modifydate')) {
|
_form.push('modifydate=getdate()')
|
}
|
if (!_arr.includes('modifyuser')) {
|
_form.push('modifyuser=@username')
|
}
|
if (!_arr.includes('modifystaff')) {
|
_form.push('modifystaff=@fullname')
|
}
|
if (!_arr.includes('modifyuserid')) {
|
_form.push('modifyuserid=@userid@')
|
}
|
}
|
|
if (hasvoucher) {
|
if (!_arr.includes('bvoucher')) {
|
_form.push('BVoucher=@BVoucher')
|
}
|
if (!_arr.includes('fibvoucherdate')) {
|
_form.push('FIBVoucherDate=@FIBVoucherDate')
|
}
|
if (!_arr.includes('fiyear')) {
|
_form.push('FiYear=@FiYear')
|
}
|
}
|
if (!_arr.includes('typename')) {
|
_form.push('typename=@typename@')
|
}
|
_form = _form.join(',')
|
|
let _ID = '=@ID@'
|
if (btn.Ot === 'requiredOnce') {
|
_ID = ' in (select ID from dbo.SplitComma(@ID@))'
|
}
|
|
_updatesql = `update ${btn.sql} set ${_form} where ${primaryKey}${_ID};`
|
}
|
|
if (_prevCustomScript) {
|
_sql += _prevCustomScript
|
}
|
|
// 添加、修改、逻辑删除、物理删除
|
if (_actionType === 'insert') {
|
_sql += `
|
/* 默认sql */
|
${_insertsql}`
|
} else if (_actionType === 'update' || _actionType === 'audit') {
|
_sql += `
|
/* 默认sql */
|
${_updatesql}`
|
} else if (_actionType === 'LogicDelete') { // 逻辑删除
|
let _ID = '=@ID@'
|
if (btn.Ot === 'requiredOnce') {
|
_ID = ' in (select ID from dbo.SplitComma(@ID@))'
|
}
|
|
_sql += `
|
/* 默认sql */
|
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 (columns && columns.length > 0 && btn.Ot !== 'notRequired') {
|
let _index = 0
|
columns.forEach(col => {
|
if (_index >= 4 || col.field === primaryKey) return
|
|
colreps.push(col.field)
|
|
_msg += col.label + `=@mk_${col.field}_mk@,`
|
_index++
|
})
|
}
|
|
let _ID = '=@ID@'
|
if (btn.Ot === 'requiredOnce') {
|
_ID = ' in (select ID from dbo.SplitComma(@ID@))'
|
}
|
|
_sql += `
|
/* 默认sql */
|
insert into snote (remark,createuserid,CreateUser,CreateStaff,typename) select left('删除表:${btn.sql} 数据: ${_msg}${primaryKey}='+@ID@,200),@userid@,@username,@fullname,@typename@
|
delete ${btn.sql} where ${primaryKey}${_ID};`
|
} else if (_actionType === 'insertOrUpdate') {
|
_sql += `
|
/* 默认sql */
|
select @tbid=''
|
select @tbid='X' from ${btn.sql} where ${primaryKey}=@ID@
|
if @tbid=''
|
begin
|
${_billcodesSql}
|
${_insertsql}
|
end
|
else
|
begin
|
${_updatesql}
|
end
|
`
|
}
|
|
if (verify.workFlow === 'true' && verify.flowSql === 'true' && process) {
|
if (verify.flowType === 'start') {
|
_sql += `
|
/* 工作流异常sql */
|
if @works_flow_error@ != ''
|
begin
|
select @ErrorCode='E',@retmsg=@works_flow_error@ goto aaa
|
end
|
|
/* 工作流默认sql */
|
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,bid,createuserid,CreateUser,CreateStaff,upid)
|
select @ID@,@works_flow_code@,@works_flow_name@ ,@works_flow_param@,@status@,@statusname@,@works_flow_detail_id@,@work_group@,@work_grade@,@bid@,@UserID@,@UserName,@FullName,@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@
|
insert into s_my_works_flow_role (works_flow_id,works_flow_code,userid,works_flow_detail_id,createuserid,CreateUser,CreateStaff,upid,typecharone)
|
select @ID@,@works_flow_code@,@userid@,@works_flow_detail_id@,@userid@,@UserName,@FullName,@time_id@,'begin'
|
`
|
} else {
|
let field = '@works_flow_sign_field@'
|
let label = '@works_flow_sign_label@'
|
|
_sql += `
|
/* 工作流异常sql */
|
if @works_flow_error@ != ''
|
begin
|
select @ErrorCode='E',@retmsg=@works_flow_error@ goto aaa
|
end
|
|
if @works_flow_countersign@ = 'Y'
|
begin
|
/* 工作流默认sql（会签） */
|
set @retmsg =''
|
select @retmsg='X' from s_my_works_flow_role where works_flow_id=@ID@ and works_flow_code=@works_flow_code@ and deleted=0 and userid =@userid@ and works_flow_detail_id =@works_flow_detail_id
|
|
if @retmsg =''
|
begin
|
select @retmsg='X' from s_my_works_flow_role where works_flow_id=@ID@ and works_flow_code=@works_flow_code@ and userid=@userid@ and works_flow_detail_id =@works_flow_detail_id
|
if @retmsg !=''
|
begin
|
select @ErrorCode='E', @retmsg='当前单据已审核，请刷新后重试'
|
goto aaa
|
end
|
|
set @retmsg =''
|
select @retmsg=userid from s_my_works_flow_role where works_flow_id=@id@ and works_flow_code=@works_flow_code@ and deleted=0 and works_flow_detail_id =@works_flow_detail_id
|
|
if @retmsg !=''
|
begin
|
select @retmsg=workerCode+workerName from BD_workers where id=@retmsg
|
|
select @retmsg='页面数据已更新，或没有当前单据的审批权限，请联系'+@retmsg+'操作'
|
goto aaa
|
end
|
|
select @retmsg='页面数据已更新，或没有当前单据的审批权限'
|
goto aaa
|
end
|
|
declare @works_flow_statuscharone nvarchar(50),@works_flow_statuschartwo nvarchar(50),@works_flow_statuscharthree nvarchar(50),@works_flow_statuscharfour nvarchar(50),@works_flow_statuscharfive nvarchar(50),@works_flow_key_id nvarchar(50),@works_flow_key_status nvarchar(20),@s_my_works_flow_log_param nvarchar(max),@s_my_works_flow_log_status int,@s_my_works_flow_log_statusname nvarchar(50),@s_my_works_flow_log_detail_id nvarchar(50)
|
select @works_flow_statuscharone='',@works_flow_statuschartwo='',@works_flow_statuscharthree='',@works_flow_statuscharfour='',@works_flow_statuscharfive='',@works_flow_key_id='',@works_flow_key_status ='',@s_my_works_flow_log_param='',@s_my_works_flow_log_status=0,@s_my_works_flow_log_statusname='',@s_my_works_flow_log_detail_id=''
|
|
select @works_flow_statuscharone=statuscharone,@works_flow_statuschartwo=statuschartwo,@works_flow_statuscharthree=statuscharthree,@works_flow_statuscharfour=statuscharfour,@works_flow_statuscharfive=statuscharfive,@works_flow_key_id=id,@s_my_works_flow_log_param=works_flow_param,@s_my_works_flow_log_status=status,@s_my_works_flow_log_statusname=statusname,@s_my_works_flow_log_detail_id=works_flow_detail_id
|
from s_my_works_flow where works_flow_id=@ID@ and works_flow_code=@works_flow_code@ and deleted=0
|
|
if @works_flow_statuscharone + @works_flow_statuschartwo + @works_flow_statuscharthree + @works_flow_statuscharfour + @works_flow_statuscharfive = @works_flow_sign_values@
|
begin
|
set @works_flow_key_status='Y'
|
end
|
|
if @works_flow_key_status='Y'
|
begin
|
update s_my_works_flow set ${field}=${label},status=@status@,statusname=@statusname@,works_flow_param=@works_flow_param@,works_flow_detail_id=@works_flow_detail_id@,modifydate=getdate(),upid=@time_id@,modifyuserid=@userid@,modifyuser=@username,modifystaff=@fullname${verify.flowRemark ? ',remark=@' + verify.flowRemark : ''}
|
where id=@works_flow_key_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,bid,createuserid,CreateUser,CreateStaff,upid${verify.flowRemark ? ',remark' : ''},${field})
|
select @ID@,@works_flow_code@,@works_flow_name@ ,@works_flow_param@,@status@,@statusname@,@works_flow_detail_id@,@work_group@,@work_grade@,@bid@,@UserID@,@UserName,@FullName,@time_id@${verify.flowRemark ? ',@' + verify.flowRemark : ''},${label}
|
|
update s_my_works_flow_role set deleted=10,modifydate=getdate(),upid=@time_id@,modifyuserid=@userid@,modifyuser=@username,modifystaff=@fullname
|
where works_flow_id=@ID@ and works_flow_code=@works_flow_code@ and deleted=0
|
|
if @check_userids@ != ''
|
begin
|
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
|
update n
|
set deleted=10,modifydate=getdate(),upid=@time_id@,modifyuserid=@userid@,modifyuser=@username,modifystaff=@fullname
|
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
|
end
|
else
|
begin
|
update s_my_works_flow set ${field}=${label},modifydate=getdate(),upid=@time_id@,modifyuserid=@userid@,modifyuser=@username,modifystaff=@fullname${verify.flowRemark ? ',remark=@' + verify.flowRemark : ''}
|
where id =@works_flow_key_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,bid,createuserid,CreateUser,CreateStaff,upid${verify.flowRemark ? ',remark' : ''},${field})
|
select @ID@,@works_flow_code@,@works_flow_name@ ,@s_my_works_flow_log_param,@s_my_works_flow_log_status,@s_my_works_flow_log_statusname,@s_my_works_flow_log_detail_id,@work_group@,@work_grade@,@bid@,@UserID@,@UserName,@FullName,@time_id@${verify.flowRemark ? ',@' + verify.flowRemark : ''},${label}
|
|
update s_my_works_flow_role set deleted=10,modifydate=getdate(),upid=@time_id@,modifyuserid=@userid@,modifyuser=@username,modifystaff=@fullname
|
where works_flow_id=@ID@ and works_flow_code=@works_flow_code@ and deleted=0 and userid =@userid@
|
end
|
end
|
else
|
begin
|
/* 工作流默认sql（或签） */
|
set @retmsg =''
|
select @retmsg='X' from s_my_works_flow_role where works_flow_id=@ID@ and works_flow_code=@works_flow_code@ and deleted=0 and userid =@userid@ and works_flow_detail_id =@works_flow_detail_id
|
|
if @retmsg =''
|
begin
|
select @retmsg='X' from s_my_works_flow_role where works_flow_id=@ID@ and works_flow_code=@works_flow_code@ and userid=@userid@ and works_flow_detail_id =@works_flow_detail_id
|
|
if @retmsg !=''
|
begin
|
select @ErrorCode='E', @retmsg='当前单据已审核，请刷新后重试'
|
goto aaa
|
end
|
|
if @dataM@ !=''
|
begin
|
set @retmsg =''
|
select @retmsg='X' from s_my_works_flow_role where works_flow_id=@ID@ and works_flow_code=@works_flow_code@ and deleted=0 and works_flow_detail_id =@works_flow_detail_id
|
|
if @retmsg != ''
|
begin
|
goto goto_mk
|
end
|
end
|
else
|
begin
|
set @retmsg =''
|
select @retmsg=userid from s_my_works_flow_role where works_flow_id=@id@ and works_flow_code=@works_flow_code@ and deleted=0 and works_flow_detail_id =@works_flow_detail_id
|
|
if @retmsg !=''
|
begin
|
select @retmsg=workerCode+workerName from BD_workers where id=@retmsg
|
|
select @retmsg='页面数据已更新，或没有当前单据的审批权限，请联系'+@retmsg+'操作'
|
goto aaa
|
end
|
end
|
|
select @retmsg='页面数据已更新，或没有当前单据的审批权限'
|
goto aaa
|
end
|
|
goto_mk:
|
|
set @retmsg=''
|
|
update s_my_works_flow set status=@status@,statusname=@statusname@,works_flow_param=@works_flow_param@,works_flow_detail_id=@works_flow_detail_id@,modifydate=getdate(),upid=@time_id@,modifyuserid=@userid@,modifyuser=@username,modifystaff=@fullname${verify.flowRemark ? ',remark=@' + verify.flowRemark : ''}
|
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,bid,createuserid,CreateUser,CreateStaff,upid${verify.flowRemark ? ',remark' : ''})
|
select @ID@,@works_flow_code@,@works_flow_name@ ,@works_flow_param@,@status@,@statusname@,@works_flow_detail_id@,@work_group@,@work_grade@,@bid@,@UserID@,@UserName,@FullName,@time_id@${verify.flowRemark ? ',@' + verify.flowRemark : ''}
|
|
if @works_begin_branch@ = 'Y'
|
begin
|
update s_my_works_flow_role set deleted=0,modifydate=getdate(),upid=@time_id@,modifyuserid=@userid@,modifyuser=@username,modifystaff=@fullname,works_flow_detail_id=@works_flow_detail_id@
|
where works_flow_id=@ID@ and works_flow_code=@works_flow_code@ and typecharone='begin'
|
end
|
else
|
begin
|
update s_my_works_flow_role set deleted=10,modifydate=getdate(),upid=@time_id@,modifyuserid=@userid@,modifyuser=@username,modifystaff=@fullname
|
where works_flow_id=@ID@ and works_flow_code=@works_flow_code@ and deleted=0
|
end
|
|
if @check_userids@ != ''
|
begin
|
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
|
update n
|
set deleted=10,modifydate=getdate(),upid=@time_id@,modifyuserid=@userid@,modifyuser=@username,modifystaff=@fullname
|
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
|
end
|
`
|
}
|
|
if (_backCustomScript) {
|
_sql += _backCustomScript
|
}
|
} else if (_backCustomScript) {
|
_sql += _backCustomScript
|
}
|
|
if (verifyValSql) {
|
_sql += verifyValSql
|
}
|
|
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']
|
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_userids', 'notice_userids', 'works_flow_sign']
|
worksReFields.forEach(n => {
|
_sql = _sql.replace(new RegExp('@' + n + '@', 'ig'), `'@${n}@'`)
|
})
|
}
|
}
|
|
// 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 += `
|
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 += `
|
select @ErrorCode as ErrorCode,@retmsg as retmsg,${btn.output} as mk_b_id
|
${callback}
|
`
|
} else {
|
_sql += `
|
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']
|
|
// 添加数据中字段，表单值优先(按钮不选行或多行拼接时跳过)
|
if (btn.Ot !== 'notRequired' && columns.length > 0) {
|
let _initColfields = []
|
columns.forEach(col => {
|
let _key = col.field.toLowerCase()
|
|
if (formkeys.includes(_key) || !new RegExp('@' + _key + '[^0-9a-z_@]', 'ig').test(_sql)) return
|
// if (_key === 'id' && !/@id[^0-9a-z_@]/ig.test(_sql)) return
|
|
colreps.push(col.field)
|
|
if (col.type === 'number') {
|
_initColfields.push(`@${_key}=@mk_${_key}_mk@`)
|
} else {
|
_initColfields.push(`@${_key}='@mk_${_key}_mk@'`)
|
}
|
|
if (!_vars.includes(_key)) {
|
_declares.push(`@${_key} ${col.datatype || 'nvarchar(50)'}`)
|
}
|
})
|
|
// 显示列变量赋值
|
if (_initColfields.length > 0) {
|
_sql = _sql.replace('@mk_cols_values@', `
|
/* 显示列变量赋值 */
|
select ${_initColfields.join(',')}
|
`)
|
} else {
|
_sql = _sql.replace('@mk_cols_values@', '')
|
}
|
}
|
|
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='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)) {
|
if (['RoleID', 'mk_departmentcode', 'mk_organization'].includes(s)) {
|
decSql.push(`@${s} nvarchar(512)`)
|
} else if (['mk_address'].includes(s)) {
|
decSql.push(`@mk_address nvarchar(100)`)
|
} else {
|
decSql.push(`@${s} nvarchar(50)`)
|
}
|
secSql.push(`@${s}=@${s}@`)
|
reps.push(s)
|
}
|
})
|
|
if (new RegExp('@mk_submit_type[^0-9a-z_]', 'ig').test(_sql)) {
|
decSql.push(`@mk_submit_type nvarchar(50)`)
|
secSql.push(`@mk_submit_type=@mk_submit_type@`)
|
reps.push('mk_submit_type')
|
}
|
|
decSql = [...decSql, ..._declares]
|
|
// 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}
|
`
|
|
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
|
})
|
|
if (/\$@/ig.test(_sql)) {
|
_sql = _sql.replace(/\$@/ig, ' @datam_begin@ ').replace(/@\$/ig, ' @datam_end@ ')
|
reps.push('datam_begin', 'datam_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')
|
}
|
}
|
reps.forEach(n => {
|
if (['datam_begin', 'datam_end', 'mk_check_begin', 'mk_check_end'].includes(n)) return
|
|
_sql = _sql.replace(new RegExp('@' + n + '@', 'ig'), `'@${n}@'`)
|
})
|
if (/@db@/ig.test(_sql)) {
|
reps.push('db')
|
}
|
|
_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
|
})
|
|
colreps = Array.from(new Set(colreps))
|
reps = [...reps, ...colreps]
|
|
return { LText: _sql, md5: md5(_sql), reps }
|
}
|
|
let getSysBackSql = (btn, component) => {
|
let verify = btn.verify || {}
|
let columns = component.columns || []
|
let colreps = [] // 待替换变量集
|
let _prev = ''
|
let _back = ''
|
let tables = []
|
let reps = []
|
|
verify.cbScripts.forEach(script => {
|
if (script.status === 'false') return
|
|
if (/\s#[a-z0-9_]+(\s|\()/ig.test(script.sql)) {
|
tables.push(...script.sql.match(/\s#[a-z0-9_]+(\s|\()/ig))
|
}
|
|
if (script.position === 'front') {
|
_prev += `
|
/* 自定义脚本 */
|
${script.sql}
|
`
|
} else {
|
_back += `
|
/* 自定义脚本 */
|
${script.sql}
|
`
|
}
|
})
|
|
tables = tables.map(tb => tb.replace(/\s|\(/g, ''))
|
|
// 需要声明的变量集
|
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 _sql = ''
|
|
let _initFormfields = []
|
let _declares = []
|
|
let formdata = null
|
let formkeys = []
|
if (btn.OpenType === 'pop' || btn.OpenType === 'formSubmit') {
|
formdata = []
|
if (btn.modal && btn.modal.fields) {
|
btn.modal.fields.forEach(item => {
|
if (!item.field) return
|
|
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
|
}
|
|
formdata.push(_item)
|
})
|
}
|
} else if (btn.OpenType === 'form') {
|
formdata = []
|
|
let item = {
|
type: 'text',
|
readin: true,
|
writein: true,
|
fieldlen: 50,
|
key: btn.field
|
}
|
if (btn.formType === 'counter') {
|
item.type = 'number'
|
item.fieldlen = 0
|
} else if (btn.formType === 'switch' || btn.formType === 'radio') {
|
if (typeof(btn.openVal) === 'number') {
|
item.type = 'number'
|
item.fieldlen = 0
|
}
|
}
|
formdata.push(item)
|
}
|
|
// 获取字段键值对
|
formdata && formdata.forEach(form => {
|
let _key = form.key.toLowerCase()
|
|
if (!formkeys.includes(_key)) {
|
formkeys.push(_key)
|
if (form.type === 'number' || form.type === 'rate') {
|
_initFormfields.push(`@${_key}=@mk_${_key}_mk@`)
|
} else if (form.type === 'date') {
|
_initFormfields.push(`@${_key}='@mk_${_key}_mk@'`)
|
} else if (form.type === 'select' || form.type === 'link' || form.type === 'radio') {
|
_initFormfields.push(`@${_key}='@mk_${_key}_mk@'`)
|
} else if (form.isconst) {
|
_initFormfields.push(`@${_key}=N'@mk_${_key}_mk@'`)
|
} else {
|
_initFormfields.push(`@${_key}='@mk_${_key}_mk@'`)
|
}
|
}
|
|
if (!_vars.includes(_key)) {
|
_vars.push(_key)
|
|
if (form.fieldlen && form.fieldlen > 4000) {
|
form.fieldlen = 'max'
|
}
|
|
let _type = `nvarchar(${form.fieldlen})`
|
|
if (form.type.match(/date/ig)) {
|
_type = 'datetime'
|
} else if (form.type === 'number') {
|
_type = `decimal(18,${form.fieldlen})`
|
} else if (form.type === 'rate') {
|
_type = `decimal(18,2)`
|
}
|
|
_declares.push(`@${_key} ${_type}`)
|
}
|
})
|
|
// 表单变量赋值
|
if (_initFormfields.length > 0) {
|
_sql += `
|
/* 表单变量赋值 */
|
select ${_initFormfields.join(',')}
|
`
|
}
|
|
let testSql = _prev + _back + (btn.output || '')
|
|
// 添加数据中字段，表单值优先(按钮不选行或多行拼接时跳过)
|
if (btn.Ot !== 'notRequired' && columns.length > 0) {
|
let _initColfields = []
|
columns.forEach(col => {
|
let _key = col.field.toLowerCase()
|
|
if (formkeys.includes(_key) || !new RegExp('@' + _key + '[^0-9a-z_@]', 'ig').test(testSql)) return
|
// if (_key === 'id' && !/@id[^0-9a-z_@]/ig.test(testSql)) return
|
|
colreps.push(col.field)
|
|
if (col.type === 'number') {
|
_initColfields.push(`@${_key}=@mk_${_key}_mk@`)
|
} else {
|
_initColfields.push(`@${_key}='@mk_${_key}_mk@'`)
|
}
|
|
if (!_vars.includes(_key)) {
|
_declares.push(`@${_key} ${col.datatype || 'nvarchar(50)'}`)
|
}
|
})
|
|
// 显示列变量赋值
|
if (_initColfields.length > 0) {
|
_sql += `
|
/* 显示列变量赋值 */
|
select ${_initColfields.join(',')}
|
`
|
}
|
}
|
|
_sql += `
|
${_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 += `
|
select @ErrorCode as ErrorCode,@retmsg as retmsg,${btn.output} as mk_b_id
|
${callback}
|
`
|
} else {
|
_sql += `
|
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='S',@retmsg=''`]
|
|
syses.forEach(s => {
|
if (new RegExp('@' + s + '[^0-9a-z_]', 'ig').test(_sql)) {
|
if (['RoleID', 'mk_departmentcode', 'mk_organization'].includes(s)) {
|
decSql.push(`@${s} nvarchar(512)`)
|
} else if (['mk_address'].includes(s)) {
|
decSql.push(`@mk_address nvarchar(100)`)
|
} else if (['mk_deleted'].includes(s)) {
|
decSql.push(`@mk_deleted int`)
|
} else {
|
decSql.push(`@${s} nvarchar(50)`)
|
}
|
if (['tbid', 'BillCode', 'BVoucher', 'FIBVoucherDate', 'FiYear', 'ModularDetailCode'].includes(s)) {
|
secSql.push(`@${s}=''`)
|
} else if (['mk_deleted'].includes(s)) {
|
secSql.push(`@mk_deleted=1`)
|
} else if (['bid'].includes(s)) {
|
secSql.push(`@bid=@BID@`)
|
} else {
|
secSql.push(`@${s}=@${s}@`)
|
reps.push(s)
|
}
|
}
|
})
|
|
if (new RegExp('@mk_submit_type[^0-9a-z_]', 'ig').test(_sql)) {
|
decSql.push(`@mk_submit_type nvarchar(50)`)
|
secSql.push(`@mk_submit_type=@mk_submit_type@`)
|
reps.push('mk_submit_type')
|
}
|
|
decSql = [...decSql, ..._declares]
|
|
_sql = `/* ${btn.logLabel}(回调) */
|
BEGIN TRY
|
begin TRAN
|
|
Declare ${decSql.join(',')}
|
/* 初始化赋值 */
|
select ${secSql.join(',')}
|
${_sql}
|
`
|
|
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
|
})
|
|
if (/\$@/ig.test(_sql)) {
|
_sql = _sql.replace(/\$@/ig, ' @datam_begin@ ').replace(/@\$/ig, ' @datam_end@ ')
|
reps.push('datam_begin', 'datam_end')
|
}
|
reps.forEach(n => {
|
if (['datam_begin', 'datam_end'].includes(n)) return
|
|
_sql = _sql.replace(new RegExp('@' + n + '@', 'ig'), `'@${n}@'`)
|
})
|
if (/@db@/ig.test(_sql)) {
|
reps.push('db')
|
}
|
|
_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, md5: md5(_sql), reps, tbs: tables }
|
}
|
|
let getDataSource = (item, mainSearch = [], type) => {
|
let searches = item.search || []
|
if (item.setting.useMSearch === 'true' && mainSearch.length > 0) {
|
searches = [...searches, ...mainSearch]
|
}
|
item.$searches = fromJS(searches).toJS()
|
let sFields = getSearches(searches)
|
|
let _columns = []
|
if (item.subtype === 'dualdatacard' && item.setting.subdata !== 'sub_data_string') {
|
_columns = [...item.columns, ...item.subColumns]
|
} else if (item.columns) {
|
_columns = [...item.columns]
|
}
|
|
let arr_field = _columns.map(col => col.field).join(',')
|
|
let _customScript = ''
|
let _tailScript = ''
|
let _dataresource = ''
|
item.scripts && item.scripts.forEach(script => {
|
if (script.status === 'false') return
|
if (script.position !== 'back') {
|
_customScript += `
|
${script.sql}
|
`
|
} else {
|
_tailScript += `
|
${script.sql}
|
`
|
}
|
})
|
|
// 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 = ''
|
}
|
|
let custompage = false
|
let testSql = _dataresource + _customScript + _tailScript
|
|
if (/order\s+by\s+sort_id\s*$/i.test(_dataresource)) {
|
custompage = true
|
} else if (/@pageSize@|@orderBy@|@mk_total/i.test(testSql)) {
|
custompage = true
|
}
|
|
if (/\s/.test(_dataresource) && !/\)\s+tb$/.test(_dataresource)) {
|
_dataresource = '(' + _dataresource + ') tb'
|
}
|
|
item.setting.dataresource = _dataresource
|
item.setting.customScript = _customScript
|
|
let decSql = [`@ErrorCode nvarchar(50),@retmsg nvarchar(4000)`]
|
let secSql = [`@ErrorCode='S',@retmsg =''`]
|
|
let reps = []
|
|
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 => {
|
if (new RegExp('@' + s + '[^0-9a-z_]', 'ig').test(testSql)) {
|
if (['RoleID', 'mk_departmentcode', 'mk_organization'].includes(s)) {
|
decSql.push(`@${s} nvarchar(512)`)
|
} else if (['mk_address'].includes(s)) {
|
decSql.push(`@mk_address nvarchar(100)`)
|
} else {
|
decSql.push(`@${s} nvarchar(50)`)
|
}
|
secSql.push(`@${s}=@${s}@`)
|
reps.push(s)
|
}
|
})
|
|
decSql = `declare ${decSql.join(',')}${type === 'print' ? '@mk_print_declare@' : ''}
|
select ${secSql.join(',')}${type === 'print' ? '@mk_print_select@' : ''}`
|
|
// 不需要单引号：orderBy、pageSize、pageIndex、db
|
let regs = [...sFields, 'orderBy', 'pageSize', 'pageIndex', 'ID', 'BID', 'time_id', 'datam', 'typename']
|
|
if (item.hasExtend) {
|
regs.push('mk_time')
|
}
|
if (item.type === 'calendar') {
|
regs.push('mk_year')
|
}
|
if (window.GLOB.getLocation) {
|
regs.push('mk_longitude', 'mk_latitude')
|
}
|
if (urlFields) {
|
regs.push(...urlFields)
|
}
|
if (process) {
|
regs.push('works_flow_code')
|
}
|
|
regs.forEach(s => {
|
if (new RegExp('@' + s + '@', 'ig').test(testSql)) {
|
reps.push(s)
|
}
|
})
|
|
let LText = ''
|
let DateCount = ''
|
if (_dataresource) {
|
/*system_query*/
|
if (custompage || (item.wrap && item.wrap.tree === 'true')) {
|
LText = `select ${arr_field} from ${_dataresource} ${_search} `
|
} else if (item.setting.laypage === 'true' && item.setting.order) {
|
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' && item.setting.subdata !== 'sub_data_string') {
|
DateCount = `select count(1) as total from (select distinct ${item.setting.primaryKey || 'ID'} from ${_dataresource} ${_search})a`
|
} else {
|
DateCount = `select count(1) as total from ${_dataresource} ${_search}`
|
}
|
} else if (item.setting.$top) {
|
if (item.setting.order) {
|
LText = `select top 1 ${arr_field} from ${_dataresource} ${_search} order by @orderBy@ `
|
reps.push('orderBy')
|
} else {
|
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 = `select ${arr_field} from ${_dataresource} ${_search} order by @orderBy@ `
|
reps.push('orderBy')
|
} else {
|
LText = `select ${arr_field} from ${_dataresource} ${_search} `
|
}
|
}
|
|
let sub_name = ''
|
let tabid = ''
|
let parid = ''
|
let sub_field = ''
|
|
if (item.subtype === 'dualdatacard' && item.setting.subdata !== 'sub_data_string') {
|
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 = ''
|
let e_sql = `select ${_columns.map(col => col.field).join(',')} from (select ${_columns.map(col => /date/ig.test(col.datatype) ? `'1949-10-01' as ${col.field}` : `'0' as ${col.field}`).join(',')}) a where ${item.setting.primaryKey || 'ID'} != '0'`
|
if (DateCount) {
|
e_sql += `
|
select 0 as total
|
`
|
}
|
|
if (item.setting.transact === 'true' && !/BEGIN\s+TRY\s+begin\s+TRAN/.test(_customScript)) {
|
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}'
|
`
|
|
_tailScript = `${_tailScript}
|
select @ErrorCode as ErrorCode,@retmsg as retmsg
|
|
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:
|
${e_sql}
|
select @ErrorCode as ErrorCode,@retmsg as retmsg
|
GOTO_RETURN:
|
ROLLBACK TRAN
|
`
|
} else {
|
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}'
|
`
|
|
let tail = 'aaa:'
|
if (/\sgoto\s+aaa([^0-9a-z_]|$)/ig.test(_customScript) && !/BEGIN\s+TRY\s+begin\s+TRAN/.test(_customScript)) {
|
tail = `if 1=2
|
begin
|
aaa:
|
${e_sql}
|
end`
|
}
|
|
_tailScript = `${_tailScript}
|
${tail}
|
select @ErrorCode as ErrorCode,@retmsg as retmsg
|
`
|
}
|
|
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}
|
`
|
|
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
|
})
|
|
if (/\$@/ig.test(sql)) {
|
sql = sql.replace(/\$@/ig, ' @datam_begin@ ').replace(/@\$/ig, ' @datam_end@ ')
|
reps.push('datam_begin', 'datam_end')
|
}
|
reps.forEach(n => {
|
if (['orderBy', 'pageSize', 'pageIndex', 'datam_begin', 'datam_end'].includes(n)) return
|
|
sql = sql.replace(new RegExp('@' + n + '@', 'ig'), `'@${n}@'`)
|
})
|
if (/@db@/ig.test(sql)) {
|
reps.push('db')
|
}
|
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, luser: /@userid@/ig.test(testSql)}
|
}
|
|
let getExcelInSql = (item) => {
|
let btn = item.verify
|
let sheet = item.sheet.replace(/@db@/ig, '')
|
let database = ''
|
if (/@db@/ig.test(item.sheet)) {
|
database = '@db@'
|
}
|
|
let sql = ''
|
|
let _initCustomScript = '' // 初始化脚本
|
let _prevCustomScript = '' // 默认sql前执行脚本
|
let _backCustomScript = '' // 默认sql后执行脚本
|
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})`},
|
]
|
|
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) {
|
let textFields = []
|
let numberFields = []
|
let dateFields = []
|
btn.columns.forEach((col) => {
|
if (/Nvarchar/ig.test(col.type)) {
|
textFields.push(col.Column)
|
} else if (/Decimal|int/ig.test(col.type)) {
|
numberFields.push(col.Column)
|
} else if (/date/ig.test(col.type)) {
|
dateFields.push(col.Column)
|
}
|
})
|
btn.uniques.forEach(unique => {
|
if (unique.status === 'false' || !unique.verifyType) return
|
|
let _fields = unique.field.split(',')
|
let _fields_ = _fields.map(_field => `a.${_field}=b.${_field}`)
|
_fields_ = _fields_.join(' and ')
|
|
let _where = []
|
_fields.forEach(f => {
|
if (textFields.includes(f)) {
|
_where.push(`${f}!=''`)
|
} else if (numberFields.includes(f)) {
|
_where.push(`${f}!=0`)
|
} else if (dateFields.includes(f)) {
|
_where.push(`${f}>'1949-10-01'`)
|
}
|
})
|
_where = _where.length ? `where ${_where.join(' and ')} ` : ''
|
|
if (unique.verifyType === 'logic' || unique.verifyType === 'logic_temp') {
|
_fields_ += ' and b.deleted=0'
|
}
|
|
let _afields = []
|
_fields = _fields.map(f => {
|
if (numberFields.includes(f)) {
|
_afields.push(`cast(a.${f} as nvarchar(50))`)
|
return `cast(${f} as nvarchar(50))`
|
} else if (dateFields.includes(f)) {
|
_afields.push(`CONVERT(nvarchar(50), a.${f}, 21)`)
|
return `CONVERT(nvarchar(50), ${f}, 21)`
|
}
|
_afields.push(`a.${f}`)
|
|
return f
|
})
|
|
_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
|
|
If @tbid!=''
|
Begin
|
select @ErrorCode='${unique.errorCode}',@retmsg=@tbid+' 重复'
|
goto aaa
|
end
|
|
${unique.verifyType.indexOf('temp') === -1 ? `Set @tbid=''
|
Select top 1 @tbid=${_afields.join('+\' \'+')} from ${_where ? `(select * from #${sheet} ${_where})` : `#${sheet}`} a Inner join ${sheet} b on ${_fields_}
|
|
If @tbid!=''
|
Begin
|
select @ErrorCode='${unique.errorCode}',@retmsg=@tbid+' 与已有数据重复'
|
goto aaa
|
end` : ''}
|
`
|
})
|
}
|
|
let declarefields = []
|
let fields = []
|
|
btn.columns.forEach(col => {
|
if (col.import === 'false') return
|
|
if (col.type === 'date') {
|
declarefields.push(`${col.Column} Nvarchar(50)`)
|
} else {
|
declarefields.push(`${col.Column} ${col.type}`)
|
}
|
fields.push(col.Column)
|
})
|
|
fields = fields.join(',')
|
|
let _insert = ''
|
if (btn.default !== 'false') {
|
_insert = `
|
/* 默认sql */
|
Insert into ${database}${sheet} (${fields},createuserid,createuser,createstaff,bid)
|
Select ${fields},@UserID@,@username,@fullname,@BID@ From #${sheet}
|
`
|
}
|
|
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='S',@retmsg=''@mk_init_select@
|
${_initCustomScript}
|
|
Insert into #${sheet} (${fields},jskey,BID)
|
|
/* excel数据*/
|
@mk_excel_data@
|
|
${_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') {
|
sql += `
|
/* 工作流异常sql */
|
if @works_flow_error@ != ''
|
begin
|
select @ErrorCode='E',@retmsg=@works_flow_error@ goto aaa
|
end
|
|
/* 工作流默认sql */
|
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 jskey,@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@
|
from #${sheet}
|
|
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,bid,createuserid,CreateUser,CreateStaff,upid)
|
select jskey,@works_flow_code@,@works_flow_name@ ,@works_flow_param@,@status@,@statusname@,@works_flow_detail_id@,@work_group@,@work_grade@,@bid@,@UserID@,@UserName,@FullName,@time_id@
|
from #${sheet}
|
|
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 jskey,@works_flow_code@,@works_flow_detail_id@,@userid@,@start_type@,@userid@,@UserName,@FullName,@time_id@
|
from #${sheet}
|
|
insert into s_my_works_flow_role (works_flow_id,works_flow_code,userid,works_flow_detail_id,createuserid,CreateUser,CreateStaff,upid,typecharone)
|
select jskey,@works_flow_code@,@userid@,@works_flow_detail_id@,@userid@,@UserName,@FullName,@time_id@,'begin'
|
from #${sheet}
|
`
|
}
|
|
sql += `
|
${_backCustomScript}
|
|
drop table #${sheet}
|
${mk_ent}
|
select @ErrorCode as ErrorCode,@retmsg as retmsg
|
${callback}`
|
|
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']
|
worksReFields.forEach(n => {
|
sql = sql.replace(new RegExp('@' + n + '@', 'ig'), `'@${n}@'`)
|
})
|
} else {
|
sql += `
|
${_backCustomScript}
|
|
drop table #${sheet}
|
${mk_ent}
|
select @ErrorCode as ErrorCode,@retmsg as retmsg
|
${callback}`
|
}
|
|
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 = []
|
let decSql = []
|
let secSql = []
|
|
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 => {
|
if (new RegExp('@' + s + '[^0-9a-z_]', 'ig').test(sql)) {
|
if (['RoleID', 'mk_departmentcode', 'mk_organization'].includes(s)) {
|
decSql.push(`@${s} nvarchar(512)`)
|
} else if (['mk_address'].includes(s)) {
|
decSql.push(`@mk_address nvarchar(100)`)
|
} else {
|
decSql.push(`@${s} nvarchar(50)`)
|
}
|
secSql.push(`@${s}=@${s}@`)
|
reps.push(s)
|
}
|
})
|
|
decSql = decSql.length ? `,${decSql.join(',')}` : ''
|
secSql = secSql.length ? `,${secSql.join(',')}` : ''
|
|
sql = sql.replace(/@mk_init_declare@/ig, decSql)
|
sql = sql.replace(/@mk_init_select@/ig, secSql)
|
|
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
|
})
|
|
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')
|
}
|
reps.forEach(n => {
|
if (['datam_begin', 'datam_end', 'mk_check_begin', 'mk_check_end'].includes(n)) return
|
|
sql = sql.replace(new RegExp('@' + n + '@', 'ig'), `'@${n}@'`)
|
})
|
|
if (/@db@/ig.test(sql)) {
|
reps.push('db')
|
}
|
|
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, setting) => {
|
let sheet = btn.sheet.replace(/@db@/ig, '')
|
let database = ''
|
if (/@db@/ig.test(btn.sheet)) {
|
database = '@db@'
|
}
|
|
let forms = []
|
let _forms = {}
|
let index = 0
|
|
let getColumns = (cols) => {
|
cols.forEach(item => {
|
if (item.type === 'colspan') {
|
getColumns(item.subcols)
|
} else if (item.editable === 'true') {
|
item.$sort = index
|
_forms[item.field] = item
|
index++
|
}
|
})
|
}
|
|
getColumns(cols)
|
|
columns.forEach(item => {
|
if (item.field === setting.primaryKey) return
|
|
if (_forms[item.field]) {
|
let _item = {..._forms[item.field]}
|
if (_item.editType === 'date') {
|
_item.datatype = _item.declareType || 'datetime'
|
} else {
|
_item.datatype = item.datatype
|
}
|
|
forms.push(_item)
|
} else {
|
forms.push({...item, $sort: 999})
|
}
|
})
|
|
forms.sort((a, b) => a.$sort - b.$sort)
|
|
let sql = ''
|
|
let _initCustomScript = '' // 初始化脚本
|
let _prevCustomScript = '' // 默认sql前执行脚本
|
let _backCustomScript = '' // 默认sql后执行脚本
|
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})`},
|
]
|
|
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) {
|
let textFields = []
|
let numberFields = []
|
let dateFields = []
|
columns.forEach((col) => {
|
if (/Nvarchar/ig.test(col.datatype)) {
|
textFields.push(col.field)
|
} else if (/Decimal|int/ig.test(col.datatype)) {
|
numberFields.push(col.field)
|
} else if (/date/ig.test(col.datatype)) {
|
dateFields.push(col.field)
|
}
|
})
|
btn.uniques.forEach(unique => {
|
if (unique.status === 'false' || !unique.verifyType) return
|
|
let _fields = unique.field.split(',')
|
let _fields_ = _fields.map(_field => `a.${_field}=b.${_field}`)
|
_fields_ = _fields_.join(' and ')
|
_fields_ += ` and a.jskey != b.${setting.primaryKey || 'id'}`
|
|
let _where = []
|
_fields.forEach(f => {
|
if (textFields.includes(f)) {
|
_where.push(`${f}!=''`)
|
} else if (numberFields.includes(f)) {
|
_where.push(`${f}!=0`)
|
} else if (dateFields.includes(f)) {
|
_where.push(`${f}>'1949-10-01'`)
|
}
|
})
|
_where = _where.length ? `where ${_where.join(' and ')} ` : ''
|
|
if (unique.verifyType === 'logic' || unique.verifyType === 'logic_temp') {
|
_fields_ += ' and b.deleted=0'
|
}
|
|
let _afields = []
|
_fields = _fields.map(f => {
|
if (numberFields.includes(f)) {
|
_afields.push(`cast(a.${f} as nvarchar(50))`)
|
return `cast(${f} as nvarchar(50))`
|
} else if (dateFields.includes(f)) {
|
_afields.push(`CONVERT(nvarchar(50), a.${f}, 21)`)
|
return `CONVERT(nvarchar(50), ${f}, 21)`
|
}
|
_afields.push(`a.${f}`)
|
|
return f
|
})
|
|
_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
|
|
If @tbid!=''
|
Begin
|
select @ErrorCode='${unique.errorCode}',@retmsg=@tbid+' 重复'
|
goto aaa
|
end
|
|
${unique.verifyType.indexOf('temp') === -1 ? `Set @tbid=''
|
Select top 1 @tbid=${_afields.join('+\' \'+')} from ${_where ? `(select * from #${sheet} ${_where})` : `#${sheet}`} a Inner join ${sheet} b on ${_fields_}
|
|
If @tbid!=''
|
Begin
|
select @ErrorCode='${unique.errorCode}',@retmsg=@tbid+' 与已有数据重复'
|
goto aaa
|
end` : ''}
|
`
|
})
|
}
|
|
let declarefields = []
|
let fields = []
|
let upFields = []
|
|
forms.forEach(col => {
|
let key = col.field.toLowerCase()
|
if (key === 'jskey' || key === 'bid' || key === 'data_type') return
|
|
declarefields.push(`${col.field} ${col.datatype}`)
|
fields.push(col.field)
|
upFields.push(`${col.field}=t.${col.field}`)
|
})
|
|
fields = fields.join(',')
|
upFields = upFields.join(',')
|
|
let _insert = ''
|
if (btn.default !== 'false') {
|
_insert = `
|
/* 默认sql */
|
update a set ${upFields},modifydate=getdate(),modifyuserid=@UserID@,modifyuser=@username,modifystaff=@fullname,deleted=0
|
from (select * from #${sheet} where data_type='upt') t
|
inner join ${database}${sheet} a on t.jskey=a.${setting.primaryKey || 'id'}
|
|
update a set deleted=1,modifydate=getdate(),modifyuserid=@UserID@,modifyuser=@username,modifystaff=@fullname
|
from (select * from #${sheet} where data_type='del') t
|
inner join ${database}${sheet} a on t.jskey=a.${setting.primaryKey || 'id'}
|
|
delete t from #${sheet} t inner join ${database}${sheet} a on t.jskey=a.${setting.primaryKey || 'id'}
|
|
Insert into ${database}${sheet} (${fields},createuserid,createuser,createstaff,bid)
|
Select ${fields},@UserID@,@username,@fullname,@BID@ From #${sheet}
|
`
|
}
|
|
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='S',@retmsg=''@mk_init_select@
|
|
${_initCustomScript}
|
Insert into #${sheet} (${fields},jskey,data_type,BID)
|
|
/* table数据*/
|
@mk_excel_data@
|
|
${_uniquesql}
|
${_prevCustomScript}
|
${_insert}
|
${_backCustomScript}
|
|
drop table #${sheet}
|
|
select @ErrorCode as ErrorCode,@retmsg as retmsg
|
${callback}`
|
|
let reps = []
|
let decSql = []
|
let secSql = []
|
|
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 => {
|
if (new RegExp('@' + s + '[^0-9a-z_]', 'ig').test(sql)) {
|
if (['RoleID', 'mk_departmentcode', 'mk_organization'].includes(s)) {
|
decSql.push(`@${s} nvarchar(512)`)
|
} else if (['mk_address'].includes(s)) {
|
decSql.push(`@mk_address nvarchar(100)`)
|
} else {
|
decSql.push(`@${s} nvarchar(50)`)
|
}
|
secSql.push(`@${s}=@${s}@`)
|
reps.push(s)
|
}
|
})
|
|
decSql = decSql.length ? `,${decSql.join(',')}` : ''
|
secSql = secSql.length ? `,${secSql.join(',')}` : ''
|
|
sql = sql.replace(/@mk_init_declare@/ig, decSql)
|
sql = sql.replace(/@mk_init_select@/ig, secSql)
|
|
let regs = ['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
|
})
|
|
if (/\$@/ig.test(sql)) {
|
sql = sql.replace(/\$@/ig, ' @datam_begin@ ').replace(/@\$/ig, ' @datam_end@ ')
|
reps.push('datam_begin', 'datam_end')
|
}
|
reps.forEach(n => {
|
if (['datam_begin', 'datam_end'].includes(n)) return
|
|
sql = sql.replace(new RegExp('@' + n + '@', 'ig'), `'@${n}@'`)
|
})
|
if (/@db@/ig.test(sql)) {
|
reps.push('db')
|
}
|
|
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) => {
|
let item = {setting: {}, columns: [], search: [], useMSearch: 'false'}
|
|
btn.verify.columns.forEach(col => {
|
if (col.output === 'false' || !col.Column || col.Column === '$Index') return
|
item.columns.push({
|
field: col.Column
|
})
|
})
|
|
if (btn.verify.useSearch !== 'false') {
|
item.search = component.$searches
|
}
|
|
item.setting.interType = 'system'
|
item.setting.execute = btn.verify.defaultSql || 'true'
|
item.setting.dataresource = btn.verify.dataresource || ''
|
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'
|
}
|
|
item.scripts = btn.verify.scripts || []
|
|
let msg = getDataSource(item, [])
|
|
return msg
|
}
|
|
let getDoubleExcelOutSql = (btn, component) => {
|
let item = fromJS(component).toJS()
|
item.search = item.$searches || []
|
|
if (item.subtype === 'dualdatacard') {
|
item.columns = [...item.columns, ...item.subColumns]
|
}
|
item.subtype = 'datacard'
|
|
item.setting.laypage = btn.pagination
|
item.setting.$name = btn.logLabel || ''
|
|
let msg = getDataSource(item, [])
|
|
return msg
|
}
|
|
let getPrintSql = (btn, component) => {
|
let item = {setting: {}, columns: btn.verify.columns || [], search: [], useMSearch: 'false'}
|
|
item.setting.interType = 'system'
|
item.setting.execute = btn.verify.setting.defaultSql || 'true'
|
item.setting.dataresource = btn.verify.setting.dataresource || ''
|
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, [], '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 = `/* ${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
|
|
_sql += `
|
${item.sql}
|
`
|
})
|
|
if (btn.output) {
|
_sql += `
|
select @ErrorCode as ErrorCode,@retmsg as retmsg,${btn.output} as mk_b_id
|
${callback}`
|
} else {
|
_sql += `
|
select @ErrorCode as ErrorCode,@retmsg as retmsg
|
${callback}`
|
}
|
|
let reps = []
|
let decSql = []
|
let secSql = []
|
|
let syses = ['UserName', 'FullName', 'RoleID', 'mk_departmentcode', 'mk_organization', 'mk_user_type', 'mk_nation', 'mk_province', 'mk_city', 'mk_district', 'mk_address', 'BID']
|
syses.forEach(s => {
|
if (new RegExp('@' + s + '[^0-9a-z_]', 'ig').test(_sql)) {
|
if (['RoleID', 'mk_departmentcode', 'mk_organization'].includes(s)) {
|
decSql.push(`@${s} nvarchar(512)`)
|
} else if (['mk_address'].includes(s)) {
|
decSql.push(`@mk_address nvarchar(100)`)
|
} else {
|
decSql.push(`@${s} nvarchar(50)`)
|
}
|
secSql.push(`@${s}=@${s}@`)
|
reps.push(s)
|
}
|
})
|
|
let regs = ['ID', 'time_id', 'datam', 'typename']
|
|
regs.forEach(s => {
|
if (new RegExp('@' + s + '@', 'ig').test(_sql)) {
|
reps.push(s)
|
}
|
})
|
|
syses = syses.map(n => n.toLowerCase())
|
syses.push('tbid')
|
|
let colreps = []
|
component.columns.forEach(col => {
|
let _key = col.field.toLowerCase()
|
|
if (syses.includes(_key) || !new RegExp('@' + _key + '[^0-9a-z_@]', 'ig').test(_sql)) return
|
// if (_key === 'id' && !/@id[^0-9a-z_@]/ig.test(_sql)) return
|
|
colreps.push(col.field)
|
|
decSql.push(`@${col.field} ${col.datatype || 'nvarchar(50)'}`)
|
|
if (col.type === 'number') {
|
secSql.push(`@${col.field}=@mk_${col.field}_mk@`)
|
} else {
|
secSql.push(`@${col.field}='@mk_${col.field}_mk@'`)
|
}
|
})
|
|
decSql = decSql.length ? `,${decSql.join(',')}` : ''
|
secSql = secSql.length ? `,${secSql.join(',')}` : ''
|
|
_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
|
})
|
|
if (/\$@/ig.test(_sql)) {
|
_sql = _sql.replace(/\$@/ig, ' @datam_begin@ ').replace(/@\$/ig, ' @datam_end@ ')
|
reps.push('datam_begin', 'datam_end')
|
}
|
reps.forEach(n => {
|
if (['datam_begin', 'datam_end'].includes(n)) return
|
|
_sql = _sql.replace(new RegExp('@' + n + '@', 'ig'), `'@${n}@'`)
|
})
|
if (/@db@/ig.test(_sql)) {
|
reps.push('db')
|
}
|
|
_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, tname) => {
|
let arrfield = [item.valueField, item.valueText]
|
|
if (item.type === 'checkcard') {
|
arrfield = item.fields ? item.fields.map(f => f.field) : []
|
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)
|
}
|
}
|
|
if (item.linkField) {
|
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) {
|
arrfield.push(item.disableField)
|
}
|
|
arrfield = Array.from(new Set(arrfield))
|
|
let _datasource = item.dataSource
|
let sql = ''
|
|
if (/\s/.test(_datasource)) { // 拼接别名
|
_datasource = '(' + _datasource + ') tb'
|
}
|
|
arrfield = arrfield.join(',')
|
|
if (item.orderBy) {
|
sql = `select distinct ${arrfield},${item.orderBy} as orderfield from ${_datasource} order by orderfield ${item.orderType}`
|
} else {
|
sql = `select distinct ${arrfield} from ${_datasource}`
|
}
|
|
let reps = []
|
|
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 (['mk_departmentcode', 'mk_organization'].includes(s)) {
|
decSql.push(`@${s} nvarchar(512)`)
|
} else {
|
decSql.push(`@${s} nvarchar(20)`)
|
}
|
secSql.push(`@${s}=@${s}@`)
|
reps.push(s)
|
}
|
})
|
|
decSql = decSql.join(',')
|
secSql = secSql.join(',')
|
decSql = decSql ? `Declare ${decSql} select ${secSql}` : ''
|
|
sql = `/* ${item.label}（${tname}） */
|
SELECT obj_name='${item.field}',prm_field='',str_field='',
|
arr_field='${arrfield}',tabid='',parid='',sub_name='',sub_field=''
|
|
${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)
|
|
if (/\$@/ig.test(sql)) {
|
sql = sql.replace(/\$@/ig, ' @datam_begin@ ').replace(/@\$/ig, ' @datam_end@ ')
|
reps.push('datam_begin', 'datam_end')
|
}
|
reps.forEach(n => {
|
if (['datam_begin', 'datam_end'].includes(n)) return
|
|
sql = sql.replace(new RegExp('@' + n + '@', 'ig'), `'@${n}@'`)
|
})
|
if (/@db@/ig.test(sql)) {
|
reps.push('db')
|
}
|
|
// 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) => {
|
let arrfield = item.columns.map(f => f.field)
|
|
if (item.linkSubField && item.linkSubField.length > 0) {
|
item.linkSubField.forEach(n => {
|
if (!arrfield.includes(n)) {
|
arrfield.push(n)
|
}
|
})
|
}
|
|
arrfield = arrfield.join(',')
|
if (/\s/.test(item.dataSource)) { // 拼接别名
|
item.dataSource = '(' + item.dataSource + ') tb'
|
}
|
|
let LText = ''
|
let DateCount = ''
|
let _search = ''
|
let reps = []
|
let sFields = []
|
|
if (item.searchKey) {
|
_search = '@mk_search@'
|
sFields = item.searchKey.split(',')
|
}
|
|
// 不需要单引号：orderBy、pageSize、pageIndex、db
|
let regs = [...sFields, 'orderBy', 'pageSize', 'pageIndex', 'ID', 'BID', 'time_id', 'datam']
|
|
regs.forEach(s => {
|
if (new RegExp('@' + s + '@', 'ig').test(item.dataSource)) {
|
reps.push(s)
|
}
|
})
|
|
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(item.dataSource)) {
|
if (['mk_departmentcode', 'mk_organization'].includes(s)) {
|
decSql.push(`@${s} nvarchar(512)`)
|
} else {
|
decSql.push(`@${s} nvarchar(20)`)
|
}
|
secSql.push(`@${s}=@${s}@`)
|
reps.push(s)
|
}
|
})
|
|
decSql = decSql.join(',')
|
secSql = secSql.join(',')
|
decSql = decSql ? `Declare ${decSql} select ${secSql}` : ''
|
|
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
|
})
|
|
if (/\$@/ig.test(sql)) {
|
sql = sql.replace(/\$@/ig, ' @datam_begin@ ').replace(/@\$/ig, ' @datam_end@ ')
|
reps.push('datam_begin', 'datam_end')
|
}
|
reps.forEach(n => {
|
if (['orderBy', 'pageSize', 'pageIndex', 'datam_begin', 'datam_end'].includes(n)) return
|
|
sql = sql.replace(new RegExp('@' + n + '@', 'ig'), `'@${n}@'`)
|
})
|
if (/@db@/ig.test(sql)) {
|
reps.push('db')
|
}
|
|
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 getInvoicePreSql = (btn, logLabel) => {
|
let reps = []
|
let sysVars = ['loginuid', 'sessionuid', 'userid', 'appkey', 'lang', 'username', 'fullname', 'menuname']
|
let _script = ''
|
btn.scripts.forEach(item => {
|
if (item.status === 'false') return
|
_script += `
|
${item.sql}
|
`
|
})
|
|
_script = _script.replace(/@typename@/ig, `'admin'`)
|
|
let regs = ['ID', 'BID', 'time_id', 'datam', ...sysVars]
|
|
regs.forEach(s => {
|
if (new RegExp('@' + s + '@', 'ig').test(_script)) {
|
reps.push(s)
|
}
|
})
|
|
if (/\$@/ig.test(_script)) {
|
_script = _script.replace(/\$@/ig, ' @datam_begin@ ').replace(/@\$/ig, ' @datam_end@ ')
|
reps.push('datam_begin', 'datam_end')
|
}
|
reps.forEach(n => {
|
if (['datam_begin', 'datam_end'].includes(n)) return
|
|
_script = _script.replace(new RegExp('@' + n + '@', 'ig'), `'@${n}@'`)
|
})
|
if (/@db@/ig.test(_script)) {
|
reps.push('db')
|
}
|
|
let syses = ['UserName', 'FullName', 'RoleID', 'mk_departmentcode', 'mk_organization', 'mk_user_type', 'mk_nation', 'mk_province', 'mk_city', 'mk_district', 'mk_address', 'bid']
|
let decSql = []
|
let secSql = []
|
|
syses.forEach(s => {
|
if (new RegExp('@' + s + '[^0-9a-z_]', 'ig').test(_script)) {
|
if (['RoleID', 'mk_departmentcode', 'mk_organization'].includes(s)) {
|
decSql.push(`@${s} nvarchar(512)`)
|
} else if (['mk_address'].includes(s)) {
|
decSql.push(`@mk_address nvarchar(100)`)
|
} else {
|
decSql.push(`@${s} nvarchar(50)`)
|
}
|
secSql.push(`@${s}='@${s}@'`)
|
reps.push(s)
|
}
|
})
|
decSql = decSql.join(',')
|
secSql = secSql.join(',')
|
|
let sql = `/* ${logLabel} */
|
BEGIN TRY
|
begin TRAN
|
|
Declare @ErrorCode nvarchar(50), @retmsg nvarchar(4000), @account_id nvarchar(50), @account_year_id nvarchar(50), @account_code nvarchar(50), @account_year_code nvarchar(50), @tbid nvarchar(50)${decSql ? ',' + decSql : ''}
|
|
Select @ErrorCode='S', @retmsg='', @account_id='@account_id@', @account_year_id='@account_year_id@', @account_code='@account_code@', @account_year_code='@account_year_code@'${secSql ? ',' + secSql : ''}
|
|
/* 发票主表字段 */
|
Declare @invoice_type Nvarchar(50), @from_to_name Nvarchar(50), @from_to_tax_no Nvarchar(50), @from_to_addr Nvarchar(100), @from_to_tel Nvarchar(50), @from_to_bank_name Nvarchar(50), @from_to_account_no Nvarchar(50), @from_to_mob Nvarchar(50), @from_to_email Nvarchar(50), @from_to_code Nvarchar(50), @orgname Nvarchar(50), @tax_no Nvarchar(50), @addr Nvarchar(100), @tel Nvarchar(50), @bank_name Nvarchar(50), @account_no Nvarchar(50), @remark Nvarchar(512), @payee Nvarchar(50), @reviewer Nvarchar(50), @drawer Nvarchar(50), @io Nvarchar(50), @orgcode Nvarchar(50), @total_net_amount Decimal(18,2), @total_tax Decimal(18,2), @total_amount Decimal(18,2), @business_type Nvarchar(20)
|
|
Select @invoice_type='@invoice_type@', @from_to_name='@from_to_name@', @from_to_tax_no='@from_to_tax_no@', @from_to_addr='@from_to_addr@', @from_to_tel='@from_to_tel@', @from_to_bank_name='@from_to_bank_name@', @from_to_account_no='@from_to_account_no@', @from_to_mob='@from_to_mob@', @from_to_email='@from_to_email@', @from_to_code='@from_to_code@', @orgname='@orgname@', @tax_no='@tax_no@', @addr='@addr@', @tel='@tel@', @bank_name='@bank_name@', @account_no='@account_no@', @remark='@remark@', @payee='@payee@', @reviewer='@reviewer@', @drawer='@drawer@', @io='@io@', @orgcode='@orgcode@', @total_net_amount=@total_net_amount@, @total_tax=@total_tax@, @total_amount=@total_amount@, @business_type='@business_type@'
|
|
/* 发票明细临时表 */
|
|
Declare @details_list table (productcode Nvarchar(50), productname Nvarchar(50), spec Nvarchar(50), unit Nvarchar(50), bill_count Decimal(18,10), unitprice Decimal(18,10), amount_line Decimal(18,2), tax_classify_code Nvarchar(50), tax_classify_name Nvarchar(50), tax_rate Decimal(18,2), tax_amount Decimal(18,2), free_tax_mark Nvarchar(50), vat_special_management Nvarchar(50), invoice_lp Nvarchar(50), tax_item Nvarchar(50), tax_method Nvarchar(50), jskey Nvarchar(50), data_type Nvarchar(50))
|
|
Insert into @details_list (productcode, productname, spec, unit, bill_count, unitprice, amount_line, tax_classify_code, tax_classify_name, tax_rate, tax_amount, free_tax_mark, vat_special_management, invoice_lp, tax_item, tax_method, jskey, data_type)
|
|
@mk_excel_data@
|
|
/* 自定义脚本 */
|
${_script}
|
`
|
|
if (btn.type === 'billout') {
|
sql += callback
|
} else {
|
sql += `
|
select @ErrorCode as ErrorCode,@retmsg as retmsg
|
${callback}
|
`
|
}
|
|
reps = reps.filter(n => {
|
if (sysVars.includes(n.toLowerCase())) {
|
return false
|
}
|
|
return true
|
})
|
|
sql = sql.replace(/\n\x20{6,8}/g, '\n').replace(/\n{3,}/g, '\n\n').replace(/^\s+|\s+$/g, '').replace(/\t+|\v+/g, ' ')
|
|
return {LText: sql, md5: md5(sql), reps}
|
}
|
|
let getInvoiceSysBackSql = (btn, logLabel) => {
|
let _prev = ''
|
let _back = ''
|
let tables = []
|
let reps = []
|
|
btn.cbScripts.forEach(script => {
|
if (script.status === 'false') return
|
|
if (/\s#[a-z0-9_]+(\s|\()/ig.test(script.sql)) {
|
tables.push(...script.sql.match(/\s#[a-z0-9_]+(\s|\()/ig))
|
}
|
|
if (script.position === 'front') {
|
_prev += `
|
/* 自定义脚本 */
|
${script.sql}
|
`
|
} else {
|
_back += `
|
/* 自定义脚本 */
|
${script.sql}
|
`
|
}
|
})
|
|
tables = tables.map(tb => tb.replace(/\s|\(/g, ''))
|
|
let syses = ['UserName', 'FullName', 'RoleID', 'mk_departmentcode', 'mk_organization', 'mk_user_type', 'mk_nation', 'mk_province', 'mk_city', 'mk_district', 'mk_address', 'bid']
|
let decSql = []
|
let secSql = []
|
let testSql = _prev + _back
|
|
_prev = _prev.replace(/@typename@/ig, `'admin'`)
|
_back = _back.replace(/@typename@/ig, `'admin'`)
|
|
let regs = ['ID', 'BID', 'time_id', 'datam', ...sysVars]
|
|
regs.forEach(s => {
|
if (new RegExp('@' + s + '@', 'ig').test(testSql)) {
|
reps.push(s)
|
}
|
})
|
|
if (/\$@/ig.test(testSql)) {
|
_prev = _prev.replace(/\$@/ig, ' @datam_begin@ ').replace(/@\$/ig, ' @datam_end@ ')
|
_back = _back.replace(/\$@/ig, ' @datam_begin@ ').replace(/@\$/ig, ' @datam_end@ ')
|
reps.push('datam_begin', 'datam_end')
|
}
|
reps.forEach(n => {
|
if (['datam_begin', 'datam_end'].includes(n)) return
|
|
_prev = _prev.replace(new RegExp('@' + n + '@', 'ig'), `'@${n}@'`)
|
_back = _back.replace(new RegExp('@' + n + '@', 'ig'), `'@${n}@'`)
|
})
|
if (/@db@/ig.test(testSql)) {
|
reps.push('db')
|
}
|
|
syses.forEach(s => {
|
if (new RegExp('@' + s + '[^0-9a-z_]', 'ig').test(testSql)) {
|
if (['RoleID', 'mk_departmentcode', 'mk_organization'].includes(s)) {
|
decSql.push(`@${s} nvarchar(512)`)
|
} else if (['mk_address'].includes(s)) {
|
decSql.push(`@mk_address nvarchar(100)`)
|
} else {
|
decSql.push(`@${s} nvarchar(50)`)
|
}
|
secSql.push(`@${s}='@${s}@'`)
|
reps.push(s)
|
}
|
})
|
decSql = decSql.join(',')
|
secSql = secSql.join(',')
|
|
// 需要声明的变量集
|
|
let _sql = `/* ${logLabel} */
|
BEGIN TRY
|
begin TRAN
|
|
Declare @ErrorCode nvarchar(50), @retmsg nvarchar(4000), @account_id nvarchar(50), @account_year_id nvarchar(50), @account_code nvarchar(50), @account_year_code nvarchar(50), @tbid nvarchar(50)${decSql ? ',' + decSql : ''}
|
|
Select @ErrorCode='S', @retmsg='', @account_id='@account_id@', @account_year_id='@account_year_id@', @account_code='@account_code@', @account_year_code='@account_year_code@'${secSql ? ',' + secSql : ''}
|
|
${_prev}
|
/* 外部接口入参 */
|
@mk_outer_params@
|
${_back}
|
select @ErrorCode as ErrorCode,@retmsg as retmsg
|
${callback}
|
`
|
|
_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, tbs: tables }
|
}
|
|
let _mainSearch = []
|
|
if (appType === 'mob') {
|
let search = []
|
let ms = null
|
config.components.forEach(item => {
|
if (item.type === 'topbar' && item.wrap.type !== 'navbar' && item.search) {
|
ms = item.search
|
} else if (item.type === 'search' && item.wrap.field) {
|
search.push({
|
type: 'text',
|
field: item.wrap.field,
|
})
|
}
|
})
|
|
if (ms) {
|
if (ms.setting.type === 'search') {
|
search.push({
|
type: 'text',
|
field: ms.setting.field,
|
})
|
}
|
search.push(...ms.fields)
|
|
ms.groups.forEach(group => {
|
if (group.setting.type === 'search') {
|
search.push({
|
type: 'text',
|
field: group.setting.field,
|
})
|
}
|
search.push(...group.fields)
|
})
|
|
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, '搜索')
|
|
sqls.push({uuid: cell.uuid, type: 'sForm', ...msg})
|
}
|
})
|
}
|
}
|
|
if (search.length > 0) {
|
_mainSearch = search
|
}
|
} else {
|
config.components.forEach(component => {
|
if (component.type !== 'search') return
|
|
_mainSearch = component.search || []
|
})
|
}
|
|
if (config.interfaces && config.interfaces.length > 0) {
|
config.interfaces.forEach(m => {
|
if (m.status !== 'true' || m.setting.interType !== 'system') return false
|
|
m.setting.laypage = 'false'
|
m.setting.$top = true
|
m.setting.$name = (config.MenuName || '') + '-' + (m.name || '')
|
|
let msg = getDataSource(m, _mainSearch)
|
|
sqls.push({uuid: m.uuid, type: 'interface', ...msg})
|
})
|
}
|
|
filterComponent(config.components, _mainSearch)
|
|
let keys = sqls.map(item => item.uuid)
|
if (keys.length > Array.from(new Set(keys)).length) {
|
if (window.backend) {
|
let m = new Map()
|
let n = new Map()
|
sqls.forEach(item => {
|
if (m.has(item.uuid)) {
|
if (!n.has(item.uuid)) {
|
window.mkInfo(m.get(item.uuid))
|
n.set(item.uuid, true)
|
}
|
window.mkInfo(item)
|
} else {
|
m.set(item.uuid, item)
|
}
|
})
|
|
notification.warning({
|
top: 92,
|
message: '存在重复的后端脚本ID！',
|
duration: 5
|
})
|
}
|
|
return []
|
}
|
|
return sqls
|
}
|
