增加xlsx转换为json 工具类

wuyouming666

2024-01-22 64cad8c9b74d1450e873ce378110a7ed8c1aef56

 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,10 +31,23 @@
    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()

@@ -42,13 +56,14 @@
        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);

@@ -74,25 +89,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,60 +107,197 @@
            // 获取出片队列信息

            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> listd17 = S7control.getinstance().ReadWord("DB17.0",10);

            // String id=spianService.queGlassid("DB17.10", 14).toString();

            //

            // // 铝框线交互

            // try {

            // if (CurrentFrame != null) {

            // spianService.outmesid(CurrentFrame.getBarCode(), "DB17.0");

            // }

            // List<Short> framerequests = S7control.getinstance().ReadWord("铝框id请求字地址", 1);

            // for (Short framerequest : framerequests) {

            // if (framerequest == 1) {

            // // 铝框id

            // String franmeno = spianService.queGlassid("DB17.10", 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);

            // }

            // }

            // } catch (Exception e) {

            // // TODO: handle exception

            // }



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

                }

            }

            


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

            }



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

            // 是否急停

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

            for (Boolean emergencystop : emergencystops) {

                jsonObject.append("emergencystop", emergencystop);

            }



            // // 终止继续按钮

            // List<String> niuanaddressList3 =

            // Arrays.asList(config.getProperty("Parameter2.stop").split(","));

            // List<Boolean> anniuread =

            // S7control.getinstance().readBits(niuanaddressList3);

            // // Boolean[] value4 = { false, false};

            // // List<Boolean> anniuread = new ArrayList<>(Arrays.asList(value4));

            // Boolean[] value5 = { true };

            // List<Boolean> resets = new ArrayList<>(Arrays.asList(value5));

            // short[] anniuparams = new short[anniuread.size()];

            // for (int i = 0; i < anniuread.size(); i++) {

            // boolean value = anniuread.get(i);

            // anniuparams[i] = value ? (short) 1 : (short) 0;

            // }



            // short[] resets2 = new short[resets.size()];

            // for (int i = 0; i < resets.size(); i++) {

            // boolean value = resets.get(i);

            // resets2[i] = value ? (short) 1 : (short) 0;

            // }



            // for (short number : resets2) {



            // if (number == 1) {

            // jsonObject.append("Abort", anniuparams);



            // }



            // }

            // }



            storageCageService = WebSocketServer.applicationContext.getBean(StorageCageService.class);

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

            boolean dbconnected = false;

            try {

@@ -179,9 +313,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();

                        }



                    }



                }

            }



        }

    }

}