From 3abf7a08a772acf35499b51f0c0e783804fc14f4 Mon Sep 17 00:00:00 2001
From: chenlu <1320612696@qq.com>
Date: 星期四, 27 三月 2025 10:37:34 +0800
Subject: [PATCH] 报工新增查询添加显示上下工序接收审核状态
---
north-glass-erp/src/main/java/com/example/erp/mapper/sd/DeliveryMapper.java | 68 ++++++++++++++++++++++++++++++++++
1 files changed, 68 insertions(+), 0 deletions(-)
diff --git a/north-glass-erp/src/main/java/com/example/erp/mapper/sd/DeliveryMapper.java b/north-glass-erp/src/main/java/com/example/erp/mapper/sd/DeliveryMapper.java
new file mode 100644
index 0000000..7decd16
--- /dev/null
+++ b/north-glass-erp/src/main/java/com/example/erp/mapper/sd/DeliveryMapper.java
@@ -0,0 +1,68 @@
+package com.example.erp.mapper.sd;
+
+import com.example.erp.entity.pp.FlowCard;
+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.util.List;
+import java.util.Map;
+
+@Mapper
+public interface DeliveryMapper extends CrudRepository<Delivery,Long> {
+
+ List<Delivery> getSelectShippingOrder(@Param("offset") Integer offset,
+ @Param("pageSize") Integer pageSize,String startDate, String endDate,
+ @Param("delivery") Delivery delivery);
+
+ Delivery getSelectShippingOrderDetailDelivery(@Param("offset") Integer offset,
+ @Param("pageSize") Integer pageSize,
+ @Param("orderDetail") OrderDetail orderDetail);
+
+ Delivery getSelectShippingOrderDetailDeliveryPrinting(@Param("deliveryDetail") DeliveryDetail deliveryDetail);
+
+ Order getSelectShippingOrderDetailPrinting(@Param("orderDetail") OrderDetail orderDetail);
+
+ Order getSelectShippingOrderDetailDeliverys(@Param("offset") Integer offset,
+ @Param("pageSize") Integer pageSize,
+ @Param("orderDetail") OrderDetail orderDetail);
+ Map<String,Integer> getSelectShippingOrderPageTotal(Integer offset, Integer pageSize, String startDate, String endDate, Delivery delivery);
+
+ List<Order> getSelectOrderInventory(@Param("offset") Integer offset,
+ @Param("pageSize") Integer pageSize,String startDate, String endDate,
+ @Param("order") Order order);
+
+ Order selectOrderId(String orderId);
+
+ Map<String,Integer> getSelectOrderInventoryPageTotal(Integer offset, Integer pageSize,String startDate, String endDate, Order order);
+
+ Boolean insertDelivery(@Param("delivery") Delivery delivery,@Param("number") String number,@Param("orderId") String orderId);
+
+ Boolean updateDelivery(@Param("delivery") Delivery delivery,@Param("number") String number,@Param("orderId") String orderId);
+
+ Integer getDeliveryConut(@Param("deliveryId") String deliveryId);
+
+ Boolean updateDeliveryToExamine(@Param("deliveryId") String deliveryId,@Param("deliveryState") int deliveryState);
+
+ Boolean deleteDelivery(@Param("deliveryId") String deliveryId);
+
+ Integer getmaximum(@Param("type") String type);
+
+ Integer getmaximumMonth();
+
+ Boolean updatedelivery(@Param("area") Double area,
+ @Param("quantity") Integer quantity,
+ @Param("money") Double money,
+ @Param("otherMoney") Double otherMoney,
+ @Param("oddNumber") String oddNumber);
+
+ boolean updateDeliveryPrintNumber(@Param("deliveryId") String deliveryId);
+
+
+
+
+}
--
Gitblit v1.8.0