From 007f07e56ff5a461b035fcde1caa72507b6c5815 Mon Sep 17 00:00:00 2001
From: zwl <1051256694@qq.com>
Date: 星期一, 27 四月 2026 11:07:02 +0800
Subject: [PATCH] 电视机托盘数优化
---
src/main/java/com/zy/asrs/mapper/WrkMastLogMapper.java | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diff --git a/src/main/java/com/zy/asrs/mapper/WrkMastLogMapper.java b/src/main/java/com/zy/asrs/mapper/WrkMastLogMapper.java
index 8cd93e9..7fdd120 100644
--- a/src/main/java/com/zy/asrs/mapper/WrkMastLogMapper.java
+++ b/src/main/java/com/zy/asrs/mapper/WrkMastLogMapper.java
@@ -39,7 +39,7 @@
@Select("SELECT MIN(ISNULL(appe_time, io_time)) FROM asr_wrk_mast_log WHERE train_no = #{trainNo} AND io_type < 100")
Date selectFirstInboundCreateTimeByTrainNo(@Param("trainNo") String trainNo);
- @Select("SELECT wrk_no FROM asr_wrk_mast_log WHERE train_no = #{trainNo} AND io_type < 100 AND wrk_sts = 5")
+ @Select("SELECT wrk_no FROM asr_wrk_mast_log WHERE train_no = #{trainNo} AND io_type = 1 AND wrk_sts = 5")
List<Integer> listFinishedInboundWrkNosByTrainNo(@Param("trainNo") String trainNo);
@Select("SELECT ISNULL(SUM(CAST(ISNULL(cost_time, 0) AS BIGINT)), 0) " +
--
Gitblit v1.9.1