package com.example.springboot.component;
|
|
import cn.hutool.json.JSONObject;
|
import java.util.List;
|
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 {
|
|
private HomeMapper homeMapper;
|
private SpianMapper spianMapper;
|
private JdbcConnections dbserve;
|
|
@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);
|
// 笼子使用情况
|
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()));
|
}
|
for (StorageCage storageCage : tasklist2) {
|
storageCage.setnorth_glass_buffer1s(homeMapper.SelectBoxNo(storageCage.getGlassId()));
|
}
|
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();
|
String 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);
|
jsonObject.append("form2", form2);
|
jsonObject.append("form3", form3);
|
// List<Short> paramlists = new ArrayList<Short>();
|
// short para1 = 11111;
|
// short para2 = 32000;
|
// paramlists.add(para1);
|
// paramlists.add(para2);
|
// System.out.println(paramlists);
|
|
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());
|
}
|
|
}
|
}
|
}
|
