From e4ea838c20e94dff4fdbb4f82b542a8b5790fa9d Mon Sep 17 00:00:00 2001
From: luxiaotao1123 <t1341870251@163.com>
Date: 星期五, 18 六月 2021 09:22:06 +0800
Subject: [PATCH] # 库存跳转上报erp
---
src/main/java/zy/cloud/wms/common/service/task/OrderScheduler.java | 58 ++++++++++++++++++++++++++++++++++++++++++++++++++++------
1 files changed, 52 insertions(+), 6 deletions(-)
diff --git a/src/main/java/zy/cloud/wms/common/service/task/OrderScheduler.java b/src/main/java/zy/cloud/wms/common/service/task/OrderScheduler.java
index 17b97c5..f1b5e48 100644
--- a/src/main/java/zy/cloud/wms/common/service/task/OrderScheduler.java
+++ b/src/main/java/zy/cloud/wms/common/service/task/OrderScheduler.java
@@ -1,13 +1,18 @@
package zy.cloud.wms.common.service.task;
import com.baomidou.mybatisplus.mapper.EntityWrapper;
+import com.core.common.Cools;
import com.core.exception.CoolException;
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.scheduling.annotation.Scheduled;
+import org.springframework.stereotype.Component;
import org.springframework.transaction.annotation.Transactional;
import zy.cloud.wms.manager.entity.Order;
+import zy.cloud.wms.manager.entity.Pakout;
import zy.cloud.wms.manager.service.OrderService;
+import zy.cloud.wms.manager.service.PakoutService;
import java.util.List;
@@ -16,11 +21,47 @@
* Created by vincent on 2021/4/22
*/
@Slf4j
-//@Component
+@Component
public class OrderScheduler {
@Autowired
private OrderService orderService;
+ @Autowired
+ private PakoutService pakoutService;
+ @Autowired
+ private JdbcTemplate jdbcTemplate;
+
+ /**
+ * 璁㈠崟杞巻鍙叉。澶勭悊鍣�
+ */
+ @Transactional
+ @Scheduled(cron = "0/10 * * * * ? ")
+ public void orderBeLogExecute(){
+ List<Order> orders = orderService.selectList(new EntityWrapper<Order>().in("settle", 3, 6));
+ for (Order order : orders) {
+ // 淇濆瓨璁㈠崟鍘嗗彶妗�
+ int saveOrderLog = jdbcTemplate.update("insert into man_order_log select * from man_order where id=" + order.getId());
+ if (saveOrderLog == 0) {
+ throw new CoolException("淇濆瓨璁㈠崟鍘嗗彶妗ｅけ璐�");
+ }
+ // 淇濆瓨璁㈠崟鏄庣粏鍘嗗彶妗�
+ int saveOrderDetlLog = jdbcTemplate.update("insert into man_order_detl_log select * from man_order_detl where order_id=" + order.getId());
+ if (saveOrderDetlLog == 0) {
+ throw new CoolException("淇濆瓨璁㈠崟鏄庣粏鍘嗗彶妗ｅけ璐�");
+ }
+ // 鍒犻櫎璁㈠崟
+ int delOrder = jdbcTemplate.update("delete from man_order where id=" + order.getId());
+ if (delOrder == 0) {
+ throw new CoolException("鍒犻櫎璁㈠崟澶辫触");
+ }
+ // 鍒犻櫎璁㈠崟鏄庣粏
+ int delOrderDetl = jdbcTemplate.update("delete from man_order_detl where order_id=" + order.getId());
+ if (delOrderDetl == 0) {
+ throw new CoolException("鍒犻櫎璁㈠崟鏄庣粏澶辫触");
+ }
+ }
+
+ }
/**
* 鍙栨秷璁㈠崟澶勭悊鍣�
@@ -30,11 +71,16 @@
public void cancelOrderExecute(){
List<Order> cancelOrders = orderService.selectList(new EntityWrapper<Order>().eq("settle", 5));
for (Order order : cancelOrders) {
-
-
-
- if (!orderService.updateSettle(order.getOrderNo(), 3L)) {
- throw new CoolException("淇敼璁㈠崟鐘舵�佸け璐�");
+ if (!pakoutService.delete(new EntityWrapper<Pakout>().eq("doc_num", order.getOrderNo()))) {
+ throw new CoolException("鍒犻櫎鎷ｈ揣鍗曞け璐�");
+ }
+ // 鍙栨秷閿�鍞鍗�
+ List<Pakout> pakouts = pakoutService.selectList(new EntityWrapper<Pakout>().eq("doc_num", order.getOrderNo()));
+ if (Cools.isEmpty(pakouts)){
+ // 淇敼鍗曟嵁鐘舵��
+ if (!orderService.updateSettle(order.getOrderNo(), 3L)) {
+ throw new CoolException("淇敼鍗曟嵁鐘舵�佸け璐�");
+ }
}
}
--
Gitblit v1.9.1