From 5dca49269399c21333b16d62945c7f74570f9ad5 Mon Sep 17 00:00:00 2001
From: chen.llin <1442464845@qq.comm>
Date: 星期三, 24 十二月 2025 20:33:59 +0800
Subject: [PATCH] 字段调整
---
src/main/java/com/zy/asrs/mapper/MonthlySettleMapper.java | 69 ++++++++++++++++++++++++++++++++++
1 files changed, 69 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/zy/asrs/mapper/MonthlySettleMapper.java b/src/main/java/com/zy/asrs/mapper/MonthlySettleMapper.java
new file mode 100644
index 0000000..13b17bf
--- /dev/null
+++ b/src/main/java/com/zy/asrs/mapper/MonthlySettleMapper.java
@@ -0,0 +1,69 @@
+package com.zy.asrs.mapper;
+
+import com.baomidou.mybatisplus.mapper.BaseMapper;
+import com.zy.asrs.entity.MonthlySettle;
+import com.zy.asrs.entity.result.MaterialInOutRawDTO;
+import com.zy.asrs.entity.result.PreviousSettleEndingQtyDTO;
+import org.apache.ibatis.annotations.Mapper;
+import org.apache.ibatis.annotations.Param;
+import org.springframework.stereotype.Repository;
+
+import java.util.List;
+
+@Mapper
+@Repository
+public interface MonthlySettleMapper extends BaseMapper<MonthlySettle> {
+
+ /**
+ * 鑾峰彇鏈�杩戠殑鏈堢粨璁板綍
+ */
+ MonthlySettle selectLatestSettle();
+
+ /**
+ * 缁熻鏈堢粨鏃堕棿鑼冨洿鍐呮湭瀹屾垚鐨勫叆搴撹鍗曟暟閲�
+ */
+ int countUnfinishedOrdersInRangePakin(@Param("startDate") String startDate, @Param("endDate") String endDate);
+
+ /**
+ * 缁熻鏈堢粨鏃堕棿鑼冨洿鍐呮湭瀹屾垚鐨勫嚭搴撹鍗曟暟閲�
+ */
+ int countUnfinishedOrdersInRangePakout(@Param("startDate") String startDate, @Param("endDate") String endDate);
+
+ /**
+ * 缁熻鏈堢粨鏃堕棿鑼冨洿鍐呯殑鐗╂枡鍑哄叆搴撴暟閲忥紙浠庡叆搴撹〃鏌ヨ锛�
+ */
+ List<MaterialInOutRawDTO> statisticsMaterialInOutFromPakin(@Param("startDate") String startDate, @Param("endDate") String endDate);
+
+ /**
+ * 缁熻鏈堢粨鏃堕棿鑼冨洿鍐呯殑鐗╂枡鍑哄叆搴撴暟閲忥紙浠庡嚭搴撹〃鏌ヨ锛�
+ */
+ List<MaterialInOutRawDTO> statisticsMaterialInOutFromPakout(@Param("startDate") String startDate, @Param("endDate") String endDate);
+
+ /**
+ * 鑾峰彇涓婁竴涓湀缁撶殑鐗╂枡鏈熸湯搴撳瓨
+ */
+ List<PreviousSettleEndingQtyDTO> getPreviousSettleEndingQty(@Param("previousSettleId") Long previousSettleId);
+
+ /**
+ * 鏇存柊鍏ュ簱璁㈠崟鐨勬湀缁撲俊鎭�
+ */
+ int updateOrderSettleInfo(@Param("settleId") Long settleId, @Param("settleNo") String settleNo,
+ @Param("startDate") String startDate, @Param("endDate") String endDate);
+
+ /**
+ * 鏇存柊鍑哄簱璁㈠崟鐨勬湀缁撲俊鎭�
+ */
+ int updateOrderSettleInfoPakout(@Param("settleId") Long settleId, @Param("settleNo") String settleNo,
+ @Param("startDate") String startDate, @Param("endDate") String endDate);
+
+ /**
+ * 娓呴櫎鍏ュ簱璁㈠崟鐨勬湀缁撲俊鎭�
+ */
+ int clearOrderSettleInfo(@Param("settleId") Long settleId);
+
+ /**
+ * 娓呴櫎鍑哄簱璁㈠崟鐨勬湀缁撲俊鎭�
+ */
+ int clearOrderSettleInfoPakout(@Param("settleId") Long settleId);
+}
+
--
Gitblit v1.9.1