From 82c2df0968b099bd589936adc5b28c1ac4827a05 Mon Sep 17 00:00:00 2001
From: wuyouming666 <2265557248@qq.com>
Date: 星期一, 04 十二月 2023 08:20:07 +0800
Subject: [PATCH] 更新测试后电气管理

---
 springboot-vue3/src/main/java/com/example/springboot/controller/HomeController.java |   87 +++++++++++++++++--------------------------
 1 files changed, 34 insertions(+), 53 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 9e66cf1..db89bb4 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
@@ -13,12 +13,15 @@
 import com.example.springboot.service.JdbcConnections;
 import com.example.springboot.service.SpianService;
 import com.example.springboot.common.Result;
+import com.example.springboot.component.Plchome;
 import com.example.springboot.component.S7control;
 import com.example.springboot.entity.CarPosition;
 import com.example.springboot.entity.StorageCage;
 import com.example.springboot.entity.alarmmg;
 import com.example.springboot.entity.north_glass_buffer1;
 import com.example.springboot.entity.Out_slice;
+import com.example.springboot.entity.Queue;
+
 import org.springframework.web.bind.annotation.*;
 
 
@@ -61,21 +64,6 @@
     map.put("list2", storageCagelist2);
     map.put("list3", storageCagelist3);
     map.put("list4", storageCagelist4);
-    return Result.success(map);
-  }
-
-  // 鏌ヨ杩�/鍑虹墖浠诲姟
-  @GetMapping("/loadinout")
-  public Result selectinout(Integer types) throws SQLException{
-    List<StorageCage> storageCageinout = homeMapper.selectinout(types);
-    
-    for (StorageCage storageCage : storageCageinout) {
-      storageCage.setnorth_glass_buffer1s(jdbcConnections.SelectGlassByGlassIdOrderIdFrameId(storageCage.getGlassId(), "", ""));
-      // storageCage.setnorth_glass_buffer1s(homeMapper.SelectBoxNo(storageCage.getGlassId()));
-    }
-    
-    Map<String, Object> map = new HashMap<>();
-    map.put("list", storageCageinout);
     return Result.success(map);
   }
 
