Merge branch 'master' of http://10.153.19.25:10101/r/CanadaMes

ZengTao

2024-05-08 9472449b4ca46f482d13b6e628660c61101b443f

 springboot-vue3/src/main/java/com/example/springboot/component/Plchome.java

@@ -1,178 +1,416 @@
package com.example.springboot.component;

import cn.hutool.json.JSONObject;
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.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) {
            try {
                Thread.sleep(1000);
            } catch (InterruptedException e) {
                e.printStackTrace();
            }
            JSONObject jsonObject = new JSONObject();

            // 注入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);
            // 格理片笼格子状态
            List<StorageCage> cagelist1 = homeMapper.selectRack1();
            List<StorageCage> cagelist2 = homeMapper.selectRack2();
            List<StorageCage> cagelist3 = homeMapper.selectRack3();
            List<StorageCage> cagelist4 = homeMapper.selectRack4();
            jsonObject.append("cagelist1", cagelist1);
            jsonObject.append("cagelist2", cagelist2);
            jsonObject.append("cagelist3", cagelist3);
            jsonObject.append("cagelist4", cagelist4);
            // 进出片任务
            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.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);
            //获取当前出片队列状态
            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;
            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) {
                sendwServer.sendMessage(jsonObject.toString());
            }


            
        }
    }
}
package com.example.springboot.component;



import cn.hutool.json.JSONObject;

import lombok.extern.slf4j.Slf4j;



import java.sql.SQLException;

import java.util.ArrayList;

import java.util.List;



import com.example.springboot.service.*;



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;



@Slf4j

public class Plchome extends Thread {



    @Autowired

    private HomeMapper homeMapper;

    private OutSliceServive outSliceServive;

    private SpianMapper spianMapper;

    private SpianService spianService;

    private North_Glass_Buffer1Service north_Glass_Buffer1Service;

    private JdbcConnections dbserve;

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

    public static Boolean isAllowQueue = true;

    public static Boolean isAllowReordering = true;

    // 出片队列警告

    public static Boolean isQueueWarning = false;

    // 铝框id

    public static String FrameNo = "";

    // 是否需要手动确认玻璃

    public static Boolean isConfirm = true;

    // 待确认的出片队列

    public static List<north_glass_buffer1> AluminumFrame;



    // private Configuration config;



    private StorageCageService storageCageService;



    public static Boolean FeedState = false;



    public static StringBuilder feedglassid;



    public static Boolean dbconnected = false;



    public static Boolean plc1 = true;

    public static Boolean plc2 = false;



    // public Plchome() throws IOException {

    // config = new Configuration("config.properties");

    // }



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

    // b.put()

    @Override

