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


@@ -2,17 +2,36 @@




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






public class Plchome extends Thread {




    @Autowired


    private HomeMapper homeMapper;


    private SpianMapper spianMapper;


    private JdbcConnections dbserve;


    private JdbcConnections jdbcConnections;






    // public static int a=1;


    // public static Map b=new HashMap<>();


    // b.put()


    @Override


    public void run() {


        while (this != null) {


@@ -25,6 +44,8 @@




            // 注入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);


@@ -38,30 +59,63 @@


            jsonObject.append("cagelist3", cagelist3);


            jsonObject.append("cagelist4", cagelist4);


            // 进出片任务


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


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


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


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


            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.0");


            addressList.add("DB106.12");


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




            // List<Short> paramlists = new ArrayList<Short>();


            // short para1 = 1;


            // short para2 = 2;


            // paramlists.add(para1);


            // paramlists.add(para2);


            // System.out.println(paramlists);




            if(paramlist!=null){


            // Short[] paramlists = paramlist.toArray(new Short[0]);


            jsonObject.append("params", paramlist);


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


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


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




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


            boolean dbconnected = false;


            try {


                dbserve.getConn();


                dbconnected = true;


            } catch (Exception e) {


                // TODO: handle exception


                dbconnected = false;


            }


            jsonObject.append("dbconnected", dbconnected);


            // jsonObject.append("params", new short[] { 30, 40, });


            WebSocketServer sendwServer = WebSocketServer.sessionMap.get("Home");


            if (sendwServer != null) {