From ca03b69027275f191f0a5c6a9c01340818a5125c Mon Sep 17 00:00:00 2001
From: pang.jiabao <pang_jiabao@163.com>
Date: 星期一, 23 三月 2026 15:09:55 +0800
Subject: [PATCH] 自动提高浅库位出库任务优先级
---
src/main/java/com/zy/asrs/task/GhjtScheduler.java | 5 +++++
src/main/java/com/zy/asrs/mapper/WrkMastMapper.java | 1 +
src/main/resources/mapper/WrkMastMapper.xml | 7 +++++++
3 files changed, 13 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/zy/asrs/mapper/WrkMastMapper.java b/src/main/java/com/zy/asrs/mapper/WrkMastMapper.java
index e5009cc..4db88ad 100644
--- a/src/main/java/com/zy/asrs/mapper/WrkMastMapper.java
+++ b/src/main/java/com/zy/asrs/mapper/WrkMastMapper.java
@@ -23,4 +23,5 @@
@Insert("insert into asr_wrk_mast_log select * from asr_wrk_mast where wrk_no=#{workNo}")
int saveWrkMastLog(Integer workNo);
+ void updatePriorityByShallow();
}
diff --git a/src/main/java/com/zy/asrs/task/GhjtScheduler.java b/src/main/java/com/zy/asrs/task/GhjtScheduler.java
index b16f487..7758557 100644
--- a/src/main/java/com/zy/asrs/task/GhjtScheduler.java
+++ b/src/main/java/com/zy/asrs/task/GhjtScheduler.java
@@ -132,4 +132,9 @@
ghjtHandler.autoTallyGoods(flag);
}
+ // 鑷姩鎻愰珮娴呭簱浣嶅嚭搴撲换鍔′紭鍏堢骇
+ @Scheduled(cron = "0/10 * * * * ? ")
+ public void boostShallowLocationTaskPriority() {
+ wrkMastMapper.updatePriorityByShallow();
+ }
}
diff --git a/src/main/resources/mapper/WrkMastMapper.xml b/src/main/resources/mapper/WrkMastMapper.xml
index f68797b..4a82e29 100644
--- a/src/main/resources/mapper/WrkMastMapper.xml
+++ b/src/main/resources/mapper/WrkMastMapper.xml
@@ -61,6 +61,13 @@
<result column="pre_have" property="preHave" />
<result column="take_none" property="takeNone" />
</resultMap>
+ <update id="updatePriorityByShallow">
+ update asr_wrk_mast
+ set io_pri = 14
+ where wrk_sts = 11
+ and io_pri = 13
+ and substring(source_loc_no,1,2) in ('02','03','06','07','10','11','14','15','18','19','22','23')
+ </update>
<select id="selectToBeCompleteData" resultMap="BaseResultMap">
select * from asr_wrk_mast where ((wrk_sts = 4 Or wrk_sts = 14 ) and io_type != 103 and io_type != 104 and io_type != 107 ) or (wrk_sts = 2 and io_type=6) order by upd_mk,error_time,io_time,wrk_no
--
Gitblit v1.9.1