From 17527437977dc2e2c39c739796e8afd881df35a1 Mon Sep 17 00:00:00 2001 From: 马宇豪 <978517621@qq.com> Date: 星期二, 10 十二月 2024 14:59:25 +0800 Subject: [PATCH] 修改 --- src/views/safetyReview/projectManage/index.vue | 14 +++++++------- 1 files changed, 7 insertions(+), 7 deletions(-) diff --git a/src/views/safetyReview/projectManage/index.vue b/src/views/safetyReview/projectManage/index.vue index 987496d..d1624b7 100644 --- a/src/views/safetyReview/projectManage/index.vue +++ b/src/views/safetyReview/projectManage/index.vue @@ -297,21 +297,21 @@ const title = [["自治区应急管理厅外聘专家劳务费发放表"]] // 固定一行:填报处室和单位 const fixedHeader = [ - ["填报处室:" + row.deptName, "", "", "", "", "单位:元", "", "", "", "","","",""] + ["填报处室:" + row.deptName, "", "", "", "", "单位:元", "", "", "", "","",""] ] if(res.data && res.data[0] && Array.isArray(res.data[0].projectExpertExportResps) && res.data[0].projectExpertExportResps.length>0){ let mainData = res.data[0].projectExpertExportResps const data = mainData.map((item,index)=>{ - return [index+1,item.name,item.companyName,item.title,item.idCard,item.freightBasis,item.billingDuration,item.taxExpertFee,item.taxableIncome,item.incomeTaxPayable,item.afterTaxAmount,item.openBank,item.bankCard] + return [index+1,item.name,item.companyName,item.title,item.idCard,item.freightBasis,item.billingDuration,item.taxExpertFee,item.incomeTaxPayable,item.afterTaxAmount,item.openBank,item.bankCard] }) // 定义表头 const headers = [ - ["序号", "姓名", "工作单位", "职称", "身份证号", "计费标准", "计费时长", "专家费", "应纳税所得额", "应缴个税", "税后金额", "开户银行", "卡号"] + ["序号", "姓名", "工作单位", "职称", "身份证号", "计费标准", "计费时长", "专家费", "应缴税费", "税后金额", "开户银行", "卡号"] ] // 固定一行:经办人和负责人 const footer = [ - ["经办人:", "", "", "", "", "处室负责人:", "", "", "", "","","",""] + ["经办人:", "", "", "", "", "处室负责人:", "", "", "", "","",""] ] // 创建工作表 const ws = XLSX.utils.aoa_to_sheet([ @@ -325,11 +325,11 @@ const dataRowCount = data.length; // 合并单元格的范围 ws['!merges'] = [ - { s: { r: 0, c: 0 }, e: { r: 0, c: 12 } }, // 合并标题:第1行 0列到12列 + { s: { r: 0, c: 0 }, e: { r: 0, c: 11 } }, // 合并标题:第1行 0列到12列 { s: { r: 1, c: 0 }, e: { r: 1, c: 4 } }, // 合并填报处室:第2行 第0列到4列 - { s: { r: 1, c: 5 }, e: { r: 1, c: 12 } }, // 合并单位:第2行 第5列到12列 + { s: { r: 1, c: 5 }, e: { r: 1, c: 11 } }, // 合并单位:第2行 第5列到12列 { s: { r: 3 + dataRowCount, c: 0 }, e: { r: 3 + dataRowCount, c: 4 } }, // 合并经办人:最后一行的第0列到4列 - { s: { r: 3 + dataRowCount, c: 5 }, e: { r: 3 + dataRowCount, c: 12 } }, // 合并负责人:最后一行的第5列到12列 + { s: { r: 3 + dataRowCount, c: 5 }, e: { r: 3 + dataRowCount, c: 11 } }, // 合并负责人:最后一行的第5列到12列 ] // 设置标题 if (!ws['A1']) ws['A1'] = {}; // 确保 A1 单元格存在 -- Gitblit v1.9.2