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 |   49 +++++++++++++++++++++++++++++++++++++++++++------
 1 files changed, 43 insertions(+), 6 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 e9dbca5..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
@@ -3,15 +3,25 @@
 import cn.hutool.json.JSONObject;
 
 import java.util.ArrayList;
+import java.util.HashMap;
 import java.util.List;
+import java.util.Map;
 
+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() {
@@ -25,6 +35,7 @@
 
             // 娉ㄥ叆mapper
             homeMapper = WebSocketServer.applicationContext.getBean(HomeMapper.class);
+            spianMapper = WebSocketServer.applicationContext.getBean(SpianMapper.class);
             // 绗煎瓙浣跨敤鎯呭喌
             List<StorageCage> tableData = homeMapper.selectAll();
             jsonObject.append("tableData", tableData);
@@ -34,12 +45,12 @@
             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);
             // 鏌ヨ鎶ヨ淇℃伅
@@ -50,7 +61,18 @@
             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;
@@ -58,9 +80,24 @@
             // paramlists.add(para2);
             // System.out.println(paramlists);
 
-            if(paramlist!=null){
-            jsonObject.append("params", paramlist);
+            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) {

--
Gitblit v1.8.0