From f41f7a7efb363425a88e1a060f81f785ba2b57a8 Mon Sep 17 00:00:00 2001
From: Administrator <admin>
Date: Fri, 29 Oct 2021 21:00:04 +0800
Subject: [PATCH] 新增保安员证相关信息导出接口（包含图片，二维码）
---
src/main/java/org/springblade/modules/system/service/impl/UserServiceImpl.java | 60 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 60 insertions(+), 0 deletions(-)
diff --git a/src/main/java/org/springblade/modules/system/service/impl/UserServiceImpl.java b/src/main/java/org/springblade/modules/system/service/impl/UserServiceImpl.java
index eba795a..553ae83 100644
--- a/src/main/java/org/springblade/modules/system/service/impl/UserServiceImpl.java
+++ b/src/main/java/org/springblade/modules/system/service/impl/UserServiceImpl.java
@@ -44,6 +44,7 @@
import org.springblade.modules.information.entity.Information;
import org.springblade.modules.information.service.IInformationService;
import org.springblade.modules.system.entity.*;
+import org.springblade.modules.system.excel.ExportSecurityPaperExcel;
import org.springblade.modules.system.excel.QrCodeExcel;
import org.springblade.modules.system.excel.UserExcel;
import org.springblade.modules.system.mapper.UserMapper;
@@ -51,6 +52,10 @@
import org.springblade.modules.system.service.*;
import org.springblade.modules.system.vo.UserVO;
import org.springblade.modules.system.wrapper.UserWrapper;
+import org.springframework.http.HttpHeaders;
+import org.springframework.http.HttpStatus;
+import org.springframework.http.MediaType;
+import org.springframework.http.ResponseEntity;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
@@ -58,6 +63,8 @@
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.UnsupportedEncodingException;
+import java.net.MalformedURLException;
+import java.net.URL;
import java.net.URLEncoder;
import java.text.SimpleDateFormat;
import java.util.*;
@@ -883,4 +890,57 @@
}
});
}
+
+
+ /**
+ * 导出保安员证信息
+ * @param user
+ * @return
+ */
+ @Override
+ public List<ExportSecurityPaperExcel> exportSecurityPaperList(UserVO user) {
+ //查询数据
+ List<UserVO> userVOList = baseMapper.exportSecurityPaperList(user);
+ if (userVOList.size()>0) {
+ //返回的集合数据
+ List<ExportSecurityPaperExcel> list = new ArrayList<>();
+ //遍历
+ userVOList.forEach(userVO -> {
+ ExportSecurityPaperExcel excel = new ExportSecurityPaperExcel();
+ //数据转换封装
+ excel.setRealName(userVO.getRealName());
+ excel.setIdCardNo(userVO.getCardid());
+ excel.setDeptName(userVO.getDeptName());
+ //如果头像有
+ if (null != userVO.getAvatar() && userVO.getAvatar() != "") {
+ try {
+ if (userVO.getAvatar().contains("http:")) {
+ excel.setAvatar(new URL(userVO.getAvatar()));
+ }
+ } catch (MalformedURLException e) {
+ e.printStackTrace();
+ }
+ }
+ //如果保安证编号不为空
+ if (null != userVO.getSecuritynumber() && userVO.getSecuritynumber() != "") {
+ //去生成二维码
+ String url = "http://223.82.109.183:2080/securityInfo.html";
+ String encoded = null;
+ try {
+ encoded = URLEncoder.encode(userVO.getSecuritynumber(), "UTF-8");
+ String content = url + "?securityNumber=" + encoded;
+ URLEncoder.encode(content, "utf-8");
+ byte[] qrCodeImage = QRCodeUtil.getQRCodeImage(content, 350, 350);
+ //设置二维码
+ excel.setQrCode(qrCodeImage);
+ } catch (Exception e) {
+ e.printStackTrace();
+ }
+ }
+ list.add(excel);
+ });
+ return list;
+ }
+ return null;
+ }
}
--
Gitblit v1.9.3