| | |
|---|
| | | |
|---|
| | | //查询大理片信息，前端展示用 |
|---|
| | | @Override |
|---|
| | | public List<BigStorageCage> querybigStorageCageDetail(int deviceId) { |
|---|
| | | LambdaQueryWrapper<BigStorageCage> bigStorageCageWrapper = new LambdaQueryWrapper<>(); |
|---|
| | | LambdaQueryWrapper<BigStorageCageDetails> bigStorageCageDetailsWrapper = new LambdaQueryWrapper<>(); |
|---|
| | | bigStorageCageDetailsWrapper |
|---|
| | | .eq(BigStorageCageDetails::getState, Const.GLASS_STATE_IN) |
|---|
| | | .or() |
|---|
| | | .eq(BigStorageCageDetails::getState, Const.GLASS_STATE_ARTIFICIAL); |
|---|
| | | if (deviceId != 0) { |
|---|
| | | bigStorageCageWrapper.eq(BigStorageCage::getDeviceId, deviceId); |
|---|
| | | bigStorageCageDetailsWrapper.eq(BigStorageCageDetails::getDeviceId, deviceId); |
|---|
| | | } |
|---|
| | | |
|---|
| | | List<BigStorageCage> bigStorageCages = bigStorageCageMapper.selectList(bigStorageCageWrapper); |
|---|
| | | log.info("1、获取大理片笼信息完成，获取到的数据{}", bigStorageCages.size()); |
|---|
| | | |
|---|
| | | List<BigStorageCageDetails> bigStorageCageDetailsList = bigStorageCageDetailsMapper.selectList(bigStorageCageDetailsWrapper); |
|---|
| | | |
|---|
| | | Map<Integer, List<BigStorageCageDetails>> listMap = bigStorageCageDetailsList.stream().collect(Collectors.groupingBy(BigStorageCageDetails::getSlot)); |
|---|
| | | for (BigStorageCage bigStorageCage : bigStorageCages) { |
|---|
| | | List<BigStorageCageDetails> bigStorageCageDetails = listMap.get(bigStorageCage.getSlot()); |
|---|
| | | bigStorageCage.setBigStorageCageDetails(bigStorageCageDetails); |
|---|
| | | } |
|---|
| | | return bigStorageCages; |
|---|
| | | public List<BigStorageCage> querybigStorageCageDetailAll() { |
|---|
| | | MPJLambdaWrapper<BigStorageCage> wrapper = new MPJLambdaWrapper<>(); |
|---|
| | | wrapper.selectAll(BigStorageCage.class).selectCollection(BigStorageCageDetails.class, BigStorageCage::getBigStorageCageDetails) |
|---|
| | | .leftJoin(BigStorageCageDetails.class, on -> on.eq(BigStorageCageDetails::getSlot, BigStorageCage::getSlot) |
|---|
| | | .in(BigStorageCageDetails::getState, Const.GLASS_STATE_IN, Const.GLASS_STATE_ARTIFICIAL)); |
|---|
| | | return bigStorageCageMapper.selectJoinList(BigStorageCage.class, wrapper); |
|---|
| | | } |
|---|
| | | |
|---|
| | | //查询大理片信息，前端展示用 |
|---|
