From 6bf8a537012962b8eb7daef698da1cc46b8310f6 Mon Sep 17 00:00:00 2001
From: wu <731351411@qq.com>
Date: 星期一, 11 九月 2023 09:52:49 +0800
Subject: [PATCH] Merge branch 'master' of ssh://10.153.19.150:29418/CanadaMes

---
 springboot-vue3/src/main/java/com/example/springboot/component/WebSocketServer.java |    1 
 CanadaMes-ui/src/views/home/index.vue                                               |   66 ++++++++++++++-------
 springboot-vue3/src/main/java/com/example/springboot/entity/alarmmg.java            |   11 +++
 springboot-vue3/src/main/java/com/example/springboot/component/Plcstate.java        |   19 +++--
 springboot-vue3/src/main/java/com/example/springboot/component/Plcalarm.java        |    8 ++
 springboot-vue3/src/main/java/com/example/springboot/component/Plcsign.java         |    3 +
 springboot-vue3/src/main/java/com/example/springboot/entity/StorageCage.java        |    8 +-
 springboot-vue3/src/main/java/com/example/springboot/component/Plchome.java         |   31 ++++------
 springboot-vue3/src/main/java/com/example/springboot/mapper/HomeMapper.java         |    4 
 springboot-vue3/src/main/java/com/example/springboot/controller/HomeController.java |    8 ++
 10 files changed, 100 insertions(+), 59 deletions(-)

