From f0bf8c399c354c22227f8f1a76ed806098db59c0 Mon Sep 17 00:00:00 2001
From: king <18310653075@163.com>
Date: 星期二, 21 五月 2024 16:51:02 +0800
Subject: [PATCH] 2024-05-21
---
src/tabviews/zshare/actionList/exceloutbutton/index.jsx | 279 +++++++++++++++++++++++++++++++++++--------------------
1 files changed, 176 insertions(+), 103 deletions(-)
diff --git a/src/tabviews/zshare/actionList/exceloutbutton/index.jsx b/src/tabviews/zshare/actionList/exceloutbutton/index.jsx
index 5db6635..0317ad6 100644
--- a/src/tabviews/zshare/actionList/exceloutbutton/index.jsx
+++ b/src/tabviews/zshare/actionList/exceloutbutton/index.jsx
@@ -90,12 +90,13 @@
/**
* @description 瑙﹀彂鎸夐挳鎿嶄綔
*/
- actionTrigger = (triggerId, record, type) => {
- const { setting, BID, btn } = this.props
+ actionTrigger = (triggerId, _, type, lid) => {
+ const { setting, BID, btn, LID } = this.props
const { loading, disabled } = this.state
if (loading || disabled) return
if (triggerId && btn.uuid !== triggerId) return
+ if (type === 'linkbtn' && !btn.$toolbtn && LID !== lid) return
if (setting.supModule && !BID) {
notification.warning({
@@ -103,30 +104,23 @@
message: '闇�瑕佷笂绾т富閿�硷紒',
duration: 5
})
- return
- } else if (type === 'linkbtn' && !btn.$toolbtn && !is(fromJS(this.props.selectedData || []), fromJS(record))) {
- return
- }
-
- if (btn.errorType === 'error1') {
+ } else if (btn.errorType === 'error1') {
notification.warning({
top: 92,
message: '璇疯缃鍑哄垪锛�',
duration: 5
})
- return
} else if (btn.errorType === 'error2') {
notification.warning({
top: 92,
message: '鎸夐挳闇�鑷畾涔夊鍑烘暟鎹簮锛�',
duration: 5
})
- return
- }
-
- MKEmitter.emit('queryModuleParam', btn.$menuId, this.triggerExcelout)
- if (window.GLOB.systemType === 'production') {
- MKEmitter.emit('queryTrigger', {menuId: btn.uuid, name: '瀵煎嚭Excel'})
+ } else {
+ MKEmitter.emit('queryModuleParam', btn.$menuId, this.triggerExcelout)
+ if (window.GLOB.systemType === 'production') {
+ MKEmitter.emit('queryTrigger', {menuId: btn.uuid, name: '瀵煎嚭Excel'})
+ }
}
}
@@ -183,6 +177,9 @@
if (btn.recordUser === 'true') {
param.username = sessionStorage.getItem('User_Name') || ''
param.fullname = sessionStorage.getItem('Full_Name') || ''
+ }
+ if (btn.dataM === 'true') {
+ param.dataM = sessionStorage.getItem('dataM') === 'true' ? 'Y' : ''
}
Api.genericInterface(param).then(result => {
@@ -387,6 +384,9 @@
param.username = sessionStorage.getItem('User_Name') || ''
param.fullname = sessionStorage.getItem('Full_Name') || ''
}
+ if (btn.dataM === 'true') {
+ param.dataM = sessionStorage.getItem('dataM') === 'true' ? 'Y' : ''
+ }
} else if (btn.intertype === 'outer' && !btn.innerFunc) { // 浣跨敤澶栭儴鍑芥暟
param = this.getExcelCustomParam(viewParam.orderBy, viewParam.search, true, pageIndex, pageSize)
@@ -443,23 +443,70 @@
/**
* @description Excel 鐢熸垚
*/
- exportExcel = (data, ErrCode, msg, search) => {
+ exportExcel = (data = [], ErrCode, msg, search) => {
const { btn } = this.props
let imgCol = false
- let columns = btn.verify.columns.map(col => {
+ let merge = false
+ let styles = []
+ let letters = 'ABCDEFGHIJKLMNOPQRSTUVWXYZ'
+
+ let columns = btn.verify.columns.map((col, index) => {
if (col.type === 'image') {
imgCol = true
}
+ if (btn.verify.merge === 'true' && /.+-.+/.test(col.Text)) {
+ merge = true
+ }
- if (col.type === 'number' && (col.decimal || col.decimal === 0) ) {
- col.round = Math.pow(10, col.decimal)
+ let i = Math.floor(index / 26)
+ let s = letters[i - 1] || ''
+ col.name = s + letters[index % 26]
+
+ if (col.type === 'number') {
+ if (col.decimal || col.decimal === 0) {
+ col.round = Math.pow(10, col.decimal)
+
+ if (col.format) {
+ let dec = Array(col.decimal).fill(0).join('')
+ dec = dec ? '.' + dec : ''
+ if (col.format === 'thdSeparator') {
+ col.z = '#,##0' + dec
+ } else if (col.format === 'thdSepPm') {
+ col.z = '#,##0' + dec + ';'
+ col.z = col.z + '[Red]-' + col.z
+ } else if (col.format === 'percent') {
+ let _dec = ''
+ if (col.decimal > 2) {
+ Array(col.decimal - 2).fill(0).join('')
+ _dec = _dec ? '.' + _dec : ''
+ }
+
+ col.z = '0' + _dec + '%'
+ }
+ }
+ }
+ } else if (col.type === 'text') {
+ if (col.wrapText === 'true') {
+ col.s = {alignment: { wrapText: true }}
+ }
+ if (col.textFormat) {
+ if (col.textFormat === 'YYYY-MM-DD') {
+ col.z = 'yyyy-mm-dd;@'
+ } else if (col.textFormat === 'YYYY-MM-DD HH:mm:ss') {
+ col.z = 'yyyy-mm-dd hh:mm:ss'
+ }
+ }
+ }
+
+ if (col.z || col.s) {
+ styles.push(col)
}
return col
})
- if (data && data[0]) {
+ if (data[0]) {
let errors = []
columns.forEach(col => {
if (col.output === 'false') return
@@ -508,7 +555,7 @@
let table = []
- data && data.forEach((item, index) => {
+ data.forEach((item, index) => {
let _row = {}
item.$Index = index + 1 + ''
@@ -516,21 +563,48 @@
columns.forEach((col, i) => {
let val = item[col.Column]
if (col.output === 'false') {
- if (col.type === 'number') {
+ if (col.type === 'number' && col.noValue !== 'false') {
val = 0
} else {
val = ''
}
- } else if (col.type === 'number' && typeof(val) === 'number') {
- if (col.abs === 'true') {
- val = Math.abs(val)
+ } else if (col.type === 'number') {
+ if (val && typeof(val) === 'string' && !isNaN(val)) {
+ val = +val
}
- if (col.round) {
- val = Math.round(val * col.round) / col.round
- // val = val.toFixed(col.decimal)
+ if (typeof(val) === 'number') {
+ if (col.abs === 'true') {
+ val = Math.abs(val)
+ }
+ if (col.round) {
+ val = Math.round(val * col.round) / col.round
+ }
+ if (col.noValue === 'false' && val === 0) {
+ val = ''
+ }
}
- if (col.noValue === 'false' && val === 0) {
+ } else if (col.type === 'text') {
+ val = val + ''
+
+ if (col.textFormat) {
+ if (col.textFormat === 'YYYY-MM-DD' && /^[1-9]\d{3}(-|\/)(0[1-9]|1[0-2])(-|\/)(0[1-9]|[1-2][0-9]|3[0-1])/.test(val)) {
+ val = `${val.substr(0, 4)}-${val.substr(5, 2)}-${val.substr(8, 2)}`
+ } else if (col.textFormat === 'YYYY-MM-DD HH:mm:ss' && /^[1-9]\d{3}(-|\/)(0[1-9]|1[0-2])(-|\/)(0[1-9]|[1-2][0-9]|3[0-1]).([0-1][0-9]|2[0-3]):[0-5][0-9]:[0-5][0-9]/.test(val)) {
+ val = `${val.substr(0, 4)}-${val.substr(5, 2)}-${val.substr(8, 2)} ${val.substr(11, 2)}:${val.substr(14, 2)}:${val.substr(17, 2)}`
+ }
+ }
+
+ if (col.noValue === 'false' && val < '1949-10-02') {
val = ''
+ }
+ }
+
+ if (val !== '') {
+ if (col.prefix) {
+ val = col.prefix + val
+ }
+ if (col.postfix) {
+ val = val + col.postfix
}
}
@@ -544,16 +618,6 @@
this.execSuccess({ErrCode: ErrCode || 'S', message: msg || '瀵煎嚭鎴愬姛锛�'})
} else {
- let letters = 'ABCDEFGHIJKLMNOPQRSTUVWXYZ'
- let cols = []
-
- for (let index = 0; index < columns.length; index++) {
- let i = Math.floor(index / 26)
- let s = letters[i - 1] || ''
-
- cols.push(s + letters[index % 26])
- }
-
let table = []
let _header = []
let _topRow = {}
@@ -561,16 +625,16 @@
let requires = []
let merges = []
- columns.forEach((col, i) => {
+ columns.forEach(col => {
_header.push(col.Column)
_topRow[col.Column] = col.Text
colwidth.push({wch: col.Width || 20})
if (col.required === 'true') {
- requires.push(i)
+ requires.push(col.name)
}
})
- if (btn.verify.merge === 'true') {
+ if (merge) {
let fLine = {}
let sLine = {}
let sign = ''
@@ -582,16 +646,16 @@
sLine[col.Column] = _name
if (sign === _sign) {
- merges[merges.length - 1] = merges[merges.length - 1].split(':')[0] + `:${cols[i]}1`
+ merges[merges.length - 1] = merges[merges.length - 1].split(':')[0] + `:${col.name}1`
} else {
- merges.push(`${cols[i]}1:${cols[i]}2`)
+ merges.push(`${col.name}1:${col.name}2`)
sign = _sign
}
} else {
fLine[col.Column] = col.Text
sLine[col.Column] = col.Text
sign = ''
- merges.push(`${cols[i]}1:${cols[i]}2`)
+ merges.push(`${col.name}1:${col.name}2`)
}
})
@@ -601,7 +665,7 @@
table.push(_topRow)
}
- data && data.forEach((item, index) => {
+ data.forEach((item, index) => {
let _row = {}
item.$Index = index + 1 + ''
@@ -610,21 +674,48 @@
let val = item[col.Column]
if (col.output === 'false') {
- if (col.type === 'number') {
+ if (col.type === 'number' && col.noValue !== 'false') {
val = 0
} else {
val = ''
}
- } else if (col.type === 'number' && typeof(val) === 'number') {
- if (col.abs === 'true') {
- val = Math.abs(val)
+ } else if (col.type === 'number') {
+ if (val && typeof(val) === 'string' && !isNaN(val)) {
+ val = +val
}
- if (col.round) {
- val = Math.round(val * col.round) / col.round
- // val = val.toFixed(col.decimal)
+ if (typeof(val) === 'number') {
+ if (col.abs === 'true') {
+ val = Math.abs(val)
+ }
+ if (col.round) {
+ val = Math.round(val * col.round) / col.round
+ }
+ if (col.noValue === 'false' && val === 0) {
+ val = ''
+ }
}
- if (col.noValue === 'false' && val === 0) {
+ } else if (col.type === 'text') {
+ val = val + ''
+
+ if (col.textFormat) {
+ if (col.textFormat === 'YYYY-MM-DD' && /^[1-9]\d{3}(-|\/)(0[1-9]|1[0-2])(-|\/)(0[1-9]|[1-2][0-9]|3[0-1])/.test(val)) {
+ val = `${val.substr(0, 4)}-${val.substr(5, 2)}-${val.substr(8, 2)}`
+ } else if (col.textFormat === 'YYYY-MM-DD HH:mm:ss' && /^[1-9]\d{3}(-|\/)(0[1-9]|1[0-2])(-|\/)(0[1-9]|[1-2][0-9]|3[0-1]).([0-1][0-9]|2[0-3]):[0-5][0-9]:[0-5][0-9]/.test(val)) {
+ val = `${val.substr(0, 4)}-${val.substr(5, 2)}-${val.substr(8, 2)} ${val.substr(11, 2)}:${val.substr(14, 2)}:${val.substr(17, 2)}`
+ }
+ }
+
+ if (col.noValue === 'false' && val < '1949-10-02') {
val = ''
+ }
+ }
+
+ if (val !== '') {
+ if (col.prefix) {
+ val = col.prefix + val
+ }
+ if (col.postfix) {
+ val = val + col.postfix
}
}
@@ -644,49 +735,46 @@
if (requires.length) {
requires.forEach(col => {
- if (cols[col]) {
- ws[cols[col] + '1'].s = {font: { color: { rgb: 'F5222D' } }}
- }
+ ws[col + '1'].s = {font: { color: { rgb: 'F5222D' } }}
})
}
- if (merges.length) {
+ if (merge) {
ws['!merges'] = []
merges.forEach(item => {
ws['!merges'].push(XLSX.utils.decode_range(item))
})
- cols.forEach(col => {
- if (ws[col + '1'].s) {
- ws[col + '1'].s = {font: { color: { rgb: 'F5222D' } }, alignment: { horizontal: 'center', vertical: 'center' }}
- } else {
- ws[col + '1'].s = {alignment: { horizontal: 'center', vertical: 'center' }}
- }
- ws[col + '2'].s = {alignment: { horizontal: 'center', vertical: 'center' }}
+ columns.forEach(col => {
+ ws[col.name + '1'].s = ws[col.name + '1'].s || {}
+ ws[col.name + '1'].s.alignment = { horizontal: 'center', vertical: 'center' }
+
+ ws[col.name + '2'].s = {alignment: { horizontal: 'center', vertical: 'center' }}
})
}
- if (btn.verify.wrapText === 'true' && data) {
- let lines = data.length + 1
- let start = 2
- if (btn.verify.merge === 'true') {
- lines = data.length + 2
- }
- for (let n = 0; n < cols.length; n++) {
- for (let m = start; m <= lines; m++) {
- if (ws[cols[n] + m] && !ws[cols[n] + m].s) {
- ws[cols[n] + m].s = {alignment: { wrapText: true }}
+ // ws['A3'].s = {font: { sz: 10 , bold: true }, alignment: { horizontal: 'center', vertical: 'center' }, border: {top: {style: 'thin', color: '000000'}, left: {style: 'thin', color: '000000'}, bottom: {style: 'thin', color: '000000'}, right: {style: 'thin', color: '000000'}}};
+ // ws['A3'].z = '#,##0.00';
+ // ws['A3'].z = '#,##0.00;[Red]-#,##0.00;';
+ // ws["A1"].s = {fill: { bgColor: { rgb: "FFFFAA" }}, font: { color: { rgb: "1890FF" } }}
+
+ if (data.length && styles.length) {
+ for (let n = table.length - data.length + 1; n <= table.length; n++) {
+ styles.forEach(col => {
+ if (col.z) {
+ ws[col.name + n].z = col.z
}
- }
+ if (col.s) {
+ ws[col.name + n].s = col.s
+ }
+ })
}
}
-
- // ws["A1"].s = {fill: { bgColor: { rgb: "FFFFAA" }}, font: { color: { rgb: "1890FF" } }}
const wb = XLSX.utils.book_new()
XLSX.utils.book_append_sheet(wb, ws, btn.verify.sheet || 'Sheet1')
- XLSX.writeFile(wb, `${btn.$menuName || ''}${moment().format('YYYYMMDDHHmmss')}.xlsx`)
+ XLSX.writeFile(wb, `${btn.verify.excelName || btn.$menuName || ''}${moment().format('YYYYMMDDHHmmss')}.xlsx`)
this.execSuccess({ErrCode: ErrCode || 'S', message: msg || '瀵煎嚭鎴愬姛锛�'})
}
@@ -784,9 +872,9 @@
_setting.arr_field = []
btn.verify.columns.forEach(col => {
- if (col.Column && col.Column !== '$Index') {
- _setting.arr_field.push(col.Column)
- }
+ if (col.output === 'false' || !col.Column || col.Column === '$Index') return
+
+ _setting.arr_field.push(col.Column)
})
_setting.arr_field = _setting.arr_field.join(',')
_setting.execute = btn.verify.defaultSql !== 'false'
@@ -986,39 +1074,24 @@
if (hidden) return null
let label = ''
- let icon = ''
- let type = 'link'
- let className = ''
- if (btn.show === 'button') {
- label = btn.label
- icon = btn.icon || ''
- } else if (btn.show === 'link') {
- label = <span>{btn.label}{btn.icon ? <MkIcon style={{marginLeft: '8px'}} type={btn.icon}/> : ''}</span>
- icon = ''
+ if (btn.show === 'link') {
+ label = <span>{btn.label}{btn.icon ? <MkIcon style={{marginLeft: '8px'}} type={btn.icon} /> : ''}</span>
} else if (btn.show === 'icon') {
- icon = btn.icon || 'download'
- } else if (!btn.$toolbtn) {
- icon = btn.icon || ''
- label = btn.label
- className = 'mk-btn mk-' + btn.class
+ label = !loading ? <MkIcon type={btn.icon} /> : null
} else {
- type = ''
- icon = btn.icon || ''
- label = btn.label
- className = 'mk-btn mk-' + btn.class
+ label = <span>{!loading && btn.icon ? <MkIcon style={{marginRight: '8px'}} type={btn.icon} /> : ''}{btn.label}</span>
}
return (
<Button
- type={type}
+ type="link"
id={'button' + btn.uuid}
title={disabled ? (btn.reason || '') : (btn.show === 'icon' ? btn.label : '')}
loading={loading}
disabled={disabled}
style={btn.style || null}
- icon={icon}
- className={className}
+ className={btn.hover || ''}
onClick={(e) => {e.stopPropagation(); this.actionTrigger()}}
>{label}</Button>
)
--
Gitblit v1.8.0