| | |
| | | Long userid = tokenService.getLoginUserApplet().getUserid(); |
| | | AppUser appUserById = appUserClient.getAppUserById(userid); |
| | | LocalDateTime now = LocalDateTime.now(); |
| | | |
| | | |
| | | //查出全部可领取的优惠劵 |
| | | List<CouponInfo> list = couponInfoService.lambdaQuery() |
| | | .le(CouponInfo::getSendStartTime, now) |
| | | .ge(CouponInfo::getSendEndTime, now) |
| | | .eq(CouponInfo::getPersonType, 1) |
| | | .eq(CouponInfo::getDelFlag, 0) |
| | | .eq(CouponInfo::getShelfStatus, 1) |
| | | .list(); |
| | | //查出指定人员可领取优惠券 |
| | | List<CouponInfo> list1 = couponInfoService.lambdaQuery() |
| | | .le(CouponInfo::getSendStartTime, now) |
| | | .ge(CouponInfo::getSendEndTime, now) |
| | | .eq(CouponInfo::getPersonType, 2) |
| | | .eq(CouponInfo::getDelFlag, 0) |
| | | .eq(CouponInfo::getShelfStatus, 1) |
| | | .apply("FIND_IN_SET('" + appUserById.getId() + "', person_ids)") |
| | | .list(); |
| | | //查出指定会员可领取优惠劵 |
| | |
| | | .le(CouponInfo::getSendStartTime, now) |
| | | .ge(CouponInfo::getSendEndTime, now) |
| | | .eq(CouponInfo::getPersonType, 3) |
| | | .eq(CouponInfo::getDelFlag, 0) |
| | | .eq(CouponInfo::getShelfStatus, 1) |
| | | .apply("FIND_IN_SET('" + appUserById.getVipId() + "', vip_ids)").list(); |
| | | List<CouponInfo> returnList = new ArrayList<>(); |
| | | returnList.addAll(list); |