package com.example.springboot.component; import java.sql.SQLException; import java.util.ArrayList; import java.util.Base64; import java.util.List; import org.apache.ibatis.javassist.compiler.ast.Symbol; import org.springframework.beans.factory.annotation.Autowired; import com.example.springboot.service.JdbcConnections; import com.example.springboot.service.SpianService; import com.example.springboot.entity.Glass; import com.example.springboot.entity.north_glass_buffer1; import com.example.springboot.mapper.AlarmMapper; import com.example.springboot.mapper.SpianMapper; public class PlcHold extends Thread { private AlarmMapper alarmMapper; @Autowired private JdbcConnections jdbcConnections; private SpianMapper spianMapper; private SpianService spianService; @Override public void run() { boolean inglassbegin = false; boolean outglassbegin = false; while (this != null) { try { Thread.sleep(1000); } catch (InterruptedException e) { // \\ TODO Auto-generated catch block e.printStackTrace(); } spianService = WebSocketServer.applicationContext.getBean(SpianService.class); spianMapper = WebSocketServer.applicationContext.getBean(SpianMapper.class); jdbcConnections = WebSocketServer.applicationContext.getBean(JdbcConnections.class); // 根据玻璃id获取订单号,单独数据源 // try { // north_glass_buffer1 glass = jdbcConnections.selectGlass(112); // // System.out.println(glass.getOrderId()); // } catch (SQLException e) { // // TODO Auto-generated catch block // e.printStackTrace(); // } // 判断进片请求 List datas1List = S7control.getinstance().ReadWord("DB106.24", 1);// 获取prc进片请求数据 List datas1ListState = S7control.getinstance().ReadWord("DB106.8", 1);// 获取进片车状态 List datas1ListState2 = S7control.getinstance().ReadWord("DB105.16", 1);// 获取进片车任务是否启动 boolean B01backs = spianService.listbool("DB106.60");// b01汇报 boolean B02backs = spianService.listbool("DB106.62");// b02汇报 StringBuilder B01glassid = spianService.queGlassid("DB103.184", 14);// BO1的玻璃id StringBuilder B02glassid = spianService.queGlassid("DB103.212", 14);// B02的玻璃id // 当进片小车完成任务时 if (B01backs == true) { // 当B01小车汇报完成时更改玻璃状态为1 spianMapper.UpdateCageOver(B01glassid.toString(), 1);// 更改笼子表进片状态 spianMapper.Updatetask(1, 0);// 更改进片任务状态为1 spianMapper.overqueue(B01glassid.toString(), 0);// 更改上片任务表的状态为0 S7control.getinstance().WriteWord("DB106.60", (short) 0);// 恢复B01小车应答改为0 S7control.getinstance().WriteWord("DB105.48", (short) 1);//汇报B01小车收到 } // 当出片小车完成任务时 if (B02backs == true) { // 当B02小车汇报完成时更改玻璃状态为0 spianMapper.UpdateCageOver(B02glassid.toString(), 0);// 更改笼子表出片状态 spianMapper.UpdatetaskOut(B02glassid.toString()); // 完成上一次出片或者调度任务 S7control.getinstance().WriteWord("DB105.50", (short) 0);// 恢复B02小车应答改为0 // S7control.getinstance().WriteWord("DB105.50", (short) 1);//汇报B02小车收到 } // 获取DO1数据 StringBuilder queueid1 = spianService.queGlassid("DB103.44", 14); // 获取DO2数据 StringBuilder queueid2 = spianService.queGlassid("DB103.58", 14); System.out.println("D01|" + queueid1); System.out.println("D02|" + queueid2); int questate = spianMapper.Selectquecount(queueid1.toString());// 判断扫码位是否有玻璃已确认 // queueid1.toString().isEmpty() north_glass_buffer1 glass1 = spianMapper.selectGlass(queueid1.toString());// D01的玻璃信息 north_glass_buffer1 glass2 = spianMapper.selectGlass(queueid2.toString());// D02玻璃信息 // 当扫码位玻璃id为空时 宽度为0 if (queueid1 != null&&questate==0) { // 写入D01的数据到上片队列表 if (glass1 == null) { //当没有值时传空 spianMapper.Updatequeue(null,null,null,null, 0, null, null, null, null, 1); } else { spianMapper.overqueue2(queueid2.toString(), 0, 1);// 更改扫码位任务表的状态为0 spianMapper.Updatequeue(queueid1.toString(),glass1.getordernumber(),glass1.getlistnumber(),glass1.getboxnumber(),0,glass1.getglasslengthmm().toString(),glass1.getglassheightmm().toString(),glass1.getglasslength().toString(),glass1.getglassheight().toString(),1); } } if (queueid2 != null) { // 写入D02的数据到上片队列表 if(glass2==null){ spianMapper.Updatequeue(null,null,null,null, 0, null, null, null, null, 2); }else{ spianMapper.Updatequeue(queueid1.toString(),glass2.getordernumber(),glass2.getlistnumber(),glass2.getboxnumber(),0,glass2.getglasslengthmm().toString(),glass2.getglassheightmm().toString(),glass2.getglasslength().toString(),glass2.getglassheight().toString(),2); S7control.getinstance().WriteWord("DB105.16", (short) 0);//关闭任务启动 } } // 出片任务//////////////////////////////// List outlist = S7control.getinstance().ReadWord("DB106.20", 1); // 出片车状态 List outlist1 = S7control.getinstance().ReadWord("DB105.18", 1); // 出片任务是否启动 // StringBuilder writedstrIdOut = new StringBuilder(); // 获取已下发的出片id byte[] writedglassidbytesOut = S7control.getinstance().ReadByte("DB105.30", 14); String writedstrIdOut = new String(writedglassidbytesOut); boolean outstate = false;// 出片车空闲判断 boolean outstate1 = false;// 出片车任务是否启动 if (outlist != null && outlist1 != null) { // 判断按订单出片 outstate = outlist.contains((short) 0);// 出片车空闲判断 outstate1 = outlist1.contains((short) 1);// 出片车任务是否启动 north_glass_buffer1 glass = spianMapper.SelectDBOut();// 判断是否有调拨后的出片任务未完成 if (!outglassbegin & !outstate)// 当任务还未开始,且出片车不空闲时,任务状态改为开始 { outglassbegin = true; } if (outglassbegin & outstate)// 当任务开始且出片车空闲时 { outglassbegin = false; } if (outstate == true & glass.getbarcode() != null) { // 当出片车空闲且有出片任务待完成时 // 判断有两个出片或调拨任务时并且出片id和未完成的出片任务id不一样时执行出片 if (!writedstrIdOut.toString().equals(glass.getbarcode().toString())) { spianService.selectout2(glass.getbarcode().toString()); outstate = false; } } // 判断当前是否有未执行的任务 int outnum = spianMapper.SelectOutSliceshu(); // 当没有任务执行并且出片车空闲时 if (outnum == 0 && outstate == true) { // 判断铝框出片队列表是否有待出片的玻璃 String outglassid = spianMapper.SelectOutSlice(); if (outglassid != null) { spianService.selectout2(outglassid); outstate = false; } } if (outstate == true) {// 下发任务后将任务启动改为0//出片车空闲判断 if (outstate1 == true) { S7control.getinstance().WriteWord("DB105.18", (short) 0);// 出片任务启动改为0 } } } // if (outstate == true) { // 出片车状态空闲时 // Integer state = spianMapper.Selectoutstate(); // String orderid = spianMapper.SelectOrderout(); // if (orderid != null && state == 0) { // spianService.selectout(orderid); // } // } // 查询数据库 // 推送到前端 } } }