From e5e576ab6840b8030a60a1e67fb94728f7ec2ae2 Mon Sep 17 00:00:00 2001
From: 严智鑫 <test>
Date: 星期三, 24 四月 2024 16:27:03 +0800
Subject: [PATCH] Changes

---
 hangzhoumesParent/moduleService/CacheGlassModule/src/test/java/com/mes/CacheGlassModuleApplicationTest.java |   62 +++++++++++++++++++++++++++++++
 1 files changed, 62 insertions(+), 0 deletions(-)

diff --git a/hangzhoumesParent/moduleService/CacheGlassModule/src/test/java/com/mes/CacheGlassModuleApplicationTest.java b/hangzhoumesParent/moduleService/CacheGlassModule/src/test/java/com/mes/CacheGlassModuleApplicationTest.java
index 9593dcd..2b083c4 100644
--- a/hangzhoumesParent/moduleService/CacheGlassModule/src/test/java/com/mes/CacheGlassModuleApplicationTest.java
+++ b/hangzhoumesParent/moduleService/CacheGlassModule/src/test/java/com/mes/CacheGlassModuleApplicationTest.java
@@ -1,12 +1,25 @@
 package com.mes;
 
+import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
+import com.github.yulichang.query.MPJLambdaQueryWrapper;
+import com.github.yulichang.query.MPJQueryWrapper;
+import com.github.yulichang.toolkit.JoinWrappers;
+import com.mes.edgstoragecage.service.EdgStorageCageDetailsService;
+import com.mes.edgstoragecage.service.EdgStorageCageService;
+import com.mes.edgstoragecage.service.impl.EdgStorageCageServiceImpl;
+import com.mes.pp.entity.OptimizeDetail;
+import com.mes.pp.entity.OptimizeLayout;
+import com.mes.pp.mapper.OptimizeDetailMapper;
 import lombok.extern.slf4j.Slf4j;
 import org.junit.Test;
 import org.junit.runner.RunWith;
+import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.boot.test.context.SpringBootTest;
 import org.springframework.test.context.junit4.SpringRunner;
 
 import java.util.Arrays;
+import java.util.List;
+import java.util.Map;
 
 /**
  * @Author : zhoush
@@ -18,9 +31,58 @@
 @SpringBootTest(classes = CacheGlassModuleApplication.class)
 public class CacheGlassModuleApplicationTest {
 
+    @Autowired
+    EdgStorageCageService edgStorageCageService;
+    @Autowired
+    EdgStorageCageDetailsService edgStorageCageDetailsService;
+
+    @Autowired
+    OptimizeDetailMapper optimizeDetailMapper;
 
     @Test
     public void testFindPath() {
         log.info("瀹屾暣璺緞锛歿}", Arrays.asList("123"));
     }
+
+    @Test
+    public void testCacheGlass() {
+        List<Map<String, Object>> map= edgStorageCageService.selectEdgStorageCages();
+        log.info("绗煎唴淇℃伅锛歿}", Arrays.asList(map));
+    }
+    @Test
+    public void testSelectCacheEmpty() {
+        List<Map<String, Object>> map= edgStorageCageService.selectCacheEmpty();
+        log.info("绗煎唴绌烘牸锛歿}", Arrays.asList(map));
+    }
+    @Test
+    public void testScan() {
+        List<Map<String, Object>> map= edgStorageCageDetailsService.selectCutTerritory();
+        log.info("鍒囧壊褰撳墠鐗堝浘淇℃伅锛歿}", Arrays.asList(map));
+    }
+
+    @Test
+    public void testPpOptimizeDetail() {
+        List<OptimizeDetail> optimizeDetail=optimizeDetailMapper.selectList(new QueryWrapper<OptimizeDetail>()
+                .eq("project_no", "P24032204")
+                .eq("stock_id",5)
+        );
+        log.info("鍒囧壊褰撳墠鐗堝浘淇℃伅锛歿}", Arrays.asList(optimizeDetail));
+
+    }
+    @Test
+    public void testOptimizeDetail() {
+
+        List<Map<String, Object>> map2=optimizeDetailMapper.selectJoinMaps(JoinWrappers.lambda(OptimizeDetail.class)
+                .selectAll(OptimizeDetail.class)
+                .selectAs(OptimizeLayout::getWidth,"olWidth")
+                .selectAs(OptimizeLayout::getWidth,"olHeight")
+                .select(OptimizeLayout::getWidth,OptimizeLayout::getHeight)
+                .leftJoin(OptimizeLayout.class,on-> on.eq(OptimizeLayout::getProjectNo,OptimizeDetail::getProjectNo)
+                        .eq(OptimizeLayout::getStockId,OptimizeDetail::getStockId))
+                .eq(OptimizeDetail::getProjectNo,"P24032204" )
+                .eq(OptimizeDetail::getStockId,5)
+        );
+        log.info("鍒囧壊褰撳墠鐗堝浘淇℃伅1锛歿}", Arrays.asList(map2));
+    }
+
 }

--
Gitblit v1.8.0