From 3a91b4d850f4b2b9a42270070ba5bffcac1de97c Mon Sep 17 00:00:00 2001
From: Administrator <admin>
Date: Sat, 22 Jan 2022 09:40:56 +0800
Subject: [PATCH] 使用easyExcel 通过填充模板的方式填入多表格带标题数据的导出
---
src/main/java/org/springblade/modules/accreditation/service/impl/AccreditationRecordsServiceImpl.java | 9 +++++++++
1 files changed, 9 insertions(+), 0 deletions(-)
diff --git a/src/main/java/org/springblade/modules/accreditation/service/impl/AccreditationRecordsServiceImpl.java b/src/main/java/org/springblade/modules/accreditation/service/impl/AccreditationRecordsServiceImpl.java
index c763ebb..d97cfe5 100644
--- a/src/main/java/org/springblade/modules/accreditation/service/impl/AccreditationRecordsServiceImpl.java
+++ b/src/main/java/org/springblade/modules/accreditation/service/impl/AccreditationRecordsServiceImpl.java
@@ -130,6 +130,15 @@
List<ExportSecurityPaperExcel> list = new ArrayList<>();
//遍历
accreditationRecordsVos.forEach(accreditationRecordsVo -> {
+ //导出即修改为已制证状态
+ AccreditationRecords accreditationRecords1 = new AccreditationRecords();
+ accreditationRecords1.setId(accreditationRecordsVo.getId());
+ accreditationRecords1.setStatus(2);
+ //记录导出时间为制证时间
+ accreditationRecords1.setPaperTime(new Date());
+ //修改
+ this.updateById(accreditationRecords1);
+
ExportSecurityPaperExcel excel = new ExportSecurityPaperExcel();
//数据转换封装
excel.setRealName(accreditationRecordsVo.getRealName());
--
Gitblit v1.9.3