DB区josn文件上传

wu

2024-01-26 3f4124093b81a6ccd6a393947cab2282ab13b248

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

@@ -1,23 +1,24 @@
package com.example.springboot.component;



import cn.hutool.json.JSONArray;

import cn.hutool.json.JSONObject;



import java.io.IOException;

import java.sql.SQLException;

import java.util.ArrayList;

import java.util.Arrays;

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;

import com.example.springboot.service.JdbcConnections;

import com.example.springboot.service.North_Glass_Buffer1Service;

import com.example.springboot.service.OutSliceServive;

import com.example.springboot.service.SpianService;



public class Plchome extends Thread {



@@ -30,30 +31,42 @@
    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 String FrameNo = "";

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

    public static Boolean isConfirm = false;

    // 待确认的出片队列

    public static List<north_glass_buffer1> AluminumFrame;



    // private Configuration config;



    private StorageCageService storageCageService;



    // public Plchome() throws IOException {

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

    // }



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

    // b.put()

    @Override

    public void run() {

        while (this != null) {

            JSONObject jsonObject = new JSONObject();

            try {

                Thread.sleep(1000);

                // 注入mapper



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

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

            jsonObject.append("tableData", tableData);

@@ -74,25 +87,7 @@
            // 查询报警信息

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

@@ -110,73 +105,178 @@
            // 获取出片队列信息

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

            jsonObject.append("listoutslice", listoutslice);

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

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

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



            // 获取铝框idDB106.DBW64

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

            // if(frameno!=Plchome.FrameNo&&frameno!=""){

            // Plchome.FrameNo=frameno;

            // }

            // try {

            // north_Glass_Buffer1Service.AddOutSliceS(Plchome.FrameNo);

            // } catch (SQLException e) {

            // // TODO Auto-generated catch block

            // e.printStackTrace();

            // }

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

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

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

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

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

            jsonObject.append("isConfirm", isConfirm);

            // 查询当前铝框信息

            Out_slice CurrentFrame = outSliceServive.SelectCurrentFrame();

            jsonObject.append("CurrentFrame", CurrentFrame);



            // 获取进片请求状态

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

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

            // boolean D01RequestState =true;

            jsonObject.append("D01RequestState", D01RequestState);

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

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



            // 复位倒计时

            // 地址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> resets = S7control.getinstance().ReadBits("DB103.284", 1);

            for (Boolean reset : resets) {

                jsonObject.append("reset", reset);

            }

            


            // 是否急停

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

            for (Boolean emergencystop : emergencystops) {

                jsonObject.append("emergencystop", emergencystop);

            }

            
            


           


            // 铝框线交互

            if (CurrentFrame != null) {

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

            }

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

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

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

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

            Short framerequest = liststate.get(0);

                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 = 0;

                    } else {

                        send = 1;

                    }

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

                }

            
            


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

            // }

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

                // 获取当前扫码方式



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

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

                if (Scanningmethods != null) {

                    for (Boolean Scanningmethod : Scanningmethods) {

                        jsonObject.append("Scanningmethod", Scanningmethod);

                    }

                }



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

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

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

                }



                // 获取进片请求状态

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

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

                // boolean D01RequestState =true;

                jsonObject.append("D01RequestState", D01RequestState);



                // 复位倒计时

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

                // 复位完成信号ss

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

                }

            }



            } catch (InterruptedException e) {

                e.printStackTrace();

            }

            


            
            
            boolean dbconnected = false;

            try {

                dbserve.getConn();

@@ -191,9 +291,20 @@
            if (sendwServer != null) {

                for (WebSocketServer webserver : sendwServer) {

                    webserver.sendMessage(jsonObject.toString());



                    if (webserver != null) {



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



                        if (!messages.isEmpty()) {

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

                            webserver.clearMessages();

                        }



                    }



                }

            }



        }

    }

}