| | |
|---|
| | | import cn.hutool.core.lang.Assert; |
|---|
| | | import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; |
|---|
| | | import com.baomidou.mybatisplus.core.conditions.update.LambdaUpdateWrapper; |
|---|
| | | import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper; |
|---|
| | | import com.baomidou.mybatisplus.core.toolkit.CollectionUtils; |
|---|
| | | import com.github.yulichang.toolkit.JoinWrappers; |
|---|
| | | import com.github.yulichang.wrapper.MPJLambdaWrapper; |
|---|
| | |
|---|
| | | */ |
|---|
| | | public Boolean judgeGlassTypeStatus(String glassId, Integer line, String mesAddress) { |
|---|
| | | //1、获取任务表中相邻玻璃 |
|---|
| | | List<EdgGlassTaskInfo> edgGlassTaskInfoList = edgGlassTaskInfoService.list(new LambdaQueryWrapper<EdgGlassTaskInfo>() |
|---|
| | | List<EdgGlassTaskInfo> edgGlassTaskInfoList ; |
|---|
| | | edgGlassTaskInfoList= edgGlassTaskInfoService.list(new LambdaQueryWrapper<EdgGlassTaskInfo>() |
|---|
| | | .eq(EdgGlassTaskInfo::getLine, line) |
|---|
| | | .apply("time >= (select time from edg_glass_task_info where line='" + line + "' and glass_id = '" + glassId + "' and deleted = 0)") |
|---|
| | | .orderByAsc(EdgGlassTaskInfo::getTime)); |
|---|
| | | if(edgGlassTaskInfoList==null){ |
|---|
| | | log.info("线路：{}识别玻璃信息未出现在尺寸表中,获取相邻两块玻璃失败",line); |
|---|
| | | }else{ |
|---|
| | | edgGlassTaskInfoList= edgGlassTaskInfoService.list(new LambdaQueryWrapper<EdgGlassTaskInfo>() |
|---|
| | | .eq(EdgGlassTaskInfo::getGlassId, glassId) |
|---|
| | | .last("limit 1")); |
|---|
| | | log.info("在尺寸表中获取玻璃信息{}",edgGlassTaskInfoList); |
|---|
| | | } |
|---|
| | | Assert.isFalse(CollectionUtils.isEmpty(edgGlassTaskInfoList), "识别玻璃信息未出现在尺寸表中,获取相邻两块玻璃失败"); |
|---|
| | | //2、获取卧转立剩余宽度 |
|---|
| | | BigStorageDTO sitToUpRemainWidth = bigStorageCageFeedTaskService.querySitToUpRemainWidth(line); |
|---|
