From d809ecd16cbb23f5aad86a6844f51ffea0455fe8 Mon Sep 17 00:00:00 2001
From: chenlu <1320612696@qq.com>
Date: 星期五, 06 九月 2024 16:53:55 +0800
Subject: [PATCH] Merge branch 'master' of http://bore.pub:10439/r/ERP_override

---
 north-glass-erp/src/main/java/com/example/erp/mapper/sd/DeliveryDetailMapper.java |   91 +++++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 91 insertions(+), 0 deletions(-)

diff --git a/north-glass-erp/src/main/java/com/example/erp/mapper/sd/DeliveryDetailMapper.java b/north-glass-erp/src/main/java/com/example/erp/mapper/sd/DeliveryDetailMapper.java
new file mode 100644
index 0000000..99db04b
--- /dev/null
+++ b/north-glass-erp/src/main/java/com/example/erp/mapper/sd/DeliveryDetailMapper.java
@@ -0,0 +1,91 @@
+package com.example.erp.mapper.sd;
+
+import com.example.erp.dto.sd.DeliveryDetailDTO;
+import com.example.erp.dto.sd.DeliveryDetailProductDTO;
+import com.example.erp.entity.sd.Delivery;
+import com.example.erp.entity.sd.DeliveryDetail;
+import com.example.erp.entity.sd.Order;
+import com.example.erp.entity.sd.OrderDetail;
+import org.apache.ibatis.annotations.Mapper;
+import org.apache.ibatis.annotations.Param;
+import org.springframework.data.repository.CrudRepository;
+
+import java.time.LocalDate;
+import java.util.List;
+import java.util.Map;
+
+@Mapper
+public interface DeliveryDetailMapper extends CrudRepository<DeliveryDetail,Long> {
+
+    List<DeliveryDetail> getSelectShippingOrderDetail(@Param("offset") Integer offset,
+                                                      @Param("pageSize") Integer pageSize,
+                                                      @Param("orderDetail") OrderDetail orderDetail);
+
+
+
+    Integer getSelectShippingOrderDetailPageTotal(Integer offset, Integer pageSize,OrderDetail orderDetail);
+
+    List<DeliveryDetail> getSelectDeliveryPrinting(@Param("deliveryDetail") DeliveryDetail deliveryDetail);
+
+    List<OrderDetail> getSelectOrderPrinting(Object productId, String orderId);
+
+    List <Map<String, Object>> getSelectDeliveryDetailPrinting(@Param("deliveryId") String deliveryId,
+                                                         @Param("productId") Integer productId,@Param("orderId") String orderId);
+
+    Map<String, Object> getSelectotherMoney(@Param("orderId") String orderId,@Param("deliveryId") String deliveryId,
+                                                   @Param("orderNumber") Integer orderNumber,@Param("key") String key,@Param("value") String value);
+
+    Map<String, Object> getSelectOrderotherMoney(@Param("orderId") String orderId,@Param("orderNumber") Integer orderNumber, @Param("key") String key,@Param("value") String value);
+
+    List <Map<String, Object>> getSelectOrderDetailPrinting(@Param("productId") Integer productId,@Param("orderId") String orderId);
+
+
+    List<DeliveryDetail> getSelectDeliveryDetailReport(@Param("offset") Integer offset,
+                                                      @Param("pageSize") Integer pageSize,String startDate, String endDate,
+                                                      @Param("deliveryDetail") DeliveryDetail deliveryDetail);
+
+    Map<String,Integer> getSelectDeliveryDetailReportPageTotal(Integer offset, Integer pageSize,String startDate, String endDate, DeliveryDetail deliveryDetail);
+
+    List<DeliveryDetail> getSelectDeliveryDetailProductReport(@Param("offset") Integer offset,
+                                                       @Param("pageSize") Integer pageSize,String startDate, String endDate,
+                                                       @Param("deliveryDetail") DeliveryDetail deliveryDetail);
+
+    Map<String,Integer> getSelectDeliveryDetailProductReportPageTotal(Integer offset, Integer pageSize,String startDate, String endDate, DeliveryDetail deliveryDetail);
+
+    List<DeliveryDetail> getSelectShippingOrderDetails(@Param("offset") Integer offset,
+                                                     @Param("pageSize") Integer pageSize,
+                                                     @Param("orderDetail") OrderDetail orderDetail);
+
+    List<DeliveryDetail> getIsNotDeliveryDetail(@Param("deliveryId") String deliveryId);
+
+
+
+    Integer getSelectShippingOrderDetailsPageTotal(Integer offset, Integer pageSize,OrderDetail orderDetail);
+
+    Boolean insertDeliveryDetail(@Param("orderDetail") OrderDetail orderDetail, @Param("number") String number
+            ,@Param("deliveryNumber") Integer deliveryNumber,@Param("deliveryDetailMoney") Double deliveryDetailMoney,
+                                 @Param("otherMoneys") Double otherMoneys,@Param("deliveryDetailArea") Double deliveryDetailArea);
+
+    Integer getdeliveryDetailmaximum(@Param("deliveryId") String deliveryId);
+
+    Integer getSelectDetailNum(@Param("orderId") String orderId);
+
+    Integer getSelectDetailQuantity(@Param("orderId") String orderId);
+
+    Boolean updateOrderDetailDeliveryNum(OrderDetail orderDetail);
+
+    Boolean updateOrderDelivery(@Param("orderDetail") OrderDetail orderDetail,@Param("state") Integer state);
+
+    Boolean updateIsNotOrderDetailDeliveryNum(@Param("orderId") String orderId,
+                                              @Param("orderNumber") Integer orderNumber,
+                                              @Param("quantity") Integer quantity);
+
+    Boolean deleteDeliveryDetail(@Param("deliveryId") String deliveryId);
+
+    List<DeliveryDetailDTO> exportDeliveryDetailReport(List<LocalDate> dates);
+
+    List<DeliveryDetailProductDTO> exportDeliveryDetailProductReport(List<LocalDate> dates);
+
+    OrderDetail selectOrderDetailDeliveryCount(@Param("orderDetail") OrderDetail orderDetail);
+
+}

--
Gitblit v1.8.0