package com.mes.tools.service.impl;
|
|
import cn.hutool.core.lang.Assert;
|
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
|
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
|
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.bigstoragetask.entity.BigStorageCageFeedTask;
|
import com.mes.common.S7object;
|
import com.mes.common.config.Const;
|
import com.mes.device.PlcParameterObject;
|
import com.mes.glassinfo.entity.GlassInfo;
|
import com.mes.glassinfo.service.GlassInfoService;
|
import com.mes.tools.S7control;
|
import com.mes.tools.service.BigStorageBaseService;
|
import lombok.extern.slf4j.Slf4j;
|
import org.springframework.beans.factory.annotation.Value;
|
import org.springframework.scheduling.annotation.Scheduled;
|
import org.springframework.stereotype.Service;
|
|
import javax.annotation.Resource;
|
import java.util.HashMap;
|
import java.util.List;
|
import java.util.Map;
|
import java.util.Set;
|
import java.util.stream.Collectors;
|
|
/**
|
* @Author : zhoush
|
* @Date: 2024/11/8 22:03
|
* @Description:
|
*/
|
@Service
|
@Slf4j
|
public class BigStorageBaseServiceImpl implements BigStorageBaseService {
|
|
@Resource
|
BigStorageCageDetailsService bigStorageCageDetailsService;
|
|
@Resource
|
BigStorageCageService bigStorageCageService;
|
|
@Resource
|
GlassInfoService glassInfoService;
|
|
@Value("${mes.slotWidth}")
|
private Integer slotWidth;
|
|
@Value("${mes.carWidth}")
|
private Integer carWidth;
|
|
@Value("${mes.outCarMaxSize}")
|
private Integer outCarMaxSize;
|
|
@Value("${mes.glassGap}")
|
private Integer glassGap;
|
|
|
@Override
|
public void updateSlotRemainBySlots(List<Integer> slotList) {
|
//获取格子内所有的玻璃信息
|
List<BigStorageCageDetails> inSlotGlassList = bigStorageCageDetailsService.list(new LambdaQueryWrapper<BigStorageCageDetails>()
|
.in(BigStorageCageDetails::getSlot, slotList).in(BigStorageCageDetails::getState, Const.GLASS_STATE_IN_ALL));
|
Map<Integer, Double> slotRemainMap = new HashMap<>();
|
//是否存在有格子非空的玻璃
|
if (CollectionUtils.isNotEmpty(inSlotGlassList)) {
|
//存在 将格子内的玻璃分别进行更新
|
slotRemainMap = inSlotGlassList.stream()
|
.collect(Collectors.groupingBy(BigStorageCageDetails::getSlot, Collectors.summingDouble(item -> Math.max(item.getWidth(), item.getHeight()) + glassGap)));
|
slotRemainMap.forEach((e, v) -> {
|
double remainWidth = slotWidth - v >= 0 ? slotWidth - v : 0;
|
bigStorageCageService.update(new LambdaUpdateWrapper<BigStorageCage>().set(BigStorageCage::getRemainWidth, remainWidth)
|
.eq(BigStorageCage::getSlot, e));
|
});
|
}
|
//过滤不存在玻璃的格子 将宽度重置为原始宽度5000
|
Set<Integer> remainSlotList = slotRemainMap.keySet();
|
slotList.removeAll(remainSlotList);
|
if (CollectionUtils.isNotEmpty(slotList)) {
|
bigStorageCageService.update(new LambdaUpdateWrapper<BigStorageCage>().set(BigStorageCage::getRemainWidth, slotWidth)
|
.in(BigStorageCage::getSlot, slotList));
|
}
|
}
|
|
/**
|
* 按照玻璃id判断玻璃状态及卧转立是否可直接启动
|
*/
|
// public Boolean judgeGlassTypeStatus(String glassId, Integer line, String mesAddress) {
|
// //判断此玻璃是在笼内或已生成进片任务
|
// BigStorageCageFeedTask bigStorageCageFeedTask = bigStorageCageFeedTaskService.getOne(
|
// new LambdaQueryWrapper<BigStorageCageFeedTask>()
|
// .lt(BigStorageCageFeedTask::getTaskState, Const.BIG_STORAGE_IN_SLOT)
|
// .eq(BigStorageCageFeedTask::getGlassId, glassId)
|
// );
|
// BigStorageCageDetails bigStorageCageDetails = bigStorageCageDetailsService.getOne(
|
// new LambdaQueryWrapper<BigStorageCageDetails>()
|
// .eq(BigStorageCageDetails::getGlassId, glassId)
|
// .ne(BigStorageCageDetails::getState, Const.GLASS_STATE_IN)
|
// );
|
// if (bigStorageCageFeedTask != null || bigStorageCageDetails != null) {
|
// log.info("此玻璃存任务或已在笼内");
|
// return Boolean.TRUE;
|
// }
|
// //1、获取任务表中相邻玻璃
|
// List<EdgGlassTaskInfo> edgGlassTaskInfoList;
|
// edgGlassTaskInfoList = edgGlassTaskInfoService.list(new LambdaQueryWrapper<EdgGlassTaskInfo>()
|
// .eq(EdgGlassTaskInfo::getLine, line)
|
// .apply("time >= (select time from edg_glass_task_info where line='" + line + "' and glass_id = '" + glassId + "' and deleted = 0)")
|
// .orderByAsc(EdgGlassTaskInfo::getTime));
|
// if (edgGlassTaskInfoList.size() == 0) {
|
// edgGlassTaskInfoList = edgGlassTaskInfoService.list(new QueryWrapper<EdgGlassTaskInfo>()
|
// .select("Top 1 *")
|
// .eq("glass_id", glassId)
|
// );
|
// log.info("在尺寸表中获取玻璃信息{}", edgGlassTaskInfoList);
|
// if (edgGlassTaskInfoList.size() == 0) {
|
// GlassInfo glassInfo = glassInfoService.getOne(
|
// new LambdaQueryWrapper<GlassInfo>()
|
// .eq(GlassInfo::getGlassId, glassId)
|
// );
|
// EdgGlassTaskInfo edgGlassTaskInfo = new EdgGlassTaskInfo();
|
// BeanUtils.copyProperties(glassInfo, edgGlassTaskInfo);
|
// edgGlassTaskInfo.setWidth((int) glassInfo.getWidth());
|
// edgGlassTaskInfo.setHeight((int) glassInfo.getHeight());
|
// edgGlassTaskInfoList.add(edgGlassTaskInfo);
|
// log.info("在玻璃信息表中获取玻璃信息{}", edgGlassTaskInfoList);
|
// }
|
// }
|
// Assert.isFalse(CollectionUtils.isEmpty(edgGlassTaskInfoList), "识别玻璃信息未出现在尺寸表中,获取相邻两块玻璃失败");
|
// //2、获取卧转立剩余宽度
|
// BigStorageDTO sitToUpRemainWidth = bigStorageCageFeedTaskService.querySitToUpRemainWidth(line);
|
// Integer remainWidth;
|
// Integer glassCount;
|
// if (0 == sitToUpRemainWidth.getGlassCount()) {
|
// remainWidth = carWidth;
|
// glassCount = 0;
|
// } else {
|
// remainWidth = sitToUpRemainWidth.getWidth();
|
// glassCount = sitToUpRemainWidth.getGlassCount();
|
// }
|
//
|
// Boolean flag = Boolean.TRUE;
|
// //2、获取卧转立
|
// Integer widthFirst = Math.max(edgGlassTaskInfoList.get(0).getWidth() / 10, edgGlassTaskInfoList.get(0).getHeight() / 10);
|
// Integer heightFirst = Math.min(edgGlassTaskInfoList.get(0).getWidth() / 10, edgGlassTaskInfoList.get(0).getHeight() / 10);
|
// if (edgGlassTaskInfoList.size() == 1) {
|
// if (remainWidth >= widthFirst) {
|
// if (glassCount < inCarMaxSize) {
|
// addFeedTask(glassId, line, Const.BIG_STORAGE_IN_WAIT, widthFirst, heightFirst);
|
// } else {
|
// if (glassCount < inCarMaxSize + 1) {
|
// addFeedTask(glassId, line, Const.BIG_STORAGE_IN_RUN, widthFirst, heightFirst);
|
// } else {
|
// return Boolean.FALSE;
|
// }
|
// }
|
// } else {
|
// flag = Boolean.FALSE;
|
// }
|
// } else {
|
// Integer widthSecond = Math.max(edgGlassTaskInfoList.get(1).getWidth() / 10, edgGlassTaskInfoList.get(1).getHeight() / 10);
|
// Integer heightSecond = Math.min(edgGlassTaskInfoList.get(1).getWidth() / 10, edgGlassTaskInfoList.get(1).getHeight() / 10);
|
// if (remainWidth >= widthFirst) {
|
// if (remainWidth - widthFirst - glassGap >= widthSecond) {
|
// if (glassCount < inCarMaxSize) {
|
// addFeedTask(glassId, line, Const.BIG_STORAGE_IN_WAIT, widthFirst, heightFirst);
|
// } else {
|
// if (glassCount < inCarMaxSize + 1) {
|
// addFeedTask(glassId, line, Const.BIG_STORAGE_IN_RUN, widthFirst, heightFirst);
|
// } else {
|
// return Boolean.FALSE;
|
// }
|
// }
|
// } else {
|
// if (glassCount < inCarMaxSize + 1) {
|
// addFeedTask(glassId, line, Const.BIG_STORAGE_IN_RUN, widthFirst, heightFirst);
|
// } else {
|
// return Boolean.FALSE;
|
// }
|
// }
|
// } else {
|
// flag = Boolean.FALSE;
|
// }
|
// }
|
// //向plc发送进片确认
|
// if (flag) {
|
// //向plc写入确认字
|
// PlcParameterObject plcParameterObject = S7object.getinstance().PlcMesObject;
|
// int returnData = 1;
|
// int count = 1;
|
// while (returnData != 0) {
|
// S7object.getinstance().plccontrol.writeWord(mesAddress, 1);
|
//
|
// if (Const.A10_OUT_TARGET_POSITION.equals(line)) {
|
// returnData = Integer.parseInt(plcParameterObject.getPlcParameter("D04ToMES").getValue());
|
// } else {
|
// returnData = Integer.parseInt(plcParameterObject.getPlcParameter("D01ToMES").getValue());
|
// }
|
//// returnData = S7object.getinstance().plccontrol.readWord(mesAddress, 1).get(0);
|
// log.info("进卧转立第{}次发送确认字完成，地址为：{},写入的内容为{}", count++, mesAddress, 1);
|
// }
|
// }
|
// //记录无法放下玻璃，后续判断启动
|
// return flag;
|
// }
|
|
/**
|
* 添加任务信息
|
*/
|
// private Boolean addFeedTask(String glassId, Integer line, Integer taskType, Integer width, Integer height) {
|
// BigStorageCageFeedTask bigStorageCageFeedTask = new BigStorageCageFeedTask();
|
// bigStorageCageFeedTask.setGlassId(glassId);
|
// bigStorageCageFeedTask.setTaskState(Const.BIG_STORAGE_IN_NEW);
|
// bigStorageCageFeedTask.setLine(line);
|
// bigStorageCageFeedTask.setTaskType(taskType);
|
// bigStorageCageFeedTask.setWidth(width);
|
// bigStorageCageFeedTask.setHeight(height);
|
// bigStorageCageFeedTask.setCreateTime(new Date());
|
// //删除理片笼表拿走/破损数据数据
|
// damageService.deleteByGlassId(glassId);
|
// Damage damage = new Damage();
|
// damage.setGlassId(glassId);
|
// damage.setWorkingProcedure("磨边");
|
// damage.setLine(line);
|
// damage.setType(1);
|
// damage.setRemark("进大理片");
|
// damageService.insertDamage(damage);
|
// 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" +
|
// "and (target_slot = 0 or target_slot is null) 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)
|
// .and(e -> e.isNull(BigStorageCageFeedTask::getTargetSlot).or().eq(BigStorageCageFeedTask::getTargetSlot, Const.OUT_TARGET_POSITION_ZERO))
|
// .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);
|
// }
|
|
// /**
|
// * 是否钢化玻璃进笼目标位置
|
// *
|
// * @param glassInfos 当条线卧转立所有玻璃
|
// * @param taskList 当条线卧转立所有任务
|
// */
|
// private boolean computeIsTemperingTargetByLine(List<GlassInfo> glassInfos, List<BigStorageCageFeedTask> taskList) {
|
// //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);
|
// //todo:2、获取目标格子信息
|
// BigStorageDTO bigStorageDTO = bigStorageCageDetailsService.queryTargetSlotByTempering(info);
|
// //3、临时更新格子的剩余尺寸：防止相邻玻璃进同一格子造成剩余尺寸不足，玻璃越界的情况，任务完成后再次更新大理片笼表剩余宽度（按照笼内玻璃数量更新大理片笼剩余尺寸）
|
// bigStorageCageService.update(new LambdaUpdateWrapper<BigStorageCage>().set(BigStorageCage::getRemainWidth, bigStorageDTO.getWidth() - Math.max(info.getWidth(), info.getHeight()) - glassGap)
|
// .eq(BigStorageCage::getSlot, bigStorageDTO.getSlot()));
|
// //4、更新进片任务表，目标格子及状态（状态改为2 电气扫到自行处理） 遇到问题：无法批量更新，批量更新无法走指定从库
|
// e.setTargetSlot(bigStorageDTO.getSlot());
|
// bigStorageCageFeedTaskService.updateById(e);
|
//
|
// //5、将进片信息存入大理片笼详情表
|
// cageDetails.setSlot(bigStorageDTO.getSlot());
|
// cageDetails.setState(Const.GLASS_STATE_NEW);
|
// cageDetails.setDeviceId(bigStorageDTO.getDeviceId());
|
// cageDetails.setGap(glassGap);
|
// bigStorageCageDetailsService.save(cageDetails);
|
//
|
// }
|
// return Boolean.TRUE;
|
// }
|
private void sendTaskListToPLC(List<BigStorageCageFeedTask> taskList, Integer line) {
|
log.info("送片任务发送进片玻璃信息");
|
S7control s7control = S7object.getinstance().plccontrol;
|
PlcParameterObject plcMesObject = S7object.getinstance().PlcMesObject;
|
String mesD03Address = plcMesObject.getPlcParameter("MESToD03").getAddress();
|
String mesD05Address = plcMesObject.getPlcParameter("MESToD05").getAddress();
|
String outLine = line.equals(Const.A09_OUT_TARGET_POSITION) ? mesD03Address : mesD05Address;
|
for (int i = 1; i <= taskList.size(); i++) {
|
s7control.writeWord(plcMesObject.getPlcParameter("StartAddToImport" + i).getAddress(), taskList.get(i - 1).getLine());
|
s7control.writeWord(plcMesObject.getPlcParameter("TargetAddToImport" + i).getAddress(), taskList.get(i - 1).getTargetSlot());
|
log.info("向plc发送第{}片玻璃已完成,起始位置是{}，目标位置是", i, taskList.get(i - 1).getLine(), taskList.get(i - 1).getTargetSlot());
|
}
|
int returnData = 1;
|
int count = 1;
|
while (returnData != 0) {
|
s7control.writeWord(outLine, 2);
|
if (line.equals(Const.A09_OUT_TARGET_POSITION)) {
|
returnData = Integer.parseInt(plcMesObject.getPlcParameter("D03ToMES").getValue());
|
} else {
|
returnData = Integer.parseInt(plcMesObject.getPlcParameter("D05ToMES").getValue());
|
}
|
// returnData = s7control.readWord(outLine, 1).get(0);
|
log.info("已向plc第{}次发送进片任务确认，地址为：{},写入的内容为{}", count++, outLine, 2);
|
}
|
}
|
|
// /**
|
// * 出片一次仅生成一车玻璃
|
// *
|
// * @param list
|
// * @param isTempering
|
// * @param mesToPLCAddress
|
// * @param <T>
|
// * @return
|
// */
|
// private <T extends BigStorageCageBaseInfo> Boolean computeOutGlassInfo(List<T> list, Boolean isTempering, String mesToPLCAddress) {
|
// //任务数据 获取车子存放玻璃最大数量 玻璃间隔
|
// List<BigStorageCageOutTask> bigStorageCageOutTaskList = new ArrayList<>();
|
// //打车剩余尺寸
|
// Integer remainWidth = carWidth;
|
// int maxX = 0;
|
// for (T e : list) {
|
// if (bigStorageCageOutTaskList.size() >= outCarMaxSize || Math.max((int) e.getWidth(), (int) e.getHeight()) > remainWidth) {
|
// break;
|
// }
|
// remainWidth = remainWidth - Math.max((int) e.getWidth(), (int) e.getHeight()) - glassGap;
|
// if (isTempering) {
|
// int minLength = Math.min((int) e.getWidth(), (int) e.getHeight());
|
// if (maxX + minLength <= xMaxSize) {
|
// bigStorageCageOutTaskList.add(new BigStorageCageOutTask(e.getGlassId(), e.getSlot(), Const.TEMPERING_OUT_TARGET_POSITION,
|
// e.getWidth() * 10, e.getHeight() * 10, 0, 0, 1, new Date()));
|
// maxX = Math.max(maxX, e.getXCoordinate());
|
// } else {
|
// break;
|
// }
|
//
|
// } else {
|
// bigStorageCageOutTaskList.add(new BigStorageCageOutTask(e.getGlassId(), e.getSlot(), Const.ARTIFICIAL_OUT_TARGET_POSITION,
|
// e.getWidth() * 10, e.getHeight(), 0, 0, 1, new Date()));
|
// }
|
// }
|
// Assert.isFalse(CollectionUtils.isEmpty(bigStorageCageOutTaskList), "未获取出片数据，结束出片任务");
|
// log.info("获取出片任务数据{}条，执行保存", bigStorageCageOutTaskList.size());
|
// bigStorageCageOutTaskService.saveBatch(bigStorageCageOutTaskList);
|
// List<String> glassIds = bigStorageCageOutTaskList.stream().map(BigStorageCageOutTask::getGlassId).collect(Collectors.toList());
|
// log.info("将出片玻璃{}玻璃状态改为已出片", glassIds);
|
// bigStorageCageDetailsService.update(new LambdaUpdateWrapper<BigStorageCageDetails>()
|
// .set(BigStorageCageDetails::getState, Const.GLASS_STATE_OUT_ING)
|
// .in(BigStorageCageDetails::getGlassId, glassIds));
|
// int returnData = 0;
|
// int count = 1;
|
// while (returnData == 0) {
|
// S7object.getinstance().plccontrol.writeWord(mesToPLCAddress, 1);
|
// returnData = S7object.getinstance().plccontrol.readWord(mesToPLCAddress, 1).get(0);
|
// log.info("已向plc第{}次发送出片任务确认，地址为：{},写入的内容为{}", count++, mesToPLCAddress, returnData);
|
// }
|
// return Boolean.TRUE;
|
// }
|
|
// /**
|
// * 出片一次生成一炉玻璃
|
// *
|
// * @param list
|
// * @param isTempering
|
// * @param mesToPLCAddress
|
// * @param <T>
|
// * @return
|
// */
|
// public <T extends BigStorageCageBaseInfo> Boolean computeOutMoreGlassInfo(List<T> list, Boolean isTempering, String mesToPLCAddress) {
|
// //任务数据 获取车子存放玻璃最大数量 玻璃间隔
|
// List<BigStorageCageOutTask> bigStorageCageOutTaskList = new ArrayList<>();
|
// //打车剩余尺寸
|
// Integer remainWidth = carWidth;
|
// int trainNumber = 1;
|
// int serialNumber = 1;
|
// int maxX = 0;
|
// for (T e : list) {
|
// int maxLength = Math.max((int) e.getWidth(), (int) e.getHeight());
|
// if (serialNumber > outCarMaxSize || maxLength > remainWidth) {
|
// remainWidth = carWidth;
|
// trainNumber = trainNumber + 1;
|
// serialNumber = 1;
|
// maxX = 0;
|
// }
|
// remainWidth = remainWidth - maxLength - glassGap;
|
// if (isTempering) {
|
// int minLength = Math.min((int) e.getWidth(), (int) e.getHeight());
|
// if (maxX + minLength <= xMaxSize) {
|
// bigStorageCageOutTaskList.add(new BigStorageCageOutTask(e.getGlassId(), e.getSlot(), Const.TEMPERING_OUT_TARGET_POSITION,
|
// e.getWidth() * 10, e.getHeight() * 10, trainNumber, serialNumber++, 1, new Date()));
|
// maxX = Math.max(maxX, e.getXCoordinate());
|
// } else {
|
// remainWidth = carWidth - maxLength - glassGap;
|
// trainNumber = trainNumber + 1;
|
// serialNumber = 1;
|
// maxX = e.getXCoordinate();
|
// bigStorageCageOutTaskList.add(new BigStorageCageOutTask(e.getGlassId(), e.getSlot(), Const.TEMPERING_OUT_TARGET_POSITION,
|
// e.getWidth() * 10, e.getHeight(), trainNumber, serialNumber++, 1, new Date()));
|
// }
|
// } else {
|
// bigStorageCageOutTaskList.add(new BigStorageCageOutTask(e.getGlassId(), e.getSlot(), Const.ARTIFICIAL_OUT_TARGET_POSITION,
|
// e.getWidth() * 10, e.getHeight(), trainNumber, serialNumber++, 1, new Date()));
|
// }
|
// }
|
// Assert.isFalse(CollectionUtils.isEmpty(bigStorageCageOutTaskList), "未获取出片数据，结束出片任务");
|
// log.info("获取出片任务数据{}条，执行保存", bigStorageCageOutTaskList.size());
|
// for (BigStorageCageOutTask bigStorageCageOutTask : bigStorageCageOutTaskList
|
// ) {
|
// bigStorageCageOutTaskService.save(bigStorageCageOutTask);
|
// }
|
//// bigStorageCageOutTaskService.saveBatch(bigStorageCageOutTaskList);
|
// List<String> glassIds = bigStorageCageOutTaskList.stream().map(BigStorageCageOutTask::getGlassId).collect(Collectors.toList());
|
// log.info("将出片玻璃{}玻璃状态改为已出片", glassIds);
|
// bigStorageCageDetailsService.update(new LambdaUpdateWrapper<BigStorageCageDetails>()
|
// .set(BigStorageCageDetails::getState, Const.GLASS_STATE_OUT_ING)
|
// .in(BigStorageCageDetails::getGlassId, glassIds)
|
// .ne(BigStorageCageDetails::getState, Const.GLASS_STATE_OUT));
|
//
|
// return Boolean.TRUE;
|
// }
|
|
@Override
|
public BigStorageDTO queryTargetSlotByTempering(GlassInfo glassInfo) {
|
// BigStorageDTO bigStorageDTO = null;
|
// MPJLambdaWrapper<BigStorageCage> wrapper = new MPJLambdaWrapper<>(BigStorageCage.class)
|
// .selectAll(BigStorageCage.class)
|
// .leftJoin(BigStorageCageDetails.class, BigStorageCageDetails::getSlot, BigStorageCage::getSlot)
|
// .eq(BigStorageCage::getEnableState, Const.SLOT_ON)
|
// .in(BigStorageCageDetails::getState, Const.GLASS_STATE_IN_ALL_ZERO)
|
// .eq(BigStorageCageDetails::getEngineerId, glassInfo.getEngineerId())
|
// .eq(BigStorageCageDetails::getTemperingLayoutId, glassInfo.getTemperingLayoutId())
|
// .gt(BigStorageCage::getRemainWidth, Math.max(glassInfo.getWidth(), glassInfo.getHeight()))
|
// .last("limit 1");
|
// if (glassInfo.getTemperingLayoutId() == 0) {
|
// wrapper.eq(BigStorageCageDetails::getFlowCardId, glassInfo.getFlowCardId())
|
// .eq(BigStorageCageDetails::getLayer, glassInfo.getLayer());
|
//// wrapper.eq(BigStorageCageDetails::getWidth, glassInfo.getWidth()).eq(BigStorageCageDetails::getHeight, glassInfo.getHeight());
|
// } else {
|
// wrapper.eq(BigStorageCageDetails::getTemperingFeedSequence, glassInfo.getTemperingFeedSequence() + 1);
|
// }
|
// BigStorageCage bigStorageCage = bigStorageCageService.selectJoinOne(BigStorageCage.class, wrapper);
|
// if (null != bigStorageCage) {
|
// log.info("无钢化版图id或根据当前玻璃片序+1找到目标格子：{},玻璃id：{}", bigStorageCage.getSlot(), glassInfo.getGlassId());
|
// bigStorageDTO = new BigStorageDTO();
|
// bigStorageDTO.setWidth(bigStorageCage.getRemainWidth());
|
// bigStorageDTO.setSlot(bigStorageCage.getSlot());
|
// bigStorageDTO.setDeviceId(bigStorageCage.getDeviceId());
|
// return bigStorageDTO;
|
// }
|
// bigStorageCage = bigStorageCageService.getOne(new LambdaQueryWrapper<BigStorageCage>()
|
// .eq(BigStorageCage::getEnableState, Const.SLOT_ON)
|
// .eq(BigStorageCage::getRemainWidth, slotWidth)
|
//// .notInSql(BigStorageCage::getSlot, "select distinct slot from big_storage_cage_details where state = 0")
|
// .inSql(BigStorageCage::getDeviceId,
|
// "select distinct device_id from big_storage_cage_details where engineer_id = '" + glassInfo.getEngineerId() + "' and tempering_layout_id = " + glassInfo.getTemperingLayoutId())
|
// .last("limit 1"));
|
// if (null != bigStorageCage) {
|
// log.info("根据版图id找到笼子内的目标格子：{},玻璃id：{}", bigStorageCage.getSlot(), glassInfo.getGlassId());
|
// bigStorageDTO = new BigStorageDTO();
|
// bigStorageDTO.setWidth(bigStorageCage.getRemainWidth());
|
// bigStorageDTO.setSlot(bigStorageCage.getSlot());
|
// bigStorageDTO.setDeviceId(bigStorageCage.getDeviceId());
|
// return bigStorageDTO;
|
// }
|
//
|
// //获取玻璃的厚度：重新选笼子需要按照笼子可放玻璃厚度进行选择 因为子查询排序对主sql无影响，所以先执行子查询获取顺序，然后一次去查询
|
// List<Integer> deviceUsedList = bigStorageCageService.queryFreeDeviceByUsed(glassInfo.getThickness());
|
// List<Integer> deviceUseds = bigStorageCageService.queryFreeDeviceByUsed(glassInfo.getThickness());
|
// List<BigStorageCageDetails> engineerCount1 = baseMapper.selectList(
|
// new LambdaQueryWrapper<BigStorageCageDetails>()
|
// .notIn(BigStorageCageDetails::getState, Const.GLASS_STATE_OUT, Const.GLASS_STATE_DAMAGE, Const.GLASS_STATE_TAKE)
|
// .select(BigStorageCageDetails::getEngineerId)
|
// .groupBy(BigStorageCageDetails::getEngineerId)
|
// .between(BigStorageCageDetails::getDeviceId, 1, 5)
|
// );
|
// List<BigStorageCageDetails> engineerCount2 = baseMapper.selectList(
|
// new LambdaQueryWrapper<BigStorageCageDetails>()
|
// .notIn(BigStorageCageDetails::getState, Const.GLASS_STATE_OUT, Const.GLASS_STATE_DAMAGE, Const.GLASS_STATE_TAKE)
|
// .select(BigStorageCageDetails::getEngineerId)
|
// .groupBy(BigStorageCageDetails::getEngineerId)
|
// .between(BigStorageCageDetails::getDeviceId, 6, 8)
|
// );
|
// if (engineerCount1.size() > engineerCount2.size()) {
|
// deviceUsedList.removeIf(device -> device < 6);
|
// } else {
|
// deviceUsedList.removeIf(device -> device > 5);
|
// }
|
// if (CollectionUtils.isEmpty(deviceUsedList)) {
|
// deviceUsedList = deviceUseds;
|
// }
|
// for (Integer item : deviceUsedList) {
|
// bigStorageCage = bigStorageCageService.getOne(new LambdaQueryWrapper<BigStorageCage>()
|
// .eq(BigStorageCage::getRemainWidth, slotWidth)
|
// .eq(BigStorageCage::getEnableState, Const.SLOT_ON)
|
// .eq(BigStorageCage::getDeviceId, item)
|
// .last("limit 1"));
|
// if (null != bigStorageCage) {
|
// log.info("按照存笼玻璃格子数占用最少方式获取信息格子为：{},玻璃id：{}", bigStorageCage.getSlot(), glassInfo.getGlassId());
|
// bigStorageDTO = new BigStorageDTO();
|
// bigStorageDTO.setWidth(bigStorageCage.getRemainWidth());
|
// bigStorageDTO.setSlot(bigStorageCage.getSlot());
|
// bigStorageDTO.setDeviceId(bigStorageCage.getDeviceId());
|
// return bigStorageDTO;
|
// }
|
// }
|
|
//获取玻璃的厚度：重新选笼子需要按照笼子可放玻璃厚度进行选择
|
// List<Integer> deviceNotUsedList = bigStorageCageService.queryFreeDeviceByNotUsed(glassInfo.getThickness());
|
// for (Integer item : deviceNotUsedList) {
|
// bigStorageCage = bigStorageCageService.getOne(new LambdaQueryWrapper<BigStorageCage>()
|
// .eq(BigStorageCage::getRemainWidth, slotWidth)
|
// .eq(BigStorageCage::getEnableState, Const.SLOT_ON)
|
// .eq(BigStorageCage::getDeviceId, item)
|
// .last("limit 1"));
|
// if (null != bigStorageCage) {
|
// log.info("按照存笼玻璃格子数剩余最多得方式获取信息版图id:{},格子：{},玻璃id：{}", glassInfo.getTemperingLayoutId(), bigStorageCage.getSlot(), glassInfo.getGlassId());
|
// bigStorageDTO = new BigStorageDTO();
|
// bigStorageDTO.setWidth(bigStorageCage.getRemainWidth());
|
// bigStorageDTO.setSlot(bigStorageCage.getSlot());
|
// bigStorageDTO.setDeviceId(bigStorageCage.getDeviceId());
|
// return bigStorageDTO;
|
// }
|
// }
|
// Assert.isTrue(null != bigStorageCage, "没有空余的笼子存放玻璃");
|
// return bigStorageDTO;
|
return null;
|
}
|
|
|
@Scheduled(fixedDelay = 300)
|
public void querySizeByEngineerTask() {
|
log.info("查询结果：{}", querySizeByEngineer("P24072402", 1, 10, 8));
|
log.info("查询结果：{}", querySizeByEngineer("P24072402", 1, 5, 8));
|
|
}
|
|
public BigStorageDTO querySizeByEngineer(String engineerId, int temperingLayoutId, int temperingFeedSequence, double thickness) {
|
BigStorageDTO bigStorageDTO = null;
|
BigStorageCage bigStorageCage = null;
|
//获取笼内当前版图每个格子已有玻璃的最小版序 获取笼内当前版图的所有玻璃信息
|
List<BigStorageCageDetails> cageDetailsList = bigStorageCageDetailsService.list(new QueryWrapper<BigStorageCageDetails>()
|
.select("slot", "min(tempering_feed_sequence) as tempering_feed_sequence")
|
.eq("engineer_id", engineerId).eq("tempering_layout_id", temperingLayoutId)
|
.in("state", Const.GLASS_STATE_IN_ALL_ZERO).groupBy("slot").orderByAsc("min(tempering_feed_sequence)"));
|
if (CollectionUtils.isNotEmpty(cageDetailsList)) {
|
Integer minLength = cageDetailsList.stream().filter(e -> e.getTemperingFeedSequence() > temperingFeedSequence)
|
.mapToInt(BigStorageCageDetails::getTemperingFeedSequence).min().orElse(1000);
|
List<GlassInfo> infoList = glassInfoService.list(new LambdaQueryWrapper<GlassInfo>()
|
.notInSql(GlassInfo::getGlassId, "select glass_id from damage where tempering_layout_id = " + temperingLayoutId + " and engineer_id = '" + engineerId + "'")
|
.eq(GlassInfo::getTemperingLayoutId, temperingLayoutId).eq(GlassInfo::getEngineerId, engineerId).orderByAsc(GlassInfo::getTemperingFeedSequence));
|
int remainWidth = carWidth;
|
int trainNumber = 1;
|
int serialNumber = 0;
|
int min = 0;
|
int temp = infoList.get(0).getTemperingFeedSequence();
|
int slot = 0;
|
int resultTrainNumber = 0;
|
for (GlassInfo e : infoList) {
|
int maxLength = Math.max((int) e.getWidth(), (int) e.getHeight());
|
if (serialNumber >= outCarMaxSize || maxLength > remainWidth || e.getTemperingFeedSequence() >= minLength) {
|
if (resultTrainNumber != 0) {
|
min = temp;
|
break;
|
}
|
temp = e.getTemperingFeedSequence();
|
remainWidth = carWidth;
|
trainNumber = trainNumber + 1;
|
serialNumber = 0;
|
}
|
if (temperingFeedSequence == e.getTemperingFeedSequence()) {
|
resultTrainNumber = trainNumber;
|
}
|
remainWidth = remainWidth - maxLength - glassGap > 0 ? remainWidth - maxLength - glassGap : 0;
|
serialNumber += 1;
|
log.info("{},{},{}", trainNumber, remainWidth, serialNumber);
|
if (e.getTemperingFeedSequence().equals(infoList.get(infoList.size() - 1).getTemperingFeedSequence())) {
|
min = temp;
|
}
|
}
|
for (BigStorageCageDetails item : cageDetailsList) {
|
if (min <= item.getTemperingFeedSequence() && item.getTemperingFeedSequence() < minLength) {
|
slot = item.getSlot();
|
bigStorageCage = bigStorageCageService.getOne(new LambdaQueryWrapper<BigStorageCage>()
|
.eq(BigStorageCage::getSlot, slot).eq(BigStorageCage::getEnableState, Const.SLOT_ON));
|
break;
|
}
|
}
|
}
|
|
if (bigStorageCage != null) {
|
bigStorageDTO = new BigStorageDTO();
|
bigStorageDTO.setWidth(bigStorageCage.getRemainWidth());
|
bigStorageDTO.setSlot(bigStorageCage.getSlot());
|
bigStorageDTO.setDeviceId(bigStorageCage.getDeviceId());
|
return bigStorageDTO;
|
}
|
|
bigStorageCage = bigStorageCageService.getOne(new LambdaQueryWrapper<BigStorageCage>()
|
.eq(BigStorageCage::getEnableState, Const.SLOT_ON)
|
.eq(BigStorageCage::getRemainWidth, slotWidth)
|
.inSql(BigStorageCage::getDeviceId,
|
"select distinct device_id from big_storage_cage_details where engineer_id = '" + engineerId + "' and tempering_layout_id = " + temperingLayoutId)
|
.last("limit 1"));
|
if (null != bigStorageCage) {
|
log.info("根据版图id找到笼子内的目标格子：{}", bigStorageCage.getSlot());
|
bigStorageDTO = new BigStorageDTO();
|
bigStorageDTO.setWidth(bigStorageCage.getRemainWidth());
|
bigStorageDTO.setSlot(bigStorageCage.getSlot());
|
bigStorageDTO.setDeviceId(bigStorageCage.getDeviceId());
|
return bigStorageDTO;
|
|
}
|
|
//获取玻璃的厚度：重新选笼子需要按照笼子可放玻璃厚度进行选择 因为子查询排序对主sql无影响，所以先执行子查询获取顺序，然后一次去查询
|
List<Integer> deviceUsedList = bigStorageCageService.queryFreeDeviceByUsed(thickness,5000);
|
for (Integer item : deviceUsedList) {
|
bigStorageCage = bigStorageCageService.getOne(new LambdaQueryWrapper<BigStorageCage>()
|
.eq(BigStorageCage::getRemainWidth, slotWidth)
|
.eq(BigStorageCage::getEnableState, Const.SLOT_ON)
|
.eq(BigStorageCage::getDeviceId, item)
|
.last("limit 1"));
|
if (null != bigStorageCage) {
|
log.info("按照存笼玻璃格子数占用最少方式获取信息格子为：{}", bigStorageCage.getSlot());
|
bigStorageDTO = new BigStorageDTO();
|
bigStorageDTO.setWidth(bigStorageCage.getRemainWidth());
|
bigStorageDTO.setSlot(bigStorageCage.getSlot());
|
bigStorageDTO.setDeviceId(bigStorageCage.getDeviceId());
|
return bigStorageDTO;
|
}
|
}
|
Assert.isTrue(null != bigStorageCage, "没有空余的笼子存放玻璃");
|
return bigStorageDTO;
|
}
|
|
|
}
|
