From 5e2d78f61bf7d1513d5d5c8cd55442133a6e898e Mon Sep 17 00:00:00 2001 From: 无关风月 <443237572@qq.com> Date: 星期一, 14 七月 2025 18:23:36 +0800 Subject: [PATCH] 保洁巡检本周代码 --- ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/DataStatisticsController.java | 146 +++++++++++++++++++++++++++--------------------- 1 files changed, 81 insertions(+), 65 deletions(-) diff --git a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/DataStatisticsController.java b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/DataStatisticsController.java index 8714eb4..4fc03de 100644 --- a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/DataStatisticsController.java +++ b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/DataStatisticsController.java @@ -228,20 +228,21 @@ } } // 超级管理员 查询所有任务列表 - List<TTask> taskList = new ArrayList<>(); + List<TTask> taskList = taskCleanService.list(Wrappers.lambdaQuery(TTask.class) + .in(TTask::getPatrolInspector, userId)); if(CollectionUtils.isEmpty(query.getProjectId())){ // 查询点位类型 - if(StringUtils.isNotEmpty(query.getLocationTypeId())){ - // 查询点位 - List<TLocation> locationList = locationService.list(Wrappers.lambdaQuery(TLocation.class) - .in(TLocation::getLocationType, query.getLocationTypeId())); - if(!CollectionUtils.isEmpty(locationList)){ - List<String> locationIds = locationList.stream().map(TLocation::getId).collect(Collectors.toList()); - taskList = taskCleanService.list(Wrappers.lambdaQuery(TTask.class) - .in(TTask::getLocationId, locationIds) - .between(TTask::getImplementTime, startTime, endTime)); - } - } +// if(StringUtils.isNotEmpty(query.getLocationTypeId())){ +// // 查询点位 +// List<TLocation> locationList = locationService.list(Wrappers.lambdaQuery(TLocation.class) +// .in(TLocation::getLocationType, query.getLocationTypeId())); +// if(!CollectionUtils.isEmpty(locationList)){ +// List<String> locationIds = locationList.stream().map(TLocation::getId).collect(Collectors.toList()); +// taskList = taskCleanService.list(Wrappers.lambdaQuery(TTask.class) +// .in(TTask::getLocationId, locationIds) +// .between(TTask::getImplementTime, startTime, endTime)); +// } +// } // 查询所有项目部的任务列表 List<TProjectDept> tProjectDeptList = projectDeptService.list(Wrappers.lambdaQuery(TProjectDept.class) .eq(TProjectDept::getStatus, 1)); @@ -503,19 +504,20 @@ } } // 超级管理员 查询所有的任务列表 - List<TTask> taskList = new ArrayList<>(); + List<TTask> taskList = taskCleanService.list(Wrappers.lambdaQuery(TTask.class) + .in(TTask::getPatrolInspector, userId)); if(CollectionUtils.isEmpty(query.getProjectId())){ - // 查询点位类型 - if(StringUtils.isNotEmpty(query.getLocationTypeId())){ - // 查询点位 - List<TLocation> locationList = locationService.list(Wrappers.lambdaQuery(TLocation.class) - .in(TLocation::getLocationType, query.getLocationTypeId())); - if(!CollectionUtils.isEmpty(locationList)){ - List<String> locationIds = locationList.stream().map(TLocation::getId).collect(Collectors.toList()); - taskList = taskCleanService.list(Wrappers.lambdaQuery(TTask.class) - .in(TTask::getLocationId, locationIds)); - } - } +// // 查询点位类型 +// if(StringUtils.isEmpty(query.getLocationTypeId())){ +// // 查询点位 +// List<TLocation> locationList = locationService.list(Wrappers.lambdaQuery(TLocation.class) +// .in(TLocation::getLocationType, query.getLocationTypeId())); +// if(!CollectionUtils.isEmpty(locationList)){ +// List<String> locationIds = locationList.stream().map(TLocation::getId).collect(Collectors.toList()); +// taskList = taskCleanService.list(Wrappers.lambdaQuery(TTask.class) +// .in(TTask::getLocationId, locationIds)); +// } +// } // 查询所有项目部的任务列表 List<TProjectDept> tProjectDeptList = projectDeptService.list(Wrappers.lambdaQuery(TProjectDept.class) .eq(TProjectDept::getStatus, 1)); @@ -687,19 +689,20 @@ } } // 超级管理员 查询所有的任务列表 - List<TTask> taskList = new ArrayList<>(); + List<TTask> taskList = taskCleanService.list(Wrappers.lambdaQuery(TTask.class) + .in(TTask::getPatrolInspector, userId)); if(CollectionUtils.isEmpty(query.getProjectId())){ // 查询点位类型 - if(StringUtils.isNotEmpty(query.getLocationTypeId())){ - // 查询点位 - List<TLocation> locationList = locationService.list(Wrappers.lambdaQuery(TLocation.class) - .in(TLocation::getLocationType, query.getLocationTypeId())); - if(!CollectionUtils.isEmpty(locationList)){ - List<String> locationIds = locationList.stream().map(TLocation::getId).collect(Collectors.toList()); - taskList = taskCleanService.list(Wrappers.lambdaQuery(TTask.class) - .in(TTask::getLocationId, locationIds)); - } - } +// if(StringUtils.isNotEmpty(query.getLocationTypeId())){ +// // 查询点位 +// List<TLocation> locationList = locationService.list(Wrappers.lambdaQuery(TLocation.class) +// .in(TLocation::getLocationType, query.getLocationTypeId())); +// if(!CollectionUtils.isEmpty(locationList)){ +// List<String> locationIds = locationList.stream().map(TLocation::getId).collect(Collectors.toList()); +// taskList = taskCleanService.list(Wrappers.lambdaQuery(TTask.class) +// .in(TTask::getLocationId, locationIds)); +// } +// } // 查询所有项目部的任务列表 List<TProjectDept> tProjectDeptList = projectDeptService.list(Wrappers.lambdaQuery(TProjectDept.class) .eq(TProjectDept::getStatus, 1)); @@ -992,20 +995,21 @@ sysUsers = sysUserService.selectListByDeptId(deptId); } // 超级管理员 查询所有的任务列表 - List<TTask> taskList = new ArrayList<>(); + List<TTask> taskList = taskCleanService.list(Wrappers.lambdaQuery(TTask.class) + .in(TTask::getPatrolInspector, userId)); if(CollectionUtils.isEmpty(query.getProjectId())){ // 查询点位类型 - if(StringUtils.isNotEmpty(query.getLocationTypeId())){ - // 查询点位 - List<TLocation> locationList = locationService.list(Wrappers.lambdaQuery(TLocation.class) - .in(TLocation::getLocationType, query.getLocationTypeId())); - if(!CollectionUtils.isEmpty(locationList)){ - List<String> locationIds = locationList.stream().map(TLocation::getId).collect(Collectors.toList()); - taskList = taskCleanService.list(Wrappers.lambdaQuery(TTask.class) - .in(TTask::getLocationId, locationIds) - .between(TTask::getImplementTime, startTime, endTime)); - } - } +// if(StringUtils.isNotEmpty(query.getLocationTypeId())){ +// // 查询点位 +// List<TLocation> locationList = locationService.list(Wrappers.lambdaQuery(TLocation.class) +// .in(TLocation::getLocationType, query.getLocationTypeId())); +// if(!CollectionUtils.isEmpty(locationList)){ +// List<String> locationIds = locationList.stream().map(TLocation::getId).collect(Collectors.toList()); +// taskList = taskCleanService.list(Wrappers.lambdaQuery(TTask.class) +// .in(TTask::getLocationId, locationIds) +// .between(TTask::getImplementTime, startTime, endTime)); +// } +// } // 查询所有项目部的任务列表 List<TProjectDept> tProjectDeptList = projectDeptService.list(Wrappers.lambdaQuery(TProjectDept.class) .eq(TProjectDept::getStatus, 1) @@ -1247,20 +1251,21 @@ map.put("totalLocationNum", locationList.size()); } // 超级管理员 查询所有的任务列表 - List<TTask> taskList = new ArrayList<>(); + List<TTask> taskList = taskCleanService.list(Wrappers.lambdaQuery(TTask.class) + .in(TTask::getPatrolInspector, userId)); if(CollectionUtils.isEmpty(query.getProjectId())){ // 查询点位类型 - if(StringUtils.isNotEmpty(query.getLocationTypeId())){ - // 查询点位 - List<TLocation> locationList = locationService.list(Wrappers.lambdaQuery(TLocation.class) - .in(TLocation::getLocationType, query.getLocationTypeId())); - if(!CollectionUtils.isEmpty(locationList)){ - List<String> locationIds = locationList.stream().map(TLocation::getId).collect(Collectors.toList()); - taskList = taskCleanService.list(Wrappers.lambdaQuery(TTask.class) - .in(TTask::getLocationId, locationIds) - .between(TTask::getImplementTime, startTime, endTime)); - } - } +// if(StringUtils.isNotEmpty(query.getLocationTypeId())){ +// // 查询点位 +// List<TLocation> locationList = locationService.list(Wrappers.lambdaQuery(TLocation.class) +// .in(TLocation::getLocationType, query.getLocationTypeId())); +// if(!CollectionUtils.isEmpty(locationList)){ +// List<String> locationIds = locationList.stream().map(TLocation::getId).collect(Collectors.toList()); +// taskList = taskCleanService.list(Wrappers.lambdaQuery(TTask.class) +// .in(TTask::getLocationId, locationIds) +// .between(TTask::getImplementTime, startTime, endTime)); +// } +// } // 查询所有项目部的任务列表 List<TProjectDept> tProjectDeptList = projectDeptService.list(Wrappers.lambdaQuery(TProjectDept.class) .eq(TProjectDept::getStatus, 1)); @@ -1432,14 +1437,25 @@ .in(TTask::getLocationId, locationIds)); // 查询片区负责人 -// List<SysUser> users = sysUserService.selectUserByNickName("片区负责人"); + List<SysUser> users = sysUserService.selectUserByNickName("片区负责人"); for (TLocation tLocation : locationList) { -// if(!CollectionUtils.isEmpty(users)){ -// -// } - long count = tasks.stream().filter(task -> task.getLocationId().equals(tLocation.getId())).count(); - tLocation.setTaskNum(count); + if(!CollectionUtils.isEmpty(users)){ + List<Long> userIds = users.stream().map(SysUser::getUserId).collect(Collectors.toList()); + List<TTask> taskList = taskCleanService.lambdaQuery().notIn(TTask::getPatrolInspector, userIds).list(); + if(!CollectionUtils.isEmpty(taskList)){ + List<String> collect = taskList.stream().map(TTask::getId).collect(Collectors.toList()); + long count = taskList.stream().filter(task -> task.getLocationId().equals(tLocation.getId()) + && collect.contains(task.getId())).count(); + tLocation.setTaskNum(count); + }else { + long count = tasks.stream().filter(task -> task.getLocationId().equals(tLocation.getId())).count(); + tLocation.setTaskNum(count); + } + }else { + long count = tasks.stream().filter(task -> task.getLocationId().equals(tLocation.getId())).count(); + tLocation.setTaskNum(count); + } } return R.ok(locationList); } -- Gitblit v1.7.1