From c8ea01fdd9fc8ebf5e1fcbbd56fee7071e4d5809 Mon Sep 17 00:00:00 2001
From: cloudroam <cloudroam>
Date: 星期二, 10 十二月 2024 14:45:05 +0800
Subject: [PATCH] 583-订单管理-订单列表统计页面增加一个，筛选地区的下拉列表，例如昆明-呈贡区等等
---
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