| | |
| | | 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; |
| | |
| | | private OutSliceServive outSliceServive; |
| | | private SpianMapper spianMapper; |
| | | private SpianService spianService; |
| | | private North_Glass_Buffer1Service north_Glass_Buffer1Service; |
| | | private JdbcConnections dbserve; |
| | | |
| | | // 出片队列是否允许出片 |
| | | public static Boolean isAllowQueue = true; |
| | |
| | | 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(); |
| | |
| | | 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); |
| | |
| | | PlcParameterObject plcmes=PLCAutoMes.PlcMesObject; |
| | | |
| | | //String PlcRequest=plcmes.getPlcParameter("GaToMES").getValue();//请求 |
| | | //String MesSend=plcmes.getPlcParameter("MESToGaStatus").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); |
| | | |
| | | |
| | | //String url="C:\\Users\\SNG-ZDH-012\\Desktop\\阿尔巴尼亚数据要求.xlsx";E:\ |
| | | //String url="E:\\阿尔巴尼亚数据要求.xlsx"; |
| | | // List result= HomeService.ReadExecl(url); |
| | | // for(int i=0;i<result.size();i++){ |
| | | // System.out.println(result.get(i)); |
| | | // } |
| | |
| | | |
| | | |
| | | String PlcRequest = "1"; |
| | | String MesSend = "0"; |
| | | double width = 402; |
| | | double height = 402; |
| | | |
| | | //获取匹配设置 |
| | | if ("1".equals(PlcRequest)) { |
| | | List<GlassInfo> Result=HomeService.NormalGlassInfo(width, height, "1"); |
| | | if(Result.size()==1){ |
| | | //匹配成功 就一种类型 添加数据 |
| | | GlassInfo GlassInfo=Result.get(0); |
| | | QueueMapper.insert(GlassInfo.getGlassid(),width,height,1); |
| | | System.out.println("匹配成功"); |
| | | //S7control.getinstance().WriteWord(plcmes.getPlcParameter("GaToMES").getAddress(), (short) 1); |
| | | System.out.println(GlassInfo.getGlassid()); |
| | | }else if(Result.size()>1){ |
| | | //匹配失败 匹配到多条符合的数据 添加数据 |
| | | QueueMapper.insert(null,width,height,2); |
| | | System.out.println("匹配失败"); |
| | | } |
| | | else{ |
| | | //匹配失败 未找到符合的数据 添加数据 |
| | | QueueMapper.insert(null,width,height,3); |
| | | System.out.println("未找到符合的数据"); |
| | | } |
| | | |
| | | //匹配 |
| | | if ("1".equals(PlcRequest)&&"0".equals(PlcRequest)) { |
| | | GlassInfo MesureGlassinfo=HomeService.Normal(width, height, "1"); |
| | | } |
| | | Queue LastQueue= QueueMapper.selectLastQueue(); |
| | | // String E01id = new String( S7controlLK.getinstance().ReadByte("DB17.0",16)); |
| | | // String J01id = new String( S7controlLK.getinstance().ReadByte("DB17.22",14)); |
| | | |
| | | |
| | | jsonObject.append("LastQueue", LastQueue); |
| | | //查询理片笼信息 |
| | | 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) { |
| | |
| | | // // 将最后一个消息转换为整数类型的列表 |
| | | webserver.clearMessages(); |
| | | } |
| | | |
| | | } |
| | | |
| | | } |