| | |
|---|
| | | |
|---|
| | | //获取玻璃的厚度：重新选笼子需要按照笼子可放玻璃厚度进行选择 因为子查询排序对主sql无影响，所以先执行子查询获取顺序，然后一次去查询 |
|---|
| | | List<Integer> deviceUsedList = bigStorageCageService.queryFreeDeviceByUsed(glassInfo.getThickness()); |
|---|
| | | List<Integer> deviceUseds = bigStorageCageService.queryFreeDeviceByUsed(glassInfo.getThickness()); |
|---|
| | | List<Integer> deviceUseds = bigStorageCageService.queryFreeDeviceByUsed(glassInfo.getThickness()); |
|---|
| | | List<BigStorageCageDetails> engineerCount1 = baseMapper.selectList( |
|---|
| | | new LambdaQueryWrapper<BigStorageCageDetails>() |
|---|
| | | .notIn(BigStorageCageDetails::getState, Const.GLASS_STATE_OUT,Const.GLASS_STATE_DAMAGE,Const.GLASS_STATE_TAKE) |
|---|
| | | .notIn(BigStorageCageDetails::getState, Const.GLASS_STATE_OUT, Const.GLASS_STATE_DAMAGE, Const.GLASS_STATE_TAKE) |
|---|
| | | .select(BigStorageCageDetails::getEngineerId) |
|---|
| | | .groupBy(BigStorageCageDetails::getEngineerId) |
|---|
| | | .between(BigStorageCageDetails::getDeviceId, 1, 5) |
|---|
| | | ); |
|---|
| | | List<BigStorageCageDetails> engineerCount2 = baseMapper.selectList( |
|---|
| | | new LambdaQueryWrapper<BigStorageCageDetails>() |
|---|
| | | .notIn(BigStorageCageDetails::getState, Const.GLASS_STATE_OUT,Const.GLASS_STATE_DAMAGE,Const.GLASS_STATE_TAKE) |
|---|
| | | .notIn(BigStorageCageDetails::getState, Const.GLASS_STATE_OUT, Const.GLASS_STATE_DAMAGE, Const.GLASS_STATE_TAKE) |
|---|
| | | .select(BigStorageCageDetails::getEngineerId) |
|---|
| | | .groupBy(BigStorageCageDetails::getEngineerId) |
|---|
| | | .between(BigStorageCageDetails::getDeviceId, 6, 8) |
|---|
| | | ); |
|---|
| | | if (engineerCount1.size() > engineerCount2.size()) { |
|---|
| | | if (glassInfo.getThickness() == 8) { |
|---|
| | | deviceUsedList.removeIf(device -> device < 6); |
|---|
| | | } else { |
|---|
| | | deviceUsedList.removeIf(device -> device > 5); |
|---|
| | | if (engineerCount1.size() > engineerCount2.size()) { |
|---|
| | | deviceUsedList.removeIf(device -> device < 6); |
|---|
| | | } else { |
|---|
| | | deviceUsedList.removeIf(device -> device > 5); |
|---|
| | | } |
|---|
| | | } |
|---|
| | | if (CollectionUtils.isEmpty(deviceUsedList)) { |
|---|
| | | deviceUsedList = deviceUseds; |
|---|
