mxys_backend/src/main/java/com/sqx/scheduler/order/OrderScheduler.java

package com.sqx.scheduler.order;

import cn.hutool.core.collection.CollUtil;
import cn.hutool.core.util.ObjectUtil;
import cn.hutool.core.util.StrUtil;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.toolkit.ObjectUtils;
import com.ekyong.www.pay.pay.qrcode.api.RhtQrcodePayApi;
import com.ekyong.www.pay.pay.qrcode.bean.QrcodeQueryRequestBean;
import com.ekyong.www.pay.pay.qrcode.bean.QrcodeQueryResponseBean;
import com.sqx.modules.common.entity.CommonInfo;
import com.sqx.modules.common.service.CommonInfoService;
import com.sqx.modules.goods.entity.GoodsShop;
import com.sqx.modules.goods.service.GoodsShopService;
import com.sqx.modules.order.entity.TbOrder;
import com.sqx.modules.order.service.AppOrderService;
import com.sqx.modules.pay.config.WechatPayConfig;
import com.sqx.modules.pay.entity.PayDetails;
import com.sqx.modules.pay.enums.PayStateEnums;
import com.sqx.modules.pay.service.PayDetailsService;
import com.sqx.modules.shop.entity.ShopType;
import com.sqx.modules.shop.service.ShopTypeService;
import com.sqx.scheduler.config.SchedulerLock;
import lombok.RequiredArgsConstructor;
import lombok.extern.slf4j.Slf4j;
import org.redisson.api.RLock;
import org.redisson.api.RedissonClient;
import org.springframework.scheduling.annotation.Async;
import org.springframework.scheduling.annotation.Scheduled;
import org.springframework.stereotype.Component;

import java.time.LocalDateTime;
import java.time.format.DateTimeFormatter;
import java.util.ArrayList;
import java.util.Collections;
import java.util.Date;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import java.util.concurrent.TimeUnit;
import java.util.stream.Collectors;

/**
 * 订单定时任务
 *
 * @author : codingliang
 * @date : 2024-08-19 20:42
 */
@Slf4j
@Component
@RequiredArgsConstructor
public class OrderScheduler {

    private final RedissonClient redissonClient;
    private final AppOrderService orderService;
    private final CommonInfoService commonInfoService;
    private final PayDetailsService payDetailsService;
    private final ShopTypeService shopTypeService;
    private final GoodsShopService goodsShopService;

    private final static String RHT_PAY_BASE_URL = "https://api.ekbuyclub.com";

    /**
     * 预约订单自动接单
     * 5分钟运行一次
     */
    @Async
    @Scheduled(cron = "0 */5 * * * ?")
    public void reservationAutoReceivingOrder() {
        RLock lock = redissonClient.getLock(SchedulerLock.ORDER_OF_RESERVATION_AUTO_RECEIVING_LOCK);
        lock.lock();
        try {
            log.info("预约订单自动接单任务开始运行");
            List<Long> orderIds = orderService.getCurWaitReceivingOrderIds();
            if (CollUtil.isEmpty(orderIds)) {
                log.info("没有符合条件的预约订单，预约订单自动接单任务运行....");
                return;
            }

            List<TbOrder> waitOrders = orderIds.stream().map(orderId -> {
                TbOrder waitOrder = new TbOrder();
                waitOrder.setOrderId(orderId);
                waitOrder.setStatus(6);

                return waitOrder;
            }).collect(Collectors.toList());

            for (TbOrder waitOrder : waitOrders) {
                log.info("预约订单id：{}，正在自动接单", waitOrder.getOrderId());
                try {
                    orderService.updateOrder(waitOrder);
                    log.info("预约订单id：{}，自动接单成功", waitOrder.getOrderId());
                } catch (Exception e) {
                    e.printStackTrace();
                    log.error("预约单id:{},自动接单失败，失败原因：{}", waitOrder.getOrderId(), e.getMessage());
                }
            }

            log.info("预约订单自动接单任务运行成功");
        } catch (Exception e) {
            log.error("预约订单自动接单任务运行失败失败原因：{}", e.getMessage());
        } finally {
            lock.unlock();
        }
    }

