From d6caf9fdfe4b8caa8ae3bca22758487e88e2ea82 Mon Sep 17 00:00:00 2001
From: 马宇豪 <978517621@qq.com>
Date: 星期五, 07 三月 2025 09:45:50 +0800
Subject: [PATCH] 导出报销表修改
---
src/views/safetyReview/expertManage/postEvaluation/components/evaluate.vue | 14 +++++++-------
src/views/safetyReview/projectManage/index.vue | 37 ++++++++++++++++++++++++-------------
2 files changed, 31 insertions(+), 20 deletions(-)
diff --git a/src/views/safetyReview/expertManage/postEvaluation/components/evaluate.vue b/src/views/safetyReview/expertManage/postEvaluation/components/evaluate.vue
index 8545953..13bf3d1 100644
--- a/src/views/safetyReview/expertManage/postEvaluation/components/evaluate.vue
+++ b/src/views/safetyReview/expertManage/postEvaluation/components/evaluate.vue
@@ -216,13 +216,13 @@
<div style="font-size: 12px;color: red">系统自动计算金额仅供参考，请注意核对。</div>
</el-form-item>
</el-col>
- <el-col :span="12">
- <el-form-item label="税后金额">
- <el-input v-model="state.form.afterTaxAmount" type="number" :readonly="state.disable">
- <template #append>元</template>
- </el-input>
- </el-form-item>
- </el-col>
+<!-- <el-col :span="12">-->
+<!-- <el-form-item label="税后金额">-->
+<!-- <el-input v-model="state.form.afterTaxAmount" type="number" :readonly="state.disable">-->
+<!-- <template #append>元</template>-->
+<!-- </el-input>-->
+<!-- </el-form-item>-->
+<!-- </el-col>-->
</el-row>
<el-row>
diff --git a/src/views/safetyReview/projectManage/index.vue b/src/views/safetyReview/projectManage/index.vue
index d1624b7..f4a94e4 100644
--- a/src/views/safetyReview/projectManage/index.vue
+++ b/src/views/safetyReview/projectManage/index.vue
@@ -297,21 +297,25 @@
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.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.openBank,item.bankCard]
})
-
+ console.log(data,'data')
// 定义表头
const headers = [
- ["序号", "姓名", "工作单位", "职称", "身份证号", "计费标准", "计费时长", "专家费", "应缴税费", "税后金额", "开户银行", "卡号"]
+ ["序号", "姓名", "工作单位", "职称", "身份证号", "计费标准", "计费时长", "专家费", "应缴税费", "开户银行", "卡号"]
]
// 固定一行：经办人和负责人
const footer = [
- ["经办人：", "", "", "", "", "处室负责人：", "", "", "", "","",""]
+ ["经办人：", "", "", "", "", "处室负责人：", "", `合计：${data.reduce((accumulator, currentValue) => {
+ return accumulator + currentValue[7]
+ }, 0).toFixed(2)}`,`合计：${data.reduce((accumulator, currentValue) => {
+ return accumulator + currentValue[8]
+ }, 0).toFixed(2)}`,"",""]
]
// 创建工作表
const ws = XLSX.utils.aoa_to_sheet([
@@ -325,11 +329,11 @@
const dataRowCount = data.length;
// 合并单元格的范围
ws['!merges'] = [
- { s: { r: 0, c: 0 }, e: { r: 0, c: 11 } }, // 合并标题：第1行 0列到12列
+ { s: { r: 0, c: 0 }, e: { r: 0, c: 10 } }, // 合并标题：第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: 11 } }, // 合并单位：第2行 第5列到12列
+ { s: { r: 1, c: 5 }, e: { r: 1, c: 10 } }, // 合并单位：第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: 11 } }, // 合并负责人：最后一行的第5列到12列
+ { s: { r: 3 + dataRowCount, c: 5 }, e: { r: 3 + dataRowCount, c: 6} }, // 合并负责人：最后一行的第5列到+6列
]
// 设置标题
if (!ws['A1']) ws['A1'] = {}; // 确保 A1 单元格存在
@@ -346,7 +350,7 @@
// 设置数据区（包括填报处室、单位、数据行和最后一行）为左对齐
const totalRows = 3 + dataRowCount + 1; // 标题、固定行和数据行的总数
for (let r = 3; r <= totalRows; r++) { // 遍历每一行
- for (let c = 0; c < 13; c++) { // 遍历每一列
+ for (let c = 0; c < 11; c++) { // 遍历每一列
const cellRef = `${String.fromCharCode(65 + c)}${r}`;
if (!ws[cellRef]) ws[cellRef] = {}; // 确保单元格存在
ws[cellRef].s = {
@@ -366,12 +370,19 @@
}
// 设置最后一行（经办人、负责人）左对齐
const lastRowStart = 3 + dataRowCount;
- for (let c = 0; c < 13; c++) {
+ for (let c = 0; c < 11; c++) {
const cellRef = `${String.fromCharCode(65 + c)}${lastRowStart + 1}`;
+ console.log(cellRef,'ref')
if (!ws[cellRef]) ws[cellRef] = {}; // 确保单元格存在
- ws[cellRef].s = {
- alignment: { horizontal: 'left', vertical: 'center' } // 设置为左对齐
- };
+ if(cellRef == 'H'+ (4 + dataRowCount) || cellRef == 'I'+ (4 + dataRowCount)){
+ ws[cellRef].s = {
+ alignment: { horizontal: 'center', vertical: 'center' } // 设置居中对齐
+ }
+ }else{
+ ws[cellRef].s = {
+ alignment: { horizontal: 'left', vertical: 'center' } // 设置为左对齐
+ }
+ }
}
// 设置列宽，计算每列的最大宽度
const MIN_COL_WIDTH = 60;
--
Gitblit v1.9.2