diff --git a/CanadaMes-ui/src/views/home/index.vue b/CanadaMes-ui/src/views/home/index.vue
index 7900d17..6695ee4 100644
--- a/CanadaMes-ui/src/views/home/index.vue
+++ b/CanadaMes-ui/src/views/home/index.vue
@@ -59,36 +59,36 @@
 }
 
 .gezi {
-    height: 25px;
-    width: 3.25px;
+    height: 35px;
+    width: 4.22px;
 }
 
 .gezi:nth-child(22),
 .gezi:nth-child(43),
 .gezi:nth-child(64),
 .gezi:nth-child(85) {
-    margin-left: 7.7px;
+    margin-left: 10px;
 }
 
 
 
 .blocks {
-    min-height: 49vh;
+    min-height: 55vh;
     max-width: 100vw;
     background-image: url('../../img/xmjc.png');
     margin: 0 auto;
     background-repeat: no-repeat;
     /* background-size: 100% 100%; */
-    background-size: 1280px 377px;
+    background-size: 1660px 560px;
     background-attachment: local;
-    width: 1280px;
+    width: 1660px;
 }
 
 .blocks-img {
     height: 100px;
     max-width: 100vw;
     background-repeat: no-repeat;
-    background-size: 32px 66px;
+    background-size: 46px 94px;
     background-attachment: local;
     width: 32px;
 
@@ -142,7 +142,7 @@
     <el-container>
         <!-- <el-header style="padding: 10px;"></el-header> -->
         <el-main>
-            <div class="box">
+            <div class="box" @click="dialogFormVisible2 = true">
                 <div class="text">
                     Alarm:
                     <label v-for="item in this.alarm" :key="item['id']">
@@ -162,7 +162,7 @@
                     <el-table-column prop="glassId" label="Coming out glass ID"></el-table-column>
                     <el-table-column :width="250" prop="cell" label="The Grille number being used"></el-table-column>
                     <el-table-column prop="orderId" label="Order Nmuber"></el-table-column>
-                    <el-table-column prop="lengthwidth" label="Length and width"></el-table-column>
+                    <el-table-column prop="lengthWidth" label="Length and width"></el-table-column>
                     <el-table-column prop="coating" label="coating"></el-table-column>
                     <el-table-column label="Operate">
                         <el-button type="primary" style="padding: 4px 10px;font-size: 12px;" @click="endtask(0)">end
@@ -173,7 +173,7 @@
                     <el-table-column prop="glassId" label="Incoming glass ID"></el-table-column>
                     <el-table-column :width="250" prop="cell" label="The Grille number being used"></el-table-column>
                     <el-table-column prop="orderId" label="Order Nmuber"></el-table-column>
-                    <el-table-column prop="lengthwidth" label="Length and width"></el-table-column>
+                    <el-table-column prop="lengthWidth" label="Length and width"></el-table-column>
                     <el-table-column prop="coating" label="coating"></el-table-column>
                     <el-table-column label="Operate">
                         <el-button type="primary" style="padding: 4px 10px;font-size: 12px;" @click="endtask(1)">end
@@ -196,22 +196,22 @@
         </el-main>
         <el-footer>
             <div class="blocks" style="position: relative;">
-                <div style="display:flex;position: absolute;float:left;z-index: 999;top:76px;left:253px;">
+                <div style="display:flex;position: absolute;float:left;z-index: 999;top:112px;left:328px;">
                     <div :class="getStatusClass(item.state)" v-for="item in cagelist1" :key="item['date']"></div>
                 </div>
-                <div style="display:flex;position: absolute;float:left;z-index: 999;top:76px;left:682.5px;">
+                <div style="display:flex;position: absolute;float:left;z-index: 999;top:112px;left:885px;">
                     <div :class="getStatusClass(item.state)" v-for="item in cagelist2" :key="item['date']"></div>
                 </div>
-                <div style="display:flex;position: absolute;float:left;z-index: 999;top:102px;left:253px;">
+                <div style="display:flex;position: absolute;float:left;z-index: 999;top:154px;left:328px;">
                     <div :class="getStatusClass(item.state)" v-for="item in cagelist3" :key="item['date']"></div>
                 </div>
-                <div style="display:flex;position: absolute;float:left;z-index: 999;top:102px;left:682.5px;">
+                <div style="display:flex;position: absolute;float:left;z-index: 999;top:154px;left:885px;">
                     <div :class="getStatusClass(item.state)" v-for="item in cagelist4" :key="item['date']"></div>
                 </div>
-                <div class="blocks-img" :style="{ left: car1 + 'px', top: '10px' }">
+                <div class="blocks-img" :style="{ left: car1 + 'px', top: '16px' }">
 
                 </div>
-                <div class="blocks-img" :style="{ left: car2 + 'px', top: '129px' }">
+                <div class="blocks-img" :style="{ left: car2 + 'px', top: '194px' }">
 
                 </div>
             </div>
@@ -254,6 +254,15 @@
                 </span>
             </template>
         </el-dialog>
+        <el-dialog :visible.sync="dialogFormVisible2" title="Ordering Information">
+            <el-table :data="this.alarm" border style="width: 100%;">
+                <el-table-column prop="id" label="id"></el-table-column>
+                <el-table-column prop="content" label="content"></el-table-column>
+                <el-table-column prop="timeons" label="timeon"></el-table-column>
+
+                <el-table-column prop="endTime" label="endTime"></el-table-column>
+            </el-table>
+        </el-dialog>
     </el-container>
 </template>
   
@@ -261,13 +270,16 @@
 
 import { home, home2, loadtask, InsertOrder, Addglassid, UpdateTask, SelectAlarmmgInfo } from "../../api/home";
 
+import LanguageMixin from '../../lang/LanguageMixin'
 let socket;
 export default {
     name: "Home",
     data() {
         return {
+            mixins: [LanguageMixin],
             dialogFormVisible: false,
             dialogFormVisible1: false,
+            dialogFormVisible2: false,
             form: {
                 orderno: "NG2210210",
                 length: 800,
@@ -291,8 +303,8 @@
             order: "",
             glassid: "",
             url: "../../img/bigcar01.png",
-            car1: 116,
-            car2: 187,
+            car1: 150,
+            car2: 242,
             incell: "",
             outcell: ""
         };
@@ -309,7 +321,6 @@
                 console.log("鎮ㄧ殑娴忚鍣ㄤ笉鏀寔WebSocket");
             } else {
                 //console.log("鎮ㄧ殑娴忚鍣ㄦ敮鎸乄ebSocket");
-
                 let socketUrl = "ws://" + "localhost:8888" + "/springboot-vue3/api/talk/" + viewname;
                 if (socket != null) {
                     socket.close();
@@ -326,10 +337,9 @@
 
                     //console.log("鏀跺埌鏁版嵁====" + msg.data);
                     let obj = JSON.parse(msg.data);
-                    //this.$set(this.record.params, 0, obj.params[0]);
 
-                    this.car1 = 116 + 18.88 * obj.params[0][0];
-                    this.car2 = 187 + 18.8 * obj.params[0][1];
+                    this.car1 = 150 + 24.6 * obj.params[0][0];
+                    this.car2 = 242 + 24.6 * obj.params[0][1];
                     this.tableData = obj.tableData[0];
                     this.cagelist1 = obj.cagelist1[0];
                     this.cagelist2 = obj.cagelist2[0];
@@ -401,7 +411,7 @@
         //鏍规嵁鏍煎瓙鐘舵�佷慨鏀归鑹�
         getStatusClass(state) {
             if (state == 0) {
-                return "green gezi";
+                return "gezi";
             } else if (state == 1) {
                 return "blue gezi";
             } else if (state == 2) {
@@ -487,6 +497,16 @@
             }
 
 
+        },
+        formatDate(timestamp) {
+            const date = new Date(timestamp);
+            const year = date.getFullYear();
+            const month = date.getMonth() + 1;
+            const day = date.getDate();
+            const hours = date.getHours();
+            const minutes = date.getMinutes();
+            const seconds = date.getSeconds();
+            return `${year}-${month}-${day} ${hours}:${minutes}:${seconds}`;
         }
 
     }
diff --git a/springboot-vue3/src/main/java/com/example/springboot/component/Plcalarm.java b/springboot-vue3/src/main/java/com/example/springboot/component/Plcalarm.java
index d391d59..91b1802 100644
--- a/springboot-vue3/src/main/java/com/example/springboot/component/Plcalarm.java
+++ b/springboot-vue3/src/main/java/com/example/springboot/component/Plcalarm.java
@@ -21,6 +21,11 @@
 
       List<Boolean> plclist = S7control.getinstance().ReadBits("DB104.DBx0.0", 40);
 
+      if(plclist==null){
+
+      }else{
+
+      
       JSONObject jsonObject = new JSONObject();
 
       jsonObject.append("params", plclist);
@@ -84,9 +89,10 @@
         if (shuzu1[i] == 1 && result == 0) {
           // alarmMapper.Insertalarm(shuzu[i]);
         } else if (shuzu1[i] == 0 && result > 0) {
-          alarmMapper.updatealarm(shuzu[i]);
+          // alarmMapper.updatealarm(shuzu[i]);
         }
       }
     }
+    }
   }
 }
