From cae5ed7160b2071033580a9eabca7ff645a0db91 Mon Sep 17 00:00:00 2001
From: ZY <zc857179121@qq.com>
Date: 星期二, 29 十月 2024 16:24:54 +0800
Subject: [PATCH] 1

---
 src/main/java/com/zy/asrs/controller/AgvMobileController.java |  223 +++++++++++++++++++++++++++++++++++++++++++++++++++++--
 1 files changed, 215 insertions(+), 8 deletions(-)

diff --git a/src/main/java/com/zy/asrs/controller/AgvMobileController.java b/src/main/java/com/zy/asrs/controller/AgvMobileController.java
index 3d35a72..1c35546 100644
--- a/src/main/java/com/zy/asrs/controller/AgvMobileController.java
+++ b/src/main/java/com/zy/asrs/controller/AgvMobileController.java
@@ -12,6 +12,8 @@
 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.*;
@@ -27,6 +29,8 @@
 @RequestMapping("agvMobile")
 public class AgvMobileController extends BaseController  {
 
+
+    private static final Logger log = LoggerFactory.getLogger(AgvMobileController.class);
     @Autowired
     private AgvMobileService agvMobileService;
     @Autowired
@@ -113,7 +117,7 @@
     }
 
     /*
-    鍚姩鍏ュ簱锛岀粍鎵� + 鐢熶骇宸ヤ綔妗�
+    鍚姩鍏ュ簱锛岀粍鎵� + 鐢熸垚宸ヤ綔妗�
     */
     @PostMapping("/start/pakin/auth")
     @Synchronized
@@ -185,7 +189,54 @@
         String matnr = params.get("matnr");
         String floor = params.get("floor");
 
-        Wrapper<AgvLocDetl> wrapper = new EntityWrapper<AgvLocDetl>().eq("matnr", matnr);
+        Wrapper<AgvLocDetl> wrapper = new EntityWrapper<AgvLocDetl>().eq("matnr", matnr).ne("process_sts",1);
+
+
+//        wrapper.eq("orderNo",orderNo);
+
+        wrapper = Cools.isEmpty(threeCode) ? wrapper.isNull("three_code") : wrapper.eq("three_code",threeCode);
+
+        if (threeCode.substring(0,2).equals(30)) {
+            wrapper.isNull("specs").or().eq("specs","").eq("floor",1);
+        }
+        List<AgvLocDetl> agvLocDetls = agvLocDetlService.selectList(wrapper);
+        List<AgvLocDetl> locDetls = new ArrayList<>();
+        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"));
+            } else {
+                // 濡傛灉鏄姞宸ュ崟 鍙湪 lev1 = 1 鏌ュ簱瀛�
+                if ("JG".equals(orderNo.substring(0,2))) {
+                    agvLocMast = agvLocMastService.selectOne(new EntityWrapper<AgvLocMast>().eq("lev1",1).eq("loc_no", agvLocDetl.getLocNo()).like("loc_no",floor));
+                } else {
+                    agvLocMast = agvLocMastService.selectOne(new EntityWrapper<AgvLocMast>().eq("loc_no", agvLocDetl.getLocNo()).like("loc_no",floor));
+                }
+            }
+
+            if (Cools.isEmpty(agvLocMast)) continue;
+            agvLocDetl.setLocSts(agvLocMast.getLocSts());
+            agvLocDetl.setLocSts$(agvLocMast.getLocSts$());
+            locDetls.add(agvLocDetl);
+        }
+
+
+        return R.ok(locDetls);
+    }
+
+    /*
+    鏌ヨ搴撳瓨 鍏ュ簱璁㈠崟涓庨攢鍞崟鍙�
+     */
+    @PostMapping("/query/locDetl/v3")
+    public R queryAgvLocDetl3(@RequestBody HashMap<String,String> params){
+
+        String orderNo = params.get("orderNo");
+        String threeCode = params.get("threeCode");
+        String matnr = params.get("matnr");
+        String floor = params.get("floor");
+
+        Wrapper<AgvLocDetl> wrapper = new EntityWrapper<AgvLocDetl>().eq("matnr", matnr).ne("process_sts",1);
+
 
 //        wrapper.eq("orderNo",orderNo);
 
@@ -215,10 +266,58 @@
     }
 
     /*
+    鏌ヨ搴撳瓨 鍏ュ簱璁㈠崟涓庨攢鍞崟鍙�
+     */
+    @PostMapping("/query/locDetl/v2")
+    public R queryAgvLocDetl2(@RequestBody HashMap<String,String> params){
+
+        String orderNo = params.get("orderNo");
+        String threeCode = params.get("threeCode");
+        String matnr = params.get("matnr");
+        String floor = params.get("floor");
+
+        OrderDetl orderDetl = orderDetlService.selectOne(new EntityWrapper<OrderDetl>().eq("order_no", orderNo).eq("three_code", threeCode).eq("matnr", matnr));
+        Wrapper<AgvLocDetl> wrapper = new EntityWrapper<AgvLocDetl>().eq("matnr", matnr);
+
+
+//        wrapper.eq("orderNo",orderNo);
+
+        wrapper = Cools.isEmpty(threeCode) ? wrapper.isNull("three_code") : wrapper.eq("three_code",threeCode);
+
+        if (threeCode.substring(0,2).equals(30)) {
+            wrapper.isNull("specs").or().eq("specs","").eq("floor",1);
+        }
+        List<AgvLocDetl> agvLocDetls = agvLocDetlService.selectList(wrapper);
+        List<AgvLocDetl> locDetls = new ArrayList<>();
+        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"));
+            } else {
+                // 濡傛灉鏄姞宸ュ崟 鍙湪 lev1 = 1 鏌ュ簱瀛�
+                if (orderDetl.getSource().equals(35)) {
+                    agvLocMast = agvLocMastService.selectOne(new EntityWrapper<AgvLocMast>().eq("lev1",1).eq("loc_no", agvLocDetl.getLocNo()).like("loc_no",floor));
+                } else {
+                    agvLocMast = agvLocMastService.selectOne(new EntityWrapper<AgvLocMast>().eq("loc_no", agvLocDetl.getLocNo()).like("loc_no",floor));
+                }
+            }
+
+            if (Cools.isEmpty(agvLocMast)) continue;
+            agvLocDetl.setLocSts(agvLocMast.getLocSts());
+            agvLocDetl.setLocSts$(agvLocMast.getLocSts$());
+            locDetls.add(agvLocDetl);
+        }
+
+
+        return R.ok(locDetls);
+    }
+
+    /*
     鐩樼偣鎺ュ彛
      */
     @PostMapping("/check/detl/v1")
     @ManagerAuth(memo = "搴撳瓨鐩樼偣")
