el-table结算单合计逻辑小记

getSummaries(param) {
const { columns, data } = param
const sums = []
columns.forEach((column, columnIndex) => {
if (columnIndex === 0) {
sums.push(‘合计’)
return
}
if (
(columnIndex >= 8 && columnIndex <= 9) ||
(columnIndex >= 16 && columnIndex <= 30) ||
columnIndex === 39 ||
columnIndex === 40 ||
(columnIndex >= 42 && columnIndex <= 44) ||
(columnIndex >= 46 && columnIndex <= 47) ||
(columnIndex >= 49 && columnIndex <= 53)
) {
const values = data?.map(item => parseFloat(item[column.property]))
const filteredValues = values.filter(value => !isNaN(value))
if (filteredValues.length > 0) {
let sum = filteredValues.reduce((acc, cur) => acc + cur, 0)
if ([9,16,17,18,19,20,21,22,23,24,25,26,27,29,30,38,39,40,42,43,44,46,47,49,50,51,52,53].includes(columnIndex)) {
sum = sum?.toFixed(4)
} else {
sum = sum
}
sums.push(sum)
} else {
sums.push(‘’)
}
} else {
sums.push(‘’)//不在计算范围内的列，直接填充空字符串
}
})
return sums
},