From ef0a11243f8ccf842e7298ae11f028afee019e4c Mon Sep 17 00:00:00 2001
From: wuyouming666 <2265557248@qq.com>
Date: 星期一, 04 十二月 2023 09:06:39 +0800
Subject: [PATCH] Merge branch 'master' of http://10.153.19.25:10101/r/CanadaMes

---
 springboot-vue3/src/main/java/com/example/springboot/entity/OrderOut.java      |    4 +-
 CanadaMes-ui/src/views/home/index.vue                                          |   23 ++++++++++-
 springboot-vue3/src/main/java/com/example/springboot/component/PlcHold.java    |    4 +
 springboot-vue3/src/main/java/com/example/springboot/mapper/SpianMapper.java   |    7 ++-
 springboot-vue3/src/main/java/com/example/springboot/entity/Out_slice.java     |   12 +++---
 springboot-vue3/src/main/java/com/example/springboot/entity/Glass.java         |    8 ++--
 springboot-vue3/src/main/java/com/example/springboot/entity/StorageCage.java   |   32 ++++++++--------
 springboot-vue3/src/main/java/com/example/springboot/service/SpianService.java |   19 +++++----
 springboot-vue3/src/main/java/com/example/springboot/entity/StorageTask.java   |   10 ++--
 9 files changed, 72 insertions(+), 47 deletions(-)

diff --git a/CanadaMes-ui/src/views/home/index.vue b/CanadaMes-ui/src/views/home/index.vue
index e3d1e15..1a1c930 100644
--- a/CanadaMes-ui/src/views/home/index.vue
+++ b/CanadaMes-ui/src/views/home/index.vue
@@ -408,7 +408,8 @@
                 <el-table-column :width="100" prop="state" :label="$t('State')">
                     <template slot-scope='scope'>
                         {{
-                            scope.row.state == 1 ? $t('Normal') : scope.row.state == 2 ? $t('Entering') : scope.row.state == 3 ? $t('Outing') : ""
+                            scope.row.state == 1 ? $t('Normal') : scope.row.state == 2 ? $t('Entering') : scope.row.state == 3 ?
+                                $t('Outing') : ""
                         }}
                     </template>
                 </el-table-column>
@@ -807,8 +808,26 @@
                         if (this.form5.glassheight < 380 || this.form5.glasswidth < 390 || this.form5.glassheight > 1810 || this.form5.glasswidth > 2760) {
                             if (this.disabled1 == false) {
                                 this.disabled1 = true;
+                                this.$confirm(this.$t('The glass size is not within the range'), this.$t('confirm'), {
+                                    // inputType: 'password',
+                                    // inputPlaceholder: this.$t('Please enter the password'),
+                                    
+                                    confirmwidth:7000,
+                                    height:8000,
+                                    confirmButtonText: this.$t('Yes'),
+                                    cancelButtonText: this.$t('No'),
+                                    type: 'warning'
+                                }).then(() => {
+                                    this.$message.success(this.$t('Operation successful'));
+                                }).catch(() => {
+                                    this.$message({
+                                        type: 'info',
+                                        message: this.$t('Operation canceled')
+                                    });
+                                });
                                 this.$message.error(this.$t('The glass size is not within the range'));
                             }
+
                         } else {
                             this.disabled1 = false;
                         }
