From 6e43a9e4daa56a07fe605d6bec1370f36bd5fbfc Mon Sep 17 00:00:00 2001
From: tuqin <tuqin@tuqin.cn>
Date: 星期一, 02 十一月 2026 13:19:02 +0800
Subject: [PATCH] feat(safety): 安全生产七期 - 安全数据统计分析
---
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/safety/vo/statistics/MesSafetyStatisticsReqVO.java | 26 ++
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/safety/vo/statistics/MesSafetyHazardExcelVO.java | 91 +++++++
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/safety/MesSafetyStatisticsController.java | 145 ++++++++++++
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/safety/MesSafetyStatisticsService.java | 18 +
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/safety/MesSafetyStatisticsServiceImpl.java | 240 ++++++++++++++++++++
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/safety/vo/statistics/MesSafetyStatisticsRespVO.java | 103 ++++++++
sql/mysql/mes_safety_statistics_init.sql | 38 +++
7 files changed, 661 insertions(+), 0 deletions(-)
diff --git a/sql/mysql/mes_safety_statistics_init.sql b/sql/mysql/mes_safety_statistics_init.sql
new file mode 100644
index 0000000..cf759b1
--- /dev/null
+++ b/sql/mysql/mes_safety_statistics_init.sql
@@ -0,0 +1,38 @@
+-- =====================================================================
+-- 瀹夊叏鐢熶骇妯″潡 鈥斺�� 涓冩湡锛氬畨鍏ㄦ暟鎹粺璁″垎鏋�
+--
+-- 瀹氫綅锛氭寜鏃堕棿娈典笌杞﹂棿绛涢�夛紝杈撳嚭闅愭偅/浣滀笟绁�/鍩硅/璇佷功鍥涗釜缁村害鐨勫垎缁勭粺璁★紝
+-- 骞舵敮鎸侀殣鎮f槑缁嗗鍑� Excel銆備笉鏂板涓氬姟琛ㄣ��
+--
+-- 涓庛�屽畨鍏ㄧ湅鏉裤�嶇殑鍖哄埆锛�
+-- 鐪嬫澘 = 瀹炴椂鍏ㄥ眬姒傝锛屼笉鍙瓫閫夈�佷笉瀵煎嚭
+-- 缁熻鍒嗘瀽 = 鍙寚瀹氭椂闂磋寖鍥翠笌杞﹂棿锛屽嚭鍒嗙粍鎶ヨ〃锛屽彲瀵煎嚭
+--
+-- 鍐呭锛氳彍鍗曘�岀粺璁″垎鏋愩��
+--
+-- 鐗规�э細鍙噸澶嶆墽琛�
+-- =====================================================================
+
+DELETE FROM system_role_menu WHERE menu_id BETWEEN 1065963 AND 1065970;
+
+DELETE FROM system_menu WHERE id BETWEEN 1065963 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
+(1065963, '缁熻鍒嗘瀽', '', 2, 8, 1065910, 'statistics', 'ep:trend-charts',
+ 'safety/statistics/index', 'SafetyStatistics', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'),
+(1065964, '缁熻鏌ヨ', 'mes:safety-statistics:query', 3, 1, 1065963, '', '', NULL, NULL, 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'),
+(1065965, '鎶ヨ〃瀵煎嚭', 'mes:safety-statistics:export', 3, 2, 1065963, '', '', 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 1065963 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/MesSafetyStatisticsController.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/safety/MesSafetyStatisticsController.java
new file mode 100644
index 0000000..0b8079b
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/safety/MesSafetyStatisticsController.java
@@ -0,0 +1,145 @@
+package cn.iocoder.yudao.module.mes.controller.admin.safety;
+
+import cn.iocoder.yudao.framework.common.pojo.CommonResult;
+import cn.iocoder.yudao.framework.common.util.object.BeanUtils;
+import cn.iocoder.yudao.framework.excel.core.util.ExcelUtils;
+import cn.iocoder.yudao.module.mes.controller.admin.safety.vo.statistics.MesSafetyHazardExcelVO;
+import cn.iocoder.yudao.module.mes.controller.admin.safety.vo.statistics.MesSafetyStatisticsReqVO;
+import cn.iocoder.yudao.module.mes.controller.admin.safety.vo.statistics.MesSafetyStatisticsRespVO;
+import cn.iocoder.yudao.module.mes.dal.dataobject.md.workstation.MesMdWorkshopDO;
+import cn.iocoder.yudao.module.mes.dal.dataobject.safety.MesSafetyHazardDO;
+import cn.iocoder.yudao.module.mes.dal.mysql.md.workstation.MesMdWorkshopMapper;
+import cn.iocoder.yudao.module.mes.dal.mysql.safety.MesSafetyHazardMapper;
+import cn.iocoder.yudao.module.mes.service.safety.MesSafetyStatisticsService;
+import cn.iocoder.yudao.module.system.api.user.AdminUserApi;
+import cn.iocoder.yudao.module.system.api.user.dto.AdminUserRespDTO;
+import io.swagger.v3.oas.annotations.Operation;
+import io.swagger.v3.oas.annotations.tags.Tag;
+import jakarta.annotation.Resource;
+import jakarta.servlet.http.HttpServletResponse;
+import jakarta.validation.Valid;
+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 java.io.IOException;
+import java.time.LocalDate;
+import java.time.LocalDateTime;
+import java.util.*;
+import java.util.stream.Collectors;
+
+import static cn.iocoder.yudao.framework.common.pojo.CommonResult.success;
+
+/**
+ * 瀹夊叏鐢熶骇 - 缁熻鍒嗘瀽 Controller
+ *
+ * @author 瓒呯骇绠$悊鍛�
+ */
+@Tag(name = "绠$悊鍚庡彴 - 瀹夊叏鐢熶骇-缁熻鍒嗘瀽")
+@RestController
+@RequestMapping("/mes/safety/statistics")
+@Validated
+public class MesSafetyStatisticsController {
+
+ @Resource
+ private MesSafetyStatisticsService statisticsService;
+
+ @Resource
+ private MesSafetyHazardMapper hazardMapper;
+
+ @Resource
+ private MesMdWorkshopMapper workshopMapper;
+
+ @Resource
+ private AdminUserApi adminUserApi;
+
+ /** 闅愭偅绛夌骇鏂囨湰 */
+ private static final String[] HAZARD_LEVEL_NAMES = {null, "涓�鑸殣鎮�", "閲嶅ぇ闅愭偅"};
+ /** 闅愭偅鏉ユ簮鏂囨湰 */
+ private static final String[] HAZARD_SOURCE_NAMES = {null, "鏃ュ父鎺掓煡", "涓撻」妫�鏌�", "涓婄骇妫�鏌�", "鍛樺伐涓婃姤", "鍏朵粬"};
+
+ @GetMapping("/report")
+ @Operation(summary = "鑾峰緱瀹夊叏鐢熶骇缁熻鎶ヨ〃")
+ @PreAuthorize("@ss.hasPermission('mes:safety-statistics:query')")
+ public CommonResult<MesSafetyStatisticsRespVO> getReport(@Valid MesSafetyStatisticsReqVO reqVO) {
+ return success(statisticsService.getStatistics(reqVO));
+ }
+
+ @GetMapping("/export-hazard")
+ @Operation(summary = "瀵煎嚭闅愭偅鏄庣粏鎶ヨ〃")
+ @PreAuthorize("@ss.hasPermission('mes:safety-statistics:export')")
+ public void exportHazard(@Valid MesSafetyStatisticsReqVO reqVO,
+ HttpServletResponse response) throws IOException {
+ List<MesSafetyHazardDO> list = hazardMapper.selectAllList().stream()
+ .filter(h -> inRange(h.getCreateTime(), reqVO))
+ .filter(h -> reqVO.getWorkshopId() == null
+ || Objects.equals(h.getWorkshopId(), reqVO.getWorkshopId()))
+ .collect(Collectors.toList());
+
+ // 瀛楀吀涓庡叧鑱斿悕绉板湪瀵煎嚭鍓嶈浆涓轰腑鏂囷紝涓氬姟浜哄憳鍙洿鎺ユ煡鐪�
+ Map<Long, String> workshopNameMap = workshopMapper.selectList().stream()
+ .collect(Collectors.toMap(MesMdWorkshopDO::getId, MesMdWorkshopDO::getName, (a, b) -> a));
+ Set<Long> userIds = list.stream().map(MesSafetyHazardDO::getChargeUserId)
+ .filter(Objects::nonNull).collect(Collectors.toSet());
+ Map<Long, AdminUserRespDTO> userMap = userIds.isEmpty()
+ ? Collections.emptyMap() : adminUserApi.getUserMap(userIds);
+
+ LocalDate today = LocalDate.now();
+ List<MesSafetyHazardExcelVO> excelList = new ArrayList<>(list.size());
+ for (MesSafetyHazardDO hazard : list) {
+ MesSafetyHazardExcelVO vo = BeanUtils.toBean(hazard, MesSafetyHazardExcelVO.class);
+ vo.setHazardLevelName(dictName(HAZARD_LEVEL_NAMES, hazard.getHazardLevel()));
+ vo.setSourceName(dictName(HAZARD_SOURCE_NAMES, hazard.getSource()));
+ vo.setWorkshopName(workshopNameMap.get(hazard.getWorkshopId()));
+ vo.setStatusName(hazardStatusName(hazard.getStatus()));
+ AdminUserRespDTO charge = hazard.getChargeUserId() == null
+ ? null : userMap.get(hazard.getChargeUserId());
+ vo.setChargeUserName(charge == null ? null : charge.getNickname());
+ boolean overdue = hazard.getDeadline() != null
+ && !MesSafetyHazardDO.STATUS_CLOSED.equals(hazard.getStatus())
+ && hazard.getDeadline().isBefore(today);
+ vo.setOverdueText(overdue ? "鏄�" : "鍚�");
+ excelList.add(vo);
+ }
+
+ ExcelUtils.write(response, "闅愭偅鏄庣粏.xlsx", "闅愭偅鏄庣粏", MesSafetyHazardExcelVO.class, excelList);
+ }
+
+ // ==================== 宸ュ叿 ====================
+
+ private String dictName(String[] names, Integer value) {
+ if (value == null || value < 0 || value >= names.length) {
+ return null;
+ }
+ return names[value];
+ }
+
+ private String hazardStatusName(Integer status) {
+ if (status == null) {
+ return null;
+ }
+ return switch (status) {
+ case 0 -> "寰呮暣鏀�";
+ case 10 -> "鏁存敼涓�";
+ case 20 -> "寰呴獙鏀�";
+ case 30 -> "宸查棴鐜�";
+ default -> "鏈煡";
+ };
+ }
+
+ private boolean inRange(LocalDateTime createTime, MesSafetyStatisticsReqVO reqVO) {
+ if (reqVO.getStartDate() == null && reqVO.getEndDate() == null) {
+ return true;
+ }
+ if (createTime == null) {
+ return false;
+ }
+ if (reqVO.getStartDate() != null && createTime.isBefore(reqVO.getStartDate().atStartOfDay())) {
+ return false;
+ }
+ return reqVO.getEndDate() == null || !createTime.isAfter(reqVO.getEndDate().atTime(23, 59, 59));
+ }
+
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/safety/vo/statistics/MesSafetyHazardExcelVO.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/safety/vo/statistics/MesSafetyHazardExcelVO.java
new file mode 100644
index 0000000..347113a
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/safety/vo/statistics/MesSafetyHazardExcelVO.java
@@ -0,0 +1,91 @@
+package cn.iocoder.yudao.module.mes.controller.admin.safety.vo.statistics;
+
+import cn.idev.excel.annotation.ExcelProperty;
+import cn.idev.excel.annotation.write.style.ColumnWidth;
+import lombok.Data;
+
+import java.math.BigDecimal;
+import java.time.LocalDate;
+
+/**
+ * 瀹夊叏鐢熶骇 - 闅愭偅鏄庣粏瀵煎嚭 Excel VO
+ *
+ * 瀛楀吀鍊煎湪瀵煎嚭鍓嶅凡杞负涓枃鏂囨湰锛屼究浜庝笟鍔′汉鍛樼洿鎺ユ煡鐪�
+ *
+ * @author 瓒呯骇绠$悊鍛�
+ */
+@Data
+public class MesSafetyHazardExcelVO {
+
+ @ExcelProperty("闅愭偅缂栫爜")
+ @ColumnWidth(20)
+ private String code;
+
+ @ExcelProperty("闅愭偅鍚嶇О")
+ @ColumnWidth(30)
+ private String name;
+
+ @ExcelProperty("闅愭偅绛夌骇")
+ @ColumnWidth(12)
+ private String hazardLevelName;
+
+ @ExcelProperty("闅愭偅鏉ユ簮")
+ @ColumnWidth(14)
+ private String sourceName;
+
+ @ExcelProperty("鎵�灞炶溅闂�")
+ @ColumnWidth(16)
+ private String workshopName;
+
+ @ExcelProperty("鍏蜂綋浣嶇疆")
+ @ColumnWidth(24)
+ private String location;
+
+ @ExcelProperty("闅愭偅鎻忚堪")
+ @ColumnWidth(40)
+ private String description;
+
+ @ExcelProperty("鍙戠幇鏃ユ湡")
+ @ColumnWidth(14)
+ private LocalDate foundDate;
+
+ @ExcelProperty("鏁存敼璐d换浜�")
+ @ColumnWidth(14)
+ private String chargeUserName;
+
+ @ExcelProperty("鏁存敼鏈熼檺")
+ @ColumnWidth(14)
+ private LocalDate deadline;
+
+ @ExcelProperty("鐘舵��")
+ @ColumnWidth(12)
+ private String statusName;
+
+ @ExcelProperty("鏄惁瓒呮湡")
+ @ColumnWidth(12)
+ private String overdueText;
+
+ @ExcelProperty("鏁存敼鎺柦")
+ @ColumnWidth(40)
+ private String measure;
+
+ @ExcelProperty("鏁存敼瀹屾垚鏃ユ湡")
+ @ColumnWidth(16)
+ private LocalDate finishDate;
+
+ @ExcelProperty("楠屾敹鎰忚")
+ @ColumnWidth(30)
+ private String checkResult;
+
+ @ExcelProperty("澶囨敞")
+ @ColumnWidth(24)
+ private String remark;
+
+ /**
+ * 鍗犱綅瀛楁锛岄伩鍏� EasyExcel 瀵规棤鏁版嵁琛ㄥご鎶ラ敊
+ */
+ @ExcelProperty("")
+ @ColumnWidth(2)
+ private BigDecimal placeholder;
+
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/safety/vo/statistics/MesSafetyStatisticsReqVO.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/safety/vo/statistics/MesSafetyStatisticsReqVO.java
new file mode 100644
index 0000000..8f7536b
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/safety/vo/statistics/MesSafetyStatisticsReqVO.java
@@ -0,0 +1,26 @@
+package cn.iocoder.yudao.module.mes.controller.admin.safety.vo.statistics;
+
+import io.swagger.v3.oas.annotations.media.Schema;
+import lombok.Data;
+import org.springframework.format.annotation.DateTimeFormat;
+
+import java.time.LocalDate;
+
+import static cn.iocoder.yudao.framework.common.util.date.DateUtils.FORMAT_YEAR_MONTH_DAY;
+
+@Schema(description = "绠$悊鍚庡彴 - 瀹夊叏鐢熶骇缁熻鍒嗘瀽 Request VO")
+@Data
+public class MesSafetyStatisticsReqVO {
+
+ @Schema(description = "缁熻璧峰鏃ユ湡锛堟寜鍒涘缓鏃堕棿杩囨护锛�", example = "2026-01-01")
+ @DateTimeFormat(pattern = FORMAT_YEAR_MONTH_DAY)
+ private LocalDate startDate;
+
+ @Schema(description = "缁熻缁撴潫鏃ユ湡", example = "2026-12-31")
+ @DateTimeFormat(pattern = FORMAT_YEAR_MONTH_DAY)
+ private LocalDate endDate;
+
+ @Schema(description = "杞﹂棿缂栧彿锛堝彲閫夛紝涓虹┖鍒欑粺璁″叏閮級", example = "7")
+ private Long workshopId;
+
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/safety/vo/statistics/MesSafetyStatisticsRespVO.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/safety/vo/statistics/MesSafetyStatisticsRespVO.java
new file mode 100644
index 0000000..1b78139
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/safety/vo/statistics/MesSafetyStatisticsRespVO.java
@@ -0,0 +1,103 @@
+package cn.iocoder.yudao.module.mes.controller.admin.safety.vo.statistics;
+
+import io.swagger.v3.oas.annotations.media.Schema;
+import lombok.Data;
+
+import java.math.BigDecimal;
+import java.util.List;
+
+/**
+ * 瀹夊叏鐢熶骇 - 缁熻鍒嗘瀽 Response VO
+ *
+ * 鎸夋椂闂存缁熻闅愭偅銆佷綔涓氱エ銆佸煿璁�佽瘉涔﹀洓涓淮搴�
+ *
+ * @author 瓒呯骇绠$悊鍛�
+ */
+@Schema(description = "绠$悊鍚庡彴 - 瀹夊叏鐢熶骇缁熻鍒嗘瀽 Response VO")
+@Data
+public class MesSafetyStatisticsRespVO {
+
+ @Schema(description = "姹囨�绘寚鏍�")
+ private Summary summary;
+
+ @Schema(description = "闅愭偅鎸夎溅闂寸粺璁�")
+ private List<GroupStat> hazardByWorkshop;
+
+ @Schema(description = "闅愭偅鎸夌瓑绾х粺璁�")
+ private List<GroupStat> hazardByLevel;
+
+ @Schema(description = "闅愭偅鎸夋潵婧愮粺璁�")
+ private List<GroupStat> hazardBySource;
+
+ @Schema(description = "浣滀笟绁ㄦ寜绫诲瀷缁熻")
+ private List<GroupStat> ticketByType;
+
+ @Schema(description = "浣滀笟绁ㄦ寜鐘舵�佺粺璁�")
+ private List<GroupStat> ticketByStatus;
+
+ @Schema(description = "鍩硅鎸夌被鍨嬬粺璁�")
+ private List<GroupStat> trainingByType;
+
+ @Schema(description = "璇佷功鎸夌被鍨嬬粺璁�")
+ private List<GroupStat> certificateByType;
+
+ // ==================== 鍐呴儴绫� ====================
+
+ @Schema(description = "姹囨�绘寚鏍�")
+ @Data
+ public static class Summary {
+ @Schema(description = "闅愭偅鎬绘暟")
+ private Long hazardTotal;
+ @Schema(description = "闅愭偅宸查棴鐜暟")
+ private Long hazardClosed;
+ @Schema(description = "闅愭偅闂幆鐜囷紙%锛�")
+ private BigDecimal hazardClosedRate;
+ @Schema(description = "闅愭偅瓒呮湡鏁�")
+ private Long hazardOverdue;
+
+ @Schema(description = "浣滀笟绁ㄦ�绘暟")
+ private Long ticketTotal;
+ @Schema(description = "浣滀笟绁ㄥ凡褰掓。鏁�")
+ private Long ticketArchived;
+ @Schema(description = "浣滀笟绁ㄥ凡椹冲洖鏁�")
+ private Long ticketRejected;
+
+ @Schema(description = "鍩硅鍦烘")
+ private Long trainingTotal;
+ @Schema(description = "绱鍙傝浜烘")
+ private Long trainingAttendee;
+ @Schema(description = "鍩硅骞冲潎鍒�")
+ private BigDecimal trainingAvgScore;
+
+ @Schema(description = "璇佷功鎬绘暟")
+ private Long certificateTotal;
+ @Schema(description = "璇佷功宸茶繃鏈熸暟")
+ private Long certificateExpired;
+ }
+
+ @Schema(description = "鍒嗙粍缁熻椤�")
+ @Data
+ public static class GroupStat {
+ @Schema(description = "鍒嗙粍鍚嶇О", example = "閫犵焊杞﹂棿")
+ private String name;
+
+ @Schema(description = "鍒嗙粍缂栫爜锛堣溅闂�/绫诲瀷/绛夌骇绛夊師濮嬪�硷級", example = "7")
+ private Integer code;
+
+ @Schema(description = "鎬绘暟閲�")
+ private Long total;
+
+ @Schema(description = "宸插畬鎴愭暟閲忥紙闅愭偅=宸查棴鐜紱浣滀笟绁�=宸插綊妗o紱鍏朵粬鍙负绌猴級")
+ private Long finished;
+
+ @Schema(description = "瀹屾垚鐜囷紙%锛�")
+ private BigDecimal finishRate;
+
+ @Schema(description = "绱鍙傝浜烘锛堜粎鍩硅缁村害锛�")
+ private Long attendeeTotal;
+
+ @Schema(description = "骞冲潎鍒嗭紙浠呭煿璁淮搴︼級")
+ private BigDecimal avgScore;
+ }
+
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/safety/MesSafetyStatisticsService.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/safety/MesSafetyStatisticsService.java
new file mode 100644
index 0000000..0c21f3c
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/safety/MesSafetyStatisticsService.java
@@ -0,0 +1,18 @@
+package cn.iocoder.yudao.module.mes.service.safety;
+
+import cn.iocoder.yudao.module.mes.controller.admin.safety.vo.statistics.MesSafetyStatisticsReqVO;
+import cn.iocoder.yudao.module.mes.controller.admin.safety.vo.statistics.MesSafetyStatisticsRespVO;
+
+/**
+ * 瀹夊叏鐢熶骇 - 缁熻鍒嗘瀽 Service 鎺ュ彛
+ *
+ * @author 瓒呯骇绠$悊鍛�
+ */
+public interface MesSafetyStatisticsService {
+
+ /**
+ * 鎸夋椂闂存涓庤溅闂寸淮搴︾粺璁℃暟鎹�
+ */
+ MesSafetyStatisticsRespVO getStatistics(MesSafetyStatisticsReqVO reqVO);
+
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/safety/MesSafetyStatisticsServiceImpl.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/safety/MesSafetyStatisticsServiceImpl.java
new file mode 100644
index 0000000..ce2a519
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/safety/MesSafetyStatisticsServiceImpl.java
@@ -0,0 +1,240 @@
+package cn.iocoder.yudao.module.mes.service.safety;
+
+import cn.iocoder.yudao.module.mes.controller.admin.safety.vo.statistics.MesSafetyStatisticsReqVO;
+import cn.iocoder.yudao.module.mes.controller.admin.safety.vo.statistics.MesSafetyStatisticsRespVO;
+import cn.iocoder.yudao.module.mes.controller.admin.safety.vo.statistics.MesSafetyStatisticsRespVO.GroupStat;
+import cn.iocoder.yudao.module.mes.controller.admin.safety.vo.statistics.MesSafetyStatisticsRespVO.Summary;
+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.stream.Collectors;
+
+/**
+ * 瀹夊叏鐢熶骇 - 缁熻鍒嗘瀽 Service 瀹炵幇
+ *
+ * 鏁版嵁瑙勬ā杈冨皬锛岄噰鐢ㄥ叏閲忔煡璇� + 鍐呭瓨杩囨护鍒嗙粍锛屼究浜庣伒娲荤粍鍚堢瓫閫夋潯浠�
+ *
+ * @author 瓒呯骇绠$悊鍛�
+ */
+@Service
+@Validated
+public class MesSafetyStatisticsServiceImpl implements MesSafetyStatisticsService {
+
+ @Resource
+ private MesSafetyHazardMapper hazardMapper;
+
+ @Resource
+ private MesSafetyWorkTicketMapper ticketMapper;
+
+ @Resource
+ private MesSafetyTrainingMapper trainingMapper;
+
+ @Resource
+ private MesSafetyCertificateMapper certificateMapper;
+
+ @Resource
+ private MesMdWorkshopMapper workshopMapper;
+
+ /** 瀛楀吀鏍囩锛堜笌 SQL 涓� system_dict_data 淇濇寔涓�鑷达級 */
+ private static final String[] HAZARD_LEVEL_NAMES = {null, "涓�鑸殣鎮�", "閲嶅ぇ闅愭偅"};
+ private static final String[] HAZARD_SOURCE_NAMES = {null, "鏃ュ父鎺掓煡", "涓撻」妫�鏌�", "涓婄骇妫�鏌�", "鍛樺伐涓婃姤", "鍏朵粬"};
+ private static final String[] TICKET_TYPE_NAMES = {null, "鍔ㄧ伀浣滀笟", "鍙楅檺绌洪棿浣滀笟", "楂樺浣滀笟", "鍚婅浣滀笟",
+ "涓存椂鐢ㄧ數浣滀笟", "鏂矾浣滀笟", "鐩叉澘鎶藉牭浣滀笟", "璁惧妫�淇綔涓�"};
+ private static final String[] TICKET_STATUS_NAMES = {null, null, null, null, null, null, null, null, null, null,
+ "宸叉壒鍑�"}; // 浠呭崰浣嶏紝瀹為檯鐢� switch
+ private static final String[] TRAINING_TYPE_NAMES = {null, "涓夌骇瀹夊叏鏁欒偛", "涓撻」鍩硅", "澶嶈", "鏃ュ父瀹夊叏鏁欒偛", "鍏朵粬"};
+ private static final String[] CERT_TYPE_NAMES = {null, "鐗圭浣滀笟鎿嶄綔璇�", "瀹夊叏绠$悊浜哄憳璇�", "涓昏璐熻矗浜鸿瘉", "鍏朵粬璧勬牸璇�"};
+
+ @Override
+ public MesSafetyStatisticsRespVO getStatistics(MesSafetyStatisticsReqVO reqVO) {
+ LocalDate today = LocalDate.now();
+ MesSafetyStatisticsRespVO vo = new MesSafetyStatisticsRespVO();
+
+ // 杞﹂棿鍚嶇О鏄犲皠
+ Map<Long, String> workshopNameMap = workshopMapper.selectList().stream()
+ .collect(Collectors.toMap(MesMdWorkshopDO::getId, MesMdWorkshopDO::getName, (a, b) -> a));
+
+ // ========== 闅愭偅 ==========
+ List<MesSafetyHazardDO> hazards = hazardMapper.selectAllList().stream()
+ .filter(h -> inRange(h.getCreateTime(), reqVO))
+ .filter(h -> matchWorkshop(h.getWorkshopId(), reqVO))
+ .collect(Collectors.toList());
+
+ Summary summary = new Summary();
+ long hazardClosed = hazards.stream()
+ .filter(h -> MesSafetyHazardDO.STATUS_CLOSED.equals(h.getStatus())).count();
+ long hazardOverdue = hazards.stream()
+ .filter(h -> h.getDeadline() != null
+ && !MesSafetyHazardDO.STATUS_CLOSED.equals(h.getStatus())
+ && h.getDeadline().isBefore(today))
+ .count();
+ summary.setHazardTotal((long) hazards.size());
+ summary.setHazardClosed(hazardClosed);
+ summary.setHazardOverdue(hazardOverdue);
+ summary.setHazardClosedRate(rate(hazardClosed, hazards.size()));
+
+ // 闅愭偅鎸夎溅闂�
+ Map<Long, List<MesSafetyHazardDO>> byWorkshop = hazards.stream()
+ .filter(h -> h.getWorkshopId() != null)
+ .collect(Collectors.groupingBy(MesSafetyHazardDO::getWorkshopId));
+ vo.setHazardByWorkshop(byWorkshop.entrySet().stream()
+ .map(e -> buildStat(workshopNameMap.getOrDefault(e.getKey(), "鏈煡杞﹂棿"),
+ e.getKey().intValue(), e.getValue(),
+ h -> MesSafetyHazardDO.STATUS_CLOSED.equals(h.getStatus())))
+ .sorted(Comparator.comparing(GroupStat::getTotal).reversed())
+ .collect(Collectors.toList()));
+
+ // 闅愭偅鎸夌瓑绾�
+ vo.setHazardByLevel(groupByInteger(hazards, MesSafetyHazardDO::getHazardLevel, HAZARD_LEVEL_NAMES,
+ h -> MesSafetyHazardDO.STATUS_CLOSED.equals(h.getStatus())));
+ // 闅愭偅鎸夋潵婧�
+ vo.setHazardBySource(groupByInteger(hazards, MesSafetyHazardDO::getSource, HAZARD_SOURCE_NAMES,
+ h -> MesSafetyHazardDO.STATUS_CLOSED.equals(h.getStatus())));
+
+ // ========== 浣滀笟绁� ==========
+ List<MesSafetyWorkTicketDO> tickets = ticketMapper.selectAllList().stream()
+ .filter(t -> inRange(t.getCreateTime(), reqVO))
+ .filter(t -> matchWorkshop(t.getWorkshopId(), reqVO))
+ .collect(Collectors.toList());
+ long ticketArchived = tickets.stream()
+ .filter(t -> MesSafetyWorkTicketDO.STATUS_ARCHIVED.equals(t.getStatus())).count();
+ long ticketRejected = tickets.stream()
+ .filter(t -> MesSafetyWorkTicketDO.STATUS_REJECTED.equals(t.getStatus())).count();
+ summary.setTicketTotal((long) tickets.size());
+ summary.setTicketArchived(ticketArchived);
+ summary.setTicketRejected(ticketRejected);
+
+ vo.setTicketByType(groupByInteger(tickets, MesSafetyWorkTicketDO::getTicketType, TICKET_TYPE_NAMES,
+ t -> MesSafetyWorkTicketDO.STATUS_ARCHIVED.equals(t.getStatus())));
+ vo.setTicketByStatus(groupByInteger(tickets, MesSafetyWorkTicketDO::getStatus, null,
+ t -> MesSafetyWorkTicketDO.STATUS_ARCHIVED.equals(t.getStatus())));
+
+ // ========== 鍩硅 ==========
+ List<MesSafetyTrainingDO> trainings = trainingMapper.selectAllList().stream()
+ .filter(t -> inRange(t.getCreateTime(), reqVO))
+ .collect(Collectors.toList());
+ long attendeeTotal = trainings.stream()
+ .mapToLong(t -> t.getAttendeeCount() == null ? 0 : t.getAttendeeCount()).sum();
+ BigDecimal scoreSum = BigDecimal.ZERO;
+ int scoredCount = 0;
+ for (MesSafetyTrainingDO t : trainings) {
+ if (t.getAvgScore() != null) {
+ scoreSum = scoreSum.add(t.getAvgScore());
+ scoredCount++;
+ }
+ }
+ summary.setTrainingTotal((long) trainings.size());
+ summary.setTrainingAttendee(attendeeTotal);
+ summary.setTrainingAvgScore(scoredCount > 0
+ ? scoreSum.divide(BigDecimal.valueOf(scoredCount), 1, RoundingMode.HALF_UP) : null);
+
+ vo.setTrainingByType(groupByInteger(trainings, MesSafetyTrainingDO::getTrainingType, TRAINING_TYPE_NAMES,
+ t -> MesSafetyTrainingDO.STATUS_FINISHED.equals(t.getStatus())));
+
+ // ========== 璇佷功 ==========
+ List<MesSafetyCertificateDO> certificates = certificateMapper.selectAllList().stream()
+ .filter(c -> inRange(c.getCreateTime(), reqVO))
+ .collect(Collectors.toList());
+ long certExpired = certificates.stream()
+ .filter(c -> c.getExpireDate() != null && c.getExpireDate().isBefore(today))
+ .count();
+ summary.setCertificateTotal((long) certificates.size());
+ summary.setCertificateExpired(certExpired);
+
+ vo.setCertificateByType(groupByInteger(certificates, MesSafetyCertificateDO::getCertType, CERT_TYPE_NAMES,
+ c -> MesSafetyCertificateDO.STATUS_VALID.equals(c.getStatus())));
+
+ vo.setSummary(summary);
+ return vo;
+ }
+
+ // ==================== 宸ュ叿 ====================
+
+ /**
+ * 閫氱敤鍒嗙粍缁熻锛氭寜 Integer 瀛楁鍒嗙粍锛岃緭鍑哄悕绉�/鏁伴噺/宸插畬鎴�/瀹屾垚鐜�
+ */
+ private <T> List<GroupStat> groupByInteger(List<T> list,
+ java.util.function.Function<T, Integer> keyFn,
+ String[] nameArray,
+ java.util.function.Predicate<T> finishedFn) {
+ Map<Integer, List<T>> grouped = list.stream()
+ .filter(item -> keyFn.apply(item) != null)
+ .collect(Collectors.groupingBy(keyFn));
+ return grouped.entrySet().stream()
+ .map(e -> {
+ Integer key = e.getKey();
+ String name = resolveName(key, nameArray);
+ return buildStat(name, key, e.getValue(), finishedFn);
+ })
+ .sorted(Comparator.comparing(GroupStat::getTotal).reversed())
+ .collect(Collectors.toList());
+ }
+
+ private String resolveName(Integer key, String[] nameArray) {
+ if (nameArray != null && key >= 0 && key < nameArray.length && nameArray[key] != null) {
+ return nameArray[key];
+ }
+ // 鐘舵�佺被瀛楀吀娌℃湁閫氱敤鍚嶇О鏁扮粍锛岀洿鎺ユ寜宸茬煡鍊兼槧灏�
+ return switch (key) {
+ case 0 -> "寰呭鐞�";
+ case 10 -> "澶勭悊涓�";
+ case 20 -> "宸插畬鎴�";
+ case 30 -> "宸插綊妗�";
+ case 90 -> "宸查┏鍥�";
+ default -> "鍏朵粬(" + key + ")";
+ };
+ }
+
+ private <T> GroupStat buildStat(String name, Integer code, List<T> items,
+ java.util.function.Predicate<T> finishedFn) {
+ GroupStat stat = new GroupStat();
+ stat.setName(name);
+ stat.setCode(code);
+ stat.setTotal((long) items.size());
+ long finished = items.stream().filter(finishedFn).count();
+ stat.setFinished(finished);
+ stat.setFinishRate(rate(finished, items.size()));
+ return stat;
+ }
+
+ private BigDecimal rate(long part, long total) {
+ if (total <= 0) {
+ return BigDecimal.ZERO;
+ }
+ return BigDecimal.valueOf(part * 100.0 / total).setScale(1, RoundingMode.HALF_UP);
+ }
+
+ /**
+ * 鏃堕棿鑼冨洿杩囨护锛堟寜鍒涘缓鏃堕棿锛屽惈棣栧熬涓ゅぉ锛�
+ */
+ private boolean inRange(LocalDateTime createTime, MesSafetyStatisticsReqVO reqVO) {
+ if (reqVO.getStartDate() == null && reqVO.getEndDate() == null) {
+ return true;
+ }
+ if (createTime == null) {
+ return false;
+ }
+ if (reqVO.getStartDate() != null && createTime.isBefore(reqVO.getStartDate().atStartOfDay())) {
+ return false;
+ }
+ if (reqVO.getEndDate() != null && createTime.isAfter(reqVO.getEndDate().atTime(23, 59, 59))) {
+ return false;
+ }
+ return true;
+ }
+
+ private boolean matchWorkshop(Long workshopId, MesSafetyStatisticsReqVO reqVO) {
+ return reqVO.getWorkshopId() == null || Objects.equals(workshopId, reqVO.getWorkshopId());
+ }
+
+}
--
Gitblit v1.9.3