From be032257d1562085b507496140dd3551570962e0 Mon Sep 17 00:00:00 2001
From: zhoushihao <zsh19950802@163.com>
Date: 星期二, 23 七月 2024 20:31:15 +0800
Subject: [PATCH] 0723联调解决bug

---
 hangzhoumesParent/moduleService/CacheVerticalGlassModule/src/main/java/com/mes/bigstorage/service/impl/BigStorageCageDetailsServiceImpl.java |   44 ++++++++++++++++++++++----------------------
 1 files changed, 22 insertions(+), 22 deletions(-)

diff --git a/hangzhoumesParent/moduleService/CacheVerticalGlassModule/src/main/java/com/mes/bigstorage/service/impl/BigStorageCageDetailsServiceImpl.java b/hangzhoumesParent/moduleService/CacheVerticalGlassModule/src/main/java/com/mes/bigstorage/service/impl/BigStorageCageDetailsServiceImpl.java
index e592ab2..9d84131 100644
--- a/hangzhoumesParent/moduleService/CacheVerticalGlassModule/src/main/java/com/mes/bigstorage/service/impl/BigStorageCageDetailsServiceImpl.java
+++ b/hangzhoumesParent/moduleService/CacheVerticalGlassModule/src/main/java/com/mes/bigstorage/service/impl/BigStorageCageDetailsServiceImpl.java
@@ -232,7 +232,7 @@
             List<BigStorageCageDetails> bigStorageCageDetailsList = new ArrayList<>();
             bigStorageCageDetailsList.add(bigStorageCageDetails);
             return bigStorageCageDetailsList;
-        }else{
+        } else {
             return null;
         }
 
@@ -308,8 +308,8 @@
                 .eq(BigStorageCage::getRemainWidth, slotWidth)
                 .eq(BigStorageCage::getEnableState, Const.SLOT_ON)
                 .notInSql(BigStorageCage::getDeviceId,
-                        "select distinct device_id from big_storage_cage_details where tempering_layout_id = " + glassInfo.getTemperingLayoutId())
-                .gt(BigStorageCage::getMaxThickness, glassInfo.getThickness())
+                        "select distinct device_id from big_storage_cage_details where state in (100,102,103)")
+                .ge(BigStorageCage::getMaxThickness, glassInfo.getThickness())
                 .orderByAsc(BigStorageCage::getDeviceId)
                 .last("limit 1"));
         if (null != bigStorageCage) {
@@ -322,7 +322,7 @@
         bigStorageCage = bigStorageCageService.getOne(new LambdaQueryWrapper<BigStorageCage>()
                 .eq(BigStorageCage::getRemainWidth, slotWidth)
                 .eq(BigStorageCage::getEnableState, Const.SLOT_ON)
-                .gt(BigStorageCage::getMaxThickness, glassInfo.getThickness())
+                .ge(BigStorageCage::getMaxThickness, glassInfo.getThickness())
                 .orderByAsc(BigStorageCage::getDeviceId)
                 .last("limit 1"));
         Assert.isTrue(null != bigStorageCage, "娌℃湁绌轰綑鐨勭瀛愬瓨鏀剧幓鐠�");
@@ -350,25 +350,25 @@
     }
 
     @Override
-    public boolean TemperingGlass(String temperingLayoutId, String engineerId){
-        LambdaQueryWrapper<TemperingGlassInfo> temperingGlassInfoLambdaQueryWrapper=new LambdaQueryWrapper<>();
+    public boolean TemperingGlass(String temperingLayoutId, String engineerId) {
+        LambdaQueryWrapper<TemperingGlassInfo> temperingGlassInfoLambdaQueryWrapper = new LambdaQueryWrapper<>();
         temperingGlassInfoLambdaQueryWrapper
-                .eq(TemperingGlassInfo::getTemperingLayoutId,temperingLayoutId)
-                .eq(TemperingGlassInfo::getEngineerId,engineerId);
-        List<TemperingGlassInfo> temperingGlassInfoList=temperingGlassInfoMapper.selectList(temperingGlassInfoLambdaQueryWrapper);
-        if(temperingGlassInfoList.size()==0){
-            LambdaQueryWrapper<BigStorageCageDetails> wrapper =new LambdaQueryWrapper<>();
-            wrapper.eq(BigStorageCageDetails::getTemperingLayoutId,temperingLayoutId)
-                    .eq(BigStorageCageDetails::getEngineerId,engineerId)
-                    .in(BigStorageCageDetails::getState,Const.GLASS_STATE_IN,Const.GLASS_STATE_ARTIFICIAL);
-            List<BigStorageCageDetails> bigStorageCageDetailsList=baseMapper.selectList(wrapper);
+                .eq(TemperingGlassInfo::getTemperingLayoutId, temperingLayoutId)
+                .eq(TemperingGlassInfo::getEngineerId, engineerId);
+        List<TemperingGlassInfo> temperingGlassInfoList = temperingGlassInfoMapper.selectList(temperingGlassInfoLambdaQueryWrapper);
+        if (temperingGlassInfoList.size() == 0) {
+            LambdaQueryWrapper<BigStorageCageDetails> wrapper = new LambdaQueryWrapper<>();
+            wrapper.eq(BigStorageCageDetails::getTemperingLayoutId, temperingLayoutId)
+                    .eq(BigStorageCageDetails::getEngineerId, engineerId)
+                    .in(BigStorageCageDetails::getState, Const.GLASS_STATE_IN, Const.GLASS_STATE_ARTIFICIAL);
+            List<BigStorageCageDetails> bigStorageCageDetailsList = baseMapper.selectList(wrapper);
 
-            for (BigStorageCageDetails bigStorageCageDetails:bigStorageCageDetailsList
+            for (BigStorageCageDetails bigStorageCageDetails : bigStorageCageDetailsList
             ) {
-                TemperingGlassInfo temperingGlassInfo=new TemperingGlassInfo();
-                LambdaQueryWrapper<GlassInfo> glassInfoLambdaQueryWrapper=new LambdaQueryWrapper<>();
-                glassInfoLambdaQueryWrapper.eq(GlassInfo::getGlassId,bigStorageCageDetails.getGlassId());
-                GlassInfo glassInfo=glassInfoMapper.selectOne(glassInfoLambdaQueryWrapper);
+                TemperingGlassInfo temperingGlassInfo = new TemperingGlassInfo();
+                LambdaQueryWrapper<GlassInfo> glassInfoLambdaQueryWrapper = new LambdaQueryWrapper<>();
+                glassInfoLambdaQueryWrapper.eq(GlassInfo::getGlassId, bigStorageCageDetails.getGlassId());
+                GlassInfo glassInfo = glassInfoMapper.selectOne(glassInfoLambdaQueryWrapper);
 
                 BeanUtils.copyProperties(glassInfo, temperingGlassInfo);
                 temperingGlassInfo.setAngle((int) glassInfo.getAngle());
@@ -377,7 +377,7 @@
                 temperingGlassInfoMapper.insert(temperingGlassInfo);
             }
             return true;
-        }else{
+        } else {
             return false;
         }
 
@@ -385,7 +385,7 @@
     }
 
     @Override
-    public List<Map<String, Object>> selectTemperingGlass(){
+    public List<Map<String, Object>> selectTemperingGlass() {
         QueryWrapper<BigStorageCageDetails> wrapper = new QueryWrapper<>();
         wrapper.select("engineer_id,tempering_layout_id,count(*) as count")
                 .groupBy("engineer_id,tempering_layout_id");

--
Gitblit v1.8.0