查询优化(查多次改为只查一次)

it2025-12-02  4

private List<IotUserVO> converToIotUserVO(List<IotUser> iotUserList,BizInfo bizInfo){ if(CollectionUtils.isEmpty(iotUserList)){ return Collections.emptyList(); } //批量获取siteInfo,只查一次 Map<String, SiteInfo> siteInfoMap; List<String> siteIdList = iotUserList.stream().map(IotUser::getUserSiteId).distinct().collect(Collectors.toList()); if(CollectionUtils.isNotEmpty(siteIdList)){ List<SiteInfo> siteInfoList = coaSiteInfoService.selectSiteInfoBySiteIdList(siteIdList); siteInfoMap = siteInfoList.stream().collect(Collectors.toMap(SiteInfo::getSiteId, item -> item)); }else{ siteInfoMap = Collections.emptyMap(); } return iotUserList.stream().map(user -> { IotUserVO vo = new IotUserVO(); BeanUtils.copyProperties(user,vo); vo.setUserBizName(bizInfo.getBizName()); vo.setUserBizLevel(bizInfo.getBizLevel()); vo.setUserSiteName(StringUtils.isNotEmpty(user.getUserSiteId())?siteInfoMap.get(user.getUserSiteId()).getSiteName():StringUtils.EMPTY); EmpUser empUser = this.getInvitationCodeName(user.getIotUserDetail().getInvitationCode()); vo.setInvitationCodeName(empUser!=null?empUser.getEmpName():StringUtils.EMPTY); vo.setInvitationEmpNo(empUser!=null?empUser.getEmpNo():StringUtils.EMPTY); return vo; }).collect(Collectors.toList()); }

 

最新回复(0)