| | |
| | | List<JkCabinet> jkCabinetList = jkCabinetMapper.selectList(new QueryWrapper<JkCabinet>() |
| | | .lambda() |
| | | .eq(JkCabinet::getIsdeleted,Constants.ZERO) |
| | | .apply(" FIND_IN_SET("+loginUserInfo.getId()+",MANAGER_ID) ") |
| | | .apply(" FIND_IN_SET("+loginUserInfo.getMemberId()+",MANAGER_ID) ") |
| | | .orderByAsc(JkCabinet::getCreateDate) |
| | | ); |
| | | if(CollectionUtils.isNotEmpty(jkCabinetList)){ |
| | |
| | | JkCabinet cabinet = jkCabinetMapper.selectOne(new QueryWrapper<JkCabinet>() |
| | | .lambda() |
| | | .eq(JkCabinet::getIsdeleted,Constants.ZERO) |
| | | .apply(" FIND_IN_SET("+loginUserInfo.getId()+",MANAGER_ID) ") |
| | | .apply(" FIND_IN_SET("+loginUserInfo.getMemberId()+",MANAGER_ID) ") |
| | | .eq(JkCabinet::getId,cabinetId) |
| | | .last(" limit 1") |
| | | ); |
| | |
| | | cabinetDetailVO.setServiceKeyNum(Constants.ZERO); |
| | | cabinetDetailVO.setOutKeyNum(Constants.ZERO); |
| | | cabinetDetailVO.setUnBindGridNum(Constants.ZERO); |
| | | cabinetDetailVO.setMemberId(loginUserInfo.getMemberId()); |
| | | |
| | | //所有柜格信息 |
| | | List<JkCabinetGrid> jkCabinetGridList = |
| | | jkCabinetGridMapper.selectJoinList(JkCabinetGrid.class, new MPJLambdaWrapper<JkCabinetGrid>() |
| | | .selectAll(JkCabinetGrid.class) |
| | | .selectAs(JkKeys::getCarCode,JkCabinetGrid::getCarCode) |
| | | .selectAs(JkKeys::getCode,JkCabinetGrid::getKeyCode) |
| | | .selectAs(JkKeys::getStatus,JkCabinetGrid::getKeyStatus) |
| | | .leftJoin(JkKeys.class,JkKeys::getId,JkCabinetGrid::getKeyId) |
| | | .eq(JkCabinetGrid::getIsdeleted,Constants.ZERO) |
| | | .eq(JkCabinetGrid::getCabinetId,cabinet.getId()) |
| | | .orderByDesc(JkCabinetGrid::getCode) |
| | | .orderByAsc(JkCabinetGrid::getCode) |
| | | ); |
| | | |
| | | List<CabinetGridInfoVO> cabinetGridInfoVOList = new ArrayList<>(); |
| | |
| | | CabinetGridInfoVO cabinetGridInfoVO = new CabinetGridInfoVO(); |
| | | BeanUtil.copyProperties(jkCabinetGrid,cabinetGridInfoVO); |
| | | cabinetGridInfoVO.setBindStatus(Objects.isNull(jkCabinetGrid.getKeyId())?Constants.ZERO:Constants.ONE); |
| | | cabinetGridInfoVO.setKeyStatus(Objects.isNull(cabinetGridInfoVO.getKeyStatus())?Constants.ZERO:cabinetGridInfoVO.getKeyStatus()); |
| | | cabinetGridInfoVOList.add(cabinetGridInfoVO); |
| | | } |
| | | cabinetDetailVO.setCabinetGridInfoVOList(cabinetGridInfoVOList); |
| | | cabinetDetailVO.setErrGridNum( |
| | | cabinetGridInfoVOList.stream().filter(i->Constants.equalsInteger(i.getWorkingStatus(),Constants.ONE)).collect(Collectors.toList()).size() |
| | | ); |
| | |
| | | CabinetInfoVO cabinetInfoVO = new CabinetInfoVO(); |
| | | if(Objects.nonNull(jkCabinet)){ |
| | | BeanUtil.copyProperties(jkCabinet,cabinetInfoVO); |
| | | //所有柜格信息 |
| | | List<JkCabinetGrid> jkCabinetGridList = |
| | | jkCabinetGridMapper.selectJoinList(JkCabinetGrid.class, new MPJLambdaWrapper<JkCabinetGrid>() |
| | | .selectAll(JkCabinetGrid.class) |
| | | .selectAs(JkKeys::getCarCode,JkCabinetGrid::getCarCode) |
| | | .selectAs(JkKeys::getStatus,JkCabinetGrid::getKeyStatus) |
| | | .selectAs(JkKeys::getCode,JkCabinetGrid::getKeyCode) |
| | | .leftJoin(JkKeys.class,JkKeys::getId,JkCabinetGrid::getKeyId) |
| | | .eq(JkCabinetGrid::getIsdeleted,Constants.ZERO) |
| | | .eq(JkCabinetGrid::getCabinetId,jkCabinet.getId()) |
| | | .orderByAsc(JkCabinetGrid::getCode) |
| | | ); |
| | | |
| | | List<CabinetGridInfoVO> cabinetGridInfoVOList = new ArrayList<>(); |
| | | if(CollectionUtils.isNotEmpty(jkCabinetGridList)) { |
| | | for (JkCabinetGrid jkCabinetGrid : jkCabinetGridList) { |
| | | CabinetGridInfoVO cabinetGridInfoVO = new CabinetGridInfoVO(); |
| | | BeanUtil.copyProperties(jkCabinetGrid, cabinetGridInfoVO); |
| | | cabinetGridInfoVO.setBindStatus(Objects.isNull(jkCabinetGrid.getKeyId()) ? Constants.ZERO : Constants.ONE); |
| | | cabinetGridInfoVO.setKeyStatus(Objects.isNull(cabinetGridInfoVO.getKeyStatus())?Constants.ZERO:cabinetGridInfoVO.getKeyStatus()); |
| | | cabinetGridInfoVOList.add(cabinetGridInfoVO); |
| | | } |
| | | cabinetInfoVO.setCabinetGridInfoVOList(cabinetGridInfoVOList); |
| | | } |
| | | |
| | | CabinetConfigDataVO cabinetConfigDataVO = new CabinetConfigDataVO(); |
| | | cabinetConfigDataVO.setConcentration(systemDictDataBiz.queryByCode(Constants.CABINET_CONFIG,Constants.CONCENTRATION).getCode()); |
| | | cabinetConfigDataVO.setPressure(systemDictDataBiz.queryByCode(Constants.CABINET_CONFIG,Constants.PRESSURE).getCode()); |
| | | cabinetConfigDataVO.setBlowTime(systemDictDataBiz.queryByCode(Constants.CABINET_CONFIG,Constants.BLOW_TIME).getCode()); |
| | | cabinetConfigDataVO.setThreshold(systemDictDataBiz.queryByCode(Constants.CABINET_CONFIG,Constants.THRESHOLD).getCode()); |
| | | cabinetInfoVO.setCabinetConfigDataVO(cabinetConfigDataVO); |
| | | |
| | | } |
| | | cabinetInfoVO.setLinkPhone("18156091665"); |
| | | List<Category> categoryList = categoryMapper.selectList(new QueryWrapper<Category>().lambda() |
| | | .eq(Category::getIsdeleted,Constants.ZERO) |
| | | .eq(Category::getStatus,Constants.ZERO) |