From 559ab830a6341fec1b920a44bafd18342f16d712 Mon Sep 17 00:00:00 2001
From: ZengTao <2773468879@qq.com>
Date: 星期一, 14 四月 2025 21:09:04 +0800
Subject: [PATCH] 大屏:大理片笼数据展示

---
 hangzhoumesParent/moduleService/CacheVerticalGlassModule/src/main/java/com/mes/bigstoragecagetask/service/impl/BigStorageCageHistoryTaskServiceImpl.java |   36 ++++++++++++++++++++++++------------
 1 files changed, 24 insertions(+), 12 deletions(-)

diff --git a/hangzhoumesParent/moduleService/CacheVerticalGlassModule/src/main/java/com/mes/bigstoragecagetask/service/impl/BigStorageCageHistoryTaskServiceImpl.java b/hangzhoumesParent/moduleService/CacheVerticalGlassModule/src/main/java/com/mes/bigstoragecagetask/service/impl/BigStorageCageHistoryTaskServiceImpl.java
index 4cf2843..992eb0a 100644
--- a/hangzhoumesParent/moduleService/CacheVerticalGlassModule/src/main/java/com/mes/bigstoragecagetask/service/impl/BigStorageCageHistoryTaskServiceImpl.java
+++ b/hangzhoumesParent/moduleService/CacheVerticalGlassModule/src/main/java/com/mes/bigstoragecagetask/service/impl/BigStorageCageHistoryTaskServiceImpl.java
@@ -4,15 +4,17 @@
 import cn.hutool.core.collection.CollectionUtil;
 import cn.smallbun.screw.core.util.StringUtils;
 import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
 import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
 import com.mes.bigstoragecagetask.entity.BigStorageCageHistoryTask;
 import com.mes.bigstoragecagetask.entity.request.BigStorageCageHistoryRequest;
 import com.mes.bigstoragecagetask.mapper.BigStorageCageHistoryTaskMapper;
 import com.mes.bigstoragecagetask.service.BigStorageCageHistoryTaskService;
+import com.mes.largenscreen.entity.DailyProductionVO;
 import com.mes.tools.DateUtil;
 import org.springframework.stereotype.Service;
 
-import java.util.List;
+import java.text.SimpleDateFormat;
 
 /**
  * (BigStorageCageHistoryTask)琛ㄦ湇鍔″疄鐜扮被
@@ -24,23 +26,33 @@
 public class BigStorageCageHistoryTaskServiceImpl extends ServiceImpl<BigStorageCageHistoryTaskMapper, BigStorageCageHistoryTask> implements BigStorageCageHistoryTaskService {
 
     @Override
-    public List<BigStorageCageHistoryTask> queryBigStorageCageHistoryTask(BigStorageCageHistoryRequest request) {
-        if (null == request) {
-            request = new BigStorageCageHistoryRequest();
-        }
+    public Page<BigStorageCageHistoryTask> queryBigStorageCageHistoryTask(BigStorageCageHistoryRequest request) {
         if (null == request.getBeginDate()) {
             request.setBeginDate(DateUtil.getBeginDate());
             request.setEndDate(DateUtil.getEndDate());
         }
+        Page<BigStorageCageHistoryTask> page = new Page<>(request.getPageNo(), request.getPageSize());
         LambdaQueryWrapper<BigStorageCageHistoryTask> wrapper = new LambdaQueryWrapper<BigStorageCageHistoryTask>()
-                .like(StringUtils.isBlank(request.getGlassId()), BigStorageCageHistoryTask::getGlassId, request.getGlassId())
-                .eq(request.getStartSlot() !=0, BigStorageCageHistoryTask::getStartSlot, request.getStartSlot())
-                .eq(request.getTargetSlot() !=0, BigStorageCageHistoryTask::getTargetSlot, request.getTargetSlot())
-                .in(CollectionUtil.isNotEmpty(request.getTaskStateList()) , BigStorageCageHistoryTask::getTaskState, request.getTaskStateList())
-                .in(CollectionUtil.isNotEmpty(request.getTaskTypeList()) , BigStorageCageHistoryTask::getTaskType, request.getTaskTypeList())
+                .like(StringUtils.isNotBlank(request.getGlassId()), BigStorageCageHistoryTask::getGlassId, request.getGlassId())
+                .eq(request.getStartSlot() != 0, BigStorageCageHistoryTask::getStartSlot, request.getStartSlot())
+                .eq(request.getTargetSlot() != 0, BigStorageCageHistoryTask::getTargetSlot, request.getTargetSlot())
+                .in(CollectionUtil.isNotEmpty(request.getTaskStateList()), BigStorageCageHistoryTask::getTaskState, request.getTaskStateList())
+                .in(CollectionUtil.isNotEmpty(request.getTaskTypeList()), BigStorageCageHistoryTask::getTaskType, request.getTaskTypeList())
                 .between(BigStorageCageHistoryTask::getCreateTime, request.getBeginDate(), request.getEndDate())
-                .orderByDesc(BigStorageCageHistoryTask::getCreateTime);
-        return this.list(wrapper);
+                .orderByAsc(BigStorageCageHistoryTask::getId);
+        return this.page(page, wrapper);
+    }
+
+    @Override
+    public DailyProductionVO queryBigDailyProduction(BigStorageCageHistoryRequest request) {
+        SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
+        String beginDate = null;
+        String endDate = null;
+        if (com.baomidou.mybatisplus.core.toolkit.StringUtils.checkValNotNull(request.getBeginDate())) {
+            beginDate = sdf.format(request.getBeginDate());
+            endDate = sdf.format(request.getEndDate());
+        }
+        return baseMapper.queryBigDailyProduction(beginDate, endDate);
     }
 }
 

--
Gitblit v1.8.0