From 7336d925a37ae4f02e8cad10948db662178e9c5e Mon Sep 17 00:00:00 2001
From: liurunyu <lry9898@163.com>
Date: 星期二, 27 五月 2025 11:33:46 +0800
Subject: [PATCH] 完善用户导出功能
---
pms-parent/pms-web-base/src/main/java/com/dy/pmsBase/user/UserCtrl.java | 34 ++++++++++++++++++++++++++++++++++
1 files changed, 34 insertions(+), 0 deletions(-)
diff --git a/pms-parent/pms-web-base/src/main/java/com/dy/pmsBase/user/UserCtrl.java b/pms-parent/pms-web-base/src/main/java/com/dy/pmsBase/user/UserCtrl.java
index 7e5bd55..420464f 100644
--- a/pms-parent/pms-web-base/src/main/java/com/dy/pmsBase/user/UserCtrl.java
+++ b/pms-parent/pms-web-base/src/main/java/com/dy/pmsBase/user/UserCtrl.java
@@ -1,5 +1,6 @@
package com.dy.pmsBase.user;
+import com.alibaba.excel.converters.Converter;
import com.dy.common.aop.SsoAop;
import com.dy.common.aop.SsoPowerAop;
import com.dy.common.util.MD5;
@@ -10,7 +11,12 @@
import com.dy.pmsGlobal.pojoBa.BaRole;
import com.dy.pmsGlobal.pojoBa.BaUser;
import com.dy.pmsGlobal.util.Constant;
+import com.dy.pmsGlobal.util.ExportExcelUtil;
+import com.dy.pmsGlobal.util.QrCodeConstant;
+import com.dy.pmsGlobal.util.QrCodeUtil;
+import com.google.zxing.WriterException;
import com.mysql.cj.util.StringUtils;
+import jakarta.servlet.http.HttpServletResponse;
import jakarta.validation.Valid;
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.factory.annotation.Autowired;
@@ -19,6 +25,8 @@
import org.springframework.validation.annotation.Validated;
import org.springframework.web.bind.annotation.*;
+import java.io.IOException;
+import java.util.ArrayList;
import java.util.List;
import java.util.Objects;
@@ -30,6 +38,9 @@
@RequestMapping(path = "user")
@SuppressWarnings("unchecked")//java鐗堟湰瓒婇珮锛屽娉涘瀷绾︽潫瓒婁弗锛屾墍浠ラ厤缃甋uppressWarnings("unchecked")
public class UserCtrl {
+
+ private static final String fileName = "淇℃伅" ;
+ private static final String sheetName = "鐢ㄦ埛淇℃伅" ;
@Autowired
private UserSv sv;
@@ -245,4 +256,27 @@
}
}
+ @PostMapping(path="export")
+ @SsoPowerAop(power = "10100001")
+ @Log("瀵煎嚭鐢ㄦ埛淇℃伅")
+ public void export(HttpServletResponse response) {
+ List<Converter> list = new ArrayList<>();
+ List<BaUser> users = sv.selectAll();
+ if (users != null) {
+ for (BaUser user : users) {
+ ExcelVo vo = new ExcelVo();
+ vo.name = user.name;
+ try {
+ vo.qrCode = QrCodeUtil.genQrCode(QrCodeConstant.TypeStation + user.id);
+ } catch (IOException e) {
+ e.printStackTrace();
+ } catch (WriterException e) {
+ e.printStackTrace();
+ }
+ list.add(vo);
+ }
+ }
+ ExportExcelUtil.downloadExcel(response, fileName, sheetName, list);
+ }
+
}
--
Gitblit v1.8.0