@@ -146,11 +134,6 @@
   @GetMapping("/SelectCageInfo")
   public Result SelectCageInfo(short cage) throws SQLException {
     List<StorageCage> cageinfo = homeMapper.SelectCageInfo(cage);
-    for (StorageCage storageCage : cageinfo) {
-      // storageCage.setnorth_glass_buffer1s(homeMapper.SelectBoxNo(storageCage.getGlassId()));
-      storageCage.setnorth_glass_buffer1s(jdbcConnections.SelectGlassByGlassIdOrderIdFrameId(storageCage.getGlassId(), "", ""));
-      
-    }
     Map<String, Object> map = new HashMap<>();
     map.put("cageinfo", cageinfo);
     return Result.success(map);
@@ -169,21 +152,17 @@
 
   // 鏍规嵁鐜荤拑id鎵嬪姩鍑虹墖
   @GetMapping("/OutByGlassID")
-  public Result OutByGlassID(String glassid) {
+  public Result OutByGlassID(String glassid) throws SQLException {
     Map<String, Object> map = new HashMap<>();
-    // 璋冪敤浼嶄笂鐗囧嚱鏁�
-    short result = homeMapper.SelectStorageByGlassId(glassid);
-    if (result > 0) {
-      Short results = spianService.selectout2(glassid);
-      if (results == 200) {
-        map.put("message2", "200");
-      } else if (results == 300) {
-        map.put("message2", "300");
-      }
+    Out_slice result = homeMapper.SelectQueueByglassid(glassid);
+    if(result==null) {
+      north_glass_buffer1 north_glass_buffer1=jdbcConnections.SelectGlassByGlassIdOrderIdFrameId(glassid, "", "");
+      String flip=jdbcConnections.SelectFlipByFrameBarcode(north_glass_buffer1.getFrameBarcode());
+      homeMapper.AddOutSliceS(glassid, flip, north_glass_buffer1.getFrameBarcode(), north_glass_buffer1.getglasslengthmm().toString(), north_glass_buffer1.getglassheightmm().toString());
+      map.put("message2", "200");
     } else {
       map.put("message2", "500");
     }
-
     return Result.success(map);
   }
 
@@ -208,14 +187,10 @@
   // 鏍规嵁鐜荤拑id鏌ヨ鐜荤拑淇℃伅
   @GetMapping("/SelectGlassByGlassID")
   public Result SelectGlassByGlassID(String glassid) throws SQLException {
-    // north_glass_buffer1 north_glass_buffer1s = homeMapper.SelectGlassByGlassID(glassid);
-    
-    north_glass_buffer1 north_glass_buffer1s=jdbcConnections.SelectGlassByGlassIdOrderIdFrameId(glassid, "", "");
+    Queue queue=jdbcConnections.SelectGlassByGlassIdOrderIdFrameIdQueue(glassid, "", "");
     Map<String, Object> map = new HashMap<>();
     if(glassid!=""){
-      
-    map.put("form", north_glass_buffer1s);
-    
+      map.put("form", queue);
     }
     return Result.success(map);
   }
@@ -231,14 +206,14 @@
 
   // 鎵嬪姩寰�鐞嗙墖绗兼坊鍔犵幓鐠�
   @PostMapping("/Inglassid")
-  public Result Inglassid(short cage, short cell, short tier, @RequestBody north_glass_buffer1 north_glass_buffer1s) {
+  public Result Inglassid(short cage, short cell, short tier, @RequestBody Queue queue) {
     Map<String, Object> map = new HashMap<>();
-    short result = homeMapper.SelectStorageByGlassId(north_glass_buffer1s.getbarcode());
+    short result = homeMapper.SelectStorageByGlassId(queue.getglassId());
     if (result > 0) {
       map.put("message", "300");
     } else {
-      homeMapper.Inglassid(north_glass_buffer1s, cage, cell, tier);
-      spianMapper.UpdataAddCage1(north_glass_buffer1s.getglasslengthmm(), cage, cell);
+      homeMapper.Inglassid(queue, cage, cell, tier);
+      spianMapper.UpdataAddCage1(queue.getglasswidth(), cage, cell);
     }
     return Result.success(map);
   }
@@ -254,15 +229,15 @@
 
   // 鎵嬪姩娣诲姞鎵爜浣嶇幓鐠�
   @PostMapping("/InsertQueueGlassId")
-  public Result InsertQueueGlassId(String glassid, Short id) {
+  public Result InsertQueueGlassId(Short id,@RequestBody Queue queue) {
     Map<String, Object> map = new HashMap<>();
-    short result = homeMapper.SelectStorageByGlassId(glassid);
+    short result = homeMapper.SelectStorageByGlassId(queue.getglassId());
     if (result > 0) {
       map.put("message", "300");
     } else {
-      homeMapper.InsertQueueGlassId(glassid, id);
+      homeMapper.InsertQueueGlassId(queue, id);
     //璋冪敤浼嶅瓨鍌ㄨ繃绋�
-    spianService.selectAll(glassid);
+    spianService.selectAll(queue.getglassId());
       map.put("message", "200");
     }
     return Result.success(map);
@@ -298,10 +273,8 @@
   // 鏍规嵁閾濇id鑾峰彇瀵瑰簲鐜荤拑淇℃伅
   @PostMapping("/SelectAluminumFrameInfoById")
   public Result SelectAluminumFrameInfoById(String FrameBarcode) throws SQLException {
-
-    // List<north_glass_buffer1> listAluminumFrame = homeMapper.SelectAluminumFrameInfoById(FrameBarcode);
-    List<north_glass_buffer1> listAluminumFrame = jdbcConnections.SelectGlassByGlassIdOrderIdFrameIds("","",FrameBarcode);
-    String flip=homeMapper.SelectFlipByFrameBarcode(FrameBarcode);
+    List<north_glass_buffer1> listAluminumFrame = jdbcConnections.SelectGlassByGlassIdOrderIdFrameIdss(FrameBarcode);
+    String flip=jdbcConnections.SelectFlipByFrameBarcode(FrameBarcode);
     for (north_glass_buffer1 north_glass_buffer1 : listAluminumFrame) {
       north_glass_buffer1.setstorageCage(homeMapper.SelectStorageGlassById(north_glass_buffer1.getbarcode()));
       north_glass_buffer1.setOut_slice(homeMapper.SelectQueueByglassid(north_glass_buffer1.getbarcode()));
@@ -312,8 +285,6 @@
     return Result.success(map);
   }
   
-  
-
   // 鏌ヨ鍑虹墖闃熷垪鏁版嵁
   @PostMapping("/SelectProductionqueue")
   public Result SelectProductionqueue() throws SQLException {
@@ -324,7 +295,9 @@
     }
     Map<String, Object> maps = new HashMap<>();
     maps.put("listoutslice", listoutslice);
+    // Plchome.isAllowQueue=false;
     return Result.success(maps);
+    
   }
 
   // 鏍规嵁鐜荤拑id鍒犻櫎鍑虹墖闃熷垪鐜荤拑
@@ -336,7 +309,7 @@
     return Result.success(map);
   }
 
-  // 
+  //娣诲姞鍑虹墖
   @PostMapping("/AddOutSliceS")
   public Result AddOutSliceS(@RequestBody String[][] AluminumFrames ) {
     for (String[] item : AluminumFrames) {
@@ -344,7 +317,15 @@
         homeMapper.AddOutSliceS(item[0],item[2],item[3],item[4],item[5]);
       }
     }
-    System.out.println(AluminumFrames);
+    Map<String, Object> map = new HashMap<>();
+    map.put("message", "200");
+    return Result.success(map);
+  }
+
+  //淇敼鍑虹墖闃熷垪鐘舵��
+  @PostMapping("/isAllowQueues")
+  public Result isAllowQueues(Boolean isAllowQueue) {
+    Plchome.isAllowQueue=isAllowQueue;
     Map<String, Object> map = new HashMap<>();
     map.put("message", "200");
     return Result.success(map);

--
Gitblit v1.8.0