| | |
| | | .like(StringUtils.isNotBlank(query.getFilmsId()), HollowBigStorageCageDetails::getFilmsId, query.getFilmsId()) |
| | | .like(StringUtils.isNotBlank(query.getFlowCardId()), HollowBigStorageCageDetails::getFlowCardId, query.getFlowCardId()) |
| | | .in(HollowBigStorageCageDetails::getState, Const.GLASS_STATE_IN, Const.GLASS_STATE_ARTIFICIAL, Const.GLASS_STATE_OUT_ING)) |
| | | .eq(HollowBigStorageCage::getDeviceId, query.getDeviceId()) |
| | | // .eq(HollowBigStorageCage::getDeviceId, query.getDeviceId()) |
| | | .orderByAsc(HollowBigStorageCage::getDeviceId) |
| | | .orderByAsc(HollowBigStorageCage::getSlot); |
| | | return baseMapper.selectJoinList(HollowBigStorageAndDetailsDTO.class, wrapper); |
| | |
| | | // 2将空格子的尺寸置为初始尺寸 |
| | | this.update(new LambdaUpdateWrapper<HollowBigStorageCage>() |
| | | .set(HollowBigStorageCage::getRemainWidth, slotWidth) |
| | | .notIn(HollowBigStorageCage::getSlot, "select distinct slot from hollow_big_storage_cage_details where state in( 100 , 102 , 103 ,104)")); |
| | | .notInSql(HollowBigStorageCage::getSlot, "select distinct slot from hollow_big_storage_cage_details where state in( 100 , 102 , 103 ,104)")); |
| | | // 3、将不在笼内的流程卡的关系表重置 |
| | | // 仅获取理片笼内的流程卡信息避免玻璃 |
| | | List<FlowCardVirtualSlotDTO> list = hollowBigStorageCageDetailsService.queryFlowCardIdsAndLayer(); |