+    @Synchronized
     public R checkLocDetl(@RequestBody HashMap<String,String> param){
 
         String locNo = param.get("locNo");
@@ -247,6 +346,7 @@
      */
     @PostMapping("/update/detl/v1")
     @ManagerAuth(memo = "绾犳搴撲綅")
+    @Synchronized
     public R updateLocDetlLocNo(@RequestBody HashMap<String,String> param){
         String locNo = param.get("locNo");
         String containerCode = param.get("containerCode");
@@ -273,9 +373,7 @@
 
 
 
-        if((!Cools.eq("F",agvLocMastByContainerCode.getLocSts())
-                && !Cools.eq("D",agvLocMastByContainerCode.getLocSts()))
-                || (!Cools.eq("F",agvLocMastByLocNo.getLocSts())
+        if((!Cools.eq("F",agvLocMastByLocNo.getLocSts())
                 && !Cools.eq("D",agvLocMastByLocNo.getLocSts()))){
 
             return R.error("搴撲綅鐘舵�佷笉涓篎鎴栬�匘锛屾棤娉曠淮鎶�");
@@ -328,7 +426,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("缁存姢鎴愬姛");
         }
 
 
@@ -369,6 +473,7 @@
     @PostMapping("/agv/v1/locMove")
     @Transactional
     @ManagerAuth(memo = "璋冩嫧鍗曚换鍔′笅鍙�")
+    @Synchronized
     public R agvLocMove(@RequestBody HashMap<String,Object> params){
         String fl = String.valueOf(params.get("floor"));
         short floor =(short)Integer.parseInt(fl.substring(0, 1));
@@ -405,6 +510,7 @@
     @PostMapping("/agv/v2/locMove")
     @Transactional
     @ManagerAuth(memo = "璋冩嫧鍗曚换鍔′笅鍙�")
+    @Synchronized
     public R agvLocMove2(@RequestBody HashMap<String,Object> params){
         Date now = new Date();
         String fl = String.valueOf(params.get("floor"));
@@ -417,6 +523,11 @@
         if (mT.equals("unAuto")) {
             moveType = "2";
             ioType = 111;
+            //int count = agvWrkMastService.selectCount(new EntityWrapper<AgvWrkMast>().eq("io_type", ioType));
+            //if (count>3){
+            //    log.equals("111浠诲姟鍫靛锛岀◢鍚庡啀璇曪紒锛侊紒褰撳墠闄愬埗鏁伴噺3鏉★紝闄愬埗鏉′欢锛歩o_type = 111");
+            //    throw new CoolException("111浠诲姟鍫靛锛岀◢鍚庡啀璇曪紒");
+            //}
         } else {
             moveType = "1";
             ioType = 108;
@@ -424,6 +535,14 @@
         for (HashMap<String, String> map : dbList) {
             String locNo = map.get("locNo");
             String barcode = map.get("suppCode");
+            AgvWrkMast source_loc_no = agvWrkMastService.selectOne(new EntityWrapper<AgvWrkMast>().eq("source_loc_no", locNo));
+            if (!Cools.isEmpty(source_loc_no)) {
+                throw new CoolException("褰撳墠搴撲綅宸茬敓鎴愪换鍔★紒");
+            }
+            AgvLocMast locMastS = agvLocMastService.selectOne(new EntityWrapper<AgvLocMast>().eq("loc_no", locNo).eq("loc_sts","F"));
+            if (Cools.isEmpty(locMastS)) {
+                throw new CoolException("褰撳墠搴撲綅闈炲湪搴撶姸鎬侊紒搴撲綅鍙�="+locNo);
+            }
             AgvWrkMast wrkMast = createWrkMast(ioType, 22L, locNo, "", barcode, now, getUserId(), 30,floor);
             // 鍚屾璋冩嫧鍗�
             List<AgvLocDetl> agvLocDetls = agvLocDetlService.selectList(new EntityWrapper<AgvLocDetl>().eq("loc_no", locNo));
@@ -441,9 +560,61 @@
                     throw new CoolException("淇濆瓨宸ヤ綔鏄庣粏澶辫触");
                 }
                 // 鏇存柊璁㈠崟
-                OrderDetl orderDetl = orderDetlService.selectOne(new EntityWrapper<OrderDetl>().eq("order_no", "DB" + agvLocDetl.getOrderNo()).eq("matnr", agvLocDetl.getMatnr()).eq("three_code",agvLocDetl.getThreeCode()));
+                OrderDetl orderDetl = orderDetlService.selectOne(new EntityWrapper<OrderDetl>().eq("source",33).eq("matnr", agvLocDetl.getMatnr()).eq("three_code",agvLocDetl.getThreeCode()));
                 orderDetl.setQty(orderDetl.getQty() + agvLocDetl.getAnfme());
-                if (!orderDetlService.update(orderDetl,new EntityWrapper<OrderDetl>().eq("order_no","DB" + agvLocDetl.getOrderNo()).eq("matnr", agvLocDetl.getMatnr()).eq("three_code",agvLocDetl.getThreeCode()))){
+                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());
+                }
+            }
+            // 鏇存柊婧愬簱浣�
+            AgvLocMast locMast = agvLocMastService.selectOne(new EntityWrapper<AgvLocMast>().eq("loc_no", locNo));
+            locMast.setLocSts("R");
+            agvLocMastService.updateById(locMast);
+        }
+        return R.ok();
+    }
+
+    @PostMapping("/agv/v3/locMove")
+    @Transactional
+    @ManagerAuth(memo = "鍥炶皟鍗曚换鍔′笅鍙�")
+    @Synchronized
+    public R agvLocMove3(@RequestBody HashMap<String,Object> params){
+        Date now = new Date();
+        List<HashMap<String,String>> dbList = (List<HashMap<String, String>>) params.get("dbList");
+        params.get("dbList");
+        for (HashMap<String, String> map : dbList) {
+            String locNo = map.get("locNo");
+            String barcode = map.get("suppCode");
+            AgvWrkMast source_loc_no = agvWrkMastService.selectOne(new EntityWrapper<AgvWrkMast>().eq("source_loc_no", locNo));
+            if (!Cools.isEmpty(source_loc_no)) {
+                throw new CoolException("褰撳墠搴撲綅宸茬敓鎴愪换鍔★紒");
+            }
+            AgvLocMast locMastS = agvLocMastService.selectOne(new EntityWrapper<AgvLocMast>().eq("loc_no", locNo).eq("loc_sts","F"));
+            if (Cools.isEmpty(locMastS)) {
+                throw new CoolException("褰撳墠搴撲綅闈炲湪搴撶姸鎬侊紒搴撲綅鍙�="+locNo);
+            }
+            AgvWrkMast wrkMast = createWrkMast(114, 22L, locNo, "", barcode, now, getUserId(), 30,1);
+            // 鍚屾璋冩嫧鍗�
+            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.setIoTime(now);
+                wrkDetl.setAppeUser(getUserId());
+                wrkDetl.setAppeTime(now);
+                wrkDetl.setModiUser(getUserId());
+                wrkDetl.setModiTime(now);
+                if (!agvWrkDetlService.insert(wrkDetl)) {
+                    throw new CoolException("淇濆瓨宸ヤ綔鏄庣粏澶辫触");
+                }
+                // 鏇存柊璁㈠崟
+                // 鍏堟煡璇㈠簱璁㈠崟鏄庣粏 鎵�灞炵殑璁㈠崟
+
+                OrderDetl orderDetl = orderDetlService.selectOne(new EntityWrapper<OrderDetl>().eq("source",36).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()))){
                     throw new CoolException("淇敼璁㈠崟鏄庣粏澶辫触锛岃鑱旂郴绠$悊鍛�"+agvLocDetl.getOrderNo()+agvLocDetl.getMatnr());
                 }
             }
@@ -458,6 +629,7 @@
     @PostMapping("/hand/control/locMove")
     @Transactional
     @ManagerAuth(memo = "鎵嬪姩搴撲綅杞Щ")
+    @Synchronized
     public R handControlLocMove(@RequestBody LocMoveParam param){
         agvMobileService.handControlLocMove(param, getUserId());
         return R.ok();
@@ -466,6 +638,7 @@
     @PostMapping("/hand/control/allocationOut")
     @Transactional
     @ManagerAuth(memo = "璋冩嫧绂诲満")
+    @Synchronized
     public R allocationOut(@RequestBody AgvMobileStartPakin param){
         agvMobileService.allocationOut(param, getUserId());
         return R.ok();
@@ -474,15 +647,38 @@
     @PostMapping("/hand/control/allocationIn")
     @Transactional
     @ManagerAuth(memo = "璋冩嫧杩涘満")
+    @Synchronized
     public R allocationIn(@RequestBody AgvMobileStartPakin param){
         agvMobileService.allocationIn(param, getUserId());
+        return R.ok();
+    }
+
+    @PostMapping("/hand/control/empOut")
+    @Transactional
+    @ManagerAuth(memo = "绌烘灦绂诲満")
+    @Synchronized
+    public R empOut(@RequestBody AgvMobileStartPakin param){
+        agvMobileService.empOut(param, getUserId());
+        return R.ok();
+    }
+
+    @PostMapping("/hand/control/empIn")
+    @Transactional
+    @ManagerAuth(memo = "绌烘灦杩涘満")
+    @Synchronized
+    public R empIn(@RequestBody AgvMobileStartPakin param){
+        agvMobileService.empIn(param, getUserId());
         return R.ok();
     }
 
     @PostMapping("/hand/control/doBack")
     @Transactional
     @ManagerAuth(memo = "绔欑偣鍥為��")
+    @Synchronized
     public R doBack(@RequestBody AgvMobileStartPakin param){
+        if (Cools.isEmpty(param)){
+            return R.error("鍙傛暟涓虹┖");
+        }
         agvMobileService.doBack(param, getUserId());
         return R.ok();
     }
@@ -490,11 +686,22 @@
     @PostMapping("/hand/control/handBack")
     @Transactional
     @ManagerAuth(memo = "杞墜鍔ㄥ洖娴�")
+    @Synchronized
     public R handBack(@RequestBody AgvMobileStartPakin param){
         agvMobileService.handBack(param, getUserId());
         return R.ok();
     }
 
+    @PostMapping("/hand/control/processed")
+    @Transactional
+    @ManagerAuth(memo = "纭鍔犲伐瀹屾垚")
+    @Synchronized
+    public R processed(@RequestBody AgvMobileStartPakin param){
+        agvMobileService.processed(param, getUserId());
+        return R.ok();
+    }
+
+
     public static void main(String[] args) {
         List<AgvLocDetl> agvLocDetls1 = new ArrayList<>();
         List<AgvLocDetl> agvLocDetls2 = new ArrayList<>();

--
Gitblit v1.9.1