package com.example.springboot.component;
|
|
import cn.hutool.json.JSONObject;
|
|
import java.sql.SQLException;
|
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.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;
|
|
@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);
|
jdbcConnections = WebSocketServer.applicationContext.getBean(JdbcConnections.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);
|
for (StorageCage storageCage : tasklist1) {
|
// storageCage.setnorth_glass_buffer1s(homeMapper.SelectBoxNo(storageCage.getGlassId()));
|
try {
|
storageCage.setnorth_glass_buffer1s(jdbcConnections.SelectGlassByGlassIdOrderIdFrameId("", "", ""));
|
} catch (SQLException e) {
|
e.printStackTrace();
|
}
|
try {
|
storageCage.setnorth_glass_buffer1s(
|
jdbcConnections.SelectGlassByGlassIdOrderIdFrameId(storageCage.getGlassId(), "", ""));
|
} catch (SQLException e) {
|
e.printStackTrace();
|
}
|
}
|
for (StorageCage storageCage : tasklist2) {
|
// storageCage.setnorth_glass_buffer1s(homeMapper.SelectBoxNo(storageCage.getGlassId()));
|
try {
|
storageCage.setnorth_glass_buffer1s(
|
jdbcConnections.SelectGlassByGlassIdOrderIdFrameId(storageCage.getGlassId(), "", ""));
|
} catch (SQLException e) {
|
e.printStackTrace();
|
}
|
|
}
|
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);
|
// 获取扫码位与上片位玻璃信息
|
String queueglassid2 = homeMapper.GetQueueInfo(2);
|
String queueglassid1 = homeMapper.GetQueueInfo(1);
|
// north_glass_buffer1 form2 = homeMapper.SelectGlassByGlassID(queueglassid2);
|
// north_glass_buffer1 form3 = homeMapper.SelectGlassByGlassID(queueglassid1);
|
|
north_glass_buffer1 form2;
|
if(queueglassid2.length()!=0){
|
try {
|
form2 = jdbcConnections.SelectGlassByGlassIdOrderIdFrameId(queueglassid2, "", "");
|
jsonObject.append("form2", form2);
|
} catch (SQLException e) {
|
e.printStackTrace();
|
}
|
}
|
|
north_glass_buffer1 form3;
|
if(queueglassid1.length()!=0){
|
try {
|
form3 = jdbcConnections.SelectGlassByGlassIdOrderIdFrameId(queueglassid1, "", "");
|
jsonObject.append("form3", form3);
|
} catch (SQLException e) {
|
e.printStackTrace();
|
}
|
}
|
|
|
// 获取出片队列信息
|
List<Out_slice> listoutslice = homeMapper.SelectProductionqueue();
|
for (Out_slice out_slice : listoutslice) {
|
out_slice.setnorth_glass_buffer1s(homeMapper.SelectBoxNo(out_slice.getGlassId()));
|
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) {
|
sendwServer.sendMessage(jsonObject.toString());
|
}
|
|
}
|
}
|
}
|
