阿尔巴尼亚项目
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
ZengTao
2024-03-21 ffc342d5c299fa3d966d88e4cdb9bf092a7c7510 
 springboot-vue3/src/main/java/com/example/springboot/component/Plchome.java


@@ -1,16 +1,20 @@


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;


@@ -32,8 +36,6 @@


    private OutSliceServive outSliceServive;


    private SpianMapper spianMapper;


    private SpianService spianService;


    private North_Glass_Buffer1Service north_Glass_Buffer1Service;


    private JdbcConnections dbserve;


    


    // 出片队列是否允许出片


    public static Boolean isAllowQueue = true;


@@ -72,19 +74,16 @@


                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<StorageCage> tableData = homeMapper.selectAlls();


                jsonObject.append("tableData", tableData);


                // 格理片笼格子状态


                List<StorageCage> cagelist1 = homeMapper.selectRack1();


                List<StorageCage> cagelist2 = homeMapper.selectRack2();


                List<StorageCage> cagelist3 = homeMapper.selectRack3();


                List<StorageCage> cagelist4 = homeMapper.selectRack4();


                List<StorageCage> cagelist1=storageCageService.SelectStorageCageByCage(1);


                List<StorageCage> cagelist2=storageCageService.SelectStorageCageByCage(2);


                List<StorageCage> cagelist3=storageCageService.SelectStorageCageByCage(3);


                List<StorageCage> cagelist4=storageCageService.SelectStorageCageByCage(4);


                jsonObject.append("cagelist1", cagelist1);


                jsonObject.append("cagelist2", cagelist2);


                jsonObject.append("cagelist3", cagelist3);


@@ -98,15 +97,7 @@


                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);


@@ -129,41 +120,52 @@


                //double width=plcmes.getPlcParameter("Height").getValue();//宽


                //double height=plcmes.getPlcParameter("width").getValue();//高


                //获取测量的长，宽


                


                


                //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";


                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("未找到符合的数据");


                    }


                    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) {


@@ -178,7 +180,6 @@


                            // // 将最后一个消息转换为整数类型的列表


                            webserver.clearMessages();


                        }




                    }




                }