    /**
     * 制作中订单自动制作完成
     * 每分钟30秒时运行一次
     */
    @Async
    @Scheduled(cron = "30 */2 * * * ?")
    public void prodIngOrderAutoCompleted(){
        try {
            log.info("自动制作完成制作中订单任务开始运行");
            // 获取配置：是否开启制作中订单自动完成
            String value = commonInfoService.findOne(418).getValue();
            if("是".equals(value)){
                String minute = commonInfoService.findOne(419).getValue();
                LocalDateTime minusMinutes = LocalDateTime.now().minusMinutes(Long.valueOf(minute));

                // 获取制作中状态的订单列表
                List<TbOrder> orders = orderService.getProdIngOrders(minusMinutes);
                if (CollUtil.isEmpty(orders)) {
                    log.info("当前时间段没有需要自动制作完成的订单");
                } else {
                    // 订单随机排序
                    Collections.shuffle(orders);
                    for (TbOrder order: orders){
                        try {
                            log.info("订单：{}，开始自动制作完成", order.getOrderId());
                            order.setStatus(3);
                            orderService.updateOrder(order);
                            log.info("订单：{}，自动制作完成", order.getOrderId());
                        } catch (Exception e){
                            e.printStackTrace();
                            log.error("订单：{}，自动完成异常，异常原因：【{}】", order.getOrderId(), e);
                        }
                    }
                }
            }
            log.info("自动制作完成制作中订单任务运行成功");
        } catch (Exception e) {
            log.error("制作中订单自动制作完成任务运行失败失败原因：【{}】", e);
        }
    }

    /**
     * 自动完成订单
     * 每30s运行一次
     */
    @Async
    @Scheduled(cron = "45 */1 * * * ?")
    public void autoFinishOrder() {
        RLock lock = redissonClient.getLock(SchedulerLock.ORDER_OF_WAIT_DELIVERY_AUTO_FINISH_LOCK);
        lock.lock();
        try {
            log.info("自动完成订单任务开始运行");
            CommonInfo one = commonInfoService.findOne(268);
            DateTimeFormatter df = DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss");

//            查询三大运营商的店铺
            List<Long> shopList = new ArrayList<>();
            QueryWrapper<ShopType> wrapperShopType = new QueryWrapper<>();
            wrapperShopType.eq("shop_type_name", "三大运营商");
            ShopType shopType = shopTypeService.getOne(wrapperShopType);
            if (ObjectUtils.isNotEmpty(shopType)) {
                QueryWrapper<GoodsShop> wrapperGoodShop = new QueryWrapper<>();
                wrapperGoodShop.eq("shop_type_id", shopType.getId());
                List<GoodsShop> goodsShops = goodsShopService.list(wrapperGoodShop);
                for (GoodsShop goodsShop : goodsShops) {
                    Long shopId = goodsShop.getShopId();
                    shopList.add(shopId);
                }
            }
            log.info("所属运营商店铺："+shopList);
            // 查询所有 待取餐/派送中 状态的订单
            QueryWrapper<TbOrder> queryWrapper = new QueryWrapper<>();
            queryWrapper.eq("status", 3);
            queryWrapper.notIn(ObjectUtils.isNotEmpty(shopList)&&shopList.size()>0,"shop_id",shopList);
            List<TbOrder> orders = orderService.list(queryWrapper);
            for (TbOrder order : orders) {
                try {
                    LocalDateTime updateTime = LocalDateTime.parse(order.getUpdateTime(), df);
                    // 计算当前订单什么时候超时完成
                    LocalDateTime overDateTime = updateTime.plusHours(Integer.parseInt(one.getValue()));
                    if (LocalDateTime.now().isAfter(overDateTime)) {
                        log.info("订单id：{}，开始自动完成", order.getOrderId());
                        orderService.accomplishOrder(order.getOrderId(), 2);
                        log.info("订单id：{}，完成自动完成", order.getOrderId());
                    }
                } catch (Exception e) {
                    log.error("订单id：{}，开始自动完成失败，失败原因【{}】", order.getOrderId(), e);
                }
            }
            log.info("自动完成订单任务运行成功");
        } catch (Exception e) {
            log.info("自动完成订单任务运行异常，异常", e);
        } finally {
            lock.unlock();
        }
    }

