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 | 114 +++++++++++++++++++++++++++++++++++++++++++++------------ 1 files changed, 90 insertions(+), 24 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 60f5831..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,20 +1,40 @@ package com.example.springboot.component; import cn.hutool.json.JSONObject; +import cn.hutool.poi.excel.sax.handler.MapRowHandler; + +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.entity.north_glass_buffer1; 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) { @@ -28,6 +48,8 @@ // 娉ㄥ叆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); @@ -43,18 +65,12 @@ // 杩涘嚭鐗囦换鍔� List<StorageCage> tasklist1 = homeMapper.selectinout(3); List<StorageCage> tasklist2 = homeMapper.selectinout(2); - for (StorageCage storageCage : tasklist1) { - storageCage.setnorth_glass_buffer1s(homeMapper.SelectBoxNo(storageCage.getGlassId())); - } - for (StorageCage storageCage : tasklist2) { - storageCage.setnorth_glass_buffer1s(homeMapper.SelectBoxNo(storageCage.getGlassId())); - } jsonObject.append("tasklist1", tasklist1); jsonObject.append("tasklist2", tasklist2); // 鏌ヨ鎶ヨ淇℃伅 List<alarmmg> alarmmg = homeMapper.SelectAlarmmgInfo(); jsonObject.append("alarmmg", alarmmg); - // // 璇诲幓Plc杩涚墖杞︿笌鍑虹墖杞︿綅缃甒 + // 璇诲幓Plc杩涚墖杞︿笌鍑虹墖杞︿綅缃甒 // List<String> addressList = new ArrayList<String>(); // addressList.add("DB106.12"); // addressList.add("DB106.0"); @@ -67,7 +83,7 @@ // 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) @@ -75,23 +91,71 @@ // } // 浼� 鑾峰彇杩涙槸鍚︽湁寰呯‘璁ょ殑鐜荤拑id String queid = spianMapper.Selectqueueid(); - String state = spianMapper.Selectqueuestate(); - jsonObject.append("queid", queid); + int state = spianMapper.Selectqueuestate(); + jsonObject.append("state", queid); jsonObject.append("state", state); // 鑾峰彇鎵爜浣嶄笌涓婄墖浣嶇幓鐠冧俊鎭� - String queueglassid2 = homeMapper.GetQueueInfo(2); - String queueglassid1 = homeMapper.GetQueueInfo(1); - north_glass_buffer1 form2 = homeMapper.SelectGlassByGlassID(queueglassid2); - north_glass_buffer1 form3 = homeMapper.SelectGlassByGlassID(queueglassid1); - 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); + 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 { @@ -108,6 +172,8 @@ sendwServer.sendMessage(jsonObject.toString()); } + + } } } -- Gitblit v1.8.0