package com.mes.edgstoragecage.service.impl;
|
|
import cn.hutool.core.collection.CollectionUtil;
|
import cn.hutool.core.lang.Assert;
|
import cn.hutool.json.JSONObject;
|
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.base.MPJBaseServiceImpl;
|
import com.github.yulichang.query.MPJLambdaQueryWrapper;
|
import com.github.yulichang.toolkit.JoinWrappers;
|
import com.github.yulichang.wrapper.MPJLambdaWrapper;
|
import com.mes.damage.entity.Damage;
|
import com.mes.damage.entity.request.DamageRequest;
|
import com.mes.damage.service.DamageService;
|
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.entity.vo.CutDrawingVO;
|
import com.mes.edgstoragecage.entity.vo.EdgSlotRemainVO;
|
import com.mes.edgstoragecage.mapper.EdgStorageCageDetailsMapper;
|
import com.mes.edgstoragecage.mapper.EdgStorageCageMapper;
|
import com.mes.edgstoragecage.service.EdgStorageCageDetailsService;
|
import com.mes.engineering.entity.Engineering;
|
import com.mes.engineering.mapper.EngineeringMapper;
|
import com.mes.glassinfo.entity.GlassInfo;
|
import com.mes.glassinfo.service.GlassInfoService;
|
import com.mes.largenscreen.entity.PieChartVO;
|
import com.mes.pp.entity.OptimizeHeatDetail;
|
import com.mes.pp.entity.OptimizeHeatLayout;
|
import com.mes.pp.entity.OptimizeProject;
|
import com.mes.pp.mapper.OptimizeHeatDetailMapper;
|
import com.mes.taskcache.entity.TaskCache;
|
import com.mes.taskcache.service.TaskCacheService;
|
import com.mes.uppattenusage.entity.UpPattenUsage;
|
import com.mes.uppattenusage.mapper.UpPattenUsageMapper;
|
import lombok.extern.slf4j.Slf4j;
|
import org.apache.commons.lang.StringUtils;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Service;
|
|
import javax.annotation.Resource;
|
import java.util.ArrayList;
|
import java.util.HashMap;
|
import java.util.List;
|
import java.util.Map;
|
import java.util.stream.Collectors;
|
|
/**
|
* <p>
|
* 服务实现类
|
* </p>
|
*
|
* @author zhoush
|
* @since 2024-04-07
|
*/
|
@Service
|
@Slf4j
|
public class EdgStorageCageDetailsServiceImpl extends MPJBaseServiceImpl<EdgStorageCageDetailsMapper, EdgStorageCageDetails> implements EdgStorageCageDetailsService {
|
|
@Resource
|
EngineeringMapper engineeringMapper;
|
|
@Resource
|
OptimizeHeatDetailMapper optimizeHeatDetailMapper;
|
|
@Resource
|
EdgStorageCageMapper edgStorageCageMapper;
|
|
@Resource
|
GlassInfoService glassInfoService;
|
|
@Autowired
|
TaskCacheService taskCacheService;
|
|
@Autowired
|
DamageService damageService;
|
|
@Resource
|
UpPattenUsageMapper upPattenUsageMapper;
|
|
@Autowired
|
EdgGlassTaskInfoService edgGlassTaskInfoService;
|
|
@Override
|
public JSONObject queryCurrentCutDrawing(int deviceId, int stationCell) {
|
// 获取本条线当前正在执行的工程
|
Engineering engineering = engineeringMapper.selectOne(new LambdaQueryWrapper<Engineering>()
|
.eq(Engineering::getState, 1).eq(Engineering::getStationCell, stationCell));
|
if (null == engineering) {
|
log.info("当前线路没有需要执行的工程");
|
return null;
|
}
|
List<EdgStorageCageDetails> edgStorageCageDetailsList = this.list(new LambdaQueryWrapper<EdgStorageCageDetails>()
|
.eq(EdgStorageCageDetails::getDeviceId, deviceId)
|
.eq(EdgStorageCageDetails::getEngineerId, engineering.getEngineerId())
|
.orderByDesc(EdgStorageCageDetails::getId));
|
//按照当前工程去理片笼搜最后一块玻璃 获取工程号 版图号 没有直接显示第一张版图
|
int patternSequence = 0;
|
if (CollectionUtil.isEmpty(edgStorageCageDetailsList)) {
|
patternSequence = 1;
|
} else {
|
EdgStorageCageDetails lastGlass = edgStorageCageDetailsList.get(0);
|
log.info("获取最后一块进笼的玻璃为：{}", lastGlass);
|
List<CutDrawingVO> drawingVOList = baseMapper.queryCutDrawingByEngineerId(lastGlass.getEngineerId(), lastGlass.getPatternSequence(), 1);
|
if (CollectionUtil.isEmpty(drawingVOList)) {
|
//无剩余 显示当前版图加1的全量版图
|
patternSequence = lastGlass.getPatternSequence() + 1;
|
} else {
|
//当前版图是否有剩余，有剩余显示当前版图
|
patternSequence = lastGlass.getPatternSequence();
|
}
|
}
|
JSONObject jsonObject = new JSONObject();
|
List<CutDrawingVO> currentCutDrawings = baseMapper.queryCutDrawingByEngineerId(engineering.getEngineerId(), patternSequence, 0);
|
jsonObject.append("currentCutTerritory", currentCutDrawings);
|
if (CollectionUtil.isNotEmpty(currentCutDrawings)) {
|
jsonObject.append("engineer", engineering.getEngineerId());
|
jsonObject.append("sequence", patternSequence);
|
UpPattenUsage upPattenUsage = upPattenUsageMapper.selectOne(new LambdaQueryWrapper<UpPattenUsage>()
|
.eq(UpPattenUsage::getEngineeringId, engineering.getEngineerId())
|
.eq(UpPattenUsage::getLayoutSequence, patternSequence));
|
jsonObject.append("upPattenUsage", upPattenUsage);
|
}
|
return jsonObject;
|
}
|
|
@Override
|
public Map<String, Object> queryCutDrawingByEngineerId(String engineerId, int patternSequence) {
|
HashMap<String, Object> map = new HashMap<>();
|
map.put("currentCutDrawing", baseMapper.queryCutDrawingByEngineerId(engineerId, patternSequence, 0));
|
List<GlassInfo> glassInfoList = glassInfoService.list(new LambdaQueryWrapper<GlassInfo>().eq(GlassInfo::getEngineerId, engineerId));
|
long totalPatternSequence = glassInfoList.stream().map(GlassInfo::getPatternSequence).distinct().count();
|
map.put("totalPatternSequence", totalPatternSequence);
|
UpPattenUsage upPattenUsage = upPattenUsageMapper.selectOne(new LambdaQueryWrapper<UpPattenUsage>().eq(UpPattenUsage::getEngineeringId, engineerId)
|
.eq(UpPattenUsage::getLayoutSequence, patternSequence));
|
map.put("upPattenUsage", upPattenUsage);
|
return map;
|
|
}
|
|
|
/**
|
* 获取 工程下的钢化版图
|
*
|
* @param current
|
* @return
|
*/
|
@Override
|
public List<Map<String, Object>> selectTemperingTerritory(String current) {
|
//此工程的所有优化数据
|
List<Map<String, Object>> resultCutTerritory = optimizeHeatDetailMapper.selectJoinMaps(JoinWrappers.lambda(OptimizeHeatDetail.class)
|
.selectAll(OptimizeHeatDetail.class)
|
.selectAs(OptimizeProject::getLoadWidth, "olWidth")
|
.selectAs(OptimizeProject::getLoadLength, "olHeight")
|
.selectAs(OptimizeHeatLayout::getLayoutRate, "olLayoutRate")
|
.leftJoin(OptimizeHeatLayout.class, on -> on
|
.eq(OptimizeHeatLayout::getProjectNo, OptimizeHeatDetail::getProjectNo)
|
.eq(OptimizeHeatLayout::getLayoutId, OptimizeHeatDetail::getLayoutId))
|
.leftJoin(OptimizeProject.class, on -> on
|
.eq(OptimizeProject::getProjectNo, OptimizeHeatLayout::getProjectNo))
|
.eq(OptimizeHeatDetail::getProjectNo, current)
|
.gt(OptimizeHeatDetail::getLayoutId, 0)
|
);
|
//这里就是 按版图号分组 [{layout_id:"1",width:200,height:300...},{layout_id:"2",width:300,height:300...}]
|
Map<String, List<Map<String, Object>>> groupBy = resultCutTerritory.stream().collect(Collectors.groupingBy(item -> item.get("layout_id").toString()));
|
//按版图号排序
|
|
List<Map<String, Object>> result = new ArrayList<>();//返回结果
|
for (int i = 1; i <= groupBy.keySet().size(); i++) {
|
String key = i + "";
|
if (key != null) {
|
List<Map<String, Object>> galssInfo = groupBy.get(key);//当前钢化版图内玻璃小片集合
|
if (!galssInfo.isEmpty()) {
|
Map<String, Object> item = new HashMap<>();//新格式编排
|
//以下为同层 {key:"groupBy.get(key)",olLayoutRate:"小片集合"}
|
// {key:"groupBy.get(key)",olLayoutRate:[{},{},{},{}]}
|
|
|
item.put("listGlass", groupBy.get(key));
|
item.put("LayoutId", key);
|
item.put("olWidth", galssInfo.get(0).get("olWidth").toString());
|
item.put("olHeight", galssInfo.get(0).get("olHeight").toString());
|
item.put("olLayoutRate", galssInfo.get(0).get("olLayoutRate").toString());
|
result.add(item);
|
} else {
|
log.info("当前钢化版图不存在小片数据请检查，版图号:{}" + key);
|
return null;
|
}
|
}
|
}
|
// List<List<Map<String, Object>>> result = new ArrayList<>();//返回结果
|
//
|
// for (int i = 1; i <= groupBy.keySet().size(); i++) {
|
// String key = i + "";
|
// if (key != null) {
|
// result.add(groupBy.get(key));
|
// }
|
// }
|
return result;
|
}
|
|
/**
|
* 查询笼内版图差值范围内的 此尺寸玻璃 如无则按照 钢化版图序号 以及玻璃序号
|
*
|
* @param glassId
|
* @param threshold
|
* @return
|
*/
|
@Override
|
public EdgStorageCageDetails selectConformGlass(String glassId, int threshold) {
|
//1.去笼内查询此尺寸的玻璃 目前版图差值内的玻璃 是否有同尺寸的
|
//1.1 有同尺寸的 则生成同尺寸的任务
|
//1.2 无同尺寸的 则生成版图顺序最小的出片
|
EdgStorageCageDetails edgStorageCageDetails = baseMapper.selectOne(new MPJLambdaQueryWrapper<EdgStorageCageDetails>()
|
.selectAll(EdgStorageCageDetails.class)
|
.eq(EdgStorageCageDetails::getGlassId, glassId)
|
);
|
List<EdgStorageCageDetails> listEdgStorageCageDetails = baseMapper.selectList(new LambdaQueryWrapper<EdgStorageCageDetails>()
|
.lt(EdgStorageCageDetails::getState, 200)
|
.orderByAsc(EdgStorageCageDetails::getTemperingLayoutId, EdgStorageCageDetails::getTemperingFeedSequence)
|
);
|
EdgStorageCageDetails minTemperingLayoutId = new EdgStorageCageDetails();
|
if (!listEdgStorageCageDetails.isEmpty()) {
|
minTemperingLayoutId = listEdgStorageCageDetails.get(0);
|
}
|
EdgStorageCageDetails result = new EdgStorageCageDetails();
|
if (edgStorageCageDetails != null && minTemperingLayoutId != null) {
|
result = edgStorageCageMapper.selectJoinOne(EdgStorageCageDetails.class, new MPJLambdaWrapper<EdgStorageCage>()
|
.selectAll(EdgStorageCageDetails.class)
|
.leftJoin(EdgStorageCageDetails.class, on -> on
|
.eq(EdgStorageCageDetails::getDeviceId, EdgStorageCage::getDeviceId)
|
.eq(EdgStorageCageDetails::getSlot, EdgStorageCage::getSlot))
|
.isNotNull(EdgStorageCageDetails::getSlot)
|
.eq(EdgStorageCageDetails::getWidth, edgStorageCageDetails.getWidth())
|
.eq(EdgStorageCageDetails::getHeight, edgStorageCageDetails.getHeight())
|
.ge(EdgStorageCageDetails::getTemperingLayoutId, minTemperingLayoutId.getTemperingLayoutId())
|
.le(EdgStorageCageDetails::getTemperingLayoutId, minTemperingLayoutId.getTemperingLayoutId() + threshold)
|
.orderByAsc(EdgStorageCageDetails::getTemperingLayoutId, EdgStorageCageDetails::getTemperingFeedSequence)
|
);
|
}
|
|
if (result == null) {
|
result = edgStorageCageMapper.selectJoinOne(EdgStorageCageDetails.class, new MPJLambdaWrapper<EdgStorageCage>()
|
.selectAll(EdgStorageCageDetails.class)
|
.leftJoin(EdgStorageCageDetails.class, on -> on
|
.eq(EdgStorageCageDetails::getDeviceId, EdgStorageCage::getDeviceId)
|
.eq(EdgStorageCageDetails::getSlot, EdgStorageCage::getSlot))
|
.isNotNull(EdgStorageCageDetails::getSlot)
|
.orderByAsc(EdgStorageCageDetails::getTemperingLayoutId, EdgStorageCageDetails::getTemperingFeedSequence)
|
);
|
}
|
return result;
|
}
|
|
/**
|
* 查询笼内版图差值范围内的 此尺寸玻璃 如无则按照 钢化版图序号 以及玻璃序号
|
*
|
* @param glassId
|
* @param threshold
|
* @return
|
*/
|
@Override
|
public EdgStorageCageDetails selectOutGlass(String glassId, int threshold) {
|
EdgStorageCageDetails oldEdgStorageCageDetails = null;
|
if (StringUtils.isNotEmpty(glassId)) {
|
oldEdgStorageCageDetails = baseMapper.selectOne(new MPJLambdaQueryWrapper<EdgStorageCageDetails>()
|
.selectAll(EdgStorageCageDetails.class)
|
.eq(EdgStorageCageDetails::getGlassId, glassId));
|
}
|
log.info("按照玻璃id：{}获取玻璃信息{}", glassId, oldEdgStorageCageDetails);
|
|
LambdaQueryWrapper<TaskCache> wrapper = new LambdaQueryWrapper<TaskCache>().select(TaskCache::getGlassId).eq(TaskCache::getTaskType, "2");
|
List<TaskCache> taskCacheList = taskCacheService.list(wrapper);
|
List<String> glassIds = taskCacheList.stream().map(TaskCache::getGlassId).collect(Collectors.toList());
|
log.info("获取笼内所有已出片的玻璃id信息:{}", glassIds);
|
|
//获取笼内最小版图id及版序为最小的玻璃信息（玻璃id不在任务表中的出片记录中）
|
EdgStorageCageDetails minTemperingLayoutId = baseMapper.selectOne(new LambdaQueryWrapper<EdgStorageCageDetails>()
|
.eq(EdgStorageCageDetails::getState, 100)
|
.notIn(CollectionUtils.isNotEmpty(glassIds), EdgStorageCageDetails::getGlassId, glassIds)
|
.orderByAsc(EdgStorageCageDetails::getTemperingLayoutId, EdgStorageCageDetails::getTemperingFeedSequence)
|
.last("limit 1"));
|
Assert.isTrue(minTemperingLayoutId != null, "笼内无符合要求的玻璃");
|
log.info("获取笼内最小版图id{}及版序为{}的玻璃信息{}", minTemperingLayoutId.getTemperingLayoutId(),
|
minTemperingLayoutId.getTemperingFeedSequence(), minTemperingLayoutId);
|
|
EdgStorageCageDetails outEdgStorageCageDetails = null;
|
|
// if (queryMaxMinDiff(threshold))
|
//todo:逻辑1：获取两条线已出最后一块玻璃在笼内相同尺寸所剩数量，优先走数量少的线
|
//todo:需要在卧式理片笼详情表中新增状态，用来表示玻璃进出理片笼情况
|
if (oldEdgStorageCageDetails != null && minTemperingLayoutId != null) {
|
log.info("按照上一片已出玻璃宽度{}，高度{}，及版图id区间{}到{}获取出片任务玻璃信息", oldEdgStorageCageDetails.getWidth()
|
, oldEdgStorageCageDetails.getHeight(), minTemperingLayoutId.getTemperingLayoutId(), minTemperingLayoutId.getTemperingLayoutId() + threshold);
|
outEdgStorageCageDetails = this.getOne(new LambdaQueryWrapper<EdgStorageCageDetails>()
|
.notIn(CollectionUtils.isNotEmpty(glassIds), EdgStorageCageDetails::getGlassId, glassIds)
|
.eq(EdgStorageCageDetails::getWidth, oldEdgStorageCageDetails.getWidth())
|
.eq(EdgStorageCageDetails::getHeight, oldEdgStorageCageDetails.getHeight())
|
.orderByAsc(EdgStorageCageDetails::getTemperingLayoutId, EdgStorageCageDetails::getTemperingFeedSequence)
|
.last("limit 1"));
|
log.info("出片任务的玻璃信息：{}", outEdgStorageCageDetails);
|
}
|
if (outEdgStorageCageDetails == null) {
|
outEdgStorageCageDetails = minTemperingLayoutId;
|
}
|
return outEdgStorageCageDetails;
|
}
|
|
|
@Override
|
public String identControls(DamageRequest request) {
|
//将识别破损的玻璃直接加入破损表
|
damageService.autoSubmitReport(request.getGlassId(), request.getLine(), request.getWorkingProcedure(), "掰片识别", request.getState());
|
return "success";
|
}
|
|
@Override
|
public String edgReportStatus(DamageRequest request) {
|
//将磨边队列破损的玻璃直接加入破损表
|
damageService.autoSubmitReport(request.getGlassId(), request.getLine(), request.getWorkingProcedure(), "磨边清洗", request.getState());
|
|
//修改磨边队列数据状态
|
edgGlassTaskInfoService.update(new LambdaUpdateWrapper<EdgGlassTaskInfo>()
|
.set(EdgGlassTaskInfo::getState, request.getState()).eq(EdgGlassTaskInfo::getGlassId, request.getGlassId()));
|
return "success";
|
}
|
|
/**
|
* 进片 扫码ID验证重复
|
*
|
* @param glassId
|
* @return
|
*/
|
@Override
|
public boolean inToVerify(String glassId) {
|
List<EdgStorageCageDetails> listEdgStorageCageDetails = baseMapper.selectList(new LambdaQueryWrapper<EdgStorageCageDetails>()
|
.eq(EdgStorageCageDetails::getGlassId, glassId)
|
);
|
if (listEdgStorageCageDetails.isEmpty()) {
|
//说明此玻璃没有进过理片
|
return true;
|
} else {
|
List<Damage> damage = damageService.list(new LambdaQueryWrapper<Damage>()
|
.eq(Damage::getGlassId, glassId)
|
.and(wrapper -> wrapper.eq(Damage::getType, 8).or().eq(Damage::getType, 9))
|
);
|
if (!damage.isEmpty()) {
|
return true;
|
}
|
}
|
return false;
|
}
|
|
@Override
|
public EdgStorageCageDetails queryEdgStorageDetailsBySize(int deviceId, int currentSlot, double width, double height) {
|
return baseMapper.queryEdgStorageDetailsBySize(deviceId, currentSlot, width, height);
|
}
|
|
@Override
|
public String edgDetailsOperate(DamageRequest request) {
|
//卧式理片笼爆破损
|
damageService.autoSubmitReport(request.getGlassId(), request.getLine(), request.getWorkingProcedure(), "卧式理片笼", request.getState());
|
this.remove(new LambdaQueryWrapper<EdgStorageCageDetails>().eq(EdgStorageCageDetails::getGlassId, request.getGlassId()));
|
return "success";
|
}
|
|
@Override
|
public List<EdgSlotRemainVO> querySlotRemainWidth(int cellLength, int glassGap) {
|
return this.baseMapper.querySlotRemainWidth(cellLength, glassGap);
|
}
|
|
@Override
|
public List<PieChartVO> queryPieChart(){
|
return this.baseMapper.queryPieChart();
|
}
|
}
|
