From 247abfbc0b322a04f8dc5fcf01fe7989b25fd7e9 Mon Sep 17 00:00:00 2001
From: Administrator <admin>
Date: Thu, 04 Nov 2021 10:35:29 +0800
Subject: [PATCH] 保安员发证时间更新接口新增
---
src/main/java/org/springblade/modules/system/controller/UserController.java | 49 ++++++++++++++++++++++---------------------------
1 files changed, 22 insertions(+), 27 deletions(-)
diff --git a/src/main/java/org/springblade/modules/system/controller/UserController.java b/src/main/java/org/springblade/modules/system/controller/UserController.java
index 1888ff1..7c0f4c9 100644
--- a/src/main/java/org/springblade/modules/system/controller/UserController.java
+++ b/src/main/java/org/springblade/modules/system/controller/UserController.java
@@ -282,6 +282,28 @@
return R.success("修改成功");
}
+
+ /**
+ * 修改发证时间
+ */
+ @PostMapping("/updatePaperTime")
+ public R updatePaperTime(@RequestBody User user) {
+ user.setPaperTime(new Date());
+ userService.updateById(user);
+ String paperTime = null;
+ //发证日期处理
+ if (user.getPaperTime() == null) {
+ paperTime = null;
+ } else {
+ paperTime = new SimpleDateFormat("yyyy-MM-dd").format(user.getPaperTime());
+ }
+ String s1 =
+ "update blade_user set paper_time = " + "'" + paperTime + "'"
+ + " " + "where id = " + "'" + user.getId() + "'";
+ FtpUtil.sqlFileUpload(s1);
+ return R.success("修改成功");
+ }
+
/**
* 删除
*/
@@ -415,33 +437,6 @@
// ExcelUtil.export(response, "用户数据" + DateUtil.time(), "用户数据表", list, UserExcel.class);
// }
- /**
- * 导出保安员证信息
- */
- @GetMapping("export-security-paper")
- public void exportSecurityPaper(UserVO user, HttpServletResponse response) throws IOException {
- //按条件查询成绩数据
- List<ExportSecurityPaperExcel> excels = userService.exportSecurityPaperList(user);
- String fileName = null;
- try {
- response.setContentType("application/vnd.ms-excel");
- response.setCharacterEncoding(org.apache.commons.codec.Charsets.UTF_8.name());
- fileName = URLEncoder.encode("保安员证数据", Charsets.UTF_8.name());
- response.setHeader("Content-disposition", "attachment;filename=" + fileName + ".xlsx");
- //修改单元格格式为文本格式
- EasyExcel.write(response.getOutputStream(), ExportSecurityPaperExcel.class)
- .sheet("保安员证数据表")
- //自定义行高
-// .registerWriteHandler(new CustomCellWriteHeightConfig())
- //自定义宽度
-// .registerWriteHandler(new CustomCellWriteWeightConfig())
- //写入
- .doWrite(excels);
- } catch (Throwable var6) {
- throw var6;
- }
-// ExcelUtil.export(response, "保安员证数据" + DateUtil.time(), "保安员证数据表", excels, ExportSecurityPaperExcel.class);
- }
/**
* 导出模板
--
Gitblit v1.9.3