\ No newline at end of file
diff --git a/springboot-vue3/src/main/java/com/example/springboot/component/Plchome.java b/springboot-vue3/src/main/java/com/example/springboot/component/Plchome.java
index c6ce249..026cace 100644
--- a/springboot-vue3/src/main/java/com/example/springboot/component/Plchome.java
+++ b/springboot-vue3/src/main/java/com/example/springboot/component/Plchome.java
@@ -2,9 +2,9 @@
 
 import cn.hutool.json.JSONObject;
 
+import java.util.ArrayList;
 import java.util.List;
 
-import org.springframework.context.ConfigurableApplicationContext;
 
 import com.example.springboot.entity.StorageCage;
 import com.example.springboot.entity.alarmmg;
@@ -25,6 +25,7 @@
 
             JSONObject jsonObject = new JSONObject();
             
+            //娉ㄥ叆mapper
             homeMapper = WebSocketServer.applicationContext.getBean(HomeMapper.class);
             // 绗煎瓙浣跨敤鎯呭喌
             List<StorageCage> tableData = homeMapper.selectAll();
@@ -46,27 +47,21 @@
             //鏌ヨ鎶ヨ淇℃伅
             List<alarmmg> alarmmg=homeMapper.SelectAlarmmgInfo();
             jsonObject.append("alarmmg", alarmmg);
