From 6afdec0062dacbded57e166230eb22cc55ced0c1 Mon Sep 17 00:00:00 2001
From: king <18310653075@163.com>
Date: 星期六, 08 五月 2021 14:30:21 +0800
Subject: [PATCH] 2021-05-08
---
src/tabviews/zshare/actionList/exceloutbutton/index.jsx | 145 ++++++++++++++++++++++++++++++++++++------------
1 files changed, 108 insertions(+), 37 deletions(-)
diff --git a/src/tabviews/zshare/actionList/exceloutbutton/index.jsx b/src/tabviews/zshare/actionList/exceloutbutton/index.jsx
index 030e799..ea6c15d 100644
--- a/src/tabviews/zshare/actionList/exceloutbutton/index.jsx
+++ b/src/tabviews/zshare/actionList/exceloutbutton/index.jsx
@@ -17,13 +17,12 @@
class ExcelOutButton extends Component {
static propTpyes = {
BID: PropTypes.string, // 涓昏〃ID
+ position: PropTypes.any, // 鎸夐挳浣嶇疆锛屽伐鍏锋爮涓簍oolbar
show: PropTypes.any, // 鏄剧ず鏍峰紡
- MenuName: PropTypes.any, // 鑿滃崟鍚嶇О
Tab: PropTypes.any, // 濡傛灉褰撳墠鍏冪礌涓烘爣绛炬椂锛宼ab涓烘爣绛句俊鎭�
btn: PropTypes.object, // 鎸夐挳
setting: PropTypes.any, // 椤甸潰閫氱敤璁剧疆
updateStatus: PropTypes.func, // 鎸夐挳鐘舵�佹洿鏂�
- getexceloutparam: PropTypes.func, // 鑾峰彇琛ㄦ牸涓弬鏁�
}
state = {
@@ -38,11 +37,12 @@
}
componentDidMount () {
- const { show } = this.props
+ const { position } = this.props
- if (show === 'actionList') {
+ if (position === 'toolbar') {
MKEmitter.addListener('triggerBtnId', this.actionTrigger)
}
+ MKEmitter.addListener('execExcelout', this.triggerExcelout)
}
componentWillUnmount () {
@@ -50,6 +50,7 @@
return
}
MKEmitter.removeListener('triggerBtnId', this.actionTrigger)
+ MKEmitter.removeListener('execExcelout', this.triggerExcelout)
}
/**
@@ -109,15 +110,20 @@
return
}
- this.triggerExcelout()
+ MKEmitter.emit('getexceloutparam', btn.$menuId, btn.uuid)
+ if (window.GLOB.systemType === 'production') {
+ MKEmitter.emit('queryTrigger', {menuId: btn.uuid, name: '瀵煎嚭Excel'})
+ }
}
/**
* @description Excel 瀵煎嚭
*/
- triggerExcelout = () => {
+ triggerExcelout = (menuId, btnId, viewParam) => {
const { btn } = this.props
- let viewParam = this.props.getexceloutparam()
+
+ if (btn.$menuId !== menuId || btn.uuid !== btnId || !viewParam) return
+
let name = `${viewParam.menuName}${moment().format('YYYYMMDDHHmmss')}.xlsx`
let pageSize = 1000
@@ -187,13 +193,21 @@
if (btn.sysInterface === 'true' && options.cloudServiceApi) {
param.rduri = options.cloudServiceApi
} else if (btn.sysInterface !== 'true') {
- param.rduri = btn.interface
+ if (window.GLOB.systemType === 'production' && btn.proInterface) {
+ param.rduri = btn.proInterface
+ } else {
+ param.rduri = btn.interface
+ }
}
} else {
if (btn.sysInterface === 'true' && window.GLOB.mainSystemApi) {
param.rduri = window.GLOB.mainSystemApi
} else if (btn.sysInterface !== 'true') {
- param.rduri = btn.interface
+ if (window.GLOB.systemType === 'production' && btn.proInterface) {
+ param.rduri = btn.proInterface
+ } else {
+ param.rduri = btn.interface
+ }
}
}
@@ -225,13 +239,21 @@
if (btn.sysInterface === 'true' && options.cloudServiceApi) {
res.rduri = options.cloudServiceApi
} else if (btn.sysInterface !== 'true') {
- res.rduri = btn.interface
+ if (window.GLOB.systemType === 'production' && btn.proInterface) {
+ res.rduri = btn.proInterface
+ } else {
+ res.rduri = btn.interface
+ }
}
} else {
if (btn.sysInterface === 'true' && window.GLOB.mainSystemApi) {
res.rduri = window.GLOB.mainSystemApi
} else if (btn.sysInterface !== 'true') {
- res.rduri = btn.interface
+ if (window.GLOB.systemType === 'production' && btn.proInterface) {
+ res.rduri = btn.proInterface
+ } else {
+ res.rduri = btn.interface
+ }
}
}
@@ -286,13 +308,21 @@
if (btn.sysInterface === 'true' && options.cloudServiceApi) {
res.rduri = options.cloudServiceApi
} else if (btn.sysInterface !== 'true') {
- res.rduri = btn.interface
+ if (window.GLOB.systemType === 'production' && btn.proInterface) {
+ res.rduri = btn.proInterface
+ } else {
+ res.rduri = btn.interface
+ }
}
} else {
if (btn.sysInterface === 'true' && window.GLOB.mainSystemApi) {
res.rduri = window.GLOB.mainSystemApi
} else if (btn.sysInterface !== 'true') {
- res.rduri = btn.interface
+ if (window.GLOB.systemType === 'production' && btn.proInterface) {
+ res.rduri = btn.proInterface
+ } else {
+ res.rduri = btn.interface
+ }
}
}
@@ -350,13 +380,21 @@
if (btn.sysInterface === 'true' && options.cloudServiceApi) {
param.rduri = options.cloudServiceApi
} else if (btn.sysInterface !== 'true') {
- param.rduri = btn.interface
+ if (window.GLOB.systemType === 'production' && btn.proInterface) {
+ param.rduri = btn.proInterface
+ } else {
+ param.rduri = btn.interface
+ }
}
} else {
if (btn.sysInterface === 'true' && window.GLOB.mainSystemApi) {
param.rduri = window.GLOB.mainSystemApi
} else if (btn.sysInterface !== 'true') {
- param.rduri = btn.interface
+ if (window.GLOB.systemType === 'production' && btn.proInterface) {
+ param.rduri = btn.proInterface
+ } else {
+ param.rduri = btn.interface
+ }
}
}
@@ -395,12 +433,17 @@
let _header = []
let _topRow = {}
let colwidth = []
+ let abses = []
btn.verify.columns.forEach(col => {
if (_topRow[col.Column]) return
_header.push(col.Column)
_topRow[col.Column] = col.Text
+
+ if (col.abs === 'true') {
+ abses.push(col.Column)
+ }
colwidth.push({width: col.Width || 20})
})
@@ -409,10 +452,17 @@
table.push(_topRow)
- data && data.forEach(item => {
+ data && data.forEach((item, index) => {
let _row = {}
+
+ item.$Index = index + 1
+
_header.forEach(field => {
- _row[field] = item[field]
+ if (item[field] && abses.includes(field)) {
+ _row[field] = Math.abs(item[field])
+ } else {
+ _row[field] = item[field]
+ }
})
table.push(_row)
@@ -441,11 +491,11 @@
* @description 鎵ц鑷畾涔夎剼鏈�
*/
execCustomScript = () => {
- const { btn, MenuName } = this.props
+ const { btn } = this.props
const { search } = this.state
let script = btn.verify.script
- if (this.props.dataManager) { // 鏁版嵁鏉冮檺
+ if (sessionStorage.getItem('dataM') === 'true') { // 鏁版嵁鏉冮檺
script = script.replace(/\$@/ig, '/*')
script = script.replace(/@\$/ig, '*/')
} else {
@@ -466,21 +516,17 @@
let param = {
func: 'sPC_TableData_InUpDe',
- menuname: `${MenuName ? MenuName + '-' : ''}${btn.label}`
+ menuname: btn.logLabel
}
if (this.props.BID) {
param.BID = this.props.BID
}
- let { LText, LText1, LText2 } = Utils.sPCInUpDeFormatOptions(script)
-
- param.LText2 = LText2
- param.LText1 = LText1
- param.LText = LText
-
+ param.exec_type = 'y' // 鍚庡彴瑙ｇ爜
param.timestamp = moment().format('YYYY-MM-DD HH:mm:ss')
- param.secretkey = Utils.encrypt(param.LText, param.timestamp)
+ param.secretkey = Utils.encrypt('', param.timestamp)
+ param.LText = Utils.formatOptions(param.LText)
if (this.props.menuType === 'HS') { // 鍑芥暟 sPC_TableData_InUpDe 浜戠楠岃瘉
param.open_key = Utils.encryptOpenKey(param.secretkey, param.timestamp)
@@ -509,7 +555,7 @@
}
// 鏁版嵁绠＄悊鏉冮檺
- if (this.props.dataManager) {
+ if (sessionStorage.getItem('dataM') === 'true') {
param.dataM = 'Y'
}
@@ -529,7 +575,7 @@
* @description 鑾峰彇榛樿瀛樺偍杩囩▼璇锋眰鍙傛暟
*/
getExcelDefaultParam = (arr_field, orderBy, search, pagination = false, pageIndex = 1, pageSize = 100) => {
- const { setting, MenuName, btn } = this.props
+ const { setting, btn } = this.props
let _search = Utils.joinMainSearchkey(search)
@@ -541,11 +587,11 @@
arr_field: arr_field,
custom_script: setting.customScript,
default_sql: setting.default || 'true',
- menuname: `${MenuName ? MenuName + '-' : ''}${btn.label}`
+ menuname: btn.logLabel
}
// 鏁版嵁绠＄悊鏉冮檺
- if (this.props.dataManager) {
+ if (sessionStorage.getItem('dataM') === 'true') {
param.dataM = 'Y'
}
@@ -558,6 +604,14 @@
let regoptions = null
if (setting.queryType === 'statistics' || param.custom_script) {
let allSearch = Utils.getAllSearchOptions(search)
+ let userName = sessionStorage.getItem('User_Name') || ''
+ let fullName = sessionStorage.getItem('Full_Name') || ''
+ let city = sessionStorage.getItem('city') || ''
+
+ if (sessionStorage.getItem('isEditState') === 'true') {
+ userName = sessionStorage.getItem('CloudUserName') || ''
+ fullName = sessionStorage.getItem('CloudFullName') || ''
+ }
regoptions = allSearch.map(item => {
return {
@@ -567,6 +621,15 @@
})
regoptions.push({
+ reg: new RegExp('@login_city@', 'ig'),
+ value: city
+ }, {
+ reg: new RegExp('@userName@', 'ig'),
+ value: userName
+ }, {
+ reg: new RegExp('@fullName@', 'ig'),
+ value: fullName
+ }, {
reg: new RegExp('@orderBy@', 'ig'),
value: orderBy
}, {
@@ -594,6 +657,9 @@
}
if (param.custom_script) {
+ param.custom_script = `declare @ErrorCode nvarchar(50),@retmsg nvarchar(4000) select @ErrorCode='',@retmsg =''
+ ${param.custom_script}
+ `
regoptions.forEach(item => {
param.custom_script = param.custom_script.replace(item.reg, item.value)
})
@@ -615,8 +681,8 @@
// 娴嬭瘯绯荤粺鎵撳嵃鏌ヨ璇彞
if ((options.sysType === 'local' && !window.GLOB.systemType) || window.debugger === true) {
- param.custom_script && console.log(`${LText ? '' : '/*涓嶆墽琛岄粯璁ql*/\n'}${param.custom_script}`)
- LText && console.log(LText)
+ param.custom_script && console.info(`${LText ? '' : '/*涓嶆墽琛岄粯璁ql*/\n'}${param.custom_script}`)
+ LText && console.info(LText)
}
param.custom_script = Utils.formatOptions(param.custom_script)
@@ -661,7 +727,9 @@
loading: false
})
- this.props.updateStatus('refresh', btn.execSuccess, btn)
+ if (btn.execSuccess !== 'never') {
+ MKEmitter.emit('refreshByButtonResult', btn.$menuId, btn.execSuccess, btn)
+ }
}
/**
@@ -698,7 +766,9 @@
loading: false
})
- this.props.updateStatus('refresh', btn.execError, btn)
+ if (btn.execError !== 'never') {
+ MKEmitter.emit('refreshByButtonResult', btn.$menuId, btn.execError, btn)
+ }
}
render() {
@@ -718,7 +788,9 @@
return (
<Button
type="link"
+ title={show === 'icon' ? btn.label : ''}
loading={loading}
+ style={btn.style}
icon={show === 'text' ? '' : (show === 'icon' ? (btn.icon || 'download') : (btn.icon || ''))}
onClick={(e) => {e.stopPropagation(); this.actionTrigger()}}
>{show === 'icon' ? '' : btn.label}</Button>
@@ -729,8 +801,7 @@
const mapStateToProps = (state) => {
return {
- menuType: state.editLevel,
- dataManager: state.dataManager
+ menuType: state.editLevel
}
}
--
Gitblit v1.8.0