| | |
|---|
| | | .eq(BigStorageCageDetails::getLayer, glassInfo.getLayer()); |
|---|
| | | // wrapper.eq(BigStorageCageDetails::getWidth, glassInfo.getWidth()).eq(BigStorageCageDetails::getHeight, glassInfo.getHeight()); |
|---|
| | | } else { |
|---|
| | | wrapper.eq(BigStorageCageDetails::getTemperingFeedSequence, glassInfo.getTemperingFeedSequence() + 1); |
|---|
| | | wrapper.eq(BigStorageCageDetails::getTemperingFeedSequence, glassInfo.getTemperingFeedSequence() - 1); |
|---|
| | | } |
|---|
| | | BigStorageCage bigStorageCage = bigStorageCageService.selectJoinOne(BigStorageCage.class, wrapper); |
|---|
| | | if (null != bigStorageCage) { |
|---|
| | |
|---|
| | | |
|---|
| | | //获取玻璃的厚度：重新选笼子需要按照笼子可放玻璃厚度进行选择 因为子查询排序对主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) |
|---|
