From ae1471f378f399f76518539ec8992e64a3673436 Mon Sep 17 00:00:00 2001
From: 陶杰 <1378534974@qq.com>
Date: 星期三, 08 一月 2025 15:26:06 +0800
Subject: [PATCH] 1.订单提交:订单最小金额配置

---
 src/main/java/com/mzl/flower/service/impl/coupon/CouponRecordServiceImpl.java |  490 +++++++++++++++++++++++++++++++++++++++++++++---------
 1 files changed, 405 insertions(+), 85 deletions(-)

diff --git a/src/main/java/com/mzl/flower/service/impl/coupon/CouponRecordServiceImpl.java b/src/main/java/com/mzl/flower/service/impl/coupon/CouponRecordServiceImpl.java
index 3724c94..398f1b3 100644
--- a/src/main/java/com/mzl/flower/service/impl/coupon/CouponRecordServiceImpl.java
+++ b/src/main/java/com/mzl/flower/service/impl/coupon/CouponRecordServiceImpl.java
@@ -1,38 +1,42 @@
 package com.mzl.flower.service.impl.coupon;
 
 import cn.hutool.core.util.IdUtil;
+import com.alibaba.fastjson.JSON;
 import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
 import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
 import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
 import com.mzl.flower.config.exception.ValidationException;
 import com.mzl.flower.config.security.SecurityUtils;
-import com.mzl.flower.dto.request.coupon.CreateCouponRecordDTO;
-import com.mzl.flower.dto.request.coupon.QueryCouponRecordDTO;
-import com.mzl.flower.dto.request.coupon.QueryCouponStatisticsBO;
-import com.mzl.flower.dto.request.coupon.QueryExistCouponDTO;
+import com.mzl.flower.dto.request.coupon.*;
 import com.mzl.flower.dto.response.coupon.CouponRecordVO;
 import com.mzl.flower.entity.coupon.CouponRecordDO;
 import com.mzl.flower.entity.coupon.CouponTemplateDO;
 import com.mzl.flower.entity.customer.Customer;
-import com.mzl.flower.entity.system.User;
 import com.mzl.flower.enums.*;
 import com.mzl.flower.mapper.coupon.CouponRecordMapper;
 import com.mzl.flower.mapper.coupon.CouponRecordMapperCustom;
 import com.mzl.flower.mapper.customer.CustomerMapper;
 import com.mzl.flower.service.coupon.CouponRecordService;
 import com.mzl.flower.service.coupon.CouponTemplateService2;
+import com.mzl.flower.service.customer.CustomerService;
 import com.mzl.flower.service.system.UserService;
 import lombok.extern.slf4j.Slf4j;
 import org.apache.commons.collections4.CollectionUtils;
 import org.apache.commons.lang3.StringUtils;
+import org.redisson.api.RLock;
+import org.redisson.api.RedissonClient;
 import org.springframework.beans.BeanUtils;
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.stereotype.Service;
 import org.springframework.transaction.annotation.Transactional;
 
+import java.math.BigDecimal;
 import java.time.LocalDateTime;
 import java.time.temporal.TemporalAdjusters;
+import java.util.Comparator;
 import java.util.List;
