From 086adfdf1d5340a3503da5b5ebcae9073775450e Mon Sep 17 00:00:00 2001 From: 陶杰 <1378534974@qq.com> Date: 星期一, 30 十二月 2024 13:59:40 +0800 Subject: [PATCH] Merge remote-tracking branch 'origin/master-v4' into master-v4 --- src/main/java/com/mzl/flower/mapper/payment/OrderItemMapper.java | 4 ++++ 1 files changed, 4 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 e60120f..950fcba 100644 --- a/src/main/java/com/mzl/flower/mapper/payment/OrderItemMapper.java +++ b/src/main/java/com/mzl/flower/mapper/payment/OrderItemMapper.java @@ -6,6 +6,7 @@ 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; @@ -21,4 +22,7 @@ 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