package com.mes.bigstorage.service.impl;
|
|
import cn.hutool.core.lang.Assert;
|
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
|
import com.github.yulichang.base.MPJBaseServiceImpl;
|
import com.github.yulichang.wrapper.MPJLambdaWrapper;
|
import com.mes.bigstorage.entity.BigStorageCage;
|
import com.mes.bigstorage.entity.BigStorageCageDetails;
|
import com.mes.bigstorage.entity.BigStorageDTO;
|
import com.mes.bigstorage.entity.dto.TemperingLayoutDTO;
|
import com.mes.bigstorage.mapper.BigStorageCageDetailsMapper;
|
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.mapper.BigStorageCageFeedTaskMapper;
|
import com.mes.bigstoragetask.mapper.BigStorageCageOutTaskMapper;
|
import com.mes.common.config.Const;
|
import com.mes.glassinfo.entity.GlassInfo;
|
import com.mes.glassinfo.mapper.GlassInfoMapper;
|
import com.mes.temperingglass.entity.TemperingGlassInfo;
|
import com.mes.temperingglass.mapper.TemperingGlassInfoMapper;
|
import org.springframework.beans.BeanUtils;
|
import org.springframework.stereotype.Service;
|
|
import javax.annotation.Resource;
|
import java.util.List;
|
import java.util.Map;
|
import java.util.stream.Collectors;
|
|
/**
|
* <p>
|
* 服务实现类
|
* </p>
|
*
|
* @author zhoush
|
* @since 2024-03-27
|
*/
|
@Service
|
public class BigStorageCageDetailsServiceImpl extends MPJBaseServiceImpl<BigStorageCageDetailsMapper, BigStorageCageDetails> implements BigStorageCageDetailsService {
|
|
@Resource
|
private BigStorageCageOutTaskMapper bigStorageCageOutTaskMapper;
|
@Resource
|
private BigStorageCageFeedTaskMapper bigStorageCageFeedTaskMapper;
|
@Resource
|
private TemperingGlassInfoMapper temperingGlassInfoMapper;
|
@Resource
|
private BigStorageCageService bigStorageCageService;
|
@Resource
|
private GlassInfoMapper glassInfoMapper;
|
|
/**
|
* 查询进/出片任务
|
*/
|
@Override
|
public List<BigStorageCageDetails> selectTask(int taskType) {
|
if (taskType == 1) {
|
//进片任务数据
|
LambdaQueryWrapper<BigStorageCageDetails> feedWrapper = new LambdaQueryWrapper<>();
|
feedWrapper.eq(BigStorageCageDetails::getState, 1)
|
.or()
|
.eq(BigStorageCageDetails::getState, 2);
|
List<BigStorageCageDetails> bigStorageCageDetailsList = baseMapper.selectList(feedWrapper);
|
List<BigStorageCageFeedTask> bigStorageCageFeedTaskList = bigStorageCageFeedTaskMapper.selectList(null);
|
|
Map<String, BigStorageCageFeedTask> listMap = bigStorageCageFeedTaskList.stream()
|
.collect(Collectors.toMap(BigStorageCageFeedTask::getGlassId, task -> task));
|
|
for (BigStorageCageDetails bigStorageCageDetails : bigStorageCageDetailsList) {
|
BigStorageCageFeedTask bigStorageCageFeedTask = listMap.get(bigStorageCageDetails.getGlassId());
|
bigStorageCageDetails.setBigStorageCageFeedTask(bigStorageCageFeedTask);
|
}
|
return bigStorageCageDetailsList;
|
} else {
|
//出片任务数据
|
LambdaQueryWrapper<BigStorageCageDetails> outWrapper = new LambdaQueryWrapper<>();
|
outWrapper.eq(BigStorageCageDetails::getState, 3)
|
.or()
|
.eq(BigStorageCageDetails::getState, 4);
|
List<BigStorageCageDetails> bigStorageCageDetailsList = baseMapper.selectList(outWrapper);
|
List<BigStorageCageOutTask> bigStorageCageOutTaskList = bigStorageCageOutTaskMapper.selectList(null);
|
|
Map<String, BigStorageCageOutTask> listMap = bigStorageCageOutTaskList.stream()
|
.collect(Collectors.toMap(BigStorageCageOutTask::getGlassId, task -> task));
|
for (BigStorageCageDetails bigStorageCageDetails : bigStorageCageDetailsList) {
|
BigStorageCageOutTask bigStorageCageOutTask = listMap.get(bigStorageCageDetails.getGlassId());
|
bigStorageCageDetails.setBigStorageCageOutTask(bigStorageCageOutTask);
|
}
|
return bigStorageCageDetailsList;
|
}
|
|
}
|
|
/**
|
* 判断当前玻璃是否能上车
|
*/
|
@Override
|
public double selectGetBoard(String plcFeedReqLine) {
|
double carWidth = 5000;
|
LambdaQueryWrapper<BigStorageCageDetails> feedWrapper = new LambdaQueryWrapper<>();
|
feedWrapper.eq(BigStorageCageDetails::getState, plcFeedReqLine);
|
List<BigStorageCageDetails> bigStorageCageDetailsList = baseMapper.selectList(feedWrapper);
|
|
LambdaQueryWrapper<BigStorageCageFeedTask> bigStorageCageFeedTaskWrapper = new LambdaQueryWrapper<>();
|
bigStorageCageFeedTaskWrapper
|
.eq(BigStorageCageFeedTask::getTaskState, plcFeedReqLine)
|
.eq(BigStorageCageFeedTask::getLine, plcFeedReqLine);
|
|
List<BigStorageCageFeedTask> bigStorageCageFeedTaskList = bigStorageCageFeedTaskMapper.selectList(bigStorageCageFeedTaskWrapper);
|
Map<String, BigStorageCageFeedTask> listMap = bigStorageCageFeedTaskList.stream()
|
.collect(Collectors.toMap(BigStorageCageFeedTask::getGlassId, task -> task));
|
for (BigStorageCageDetails bigStorageCageDetails : bigStorageCageDetailsList) {
|
BigStorageCageFeedTask bigStorageCageFeedTask = listMap.get(bigStorageCageDetails.getGlassId());
|
bigStorageCageDetails.setBigStorageCageFeedTask(bigStorageCageFeedTask);
|
}
|
for (BigStorageCageDetails bigStorageCageDetails : bigStorageCageDetailsList
|
) {
|
if (bigStorageCageDetails.getBigStorageCageFeedTask().getTaskState() == 0) {
|
carWidth -= Integer.parseInt(bigStorageCageDetails.getWidth().toString()) + bigStorageCageDetails.getGap();
|
}
|
}
|
return carWidth;
|
|
}
|
|
|
//栓除出片任务.更新格子宽度
|
@Override
|
public void deleteBigStorageCageDetails(BigStorageCageDetails bigStorageCageDetails) {
|
baseMapper.deleteById(bigStorageCageDetails.getId());
|
bigStorageCageService.updateRemainWidth(bigStorageCageDetails.getSlot());
|
}
|
|
//理片笼详情破损
|
@Override
|
public void damageBigStorageCageDetails(String glassId) {
|
LambdaQueryWrapper<TemperingGlassInfo> temperingGlassInfoWrapper = new LambdaQueryWrapper<>();
|
temperingGlassInfoWrapper.eq(TemperingGlassInfo::getGlassId, glassId);
|
TemperingGlassInfo temperingGlassInfo = temperingGlassInfoMapper.selectOne(temperingGlassInfoWrapper);
|
|
LambdaQueryWrapper<BigStorageCageDetails> bigStorageCageDetailsWrapper = new LambdaQueryWrapper<>();
|
bigStorageCageDetailsWrapper.eq(BigStorageCageDetails::getGlassId, glassId);
|
BigStorageCageDetails bigStorageCageDetails = baseMapper.selectOne(bigStorageCageDetailsWrapper);
|
|
if (temperingGlassInfo.getState() == -2) {
|
temperingGlassInfoMapper.deleteById(temperingGlassInfo);
|
} else {
|
temperingGlassInfo.setState(5);
|
temperingGlassInfoMapper.updateById(temperingGlassInfo);
|
}
|
baseMapper.deleteById(bigStorageCageDetails.getId());
|
bigStorageCageService.updateRemainWidth(bigStorageCageDetails.getSlot());
|
//todo:插入破损数据
|
|
}
|
|
//查询玻璃信息
|
@Override
|
public BigStorageCageDetails selectBigStorageCageDetails(String glassId) {
|
LambdaQueryWrapper<GlassInfo> glassInfoWrapper = new LambdaQueryWrapper<>();
|
glassInfoWrapper.eq(GlassInfo::getGlassId, glassId);
|
GlassInfo glassInfo = glassInfoMapper.selectOne(glassInfoWrapper);
|
BigStorageCageDetails bigStorageCageDetails = new BigStorageCageDetails();
|
BeanUtils.copyProperties(glassInfo, bigStorageCageDetails);
|
bigStorageCageDetails.setState(0);
|
bigStorageCageDetails.setGap(20);
|
return bigStorageCageDetails;
|
}
|
|
//理片笼详情添加
|
@Override
|
public void insertBigStorageCageDetails(BigStorageCageDetails bigStorageCageDetails) {
|
baseMapper.insert(bigStorageCageDetails);
|
bigStorageCageService.updateRemainWidth(bigStorageCageDetails.getSlot());
|
}
|
|
//理片笼详情完成
|
@Override
|
public void finishBigStorageCageDetails(BigStorageCageDetails bigStorageCageDetails) {
|
if (bigStorageCageDetails.getState() == 1 || bigStorageCageDetails.getState() == 2) {
|
bigStorageCageDetails.setState(0);
|
baseMapper.updateById(bigStorageCageDetails);
|
bigStorageCageFeedTaskMapper.deleteById(bigStorageCageDetails.getBigStorageCageFeedTask().getId());
|
} else {
|
baseMapper.deleteById(bigStorageCageDetails.getId());
|
bigStorageCageOutTaskMapper.deleteById(bigStorageCageDetails.getBigStorageCageOutTask().getId());
|
}
|
|
}
|
|
//手动出片
|
@Override
|
public void outBigStorageCageDetails(BigStorageCageDetails bigStorageCageDetails) {
|
LambdaQueryWrapper<TemperingGlassInfo> temperingGlassInfoWrapper = new LambdaQueryWrapper<>();
|
temperingGlassInfoWrapper
|
.eq(TemperingGlassInfo::getGlassId, bigStorageCageDetails.getGlassId());
|
TemperingGlassInfo temperingGlassInfo = temperingGlassInfoMapper.selectOne(temperingGlassInfoWrapper);
|
if (temperingGlassInfo.getGlassId() == null) {
|
LambdaQueryWrapper<GlassInfo> glassInfoWrapper = new LambdaQueryWrapper<>();
|
glassInfoWrapper
|
.eq(GlassInfo::getGlassId, bigStorageCageDetails.getGlassId());
|
GlassInfo glassInfo = glassInfoMapper.selectOne(glassInfoWrapper);
|
TemperingGlassInfo temperingGlassInfo1 = new TemperingGlassInfo();
|
BeanUtils.copyProperties(glassInfo, temperingGlassInfo1);
|
|
if (temperingGlassInfo.getTemperingLayoutId() != null) {
|
temperingGlassInfo1.setState(-1);
|
} else {
|
temperingGlassInfo1.setState(-2);
|
}
|
temperingGlassInfoMapper.insert(temperingGlassInfo1);
|
}
|
}
|
|
@Override
|
public BigStorageDTO queryTargetSlotByTempering(GlassInfo glassInfo) {
|
// MPJLambdaWrapper<BigStorageDTO> wrapper = new MPJLambdaWrapper<>(BigStorageCage.class)
|
// .selectAll(BigStorageDTO.class)
|
// .leftJoin(BigStorageCageDetails.class, BigStorageCageDetails::getSlot, BigStorageCage::getSlot)
|
// .eq(BigStorageCageDetails::getTemperingLayoutId, glassInfo.getTemperingLayoutId())
|
// .eq(BigStorageCageDetails::getTemperingFeedSequence, glassInfo.getTemperingFeedSequence() + 1)
|
// .last("limit 1");
|
BigStorageDTO bigStorageDTO = null;
|
MPJLambdaWrapper<BigStorageCage> wrapper = new MPJLambdaWrapper<>(BigStorageCage.class)
|
.selectAsClass(BigStorageCage.class, BigStorageDTO.class)
|
.leftJoin(BigStorageCageDetails.class, BigStorageCageDetails::getSlot, BigStorageCage::getSlot)
|
.eq(BigStorageCageDetails::getTemperingLayoutId, glassInfo.getTemperingLayoutId())
|
.eq(BigStorageCageDetails::getTemperingFeedSequence, glassInfo.getTemperingFeedSequence() + 1)
|
.last("limit 1");
|
bigStorageDTO = bigStorageCageService.selectJoinOne(BigStorageDTO.class, wrapper);
|
if (null != bigStorageDTO) {
|
return bigStorageDTO;
|
}
|
BigStorageCage bigStorageCage = bigStorageCageService.getOne(new LambdaQueryWrapper<BigStorageCage>()
|
.eq(BigStorageCage::getRemainWidth, Const.BIG_STORAGE_WIDTH)
|
.inSql(BigStorageCage::getDeviceId,
|
"select distinct device_id from big_storage_cage_details where tempering_layout_id = " + glassInfo.getTemperingLayoutId())
|
.last("limit 1"));
|
if (null != bigStorageCage) {
|
bigStorageDTO = new BigStorageDTO();
|
bigStorageDTO.setWidth(bigStorageCage.getRemainWidth());
|
bigStorageDTO.setSlot(bigStorageCage.getSlot());
|
return bigStorageDTO;
|
}
|
bigStorageCage = bigStorageCageService.getOne(new LambdaQueryWrapper<BigStorageCage>()
|
.eq(BigStorageCage::getRemainWidth, Const.BIG_STORAGE_WIDTH)
|
.last("limit 1"));
|
Assert.isTrue(null != bigStorageCage, "没有空余的笼子存放玻璃");
|
bigStorageDTO = new BigStorageDTO();
|
bigStorageDTO.setWidth(bigStorageCage.getRemainWidth());
|
bigStorageDTO.setSlot(bigStorageCage.getSlot());
|
return bigStorageDTO;
|
|
|
}
|
|
@Override
|
public TemperingLayoutDTO temperingIsAll() {
|
return baseMapper.temperingIsAll();
|
}
|
}
|
