package com.ruoyi.web.controller.api; import com.alibaba.fastjson2.JSONArray; import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; import com.ruoyi.common.core.domain.R; import com.ruoyi.framework.web.service.TokenService; import com.ruoyi.system.dto.EquipmentDto; import com.ruoyi.system.model.*; import com.ruoyi.system.service.*; import com.ruoyi.system.vo.IndexDataDetailVo; import com.ruoyi.system.vo.IndexDataRankVo; import com.ruoyi.system.vo.IndexDataVo; import com.tencentcloudapi.iot.v20180123.models.AppUser; import io.swagger.annotations.Api; import io.swagger.annotations.ApiOperation; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.GetMapping; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RestController; import java.math.BigDecimal; import java.math.RoundingMode; import java.time.Duration; import java.time.LocalDate; import java.time.LocalDateTime; import java.util.ArrayList; import java.util.Comparator; import java.util.List; import java.util.Map; import java.util.stream.Collectors; import static java.util.stream.Collectors.groupingBy; /** *

* 专业管理 前端控制器 *

* * @author xiaochen * @since 2025-09-28 */ @Api(tags = "数据统计") @RestController @RequestMapping("") public class TDataStatisticsController { private final TMissionService missionService; private final TokenService tokenService; private final TMissionUserService missionUserService; private final TAppUserService appUserService; private final TDivisionTeamService divisionTeamService; private final TMissionAssignRuleService missionReassignService; private final TAppUserEquipmentService appUserEquipmentService; private final TEquipmentService equipmentService; @Autowired public TDataStatisticsController(TMissionService missionService, TokenService tokenService, TMissionUserService missionUserService, TAppUserService appUserService, TDivisionTeamService divisionTeamService, TMissionAssignRuleService missionReassignService1, TAppUserEquipmentService appUserEquipmentService, TEquipmentService equipmentService) { this.missionService = missionService; this.tokenService = tokenService; this.missionUserService = missionUserService; this.appUserService = appUserService; this.divisionTeamService = divisionTeamService; this.missionReassignService = missionReassignService1; this.appUserEquipmentService = appUserEquipmentService; this.equipmentService = equipmentService; } @ApiOperation(value = "获取数据-第一部分") @GetMapping(value = "/open/t-data-statistics/getData") public R getData() { IndexDataVo indexDataVo = new IndexDataVo(); List list = missionService.list(); if(list.isEmpty()){ return R.ok(indexDataVo); } indexDataVo.setAllMissionNum(list.size()); indexDataVo.setUnAssignMissionNum((int) list.stream().filter(item -> item.getStatus() == 1).count()); indexDataVo.setFinishMissionNum((int) list.stream().filter(item -> item.getStatus() == 4 || item.getStatus() == 6).count()); indexDataVo.setUnFinishMissionNum(indexDataVo.getAllMissionNum()-indexDataVo.getFinishMissionNum()); indexDataVo.setSpecialMissionNum((int) list.stream().filter(item -> item.getUrgencyLevel() == 3).count()); indexDataVo.setEmergencyMissionNum((int) list.stream().filter(item -> item.getUrgencyLevel() == 2).count()); indexDataVo.setRegularMissionNum((int) list.stream().filter(item -> item.getUrgencyLevel() == 1).count()); ArrayList indexDataDetailVos = new ArrayList<>(); // 近7天 for (int i = 6; i >=0 ; i--) { IndexDataDetailVo indexDataDetailVo = new IndexDataDetailVo(); // list根据createTime 获取对应时间的数据 String time = LocalDate.now().minusDays(i).toString(); List timeList = list.stream().filter(item -> item.getCreateTime().toLocalDate().toString().equals(time)).collect(Collectors.toList()); indexDataDetailVo.setTime(time); indexDataDetailVo.setSpecialMissionNum((int) timeList.stream().filter(item -> item.getUrgencyLevel() == 3).count()); indexDataDetailVo.setEmergencyMissionNum((int) timeList.stream().filter(item -> item.getUrgencyLevel() == 2).count()); indexDataDetailVo.setRegularMissionNum((int) timeList.stream().filter(item -> item.getUrgencyLevel() == 1).count()); indexDataDetailVos.add(indexDataDetailVo); } indexDataVo.setMissionDetail(indexDataDetailVos); List tMissions = list.stream().filter(e -> e.getReceiveTime() != null).collect(Collectors.toList()); double v = tMissions.stream().mapToDouble(TMission::getResTime).average().orElse(0); indexDataVo.setAvgResponseTime(String.valueOf(v)); List tMissions1 = list.stream().filter(e -> e.getFinishTime() != null).collect(Collectors.toList()); if(!tMissions1.isEmpty()){ long count = tMissions1.stream().filter(e -> e.getStatus() == 4).count(); String finishRate = new BigDecimal(count).divide(new BigDecimal(tMissions1.size()), 4, BigDecimal.ROUND_HALF_UP).multiply(BigDecimal.valueOf(100)).setScale(2, RoundingMode.HALF_UP).toString(); indexDataVo.setFinishRate(finishRate); } double avgFinishTime = tMissions1.stream().mapToDouble(TMission::getSuccessTime).average().orElse(0); indexDataVo.setAvgFinishTime(String.valueOf(avgFinishTime)); // 平了分的 List tMissions2 = list.stream().filter(e -> e.getAddressScore() != null ).collect(Collectors.toList()); if(!tMissions2.isEmpty()){ long count1 = tMissions2.stream().filter(e -> e.getTimeScore() + e.getAddressScore() + e.getPersonCountScore() + e.getEquipmentScore() + e.getAttemptScore() > 30).count(); String enemyAccuracyRate = new BigDecimal(count1).divide(new BigDecimal(tMissions2.size()), 4, RoundingMode.HALF_UP).multiply(BigDecimal.valueOf(100)).setScale(2, RoundingMode.HALF_UP).toString(); indexDataVo.setEnemyAccuracyRate(enemyAccuracyRate); } List list1 = missionUserService.list(new LambdaQueryWrapper().eq(TMissionUser::getUserType, 1).isNotNull(TMissionUser::getSuccessTime)); if(!list1.isEmpty()){ double setDamageRate = list1.stream().mapToDouble(TMissionUser::getDamageRate).average().orElse(0); indexDataVo.setDamageRate(String.valueOf(setDamageRate)); } return R.ok(indexDataVo); } @ApiOperation(value = "获取数据-第二部分") @GetMapping(value = "/open/t-data-statistics/getDataTwo") public R getDataTwo() { IndexDataVo indexDataVo = new IndexDataVo(); List listAll = missionService.list(); List list = listAll.stream().filter(item -> item.getStatus() == 4).collect(Collectors.toList()); if(listAll.isEmpty()){ return R.ok(indexDataVo); } if (!list.isEmpty()) { List missionIds = list.stream().map(TMission::getId).collect(Collectors.toList()); List missionUsers = missionUserService.list(new LambdaQueryWrapper().in(TMissionUser::getMissionId, missionIds)); List userIds = missionUsers.stream().map(TMissionUser::getAppUserId).collect(Collectors.toList()); List appUsers = appUserService.list(new LambdaQueryWrapper().in(TAppUser::getId, userIds)); Map> collect = appUsers.stream().collect(groupingBy(TAppUser::getTeamId)); ArrayList indexDataRankVos = new ArrayList<>(); for (Map.Entry> entry : collect.entrySet()) { IndexDataRankVo indexDataRankVo = new IndexDataRankVo(); indexDataRankVo.setId(entry.getKey()); List userIds1 = entry.getValue().stream().map(TAppUser::getId).collect(Collectors.toList()); long count = missionUsers.stream().filter(e -> userIds1.contains(e.getAppUserId())).count(); indexDataRankVo.setCount((int) count); indexDataRankVos.add(indexDataRankVo); } List teamIds = indexDataRankVos.stream().map(IndexDataRankVo::getId).collect(Collectors.toList()); List list2 = divisionTeamService.list(new LambdaQueryWrapper().in(TDivisionTeam::getId, teamIds)); indexDataRankVos.forEach(e -> { TDivisionTeam tDivisionTeam = list2.stream().filter(s -> s.getId().equals(e.getId())).findFirst().get(); e.setName(tDivisionTeam.getTeamName()); }); // indexDataRankVos取出count排名前5的 若没有5个全取 if(indexDataRankVos.size()>5){ List collect1 = indexDataRankVos.stream().sorted(Comparator.comparingInt(IndexDataRankVo::getCount).reversed()).limit(5).collect(Collectors.toList()); indexDataVo.setRank(collect1); }else { List collect1 = indexDataRankVos.stream().sorted(Comparator.comparingInt(IndexDataRankVo::getCount).reversed()).collect(Collectors.toList()); indexDataVo.setRank(collect1); } } Map> collect = listAll.stream().collect(groupingBy(TMission::getMissionTypeId)); List indexDataDetailVos = new ArrayList<>(); for (Map.Entry> entry : collect.entrySet()) { IndexDataRankVo indexDataDetailVo = new IndexDataRankVo(); indexDataDetailVo.setId(entry.getKey()); indexDataDetailVo.setCount(entry.getValue().size()); indexDataDetailVos.add(indexDataDetailVo); } if(!indexDataDetailVos.isEmpty()){ List typeIds = indexDataDetailVos.stream().map(IndexDataRankVo::getId).collect(Collectors.toList()); List tMissionAssignRules = missionReassignService.list(new LambdaQueryWrapper().in(TMissionAssignRule::getId, typeIds)); indexDataDetailVos.forEach(e -> { TMissionAssignRule tMissionAssignRule = tMissionAssignRules.stream().filter(s -> s.getId().equals(e.getId())).findFirst().get(); e.setName(tMissionAssignRule.getTypeName()); }); } indexDataVo.setMissionType(indexDataDetailVos); // 装备库统计 List list1 = appUserEquipmentService.list(); ArrayList equipmentDtos = new ArrayList<>(); if (!list1.isEmpty()) { List equipments = list1.stream().map(TAppUserEquipment::getEquipmentCount).collect(Collectors.toList()); for (String equipment : equipments) { List dtos = JSONArray.parseArray(equipment, EquipmentDto.class); dtos = dtos.stream().filter(e->!e.getId().equals("0")).collect(Collectors.toList()); equipmentDtos.addAll(dtos); } } Map> listMap = equipmentDtos.stream().collect(groupingBy(EquipmentDto::getId)); List indexDataRankVos = new ArrayList<>(); for (Map.Entry> entry : listMap.entrySet()) { IndexDataRankVo indexDataRankVo = new IndexDataRankVo(); indexDataRankVo.setId(entry.getKey()); indexDataRankVo.setCount(entry.getValue().stream().mapToInt(EquipmentDto::getCount).sum()); indexDataRankVos.add(indexDataRankVo); } if(!indexDataRankVos.isEmpty()){ List equipIds = indexDataRankVos.stream().map(IndexDataRankVo::getId).collect(Collectors.toList()); List equipmentList = equipmentService.list(new LambdaQueryWrapper().in(TEquipment::getId, equipIds)); indexDataRankVos.forEach(e -> { TEquipment tEquipment = equipmentList.stream().filter(s -> s.getId().equals(e.getId())).findFirst().orElse(null); if(tEquipment!=null){ e.setName(tEquipment.getEquipmentName()); } }); } indexDataVo.setEquip(indexDataRankVos); return R.ok(indexDataVo); } public static void main(String[] args) { String format = String.format("%05d", 2); System.out.println(format); } }