From e47aa1b3ca12923e194d6e88187d2ecdb29eb186 Mon Sep 17 00:00:00 2001 From: wuyouming666 <2265557248@qq.com> Date: 星期二, 05 十二月 2023 16:09:04 +0800 Subject: [PATCH] Merge branch 'master' of http://10.153.19.25:10101/r/CanadaMes --- springboot-vue3/src/main/java/com/example/springboot/component/Plchome.java | 153 ++++++++++++++++++++++++++++++++++++++++++++------- 1 files changed, 132 insertions(+), 21 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 026cace..8d1b7c3 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,36 +1,59 @@ package com.example.springboot.component; import cn.hutool.json.JSONObject; +import cn.hutool.poi.excel.sax.handler.MapRowHandler; -import java.util.ArrayList; +import java.sql.SQLException; import java.util.List; +import org.springframework.beans.factory.annotation.Autowired; +import com.example.springboot.entity.Out_slice; +import com.example.springboot.entity.Queue; 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; +import com.example.springboot.service.North_Glass_Buffer1Service; +import com.example.springboot.service.SpianService; + public class Plchome extends Thread { + @Autowired private HomeMapper homeMapper; - + private SpianMapper spianMapper; + private SpianService spianService; + private North_Glass_Buffer1Service north_Glass_Buffer1Service; + private JdbcConnections dbserve; + //鍑虹墖闃熷垪鏄惁鍏佽鍑虹墖 + public static Boolean isAllowQueue=true; + //閾濇id + public static String FrameNo; + //鏄惁闇�瑕佹墜鍔ㄧ‘璁ょ幓鐠� + public static Boolean isConfirm=true; + // public static Map b=new HashMap<>(); + // b.put() @Override public void run() { while (this != null) { try { - Thread.sleep(10000); + Thread.sleep(1000); } catch (InterruptedException e) { e.printStackTrace(); } - JSONObject jsonObject = new JSONObject(); - - //娉ㄥ叆mapper + + // 娉ㄥ叆mapper homeMapper = WebSocketServer.applicationContext.getBean(HomeMapper.class); + spianMapper = WebSocketServer.applicationContext.getBean(SpianMapper.class); + spianService = WebSocketServer.applicationContext.getBean(SpianService.class); + north_Glass_Buffer1Service = WebSocketServer.applicationContext.getBean(North_Glass_Buffer1Service.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(); @@ -39,30 +62,118 @@ jsonObject.append("cagelist2", 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(); + // 鏌ヨ鎶ヨ淇℃伅 + List<alarmmg> alarmmg = homeMapper.SelectAlarmmgInfo(); jsonObject.append("alarmmg", alarmmg); - //璇诲幓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); + // 璇诲幓Plc杩涚墖杞︿笌鍑虹墖杞︿綅缃甒 + // List<String> addressList = new ArrayList<String>(); + // addressList.add("DB106.12"); + // addressList.add("DB106.0"); + // List<Short> paramlist = S7control.getinstance().ReadWord(addressList); + // if (paramlist != null) { + // jsonObject.append("params", paramlist); + // } + // // 鑾峰彇杩涚墖杞︾姸鎬� + // List<Short> datas1ListState = S7control.getinstance().ReadWord("DB106.8", + // 1);// 鑾峰彇杩涚墖杞︾姸鎬� + // boolean exist1 = datas1ListState.contains((short) 0); + // jsonObject.append("zhuangtai", exist1); + // //鑾峰彇杩涚墖鐜荤拑淇℃伅 + // List<Short> inglassInfo = S7control.getinstance().ReadWord("DB106.24", 1); + // if (inglassInfo != null) { + // if (inglassInfo.size() > 0) + // jsonObject.append("loadglassheight", inglassInfo.get(0) * 70); + // } + // 浼� 鑾峰彇杩涙槸鍚︽湁寰呯‘璁ょ殑鐜荤拑id + String queid = spianMapper.Selectqueueid(); + int state = spianMapper.Selectqueuestate(); + jsonObject.append("state", queid); + jsonObject.append("state", state); + // 鑾峰彇鎵爜浣嶄笌涓婄墖浣嶇幓鐠冧俊鎭� + 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 = homeMapper.SelectProductionqueue(); + for (Out_slice out_slice : listoutslice) { + out_slice.setstorageCage(homeMapper.SelectStorageGlassById(out_slice.getGlassId())); + } + jsonObject.append("listoutslice", listoutslice); + //鑾峰彇褰撳墠鍑虹墖闃熷垪鐘舵�� + jsonObject.append("isAllowQueue",Plchome.isAllowQueue); + + //鑾峰彇閾濇idDB106.DBW64 + // String frameno=spianService.queGlassid("DB106.24",14).toString(); + // if(frameno!=Plchome.FrameNo){ + // Plchome.FrameNo=frameno; + // } + // Plchome.FrameNo="123"; + // try { + // north_Glass_Buffer1Service.AddOutSliceS(Plchome.FrameNo); + // } catch (SQLException e) { + // // TODO Auto-generated catch block + // e.printStackTrace(); + // } + //鏄惁闇�瑕佷汉宸ョ‘璁や笂鐗囩幓鐠� + jsonObject.append("isConfirm", isConfirm); + + //閾濇绾夸氦浜� + + // //閾濇id璇锋眰瀛� + // List<Short> framerequest = S7control.getinstance().ReadWord("閾濇id璇锋眰瀛楀湴鍧�", 1); + // if(framerequest!=null){ + // //閾濇id + // String franmeno= spianService.queGlassid("閾濇id鍦板潃", 14).toString(); + // String position; + // try { + // position=dbserve.SelectPositionByFrameBarcode(franmeno); + // } catch (SQLException e) { + // // TODO Auto-generated catch block + // position="0"; + // e.printStackTrace(); + // } + // Short send; + // if(position=="0"){ + // send=0; + // }else{ + // send=1; + // } + // S7control.getinstance().WriteWord("閾濇缈昏浆鍙戦�佸湴鍧�", (short)send); + // } + + + + + + + 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()); } + + } } } -- Gitblit v1.8.0