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/CacheVerticalGlassModule/src/main/java/com/mes/bigstoragetask/service/impl/BigStorageCageOutTaskServiceImpl.java |  115 +++++++++++++++++++++++++++++++++++++++++++++++++++++++--
 1 files changed, 111 insertions(+), 4 deletions(-)

diff --git a/hangzhoumesParent/moduleService/CacheVerticalGlassModule/src/main/java/com/mes/bigstoragetask/service/impl/BigStorageCageOutTaskServiceImpl.java b/hangzhoumesParent/moduleService/CacheVerticalGlassModule/src/main/java/com/mes/bigstoragetask/service/impl/BigStorageCageOutTaskServiceImpl.java
index c874c83..fce5ab7 100644
--- a/hangzhoumesParent/moduleService/CacheVerticalGlassModule/src/main/java/com/mes/bigstoragetask/service/impl/BigStorageCageOutTaskServiceImpl.java
+++ b/hangzhoumesParent/moduleService/CacheVerticalGlassModule/src/main/java/com/mes/bigstoragetask/service/impl/BigStorageCageOutTaskServiceImpl.java
@@ -1,12 +1,19 @@
 package com.mes.bigstoragetask.service.impl;
 
 import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
+import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+import com.mes.bigstorage.entity.BigStorageCageDetails;
+import com.mes.bigstorage.mapper.BigStorageCageDetailsMapper;
+import com.mes.bigstoragetask.entity.BigStorageCageFeedTask;
 import com.mes.bigstoragetask.entity.BigStorageCageOutTask;
 import com.mes.bigstoragetask.mapper.BigStorageCageOutTaskMapper;
 import com.mes.bigstoragetask.service.BigStorageCageOutTaskService;
-import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+import com.mes.temperingglass.entity.TemperingGlassInfo;
+import com.mes.temperingglass.mapper.TemperingGlassInfoMapper;
+import lombok.extern.slf4j.Slf4j;
 import org.springframework.stereotype.Service;
 
+import javax.annotation.Resource;
 import java.util.List;
 
 /**
@@ -17,13 +24,113 @@
  * @author zhoush
  * @since 2024-04-16
  */
