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 | 125 ++++++++++++++++++++++++++++++----------- 1 files changed, 90 insertions(+), 35 deletions(-) diff --git a/src/tabviews/zshare/actionList/exceloutbutton/index.jsx b/src/tabviews/zshare/actionList/exceloutbutton/index.jsx index 3a85b94..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' // 鍚庡彴瑙g爜 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' } @@ -560,6 +606,7 @@ 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') || '' @@ -574,6 +621,9 @@ }) regoptions.push({ + reg: new RegExp('@login_city@', 'ig'), + value: city + }, { reg: new RegExp('@userName@', 'ig'), value: userName }, { @@ -677,7 +727,9 @@ loading: false }) - this.props.updateStatus('refresh', btn.execSuccess, btn) + if (btn.execSuccess !== 'never') { + MKEmitter.emit('refreshByButtonResult', btn.$menuId, btn.execSuccess, btn) + } } /** @@ -714,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() { @@ -734,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> @@ -745,8 +801,7 @@ const mapStateToProps = (state) => { return { - menuType: state.editLevel, - dataManager: state.dataManager + menuType: state.editLevel } } -- Gitblit v1.8.0