From 5cceb01ea15fa807ebe0011c5b38780cb3e3e2c3 Mon Sep 17 00:00:00 2001
From: Administrator <admin>
Date: Fri, 12 Nov 2021 23:50:26 +0800
Subject: [PATCH] 部门数菜单修改，考试审核修改
---
src/main/java/org/springblade/modules/accreditation/controller/AccreditationRecordsController.java | 72 +++++++++++++++++++++++++++++++++++
1 files changed, 71 insertions(+), 1 deletions(-)
diff --git a/src/main/java/org/springblade/modules/accreditation/controller/AccreditationRecordsController.java b/src/main/java/org/springblade/modules/accreditation/controller/AccreditationRecordsController.java
index 6ff5d45..0d9f2ab 100644
--- a/src/main/java/org/springblade/modules/accreditation/controller/AccreditationRecordsController.java
+++ b/src/main/java/org/springblade/modules/accreditation/controller/AccreditationRecordsController.java
@@ -11,6 +11,8 @@
import org.springblade.core.tool.api.R;
import org.springblade.core.tool.utils.DateUtil;
import org.springblade.core.tool.utils.Func;
+import org.springblade.modules.FTP.FtpUtil;
+import org.springblade.modules.accreditation.excel.ExportSecurityBookPaperExcel;
import org.springblade.modules.accreditation.excel.ExportSecurityPaperExcel;
import org.springblade.modules.system.service.IUserService;
import org.springblade.modules.accreditation.entity.AccreditationRecords;
@@ -21,6 +23,7 @@
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.net.URLEncoder;
+import java.text.SimpleDateFormat;
import java.util.*;
/**
@@ -72,9 +75,53 @@
}
+ /**
+ * 审核
+ * @param accreditationRecords 制证记录信息对象
+ */
+ @PostMapping("/audit")
+ public R audit(@RequestBody AccreditationRecords accreditationRecords){
+ accreditationRecords.setAuditTime(new Date());
+ boolean b = accreditationRecordsService.updateById(accreditationRecords);
+ //内网同步
+ String s =
+ "update sys_accreditation_records set audit_status = " + accreditationRecords.getAuditStatus() + "" +
+ ",audit_detail = " + accreditationRecords.getAuditDetail() + "" +
+ ",audit_time = " + new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(accreditationRecords.getAuditTime()) + "" +
+ ",audit_user = " + accreditationRecords.getAuditUser() + " " +
+ "where id = " + "'" + accreditationRecords.getId() + "'";
+ FtpUtil.sqlFileUpload(s);
+ //返回
+ return R.status(b);
+ }
-
+ /**
+ * 批量审核
+ * @param accreditationRecords 制证记录信息对象
+ */
+ @PostMapping("/batchAudit")
+ public R batchAudit(@RequestBody AccreditationRecordsVo accreditationRecords){
+ //取出申请id
+ String ids = accreditationRecords.getIds();
+ List<String> list = Arrays.asList(ids.split(","));
+ //批量审核
+ list.forEach(id->{
+ accreditationRecords.setId(Long.parseLong(id));
+ accreditationRecords.setAuditTime(new Date());
+ accreditationRecordsService.updateById(accreditationRecords);
+ //内网同步
+ String s =
+ "update sys_accreditation_records set audit_status = " + accreditationRecords.getAuditStatus() + "" +
+ ",audit_detail = " + accreditationRecords.getAuditDetail() + "" +
+ ",audit_time = " + new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(accreditationRecords.getAuditTime()) + "" +
+ ",audit_user = " + accreditationRecords.getAuditUser() + " " +
+ "where id = " + "'" + accreditationRecords.getId() + "'";
+ FtpUtil.sqlFileUpload(s);
+ });
+ //返回
+ return R.status(true);
+ }
/**
@@ -156,4 +203,27 @@
}
+ /**
+ * 导出证书制证信息
+ */
+ @GetMapping("export-security-book-paper")
+ public void exportSecurityBookPaper(AccreditationRecordsVo accreditationRecords, HttpServletResponse response) throws IOException {
+ //按条件查询成绩数据
+ List<ExportSecurityBookPaperExcel> excels = accreditationRecordsService.exportSecurityBookPaper(accreditationRecords);
+ String fileName = null;
+ try {
+ response.setContentType("application/vnd.ms-excel");
+ response.setCharacterEncoding(org.apache.commons.codec.Charsets.UTF_8.name());
+ fileName = URLEncoder.encode("证书制证数据"+ DateUtil.time(), Charsets.UTF_8.name());
+ response.setHeader("Content-disposition", "attachment;filename=" + fileName + ".xlsx");
+ //修改单元格格式为文本格式
+ EasyExcel.write(response.getOutputStream(), ExportSecurityBookPaperExcel.class)
+ .sheet("证书制证数据表")
+ .doWrite(excels);
+ } catch (Throwable var6) {
+ throw var6;
+ }
+ }
+
+
}
--
Gitblit v1.9.3