From 63b27a3ade03b0214c90a2b5ca71b12380b20832 Mon Sep 17 00:00:00 2001
From: ZengTao <2773468879@qq.com>
Date: 星期四, 21 十二月 2023 16:43:57 +0800
Subject: [PATCH] 修改终止进出片方法

---
 springboot-vue3/src/main/java/com/example/springboot/controller/HomeController.java |   93 +++++++++++++++++++++++++---------------------
 1 files changed, 51 insertions(+), 42 deletions(-)

diff --git a/springboot-vue3/src/main/java/com/example/springboot/controller/HomeController.java b/springboot-vue3/src/main/java/com/example/springboot/controller/HomeController.java
index a8fcacd..ff84539 100644
--- a/springboot-vue3/src/main/java/com/example/springboot/controller/HomeController.java
+++ b/springboot-vue3/src/main/java/com/example/springboot/controller/HomeController.java
@@ -22,6 +22,7 @@
 import com.example.springboot.service.OutSliceServive;
 import com.example.springboot.service.PermissionService;
 import com.example.springboot.service.SpianService;
+import com.example.springboot.service.StorageCageService;
 
 import cn.hutool.core.util.StrUtil;
 
@@ -30,6 +31,7 @@
 import com.example.springboot.component.S7control;
 import com.example.springboot.entity.CarPosition;
 import com.example.springboot.entity.StorageCage;
+import com.example.springboot.entity.StorageTask;
 import com.example.springboot.entity.User;
 import com.example.springboot.entity.alarmmg;
 import com.example.springboot.entity.north_glass_buffer1;
