派生自 HangZhouMes
hangzhoumesParent/moduleService/CacheGlassModule/src/main/java/com/mes/edgstoragecage/service/impl/EdgStorageCageDetailsServiceImpl.java
@@ -1,21 +1,28 @@ package com.mes.edgstoragecage.service.impl; import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; import com.github.yulichang.base.MPJBaseServiceImpl; import com.github.yulichang.query.MPJLambdaQueryWrapper; import com.github.yulichang.query.MPJQueryWrapper; import com.github.yulichang.wrapper.interfaces.LambdaJoin; 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.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.uppattenusage.entity.UpPattenUsage; import com.mes.uppattenusage.mapper.UpPattenUsageMapper; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import java.util.List; import java.util.Map; import java.util.Objects; /** * <p> @@ -30,47 +37,146 @@ @Autowired UpPattenUsageMapper upPattenUsageMapper; @Autowired OptimizeDetailMapper optimizeDetailMapper; //识别 破损/拿走 public boolean identWorn(String glassid, int ControlsId) { List<EdgStorageCageDetails> edgStorageCageDetails = baseMapper.selectList(new QueryWrapper<EdgStorageCageDetails>().eq("glassid", glassid)); @Autowired EdgStorageCageMapper edgStorageCageMapper; /** * 识别 拿走:200/破损:201 * @param glassId * @param ControlsId * @return */ 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) { baseMapper.update(edgStorageCageDetails.get(0), new QueryWrapper<EdgStorageCageDetails>().eq("glassid", glassid)); 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> selectCutTerritory() { List<Map> list = upPattenUsageMapper.selectJoinList( Map.class, new MPJQueryWrapper<UpPattenUsage>().selectAll(UpPattenUsage.class) .select("escd.glass_id", "escd.flow_card_id", "escd.width", "escd.height") .select("gi.x_coordinate","gi.y_coordinate","gi.tempering_feed_sequence") .leftJoin("glass_info gi on t.layout_sequence=gi.pattern_sequence and t.engineering_id=gi.engineer_id") .leftJoin("edg_storage_cage_details escd on gi.id=escd.glass_id") .eq("t.state", 1) .orderByAsc("t.layout_sequence") ); return list; 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> selectCurrentCutTerritory(String current) { List<Map> list = baseMapper.selectJoinList( Map.class, new MPJQueryWrapper<EdgStorageCageDetails>().selectAll(EdgStorageCageDetails.class) .select("escd.glass_id", "escd.flow_card_id", "escd.width", "escd.height") .leftJoin("glass_info gi on t.layout_sequence=gi.pattern_sequence and t.engineering_id=gi.engineer_id") .leftJoin("edg_storage_cage_details escd on gi.id=escd.glass_id") .eq("t.engineering_id", current) .orderByAsc("t.layout_sequence") 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 list; //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 poor * @return */ @Override public EdgStorageCageDetails selectConformGlass(String glassId, int poor){ //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()+poor) .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; } }
