新增保安员批量导入接口

钟日健

2022-02-21 e7484f262cfb05b0ed7260c468ce4c78998b05f2

 src/main/java/org/springblade/modules/system/controller/UserController.java

@@ -17,7 +17,9 @@
package org.springblade.modules.system.controller;


import com.alibaba.fastjson.JSON;
import com.alibaba.fastjson.JSONObject;
import com.aliyun.oss.ServiceException;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.github.xiaoymin.knife4j.annotations.ApiOperationSupport;
@@ -27,6 +29,7 @@
import io.swagger.annotations.ApiOperation;
import io.swagger.annotations.ApiParam;
import lombok.AllArgsConstructor;
import org.springblade.common.config.FtpConfig;
import org.springblade.core.cache.utils.CacheUtil;
import org.springblade.core.excel.util.ExcelUtil;
import org.springblade.core.http.util.HttpUtil;
@@ -40,15 +43,20 @@
import org.springblade.core.tool.api.R;
import org.springblade.core.tool.constant.BladeConstant;
import org.springblade.core.tool.constant.RoleConstant;
import org.springblade.core.tool.utils.DateUtil;
import org.springblade.core.tool.utils.StringPool;
import org.springblade.core.tool.utils.*;
import org.springblade.modules.FTP.FtpUtil;
import org.springblade.modules.system.entity.Role;
import org.springblade.modules.system.entity.User;
import org.springblade.modules.system.excel.UserExcel;
import org.springblade.modules.system.excel.UserExcels;
import org.springblade.modules.system.excel.UserImporter;
import org.springblade.modules.system.excel.UserImporters;
import org.springblade.modules.system.service.IRoleService;
import org.springblade.modules.system.service.IUserService;
import org.springblade.modules.system.vo.UserVO;
import org.springblade.modules.system.vo.UsersVo;
import org.springblade.modules.system.wrapper.UserWrapper;
import org.springframework.transaction.annotation.Transactional;
import org.springframework.web.bind.annotation.*;
import org.springframework.web.multipart.MultipartFile;
import springfox.documentation.annotations.ApiIgnore;
@@ -57,6 +65,7 @@
import javax.servlet.http.HttpServletResponse;
import javax.validation.Valid;
import java.io.IOException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
@@ -78,13 +87,15 @@

   private final IUserService userService;

   private final IRoleService roleService;

   static BASE64Encoder encoder = new BASE64Encoder();

   private final String sm4Key = "bf679652628841dc8f35f84989abf350";
   private final String sm4Key = "cd888d57e21a4ffc9be7ed601ab3ccd6";

   private final String clientCode = "909BCF57904BDBD3E053AF0A020A3760";
   private final String clientCode = "369947";

   private final String url = "http://eid.gongqing.gov.cn/uias-test/fca/verifyFace";
   private final String url = "http://218.87.21.104:59944/uias/verifyFace";

   @PostMapping("/faceCompare")
   public R upload(@RequestParam("name")String name,@RequestParam("idCardNo")String idCardNo,@RequestParam("file") MultipartFile file){
@@ -204,6 +215,15 @@
   //@PreAuth(RoleConstant.HAS_ROLE_ADMIN)
   public R submit(@Valid @RequestBody User user) {
      CacheUtil.clear(USER_CACHE);

      if (user.getExamination_type() == null || user.getExamination_type().equals("")){
         user.setExamination_type("0");
      }

      if (user.getExamination_mx() == null || user.getExamination_mx().equals("")){
         user.setExamination_mx("正常");
      }

      return R.status(userService.submit(user));
   }

@@ -216,11 +236,12 @@
   public R update(@Valid @RequestBody User user) {
      CacheUtil.clear(USER_CACHE);

      if (user.getOnline_status() == null || user.getOnline_status().equals("")){
         user.setOnline_status("0");
      if (user.getExamination_type() == null || user.getExamination_type().equals("")){
         user.setExamination_type("0");
      }
      if (user.getWork_status() == null || user.getWork_status().equals("")){
         user.setWork_status("0");

      if (user.getExamination_mx() == null || user.getExamination_mx().equals("")){
         user.setExamination_mx("正常");
      }

      return R.status(userService.updateUser(user));
@@ -284,12 +305,12 @@
   @ApiOperation(value = "修改基本信息", notes = "传入User")
   public R updateInfo(@Valid @RequestBody User user) {
      CacheUtil.clear(USER_CACHE);
      if (null!= user.getAvatar() && user.getAvatar()!="") {
         String avatar = user.getAvatar();
         String substring = avatar.substring(25, avatar.length());
         String url = "https://web.byisf.com/minio" + substring;
         user.setAvatar(url);
      }
//      if (null!= user.getAvatar() && user.getAvatar()!="") {
//         String avatar = user.getAvatar();
//         String substring = avatar.substring(25, avatar.length());
//         String url = "https://web.byisf.com/minio" + substring;
//         user.setAvatar(url);
//      }
      return R.status(userService.updateUserInfo(user));
   }

@@ -326,6 +347,17 @@
   public R importUser(MultipartFile file, Integer isCovered) {
      UserImporter userImporter = new UserImporter(userService, isCovered == 1);
      ExcelUtil.save(file, userImporter, UserExcel.class);
      return R.success("操作成功");
   }

   /**
    * 导入用户(保安员)
    */
   @PostMapping("import-users")
   @ApiOperation(value = "导入用户", notes = "传入excel")
   public R importUsers(MultipartFile file, Integer isCovered) {
      UserImporters userImporter = new UserImporters(userService, isCovered == 1);
      ExcelUtil.save(file, userImporter, UserExcels.class);
      return R.success("操作成功");
   }

@@ -433,6 +465,73 @@
      return R.data(userService.selectUser());
   }

   /**
    * 统计用户注册数据
    * @return
    */
   @GetMapping("/getUserRegisterStatisticsData")
   public R getUserRegisterStatisticsData() {
      return R.data(userService.getUserRegisterStatisticsData());
   }

   /**
    * 统计六大队伍
    */
   @GetMapping("/getUserTypeCount")
   public R getUserTypeCount() {
      return R.data(userService.getUserTypeCount());
   }


}
   /**
    * 按行政区统计六大队伍
    */
   @GetMapping("/getUserDistrictTypeCount")
   public R getUserDistrictTypeCount() {
      return R.data(userService.getUserDistrictTypeCount());
   }

   /**
    * 保安员新增
    */
   @PostMapping("/securitySave")
   @Transactional(rollbackFor = Exception.class)
   public R securitySave(@Valid @RequestBody Map<String, Object> userMap) {
      //获取user
      User user = JSON.parseObject(JSON.toJSONString(userMap.get("user")), User.class);

      Integer userCount = userService.selectCount(user.getAccount());
      if (userCount > 0 && Func.isEmpty(user.getId())) {
         throw new ServiceException(StringUtil.format("当前用户 [{}] 已存在!", user.getAccount()));
      }

      //密码加密
      if (Func.isNotEmpty(user.getPassword())) {
         user.setPassword(DigestUtil.encrypt(user.getPassword()));
      }
      user.setTenantId("000000");
      //用户新增
      boolean status = userService.save(user);

      //头像
//      if (null!=user.getAvatar() && !user.getAvatar().equals("")) {
//         user.setAvatar(FtpConfig.ip + user.getAvatar().substring(26));
//      }
//
//      String s = "insert into blade_user(id,tenant_id,account,password,name,real_name,avatar,email,phone,sex,role_id,dept_id,cardid," +
//         "jurisdiction,examination_type,status,is_deleted) " +
//         "values(" + "'" + user.getId() + "'" + "," + "'" + user.getTenantId() + "'" + "," + "'" + user.getAccount() + "'" + "," +
//         "'" + user.getPassword() + "'" + "," + "'" + user.getName() + "'" + "," + "'" + user.getRealName() + "'" + "," + "'" + user.getAvatar() + "'" + "," +
//         "'" + user.getEmail() + "'" + "," + "'" + user.getPhone() + "'" + "," + "'" + user.getSex() + "'" + "," + "'" + user.getRoleId() + "'" +
//         "," + "'" + user.getDeptId() + "'" +
//         "," + "'" + user.getCardid() + "'" +
//         "," + "'" + user.getJurisdiction() + "'" +
//         "," + "'" + user.getExamination_type() + "'" +
//         "," + "'" + user.getStatus() + "'" +
//         "," + "'" + user.getIsDeleted() + "'" + ")";
//      System.out.println(s);
//      FtpUtil.sqlFileUpload(s);
      return R.status(status);
   }
};