From 34bb2f6dc89ab3589f4a11f2f0b4c2f19ff8c7ad Mon Sep 17 00:00:00 2001
From: pjb <pjb123456>
Date: 星期四, 14 八月 2025 20:33:23 +0800
Subject: [PATCH] 自动出空桶判断4号堆垛机有无出库任务，有则不生成，让入库口直供罐装线

---
 src/main/java/com/zy/mapper/LocDetlMapper.java |    1 +
 1 files changed, 1 insertions(+), 0 deletions(-)

diff --git a/src/main/java/com/zy/mapper/LocDetlMapper.java b/src/main/java/com/zy/mapper/LocDetlMapper.java
index 595007c..5880a7b 100644
--- a/src/main/java/com/zy/mapper/LocDetlMapper.java
+++ b/src/main/java/com/zy/mapper/LocDetlMapper.java
@@ -28,4 +28,5 @@
     @Select("SELECT ld.loc_no FROM asr_loc_detl ld LEFT JOIN asr_loc_mast lm ON ld.loc_no = lm.loc_no WHERE (1 = 1 AND ld.matnr = #{matnr} AND (lm.row1 >= #{start} AND lm.row1 <= #{end})  AND lm.loc_sts = 'F' AND DateDiff(dd, lm.modi_time, getdate()) = 0) ORDER BY lm.modi_time ASC")
     List<String> selectSameDetlToday(@Param("matnr") String matnr, @Param("start") Integer start, @Param("end") Integer end);
 
+    List<LocDetl> selectListByMatnr(@Param("bucketType") int bucketType);
 }

--
Gitblit v1.9.1