    /**
     * 自动更改超时订单
     * 每3分钟运行一次
     */
    @Async
    @Scheduled(cron = "0 */3 * * * ?")
    public void changeTimeOutOrder() {
        RLock lock = redissonClient.getLock(SchedulerLock.TIME_OUT_LOCK);
        lock.lock();
        try {
            log.info("超时订单自动取消任务开始运行");
            // 加5分钟在前端强制取消前执行 ??
            long time = new Date().getTime() + 5*60*1000;
            List<TbOrder> orderList = orderService.changeTimeOutOrder(time);

            if (orderList.size() == 0) {
                log.info("没有符合条件的超时订单，超时订单自动取消任务运行....");
                return;
            }

            WechatPayConfig wechatMchConfig = WechatPayConfig.builder()
                    .appId(commonInfoService.findOne(45).getValue())
                    .mchId(commonInfoService.findOne(434).getValue())
                    .mchKey(commonInfoService.findOne(435).getValue())
                    .h5Url(commonInfoService.findOne(19).getValue())
                    .build();

            RhtQrcodePayApi qrcodePay = new RhtQrcodePayApi(wechatMchConfig.getMchId(), wechatMchConfig.getMchKey(), RHT_PAY_BASE_URL);
            ArrayList<TbOrder> orders = new ArrayList<>();
            for (TbOrder tbOrder : orderList) {
                String orderNumber = tbOrder.getOrderNumber();
                try {
                    // 状态为待支付需要调用支付系统订单查询接口判断支付系统对应的订单状态
                    Map<String, String> data = new HashMap<>();
                    // 商户订单号
                    data.put("out_trade_no", orderNumber);
                    QrcodeQueryRequestBean qqrb = new QrcodeQueryRequestBean();
                    qqrb.setTraceno(orderNumber);// 商户流水号
                    QrcodeQueryResponseBean response2 = qrcodePay.query(qqrb);
                    String respCode = response2.getRespCode();
                    log.info("超时任务处理订单【{}】查询支付结果，支付通知信息：{}", orderNumber, response2);
                    // 0未支付，1支付成功，2支付失败，4退款中，5退款成功，6退款失败
                    if (StrUtil.equals("1", respCode)){
                        String payTime = response2.getTransDate()+ " " + response2.getTransTime();
                        PayDetails payDetails = payDetailsService.getByOrderNo(orderNumber);
                        if (!ObjectUtil.isNull(payDetails)) {
                            payDetails.setState(PayStateEnums.PAY_SUCCESS.getStateCode());
                            payDetails.setPayTime(payTime);
                            payDetails.setTradeNo(response2.getChannelOrderno());
                            payDetails.setRemark("Scheduled RHT PAY SUCCESS");
                            payDetailsService.updateDetail(payDetails);
                        }else {
                            log.error("超时任务处理订单【{}】支付成功，但未获取到支付订单！支付通知信息：{}", orderNumber, response2);
                        }
                        tbOrder.setPayTime(payTime);
                        tbOrder.setPayType(1);
                        orderService.updateOrderAfterPaySuccess(tbOrder);
                    } else {
                        tbOrder.setStatus(5);
                        orders.add(tbOrder);
                    }
                } catch (Exception e) {
                    log.error("超时任务处理订单【{}】查询支付结果失败，失败原因：{}", orderNumber, e.getMessage());
                    e.printStackTrace();
                }
            }
            // list为空不要执行
            if(!orders.isEmpty()){
                orderService.updateBatchById(orders);
            }
            log.info("超时订单自动取消运行成功");
        } catch (Exception e) {
            log.error("超时订单自动取消任务运行失败失败原因：{}", e.getMessage());
            e.printStackTrace();
        } finally {
            lock.unlock();
        }
    }

    /**
     * 更新店铺销量
     *  每天1点执行
     */
     @Async
     @Scheduled(cron = "0 0 1 * * ?")
    public void updateShopSales() {
        RLock lock = null;
        try {
            // 尝试获取锁，最多等待0秒（即立即返回），锁的过期时间为2分钟
            lock = redissonClient.getLock(SchedulerLock.UPDATE_SHOP_SALES_LOCK);
            boolean isLocked = lock.tryLock(0, 2, TimeUnit.MINUTES);
            if (!isLocked) {
                log.info("更新店铺销量任务：当前有其他服务实例正在执行，本次跳过");
                return;
            }
            log.info("更新店铺销量任务开始运行");
            Map<Long, Integer> shopSalesMap = orderService.countFinishGroupByShopId();
            goodsShopService.updateShopSales(shopSalesMap);
            log.info("更新店铺销量任务运行成功");
        } catch (Exception e) {
            log.error("更新店铺销量任务运行失败，失败原因：{}", e.getMessage());
        } finally {
            if (lock != null && lock.isHeldByCurrentThread()) {
                lock.unlock();
            }
        }
    }
}