hangzhoumesParent/moduleService/CacheGlassModule/src/main/java/com/mes/job/CacheGlassTask.java
@@ -21,6 +21,7 @@ import com.mes.glassinfo.service.GlassInfoService; import com.mes.taskcache.entity.TaskCache; import com.mes.taskcache.service.TaskCacheService; import com.mes.temperingglass.entity.TemperingGlassInfo; import com.mes.tools.WebSocketServer; import lombok.extern.slf4j.Slf4j; import org.apache.commons.lang.StringUtils; @@ -131,7 +132,23 @@ Date endDate = new Date(); log.info("本次任务结束时间:{},共耗时:{}ms", endDate, endDate.getTime() - startDate.getTime()); } @Scheduled(fixedDelay = 1000) public void temperingIsRun(){ JSONObject jsonObject = new JSONObject(); //正在进行的任务 List<TaskCache>taskCaches=taskCacheService.selectTaskCacheIsRun(); jsonObject.append("taskCaches", taskCaches); ArrayList<WebSocketServer> sendwServer = WebSocketServer.sessionMap.get("isRun"); if (sendwServer != null) { for (WebSocketServer webserver : sendwServer) { if (webserver != null) { webserver.sendMessage(jsonObject.toString()); } else { log.info("Home is closed"); } } } } /** * 进片任务 * hangzhoumesParent/moduleService/CacheGlassModule/src/main/java/com/mes/taskcache/mapper/TaskCacheMapper.java
@@ -2,6 +2,7 @@ import com.baomidou.dynamic.datasource.annotation.DS; import com.baomidou.mybatisplus.core.mapper.BaseMapper; import com.github.yulichang.base.MPJBaseMapper; import com.mes.taskcache.entity.TaskCache; import org.apache.ibatis.annotations.Param; @@ -16,7 +17,7 @@ * @since 2024-04-07 */ @DS("salve_hangzhoumes") public interface TaskCacheMapper extends BaseMapper<TaskCache> { public interface TaskCacheMapper extends MPJBaseMapper<TaskCache> { TaskCache queryGlassByTaskCache(@Param(value = "line") int line, @Param(value = "taskTypes") List<Integer> taskTypes); } hangzhoumesParent/moduleService/CacheGlassModule/src/main/java/com/mes/taskcache/service/TaskCacheService.java
@@ -1,6 +1,7 @@ package com.mes.taskcache.service; import com.baomidou.mybatisplus.extension.service.IService; import com.github.yulichang.base.MPJBaseService; import com.mes.taskcache.entity.TaskCache; import java.util.List; @@ -14,7 +15,7 @@ * @author zhoush * @since 2024-04-07 */ public interface TaskCacheService extends IService<TaskCache> { public interface TaskCacheService extends MPJBaseService<TaskCache> { boolean insertTaskCache(TaskCache taskCache); @@ -72,5 +73,11 @@ * @return */ TaskCache selectLastOutCacheInfo(int line); /** * 查询判断磨边线是否有玻璃运行 * @param * @return */ List<TaskCache> selectTaskCacheIsRun(); } hangzhoumesParent/moduleService/CacheGlassModule/src/main/java/com/mes/taskcache/service/impl/TaskCacheServiceImpl.java
@@ -2,6 +2,7 @@ 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.wrapper.MPJLambdaWrapper; import com.mes.common.config.Const; import com.mes.damage.entity.Damage; @@ -18,10 +19,7 @@ import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import java.util.ArrayList; import java.util.HashMap; import java.util.List; import java.util.Map; import java.util.*; /** * <p> @@ -33,13 +31,15 @@ */ @Slf4j @Service public class TaskCacheServiceImpl extends ServiceImpl<TaskCacheMapper, TaskCache> implements TaskCacheService { public class TaskCacheServiceImpl extends MPJBaseServiceImpl<TaskCacheMapper, TaskCache> implements TaskCacheService { @Autowired EdgStorageCageDetailsMapper edgStorageCageDetailsMapper; @Autowired GlassInfoMapper glassInfoMapper; @Autowired private TaskCacheMapper taskCacheMapper; /** @@ -169,7 +169,22 @@ 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>() .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") .orderByDesc("t.create_time") ); return taskCaches; } }