//这是在vue上面引用vxe-table插件实现的，主要方法都设置在table中，mergeCells，tableData都是在vue页面的data初使化数据， :footer-method=“footerMethod”：尾部数据，:merge-footer-items=“mergeCells”：尾部合并单元格。vxe-table网址：https://vxetable.cn/#/table/advanced/footerSpan

mergeCells: [
{ row: 1, col: 1, rowspan: 0, colspan: 3 },
{ row: 1, col: 4, rowspan: 0, colspan: 3 },
{ row: 1, col: 9, rowspan: 0, colspan: 3 },
{ row: 1, col: 12, rowspan: 0, colspan: 3 },
{ row: 1, col: 17, rowspan: 0, colspan: 3 },
{ row: 1, col: 20, rowspan: 0, colspan: 4 },
{ row: 1, col: 26, rowspan: 0, colspan: 3 },
{ row: 1, col: 29, rowspan: 0, colspan: 3 },
{ row: 1, col: 34, rowspan: 0, colspan: 2 },
{ row: 1, col: 36, rowspan: 0, colspan: 4 },
{ row: 2, col: 0, rowspan: 0, colspan: 6 },
{ row: 2, col: 6, rowspan: 0, colspan: 9 },
{ row: 2, col: 15, rowspan: 0, colspan: 5 },
{ row: 2, col: 20, rowspan: 0, colspan: 9 },
{ row: 2, col: 29, rowspan: 0, colspan: 14 },
],
tableData: [
{
name: ‘张三’,
item1s: 5,
item2s: 2,
item3s: 3,
item4s: 4,
item5: 0,
item6: 0,
item7: 7,
item8: 0,
dmjlNum: 0,
item10: 10,
item11: 11,
item12: 12,
item13: 13,
item14: 14,
item15: 15,
item16: 16,
item17: 17,
item18: 18,
item19: 18,
item20: 20,
item21: 21,
item22: 22,
item23: 23,
item24: 24,
item25: 0,
},
{
name: ‘张四’,
item1s: 1,
item2s: 2,
item3s: -3,
item4s: 4,
item5: 0,
item6: 0,
item7: 7,
item8: 0,
dmjlNum: 0,
item10: 10,
item11: 11,
item12: 12,
item13: 13,
item14: 14,
item15: -5,
item16: 16,
item17: 17,
item18: 18,
item19: 18,
item20: 20,
item21: 21,
item22: 22,
item23: 23,
item24: 24,
item25: 0,
},
{
name: ‘张四’,
item1s: 1,
item2s: 2,
item3s: -3,
item4s: 4,
item5: 0,
item6: 0,
item7: 7,
item8: 0,
dmjlNum: 0,
item10: 10,
item11: 11,
item12: 12,
item13: 13,
item14: 14,
item15: -5,
item16: 16,
item17: 17,
item18: 18,
item19: 18,
item20: 20,
item21: 21,
item22: 22,
item23: 23,
item24: 24,
item25: 0,
},
{
name: ‘张四’,
item1s: 1,
item2s: 2,
item3s: -3,
item4s: 4,
item5: 0,
item6: 0,
item7: 7,
item8: 0,
dmjlNum: 0,
item10: 10,
item11: 11,
item12: 12,
item13: 13,
item14: 14,
item15: -5,
item16: 16,
item17: 17,
item18: 18,
item19: 18,
item20: 20,
item21: 21,
item22: 22,
item23: 23,
item24: 24,
item25: 0,
},
{
name: ‘张四’,
item1s: 1,
item2s: 2,
item3s: -3,
item4s: 4,
item5: 0,
item6: 0,
item7: 7,
item8: 0,
dmjlNum: 0,
item10: 10,
item11: 11,
item12: 12,
item13: 13,
item14: 14,
item15: -5,
item16: 16,
item17: 17,
item18: 18,
item19: 18,
item20: 20,
item21: 21,
item22: 22,
item23: 23,
item24: 24,
item25: 0,
},
],

//表尾方法
footerMethod({ columns, data }) {
console.log(data + ‘------’)

  return [columns.map((column, columnIndex) => {if (columnIndex === 0) {return '小计'}if (['item1s','item2s','item3s','item4s','item5','item6','item7','item8','item9','item10','item11','item12','item13','item14','item15','item16','item17','item18','item19','item20',].includes(column.property)) {return XEUtils.sum(data, column.property)}return null}),columns.map((column, columnIndex) => {if (columnIndex === 0) {return '合计'}if (columnIndex === 1) {return '店员奖金'}if (columnIndex === 7) {return '元'}if (columnIndex === 8) {return ''}if (columnIndex === 9) {return '绩效奖金'}if (columnIndex === 15) {return '元'}if (columnIndex === 16) {return ''}if (columnIndex === 17) {return '线上奖金'}if (columnIndex === 24) {return '元'}if (columnIndex === 26) {return '线上罚款'}if (columnIndex === 32) {return '元'}if (columnIndex === 34) {return '总金额'}if (columnIndex === 40) {return '元'}if (['item4s'].includes(column.property)) {return XEUtils.sum(data, column.property)}return null}),columns.map((column, columnIndex) => {if (columnIndex === 0) {return '填表人（收银员/店助)'}if (columnIndex === 15) {return '审核人(店长)：'}if (['age', 'rate'].includes(column.property)) {return XEUtils.mean(data, column.property)}return null}),]
},