From f1c69821bfa7733daaa79a377dac45556946cf6b Mon Sep 17 00:00:00 2001
From: pang.jiabao <pang_jiabao@163.com>
Date: 星期六, 08 二月 2025 08:44:50 +0800
Subject: [PATCH] 物料冻结时间超三个月自动解冻
---
src/main/java/com/zy/asrs/mapper/PlaMapper.java | 6 ++++++
src/main/java/com/zy/asrs/task/PlaDetlScheduler.java | 17 +++++++++++++++++
src/main/resources/mapper/PlaMapper.xml | 11 +++++++++++
3 files changed, 34 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/zy/asrs/mapper/PlaMapper.java b/src/main/java/com/zy/asrs/mapper/PlaMapper.java
index 9c5b708..7c03a65 100644
--- a/src/main/java/com/zy/asrs/mapper/PlaMapper.java
+++ b/src/main/java/com/zy/asrs/mapper/PlaMapper.java
@@ -24,4 +24,10 @@
Integer getStockStatisCountAll(Map<String, Object> map);
+ /**
+ * 鑷姩瑙ｅ喕鍐荤粨鏃堕棿瓒呰繃90澶╃殑搴撳瓨
+ * @return 鏇存柊鏁伴噺
+ */
+ int autoThaw();
+
}
diff --git a/src/main/java/com/zy/asrs/task/PlaDetlScheduler.java b/src/main/java/com/zy/asrs/task/PlaDetlScheduler.java
index 945124b..72af2f6 100644
--- a/src/main/java/com/zy/asrs/task/PlaDetlScheduler.java
+++ b/src/main/java/com/zy/asrs/task/PlaDetlScheduler.java
@@ -2,12 +2,14 @@
import com.core.common.Cools;
import com.zy.asrs.entity.Pla;
+import com.zy.asrs.mapper.PlaMapper;
import com.zy.asrs.service.PlaService;
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.scheduling.annotation.Scheduled;
import org.springframework.stereotype.Component;
+import javax.annotation.Resource;
import java.util.List;
@Slf4j
@@ -16,6 +18,9 @@
@Autowired
private PlaService plaService;
+
+ @Resource
+ private PlaMapper plaMapper;
@Scheduled(cron = "0/60 * * * * ? ")
private void execute(){
@@ -29,4 +34,16 @@
}
}
+
+ /**
+ * 姣忛殧涓�澶╂壂鎻忎竴娆″喕缁撶殑搴撳瓨锛岃秴杩囦笁涓湀鍒欒嚜鍔ㄨВ鍐�
+ */
+ @Scheduled(cron = "0 0 0 * * ?")
+ private void autoThaw(){
+
+ int i = plaMapper.autoThaw();
+ log.info("---------------鑷姩瑙ｅ喕搴撳瓨{}涓�--------------------------", i);
+
+ }
+
}
diff --git a/src/main/resources/mapper/PlaMapper.xml b/src/main/resources/mapper/PlaMapper.xml
index 1c1f62d..7aa3286 100644
--- a/src/main/resources/mapper/PlaMapper.xml
+++ b/src/main/resources/mapper/PlaMapper.xml
@@ -1,6 +1,17 @@
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper namespace="com.zy.asrs.mapper.PlaMapper">
+ <update id="autoThaw">
+ update
+ asr_pla_detl
+ set
+ stock_freeze = 1
+ where
+ stock_freeze = 0
+ and status != '鍏ㄩ儴鍑哄簱'
+ and stock_freeze_date is not null
+ and datediff(day , stock_freeze_date, getdate()) > 90
+ </update>
<select id="getStockStatisAll" resultType="com.zy.asrs.entity.Pla">
select brand, matnr,workshop, sum(weight_anfme) as weight
from asr_pla_detl
--
Gitblit v1.9.1