+import java.util.Objects;
+import java.util.concurrent.TimeUnit;
 import java.util.stream.Collectors;
 
 /**
@@ -59,97 +63,163 @@
     @Autowired
     private CustomerMapper customerMapper;
 
+    @Autowired
+    private CustomerService customerService;
+
+
     @Override
     public List<CouponRecordVO> getList(QueryCouponRecordDTO dto) {
         return couponRecordMapperCustom.getList(dto);
     }
 
+    @Autowired
+    RedissonClient redissonClient;
+
+    private static final String COUPON_KEY="com:mzl:flower:service:impl:coupon:%s";
+
+    @Transactional
     @Override
     public boolean createCouponRecord(CreateCouponRecordDTO dto) {
+
+        final CouponTemplateDO couponTemplateDO = couponTemplateService.getById(dto.getCouponId());
+        if(couponTemplateDO==null){
+            throw new ValidationException("优惠券不存在");
+        }
 
         final Customer customer = customerMapper.selectById(dto.getCustomerId());
         if(null==customer){
             throw new ValidationException("商户信息不存在");
         }
 
-        final CouponTemplateDO couponTemplateDO = couponTemplateService.getById(dto.getCouponId());
-
-        // TODO  活动优惠券和积分优惠券需要根据库存来控制- 根据优惠券的发放数量来控制有没有超发
-
-
-        // TODO 根据用户领取设置的getLimit 查看当前用户是否已经超领优惠券
-
-
-        CouponRecordDO couponRecordDO=new CouponRecordDO();
-        BeanUtils.copyProperties(dto,couponRecordDO);
-        couponRecordDO.create(SecurityUtils.getUserId());
-        // 设置为待使用状态
-        couponRecordDO.setStatus(CouponUsedStatusEnum.UNUSED.getType());
-
-        // 根据商户设置用户id
-        if(StringUtils.isBlank(dto.getUserId()) && StringUtils.isNotBlank(customer.getUserId())){
-            couponRecordDO.setUserId(customer.getUserId());
-        }
-
-        // 优惠券字段冗余
-
-        if(null!=couponTemplateDO){
-            couponRecordDO.setCategory(couponTemplateDO.getGetUserType());
-            couponRecordDO.setCouponCode(couponTemplateDO.getCouponCode());
-            couponRecordDO.setCouponName(couponTemplateDO.getCouponName());
-            couponRecordDO.setCouponDiscountValue(couponTemplateDO.getCouponDiscountValue());
-            couponRecordDO.setMinOrderAmount(couponTemplateDO.getMinOrderAmount());
-            couponRecordDO.setGetType(couponTemplateDO.getGetType());
-            couponRecordDO.setCouponDiscountType(couponTemplateDO.getCouponDiscountType());
-            couponRecordDO.setGetUserType(couponTemplateDO.getGetUserType());
-            couponRecordDO.setPoint(couponTemplateDO.getPoint());
-
-
-            // 根据优惠券模板来计算优惠券的生效开始时间和结束时间
-            if(StringUtils.isNotBlank(couponTemplateDO.getCategory()) && couponTemplateDO.getCategory().equals(CouponCategoryEnum.MEMBER.getStatus())){
-                // 如果是会员优惠券的话,则设置为优惠券的使用条件为优惠券的时间
-                couponRecordDO.setEffectiveStart(couponTemplateDO.getUsageStartDate());
-                couponRecordDO.setEffectiveEnd(couponTemplateDO.getUsageEndDate());
-            }else{
-                // 非会员的根据领取时间类型来计算优惠券的时间
-                if(StringUtils.isNotBlank(couponTemplateDO.getUsageType()) && couponTemplateDO.getUsageType().equals(CouponUsageTypeEnum.GET.getType())){
-                    // 与领取时间一致
-                    couponRecordDO.setEffectiveStart(couponTemplateDO.getGetStartDate());
-                    couponRecordDO.setEffectiveEnd(couponTemplateDO.getGetEndDate());
-                }
-                if(StringUtils.isNotBlank(couponTemplateDO.getUsageType()) && couponTemplateDO.getUsageType().equals(CouponUsageTypeEnum.FIXED.getType())){
-                    // 固定时间
-                    couponRecordDO.setEffectiveStart(couponTemplateDO.getUsageStartDate());
-                    couponRecordDO.setEffectiveEnd(couponTemplateDO.getUsageEndDate());
-                }
-                if(StringUtils.isNotBlank(couponTemplateDO.getUsageType()) && couponTemplateDO.getUsageType().equals(CouponUsageTypeEnum.GET_AFTER_TIME.getType())){
-                    // 领取后有段时间 领取后有效时间
-                    // 根据发放后有效期来设置时间
-                    if (couponTemplateDO.getUsageTimeNum() == null || couponTemplateDO.getUsageTimeNum() <= 0) {
-                        throw new IllegalArgumentException("使用时间数量必须为正整数");
+        RLock lock = redissonClient.getLock(String.format(COUPON_KEY, couponTemplateDO.getId()));
+        try {
+            // 获取锁,最多等待 10 秒,锁自动释放时间 30 秒
+            if (lock.tryLock(10, 30, TimeUnit.SECONDS)) {
+                try {
+                    // 活动优惠券 根据优惠券的发放数量来控制有没有超发
+                    if(StringUtils.isNotBlank(couponTemplateDO.getCategory()) &&
+                            couponTemplateDO.getCategory().equals(CouponCategoryEnum.ACTIVITY.getStatus())
+                    ){
+                        // 获取当前优惠券已经领取的数量
+                        final Integer gainTotal = getExistGainCouponRecordAmountById(couponTemplateDO.getId());
+                        if(couponTemplateDO.getCouponAmount().compareTo(gainTotal)<=0){
+                            throw new ValidationException("当前优惠券已经领完!");
+                        }
                     }
-                    LocalDateTime currentTime = LocalDateTime.now();
-                    couponRecordDO.setEffectiveStart(currentTime);
-                    if (couponTemplateDO.getUsageTimeType().equals(CouponUsageTimeTypeEnum.DAY.getType())) {
-                        // 天
-                        couponRecordDO.setEffectiveEnd(currentTime.plusDays(couponTemplateDO.getUsageTimeNum()));
-                    }
-                    if (couponTemplateDO.getUsageTimeType().equals(CouponUsageTimeTypeEnum.HOUR.getType())) {
-                        // 小时
-                        couponRecordDO.setEffectiveEnd(currentTime.plusHours(couponTemplateDO.getUsageTimeNum()));
-                    }
-                    if (couponTemplateDO.getUsageTimeType().equals(CouponUsageTimeTypeEnum.MINUTE.getType())) {
-                        // 分钟
-                        couponRecordDO.setEffectiveEnd(currentTime.plusMinutes(couponTemplateDO.getUsageTimeNum()));
+                    if(StringUtils.isNotBlank(couponTemplateDO.getCategory())
+                            && couponTemplateDO.getCategory().equals(CouponCategoryEnum.POINT.getStatus()
+                    )){
+                        // 获取当前优惠券已经领取的数量
+
+                        if(couponTemplateDO.getCouponAmount()<=0){
+                            throw new ValidationException("当前优惠券已经领完!");
+                        }else{
+                            couponTemplateDO.setCouponAmount(couponTemplateDO.getCouponAmount()-1);
+                            // 更新库存
+                            couponTemplateService.updateById(couponTemplateDO);
+                        }
+
                     }
 
+                    // 根据用户领取设置的getLimit 查看当前用户是否已经超领优惠券
+                    if(StringUtils.isNotBlank(couponTemplateDO.getCategory()) && couponTemplateDO.getCategory().equals(CouponCategoryEnum.ACTIVITY.getStatus()) ){
+                        // 查看当前优惠券的领取时间在不在设置的领取时间范围类
+                        LocalDateTime now = LocalDateTime.now();
+                        // 判断当前时间是否在领取时间范围内
+                        if (!(now.isAfter(couponTemplateDO.getGetStartDate()) && now.isBefore(couponTemplateDO.getGetEndDate()))) {
+                            throw new ValidationException("当前时间不在优惠券的领取时间范围内,无法操作!");
+                        }
+
+                        // 获取当前优惠券已经领取的数量
+                        final Integer customGainTotal = getUserGainCouponRecordAmountById(couponTemplateDO.getId(),customer.getId());
+                        if(couponTemplateDO.getGetLimit().compareTo(customGainTotal)<=0){
+                            throw new ValidationException("超出个人领取限制,每人限领"+couponTemplateDO.getGetLimit()+"张!");
+                        }
+                    }
+
+
+                    CouponRecordDO couponRecordDO=new CouponRecordDO();
+                    BeanUtils.copyProperties(dto,couponRecordDO);
+                    couponRecordDO.create(SecurityUtils.getUserId());
+                    // 设置为待使用状态
+                    couponRecordDO.setStatus(CouponUsedStatusEnum.UNUSED.getType());
+
+                    // 根据商户设置用户id
+                    if(StringUtils.isBlank(dto.getUserId()) && StringUtils.isNotBlank(customer.getUserId())){
+                        couponRecordDO.setUserId(customer.getUserId());
+                    }
+
+                    // 优惠券字段冗余
+                    couponRecordDO.setCategory(couponTemplateDO.getCategory());
+                    couponRecordDO.setCouponCode(couponTemplateDO.getCouponCode());
+                    couponRecordDO.setCouponName(couponTemplateDO.getCouponName());
+                    couponRecordDO.setCouponDiscountValue(couponTemplateDO.getCouponDiscountValue());
+                    couponRecordDO.setMinOrderAmount(couponTemplateDO.getMinOrderAmount());
+                    couponRecordDO.setGetType(couponTemplateDO.getGetType());
+                    couponRecordDO.setCouponDiscountType(couponTemplateDO.getCouponDiscountType());
+                    couponRecordDO.setGetUserType(couponTemplateDO.getGetUserType());
+                    couponRecordDO.setPoint(couponTemplateDO.getPoint());
+                    couponRecordDO.setMemberId(couponTemplateDO.getMemberId());
+                    couponRecordDO.setImageUrl(couponTemplateDO.getImageUrl());
+                    couponRecordDO.setCouponDescription(couponTemplateDO.getCouponDescription());
+
+
+                    // 根据优惠券模板来计算优惠券的生效开始时间和结束时间
+                    if(StringUtils.isNotBlank(couponTemplateDO.getCategory()) && couponTemplateDO.getCategory().equals(CouponCategoryEnum.MEMBER.getStatus())){
+                        // 如果是会员优惠券的话,则设置为优惠券的使用条件为优惠券的时间
+                        couponRecordDO.setEffectiveStart(couponTemplateDO.getUsageStartDate());
+                        couponRecordDO.setEffectiveEnd(couponTemplateDO.getUsageEndDate());
+                    }else{
+                        // 非会员的根据领取时间类型来计算优惠券的时间
+                        if(StringUtils.isNotBlank(couponTemplateDO.getUsageType()) && couponTemplateDO.getUsageType().equals(CouponUsageTypeEnum.GET.getType())){
+                            // 与领取时间一致
+                            couponRecordDO.setEffectiveStart(couponTemplateDO.getGetStartDate());
+                            couponRecordDO.setEffectiveEnd(couponTemplateDO.getGetEndDate());
+                        }
+                        if(StringUtils.isNotBlank(couponTemplateDO.getUsageType()) && couponTemplateDO.getUsageType().equals(CouponUsageTypeEnum.FIXED.getType())){
+                            // 固定时间
+                            couponRecordDO.setEffectiveStart(couponTemplateDO.getUsageStartDate());
+                            couponRecordDO.setEffectiveEnd(couponTemplateDO.getUsageEndDate());
+                        }
+                        if(StringUtils.isNotBlank(couponTemplateDO.getUsageType()) && couponTemplateDO.getUsageType().equals(CouponUsageTypeEnum.GET_AFTER_TIME.getType())){
+                            // 领取后有段时间 领取后有效时间
+                            // 根据发放后有效期来设置时间
+                            if (couponTemplateDO.getUsageTimeNum() == null || couponTemplateDO.getUsageTimeNum() <= 0) {
+                                throw new ValidationException("使用时间数量必须为正整数");
+                            }
+                            LocalDateTime currentTime = LocalDateTime.now();
+                            couponRecordDO.setEffectiveStart(currentTime);
+                            if (couponTemplateDO.getUsageTimeType().equals(CouponUsageTimeTypeEnum.DAY.getType())) {
+                                // 天
+                                couponRecordDO.setEffectiveEnd(currentTime.plusDays(couponTemplateDO.getUsageTimeNum()));
+                            }
+                            if (couponTemplateDO.getUsageTimeType().equals(CouponUsageTimeTypeEnum.HOUR.getType())) {
+                                // 小时
+                                couponRecordDO.setEffectiveEnd(currentTime.plusHours(couponTemplateDO.getUsageTimeNum()));
+                            }
+                            if (couponTemplateDO.getUsageTimeType().equals(CouponUsageTimeTypeEnum.MINUTE.getType())) {
+                                // 分钟
+                                couponRecordDO.setEffectiveEnd(currentTime.plusMinutes(couponTemplateDO.getUsageTimeNum()));
+                            }
+
+                        }
+                    }
+
+                    // 手动设置ID
+                    couponRecordDO.setId(IdUtil.simpleUUID());
+                    return baseMapper.insert(couponRecordDO)>0;
+
+                } finally {
+                    lock.unlock();
                 }
             }
-
+        } catch (InterruptedException e) {
+            Thread.currentThread().interrupt();
+            // 处理异常
         }
 
+        return false;
 
-        return baseMapper.insert(couponRecordDO)>0;
     }
 
     @Override
@@ -161,7 +231,7 @@
         // 优惠券字段冗余
         final CouponTemplateDO couponTemplateDO = couponTemplateService.getById(dto.getCouponId());
         if(null!=couponTemplateDO){
-            couponRecordDO.setCategory(couponTemplateDO.getGetUserType());
+            couponRecordDO.setCategory(couponTemplateDO.getCategory());
             couponRecordDO.setCouponCode(couponTemplateDO.getCouponCode());
             couponRecordDO.setCouponName(couponTemplateDO.getCouponName());
             couponRecordDO.setCouponDiscountValue(couponTemplateDO.getCouponDiscountValue());
@@ -199,6 +269,7 @@
     public boolean grantVipCouponRecordList() {
 
         try{
+
             LocalDateTime now = LocalDateTime.now();
             LocalDateTime firstDayStart = now.with(TemporalAdjusters.firstDayOfMonth()).withHour(0).withMinute(0).withSecond(0).withNano(0);
             LocalDateTime lastDayEnd = now.with(TemporalAdjusters.lastDayOfMonth()).withHour(23).withMinute(59).withSecond(59).withNano(0);
@@ -208,21 +279,32 @@
 
             // 遍历所有相同等级用户信息,并根据优惠券设置的规则构造优惠券
             final List<CouponTemplateDO> updateCouponTemplateList = vipTemplateList.stream().map(couponTemplateDO -> {
-                final List<User> vipGradeUserList = userService.getVipGradeUserList(couponTemplateDO.getVipGrade());
-                final List<CouponRecordDO> gradeCouponRecordList = vipGradeUserList.stream().map(user -> {
+                // 获取当前等级下的所有用户
+                final List<Customer> customerList = customerService.getCustomerListByLevelId(couponTemplateDO.getMemberId());
+
+                final List<CouponRecordDO> gradeCouponRecordList = customerList.stream().map(customer -> {
                     CouponRecordDO couponRecordDO = new CouponRecordDO();
                     BeanUtils.copyProperties(couponTemplateDO, couponRecordDO);
                     couponRecordDO.setId(IdUtil.simpleUUID());
                     couponRecordDO.setCouponId(couponTemplateDO.getId());
-                    couponRecordDO.setUserId(user.getId());
+                    couponRecordDO.setUserId(customer.getUserId());
+                    couponRecordDO.setCustomerId(customer.getId());
                     couponRecordDO.setStatus(CouponUsedStatusEnum.UNUSED.getType());
                     couponRecordDO.setEffectiveStart(firstDayStart);
                     couponRecordDO.setEffectiveEnd(lastDayEnd);
-
+                    couponRecordDO.setMemberId(couponTemplateDO.getMemberId());
+                    couponRecordDO.setImageUrl(couponTemplateDO.getImageUrl());
+                    couponRecordDO.setCouponDescription(couponTemplateDO.getCouponDescription());
                     // 创建信息
                     couponRecordDO.create();
-                    return couponRecordDO;
-                }).collect(Collectors.toList());
+                    if(!checkCurMonVipCouponExists(couponRecordDO.getCouponId(),couponRecordDO.getCustomerId(),firstDayStart,lastDayEnd)){
+                        return couponRecordDO;
+                    }else{
+                        return null;
+                    }
+
+                }).filter(Objects::nonNull)
+                        .collect(Collectors.toList());
 
                 // 批量保存等级下的优惠券信息
                 saveBatch(gradeCouponRecordList);
@@ -231,6 +313,9 @@
                 couponTemplateDO.setUsageEndDate(lastDayEnd);
                 couponTemplateDO.setGetStartDate(firstDayStart);
                 couponTemplateDO.setGetEndDate(lastDayEnd);
+
+                // 设置总数为当前会员的人数
+                couponTemplateDO.setCouponAmount(CollectionUtils.isNotEmpty(customerList)?customerList.size():0);
 
                 // 设置默认类型固定
                 couponTemplateDO.setUsageType(CouponUsageTypeEnum.FIXED.getType());
@@ -251,7 +336,7 @@
     }
 
     @Override
-    public boolean expiredCouponRecordByListCurMonth() {
+    public boolean expiredCouponRecordLastMon() {
 
         try{
             LocalDateTime now = LocalDateTime.now();
@@ -298,13 +383,248 @@
     }
 
     @Override
-    public int getExistCouponAmount(QueryExistCouponDTO dto) {
+    public Integer getExistCouponAmount(QueryExistCouponDTO dto) {
         QueryWrapper<CouponRecordDO> queryWrapper=new QueryWrapper<>();
         queryWrapper.lambda().eq(CouponRecordDO::getDeleted, TrueOrFalseEnum.FALSE.isFlag())
                 .eq(StringUtils.isNotBlank(dto.getCouponId()), CouponRecordDO::getCouponId,dto.getCouponId())
-                .eq(StringUtils.isNotBlank(dto.getCustomerId()),CouponRecordDO::getCustomerId,dto.getCustomerId())
+                .eq(null!=dto.getCustomerId(),CouponRecordDO::getCustomerId,dto.getCustomerId())
                 .eq(StringUtils.isNotBlank(dto.getCategory()),CouponRecordDO::getCategory,dto.getCategory());
 
         return baseMapper.selectCount(queryWrapper);
     }
+
+    @Override
+    public Integer getExistGainCouponRecordAmountById(String couponId) {
+        QueryWrapper<CouponRecordDO> queryWrapper=new QueryWrapper<>();
+        queryWrapper.lambda().eq(CouponRecordDO::getDeleted, TrueOrFalseEnum.FALSE.isFlag())
+                .eq(StringUtils.isNotBlank(couponId), CouponRecordDO::getCouponId,couponId)
+                ;
+        return baseMapper.selectCount(queryWrapper);
+    }
+
+    @Override
+    public Integer getUserGainCouponRecordAmountById(String couponId, Long customerId) {
+        QueryWrapper<CouponRecordDO> queryWrapper=new QueryWrapper<>();
+        queryWrapper.lambda().eq(CouponRecordDO::getDeleted, TrueOrFalseEnum.FALSE.isFlag())
+                .eq(StringUtils.isNotBlank(couponId), CouponRecordDO::getCouponId,couponId)
+                .eq(null!=customerId,CouponRecordDO::getCustomerId,customerId)
+                ;
+
+        return baseMapper.selectCount(queryWrapper);
+    }
+
+    @Override
+    public Integer getUserGainCouponRecordAmountByUserId(String couponId, String userId) {
+        QueryWrapper<CouponRecordDO> queryWrapper=new QueryWrapper<>();
+        queryWrapper.lambda().eq(CouponRecordDO::getDeleted, TrueOrFalseEnum.FALSE.isFlag())
+                .eq(StringUtils.isNotBlank(couponId), CouponRecordDO::getCouponId,couponId)
+                .eq(null!=userId,CouponRecordDO::getUserId,userId)
+        ;
+
+        return baseMapper.selectCount(queryWrapper);
+    }
+
+    @Override
+    public List<CouponRecordVO> getMineCouponRecordList(QueryMineCouponRecordDTO dto) {
+        checkCouponExpired(dto);
+        return couponRecordMapperCustom.getMineCouponRecordList(dto);
+    }
+
+    @Override
+    public void checkCouponExpired(QueryMineCouponRecordDTO dto) {
+        if(StringUtils.isBlank(dto.getUserId())){
+            dto.setUserId(SecurityUtils.getUserId());
+        }
+        // 将未使用的优惠券直接过期
+        couponRecordMapperCustom.checkCouponExpired(dto);
+    }
+
+    @Override
+    public boolean checkCurMonVipCouponExists(String couponId, Long customId, LocalDateTime startDateTime, LocalDateTime endDateTime) {
+
+        LocalDateTime now = LocalDateTime.now();
+        LocalDateTime firstDayStart = now.with(TemporalAdjusters.firstDayOfMonth()).withHour(0).withMinute(0).withSecond(0).withNano(0);
+        LocalDateTime lastDayEnd = now.with(TemporalAdjusters.lastDayOfMonth()).withHour(23).withMinute(59).withSecond(59).withNano(0);
+        if(null==startDateTime){
+            startDateTime=firstDayStart;
+        }
+        if(null==endDateTime){
+            endDateTime=lastDayEnd;
+        }
+
+        QueryWrapper<CouponRecordDO> queryWrapper=new QueryWrapper<>();
+        queryWrapper.lambda().eq(CouponRecordDO::getDeleted,TrueOrFalseEnum.FALSE.isFlag())
+                .eq(CouponRecordDO::getCouponId,couponId)
+                .eq(CouponRecordDO::getCustomerId,customId)
+                .eq(CouponRecordDO::getEffectiveStart,startDateTime)
+                .eq(CouponRecordDO::getEffectiveEnd,endDateTime);
+        return  baseMapper.selectCount(queryWrapper)>0;
+
+    }
+
+    @Transactional
+    @Override
+    public boolean useCoupon(String couponId, String orderId, BigDecimal orderMount) {
+        // 优惠券为空
+        if(StringUtils.isBlank(couponId)){
+            throw new ValidationException("无效的优惠券");
+        }
+        if(StringUtils.isBlank(orderId)){
+            throw new ValidationException("订单id不能为空");
+        }
+        if(orderMount.compareTo(BigDecimal.ZERO)<=0){
+            throw new ValidationException("订单金额不能小于0");
+        }
+
+        // 验证优惠券存在且有效
+        final CouponRecordDO couponRecordDO = baseMapper.selectById(couponId);
+        if(null==couponRecordDO || StringUtils.isNotBlank(couponRecordDO.getOrderId()) ){
+            throw new ValidationException("无效的优惠券");
+        }
+
+        if(couponRecordDO.getStatus().equals(CouponUsedStatusEnum.USED.getType())){
+            throw new ValidationException("优惠券已经被使用");
+        }
+        if(couponRecordDO.getStatus().equals(CouponUsedStatusEnum.EXPIRED.getType()) || LocalDateTime.now().isAfter(couponRecordDO.getEffectiveEnd())){
+            throw new ValidationException("优惠券已过期");
+        }
+
+        // 根据类型判断是无门槛还是满减,如果是无门槛
+        if(couponRecordDO.getCouponDiscountType().equals(CouponTypeEnum.ZERO.getType())){
+            // 无门槛,查看金额是否大于满减值
+            if(orderMount.compareTo(couponRecordDO.getCouponDiscountValue())<0){
+                throw new ValidationException(String.format("订单金额(%s)小于无门槛的金额(%s)", orderMount, couponRecordDO.getCouponDiscountValue()));
+            }
+        }
+
+        if(couponRecordDO.getCouponDiscountType().equals(CouponTypeEnum.DISCOUNT.getType())){
+            //满减,查看金额是否满足最小订单额
+            if(orderMount.compareTo(couponRecordDO.getMinOrderAmount())<0){
+                throw new ValidationException(String.format("订单金额(%s)小于最低折扣订单金额(%s)", orderMount, couponRecordDO.getMinOrderAmount()));
+            }
+
+            if(orderMount.compareTo(couponRecordDO.getCouponDiscountValue())<0){
+                throw new ValidationException(String.format("订单金额(%s)小于折扣的金额(%s)", orderMount, couponRecordDO.getCouponDiscountValue()));
+            }
+        }
+
+        // 查看当前的优惠券是否是当前人员的
+        if(!SecurityUtils.getUserId().equals(couponRecordDO.getUserId())){
+            throw new ValidationException("优惠券不属于当前人员");
+        }
+
+        // 优惠券使用操作
+        couponRecordDO.setStatus(CouponUsedStatusEnum.USED.getType());
+        couponRecordDO.setUsedTime(LocalDateTime.now());
+        couponRecordDO.setOrderId(orderId);
+
+        return baseMapper.updateById(couponRecordDO)>0;
+
+    }
+
+
+    @Transactional
+    @Override
+    public boolean cancelCouponUsage(String orderId) {
+        // 查询订单使用的优惠券
+        final CouponRecordDO couponRecordDO = getCouponByOrderId(orderId);
+        if(null==couponRecordDO){
+            return false;
+        }
+        log.info("优惠券退回之前:"+ JSON.toJSONString(couponRecordDO));
+        couponRecordDO.setStatus(CouponUsedStatusEnum.UNUSED.getType());
+        couponRecordDO.setUsedTime(null);
+        couponRecordDO.setOrderId(null);
+        log.info("优惠券退回之后:"+ JSON.toJSONString(couponRecordDO));
+        return baseMapper.updateById(couponRecordDO)>0;
+    }
+
+    @Override
+    public List<CouponRecordDO> getCouponListByOrderId(String orderId) {
+        QueryWrapper<CouponRecordDO> queryWrapper=new QueryWrapper<>();
+        queryWrapper.lambda().eq(CouponRecordDO::getDeleted,TrueOrFalseEnum.FALSE.isFlag())
+                .eq(CouponRecordDO::getOrderId,orderId);
+
+        return baseMapper.selectList(queryWrapper);
+    }
+
+    @Override
+    public CouponRecordDO getCouponByOrderId(String orderId) {
+        final List<CouponRecordDO> couponRecordDOList = getCouponListByOrderId(orderId);
+        if(CollectionUtils.isNotEmpty(couponRecordDOList)){
+            return couponRecordDOList.get(0);
+        }
+        return null;
+    }
+
+    @Override
+    public boolean checkUserCouponExists(String couponId, Long customId) {
+        QueryWrapper<CouponRecordDO> queryWrapper=new QueryWrapper<>();
+        queryWrapper.lambda().eq(CouponRecordDO::getDeleted,TrueOrFalseEnum.FALSE.isFlag())
+                .eq(CouponRecordDO::getCouponId,couponId)
+                .eq(CouponRecordDO::getCustomerId,customId)
+        ;
+        return baseMapper.selectCount(queryWrapper)>0;
+    }
+
+    @Override
+    public boolean expireCouponRecordAll() {
+
+        return couponRecordMapperCustom.expireCouponRecordAll();
+    }
+
+    @Override
+    public CouponRecordVO getUnusedFit(QueryMineCouponRecordDTO dto) {
+
+        /**
+         * ①.先查询出满足条件的优惠券(满减面值最大)
+         * ②.查询面值最大的优惠券(无门槛面值最大)
+         * ③查询过期时间早的优惠券④在满足③的条件下,优先使用无门槛优惠券
+         * ④基于以上规则如果还存在相同的优惠券,任意选择一张优惠券即可
+         */
+
+        CouponRecordVO bestCoupon=null;
+        // 查出我所有可用优惠券
+        final List<CouponRecordVO> mineCouponRecordList = getMineCouponRecordList(dto);
+
+        if(null!=dto.getOrderAmount() && CollectionUtils.isNotEmpty(mineCouponRecordList)){
+            // ①.先查询出满足条件的优惠券
+            // 遍历优惠券列表,找出所有minOrderAmount >= dto.orderAmount ,且couponDiscountValue 最大的优惠券
+            // 筛选符合条件并找出优惠面值最大的优惠券
+            bestCoupon = mineCouponRecordList.stream()
+                    // 筛选出 minOrderAmount >= dto.orderAmount 的优惠券并且优惠券类型是discount的
+                    .filter(coupon -> coupon.getCouponDiscountType().equals(CouponTypeEnum.DISCOUNT.getType()))
+                    .filter(coupon -> coupon.getMinOrderAmount().compareTo(dto.getOrderAmount()) <= 0)
+                    // 按 couponDiscountValue 倒序排序
+                    .max(Comparator.comparing(CouponRecordVO::getCouponDiscountValue))
+                    // 如果没有符合条件的优惠券,使用 Optional.orElse(null) 返回 null
+                    .orElse(null);
+
+            if(null==bestCoupon){
+            // ②.查询面值最大的优惠券(无门槛面值最大)
+//               过滤出discountType 是zero的优惠券,并根据couponDiscountValue倒序排序
+                bestCoupon = mineCouponRecordList.stream()
+                        .filter(coupon -> coupon.getCouponDiscountType().equals(CouponTypeEnum.ZERO.getType()))
+                        .max(Comparator.comparing(CouponRecordVO::getCouponDiscountValue))
+                        .orElse(null);
+
+                // ③查询过期时间早的优惠券
+                if(null!=bestCoupon){
+                    final BigDecimal zeroMaxCouponDiscountValue = bestCoupon.getCouponDiscountValue();
+                    // 过滤出discountType 是zero的优惠券,且couponDiscountValue与bestCoupon的couponDiscountValue面值一样的优惠券,并根据effectiveEnd正序排,获取第一条数据
+                    CouponRecordVO effectiveEndEarlyCoupon= mineCouponRecordList.stream()
+                            .filter(coupon -> coupon.getCouponDiscountType().equals(CouponTypeEnum.ZERO.getType()))
+                            .filter(coupon -> coupon.getCouponDiscountValue().compareTo(zeroMaxCouponDiscountValue)==0)
+                            .min(Comparator.comparing(CouponRecordVO::getEffectiveEnd))
+                            .orElse(null);
+                    if(null!=effectiveEndEarlyCoupon){
+                        bestCoupon=effectiveEndEarlyCoupon;
+                    }
+                }
+
+            }
+        }
+        return bestCoupon;
+
+    }
 }

--
Gitblit v1.9.3