新增保安员证相关信息导出接口（包含图片，二维码）

Administrator

2021-10-29 f41f7a7efb363425a88e1a060f81f785ba2b57a8

 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.*;
@@ -380,10 +387,14 @@
   }

   @Override
//   @Transactional(rollbackFor = Exception.class)
//   @Transactional(rollbackFor = Exception.class) 去除事务回滚
   public void importUser(List<UserExcel> data, Boolean isCovered,String deptId) {
      //将不能导入的保安员账号存起来
      List<String> errorList = new ArrayList<>();
      //将需要新增的保安员信息存入集合
      List<User> insertList = new ArrayList<>();
      //将需要更新的保安员信息存入集合
      List<User> updateList = new ArrayList<>();
      //导入状态，默认为true ,如果有一个出现问题则为 false
      AtomicBoolean status = new AtomicBoolean(true);
      data.forEach(userExcel -> {
@@ -404,7 +415,6 @@
         //判断当前用户是否已在本单位，如果是的更新数据
         User user1 = new User();
         user1.setAccount(user.getCardid());
//         System.out.println("user.getCardid() = " + user.getCardid());
         user1.setIsDeleted(0);
         user1.setStatus(1);
         User user2 = this.getOne(Condition.getQueryWrapper(user1));
@@ -805,6 +815,10 @@
      if (Integer.parseInt(type) == 4) {
         list = baseMapper.getWorkReportInfo(type, deptid, jurisdiction);
      }
      //现场检查获取保安员
      if (Integer.parseInt(type) == 5) {
         list = baseMapper.getSecurityInfo(jurisdiction);
      }
      return list;
   }

@@ -876,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;
   }
}