| | |
| | | } |
| | | if(delIds.size()>0){ |
| | | //删除所有需要删除的组织信息(逻辑删除) |
| | | companyMapper.update(null,new UpdateWrapper<Company>().lambda().set(Company::getIsdeleted, Constants.ONE).in(Company::getId,delIds)); |
| | | companyMapper.update(null,new UpdateWrapper<Company>().lambda() |
| | | .set(Company::getIsdeleted, Constants.ONE) |
| | | .set(Company::getHkStatus, Constants.ZERO) |
| | | .in(Company::getId,delIds)); |
| | | } |
| | | return "同步数据:新增【"+addList.size()+"】条,更新【"+updateList.size()+"】条,删除【"+delIds.size()+"】条"; |
| | | }else{ |
| | |
| | | company.setCode(respone.getCode()); |
| | | company.setErpParentId(respone.getParentOrgId()); |
| | | company.setErpDate(date); |
| | | //海康数据 |
| | | company.setHkId(HKConstants.RES_INDEX+UUID.randomUUID().toString()); |
| | | company.setHkStatus(Constants.ZERO); |
| | | return company; |
| | | } |
| | | |
| | |
| | | return null; |
| | | } |
| | | |
| | | |
| | | |
| | | |
| | | /** |
| | | * 同步ERP人员信息 |
| | | * @param param |
| | | * @return |
| | | */ |
| | | @Override |
| | | public String syncUsers(UserListRequest param){ |
| | | //TODO----------------RK------------------ |
| | | List<UserListRespone> allList = ErpTool.getErpUserList(ErpConstants.userListUrl,param); |
| | | public String syncUsers(UserListRequest param){ |
| | | List<UserListRespone> list = ErpTool.getErpUserList(ErpConstants.userListUrl,param); |
| | | if(list !=null && list.size()>0) { |
| | | List<Member> addList = new ArrayList<>(); |
| | | List<Member> updateList = new ArrayList<>(); |
| | | List<Integer> delIds = new ArrayList<>(); |
| | | List<Member> allList = memberMapper.selectList(new QueryWrapper<Member>().lambda() |
| | | .eq(Member::getIsdeleted,Constants.ZERO) |
| | | .eq(Member::getType, Constants.memberType.internal)); |
| | | dealUserChangeList(list,addList,updateList,delIds,allList); |
| | | |
| | | if(addList.size()>0){ |
| | | memberMapper.insertBatchSomeColumn(addList); |
| | | } |
| | | if(updateList.size()>0){ |
| | | for(Member c : updateList){ |
| | | memberMapper.updateById(c); |
| | | } |
| | | } |
| | | if(delIds.size()>0){ |
| | | //删除所有需要删除的组织信息(逻辑删除) |
| | | memberMapper.update(null,new UpdateWrapper<Member>().lambda().set(Member::getHkStatus,Constants.ZERO) |
| | | .set(Member::getIsdeleted, Constants.ONE).in(Member::getId,delIds)); |
| | | } |
| | | |
| | | }else{ |
| | | throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(), "同步ERP数据为空!"); |
| | | } |
| | | return null; |
| | | } |
| | | |
| | | private void dealUserChangeList(List<UserListRespone> list, List<Member> addList, List<Member> updateList, List<Integer> delIds, List<Member> allList) { |
| | | Date date = new Date(); |
| | | for(UserListRespone response : list){ |
| | | //根据 erpId 查询用户信息,判断是新增还是更新 |
| | | Member member = findUserByERPId(allList,response.getId()); |
| | | if(member == null){ |
| | | //如果是新增 |
| | | if(Constants.formatIntegerNum(response.getIsdeleted()) == Constants.ONE){ |
| | | continue; |
| | | } |
| | | //封装新增组织对象数据 |
| | | addList.add(getAddMemberModel(response,date)); |
| | | }else{ |
| | | //如果是更新 |
| | | if(Constants.formatIntegerNum(response.getIsdeleted()) == Constants.ONE){ |
| | | //如果已删除,加入删除集合中 |
| | | delIds.add(member.getId()); |
| | | continue; |
| | | } |
| | | updateList.add(addUpdateMemberModel(response,member,date)); |
| | | } |
| | | } |
| | | if(allList!=null && allList.size()>0){ |
| | | for(Member c : allList){ |
| | | if(isUserDeleted(c,list)){ |
| | | delIds.add(c.getId()); |
| | | } |
| | | } |
| | | } |
| | | } |
| | | |
| | | private Member getAddMemberModel(UserListRespone param, Date date) { |
| | | Member member = new Member(); |
| | | BeanUtils.copyProperties(param,member); |
| | | member.setCreateDate(new Date()); |
| | | member.setHkStatus(Constants.ZERO); |
| | | member.setErpStatus(Constants.ONE); |
| | | member.setErpDate(new Date()); |
| | | member.setErpId(param.getId()); |
| | | member.setFsStatus(Constants.ZERO); |
| | | member.setType(Constants.memberType.internal); |
| | | String encryptIdNo = DESUtil.encrypt(Constants.EDS_PWD,param.getIdNo()); |
| | | member.setIdcardNo(encryptIdNo); |
| | | member.setIdcardDecode(Constants.getTuominStr(param.getIdNo())); |
| | | member.setCompanyId(param.getOrgId()); |
| | | member.setHkStatus(Constants.ZERO); |
| | | return member; |
| | | } |
| | | |
| | | private Member addUpdateMemberModel(UserListRespone param,Member member,Date date) { |
| | | BeanUtils.copyProperties(param,member); |
| | | String encryptIdNo = DESUtil.encrypt(Constants.EDS_PWD,param.getIdNo()); |
| | | member.setIdcardNo(encryptIdNo); |
| | | member.setIdcardDecode(Constants.getTuominStr(param.getIdNo())); |
| | | member.setCompanyId(param.getOrgId()); |
| | | member.setEditDate(new Date()); |
| | | member.setErpDate(new Date()); |
| | | member.setHkStatus(Constants.ZERO); |
| | | return member; |
| | | } |
| | | |
| | | private boolean isUserDeleted(Member c, List<UserListRespone> list) { |
| | | for(UserListRespone m : list){ |
| | | if(StringUtils.equals(c.getErpId(),m.getId().toString())){ |
| | | return true; |
| | | } |
| | | } |
| | | return false; |
| | | } |
| | | |
| | | private Member findUserByERPId(List<Member> allList, String id) { |
| | | if(allList!=null){ |
| | | for(Member com :allList){ |
| | | if(StringUtils.equals(com.getErpId(),id)){ |
| | | return com; |
| | | } |
| | | } |
| | | } |
| | | return null; |
| | | } |
| | | |
| | | |
| | | |
| | | /** |
| | |
| | | Company company = companyMapper.selectOne(new QueryWrapper<Company>().lambda().eq(Company::getErpId,param.getId()).last("limit 1")); |
| | | if(Objects.isNull(company)){ |
| | | company = new Company(); |
| | | BeanUtils.copyProperties(param,company); |
| | | // BeanUtils.copyProperties(param,company); |
| | | company.setId(null); |
| | | company.setCreateDate(new Date()); |
| | | company.setHkStatus(Constants.ZERO); |
| | | company.setErpStatus(Constants.ONE); |
| | | company.setErpDate(new Date()); |
| | | company.setErpId(param.getId()); |
| | | company.setErpParentId(param.getParentId()); |
| | | company.setFsStatus(Constants.ZERO); |
| | | company.setType(Constants.ONE); |
| | | company.setLinkName(param.getLinkName()); |
| | | company.setLinkPhone(param.getLinkPhone()); |
| | | companyMapper.insert(company); |
| | | //TODO 海康数据创建 |
| | | }else{ |
| | | BeanUtils.copyProperties(param,company); |
| | | // BeanUtils.copyProperties(param,company); |
| | | company.setEditDate(new Date()); |
| | | company.setErpId(param.getId()); |
| | | company.setHkStatus(Constants.ZERO); |
| | | company.setErpDate(new Date()); |
| | | company.setErpParentId(param.getParentId()); |
| | | company.setLinkName(param.getLinkName()); |
| | | company.setLinkPhone(param.getLinkPhone()); |
| | | companyMapper.updateById(company); |
| | | //TODO 海康数据更新 |
| | | } |
| | |
| | | member.setIdcardDecode(Constants.getTuominStr(param.getIdNo())); |
| | | member.setCompanyId(param.getOrgId()); |
| | | memberMapper.insert(member); |
| | | |
| | | //TODO 海康数据创建 |
| | | }else{ |
| | | BeanUtils.copyProperties(param,member); |
| | |
| | | visitsList.forEach(i->{ |
| | | i.setStatus(param.getStatus().equals(Constants.ZERO)?Constants.VisitStatus.pass:Constants.VisitStatus.noPass); |
| | | i.setEndCheckDate(DateUtil.StringToDate(param.getApproveDate(),"yyyy-MM-dd HH:mm:ss")); |
| | | i.setHkStatus(Constants.ZERO); |
| | | visitsMapper.updateById(i); |
| | | }); |
| | | } |