From 4e8378a810220091e51aef35573fc56768b59a32 Mon Sep 17 00:00:00 2001
From: 廖井涛 <2265517004@qq.com>
Date: 星期一, 15 七月 2024 13:13:16 +0800
Subject: [PATCH] 新增发货报表导出客户简称字段
---
north-glass-erp/src/main/java/com/example/erp/mapper/sd/OrderDetailMapper.java | 34 +++++++++++++++++++++++++++++++++-
1 files changed, 33 insertions(+), 1 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
index 49c16de..2b59dbb 100644
--- 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
@@ -1,14 +1,46 @@
package com.example.erp.mapper.sd;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
-import com.example.erp.entity.sd.Order;
+import com.example.erp.dto.sd.OrderDTO;
+import com.example.erp.dto.sd.OrderDetailProductDTO;
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);
+
+
}
--
Gitblit v1.8.0