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.entity.EdgStorageCage;
|
import com.mes.edgstoragecage.entity.EdgStorageCageDetails;
|
import com.mes.edgstoragecage.service.EdgStorageCageDetailsService;
|
import com.mes.edgstoragecage.service.EdgStorageCageService;
|
import com.mes.edgstoragecage.service.impl.EdgStorageCageServiceImpl;
|
import com.mes.glassinfo.entity.GlassInfo;
|
import com.mes.glassinfo.service.GlassInfoService;
|
import com.mes.pp.entity.OptimizeDetail;
|
import com.mes.pp.entity.OptimizeLayout;
|
import com.mes.pp.mapper.OptimizeDetailMapper;
|
import com.mes.taskcache.entity.TaskCache;
|
import com.mes.taskcache.mapper.TaskCacheMapper;
|
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
|
TaskCacheMapper taskCacheMapper;
|
@Autowired
|
OptimizeDetailMapper optimizeDetailMapper;
|
@Autowired
|
GlassInfoService glassInfoService;
|
|
@Test
|
public void testFindPath() {
|
String url=getClass().getResource("").getPath();
|
log.info("完整路径：{}", Arrays.asList(url));
|
}
|
|
@Test
|
public void testSqlServer() {
|
List<TaskCache> list=taskCacheMapper.selectList(null);
|
log.info("数据{}",list);
|
log.info("Sql数据：{}", Arrays.asList(list));
|
}
|
|
@Test
|
public void testglassinfo() {
|
List<GlassInfo> glassInfos=glassInfoService.selectId("7");
|
log.info("玻璃数据数据：{}", Arrays.asList(glassInfos));
|
}
|
|
@Test
|
public void testCacheGlass() {
|
List<Map<String, Object>> map= edgStorageCageService.selectEdgStorageCages();
|
log.info("笼内信息：{}", Arrays.asList(map));
|
}
|
@Test
|
public void testSelectCacheEmpty() {
|
List<EdgStorageCage> 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));
|
}
|
|
@Test
|
public void testOutTask() {
|
EdgStorageCageDetails edgStorageCageDetails=edgStorageCageDetailsService.selectConformGlass("1",3);
|
|
log.info("出片任务：{}", Arrays.asList(edgStorageCageDetails));
|
}
|
|
}
|
