From 41173fc2dfd848b08a217ab725033a412868a31c Mon Sep 17 00:00:00 2001 From: ZengTao <2773468879@qq.com> Date: 星期二, 06 八月 2024 10:59:01 +0800 Subject: [PATCH] 修改磨边界面显示数据为磨边队列表的数据 --- hangzhoumesParent/moduleService/CacheGlassModule/src/main/java/com/mes/taskcache/service/impl/TaskCacheServiceImpl.java | 88 +++++++++++++++++++++++++------------------- 1 files changed, 50 insertions(+), 38 deletions(-) diff --git a/hangzhoumesParent/moduleService/CacheGlassModule/src/main/java/com/mes/taskcache/service/impl/TaskCacheServiceImpl.java b/hangzhoumesParent/moduleService/CacheGlassModule/src/main/java/com/mes/taskcache/service/impl/TaskCacheServiceImpl.java index 0e330b0..cf78834 100644 --- a/hangzhoumesParent/moduleService/CacheGlassModule/src/main/java/com/mes/taskcache/service/impl/TaskCacheServiceImpl.java +++ b/hangzhoumesParent/moduleService/CacheGlassModule/src/main/java/com/mes/taskcache/service/impl/TaskCacheServiceImpl.java @@ -1,5 +1,6 @@ package com.mes.taskcache.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; @@ -7,6 +8,7 @@ import com.mes.common.config.Const; import com.mes.damage.entity.Damage; import com.mes.damage.service.DamageService; +import com.mes.edgglasstask.entity.EdgGlassTaskInfo; import com.mes.edgstoragecage.entity.EdgStorageCage; import com.mes.edgstoragecage.entity.EdgStorageCageDetails; import com.mes.edgstoragecage.mapper.EdgStorageCageDetailsMapper; @@ -23,7 +25,7 @@ /** * <p> - * 鏈嶅姟瀹炵幇绫� + * 鏈嶅姟瀹炵幇绫� * </p> * * @author zhoush @@ -44,57 +46,59 @@ /** * 娣诲姞鐞嗙墖绗间换鍔� + * * @param taskCache * @return */ @Override - public boolean insertTaskCache(TaskCache taskCache){ + public boolean insertTaskCache(TaskCache taskCache) { baseMapper.insert(taskCache); return true; } /** * 鏌ヨ纾ㄨ竟浠诲姟 + * * @param line * @return */ @Override - public List<Map<String,Object>> selectEdgInfo(String line) { - List<TaskCache> taskCache=baseMapper.selectList(new MPJLambdaWrapper<TaskCache>() + public List<Map<String, Object>> selectEdgInfo(String line) { + List<TaskCache> taskCache = baseMapper.selectList(new MPJLambdaWrapper<TaskCache>() .selectAll(TaskCache.class) .eq(TaskCache::getEndCell, line) - .eq(TaskCache::getTaskStatus,1) + .eq(TaskCache::getTaskStatus, 1) .orderByAsc(TaskCache::getCreateTime)); - List<Map<String,Object>> result=new ArrayList<>(); - int serialNumber=1; - for(TaskCache taskCache1:taskCache){ - Map<String,Object> map=new HashMap<>(); + List<Map<String, Object>> result = new ArrayList<>(); + int serialNumber = 1; + for (TaskCache taskCache1 : taskCache) { + Map<String, Object> map = new HashMap<>(); // GlassInfo glassInfo=glassInfoMapper.selectOne(new MPJLambdaWrapper<GlassInfo>() // .selectAll(GlassInfo.class) // .eq(GlassInfo::getGlassId,taskCache1.getGlassId())); - List<GlassInfo> glassInfos=glassInfoMapper.selectJoinList(GlassInfo.class, new MPJLambdaWrapper<GlassInfo>() + List<GlassInfo> glassInfos = glassInfoMapper.selectJoinList(GlassInfo.class, new MPJLambdaWrapper<GlassInfo>() .selectAll(GlassInfo.class) .innerJoin(EdgStorageCageDetails.class, on -> on .eq(EdgStorageCageDetails::getGlassId, GlassInfo::getGlassId) .eq(EdgStorageCageDetails::getEngineerId, GlassInfo::getEngineerId)) - .eq(GlassInfo::getGlassId,taskCache1.getGlassId()) - .eq(EdgStorageCageDetails::getState,Const.GLASS_STATE_OUT) + .eq(GlassInfo::getGlassId, taskCache1.getGlassId()) + .eq(EdgStorageCageDetails::getState, Const.GLASS_STATE_OUT) ); - if(glassInfos.size()==1){ - GlassInfo glassInfo=glassInfos.get(0); - map.put("Line",line);//绾胯矾 2001 1绾匡紝 2002 2绾� - map.put("Width",glassInfo.getWidth());//瀹� - map.put("Height",glassInfo.getHeight());//楂� - map.put("Thickness",glassInfo.getThickness());//鍘� - map.put("GlassId",glassInfo.getGlassId());//鐜荤拑ID - map.put("FlowCardId",glassInfo.getFlowCardId());//娴佺▼鍗″彿 - map.put("TemperingLayoutId",glassInfo.getTemperingLayoutId());// 鏆備笉鏄剧ず 閽㈠寲鐗堝浘ID - map.put("TemperingFeedSequence",glassInfo.getTemperingFeedSequence());// 鏆備笉鏄剧ず 閽㈠寲鐗堝浘ID鍐呯殑搴忓彿 - map.put("FilmsId",glassInfo.getFilmsid());//鑶滅郴 - map.put("SerialNumber",serialNumber);//鍑虹墖椤哄簭 + if (glassInfos.size() == 1) { + GlassInfo glassInfo = glassInfos.get(0); + map.put("Line", line);//绾胯矾 2001 1绾匡紝 2002 2绾� + map.put("Width", glassInfo.getWidth());//瀹� + map.put("Height", glassInfo.getHeight());//楂� + map.put("Thickness", glassInfo.getThickness());//鍘� + map.put("GlassId", glassInfo.getGlassId());//鐜荤拑ID + map.put("FlowCardId", glassInfo.getFlowCardId());//娴佺▼鍗″彿 + map.put("TemperingLayoutId", glassInfo.getTemperingLayoutId());// 鏆備笉鏄剧ず 閽㈠寲鐗堝浘ID + map.put("TemperingFeedSequence", glassInfo.getTemperingFeedSequence());// 鏆備笉鏄剧ず 閽㈠寲鐗堝浘ID鍐呯殑搴忓彿 + map.put("FilmsId", glassInfo.getFilmsid());//鑶滅郴 + map.put("SerialNumber", serialNumber);//鍑虹墖椤哄簭 result.add(map); - }else if(glassInfos.size()>1){ - log.info("鏁版嵁涓嶇鍚堥�昏緫--纾ㄨ竟闃熷垪glassId閲嶅:",glassInfos); + } else if (glassInfos.size() > 1) { + log.info("鏁版嵁涓嶇鍚堥�昏緫--纾ㄨ竟闃熷垪glassId閲嶅:", glassInfos); return new ArrayList<>(); } serialNumber++; @@ -111,16 +115,18 @@ /** * 鏌ヨ寰呯悊鐗囧伐浣滅殑浠诲姟 + * * @return */ @Override - public List<TaskCache> selectCacheInfo(){ - return baseMapper.selectList(new MPJLambdaWrapper<TaskCache>().selectAll(TaskCache.class).eq(TaskCache::getTaskStatus,0)); + public List<TaskCache> selectCacheInfo() { + return baseMapper.selectList(new MPJLambdaWrapper<TaskCache>().selectAll(TaskCache.class).eq(TaskCache::getTaskStatus, 0)); // return baseMapper.selectList(new QueryWrapper<TaskCache>().eq("task_status",0)); } /** * 鏌ヨ鍏ㄩ儴浠诲姟 + * * @return */ @Override @@ -130,54 +136,60 @@ /** * 鏌ヨ寰呰繘鐗囦换鍔� + * * @return */ @Override - public List<TaskCache> selectInputTaskCache(){ - return baseMapper.selectList(new MPJLambdaWrapper<TaskCache>().selectAll(TaskCache.class).eq(TaskCache::getTaskStatus,0).eq(TaskCache::getTaskType,1)); + public List<TaskCache> selectInputTaskCache() { + return baseMapper.selectList(new MPJLambdaWrapper<TaskCache>().selectAll(TaskCache.class).eq(TaskCache::getTaskStatus, 0).eq(TaskCache::getTaskType, 1)); // return baseMapper.selectList(new QueryWrapper<TaskCache>().eq("task_status",0).eq("task_type",1)); } /** * 鏌ヨ寰呭嚭鐗囦换鍔� + * * @return */ @Override - public List<TaskCache> selectOutTaskCache(){ - return baseMapper.selectList(new MPJLambdaWrapper<TaskCache>().selectAll(TaskCache.class).eq(TaskCache::getTaskStatus,0).eq(TaskCache::getTaskType,2)); + public List<TaskCache> selectOutTaskCache() { + return baseMapper.selectList(new MPJLambdaWrapper<TaskCache>().selectAll(TaskCache.class).eq(TaskCache::getTaskStatus, 0).eq(TaskCache::getTaskType, 2)); // return baseMapper.selectList(new QueryWrapper<TaskCache>().eq("task_status",0).eq("task_type",2)); } /** * 鏌ヨ A09 鎴� A10 鏈�鏂扮殑涓�鐗� 鍑虹墖浠诲姟 + * * @param line * @return */ @Override - public List<TaskCache> selectLastOutCacheInfos(int line){ - return baseMapper.selectList(new MPJLambdaWrapper<TaskCache>().selectAll(TaskCache.class).eq(TaskCache::getEndCell,line).eq(TaskCache::getTaskStatus,1).orderByDesc(TaskCache::getCreateTime)); + public List<TaskCache> selectLastOutCacheInfos(int line) { + return baseMapper.selectList(new MPJLambdaWrapper<TaskCache>().selectAll(TaskCache.class).eq(TaskCache::getEndCell, line).eq(TaskCache::getTaskStatus, 1).orderByDesc(TaskCache::getCreateTime)); // return baseMapper.selectList(new QueryWrapper<TaskCache>().eq("end_cell",line).eq("task_status",1).orderByDesc("ID")); } /** * 鏌ヨ A09 鎴� A10 鏈�鏂扮殑涓�鐗� 鍑虹墖浠诲姟 + * * @param line * @return */ @Override - public TaskCache selectLastOutCacheInfo(int line){ - return baseMapper.selectOne(new MPJLambdaWrapper<TaskCache>().selectAll(TaskCache.class).eq(TaskCache::getEndCell,line).eq(TaskCache::getTaskStatus,1).orderByDesc(TaskCache::getCreateTime)); + public TaskCache selectLastOutCacheInfo(int line) { + return baseMapper.selectOne(new MPJLambdaWrapper<TaskCache>().selectAll(TaskCache.class).eq(TaskCache::getEndCell, line).eq(TaskCache::getTaskStatus, 1).orderByDesc(TaskCache::getCreateTime)); } + /** * 鏌ヨ鍒ゆ柇纾ㄨ竟绾挎槸鍚︽湁鐜荤拑杩愯 + * * @param * @return */ @Override public List<TaskCache> selectTaskCacheIsRun() { - List<TaskCache> taskCaches=null; - taskCaches=taskCacheMapper.selectJoinList(TaskCache.class, new MPJLambdaWrapper<TaskCache>() + List<TaskCache> taskCaches = null; + taskCaches = taskCacheMapper.selectJoinList(TaskCache.class, new MPJLambdaWrapper<TaskCache>() .select("top 4 t.end_cell,ISNULL(b.glass_id, 0)as glass_id") .leftJoin("big_storage_cage_feed_task as b on t.glass_id=b.glass_id ") .groupBy("t.end_cell,b.glass_id,t.create_time") -- Gitblit v1.8.0