From 4c1bcfba73c00f44adc5b5b7f1275e24d5e6a901 Mon Sep 17 00:00:00 2001
From: wu <731351411@qq.com>
Date: 星期一, 02 九月 2024 14:06:28 +0800
Subject: [PATCH] Merge branch 'master' of http://10.153.19.25:10101/r/HangZhouMes

---
 hangzhoumesParent/moduleService/CacheVerticalGlassModule/src/main/java/com/mes/job/PlcSlicecage.java |    9 ++++++++-
 1 files changed, 8 insertions(+), 1 deletions(-)

diff --git a/hangzhoumesParent/moduleService/CacheVerticalGlassModule/src/main/java/com/mes/job/PlcSlicecage.java b/hangzhoumesParent/moduleService/CacheVerticalGlassModule/src/main/java/com/mes/job/PlcSlicecage.java
index 8f7ba74..10dbb2d 100644
--- a/hangzhoumesParent/moduleService/CacheVerticalGlassModule/src/main/java/com/mes/job/PlcSlicecage.java
+++ b/hangzhoumesParent/moduleService/CacheVerticalGlassModule/src/main/java/com/mes/job/PlcSlicecage.java
@@ -1,10 +1,13 @@
 package com.mes.job;
 
 import cn.hutool.json.JSONObject;
+import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
+import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
 import com.mes.bigstorage.entity.BigStorageCageDetails;
 import com.mes.bigstorage.service.BigStorageCageDetailsService;
 import com.mes.bigstorage.service.BigStorageCageService;
 import com.mes.common.S7object;
+import com.mes.common.config.Const;
 import com.mes.common.utils.RedisUtil;
 import com.mes.device.PlcParameterObject;
 import com.mes.temperingglass.entity.TemperingGlassInfo;
@@ -68,11 +71,15 @@
         }
         jsonObject.append("temperingSwitch", temperingSwitch);
 
+
     }
 
     public void queryDataSource2() throws InterruptedException {
         //鍑虹墖闃熷垪
-        List<TemperingGlassInfo> temperingGlassInfoList= temperingGlassInfoService.list();
+        List<TemperingGlassInfo> temperingGlassInfoList= temperingGlassInfoService.list(
+                new LambdaQueryWrapper<TemperingGlassInfo>()
+                .inSql(TemperingGlassInfo::getEngineerId,"select distinct engineer_id from tempering_glass_info where state<4")
+        );
         jsonObject.append("temperingGlassInfoList", temperingGlassInfoList);
 
     }

--
Gitblit v1.8.0