package com.mes.job;
|
|
import cn.hutool.core.lang.Assert;
|
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.github.yulichang.toolkit.JoinWrappers;
|
import com.mes.bigstorage.entity.BigStorageCage;
|
import com.mes.bigstorage.entity.BigStorageCageDetails;
|
import com.mes.bigstorage.entity.BigStorageDTO;
|
import com.mes.bigstorage.entity.dto.SlotSequenceDTO;
|
import com.mes.bigstorage.entity.dto.TemperingLayoutDTO;
|
import com.mes.bigstorage.service.BigStorageCageDetailsService;
|
import com.mes.bigstorage.service.BigStorageCageService;
|
import com.mes.bigstoragetask.entity.BigStorageCageFeedTask;
|
import com.mes.bigstoragetask.entity.BigStorageCageOutTask;
|
import com.mes.bigstoragetask.service.BigStorageCageFeedTaskService;
|
import com.mes.bigstoragetask.service.BigStorageCageOutTaskService;
|
import com.mes.common.config.Const;
|
import com.mes.edgglasstask.entity.EdgGlassTaskInfo;
|
import com.mes.edgglasstask.service.EdgGlassTaskInfoService;
|
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 lombok.extern.slf4j.Slf4j;
|
import org.apache.commons.lang.StringUtils;
|
import org.springframework.beans.BeanUtils;
|
import org.springframework.beans.factory.annotation.Value;
|
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 PlcStorageCageTask {
|
|
@Resource
|
private BigStorageCageService bigStorageCageService;
|
@Resource
|
private BigStorageCageDetailsService bigStorageCageDetailsService;
|
@Resource
|
private GlassInfoService glassInfoService;
|
@Resource
|
private BigStorageCageFeedTaskService bigStorageCageFeedTaskService;
|
@Resource
|
private BigStorageCageOutTaskService bigStorageCageOutTaskService;
|
@Resource
|
private EdgGlassTaskInfoService edgGlassTaskInfoService;
|
@Resource
|
private TemperingGlassInfoService temperingGlassInfoService;
|
|
private static final String REQUEST_WORD = "1";
|
|
@Value("${mes.sequence.order}")
|
private boolean sequenceOrder;
|
|
@Value("${mes.slotWidth}")
|
private Integer slotWidth;
|
|
// @Scheduled(fixedDelay = 5000)
|
public void plcToHomeEdgScan(String d01Id) {
|
// PlcParameterObject plcParameterObject = S7object.getinstance().PlcMesObject;
|
// String d01Request = plcParameterObject.getPlcParameter("D01Request").getValue();
|
// String d01Id = plcParameterObject.getPlcParameter("D01ID1").getValue();
|
// String d02SitState = plcParameterObject.getPlcParameter("D02SitState").getValue();
|
// String d04Request = plcParameterObject.getPlcParameter("D04Request").getValue();
|
// String d04Id = plcParameterObject.getPlcParameter("D04ID1").getValue();
|
// String d05SitState = plcParameterObject.getPlcParameter("D05SitState").getValue();
|
|
String d01Request = "1";
|
String d02SitState = "0";
|
// String d01Id = "P24060403|3|6";
|
String d04Request = "0";
|
String d05SitState = "0";
|
// String d04Id = "P24060403|4|3";
|
String d04Id = "P24060403|5|4";
|
log.info("1、获取到的请求字d01为：{}，获取到的扫描ID为：{};获取到的请求字d04为：{}，获取到的扫描ID为：{};",
|
d01Request, d01Id, d04Request, d04Id);
|
if (!REQUEST_WORD.equals(d01Request) && !REQUEST_WORD.equals(d04Request)) {
|
log.info("两条线未收到进片任务，结束本次扫描进卧转立任务");
|
return;
|
}
|
if (REQUEST_WORD.equals(d02SitState) && REQUEST_WORD.equals(d05SitState)) {
|
log.info("两条线卧转立均在执行任务，结束本次扫描进卧转立任务");
|
return;
|
}
|
Boolean flag01 = Boolean.FALSE;
|
Boolean flag04 = Boolean.FALSE;
|
//按照线路及玻璃id获取相邻两块玻璃 卧转立上的玻璃
|
if (REQUEST_WORD.equals(d01Request) && !REQUEST_WORD.equals(d02SitState)) {
|
flag01 = judgeGlassTypeStatus(d01Id, Const.A09_OUT_TARGET_POSITION);
|
}
|
if (REQUEST_WORD.equals(d04Request) && !REQUEST_WORD.equals(d05SitState)) {
|
flag04 = judgeGlassTypeStatus(d04Id, Const.A10_OUT_TARGET_POSITION);
|
}
|
if (flag01 && flag04) {
|
//比较最早一片任务的版图id及版序 求出卧转立的线路
|
Integer startLine = getStartLine();
|
//计算目标格子，发送启动任务
|
computeTargetByLine(startLine);
|
} else if (flag01 || flag04) {
|
Integer startLine = flag01.equals(Boolean.TRUE) ? Const.A09_OUT_TARGET_POSITION : Const.A10_OUT_TARGET_POSITION;
|
//计算目标格子，发送启动任务
|
computeTargetByLine(startLine);
|
} else {
|
log.info("两条线未收到进片任务，结束本次扫描进卧转立任务");
|
}
|
}
|
|
// @Scheduled(fixedDelay = 5000)
|
public void plcToHomeEdgFreeCarTask() {
|
// PlcParameterObject plcParameterObject = S7object.getinstance().PlcMesObject;
|
// String e01Status = plcParameterObject.getPlcParameter("E01Status").getValue();
|
String e01Status = "0";
|
if (REQUEST_WORD.equals(e01Status)) {
|
log.info("进片大车非空闲");
|
return;
|
}
|
// String d01Request = plcParameterObject.getPlcParameter("D01Request").getValue();
|
// String d01Id = plcParameterObject.getPlcParameter("D01ID1").getValue();
|
// String d04Request = plcParameterObject.getPlcParameter("D04Request").getValue();
|
// String d04Id = plcParameterObject.getPlcParameter("D04ID1").getValue();
|
String d01Request = "";
|
String d01Id = "";
|
String d04Request = "1";
|
String d04Id = "";
|
log.info("1、获取到的请求字d01为：{}，获取到的扫描ID为：{};获取到的请求字d04为：{}，获取到的扫描ID为：{};",
|
d01Request, d01Id, d04Request, d04Id);
|
//两条线都有进卧转立任务，直接结束
|
if (Const.BIG_STORAGE_REQUEST_IN.equals(d01Request)
|
&& Const.BIG_STORAGE_REQUEST_IN.equals(d04Request)) {
|
log.info("两条线都存在进片任务，结束任务");
|
return;
|
}
|
//获取两条线卧转立是否有玻璃，且任务状态都为2
|
List<Integer> lineList = bigStorageCageFeedTaskService.querySitToUpGlass();
|
if (CollectionUtils.isEmpty(lineList)) {
|
log.info("两条线卧转立为空或者有进片任务未完成，结束任务");
|
return;
|
}
|
Integer lineFirst = lineList.get(0);
|
String lineGlassId = lineFirst.equals(Const.A09_OUT_TARGET_POSITION) ? d01Id : d04Id;
|
if (lineList.size() == 1) {
|
//计算任务表进片格子 发送进片任务
|
if (StringUtils.isEmpty(lineGlassId)) {
|
computeTargetByLine(lineFirst);
|
}
|
return;
|
}
|
if (StringUtils.isBlank(d01Id) && StringUtils.isBlank(d04Id)) {
|
//比较最早一片任务的版图id及版序 求出卧转立的线路
|
Integer line = getStartLine();
|
//计算任务表进片格子 发送进片任务
|
computeTargetByLine(line);
|
return;
|
}
|
int outLine = StringUtils.isBlank(d01Id) ? Const.A09_OUT_TARGET_POSITION : Const.A10_OUT_TARGET_POSITION;
|
//计算任务表进片格子 发送进片任务
|
computeTargetByLine(outLine);
|
}
|
|
// @Scheduled(fixedDelay = 5000)
|
public void plcToHomeEdgOutTask() {
|
//任务数据 获取车子存放玻璃最大数量 玻璃间隔
|
List<BigStorageCageOutTask> bigStorageCageOutTaskList = new ArrayList<>();
|
//是否有正在钢化的玻璃
|
List<TemperingGlassInfo> temperingGlassInfoList = temperingGlassInfoService.list(new LambdaQueryWrapper<TemperingGlassInfo>()
|
.eq(TemperingGlassInfo::getState, Const.TEMPERING_NEW)
|
.orderBy(Boolean.TRUE, sequenceOrder, TemperingGlassInfo::getTemperingFeedSequence));
|
if (CollectionUtils.isNotEmpty(temperingGlassInfoList)) {
|
log.info("有正在出片的钢化任务");
|
//打车剩余尺寸
|
Integer remainWidth = Const.BIG_STORAGE_WIDTH;
|
for (TemperingGlassInfo e : temperingGlassInfoList) {
|
if (bigStorageCageOutTaskList.size() > 5 || e.getWidth() > remainWidth) {
|
break;
|
}
|
remainWidth = remainWidth - e.getWidth().intValue() - Const.BIG_STORAGE_GAP;
|
bigStorageCageOutTaskList.add(new BigStorageCageOutTask(e.getGlassId(), e.getState(), Const.A09_OUT_TARGET_POSITION,
|
e.getWidth().intValue(), 0, 0, 1));
|
}
|
bigStorageCageOutTaskService.saveBatch(bigStorageCageOutTaskList);
|
return;
|
}
|
//是否有人工下片任务 有直接出
|
List<BigStorageCageDetails> artificialList = bigStorageCageDetailsService.list(new LambdaQueryWrapper<BigStorageCageDetails>()
|
.eq(BigStorageCageDetails::getState, Const.GLASS_STATE_ARTIFICIAL).orderByDesc(BigStorageCageDetails::getWidth));
|
if (CollectionUtils.isNotEmpty(artificialList)) {
|
Integer remainWidth = Const.BIG_STORAGE_WIDTH;
|
for (BigStorageCageDetails e : artificialList) {
|
if (remainWidth < e.getWidth().intValue()) {
|
break;
|
}
|
bigStorageCageOutTaskList.add(new BigStorageCageOutTask(e.getGlassId(), e.getSlot(), Const.A10_OUT_TARGET_POSITION,
|
e.getWidth().intValue(), 0, 0, 1));
|
remainWidth = remainWidth - e.getWidth().intValue() - Const.BIG_STORAGE_GAP;
|
}
|
bigStorageCageOutTaskService.saveBatch(bigStorageCageOutTaskList);
|
return;
|
}
|
//钢化优先：获取理片笼 玻璃小片 破损表 数量 判断笼内版图是否到齐
|
TemperingLayoutDTO temperingLayoutDTO = bigStorageCageDetailsService.temperingIsAll();
|
if (null != temperingLayoutDTO) {
|
//玻璃到齐
|
//到齐，将玻璃小片数据存入钢化小片表，逻辑生成出片任务 结束
|
List<TemperingGlassInfo> temperingGlassInfos = glassInfoService.selectJoinList(TemperingGlassInfo.class, JoinWrappers.lambda(GlassInfo.class)
|
.selectAll(GlassInfo.class)
|
.selectAs(BigStorageCageDetails::getSlot, TemperingGlassInfo::getSlot)
|
.innerJoin(BigStorageCageDetails.class, BigStorageCageDetails::getGlassId, GlassInfo::getGlassId)
|
.eq(BigStorageCageDetails::getState, Const.GLASS_STATE_IN)
|
.eq(GlassInfo::getTemperingLayoutId, temperingLayoutDTO.getTemperingLayoutId())
|
.eq(GlassInfo::getEngineerId, temperingLayoutDTO.getEngineerId()));
|
temperingGlassInfoService.saveBatch(temperingGlassInfos);
|
|
//大车剩余尺寸
|
Integer remainWidth = Const.BIG_STORAGE_WIDTH;
|
for (TemperingGlassInfo e : temperingGlassInfos) {
|
if (bigStorageCageOutTaskList.size() > 5 || e.getWidth() > remainWidth) {
|
break;
|
}
|
remainWidth = remainWidth - e.getWidth().intValue() - Const.BIG_STORAGE_GAP;
|
bigStorageCageOutTaskList.add(new BigStorageCageOutTask(e.getGlassId(), e.getState(), Const.A09_OUT_TARGET_POSITION,
|
e.getWidth().intValue(), 0, 0, 1));
|
}
|
bigStorageCageOutTaskService.saveBatch(bigStorageCageOutTaskList);
|
return;
|
}
|
//未到齐 执行内部调度任务
|
TemperingLayoutDTO temperingOccupySlot = bigStorageCageDetailsService.queryTemperingOccupySlot();
|
if (null != temperingOccupySlot) {
|
List<SlotSequenceDTO> slotSequenceList = bigStorageCageDetailsService.queryGlassMaxAndMin(temperingOccupySlot.getEngineerId(), temperingOccupySlot.getTemperingLayoutId());
|
for (int i = 0; i < slotSequenceList.size() - 1; i++) {
|
SlotSequenceDTO first = slotSequenceList.get(i);
|
SlotSequenceDTO second = slotSequenceList.get(i + 1);
|
int slotWidth = Const.BIG_STORAGE_WIDTH - first.getRemainWidth() - Const.BIG_STORAGE_GAP;
|
if (first.getMinSequence() == second.getMaxSequence() + 1
|
&& second.getRemainWidth() > slotWidth) {
|
List<BigStorageCageDetails> list = bigStorageCageDetailsService.list(new LambdaQueryWrapper<BigStorageCageDetails>()
|
.eq(BigStorageCageDetails::getSlot, first.getSlot()).eq(BigStorageCageDetails::getState, Const.GLASS_STATE_IN));
|
List<BigStorageCageOutTask> outTasks = list.stream().map(e -> new BigStorageCageOutTask(e.getGlassId(), first.getSlot(), second.getSlot(),
|
slotWidth, 0, 0, 1)).collect(Collectors.toList());
|
bigStorageCageOutTaskService.saveBatch(outTasks);
|
return;
|
}
|
}
|
}
|
}
|
|
|
/**
|
* 按照玻璃id判断玻璃状态及卧转立是否可直接启动
|
*/
|
public Boolean judgeGlassTypeStatus(String glassId, Integer line) {
|
//1、获取任务表中相邻玻璃
|
List<EdgGlassTaskInfo> edgGlassTaskInfoList = edgGlassTaskInfoService.list(new LambdaQueryWrapper<EdgGlassTaskInfo>()
|
.eq(EdgGlassTaskInfo::getLine, line)
|
.apply("time >= (select time from edg_glass_task_info where glass_id = '" + glassId + "')")
|
.orderByAsc(EdgGlassTaskInfo::getTime));
|
Assert.isFalse(CollectionUtils.isEmpty(edgGlassTaskInfoList), "识别玻璃信息未出现在尺寸表中,获取相邻两块玻璃失败");
|
//2、获取卧转立剩余宽度
|
BigStorageDTO sitToUpRemainWidth = bigStorageCageFeedTaskService.querySitToUpRemainWidth(line);
|
Integer remainWidth;
|
Integer glassCount;
|
if (0 == sitToUpRemainWidth.getGlassCount()) {
|
remainWidth = Const.BIG_STORAGE_WIDTH;
|
glassCount = 0;
|
} else {
|
remainWidth = sitToUpRemainWidth.getWidth();
|
glassCount = sitToUpRemainWidth.getGlassCount();
|
}
|
//2、获取卧转立
|
Integer widthFirst = edgGlassTaskInfoList.get(0).getWidth();
|
if (edgGlassTaskInfoList.size() == 1) {
|
if (remainWidth >= widthFirst) {
|
if (glassCount <= 5) {
|
addFeedTask(glassId, line, Const.BIG_STORAGE_IN_WAIT, widthFirst);
|
return Boolean.FALSE;
|
} else {
|
addFeedTask(glassId, line, Const.BIG_STORAGE_IN_RUN, widthFirst);
|
return Boolean.TRUE;
|
}
|
}
|
} else {
|
Integer widthSecond = edgGlassTaskInfoList.get(1).getWidth();
|
if (remainWidth >= widthFirst) {
|
if (remainWidth - widthFirst - Const.BIG_STORAGE_GAP >= widthSecond) {
|
if (glassCount <= 5) {
|
addFeedTask(glassId, line, Const.BIG_STORAGE_IN_WAIT, widthFirst);
|
return Boolean.FALSE;
|
} else {
|
addFeedTask(glassId, line, Const.BIG_STORAGE_IN_RUN, widthFirst);
|
return Boolean.TRUE;
|
}
|
} else {
|
addFeedTask(glassId, line, Const.BIG_STORAGE_IN_RUN, widthFirst);
|
}
|
}
|
}
|
//记录无法放下玻璃，后续判断启动
|
return Boolean.TRUE;
|
}
|
|
/**
|
* 添加任务信息
|
*/
|
private Boolean addFeedTask(String glassId, Integer line, Integer taskType, Integer width) {
|
BigStorageCageFeedTask bigStorageCageFeedTask = new BigStorageCageFeedTask();
|
bigStorageCageFeedTask.setGlassId(glassId);
|
bigStorageCageFeedTask.setTaskState(Const.BIG_STORAGE_IN_NEW);
|
bigStorageCageFeedTask.setLine(line);
|
bigStorageCageFeedTask.setTaskType(taskType);
|
bigStorageCageFeedTask.setWidth(width);
|
bigStorageCageFeedTask.setCreateTime(new Date());
|
return bigStorageCageFeedTaskService.save(bigStorageCageFeedTask);
|
}
|
|
/**
|
* 获取需要启动的线路：两条线都可启动 获取第一片玻璃版图id最小 版序最大的线路
|
*
|
* @return 需要启动的线路
|
*/
|
public Integer getStartLine() {
|
List<BigStorageCageFeedTask> taskList = bigStorageCageFeedTaskService.list(new LambdaQueryWrapper<BigStorageCageFeedTask>()
|
.inSql(BigStorageCageFeedTask::getId, "select min(id) from big_storage_cage_feed_task where task_state = 2 group by line"));
|
Assert.isFalse(CollectionUtils.isEmpty(taskList), "卧转立两条线都没有玻璃进片任务");
|
Map<String, Integer> taskMap = taskList.stream().collect(Collectors.toMap(BigStorageCageFeedTask::getGlassId,
|
BigStorageCageFeedTask::getLine));
|
GlassInfo glassInfo = glassInfoService.getOne(new LambdaQueryWrapper<GlassInfo>()
|
.in(GlassInfo::getGlassId, taskMap.keySet())
|
.orderByAsc(GlassInfo::getTemperingLayoutId)
|
.orderBy(Boolean.TRUE, sequenceOrder, GlassInfo::getTemperingFeedSequence)
|
.last("limit 1"));
|
return taskMap.get(glassInfo.getGlassId());
|
}
|
|
/**
|
* 计算任务表进片线路的目标格子，并启动任务
|
*/
|
public boolean computeTargetByLine(Integer line) {
|
//1、获取任务表中的所有玻璃（指定线路且已经进卧转立完成）
|
List<BigStorageCageFeedTask> taskList = bigStorageCageFeedTaskService.list(new LambdaQueryWrapper<BigStorageCageFeedTask>()
|
.eq(BigStorageCageFeedTask::getLine, line)
|
.in(BigStorageCageFeedTask::getTaskState, Const.BIG_STORAGE_IN_UP_ALL)
|
.orderByAsc(BigStorageCageFeedTask::getId));
|
//2、去笼子内查找是否可以继续存放的笼子
|
List<String> glassIds = taskList.stream().map(BigStorageCageFeedTask::getGlassId).collect(Collectors.toList());
|
List<GlassInfo> glassInfos = glassInfoService.list(new LambdaQueryWrapper<GlassInfo>().in(GlassInfo::getGlassId, glassIds));
|
return computeIsTemperingTargetByLine(glassInfos, taskList, Boolean.TRUE) && computeIsTemperingTargetByLine(glassInfos, taskList, Boolean.FALSE);
|
}
|
|
/**
|
* 是否钢化玻璃进笼目标位置
|
*
|
* @param glassInfos 当条线卧转立所有玻璃
|
* @param taskList 当条线卧转立所有任务
|
* @param isTempering true 钢化 false 不钢化
|
*/
|
private boolean computeIsTemperingTargetByLine(List<GlassInfo> glassInfos, List<BigStorageCageFeedTask> taskList, Boolean isTempering) {
|
//1、将玻璃信息集合转为glassid为key的map
|
Map<String, GlassInfo> glassInfoMap = glassInfos.stream()
|
.collect(Collectors.toMap(GlassInfo::getGlassId, p -> p));
|
for (BigStorageCageFeedTask e : taskList) {
|
GlassInfo info = glassInfoMap.get(e.getGlassId());
|
if (info == null) {
|
continue;
|
}
|
BigStorageCageDetails cageDetails = new BigStorageCageDetails();
|
BeanUtils.copyProperties(info, cageDetails);
|
//2、获取目标格子信息
|
BigStorageDTO bigStorageDTO = bigStorageCageDetailsService.queryTargetSlotByTempering(info);
|
//3、更新大理片笼表剩余宽度
|
bigStorageCageService.update(new LambdaUpdateWrapper<BigStorageCage>().set(BigStorageCage::getRemainWidth, bigStorageDTO.getWidth())
|
.eq(BigStorageCage::getSlot, bigStorageDTO.getSlot()));
|
//4、更新进片任务表，目标格子及状态（状态改为2 电气扫到自行处理） 遇到问题：无法批量更新，批量更新无法走指定从库
|
e.setTargetSlot(bigStorageDTO.getSlot());
|
e.setTaskType(Const.BIG_STORAGE_IN_RUN);
|
bigStorageCageFeedTaskService.updateById(e);
|
|
//5、将进片信息存入大理片笼详情表
|
cageDetails.setSlot(bigStorageDTO.getSlot());
|
cageDetails.setState(Const.GLASS_STATE_IN);
|
bigStorageCageDetailsService.save(cageDetails);
|
}
|
return Boolean.TRUE;
|
}
|
}
|
