From f4be36f30a802e70038bde438d1689eb749032fd Mon Sep 17 00:00:00 2001
From: zhangchao <zc857179121@qq.com>
Date: 星期五, 22 十一月 2024 08:49:19 +0800
Subject: [PATCH] 采用定长的线程池,防止定时任务的异常导致大量线程被占用

---
 src/main/java/com/zy/asrs/controller/AgvMobileController.java |  151 ++++++++++++++++++++++++++++++++++++-------------
 1 files changed, 110 insertions(+), 41 deletions(-)

diff --git a/src/main/java/com/zy/asrs/controller/AgvMobileController.java b/src/main/java/com/zy/asrs/controller/AgvMobileController.java
index 48b40e8..33fae25 100644
--- a/src/main/java/com/zy/asrs/controller/AgvMobileController.java
+++ b/src/main/java/com/zy/asrs/controller/AgvMobileController.java
@@ -1,22 +1,27 @@
 package com.zy.asrs.controller;
 
+import com.alibaba.fastjson.JSON;
 import com.baomidou.mybatisplus.mapper.EntityWrapper;
 import com.baomidou.mybatisplus.mapper.Wrapper;
 import com.core.annotations.ManagerAuth;
 import com.core.common.Cools;
 import com.core.common.R;
+import com.core.common.SnowflakeIdWorker;
 import com.core.exception.CoolException;
 import com.zy.asrs.entity.*;
 import com.zy.asrs.entity.param.*;
 import com.zy.asrs.service.*;
+import com.zy.asrs.service.impl.OrderServiceImpl;
 import com.zy.common.web.BaseController;
-import io.swagger.models.auth.In;
 import lombok.Synchronized;
 import org.slf4j.Logger;
 import org.slf4j.LoggerFactory;
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.transaction.annotation.Transactional;
-import org.springframework.web.bind.annotation.*;
+import org.springframework.web.bind.annotation.PostMapping;
+import org.springframework.web.bind.annotation.RequestBody;
+import org.springframework.web.bind.annotation.RequestMapping;
+import org.springframework.web.bind.annotation.RestController;
 
 import java.util.*;
 import java.util.stream.Collectors;
@@ -27,7 +32,7 @@
  */
 @RestController
 @RequestMapping("agvMobile")
