| | |
| | | @Override |
| | | public Integer getTargetedServiceWeight(Long appUserId, String cityCode) { |
| | | List<XpWhitelist> one = xpWhitelistService.list(new QueryWrapper<XpWhitelist>().eq("app_user_id", appUserId).eq("status", 1) |
| | | .eq("is_deleted", 0).last(" and expire_time >= DATE(NOW()) or expire_time is null")); |
| | | .eq("is_deleted", 0).last(" and (expire_time >= DATE(NOW()) or expire_time is null)")); |
| | | if(!one.isEmpty()){ |
| | | List<Long> collect = one.stream().map(XpWhitelist::getId).collect(Collectors.toList()); |
| | | List<XpTargetedServiceWhitelist> xpTargetedServiceWhitelists = xpTargetedServiceWhitelistService.list(new QueryWrapper<XpTargetedServiceWhitelist>().in("whitelist_id", collect)); |