| | |
|---|
| | | public BigStorageDTO queryTargetSlotByTempering(GlassInfo glassInfo) { |
|---|
| | | BigStorageDTO bigStorageDTO = null; |
|---|
| | | MPJLambdaWrapper<BigStorageCage> wrapper = new MPJLambdaWrapper<>(BigStorageCage.class) |
|---|
| | | .selectAsClass(BigStorageCage.class, BigStorageDTO.class) |
|---|
| | | .selectAll(BigStorageCage.class) |
|---|
| | | .leftJoin(BigStorageCageDetails.class, BigStorageCageDetails::getSlot, BigStorageCage::getSlot) |
|---|
| | | .eq(BigStorageCageDetails::getTemperingLayoutId, glassInfo.getTemperingLayoutId()) |
|---|
| | | .gt(BigStorageCage::getRemainWidth, glassInfo.getWidth()) |
|---|
| | | .last("limit 1"); |
|---|
| | | if (glassInfo.getTemperingLayoutId() == 0) { |
|---|
| | | wrapper.eq(BigStorageCageDetails::getWidth, glassInfo.getWidth()).eq(BigStorageCageDetails::getHeight, glassInfo.getHeight()); |
|---|
| | | } else { |
|---|
| | | wrapper.eq(BigStorageCageDetails::getTemperingFeedSequence, glassInfo.getTemperingFeedSequence() + 1); |
|---|
| | | } |
|---|
| | | bigStorageDTO = bigStorageCageService.selectJoinOne(BigStorageDTO.class, wrapper); |
|---|
| | | if (null != bigStorageDTO) { |
|---|
| | | BigStorageCage bigStorageCage = bigStorageCageService.selectJoinOne(BigStorageCage.class, wrapper); |
|---|
| | | if (null != bigStorageCage) { |
|---|
| | | bigStorageDTO = new BigStorageDTO(); |
|---|
| | | bigStorageDTO.setWidth(bigStorageCage.getRemainWidth()); |
|---|
| | | bigStorageDTO.setSlot(bigStorageCage.getSlot()); |
|---|
| | | return bigStorageDTO; |
|---|
| | | } |
|---|
| | | BigStorageCage bigStorageCage = bigStorageCageService.getOne(new LambdaQueryWrapper<BigStorageCage>() |
|---|
| | | bigStorageCage = bigStorageCageService.getOne(new LambdaQueryWrapper<BigStorageCage>() |
|---|
| | | .eq(BigStorageCage::getRemainWidth, Const.BIG_STORAGE_WIDTH) |
|---|
| | | .inSql(BigStorageCage::getDeviceId, |
|---|
| | | "select distinct device_id from big_storage_cage_details where tempering_layout_id = " + glassInfo.getTemperingLayoutId()) |
|---|
| | |
|---|
| | | bigStorageDTO.setWidth(bigStorageCage.getRemainWidth()); |
|---|
| | | bigStorageDTO.setSlot(bigStorageCage.getSlot()); |
|---|
| | | return bigStorageDTO; |
|---|
| | | |
|---|
| | | |
|---|
| | | } |
|---|
| | | |
|---|
| | | @Override |
|---|