@@ -46,6 +48,7 @@
 @RequestMapping("/home")
 public class HomeController {
   @Autowired
+ 
   HomeMapper homeMapper;
 
   @Autowired
@@ -61,6 +64,9 @@
   OutSliceServive outSliceServive;
 
   @Autowired
+  StorageCageService storageCageService;
+
+  @Autowired
   North_Glass_Buffer1Service north_Glass_Buffer1Service;
 
   @Autowired
@@ -68,7 +74,7 @@
 
   // 鑾峰彇褰撳墠鐧诲綍鐢ㄦ埛鏉冮檺
   @GetMapping("/SelectPermissionByUserName")
-  public Result SelectPermissionByUserName(String username) {
+  public Result SelectPermissionByUserName(String username) throws SQLException {
     Map<String, Object> map = new HashMap<>();
     List<RolePermission> permission = homeMapper.SelectPermissionByUserName(username);
     map.put("permission", permission);
@@ -78,6 +84,8 @@
   // 鏌ヨ鐞嗙墖绗间娇鐢ㄦ儏鍐�
   @GetMapping("/load")
   public Result selectAll() {
+    // storageCageService.EndTask(1);
+    // UpdateTask(2,0,"X12345610402GV");
     List<StorageCage> storageCagelist = homeMapper.selectAll();
     Map<String, Object> map = new HashMap<>();
     map.put("list", storageCagelist);
@@ -136,20 +144,21 @@
     return Result.success(map);
   }
 
-  // 鎵嬪姩瀹屾垚杩�/鍑虹墖浠诲姟
+  // 鎵嬪姩瀹屾垚杩�/鍑虹墖浠诲姟 缁堟杩涚墖/鍑虹墖浠诲姟
   @GetMapping("/UpdateTask")
   public Result UpdateTask(Integer types, Integer shelfrack, String glassid) {
+    storageCageService.UpdateTask(types, shelfrack, glassid);
     Map<String, Object> map = new HashMap<>();
-    homeMapper.UpdateTask(types);
-    StorageCage glass = homeMapper.SelectGlassInfo(glassid);
-    if (types == 0) {
-      homeMapper.UpdateCageTask1(glassid);
-      S7control.getinstance().WriteWord("DB105.14", (short) 0);
-    } else {
-      spianMapper.UpdataOutCage1(glass.getGlassWidth(), glass.getCage(), glass.getCell());
-      homeMapper.UpdateCageTask2(glassid);
-      S7control.getinstance().WriteWord("DB105.12", (short) 0);
-    }
+    map.put("message3", "200");
+    return Result.success(map);
+  }
+
+  //缁堟杩涚墖/鍑虹墖浠诲姟
+  @GetMapping("/EndTask")
+  public Result EndTask(int types) {
+    storageCageService.EndTask(types);
+     
+    Map<String, Object> map = new HashMap<>();
     map.put("message3", "200");
     return Result.success(map);
   }
@@ -175,9 +184,7 @@
   // 鎵嬪姩鍒犻櫎鐞嗙墖绗肩幓鐠�
   @GetMapping("/DeleteByGlassID")
   public Result DeleteByGlassID(String glassid) {
-    StorageCage glassinfor = homeMapper.SelectGlassInfo(glassid);
-    spianMapper.UpdataOutCage1(glassinfor.getGlassWidth(), glassinfor.getCage(), glassinfor.getCell());
-    homeMapper.DeleteByGlassID(glassid);
+    outSliceServive.DeleteByGlassIDs(glassid);
     Map<String, Object> map = new HashMap<>();
     map.put("message3", "200");
     return Result.success(map);
@@ -186,6 +193,7 @@
   // 鏍规嵁鐜荤拑id鎵嬪姩鍑虹墖
   @GetMapping("/OutByGlassID")
   public Result OutByGlassID(String glassid) throws SQLException {
+
     Map<String, Object> map = new HashMap<>();
     Out_slice result = homeMapper.SelectQueueByglassid(glassid);
     if (result == null) {
@@ -197,16 +205,17 @@
           int sequence = homeMapper.SelectMaxSquence();
           homeMapper.AddOutSliceS(glassid, flip, north_glass_buffer1.getFrameBarcode(),
               north_glass_buffer1.getglasslengthmm().toString(), north_glass_buffer1.getglassheightmm().toString(),
-              sequence, position);
+              sequence, position, (short) 0, north_glass_buffer1.getordernumber(), north_glass_buffer1.getlistnumber(),
+              north_glass_buffer1.getboxnumber(), north_glass_buffer1.getglasslength().toString(),
+              north_glass_buffer1.getglassheight().toString());
+
           map.put("message2", "200");
         } else {
           map.put("message2", "300");
         }
-
       } else {
         map.put("message2", "400");
       }
-
     } else {
       map.put("message2", "500");
     }
@@ -256,11 +265,17 @@
   public Result Inglassid(short cage, short cell, short tier, @RequestBody Queue queue) {
     Map<String, Object> map = new HashMap<>();
     short result = homeMapper.SelectStorageByGlassId(queue.getglassId());
-    if (result > 0) {
-      map.put("message", "300");
+    Double cagewidth = homeMapper.SelectCageWidth(cage, cell);
+    if (cagewidth - queue.getglasswidth() - 400 < 0 || (cagewidth == 2750 && queue.getglasswidth() > cagewidth)) {
+      map.put("message", "400");
     } else {
-      homeMapper.Inglassid(queue, cage, cell, tier);
-      spianMapper.UpdataAddCage1(queue.getglasswidth(), cage, cell);
+      if (result > 0) {
+        map.put("message", "300");
+      } else {
+        homeMapper.Inglassid(queue, cage, cell, tier);
+        spianMapper.UpdataAddCage1(queue.getglasswidth(), cage, cell);
+        map.put("message", "200");
+      }
     }
     return Result.success(map);
   }
@@ -283,8 +298,10 @@
       map.put("message", "300");
     } else {
       homeMapper.InsertQueueGlassId(queue, id);
-      // 璋冪敤浼嶅瓨鍌ㄨ繃绋�
-      spianService.selectAll(queue.getglassId());
+      if (id == 1) {
+        // 璋冪敤浼嶅瓨鍌ㄨ繃绋�
+        spianService.selectAll(queue.getglassId());
+      }
       map.put("message", "200");
     }
     return Result.success(map);
@@ -328,26 +345,11 @@
     return Result.success(map);
   }
 
-  // 鏌ヨ鍑虹墖闃熷垪鏁版嵁
-  @PostMapping("/SelectProductionqueue")
-  public Result SelectProductionqueue() throws SQLException {
-    List<Out_slice> listoutslice = homeMapper.SelectProductionqueue();
-    for (Out_slice out_slice : listoutslice) {
-      out_slice
-          .setnorth_glass_buffer1s(jdbcConnections.SelectGlassByGlassIdOrderIdFrameId(out_slice.getGlassId(), "", ""));
-      out_slice.setstorageCage(homeMapper.SelectStorageGlassById(out_slice.getGlassId()));
-    }
-    Map<String, Object> maps = new HashMap<>();
-    maps.put("listoutslice", listoutslice);
-    // Plchome.isAllowQueue=false;
-    return Result.success(maps);
-
-  }
-
-  // 鏍规嵁鐜荤拑id鍒犻櫎鍑虹墖闃熷垪鐜荤拑
+  // 鏍规嵁閾濇id鍒犻櫎鍑虹墖闃熷垪鐜荤拑
   @PostMapping("/DeleteProductionQueueGlass")
   public Result DeleteProductionQueueGlass(String FrameNo) {
-    homeMapper.DeleteProductionQueueGlass(FrameNo);
+    homeMapper.CompleteQueueByFrameNo(FrameNo);
+
     Map<String, Object> map = new HashMap<>();
     map.put("message", "200");
     return Result.success(map);
@@ -384,4 +386,11 @@
     map.put("message", "200");
     return Result.success(map);
   }
+
+  // 鎵嬪姩瀹屾垚浠诲姟
+  @PostMapping("/CompleteQueue")
+  public Result CompleteQueue(String id, String frameid, String glassid) {
+    return outSliceServive.CompleteQueue(id, frameid, glassid);
+  }
+
 }

--
Gitblit v1.8.0