From 00ecb40e3882df465f70f715531796912bd3c29c Mon Sep 17 00:00:00 2001
From: pjb <pjb123456>
Date: 星期日, 13 七月 2025 16:54:27 +0800
Subject: [PATCH] 增加空托出库条件(堆垛机自动+无报警码)

---
 src/main/resources/mapper/LocMastMapper.xml |    4 ++--
 1 files changed, 2 insertions(+), 2 deletions(-)

diff --git a/src/main/resources/mapper/LocMastMapper.xml b/src/main/resources/mapper/LocMastMapper.xml
index 25e2ad2..630a9ba 100644
--- a/src/main/resources/mapper/LocMastMapper.xml
+++ b/src/main/resources/mapper/LocMastMapper.xml
@@ -207,9 +207,9 @@
         select
         top 1 *
         from
-        asr_loc_mast alm
+        asr_loc_mast alm inner join asr_bas_crnp abc on alm.crn_no = abc.crn_no
         where
-        alm.loc_sts = #{locType}
+        alm.loc_sts = #{locType} and abc.crn_err = 0 and abc.crn_sts = 3
         <if test="rowList != null and !rowList.isEmpty()">
             and alm.row1 in
             <foreach collection="rowList" item="item" open="(" close=")" separator=",">

--
Gitblit v1.9.1