| | |
| | | List<TLocation> locations = locationService.list(); |
| | | LambdaQueryWrapper<TTask> tTaskLambdaQueryWrapper = new LambdaQueryWrapper<>(); |
| | | if (StringUtils.hasLength(query.getStartTime()) && StringUtils.hasLength(query.getEndTime())) { |
| | | String endTime = query.getEndTime(); |
| | | String replace = endTime.replace(" 00:00:00", " 23:59:59"); |
| | | query.setEndTime(replace); |
| | | tTaskLambdaQueryWrapper.ge(TTask::getImplementTime, query.getStartTime()); |
| | | tTaskLambdaQueryWrapper.le(TTask::getImplementTime, query.getEndTime()); |
| | | } |
| | |
| | | List<TLocation> locations = locationService.list(); |
| | | LambdaQueryWrapper<TTask> tTaskLambdaQueryWrapper = new LambdaQueryWrapper<>(); |
| | | if (StringUtils.hasLength(query.getStartTime()) && StringUtils.hasLength(query.getEndTime())) { |
| | | String endTime = query.getEndTime(); |
| | | String replace = endTime.replace(" 00:00:00", " 23:59:59"); |
| | | query.setEndTime(replace); |
| | | tTaskLambdaQueryWrapper.ge(TTask::getImplementTime, query.getStartTime()); |
| | | tTaskLambdaQueryWrapper.le(TTask::getImplementTime, query.getEndTime()); |
| | | } |
| | | List<ProjectDeptDetailsVO> res = new ArrayList<>(); |
| | | List<TTask> tasks = taskCleanerService.list(tTaskLambdaQueryWrapper); |
| | | |
| | | List<TTaskDetail> taskDetails = taskDetailService.lambdaQuery().orderByDesc(BaseModel::getCreateTime).list(); |
| | | List<String> collect = tasks.stream().map(TTask::getProjectId).distinct().collect(Collectors.toList()); |
| | | List<TProjectDept> projectDepts = projectDeptService.list(); |
| | |
| | | entityList.add(excelExportEntity1); |
| | | } |
| | | |
| | | ExcelExportEntity excelExportEntity8 = new ExcelExportEntity("整改完成任务", "total", 15); |
| | | ExcelExportEntity excelExportEntity8 = new ExcelExportEntity("整改完成任务", "num7", 15); |
| | | excelExportEntity8.setGroupName("任务情况汇总"); |
| | | entityList.add(excelExportEntity8); |
| | | ExcelExportEntity excelExportEntity7 = new ExcelExportEntity("超时未执行任务", "total", 15); |
| | | ExcelExportEntity excelExportEntity7 = new ExcelExportEntity("超时未执行任务", "num6", 15); |
| | | excelExportEntity7.setGroupName("任务情况汇总"); |
| | | entityList.add(excelExportEntity7); |
| | | ExcelExportEntity excelExportEntity6 = new ExcelExportEntity("审核通过任务", "total", 15); |
| | | ExcelExportEntity excelExportEntity6 = new ExcelExportEntity("审核通过任务", "num5", 15); |
| | | excelExportEntity6.setGroupName("任务情况汇总"); |
| | | entityList.add(excelExportEntity6); |
| | | ExcelExportEntity excelExportEntity5 = new ExcelExportEntity("待整改任务", "total", 15); |
| | | ExcelExportEntity excelExportEntity5 = new ExcelExportEntity("待整改任务", "num4", 15); |
| | | excelExportEntity5.setGroupName("任务情况汇总"); |
| | | entityList.add(excelExportEntity5); |
| | | ExcelExportEntity excelExportEntity4 = new ExcelExportEntity("未执行任务", "total", 15); |
| | | ExcelExportEntity excelExportEntity4 = new ExcelExportEntity("未执行任务", "num3", 15); |
| | | excelExportEntity4.setGroupName("任务情况汇总"); |
| | | entityList.add(excelExportEntity4); |
| | | ExcelExportEntity excelExportEntity3 = new ExcelExportEntity("清洁不合格", "total", 15); |
| | | ExcelExportEntity excelExportEntity3 = new ExcelExportEntity("清洁不合格", "num2", 15); |
| | | excelExportEntity3.setGroupName("任务情况汇总"); |
| | | entityList.add(excelExportEntity3); |
| | | ExcelExportEntity excelExportEntity2 = new ExcelExportEntity("清洁合格", "total", 15); |
| | | ExcelExportEntity excelExportEntity2 = new ExcelExportEntity("清洁合格", "num1", 15); |
| | | excelExportEntity2.setGroupName("任务情况汇总"); |
| | | entityList.add(excelExportEntity2); |
| | | ExcelExportEntity excelExportEntity1 = new ExcelExportEntity("总数", "total", 15); |
| | |
| | | map.put("num6", row.getNum6()); |
| | | map.put("num7", row.getNum7()); |
| | | mapList.add(map); |
| | | break; |
| | | } |
| | | } |
| | | |
| | |
| | | .divide(new BigDecimal(status4.size()).add(new BigDecimal(status5.size())), 2, RoundingMode.HALF_DOWN) |
| | | .multiply(new BigDecimal(100)) : BigDecimal.ZERO); |
| | | patrolInspectorVO.setNum10(status6.size()); |
| | | patrolInspectorVO.setNum11(!taskList.isEmpty() ? new BigDecimal(status6.size()).divide(new BigDecimal(taskList.size()), 2, RoundingMode.HALF_DOWN) : BigDecimal.ZERO); |
| | | patrolInspectorVO.setNum11(!taskList.isEmpty() ? new BigDecimal(status6.size()).divide(new BigDecimal(taskList.size()), 2, RoundingMode.HALF_DOWN).multiply(new BigDecimal(100)) : BigDecimal.ZERO); |
| | | List<TLeave> collect1 = leaves.stream().filter(e -> e.getLeavePerson().equals(sysUser.getUserId() + "")).collect(Collectors.toList()); |
| | | patrolInspectorVO.setNum12(collect1.size()); |
| | | res.add(patrolInspectorVO); |