From e76f203f76b934d2f49dcea89649b2f616878056 Mon Sep 17 00:00:00 2001
From: ZengTao <2773468879@qq.com>
Date: 星期一, 18 三月 2024 12:36:22 +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 |   87 ++++++++++++++++++++++++++++++++++---------
 1 files changed, 69 insertions(+), 18 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 43d90c2..684d234 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,27 +1,42 @@
 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;
 import com.example.springboot.mapper.HomeMapper;
+import com.example.springboot.mapper.GlassInfoMapper;
+import com.example.springboot.mapper.MeasureSettingMapper;
+import com.example.springboot.mapper.QueueMapper;
 import com.example.springboot.mapper.SpianMapper;
 
 public class Plchome extends Thread {
 
     @Autowired
     private HomeMapper homeMapper;
+    @Autowired
+    private HomeService HomeService;
+    private QueueMapper QueueMapper;
+    private GlassInfoMapper GlassInfoMapper;
+    private MeasureSettingMapper MeasureSettingMapper;
     private OutSliceServive outSliceServive;
     private SpianMapper spianMapper;
     private SpianService spianService;
-    private North_Glass_Buffer1Service north_Glass_Buffer1Service;
-    private JdbcConnections dbserve;
+    
     // 鍑虹墖闃熷垪鏄惁鍏佽鍑虹墖
     public static Boolean isAllowQueue = true;
     public static Boolean isAllowReordering = true;
@@ -53,14 +68,13 @@
             try {
                 Thread.sleep(1000);
                 // 娉ㄥ叆mapper
+                HomeService  = WebSocketServer.applicationContext.getBean(HomeService.class);
+                QueueMapper  = WebSocketServer.applicationContext.getBean(QueueMapper.class);
                 homeMapper = WebSocketServer.applicationContext.getBean(HomeMapper.class);
                 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();
@@ -84,15 +98,6 @@
                 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);
@@ -107,19 +112,66 @@
                 // 鏌ヨ褰撳墠閾濇淇℃伅
                 Out_slice CurrentFrame = outSliceServive.SelectCurrentFrame();
                 jsonObject.append("CurrentFrame", CurrentFrame);
+              
+                //璇诲彇DB105鍖烘枃浠�
+                PlcParameterObject plcmes=PLCAutoMes.PlcMesObject;
+      
+                //String PlcRequest=plcmes.getPlcParameter("GaToMES").getValue();//璇锋眰
+                //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)) {
+                    boolean Result=HomeService.Normal(width, height, "1");                   
+                }
                 // String E01id = new String( S7controlLK.getinstance().ReadByte("DB17.0",16));
                 // 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) {
@@ -134,7 +186,6 @@
                             // // 灏嗘渶鍚庝竴涓秷鎭浆鎹负鏁存暟绫诲瀷鐨勫垪琛�
                             webserver.clearMessages();
                         }
-
                     }
 
                 }

--
Gitblit v1.8.0