From ef47083c90ff7e70362a32741a0a4d5770037e7f Mon Sep 17 00:00:00 2001
From: 严智鑫 <test>
Date: 星期一, 18 三月 2024 10:44:04 +0800
Subject: [PATCH] Merge branch 'master' of http://10.153.19.25:10101/r/Albania_Mes

---
 springboot-vue3/src/main/java/com/example/springboot/component/Plchome.java |   59 ++++++++++++++++++++++++++++++++++++++++++-----------------
 1 files changed, 42 insertions(+), 17 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 2d9bfad..425009b 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
@@ -1,16 +1,20 @@
 package com.example.springboot.component;
 import cn.hutool.json.JSONObject;
-import java.sql.SQLException;
 import java.util.ArrayList;
 import java.util.List;
 import com.example.springboot.service.*;
+
+import org.apache.poi.ss.usermodel.Workbook;
 import org.springframework.beans.factory.annotation.Autowired;
 
+import com.example.springboot.entity.FlowCard;
+import com.example.springboot.entity.FlowCard;
 import com.example.springboot.entity.GlassInfo;
 import com.example.springboot.entity.MeasureSetting;
 import com.example.springboot.entity.Out_slice;
 import com.example.springboot.entity.Queue;
 import com.example.springboot.entity.StorageCage;
+import com.example.springboot.entity.StorageTask;
 import com.example.springboot.entity.alarmmg;
 import com.example.springboot.entity.north_glass_buffer1;
 import com.example.springboot.entity.device.PlcParameterObject;
@@ -32,8 +36,6 @@
     private OutSliceServive outSliceServive;
     private SpianMapper spianMapper;
     private SpianService spianService;
-    private North_Glass_Buffer1Service north_Glass_Buffer1Service;
-    private JdbcConnections dbserve;
     
     // 鍑虹墖闃熷垪鏄惁鍏佽鍑虹墖
     public static Boolean isAllowQueue = true;
@@ -72,10 +74,7 @@
                 spianMapper = WebSocketServer.applicationContext.getBean(SpianMapper.class);
                 spianService = WebSocketServer.applicationContext.getBean(SpianService.class);
                 outSliceServive = WebSocketServer.applicationContext.getBean(OutSliceServive.class);
-                north_Glass_Buffer1Service = WebSocketServer.applicationContext
-                        .getBean(North_Glass_Buffer1Service.class);
                 storageCageService = WebSocketServer.applicationContext.getBean(StorageCageService.class);
-                dbserve = WebSocketServer.applicationContext.getBean(JdbcConnections.class);
 
                 // 绗煎瓙浣跨敤鎯呭喌
                 List<StorageCage> tableData = homeMapper.selectAll();
@@ -98,15 +97,7 @@
                 List<alarmmg> alarmmg = homeMapper.SelectAlarmmgInfo();
                 jsonObject.append("alarmmg", alarmmg);
 
-                // 鑾峰彇鎵爜浣嶄笌涓婄墖浣嶇幓鐠冧俊鎭�
-                Queue form2 = homeMapper.GetQueueInfo(2);
-                Queue form3 = homeMapper.GetQueueInfo(1);
-                if (form2.getglassId() != null && form2.getglassId() != "") {
-                    jsonObject.append("form2", form2);
-                }
-                if (form3.getglassId() != null && form3.getglassId() != "") {
-                    jsonObject.append("form3", form3);
-                }
+                
                 // 鑾峰彇鍑虹墖闃熷垪淇℃伅
                 List<Out_slice> listoutslice = outSliceServive.SelectProductionqueue();
                 jsonObject.append("listoutslice", listoutslice);
@@ -129,9 +120,30 @@
                 //double width=plcmes.getPlcParameter("Height").getValue();//瀹�
                 //double height=plcmes.getPlcParameter("width").getValue();//楂�
                 //鑾峰彇娴嬮噺鐨勯暱锛屽
+                String url="C:\\Users\\SNG-ZDH-012\\Desktop\\闃垮皵宸村凹浜氭暟鎹姹�.xlsx";
+                //List typecount= HomeService.ReadExecl2(s);
+                // List xiaopian=HomeService.ReadExecl2(s);
+                // //xiaopian   NG1{A:10,B20}   NG2{A:5,B5}
+                // for(Object C:xiaopian){
+                //     //鐪嬪眰鏁�
+                // }
+
+                // for(int i=0;i<result.size();i++){
+                //     System.out.println(result.get(i));
+                // }
+
+
+                //List result= HomeService.ReadExecl(url);
+                // for(int i=0;i<result.size();i++){
+                //     System.out.println(result.get(i));
+                // }
+
+
+
                 String PlcRequest = "1";
                 double width = 402;
                 double height = 402;
+                
                 //鑾峰彇鍖归厤璁剧疆
                 if ("1".equals(PlcRequest)) {
                     List<GlassInfo> Result=HomeService.NormalGlassInfo(width, height, "1");
@@ -158,12 +170,26 @@
                 // String J01id = new String( S7controlLK.getinstance().ReadByte("DB17.22",14));
 
                 
+                //鏌ヨ鐞嗙墖绗间俊鎭�
+                List<StorageCage> StorageCageInfo = storageCageService.SelectStorageCageInfo();
+                jsonObject.append("StorageCageInfo", StorageCageInfo);
+
+                //鏌ヨ褰撳墠杩涚墖浠诲姟
+                List<StorageTask> StoragTaskeTaskFeed = storageCageService.SelectStorageTask(0);
+                jsonObject.append("StoragTaskeTaskFeed", StoragTaskeTaskFeed);
+
+                //鏌ヨ褰撳墠鍑虹墖浠诲姟
+                List<StorageTask> StoragTaskeTaskOut = storageCageService.SelectStorageTask(1);
+                jsonObject.append("StoragTaskeTaskOut", StoragTaskeTaskOut);
+
+                //鏌ヨ褰撳墠璁㈠崟浠诲姟
+                List<FlowCard> OrderTask = storageCageService.SelectOrderTask();
+                jsonObject.append("OrderTask", OrderTask);
 
             } catch (InterruptedException e) {
                 e.printStackTrace();
             }
 
-            
             // jsonObject.append("params", new short[] { 30, 40, });
             ArrayList<WebSocketServer> sendwServer = WebSocketServer.sessionMap.get("Home");
             if (sendwServer != null) {
@@ -178,7 +204,6 @@
                             // // 灏嗘渶鍚庝竴涓秷鎭浆鎹负鏁存暟绫诲瀷鐨勫垪琛�
                             webserver.clearMessages();
                         }
-
                     }
 
                 }

--
Gitblit v1.8.0