From 2b91b242113bd10f1be241d19ab154e9ad6506cd Mon Sep 17 00:00:00 2001 From: wangfei <3597712270@qq.com> Date: 星期二, 10 六月 2025 14:18:00 +0800 Subject: [PATCH] 国际化命名 --- hangzhoumesParent/moduleService/CacheVerticalGlassModule/src/main/java/com/mes/bigstorage/service/impl/BigStorageCageDetailsServiceImpl.java | 197 ++++++++++++++++++++++++++++++++++++++++-------- 1 files changed, 162 insertions(+), 35 deletions(-) diff --git a/hangzhoumesParent/moduleService/CacheVerticalGlassModule/src/main/java/com/mes/bigstorage/service/impl/BigStorageCageDetailsServiceImpl.java b/hangzhoumesParent/moduleService/CacheVerticalGlassModule/src/main/java/com/mes/bigstorage/service/impl/BigStorageCageDetailsServiceImpl.java index ee80460..d53d7a5 100644 --- a/hangzhoumesParent/moduleService/CacheVerticalGlassModule/src/main/java/com/mes/bigstorage/service/impl/BigStorageCageDetailsServiceImpl.java +++ b/hangzhoumesParent/moduleService/CacheVerticalGlassModule/src/main/java/com/mes/bigstorage/service/impl/BigStorageCageDetailsServiceImpl.java @@ -6,33 +6,37 @@ import com.github.yulichang.base.MPJBaseServiceImpl; import com.github.yulichang.toolkit.JoinWrappers; import com.github.yulichang.wrapper.MPJLambdaWrapper; +import com.google.common.collect.Lists; +import com.mes.base.entity.vo.BigStorageVO; 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.entity.dto.*; +import com.mes.bigstorage.entity.vo.BigStorageQueryVO; import com.mes.bigstorage.mapper.BigStorageCageDetailsMapper; import com.mes.bigstorage.service.BigStorageCageDetailsService; import com.mes.bigstorage.service.BigStorageCageService; +import com.mes.bigstoragecagetask.entity.BigStorageCageHistoryTask; +import com.mes.bigstoragecagetask.service.BigStorageCageHistoryTaskService; import com.mes.bigstoragetask.entity.BigStorageCageFeedTask; import com.mes.bigstoragetask.entity.BigStorageCageOutTask; import com.mes.bigstoragetask.entity.UpdateBigStorageCageDTO; import com.mes.bigstoragetask.mapper.BigStorageCageFeedTaskMapper; import com.mes.bigstoragetask.mapper.BigStorageCageOutTaskMapper; import com.mes.common.config.Const; +import com.mes.common.config.ConstSysConfig; import com.mes.damage.entity.Damage; import com.mes.damage.service.DamageService; import com.mes.glassinfo.entity.GlassInfo; import com.mes.glassinfo.mapper.GlassInfoMapper; import com.mes.glassinfo.service.GlassInfoService; -import com.mes.job.PlcStorageCageTask; +import com.mes.sysconfig.entity.SysConfig; +import com.mes.sysconfig.service.SysConfigService; import com.mes.temperingglass.entity.TemperingGlassInfo; import com.mes.temperingglass.mapper.TemperingGlassInfoMapper; import com.mes.temperingglass.service.TemperingGlassInfoService; import com.mes.utils.RedisUtil; import lombok.extern.slf4j.Slf4j; import org.springframework.beans.BeanUtils; -import org.springframework.beans.factory.annotation.Value; import org.springframework.stereotype.Service; import javax.annotation.Resource; @@ -70,26 +74,29 @@ @Resource private TemperingGlassInfoService temperingGlassInfoService; - @Resource - private PlcStorageCageTask plcStorageCageTask; + private SysConfigService sysConfigService; + @Resource private DamageService damageService; @Resource private RedisUtil redisUtil; - @Value("${mes.minCount}") - private int minCount; - - @Value("${mes.slotWidth}") - private Integer slotWidth; - - @Value("${mes.glassGap}") - private Integer glassGap; - - @Value("${mes.sequence.order}") - private boolean sequenceOrder; + @Resource + BigStorageCageHistoryTaskService bigStorageCageHistoryTaskService; +// +// @Value("${mes.minCount}") +// private int minCount; +// +// @Value("${mes.slotWidth}") +// private Integer slotWidth; +// +// @Value("${mes.glassGap}") +// private Integer glassGap; +// +// @Value("${mes.sequence.order}") +// private boolean sequenceOrder; @Override @@ -165,7 +172,7 @@ for (BigStorageCageDetails bigStorageCageDetails : bigStorageCageDetailsList ) { if (bigStorageCageDetails.getBigStorageCageFeedTask().getTaskState() == 0) { - carWidth = carWidth - bigStorageCageDetails.getWidth() - glassGap; + carWidth = carWidth - bigStorageCageDetails.getWidth() - 250; } } return carWidth; @@ -231,7 +238,7 @@ if (glassInfo != null) { BeanUtils.copyProperties(glassInfo, bigStorageCageDetails); bigStorageCageDetails.setState(1); - bigStorageCageDetails.setGap(glassGap); + bigStorageCageDetails.setGap(250); bigStorageCageDetailsList = new ArrayList<>(); bigStorageCageDetailsList.add(bigStorageCageDetails); } @@ -269,6 +276,7 @@ @Override public BigStorageDTO queryTargetSlotByTempering(GlassInfo glassInfo) { BigStorageDTO bigStorageDTO = null; + int slotWidth = sysConfigService.queryConfigValue(ConstSysConfig.VERTICAL_SLOT_WIDTH); MPJLambdaWrapper<BigStorageCage> wrapper = new MPJLambdaWrapper<>(BigStorageCage.class) .selectAll(BigStorageCage.class) .leftJoin(BigStorageCageDetails.class, BigStorageCageDetails::getSlot, BigStorageCage::getSlot) @@ -296,7 +304,7 @@ } bigStorageCage = bigStorageCageService.getOne(new LambdaQueryWrapper<BigStorageCage>() .eq(BigStorageCage::getEnableState, Const.SLOT_ON) - .eq(BigStorageCage::getRemainWidth, slotWidth) + .eq(BigStorageCage::getRemainWidth, slotWidth).orderByAsc(BigStorageCage::getSlot) // .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()) @@ -337,7 +345,7 @@ } for (Integer item : deviceUsedList) { bigStorageCage = bigStorageCageService.getOne(new LambdaQueryWrapper<BigStorageCage>() - .eq(BigStorageCage::getRemainWidth, slotWidth) + .eq(BigStorageCage::getRemainWidth, slotWidth).orderByAsc(BigStorageCage::getSlot) .eq(BigStorageCage::getEnableState, Const.SLOT_ON) .eq(BigStorageCage::getDeviceId, item) .last("limit 1")); @@ -380,7 +388,7 @@ @Override public List<TemperingLayoutDTO> queryTemperingOccupySlot() { - return baseMapper.queryTemperingOccupySlot(minCount); + return baseMapper.queryTemperingOccupySlot(10); } @Override @@ -391,24 +399,36 @@ @Override public boolean temperingGlass(String temperingLayoutId, String engineerId, String temperingFeedSequence) { LambdaQueryWrapper<TemperingGlassInfo> temperingGlassInfoLambdaQueryWrapper = new LambdaQueryWrapper<>(); + SysConfig sysConfig = sysConfigService.queryConfigById(ConstSysConfig.CACHE_SEQUENCE_ORDER_TRUE); + boolean sequenceOrder = Boolean.parseBoolean(sysConfig.getConfigValue()); temperingGlassInfoLambdaQueryWrapper .eq(TemperingGlassInfo::getState, Const.TEMPERING_NEW); List<TemperingGlassInfo> temperingGlassInfoList = temperingGlassInfoMapper.selectList(temperingGlassInfoLambdaQueryWrapper); + int dispatchCount = bigStorageCageHistoryTaskService.count(new LambdaQueryWrapper<BigStorageCageHistoryTask>() + .eq(BigStorageCageHistoryTask::getTaskState, Const.GLASS_STATE_NEW) + .eq(BigStorageCageHistoryTask::getTaskType, Const.BIG_STORAGE_BEFORE_DISPATCH)); + if (temperingGlassInfoList.size() == 0) { - List<TemperingGlassInfo> temperingGlassInfos = glassInfoService.selectJoinList(TemperingGlassInfo.class, JoinWrappers.lambda(GlassInfo.class) - .selectAll(GlassInfo.class) - .select("-1 as state") - .selectAs(BigStorageCageDetails::getSlot, TemperingGlassInfo::getSlot) + MPJLambdaWrapper<GlassInfo> wrapper = JoinWrappers.lambda(GlassInfo.class) + .select("-1 as state,t.filmsid as films_id,t.glass_id,t.flow_card_id,t.glass_type,t.width,t.height" + + ",t.thickness,t.ishorizontal,t.tempering_layout_id,t.tempering_feed_sequence,t.x_coordinate,t.y_coordinate," + + "t.angle,t1.slot,t.engineer_id") .innerJoin(BigStorageCageDetails.class, BigStorageCageDetails::getGlassId, GlassInfo::getGlassId) .eq(GlassInfo::getTemperingLayoutId, temperingLayoutId) .eq(GlassInfo::getEngineerId, engineerId) - .in(BigStorageCageDetails::getState, Const.GLASS_STATE_IN) - .orderBy(Boolean.TRUE, sequenceOrder, GlassInfo::getTemperingFeedSequence)); + + .orderBy(Boolean.TRUE, sequenceOrder, GlassInfo::getTemperingFeedSequence); + if (dispatchCount > 0) { + wrapper.in(BigStorageCageDetails::getState, Const.GLASS_STATE_IN_ALL); + } else { + wrapper.in(BigStorageCageDetails::getState, Const.GLASS_STATE_IN); + } + List<TemperingGlassInfo> temperingGlassInfos = glassInfoService.selectJoinList(TemperingGlassInfo.class, wrapper); if (CollectionUtils.isNotEmpty(temperingGlassInfos)) { if ("0".equals(temperingFeedSequence)) { if (CollectionUtils.isNotEmpty(temperingGlassInfos)) { - plcStorageCageTask.computeOutMoreGlassInfo(temperingGlassInfos, Boolean.FALSE, ""); +// plcStorageCageTask.computeOutMoreGlassInfo(temperingGlassInfos, Boolean.FALSE, ""); } } else { temperingGlassInfoService.saveBatch(temperingGlassInfos); @@ -421,14 +441,62 @@ @Override - public List<Map<String, Object>> selectTemperingGlass() { - List<Map<String, Object>> temperingGlass = baseMapper.selectTemperingGlassCount(); - return temperingGlass; + public List<TemperingGlassCountDTO> selectTemperingGlass(int isTempering) { + return baseMapper.selectTemperingGlassCount(isTempering); } @Override public void updateBySlot(List<UpdateBigStorageCageDTO> glassList, int state) { baseMapper.updateBySlot(glassList, state); + } + + @Override + public String dispatchSwitch(Boolean flag) { + redisUtil.setCacheObject("dispatchSwitch", flag); + return "success"; + } + + @Override + public List<GlassInfoLackDTO> queryLackGlassInfo(BigStorageQueryVO bigStorageQueryVO) { + return baseMapper.queryLackGlassInfo(bigStorageQueryVO); + } + + @Override + public List<BigStorageCageDetails> queryRealGlassInfo(BigStorageQueryVO bigStorageQueryVO) { + return this.list(new LambdaQueryWrapper<BigStorageCageDetails>() + .eq(BigStorageCageDetails::getEngineerId, bigStorageQueryVO.getEngineerId()) + .eq(BigStorageCageDetails::getTemperingLayoutId, bigStorageQueryVO.getTemperingLayoutId()) + .in(BigStorageCageDetails::getState, Const.GLASS_STATE_IN_ALL).orderByAsc(BigStorageCageDetails::getTemperingFeedSequence)); + } + + @Override + public Map<Integer, List<BigStorageVO>> querybigStorageCageDetail() { + List<BigStorageVO> bigStorageCages = baseMapper.querybigStorageCageDetail(); + return bigStorageCages.stream().collect(Collectors.groupingBy(item -> item.getDeviceId())); + } + + @Override + public boolean cancelTemperingTask() { + //褰撳墠姝e湪鎵ц鐨勫嚭鐗囦换鍔� + List<BigStorageCageHistoryTask> historyTaskList = bigStorageCageHistoryTaskService.list(new LambdaQueryWrapper<BigStorageCageHistoryTask>() + .eq(BigStorageCageHistoryTask::getTaskState, Const.GLASS_STATE_NEW) + .eq(BigStorageCageHistoryTask::getTargetSlot, Const.TEMPERING_OUT_TARGET_POSITION)); + //涓嶅瓨鍦ㄥ嚭鐗囦换鍔★紝鐩存帴鍒犻櫎閽㈠寲灏忕墖琛ㄦ湭鍑虹墖鐨勪换鍔� + if (CollectionUtils.isEmpty(historyTaskList)) { + temperingGlassInfoMapper.delete(new LambdaQueryWrapper<TemperingGlassInfo>().eq(TemperingGlassInfo::getState, Const.TEMPERING_NEW)); + return Boolean.TRUE; + } + //瀛樺湪鍑虹墖浠诲姟锛屽垹闄ら挗鍖栧皬鐗囪〃 + List<String> glassIdList = historyTaskList.stream().map(BigStorageCageHistoryTask::getGlassId).collect(Collectors.toList()); + GlassInfo glassInfo = glassInfoService.getOne(new LambdaQueryWrapper<GlassInfo>().in(GlassInfo::getGlassId, glassIdList) + .orderByDesc(GlassInfo::getTemperingFeedSequence).last("limit 1")); + temperingGlassInfoMapper.delete(new LambdaQueryWrapper<TemperingGlassInfo>() + .eq(TemperingGlassInfo::getEngineerId, glassInfo.getEngineerId()) + .eq(TemperingGlassInfo::getState, Const.TEMPERING_NEW) + .ge(TemperingGlassInfo::getTemperingLayoutId, glassInfo.getTemperingLayoutId()) + .gt(TemperingGlassInfo::getTemperingFeedSequence, glassInfo.getTemperingFeedSequence()) + ); + return Boolean.TRUE; } @Override @@ -438,7 +506,66 @@ } @Override - public void appointEngineerId(String engineerId) { - redisUtil.setCacheObject("temperingengineerId", engineerId); + public boolean appointTemperingEngineerId(String engineerId) { + LambdaQueryWrapper<TemperingGlassInfo> temperingGlassInfoLambdaQueryWrapper = new LambdaQueryWrapper<>(); + temperingGlassInfoLambdaQueryWrapper + .eq(TemperingGlassInfo::getState, Const.TEMPERING_NEW); + List<TemperingGlassInfo> temperingGlassInfoList = temperingGlassInfoMapper.selectList(temperingGlassInfoLambdaQueryWrapper); + + int dispatchCount = bigStorageCageHistoryTaskService.count(new LambdaQueryWrapper<BigStorageCageHistoryTask>() + .eq(BigStorageCageHistoryTask::getTaskState, Const.GLASS_STATE_NEW) + .eq(BigStorageCageHistoryTask::getTaskType, Const.BIG_STORAGE_BEFORE_DISPATCH)); + + if (temperingGlassInfoList.size() == 0) { + MPJLambdaWrapper<GlassInfo> wrapper = JoinWrappers.lambda(GlassInfo.class) + .select("-1 as state,t.filmsid as films_id,t.glass_id,t.flow_card_id,t.glass_type,t.width,t.height" + + ",t.thickness,t.ishorizontal,t.tempering_layout_id,t.tempering_feed_sequence,t.x_coordinate,t.y_coordinate," + + "t.angle,t1.slot,t.engineer_id") + .innerJoin(BigStorageCageDetails.class, BigStorageCageDetails::getGlassId, GlassInfo::getGlassId) + .eq(GlassInfo::getEngineerId, engineerId) + .ne(GlassInfo::getTemperingLayoutId, 0) + .orderByAsc(BigStorageCageDetails::getTemperingLayoutId) + .orderByAsc(BigStorageCageDetails::getTemperingFeedSequence); + if (dispatchCount > 0) { + wrapper.in(BigStorageCageDetails::getState, Const.GLASS_STATE_IN_ALL); + } else { + wrapper.in(BigStorageCageDetails::getState, Const.GLASS_STATE_IN); + } + List<TemperingGlassInfo> temperingGlassInfos = glassInfoService.selectJoinList(TemperingGlassInfo.class, wrapper); + + if (CollectionUtils.isNotEmpty(temperingGlassInfos)) { + //閬垮厤澶ч噺鏁版嵁鎻掑叆瀵艰嚧sqlserver鏁版嵁搴撳紓甯革紝鍒嗘壒娆℃瘡璋冨瓨鍌ㄤ緷娆� + List<List<TemperingGlassInfo>> temperingGlassInfoLists = Lists.partition(temperingGlassInfos, 50); + for (List<TemperingGlassInfo> item : temperingGlassInfoLists) { + temperingGlassInfoService.saveBatch(item); + } + return true; + } + } + return false; + } + + @Override + public List<BigStorageRelationDTO> queryIsAllNeedDispatchVirtualSlot() { + return baseMapper.queryIsAllNeedDispatchVirtualSlot(); + } + + @Override + public List<BigStorageSequenceDTO> dispatchBigStorageGlassInfo(BigStorageRelationDTO bigStorageRelationDTO) { + return baseMapper.queryNeedDispatchSlot(bigStorageRelationDTO); + } + + @Override + public String bigStorageGlassDamageByGlassId(String glassId) { + Damage damage = new Damage(); + damage.setGlassId(glassId); + damage.setType(Const.GLASS_STATE_DAMAGE); + damageService.insertDamage(damage); + return "success"; + } + + @Override + public void updateDeviceIdBySlot(List<Integer> slotList) { + baseMapper.updateDeviceIdBySlot(slotList); } } -- Gitblit v1.8.0