| | |
| | | private List<Member> getMemberListByParam(MemberCouponAddDTO memberCoupon) { |
| | | List<Member> list = memberMapper.selectList(new QueryWrapper<Member>().lambda() |
| | | .eq(Member::getIsdeleted,Constants.ZERO) |
| | | .eq(Member::getStatus,Constants.ZERO) |
| | | .eq(memberCoupon.getAddType() == Constants.ZERO,Member::getId,memberCoupon.getAddMemberIds()) |
| | | .in(memberCoupon.getAddType() == Constants.ONE,Member::getPhone,memberCoupon.getPhones())); |
| | | if(list == null || list.size()==0){ |
| | |
| | | .apply(Objects.nonNull(status)&&Constants.equalsInteger(status,Constants.TWO),"m.STATUS = 0 and m.END_DATE < now() " ) |
| | | .eq("TYPE",couponType) |
| | | .apply(!Objects.isNull(price)," m.LIMIT_PRICE >= "+price+" ") |
| | | // .apply(" now() between m.START_DATE and m.END_DATE ") |
| | | .orderByDesc(" m.PRICE ") |
| | | .orderByDesc( " m.CREATE_DATE ") |
| | | ); |
| | | return page; |
| | | } |
| | |
| | | .apply(" now() between START_DATE and END_DATE ") |
| | | .orderByDesc(MemberCoupon::getMaxPrice) |
| | | .orderByAsc(MemberCoupon::getEndDate) |
| | | ) |
| | | ; |
| | | ); |
| | | |
| | | if(CollectionUtils.isNotEmpty(allCoupon)){ |
| | | for (MemberCoupon memberCoupon:allCoupon) { |