-            //璇诲幓Plc杩涚墖杞︿笌鍑虹墖杞︿綅缃�
-            // List<String> addressList = new ArrayList<>();
-            // addressList.add("DB100.DBW0");
-            // addressList.add("DB100.DBW2");
-            // List<Short> paramlist = S7control.getinstance().ReadWord(addressList);
-            // jsonObject.append("params", paramlist);
-
-            jsonObject.append("params", new short[] { 30, 40, });
+            //璇诲幓Plc杩涚墖杞︿笌鍑虹墖杞︿綅缃甒
+            List<String> addressList = new ArrayList<String>();
+            addressList.add("DB105.DBW0");
+            addressList.add("DB105.DBW12");
+            List<Short> paramlist = S7control.getinstance().ReadWord(addressList);
+            //灏嗛泦鍚堣浆涓烘暟缁�
+            if(paramlist!=null){
+                Short[] paramlists = paramlist.toArray(new Short[0]);
+                jsonObject.append("params", paramlists);
+            }
+            // jsonObject.append("params", new short[] { 30, 40, });
             WebSocketServer sendwServer = WebSocketServer.sessionMap.get("Home");
-
             if (sendwServer != null) {
                 sendwServer.sendMessage(jsonObject.toString());
             }
-
-            // JSONObject jsonObject = new JSONObject();
-            // jsonObject.append("params", new short[] { 0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10,
-            // 11, });
-            // WebSocketServer sendwServer = WebSocketServer.sessionMap.get("Home");
-            // if (sendwServer != null) {
-            // sendwServer.sendMessage(jsonObject.toString());
-            // }
 
         }
     }
diff --git a/springboot-vue3/src/main/java/com/example/springboot/component/Plcsign.java b/springboot-vue3/src/main/java/com/example/springboot/component/Plcsign.java
index b641602..4fd48c7 100644
--- a/springboot-vue3/src/main/java/com/example/springboot/component/Plcsign.java
+++ b/springboot-vue3/src/main/java/com/example/springboot/component/Plcsign.java
@@ -16,7 +16,9 @@
       }
 
       List<Boolean> plclist = S7control.getinstance().ReadBits("DB102.DBX0.0", 58);
+      if(plclist==null){
 
+      }else{
       JSONObject jsonObject = new JSONObject();
       // jsonObject3.append("sig",
       // new short[] { 0, 0, 0, 0, 1, 0, 1, 0, 1, 0, 1, 0, 1, 0, 1, 0, 1, 0, 1, 0, 1,
@@ -30,5 +32,6 @@
       }
 
     }
+    }
   }
 }
diff --git a/springboot-vue3/src/main/java/com/example/springboot/component/Plcstate.java b/springboot-vue3/src/main/java/com/example/springboot/component/Plcstate.java
index b3556f7..478a339 100644
--- a/springboot-vue3/src/main/java/com/example/springboot/component/Plcstate.java
+++ b/springboot-vue3/src/main/java/com/example/springboot/component/Plcstate.java
@@ -16,16 +16,19 @@
       }
 
       List<Short> plclist = S7control.getinstance().ReadWord("DB103.DBW0", 10);
+      if (plclist == null) {
 
-      JSONObject jsonObject = new JSONObject();
-      // jsonObject.append("sta",
-      // new short[] { 1, 0, 1, 0, 1, 0, 1, 0, 1, 0, });
-      jsonObject.append("sta", plclist);
-      WebSocketServer sendwServer = WebSocketServer.sessionMap.get("State");
-      if (sendwServer != null) {
-        sendwServer.sendMessage(jsonObject.toString());
+      } else {
+        JSONObject jsonObject = new JSONObject();
+        // jsonObject.append("sta",
+        // new short[] { 1, 0, 1, 0, 1, 0, 1, 0, 1, 0, });
+        jsonObject.append("sta", plclist);
+        WebSocketServer sendwServer = WebSocketServer.sessionMap.get("State");
+        if (sendwServer != null) {
+          sendwServer.sendMessage(jsonObject.toString());
+        }
+
       }
-
     }
   }
 }
diff --git a/springboot-vue3/src/main/java/com/example/springboot/component/WebSocketServer.java b/springboot-vue3/src/main/java/com/example/springboot/component/WebSocketServer.java
index 8749b5e..ebdc697 100644
--- a/springboot-vue3/src/main/java/com/example/springboot/component/WebSocketServer.java
+++ b/springboot-vue3/src/main/java/com/example/springboot/component/WebSocketServer.java
@@ -5,7 +5,6 @@
 import java.util.Map;
 import java.util.concurrent.ConcurrentHashMap;
 
-import org.apache.catalina.core.ApplicationContext;
 import org.slf4j.Logger;
 import org.slf4j.LoggerFactory;
 
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 b7332cb..aea9709 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
@@ -8,6 +8,7 @@
 
 import com.example.springboot.mapper.HomeMapper;
 import com.example.springboot.service.HomeService;
