加拿大MES项目
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
wuyouming666
2023-11-30 8dfb37b10ffb2fcb41c85b3fa266d1ef2874aebc 
 springboot-vue3/src/main/java/com/example/springboot/component/Plchome.java


@@ -2,26 +2,27 @@




import cn.hutool.json.JSONObject;




import java.sql.SQLException;


import java.util.ArrayList;


import java.util.HashMap;


import java.util.List;


import java.util.Map;




import org.springframework.web.bind.annotation.PostMapping;


import org.springframework.beans.factory.annotation.Autowired;




import com.example.springboot.common.Result;


import com.example.springboot.entity.Glass;


import com.example.springboot.entity.Out_slice;


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;




public class Plchome extends Thread {




    @Autowired


    private HomeMapper homeMapper;


    private SpianMapper spianMapper;


    private JdbcConnections dbserve;


    private JdbcConnections jdbcConnections;




    @Override


    public void run() {


@@ -36,6 +37,7 @@


            // 注入mapper


            homeMapper = WebSocketServer.applicationContext.getBean(HomeMapper.class);


            spianMapper = WebSocketServer.applicationContext.getBean(SpianMapper.class);


            jdbcConnections = WebSocketServer.applicationContext.getBean(JdbcConnections.class);


            // 笼子使用情况


            List<StorageCage> tableData = homeMapper.selectAll();


            jsonObject.append("tableData", tableData);


@@ -45,49 +47,100 @@


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


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


            jsonObject.append("cagelist1", cagelist1);


            jsonObject.append("cagelist2", (Object) cagelist2);


            jsonObject.append("cagelist2", cagelist2);


            jsonObject.append("cagelist3", cagelist3);


            jsonObject.append("cagelist4", cagelist4);


            // 进出片任务


            List<StorageCage> tasklist1 = homeMapper.selectinout(3);


            List<StorageCage> tasklist2 = homeMapper.selectinout(2);


            for (StorageCage storageCage : tasklist1) {


                // storageCage.setnorth_glass_buffer1s(homeMapper.SelectBoxNo(storageCage.getGlassId()));


                try {


                    storageCage.setnorth_glass_buffer1s(jdbcConnections.SelectGlassByGlassIdOrderIdFrameId("", "", ""));


                } catch (SQLException e) {


                    e.printStackTrace();


                }


                try {


                    storageCage.setnorth_glass_buffer1s(


                            jdbcConnections.SelectGlassByGlassIdOrderIdFrameId(storageCage.getGlassId(), "", ""));


                } catch (SQLException e) {


                    e.printStackTrace();


                }


            }


            for (StorageCage storageCage : tasklist2) {


                // storageCage.setnorth_glass_buffer1s(homeMapper.SelectBoxNo(storageCage.getGlassId()));


                try {


                    storageCage.setnorth_glass_buffer1s(


                            jdbcConnections.SelectGlassByGlassIdOrderIdFrameId(storageCage.getGlassId(), "", ""));


                } catch (SQLException e) {


                    e.printStackTrace();


                }




            }


            jsonObject.append("tasklist1", tasklist1);


            jsonObject.append("tasklist2", tasklist2);


            // 查询报警信息


            List<alarmmg> alarmmg = homeMapper.SelectAlarmmgInfo();


            jsonObject.append("alarmmg", alarmmg);


            // 读去Plc进片车与出片车位置W


            List<String> addressList = new ArrayList<String>();


            addressList.add("DB106.12");


            addressList.add("DB106.0");


            List<Short> paramlist = S7control.getinstance().ReadWord(addressList);


            // 获取进片车状态


            List<Short> datas1ListState = S7control.getinstance().ReadWord("DB106.8", 1);// 获取进片车状态


            boolean exist1 = datas1ListState.contains((short) 0);


            jsonObject.append("zhuangtai", exist1);


            // 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("queid", queid);


            jsonObject.append("state", state);


            // 获取扫码位与上片位玻璃信息


            List<Glass> form2 = homeMapper.GetQueueInfo(1);


            List<Glass> form3 = homeMapper.GetQueueInfo(2);


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


            String queueglassid2 = homeMapper.GetQueueInfo(2);


            String queueglassid1 = homeMapper.GetQueueInfo(1);


            // north_glass_buffer1 form2 = homeMapper.SelectGlassByGlassID(queueglassid2);


            // north_glass_buffer1 form3 = homeMapper.SelectGlassByGlassID(queueglassid1);




            if (paramlist != null) {


                jsonObject.append("params", paramlist);


            north_glass_buffer1 form2;


            if(queueglassid2.length()!=0){


                try {


                    form2 = jdbcConnections.SelectGlassByGlassIdOrderIdFrameId(queueglassid2, "", "");


                    jsonObject.append("form2", form2);


                } catch (SQLException e) {


                    e.printStackTrace();


                }


            }


            List<Short> inglassInfo = S7control.getinstance().ReadWord("DB106.24", 1);


            if (inglassInfo != null) {


                if (inglassInfo.size() > 0)


                    jsonObject.append("loadglassheight", inglassInfo.get(0) * 70);


                


            north_glass_buffer1 form3;


            if(queueglassid1.length()!=0){


                try {


                    form3 = jdbcConnections.SelectGlassByGlassIdOrderIdFrameId(queueglassid1, "", "");


                    jsonObject.append("form3", form3);


                } catch (SQLException e) {


                    e.printStackTrace();


                }


            }


                




            // 获取出片队列信息


            List<Out_slice> listoutslice = homeMapper.SelectProductionqueue();


            for (Out_slice out_slice : listoutslice) {


                out_slice.setnorth_glass_buffer1s(homeMapper.SelectBoxNo(out_slice.getGlassId()));


                out_slice.setstorageCage(homeMapper.SelectStorageGlassById(out_slice.getGlassId()));


            }


            jsonObject.append("listoutslice", listoutslice);




            dbserve = WebSocketServer.applicationContext.getBean(JdbcConnections.class);


            boolean dbconnected = false;


            try {