YiWuProject.git

			@@ -1,51 +1,250 @@
			package com.mes.edgstoragecage.service.impl;

			import com.github.yulichang.query.MPJQueryWrapper;
			import com.github.yulichang.wrapper.MPJAbstractLambdaWrapper;
			import cn.hutool.core.lang.Assert;
			import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
			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.edgstoragecage.entity.EdgStorageCage;
			import com.mes.edgstoragecage.entity.EdgStorageCageDetails;
			import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
			import com.mes.edgstoragecage.mapper.EdgStorageCageDetailsMapper;
			import com.mes.edgstoragecage.mapper.EdgStorageCageMapper;
			import com.mes.edgstoragecage.service.EdgStorageCageDetailsService;
			import com.mes.taskcache.mapper.HangzhouMesMapper;
			import com.mes.pp.entity.OptimizeDetail;
			import com.mes.pp.entity.OptimizeLayout;
			import com.mes.pp.mapper.OptimizeDetailMapper;
			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 java.util.List;
			import java.util.Map;
			import java.util.stream.Collectors;

			/**
			* <p>
			* 服务实现类
			* 服务实现类
			* </p>
			*
			* @author zhoush
			* @since 2024-04-07
			*/
			@Service
			public class EdgStorageCageDetailsServiceImpl extends ServiceImpl<EdgStorageCageDetailsMapper, EdgStorageCageDetails> implements EdgStorageCageDetailsService {
			//获取全部数据
			@Autowired
			private HangzhouMesMapper hangzhouMesMapper;
			@Autowired
			private EdgStorageCageDetailsMapper edgStorageCageDetailsMapper;
			@Slf4j
			public class EdgStorageCageDetailsServiceImpl extends MPJBaseServiceImpl<EdgStorageCageDetailsMapper, EdgStorageCageDetails> implements EdgStorageCageDetailsService {

			//获取磨边前缓存理片笼信息
			@Autowired
			UpPattenUsageMapper upPattenUsageMapper;

			@Autowired
			OptimizeDetailMapper optimizeDetailMapper;

			@Autowired
			EdgStorageCageMapper edgStorageCageMapper;

			@Autowired
			TaskCacheService taskCacheService;


			/**
			* 识别拿走:200/破损:201
			*
			* @param glassId
			* @param ControlsId
			* @return
			*/
			@Override
			public List<Map> getEdgStorageInfos(){
			List<Map> map=edgStorageCageDetailsMapper.selectJoinList(
			Map.class,new MPJQueryWrapper<EdgStorageCage>().selectAll(EdgStorageCage.class)
			.select("a.c","a.d")
			.leftJoin("ab a on t.id=a.id")
			.le("a.id","1")
			public boolean identWorn(String glassId, int ControlsId) {
			List<EdgStorageCageDetails> edgStorageCageDetails = baseMapper.selectList(new MPJLambdaQueryWrapper<EdgStorageCageDetails>().selectAll(EdgStorageCageDetails.class).eq(EdgStorageCageDetails::getGlassId, glassId));
			if (edgStorageCageDetails.size() == 1) {
			EdgStorageCageDetails item = edgStorageCageDetails.get(0);
			item.setState(ControlsId);
			baseMapper.update(edgStorageCageDetails.get(0), new MPJLambdaWrapper<EdgStorageCageDetails>().selectAll(EdgStorageCageDetails.class).eq(EdgStorageCageDetails::getGlassId, glassId));
			return true;
			}
			// Sql版本
			// List<EdgStorageCageDetails> edgStorageCageDetails = baseMapper.selectList(new QueryWrapper<EdgStorageCageDetails>().eq("glass_id", glassId));
			// if (edgStorageCageDetails.size() == 1) {
			// EdgStorageCageDetails item=edgStorageCageDetails.get(0);
			// item.setState(ControlsId);
			// baseMapper.update(edgStorageCageDetails.get(0), new QueryWrapper<EdgStorageCageDetails>().eq("glass_id", glassId));
			// return true;
			// }
			return false;
			}

			/**
			* 获取切割当前版图
			*
			* @return
			*/
			@Override
			public List<Map<String, Object>> selectCutTerritory() {
			List<UpPattenUsage> upPattenUsage = upPattenUsageMapper.selectList(new MPJLambdaWrapper<UpPattenUsage>()
			.selectAll(UpPattenUsage.class)
			.eq(UpPattenUsage::getState, 1));

			if (!upPattenUsage.isEmpty()) {
			UpPattenUsage upPattenUsage1 = upPattenUsage.get(0);
			return optimizeDetailMapper.selectJoinMaps(JoinWrappers.lambda(OptimizeDetail.class)
			.selectAll(OptimizeDetail.class)
			.selectAs(OptimizeLayout::getWidth, "olWidth")
			.selectAs(OptimizeLayout::getWidth, "olHeight")
			.leftJoin(OptimizeLayout.class, on -> on
			.eq(OptimizeLayout::getProjectNo, OptimizeDetail::getProjectNo)
			.eq(OptimizeLayout::getStockId, OptimizeDetail::getStockId))
			.eq(OptimizeDetail::getProjectNo, upPattenUsage1.getEngineeringId())
			.eq(OptimizeDetail::getStockId, upPattenUsage1.getLayoutSequence())
			);

			// Sql版本
			// return optimizeDetailMapper.selectJoinMaps(new MPJQueryWrapper<OptimizeDetail>().selectAll(OptimizeDetail.class)
			// .select("ol.width as olwidth","ol.height as olheight")
			// .leftJoin("optimize_layout ol on t.project_no=ol.project_no and t.stock_id=ol.stock_id")
			// .eq("t.project_no", upPattenUsage1.getEngineeringId())
			// .eq("t.stock_id",upPattenUsage1.getLayoutSequence())
			// );
			}
			return null;
			}

			/**
			* 获取工程下的当前版图
			*
			* @param current
			* @return
			*/
			@Override
			public List<Map<String, Object>> selectCurrentCutTerritory(String current) {

			return optimizeDetailMapper.selectJoinMaps(JoinWrappers.lambda(OptimizeDetail.class)
			.selectAll(OptimizeDetail.class)
			.selectAs(OptimizeLayout::getWidth, "olWidth")
			.selectAs(OptimizeLayout::getWidth, "olHeight")
			.leftJoin(OptimizeLayout.class, on -> on
			.eq(OptimizeLayout::getProjectNo, OptimizeDetail::getProjectNo)
			.eq(OptimizeLayout::getStockId, OptimizeDetail::getStockId))
			.eq(OptimizeDetail::getProjectNo, current)
			);
			return map;
			};
			//Sql版本
			// return optimizeDetailMapper.selectJoinMaps(new MPJQueryWrapper<OptimizeDetail>().selectAll(OptimizeDetail.class)
			// .select("ol.width as olwidth","ol.height as olheight")
			// .leftJoin("optimize_layout ol on t.project_no=ol.project_no and t.stock_id=ol.stock_id")
			// .eq("t.project_no",current)
			// );
			}

			/**
			* 查询笼内版图差值范围内的此尺寸玻璃如无则按照钢化版图序号以及玻璃序号
			*
			* @param glassId
			* @param threshold
			* @return
			*/
			@Override
			public List<Map> setEdgStorageInfos(){
			return hangzhouMesMapper.selectCachInfo();
			};
			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;
			}
			}