+import com.example.springboot.service.SpianService;
 import com.example.springboot.common.Result;
 import com.example.springboot.entity.StorageCage;
 import com.example.springboot.entity.alarmmg;
@@ -22,6 +23,9 @@
 
     @Autowired
     HomeService storageRackService;
+
+    @Autowired
+    SpianService spianService;
 
     @GetMapping("/load")    
     public Result selectAll(){
@@ -69,7 +73,7 @@
     }
 
     @GetMapping("/Addglassid")
-    public Result Addglassid(Integer glassid){
+    public Result Addglassid(short glassid){
         Map<String, Object> map = new HashMap<>();
         short taskno=homeMapper.SelectOutTask();
         if(taskno>0){
@@ -77,7 +81,7 @@
         }else{
             map.put("message2","200");
             //璋冪敤浼嶄笂鐗囧嚱鏁�
-            
+            spianService.selectAll(glassid);
         }
         return Result.success(map);
     }
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 1a394d7..15321e2 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
@@ -12,7 +12,7 @@
     private Integer tier;
     private String orderId;
     private String coating;
-    private String lengthwidth;
+    private String lengthWidth;
 
     public Integer id() {
         return id;
@@ -107,10 +107,10 @@
     }
 
     public String getLengthWidth() {
-        return lengthwidth;
+        return lengthWidth;
     }
 
-    public void setLengthWidth(String lengthwidth) {
-        this.lengthwidth = lengthwidth;
+    public void setLengthWidth(String lengthWidth) {
+        this.lengthWidth = lengthWidth;
     }
 }
diff --git a/springboot-vue3/src/main/java/com/example/springboot/entity/alarmmg.java b/springboot-vue3/src/main/java/com/example/springboot/entity/alarmmg.java
index 3ddeac5..e1380ba 100644
--- a/springboot-vue3/src/main/java/com/example/springboot/entity/alarmmg.java
+++ b/springboot-vue3/src/main/java/com/example/springboot/entity/alarmmg.java
@@ -2,11 +2,14 @@
 
 import java.util.Date;
 
+
 public class alarmmg {
   private Integer id;
   private String content;
   private Date timeon;
   private Date endTime;
+
+  private String timeons;
 
   public void setid(Integer id) {
     this.id = id;
@@ -40,4 +43,12 @@
     return endTime;
   }
 
+  public void settimeons(String timeons) {
+    this.timeons = timeons;
+  }
+
+  public String gettimeons() {
+    return timeons;
+  }
+
 }
diff --git a/springboot-vue3/src/main/java/com/example/springboot/mapper/HomeMapper.java b/springboot-vue3/src/main/java/com/example/springboot/mapper/HomeMapper.java
index c0ea329..c7ec473 100644
--- a/springboot-vue3/src/main/java/com/example/springboot/mapper/HomeMapper.java
+++ b/springboot-vue3/src/main/java/com/example/springboot/mapper/HomeMapper.java
@@ -10,7 +10,7 @@
 @Mapper
 public interface HomeMapper {
   //鏌ヨ姣忎釜绗煎瓙鐨勪娇鐢ㄦ儏鍐�
-  @Select("SELECT cage,round(round(sum(state)/42,2)*100) as cell,42-sum(state) as state FROM storage_cage group by cage")
+  @Select("SELECT cage,ROUND(sum(case when state=1 or state=2 or state=3 then 1 else 0 end)/42*100) as cell,42-sum(case when state=1 or state=2 or state=3 then 1 else 0 end) as state FROM `storage_cage` group by cage")
   List<StorageCage> selectAll();
 
   // 鏌ヨ1-5绗煎唴灞傛牸瀛愮姸鎬�
@@ -62,6 +62,6 @@
   void UpdateCageTask2(@Param("cell") Integer cell);
 
   //鑾峰彇鎶ヨ淇℃伅
-  @Select("select * from alarmmg where endTime is null")
+  @Select("select id,content,timeon as timeons,endTime from alarmmg where endTime is null")
   List<alarmmg> SelectAlarmmgInfo();
 }

--
Gitblit v1.8.0