+@Slf4j
 @Service
 public class BigStorageCageOutTaskServiceImpl extends ServiceImpl<BigStorageCageOutTaskMapper, BigStorageCageOutTask> implements BigStorageCageOutTaskService {
 
+    @Resource
+    TemperingGlassInfoMapper temperingGlassInfoMapper;
+    @Resource
+    BigStorageCageOutTaskMapper bigStorageCageOutTaskMapper;
+    @Resource
+    BigStorageCageDetailsMapper bigStorageCageDetailsMapper;
+
     @Override
-    public List<BigStorageCageOutTask> querybigStorageCageOutTask(int taskState){
-        LambdaQueryWrapper<BigStorageCageOutTask> getOutTaskWrapper=new LambdaQueryWrapper<>();
-        getOutTaskWrapper.eq(BigStorageCageOutTask::getTaskState,taskState);
+    public boolean saveBatch(List<BigStorageCageOutTask> list) {
+        return baseMapper.saveBatch(list);
+    }
+
+    /**
+     * 鏌ヨ浠诲姟淇℃伅
+     */
+    @Override
+    public List<BigStorageCageOutTask> querybigStorageCageOutTask(int taskState) {
+        log.info("鏍规嵁浼犲叆鐨勪换鍔$姸鎬佹煡璇换鍔′俊鎭細" + taskState);
+        LambdaQueryWrapper<BigStorageCageOutTask> getOutTaskWrapper = new LambdaQueryWrapper<>();
+        getOutTaskWrapper.eq(BigStorageCageOutTask::getTaskState, taskState);
         return baseMapper.selectList(getOutTaskWrapper);
     }
+
+    /**
+     * 妫�娴婸LC鏄惁瀹屾垚浠诲姟
+     */
+    @Override
+    public void updateOutTask(){
+        List<BigStorageCageOutTask> bigStorageCageOutTaskList=querybigStorageCageOutTask(1);
+        log.info("鏌ヨ浠诲姟琛ㄦ槸鍚︽湁宸插畬鎴愮殑鍑虹墖浠诲姟"+bigStorageCageOutTaskList.size());
+        for (BigStorageCageOutTask bigStorageCageOutTask:bigStorageCageOutTaskList
+        ) {
+            deleteOutTask(bigStorageCageOutTask.getGlassId());
+        }
+    }
+
+    /**
+     * 瀹屾垚鍑虹墖浠诲姟
+     */
+    @Override
+    public void deleteOutTask(String glassId){
+        log.info("鏍规嵁浠诲姟id淇敼閽㈠寲灏忕墖琛ㄧ姸鎬侊紝鍒犻櫎宸插畬鎴愮殑鍑虹墖浠诲姟,鍒犻櫎绗煎瓙琛ㄧ幓鐠�");
+
+        LambdaQueryWrapper<TemperingGlassInfo> temperingGlassInfoWrapper =new LambdaQueryWrapper<>();
+        temperingGlassInfoWrapper.eq(TemperingGlassInfo::getGlassId,glassId);
+        TemperingGlassInfo temperingGlassInfo=temperingGlassInfoMapper.selectOne(temperingGlassInfoWrapper);
+        //鍒ゆ柇鏄惁鎵嬪姩浠诲姟锛屼笉閽㈠寲浠诲姟瀹屾垚鍚庡垹鎺夛紝閽㈠寲浠诲姟瀹屾垚鍚庢敼鐘舵�佷负0
+        if(temperingGlassInfo.getState()==-2){
+            temperingGlassInfoMapper.deleteById(temperingGlassInfo.getId());
+        }else{
+            temperingGlassInfo.setState(0);
+            temperingGlassInfoMapper.updateById(temperingGlassInfo);
+        }
+
+        LambdaQueryWrapper<BigStorageCageOutTask> bigStorageCageOutTaskWrapper =new LambdaQueryWrapper<>();
+        bigStorageCageOutTaskWrapper.eq(BigStorageCageOutTask::getGlassId,glassId);
+        BigStorageCageOutTask bigStorageCageOutTask=bigStorageCageOutTaskMapper.selectOne(bigStorageCageOutTaskWrapper);
+        bigStorageCageOutTaskMapper.deleteById(bigStorageCageOutTask.getId());
+
+        LambdaQueryWrapper<BigStorageCageDetails> bigStorageCageDetailsWrapper =new LambdaQueryWrapper<>();
+        bigStorageCageDetailsWrapper.eq(BigStorageCageDetails::getGlassId,glassId);
+        BigStorageCageDetails bigStorageCageDetails=bigStorageCageDetailsMapper.selectOne(bigStorageCageDetailsWrapper);
+        bigStorageCageDetailsMapper.deleteById(bigStorageCageOutTask.getId());
+
+    }
+
+    @Override
+    public void deleteTask(List<BigStorageCageOutTask> outGlassId){
+        baseMapper.deleteTask(outGlassId);
+    }
+
+    @Override
+    public List<BigStorageCageOutTask> selectBigStorageCageOutTask(BigStorageCageOutTask bigStorageCageOutTask, String startTime, String endTime){
+        if (endTime != null && !endTime.isEmpty()) {
+            endTime = endTime + " 23:59:59";
+        }
+        LambdaQueryWrapper<BigStorageCageOutTask> wrapper = new LambdaQueryWrapper<>();
+        if (bigStorageCageOutTask.getStartSlot() != null) {
+            wrapper.eq(BigStorageCageOutTask::getStartSlot, bigStorageCageOutTask.getStartSlot());
+        }
+        if (bigStorageCageOutTask.getWidth() != null) {
+            wrapper.eq(BigStorageCageOutTask::getWidth, bigStorageCageOutTask.getWidth());
+        }
+        if (bigStorageCageOutTask.getHeight() != null) {
+            wrapper.eq(BigStorageCageOutTask::getHeight, bigStorageCageOutTask.getHeight());
+        }
+        if (bigStorageCageOutTask.getEndSlot() != 0) {
+            wrapper.eq(BigStorageCageOutTask::getEndSlot, bigStorageCageOutTask.getEndSlot());
+        }
+        if (bigStorageCageOutTask.getTaskState() != -1) {
+            wrapper.eq(BigStorageCageOutTask::getTaskState, bigStorageCageOutTask.getTaskState());
+        }
+        if (startTime != null && !startTime.isEmpty()) {
+            wrapper.ge(BigStorageCageOutTask::getCreateTime, startTime);
+        }
+        if (endTime != null && !endTime.isEmpty()) {
+            wrapper.le(BigStorageCageOutTask::getCreateTime, endTime);
+        }
+        wrapper.orderByDesc(BigStorageCageOutTask::getId);
+        wrapper.and(item -> item.eq(BigStorageCageOutTask::getDeleted, 0)
+                .or()
+                .eq(BigStorageCageOutTask::getDeleted, 1));
+        wrapper.between(BigStorageCageOutTask::getCreateTime, startTime, endTime);
+        return baseMapper.selectList(wrapper);
+    }
 }

--
Gitblit v1.8.0