From afbddf62e45bce6fd9428cddec36382c75cee53a Mon Sep 17 00:00:00 2001 From: wu <731351411@qq.com> Date: 星期四, 07 十二月 2023 08:38:09 +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 | 117 ++++++++++++++++++++++++++++++++++++++++++++-------------- 1 files changed, 89 insertions(+), 28 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 d463ddd..28c2308 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,22 +1,41 @@ 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.ArrayList; 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 = false; + // public static Map b=new HashMap<>(); + // b.put() @Override public void run() { while (this != null) { @@ -30,6 +49,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); @@ -45,12 +66,6 @@ // 杩涘嚭鐗囦换鍔� 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); // 鏌ヨ鎶ヨ淇℃伅 @@ -58,41 +73,87 @@ jsonObject.append("alarmmg", alarmmg); // 璇诲幓Plc杩涚墖杞︿笌鍑虹墖杞︿綅缃甒 List<String> addressList = new ArrayList<String>(); - addressList.add("DB106.12"); - addressList.add("DB106.0"); + if (addressList != null) { + addressList.add("DB106.12"); + addressList.add("DB106.0"); + } + List<Short> paramlist = S7control.getinstance().ReadWord(addressList); if (paramlist != null) { - jsonObject.append("params", paramlist); + jsonObject.append("params", paramlist); } // 鑾峰彇杩涚墖杞︾姸鎬� List<Short> datas1ListState = S7control.getinstance().ReadWord("DB106.8", - 1);// 鑾峰彇杩涚墖杞︾姸鎬� + 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); + if (inglassInfo.size() > 0) + jsonObject.append("loadglassheight", inglassInfo.get(0) * 70); } - //浼� 鑾峰彇杩涙槸鍚︽湁寰呯‘璁ょ殑鐜荤拑id + // 鑾峰彇杩涙槸鍚︽湁寰呯‘璁ょ殑鐜荤拑id String queid = spianMapper.Selectqueueid(); int state = spianMapper.Selectqueuestate(); - jsonObject.append("queid", queid); + 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; -- Gitblit v1.8.0