-public class AgvMobileController extends BaseController  {
+public class AgvMobileController extends BaseController {
 
 
     private static final Logger log = LoggerFactory.getLogger(AgvMobileController.class);
@@ -47,13 +52,19 @@
     private AgvWrkMastService agvWrkMastService;
     @Autowired
     private AgvWrkDetlService agvWrkDetlService;
+    @Autowired
+    private SnowflakeIdWorker snowflakeIdWorker;
+    @Autowired
+    private FlowLogService flowLogService;
+    @Autowired
+    private OrderServiceImpl orderService;
 
 
     /*
     locno锛熺粍鎵�+缁戝畾鏆傚瓨浣� 锛� 缁勬墭
      */
     @PostMapping("/comb/auth")
-    public R comb(@RequestBody CombParam combParam){
+    public R comb(@RequestBody CombParam combParam) {
         agvMobileService.comb(combParam, getUserId());
 
         return R.ok();
@@ -62,7 +73,7 @@
     //    鍐嶆鎷f枡
     @RequestMapping("/pick/again/auth")
     @ManagerAuth(memo = "鍐嶆鎷f枡")
-    public R pickAgain(@RequestBody PickParam pickParams){
+    public R pickAgain(@RequestBody PickParam pickParams) {
         agvMobileService.pickAgain(pickParams, 1l);
         return R.ok("鎷f枡鎴愬姛");
     }
@@ -71,11 +82,11 @@
     缁戝畾璐ф灦鏉$爜涓庢殏瀛樹綅
      */
     @PostMapping("/combBinging/auth")
-    public R combBinding(@RequestBody Map<String,Object> map){
+    public R combBinding(@RequestBody Map<String, Object> map) {
         String barcode = map.get("barcode").toString();
         String stationCode = map.get("stationCode").toString();
-        Short containerType = Short.valueOf(barcode.substring(0,2));
-        agvMobileService.combBinding(barcode,stationCode,containerType);
+        Short containerType = Short.valueOf(barcode.substring(0, 2));
+        agvMobileService.combBinding(barcode, stationCode, containerType);
         return R.ok("璐ф灦缁戝畾绔欑偣鎴愬姛");
     }
 
@@ -83,9 +94,9 @@
     鑾峰彇褰撳墠宸茬粦瀹氱殑杩樻病鐢熸垚宸ヤ綔妗g殑鏆傚瓨浣�
      */
     @PostMapping("/getBasDevp/auth")
-    public R getBasDevpByFloor(@RequestBody Map<String,Object> map){
+    public R getBasDevpByFloor(@RequestBody Map<String, Object> map) {
         String floor = map.get("floor").toString();
-        if("1".equals(floor) || "3".equals(floor)){
+        if ("1".equals(floor) || "3".equals(floor)) {
             return R.ok(agvMobileService.getAgvBasDevpByFloor(Integer.parseInt(floor)));
         }
         return R.error("鍙傛暟閿欒");
@@ -95,7 +106,7 @@
     鑾峰彇杈撻�佺嚎绔欑偣
      */
     @PostMapping("/getBasDevp/noCacheShelves/auth")
-    public R getBasDevpByNoCacheShelves(){
+    public R getBasDevpByNoCacheShelves() {
         return R.ok(agvBasDevpService.getBasDevpByNoCacheShelves());
     }
 
@@ -104,15 +115,15 @@
      */
     @PostMapping("/pakin/auth")
     @Synchronized
-    public R pakin(@RequestBody Map<String,Object> map){
+    public R pakin(@RequestBody Map<String, Object> map) {
         List<String> devNos = (List<String>) map.get("devNo");
 
         List<AgvBasDevp> agvBasDevpList = devNos.stream().map(devNo -> {
             return agvBasDevpService.selectById(devNo);
         }).collect(Collectors.toList());
 
-        workService.createWaitPainWrkMastStart(agvBasDevpList, getUserId(),false);
-        
+        workService.createWaitPainWrkMastStart(agvBasDevpList, getUserId(), false);
+
         return R.ok("鐢熸垚宸ヤ綔妗f垚鍔�");
     }
 
@@ -123,13 +134,14 @@
     @Synchronized
     @Transactional
     @ManagerAuth(memo = "鍚姩鍏ュ簱")
-    public R startPakin(@RequestBody AgvMobileStartPakin params){
+    public R startPakin(@RequestBody AgvMobileStartPakin params) {
+        log.info("鍚姩鍏ュ簱,{}", JSON.toJSONString(params));
         // 缁勬墭
         params.getCombParams().forEach(combParam -> {
-            agvMobileService.comb(combParam,getUserId());
+            agvMobileService.comb(combParam, getUserId());
         });
-        params.setContainerType(Short.valueOf(params.getContainerCode().substring(0,2)));
-        workService.emptyPlateIn(params.getDevNo(),params.getContainerCode(),params.getContainerType(), getUserId(),false);
+        params.setContainerType(Short.valueOf(params.getContainerCode().substring(0, 2)));
+        workService.emptyPlateIn(params.getDevNo(), params.getContainerCode(), params.getContainerType(), getUserId(), false);
 
         return R.ok("鐢熸垚宸ヤ綔妗f垚鍔�");
     }
@@ -140,11 +152,11 @@
     @PostMapping("/pakin/empty/auth")
     @Synchronized
     @ManagerAuth(memo = "绌烘澘鍏ュ簱")
-    public R pakinEmpty(@RequestBody AgvMobileStartParam params){
+    public R pakinEmpty(@RequestBody AgvMobileStartParam params) {
 
         for (AgvMobileStartParam.Pda pda : params.getPad()) {
-            pda.setContainerType(Short.valueOf(pda.getContainerCode().substring(0,2)));
-            workService.emptyPlateIn(pda.getDevNo(),pda.getContainerCode(),pda.getContainerType(), getUserId(),false);
+            pda.setContainerType(Short.valueOf(pda.getContainerCode().substring(0, 2)));
+            workService.emptyPlateIn(pda.getDevNo(), pda.getContainerCode(), pda.getContainerType(), getUserId(), false);
         }
 
         return R.ok();
@@ -156,10 +168,10 @@
     @PostMapping("/pakout/empty/auth")
     @Synchronized
     @ManagerAuth(memo = "绌烘澘鍑哄簱")
-    public R pakoutEmpty(@RequestBody AgvMobileStartParam params){
+    public R pakoutEmpty(@RequestBody AgvMobileStartParam params) {
 
         for (AgvMobileStartParam.Pda pda : params.getPad()) {
-            workService.emptyPlateOut(pda.getDevNo(),pda.getContainerType(), getUserId());
+            workService.emptyPlateOut(pda.getDevNo(), pda.getContainerType(), getUserId());
         }
 
         return R.ok();
@@ -169,7 +181,7 @@
     绌烘澘鍑哄簱璐ф灦鐮侀�夋嫨
      */
     @PostMapping("/pakout/empty/container/selector/auth")
-    public R containerType(@RequestBody HashMap<String,String> params){
+    public R containerType(@RequestBody HashMap<String, String> params) {
 
         String devNo = params.get("devNo");
         AgvBasDevp agvBasDevp = agvBasDevpService.selectById(devNo);
@@ -177,12 +189,12 @@
         return R.ok(agvLocMastService.queryContainerTypeByLocType1(agvBasDevp.getLocType1()));
 
     }
-    
+
     /*
     鏌ヨ搴撳瓨 鍏ュ簱璁㈠崟涓庨攢鍞崟鍙�
      */
     @PostMapping("/query/locDetl/v1")
-    public R queryAgvLocDetl(@RequestBody HashMap<String,String> params){
+    public R queryAgvLocDetl(@RequestBody HashMap<String, String> params) {
 
         String orderNo = params.get("orderNo");
         String threeCode = params.get("threeCode");
@@ -204,7 +216,7 @@
         for (AgvLocDetl agvLocDetl : agvLocDetls) {
             AgvLocMast agvLocMast = new AgvLocMast();
             if (Cools.isEmpty(floor)) {
-                agvLocMast = agvLocMastService.selectOne(new EntityWrapper<AgvLocMast>().eq("loc_no", agvLocDetl.getLocNo()).notLike("loc_no","F1"));
+                agvLocMast = agvLocMastService.selectOne(new EntityWrapper<AgvLocMast>().eq("loc_no", agvLocDetl.getLocNo()).notLike("loc_no", "F1"));
             } else {
                 // 濡傛灉鏄姞宸ュ崟 鍙湪 lev1 = 1 鏌ュ簱瀛�
                 if ("JG".equals(orderNo.substring(0,2))) {
@@ -369,26 +381,23 @@
         AgvLocMast agvLocMastByContainerCode = agvLocMastService.selectOne(new EntityWrapper<AgvLocMast>().eq("barcode", containerCode));
         AgvLocMast agvLocMastByLocNo = agvLocMastService.selectOne(new EntityWrapper<AgvLocMast>().eq("loc_no", locNo));
 
-        String barcode1 =  agvLocMastByLocNo.getBarcode();
+        String barcode1 = agvLocMastByLocNo.getBarcode();
 
 
-
-        if((!Cools.eq("F",agvLocMastByContainerCode.getLocSts())
-                && !Cools.eq("D",agvLocMastByContainerCode.getLocSts()))
-                || (!Cools.eq("F",agvLocMastByLocNo.getLocSts())
-                && !Cools.eq("D",agvLocMastByLocNo.getLocSts()))){
+        if ((!Cools.eq("F", agvLocMastByLocNo.getLocSts())
+                && !Cools.eq("D", agvLocMastByLocNo.getLocSts()))) {
 
             return R.error("搴撲綅鐘舵�佷笉涓篎鎴栬�匘锛屾棤娉曠淮鎶�");
 
         }
         // -------------1-----------------------------
         //搴撲綅淇℃伅涓虹┖ 璐ф灦淇℃伅涓嶄负绌�
-        if(Cools.isEmpty(listByLocNo) && !Cools.isEmpty(listByContainerCode)){
+        if (Cools.isEmpty(listByLocNo) && !Cools.isEmpty(listByContainerCode)) {
             //鏇存柊璐ф灦淇℃伅鐨勫簱浣嶄负褰撳墠搴撲綅
             listByContainerCode.forEach(agvLocDetl -> {
                 String sourceLoc = agvLocDetl.getLocNo();
                 agvLocDetl.setLocNo(locNo);
-                agvLocDetlService.updateLocNo(locNo,sourceLoc,agvLocDetl);
+                agvLocDetlService.updateLocNo(locNo, sourceLoc, agvLocDetl);
             });
 
             agvLocMastByLocNo.setLocSts("F");
@@ -400,6 +409,9 @@
                 agvLocMastByContainerCode.setBarcode(barcode1);
                 agvLocMastService.updateById(agvLocMastByContainerCode);
             }
+            // 淇濆瓨璋冩暣璁板綍
+            AdjDetl adjDetl = new AdjDetl();
+
 
             return R.ok("缁存姢鎴愬姛");
         }
@@ -428,7 +440,13 @@
         }
 
         if((listByLocNo == null && listByContainerCode == null) || listByLocNo.equals(listByContainerCode)){
-            return R.ok("璇ュ簱浣嶄笌璐ф灦搴撳瓨涓�鑷达紝鏃犻渶缁存姢");
+            //agvLocMastByContainerCode.setBarcode(agvLocMastByLocNo.getBarcode());
+            //agvLocMastService.updateById(agvLocMastByContainerCode);
+
+            agvLocMastByLocNo.setBarcode(containerCode);
+            agvLocMastService.updateById(agvLocMastByLocNo);
+            //return R.ok("璇ュ簱浣嶄笌璐ф灦搴撳瓨涓�鑷达紝鏃犻渶缁存姢");
+            return R.ok("缁存姢鎴愬姛");
         }
 
 
@@ -514,6 +532,7 @@
         List<HashMap<String,String>> dbList = (List<HashMap<String, String>>) params.get("dbList");
         params.get("dbList");
         Object mT = params.get("moveType");
+        String orderNo = params.get("orderNo").toString();
         String moveType = "";
         Integer ioType = 0;
         if (mT.equals("unAuto")) {
@@ -541,12 +560,14 @@
             }
             AgvWrkMast wrkMast = createWrkMast(ioType, 22L, locNo, "", barcode, now, getUserId(), 30,floor);
             // 鍚屾璋冩嫧鍗�
+            long flowId = snowflakeIdWorker.nextId();
             List<AgvLocDetl> agvLocDetls = agvLocDetlService.selectList(new EntityWrapper<AgvLocDetl>().eq("loc_no", locNo));
             for (AgvLocDetl agvLocDetl : agvLocDetls) {
                 AgvWrkDetl wrkDetl = new AgvWrkDetl();
                 wrkDetl.setWrkNo(wrkMast.getWrkNo());
                 wrkDetl.sync(agvLocDetl);
                 wrkDetl.setSuppCode(agvLocDetl.getSuppCode());
+                wrkDetl.setModel(orderNo);
                 wrkDetl.setIoTime(now);
                 wrkDetl.setAppeUser(getUserId());
                 wrkDetl.setAppeTime(now);
@@ -556,10 +577,48 @@
                     throw new CoolException("淇濆瓨宸ヤ綔鏄庣粏澶辫触");
                 }
                 // 鏇存柊璁㈠崟
-                OrderDetl orderDetl = orderDetlService.selectOne(new EntityWrapper<OrderDetl>().eq("source",33).eq("matnr", agvLocDetl.getMatnr()).eq("three_code",agvLocDetl.getThreeCode()));
+                OrderDetl orderDetl = orderDetlService.selectOne(new EntityWrapper<OrderDetl>().eq("order_no",orderNo).eq("source",33).eq("matnr", agvLocDetl.getMatnr()).eq("three_code",agvLocDetl.getThreeCode()));
+                // 鍒ゆ柇璁㈠崟鏄惁瓒呴噺
+                if (orderDetl.getQty() >= orderDetl.getAnfme()) {
+                    throw new CoolException("璋冩嫧鍗�:" + orderNo + "鐨�<" + agvLocDetl.getMatnr() + ">宸插畬鎴愯皟鎷ㄦ暟閲�,璇锋鏌�!");
+                }
+                //                FlowLog flowLog = new FlowLog();
+//                flowLog.setFid(String.valueOf(flowId));
+//                flowLog.setSpare2(wrkMast.getWrkNo().toString());
+//                flowLog.setLocNo(wrkMast.getSourceLocNo());
+//                flowLog.setSpare1(barcode);
+//                flowLog.setOpType(5L);
+//                flowLog.setOrderNo(orderDetl.getOrderNo());
+//                flowLog.setThreeCode(orderDetl.getThreeCode());
+//                flowLog.setMatnr(agvLocDetl.getMatnr());
+//                flowLog.setMaktx(agvLocDetl.getMaktx());
+//                flowLog.setOrderPrevious(orderDetl.getAnfme());
+//                flowLog.setOrderCurrent(orderDetl.getAnfme());
+//                flowLog.setOrderChanged(0.0);
+//
+//                flowLog.setQtyPrevious(orderDetl.getQty());
+//                flowLog.setQtyCurrent(orderDetl.getQty() + agvLocDetl.getAnfme());
+//                flowLog.setQtyChanged(agvLocDetl.getAnfme());
+//
+//                flowLog.setLocPrevious(agvLocDetl.getAnfme());
+//                flowLog.setLocCurrent(0.0d);
+//                flowLog.setLocChanged(agvLocDetl.getAnfme());
+//                flowLog.setUserId(getUserId());
+//                flowLog.setAppeTime(now);
+//                if (!flowLogService.insert(flowLog)) {
+//                    throw new CoolException("鍚屾鍗婃垚鍝佽皟鎷ㄥ崟娴佹按璁板綍澶辫触");
+//                }
                 orderDetl.setQty(orderDetl.getQty() + agvLocDetl.getAnfme());
-                if (!orderDetlService.update(orderDetl,new EntityWrapper<OrderDetl>().eq("source",33).eq("matnr", agvLocDetl.getMatnr()).eq("three_code",agvLocDetl.getThreeCode()))){
-                    throw new CoolException("淇敼璁㈠崟鏄庣粏澶辫触锛岃鑱旂郴绠$悊鍛�"+agvLocDetl.getOrderNo()+agvLocDetl.getMatnr());
+                if (!orderDetlService.update(orderDetl,new EntityWrapper<OrderDetl>().eq("order_no",orderNo).eq("source",33).eq("matnr", agvLocDetl.getMatnr()).eq("three_code",agvLocDetl.getThreeCode()))){
+                    throw new CoolException("璁㈠崟鍙凤細{"+orderNo+"}鏇存柊璁㈠崟鏄庣粏澶辫触锛� 寮傚父鐗╂枡:"+agvLocDetl.getMatnr()+"(鍗婃垚鍝佽皟鎷ㄥ崟浠诲姟)" );
+                }
+                // 鏇存柊璁㈠崟鐘舵��
+                Order order = orderService.selectByNo(orderDetl.getOrderNo());
+                Long settle = order.getSettle();
+                if (settle == 1L) {
+                    if (!orderService.updateSettle(order.getId(),2L,getUserId())) {
+                        throw new CoolException("璁㈠崟鍙凤細{"+order.getOrderNo()+"}鏇存柊璁㈠崟鐘舵�侊細1-->2 澶辫触锛�(鍗婃垚鍝佽皟鎷ㄥ崟浠诲姟)" );
+                    }
                 }
             }
             // 鏇存柊婧愬簱浣�
@@ -578,6 +637,7 @@
         Date now = new Date();
         List<HashMap<String,String>> dbList = (List<HashMap<String, String>>) params.get("dbList");
         params.get("dbList");
+        String orderNo = params.get("orderNo").toString();
         for (HashMap<String, String> map : dbList) {
             String locNo = map.get("locNo");
             String barcode = map.get("suppCode");
@@ -608,10 +668,18 @@
                 // 鏇存柊璁㈠崟
                 // 鍏堟煡璇㈠簱璁㈠崟鏄庣粏 鎵�灞炵殑璁㈠崟
 
-                OrderDetl orderDetl = orderDetlService.selectOne(new EntityWrapper<OrderDetl>().eq("source",36).eq("matnr", agvLocDetl.getMatnr()).eq("three_code",agvLocDetl.getThreeCode()));
+                OrderDetl orderDetl = orderDetlService.selectOne(new EntityWrapper<OrderDetl>().eq("order_no",orderNo).eq("source",17).eq("matnr", agvLocDetl.getMatnr()).eq("three_code",agvLocDetl.getThreeCode()));
                 orderDetl.setQty(orderDetl.getQty() + agvLocDetl.getAnfme());
-                if (!orderDetlService.update(orderDetl,new EntityWrapper<OrderDetl>().eq("source",36).eq("matnr", agvLocDetl.getMatnr()).eq("three_code",agvLocDetl.getThreeCode()))){
+                if (!orderDetlService.update(orderDetl,new EntityWrapper<OrderDetl>().eq("order_no",orderNo).eq("source",17).eq("matnr", agvLocDetl.getMatnr()).eq("three_code",agvLocDetl.getThreeCode()))){
                     throw new CoolException("淇敼璁㈠崟鏄庣粏澶辫触锛岃鑱旂郴绠$悊鍛�"+agvLocDetl.getOrderNo()+agvLocDetl.getMatnr());
+                }
+                // 鏇存柊璁㈠崟鐘舵��
+                Order order = orderService.selectByNo(orderNo);
+                Long settle = order.getSettle();
+                if (settle == 1L) {
+                    if (!orderService.updateSettle(order.getId(),2L,getUserId())) {
+                        throw new CoolException("璁㈠崟鍙凤細{"+order.getOrderNo()+"}鏇存柊璁㈠崟鐘舵�侊細1-->2 澶辫触锛�(鍗婃垚鍝佽皟鎷ㄥ崟浠诲姟)" );
+                    }
                 }
             }
             // 鏇存柊婧愬簱浣�
@@ -697,6 +765,7 @@
         return R.ok();
     }
 
+
     public static void main(String[] args) {
         List<AgvLocDetl> agvLocDetls1 = new ArrayList<>();
         List<AgvLocDetl> agvLocDetls2 = new ArrayList<>();

--
Gitblit v1.9.1