    public void run() {

        while (this != null) {

            Short zhi = 0;

            JSONObject jsonObject = new JSONObject();

            jsonObject.append("feedglassid", feedglassid);

            try {

                Thread.sleep(1000);

                // 注入mapper

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

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



                // boolean dbconnected = false;

                try {

                    dbserve.getConn();

                    dbconnected = true;

                } catch (Exception e) {

                    e.printStackTrace();

                    dbconnected = false;

                    log.info("dbconnected:" + dbconnected);

                }

                jsonObject.append("dbconnected", dbconnected);

                // // 获取当前扫码枪玻璃id

                // String CurrrentGlassId = "X22595911002GV";

                // if (CurrrentGlassId.toString() != "" && CurrrentGlassId.toString() != null) {

                // north_glass_buffer1 form6 =

                // dbserve.SelectGlassByGlassIdOrderIdFrameIdouts(CurrrentGlassId, "",

                // "");

                // if (form6.getbarcode() != null) {

                // jsonObject.append("form6", form6);

                // double width = 0;

                // double height = 0;

                // if (form6.getglassheightmm() < form6.getglasslengthmm()) {

                // height = form6.getglassheightmm();

                // width = form6.getglasslengthmm();

                // } else {

                // height = form6.getglasslengthmm();

                // width = form6.getglassheightmm();

                // }

                // if (height < 380 || width < 380 || height > 1810 || width > 2760) {

                // zhi = 600;

                // } else {

                // zhi = spianService.selectAlls(form6);

                // }

                // }

                // }



                // 笼子使用情况

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

                jsonObject.append("tableData", tableData);

                // 格理片笼格子状态

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

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

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

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

                jsonObject.append("cagelist1", cagelist1);

                jsonObject.append("cagelist2", cagelist2);

                jsonObject.append("cagelist3", cagelist3);

                jsonObject.append("cagelist4", cagelist4);

                // 进出片任务

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



                // 伍 获取进是否有待确认的玻璃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 = outSliceServive.SelectProductionqueue();

                jsonObject.append("listoutslice", listoutslice);

                // 获取当前出片队列出片状态

                jsonObject.append("isAllowQueue", Plchome.isAllowQueue);

                // 获取出片队列警告状态

                jsonObject.append("isQueueWarning", Plchome.isQueueWarning);

                // 获取当前出片队列调序状态

                jsonObject.append("isAllowReordering", Plchome.isAllowReordering);

                // 是否需要人工确认上片玻璃

                jsonObject.append("isConfirm", isConfirm);

                // 查询当前铝框信息

                Out_slice CurrentFrame = outSliceServive.SelectCurrentFrame();

                jsonObject.append("CurrentFrame", CurrentFrame);



                // String E01id = new String( S7controlLK.getinstance().ReadByte("DB17.0",16));

                // String J01id = new String( S7controlLK.getinstance().ReadByte("DB17.22",14));

                try {

                    // 铝框线交互

                    // if (S7controlLK.getinstance().CheckConnected() == true) {

                    // E02玻璃id

                    // log.info("frame1"+S7controlLK.getinstance().CheckConnected());

                    String E02id="";

                    try {

                        E02id= S7controlLK.getinstance().readStrings("DB17.40");

                        plc2=true;

                    } catch (Exception e) {

                        // TODO: handle exception

                        plc2=false;

                        e.printStackTrace();

                    }

                    
                    jsonObject.append("Plc2", plc2);

                    // log.info("铝框线读取2"+S7controlLK.getinstance().CheckConnected());

                    
                    // log.info("E02id"+E02id);

                    outSliceServive.FrameStateUpdate(E02id);

                    if (CurrentFrame != null) {

                        S7controlLK.getinstance().writeStrings(CurrentFrame.getBarCode(), "DB17.0");

                    }

                    String J01id = S7controlLK.getinstance().readStrings("DB17.22");

                    List<Short> liststate = S7controlLK.getinstance().ReadWord("DB17.20", 1);

                    Short framerequest = liststate.get(0);

                    // log.info("liststate:" + liststate);

                    if (framerequest == 1) {

                        // 铝框id

                        String position;

                        try {

                            position = dbserve.SelectPositionByFrameBarcode(J01id);

                        } catch (SQLException e) {

                            // TODO Auto-generated catch block

                            position = "0";

                            e.printStackTrace();

                        }

                        Short send;

                        if (position.equals("0")) {

                            send = 2;

                        } else {

                            send = 1;

                        }

                        if (J01id != null) {

                            int barcodeState = spianMapper.SelectOverState(J01id);// 获取该铝框的状态

                            if (barcodeState == 0) {// 当该铝框所有的玻璃都是完成状态时删除在出片队列的数据

                                spianMapper.DeleteQueue(J01id);

                                // log.info("deleteoutslice:" + J01id);

                            }

                        }

                        S7controlLK.getinstance().WriteWord("DB17.38", (short) send);

                    }



                    String E01id = S7controlLK.getinstance().readStrings("DB17.0");

                    // log.info("frameno:" + E01id);

                    List<Short> liststates = S7controlLK.getinstance().ReadWord("DB17.38", 1);

                    // log.info("frameflip:" + liststates);

                    // }else{

                    // log.info("Plc2"+S7controlLK.getinstance().CheckConnected());

                    // jsonObject.append("Plc2", false);

                    // }

                } catch (Exception e) {

                    e.printStackTrace();

                }



                if (S7control.getinstance().CheckConnected() == true) {



                    // 获取当前扫码方式

                    List<Boolean> Scanningmethods = S7control.getinstance().ReadBits("DB101.11.4", 1);

                    if (Scanningmethods != null) {

                        for (Boolean Scanningmethod : Scanningmethods) {

                            jsonObject.append("Scanningmethod", Scanningmethod);

                        }

                    }

                    // 获取当前扫码枪玻璃id

                    String CurrrentGlassId = spianService.queGlassid("DB103.256", 14).toString();

                    if (CurrrentGlassId.toString() != "" && CurrrentGlassId.toString() != null) {

                        north_glass_buffer1 form6 = dbserve.SelectGlassByGlassIdOrderIdFrameIdouts(CurrrentGlassId, "",

                                "");

                        if (form6.getbarcode() != null) {

                            jsonObject.append("form6", form6);

                            double width = 0;

                            double height = 0;

                            if (form6.getglassheightmm() < form6.getglasslengthmm()) {

                                height = form6.getglassheightmm();

                                width = form6.getglasslengthmm();

                            } else {

                                height = form6.getglasslengthmm();

                                width = form6.getglassheightmm();

                            }

                            if (height < 380 || width < 380 || height > 1810 || width > 2760) {

                                zhi = 600;

                            } else {

                                zhi = spianService.selectAlls(form6);

                            }

                        }

                    }



                    jsonObject.append("CurrrentGlassId", CurrrentGlassId);



                    // 获取D01-D06,A01,A02,B01,B02状态

                    List<Short> DeviceList = S7control.getinstance().ReadWord("DB103.0", 10);

                    jsonObject.append("DeviceList", DeviceList);

                    // 获取D01-D06,A01,A02,B01,B02玻璃id

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

                    GlassIdList.add(spianService.queGlassid("DB103.44", 14).toString());

                    GlassIdList.add(spianService.queGlassid("DB103.58", 14).toString());



                    GlassIdList.add(spianService.queGlassid("DB103.184", 14).toString());

                    GlassIdList.add(spianService.queGlassid("DB103.212", 14).toString());



                    GlassIdList.add(spianService.queGlassid("DB103.128", 14).toString());

                    GlassIdList.add(spianService.queGlassid("DB103.142", 14).toString());

                    GlassIdList.add(spianService.queGlassid("DB103.156", 14).toString());



                    GlassIdList.add(spianService.queGlassid("DB103.72", 14).toString());

                    GlassIdList.add(spianService.queGlassid("DB103.86", 14).toString());

                    GlassIdList.add(spianService.queGlassid("DB103.100", 14).toString());

                    GlassIdList.add(spianService.queGlassid("DB103.114", 14).toString());

                    jsonObject.append("GlassIdList", GlassIdList);



                    // 获取Plc进片车与出片车位置

                    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);// 获取进片车状态

                    // if (datas1ListState != null) {

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

                    // }

                    // }

                    // // 获取铝框idDB106.DBW64，添加到出片队列

                    // String frameno="X21763329601FB";

                    String frameno = spianService.queGlassid("DB103.270", 11).toString();

                    if (!frameno.equals(Plchome.FrameNo)) {

                        Plchome.FrameNo = frameno;

                        try {

                            Short num = 0;

                            List<north_glass_buffer1> north_glass_buffer1s = north_Glass_Buffer1Service

                                    .SelectAluminumFrameInfoById(Plchome.FrameNo);

                            for (north_glass_buffer1 north_glass_buffer1 : north_glass_buffer1s) {

                                if (north_glass_buffer1.getstorageCage() == null) {

                                    break;

                                }

                                num++;

                            }

                            if (num == north_glass_buffer1s.size()) {

                                north_Glass_Buffer1Service.AddOutSliceS(Plchome.FrameNo);

                            } else {

                                Plchome.AluminumFrame = north_glass_buffer1s;

                            }

                        } catch (SQLException e) {

                            // TODO Auto-generated catch block

                            e.printStackTrace();

                        }

                    }

                    if (AluminumFrame != null) {

                        jsonObject.append("AluminumFrame", AluminumFrame);

                    }



                    // 复位倒计时

                    // 地址104.9.6

                    List<Boolean> countdown = S7control.getinstance().ReadBits("DB104.9.6", 1);

                    for (Boolean countdowns : countdown) {

                        jsonObject.append("countdown", countdowns);

                    }

                    // jsonObject.append("countdown", true);

                    // 复位完成信号

                    List<Boolean> resetss = S7control.getinstance().ReadBits("DB103.284", 1);

                    for (Boolean reset : resetss) {

                        jsonObject.append("reset", reset);

                    }



                    // 是否急停

                    List<Boolean> emergencystops = S7control.getinstance().ReadBits("DB104.5.1", 1);

                    for (Boolean emergencystop : emergencystops) {

                        jsonObject.append("emergencystop", emergencystop);

                    }

                    // 获取进片请求状态

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

                    boolean D01RequestState = D01Request.contains((short) 1);

                    jsonObject.append("D01RequestState", D01RequestState);



                    // 获取进片发送状态

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

                    boolean D01ResponseState = D01respnse.contains((short) 1);

                    // jsonObject.append("D01RequestState", D01RequestState);

                    // 自动进片

                    if (isConfirm == true && form3.getglassId() != null && form3.getglassId() != "") {

                        double width = 0;

                        double height = 0;

                        if (form3.getglassheight() < form3.getglasswidth()) {

                            height = form3.getglassheight();

                            width = form3.getglasswidth();

                        } else {

                            height = form3.getglasswidth();

                            width = form3.getglassheight();

                        }

                        if (height < 380 || width < 380 || height > 1810 || width > 2760) {

                            zhi = 600;

                        } else {

                            if (D01RequestState == true && D01ResponseState != true) {

                                zhi = storageCageService.InsertQueueGlassIds((short) 1, form3);

                            }

                        }

                    }

                    plc1=true;

                } else {

                    plc1=false;

                    log.info("Plc1" + S7controlLK.getinstance().CheckConnected());

                }

                jsonObject.append("zhi", zhi);

                jsonObject.append("Plc1", plc1);

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

                ArrayList<WebSocketServer> sendwServer = WebSocketServer.sessionMap.get("Home");

                if (sendwServer != null) {

                    for (WebSocketServer webserver : sendwServer) {

                        if (webserver != null && webserver.session.isOpen()) {

                            webserver.sendMessage(jsonObject.toString());

                            List<String> messages = webserver.getMessages();

                            if (!messages.isEmpty()) {

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

                                webserver.clearMessages();

                            }

                        } else {

                            log.info("Home is closed");

                        }

                    }

                }

            } catch (InterruptedException | SQLException e) {

                e.printStackTrace();

            }



        }

    }

}