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