From 9ccdf529fcc03b32ec1656c3b668b8bddd43ea5f Mon Sep 17 00:00:00 2001 From: wang <3597712270@qq.com> Date: 星期三, 24 四月 2024 18:54:38 +0800 Subject: [PATCH] Merge branch 'master' of http://10.153.19.25:10101/r/HangZhouMes --- 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