|  |  |  | 
|---|
|  |  |  | 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() | 
|---|
|  |  |  | ); | 
|---|
|  |  |  | 
|---|
|  |  |  | //查询车辆所有人员信息 | 
|---|
|  |  |  | List<Member> memberList = memberMapper.selectJoinList(Member.class,new MPJLambdaWrapper<Member>() | 
|---|
|  |  |  | .selectAll(Member.class) | 
|---|
|  |  |  | .leftJoin(CarDriver.class,CarDriver::getMemberId,Member::getId) | 
|---|
|  |  |  | .leftJoin(Cars.class,Cars::getMemberId,Member::getId) | 
|---|
|  |  |  | .leftJoin(JkKeys.class,JkKeys::getCarId,Cars::getId) | 
|---|
|  |  |  | .eq(Member::getIsdeleted,Constants.ZERO) | 
|---|
|  |  |  | .eq(CarDriver::getIsdeleted,Constants.ZERO) | 
|---|
|  |  |  | .eq(CarDriver::getStatus,Constants.ZERO) | 
|---|
|  |  |  | .isNotNull(Member::getFaceImg) | 
|---|
|  |  |  | .in(CarDriver::getCarId,carIdList) | 
|---|
|  |  |  | .in(JkKeys::getId,carIdList) | 
|---|
|  |  |  | ); | 
|---|
|  |  |  | if(CollectionUtils.isNotEmpty(memberList)){ | 
|---|
|  |  |  | Set<Member> memberSet = new HashSet<>(memberList); | 
|---|
|  |  |  | 
|---|
|  |  |  | 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(systemDictDataBiz.queryByCode(Constants.CABINET_CONFIG,Constants.LINK_PHONE).getCode()); | 
|---|
|  |  |  | List<Category> categoryList = categoryMapper.selectList(new QueryWrapper<Category>().lambda() | 
|---|
|  |  |  | .eq(Category::getIsdeleted,Constants.ZERO) | 
|---|
|  |  |  | .eq(Category::getStatus,Constants.ZERO) | 
|---|