辖区人员查询

zengh

2022-03-08 d331f44d8d8aa68564bd3fa7f85046e945025ae8

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

@@ -45,15 +45,20 @@
import org.springblade.core.tool.constant.RoleConstant;
import org.springblade.core.tool.utils.*;
import org.springblade.modules.FTP.FtpUtil;
import org.springblade.modules.system.dto.UserDTO;
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.UserRegisterStatisVO;
import org.springblade.modules.system.vo.UserVO;
import org.springblade.modules.system.vo.UsersVo;
import org.springblade.modules.system.wrapper.UserWrapper;
import org.springblade.modules.taskqd.vo.TaskqdVO;
import org.springframework.transaction.annotation.Transactional;
import org.springframework.web.bind.annotation.*;
import org.springframework.web.multipart.MultipartFile;
@@ -64,10 +69,7 @@
import javax.validation.Valid;
import java.io.IOException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import java.util.*;

import static org.springblade.core.cache.constant.CacheConstant.USER_CACHE;

@@ -349,6 +351,17 @@
   }

   /**
    * 导入用户(保安员)
    */
   @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("操作成功");
   }

   /**
    * 导出用户
    */
   @GetMapping("export-user")
@@ -501,23 +514,138 @@
      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() + "'" + ")";
//      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);
//      FtpUtil.sqlFileUpload(s);
      return R.status(status);
   }


   /**
    * 保安员新增(数据同步调用)
    */
   @PostMapping("/securitySaves")
   @Transactional(rollbackFor = Exception.class)
   public R securitySaves(@RequestBody User user) {
      Integer userCount = userService.selectCount(user.getAccount());
      //判断用户是否存在
      if (userCount > 0) {
         throw new ServiceException(StringUtil.format("当前用户 [{}] 已存在!", user.getAccount()));
      }
      user.setRoleId("1372092102682521602");
      user.setDeptId("1424615972718895106");
      user.setStype("1");
      user.setId(null);
      //用户新增
      boolean status = userService.save(user);
//      System.out.println("user = " + user);
      //返回
      return R.status(status);
   }

   /**
    * 保安员新增(数据同步调用)
    */
   @PostMapping("/updateBySecurtiy")
   @Transactional(rollbackFor = Exception.class)
   public R updateBySecurtiy(@RequestBody User user) {
      User user1 = new User();
      user1.setIsDeleted(0);
      user1.setStatus(1);
      user1.setCardid(user.getCardid());
      User one = userService.getOne(Condition.getQueryWrapper(user1));
      boolean status = false;
      if (null!=one){
         one.setRealName(user.getRealName());
         one.setAvatar(user.getAvatar());
         one.setPhone(user.getPhone());
         one.setExamination_type(user.getExamination_type());
         one.setStatus(user.getStatus());
         one.setUpdateTime(new Date());
         //修改
         status = userService.updateById(one);
      }
      //返回
      return R.status(status);
   }

   /**
    * 保安员信息修改(账号,身份证,密码 修改)
    */
   @PostMapping("/updateUserByAccount")
   @Transactional(rollbackFor = Exception.class)
   public R updateUserByAccount(@RequestBody UserDTO user) {
      User user1 = new User();
      user1.setIsDeleted(0);
      user1.setStatus(1);
      user1.setCardid(user.getOldCardid());
      User one = userService.getOne(Condition.getQueryWrapper(user1));
      boolean status = false;
      if (null!=one){
         //修改
         one.setAccount(user.getCardid());
         one.setCardid(user.getCardid());
         one.setPassword(user.getPassword());
         one.setAvatar(user.getAvatar());
         one.setPhone(user.getPhone());
         one.setRealName(user.getRealName());
         one.setUpdateTime(new Date());
         //用户修改
          status = userService.updateById(one);
      }
      //返回
      return R.status(status);
   }

   /**
    * 同步删除
    */
   @PostMapping("/removeSecurity")
   @Transactional(rollbackFor = Exception.class)
   public R removeSecurity(@RequestBody User user) {
      User user1 = new User();
      user1.setIsDeleted(0);
      user1.setStatus(1);
      user1.setCardid(user.getCardid());
      User one = userService.getOne(Condition.getQueryWrapper(user1));
      boolean status = false;
      if (null!=one){
         //修改
         one.setIsDeleted(1);
         //用户修改
         status = userService.removeById(one.getId());
      }
      //返回
      return R.status(status);
   }

   /**
    * 人员统计
    */
   @GetMapping("/userCount")
   public R cancelTask(String xid,String index) {
      List<UserRegisterStatisVO> cout =  userService.getUserTypeCountXq(xid);
      List<UserVO> list =  userService.getUserTypeList(xid,index);
      Map<String,Object> res = new HashMap<>();
      res.put("cout",cout);
      res.put("list",list);
      return R.data(res);
   }


}