@@ -1047,7 +1066,7 @@
             SelectAluminumFrameInfoById(this.framebarcode).then(res => {
                 this.AluminumFrame = res.data.listAluminumFrame;
                 this.AluminumFrame.sort(function (x, y) {
-                    if(x['storageCage']!=null&&y['storageCage']!=null){
+                    if (x['storageCage'] != null && y['storageCage'] != null) {
                         return y['storageCage']['tier'] - x['storageCage']['tier'];
                     }
                 });
diff --git a/springboot-vue3/src/main/java/com/example/springboot/component/PlcHold.java b/springboot-vue3/src/main/java/com/example/springboot/component/PlcHold.java
index a94bd20..d40420e 100644
--- a/springboot-vue3/src/main/java/com/example/springboot/component/PlcHold.java
+++ b/springboot-vue3/src/main/java/com/example/springboot/component/PlcHold.java
@@ -48,7 +48,7 @@
       // // TODO Auto-generated catch block
       // e.printStackTrace(); 
       // }
-
+      //spianService.selectout2("250");
       List<Short> datas1List = S7control.getinstance().ReadWord("DB106.24", 1);// 鑾峰彇prc杩涚墖璇锋眰鏁版嵁
       List<Short> datas1ListState = S7control.getinstance().ReadWord("DB106.8", 1);// 鑾峰彇杩涚墖杞︾姸鎬�
       List<Short> datas1ListState2 = S7control.getinstance().ReadWord("DB105.16", 1);// 鑾峰彇杩涚墖杞︿换鍔℃槸鍚﹀惎鍔�
@@ -64,6 +64,7 @@
         spianMapper.Updatetask(1, 0);// 鏇存敼杩涚墖浠诲姟鐘舵�佷负1
         spianMapper.UpdatetaskOut(B01glassid.toString()); // 瀹屾垚涓婁竴娆″嚭鐗囨垨鑰呰繘鐗囦换鍔�
         spianMapper.OverOutSlice(B01glassid.toString(), 2);// 瀹屾垚鍑虹墖闃熷垪浠诲姟
+        spianMapper.UpdataGlassCage(B01glassid.toString(),0);// 娓呴櫎鍑虹墖鏍煎瓙鐜荤拑淇℃伅
         S7control.getinstance().WriteWord("DB106.60", (short) 0);// 鎭㈠B01灏忚溅搴旂瓟鏀逛负0
         System.out.println("姹囨姤鏃禕01|" + B01glassid);
 
@@ -76,6 +77,7 @@
         spianMapper.UpdateCageOver(B02glassid.toString(), 0);// 鏇存敼绗煎瓙琛ㄥ嚭鐗囩姸鎬�
         spianMapper.UpdatetaskOut(B02glassid.toString()); // 瀹屾垚涓婁竴娆″嚭鐗囨垨鑰呰繘鐗囦换鍔�
         spianMapper.OverOutSlice(B02glassid.toString(), 2);// 瀹屾垚鍑虹墖闃熷垪浠诲姟
+        spianMapper.UpdataGlassCage(B01glassid.toString(),0);// 娓呴櫎鍑虹墖鏍煎瓙鐜荤拑淇℃伅
         S7control.getinstance().WriteWord("DB106.62", (short) 0);// 鎭㈠B02灏忚溅搴旂瓟鏀逛负0
         // S7control.getinstance().WriteWord("DB105.50", (short) 1);//姹囨姤B02灏忚溅鏀跺埌
         System.out.println("姹囨姤鏃禕02|" + B02glassid);
diff --git a/springboot-vue3/src/main/java/com/example/springboot/entity/Glass.java b/springboot-vue3/src/main/java/com/example/springboot/entity/Glass.java
index 1e448ec..ab1ce6f 100644
--- a/springboot-vue3/src/main/java/com/example/springboot/entity/Glass.java
+++ b/springboot-vue3/src/main/java/com/example/springboot/entity/Glass.java
@@ -2,10 +2,10 @@
 
 public class Glass {
   private Integer id;
-  private String orderId;
-  private double width;
-  private double height;
-  private String glassId;
+  private String orderId;//璁㈠崟id
+  private double width;//瀹藉害
+  private double height;//楂樺害
+  private String glassId;//鐜荤拑id
 
   public Integer id() {
     return id;
diff --git a/springboot-vue3/src/main/java/com/example/springboot/entity/OrderOut.java b/springboot-vue3/src/main/java/com/example/springboot/entity/OrderOut.java
index 044d19b..209de27 100644
--- a/springboot-vue3/src/main/java/com/example/springboot/entity/OrderOut.java
+++ b/springboot-vue3/src/main/java/com/example/springboot/entity/OrderOut.java
@@ -4,8 +4,8 @@
 
 public class OrderOut {
     private Integer id;
-    private String orderid;
-    private Integer state;
+    private String orderid;//璁㈠崟id
+    private Integer state;//鐘舵��
     private Date modtime;
 
     public Integer id() {
diff --git a/springboot-vue3/src/main/java/com/example/springboot/entity/Out_slice.java b/springboot-vue3/src/main/java/com/example/springboot/entity/Out_slice.java
index 68256dd..258a40f 100644
--- a/springboot-vue3/src/main/java/com/example/springboot/entity/Out_slice.java
+++ b/springboot-vue3/src/main/java/com/example/springboot/entity/Out_slice.java
@@ -2,12 +2,12 @@
  
 public class Out_slice {
     private int id;
-    private String glassId;
-    private String barcode;
-    private double glasswidth;
-    private double glassheight;
-    private int state;
-    private String time;
+    private String glassId;//鐜荤拑id
+    private String barcode;//閾濇id
+    private double glasswidth;//鐜荤拑瀹�
+    private double glassheight;//鐜荤拑楂�
+    private int state;//鐘舵��
+    private String time;//鏃堕棿
  
     private north_glass_buffer1 north_glass_buffer1s;
  
diff --git a/springboot-vue3/src/main/java/com/example/springboot/entity/StorageCage.java b/springboot-vue3/src/main/java/com/example/springboot/entity/StorageCage.java
index 9cb95ce..c1ff53e 100644
--- a/springboot-vue3/src/main/java/com/example/springboot/entity/StorageCage.java
+++ b/springboot-vue3/src/main/java/com/example/springboot/entity/StorageCage.java
@@ -1,22 +1,22 @@
 package com.example.springboot.entity;
 
 public class StorageCage {
-    private Integer id;
-    private Integer prcId;
-    private String glassId;
-    private Integer cage;
-    private Integer cell;
-    private Double width;
-    private Double glasswidth;
-    private Double glassheight;
-    private Double glasswidthmm;
-    private Double glassheightmm;
-    private String state;
-    private Integer tier;
-    private String orderId;
-    private Integer disabled;
-    private String listId;
-    private String boxId;
+    private Integer id; //鑷簭id
+    private Integer prcId;//plcid
+    private String glassId;//鐜荤拑id
+    private Integer cage;//绗煎瓙鍙�
+    private Integer cell;//鏍煎瓙鍙�
+    private Double width;//鏍煎瓙瀹�
+    private Double glasswidth;//鐜荤拑瀹�
+    private Double glassheight;//鐜荤拑楂�
+    private Double glasswidthmm;//鑻卞鐜荤拑瀹�
+    private Double glassheightmm;//鑻卞鐜荤拑楂�
+    private String state;//鐘舵��
+    private Integer tier;//鍐呭鐗�
+    private String orderId;//璁㈠崟id
+    private Integer disabled;//鍋滅敤
+    private String listId;//闆嗗悎id
+    private String boxId;//绠卞瓙id
 
     private north_glass_buffer1 north_glass_buffer1s;
 
diff --git a/springboot-vue3/src/main/java/com/example/springboot/entity/StorageTask.java b/springboot-vue3/src/main/java/com/example/springboot/entity/StorageTask.java
index a1de33a..5fae01d 100644
--- a/springboot-vue3/src/main/java/com/example/springboot/entity/StorageTask.java
+++ b/springboot-vue3/src/main/java/com/example/springboot/entity/StorageTask.java
@@ -1,12 +1,12 @@
 package com.example.springboot.entity;
 
 public class StorageTask{
-    private Integer id;
-    private String taskType;
-    private String glassId;
+    private Integer id;//鑷簭
+    private String taskType;//绫诲瀷
+    private String glassId;//鐜荤拑id
     private String cataskStatege;
-    private String shelfRack;
-    private String loadrack;
+    private String shelfRack;//璧峰浣�
+    private String loadrack;//鐩爣浣�
     
 
     public Integer id() {
diff --git a/springboot-vue3/src/main/java/com/example/springboot/mapper/SpianMapper.java b/springboot-vue3/src/main/java/com/example/springboot/mapper/SpianMapper.java
index d64b361..75581e5 100644
--- a/springboot-vue3/src/main/java/com/example/springboot/mapper/SpianMapper.java
+++ b/springboot-vue3/src/main/java/com/example/springboot/mapper/SpianMapper.java
@@ -58,8 +58,11 @@
      StorageCage selectGlassCage(int cage,double width,int cage1,int cage2);
 
     //鍒犻櫎绗煎瓙淇℃伅(鍑虹墖)
-    @Update("update storage_cage as a set state=#{state},glass_id=#{glassid},order_id=#{orderid},glasswidth=0 where cage=#{cage} and cell=#{cell} and tier=#{tier};")
-    void UpdataGlassCage(String orderid,String glassid,double width,int cage,int cell,int tier,int state);
+    @Update("update storage_cage as a set state=#{state},glass_id=null,order_id=null,glasswidth=0,a.glassheight=null,a.glasswidthmm=null,a.glassheightmm=null,a.listid=null,a.boxid=null where glassid=#{glassid};")
+    void UpdataGlassCage(String glassid,int state);
+     //鏀瑰彉鐜荤拑鐘舵�佷负鍑虹墖涓�
+    @Update("update storage_cage as a set state=#{state} where glass_id=#{glassid};")        
+    void UpdataGlassCageState(String glassid,int state);
 
     //淇敼绗煎瓙淇℃伅(杩涚墖)
     @Update("update storage_cage set state=#{state},glass_id=#{glassid},order_id=#{orderid},glasswidth=#{width} where id=#{id};")
diff --git a/springboot-vue3/src/main/java/com/example/springboot/service/SpianService.java b/springboot-vue3/src/main/java/com/example/springboot/service/SpianService.java
index f5d8671..2f1045f 100644
--- a/springboot-vue3/src/main/java/com/example/springboot/service/SpianService.java
+++ b/springboot-vue3/src/main/java/com/example/springboot/service/SpianService.java
@@ -291,7 +291,7 @@
                 datas.add((short) 1);
 
                 spianMapper.UpdataOutCage1(glasswidth, cage, cell);// 澧炲姞鍘熸牸瀛愬搴�
-                spianMapper.UpdataGlassCage("", "", glasswidth, cage, cell, tier, 3);// 娓呴櫎鏍煎瓙鐜荤拑淇℃伅
+                spianMapper.UpdataGlassCageState(glassid,3);//鏇存敼绗煎瓙琛ㄧ殑鐜荤拑鐘舵��
                 spianMapper.Inserttask(1, 0, cageout.getId(), 1000, orderid);// 鏂板浠诲姟
                 S7control.getinstance().WriteWord(adddresslist, datas);// 娲惧彂鍑虹墖杞︿换鍔�
                 outmesid(glassid,"DB105.34");// 娲惧彂鍑虹墖ID
@@ -315,7 +315,7 @@
                     datas.add((short) 1);
                     spianMapper.Inserttask(1, 0,prcid, 1000, orderid);// 鏂板浠诲姟
                     spianMapper.UpdataOutCage1(glasswidth, cage, cell);// 澧炲姞鍘熸牸瀛愬搴�
-                    spianMapper.UpdataGlassCage("", "", glasswidth, cage, cell, tier, 0);// 娓呴櫎鏍煎瓙鐜荤拑淇℃伅
+                    spianMapper.UpdataGlassCageState(glassid,3);//鏇存敼绗煎瓙琛ㄧ殑鐜荤拑鐘舵��
                     //S7control.getinstance().WriteWord(adddresslist, datas);// 娲惧彂鍑虹墖杞︿换鍔�
                     //outmesid(glassid);// 娲惧彂鍑虹墖ID
                     if (pd != null) {
@@ -350,7 +350,7 @@
                         spianMapper.UpdateDBCage(ids, cage, cell,2);// 灏嗗師鏍煎瓙鏁版嵁鏇存柊鍒版柊鏍煎瓙閲�
                         spianMapper.UpdataAddCage1(glasswidth, cages, cells);// 鍑忓皯鏂版牸瀛愬搴�
                         spianMapper.UpdataOutCage1(glasswidth, cage, cell);// 澧炲姞鍘熸牸瀛愬搴�
-                        spianMapper.UpdataGlassCage("", "", glasswidth, cage, cell, 2, 3);// 娓呴櫎琚皟鎷ㄦ牸瀛愭暟鎹�
+                        spianMapper.UpdataGlassCageState(glassid,3);//鏇存敼绗煎瓙琛ㄧ殑鐜荤拑鐘舵��
                         spianMapper.Inserttask(2, 0, cageout.getId(), ids, orderid);// 鏂板璋冨害浠诲姟
                         // 浼犺緭mes鏁版嵁,鍧愭爣锛屾暟鎹�
                         S7control.getinstance().WriteWord(adddresslist, datas);// 娲惧彂鍑虹墖杞︿换鍔�
@@ -378,7 +378,7 @@
                         spianMapper.Inserttask(2, 0, cageout.getId(), ids, orderid);// 鏂板璋冨害浠诲姟
                         spianMapper.UpdataAddCage1(glasswidth, cages, cells);// 鍑忓皯鏂版牸瀛愬搴�
                         spianMapper.UpdataOutCage1(glasswidth, cage, cell);// 澧炲姞鍘熸牸瀛愬搴�
-                        spianMapper.UpdataGlassCage("", "", glasswidth, cage, cell, 2, 3);// 娓呴櫎琚皟鎷ㄦ牸瀛愭暟鎹�
+                        spianMapper.UpdataGlassCageState(glassid,3);//鏇存敼绗煎瓙琛ㄧ殑鐜荤拑鐘舵��
                         // 浼犺緭mes鏁版嵁,鍧愭爣锛屾暟鎹�
                         S7control.getinstance().WriteWord(adddresslist, datas);// 娲惧彂鍑虹墖杞︿换鍔�
 
@@ -430,7 +430,8 @@
             datas.add((short) 1);
             spianMapper.OverOutSlice(glassid, 1);//鏇存柊鍑虹墖闃熷垪浠诲姟鐘舵�佷负杩涜涓�
             spianMapper.UpdataOutCage1(glasswidth, cage, cell);// 澧炲姞鍘熸牸瀛愬搴�
-            spianMapper.UpdataGlassCage("", "", glasswidth, cage, cell, tier, 3);// 娓呴櫎鏍煎瓙鐜荤拑淇℃伅
+            spianMapper.UpdataGlassCageState(glassid,3);//鏇存敼绗煎瓙琛ㄧ殑鐜荤拑鐘舵��
+            
             spianMapper.Inserttask(1, 0, cageout.getId(), 1000, glassid);// 鏂板浠诲姟
             // int state = spianMapper.selectGlassState(cage, cell);//鑾峰彇鏍煎瓙鏁伴噺
             if (state == 2) {
@@ -452,12 +453,12 @@
                 datas.add((short) 1000);
                 datas.add((short) 1);
                 datas.add((short) 1);
-                outmesid(glassid,"DB105.34");// 娲惧彂鍑虹墖ID
                 spianMapper.OverOutSlice(glassid, 1);//鏇存柊鍑虹墖闃熷垪浠诲姟鐘舵�佷负杩涜涓�
                 spianMapper.Inserttask(1, 0, cageout.getId(), 1000, glassid);// 鏂板浠诲姟
                 spianMapper.UpdataOutCage1(glasswidth, cage, cell);// 澧炲姞鍘熸牸瀛愬搴�
-                spianMapper.UpdataGlassCage("", "", glasswidth, cage, cell, tier, 3);// 娓呴櫎鏍煎瓙鐜荤拑淇℃伅
+                spianMapper.UpdataGlassCageState(glassid,3);//鏇存敼绗煎瓙琛ㄧ殑鐜荤拑鐘舵��
                 spianMapper.OverOutSlice(glassid,2);//瀹屾垚鍑虹墖闃熷垪浠诲姟
+                outmesid(glassid,"DB105.34");// 娲惧彂鍑虹墖ID
                 S7control.getinstance().WriteWord(adddresslist, datas);// 娲惧彂鍑虹墖杞︿换鍔�
 
                 return (200);// 缁撴潫
@@ -485,7 +486,7 @@
                     spianMapper.UpdateDBCage(ids, cage, cell,2);// 灏嗗師鏍煎瓙鏁版嵁鏇存柊鍒版柊鏍煎瓙閲�
                     spianMapper.UpdataAddCage1(glasswidth, cages, cells);// 鍑忓皯鏂版牸瀛愬搴�
                     spianMapper.UpdataOutCage1(glasswidth, cage, cell);// 澧炲姞鍘熸牸瀛愬搴�
-                    spianMapper.UpdataGlassCage("", "", glasswidth, cage, cell, 2, 3);// 娓呴櫎琚皟鎷ㄦ牸瀛愭暟鎹�
+                    spianMapper.UpdataGlassCageState(glassids,3);//鏇存敼绗煎瓙琛ㄧ殑鐜荤拑鐘舵��
                     spianMapper.Inserttask(2, 0, cageout.getId(), ids, glassid);// 鏂板璋冨害浠诲姟
                     //spianMapper.Inserttask(1, 0, cageout.getId(), 1000, glassid);// 鏂板鍑虹墖浠诲姟
                     // 浼犺緭mes鏁版嵁,鍧愭爣锛屾暟鎹�
@@ -515,7 +516,7 @@
                     spianMapper.UpdateDBCage(ids, cage, cell,2);// 灏嗗師鏍煎瓙鏁版嵁鏇存柊鍒版柊鏍煎瓙閲�
                     spianMapper.UpdataAddCage1(glasswidth, cages, cells);// 鍑忓皯鏂版牸瀛愬搴�
                     spianMapper.UpdataOutCage1(glasswidth, cage, cell);// 澧炲姞鍘熸牸瀛愬搴�
-                    spianMapper.UpdataGlassCage("", "", glasswidth, cage, cell, 2, 3);// 娓呴櫎琚皟鎷ㄦ牸瀛愭暟鎹�
+                    spianMapper.UpdataGlassCageState(glassids,3);//鏇存敼绗煎瓙琛ㄧ殑鐜荤拑鐘舵��
                     // 浼犺緭mes鏁版嵁,鍧愭爣锛屾暟鎹�
                     S7control.getinstance().WriteWord(adddresslist, datas);// 娲惧彂鍑虹墖杞︿换鍔�
 

--
Gitblit v1.8.0