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
|
* @Date: 2024/3/27 16:37
|
* @Description:
|
*/
|
@Slf4j
|
@RunWith(SpringRunner.class)
|
@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));
|
}
|
|
}
|
