From c35bd84886fb0c4e4ee0ffeeb3819a8a8df532b5 Mon Sep 17 00:00:00 2001
From: tuqin <tuqin@tuqin.cn>
Date: 星期一, 02 十一月 2026 13:13:36 +0800
Subject: [PATCH] feat(safety): 安全生产六期 - 风险可视化看板
---
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/safety/vo/dashboard/MesSafetyDashboardRespVO.java | 192 +++++++++++++++++++
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/safety/MesSafetyDashboardServiceImpl.java | 317 +++++++++++++++++++++++++++++++
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/safety/MesSafetyDashboardController.java | 38 +++
sql/mysql/mes_safety_dashboard_init.sql | 33 +++
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/safety/MesSafetyDashboardService.java | 19 +
5 files changed, 599 insertions(+), 0 deletions(-)
diff --git a/sql/mysql/mes_safety_dashboard_init.sql b/sql/mysql/mes_safety_dashboard_init.sql
new file mode 100644
index 0000000..12b992b
--- /dev/null
+++ b/sql/mysql/mes_safety_dashboard_init.sql
@@ -0,0 +1,33 @@
+-- =====================================================================
+-- 瀹夊叏鐢熶骇妯″潡 鈥斺�� 鍏湡锛氶闄╁彲瑙嗗寲鐪嬫澘
+--
+-- 瀹氫綅锛氭妸椋庨櫓銆侀殣鎮c�佷綔涓氱エ銆佸煿璁�佽瘉涔︿簲鍧楁暟鎹泦涓憟鐜帮紝渚涚鐞嗗眰涓�鐪肩湅鍏ㄥ眬銆�
+-- 涓嶆柊澧炰笟鍔¤〃锛屽彧鍋氭暟鎹仛鍚堝睍绀恒��
+--
+-- 鍐呭锛氳彍鍗曘�屽畨鍏ㄧ湅鏉裤�嶏紝缃簬瀹夊叏鐢熶骇鐩綍棣栦綅
+--
+-- 鐗规�э細鍙噸澶嶆墽琛�
+-- =====================================================================
+
+DELETE FROM system_role_menu WHERE menu_id BETWEEN 1065961 AND 1065970;
+
+DELETE FROM system_menu WHERE id BETWEEN 1065961 AND 1065970;
+
+INSERT INTO system_menu (id, name, permission, type, sort, parent_id, path, icon,
+ component, component_name, status, visible, keep_alive, always_show,
+ creator, create_time, updater, update_time, deleted)
+VALUES
+(1065961, '瀹夊叏鐪嬫澘', '', 2, 0, 1065910, 'dashboard', 'ep:data-analysis',
+ 'safety/dashboard/index', 'SafetyDashboard', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'),
+(1065962, '鐪嬫澘鏌ヨ', 'mes:safety-dashboard:query', 3, 1, 1065961, '', '', NULL, NULL, 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0');
+
+INSERT INTO system_role_menu (role_id, menu_id, creator, create_time, updater, update_time, deleted)
+SELECT 1, m.id, '1', NOW(), '1', NOW(), b'0'
+FROM system_menu m
+WHERE m.id BETWEEN 1065961 AND 1065970;
+
+-- ---------------------------------------------------------------------
+-- 楠岃瘉锛氬畨鍏ㄧ敓浜х洰褰曚笅鐨勫叏閮ㄨ彍鍗�
+-- ---------------------------------------------------------------------
+SELECT id, parent_id, name, path, component, permission, type, sort
+FROM system_menu WHERE id BETWEEN 1065910 AND 1065970 ORDER BY sort, id;
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/safety/MesSafetyDashboardController.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/safety/MesSafetyDashboardController.java
new file mode 100644
index 0000000..6a7b3e1
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/safety/MesSafetyDashboardController.java
@@ -0,0 +1,38 @@
+package cn.iocoder.yudao.module.mes.controller.admin.safety;
+
+import cn.iocoder.yudao.framework.common.pojo.CommonResult;
+import cn.iocoder.yudao.module.mes.controller.admin.safety.vo.dashboard.MesSafetyDashboardRespVO;
+import cn.iocoder.yudao.module.mes.service.safety.MesSafetyDashboardService;
+import io.swagger.v3.oas.annotations.Operation;
+import io.swagger.v3.oas.annotations.tags.Tag;
+import jakarta.annotation.Resource;
+import org.springframework.security.access.prepost.PreAuthorize;
+import org.springframework.validation.annotation.Validated;
+import org.springframework.web.bind.annotation.GetMapping;
+import org.springframework.web.bind.annotation.RequestMapping;
+import org.springframework.web.bind.annotation.RestController;
+
+import static cn.iocoder.yudao.framework.common.pojo.CommonResult.success;
+
+/**
+ * 瀹夊叏鐢熶骇 - 鍙鍖栫湅鏉� Controller
+ *
+ * @author 瓒呯骇绠$悊鍛�
+ */
+@Tag(name = "绠$悊鍚庡彴 - 瀹夊叏鐢熶骇-鍙鍖栫湅鏉�")
+@RestController
+@RequestMapping("/mes/safety/dashboard")
+@Validated
+public class MesSafetyDashboardController {
+
+ @Resource
+ private MesSafetyDashboardService dashboardService;
+
+ @GetMapping("/overview")
+ @Operation(summary = "鑾峰緱鐪嬫澘姒傝鏁版嵁")
+ @PreAuthorize("@ss.hasPermission('mes:safety-dashboard:query')")
+ public CommonResult<MesSafetyDashboardRespVO> getOverview() {
+ return success(dashboardService.getOverview());
+ }
+
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/safety/vo/dashboard/MesSafetyDashboardRespVO.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/safety/vo/dashboard/MesSafetyDashboardRespVO.java
new file mode 100644
index 0000000..a9378ef
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/safety/vo/dashboard/MesSafetyDashboardRespVO.java
@@ -0,0 +1,192 @@
+package cn.iocoder.yudao.module.mes.controller.admin.safety.vo.dashboard;
+
+import io.swagger.v3.oas.annotations.media.Schema;
+import lombok.Data;
+
+import java.math.BigDecimal;
+import java.time.LocalDate;
+import java.time.LocalDateTime;
+import java.util.List;
+
+/**
+ * 瀹夊叏鐢熶骇 - 鍙鍖栫湅鏉� Response VO
+ *
+ * 鑱氬悎椋庨櫓銆侀殣鎮c�佷綔涓氱エ銆佸煿璁�佽瘉涔︾殑缁熻鏁版嵁锛屼緵鐪嬫澘涓�娆℃�ф覆鏌�
+ *
+ * @author 瓒呯骇绠$悊鍛�
+ */
+@Schema(description = "绠$悊鍚庡彴 - 瀹夊叏鐢熶骇鐪嬫澘 Response VO")
+@Data
+public class MesSafetyDashboardRespVO {
+
+ // ==================== 椋庨櫓 ====================
+
+ @Schema(description = "椋庨櫓鎬绘暟", example = "25")
+ private Long riskTotal;
+
+ @Schema(description = "椋庨櫓绛夌骇鍒嗗竷")
+ private List<NameCount> riskLevelStats;
+
+ @Schema(description = "椋庨櫓鎸夎溅闂村垎甯冿紙Top 10锛�")
+ private List<NameCount> riskByWorkshop;
+
+ // ==================== 闅愭偅 ====================
+
+ @Schema(description = "闅愭偅缁熻")
+ private HazardStats hazardStats;
+
+ @Schema(description = "闅愭偅鎸夎溅闂村垎甯冿紙Top 10锛�")
+ private List<NameCount> hazardByWorkshop;
+
+ // ==================== 浣滀笟绁� ====================
+
+ @Schema(description = "浣滀笟绁ㄧ粺璁�")
+ private TicketStats ticketStats;
+
+ // ==================== 鍩硅 ====================
+
+ @Schema(description = "鍩硅缁熻")
+ private TrainingStats trainingStats;
+
+ // ==================== 璇佷功 ====================
+
+ @Schema(description = "璇佷功缁熻")
+ private CertificateStats certificateStats;
+
+ // ==================== 鏈�杩戝姩鎬� ====================
+
+ @Schema(description = "鏈�杩戦殣鎮o紙5 鏉★級")
+ private List<RecentHazard> recentHazards;
+
+ @Schema(description = "鏈�杩戜綔涓氱エ锛�5 鏉★級")
+ private List<RecentTicket> recentTickets;
+
+ // ==================== 鍐呴儴绫� ====================
+
+ @Schema(description = "鍚嶇О-鏁伴噺")
+ @Data
+ public static class NameCount {
+ @Schema(description = "鍚嶇О", example = "閲嶅ぇ椋庨櫓")
+ private String name;
+ @Schema(description = "鏁伴噺", example = "3")
+ private Long count;
+ @Schema(description = "闄勫姞椤癸細绛夌骇缂栫爜锛岀敤浜庡墠绔厤鑹�", example = "1")
+ private Integer extra;
+
+ public NameCount() {}
+
+ public NameCount(String name, Long count) {
+ this.name = name;
+ this.count = count;
+ }
+
+ public NameCount(String name, Long count, Integer extra) {
+ this.name = name;
+ this.count = count;
+ this.extra = extra;
+ }
+ }
+
+ @Schema(description = "闅愭偅缁熻")
+ @Data
+ public static class HazardStats {
+ @Schema(description = "闅愭偅鎬绘暟")
+ private Long total;
+ @Schema(description = "寰呮暣鏀�")
+ private Long pending;
+ @Schema(description = "鏁存敼涓�")
+ private Long rectifying;
+ @Schema(description = "寰呴獙鏀�")
+ private Long toCheck;
+ @Schema(description = "宸查棴鐜�")
+ private Long closed;
+ @Schema(description = "宸茶秴鏈燂紙鏈棴鐜笖瓒呰繃鏁存敼鏈熼檺锛�")
+ private Long overdue;
+ @Schema(description = "鏁存敼闂幆鐜囷紙%锛�")
+ private BigDecimal closedRate;
+ }
+
+ @Schema(description = "浣滀笟绁ㄧ粺璁�")
+ @Data
+ public static class TicketStats {
+ @Schema(description = "浣滀笟绁ㄦ�绘暟")
+ private Long total;
+ @Schema(description = "寰呭鎵�")
+ private Long pending;
+ @Schema(description = "宸叉壒鍑�")
+ private Long approved;
+ @Schema(description = "宸插畬宸�")
+ private Long finished;
+ @Schema(description = "宸插綊妗�")
+ private Long archived;
+ @Schema(description = "宸查┏鍥�")
+ private Long rejected;
+ @Schema(description = "宸叉壒鍑嗕絾瓒呰鍒掔粨鏉熸椂闂�")
+ private Long overdue;
+ }
+
+ @Schema(description = "鍩硅缁熻")
+ @Data
+ public static class TrainingStats {
+ @Schema(description = "鍩硅鎬绘暟")
+ private Long total;
+ @Schema(description = "宸插畬鎴�")
+ private Long finished;
+ @Schema(description = "杩涜涓�")
+ private Long ongoing;
+ @Schema(description = "璁″垝涓�")
+ private Long planned;
+ @Schema(description = "绱鍙傝浜烘")
+ private Long attendeeTotal;
+ @Schema(description = "骞冲潎鑰冭瘯鎴愮哗")
+ private BigDecimal avgScore;
+ }
+
+ @Schema(description = "璇佷功缁熻")
+ @Data
+ public static class CertificateStats {
+ @Schema(description = "璇佷功鎬绘暟")
+ private Long total;
+ @Schema(description = "鏈夋晥")
+ private Long valid;
+ @Schema(description = "宸茶繃鏈�")
+ private Long expired;
+ @Schema(description = "30 澶╁唴鍒版湡")
+ private Long expiringSoon;
+ }
+
+ @Schema(description = "鏈�杩戦殣鎮�")
+ @Data
+ public static class RecentHazard {
+ @Schema(description = "缂栧彿")
+ private Long id;
+ @Schema(description = "闅愭偅缂栫爜")
+ private String code;
+ @Schema(description = "闅愭偅鍚嶇О")
+ private String name;
+ @Schema(description = "闅愭偅绛夌骇")
+ private Integer hazardLevel;
+ @Schema(description = "鐘舵��")
+ private Integer status;
+ @Schema(description = "鍙戠幇鏃ユ湡")
+ private LocalDate foundDate;
+ }
+
+ @Schema(description = "鏈�杩戜綔涓氱エ")
+ @Data
+ public static class RecentTicket {
+ @Schema(description = "缂栧彿")
+ private Long id;
+ @Schema(description = "浣滀笟绁ㄥ彿")
+ private String code;
+ @Schema(description = "浣滀笟绫诲瀷")
+ private Integer ticketType;
+ @Schema(description = "浣滀笟鍦扮偣")
+ private String workLocation;
+ @Schema(description = "鐘舵��")
+ private Integer status;
+ @Schema(description = "鍒涘缓鏃堕棿")
+ private LocalDateTime createTime;
+ }
+
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/safety/MesSafetyDashboardService.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/safety/MesSafetyDashboardService.java
new file mode 100644
index 0000000..27d5b24
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/safety/MesSafetyDashboardService.java
@@ -0,0 +1,19 @@
+package cn.iocoder.yudao.module.mes.service.safety;
+
+import cn.iocoder.yudao.module.mes.controller.admin.safety.vo.dashboard.MesSafetyDashboardRespVO;
+
+/**
+ * 瀹夊叏鐢熶骇 - 鍙鍖栫湅鏉� Service 鎺ュ彛
+ *
+ * 鑱氬悎椋庨櫓銆侀殣鎮c�佷綔涓氱エ銆佸煿璁�佽瘉涔︾殑缁熻鏁版嵁
+ *
+ * @author 瓒呯骇绠$悊鍛�
+ */
+public interface MesSafetyDashboardService {
+
+ /**
+ * 鑾峰緱鐪嬫澘姒傝鏁版嵁
+ */
+ MesSafetyDashboardRespVO getOverview();
+
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/safety/MesSafetyDashboardServiceImpl.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/safety/MesSafetyDashboardServiceImpl.java
new file mode 100644
index 0000000..aa5a5f7
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/safety/MesSafetyDashboardServiceImpl.java
@@ -0,0 +1,317 @@
+package cn.iocoder.yudao.module.mes.service.safety;
+
+import cn.iocoder.yudao.module.mes.controller.admin.safety.vo.dashboard.MesSafetyDashboardRespVO;
+import cn.iocoder.yudao.module.mes.controller.admin.safety.vo.dashboard.MesSafetyDashboardRespVO.*;
+import cn.iocoder.yudao.module.mes.dal.dataobject.md.workstation.MesMdWorkshopDO;
+import cn.iocoder.yudao.module.mes.dal.dataobject.safety.*;
+import cn.iocoder.yudao.module.mes.dal.mysql.md.workstation.MesMdWorkshopMapper;
+import cn.iocoder.yudao.module.mes.dal.mysql.safety.*;
+import jakarta.annotation.Resource;
+import org.springframework.stereotype.Service;
+import org.springframework.validation.annotation.Validated;
+
+import java.math.BigDecimal;
+import java.math.RoundingMode;
+import java.time.LocalDate;
+import java.time.LocalDateTime;
+import java.util.*;
+import java.util.function.Function;
+import java.util.stream.Collectors;
+
+/**
+ * 瀹夊叏鐢熶骇 - 鍙鍖栫湅鏉� Service 瀹炵幇
+ *
+ * 鏁版嵁閲忓湪褰撳墠瑙勬ā涓嬭緝灏忥紝閲囩敤鍏ㄩ噺鏌ヨ + 鍐呭瓨鑱氬悎锛岄伩鍏嶄负姣忓紶缁熻鍐欎竴濂� SQL
+ *
+ * @author 瓒呯骇绠$悊鍛�
+ */
+@Service
+@Validated
+public class MesSafetyDashboardServiceImpl implements MesSafetyDashboardService {
+
+ @Resource
+ private MesSafetyRiskMapper riskMapper;
+
+ @Resource
+ private MesSafetyRiskUnitMapper riskUnitMapper;
+
+ @Resource
+ private MesSafetyHazardMapper hazardMapper;
+
+ @Resource
+ private MesSafetyWorkTicketMapper ticketMapper;
+
+ @Resource
+ private MesSafetyTrainingMapper trainingMapper;
+
+ @Resource
+ private MesSafetyTrainingAttendeeMapper attendeeMapper;
+
+ @Resource
+ private MesSafetyCertificateMapper certificateMapper;
+
+ @Resource
+ private MesMdWorkshopMapper workshopMapper;
+
+ /** Top N */
+ private static final int TOP_N = 10;
+ /** 鏈�杩戝姩鎬佹潯鏁� */
+ private static final int RECENT_N = 5;
+ /** 璇佷功鍗冲皢鍒版湡闃堝�� */
+ private static final long EXPIRING_SOON_DAYS = 30L;
+
+ @Override
+ public MesSafetyDashboardRespVO getOverview() {
+ MesSafetyDashboardRespVO vo = new MesSafetyDashboardRespVO();
+ LocalDate today = LocalDate.now();
+ LocalDateTime now = LocalDateTime.now();
+
+ // 杞﹂棿鍚嶇О鏄犲皠锛堝涓粺璁″叡鐢級
+ Map<Long, String> workshopNameMap = loadWorkshopNames();
+
+ // ========== 椋庨櫓 ==========
+ List<MesSafetyRiskDO> risks = riskMapper.selectAllList();
+ vo.setRiskTotal((long) risks.size());
+ vo.setRiskLevelStats(buildRiskLevelStats(risks));
+ vo.setRiskByWorkshop(buildRiskByWorkshop(risks, workshopNameMap));
+
+ // ========== 闅愭偅 ==========
+ List<MesSafetyHazardDO> hazards = hazardMapper.selectAllList();
+ vo.setHazardStats(buildHazardStats(hazards, today));
+ vo.setHazardByWorkshop(buildHazardByWorkshop(hazards, workshopNameMap));
+
+ // ========== 浣滀笟绁� ==========
+ List<MesSafetyWorkTicketDO> tickets = ticketMapper.selectAllList();
+ vo.setTicketStats(buildTicketStats(tickets, now));
+
+ // ========== 鍩硅 ==========
+ List<MesSafetyTrainingDO> trainings = trainingMapper.selectAllList();
+ vo.setTrainingStats(buildTrainingStats(trainings));
+
+ // ========== 璇佷功 ==========
+ List<MesSafetyCertificateDO> certificates = certificateMapper.selectAllList();
+ vo.setCertificateStats(buildCertificateStats(certificates, today));
+
+ // ========== 鏈�杩戝姩鎬� ==========
+ vo.setRecentHazards(buildRecentHazards(hazards));
+ vo.setRecentTickets(buildRecentTickets(tickets));
+
+ return vo;
+ }
+
+ // ==================== 椋庨櫓 ====================
+
+ private List<NameCount> buildRiskLevelStats(List<MesSafetyRiskDO> risks) {
+ // 1閲嶅ぇ 2杈冨ぇ 3涓�鑸� 4浣�
+ String[] levelNames = {"閲嶅ぇ椋庨櫓", "杈冨ぇ椋庨櫓", "涓�鑸闄�", "浣庨闄�"};
+ Map<Integer, Long> countMap = risks.stream()
+ .filter(r -> r.getRiskLevel() != null)
+ .collect(Collectors.groupingBy(MesSafetyRiskDO::getRiskLevel, Collectors.counting()));
+ List<NameCount> list = new ArrayList<>(4);
+ for (int i = 1; i <= 4; i++) {
+ list.add(new NameCount(levelNames[i - 1], countMap.getOrDefault(i, 0L), i));
+ }
+ return list;
+ }
+
+ private List<NameCount> buildRiskByWorkshop(List<MesSafetyRiskDO> risks, Map<Long, String> workshopNameMap) {
+ // 椋庨櫓鏈韩娌℃湁杞﹂棿锛岀粡椋庨櫓鍗曞厓鐨� workshopId 褰掑睘
+ Set<Long> unitIds = risks.stream().map(MesSafetyRiskDO::getUnitId)
+ .filter(Objects::nonNull).collect(Collectors.toSet());
+ if (unitIds.isEmpty()) {
+ return Collections.emptyList();
+ }
+ Map<Long, MesSafetyRiskUnitDO> unitMap = riskUnitMapper.selectByIds(unitIds).stream()
+ .collect(Collectors.toMap(MesSafetyRiskUnitDO::getId, Function.identity(), (a, b) -> a));
+ Map<Long, Long> countMap = new HashMap<>();
+ for (MesSafetyRiskDO risk : risks) {
+ MesSafetyRiskUnitDO unit = unitMap.get(risk.getUnitId());
+ if (unit == null || unit.getWorkshopId() == null) {
+ continue;
+ }
+ countMap.merge(unit.getWorkshopId(), 1L, Long::sum);
+ }
+ return toTopList(countMap, workshopNameMap);
+ }
+
+ // ==================== 闅愭偅 ====================
+
+ private HazardStats buildHazardStats(List<MesSafetyHazardDO> hazards, LocalDate today) {
+ HazardStats stats = new HazardStats();
+ long total = hazards.size();
+ long pending = 0, rectifying = 0, toCheck = 0, closed = 0, overdue = 0;
+ for (MesSafetyHazardDO h : hazards) {
+ Integer s = h.getStatus();
+ if (MesSafetyHazardDO.STATUS_PENDING.equals(s)) pending++;
+ else if (MesSafetyHazardDO.STATUS_RECTIFYING.equals(s)) rectifying++;
+ else if (MesSafetyHazardDO.STATUS_TO_CHECK.equals(s)) toCheck++;
+ else if (MesSafetyHazardDO.STATUS_CLOSED.equals(s)) closed++;
+ if (h.getDeadline() != null
+ && !MesSafetyHazardDO.STATUS_CLOSED.equals(s)
+ && h.getDeadline().isBefore(today)) {
+ overdue++;
+ }
+ }
+ stats.setTotal(total);
+ stats.setPending(pending);
+ stats.setRectifying(rectifying);
+ stats.setToCheck(toCheck);
+ stats.setClosed(closed);
+ stats.setOverdue(overdue);
+ stats.setClosedRate(total > 0
+ ? BigDecimal.valueOf(closed * 100.0 / total).setScale(1, RoundingMode.HALF_UP)
+ : BigDecimal.ZERO);
+ return stats;
+ }
+
+ private List<NameCount> buildHazardByWorkshop(List<MesSafetyHazardDO> hazards, Map<Long, String> workshopNameMap) {
+ Map<Long, Long> countMap = new HashMap<>();
+ for (MesSafetyHazardDO h : hazards) {
+ if (h.getWorkshopId() != null) {
+ countMap.merge(h.getWorkshopId(), 1L, Long::sum);
+ }
+ }
+ return toTopList(countMap, workshopNameMap);
+ }
+
+ // ==================== 浣滀笟绁� ====================
+
+ private TicketStats buildTicketStats(List<MesSafetyWorkTicketDO> tickets, LocalDateTime now) {
+ TicketStats stats = new TicketStats();
+ long pending = 0, approved = 0, finished = 0, archived = 0, rejected = 0, overdue = 0;
+ for (MesSafetyWorkTicketDO t : tickets) {
+ Integer s = t.getStatus();
+ if (MesSafetyWorkTicketDO.STATUS_PENDING.equals(s)) pending++;
+ else if (MesSafetyWorkTicketDO.STATUS_APPROVED.equals(s)) approved++;
+ else if (MesSafetyWorkTicketDO.STATUS_FINISHED.equals(s)) finished++;
+ else if (MesSafetyWorkTicketDO.STATUS_ARCHIVED.equals(s)) archived++;
+ else if (MesSafetyWorkTicketDO.STATUS_REJECTED.equals(s)) rejected++;
+ if (MesSafetyWorkTicketDO.STATUS_APPROVED.equals(s)
+ && t.getPlanEndTime() != null
+ && t.getPlanEndTime().isBefore(now)) {
+ overdue++;
+ }
+ }
+ stats.setTotal((long) tickets.size());
+ stats.setPending(pending);
+ stats.setApproved(approved);
+ stats.setFinished(finished);
+ stats.setArchived(archived);
+ stats.setRejected(rejected);
+ stats.setOverdue(overdue);
+ return stats;
+ }
+
+ // ==================== 鍩硅 ====================
+
+ private TrainingStats buildTrainingStats(List<MesSafetyTrainingDO> trainings) {
+ TrainingStats stats = new TrainingStats();
+ long finished = 0, ongoing = 0, planned = 0;
+ long attendeeTotal = 0;
+ BigDecimal scoreSum = BigDecimal.ZERO;
+ int scoredCount = 0;
+ for (MesSafetyTrainingDO t : trainings) {
+ Integer s = t.getStatus();
+ if (MesSafetyTrainingDO.STATUS_FINISHED.equals(s)) finished++;
+ else if (MesSafetyTrainingDO.STATUS_ONGOING.equals(s)) ongoing++;
+ else if (MesSafetyTrainingDO.STATUS_PLANNED.equals(s)) planned++;
+ if (t.getAttendeeCount() != null) {
+ attendeeTotal += t.getAttendeeCount();
+ }
+ if (t.getAvgScore() != null) {
+ scoreSum = scoreSum.add(t.getAvgScore());
+ scoredCount++;
+ }
+ }
+ stats.setTotal((long) trainings.size());
+ stats.setFinished(finished);
+ stats.setOngoing(ongoing);
+ stats.setPlanned(planned);
+ stats.setAttendeeTotal(attendeeTotal);
+ stats.setAvgScore(scoredCount > 0
+ ? scoreSum.divide(BigDecimal.valueOf(scoredCount), 1, RoundingMode.HALF_UP)
+ : null);
+ return stats;
+ }
+
+ // ==================== 璇佷功 ====================
+
+ private CertificateStats buildCertificateStats(List<MesSafetyCertificateDO> certificates, LocalDate today) {
+ CertificateStats stats = new CertificateStats();
+ long valid = 0, expired = 0, expiringSoon = 0;
+ for (MesSafetyCertificateDO c : certificates) {
+ boolean isValid = MesSafetyCertificateDO.STATUS_VALID.equals(c.getStatus());
+ if (isValid) {
+ valid++;
+ }
+ if (c.getExpireDate() != null) {
+ long days = java.time.temporal.ChronoUnit.DAYS.between(today, c.getExpireDate());
+ if (days < 0) {
+ expired++;
+ } else if (days <= EXPIRING_SOON_DAYS) {
+ expiringSoon++;
+ }
+ }
+ }
+ stats.setTotal((long) certificates.size());
+ stats.setValid(valid);
+ stats.setExpired(expired);
+ stats.setExpiringSoon(expiringSoon);
+ return stats;
+ }
+
+ // ==================== 鏈�杩戝姩鎬� ====================
+
+ private List<RecentHazard> buildRecentHazards(List<MesSafetyHazardDO> hazards) {
+ return hazards.stream()
+ .sorted(Comparator.comparing(MesSafetyHazardDO::getId, Comparator.nullsLast(Comparator.reverseOrder())))
+ .limit(RECENT_N)
+ .map(h -> {
+ RecentHazard r = new RecentHazard();
+ r.setId(h.getId());
+ r.setCode(h.getCode());
+ r.setName(h.getName());
+ r.setHazardLevel(h.getHazardLevel());
+ r.setStatus(h.getStatus());
+ r.setFoundDate(h.getFoundDate());
+ return r;
+ })
+ .collect(Collectors.toList());
+ }
+
+ private List<RecentTicket> buildRecentTickets(List<MesSafetyWorkTicketDO> tickets) {
+ return tickets.stream()
+ .sorted(Comparator.comparing(MesSafetyWorkTicketDO::getId, Comparator.nullsLast(Comparator.reverseOrder())))
+ .limit(RECENT_N)
+ .map(t -> {
+ RecentTicket r = new RecentTicket();
+ r.setId(t.getId());
+ r.setCode(t.getCode());
+ r.setTicketType(t.getTicketType());
+ r.setWorkLocation(t.getWorkLocation());
+ r.setStatus(t.getStatus());
+ r.setCreateTime(t.getCreateTime());
+ return r;
+ })
+ .collect(Collectors.toList());
+ }
+
+ // ==================== 宸ュ叿 ====================
+
+ private Map<Long, String> loadWorkshopNames() {
+ return workshopMapper.selectList().stream()
+ .collect(Collectors.toMap(MesMdWorkshopDO::getId, MesMdWorkshopDO::getName, (a, b) -> a));
+ }
+
+ private List<NameCount> toTopList(Map<Long, Long> countMap, Map<Long, String> nameMap) {
+ return countMap.entrySet().stream()
+ .sorted(Map.Entry.<Long, Long>comparingByValue().reversed())
+ .limit(TOP_N)
+ .map(e -> new NameCount(
+ nameMap.getOrDefault(e.getKey(), "鏈煡杞﹂棿"),
+ e.getValue(),
+ e.getKey().intValue()))
+ .collect(Collectors.toList());
+ }
+
+}
--
Gitblit v1.9.3