From 5ff8fb8bd9d298def47437b24e77c8879cdc37d2 Mon Sep 17 00:00:00 2001 From: 陶杰 <1378534974@qq.com> Date: 星期四, 14 十一月 2024 09:36:39 +0800 Subject: [PATCH] 1.定时任务-待付款-15分钟 2.领券中心:根据领取次数判断是否已领取 3.付款:优惠券自动领取最大优惠券 --- src/main/java/com/mzl/flower/mapper/payment/OrderItemMapper.java | 11 +++++++++++ 1 files changed, 11 insertions(+), 0 deletions(-) diff --git a/src/main/java/com/mzl/flower/mapper/payment/OrderItemMapper.java b/src/main/java/com/mzl/flower/mapper/payment/OrderItemMapper.java index ff6f409..950fcba 100644 --- a/src/main/java/com/mzl/flower/mapper/payment/OrderItemMapper.java +++ b/src/main/java/com/mzl/flower/mapper/payment/OrderItemMapper.java @@ -2,11 +2,14 @@ import com.baomidou.mybatisplus.core.mapper.BaseMapper; import com.mzl.flower.dto.response.payment.AbnormalOrderItemDTO; +import com.mzl.flower.dto.response.payment.OrderItemListDTO; import com.mzl.flower.dto.response.payment.OrderItemPlatformListDTO; import com.mzl.flower.entity.payment.OrderItem; import org.apache.ibatis.annotations.Param; +import org.apache.ibatis.annotations.Select; import org.springframework.stereotype.Repository; +import java.time.LocalDateTime; import java.util.List; @Repository @@ -14,4 +17,12 @@ List<AbnormalOrderItemDTO> getAbnormalItems(@Param("orderId") String orderId); List<OrderItemPlatformListDTO> getPlatformOrderItems(@Param("orderId") String orderId); + + List<OrderItemListDTO> getOrderItems(@Param("orderIds") List<String> orderIds); + + Integer getFlowerSaleNum(@Param("startTime") LocalDateTime startTime + , @Param("endTime") LocalDateTime endTime); + + @Select("select sum(num) from t_order_item where deleted = '0' and order_id = #{orderId}") + Integer getSumNumByOrderId(String orderId); } -- Gitblit v1.9.3