package com.mes.job;
|
|
import cn.hutool.core.collection.CollectionUtil;
|
import cn.hutool.core.lang.Assert;
|
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
|
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
|
import com.github.yulichang.query.MPJQueryWrapper;
|
import com.mes.common.S7object;
|
import com.mes.common.WebSocketServer;
|
import com.mes.common.config.Const;
|
import com.mes.device.PlcParameterObject;
|
import com.mes.edgglasstask.entity.EdgGlassTaskInfo;
|
import com.mes.edgglasstask.service.EdgGlassTaskInfoService;
|
import com.mes.edgstoragecage.entity.EdgStorageCage;
|
import com.mes.edgstoragecage.entity.EdgStorageCageDetails;
|
import com.mes.edgstoragecage.service.EdgStorageCageDetailsService;
|
import com.mes.edgstoragecage.service.EdgStorageCageService;
|
import com.mes.glassinfo.entity.GlassInfo;
|
import com.mes.glassinfo.service.GlassInfoService;
|
import com.mes.taskcache.entity.TaskCache;
|
import com.mes.taskcache.service.TaskCacheService;
|
import lombok.extern.slf4j.Slf4j;
|
import org.apache.commons.lang.StringUtils;
|
import org.springframework.beans.BeanUtils;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.beans.factory.annotation.Value;
|
import org.springframework.scheduling.annotation.Scheduled;
|
import org.springframework.stereotype.Component;
|
|
import java.util.ArrayList;
|
import java.util.Date;
|
import java.util.List;
|
|
/**
|
* @Author : zhoush
|
* @Date: 2024/5/8 8:17
|
* @Description:
|
*/
|
@Component
|
@Slf4j
|
public class CacheGlassTask {
|
|
@Autowired
|
TaskCacheService taskCacheService;
|
@Autowired
|
GlassInfoService glassInfoService;
|
@Autowired
|
EdgStorageCageService edgStorageCageService;
|
@Autowired
|
EdgStorageCageDetailsService edgStorageCageDetailsService;
|
|
@Autowired
|
EdgGlassTaskInfoService edgGlassTaskInfoService;
|
|
@Autowired
|
WebSocketServer webServerService;
|
|
@Value("${mes.threshold}")
|
private int threshold;
|
|
@Value("${mes.ratio}")
|
private int ratio;
|
|
@Value("${mes.sequence.order}")
|
private boolean sequenceOrder;
|
|
@Scheduled(fixedDelay = 1000)
|
public void plcHomeEdgTask() {
|
PlcParameterObject plcParameterObject = S7object.getinstance().PlcMesObject;
|
String taskRequestTypeValue = plcParameterObject.getPlcParameter("A06_request_word").getValue();
|
String glassIdeValue = plcParameterObject.getPlcParameter("A05_scanning_ID").getValue();
|
String confirmationWrodValue = plcParameterObject.getPlcParameter("MES_confirmation_word").getValue();
|
//A08 A09表示线路相同 可做等价 无数据转int异常
|
String out08Glassstate = plcParameterObject.getPlcParameter("A08_glass_status").getValue();
|
String out10Glassstate = plcParameterObject.getPlcParameter("A10_glass_status").getValue();
|
String confirmationWrodAddress = plcParameterObject.getPlcParameter("MES_confirmation_word").getAddress();
|
String currentSlot = plcParameterObject.getPlcParameter("Current_slot").getValue();
|
|
log.info("1、获取到的请求字为：{}，获取到的扫描ID为：{}，获取到的确认字为：{}，获取到的出片状态分别为：A09:{}、A10:{},当前格子号为：{}",
|
taskRequestTypeValue, glassIdeValue, confirmationWrodValue, out08Glassstate, out10Glassstate, currentSlot);
|
|
if ("0".equals(taskRequestTypeValue)) {
|
if ("0".equals(confirmationWrodValue)) {
|
log.info("2、获取到的请求字为0，且确认字为0，不执行任务");
|
return;
|
}
|
log.info("2、获取到的请求字为0，将确认字改为0");
|
S7object.getinstance().plccontrol.writeWord(confirmationWrodAddress, (short) 0);
|
return;
|
}
|
if (!"0".equals(confirmationWrodValue)) {
|
log.info("2、获取到的请求字不为0，将确认字不为0，直接结束");
|
return;
|
}
|
if ("1".equals(taskRequestTypeValue)) {
|
log.info("2、进片请求，且确认字为0，执行进片任务");
|
inTo(glassIdeValue, confirmationWrodAddress, currentSlot);
|
} else if ("2".equals(taskRequestTypeValue)) {
|
//09空闲 ：1 10空闲 ：2 都空闲：3 其他0
|
log.info("2、出片请求，且确认字为0，执行进片任务");
|
outTo(Integer.parseInt(out08Glassstate),
|
Integer.parseInt(out10Glassstate), confirmationWrodAddress, "", 0);
|
} else if ("3".equals(taskRequestTypeValue)) {
|
log.info("2、进片和出片都空闲，执行出片任务");
|
//加笼子里面是否有玻璃，有先出，无玻璃先进
|
boolean outFlase = outTo(Integer.parseInt(out08Glassstate),
|
Integer.parseInt(out10Glassstate), confirmationWrodAddress, glassIdeValue, Integer.parseInt(currentSlot));
|
log.info("出片任务是否完成：{},失败且玻璃id:{}不为空则执行进片任务", outFlase, glassIdeValue);
|
if (!outFlase && StringUtils.isNotBlank(glassIdeValue)) {
|
inTo(glassIdeValue, confirmationWrodAddress, currentSlot);
|
}
|
}
|
}
|
|
public void plcToHomeEdgTask() {
|
// log.info("推数据");
|
// jsonObject.append("params", new short[] { 30, 40, });
|
// ArrayList<WebSocketServer> sendwServer = WebSocketServer.sessionMap.get("Home");
|
// if (sendwServer != null) {
|
// for (WebSocketServer webserver : sendwServer) {
|
// webserver.sendMessage(jsonObject.toString());
|
// if (webserver != null) {
|
//
|
// List<String> messages = webserver.getMessages();
|
//
|
// if (!messages.isEmpty()) {
|
// // // 将最后一个消息转换为整数类型的列表
|
// webserver.clearMessages();
|
// }
|
// }
|
//
|
// }
|
// }
|
}
|
|
/**
|
* 进片任务
|
*
|
* @param glassId
|
* @param confirmationWrodAddress
|
* @param currentSlot
|
*/
|
private void inTo(String glassId, String confirmationWrodAddress, String currentSlot) {
|
log.info("1、按照玻璃id:{}获取玻璃小片信息,当前格子为:{}", glassId, currentSlot);
|
GlassInfo glassInfo = glassInfoService.getOne(new LambdaQueryWrapper<GlassInfo>().eq(GlassInfo::getGlassId, glassId));
|
//TODO: 查询玻璃
|
if (glassInfo == null) {
|
log.info("2、此玻璃编号不存在");
|
return;
|
}
|
log.info("2、获取到的玻璃信息为{}", glassInfo);
|
//添加进片任务 查找空格
|
EdgStorageCage nearestEmpty = edgStorageCageService.selectNearestEmpty(Integer.parseInt(currentSlot), Boolean.FALSE);
|
Assert.isTrue(null != nearestEmpty, "格子已满");
|
log.info("3、查询卧式理片笼里面的空格:{}", nearestEmpty);
|
|
log.info("4、将玻璃信息插入卧式理片笼,当前玻璃信息:{}", glassInfo);
|
EdgStorageCageDetails details = new EdgStorageCageDetails();
|
BeanUtils.copyProperties(glassInfo, details);
|
details.setState(Const.GLASS_STATE_IN);
|
details.setSlot(nearestEmpty.getSlot());
|
details.setDeviceId(nearestEmpty.getDeviceId());
|
edgStorageCageDetailsService.save(details);
|
log.info("5、玻璃信息已存入理片笼详情表，玻璃信息为{}", details);
|
//添加进片任务
|
boolean taskCache = saveTaskCache(details.getGlassId(), 0, nearestEmpty.getSlot(), Const.GLASS_CACHE_TYPE_IN);
|
log.info("6、生成进片任务信息存入任务表是否完成：{}", taskCache);
|
|
S7object.getinstance().plccontrol.writeWord(confirmationWrodAddress, (short) 1);
|
log.info("7、发送确认字完成");
|
|
|
}
|
|
/**
|
* 出片任务
|
*
|
* @param out08Glassstate
|
* @param out10Glassstate
|
* @param confirmationWrodAddress
|
* @param glassId
|
* @param currentSlot
|
*/
|
public boolean outTo(int out08Glassstate, int out10Glassstate, String confirmationWrodAddress, String glassId, int currentSlot) {
|
//逻辑步骤：
|
// 0、A09、A10是否空闲，是否可以执行出片任务
|
// 1、获取钢化版图是否超过阈值
|
// 1.1、超过阈值：获取当前最小版图需要出片的玻璃信息
|
// 1.1.1、获取两条线最后一次出片的任务信息
|
// 1.1.2、按照出片信息去详情表查询格子在笼子里面剩余相同尺寸的玻璃数据
|
// 1.1.3、判断哪条线玻璃数量在理片笼内的数据最少，决定最小版图走该条线（问题：如果这条线非空闲，直接结束）
|
// 1.2、未超过阈值：
|
// 1.2.1、获取程序那条线空闲
|
// 1.2.2、获取该条线最后一次出片的任务信息
|
// 1.2.3、按照出片信息去详情表查询格子在笼子里面剩余相同尺寸的玻璃数据且以版图id、版序升序排序 取第一块玻璃出片
|
// 2、如果没有历史出片任务
|
// 2.1、出当前版图id最小版序最小的玻璃（问题：两条线都没有历史任务，出片时两条线的玻璃尺寸相同，是否找尺寸不同的）
|
if (out08Glassstate == 2 && out10Glassstate == 2) {
|
log.info("A09、A10为{},{}非自动状态，无法出片");
|
return Boolean.FALSE;
|
}
|
log.info("0、出片任务出的状态:A09:【{}】;A10:【{}】)", out08Glassstate, out10Glassstate);
|
//定义出片玻璃信息
|
int endcell = 0;
|
EdgStorageCageDetails glassInfo = null;
|
boolean flag = queryMaxMinDiff(threshold);
|
log.info("1、获取钢化版图是否超过阈值:{}", flag);
|
if (flag) {
|
//获取当前最小版图需要出片的玻璃信息
|
glassInfo = queryMinGlass(0.0, 0.0, glassId);
|
log.info("1.1、超过阈值：获取当前最小版图需要出片的玻璃信息:{}", glassInfo);
|
if (glassInfo == null) {
|
log.info("笼子内和待进片没有玻璃");
|
return Boolean.FALSE;
|
}
|
EdgStorageCageDetails a09EdgGlass = queryGlassByTaskCache(Const.A09_OUT_TARGET_POSITION, Const.GLASS_CACHE_TYPE_OUT);
|
EdgStorageCageDetails a10EdgGlass = queryGlassByTaskCache(Const.A10_OUT_TARGET_POSITION, Const.GLASS_CACHE_TYPE_OUT);
|
endcell = queryLineByGlassInfo(a09EdgGlass, a10EdgGlass, glassInfo, out08Glassstate, out10Glassstate);
|
} else {
|
//判断两条线是否都空闲
|
endcell = out10Glassstate == 2 ? Const.A09_OUT_TARGET_POSITION : Const.A10_OUT_TARGET_POSITION;
|
|
if ((out08Glassstate == 0 && out10Glassstate == 0) || (out08Glassstate == 1 && out10Glassstate == 1)) {
|
EdgStorageCageDetails a09EdgGlass = queryGlassByTaskCache(Const.A09_OUT_TARGET_POSITION, Const.GLASS_CACHE_TYPE_OUT);
|
EdgStorageCageDetails a10EdgGlass = queryGlassByTaskCache(Const.A10_OUT_TARGET_POSITION, Const.GLASS_CACHE_TYPE_OUT);
|
if (a09EdgGlass == null && a10EdgGlass == null) {
|
MPJQueryWrapper<EdgStorageCageDetails> wrapper = new MPJQueryWrapper<>();
|
wrapper.select("count(t.glass_id), t.width, t.height")
|
.eq("t.state", Const.GLASS_STATE_IN)
|
.groupBy("t.width, t.height");
|
if (endcell == Const.A10_OUT_TARGET_POSITION) {
|
wrapper.innerJoin("(select glass_id, case when height <= width then width else height end as first_length, " +
|
"case when width < height then width else height end as second_length from edg_storage_cage_details) t1 " +
|
"on t.glass_id = t1.glass_id and t1.first_length <3500 and t1.second_length<2600 ");
|
}
|
wrapper.last("order by count(t.glass_id) desc limit 2");
|
List<EdgStorageCageDetails> list = edgStorageCageDetailsService.list(wrapper);
|
if (CollectionUtil.isEmpty(list)) {
|
MPJQueryWrapper<GlassInfo> queryWrapper = new MPJQueryWrapper<GlassInfo>()
|
.selectAll(GlassInfo.class).eq("t.glass_id", glassId);
|
if (endcell == Const.A10_OUT_TARGET_POSITION) {
|
queryWrapper.innerJoin("(select glass_id, case when height <= width then width else height end as first_length, " +
|
"case when width < height then width else height end as second_length from glass_info) t1 " +
|
"on t.glass_id = t1.glass_id and t1.first_length <3500 and t1.second_length<2600 ");
|
}
|
GlassInfo one = glassInfoService.getOne(queryWrapper);
|
if (one != null) {
|
EdgStorageCageDetails resultDetails = new EdgStorageCageDetails();
|
BeanUtils.copyProperties(one, resultDetails);
|
glassInfo = resultDetails;
|
} else {
|
log.info("获取笼内玻璃和带进片玻璃为空或者不符合磨边尺寸");
|
}
|
} else {
|
glassInfo = queryMinGlass(list.get(0).getWidth(), list.get(0).getHeight(), glassId);
|
}
|
} else if (a09EdgGlass != null && a10EdgGlass != null) {
|
List<EdgStorageCageDetails> a09Count = queryGlassByTaskLine(Const.A09_OUT_TARGET_POSITION);
|
List<EdgStorageCageDetails> a10Count = queryGlassByTaskLine(Const.A10_OUT_TARGET_POSITION);
|
endcell = a09Count.size() > a10Count.size() ? Const.A09_OUT_TARGET_POSITION : Const.A10_OUT_TARGET_POSITION;
|
glassInfo = a09Count.size() > a10Count.size() ? queryMinGlass(a09EdgGlass.getWidth(), a09EdgGlass.getHeight(), glassId)
|
: queryMinGlass(a10EdgGlass.getWidth(), a10EdgGlass.getHeight(), glassId);
|
} else {
|
//按照历史任务获取需要执行的路线，如果该条线笼内无玻璃 走其他逻辑
|
endcell = a09EdgGlass == null ? Const.A09_OUT_TARGET_POSITION : Const.A10_OUT_TARGET_POSITION;
|
List<EdgStorageCageDetails> details = queryGlassByTaskLine(endcell);
|
if (CollectionUtil.isEmpty(details)) {
|
int othercell = endcell == Const.A10_OUT_TARGET_POSITION ? Const.A09_OUT_TARGET_POSITION : Const.A10_OUT_TARGET_POSITION;
|
glassInfo = queryChangeGlassInfo(othercell, glassId);
|
} else {
|
glassInfo = a09EdgGlass != null ? queryMinGlass(a09EdgGlass.getWidth(), a09EdgGlass.getHeight(), glassId)
|
: queryMinGlass(a10EdgGlass.getWidth(), a10EdgGlass.getHeight(), glassId);
|
}
|
}
|
} else {
|
List<EdgStorageCageDetails> edgStorageCageDetails = queryGlassByTaskLine(endcell);
|
if (CollectionUtil.isNotEmpty(edgStorageCageDetails)) {
|
glassInfo = edgStorageCageDetails.get(0);
|
} else {
|
//获取笼内所有玻璃信息，包括待进片的
|
List<EdgStorageCageDetails> glassList = queryEdgAllGlass(glassId);
|
if (CollectionUtil.isEmpty(glassList)) {
|
log.info("笼内和待进片都没有玻璃");
|
return Boolean.FALSE;
|
}
|
if (glassList.size() == 1 && glassId.equals(glassList.get(0).getGlassId())) {
|
glassInfo = glassList.get(0);
|
} else {
|
int othercell = endcell == Const.A10_OUT_TARGET_POSITION ? Const.A09_OUT_TARGET_POSITION : Const.A10_OUT_TARGET_POSITION;
|
glassInfo = queryChangeGlassInfo(othercell, glassId);
|
}
|
}
|
}
|
}
|
return saveOutGlassMessage(glassInfo, endcell, confirmationWrodAddress, glassId, currentSlot);
|
}
|
|
/**
|
* 获取笼子内所有玻璃信息，包括待进片的
|
*
|
* @param glassId
|
*/
|
private List<EdgStorageCageDetails> queryEdgAllGlass(String glassId) {
|
List<EdgStorageCageDetails> glassList = new ArrayList<>();
|
//获取待进片玻璃
|
//todo: 获取正在执行的工程信息
|
if (StringUtils.isNotBlank(glassId)) {
|
GlassInfo one = glassInfoService.getOne(new LambdaQueryWrapper<GlassInfo>()
|
.eq(GlassInfo::getGlassId, glassId));
|
EdgStorageCageDetails resultDetails = new EdgStorageCageDetails();
|
BeanUtils.copyProperties(one, resultDetails);
|
glassList.add(resultDetails);
|
}
|
//获取笼内玻璃
|
List<EdgStorageCageDetails> details = edgStorageCageDetailsService.list(new LambdaQueryWrapper<EdgStorageCageDetails>()
|
.eq(EdgStorageCageDetails::getState, Const.GLASS_STATE_IN));
|
glassList.addAll(details);
|
return glassList;
|
|
}
|
|
/**
|
* 获取详情表内最大最小版图id的差值，判断是否出最小版图玻璃
|
*
|
* @return
|
*/
|
private boolean queryMaxMinDiff(int threshold) {
|
//获取笼子内最大版图id和最小版图id插值，判断是否大于阈值，大于阈值直接出最小版图玻璃
|
QueryWrapper<EdgStorageCageDetails> queryWrapper = new QueryWrapper<>();
|
queryWrapper.select("max(tempering_layout_id)-min(tempering_layout_id) as diff")
|
.eq("state", Const.GLASS_STATE_IN);
|
List<Object> list = edgStorageCageDetailsService.listObjs(queryWrapper);
|
if (CollectionUtil.isNotEmpty(list)) {
|
Long diff = (Long) list.get(0);
|
return diff > threshold;
|
} else {
|
return Boolean.FALSE;
|
}
|
|
}
|
|
/**
|
* 获取当前最小版图需要出片的玻璃信息
|
*
|
* @param width
|
* @param height
|
*/
|
private EdgStorageCageDetails queryMinGlass(Double width, Double height, String glassId) {
|
//获取表内版图id最小的玻璃信息
|
EdgStorageCageDetails glassDetails = edgStorageCageDetailsService.getOne(new LambdaQueryWrapper<EdgStorageCageDetails>()
|
.eq(EdgStorageCageDetails::getState, 100)
|
.eq(width != 0, EdgStorageCageDetails::getWidth, width)
|
.eq(height != 0, EdgStorageCageDetails::getHeight, height)
|
.orderByAsc(EdgStorageCageDetails::getTemperingLayoutId)
|
.orderBy(Boolean.TRUE, sequenceOrder, EdgStorageCageDetails::getTemperingFeedSequence)
|
.last("limit 1"));
|
if (StringUtils.isBlank(glassId)) {
|
return glassDetails;
|
}
|
GlassInfo one = glassInfoService.getOne(new LambdaQueryWrapper<GlassInfo>()
|
.eq(GlassInfo::getGlassId, glassId));
|
EdgStorageCageDetails resultDetails = new EdgStorageCageDetails();
|
BeanUtils.copyProperties(one, resultDetails);
|
if (null == glassDetails) {
|
return resultDetails;
|
}
|
return resultDetails.getTemperingLayoutId() <= glassDetails.getTemperingLayoutId() && resultDetails.getTemperingFeedSequence() > glassDetails.getTemperingFeedSequence() ?
|
resultDetails : glassDetails;
|
}
|
|
/**
|
* 获取任务表中指定线路笼子内还剩余的玻璃信息
|
*/
|
private List<EdgStorageCageDetails> queryGlassByTaskLine(int line) {
|
//获取任务表中最后一次出片的玻璃id
|
LambdaQueryWrapper<TaskCache> queryWrapper = new LambdaQueryWrapper<TaskCache>().eq(TaskCache::getTaskType, Const.GLASS_CACHE_TYPE_OUT)
|
.eq(TaskCache::getEndCell, line).orderByDesc(TaskCache::getCreateTime);
|
List<TaskCache> taskCacheList = taskCacheService.list(queryWrapper);
|
if (CollectionUtil.isEmpty(taskCacheList)) {
|
log.info("没有找到{}线任务信息", line);
|
return new ArrayList<>();
|
}
|
TaskCache taskCache = taskCacheList.get(0);
|
MPJQueryWrapper<EdgStorageCageDetails> mpjLambdaWrapper = new MPJQueryWrapper<>();
|
mpjLambdaWrapper.select("t1.*")
|
.innerJoin("edg_storage_cage_details t1 on t.width = t1.width and t.height = t1.height")
|
.eq("t.glass_id", taskCache.getGlassId())
|
.ne("t1.glass_id", taskCache.getGlassId())
|
.eq("t1.state", Const.GLASS_STATE_IN)
|
.orderByAsc("t1.tempering_layout_id")
|
.orderBy(Boolean.TRUE, sequenceOrder, "t1.tempering_feed_sequence");
|
List<EdgStorageCageDetails> details = edgStorageCageDetailsService.selectJoinList(EdgStorageCageDetails.class, mpjLambdaWrapper);
|
if (CollectionUtil.isEmpty(details)) {
|
return new ArrayList<>();
|
}
|
return details;
|
}
|
|
/**
|
* 按照任务类型、线号获取任务信息
|
*
|
* @param line
|
* @param taskType
|
* @return
|
*/
|
private EdgStorageCageDetails queryGlassByTaskCache(int line, int taskType) {
|
LambdaQueryWrapper<TaskCache> queryWrapper = new LambdaQueryWrapper<TaskCache>().eq(TaskCache::getTaskType, taskType)
|
.eq(TaskCache::getEndCell, line).orderByDesc(TaskCache::getCreateTime);
|
List<TaskCache> list = taskCacheService.list(queryWrapper);
|
if (CollectionUtil.isEmpty(list)) {
|
log.info("没有找到{}线任务信息", line);
|
return null;
|
}
|
return edgStorageCageDetailsService.getOne(new LambdaQueryWrapper<EdgStorageCageDetails>().eq(EdgStorageCageDetails::getGlassId, list.get(0).getGlassId()));
|
}
|
|
/**
|
* 按照任务玻璃信息和待出片玻璃信息获取出片路径
|
*
|
* @param a08EdgStorageCageDetails 09号线出片玻璃信息
|
* @param a10EdgStorageCageDetails 10号线出片玻璃信息
|
* @param glassInfo 带出片玻璃信息
|
* @param out08Glassstate 09号线空闲状态
|
* @param out10Glassstate 10号线空闲状态
|
* @return
|
*/
|
private Integer queryLineByGlassInfo(EdgStorageCageDetails a08EdgStorageCageDetails, EdgStorageCageDetails a10EdgStorageCageDetails,
|
EdgStorageCageDetails glassInfo, int out08Glassstate, int out10Glassstate) {
|
boolean b08 = a08EdgStorageCageDetails != null && a08EdgStorageCageDetails.getHeight().equals(glassInfo.getHeight())
|
&& a08EdgStorageCageDetails.getWidth().equals(glassInfo.getWidth());
|
boolean b10 = a10EdgStorageCageDetails != null && a10EdgStorageCageDetails.getHeight().equals(glassInfo.getHeight())
|
&& a10EdgStorageCageDetails.getWidth().equals(glassInfo.getWidth());
|
//存在出片任务 07为空
|
if (b10) {
|
return out10Glassstate == 2 ? Const.A09_OUT_TARGET_POSITION : Const.A10_OUT_TARGET_POSITION;
|
}
|
if (b08) {
|
return out08Glassstate == 2 ? Const.A10_OUT_TARGET_POSITION : Const.A09_OUT_TARGET_POSITION;
|
}
|
return out10Glassstate == 2 ? Const.A09_OUT_TARGET_POSITION : Const.A10_OUT_TARGET_POSITION;
|
}
|
|
/**
|
* 按照尺寸出玻璃
|
*
|
* @param endcell endcell = out08Glassstate == 1 ? Const.A09_OUT_TARGET_POSITION : Const.A10_OUT_TARGET_POSITION;
|
* @param glassId
|
* @return
|
*/
|
public EdgStorageCageDetails queryChangeGlassInfo(int endcell, String glassId) {
|
//获取笼子内数量前二的玻璃数量
|
MPJQueryWrapper<EdgStorageCageDetails> wrapper = new MPJQueryWrapper<>();
|
wrapper.select("count(t.glass_id), t.width, t.height")
|
.eq("t.state", Const.GLASS_STATE_IN)
|
.groupBy("t.width, t.height");
|
if (endcell == Const.A09_OUT_TARGET_POSITION) {
|
wrapper.innerJoin("(select glass_id, case when height <= width then width else height end as first_length, " +
|
"case when width < height then width else height end as second_length from edg_storage_cage_details) t1 " +
|
"on t.glass_id = t1.glass_id and t1.first_length <3500 and t1.second_length<2600 ");
|
}
|
wrapper.last("order by count(t.glass_id) desc limit 2");
|
List<EdgStorageCageDetails> list = edgStorageCageDetailsService.list(wrapper);
|
if (CollectionUtil.isEmpty(list)) {
|
return null;
|
}
|
log.info("获取笼子内数量前二的玻璃数量：{}", list);
|
//获取宽高拍第一的玻璃信息
|
EdgStorageCageDetails firstSize = list.get(0);
|
Integer firstCount = firstSize.getCount();
|
Double firstWidth = firstSize.getWidth();
|
Double firstHeight = firstSize.getHeight();
|
if (list.size() == 1) {
|
return queryMinGlass(firstWidth, firstHeight, glassId);
|
}
|
//获取宽高拍第二的玻璃信息
|
EdgStorageCageDetails secondSize = list.get(1);
|
Integer secondCount = secondSize.getCount();
|
Double secondWidth = secondSize.getWidth();
|
Double secondHeight = secondSize.getHeight();
|
//获取数量前2的玻璃数量比例
|
Integer mix = firstCount / secondCount;
|
log.info("获取玻璃数量前2的玻璃占比为：{}", mix);
|
|
if (mix >= 2) {
|
log.info("获取玻璃数量前2的玻璃占比为{}，大于2，直接出玻璃数据的最多的，宽：{}，高：{}", mix, firstWidth, firstHeight);
|
return queryMinGlass(firstWidth, firstHeight, glassId);
|
} else {
|
log.info("获取玻璃数量前2的玻璃占比为{}，小于2", mix);
|
//获取任务表中最后一次出片的玻璃id
|
LambdaQueryWrapper<TaskCache> queryWrapper = new LambdaQueryWrapper<TaskCache>().eq(TaskCache::getTaskType, Const.GLASS_CACHE_TYPE_OUT)
|
.eq(TaskCache::getEndCell, endcell).orderByDesc(TaskCache::getCreateTime);
|
List<TaskCache> taskCacheList = taskCacheService.list(queryWrapper);
|
log.info("获取任务表中{}线最后一次出片的玻璃任务信息：{}", endcell, taskCacheList);
|
if (CollectionUtil.isEmpty(taskCacheList)) {
|
log.info("{}线没有出片任务信息，直接出片", endcell);
|
return queryMinGlass(firstSize.getWidth(), firstSize.getHeight(), glassId);
|
}
|
TaskCache taskCache = taskCacheList.get(0);
|
EdgStorageCageDetails outGlassInfo = edgStorageCageDetailsService.getOne(new LambdaQueryWrapper<EdgStorageCageDetails>()
|
.eq(EdgStorageCageDetails::getGlassId, taskCache.getGlassId()));
|
log.info("{}线有出片任务信息,任务信息为{}，玻璃信息为{}", endcell, taskCache, outGlassInfo);
|
if (outGlassInfo.getWidth().equals(firstWidth) && outGlassInfo.getHeight().equals(firstHeight)) {
|
log.info("数量最多的宽{}高{}和{}线任务的宽{}高{}相同，出数量排第二的玻璃，宽{}高{}",
|
firstWidth, firstHeight, endcell, outGlassInfo.getWidth(), outGlassInfo.getHeight(), secondWidth, secondHeight);
|
return queryMinGlass(secondWidth, secondHeight, glassId);
|
} else {
|
log.info("数量第二多的宽{}高{}和{}线任务的宽{}高{}相同，出数量排第二的玻璃，宽{}高{}",
|
secondWidth, secondHeight, endcell, outGlassInfo.getWidth(), outGlassInfo.getHeight(), firstWidth, firstHeight);
|
return queryMinGlass(firstWidth, firstHeight, glassId);
|
}
|
}
|
}
|
|
/**
|
* 保存出片任务相关信息
|
*
|
* @param glassInfo
|
* @param endcell
|
* @param confirmationWrodAddress
|
* @param glassId
|
* @return
|
*/
|
private boolean saveOutGlassMessage(EdgStorageCageDetails glassInfo, int endcell, String confirmationWrodAddress, String glassId, Integer currentSlot) {
|
if (glassInfo != null) {
|
log.info("4、添加出片任务，玻璃id：{}，任务类型：{}，起始位置：{}，结束位置：{}", glassInfo.getGlassId(),
|
2, glassInfo.getSlot(), endcell);
|
if (glassInfo.getGlassId().equals(glassId)) {
|
log.info("5、直通任务,将玻璃信息插入卧式理片笼,当前玻璃信息:{}", glassInfo);
|
EdgStorageCageDetails details = new EdgStorageCageDetails();
|
BeanUtils.copyProperties(glassInfo, details);
|
EdgStorageCage nearestEmpty = edgStorageCageService.selectNearestEmpty(currentSlot, Boolean.TRUE);
|
Assert.isTrue(null != nearestEmpty, "格子已满,无法执行直通任务");
|
log.info("3、查询卧式理片笼里面的空格:{}", nearestEmpty);
|
details.setSlot(nearestEmpty.getSlot());
|
details.setState(Const.GLASS_STATE_OUT);
|
edgStorageCageDetailsService.save(details);
|
|
boolean taskCacheStatus = saveTaskCache(glassInfo.getGlassId(), nearestEmpty.getSlot(), endcell, Const.GLASS_CACHE_TYPE_THROUGH);
|
log.info("6、添加出片任务是否完成：{}", taskCacheStatus);
|
} else {
|
log.info("5、非直通任务,将玻璃信息插入卧式理片笼,当前玻璃信息:{}", glassInfo);
|
LambdaQueryWrapper<EdgStorageCageDetails> wrapper = new LambdaQueryWrapper<>();
|
wrapper.eq(EdgStorageCageDetails::getGlassId, glassInfo.getGlassId());
|
EdgStorageCageDetails updateDetail = new EdgStorageCageDetails();
|
updateDetail.setState(Const.GLASS_STATE_OUT);
|
edgStorageCageDetailsService.update(updateDetail, wrapper);
|
log.info("5、更新出片玻璃的状态为{}", Const.GLASS_STATE_OUT);
|
|
boolean taskCacheStatus = saveTaskCache(glassInfo.getGlassId(), glassInfo.getSlot(), endcell, Const.GLASS_CACHE_TYPE_OUT);
|
log.info("6、添加出片任务是否完成：{}", taskCacheStatus);
|
}
|
boolean glassSizeStatus = saveGlassSize(glassInfo);
|
log.info("7、添加出片玻璃尺寸信息到磨边前玻璃表是否完成：{}", glassSizeStatus);
|
S7object.getinstance().plccontrol.writeWord(confirmationWrodAddress, (short) 1);
|
log.info("8、发送确认字已完成");
|
return Boolean.TRUE;
|
}
|
return Boolean.FALSE;
|
}
|
|
/**
|
* 添加理片笼任务
|
*
|
* @param glassId
|
* @param startcell
|
* @param endcell
|
* @param taskType
|
* @return
|
*/
|
private boolean saveTaskCache(String glassId, int startcell, int endcell, int taskType) {
|
TaskCache taskCache = new TaskCache();
|
taskCache.setGlassId(glassId);
|
taskCache.setTaskStatus(0);
|
taskCache.setStartCell(startcell);
|
taskCache.setEndCell(endcell);
|
taskCache.setTaskType(taskType);
|
taskCache.setCreateTime(new Date());
|
return taskCacheService.save(taskCache);
|
}
|
|
/**
|
* 添加理片笼任务
|
*
|
* @param glassInfo
|
* @return
|
*/
|
private boolean saveGlassSize(EdgStorageCageDetails glassInfo) {
|
EdgGlassTaskInfo edgGlassTaskInfo = new EdgGlassTaskInfo();
|
BeanUtils.copyProperties(glassInfo, edgGlassTaskInfo);
|
edgGlassTaskInfo.setHeight((int) (glassInfo.getHeight() * ratio));
|
edgGlassTaskInfo.setWidth((int) (glassInfo.getWidth() * ratio));
|
edgGlassTaskInfo.setThickness((int) (glassInfo.getThickness() * ratio));
|
edgGlassTaskInfo.setStatus(Const.EDG_GLASS_BEFORE);
|
return edgGlassTaskInfoService.save(edgGlassTaskInfo);
|
}
|
|
|
}
|
