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 | 38 ++++++++++++++++++++++++++++++++++++++ 1 files changed, 38 insertions(+), 0 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 b050fe9..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 @@ -1,11 +1,20 @@ package com.mes.bigstoragecagetask.service.impl; +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.text.SimpleDateFormat; /** * (BigStorageCageHistoryTask)琛ㄦ湇鍔″疄鐜扮被 @@ -16,5 +25,34 @@ @Service public class BigStorageCageHistoryTaskServiceImpl extends ServiceImpl<BigStorageCageHistoryTaskMapper, BigStorageCageHistoryTask> implements BigStorageCageHistoryTaskService { + @Override + 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.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()) + .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