From f68d3c71819feb59e7a227a5d992b059b900916c Mon Sep 17 00:00:00 2001 From: ZengTao <2773468879@qq.com> Date: 星期五, 28 三月 2025 08:28:26 +0800 Subject: [PATCH] 修改报表,界面添加查询流程卡个数,调整推送数据到前端的间隔 --- hangzhoumesParent/moduleService/CacheGlassModule/src/main/java/com/mes/taskcache/service/impl/TaskCacheServiceImpl.java | 39 +++++++++++++++++++++++++++++++++++---- 1 files changed, 35 insertions(+), 4 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 df949ef..3be1f62 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 @@ -21,6 +21,7 @@ import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; +import javax.annotation.Resource; import java.util.*; /** @@ -35,12 +36,12 @@ @Service public class TaskCacheServiceImpl extends MPJBaseServiceImpl<TaskCacheMapper, TaskCache> implements TaskCacheService { - @Autowired + @Resource EdgStorageCageDetailsMapper edgStorageCageDetailsMapper; - @Autowired + @Resource GlassInfoMapper glassInfoMapper; - @Autowired + @Resource private TaskCacheMapper taskCacheMapper; @@ -181,6 +182,36 @@ } - + @Override + public List<TaskCache> selectTaskCache(TaskCache taskCache, String startTime, String endTime){ + if (endTime != null && !endTime.isEmpty()) { + endTime = endTime + " 23:59:59"; + } + LambdaQueryWrapper<TaskCache> wrapper = new LambdaQueryWrapper<>(); + if (taskCache.getStartCell() != null) { + wrapper.eq(TaskCache::getStartCell, taskCache.getStartCell()); + } + if (taskCache.getEndCell() != 0) { + wrapper.eq(TaskCache::getEndCell, taskCache.getEndCell()); + } + if (taskCache.getTaskStatus() != -1) { + wrapper.eq(TaskCache::getTaskStatus, taskCache.getTaskStatus()); + } + if (taskCache.getTaskType() != -1) { + wrapper.eq(TaskCache::getTaskType, taskCache.getTaskType()); + } + if (startTime != null && !startTime.isEmpty()) { + wrapper.ge(TaskCache::getCreateTime, startTime); + } + if (endTime != null && !endTime.isEmpty()) { + wrapper.le(TaskCache::getCreateTime, endTime); + } + wrapper.orderByDesc(TaskCache::getCreateTime); + wrapper.and(item -> item.eq(TaskCache::getDeleted, 0) + .or() + .eq(TaskCache::getDeleted, 1)); + wrapper.between(TaskCache::getCreateTime, startTime, endTime); + return baseMapper.selectList(wrapper); + } } -- Gitblit v1.8.0