用户号已经存在是否覆盖解决办

@Transactional(rollbackFor = Exception.class)
    @Override
    public void importUser(List<ExcelEmployeeBasicInformation> data, Boolean isCovered) {
       log.info("员工基本信息导入data======="+data);
       if(Func.isNotEmpty(data)){
           for(int i=0;i<data.size();i++){
               //根据租户id和账号查询用户是否已经存在
               User oldUser = UserCache.getUser(data.get(i).getTenantId(), data.get(i).getAccount());
               boolean isExist=Func.isNotEmpty(oldUser);//用存在则为true
               //将实体类转换成map
               Map<String,Object>map= new HashMap<String,Object>();
               map=JSONObject.parseObject(JSONObject.toJSONString(data.get(i)),Map.class);
               //将map中的数据转换成员工基本信息表数据
               //EmployeeBasicInformation basicInfo= new EmployeeBasicInformation();
               EmployeeBasicInformation basicInfo=JSONObject.parseObject(JSONObject.toJSONString(map),EmployeeBasicInformation.class);
               //创建人名称
               basicInfo.setCreatorName(SecureUtil.getUserName());
               //创建人编号
               basicInfo.setCreatorCode(String.valueOf(AuthUtil.getUserId()));
               //创建部门名称
               basicInfo.setCreatorDeptName(deptUserEmployeeUtil.getDeptById(Long.valueOf(AuthUtil.getDeptId())).getDeptName());
               basicInfo.setTenantId(AuthUtil.getTenantId());
               //用户存在不覆盖
               if(isExist&&!isCovered){
                     continue;
               }
               if(isExist&&isCovered){//用户存在覆盖
                   basicInfo.setId(oldUser.getId());//根据已存在的用户id修改员工基本信息
                   saveOrUpdate(basicInfo);//修改
               }else if(!isExist){//用户不存在
                   saveOrUpdate(basicInfo);//保存用户信息
               }
               //将用户信息组装成用户信息的数据
               //User user=new User();
               User user=JSONObject.parseObject(JSONObject.toJSONString(map),User.class);
               user.setId(basicInfo.getId());
               //角色id 普通员工
               user.setRoleId(deptUserEmployeeUtil.getRoleId(AuthUtil.getTenantId(),"普通员工"));
               //职位id position
               user.setPostId(deptUserEmployeeUtil.getPostId(basicInfo.getPosition(),AuthUtil.getTenantId()));
               //入职部门id
               user.setDeptId(deptUserEmployeeUtil.getDeptId(AuthUtil.getTenantId(),basicInfo.getDepartment()));
               //租户id
               user.setTenantId(AuthUtil.getTenantId());
               //密码
               user.setPassword(EmployeeConstant.default_password);
               //创建人
               user.setCreateUser(basicInfo.getCreateUser());
               //创建部门
               user.setCreateDept(basicInfo.getCreateDept());
               //创建时间
               user.setCreateTime(basicInfo.getCreateTime());
               //状态值
               user.setStatus(basicInfo.getStatus());
               //是否删除
               user.setIsDeleted(basicInfo.getIsDeleted());
               if(isExist&&isCovered){//用户存在覆盖
                   userClient.updateUser(user);
               }else if(!isExist){//用户不存在
                   userClient.saveUser(user);//修改用户信息
               }
           }

       }

    }

//分解步骤实现

/**
     * 员工基本信息导入
     * @param data
     * @param isCovered
     */
    @Transactional(rollbackFor = Exception.class)
    @Override
    public void importUser(List<ExcelEmployeeBasicInformation> data, Boolean isCovered) {
       log.info("员工基本信息导入data======="+data);
       if(Func.isNotEmpty(data)){
           //list的实体类转换成list map
           List<Map<String,Object>>list=new ArrayList<Map<String,Object>>();
           for(ExcelEmployeeBasicInformation excelInfo:data){
               Map<String,Object>map=new HashMap<String,Object>();
               map=JSONObject.parseObject(JSONObject.toJSONString(excelInfo),Map.class);
               list.add(map);
           }
           //将数据组装成员工基本信息表所需要的数据
           List<EmployeeBasicInformation> basicList=new ArrayList<EmployeeBasicInformation>();
           for(Map<String,Object>map1:list){
               EmployeeBasicInformation basicInfo=new EmployeeBasicInformation();
               basicInfo=JSONObject.parseObject(JSONObject.toJSONString(map1),EmployeeBasicInformation.class);
               //创建人名称
               basicInfo.setCreatorName(SecureUtil.getUserName());
               //创建人编号
               basicInfo.setCreatorCode(String.valueOf(AuthUtil.getUserId()));
               //创建部门名称
               basicInfo.setCreatorDeptName(deptUserEmployeeUtil.getDeptById(Long.valueOf(AuthUtil.getDeptId())).getDeptName());
               basicInfo.setTenantId(AuthUtil.getTenantId());
               saveOrUpdate(basicInfo);
               basicList.add(basicInfo);
           }
           log.info("将数据组装成员工基本信息表所需要的数据basicList====="+basicList);
           //将数据组装成用户所需要的数据进入用户表
           List<User>userList=new ArrayList<User>();
           for(Map<String,Object>map2:list){
                   User user=new User();
                user=JSONObject.parseObject(JSONObject.toJSONString(map2),User.class);

                userList.add(user);
           }
           //将用户信息需要的数据放入用户信息表
           for(int i=0;i<basicList.size();i++){
               userList.get(i).setId(basicList.get(i).getId());
               //角色id 普通员工
               userList.get(i).setRoleId(deptUserEmployeeUtil.getRoleId(AuthUtil.getTenantId(),"普通员工"));
               //职位id position
               userList.get(i).setPostId(deptUserEmployeeUtil.getPostId(basicList.get(i).getPosition(),AuthUtil.getTenantId()));
               //入职部门id
               userList.get(i).setDeptId(deptUserEmployeeUtil.getDeptId(AuthUtil.getTenantId(),basicList.get(i).getDepartment()));
               //租户id
               userList.get(i).setTenantId(AuthUtil.getTenantId());
               //密码
               userList.get(i).setPassword(EmployeeConstant.default_password);
               //创建人
               userList.get(i).setCreateUser(basicList.get(i).getCreateUser());
               //创建部门
               userList.get(i).setCreateDept(basicList.get(i).getCreateDept());
               //创建时间
               userList.get(i).setCreateTime(basicList.get(i).getCreateTime());
               //状态值
               userList.get(i).setStatus(basicList.get(i).getStatus());
               //是否删除
               userList.get(i).setIsDeleted(basicList.get(i).getIsDeleted());
               userClient.saveUser(userList.get(i));

           }
           log.info("将数据组装成用户所需要的数据进入用户表userList====="+userList);
       }

    }

 

上一篇:list对象转json


下一篇:delphi 10.4 JSON 建立数组示例