From 95270d9f2d0c93b52569268737902c4f09216c6b Mon Sep 17 00:00:00 2001
From: 廖井涛 <2265517004@qq.com>
Date: 星期五, 13 九月 2024 12:04:39 +0800
Subject: [PATCH] 返工查询后端筛选提交
---
north-glass-erp/src/main/java/com/example/erp/mapper/sd/OrderDetailMapper.java | 53 +++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 53 insertions(+), 0 deletions(-)
diff --git a/north-glass-erp/src/main/java/com/example/erp/mapper/sd/OrderDetailMapper.java b/north-glass-erp/src/main/java/com/example/erp/mapper/sd/OrderDetailMapper.java
new file mode 100644
index 0000000..f76f5aa
--- /dev/null
+++ b/north-glass-erp/src/main/java/com/example/erp/mapper/sd/OrderDetailMapper.java
@@ -0,0 +1,53 @@
+package com.example.erp.mapper.sd;
+
+import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import com.example.erp.dto.sd.OrderDTO;
+import com.example.erp.dto.sd.OrderDetailProductDTO;
+import com.example.erp.entity.sd.Order;
+import com.example.erp.entity.sd.OrderDetail;
+import org.apache.ibatis.annotations.Mapper;
+
+import java.time.LocalDate;
+import java.util.List;
+import java.util.Map;
+
+@Mapper
+public interface OrderDetailMapper extends BaseMapper<OrderDetail> {
+
+ boolean insertBatch(List<OrderDetail> orderDetails);
+
+ boolean updateOrderMoney( List<OrderDetail> orderDetails);
+
+ List<OrderDetail> getOrderReport(Integer offset, Integer pageSize, String startDate, String endDate, OrderDetail orderDetail);
+
+ //type涓轰簡鍖哄埆闇�涓嶉渶瑕佹牴鎹骇鍝佸垎绫�
+ Map<String,Integer> getOrderReportTotal(Integer offset, Integer pageSize, String startDate, String endDate, OrderDetail orderDetail, String type);
+
+ List<OrderDTO> exportOrderReport(List<LocalDate> dates);
+
+ List<OrderDetail> getOrderProductSummary(Integer offset, Integer pageSize, String startDate, String endDate, OrderDetail orderDetail);
+
+ Map<String,Integer> getOrderProductSummaryTotal(Integer offset, Integer pageSize, String startDate, String endDate, OrderDetail orderDetail, String product);
+
+ List<OrderDTO> exportOrderProductSummary(List<LocalDate> dates);
+
+ List<OrderDetailProductDTO> exportOrderReportProduct(List<LocalDate> dates);
+
+ Map<String, String> getOrderProductDetailTag(String orderId);
+
+ List<Map<String,Object>> getOrderProductDistinctById(String orderId);
+
+ List<Map<String,Object>> getOrderProductDistinctByIds(String orderId,List<String> productId);
+
+ List<OrderDetail> getOrderProductByProductId(Object productId, String orderId);
+
+ List<Map<String,Object>> getOrderProductByProductIds(Object productId, String orderId);
+
+ List<Order> getOrderSummaryReport(Integer offset, Integer pageSize, String startDate, String endDate, Order order);
+
+ Map<String,Integer> getOrderSummaryReportTotal(Integer offset, Integer pageSize, String startDate, String endDate, Order order, String type);
+
+ List<Order> exportOrderSummary(List<LocalDate> dates);
+
+
+}
--
Gitblit v1.8.0