From f59d1cd5a51e6e1dea40b7253e16cac9f949fc30 Mon Sep 17 00:00:00 2001
From: wu <731351411@qq.com>
Date: 星期五, 03 十一月 2023 15:18:09 +0800
Subject: [PATCH] 增加玻璃表

---
 springboot-vue3/src/main/java/com/example/springboot/component/Plchome.java |   91 ++++++++++++++++++++++++++++++++-------------
 1 files changed, 65 insertions(+), 26 deletions(-)

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 6450dc5..06a6a0f 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,68 +2,107 @@
 
 import cn.hutool.json.JSONObject;
 
+import java.util.ArrayList;
+import java.util.HashMap;
 import java.util.List;
+import java.util.Map;
 
-import org.springframework.context.ConfigurableApplicationContext;
+import org.springframework.web.bind.annotation.PostMapping;
 
+import com.example.springboot.common.Result;
+import com.example.springboot.entity.Glass;
 import com.example.springboot.entity.StorageCage;
+import com.example.springboot.entity.alarmmg;
 import com.example.springboot.mapper.HomeMapper;
+import com.example.springboot.mapper.SpianMapper;
+import com.example.springboot.service.JdbcConnections;
 
 public class Plchome extends Thread {
 
     private HomeMapper homeMapper;
+    private SpianMapper spianMapper;
+    private JdbcConnections dbserve;
 
     @Override
     public void run() {
         while (this != null) {
             try {
-                Thread.sleep(10000);
+                Thread.sleep(1000);
             } catch (InterruptedException e) {
                 e.printStackTrace();
             }
-
             JSONObject jsonObject = new JSONObject();
-            
+
+            // 娉ㄥ叆mapper
             homeMapper = WebSocketServer.applicationContext.getBean(HomeMapper.class);
+            spianMapper = WebSocketServer.applicationContext.getBean(SpianMapper.class);
             // 绗煎瓙浣跨敤鎯呭喌
             List<StorageCage> tableData = homeMapper.selectAll();
             jsonObject.append("tableData", tableData);
-            //鏍肩悊鐗囩鏍煎瓙鐘舵��
+            // 鏍肩悊鐗囩鏍煎瓙鐘舵��
             List<StorageCage> cagelist1 = homeMapper.selectRack1();
             List<StorageCage> cagelist2 = homeMapper.selectRack2();
             List<StorageCage> cagelist3 = homeMapper.selectRack3();
             List<StorageCage> cagelist4 = homeMapper.selectRack4();
             jsonObject.append("cagelist1", cagelist1);
-            jsonObject.append("cagelist2", cagelist2);
+            jsonObject.append("cagelist2", (Object) cagelist2);
             jsonObject.append("cagelist3", cagelist3);
             jsonObject.append("cagelist4", cagelist4);
-            //杩涘嚭鐗囦换鍔�
-            List<StorageCage> tasklist1=homeMapper.selectinout(2);
-            List<StorageCage> tasklist2=homeMapper.selectinout(3);
+            // 杩涘嚭鐗囦换鍔�
+            List<StorageCage> tasklist1 = homeMapper.selectinout(3);
+            List<StorageCage> tasklist2 = homeMapper.selectinout(2);
             jsonObject.append("tasklist1", tasklist1);
             jsonObject.append("tasklist2", tasklist2);
+            // 鏌ヨ鎶ヨ淇℃伅
+            List<alarmmg> alarmmg = homeMapper.SelectAlarmmgInfo();
+            jsonObject.append("alarmmg", alarmmg);
+            // 璇诲幓Plc杩涚墖杞︿笌鍑虹墖杞︿綅缃甒
+            List<String> addressList = new ArrayList<String>();
+            addressList.add("DB106.12");
+            addressList.add("DB106.0");
+            List<Short> paramlist = S7control.getinstance().ReadWord(addressList);
+            // 鑾峰彇杩涚墖杞︾姸鎬�
+            List<Short> datas1ListState = S7control.getinstance().ReadWord("DB106.8", 1);// 鑾峰彇杩涚墖杞︾姸鎬�
+            boolean exist1 = datas1ListState.contains((short) 0);
+            jsonObject.append("zhuangtai", exist1);
+            // 浼� 鑾峰彇杩涙槸鍚︽湁寰呯‘璁ょ殑鐜荤拑id
+            String queid = spianMapper.Selectqueueid();
+            jsonObject.append("queid", queid);
+            // 鑾峰彇鎵爜浣嶄笌涓婄墖浣嶇幓鐠冧俊鎭�
+            List<Glass> form2 = homeMapper.GetQueueInfo(1);
+            List<Glass> form3 = homeMapper.GetQueueInfo(2);
+            jsonObject.append("form2", form2);
+            jsonObject.append("form3", form3);
+            // List<Short> paramlists = new ArrayList<Short>();
+            // short para1 = 11111;
+            // short para2 = 32000;
+            // paramlists.add(para1);
+            // paramlists.add(para2);
+            // System.out.println(paramlists);
 
-            //璇诲幓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, });
+            if (paramlist != null) {
+                jsonObject.append("params", paramlist);
+            }
+            List<Short> inglassInfo = S7control.getinstance().ReadWord("DB106.24", 1);
+            if (inglassInfo != null) {
+                if (inglassInfo.size() > 0)
+                    jsonObject.append("loadglassheight", inglassInfo.get(0) * 70);
+            }
+            dbserve = WebSocketServer.applicationContext.getBean(JdbcConnections.class);
+            boolean dbconnected = false;
+            try {
+                dbserve.getConn();
+                dbconnected = true;
+            } catch (Exception e) {
+                // TODO: handle exception
+                dbconnected = false;
+            }
+            jsonObject.append("dbconnected", dbconnected);
+            // 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());
-            // }
 
         }
     }

--
Gitblit v1.8.0