From 81826e66f68a37486516ee93c4e11d92a00c3fb6 Mon Sep 17 00:00:00 2001
From: wuyouming666 <2265557248@qq.com>
Date: 星期四, 21 十二月 2023 14:43:21 +0800
Subject: [PATCH] 增加清除id调用终止出片任务

---
 springboot-vue3/src/main/java/com/example/springboot/controller/HomeController.java |  132 +++++++++++++++++++++++++++++---------------
 1 files changed, 87 insertions(+), 45 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 1f3445c..6c25db4 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
@@ -30,6 +30,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,18 +47,21 @@
 @RequestMapping("/home")
 public class HomeController {
   @Autowired
+  static
   HomeMapper homeMapper;
 
   @Autowired
   HomeService storageRackService;
 
   @Autowired
+  static
   SpianService spianService;
 
   @Autowired
   SpianMapper spianMapper;
 
   @Autowired
+  static
   OutSliceServive outSliceServive;
 
   @Autowired
@@ -68,7 +72,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);
@@ -136,20 +140,47 @@
     return Result.success(map);
   }
 
-  // 鎵嬪姩瀹屾垚杩�/鍑虹墖浠诲姟
+  // 鎵嬪姩瀹屾垚杩�/鍑虹墖浠诲姟 缁堟杩涚墖/鍑虹墖浠诲姟
   @GetMapping("/UpdateTask")
-  public Result UpdateTask(Integer types, Integer shelfrack, String glassid) {
+  public static Result UpdateTask(Integer types, Integer shelfrack, String 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);
+    if (types == 0) {// 瀹屾垚杩涚墖
+      spianService.overtask(glassid);
+    } else if (types == 1) {// 瀹屾垚鍑虹墖
+      spianService.overtask(glassid);
+    } else if (types == 2) {// 缁堟杩涚墖浠诲姟
+      outSliceServive.StopTask(glassid, 0);
+      // 鍙戦�佺粓姝㈣繘鐗囦换鍔′俊鍙�
+    } else {// 缁堟鍑虹墖浠诲姟
+      outSliceServive.StopTask(glassid, 1);
     }
+    map.put("message3", "200");
+    return Result.success(map);
+  }
+
+  //缁堟杩涚墖/鍑虹墖浠诲姟
+  @GetMapping("/EndTask")
+  public static Result EndTask(int types) {
+     if (types == 0) {// 缁堟杩涚墖浠诲姟
+      List<StorageTask> cageList = homeMapper.SelectTaskByState(types);
+      for (StorageTask storageTask : cageList) {
+        outSliceServive.StopTask(storageTask.getGlassId(), types);  
+      }
+      // 鍙戦�佺粓姝㈣繘鐗囦换鍔′俊鍙�
+    } else {// 缁堟鍑虹墖浠诲姟
+      List<StorageCage> storageCages =homeMapper.selectinout(types);
+      for (StorageCage storageCage : storageCages) {
+        List<StorageCage> storageCagess=homeMapper.SelectStoragesGlassById(storageCage.getGlassId());
+        for (StorageCage storageCagez : storageCagess) {
+          if (storageCagez.getState().equals("2")) {//璋冩嫧杩涚墖
+            outSliceServive.StopTask(storageCagez.getGlassId(), 0);
+          }else{//鍑虹墖
+            outSliceServive.StopTask(storageCagez.getGlassId(), types);
+          }
+        }
+      }
+    }
+    Map<String, Object> map = new HashMap<>();
     map.put("message3", "200");
     return Result.success(map);
   }
@@ -175,9 +206,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.DeleteByGlassID(glassid);
     Map<String, Object> map = new HashMap<>();
     map.put("message3", "200");
     return Result.success(map);
@@ -191,12 +220,25 @@
     if (result == null) {
       north_glass_buffer1 north_glass_buffer1 = jdbcConnections.SelectGlassByGlassIdOrderIdFrameId(glassid, "", "");
       String flip = jdbcConnections.SelectFlipByFrameBarcode(north_glass_buffer1.getFrameBarcode());
-      String position = jdbcConnections.SelectPositionByFrameBarcode(north_glass_buffer1.getFrameBarcode());
-      int sequence = homeMapper.SelectMaxSquence();
-      homeMapper.AddOutSliceS(glassid, flip, north_glass_buffer1.getFrameBarcode(),
-          north_glass_buffer1.getglasslengthmm().toString(), north_glass_buffer1.getglassheightmm().toString(),
-          sequence, position);
-      map.put("message2", "200");
+      if (flip != null) {
+        String position = jdbcConnections.SelectPositionByFrameBarcode(north_glass_buffer1.getFrameBarcode());
+        if (position != null) {
+          int sequence = homeMapper.SelectMaxSquence();
+
+          homeMapper.AddOutSliceS(glassid, flip, north_glass_buffer1.getFrameBarcode(),
+              north_glass_buffer1.getglasslengthmm().toString(), north_glass_buffer1.getglassheightmm().toString(),
+              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");
     }
@@ -246,11 +288,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);
   }
@@ -273,8 +321,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);
@@ -318,26 +368,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);
@@ -374,4 +409,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