package com.mes.job;
|
|
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
|
import com.baomidou.mybatisplus.core.conditions.update.LambdaUpdateWrapper;
|
import com.baomidou.mybatisplus.core.toolkit.CollectionUtils;
|
import com.mes.bigstorage.entity.BigStorageCage;
|
import com.mes.bigstorage.entity.BigStorageCageDetails;
|
import com.mes.bigstorage.entity.BigStorageDTO;
|
import com.mes.bigstorage.service.BigStorageCageDetailsService;
|
import com.mes.bigstorage.service.BigStorageCageService;
|
import com.mes.bigstoragecageIntask.entity.BigStorageCageInTask;
|
import com.mes.bigstoragecageIntask.service.BigStorageCageInTaskService;
|
import com.mes.bigstoragetask.entity.BigStorageCageFeedTask;
|
import com.mes.bigstoragetask.entity.BigStorageCageOutTask;
|
import com.mes.bigstoragetask.entity.UpdateBigStorageCageDTO;
|
import com.mes.bigstoragetask.service.BigStorageCageFeedTaskService;
|
import com.mes.bigstoragetask.service.BigStorageCageOutTaskService;
|
import com.mes.common.config.Const;
|
import com.mes.damage.entity.Damage;
|
import com.mes.damage.service.DamageService;
|
import com.mes.glassinfo.entity.GlassInfo;
|
import com.mes.glassinfo.service.GlassInfoService;
|
import com.mes.temperingglass.entity.TemperingGlassInfo;
|
import com.mes.temperingglass.service.TemperingGlassInfoService;
|
import com.mes.tools.service.BigStorageBaseService;
|
import lombok.extern.slf4j.Slf4j;
|
import org.springframework.beans.BeanUtils;
|
import org.springframework.beans.factory.annotation.Value;
|
import org.springframework.scheduling.annotation.Scheduled;
|
import org.springframework.stereotype.Component;
|
|
import javax.annotation.Resource;
|
import java.util.ArrayList;
|
import java.util.Date;
|
import java.util.List;
|
import java.util.Map;
|
import java.util.stream.Collectors;
|
|
/**
|
* @author SNG-015
|
*/
|
@Component
|
@Slf4j
|
public class OpcPlcStorageCageTask {
|
@Resource
|
private BigStorageCageDetailsService bigStorageCageDetailsService;
|
@Resource
|
private BigStorageCageFeedTaskService bigStorageCageFeedTaskService;
|
@Resource
|
private BigStorageCageOutTaskService bigStorageCageOutTaskService;
|
@Resource
|
private TemperingGlassInfoService temperingGlassInfoService;
|
@Resource
|
private DamageService damageService;
|
|
@Resource
|
private GlassInfoService glassInfoService;
|
@Resource
|
private BigStorageCageService bigStorageCageService;
|
|
@Resource
|
private BigStorageBaseService baseService;
|
@Resource
|
private BigStorageCageInTaskService bigStorageBaseInTaskService;
|
|
@Value("${mes.glassGap}")
|
private Integer glassGap;
|
|
// @Resource
|
// private BigStorageCage bigStorageBaseInTaskService;
|
|
// @Autowired(required = false)
|
// MiloService miloService;
|
//
|
// @Resource(name = "bigStorageStartCallback")
|
// SubscriptionCallback bigStorageStartCallback;
|
|
|
// @Scheduled(fixedDelay = Long.MAX_VALUE)
|
// public void startOpcTask() throws Exception {
|
// //设备一二的进片请求
|
// miloService.subscriptionFromOpcUa(Arrays.asList("my.device01.x1", "my.device02.x1"), bigStorageStartCallback);
|
// }
|
|
// @Scheduled(fixedDelay = Long.MAX_VALUE)
|
// public void outOpcTask() throws Exception {
|
// //设备1的出片请求
|
// miloService.subscriptionFromOpcUa(Arrays.asList("my.device03.x1"), bigStorageStartCallback);
|
// }
|
|
|
@Scheduled(fixedDelay = 200)
|
public void inBigStorageTask() {
|
//todo:获取进片任务表
|
List<BigStorageCageInTask> inTaskList = bigStorageBaseInTaskService.queryTaskMessage("big_storage_cage_in_one_task");
|
if (CollectionUtils.isEmpty(inTaskList)) {
|
log.info("当前大车无进片任务，结束本地定时任务");
|
}
|
List<String> glassIdList = inTaskList.stream().map(BigStorageCageInTask::getGlassId).collect(Collectors.toList());
|
Map<String, List<BigStorageCageInTask>> taskMap = inTaskList.stream().collect(Collectors.groupingBy(BigStorageCageInTask::getGlassId));
|
List<GlassInfo> glassInfoList = glassInfoService.list(new LambdaQueryWrapper<GlassInfo>().in(GlassInfo::getGlassId, glassIdList));
|
//todo:计算目标格子
|
for (GlassInfo info : glassInfoList) {
|
//获取目标格子信息
|
BigStorageDTO bigStorageDTO = bigStorageCageDetailsService.queryTargetSlotByTempering(info);
|
// 临时更新格子的剩余尺寸：防止相邻玻璃进同一格子造成剩余尺寸不足，玻璃越界的情况，任务完成后再次更新大理片笼表剩余宽度（按照笼内玻璃数量更新大理片笼剩余尺寸）
|
bigStorageCageService.update(new LambdaUpdateWrapper<BigStorageCage>()
|
.set(BigStorageCage::getRemainWidth, bigStorageDTO.getWidth() - Math.max(info.getWidth(), info.getHeight()) - glassGap)
|
.eq(BigStorageCage::getSlot, bigStorageDTO.getSlot()));
|
BigStorageCageInTask task = taskMap.get(info.getGlassId()).get(0);
|
task.setTargetSlot(bigStorageDTO.getSlot());
|
task.setGlassId(info.getGlassId());
|
task.setTaskRunning(Const.BIG_STORAGE_TASK_RUNNING);
|
bigStorageBaseInTaskService.updateTaskMessage("", task);
|
//todo:存放历史任务
|
}
|
|
}
|
|
|
@Scheduled(fixedDelay = 300)
|
public void updateInGlassStateTask() {
|
Date startDate = new Date();
|
log.info("1、大理片笼进片完成后更新大理片笼数据任务开始执行时间：{}", startDate);
|
//因为大理片笼和出片任务是两个库的数据，所以要分开查找
|
List<Object> list = bigStorageCageDetailsService.listObjs(new LambdaQueryWrapper<BigStorageCageDetails>()
|
.select(BigStorageCageDetails::getGlassId).eq(BigStorageCageDetails::getState, Const.GLASS_STATE_NEW));
|
if (CollectionUtils.isNotEmpty(list)) {
|
log.info("2、获取所有正在进片的玻璃信息id:{}", list);
|
List<String> glassIds = list.stream().map(String::valueOf).collect(Collectors.toList());
|
List<BigStorageCageFeedTask> inSuccessGlass = bigStorageCageFeedTaskService.list(new LambdaQueryWrapper<BigStorageCageFeedTask>()
|
.in(BigStorageCageFeedTask::getGlassId, glassIds)
|
.in(BigStorageCageFeedTask::getTaskState, Const.BIG_STORAGE_IN_SLOT));
|
if (CollectionUtils.isNotEmpty(inSuccessGlass)) {
|
log.info("3、获取进片已完成的玻璃信息id:{}", inSuccessGlass);
|
List<Integer> inSuccessGlassSlot = inSuccessGlass.stream().map(BigStorageCageFeedTask::getTargetSlot).collect(Collectors.toList());
|
List<UpdateBigStorageCageDTO> storageCageDTOList = inSuccessGlass.stream().map(e -> {
|
UpdateBigStorageCageDTO storageCageDTO = new UpdateBigStorageCageDTO();
|
BeanUtils.copyProperties(e, storageCageDTO);
|
return storageCageDTO;
|
}).collect(Collectors.toList());
|
bigStorageCageDetailsService.updateBySlot(storageCageDTOList, Const.GLASS_STATE_IN);
|
log.info("4、大理片笼进片状态已完成已完成的玻璃信息id:{}", inSuccessGlass);
|
//更新理片笼玻璃尺寸
|
baseService.updateSlotRemainBySlots(inSuccessGlassSlot);
|
log.info("5、大理片笼进片目标格子尺寸更新完成");
|
}
|
|
}
|
Date endDate = new Date();
|
log.info("end:大理片笼进片完成后更新大理片笼数据任务结束时间：{}，共耗时：{}ms,结束任务", endDate, endDate.getTime() - startDate.getTime());
|
return;
|
|
}
|
|
@Scheduled(fixedDelay = 300)
|
public void updateOutGlassStateTask() {
|
Date startDate = new Date();
|
log.info("1、大理片笼出片完成后更新大理片笼数据任务开始执行时间：{}", startDate);
|
//因为大理片笼和出片任务是两个库的数据，所以要分开查找
|
List<Object> list = bigStorageCageDetailsService.listObjs(new LambdaQueryWrapper<BigStorageCageDetails>()
|
.select(BigStorageCageDetails::getGlassId).eq(BigStorageCageDetails::getState, Const.GLASS_STATE_OUT_ING));
|
if (CollectionUtils.isNotEmpty(list)) {
|
log.info("2、获取所有正在出片的玻璃信息id:{}", list);
|
List<String> glassIds = list.stream().map(String::valueOf).collect(Collectors.toList());
|
List<BigStorageCageOutTask> outSuccessGlass = bigStorageCageOutTaskService.list(new LambdaQueryWrapper<BigStorageCageOutTask>()
|
.in(BigStorageCageOutTask::getGlassId, glassIds).in(BigStorageCageOutTask::getTaskState, Const.BIG_STORAGE_OUT_ALL));
|
if (CollectionUtils.isNotEmpty(outSuccessGlass)) {
|
for (BigStorageCageOutTask bigStorageCageOutTask : outSuccessGlass
|
) {
|
if (bigStorageCageOutTask.getEndSlot().equals(Const.ARTIFICIAL_OUT_TARGET_POSITION)) {
|
temperingGlassInfoService.update(
|
new LambdaUpdateWrapper<TemperingGlassInfo>()
|
.set(TemperingGlassInfo::getState, Const.TEMPERING_END)
|
.eq(TemperingGlassInfo::getGlassId, bigStorageCageOutTask.getGlassId())
|
);
|
}
|
}
|
log.info("3、获取出片已完成的玻璃信息id:{}", outSuccessGlass);
|
List<UpdateBigStorageCageDTO> storageCageDTOList = outSuccessGlass.stream().map(e -> {
|
UpdateBigStorageCageDTO storageCageDTO = new UpdateBigStorageCageDTO();
|
storageCageDTO.setGlassId(e.getGlassId());
|
storageCageDTO.setTargetSlot(e.getStartSlot());
|
return storageCageDTO;
|
}).collect(Collectors.toList());
|
bigStorageCageDetailsService.updateBySlot(storageCageDTOList, Const.GLASS_STATE_OUT);
|
List<Integer> outSuccessSlotList = outSuccessGlass.stream().map(BigStorageCageOutTask::getStartSlot).collect(Collectors.toList());
|
log.info("4、大理片笼出片状态已完成已完成的玻璃信息id:{}", outSuccessGlass);
|
//更新理片笼玻璃尺寸
|
baseService.updateSlotRemainBySlots(outSuccessSlotList);
|
log.info("5、大理片笼进片目标格子尺寸更新完成");
|
}
|
}
|
Date endDate = new Date();
|
log.info("end:大理片笼出片完成后更新大理片笼数据任务结束时间：{}，共耗时：{}ms,结束任务", endDate, endDate.getTime() - startDate.getTime());
|
return;
|
|
}
|
|
@Scheduled(fixedDelay = 300)
|
public void updateScheduleGlassStateTask() {
|
Date startDate = new Date();
|
log.info("1、大理片笼调度完成后更新大理片笼数据任务开始执行时间：{}", startDate);
|
//因为大理片笼和调度任务是两个库的数据，所以要分开查找
|
List<Object> list = bigStorageCageDetailsService.listObjs(new LambdaQueryWrapper<BigStorageCageDetails>()
|
.select(BigStorageCageDetails::getGlassId).eq(BigStorageCageDetails::getState, Const.GLASS_STATE_SCHEDULE_ING));
|
if (CollectionUtils.isNotEmpty(list)) {
|
log.info("2、获取所有正在出片的玻璃信息id:{}", list);
|
List<String> glassIds = list.stream().map(String::valueOf).collect(Collectors.toList());
|
List<BigStorageCageOutTask> scheduleSuccessGlass = bigStorageCageOutTaskService.list(new LambdaQueryWrapper<BigStorageCageOutTask>()
|
.in(BigStorageCageOutTask::getGlassId, glassIds).eq(BigStorageCageOutTask::getTaskState, Const.BIG_STORAGE_OUT_SUCCESS)
|
.notIn(BigStorageCageOutTask::getEndSlot, Const.TEMPERING_OUT_TARGET_POSITION, Const.ARTIFICIAL_OUT_TARGET_POSITION));
|
if (CollectionUtils.isNotEmpty(scheduleSuccessGlass)) {
|
log.info("3、获取调度已完成的玻璃信息id:{}", scheduleSuccessGlass);
|
List<UpdateBigStorageCageDTO> storageCageDTOList = scheduleSuccessGlass.stream().map(e -> {
|
UpdateBigStorageCageDTO storageCageDTO = new UpdateBigStorageCageDTO();
|
storageCageDTO.setGlassId(e.getGlassId());
|
storageCageDTO.setTargetSlot(e.getEndSlot());
|
return storageCageDTO;
|
}).collect(Collectors.toList());
|
bigStorageCageDetailsService.updateBySlot(storageCageDTOList, Const.GLASS_STATE_IN);
|
List<String> scheduleSuccessGlassIds = scheduleSuccessGlass.stream().map(BigStorageCageOutTask::getGlassId).collect(Collectors.toList());
|
log.info("4、大理片笼出片状态已完成已完成的玻璃信息id:{}", scheduleSuccessGlassIds);
|
//更新理片笼玻璃尺寸
|
List<Integer> slotList = scheduleSuccessGlass.stream().map(BigStorageCageOutTask::getStartSlot).distinct().collect(Collectors.toList());
|
slotList.addAll(scheduleSuccessGlass.stream().map(BigStorageCageOutTask::getEndSlot).distinct().collect(Collectors.toList()));
|
baseService.updateSlotRemainBySlots(slotList);
|
log.info("5、大理片笼进片目标格子尺寸更新完成");
|
}
|
}
|
Date endDate = new Date();
|
log.info("end:大理片笼出片完成后更新大理片笼数据任务结束时间：{}，共耗时：{}ms,结束任务", endDate, endDate.getTime() - startDate.getTime());
|
return;
|
|
}
|
|
/**
|
* 处理破损表任务
|
*/
|
@Scheduled(fixedDelay = 300)
|
public void dealDamageTask() {
|
Date startDate = new Date();
|
log.info("大理片笼破损玻璃清除任务开始执行时间：{}", startDate);
|
//获取进片任务表中状态为破损的数据
|
List<BigStorageCageFeedTask> inDamageTaskInfoList = bigStorageCageFeedTaskService.list(new LambdaQueryWrapper<BigStorageCageFeedTask>()
|
.in(BigStorageCageFeedTask::getTaskState, Const.GLASS_STATE_DAMAGE_TAKE));
|
if (CollectionUtils.isNotEmpty(inDamageTaskInfoList)) {
|
log.info("获取进片任务表中破损的玻璃信息{}", inDamageTaskInfoList);
|
bigStorageCageFeedTaskService.remove(new LambdaQueryWrapper<BigStorageCageFeedTask>().in(BigStorageCageFeedTask::getTaskState, Const.GLASS_STATE_DAMAGE_TAKE));
|
//理片笼详情表数据状态更新
|
bigStorageCageDetailsService.remove(new LambdaQueryWrapper<BigStorageCageDetails>()
|
.eq(BigStorageCageDetails::getState, Const.GLASS_STATE_NEW).in(BigStorageCageDetails::getGlassId, inDamageTaskInfoList.stream().map(BigStorageCageFeedTask::getGlassId).collect(Collectors.toList())));
|
//将破损信息新增入破损表
|
List<Integer> slotList = new ArrayList<>();
|
for (BigStorageCageFeedTask bigStorageCageFeedTask : inDamageTaskInfoList) {
|
Damage damage = new Damage();
|
damage.setGlassId(bigStorageCageFeedTask.getGlassId());
|
damage.setLine(bigStorageCageFeedTask.getLine());
|
damage.setWorkingProcedure("磨边");
|
damage.setRemark("进笼前卧转立");
|
damage.setStatus(1);
|
damage.setType(bigStorageCageFeedTask.getTaskState());
|
damageService.insertDamage(damage);
|
slotList.add(bigStorageCageFeedTask.getTargetSlot());
|
}
|
//更新格子剩余宽度
|
baseService.updateSlotRemainBySlots(slotList);
|
log.info("进片任务执行完成");
|
}
|
//获取出片任务表中状态为破损的数据
|
List<BigStorageCageOutTask> outDamageTaskInfoList = bigStorageCageOutTaskService.list(new LambdaQueryWrapper<BigStorageCageOutTask>()
|
.in(BigStorageCageOutTask::getTaskState, Const.GLASS_STATE_DAMAGE_TAKE));
|
if (CollectionUtils.isNotEmpty(outDamageTaskInfoList)) {
|
log.info("获取出片任务表中破损的玻璃信息{}", outDamageTaskInfoList);
|
bigStorageCageOutTaskService.remove(new LambdaQueryWrapper<BigStorageCageOutTask>().in(BigStorageCageOutTask::getTaskState, Const.GLASS_STATE_DAMAGE_TAKE));
|
List<String> glassIdList = outDamageTaskInfoList.stream().map(BigStorageCageOutTask::getGlassId).collect(Collectors.toList());
|
//移除钢化下片表数据
|
temperingGlassInfoService.remove(new LambdaQueryWrapper<TemperingGlassInfo>().in(TemperingGlassInfo::getGlassId, glassIdList));
|
//理片笼详情表数据状态删除
|
bigStorageCageDetailsService.remove(new LambdaQueryWrapper<BigStorageCageDetails>().in(BigStorageCageDetails::getGlassId, glassIdList));
|
//将破损信息新增入破损表
|
List<Integer> slotList = new ArrayList<>();
|
for (BigStorageCageOutTask bigStorageCageOutTask : outDamageTaskInfoList) {
|
Damage damage = new Damage();
|
damage.setGlassId(bigStorageCageOutTask.getGlassId());
|
damage.setLine(bigStorageCageOutTask.getEndSlot());
|
damage.setWorkingProcedure("钢化");
|
damage.setRemark("出片后卧转立");
|
damage.setStatus(1);
|
damage.setType(bigStorageCageOutTask.getTaskState());
|
damageService.insertDamage(damage);
|
slotList.add(bigStorageCageOutTask.getStartSlot());
|
}
|
//更新格子剩余宽度
|
baseService.updateSlotRemainBySlots(slotList);
|
log.info("出片任务执行完成");
|
}
|
Date endDate = new Date();
|
log.info("大理片笼破损玻璃清除任务结束时间：{}，共耗时：{}ms,结束扫码任务", endDate, endDate.getTime() - startDate.getTime());
|
return;
|
}
|
|
|
}
|
