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