| | |
| | | .eq(JkCabinetLog::getIsdeleted, Constants.ZERO) |
| | | .eq(JkCabinetLog::getType,Constants.ONE) |
| | | .eq(JkCabinetLog::getKeyStatus,Constants.TWO) |
| | | .like(StringUtils.isNotBlank(dto.getCarCode()),JkCabinetLog::getCarCode,dto.getCarCode()) |
| | | .like(StringUtils.isNotBlank(dto.getCarCode()),JkKeys::getCarCode,dto.getCarCode()) |
| | | .isNotNull(Objects.nonNull(dto.getStatus())&&Constants.equalsInteger(dto.getStatus(),Constants.ONE),JkCabinetLog::getCloseLogId) |
| | | .isNull(Objects.nonNull(dto.getStatus())&&Constants.equalsInteger(dto.getStatus(),Constants.ZERO),JkCabinetLog::getCloseLogId) |
| | | .orderByDesc(JkCabinetLog::getCreateDate); |
| | |
| | | for (JkCabinetLog jkCabinetLog:jkCabinetLogs) { |
| | | CabinetBoardUseRecordVO cabinetBoardUseRecordVO = new CabinetBoardUseRecordVO(); |
| | | BeanUtil.copyProperties(jkCabinetLog,cabinetBoardUseRecordVO); |
| | | cabinetBoardUseRecordVO.setStatus(Objects.nonNull(jkCabinetLog.getReturnDate())?Constants.ZERO:Constants.ONE); |
| | | cabinetBoardUseRecordVO.setStatus(Objects.nonNull(jkCabinetLog.getReturnDate())?Constants.ONE:Constants.ZERO); |
| | | cabinetBoardUseRecordVO.setRemark(Objects.isNull(jkCabinetLog.getOpenWay())?"": |
| | | Constants.equalsInteger(jkCabinetLog.getOpenWay(),Constants.ZERO)?"随车领取": |
| | | Constants.equalsInteger(jkCabinetLog.getOpenWay(),Constants.ONE)?"随派车单领取":"保洁领取" |
| | |
| | | |
| | | @Override |
| | | public List<InterestedListVO> getKeyUseStatistics(Integer type){ |
| | | List<String> weekDays = DateUtil.getBeforDays(new Date(),Objects.isNull(type)||Constants.equalsInteger(type,Constants.ZERO)?7:15); |
| | | List<String> weekDays = DateUtil.getBeforDaysByFormat(new Date(),Objects.isNull(type)||Constants.equalsInteger(type,Constants.ZERO)?7:15,"MM月dd日"); |
| | | MPJLambdaWrapper<JkCabinetLog> wrapper = new MPJLambdaWrapper<JkCabinetLog>() |
| | | .selectAll(JkCabinetLog.class) |
| | | .selectAs(Member::getName,JkCabinetLog::getMemberName) |
| | |
| | | .eq(JkCabinetLog::getIsdeleted, Constants.ZERO) |
| | | .eq(JkCabinetLog::getType,Constants.ONE) |
| | | .ne(JkCabinetLog::getKeyStatus,Constants.ZERO) |
| | | .apply(" CREATE_DATE > CURDATE() - INTERVAL "+(Objects.isNull(type)||Constants.equalsInteger(type,Constants.ZERO)?7:15)+" DAY ") |
| | | .apply(" t.CREATE_DATE > CURDATE() - INTERVAL "+(Objects.isNull(type)||Constants.equalsInteger(type,Constants.ZERO)?7:15)+" DAY ") |
| | | .orderByDesc(JkCabinetLog::getCreateDate); |
| | | List<JkCabinetLog> jkCabinetLogs = jkCabinetLogMapper.selectJoinList(JkCabinetLog.class,wrapper); |
| | | List<InterestedListVO> list = new ArrayList<>(); |
| | |
| | | if (com.github.xiaoymin.knife4j.core.util.CollectionUtils.isNotEmpty(jkCabinetLogs)) { |
| | | vo.setNum( |
| | | jkCabinetLogs.stream().filter(i->Constants.equalsInteger(i.getKeyStatus(),Constants.TWO) |
| | | &&DateUtil.dateToString(i.getCreateDate(),"yyyy-MM-dd").equals(days)) |
| | | &&DateUtil.dateToString(i.getCreateDate(),"MM月dd日").equals(days)) |
| | | .collect(Collectors.toList()).size() |
| | | ); |
| | | vo.setNextNum(jkCabinetLogs.stream().filter(i->Constants.equalsInteger(i.getKeyStatus(),Constants.ONE) |
| | | &&DateUtil.dateToString(i.getCreateDate(),"yyyy-MM-dd").equals(days)) |
| | | &&DateUtil.dateToString(i.getCreateDate(),"MM月dd日").equals(days)) |
| | | .collect(Collectors.toList()).size()); |
| | | |
| | | } |
| | | list.add(vo); |
| | | } |
| | | return list; |
| | | } |