From f0d1f1ad146e284c0adcc851a9501f468ca1aa5d Mon Sep 17 00:00:00 2001
From: gaoluyang <2820782392@qq.com>
Date: 星期日, 18 十月 2026 18:56:48 +0800
Subject: [PATCH] feat(mes): 新增能耗管理模块(计量点/抄表/定额/预警/统计)
---
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/em/meter/MesEmMeterServiceImpl.java | 249 +++
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/em/meter/vo/MesEmMeterSaveReqVO.java | 70
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/dataobject/em/record/MesEmRecordDO.java | 124 +
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/em/meter/vo/MesEmMeterRespVO.java | 86 +
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/em/quota/MesEmQuotaMapper.java | 50
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/em/quota/vo/MesEmQuotaSaveReqVO.java | 64
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/em/alert/vo/MesEmAlertRespVO.java | 95 +
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/em/meter/MesEmMeterService.java | 46
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/em/alert/MesEmAlertController.java | 72 +
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/em/alert/MesEmAlertServiceImpl.java | 339 ++++
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/enums/em/MesEmAlertLevelEnum.java | 39
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/em/quota/MesEmQuotaService.java | 32
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/em/statistics/vo/MesEmReportRespVO.java | 111 +
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/em/quota/vo/MesEmQuotaPageReqVO.java | 30
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/em/quota/MesEmQuotaServiceImpl.java | 157 ++
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/enums/em/MesEmEnergyTypeEnum.java | 49
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/em/alert/MesEmAlertService.java | 45
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/enums/em/MesEmAlertStatusEnum.java | 38
sql/mysql/mes_em_energy_init.sql | 255 +++
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/em/alert/vo/MesEmAlertPageReqVO.java | 39
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/em/meter/vo/MesEmMeterPageReqVO.java | 30
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/em/statistics/MesEmStatisticsController.java | 52
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/dataobject/em/quota/MesEmQuotaDO.java | 98 +
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/em/quota/vo/MesEmQuotaRespVO.java | 73 +
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/dataobject/em/meter/MesEmMeterDO.java | 115 +
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/enums/em/MesEmQuotaPeriodEnum.java | 38
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/em/record/vo/MesEmLastReadingRespVO.java | 23
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/enums/ErrorCodeConstants.java | 13
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/em/statistics/vo/MesEmOverviewRespVO.java | 161 ++
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/em/alert/MesEmAlertMapper.java | 66
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/enums/DictTypeConstants.java | 10
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/em/record/vo/MesEmRecordRespVO.java | 89 +
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/em/meter/MesEmMeterController.java | 107 +
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/em/quota/MesEmQuotaController.java | 77 +
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/em/statistics/MesEmStatisticsServiceImpl.java | 331 ++++
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/enums/em/MesEmAlertTypeEnum.java | 40
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/em/record/MesEmRecordService.java | 34
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/enums/em/MesEmRecordSourceEnum.java | 39
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/em/record/MesEmRecordController.java | 90 +
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/em/alert/vo/MesEmAlertHandleReqVO.java | 18
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/em/record/vo/MesEmRecordPageReqVO.java | 39
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/em/statistics/MesEmStatisticsService.java | 19
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/em/meter/MesEmMeterMapper.java | 56
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/dataobject/em/alert/MesEmAlertDO.java | 124 +
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/enums/em/MesEmQuotaObjectTypeEnum.java | 40
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/em/record/vo/MesEmRecordSaveReqVO.java | 41
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/enums/em/MesEmMeterStatusEnum.java | 38
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/em/meter/vo/MesEmOptionRespVO.java | 44
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/em/record/MesEmRecordServiceImpl.java | 178 ++
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/em/record/MesEmRecordMapper.java | 165 ++
50 files changed, 4,238 insertions(+), 0 deletions(-)
diff --git a/sql/mysql/mes_em_energy_init.sql b/sql/mysql/mes_em_energy_init.sql
new file mode 100644
index 0000000..8aad803
--- /dev/null
+++ b/sql/mysql/mes_em_energy_init.sql
@@ -0,0 +1,255 @@
+-- ============================================
+-- MES 鑳借�楃鐞� 妯″潡鍒濆鍖栬剼鏈�
+-- 1. 寤鸿〃 2. 瀛楀吀 3. 鑿滃崟涓庢寜閽潈闄� 4. 瓒呯骇绠$悊鍛樿彍鍗曟巿鏉�
+--
+-- 璇存槑锛�
+-- * 涓氬姟琛ㄧ粺涓�閫昏緫鍒犻櫎锛坉eleted 浣嶏級锛屽洜姝� code / (meter_id, record_date) 绛�
+-- 涓氬姟鍞竴鎬х敱鏈嶅姟灞傛牎楠岋紝鏁版嵁搴撲晶鍙缓鏅�氱储寮曪紝閬垮厤閫昏緫鍒犻櫎鍚庢棤娉曞鐢ㄧ紪鐮併��
+-- * 鑿滃崟鎸傚湪宸插瓨鍦ㄧ殑銆岃兘鑰楃鐞嗐�嶇洰褰曚笅锛坕d = 1065864锛�/energyManagement锛夈��
+-- ============================================
+
+-- 1. 寤鸿〃
+
+CREATE TABLE IF NOT EXISTS `mes_em_meter` (
+ `id` bigint NOT NULL AUTO_INCREMENT COMMENT '涓婚敭ID',
+ `code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '璁¢噺鐐圭紪鐮�',
+ `name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '璁¢噺鐐瑰悕绉�',
+ `energy_type` int NOT NULL COMMENT '鑳芥簮绫诲瀷锛屽瓧鍏� mes_em_energy_type',
+ `unit` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '璁¢噺鍗曚綅',
+ `meter_no` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '鐜板満琛ㄨ缂栧彿',
+ `workshop_id` bigint NULL DEFAULT NULL COMMENT '鎵�灞炶溅闂寸紪鍙�',
+ `workshop_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '鎵�灞炶溅闂村悕绉�',
+ `line_id` bigint NULL DEFAULT NULL COMMENT '鎵�灞炰骇绾跨紪鍙�',
+ `line_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '鎵�灞炰骇绾垮悕绉�',
+ `machinery_id` bigint NULL DEFAULT NULL COMMENT '鍏宠仈璁惧缂栧彿',
+ `machinery_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '鍏宠仈璁惧鍚嶇О',
+ `ratio` decimal(18, 4) NULL DEFAULT 1.0000 COMMENT '鍊嶇巼',
+ `initial_reading` decimal(18, 2) NULL DEFAULT 0.00 COMMENT '鍒濆璇绘暟',
+ `coal_factor` decimal(18, 4) NULL DEFAULT NULL COMMENT '鎶樻爣鐓ょ郴鏁帮紙kgce/璁¢噺鍗曚綅锛�',
+ `leak_threshold` decimal(18, 2) NULL DEFAULT NULL COMMENT '鏃ョ敤閲忓紓甯镐笂闄愶紙瓒呰繃瑙﹀彂鐤戜技璺戝啋婊存紡锛�',
+ `charge_user_id` bigint NULL DEFAULT NULL COMMENT '璐d换浜虹紪鍙�',
+ `install_date` date NULL DEFAULT NULL COMMENT '瀹夎鏃ユ湡',
+ `status` int NOT NULL DEFAULT 1 COMMENT '鐘舵�侊紝瀛楀吀 mes_em_meter_status',
+ `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '澶囨敞',
+
+ `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '鍒涘缓鑰�',
+ `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
+ `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '鏇存柊鑰�',
+ `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿',
+ `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎',
+ PRIMARY KEY (`id`) USING BTREE,
+ INDEX `idx_code` (`code`),
+ INDEX `idx_energy_type` (`energy_type`),
+ INDEX `idx_workshop_id` (`workshop_id`),
+ INDEX `idx_machinery_id` (`machinery_id`)
+) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = 'MES 鑳借�楄閲忕偣' ROW_FORMAT = Dynamic;
+
+CREATE TABLE IF NOT EXISTS `mes_em_record` (
+ `id` bigint NOT NULL AUTO_INCREMENT COMMENT '涓婚敭ID',
+ `meter_id` bigint NOT NULL COMMENT '璁¢噺鐐圭紪鍙�',
+ `meter_code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '璁¢噺鐐圭紪鐮佸揩鐓�',
+ `meter_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '璁¢噺鐐瑰悕绉板揩鐓�',
+ `energy_type` int NULL DEFAULT NULL COMMENT '鑳芥簮绫诲瀷蹇収锛屽瓧鍏� mes_em_energy_type',
+ `unit` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '璁¢噺鍗曚綅蹇収',
+ `ratio` decimal(18, 4) NULL DEFAULT NULL COMMENT '鍊嶇巼蹇収',
+ `coal_factor` decimal(18, 4) NULL DEFAULT NULL COMMENT '鎶樻爣鐓ょ郴鏁板揩鐓�',
+ `workshop_id` bigint NULL DEFAULT NULL COMMENT '鎵�灞炶溅闂寸紪鍙峰揩鐓�',
+ `workshop_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '鎵�灞炶溅闂村悕绉板揩鐓�',
+ `line_id` bigint NULL DEFAULT NULL COMMENT '鎵�灞炰骇绾跨紪鍙峰揩鐓�',
+ `line_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '鎵�灞炰骇绾垮悕绉板揩鐓�',
+ `machinery_id` bigint NULL DEFAULT NULL COMMENT '鍏宠仈璁惧缂栧彿蹇収',
+ `machinery_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '鍏宠仈璁惧鍚嶇О蹇収',
+ `record_date` date NOT NULL COMMENT '鎶勮〃鏃ユ湡',
+ `prev_reading` decimal(18, 2) NULL DEFAULT NULL COMMENT '鏈熷垵璇绘暟',
+ `reading` decimal(18, 2) NULL DEFAULT NULL COMMENT '鏈熸湯璇绘暟',
+ `usage_amount` decimal(18, 4) NULL DEFAULT NULL COMMENT '鏈湡鐢ㄩ噺',
+ `price` decimal(18, 4) NULL DEFAULT NULL COMMENT '鍗曚环锛堝厓/璁¢噺鍗曚綅锛�',
+ `cost` decimal(18, 2) NULL DEFAULT NULL COMMENT '鏈湡璐圭敤锛堝厓锛�',
+ `source` int NULL DEFAULT 1 COMMENT '鏁版嵁鏉ユ簮锛屽瓧鍏� mes_em_record_source',
+ `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '澶囨敞',
+
+ `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '鍒涘缓鑰�',
+ `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
+ `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '鏇存柊鑰�',
+ `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿',
+ `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎',
+ PRIMARY KEY (`id`) USING BTREE,
+ INDEX `idx_meter_date` (`meter_id`, `record_date`),
+ INDEX `idx_record_date` (`record_date`),
+ INDEX `idx_energy_type` (`energy_type`),
+ INDEX `idx_workshop_id` (`workshop_id`)
+) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = 'MES 鑳借�楁妱琛ㄨ褰�' ROW_FORMAT = Dynamic;
+
+CREATE TABLE IF NOT EXISTS `mes_em_quota` (
+ `id` bigint NOT NULL AUTO_INCREMENT COMMENT '涓婚敭ID',
+ `name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '鎸囨爣鍚嶇О',
+ `energy_type` int NOT NULL COMMENT '鑳芥簮绫诲瀷锛屽瓧鍏� mes_em_energy_type',
+ `object_type` int NOT NULL COMMENT '鑰冩牳瀵硅薄绫诲瀷锛屽瓧鍏� mes_em_quota_object_type',
+ `object_id` bigint NOT NULL DEFAULT 0 COMMENT '鑰冩牳瀵硅薄缂栧彿锛堝叏鍘備负 0锛�',
+ `object_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '鑰冩牳瀵硅薄鍚嶇О',
+ `period_type` int NOT NULL COMMENT '鑰冩牳鍛ㄦ湡锛屽瓧鍏� mes_em_quota_period',
+ `quota_value` decimal(18, 4) NOT NULL COMMENT '瀹氶鍊�',
+ `unit` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '璁¢噺鍗曚綅',
+ `warn_ratio` decimal(8, 2) NULL DEFAULT 10.00 COMMENT '棰勮姣斾緥锛�%锛�',
+ `alarm_ratio` decimal(8, 2) NULL DEFAULT 20.00 COMMENT '涓ラ噸棰勮姣斾緥锛�%锛�',
+ `mom_warn_ratio` decimal(8, 2) NULL DEFAULT 30.00 COMMENT '鐜瘮寮傚父闃堝�硷紙%锛�',
+ `yoy_warn_ratio` decimal(8, 2) NULL DEFAULT 30.00 COMMENT '鍚屾瘮寮傚父闃堝�硷紙%锛�',
+ `status` int NOT NULL DEFAULT 1 COMMENT '鐘舵�侊紝瀛楀吀 mes_em_meter_status',
+ `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '澶囨敞',
+
+ `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '鍒涘缓鑰�',
+ `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
+ `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '鏇存柊鑰�',
+ `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿',
+ `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎',
+ PRIMARY KEY (`id`) USING BTREE,
+ INDEX `idx_object` (`object_type`, `object_id`),
+ INDEX `idx_energy_type` (`energy_type`),
+ INDEX `idx_period_type` (`period_type`)
+) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = 'MES 鑳借�楄�冩牳鎸囨爣' ROW_FORMAT = Dynamic;
+
+CREATE TABLE IF NOT EXISTS `mes_em_alert` (
+ `id` bigint NOT NULL AUTO_INCREMENT COMMENT '涓婚敭ID',
+ `alert_no` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '棰勮缂栧彿',
+ `meter_id` bigint NOT NULL DEFAULT 0 COMMENT '璁¢噺鐐圭紪鍙凤紙瀹氶棰勮涓� 0锛�',
+ `meter_code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '璁¢噺鐐圭紪鐮佸揩鐓�',
+ `meter_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '璁¢噺鐐�/鑰冩牳瀵硅薄鍚嶇О',
+ `energy_type` int NULL DEFAULT NULL COMMENT '鑳芥簮绫诲瀷锛屽瓧鍏� mes_em_energy_type',
+ `alert_type` int NOT NULL COMMENT '棰勮绫诲瀷锛屽瓧鍏� mes_em_alert_type',
+ `alert_level` int NOT NULL COMMENT '棰勮绾у埆锛屽瓧鍏� mes_em_alert_level',
+ `alert_date` date NOT NULL COMMENT '棰勮鏃ユ湡',
+ `object_type` int NULL DEFAULT NULL COMMENT '鑰冩牳瀵硅薄绫诲瀷锛屽瓧鍏� mes_em_quota_object_type',
+ `object_id` bigint NOT NULL DEFAULT 0 COMMENT '鑰冩牳瀵硅薄缂栧彿锛堣閲忕偣绾ч璀︿负 0锛�',
+ `object_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '鑰冩牳瀵硅薄鍚嶇О',
+ `actual_value` decimal(18, 4) NULL DEFAULT NULL COMMENT '瀹為檯鍊�',
+ `threshold_value` decimal(18, 4) NULL DEFAULT NULL COMMENT '闃堝��',
+ `unit` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '璁¢噺鍗曚綅',
+ `content` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '棰勮鍐呭',
+ `status` int NOT NULL DEFAULT 0 COMMENT '澶勭悊鐘舵�侊紝瀛楀吀 mes_em_alert_status',
+ `handle_user_id` bigint NULL DEFAULT NULL COMMENT '澶勭悊浜虹紪鍙�',
+ `handle_user_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '澶勭悊浜哄悕绉�',
+ `handle_time` datetime NULL DEFAULT NULL COMMENT '澶勭悊鏃堕棿',
+ `handle_remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '澶勭悊璇存槑',
+
+ `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '鍒涘缓鑰�',
+ `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
+ `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '鏇存柊鑰�',
+ `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿',
+ `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎',
+ PRIMARY KEY (`id`) USING BTREE,
+ INDEX `idx_lookup` (`meter_id`, `alert_type`, `alert_date`, `object_id`),
+ INDEX `idx_alert_date` (`alert_date`),
+ INDEX `idx_status` (`status`)
+) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = 'MES 鑳借�楅璀�' ROW_FORMAT = Dynamic;
+
+-- 2. 瀛楀吀绫诲瀷
+INSERT INTO `system_dict_type` (`name`, `type`, `status`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`)
+VALUES
+('MES 鑳芥簮绫诲瀷', 'mes_em_energy_type', 0, '鐢点�佹按銆佺噧娌广�佸ぉ鐒舵皵', '1', NOW(), '1', NOW(), b'0'),
+('MES 鑳借�楄閲忕偣鐘舵��', 'mes_em_meter_status', 0, '鑳借�楄閲忕偣/鑰冩牳鎸囨爣鐘舵��', '1', NOW(), '1', NOW(), b'0'),
+('MES 鑳借�楁暟鎹潵婧�', 'mes_em_record_source', 0, '鎶勮〃璁板綍鏉ユ簮', '1', NOW(), '1', NOW(), b'0'),
+('MES 鑳借�楄�冩牳瀵硅薄绫诲瀷', 'mes_em_quota_object_type', 0, '鍏ㄥ巶/杞﹂棿/浜х嚎/璁惧', '1', NOW(), '1', NOW(), b'0'),
+('MES 鑳借�楄�冩牳鍛ㄦ湡', 'mes_em_quota_period', 0, '鏃ュ畾棰�/鏈堝畾棰�', '1', NOW(), '1', NOW(), b'0'),
+('MES 鑳借�楅璀︾被鍨�', 'mes_em_alert_type', 0, '瓒呭畾棰�/鐜瘮寮傚父/鍚屾瘮寮傚父/璺戝啋婊存紡', '1', NOW(), '1', NOW(), b'0'),
+('MES 鑳借�楅璀︾骇鍒�', 'mes_em_alert_level', 0, '鎻愮ず/璀﹀憡/涓ラ噸', '1', NOW(), '1', NOW(), b'0'),
+('MES 鑳借�楅璀﹀鐞嗙姸鎬�', 'mes_em_alert_status', 0, '鏈鐞�/宸插鐞�', '1', NOW(), '1', NOW(), b'0');
+
+-- 3. 瀛楀吀鏁版嵁
+INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`)
+VALUES
+-- 鑳芥簮绫诲瀷
+(1, '鐢�', '1', 'mes_em_energy_type', 0, 'primary', '', '鐢ㄧ數閲忥紝鍗曚綅 kWh', '1', NOW(), '1', NOW(), b'0'),
+(2, '姘�', '2', 'mes_em_energy_type', 0, 'info', '', '鐢ㄦ按閲忥紝鍗曚綅 t', '1', NOW(), '1', NOW(), b'0'),
+(3, '鐕冩补', '3', 'mes_em_energy_type', 0, 'warning', '', '鐕冩补鐢ㄩ噺锛屽崟浣� L', '1', NOW(), '1', NOW(), b'0'),
+(4, '澶╃劧姘�', '4', 'mes_em_energy_type', 0, 'success', '', '澶╃劧姘旂敤閲忥紝鍗曚綅 m鲁', '1', NOW(), '1', NOW(), b'0'),
+-- 璁¢噺鐐圭姸鎬�
+(1, '鍚敤', '1', 'mes_em_meter_status', 0, 'success', '', '鍚敤', '1', NOW(), '1', NOW(), b'0'),
+(2, '鍋滅敤', '0', 'mes_em_meter_status', 0, 'info', '', '鍋滅敤', '1', NOW(), '1', NOW(), b'0'),
+-- 鏁版嵁鏉ユ簮
+(1, '鎵嬪伐褰曞叆', '1', 'mes_em_record_source', 0, 'primary', '', '浜哄伐鎶勮〃褰曞叆', '1', NOW(), '1', NOW(), b'0'),
+(2, 'Excel 瀵煎叆', '2', 'mes_em_record_source', 0, 'warning', '', '鎵归噺瀵煎叆', '1', NOW(), '1', NOW(), b'0'),
+(3, '鑷姩閲囬泦', '3', 'mes_em_record_source', 0, 'success', '', '閲囬泦璁惧鑷姩涓婃姤', '1', NOW(), '1', NOW(), b'0'),
+-- 鑰冩牳瀵硅薄绫诲瀷
+(1, '鍏ㄥ巶', '0', 'mes_em_quota_object_type', 0, 'info', '', '鍏ㄥ巶绾ц�冩牳', '1', NOW(), '1', NOW(), b'0'),
+(2, '杞﹂棿', '1', 'mes_em_quota_object_type', 0, 'primary', '', '杞﹂棿绾ц�冩牳', '1', NOW(), '1', NOW(), b'0'),
+(3, '浜х嚎', '2', 'mes_em_quota_object_type', 0, 'warning', '', '浜х嚎绾ц�冩牳', '1', NOW(), '1', NOW(), b'0'),
+(4, '璁惧', '3', 'mes_em_quota_object_type', 0, 'danger', '', '閲嶇偣鐢ㄨ兘璁惧鑰冩牳', '1', NOW(), '1', NOW(), b'0'),
+-- 鑰冩牳鍛ㄦ湡
+(1, '鏃�', '1', 'mes_em_quota_period', 0, 'primary', '', '鎸夋棩鑰冩牳', '1', NOW(), '1', NOW(), b'0'),
+(2, '鏈�', '2', 'mes_em_quota_period', 0, 'success', '', '鎸夋湀绱鑰冩牳', '1', NOW(), '1', NOW(), b'0'),
+-- 棰勮绫诲瀷
+(1, '瓒呭畾棰�', '1', 'mes_em_alert_type', 0, 'danger', '', '瀹為檯鐢ㄩ噺瓒呰繃鑰冩牳瀹氶', '1', NOW(), '1', NOW(), b'0'),
+(2, '鐜瘮寮傚父', '2', 'mes_em_alert_type', 0, 'warning', '', '杈冧笂涓�鍛ㄦ湡寮傚父澧為暱', '1', NOW(), '1', NOW(), b'0'),
+(3, '鍚屾瘮寮傚父', '3', 'mes_em_alert_type', 0, 'warning', '', '杈冨幓骞村悓鏈熷紓甯稿闀�', '1', NOW(), '1', NOW(), b'0'),
+(4, '鐤戜技璺戝啋婊存紡', '4', 'mes_em_alert_type', 0, 'danger', '', '鍗曟棩鐢ㄩ噺瓒呰繃璁¢噺鐐硅瀹氶槇鍊�', '1', NOW(), '1', NOW(), b'0'),
+-- 棰勮绾у埆
+(1, '鎻愮ず', '1', 'mes_em_alert_level', 0, 'info', '', '鎻愮ず绾�', '1', NOW(), '1', NOW(), b'0'),
+(2, '璀﹀憡', '2', 'mes_em_alert_level', 0, 'warning', '', '璀﹀憡绾�', '1', NOW(), '1', NOW(), b'0'),
+(3, '涓ラ噸', '3', 'mes_em_alert_level', 0, 'danger', '', '涓ラ噸绾�', '1', NOW(), '1', NOW(), b'0'),
+-- 棰勮澶勭悊鐘舵��
+(1, '鏈鐞�', '0', 'mes_em_alert_status', 0, 'danger', '', '寰呭鐞�', '1', NOW(), '1', NOW(), b'0'),
+(2, '宸插鐞�', '1', 'mes_em_alert_status', 0, 'success', '', '宸插鐞�', '1', NOW(), '1', NOW(), b'0');
+
+-- 4. 鑿滃崟锛堢埗鑿滃崟 1065864 鑳借�楃鐞嗭級
+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
+(1065865, '鑳借�楁�昏', '', 2, 1, 1065864, 'overview', 'ep:data-analysis', 'energy/overview/index', 'EnergyOverview', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'),
+(1065866, '璁¢噺鐐圭鐞�', '', 2, 2, 1065864, 'meter', 'ep:odometer', 'energy/meter/index', 'EnergyMeter', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'),
+(1065867, '鑳借�楁暟鎹噰闆�', '', 2, 3, 1065864, 'record', 'ep:edit', 'energy/record/index', 'EnergyRecord', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'),
+(1065868, '鑰冩牳鎸囨爣', '', 2, 4, 1065864, 'quota', 'ep:aim', 'energy/quota/index', 'EnergyQuota', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'),
+(1065869, '鑳借�楅璀�', '', 2, 5, 1065864, 'alert', 'ep:bell', 'energy/alert/index', 'EnergyAlert', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'),
+(1065870, '鎶ヨ〃鍒嗘瀽', '', 2, 6, 1065864, 'report', 'ep:document', 'energy/report/index', 'EnergyReport', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0');
+
+-- 5. 鎸夐挳鏉冮檺
+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
+-- 鑳借�楁�昏
+(1065871, '鑳借�楁�昏鏌ヨ', 'mes:em-overview:query', 3, 1, 1065865, '', '', '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'),
+-- 璁¢噺鐐圭鐞�
+(1065872, '璁¢噺鐐规煡璇�', 'mes:em-meter:query', 3, 1, 1065866, '', '', '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'),
+(1065873, '璁¢噺鐐瑰垱寤�', 'mes:em-meter:create', 3, 2, 1065866, '', '', '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'),
+(1065874, '璁¢噺鐐规洿鏂�', 'mes:em-meter:update', 3, 3, 1065866, '', '', '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'),
+(1065875, '璁¢噺鐐瑰垹闄�', 'mes:em-meter:delete', 3, 4, 1065866, '', '', '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'),
+-- 鑳借�楁暟鎹噰闆�
+(1065876, '鎶勮〃璁板綍鏌ヨ', 'mes:em-record:query', 3, 1, 1065867, '', '', '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'),
+(1065877, '鎶勮〃璁板綍鍒涘缓', 'mes:em-record:create', 3, 2, 1065867, '', '', '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'),
+(1065878, '鎶勮〃璁板綍鏇存柊', 'mes:em-record:update', 3, 3, 1065867, '', '', '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'),
+(1065879, '鎶勮〃璁板綍鍒犻櫎', 'mes:em-record:delete', 3, 4, 1065867, '', '', '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'),
+-- 鑰冩牳鎸囨爣
+(1065880, '鑰冩牳鎸囨爣鏌ヨ', 'mes:em-quota:query', 3, 1, 1065868, '', '', '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'),
+(1065881, '鑰冩牳鎸囨爣鍒涘缓', 'mes:em-quota:create', 3, 2, 1065868, '', '', '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'),
+(1065882, '鑰冩牳鎸囨爣鏇存柊', 'mes:em-quota:update', 3, 3, 1065868, '', '', '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'),
+(1065883, '鑰冩牳鎸囨爣鍒犻櫎', 'mes:em-quota:delete', 3, 4, 1065868, '', '', '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'),
+-- 鑳借�楅璀�
+(1065884, '鑳借�楅璀︽煡璇�', 'mes:em-alert:query', 3, 1, 1065869, '', '', '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'),
+(1065885, '鑳借�楅璀﹀鐞�', 'mes:em-alert:handle', 3, 2, 1065869, '', '', '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'),
+-- 鎶ヨ〃鍒嗘瀽
+(1065886, '鎶ヨ〃鍒嗘瀽鏌ヨ', 'mes:em-report:query', 3, 1, 1065870, '', '', '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0');
+
+-- 6. 瓒呯骇绠$悊鍛樿彍鍗曟巿鏉冿紙瑙掕壊 1 缁曡繃鏉冮檺鏍¢獙锛岃繖閲岃ˉ榻愭巿鏉冭褰曚究浜庤鑹茶彍鍗曟爲灞曠ず锛�
+-- 鍏朵粬瑙掕壊濡傞渶浣跨敤锛岃鍦ㄣ�岀郴缁熺鐞� - 瑙掕壊绠$悊銆嶄腑鍕鹃�夈�岃兘鑰楃鐞嗐�嶅悗淇濆瓨銆�
+INSERT INTO `system_role_menu` (`role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`)
+VALUES
+(1, 1065864, '1', NOW(), '1', NOW(), b'0'),
+(1, 1065865, '1', NOW(), '1', NOW(), b'0'),
+(1, 1065866, '1', NOW(), '1', NOW(), b'0'),
+(1, 1065867, '1', NOW(), '1', NOW(), b'0'),
+(1, 1065868, '1', NOW(), '1', NOW(), b'0'),
+(1, 1065869, '1', NOW(), '1', NOW(), b'0'),
+(1, 1065870, '1', NOW(), '1', NOW(), b'0'),
+(1, 1065871, '1', NOW(), '1', NOW(), b'0'),
+(1, 1065872, '1', NOW(), '1', NOW(), b'0'),
+(1, 1065873, '1', NOW(), '1', NOW(), b'0'),
+(1, 1065874, '1', NOW(), '1', NOW(), b'0'),
+(1, 1065875, '1', NOW(), '1', NOW(), b'0'),
+(1, 1065876, '1', NOW(), '1', NOW(), b'0'),
+(1, 1065877, '1', NOW(), '1', NOW(), b'0'),
+(1, 1065878, '1', NOW(), '1', NOW(), b'0'),
+(1, 1065879, '1', NOW(), '1', NOW(), b'0'),
+(1, 1065880, '1', NOW(), '1', NOW(), b'0'),
+(1, 1065881, '1', NOW(), '1', NOW(), b'0'),
+(1, 1065882, '1', NOW(), '1', NOW(), b'0'),
+(1, 1065883, '1', NOW(), '1', NOW(), b'0'),
+(1, 1065884, '1', NOW(), '1', NOW(), b'0'),
+(1, 1065885, '1', NOW(), '1', NOW(), b'0'),
+(1, 1065886, '1', NOW(), '1', NOW(), b'0');
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/em/alert/MesEmAlertController.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/em/alert/MesEmAlertController.java
new file mode 100644
index 0000000..f3e8cad
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/em/alert/MesEmAlertController.java
@@ -0,0 +1,72 @@
+package cn.iocoder.yudao.module.mes.controller.admin.em.alert;
+
+import cn.iocoder.yudao.framework.common.pojo.CommonResult;
+import cn.iocoder.yudao.framework.common.pojo.PageResult;
+import cn.iocoder.yudao.module.mes.controller.admin.em.alert.vo.MesEmAlertHandleReqVO;
+import cn.iocoder.yudao.module.mes.controller.admin.em.alert.vo.MesEmAlertPageReqVO;
+import cn.iocoder.yudao.module.mes.controller.admin.em.alert.vo.MesEmAlertRespVO;
+import cn.iocoder.yudao.module.mes.dal.dataobject.em.alert.MesEmAlertDO;
+import cn.iocoder.yudao.module.mes.service.em.alert.MesEmAlertService;
+import io.swagger.v3.oas.annotations.Operation;
+import io.swagger.v3.oas.annotations.Parameter;
+import io.swagger.v3.oas.annotations.tags.Tag;
+import jakarta.annotation.Resource;
+import jakarta.validation.Valid;
+import org.springframework.format.annotation.DateTimeFormat;
+import org.springframework.security.access.prepost.PreAuthorize;
+import org.springframework.validation.annotation.Validated;
+import org.springframework.web.bind.annotation.*;
+
+import java.time.LocalDate;
+import java.util.Collections;
+
+import static cn.iocoder.yudao.framework.common.pojo.CommonResult.success;
+
+@Tag(name = "绠$悊鍚庡彴 - MES 鑳借�楅璀�")
+@RestController
+@RequestMapping("/mes/em/alert")
+@Validated
+public class MesEmAlertController {
+
+ @Resource
+ private MesEmAlertService alertService;
+
+ @GetMapping("/page")
+ @Operation(summary = "鑾峰緱鑳借�楅璀﹀垎椤�")
+ @PreAuthorize("@ss.hasPermission('mes:em-alert:query')")
+ public CommonResult<PageResult<MesEmAlertRespVO>> getAlertPage(@Valid MesEmAlertPageReqVO pageReqVO) {
+ PageResult<MesEmAlertDO> pageResult = alertService.getAlertPage(pageReqVO);
+ return success(new PageResult<>(alertService.getAlertRespVOList(pageResult.getList()),
+ pageResult.getTotal()));
+ }
+
+ @GetMapping("/get")
+ @Operation(summary = "鑾峰緱鑳借�楅璀�")
+ @Parameter(name = "id", description = "缂栧彿", required = true)
+ @PreAuthorize("@ss.hasPermission('mes:em-alert:query')")
+ public CommonResult<MesEmAlertRespVO> getAlert(@RequestParam("id") Long id) {
+ MesEmAlertDO alert = alertService.getAlert(id);
+ if (alert == null) {
+ return success(null);
+ }
+ return success(alertService.getAlertRespVOList(Collections.singletonList(alert)).get(0));
+ }
+
+ @PutMapping("/handle")
+ @Operation(summary = "澶勭悊鑳借�楅璀�")
+ @PreAuthorize("@ss.hasPermission('mes:em-alert:handle')")
+ public CommonResult<Boolean> handleAlert(@Valid @RequestBody MesEmAlertHandleReqVO handleReqVO) {
+ alertService.handleAlert(handleReqVO);
+ return success(true);
+ }
+
+ @PostMapping("/check")
+ @Operation(summary = "閲嶆柊妫�娴嬫寚瀹氭棩鏈熷尯闂寸殑鑳借�楅璀�")
+ @PreAuthorize("@ss.hasPermission('mes:em-alert:handle')")
+ public CommonResult<Integer> checkAlerts(
+ @RequestParam("beginDate") @DateTimeFormat(iso = DateTimeFormat.ISO.DATE) LocalDate beginDate,
+ @RequestParam("endDate") @DateTimeFormat(iso = DateTimeFormat.ISO.DATE) LocalDate endDate) {
+ return success(alertService.checkRange(beginDate, endDate));
+ }
+
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/em/alert/vo/MesEmAlertHandleReqVO.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/em/alert/vo/MesEmAlertHandleReqVO.java
new file mode 100644
index 0000000..9055fd8
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/em/alert/vo/MesEmAlertHandleReqVO.java
@@ -0,0 +1,18 @@
+package cn.iocoder.yudao.module.mes.controller.admin.em.alert.vo;
+
+import io.swagger.v3.oas.annotations.media.Schema;
+import jakarta.validation.constraints.NotNull;
+import lombok.Data;
+
+@Schema(description = "绠$悊鍚庡彴 - MES 鑳借�楅璀﹀鐞� Request VO")
+@Data
+public class MesEmAlertHandleReqVO {
+
+ @Schema(description = "棰勮缂栧彿", requiredMode = Schema.RequiredMode.REQUIRED, example = "1024")
+ @NotNull(message = "棰勮缂栧彿涓嶈兘涓虹┖")
+ private Long id;
+
+ @Schema(description = "澶勭悊璇存槑", example = "宸插畨鎺掓淇紝鏇存崲瀵嗗皝浠�")
+ private String handleRemark;
+
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/em/alert/vo/MesEmAlertPageReqVO.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/em/alert/vo/MesEmAlertPageReqVO.java
new file mode 100644
index 0000000..ac08b68
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/em/alert/vo/MesEmAlertPageReqVO.java
@@ -0,0 +1,39 @@
+package cn.iocoder.yudao.module.mes.controller.admin.em.alert.vo;
+
+import cn.iocoder.yudao.framework.common.pojo.PageParam;
+import io.swagger.v3.oas.annotations.media.Schema;
+import lombok.Data;
+import lombok.EqualsAndHashCode;
+import lombok.ToString;
+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 = "绠$悊鍚庡彴 - MES 鑳借�楅璀﹀垎椤� Request VO")
+@Data
+@EqualsAndHashCode(callSuper = true)
+@ToString(callSuper = true)
+public class MesEmAlertPageReqVO extends PageParam {
+
+ @Schema(description = "璁¢噺鐐瑰悕绉�", example = "鍙樺帇鍣ㄨ溅闂存�荤數琛�")
+ private String meterName;
+
+ @Schema(description = "鑳芥簮绫诲瀷", example = "1")
+ private Integer energyType;
+
+ @Schema(description = "棰勮绫诲瀷", example = "1")
+ private Integer alertType;
+
+ @Schema(description = "棰勮绾у埆", example = "2")
+ private Integer alertLevel;
+
+ @Schema(description = "澶勭悊鐘舵��", example = "0")
+ private Integer status;
+
+ @Schema(description = "棰勮鏃ユ湡")
+ @DateTimeFormat(pattern = FORMAT_YEAR_MONTH_DAY)
+ private LocalDate[] alertDate;
+
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/em/alert/vo/MesEmAlertRespVO.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/em/alert/vo/MesEmAlertRespVO.java
new file mode 100644
index 0000000..31ffee2
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/em/alert/vo/MesEmAlertRespVO.java
@@ -0,0 +1,95 @@
+package cn.iocoder.yudao.module.mes.controller.admin.em.alert.vo;
+
+import io.swagger.v3.oas.annotations.media.Schema;
+import lombok.Data;
+
+import java.math.BigDecimal;
+import java.time.LocalDate;
+import java.time.LocalDateTime;
+
+@Schema(description = "绠$悊鍚庡彴 - MES 鑳借�楅璀� Response VO")
+@Data
+public class MesEmAlertRespVO {
+
+ @Schema(description = "缂栧彿", requiredMode = Schema.RequiredMode.REQUIRED, example = "1024")
+ private Long id;
+
+ @Schema(description = "棰勮缂栧彿", example = "AL20261018-1024-1")
+ private String alertNo;
+
+ @Schema(description = "璁¢噺鐐圭紪鍙�", example = "1024")
+ private Long meterId;
+
+ @Schema(description = "璁¢噺鐐圭紪鐮�", example = "EM-DL-001")
+ private String meterCode;
+
+ @Schema(description = "璁¢噺鐐瑰悕绉�", example = "鍙樺帇鍣ㄨ溅闂存�荤數琛�")
+ private String meterName;
+
+ @Schema(description = "鑳芥簮绫诲瀷", example = "1")
+ private Integer energyType;
+
+ @Schema(description = "鑳芥簮绫诲瀷鍚嶇О", example = "鐢�")
+ private String energyTypeName;
+
+ @Schema(description = "棰勮绫诲瀷", example = "1")
+ private Integer alertType;
+
+ @Schema(description = "棰勮绫诲瀷鍚嶇О", example = "瓒呭畾棰�")
+ private String alertTypeName;
+
+ @Schema(description = "棰勮绾у埆", example = "2")
+ private Integer alertLevel;
+
+ @Schema(description = "棰勮绾у埆鍚嶇О", example = "璀﹀憡")
+ private String alertLevelName;
+
+ @Schema(description = "棰勮鏃ユ湡")
+ private LocalDate alertDate;
+
+ @Schema(description = "鑰冩牳瀵硅薄绫诲瀷", example = "1")
+ private Integer objectType;
+
+ @Schema(description = "鑰冩牳瀵硅薄绫诲瀷鍚嶇О", example = "杞﹂棿")
+ private String objectTypeName;
+
+ @Schema(description = "鑰冩牳瀵硅薄缂栧彿", example = "7")
+ private Long objectId;
+
+ @Schema(description = "鑰冩牳瀵硅薄鍚嶇О", example = "鍙樺帇鍣ㄥ埗閫犺溅闂�")
+ private String objectName;
+
+ @Schema(description = "瀹為檯鍊�", example = "1234")
+ private BigDecimal actualValue;
+
+ @Schema(description = "闃堝��", example = "1000")
+ private BigDecimal thresholdValue;
+
+ @Schema(description = "璁¢噺鍗曚綅", example = "kWh")
+ private String unit;
+
+ @Schema(description = "棰勮鍐呭")
+ private String content;
+
+ @Schema(description = "澶勭悊鐘舵��", example = "0")
+ private Integer status;
+
+ @Schema(description = "澶勭悊鐘舵�佸悕绉�", example = "鏈鐞�")
+ private String statusName;
+
+ @Schema(description = "澶勭悊浜虹紪鍙�")
+ private Long handleUserId;
+
+ @Schema(description = "澶勭悊浜哄悕绉�")
+ private String handleUserName;
+
+ @Schema(description = "澶勭悊鏃堕棿")
+ private LocalDateTime handleTime;
+
+ @Schema(description = "澶勭悊璇存槑")
+ private String handleRemark;
+
+ @Schema(description = "鍒涘缓鏃堕棿")
+ private LocalDateTime createTime;
+
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/em/meter/MesEmMeterController.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/em/meter/MesEmMeterController.java
new file mode 100644
index 0000000..e84e80b
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/em/meter/MesEmMeterController.java
@@ -0,0 +1,107 @@
+package cn.iocoder.yudao.module.mes.controller.admin.em.meter;
+
+import cn.iocoder.yudao.framework.common.pojo.CommonResult;
+import cn.iocoder.yudao.framework.common.pojo.PageResult;
+import cn.iocoder.yudao.module.mes.controller.admin.em.meter.vo.MesEmMeterPageReqVO;
+import cn.iocoder.yudao.module.mes.controller.admin.em.meter.vo.MesEmMeterRespVO;
+import cn.iocoder.yudao.module.mes.controller.admin.em.meter.vo.MesEmMeterSaveReqVO;
+import cn.iocoder.yudao.module.mes.controller.admin.em.meter.vo.MesEmOptionRespVO;
+import cn.iocoder.yudao.module.mes.dal.dataobject.em.meter.MesEmMeterDO;
+import cn.iocoder.yudao.module.mes.service.em.meter.MesEmMeterService;
+import io.swagger.v3.oas.annotations.Operation;
+import io.swagger.v3.oas.annotations.Parameter;
+import io.swagger.v3.oas.annotations.tags.Tag;
+import jakarta.annotation.Resource;
+import jakarta.validation.Valid;
+import org.springframework.security.access.prepost.PreAuthorize;
+import org.springframework.validation.annotation.Validated;
+import org.springframework.web.bind.annotation.*;
+
+import java.util.Collections;
+import java.util.List;
+
+import static cn.iocoder.yudao.framework.common.pojo.CommonResult.success;
+
+@Tag(name = "绠$悊鍚庡彴 - MES 鑳借�楄閲忕偣")
+@RestController
+@RequestMapping("/mes/em/meter")
+@Validated
+public class MesEmMeterController {
+
+ @Resource
+ private MesEmMeterService meterService;
+
+ @PostMapping("/create")
+ @Operation(summary = "鍒涘缓鑳借�楄閲忕偣")
+ @PreAuthorize("@ss.hasPermission('mes:em-meter:create')")
+ public CommonResult<Long> createMeter(@Valid @RequestBody MesEmMeterSaveReqVO createReqVO) {
+ return success(meterService.createMeter(createReqVO));
+ }
+
+ @PutMapping("/update")
+ @Operation(summary = "鏇存柊鑳借�楄閲忕偣")
+ @PreAuthorize("@ss.hasPermission('mes:em-meter:update')")
+ public CommonResult<Boolean> updateMeter(@Valid @RequestBody MesEmMeterSaveReqVO updateReqVO) {
+ meterService.updateMeter(updateReqVO);
+ return success(true);
+ }
+
+ @DeleteMapping("/delete")
+ @Operation(summary = "鍒犻櫎鑳借�楄閲忕偣")
+ @Parameter(name = "id", description = "缂栧彿", required = true)
+ @PreAuthorize("@ss.hasPermission('mes:em-meter:delete')")
+ public CommonResult<Boolean> deleteMeter(@RequestParam("id") Long id) {
+ meterService.deleteMeter(id);
+ return success(true);
+ }
+
+ @GetMapping("/get")
+ @Operation(summary = "鑾峰緱鑳借�楄閲忕偣")
+ @Parameter(name = "id", description = "缂栧彿", required = true)
+ @PreAuthorize("@ss.hasPermission('mes:em-meter:query')")
+ public CommonResult<MesEmMeterRespVO> getMeter(@RequestParam("id") Long id) {
+ MesEmMeterDO meter = meterService.getMeter(id);
+ if (meter == null) {
+ return success(null);
+ }
+ return success(meterService.getMeterRespVOList(Collections.singletonList(meter)).get(0));
+ }
+
+ @GetMapping("/page")
+ @Operation(summary = "鑾峰緱鑳借�楄閲忕偣鍒嗛〉")
+ @PreAuthorize("@ss.hasPermission('mes:em-meter:query')")
+ public CommonResult<PageResult<MesEmMeterRespVO>> getMeterPage(@Valid MesEmMeterPageReqVO pageReqVO) {
+ PageResult<MesEmMeterDO> pageResult = meterService.getMeterPage(pageReqVO);
+ return success(new PageResult<>(meterService.getMeterRespVOList(pageResult.getList()),
+ pageResult.getTotal()));
+ }
+
+ @GetMapping("/simple-list")
+ @Operation(summary = "鑾峰緱鍚敤涓殑鑳借�楄閲忕偣绮剧畝鍒楄〃")
+ @PreAuthorize("@ss.hasPermission('mes:em-meter:query')")
+ public CommonResult<List<MesEmOptionRespVO>> getMeterSimpleList() {
+ return success(meterService.getMeterSimpleList());
+ }
+
+ @GetMapping("/workshop-options")
+ @Operation(summary = "鑾峰緱杞﹂棿涓嬫媺閫夐」")
+ @PreAuthorize("@ss.hasPermission('mes:em-meter:query')")
+ public CommonResult<List<MesEmOptionRespVO>> getWorkshopOptions() {
+ return success(meterService.getWorkshopOptions());
+ }
+
+ @GetMapping("/line-options")
+ @Operation(summary = "鑾峰緱浜х嚎涓嬫媺閫夐」")
+ @PreAuthorize("@ss.hasPermission('mes:em-meter:query')")
+ public CommonResult<List<MesEmOptionRespVO>> getLineOptions() {
+ return success(meterService.getLineOptions());
+ }
+
+ @GetMapping("/machinery-options")
+ @Operation(summary = "鑾峰緱璁惧涓嬫媺閫夐」")
+ @PreAuthorize("@ss.hasPermission('mes:em-meter:query')")
+ public CommonResult<List<MesEmOptionRespVO>> getMachineryOptions() {
+ return success(meterService.getMachineryOptions());
+ }
+
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/em/meter/vo/MesEmMeterPageReqVO.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/em/meter/vo/MesEmMeterPageReqVO.java
new file mode 100644
index 0000000..6f80b34
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/em/meter/vo/MesEmMeterPageReqVO.java
@@ -0,0 +1,30 @@
+package cn.iocoder.yudao.module.mes.controller.admin.em.meter.vo;
+
+import cn.iocoder.yudao.framework.common.pojo.PageParam;
+import io.swagger.v3.oas.annotations.media.Schema;
+import lombok.Data;
+import lombok.EqualsAndHashCode;
+import lombok.ToString;
+
+@Schema(description = "绠$悊鍚庡彴 - MES 鑳借�楄閲忕偣鍒嗛〉 Request VO")
+@Data
+@EqualsAndHashCode(callSuper = true)
+@ToString(callSuper = true)
+public class MesEmMeterPageReqVO extends PageParam {
+
+ @Schema(description = "璁¢噺鐐圭紪鐮�", example = "EM-DL-001")
+ private String code;
+
+ @Schema(description = "璁¢噺鐐瑰悕绉�", example = "鍙樺帇鍣ㄨ溅闂存�荤數琛�")
+ private String name;
+
+ @Schema(description = "鑳芥簮绫诲瀷", example = "1")
+ private Integer energyType;
+
+ @Schema(description = "鎵�灞炶溅闂寸紪鍙�", example = "7")
+ private Long workshopId;
+
+ @Schema(description = "鐘舵��", example = "1")
+ private Integer status;
+
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/em/meter/vo/MesEmMeterRespVO.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/em/meter/vo/MesEmMeterRespVO.java
new file mode 100644
index 0000000..4886b6e
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/em/meter/vo/MesEmMeterRespVO.java
@@ -0,0 +1,86 @@
+package cn.iocoder.yudao.module.mes.controller.admin.em.meter.vo;
+
+import io.swagger.v3.oas.annotations.media.Schema;
+import lombok.Data;
+
+import java.math.BigDecimal;
+import java.time.LocalDate;
+import java.time.LocalDateTime;
+
+@Schema(description = "绠$悊鍚庡彴 - MES 鑳借�楄閲忕偣 Response VO")
+@Data
+public class MesEmMeterRespVO {
+
+ @Schema(description = "缂栧彿", requiredMode = Schema.RequiredMode.REQUIRED, example = "1024")
+ private Long id;
+
+ @Schema(description = "璁¢噺鐐圭紪鐮�", requiredMode = Schema.RequiredMode.REQUIRED, example = "EM-DL-001")
+ private String code;
+
+ @Schema(description = "璁¢噺鐐瑰悕绉�", requiredMode = Schema.RequiredMode.REQUIRED, example = "鍙樺帇鍣ㄨ溅闂存�荤數琛�")
+ private String name;
+
+ @Schema(description = "鑳芥簮绫诲瀷", requiredMode = Schema.RequiredMode.REQUIRED, example = "1")
+ private Integer energyType;
+
+ @Schema(description = "鑳芥簮绫诲瀷鍚嶇О", example = "鐢�")
+ private String energyTypeName;
+
+ @Schema(description = "璁¢噺鍗曚綅", example = "kWh")
+ private String unit;
+
+ @Schema(description = "琛ㄥ彿", example = "DTSD341-001")
+ private String meterNo;
+
+ @Schema(description = "鎵�灞炶溅闂寸紪鍙�", example = "7")
+ private Long workshopId;
+
+ @Schema(description = "鎵�灞炶溅闂村悕绉�", example = "鍙樺帇鍣ㄥ埗閫犺溅闂�")
+ private String workshopName;
+
+ @Schema(description = "鎵�灞炰骇绾跨紪鍙�", example = "1")
+ private Long lineId;
+
+ @Schema(description = "鎵�灞炰骇绾垮悕绉�", example = "鍙樺帇鍣ㄧ敓浜х嚎")
+ private String lineName;
+
+ @Schema(description = "鍏宠仈璁惧缂栧彿", example = "1001")
+ private Long machineryId;
+
+ @Schema(description = "鍏宠仈璁惧鍚嶇О", example = "鐪熺┖娴囨敞缃�")
+ private String machineryName;
+
+ @Schema(description = "鍊嶇巼", example = "1")
+ private BigDecimal ratio;
+
+ @Schema(description = "鍒濆璇绘暟", example = "0")
+ private BigDecimal initialReading;
+
+ @Schema(description = "鎶樻爣鐓ょ郴鏁帮紙kgce/璁¢噺鍗曚綅锛�", example = "0.1229")
+ private BigDecimal coalFactor;
+
+ @Schema(description = "鏃ョ敤閲忓紓甯镐笂闄�", example = "500")
+ private BigDecimal leakThreshold;
+
+ @Schema(description = "璐d换浜虹紪鍙�", example = "1")
+ private Long chargeUserId;
+
+ @Schema(description = "璐d换浜哄悕绉�", example = "寮犱笁")
+ private String chargeUserName;
+
+ @Schema(description = "鎶曠敤鏃ユ湡")
+ private LocalDate installDate;
+
+ @Schema(description = "鐘舵��", requiredMode = Schema.RequiredMode.REQUIRED, example = "1")
+ private Integer status;
+
+ @Schema(description = "鐘舵�佸悕绉�", example = "鍚敤")
+ private String statusName;
+
+ @Schema(description = "澶囨敞", example = "澶囨敞")
+ private String remark;
+
+ @Schema(description = "鍒涘缓鏃堕棿")
+ private LocalDateTime createTime;
+
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/em/meter/vo/MesEmMeterSaveReqVO.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/em/meter/vo/MesEmMeterSaveReqVO.java
new file mode 100644
index 0000000..8021608
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/em/meter/vo/MesEmMeterSaveReqVO.java
@@ -0,0 +1,70 @@
+package cn.iocoder.yudao.module.mes.controller.admin.em.meter.vo;
+
+import io.swagger.v3.oas.annotations.media.Schema;
+import jakarta.validation.constraints.NotEmpty;
+import jakarta.validation.constraints.NotNull;
+import lombok.Data;
+
+import java.math.BigDecimal;
+import java.time.LocalDate;
+
+@Schema(description = "绠$悊鍚庡彴 - MES 鑳借�楄閲忕偣鏂板/淇敼 Request VO")
+@Data
+public class MesEmMeterSaveReqVO {
+
+ @Schema(description = "缂栧彿", example = "1024")
+ private Long id;
+
+ @Schema(description = "璁¢噺鐐圭紪鐮�", requiredMode = Schema.RequiredMode.REQUIRED, example = "EM-DL-001")
+ @NotEmpty(message = "璁¢噺鐐圭紪鐮佷笉鑳戒负绌�")
+ private String code;
+
+ @Schema(description = "璁¢噺鐐瑰悕绉�", requiredMode = Schema.RequiredMode.REQUIRED, example = "鍙樺帇鍣ㄨ溅闂存�荤數琛�")
+ @NotEmpty(message = "璁¢噺鐐瑰悕绉颁笉鑳戒负绌�")
+ private String name;
+
+ @Schema(description = "鑳芥簮绫诲瀷", requiredMode = Schema.RequiredMode.REQUIRED, example = "1")
+ @NotNull(message = "鑳芥簮绫诲瀷涓嶈兘涓虹┖")
+ private Integer energyType;
+
+ @Schema(description = "璁¢噺鍗曚綅", example = "kWh")
+ private String unit;
+
+ @Schema(description = "琛ㄥ彿", example = "DTSD341-001")
+ private String meterNo;
+
+ @Schema(description = "鎵�灞炶溅闂寸紪鍙�", example = "7")
+ private Long workshopId;
+
+ @Schema(description = "鎵�灞炰骇绾跨紪鍙�", example = "1")
+ private Long lineId;
+
+ @Schema(description = "鍏宠仈璁惧缂栧彿", example = "1001")
+ private Long machineryId;
+
+ @Schema(description = "鍊嶇巼", example = "1")
+ private BigDecimal ratio;
+
+ @Schema(description = "鍒濆璇绘暟", example = "0")
+ private BigDecimal initialReading;
+
+ @Schema(description = "鎶樻爣鐓ょ郴鏁帮紙kgce/璁¢噺鍗曚綅锛�", example = "0.1229")
+ private BigDecimal coalFactor;
+
+ @Schema(description = "鏃ョ敤閲忓紓甯镐笂闄愶紙瓒呰繃瑙﹀彂鐤戜技璺戝啋婊存紡棰勮锛�", example = "500")
+ private BigDecimal leakThreshold;
+
+ @Schema(description = "璐d换浜虹紪鍙�", example = "1")
+ private Long chargeUserId;
+
+ @Schema(description = "鎶曠敤鏃ユ湡")
+ private LocalDate installDate;
+
+ @Schema(description = "鐘舵��", requiredMode = Schema.RequiredMode.REQUIRED, example = "1")
+ @NotNull(message = "鐘舵�佷笉鑳戒负绌�")
+ private Integer status;
+
+ @Schema(description = "澶囨敞", example = "澶囨敞")
+ private String remark;
+
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/em/meter/vo/MesEmOptionRespVO.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/em/meter/vo/MesEmOptionRespVO.java
new file mode 100644
index 0000000..9a9e230
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/em/meter/vo/MesEmOptionRespVO.java
@@ -0,0 +1,44 @@
+package cn.iocoder.yudao.module.mes.controller.admin.em.meter.vo;
+
+import io.swagger.v3.oas.annotations.media.Schema;
+import lombok.Data;
+
+/**
+ * 鑳借�楁ā鍧椾笅鎷夐�夐」 VO
+ *
+ * 鍚屾椂鐢ㄤ簬杞﹂棿銆佷骇绾裤�佽澶囥�佽閲忕偣鐨勪笅鎷夐�夋嫨銆�
+ *
+ * @author 瓒呯骇绠$悊鍛�
+ */
+@Schema(description = "绠$悊鍚庡彴 - MES 鑳借�椾笅鎷夐�夐」 Response VO")
+@Data
+public class MesEmOptionRespVO {
+
+ @Schema(description = "缂栧彿")
+ private Long id;
+
+ @Schema(description = "缂栫爜")
+ private String code;
+
+ @Schema(description = "鍚嶇О")
+ private String name;
+
+ @Schema(description = "鑳芥簮绫诲瀷锛堣閲忕偣閫夐」浣跨敤锛�")
+ private Integer energyType;
+
+ @Schema(description = "璁¢噺鍗曚綅锛堣閲忕偣閫夐」浣跨敤锛�")
+ private String unit;
+
+ @Schema(description = "鎵�灞炶溅闂寸紪鍙�")
+ private Long workshopId;
+
+ @Schema(description = "鎵�灞炶溅闂村悕绉�")
+ private String workshopName;
+
+ @Schema(description = "鎵�灞炰骇绾跨紪鍙�")
+ private Long lineId;
+
+ @Schema(description = "鎵�灞炰骇绾垮悕绉�")
+ private String lineName;
+
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/em/quota/MesEmQuotaController.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/em/quota/MesEmQuotaController.java
new file mode 100644
index 0000000..cd2930b
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/em/quota/MesEmQuotaController.java
@@ -0,0 +1,77 @@
+package cn.iocoder.yudao.module.mes.controller.admin.em.quota;
+
+import cn.iocoder.yudao.framework.common.pojo.CommonResult;
+import cn.iocoder.yudao.framework.common.pojo.PageResult;
+import cn.iocoder.yudao.module.mes.controller.admin.em.quota.vo.MesEmQuotaPageReqVO;
+import cn.iocoder.yudao.module.mes.controller.admin.em.quota.vo.MesEmQuotaRespVO;
+import cn.iocoder.yudao.module.mes.controller.admin.em.quota.vo.MesEmQuotaSaveReqVO;
+import cn.iocoder.yudao.module.mes.dal.dataobject.em.quota.MesEmQuotaDO;
+import cn.iocoder.yudao.module.mes.service.em.quota.MesEmQuotaService;
+import io.swagger.v3.oas.annotations.Operation;
+import io.swagger.v3.oas.annotations.Parameter;
+import io.swagger.v3.oas.annotations.tags.Tag;
+import jakarta.annotation.Resource;
+import jakarta.validation.Valid;
+import org.springframework.security.access.prepost.PreAuthorize;
+import org.springframework.validation.annotation.Validated;
+import org.springframework.web.bind.annotation.*;
+
+import java.util.Collections;
+
+import static cn.iocoder.yudao.framework.common.pojo.CommonResult.success;
+
+@Tag(name = "绠$悊鍚庡彴 - MES 鑳借�楄�冩牳鎸囨爣")
+@RestController
+@RequestMapping("/mes/em/quota")
+@Validated
+public class MesEmQuotaController {
+
+ @Resource
+ private MesEmQuotaService quotaService;
+
+ @PostMapping("/create")
+ @Operation(summary = "鍒涘缓鑳借�楄�冩牳鎸囨爣")
+ @PreAuthorize("@ss.hasPermission('mes:em-quota:create')")
+ public CommonResult<Long> createQuota(@Valid @RequestBody MesEmQuotaSaveReqVO createReqVO) {
+ return success(quotaService.createQuota(createReqVO));
+ }
+
+ @PutMapping("/update")
+ @Operation(summary = "鏇存柊鑳借�楄�冩牳鎸囨爣")
+ @PreAuthorize("@ss.hasPermission('mes:em-quota:update')")
+ public CommonResult<Boolean> updateQuota(@Valid @RequestBody MesEmQuotaSaveReqVO updateReqVO) {
+ quotaService.updateQuota(updateReqVO);
+ return success(true);
+ }
+
+ @DeleteMapping("/delete")
+ @Operation(summary = "鍒犻櫎鑳借�楄�冩牳鎸囨爣")
+ @Parameter(name = "id", description = "缂栧彿", required = true)
+ @PreAuthorize("@ss.hasPermission('mes:em-quota:delete')")
+ public CommonResult<Boolean> deleteQuota(@RequestParam("id") Long id) {
+ quotaService.deleteQuota(id);
+ return success(true);
+ }
+
+ @GetMapping("/get")
+ @Operation(summary = "鑾峰緱鑳借�楄�冩牳鎸囨爣")
+ @Parameter(name = "id", description = "缂栧彿", required = true)
+ @PreAuthorize("@ss.hasPermission('mes:em-quota:query')")
+ public CommonResult<MesEmQuotaRespVO> getQuota(@RequestParam("id") Long id) {
+ MesEmQuotaDO quota = quotaService.getQuota(id);
+ if (quota == null) {
+ return success(null);
+ }
+ return success(quotaService.getQuotaRespVOList(Collections.singletonList(quota)).get(0));
+ }
+
+ @GetMapping("/page")
+ @Operation(summary = "鑾峰緱鑳借�楄�冩牳鎸囨爣鍒嗛〉")
+ @PreAuthorize("@ss.hasPermission('mes:em-quota:query')")
+ public CommonResult<PageResult<MesEmQuotaRespVO>> getQuotaPage(@Valid MesEmQuotaPageReqVO pageReqVO) {
+ PageResult<MesEmQuotaDO> pageResult = quotaService.getQuotaPage(pageReqVO);
+ return success(new PageResult<>(quotaService.getQuotaRespVOList(pageResult.getList()),
+ pageResult.getTotal()));
+ }
+
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/em/quota/vo/MesEmQuotaPageReqVO.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/em/quota/vo/MesEmQuotaPageReqVO.java
new file mode 100644
index 0000000..6925aee
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/em/quota/vo/MesEmQuotaPageReqVO.java
@@ -0,0 +1,30 @@
+package cn.iocoder.yudao.module.mes.controller.admin.em.quota.vo;
+
+import cn.iocoder.yudao.framework.common.pojo.PageParam;
+import io.swagger.v3.oas.annotations.media.Schema;
+import lombok.Data;
+import lombok.EqualsAndHashCode;
+import lombok.ToString;
+
+@Schema(description = "绠$悊鍚庡彴 - MES 鑳借�楄�冩牳鎸囨爣鍒嗛〉 Request VO")
+@Data
+@EqualsAndHashCode(callSuper = true)
+@ToString(callSuper = true)
+public class MesEmQuotaPageReqVO extends PageParam {
+
+ @Schema(description = "鎸囨爣鍚嶇О", example = "鍙樺帇鍣ㄨ溅闂寸敤鐢垫棩瀹氶")
+ private String name;
+
+ @Schema(description = "鑳芥簮绫诲瀷", example = "1")
+ private Integer energyType;
+
+ @Schema(description = "鑰冩牳瀵硅薄绫诲瀷", example = "1")
+ private Integer objectType;
+
+ @Schema(description = "鑰冩牳鍛ㄦ湡", example = "1")
+ private Integer periodType;
+
+ @Schema(description = "鐘舵��", example = "1")
+ private Integer status;
+
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/em/quota/vo/MesEmQuotaRespVO.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/em/quota/vo/MesEmQuotaRespVO.java
new file mode 100644
index 0000000..62140c5
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/em/quota/vo/MesEmQuotaRespVO.java
@@ -0,0 +1,73 @@
+package cn.iocoder.yudao.module.mes.controller.admin.em.quota.vo;
+
+import io.swagger.v3.oas.annotations.media.Schema;
+import lombok.Data;
+
+import java.math.BigDecimal;
+import java.time.LocalDateTime;
+
+@Schema(description = "绠$悊鍚庡彴 - MES 鑳借�楄�冩牳鎸囨爣 Response VO")
+@Data
+public class MesEmQuotaRespVO {
+
+ @Schema(description = "缂栧彿", requiredMode = Schema.RequiredMode.REQUIRED, example = "1024")
+ private Long id;
+
+ @Schema(description = "鎸囨爣鍚嶇О", requiredMode = Schema.RequiredMode.REQUIRED, example = "鍙樺帇鍣ㄨ溅闂寸敤鐢垫棩瀹氶")
+ private String name;
+
+ @Schema(description = "鑳芥簮绫诲瀷", example = "1")
+ private Integer energyType;
+
+ @Schema(description = "鑳芥簮绫诲瀷鍚嶇О", example = "鐢�")
+ private String energyTypeName;
+
+ @Schema(description = "鑰冩牳瀵硅薄绫诲瀷", example = "1")
+ private Integer objectType;
+
+ @Schema(description = "鑰冩牳瀵硅薄绫诲瀷鍚嶇О", example = "杞﹂棿")
+ private String objectTypeName;
+
+ @Schema(description = "鑰冩牳瀵硅薄缂栧彿", example = "7")
+ private Long objectId;
+
+ @Schema(description = "鑰冩牳瀵硅薄鍚嶇О", example = "鍙樺帇鍣ㄥ埗閫犺溅闂�")
+ private String objectName;
+
+ @Schema(description = "鑰冩牳鍛ㄦ湡", example = "1")
+ private Integer periodType;
+
+ @Schema(description = "鑰冩牳鍛ㄦ湡鍚嶇О", example = "鏃�")
+ private String periodTypeName;
+
+ @Schema(description = "瀹氶鍊�", example = "1000")
+ private BigDecimal quotaValue;
+
+ @Schema(description = "璁¢噺鍗曚綅", example = "kWh")
+ private String unit;
+
+ @Schema(description = "棰勮姣斾緥锛�%锛�", example = "10")
+ private BigDecimal warnRatio;
+
+ @Schema(description = "涓ラ噸棰勮姣斾緥锛�%锛�", example = "20")
+ private BigDecimal alarmRatio;
+
+ @Schema(description = "鐜瘮寮傚父闃堝�硷紙%锛�", example = "30")
+ private BigDecimal momWarnRatio;
+
+ @Schema(description = "鍚屾瘮寮傚父闃堝�硷紙%锛�", example = "30")
+ private BigDecimal yoyWarnRatio;
+
+ @Schema(description = "鐘舵��", example = "1")
+ private Integer status;
+
+ @Schema(description = "鐘舵�佸悕绉�", example = "鍚敤")
+ private String statusName;
+
+ @Schema(description = "澶囨敞")
+ private String remark;
+
+ @Schema(description = "鍒涘缓鏃堕棿")
+ private LocalDateTime createTime;
+
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/em/quota/vo/MesEmQuotaSaveReqVO.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/em/quota/vo/MesEmQuotaSaveReqVO.java
new file mode 100644
index 0000000..70ee2c6
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/em/quota/vo/MesEmQuotaSaveReqVO.java
@@ -0,0 +1,64 @@
+package cn.iocoder.yudao.module.mes.controller.admin.em.quota.vo;
+
+import io.swagger.v3.oas.annotations.media.Schema;
+import jakarta.validation.constraints.DecimalMin;
+import jakarta.validation.constraints.NotEmpty;
+import jakarta.validation.constraints.NotNull;
+import lombok.Data;
+
+import java.math.BigDecimal;
+
+@Schema(description = "绠$悊鍚庡彴 - MES 鑳借�楄�冩牳鎸囨爣鏂板/淇敼 Request VO")
+@Data
+public class MesEmQuotaSaveReqVO {
+
+ @Schema(description = "缂栧彿", example = "1024")
+ private Long id;
+
+ @Schema(description = "鎸囨爣鍚嶇О", requiredMode = Schema.RequiredMode.REQUIRED, example = "鍙樺帇鍣ㄨ溅闂寸敤鐢垫棩瀹氶")
+ @NotEmpty(message = "鎸囨爣鍚嶇О涓嶈兘涓虹┖")
+ private String name;
+
+ @Schema(description = "鑳芥簮绫诲瀷", requiredMode = Schema.RequiredMode.REQUIRED, example = "1")
+ @NotNull(message = "鑳芥簮绫诲瀷涓嶈兘涓虹┖")
+ private Integer energyType;
+
+ @Schema(description = "鑰冩牳瀵硅薄绫诲瀷", requiredMode = Schema.RequiredMode.REQUIRED, example = "1")
+ @NotNull(message = "鑰冩牳瀵硅薄绫诲瀷涓嶈兘涓虹┖")
+ private Integer objectType;
+
+ @Schema(description = "鑰冩牳瀵硅薄缂栧彿锛堝叏鍘傛椂涓虹┖锛�", example = "7")
+ private Long objectId;
+
+ @Schema(description = "鑰冩牳鍛ㄦ湡", requiredMode = Schema.RequiredMode.REQUIRED, example = "1")
+ @NotNull(message = "鑰冩牳鍛ㄦ湡涓嶈兘涓虹┖")
+ private Integer periodType;
+
+ @Schema(description = "瀹氶鍊�", requiredMode = Schema.RequiredMode.REQUIRED, example = "1000")
+ @NotNull(message = "瀹氶鍊间笉鑳戒负绌�")
+ @DecimalMin(value = "0", message = "瀹氶鍊间笉鑳藉皬浜� 0")
+ private BigDecimal quotaValue;
+
+ @Schema(description = "璁¢噺鍗曚綅", example = "kWh")
+ private String unit;
+
+ @Schema(description = "棰勮姣斾緥锛�%锛�", example = "10")
+ private BigDecimal warnRatio;
+
+ @Schema(description = "涓ラ噸棰勮姣斾緥锛�%锛�", example = "20")
+ private BigDecimal alarmRatio;
+
+ @Schema(description = "鐜瘮寮傚父闃堝�硷紙%锛�", example = "30")
+ private BigDecimal momWarnRatio;
+
+ @Schema(description = "鍚屾瘮寮傚父闃堝�硷紙%锛�", example = "30")
+ private BigDecimal yoyWarnRatio;
+
+ @Schema(description = "鐘舵��", requiredMode = Schema.RequiredMode.REQUIRED, example = "1")
+ @NotNull(message = "鐘舵�佷笉鑳戒负绌�")
+ private Integer status;
+
+ @Schema(description = "澶囨敞")
+ private String remark;
+
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/em/record/MesEmRecordController.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/em/record/MesEmRecordController.java
new file mode 100644
index 0000000..140f1d3
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/em/record/MesEmRecordController.java
@@ -0,0 +1,90 @@
+package cn.iocoder.yudao.module.mes.controller.admin.em.record;
+
+import cn.iocoder.yudao.framework.common.pojo.CommonResult;
+import cn.iocoder.yudao.framework.common.pojo.PageResult;
+import cn.iocoder.yudao.module.mes.controller.admin.em.record.vo.MesEmLastReadingRespVO;
+import cn.iocoder.yudao.module.mes.controller.admin.em.record.vo.MesEmRecordPageReqVO;
+import cn.iocoder.yudao.module.mes.controller.admin.em.record.vo.MesEmRecordRespVO;
+import cn.iocoder.yudao.module.mes.controller.admin.em.record.vo.MesEmRecordSaveReqVO;
+import cn.iocoder.yudao.module.mes.dal.dataobject.em.record.MesEmRecordDO;
+import cn.iocoder.yudao.module.mes.service.em.record.MesEmRecordService;
+import io.swagger.v3.oas.annotations.Operation;
+import io.swagger.v3.oas.annotations.Parameter;
+import io.swagger.v3.oas.annotations.tags.Tag;
+import jakarta.annotation.Resource;
+import jakarta.validation.Valid;
+import org.springframework.format.annotation.DateTimeFormat;
+import org.springframework.security.access.prepost.PreAuthorize;
+import org.springframework.validation.annotation.Validated;
+import org.springframework.web.bind.annotation.*;
+
+import java.time.LocalDate;
+import java.util.Collections;
+
+import static cn.iocoder.yudao.framework.common.pojo.CommonResult.success;
+
+@Tag(name = "绠$悊鍚庡彴 - MES 鑳借�楁妱琛ㄨ褰�")
+@RestController
+@RequestMapping("/mes/em/record")
+@Validated
+public class MesEmRecordController {
+
+ @Resource
+ private MesEmRecordService recordService;
+
+ @PostMapping("/create")
+ @Operation(summary = "鍒涘缓鑳借�楁妱琛ㄨ褰�")
+ @PreAuthorize("@ss.hasPermission('mes:em-record:create')")
+ public CommonResult<Long> createRecord(@Valid @RequestBody MesEmRecordSaveReqVO createReqVO) {
+ return success(recordService.createRecord(createReqVO));
+ }
+
+ @PutMapping("/update")
+ @Operation(summary = "鏇存柊鑳借�楁妱琛ㄨ褰�")
+ @PreAuthorize("@ss.hasPermission('mes:em-record:update')")
+ public CommonResult<Boolean> updateRecord(@Valid @RequestBody MesEmRecordSaveReqVO updateReqVO) {
+ recordService.updateRecord(updateReqVO);
+ return success(true);
+ }
+
+ @DeleteMapping("/delete")
+ @Operation(summary = "鍒犻櫎鑳借�楁妱琛ㄨ褰�")
+ @Parameter(name = "id", description = "缂栧彿", required = true)
+ @PreAuthorize("@ss.hasPermission('mes:em-record:delete')")
+ public CommonResult<Boolean> deleteRecord(@RequestParam("id") Long id) {
+ recordService.deleteRecord(id);
+ return success(true);
+ }
+
+ @GetMapping("/get")
+ @Operation(summary = "鑾峰緱鑳借�楁妱琛ㄨ褰�")
+ @Parameter(name = "id", description = "缂栧彿", required = true)
+ @PreAuthorize("@ss.hasPermission('mes:em-record:query')")
+ public CommonResult<MesEmRecordRespVO> getRecord(@RequestParam("id") Long id) {
+ MesEmRecordDO record = recordService.getRecord(id);
+ if (record == null) {
+ return success(null);
+ }
+ return success(recordService.getRecordRespVOList(Collections.singletonList(record)).get(0));
+ }
+
+ @GetMapping("/page")
+ @Operation(summary = "鑾峰緱鑳借�楁妱琛ㄨ褰曞垎椤�")
+ @PreAuthorize("@ss.hasPermission('mes:em-record:query')")
+ public CommonResult<PageResult<MesEmRecordRespVO>> getRecordPage(@Valid MesEmRecordPageReqVO pageReqVO) {
+ PageResult<MesEmRecordDO> pageResult = recordService.getRecordPage(pageReqVO);
+ return success(new PageResult<>(recordService.getRecordRespVOList(pageResult.getList()),
+ pageResult.getTotal()));
+ }
+
+ @GetMapping("/last-reading")
+ @Operation(summary = "鑾峰緱璁¢噺鐐逛笂鏈熻鏁�", description = "鐢ㄤ簬鏂板鎶勮〃璁板綍鏃惰嚜鍔ㄥ甫鍏ユ湡鍒濊鏁�")
+ @PreAuthorize("@ss.hasPermission('mes:em-record:query')")
+ public CommonResult<MesEmLastReadingRespVO> getLastReading(
+ @RequestParam("meterId") Long meterId,
+ @RequestParam("recordDate") @DateTimeFormat(iso = DateTimeFormat.ISO.DATE) LocalDate recordDate,
+ @RequestParam(value = "excludeId", required = false) Long excludeId) {
+ return success(recordService.getLastReading(meterId, recordDate, excludeId));
+ }
+
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/em/record/vo/MesEmLastReadingRespVO.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/em/record/vo/MesEmLastReadingRespVO.java
new file mode 100644
index 0000000..59307cc
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/em/record/vo/MesEmLastReadingRespVO.java
@@ -0,0 +1,23 @@
+package cn.iocoder.yudao.module.mes.controller.admin.em.record.vo;
+
+import io.swagger.v3.oas.annotations.media.Schema;
+import lombok.AllArgsConstructor;
+import lombok.Data;
+import lombok.NoArgsConstructor;
+
+import java.math.BigDecimal;
+import java.time.LocalDate;
+
+@Schema(description = "绠$悊鍚庡彴 - MES 鑳借�椾笂鏈熻鏁� Response VO")
+@Data
+@NoArgsConstructor
+@AllArgsConstructor
+public class MesEmLastReadingRespVO {
+
+ @Schema(description = "涓婃湡璇绘暟", example = "1000")
+ private BigDecimal prevReading;
+
+ @Schema(description = "涓婃湡鎶勮〃鏃ユ湡")
+ private LocalDate lastDate;
+
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/em/record/vo/MesEmRecordPageReqVO.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/em/record/vo/MesEmRecordPageReqVO.java
new file mode 100644
index 0000000..c7706ca
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/em/record/vo/MesEmRecordPageReqVO.java
@@ -0,0 +1,39 @@
+package cn.iocoder.yudao.module.mes.controller.admin.em.record.vo;
+
+import cn.iocoder.yudao.framework.common.pojo.PageParam;
+import io.swagger.v3.oas.annotations.media.Schema;
+import lombok.Data;
+import lombok.EqualsAndHashCode;
+import lombok.ToString;
+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 = "绠$悊鍚庡彴 - MES 鑳借�楁妱琛ㄨ褰曞垎椤� Request VO")
+@Data
+@EqualsAndHashCode(callSuper = true)
+@ToString(callSuper = true)
+public class MesEmRecordPageReqVO extends PageParam {
+
+ @Schema(description = "璁¢噺鐐圭紪鍙�", example = "1024")
+ private Long meterId;
+
+ @Schema(description = "璁¢噺鐐瑰悕绉�", example = "鍙樺帇鍣ㄨ溅闂存�荤數琛�")
+ private String meterName;
+
+ @Schema(description = "鑳芥簮绫诲瀷", example = "1")
+ private Integer energyType;
+
+ @Schema(description = "鎵�灞炶溅闂寸紪鍙�", example = "7")
+ private Long workshopId;
+
+ @Schema(description = "鏁版嵁鏉ユ簮", example = "1")
+ private Integer source;
+
+ @Schema(description = "鎶勮〃鏃ユ湡")
+ @DateTimeFormat(pattern = FORMAT_YEAR_MONTH_DAY)
+ private LocalDate[] recordDate;
+
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/em/record/vo/MesEmRecordRespVO.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/em/record/vo/MesEmRecordRespVO.java
new file mode 100644
index 0000000..f8ef47b
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/em/record/vo/MesEmRecordRespVO.java
@@ -0,0 +1,89 @@
+package cn.iocoder.yudao.module.mes.controller.admin.em.record.vo;
+
+import io.swagger.v3.oas.annotations.media.Schema;
+import lombok.Data;
+
+import java.math.BigDecimal;
+import java.time.LocalDate;
+import java.time.LocalDateTime;
+
+@Schema(description = "绠$悊鍚庡彴 - MES 鑳借�楁妱琛ㄨ褰� Response VO")
+@Data
+public class MesEmRecordRespVO {
+
+ @Schema(description = "缂栧彿", requiredMode = Schema.RequiredMode.REQUIRED, example = "1024")
+ private Long id;
+
+ @Schema(description = "璁¢噺鐐圭紪鍙�", requiredMode = Schema.RequiredMode.REQUIRED, example = "1024")
+ private Long meterId;
+
+ @Schema(description = "璁¢噺鐐圭紪鐮�", example = "EM-DL-001")
+ private String meterCode;
+
+ @Schema(description = "璁¢噺鐐瑰悕绉�", example = "鍙樺帇鍣ㄨ溅闂存�荤數琛�")
+ private String meterName;
+
+ @Schema(description = "鑳芥簮绫诲瀷", example = "1")
+ private Integer energyType;
+
+ @Schema(description = "鑳芥簮绫诲瀷鍚嶇О", example = "鐢�")
+ private String energyTypeName;
+
+ @Schema(description = "璁¢噺鍗曚綅", example = "kWh")
+ private String unit;
+
+ @Schema(description = "鍊嶇巼", example = "1")
+ private BigDecimal ratio;
+
+ @Schema(description = "鎶樻爣鐓ょ郴鏁�", example = "0.1229")
+ private BigDecimal coalFactor;
+
+ @Schema(description = "鎵�灞炶溅闂寸紪鍙�", example = "7")
+ private Long workshopId;
+
+ @Schema(description = "鎵�灞炶溅闂村悕绉�", example = "鍙樺帇鍣ㄥ埗閫犺溅闂�")
+ private String workshopName;
+
+ @Schema(description = "鎵�灞炰骇绾跨紪鍙�", example = "1")
+ private Long lineId;
+
+ @Schema(description = "鎵�灞炰骇绾垮悕绉�", example = "鍙樺帇鍣ㄧ敓浜х嚎")
+ private String lineName;
+
+ @Schema(description = "鍏宠仈璁惧缂栧彿", example = "1001")
+ private Long machineryId;
+
+ @Schema(description = "鍏宠仈璁惧鍚嶇О", example = "鐪熺┖娴囨敞缃�")
+ private String machineryName;
+
+ @Schema(description = "鎶勮〃鏃ユ湡", requiredMode = Schema.RequiredMode.REQUIRED)
+ private LocalDate recordDate;
+
+ @Schema(description = "鏈熷垵璇绘暟", example = "1000")
+ private BigDecimal prevReading;
+
+ @Schema(description = "鏈熸湯璇绘暟", example = "1200")
+ private BigDecimal reading;
+
+ @Schema(description = "瀹為檯鐢ㄩ噺", example = "200")
+ private BigDecimal usageAmount;
+
+ @Schema(description = "鍗曚环", example = "0.68")
+ private BigDecimal price;
+
+ @Schema(description = "璐圭敤", example = "136")
+ private BigDecimal cost;
+
+ @Schema(description = "鏁版嵁鏉ユ簮", example = "1")
+ private Integer source;
+
+ @Schema(description = "鏁版嵁鏉ユ簮鍚嶇О", example = "鎵嬪伐褰曞叆")
+ private String sourceName;
+
+ @Schema(description = "澶囨敞")
+ private String remark;
+
+ @Schema(description = "鍒涘缓鏃堕棿")
+ private LocalDateTime createTime;
+
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/em/record/vo/MesEmRecordSaveReqVO.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/em/record/vo/MesEmRecordSaveReqVO.java
new file mode 100644
index 0000000..7e2b9d7
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/em/record/vo/MesEmRecordSaveReqVO.java
@@ -0,0 +1,41 @@
+package cn.iocoder.yudao.module.mes.controller.admin.em.record.vo;
+
+import io.swagger.v3.oas.annotations.media.Schema;
+import jakarta.validation.constraints.NotNull;
+import lombok.Data;
+
+import java.math.BigDecimal;
+import java.time.LocalDate;
+
+@Schema(description = "绠$悊鍚庡彴 - MES 鑳借�楁妱琛ㄨ褰曟柊澧�/淇敼 Request VO")
+@Data
+public class MesEmRecordSaveReqVO {
+
+ @Schema(description = "缂栧彿", example = "1024")
+ private Long id;
+
+ @Schema(description = "璁¢噺鐐圭紪鍙�", requiredMode = Schema.RequiredMode.REQUIRED, example = "1024")
+ @NotNull(message = "璁¢噺鐐逛笉鑳戒负绌�")
+ private Long meterId;
+
+ @Schema(description = "鎶勮〃鏃ユ湡", requiredMode = Schema.RequiredMode.REQUIRED)
+ @NotNull(message = "鎶勮〃鏃ユ湡涓嶈兘涓虹┖")
+ private LocalDate recordDate;
+
+ @Schema(description = "鏈熷垵璇绘暟锛堜负绌烘椂鍙栦笂涓�鏉¤褰曡鏁版垨璁¢噺鐐瑰垵濮嬭鏁帮級", example = "1000")
+ private BigDecimal prevReading;
+
+ @Schema(description = "鏈熸湯璇绘暟", requiredMode = Schema.RequiredMode.REQUIRED, example = "1200")
+ @NotNull(message = "鏈熸湯璇绘暟涓嶈兘涓虹┖")
+ private BigDecimal reading;
+
+ @Schema(description = "鍗曚环锛堝厓/璁¢噺鍗曚綅锛�", example = "0.68")
+ private BigDecimal price;
+
+ @Schema(description = "鏁版嵁鏉ユ簮", example = "1")
+ private Integer source;
+
+ @Schema(description = "澶囨敞", example = "澶囨敞")
+ private String remark;
+
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/em/statistics/MesEmStatisticsController.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/em/statistics/MesEmStatisticsController.java
new file mode 100644
index 0000000..5bd08bf
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/em/statistics/MesEmStatisticsController.java
@@ -0,0 +1,52 @@
+package cn.iocoder.yudao.module.mes.controller.admin.em.statistics;
+
+import cn.iocoder.yudao.framework.common.pojo.CommonResult;
+import cn.iocoder.yudao.module.mes.controller.admin.em.statistics.vo.MesEmOverviewRespVO;
+import cn.iocoder.yudao.module.mes.controller.admin.em.statistics.vo.MesEmReportRespVO;
+import cn.iocoder.yudao.module.mes.service.em.statistics.MesEmStatisticsService;
+import io.swagger.v3.oas.annotations.Operation;
+import io.swagger.v3.oas.annotations.Parameter;
+import io.swagger.v3.oas.annotations.tags.Tag;
+import jakarta.annotation.Resource;
+import org.springframework.format.annotation.DateTimeFormat;
+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.RequestParam;
+import org.springframework.web.bind.annotation.RestController;
+
+import java.time.LocalDate;
+
+import static cn.iocoder.yudao.framework.common.pojo.CommonResult.success;
+
+@Tag(name = "绠$悊鍚庡彴 - MES 鑳借�楃粺璁�")
+@RestController
+@RequestMapping("/mes/em/statistics")
+@Validated
+public class MesEmStatisticsController {
+
+ @Resource
+ private MesEmStatisticsService statisticsService;
+
+ @GetMapping("/overview")
+ @Operation(summary = "鑾峰緱鑳借�楁�昏鏁版嵁")
+ @PreAuthorize("@ss.hasPermission('mes:em-overview:query')")
+ public CommonResult<MesEmOverviewRespVO> getOverview(
+ @RequestParam(value = "beginDate", required = false)
+ @DateTimeFormat(iso = DateTimeFormat.ISO.DATE) LocalDate beginDate,
+ @RequestParam(value = "endDate", required = false)
+ @DateTimeFormat(iso = DateTimeFormat.ISO.DATE) LocalDate endDate) {
+ return success(statisticsService.getOverview(beginDate, endDate));
+ }
+
+ @GetMapping("/report")
+ @Operation(summary = "鑾峰緱鏈堝害鑳借�楁姤琛紙鍚悓姣斻�佺幆姣旓級")
+ @Parameter(name = "period", description = "鏈堜唤 yyyy-MM", example = "2026-10")
+ @PreAuthorize("@ss.hasPermission('mes:em-report:query')")
+ public CommonResult<MesEmReportRespVO> getReport(
+ @RequestParam(value = "period", required = false) String period) {
+ return success(statisticsService.getReport(period));
+ }
+
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/em/statistics/vo/MesEmOverviewRespVO.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/em/statistics/vo/MesEmOverviewRespVO.java
new file mode 100644
index 0000000..c9415ec
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/em/statistics/vo/MesEmOverviewRespVO.java
@@ -0,0 +1,161 @@
+package cn.iocoder.yudao.module.mes.controller.admin.em.statistics.vo;
+
+import io.swagger.v3.oas.annotations.media.Schema;
+import lombok.Data;
+
+import java.math.BigDecimal;
+import java.util.List;
+
+@Schema(description = "绠$悊鍚庡彴 - MES 鑳借�楁�昏 Response VO")
+@Data
+public class MesEmOverviewRespVO {
+
+ @Schema(description = "缁煎悎鑳借�楋紙鍚ㄦ爣鐓わ級", example = "12.34")
+ private BigDecimal totalTce;
+
+ @Schema(description = "鎬昏垂鐢紙鍏冿級", example = "123456.78")
+ private BigDecimal totalCost;
+
+ @Schema(description = "璁¢噺鐐规暟閲�", example = "20")
+ private Integer meterCount;
+
+ @Schema(description = "鏈鐞嗛璀︽暟閲�", example = "3")
+ private Integer pendingAlertCount;
+
+ @Schema(description = "鑳芥簮绫诲瀷缁熻")
+ private List<TypeStat> typeStats;
+
+ @Schema(description = "杞﹂棿鑳借�楃粺璁�")
+ private List<WorkshopStat> workshopStats;
+
+ @Schema(description = "鑳借�楄秼鍔�")
+ private List<TrendPoint> trend;
+
+ @Schema(description = "閲嶇偣鐢ㄨ兘璁惧鎺掕")
+ private List<MeterStat> topMeters;
+
+ @Schema(description = "鏈�杩戦璀�")
+ private List<RecentAlert> recentAlerts;
+
+ @Data
+ public static class TypeStat {
+
+ @Schema(description = "鑳芥簮绫诲瀷")
+ private Integer energyType;
+
+ @Schema(description = "鑳芥簮绫诲瀷鍚嶇О")
+ private String energyTypeName;
+
+ @Schema(description = "鐢ㄩ噺")
+ private BigDecimal usage;
+
+ @Schema(description = "璁¢噺鍗曚綅")
+ private String unit;
+
+ @Schema(description = "璐圭敤")
+ private BigDecimal cost;
+
+ @Schema(description = "鎶樻爣鐓わ紙鍚級")
+ private BigDecimal tce;
+
+ }
+
+ @Data
+ public static class WorkshopStat {
+
+ @Schema(description = "杞﹂棿缂栧彿")
+ private Long workshopId;
+
+ @Schema(description = "杞﹂棿鍚嶇О")
+ private String workshopName;
+
+ @Schema(description = "鎶樻爣鐓わ紙鍚級")
+ private BigDecimal tce;
+
+ @Schema(description = "璐圭敤")
+ private BigDecimal cost;
+
+ }
+
+ @Data
+ public static class TrendPoint {
+
+ @Schema(description = "鏃ユ湡")
+ private String date;
+
+ @Schema(description = "缁煎悎鑳借�楋紙鍚ㄦ爣鐓わ級")
+ private BigDecimal tce;
+
+ @Schema(description = "璐圭敤")
+ private BigDecimal cost;
+
+ @Schema(description = "鐢ㄧ數閲�")
+ private BigDecimal electricity;
+
+ @Schema(description = "鐢ㄦ按閲�")
+ private BigDecimal water;
+
+ @Schema(description = "鐕冩补鐢ㄩ噺")
+ private BigDecimal fuel;
+
+ @Schema(description = "澶╃劧姘旂敤閲�")
+ private BigDecimal gas;
+
+ }
+
+ @Data
+ public static class MeterStat {
+
+ @Schema(description = "璁¢噺鐐圭紪鍙�")
+ private Long meterId;
+
+ @Schema(description = "璁¢噺鐐瑰悕绉�")
+ private String meterName;
+
+ @Schema(description = "鑳芥簮绫诲瀷")
+ private Integer energyType;
+
+ @Schema(description = "鑳芥簮绫诲瀷鍚嶇О")
+ private String energyTypeName;
+
+ @Schema(description = "鐢ㄩ噺")
+ private BigDecimal usage;
+
+ @Schema(description = "璁¢噺鍗曚綅")
+ private String unit;
+
+ @Schema(description = "璐圭敤")
+ private BigDecimal cost;
+
+ @Schema(description = "鎶樻爣鐓わ紙鍚級")
+ private BigDecimal tce;
+
+ }
+
+ @Data
+ public static class RecentAlert {
+
+ @Schema(description = "棰勮缂栧彿")
+ private Long id;
+
+ @Schema(description = "棰勮鍐呭")
+ private String content;
+
+ @Schema(description = "棰勮绾у埆")
+ private Integer alertLevel;
+
+ @Schema(description = "棰勮绾у埆鍚嶇О")
+ private String alertLevelName;
+
+ @Schema(description = "棰勮鏃ユ湡")
+ private String alertDate;
+
+ @Schema(description = "澶勭悊鐘舵��")
+ private Integer status;
+
+ @Schema(description = "澶勭悊鐘舵�佸悕绉�")
+ private String statusName;
+
+ }
+
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/em/statistics/vo/MesEmReportRespVO.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/em/statistics/vo/MesEmReportRespVO.java
new file mode 100644
index 0000000..1e62eda
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/em/statistics/vo/MesEmReportRespVO.java
@@ -0,0 +1,111 @@
+package cn.iocoder.yudao.module.mes.controller.admin.em.statistics.vo;
+
+import io.swagger.v3.oas.annotations.media.Schema;
+import lombok.Data;
+
+import java.math.BigDecimal;
+import java.time.LocalDate;
+import java.util.List;
+
+@Schema(description = "绠$悊鍚庡彴 - MES 鑳借�楁姤琛� Response VO")
+@Data
+public class MesEmReportRespVO {
+
+ @Schema(description = "鎶ヨ〃鏈堜唤", example = "2026-10")
+ private String period;
+
+ @Schema(description = "寮�濮嬫棩鏈�")
+ private LocalDate beginDate;
+
+ @Schema(description = "缁撴潫鏃ユ湡")
+ private LocalDate endDate;
+
+ @Schema(description = "缁煎悎鑳借�楋紙鍚ㄦ爣鐓わ級")
+ private BigDecimal totalTce;
+
+ @Schema(description = "鎬昏垂鐢�")
+ private BigDecimal totalCost;
+
+ @Schema(description = "涓婃湀缁煎悎鑳借��")
+ private BigDecimal lastMonthTce;
+
+ @Schema(description = "鐜瘮锛�%锛�")
+ private BigDecimal momRate;
+
+ @Schema(description = "鍘诲勾鍚屾湀缁煎悎鑳借��")
+ private BigDecimal lastYearTce;
+
+ @Schema(description = "鍚屾瘮锛�%锛�")
+ private BigDecimal yoyRate;
+
+ @Schema(description = "鎸夎兘婧愮被鍨嬬粺璁�")
+ private List<TypeRow> typeRows;
+
+ @Schema(description = "鎸夎溅闂寸粺璁�")
+ private List<WorkshopRow> workshopRows;
+
+ @Data
+ public static class TypeRow {
+
+ @Schema(description = "鑳芥簮绫诲瀷")
+ private Integer energyType;
+
+ @Schema(description = "鑳芥簮绫诲瀷鍚嶇О")
+ private String energyTypeName;
+
+ @Schema(description = "鏈湀鐢ㄩ噺")
+ private BigDecimal usage;
+
+ @Schema(description = "璁¢噺鍗曚綅")
+ private String unit;
+
+ @Schema(description = "鏈湀璐圭敤")
+ private BigDecimal cost;
+
+ @Schema(description = "鏈湀鎶樻爣鐓わ紙鍚級")
+ private BigDecimal tce;
+
+ @Schema(description = "涓婃湀鐢ㄩ噺")
+ private BigDecimal lastMonthUsage;
+
+ @Schema(description = "鐜瘮锛�%锛�")
+ private BigDecimal momRate;
+
+ @Schema(description = "鍘诲勾鍚屾湀鐢ㄩ噺")
+ private BigDecimal lastYearUsage;
+
+ @Schema(description = "鍚屾瘮锛�%锛�")
+ private BigDecimal yoyRate;
+
+ }
+
+ @Data
+ public static class WorkshopRow {
+
+ @Schema(description = "杞﹂棿缂栧彿")
+ private Long workshopId;
+
+ @Schema(description = "杞﹂棿鍚嶇О")
+ private String workshopName;
+
+ @Schema(description = "鏈湀璐圭敤")
+ private BigDecimal cost;
+
+ @Schema(description = "鏈湀鎶樻爣鐓わ紙鍚級")
+ private BigDecimal tce;
+
+ @Schema(description = "涓婃湀鎶樻爣鐓わ紙鍚級")
+ private BigDecimal lastMonthTce;
+
+ @Schema(description = "鐜瘮锛�%锛�")
+ private BigDecimal momRate;
+
+ @Schema(description = "鍘诲勾鍚屾湀鎶樻爣鐓わ紙鍚級")
+ private BigDecimal lastYearTce;
+
+ @Schema(description = "鍚屾瘮锛�%锛�")
+ private BigDecimal yoyRate;
+
+ }
+
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/dataobject/em/alert/MesEmAlertDO.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/dataobject/em/alert/MesEmAlertDO.java
new file mode 100644
index 0000000..bc2260d
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/dataobject/em/alert/MesEmAlertDO.java
@@ -0,0 +1,124 @@
+package cn.iocoder.yudao.module.mes.dal.dataobject.em.alert;
+
+import cn.iocoder.yudao.framework.mybatis.core.dataobject.BaseDO;
+import com.baomidou.mybatisplus.annotation.KeySequence;
+import com.baomidou.mybatisplus.annotation.TableId;
+import com.baomidou.mybatisplus.annotation.TableName;
+import lombok.*;
+
+import java.math.BigDecimal;
+import java.time.LocalDate;
+import java.time.LocalDateTime;
+
+/**
+ * MES 鑳借�楅璀﹁褰� DO
+ *
+ * @author 瓒呯骇绠$悊鍛�
+ */
+@TableName("mes_em_alert")
+@KeySequence("mes_em_alert_seq")
+@Data
+@EqualsAndHashCode(callSuper = true)
+@ToString(callSuper = true)
+@Builder
+@NoArgsConstructor
+@AllArgsConstructor
+public class MesEmAlertDO extends BaseDO {
+
+ /**
+ * 缂栧彿
+ */
+ @TableId
+ private Long id;
+ /**
+ * 棰勮缂栧彿
+ */
+ private String alertNo;
+ /**
+ * 璁¢噺鐐圭紪鍙凤紙瀹氶棰勮涓� 0锛�
+ */
+ private Long meterId;
+ /**
+ * 璁¢噺鐐圭紪鐮�
+ */
+ private String meterCode;
+ /**
+ * 璁¢噺鐐瑰悕绉�
+ */
+ private String meterName;
+ /**
+ * 鑳芥簮绫诲瀷
+ *
+ * 鏋氫妇 {@link cn.iocoder.yudao.module.mes.enums.em.MesEmEnergyTypeEnum}
+ */
+ private Integer energyType;
+ /**
+ * 棰勮绫诲瀷
+ *
+ * 鏋氫妇 {@link cn.iocoder.yudao.module.mes.enums.em.MesEmAlertTypeEnum}
+ */
+ private Integer alertType;
+ /**
+ * 棰勮绾у埆
+ *
+ * 鏋氫妇 {@link cn.iocoder.yudao.module.mes.enums.em.MesEmAlertLevelEnum}
+ */
+ private Integer alertLevel;
+ /**
+ * 棰勮鏃ユ湡
+ */
+ private LocalDate alertDate;
+ /**
+ * 鑰冩牳瀵硅薄绫诲瀷
+ *
+ * 鏋氫妇 {@link cn.iocoder.yudao.module.mes.enums.em.MesEmQuotaObjectTypeEnum}
+ */
+ private Integer objectType;
+ /**
+ * 鑰冩牳瀵硅薄缂栧彿锛堥潪瀹氶棰勮涓� 0锛�
+ */
+ private Long objectId;
+ /**
+ * 鑰冩牳瀵硅薄鍚嶇О
+ */
+ private String objectName;
+ /**
+ * 瀹為檯鍊�
+ */
+ private BigDecimal actualValue;
+ /**
+ * 闃堝��
+ */
+ private BigDecimal thresholdValue;
+ /**
+ * 璁¢噺鍗曚綅
+ */
+ private String unit;
+ /**
+ * 棰勮鍐呭
+ */
+ private String content;
+ /**
+ * 澶勭悊鐘舵��
+ *
+ * 鏋氫妇 {@link cn.iocoder.yudao.module.mes.enums.em.MesEmAlertStatusEnum}
+ */
+ private Integer status;
+ /**
+ * 澶勭悊浜虹紪鍙�
+ */
+ private Long handleUserId;
+ /**
+ * 澶勭悊浜哄悕绉�
+ */
+ private String handleUserName;
+ /**
+ * 澶勭悊鏃堕棿
+ */
+ private LocalDateTime handleTime;
+ /**
+ * 澶勭悊璇存槑
+ */
+ private String handleRemark;
+
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/dataobject/em/meter/MesEmMeterDO.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/dataobject/em/meter/MesEmMeterDO.java
new file mode 100644
index 0000000..a6e1942
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/dataobject/em/meter/MesEmMeterDO.java
@@ -0,0 +1,115 @@
+package cn.iocoder.yudao.module.mes.dal.dataobject.em.meter;
+
+import cn.iocoder.yudao.framework.mybatis.core.dataobject.BaseDO;
+import com.baomidou.mybatisplus.annotation.KeySequence;
+import com.baomidou.mybatisplus.annotation.TableId;
+import com.baomidou.mybatisplus.annotation.TableName;
+import lombok.*;
+
+import java.math.BigDecimal;
+import java.time.LocalDate;
+
+/**
+ * MES 鑳借�楄閲忕偣 DO
+ *
+ * 涓�涓閲忕偣鍙互鎸傚湪杞﹂棿銆佷骇绾挎垨閲嶇偣楂樿�楄兘璁惧涓婏紝鐢ㄤ簬閲囬泦鏌愪竴绫昏兘婧愮殑鐢ㄩ噺銆�
+ *
+ * @author 瓒呯骇绠$悊鍛�
+ */
+@TableName("mes_em_meter")
+@KeySequence("mes_em_meter_seq")
+@Data
+@EqualsAndHashCode(callSuper = true)
+@ToString(callSuper = true)
+@Builder
+@NoArgsConstructor
+@AllArgsConstructor
+public class MesEmMeterDO extends BaseDO {
+
+ /**
+ * 缂栧彿
+ */
+ @TableId
+ private Long id;
+ /**
+ * 璁¢噺鐐圭紪鐮�
+ */
+ private String code;
+ /**
+ * 璁¢噺鐐瑰悕绉�
+ */
+ private String name;
+ /**
+ * 鑳芥簮绫诲瀷
+ *
+ * 鏋氫妇 {@link cn.iocoder.yudao.module.mes.enums.em.MesEmEnergyTypeEnum}
+ */
+ private Integer energyType;
+ /**
+ * 璁¢噺鍗曚綅
+ */
+ private String unit;
+ /**
+ * 琛ㄥ彿锛堢幇鍦鸿〃璁$紪鍙凤級
+ */
+ private String meterNo;
+ /**
+ * 鎵�灞炶溅闂寸紪鍙�
+ */
+ private Long workshopId;
+ /**
+ * 鎵�灞炶溅闂村悕绉�
+ */
+ private String workshopName;
+ /**
+ * 鎵�灞炰骇绾跨紪鍙�
+ */
+ private Long lineId;
+ /**
+ * 鎵�灞炰骇绾垮悕绉�
+ */
+ private String lineName;
+ /**
+ * 鍏宠仈璁惧缂栧彿
+ */
+ private Long machineryId;
+ /**
+ * 鍏宠仈璁惧鍚嶇О
+ */
+ private String machineryName;
+ /**
+ * 鍊嶇巼锛堣鏁� 脳 鍊嶇巼 = 瀹為檯鐢ㄩ噺锛�
+ */
+ private BigDecimal ratio;
+ /**
+ * 鍒濆璇绘暟
+ */
+ private BigDecimal initialReading;
+ /**
+ * 鎶樻爣鐓ょ郴鏁帮紙kgce/璁¢噺鍗曚綅锛�
+ */
+ private BigDecimal coalFactor;
+ /**
+ * 鏃ョ敤閲忓紓甯镐笂闄愶紙瓒呰繃鍚庤Е鍙戠枒浼艰窇鍐掓淮婕忛璀︼紝涓虹┖琛ㄧず涓嶆娴嬶級
+ */
+ private BigDecimal leakThreshold;
+ /**
+ * 璐d换浜虹紪鍙�
+ */
+ private Long chargeUserId;
+ /**
+ * 鎶曠敤鏃ユ湡
+ */
+ private LocalDate installDate;
+ /**
+ * 鐘舵��
+ *
+ * 鏋氫妇 {@link cn.iocoder.yudao.module.mes.enums.em.MesEmMeterStatusEnum}
+ */
+ private Integer status;
+ /**
+ * 澶囨敞
+ */
+ private String remark;
+
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/dataobject/em/quota/MesEmQuotaDO.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/dataobject/em/quota/MesEmQuotaDO.java
new file mode 100644
index 0000000..0205b49
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/dataobject/em/quota/MesEmQuotaDO.java
@@ -0,0 +1,98 @@
+package cn.iocoder.yudao.module.mes.dal.dataobject.em.quota;
+
+import cn.iocoder.yudao.framework.mybatis.core.dataobject.BaseDO;
+import com.baomidou.mybatisplus.annotation.KeySequence;
+import com.baomidou.mybatisplus.annotation.TableId;
+import com.baomidou.mybatisplus.annotation.TableName;
+import lombok.*;
+
+import java.math.BigDecimal;
+
+/**
+ * MES 鑳借�楄�冩牳鎸囨爣 DO
+ *
+ * 鎸夊叏鍘� / 杞﹂棿 / 浜х嚎 / 璁惧閰嶇疆鏃ユ垨鏈堢殑鑳借�楀畾棰濓紝骞惰缃秴闄愰璀︽瘮渚嬨��
+ *
+ * @author 瓒呯骇绠$悊鍛�
+ */
+@TableName("mes_em_quota")
+@KeySequence("mes_em_quota_seq")
+@Data
+@EqualsAndHashCode(callSuper = true)
+@ToString(callSuper = true)
+@Builder
+@NoArgsConstructor
+@AllArgsConstructor
+public class MesEmQuotaDO extends BaseDO {
+
+ /**
+ * 缂栧彿
+ */
+ @TableId
+ private Long id;
+ /**
+ * 鎸囨爣鍚嶇О
+ */
+ private String name;
+ /**
+ * 鑳芥簮绫诲瀷
+ *
+ * 鏋氫妇 {@link cn.iocoder.yudao.module.mes.enums.em.MesEmEnergyTypeEnum}
+ */
+ private Integer energyType;
+ /**
+ * 鑰冩牳瀵硅薄绫诲瀷
+ *
+ * 鏋氫妇 {@link cn.iocoder.yudao.module.mes.enums.em.MesEmQuotaObjectTypeEnum}
+ */
+ private Integer objectType;
+ /**
+ * 鑰冩牳瀵硅薄缂栧彿锛堝叏鍘傛椂涓虹┖锛�
+ */
+ private Long objectId;
+ /**
+ * 鑰冩牳瀵硅薄鍚嶇О锛堜繚瀛樻椂鍐椾綑锛�
+ */
+ private String objectName;
+ /**
+ * 鑰冩牳鍛ㄦ湡
+ *
+ * 鏋氫妇 {@link cn.iocoder.yudao.module.mes.enums.em.MesEmQuotaPeriodEnum}
+ */
+ private Integer periodType;
+ /**
+ * 瀹氶鍊�
+ */
+ private BigDecimal quotaValue;
+ /**
+ * 璁¢噺鍗曚綅
+ */
+ private String unit;
+ /**
+ * 棰勮姣斾緥锛堣秴鍑哄畾棰濆灏戠櫨鍒嗘瘮瑙﹀彂璀﹀憡锛�
+ */
+ private BigDecimal warnRatio;
+ /**
+ * 涓ラ噸棰勮姣斾緥锛堣秴鍑哄畾棰濆灏戠櫨鍒嗘瘮瑙﹀彂涓ラ噸棰勮锛�
+ */
+ private BigDecimal alarmRatio;
+ /**
+ * 鐜瘮寮傚父闃堝�硷紙%锛�
+ */
+ private BigDecimal momWarnRatio;
+ /**
+ * 鍚屾瘮寮傚父闃堝�硷紙%锛�
+ */
+ private BigDecimal yoyWarnRatio;
+ /**
+ * 鐘舵��
+ *
+ * 鏋氫妇 {@link cn.iocoder.yudao.module.mes.enums.em.MesEmMeterStatusEnum}
+ */
+ private Integer status;
+ /**
+ * 澶囨敞
+ */
+ private String remark;
+
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/dataobject/em/record/MesEmRecordDO.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/dataobject/em/record/MesEmRecordDO.java
new file mode 100644
index 0000000..c549edd
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/dataobject/em/record/MesEmRecordDO.java
@@ -0,0 +1,124 @@
+package cn.iocoder.yudao.module.mes.dal.dataobject.em.record;
+
+import cn.iocoder.yudao.framework.mybatis.core.dataobject.BaseDO;
+import com.baomidou.mybatisplus.annotation.KeySequence;
+import com.baomidou.mybatisplus.annotation.TableId;
+import com.baomidou.mybatisplus.annotation.TableName;
+import lombok.*;
+
+import java.math.BigDecimal;
+import java.time.LocalDate;
+
+/**
+ * MES 鑳借�楁妱琛ㄨ褰� DO
+ *
+ * 璁板綍淇濆瓨鏃朵細鎶婅閲忕偣鐨勫悕绉般�佽溅闂�/浜х嚎/璁惧淇℃伅鍐椾綑杩涙潵锛屼綔涓哄巻鍙插揩鐓э紝
+ * 鍚庣画涓绘暟鎹敼鍚嶄笉浼氬奖鍝嶅巻鍙叉姤琛ㄣ��
+ *
+ * @author 瓒呯骇绠$悊鍛�
+ */
+@TableName("mes_em_record")
+@KeySequence("mes_em_record_seq")
+@Data
+@EqualsAndHashCode(callSuper = true)
+@ToString(callSuper = true)
+@Builder
+@NoArgsConstructor
+@AllArgsConstructor
+public class MesEmRecordDO extends BaseDO {
+
+ /**
+ * 缂栧彿
+ */
+ @TableId
+ private Long id;
+ /**
+ * 璁¢噺鐐圭紪鍙�
+ */
+ private Long meterId;
+ /**
+ * 璁¢噺鐐圭紪鐮�
+ */
+ private String meterCode;
+ /**
+ * 璁¢噺鐐瑰悕绉�
+ */
+ private String meterName;
+ /**
+ * 鑳芥簮绫诲瀷
+ *
+ * 鏋氫妇 {@link cn.iocoder.yudao.module.mes.enums.em.MesEmEnergyTypeEnum}
+ */
+ private Integer energyType;
+ /**
+ * 璁¢噺鍗曚綅
+ */
+ private String unit;
+ /**
+ * 鍊嶇巼
+ */
+ private BigDecimal ratio;
+ /**
+ * 鎶樻爣鐓ょ郴鏁帮紙kgce/璁¢噺鍗曚綅锛�
+ */
+ private BigDecimal coalFactor;
+ /**
+ * 鎵�灞炶溅闂寸紪鍙�
+ */
+ private Long workshopId;
+ /**
+ * 鎵�灞炶溅闂村悕绉�
+ */
+ private String workshopName;
+ /**
+ * 鎵�灞炰骇绾跨紪鍙�
+ */
+ private Long lineId;
+ /**
+ * 鎵�灞炰骇绾垮悕绉�
+ */
+ private String lineName;
+ /**
+ * 鍏宠仈璁惧缂栧彿
+ */
+ private Long machineryId;
+ /**
+ * 鍏宠仈璁惧鍚嶇О
+ */
+ private String machineryName;
+ /**
+ * 鎶勮〃鏃ユ湡
+ */
+ private LocalDate recordDate;
+ /**
+ * 鏈熷垵璇绘暟
+ */
+ private BigDecimal prevReading;
+ /**
+ * 鏈熸湯璇绘暟
+ */
+ private BigDecimal reading;
+ /**
+ * 瀹為檯鐢ㄩ噺锛�(鏈熸湯璇绘暟 - 鏈熷垵璇绘暟) 脳 鍊嶇巼锛�
+ */
+ private BigDecimal usageAmount;
+ /**
+ * 鍗曚环锛堝厓/璁¢噺鍗曚綅锛�
+ */
+ private BigDecimal price;
+ /**
+ * 璐圭敤锛堝厓锛�
+ */
+ private BigDecimal cost;
+ /**
+ * 鏁版嵁鏉ユ簮
+ *
+ * 鏋氫妇 {@link cn.iocoder.yudao.module.mes.enums.em.MesEmRecordSourceEnum}
+ */
+ private Integer source;
+ /**
+ * 澶囨敞
+ */
+ private String remark;
+
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/em/alert/MesEmAlertMapper.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/em/alert/MesEmAlertMapper.java
new file mode 100644
index 0000000..f2871f6
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/em/alert/MesEmAlertMapper.java
@@ -0,0 +1,66 @@
+package cn.iocoder.yudao.module.mes.dal.mysql.em.alert;
+
+import cn.iocoder.yudao.framework.common.pojo.PageResult;
+import cn.iocoder.yudao.framework.mybatis.core.mapper.BaseMapperX;
+import cn.iocoder.yudao.framework.mybatis.core.query.LambdaQueryWrapperX;
+import cn.iocoder.yudao.module.mes.controller.admin.em.alert.vo.MesEmAlertPageReqVO;
+import cn.iocoder.yudao.module.mes.dal.dataobject.em.alert.MesEmAlertDO;
+import org.apache.ibatis.annotations.Mapper;
+
+import java.time.LocalDate;
+import java.util.List;
+
+/**
+ * MES 鑳借�楅璀� Mapper
+ *
+ * @author 瓒呯骇绠$悊鍛�
+ */
+@Mapper
+public interface MesEmAlertMapper extends BaseMapperX<MesEmAlertDO> {
+
+ default PageResult<MesEmAlertDO> selectPage(MesEmAlertPageReqVO reqVO) {
+ return selectPage(reqVO, new LambdaQueryWrapperX<MesEmAlertDO>()
+ .likeIfPresent(MesEmAlertDO::getMeterName, reqVO.getMeterName())
+ .eqIfPresent(MesEmAlertDO::getEnergyType, reqVO.getEnergyType())
+ .eqIfPresent(MesEmAlertDO::getAlertType, reqVO.getAlertType())
+ .eqIfPresent(MesEmAlertDO::getAlertLevel, reqVO.getAlertLevel())
+ .eqIfPresent(MesEmAlertDO::getStatus, reqVO.getStatus())
+ .betweenIfPresent(MesEmAlertDO::getAlertDate, reqVO.getAlertDate())
+ .orderByDesc(MesEmAlertDO::getAlertDate)
+ .orderByDesc(MesEmAlertDO::getId));
+ }
+
+ default MesEmAlertDO selectByUnique(Long meterId, Integer alertType, LocalDate alertDate, Long objectId) {
+ return selectOne(new LambdaQueryWrapperX<MesEmAlertDO>()
+ .eq(MesEmAlertDO::getMeterId, meterId)
+ .eq(MesEmAlertDO::getAlertType, alertType)
+ .eq(MesEmAlertDO::getAlertDate, alertDate)
+ .eq(MesEmAlertDO::getObjectId, objectId));
+ }
+
+ default List<MesEmAlertDO> selectRecent(LocalDate begin, LocalDate end, int limit) {
+ return selectList(new LambdaQueryWrapperX<MesEmAlertDO>()
+ .ge(MesEmAlertDO::getAlertDate, begin)
+ .le(MesEmAlertDO::getAlertDate, end)
+ .orderByDesc(MesEmAlertDO::getAlertDate)
+ .orderByDesc(MesEmAlertDO::getId)
+ .last("LIMIT " + limit));
+ }
+
+ default Long selectPendingCount() {
+ return selectCount(new LambdaQueryWrapperX<MesEmAlertDO>()
+ .eq(MesEmAlertDO::getStatus, 0));
+ }
+
+ default Long selectCountByDateRange(LocalDate begin, LocalDate end) {
+ return selectCount(new LambdaQueryWrapperX<MesEmAlertDO>()
+ .between(MesEmAlertDO::getAlertDate, begin, end));
+ }
+
+ default int deleteByMeterIdAndDate(Long meterId, LocalDate alertDate) {
+ return delete(new LambdaQueryWrapperX<MesEmAlertDO>()
+ .eq(MesEmAlertDO::getMeterId, meterId)
+ .eq(MesEmAlertDO::getAlertDate, alertDate));
+ }
+
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/em/meter/MesEmMeterMapper.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/em/meter/MesEmMeterMapper.java
new file mode 100644
index 0000000..ef6a01f
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/em/meter/MesEmMeterMapper.java
@@ -0,0 +1,56 @@
+package cn.iocoder.yudao.module.mes.dal.mysql.em.meter;
+
+import cn.iocoder.yudao.framework.common.pojo.PageResult;
+import cn.iocoder.yudao.framework.mybatis.core.mapper.BaseMapperX;
+import cn.iocoder.yudao.framework.mybatis.core.query.LambdaQueryWrapperX;
+import cn.iocoder.yudao.module.mes.controller.admin.em.meter.vo.MesEmMeterPageReqVO;
+import cn.iocoder.yudao.module.mes.controller.admin.em.meter.vo.MesEmOptionRespVO;
+import cn.iocoder.yudao.module.mes.dal.dataobject.em.meter.MesEmMeterDO;
+import org.apache.ibatis.annotations.Mapper;
+import org.apache.ibatis.annotations.Param;
+import org.apache.ibatis.annotations.Select;
+
+import java.util.List;
+
+/**
+ * MES 鑳借�楄閲忕偣 Mapper
+ *
+ * @author 瓒呯骇绠$悊鍛�
+ */
+@Mapper
+public interface MesEmMeterMapper extends BaseMapperX<MesEmMeterDO> {
+
+ default PageResult<MesEmMeterDO> selectPage(MesEmMeterPageReqVO reqVO) {
+ return selectPage(reqVO, new LambdaQueryWrapperX<MesEmMeterDO>()
+ .likeIfPresent(MesEmMeterDO::getCode, reqVO.getCode())
+ .likeIfPresent(MesEmMeterDO::getName, reqVO.getName())
+ .eqIfPresent(MesEmMeterDO::getEnergyType, reqVO.getEnergyType())
+ .eqIfPresent(MesEmMeterDO::getWorkshopId, reqVO.getWorkshopId())
+ .eqIfPresent(MesEmMeterDO::getStatus, reqVO.getStatus())
+ .orderByDesc(MesEmMeterDO::getId));
+ }
+
+ default MesEmMeterDO selectByCode(String code) {
+ return selectOne(MesEmMeterDO::getCode, code);
+ }
+
+ default List<MesEmMeterDO> selectListByStatus(Integer status) {
+ return selectList(new LambdaQueryWrapperX<MesEmMeterDO>()
+ .eqIfPresent(MesEmMeterDO::getStatus, status)
+ .orderByAsc(MesEmMeterDO::getEnergyType)
+ .orderByAsc(MesEmMeterDO::getCode));
+ }
+
+ @Select("SELECT id, code, name FROM mes_md_workshop WHERE deleted = 0 ORDER BY id")
+ List<MesEmOptionRespVO> selectWorkshopOptions();
+
+ @Select("SELECT id, code, name FROM mes_pro_line WHERE deleted = 0 ORDER BY id")
+ List<MesEmOptionRespVO> selectLineOptions();
+
+ @Select("SELECT id, code, name FROM mes_pro_line WHERE id = #{id} AND deleted = 0")
+ MesEmOptionRespVO selectLineOptionById(@Param("id") Long id);
+
+ @Select("SELECT id, code, name, workshop_id AS workshopId FROM mes_dv_machinery WHERE deleted = 0 ORDER BY id")
+ List<MesEmOptionRespVO> selectMachineryOptions();
+
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/em/quota/MesEmQuotaMapper.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/em/quota/MesEmQuotaMapper.java
new file mode 100644
index 0000000..d4f89c9
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/em/quota/MesEmQuotaMapper.java
@@ -0,0 +1,50 @@
+package cn.iocoder.yudao.module.mes.dal.mysql.em.quota;
+
+import cn.iocoder.yudao.framework.common.pojo.PageResult;
+import cn.iocoder.yudao.framework.mybatis.core.mapper.BaseMapperX;
+import cn.iocoder.yudao.framework.mybatis.core.query.LambdaQueryWrapperX;
+import cn.iocoder.yudao.module.mes.controller.admin.em.quota.vo.MesEmQuotaPageReqVO;
+import cn.iocoder.yudao.module.mes.dal.dataobject.em.quota.MesEmQuotaDO;
+import org.apache.ibatis.annotations.Mapper;
+
+import java.util.List;
+
+/**
+ * MES 鑳借�楄�冩牳鎸囨爣 Mapper
+ *
+ * @author 瓒呯骇绠$悊鍛�
+ */
+@Mapper
+public interface MesEmQuotaMapper extends BaseMapperX<MesEmQuotaDO> {
+
+ default PageResult<MesEmQuotaDO> selectPage(MesEmQuotaPageReqVO reqVO) {
+ return selectPage(reqVO, new LambdaQueryWrapperX<MesEmQuotaDO>()
+ .likeIfPresent(MesEmQuotaDO::getName, reqVO.getName())
+ .eqIfPresent(MesEmQuotaDO::getEnergyType, reqVO.getEnergyType())
+ .eqIfPresent(MesEmQuotaDO::getObjectType, reqVO.getObjectType())
+ .eqIfPresent(MesEmQuotaDO::getPeriodType, reqVO.getPeriodType())
+ .eqIfPresent(MesEmQuotaDO::getStatus, reqVO.getStatus())
+ .orderByDesc(MesEmQuotaDO::getId));
+ }
+
+ /**
+ * 鏌ヨ鏌愮被鑳芥簮涓嬨�佷笌鎸囧畾杞﹂棿/浜х嚎/璁惧鐩稿叧鐨勫惎鐢ㄦ寚鏍�
+ */
+ default List<MesEmQuotaDO> selectListByObject(Integer energyType, Integer periodType,
+ Long workshopId, Long lineId, Long machineryId) {
+ return selectList(new LambdaQueryWrapperX<MesEmQuotaDO>()
+ .eq(MesEmQuotaDO::getEnergyType, energyType)
+ .eqIfPresent(MesEmQuotaDO::getPeriodType, periodType)
+ .eq(MesEmQuotaDO::getStatus, 1)
+ .and(wrapper -> wrapper
+ .eq(MesEmQuotaDO::getObjectType, 0)
+ .or(workshopId != null, w -> w.eq(MesEmQuotaDO::getObjectType, 1)
+ .eq(MesEmQuotaDO::getObjectId, workshopId))
+ .or(lineId != null, w -> w.eq(MesEmQuotaDO::getObjectType, 2)
+ .eq(MesEmQuotaDO::getObjectId, lineId))
+ .or(machineryId != null, w -> w.eq(MesEmQuotaDO::getObjectType, 3)
+ .eq(MesEmQuotaDO::getObjectId, machineryId)))
+ .orderByAsc(MesEmQuotaDO::getId));
+ }
+
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/em/record/MesEmRecordMapper.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/em/record/MesEmRecordMapper.java
new file mode 100644
index 0000000..d16c2d9
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/em/record/MesEmRecordMapper.java
@@ -0,0 +1,165 @@
+package cn.iocoder.yudao.module.mes.dal.mysql.em.record;
+
+import cn.iocoder.yudao.framework.common.pojo.PageResult;
+import cn.iocoder.yudao.framework.mybatis.core.mapper.BaseMapperX;
+import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
+import cn.iocoder.yudao.framework.mybatis.core.query.LambdaQueryWrapperX;
+import cn.iocoder.yudao.module.mes.controller.admin.em.record.vo.MesEmRecordPageReqVO;
+import cn.iocoder.yudao.module.mes.dal.dataobject.em.record.MesEmRecordDO;
+import org.apache.ibatis.annotations.Mapper;
+import org.apache.ibatis.annotations.Param;
+import org.apache.ibatis.annotations.Select;
+
+import java.math.BigDecimal;
+import java.time.LocalDate;
+import java.util.List;
+import java.util.Map;
+
+/**
+ * MES 鑳借�楁妱琛ㄨ褰� Mapper
+ *
+ * @author 瓒呯骇绠$悊鍛�
+ */
+@Mapper
+public interface MesEmRecordMapper extends BaseMapperX<MesEmRecordDO> {
+
+ default PageResult<MesEmRecordDO> selectPage(MesEmRecordPageReqVO reqVO) {
+ return selectPage(reqVO, new LambdaQueryWrapperX<MesEmRecordDO>()
+ .eqIfPresent(MesEmRecordDO::getMeterId, reqVO.getMeterId())
+ .likeIfPresent(MesEmRecordDO::getMeterName, reqVO.getMeterName())
+ .eqIfPresent(MesEmRecordDO::getEnergyType, reqVO.getEnergyType())
+ .eqIfPresent(MesEmRecordDO::getWorkshopId, reqVO.getWorkshopId())
+ .eqIfPresent(MesEmRecordDO::getSource, reqVO.getSource())
+ .betweenIfPresent(MesEmRecordDO::getRecordDate, reqVO.getRecordDate())
+ .orderByDesc(MesEmRecordDO::getRecordDate)
+ .orderByDesc(MesEmRecordDO::getId));
+ }
+
+ default MesEmRecordDO selectByMeterIdAndDate(Long meterId, LocalDate recordDate) {
+ return selectOne(new LambdaQueryWrapperX<MesEmRecordDO>()
+ .eq(MesEmRecordDO::getMeterId, meterId)
+ .eq(MesEmRecordDO::getRecordDate, recordDate));
+ }
+
+ default MesEmRecordDO selectLastByMeterId(Long meterId, LocalDate beforeDate, Long excludeId) {
+ return selectOne(new LambdaQueryWrapperX<MesEmRecordDO>()
+ .eq(MesEmRecordDO::getMeterId, meterId)
+ .lt(MesEmRecordDO::getRecordDate, beforeDate)
+ .ne(excludeId != null, MesEmRecordDO::getId, excludeId)
+ .orderByDesc(MesEmRecordDO::getRecordDate)
+ .orderByDesc(MesEmRecordDO::getId)
+ .last("LIMIT 1"));
+ }
+
+ default List<MesEmRecordDO> selectListByMeterIdAndDateRange(Long meterId, LocalDate begin, LocalDate end) {
+ return selectList(new LambdaQueryWrapperX<MesEmRecordDO>()
+ .eq(MesEmRecordDO::getMeterId, meterId)
+ .between(MesEmRecordDO::getRecordDate, begin, end));
+ }
+
+ /**
+ * 缁熻鏌愪釜鑰冩牳瀵硅薄鍦ㄦ寚瀹氬尯闂村唴鐨勭敤閲�
+ *
+ * @param objectType 0 鍏ㄥ巶 / 1 杞﹂棿 / 2 浜х嚎 / 3 璁惧
+ */
+ @Select("""
+ <script>
+ SELECT COALESCE(SUM(usage_amount), 0)
+ FROM mes_em_record
+ WHERE deleted = 0
+ AND energy_type = #{energyType}
+ AND record_date BETWEEN #{begin} AND #{end}
+ <if test="objectType == 1">AND workshop_id = #{objectId}</if>
+ <if test="objectType == 2">AND line_id = #{objectId}</if>
+ <if test="objectType == 3">AND machinery_id = #{objectId}</if>
+ </script>
+ """)
+ BigDecimal sumUsage(@Param("energyType") Integer energyType,
+ @Param("objectType") Integer objectType,
+ @Param("objectId") Long objectId,
+ @Param("begin") LocalDate begin,
+ @Param("end") LocalDate end);
+
+ @Select("""
+ SELECT COALESCE(SUM(usage_amount), 0)
+ FROM mes_em_record
+ WHERE deleted = 0 AND meter_id = #{meterId} AND record_date BETWEEN #{begin} AND #{end}
+ """)
+ BigDecimal sumMeterUsage(@Param("meterId") Long meterId,
+ @Param("begin") LocalDate begin,
+ @Param("end") LocalDate end);
+
+ @Select("""
+ SELECT COALESCE(SUM(usage_amount), 0)
+ FROM mes_em_record
+ WHERE deleted = 0 AND energy_type = #{energyType} AND record_date BETWEEN #{begin} AND #{end}
+ """)
+ BigDecimal sumTypeUsage(@Param("energyType") Integer energyType,
+ @Param("begin") LocalDate begin,
+ @Param("end") LocalDate end);
+
+ default List<MesEmRecordDO> selectListByDateRange(LocalDate begin, LocalDate end) {
+ return selectList(new LambdaQueryWrapperX<MesEmRecordDO>()
+ .between(MesEmRecordDO::getRecordDate, begin, end)
+ .orderByAsc(MesEmRecordDO::getRecordDate)
+ .orderByAsc(MesEmRecordDO::getId));
+ }
+
+ // ==================== 缁熻鏌ヨ ====================
+
+ default List<Map<String, Object>> selectTypeStats(LocalDate begin, LocalDate end) {
+ return selectMaps(new QueryWrapper<MesEmRecordDO>()
+ .select("energy_type AS energyType",
+ "COALESCE(SUM(usage_amount), 0) AS usageAmount",
+ "COALESCE(SUM(cost), 0) AS costAmount",
+ "COALESCE(SUM(usage_amount * coal_factor) / 1000, 0) AS tce")
+ .between("record_date", begin, end)
+ .groupBy("energy_type")
+ .orderByAsc("energy_type"));
+ }
+
+ default List<Map<String, Object>> selectWorkshopStats(LocalDate begin, LocalDate end) {
+ return selectMaps(new QueryWrapper<MesEmRecordDO>()
+ .select("workshop_id AS workshopId",
+ "workshop_name AS workshopName",
+ "COALESCE(SUM(usage_amount * coal_factor) / 1000, 0) AS tce",
+ "COALESCE(SUM(cost), 0) AS costAmount")
+ .between("record_date", begin, end)
+ .isNotNull("workshop_id")
+ .groupBy("workshop_id", "workshop_name")
+ .orderByDesc("tce"));
+ }
+
+ default List<Map<String, Object>> selectTrendRows(LocalDate begin, LocalDate end) {
+ return selectMaps(new QueryWrapper<MesEmRecordDO>()
+ .select("record_date AS recordDate",
+ "energy_type AS energyType",
+ "COALESCE(SUM(usage_amount), 0) AS usageAmount",
+ "COALESCE(SUM(cost), 0) AS costAmount",
+ "COALESCE(SUM(usage_amount * coal_factor) / 1000, 0) AS tce")
+ .between("record_date", begin, end)
+ .groupBy("record_date", "energy_type")
+ .orderByAsc("record_date"));
+ }
+
+ default List<Map<String, Object>> selectTopMeterStats(LocalDate begin, LocalDate end, int limit) {
+ return selectMaps(new QueryWrapper<MesEmRecordDO>()
+ .select("meter_id AS meterId",
+ "meter_name AS meterName",
+ "energy_type AS energyType",
+ "unit AS unit",
+ "COALESCE(SUM(usage_amount), 0) AS usageAmount",
+ "COALESCE(SUM(cost), 0) AS costAmount",
+ "COALESCE(SUM(usage_amount * coal_factor) / 1000, 0) AS tce")
+ .between("record_date", begin, end)
+ .groupBy("meter_id", "meter_name", "energy_type", "unit")
+ .orderByDesc("tce")
+ .last("LIMIT " + limit));
+ }
+
+ default Long selectCountByMeterId(Long meterId) {
+ return selectCount(new LambdaQueryWrapperX<MesEmRecordDO>()
+ .eq(MesEmRecordDO::getMeterId, meterId));
+ }
+
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/enums/DictTypeConstants.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/enums/DictTypeConstants.java
index d0f62a0..071c3bf 100644
--- a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/enums/DictTypeConstants.java
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/enums/DictTypeConstants.java
@@ -107,6 +107,16 @@
String MES_DV_METERING_CHECK_RESULT = "mes_dv_metering_check_result"; // MES 璁¢噺妫�娴嬬粨璁�
String MES_DV_TELEMETRY_ANOMALY = "mes_dv_telemetry_anomaly"; // MES 鏁伴噰鏄惁寮傚父
+ // ========== 鑳借�楃鐞� (EM) ==========
+ String MES_EM_ENERGY_TYPE = "mes_em_energy_type"; // MES 鑳芥簮绫诲瀷
+ String MES_EM_METER_STATUS = "mes_em_meter_status"; // MES 鑳借�楄閲忕偣鐘舵��
+ String MES_EM_RECORD_SOURCE = "mes_em_record_source"; // MES 鑳借�楁暟鎹潵婧�
+ String MES_EM_QUOTA_OBJECT_TYPE = "mes_em_quota_object_type"; // MES 鑳借�楄�冩牳瀵硅薄绫诲瀷
+ String MES_EM_QUOTA_PERIOD = "mes_em_quota_period"; // MES 鑳借�楄�冩牳鍛ㄦ湡
+ String MES_EM_ALERT_TYPE = "mes_em_alert_type"; // MES 鑳借�楅璀︾被鍨�
+ String MES_EM_ALERT_LEVEL = "mes_em_alert_level"; // MES 鑳借�楅璀︾骇鍒�
+ String MES_EM_ALERT_STATUS = "mes_em_alert_status"; // MES 鑳借�楅璀﹀鐞嗙姸鎬�
+
// ========== 鎺掔彮鏃ュ巻 (CAL) ==========
String MES_CAL_HOLIDAY_TYPE = "mes_cal_holiday_type"; // MES 鍋囨湡绫诲瀷
String MES_CAL_SHIFT_TYPE = "mes_cal_shift_type"; // MES 杞彮鏂瑰紡
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/enums/ErrorCodeConstants.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/enums/ErrorCodeConstants.java
index 30ac42c..8bd9847 100644
--- a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/enums/ErrorCodeConstants.java
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/enums/ErrorCodeConstants.java
@@ -948,6 +948,19 @@
ErrorCode WM_TRANSFER_IMPORT_LIST_IS_EMPTY = new ErrorCode(1_040_950_014, "瀵煎叆杞Щ鍗曟暟鎹笉鑳戒负绌猴紒");
ErrorCode WM_PACKAGE_IMPORT_LIST_IS_EMPTY = new ErrorCode(1_040_950_015, "瀵煎叆瑁呯鍗曟暟鎹笉鑳戒负绌猴紒");
+ // ========== MES 鑳借�楃鐞嗭紙1-040-902-000锛� ==========
+ ErrorCode EM_METER_NOT_EXISTS = new ErrorCode(1_040_902_000, "鑳借�楄閲忕偣涓嶅瓨鍦�");
+ ErrorCode EM_METER_CODE_DUPLICATE = new ErrorCode(1_040_902_001, "鑳借�楄閲忕偣缂栫爜宸插瓨鍦�");
+ ErrorCode EM_METER_HAS_RECORD = new ErrorCode(1_040_902_002, "鑳借�楄閲忕偣宸插瓨鍦ㄦ妱琛ㄨ褰曪紝鏃犳硶鍒犻櫎");
+ ErrorCode EM_METER_OBJECT_NOT_EXISTS = new ErrorCode(1_040_902_003, "璁¢噺鐐瑰叧鑱旂殑杞﹂棿/浜х嚎/璁惧涓嶅瓨鍦�");
+ ErrorCode EM_RECORD_NOT_EXISTS = new ErrorCode(1_040_902_010, "鑳借�楁妱琛ㄨ褰曚笉瀛樺湪");
+ ErrorCode EM_RECORD_DATE_DUPLICATE = new ErrorCode(1_040_902_011, "璇ヨ閲忕偣鍦ㄥ綋鏃ュ凡瀛樺湪鎶勮〃璁板綍");
+ ErrorCode EM_RECORD_READING_INVALID = new ErrorCode(1_040_902_012, "鏈熸湯璇绘暟涓嶈兘灏忎簬鏈熷垵璇绘暟");
+ ErrorCode EM_QUOTA_NOT_EXISTS = new ErrorCode(1_040_902_020, "鑳借�楄�冩牳鎸囨爣涓嶅瓨鍦�");
+ ErrorCode EM_QUOTA_OBJECT_NOT_EXISTS = new ErrorCode(1_040_902_021, "鑰冩牳瀵硅薄涓嶅瓨鍦�");
+ ErrorCode EM_ALERT_NOT_EXISTS = new ErrorCode(1_040_902_030, "鑳借�楅璀︿笉瀛樺湪");
+ ErrorCode EM_ALERT_ALREADY_HANDLED = new ErrorCode(1_040_902_031, "鑳借�楅璀﹀凡澶勭悊锛岃鍕块噸澶嶆搷浣�");
+
// ========== MES 鐢熶骇妯″潡-鍗曟嵁瀵煎叆锛�1-040-960-000锛� ==========
ErrorCode MES_PRO_WORK_ORDER_IMPORT_LIST_IS_EMPTY = new ErrorCode(1_040_960_000, "瀵煎叆鐢熶骇宸ュ崟鏁版嵁涓嶈兘涓虹┖锛�");
ErrorCode MES_PRO_FEEDBACK_IMPORT_LIST_IS_EMPTY = new ErrorCode(1_040_960_001, "瀵煎叆鐢熶骇鎶ュ伐鏁版嵁涓嶈兘涓虹┖锛�");
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/enums/em/MesEmAlertLevelEnum.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/enums/em/MesEmAlertLevelEnum.java
new file mode 100644
index 0000000..ab55310
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/enums/em/MesEmAlertLevelEnum.java
@@ -0,0 +1,39 @@
+package cn.iocoder.yudao.module.mes.enums.em;
+
+import lombok.AllArgsConstructor;
+import lombok.Getter;
+
+import java.util.Arrays;
+
+/**
+ * MES 鑳借�楅璀︾骇鍒灇涓�
+ *
+ * @author 瓒呯骇绠$悊鍛�
+ */
+@Getter
+@AllArgsConstructor
+public enum MesEmAlertLevelEnum {
+
+ INFO(1, "鎻愮ず"),
+ WARN(2, "璀﹀憡"),
+ SERIOUS(3, "涓ラ噸");
+
+ /**
+ * 绾у埆
+ */
+ private final Integer level;
+ /**
+ * 绾у埆鍚嶇О
+ */
+ private final String name;
+
+ public static MesEmAlertLevelEnum getByLevel(Integer level) {
+ return Arrays.stream(values()).filter(item -> item.getLevel().equals(level)).findFirst().orElse(null);
+ }
+
+ public static String getName(Integer level) {
+ MesEmAlertLevelEnum item = getByLevel(level);
+ return item == null ? null : item.getName();
+ }
+
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/enums/em/MesEmAlertStatusEnum.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/enums/em/MesEmAlertStatusEnum.java
new file mode 100644
index 0000000..85b926b
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/enums/em/MesEmAlertStatusEnum.java
@@ -0,0 +1,38 @@
+package cn.iocoder.yudao.module.mes.enums.em;
+
+import lombok.AllArgsConstructor;
+import lombok.Getter;
+
+import java.util.Arrays;
+
+/**
+ * MES 鑳借�楅璀﹀鐞嗙姸鎬佹灇涓�
+ *
+ * @author 瓒呯骇绠$悊鍛�
+ */
+@Getter
+@AllArgsConstructor
+public enum MesEmAlertStatusEnum {
+
+ PENDING(0, "鏈鐞�"),
+ HANDLED(1, "宸插鐞�");
+
+ /**
+ * 鐘舵��
+ */
+ private final Integer status;
+ /**
+ * 鐘舵�佸悕绉�
+ */
+ private final String name;
+
+ public static MesEmAlertStatusEnum getByStatus(Integer status) {
+ return Arrays.stream(values()).filter(item -> item.getStatus().equals(status)).findFirst().orElse(null);
+ }
+
+ public static String getName(Integer status) {
+ MesEmAlertStatusEnum item = getByStatus(status);
+ return item == null ? null : item.getName();
+ }
+
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/enums/em/MesEmAlertTypeEnum.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/enums/em/MesEmAlertTypeEnum.java
new file mode 100644
index 0000000..5ef868f
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/enums/em/MesEmAlertTypeEnum.java
@@ -0,0 +1,40 @@
+package cn.iocoder.yudao.module.mes.enums.em;
+
+import lombok.AllArgsConstructor;
+import lombok.Getter;
+
+import java.util.Arrays;
+
+/**
+ * MES 鑳借�楅璀︾被鍨嬫灇涓�
+ *
+ * @author 瓒呯骇绠$悊鍛�
+ */
+@Getter
+@AllArgsConstructor
+public enum MesEmAlertTypeEnum {
+
+ QUOTA(1, "瓒呭畾棰�"),
+ MOM(2, "鐜瘮寮傚父"),
+ YOY(3, "鍚屾瘮寮傚父"),
+ LEAK(4, "鐤戜技璺戝啋婊存紡");
+
+ /**
+ * 绫诲瀷
+ */
+ private final Integer type;
+ /**
+ * 绫诲瀷鍚嶇О
+ */
+ private final String name;
+
+ public static MesEmAlertTypeEnum getByType(Integer type) {
+ return Arrays.stream(values()).filter(item -> item.getType().equals(type)).findFirst().orElse(null);
+ }
+
+ public static String getName(Integer type) {
+ MesEmAlertTypeEnum item = getByType(type);
+ return item == null ? null : item.getName();
+ }
+
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/enums/em/MesEmEnergyTypeEnum.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/enums/em/MesEmEnergyTypeEnum.java
new file mode 100644
index 0000000..a2c8525
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/enums/em/MesEmEnergyTypeEnum.java
@@ -0,0 +1,49 @@
+package cn.iocoder.yudao.module.mes.enums.em;
+
+import lombok.AllArgsConstructor;
+import lombok.Getter;
+
+import java.math.BigDecimal;
+import java.util.Arrays;
+
+/**
+ * MES 鑳芥簮绫诲瀷鏋氫妇
+ *
+ * @author 瓒呯骇绠$悊鍛�
+ */
+@Getter
+@AllArgsConstructor
+public enum MesEmEnergyTypeEnum {
+
+ ELECTRICITY(1, "鐢�", "kWh", new BigDecimal("0.1229")),
+ WATER(2, "姘�", "t", new BigDecimal("0.2429")),
+ FUEL(3, "鐕冩补", "L", new BigDecimal("1.2000")),
+ GAS(4, "澶╃劧姘�", "m鲁", new BigDecimal("1.3300"));
+
+ /**
+ * 鑳芥簮绫诲瀷
+ */
+ private final Integer type;
+ /**
+ * 鑳芥簮绫诲瀷鍚嶇О
+ */
+ private final String name;
+ /**
+ * 榛樿璁¢噺鍗曚綅
+ */
+ private final String unit;
+ /**
+ * 榛樿鎶樻爣鐓ょ郴鏁帮紙kgce/璁¢噺鍗曚綅锛�
+ */
+ private final BigDecimal coalFactor;
+
+ public static MesEmEnergyTypeEnum getByType(Integer type) {
+ return Arrays.stream(values()).filter(item -> item.getType().equals(type)).findFirst().orElse(null);
+ }
+
+ public static String getName(Integer type) {
+ MesEmEnergyTypeEnum energyType = getByType(type);
+ return energyType == null ? null : energyType.getName();
+ }
+
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/enums/em/MesEmMeterStatusEnum.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/enums/em/MesEmMeterStatusEnum.java
new file mode 100644
index 0000000..29f8125
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/enums/em/MesEmMeterStatusEnum.java
@@ -0,0 +1,38 @@
+package cn.iocoder.yudao.module.mes.enums.em;
+
+import lombok.AllArgsConstructor;
+import lombok.Getter;
+
+import java.util.Arrays;
+
+/**
+ * MES 鑳借�楄閲忕偣鐘舵�佹灇涓�
+ *
+ * @author 瓒呯骇绠$悊鍛�
+ */
+@Getter
+@AllArgsConstructor
+public enum MesEmMeterStatusEnum {
+
+ ENABLE(1, "鍚敤"),
+ DISABLE(0, "鍋滅敤");
+
+ /**
+ * 鐘舵��
+ */
+ private final Integer status;
+ /**
+ * 鐘舵�佸悕绉�
+ */
+ private final String name;
+
+ public static MesEmMeterStatusEnum getByStatus(Integer status) {
+ return Arrays.stream(values()).filter(item -> item.getStatus().equals(status)).findFirst().orElse(null);
+ }
+
+ public static String getName(Integer status) {
+ MesEmMeterStatusEnum item = getByStatus(status);
+ return item == null ? null : item.getName();
+ }
+
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/enums/em/MesEmQuotaObjectTypeEnum.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/enums/em/MesEmQuotaObjectTypeEnum.java
new file mode 100644
index 0000000..ff79597
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/enums/em/MesEmQuotaObjectTypeEnum.java
@@ -0,0 +1,40 @@
+package cn.iocoder.yudao.module.mes.enums.em;
+
+import lombok.AllArgsConstructor;
+import lombok.Getter;
+
+import java.util.Arrays;
+
+/**
+ * MES 鑳借�楄�冩牳瀵硅薄绫诲瀷鏋氫妇
+ *
+ * @author 瓒呯骇绠$悊鍛�
+ */
+@Getter
+@AllArgsConstructor
+public enum MesEmQuotaObjectTypeEnum {
+
+ FACTORY(0, "鍏ㄥ巶"),
+ WORKSHOP(1, "杞﹂棿"),
+ LINE(2, "浜х嚎"),
+ MACHINERY(3, "璁惧");
+
+ /**
+ * 瀵硅薄绫诲瀷
+ */
+ private final Integer type;
+ /**
+ * 瀵硅薄绫诲瀷鍚嶇О
+ */
+ private final String name;
+
+ public static MesEmQuotaObjectTypeEnum getByType(Integer type) {
+ return Arrays.stream(values()).filter(item -> item.getType().equals(type)).findFirst().orElse(null);
+ }
+
+ public static String getName(Integer type) {
+ MesEmQuotaObjectTypeEnum item = getByType(type);
+ return item == null ? null : item.getName();
+ }
+
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/enums/em/MesEmQuotaPeriodEnum.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/enums/em/MesEmQuotaPeriodEnum.java
new file mode 100644
index 0000000..b5c3370
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/enums/em/MesEmQuotaPeriodEnum.java
@@ -0,0 +1,38 @@
+package cn.iocoder.yudao.module.mes.enums.em;
+
+import lombok.AllArgsConstructor;
+import lombok.Getter;
+
+import java.util.Arrays;
+
+/**
+ * MES 鑳借�楄�冩牳鍛ㄦ湡鏋氫妇
+ *
+ * @author 瓒呯骇绠$悊鍛�
+ */
+@Getter
+@AllArgsConstructor
+public enum MesEmQuotaPeriodEnum {
+
+ DAY(1, "鏃�"),
+ MONTH(2, "鏈�");
+
+ /**
+ * 鍛ㄦ湡
+ */
+ private final Integer period;
+ /**
+ * 鍛ㄦ湡鍚嶇О
+ */
+ private final String name;
+
+ public static MesEmQuotaPeriodEnum getByPeriod(Integer period) {
+ return Arrays.stream(values()).filter(item -> item.getPeriod().equals(period)).findFirst().orElse(null);
+ }
+
+ public static String getName(Integer period) {
+ MesEmQuotaPeriodEnum item = getByPeriod(period);
+ return item == null ? null : item.getName();
+ }
+
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/enums/em/MesEmRecordSourceEnum.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/enums/em/MesEmRecordSourceEnum.java
new file mode 100644
index 0000000..09f85d0
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/enums/em/MesEmRecordSourceEnum.java
@@ -0,0 +1,39 @@
+package cn.iocoder.yudao.module.mes.enums.em;
+
+import lombok.AllArgsConstructor;
+import lombok.Getter;
+
+import java.util.Arrays;
+
+/**
+ * MES 鑳借�楁暟鎹潵婧愭灇涓�
+ *
+ * @author 瓒呯骇绠$悊鍛�
+ */
+@Getter
+@AllArgsConstructor
+public enum MesEmRecordSourceEnum {
+
+ MANUAL(1, "鎵嬪伐褰曞叆"),
+ IMPORT(2, "Excel 瀵煎叆"),
+ AUTO(3, "鑷姩閲囬泦");
+
+ /**
+ * 鏉ユ簮
+ */
+ private final Integer source;
+ /**
+ * 鏉ユ簮鍚嶇О
+ */
+ private final String name;
+
+ public static MesEmRecordSourceEnum getBySource(Integer source) {
+ return Arrays.stream(values()).filter(item -> item.getSource().equals(source)).findFirst().orElse(null);
+ }
+
+ public static String getName(Integer source) {
+ MesEmRecordSourceEnum item = getBySource(source);
+ return item == null ? null : item.getName();
+ }
+
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/em/alert/MesEmAlertService.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/em/alert/MesEmAlertService.java
new file mode 100644
index 0000000..f805b95
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/em/alert/MesEmAlertService.java
@@ -0,0 +1,45 @@
+package cn.iocoder.yudao.module.mes.service.em.alert;
+
+import cn.iocoder.yudao.framework.common.pojo.PageResult;
+import cn.iocoder.yudao.module.mes.controller.admin.em.alert.vo.MesEmAlertHandleReqVO;
+import cn.iocoder.yudao.module.mes.controller.admin.em.alert.vo.MesEmAlertPageReqVO;
+import cn.iocoder.yudao.module.mes.controller.admin.em.alert.vo.MesEmAlertRespVO;
+import cn.iocoder.yudao.module.mes.dal.dataobject.em.alert.MesEmAlertDO;
+import cn.iocoder.yudao.module.mes.dal.dataobject.em.record.MesEmRecordDO;
+
+import java.time.LocalDate;
+import java.util.List;
+
+/**
+ * MES 鑳借�楅璀� Service
+ *
+ * @author 瓒呯骇绠$悊鍛�
+ */
+public interface MesEmAlertService {
+
+ /**
+ * 鏍规嵁涓�鏉℃妱琛ㄨ褰曟娴嬪苟鐢熸垚棰勮
+ */
+ void checkRecord(MesEmRecordDO record);
+
+ /**
+ * 閲嶆柊妫�娴嬫寚瀹氭棩鏈熷尯闂寸殑鎶勮〃璁板綍
+ *
+ * @return 妫�娴嬬殑璁板綍鏁�
+ */
+ int checkRange(LocalDate begin, LocalDate end);
+
+ /**
+ * 鍒犻櫎鏌愪釜璁¢噺鐐规煇澶╃殑鐜瘮/鍚屾瘮/璺戝啋婊存紡棰勮锛堟妱琛ㄨ褰曞垹闄ゆ椂璋冪敤锛�
+ */
+ void deleteMeterAlerts(Long meterId, LocalDate alertDate);
+
+ MesEmAlertDO getAlert(Long id);
+
+ PageResult<MesEmAlertDO> getAlertPage(MesEmAlertPageReqVO pageReqVO);
+
+ List<MesEmAlertRespVO> getAlertRespVOList(List<MesEmAlertDO> list);
+
+ void handleAlert(MesEmAlertHandleReqVO handleReqVO);
+
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/em/alert/MesEmAlertServiceImpl.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/em/alert/MesEmAlertServiceImpl.java
new file mode 100644
index 0000000..175d5c8
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/em/alert/MesEmAlertServiceImpl.java
@@ -0,0 +1,339 @@
+package cn.iocoder.yudao.module.mes.service.em.alert;
+
+import cn.hutool.core.collection.CollUtil;
+import cn.hutool.core.util.StrUtil;
+import cn.iocoder.yudao.framework.common.pojo.PageResult;
+import cn.iocoder.yudao.framework.common.util.object.BeanUtils;
+import cn.iocoder.yudao.framework.security.core.util.SecurityFrameworkUtils;
+import cn.iocoder.yudao.module.mes.controller.admin.em.alert.vo.MesEmAlertHandleReqVO;
+import cn.iocoder.yudao.module.mes.controller.admin.em.alert.vo.MesEmAlertPageReqVO;
+import cn.iocoder.yudao.module.mes.controller.admin.em.alert.vo.MesEmAlertRespVO;
+import cn.iocoder.yudao.module.mes.dal.dataobject.em.alert.MesEmAlertDO;
+import cn.iocoder.yudao.module.mes.dal.dataobject.em.meter.MesEmMeterDO;
+import cn.iocoder.yudao.module.mes.dal.dataobject.em.quota.MesEmQuotaDO;
+import cn.iocoder.yudao.module.mes.dal.dataobject.em.record.MesEmRecordDO;
+import cn.iocoder.yudao.module.mes.dal.mysql.em.alert.MesEmAlertMapper;
+import cn.iocoder.yudao.module.mes.dal.mysql.em.meter.MesEmMeterMapper;
+import cn.iocoder.yudao.module.mes.dal.mysql.em.quota.MesEmQuotaMapper;
+import cn.iocoder.yudao.module.mes.dal.mysql.em.record.MesEmRecordMapper;
+import cn.iocoder.yudao.module.mes.enums.em.*;
+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.time.format.DateTimeFormatter;
+import java.util.Collections;
+import java.util.Comparator;
+import java.util.List;
+
+import static cn.iocoder.yudao.framework.common.exception.util.ServiceExceptionUtil.exception;
+import static cn.iocoder.yudao.module.mes.enums.ErrorCodeConstants.EM_ALERT_ALREADY_HANDLED;
+import static cn.iocoder.yudao.module.mes.enums.ErrorCodeConstants.EM_ALERT_NOT_EXISTS;
+
+/**
+ * MES 鑳借�楅璀� Service 瀹炵幇绫�
+ *
+ * @author 瓒呯骇绠$悊鍛�
+ */
+@Service
+@Validated
+public class MesEmAlertServiceImpl implements MesEmAlertService {
+
+ private static final BigDecimal HUNDRED = new BigDecimal("100");
+ private static final BigDecimal DEFAULT_MOM_RATIO = new BigDecimal("30");
+ private static final BigDecimal DEFAULT_YOY_RATIO = new BigDecimal("30");
+ private static final DateTimeFormatter DATE_NO_FORMATTER = DateTimeFormatter.ofPattern("yyyyMMdd");
+
+ @Resource
+ private MesEmAlertMapper alertMapper;
+ @Resource
+ private MesEmRecordMapper recordMapper;
+ @Resource
+ private MesEmMeterMapper meterMapper;
+ @Resource
+ private MesEmQuotaMapper quotaMapper;
+
+ @Override
+ public void checkRecord(MesEmRecordDO record) {
+ MesEmMeterDO meter = meterMapper.selectById(record.getMeterId());
+ checkQuota(record, MesEmQuotaPeriodEnum.DAY);
+ checkQuota(record, MesEmQuotaPeriodEnum.MONTH);
+ checkMomentum(record);
+ checkLeak(record, meter);
+ }
+
+ /**
+ * 瀹氶棰勮锛氭棩瀹氶姣旇緝褰撴棩鐢ㄩ噺锛屾湀瀹氶姣旇緝鏈堝垵鑷冲綋鏃ョ疮璁$敤閲�
+ */
+ private void checkQuota(MesEmRecordDO record, MesEmQuotaPeriodEnum period) {
+ List<MesEmQuotaDO> quotas = quotaMapper.selectListByObject(record.getEnergyType(), period.getPeriod(),
+ record.getWorkshopId(), record.getLineId(), record.getMachineryId());
+ MesEmQuotaDO quota = mostSpecificQuota(quotas);
+ if (quota == null) {
+ return;
+ }
+ LocalDate begin = MesEmQuotaPeriodEnum.MONTH.equals(period)
+ ? record.getRecordDate().withDayOfMonth(1) : record.getRecordDate();
+ BigDecimal actual = recordMapper.sumUsage(record.getEnergyType(), quota.getObjectType(),
+ quota.getObjectId(), begin, record.getRecordDate());
+ BigDecimal quotaValue = quota.getQuotaValue() == null ? BigDecimal.ZERO : quota.getQuotaValue();
+ BigDecimal warnRatio = defaultIfNull(quota.getWarnRatio(), new BigDecimal("10"));
+ BigDecimal alarmRatio = defaultIfNull(quota.getAlarmRatio(), new BigDecimal("20"));
+ BigDecimal warnThreshold = quotaValue.multiply(BigDecimal.ONE.add(
+ warnRatio.divide(HUNDRED, 6, RoundingMode.HALF_UP)));
+ BigDecimal alarmThreshold = quotaValue.multiply(BigDecimal.ONE.add(
+ alarmRatio.divide(HUNDRED, 6, RoundingMode.HALF_UP)));
+
+ Long objectId = quota.getObjectId() == null ? 0L : quota.getObjectId();
+ if (actual.compareTo(warnThreshold) <= 0) {
+ // 鐢ㄩ噺鍥炶惤鍒伴槇鍊煎唴鏃讹紝鎾ら攢灏氭湭澶勭悊鐨勯璀�
+ deleteIfPending(0L, MesEmAlertTypeEnum.QUOTA.getType(), record.getRecordDate(), objectId);
+ return;
+ }
+ BigDecimal exceedRate = rate(actual, quotaValue);
+ String unit = StrUtil.blankToDefault(record.getUnit(), StrUtil.blankToDefault(quota.getUnit(), ""));
+ String content = StrUtil.format("{}{} {} 鐢ㄩ噺 {} {}锛屽畾棰� {} {}锛岃秴鍑� {}%", period.getName(),
+ quota.getObjectName(), MesEmEnergyTypeEnum.getName(record.getEnergyType()),
+ stripZeros(actual), unit, stripZeros(quotaValue), unit,
+ exceedRate == null ? "-" : stripZeros(exceedRate));
+ MesEmAlertDO alert = buildAlert(record, 0L, "", quota.getObjectName(),
+ MesEmAlertTypeEnum.QUOTA, actual.compareTo(alarmThreshold) > 0
+ ? MesEmAlertLevelEnum.SERIOUS : MesEmAlertLevelEnum.WARN,
+ quota.getObjectType(), objectId, actual, quotaValue, unit, content);
+ upsertAlert(alert);
+ }
+
+ /**
+ * 鐜瘮 / 鍚屾瘮寮傚父棰勮锛氫笌涓婃棩銆佸幓骞村悓鏃ユ瘮杈�
+ */
+ private void checkMomentum(MesEmRecordDO record) {
+ List<MesEmQuotaDO> quotas = quotaMapper.selectListByObject(record.getEnergyType(), null,
+ record.getWorkshopId(), record.getLineId(), record.getMachineryId());
+ MesEmQuotaDO quota = mostSpecificQuota(quotas);
+ BigDecimal momRatio = quota == null ? DEFAULT_MOM_RATIO : defaultIfNull(quota.getMomWarnRatio(), DEFAULT_MOM_RATIO);
+ BigDecimal yoyRatio = quota == null ? DEFAULT_YOY_RATIO : defaultIfNull(quota.getYoyWarnRatio(), DEFAULT_YOY_RATIO);
+ BigDecimal current = defaultIfNull(record.getUsageAmount(), BigDecimal.ZERO);
+ String unit = StrUtil.blankToDefault(record.getUnit(), "");
+
+ // 鐜瘮锛氭槰鏃�
+ LocalDate prevDate = record.getRecordDate().minusDays(1);
+ BigDecimal previous = recordMapper.sumMeterUsage(record.getMeterId(), prevDate, prevDate);
+ checkMomentumItem(record, current, previous, momRatio, unit,
+ MesEmAlertTypeEnum.MOM, "鐜瘮", prevDate);
+
+ // 鍚屾瘮锛氬幓骞村悓鏃�
+ LocalDate lastYearDate = record.getRecordDate().minusYears(1);
+ BigDecimal lastYear = recordMapper.sumMeterUsage(record.getMeterId(), lastYearDate, lastYearDate);
+ checkMomentumItem(record, current, lastYear, yoyRatio, unit,
+ MesEmAlertTypeEnum.YOY, "鍚屾瘮", lastYearDate);
+ }
+
+ private void checkMomentumItem(MesEmRecordDO record, BigDecimal current, BigDecimal base,
+ BigDecimal thresholdRatio, String unit, MesEmAlertTypeEnum alertType,
+ String label, LocalDate baseDate) {
+ if (base == null || base.compareTo(BigDecimal.ZERO) <= 0) {
+ deleteIfPending(record.getMeterId(), alertType.getType(), record.getRecordDate(), 0L);
+ return;
+ }
+ BigDecimal changeRate = rate(current, base);
+ if (changeRate == null || changeRate.compareTo(thresholdRatio) <= 0) {
+ deleteIfPending(record.getMeterId(), alertType.getType(), record.getRecordDate(), 0L);
+ return;
+ }
+ MesEmAlertLevelEnum level = changeRate.compareTo(thresholdRatio.multiply(new BigDecimal("2"))) > 0
+ ? MesEmAlertLevelEnum.SERIOUS : MesEmAlertLevelEnum.WARN;
+ String content = StrUtil.format("{} {} {} 鐢ㄩ噺 {} {}锛岃緝 {} 鐨� {} {} 涓婂崌 {}%锛岃秴杩噞}寮傚父闃堝�� {}%",
+ record.getMeterName(), MesEmEnergyTypeEnum.getName(record.getEnergyType()), label,
+ stripZeros(current), unit, baseDate, label, stripZeros(base), stripZeros(changeRate),
+ label, stripZeros(thresholdRatio));
+ MesEmAlertDO alert = buildAlert(record, record.getMeterId(), record.getMeterCode(), record.getMeterName(),
+ alertType, level, resolveObjectType(record), resolveObjectId(record),
+ current, base, unit, content);
+ upsertAlert(alert);
+ }
+
+ /**
+ * 鐤戜技璺戝啋婊存紡棰勮锛氬綋鏃ョ敤閲忚秴杩囪閲忕偣閰嶇疆鐨勫紓甯镐笂闄�
+ */
+ private void checkLeak(MesEmRecordDO record, MesEmMeterDO meter) {
+ BigDecimal threshold = meter == null ? null : meter.getLeakThreshold();
+ BigDecimal current = defaultIfNull(record.getUsageAmount(), BigDecimal.ZERO);
+ if (threshold == null || current.compareTo(threshold) <= 0) {
+ deleteIfPending(record.getMeterId(), MesEmAlertTypeEnum.LEAK.getType(), record.getRecordDate(), 0L);
+ return;
+ }
+ MesEmAlertLevelEnum level = current.compareTo(threshold.multiply(new BigDecimal("1.5"))) > 0
+ ? MesEmAlertLevelEnum.SERIOUS : MesEmAlertLevelEnum.WARN;
+ String unit = StrUtil.blankToDefault(record.getUnit(), "");
+ String content = StrUtil.format("{} 褰撴棩鐢ㄩ噺 {} {}锛岃秴杩囨棩鐢ㄩ噺寮傚父涓婇檺 {} {}锛岀枒浼艰窇鍐掓淮婕�",
+ record.getMeterName(), stripZeros(current), unit, stripZeros(threshold), unit);
+ MesEmAlertDO alert = buildAlert(record, record.getMeterId(), record.getMeterCode(), record.getMeterName(),
+ MesEmAlertTypeEnum.LEAK, level, resolveObjectType(record), resolveObjectId(record),
+ current, threshold, unit, content);
+ upsertAlert(alert);
+ }
+
+ private MesEmAlertDO buildAlert(MesEmRecordDO record, Long meterId, String meterCode, String meterName,
+ MesEmAlertTypeEnum alertType, MesEmAlertLevelEnum alertLevel,
+ Integer objectType, Long objectId,
+ BigDecimal actualValue, BigDecimal thresholdValue,
+ String unit, String content) {
+ MesEmAlertDO alert = new MesEmAlertDO();
+ alert.setAlertNo(buildAlertNo(record.getRecordDate(), meterId, alertType.getType(), objectId));
+ alert.setMeterId(meterId);
+ alert.setMeterCode(meterCode);
+ alert.setMeterName(meterName);
+ alert.setEnergyType(record.getEnergyType());
+ alert.setAlertType(alertType.getType());
+ alert.setAlertLevel(alertLevel.getLevel());
+ alert.setAlertDate(record.getRecordDate());
+ alert.setObjectType(objectType);
+ alert.setObjectId(objectId);
+ alert.setObjectName(meterName);
+ alert.setActualValue(actualValue);
+ alert.setThresholdValue(thresholdValue);
+ alert.setUnit(unit);
+ alert.setContent(content);
+ alert.setStatus(MesEmAlertStatusEnum.PENDING.getStatus());
+ return alert;
+ }
+
+ private void upsertAlert(MesEmAlertDO alert) {
+ MesEmAlertDO existing = alertMapper.selectByUnique(alert.getMeterId(), alert.getAlertType(),
+ alert.getAlertDate(), alert.getObjectId());
+ if (existing == null) {
+ alertMapper.insert(alert);
+ return;
+ }
+ alert.setId(existing.getId());
+ alert.setAlertNo(existing.getAlertNo());
+ alert.setStatus(existing.getStatus());
+ alertMapper.updateById(alert);
+ }
+
+ private void deleteIfPending(Long meterId, Integer alertType, LocalDate alertDate, Long objectId) {
+ MesEmAlertDO existing = alertMapper.selectByUnique(meterId, alertType, alertDate, objectId);
+ if (existing != null && MesEmAlertStatusEnum.PENDING.getStatus().equals(existing.getStatus())) {
+ alertMapper.deleteById(existing.getId());
+ }
+ }
+
+ private String buildAlertNo(LocalDate date, Long meterId, Integer alertType, Long objectId) {
+ return "AL" + date.format(DATE_NO_FORMATTER) + "-" + meterId + "-" + alertType + "-" + objectId;
+ }
+
+ private MesEmQuotaDO mostSpecificQuota(List<MesEmQuotaDO> quotas) {
+ if (CollUtil.isEmpty(quotas)) {
+ return null;
+ }
+ return quotas.stream()
+ .max(Comparator.comparing(MesEmQuotaDO::getObjectType)
+ .thenComparing(MesEmQuotaDO::getId))
+ .orElse(null);
+ }
+
+ private Integer resolveObjectType(MesEmRecordDO record) {
+ if (record.getMachineryId() != null) {
+ return MesEmQuotaObjectTypeEnum.MACHINERY.getType();
+ }
+ if (record.getLineId() != null) {
+ return MesEmQuotaObjectTypeEnum.LINE.getType();
+ }
+ if (record.getWorkshopId() != null) {
+ return MesEmQuotaObjectTypeEnum.WORKSHOP.getType();
+ }
+ return MesEmQuotaObjectTypeEnum.FACTORY.getType();
+ }
+
+ private Long resolveObjectId(MesEmRecordDO record) {
+ if (record.getMachineryId() != null) {
+ return record.getMachineryId();
+ }
+ if (record.getLineId() != null) {
+ return record.getLineId();
+ }
+ if (record.getWorkshopId() != null) {
+ return record.getWorkshopId();
+ }
+ return 0L;
+ }
+
+ private BigDecimal defaultIfNull(BigDecimal value, BigDecimal defaultValue) {
+ return value == null ? defaultValue : value;
+ }
+
+ /**
+ * 璁$畻鍙樺寲鐜囷紙%锛夛紝鍩烘暟涓� 0 鏃惰繑鍥� null
+ */
+ private BigDecimal rate(BigDecimal current, BigDecimal base) {
+ if (base == null || base.compareTo(BigDecimal.ZERO) == 0) {
+ return null;
+ }
+ return current.subtract(base).multiply(HUNDRED).divide(base, 2, RoundingMode.HALF_UP);
+ }
+
+ private String stripZeros(BigDecimal value) {
+ if (value == null) {
+ return "0";
+ }
+ return value.stripTrailingZeros().toPlainString();
+ }
+
+ @Override
+ public int checkRange(LocalDate begin, LocalDate end) {
+ List<MesEmRecordDO> records = recordMapper.selectListByDateRange(begin, end);
+ records.forEach(this::checkRecord);
+ return records.size();
+ }
+
+ @Override
+ public void deleteMeterAlerts(Long meterId, LocalDate alertDate) {
+ alertMapper.deleteByMeterIdAndDate(meterId, alertDate);
+ }
+
+ @Override
+ public MesEmAlertDO getAlert(Long id) {
+ return alertMapper.selectById(id);
+ }
+
+ @Override
+ public PageResult<MesEmAlertDO> getAlertPage(MesEmAlertPageReqVO pageReqVO) {
+ return alertMapper.selectPage(pageReqVO);
+ }
+
+ @Override
+ public List<MesEmAlertRespVO> getAlertRespVOList(List<MesEmAlertDO> list) {
+ if (CollUtil.isEmpty(list)) {
+ return Collections.emptyList();
+ }
+ return BeanUtils.toBean(list, MesEmAlertRespVO.class, vo -> {
+ vo.setEnergyTypeName(MesEmEnergyTypeEnum.getName(vo.getEnergyType()));
+ vo.setAlertTypeName(MesEmAlertTypeEnum.getName(vo.getAlertType()));
+ vo.setAlertLevelName(MesEmAlertLevelEnum.getName(vo.getAlertLevel()));
+ vo.setObjectTypeName(MesEmQuotaObjectTypeEnum.getName(vo.getObjectType()));
+ vo.setStatusName(MesEmAlertStatusEnum.getName(vo.getStatus()));
+ });
+ }
+
+ @Override
+ public void handleAlert(MesEmAlertHandleReqVO handleReqVO) {
+ MesEmAlertDO alert = alertMapper.selectById(handleReqVO.getId());
+ if (alert == null) {
+ throw exception(EM_ALERT_NOT_EXISTS);
+ }
+ if (MesEmAlertStatusEnum.HANDLED.getStatus().equals(alert.getStatus())) {
+ throw exception(EM_ALERT_ALREADY_HANDLED);
+ }
+ alertMapper.updateById(new MesEmAlertDO().setId(alert.getId())
+ .setStatus(MesEmAlertStatusEnum.HANDLED.getStatus())
+ .setHandleUserId(SecurityFrameworkUtils.getLoginUserId())
+ .setHandleUserName(SecurityFrameworkUtils.getLoginUserNickname())
+ .setHandleTime(LocalDateTime.now())
+ .setHandleRemark(handleReqVO.getHandleRemark()));
+ }
+
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/em/meter/MesEmMeterService.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/em/meter/MesEmMeterService.java
new file mode 100644
index 0000000..bfc1515
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/em/meter/MesEmMeterService.java
@@ -0,0 +1,46 @@
+package cn.iocoder.yudao.module.mes.service.em.meter;
+
+import cn.iocoder.yudao.framework.common.pojo.PageResult;
+import cn.iocoder.yudao.module.mes.controller.admin.em.meter.vo.MesEmMeterPageReqVO;
+import cn.iocoder.yudao.module.mes.controller.admin.em.meter.vo.MesEmMeterRespVO;
+import cn.iocoder.yudao.module.mes.controller.admin.em.meter.vo.MesEmMeterSaveReqVO;
+import cn.iocoder.yudao.module.mes.controller.admin.em.meter.vo.MesEmOptionRespVO;
+import cn.iocoder.yudao.module.mes.dal.dataobject.em.meter.MesEmMeterDO;
+
+import java.util.Collection;
+import java.util.List;
+
+/**
+ * MES 鑳借�楄閲忕偣 Service
+ *
+ * @author 瓒呯骇绠$悊鍛�
+ */
+public interface MesEmMeterService {
+
+ Long createMeter(MesEmMeterSaveReqVO createReqVO);
+
+ void updateMeter(MesEmMeterSaveReqVO updateReqVO);
+
+ void deleteMeter(Long id);
+
+ MesEmMeterDO getMeter(Long id);
+
+ void validateMeterExists(Long id);
+
+ PageResult<MesEmMeterDO> getMeterPage(MesEmMeterPageReqVO pageReqVO);
+
+ List<MesEmMeterDO> getMeterList();
+
+ List<MesEmMeterDO> getMeterList(Collection<Long> ids);
+
+ List<MesEmMeterRespVO> getMeterRespVOList(List<MesEmMeterDO> list);
+
+ List<MesEmOptionRespVO> getMeterSimpleList();
+
+ List<MesEmOptionRespVO> getWorkshopOptions();
+
+ List<MesEmOptionRespVO> getLineOptions();
+
+ List<MesEmOptionRespVO> getMachineryOptions();
+
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/em/meter/MesEmMeterServiceImpl.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/em/meter/MesEmMeterServiceImpl.java
new file mode 100644
index 0000000..5701fd2
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/em/meter/MesEmMeterServiceImpl.java
@@ -0,0 +1,249 @@
+package cn.iocoder.yudao.module.mes.service.em.meter;
+
+import cn.hutool.core.collection.CollUtil;
+import cn.hutool.core.util.ObjUtil;
+import cn.hutool.core.util.StrUtil;
+import cn.iocoder.yudao.framework.common.pojo.PageResult;
+import cn.iocoder.yudao.framework.common.util.collection.MapUtils;
+import cn.iocoder.yudao.framework.common.util.object.BeanUtils;
+import cn.iocoder.yudao.module.mes.controller.admin.em.meter.vo.MesEmMeterPageReqVO;
+import cn.iocoder.yudao.module.mes.controller.admin.em.meter.vo.MesEmMeterRespVO;
+import cn.iocoder.yudao.module.mes.controller.admin.em.meter.vo.MesEmMeterSaveReqVO;
+import cn.iocoder.yudao.module.mes.controller.admin.em.meter.vo.MesEmOptionRespVO;
+import cn.iocoder.yudao.module.mes.dal.dataobject.dv.machinery.MesDvMachineryDO;
+import cn.iocoder.yudao.module.mes.dal.dataobject.em.meter.MesEmMeterDO;
+import cn.iocoder.yudao.module.mes.dal.dataobject.md.workstation.MesMdWorkshopDO;
+import cn.iocoder.yudao.module.mes.dal.mysql.dv.machinery.MesDvMachineryMapper;
+import cn.iocoder.yudao.module.mes.dal.mysql.em.meter.MesEmMeterMapper;
+import cn.iocoder.yudao.module.mes.dal.mysql.em.record.MesEmRecordMapper;
+import cn.iocoder.yudao.module.mes.dal.mysql.md.workstation.MesMdWorkshopMapper;
+import cn.iocoder.yudao.module.mes.enums.em.MesEmEnergyTypeEnum;
+import cn.iocoder.yudao.module.mes.enums.em.MesEmMeterStatusEnum;
+import cn.iocoder.yudao.module.system.api.user.AdminUserApi;
+import cn.iocoder.yudao.module.system.api.user.dto.AdminUserRespDTO;
+import jakarta.annotation.Resource;
+import org.springframework.stereotype.Service;
+import org.springframework.validation.annotation.Validated;
+
+import java.math.BigDecimal;
+import java.util.Collection;
+import java.util.Collections;
+import java.util.List;
+import java.util.Map;
+import java.util.function.Function;
+import java.util.stream.Collectors;
+
+import static cn.iocoder.yudao.framework.common.exception.util.ServiceExceptionUtil.exception;
+import static cn.iocoder.yudao.framework.common.util.collection.CollectionUtils.convertSet;
+import static cn.iocoder.yudao.module.mes.enums.ErrorCodeConstants.*;
+
+/**
+ * MES 鑳借�楄閲忕偣 Service 瀹炵幇绫�
+ *
+ * @author 瓒呯骇绠$悊鍛�
+ */
+@Service
+@Validated
+public class MesEmMeterServiceImpl implements MesEmMeterService {
+
+ @Resource
+ private MesEmMeterMapper meterMapper;
+ @Resource
+ private MesEmRecordMapper recordMapper;
+ @Resource
+ private MesMdWorkshopMapper workshopMapper;
+ @Resource
+ private MesDvMachineryMapper machineryMapper;
+ @Resource
+ private AdminUserApi adminUserApi;
+
+ @Override
+ public Long createMeter(MesEmMeterSaveReqVO createReqVO) {
+ validateMeterCodeUnique(null, createReqVO.getCode());
+ MesEmMeterDO meter = BeanUtils.toBean(createReqVO, MesEmMeterDO.class);
+ fillMeterDefaultsAndNames(meter);
+ meterMapper.insert(meter);
+ return meter.getId();
+ }
+
+ @Override
+ public void updateMeter(MesEmMeterSaveReqVO updateReqVO) {
+ validateMeterExists(updateReqVO.getId());
+ validateMeterCodeUnique(updateReqVO.getId(), updateReqVO.getCode());
+ MesEmMeterDO meter = BeanUtils.toBean(updateReqVO, MesEmMeterDO.class);
+ fillMeterDefaultsAndNames(meter);
+ meterMapper.updateById(meter);
+ }
+
+ @Override
+ public void deleteMeter(Long id) {
+ validateMeterExists(id);
+ if (recordMapper.selectCountByMeterId(id) > 0) {
+ throw exception(EM_METER_HAS_RECORD);
+ }
+ meterMapper.deleteById(id);
+ }
+
+ @Override
+ public MesEmMeterDO getMeter(Long id) {
+ return meterMapper.selectById(id);
+ }
+
+ @Override
+ public void validateMeterExists(Long id) {
+ if (meterMapper.selectById(id) == null) {
+ throw exception(EM_METER_NOT_EXISTS);
+ }
+ }
+
+ private void validateMeterCodeUnique(Long id, String code) {
+ if (StrUtil.isBlank(code)) {
+ return;
+ }
+ MesEmMeterDO meter = meterMapper.selectByCode(code);
+ if (meter == null) {
+ return;
+ }
+ if (ObjUtil.notEqual(meter.getId(), id)) {
+ throw exception(EM_METER_CODE_DUPLICATE);
+ }
+ }
+
+ /**
+ * 琛ュ叏鍗曚綅銆佸�嶇巼銆佹姌鏍囩叅绯绘暟锛屽苟鍐椾綑杞﹂棿/浜х嚎/璁惧鍚嶇О
+ */
+ private void fillMeterDefaultsAndNames(MesEmMeterDO meter) {
+ MesEmEnergyTypeEnum energyType = MesEmEnergyTypeEnum.getByType(meter.getEnergyType());
+ if (StrUtil.isBlank(meter.getUnit()) && energyType != null) {
+ meter.setUnit(energyType.getUnit());
+ }
+ if (meter.getRatio() == null) {
+ meter.setRatio(BigDecimal.ONE);
+ }
+ if (meter.getInitialReading() == null) {
+ meter.setInitialReading(BigDecimal.ZERO);
+ }
+ if (meter.getCoalFactor() == null && energyType != null) {
+ meter.setCoalFactor(energyType.getCoalFactor());
+ }
+ if (meter.getStatus() == null) {
+ meter.setStatus(MesEmMeterStatusEnum.ENABLE.getStatus());
+ }
+ // 杞﹂棿
+ if (meter.getWorkshopId() != null) {
+ MesMdWorkshopDO workshop = workshopMapper.selectById(meter.getWorkshopId());
+ if (workshop == null) {
+ throw exception(EM_METER_OBJECT_NOT_EXISTS);
+ }
+ meter.setWorkshopName(workshop.getName());
+ } else {
+ meter.setWorkshopName(null);
+ }
+ // 浜х嚎
+ if (meter.getLineId() != null) {
+ MesEmOptionRespVO line = meterMapper.selectLineOptionById(meter.getLineId());
+ if (line == null) {
+ throw exception(EM_METER_OBJECT_NOT_EXISTS);
+ }
+ meter.setLineName(line.getName());
+ } else {
+ meter.setLineName(null);
+ }
+ // 璁惧锛涙湭閫夋嫨杞﹂棿鏃惰嚜鍔ㄥ甫鍏ヨ澶囨墍灞炶溅闂�
+ if (meter.getMachineryId() != null) {
+ MesDvMachineryDO machinery = machineryMapper.selectById(meter.getMachineryId());
+ if (machinery == null) {
+ throw exception(EM_METER_OBJECT_NOT_EXISTS);
+ }
+ meter.setMachineryName(machinery.getName());
+ if (meter.getWorkshopId() == null && machinery.getWorkshopId() != null) {
+ MesMdWorkshopDO workshop = workshopMapper.selectById(machinery.getWorkshopId());
+ if (workshop != null) {
+ meter.setWorkshopId(workshop.getId());
+ meter.setWorkshopName(workshop.getName());
+ }
+ }
+ } else {
+ meter.setMachineryName(null);
+ }
+ }
+
+ @Override
+ public PageResult<MesEmMeterDO> getMeterPage(MesEmMeterPageReqVO pageReqVO) {
+ return meterMapper.selectPage(pageReqVO);
+ }
+
+ @Override
+ public List<MesEmMeterDO> getMeterList() {
+ return meterMapper.selectList();
+ }
+
+ @Override
+ public List<MesEmMeterDO> getMeterList(Collection<Long> ids) {
+ if (CollUtil.isEmpty(ids)) {
+ return Collections.emptyList();
+ }
+ return meterMapper.selectByIds(ids);
+ }
+
+ @Override
+ public List<MesEmMeterRespVO> getMeterRespVOList(List<MesEmMeterDO> list) {
+ if (CollUtil.isEmpty(list)) {
+ return Collections.emptyList();
+ }
+ Map<Long, AdminUserRespDTO> userMap = CollUtil.isNotEmpty(convertSet(list, MesEmMeterDO::getChargeUserId))
+ ? adminUserApi.getUserMap(convertSet(list, MesEmMeterDO::getChargeUserId))
+ : Collections.emptyMap();
+ return BeanUtils.toBean(list, MesEmMeterRespVO.class, vo -> {
+ vo.setEnergyTypeName(MesEmEnergyTypeEnum.getName(vo.getEnergyType()));
+ vo.setStatusName(MesEmMeterStatusEnum.getName(vo.getStatus()));
+ MapUtils.findAndThen(userMap, vo.getChargeUserId(), user -> vo.setChargeUserName(user.getNickname()));
+ });
+ }
+
+ @Override
+ public List<MesEmOptionRespVO> getMeterSimpleList() {
+ List<MesEmMeterDO> list = meterMapper.selectListByStatus(MesEmMeterStatusEnum.ENABLE.getStatus());
+ return list.stream().map(meter -> {
+ MesEmOptionRespVO option = new MesEmOptionRespVO();
+ option.setId(meter.getId());
+ option.setCode(meter.getCode());
+ option.setName(meter.getName());
+ option.setEnergyType(meter.getEnergyType());
+ option.setUnit(meter.getUnit());
+ option.setWorkshopId(meter.getWorkshopId());
+ option.setWorkshopName(meter.getWorkshopName());
+ option.setLineId(meter.getLineId());
+ option.setLineName(meter.getLineName());
+ return option;
+ }).collect(Collectors.toList());
+ }
+
+ @Override
+ public List<MesEmOptionRespVO> getWorkshopOptions() {
+ return meterMapper.selectWorkshopOptions();
+ }
+
+ @Override
+ public List<MesEmOptionRespVO> getLineOptions() {
+ return meterMapper.selectLineOptions();
+ }
+
+ @Override
+ public List<MesEmOptionRespVO> getMachineryOptions() {
+ List<MesEmOptionRespVO> options = meterMapper.selectMachineryOptions();
+ if (CollUtil.isEmpty(options)) {
+ return options;
+ }
+ Map<Long, MesMdWorkshopDO> workshopMap = workshopMapper.selectList().stream()
+ .collect(Collectors.toMap(MesMdWorkshopDO::getId, Function.identity(), (a, b) -> a));
+ options.forEach(option -> {
+ MesMdWorkshopDO workshop = workshopMap.get(option.getWorkshopId());
+ if (workshop != null) {
+ option.setWorkshopName(workshop.getName());
+ }
+ });
+ return options;
+ }
+
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/em/quota/MesEmQuotaService.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/em/quota/MesEmQuotaService.java
new file mode 100644
index 0000000..22f6e1f
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/em/quota/MesEmQuotaService.java
@@ -0,0 +1,32 @@
+package cn.iocoder.yudao.module.mes.service.em.quota;
+
+import cn.iocoder.yudao.framework.common.pojo.PageResult;
+import cn.iocoder.yudao.module.mes.controller.admin.em.quota.vo.MesEmQuotaPageReqVO;
+import cn.iocoder.yudao.module.mes.controller.admin.em.quota.vo.MesEmQuotaRespVO;
+import cn.iocoder.yudao.module.mes.controller.admin.em.quota.vo.MesEmQuotaSaveReqVO;
+import cn.iocoder.yudao.module.mes.dal.dataobject.em.quota.MesEmQuotaDO;
+
+import java.util.List;
+
+/**
+ * MES 鑳借�楄�冩牳鎸囨爣 Service
+ *
+ * @author 瓒呯骇绠$悊鍛�
+ */
+public interface MesEmQuotaService {
+
+ Long createQuota(MesEmQuotaSaveReqVO createReqVO);
+
+ void updateQuota(MesEmQuotaSaveReqVO updateReqVO);
+
+ void deleteQuota(Long id);
+
+ MesEmQuotaDO getQuota(Long id);
+
+ void validateQuotaExists(Long id);
+
+ PageResult<MesEmQuotaDO> getQuotaPage(MesEmQuotaPageReqVO pageReqVO);
+
+ List<MesEmQuotaRespVO> getQuotaRespVOList(List<MesEmQuotaDO> list);
+
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/em/quota/MesEmQuotaServiceImpl.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/em/quota/MesEmQuotaServiceImpl.java
new file mode 100644
index 0000000..340c2e4
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/em/quota/MesEmQuotaServiceImpl.java
@@ -0,0 +1,157 @@
+package cn.iocoder.yudao.module.mes.service.em.quota;
+
+import cn.hutool.core.collection.CollUtil;
+import cn.hutool.core.util.StrUtil;
+import cn.iocoder.yudao.framework.common.pojo.PageResult;
+import cn.iocoder.yudao.framework.common.util.object.BeanUtils;
+import cn.iocoder.yudao.module.mes.controller.admin.em.meter.vo.MesEmOptionRespVO;
+import cn.iocoder.yudao.module.mes.controller.admin.em.quota.vo.MesEmQuotaPageReqVO;
+import cn.iocoder.yudao.module.mes.controller.admin.em.quota.vo.MesEmQuotaRespVO;
+import cn.iocoder.yudao.module.mes.controller.admin.em.quota.vo.MesEmQuotaSaveReqVO;
+import cn.iocoder.yudao.module.mes.dal.dataobject.dv.machinery.MesDvMachineryDO;
+import cn.iocoder.yudao.module.mes.dal.dataobject.em.quota.MesEmQuotaDO;
+import cn.iocoder.yudao.module.mes.dal.dataobject.md.workstation.MesMdWorkshopDO;
+import cn.iocoder.yudao.module.mes.dal.mysql.dv.machinery.MesDvMachineryMapper;
+import cn.iocoder.yudao.module.mes.dal.mysql.em.meter.MesEmMeterMapper;
+import cn.iocoder.yudao.module.mes.dal.mysql.em.quota.MesEmQuotaMapper;
+import cn.iocoder.yudao.module.mes.dal.mysql.md.workstation.MesMdWorkshopMapper;
+import cn.iocoder.yudao.module.mes.enums.em.MesEmEnergyTypeEnum;
+import cn.iocoder.yudao.module.mes.enums.em.MesEmMeterStatusEnum;
+import cn.iocoder.yudao.module.mes.enums.em.MesEmQuotaObjectTypeEnum;
+import cn.iocoder.yudao.module.mes.enums.em.MesEmQuotaPeriodEnum;
+import jakarta.annotation.Resource;
+import org.springframework.stereotype.Service;
+import org.springframework.validation.annotation.Validated;
+
+import java.math.BigDecimal;
+import java.util.Collections;
+import java.util.List;
+
+import static cn.iocoder.yudao.framework.common.exception.util.ServiceExceptionUtil.exception;
+import static cn.iocoder.yudao.module.mes.enums.ErrorCodeConstants.EM_QUOTA_NOT_EXISTS;
+import static cn.iocoder.yudao.module.mes.enums.ErrorCodeConstants.EM_QUOTA_OBJECT_NOT_EXISTS;
+
+/**
+ * MES 鑳借�楄�冩牳鎸囨爣 Service 瀹炵幇绫�
+ *
+ * @author 瓒呯骇绠$悊鍛�
+ */
+@Service
+@Validated
+public class MesEmQuotaServiceImpl implements MesEmQuotaService {
+
+ @Resource
+ private MesEmQuotaMapper quotaMapper;
+ @Resource
+ private MesEmMeterMapper meterMapper;
+ @Resource
+ private MesMdWorkshopMapper workshopMapper;
+ @Resource
+ private MesDvMachineryMapper machineryMapper;
+
+ @Override
+ public Long createQuota(MesEmQuotaSaveReqVO createReqVO) {
+ MesEmQuotaDO quota = BeanUtils.toBean(createReqVO, MesEmQuotaDO.class);
+ fillQuotaDefaultsAndObjectName(quota);
+ quotaMapper.insert(quota);
+ return quota.getId();
+ }
+
+ @Override
+ public void updateQuota(MesEmQuotaSaveReqVO updateReqVO) {
+ validateQuotaExists(updateReqVO.getId());
+ MesEmQuotaDO quota = BeanUtils.toBean(updateReqVO, MesEmQuotaDO.class);
+ fillQuotaDefaultsAndObjectName(quota);
+ quotaMapper.updateById(quota);
+ }
+
+ @Override
+ public void deleteQuota(Long id) {
+ validateQuotaExists(id);
+ quotaMapper.deleteById(id);
+ }
+
+ @Override
+ public MesEmQuotaDO getQuota(Long id) {
+ return quotaMapper.selectById(id);
+ }
+
+ @Override
+ public void validateQuotaExists(Long id) {
+ if (quotaMapper.selectById(id) == null) {
+ throw exception(EM_QUOTA_NOT_EXISTS);
+ }
+ }
+
+ private void fillQuotaDefaultsAndObjectName(MesEmQuotaDO quota) {
+ MesEmEnergyTypeEnum energyType = MesEmEnergyTypeEnum.getByType(quota.getEnergyType());
+ if (StrUtil.isBlank(quota.getUnit()) && energyType != null) {
+ quota.setUnit(energyType.getUnit());
+ }
+ if (quota.getWarnRatio() == null) {
+ quota.setWarnRatio(new BigDecimal("10"));
+ }
+ if (quota.getAlarmRatio() == null) {
+ quota.setAlarmRatio(new BigDecimal("20"));
+ }
+ if (quota.getMomWarnRatio() == null) {
+ quota.setMomWarnRatio(new BigDecimal("30"));
+ }
+ if (quota.getYoyWarnRatio() == null) {
+ quota.setYoyWarnRatio(new BigDecimal("30"));
+ }
+ if (quota.getStatus() == null) {
+ quota.setStatus(MesEmMeterStatusEnum.ENABLE.getStatus());
+ }
+ // 鑰冩牳瀵硅薄鍚嶇О
+ Integer objectType = quota.getObjectType();
+ if (MesEmQuotaObjectTypeEnum.FACTORY.getType().equals(objectType)) {
+ quota.setObjectId(0L);
+ quota.setObjectName("鍏ㄥ巶");
+ return;
+ }
+ if (quota.getObjectId() == null) {
+ throw exception(EM_QUOTA_OBJECT_NOT_EXISTS);
+ }
+ if (MesEmQuotaObjectTypeEnum.WORKSHOP.getType().equals(objectType)) {
+ MesMdWorkshopDO workshop = workshopMapper.selectById(quota.getObjectId());
+ if (workshop == null) {
+ throw exception(EM_QUOTA_OBJECT_NOT_EXISTS);
+ }
+ quota.setObjectName(workshop.getName());
+ } else if (MesEmQuotaObjectTypeEnum.LINE.getType().equals(objectType)) {
+ MesEmOptionRespVO line = meterMapper.selectLineOptionById(quota.getObjectId());
+ if (line == null) {
+ throw exception(EM_QUOTA_OBJECT_NOT_EXISTS);
+ }
+ quota.setObjectName(line.getName());
+ } else if (MesEmQuotaObjectTypeEnum.MACHINERY.getType().equals(objectType)) {
+ MesDvMachineryDO machinery = machineryMapper.selectById(quota.getObjectId());
+ if (machinery == null) {
+ throw exception(EM_QUOTA_OBJECT_NOT_EXISTS);
+ }
+ quota.setObjectName(machinery.getName());
+ } else {
+ throw exception(EM_QUOTA_OBJECT_NOT_EXISTS);
+ }
+ }
+
+ @Override
+ public PageResult<MesEmQuotaDO> getQuotaPage(MesEmQuotaPageReqVO pageReqVO) {
+ return quotaMapper.selectPage(pageReqVO);
+ }
+
+ @Override
+ public List<MesEmQuotaRespVO> getQuotaRespVOList(List<MesEmQuotaDO> list) {
+ if (CollUtil.isEmpty(list)) {
+ return Collections.emptyList();
+ }
+ return BeanUtils.toBean(list, MesEmQuotaRespVO.class, vo -> {
+ vo.setEnergyTypeName(MesEmEnergyTypeEnum.getName(vo.getEnergyType()));
+ vo.setObjectTypeName(MesEmQuotaObjectTypeEnum.getName(vo.getObjectType()));
+ vo.setPeriodTypeName(MesEmQuotaPeriodEnum.getName(vo.getPeriodType()));
+ vo.setStatusName(MesEmMeterStatusEnum.getName(vo.getStatus()));
+ });
+ }
+
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/em/record/MesEmRecordService.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/em/record/MesEmRecordService.java
new file mode 100644
index 0000000..906e291
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/em/record/MesEmRecordService.java
@@ -0,0 +1,34 @@
+package cn.iocoder.yudao.module.mes.service.em.record;
+
+import cn.iocoder.yudao.framework.common.pojo.PageResult;
+import cn.iocoder.yudao.module.mes.controller.admin.em.record.vo.MesEmLastReadingRespVO;
+import cn.iocoder.yudao.module.mes.controller.admin.em.record.vo.MesEmRecordPageReqVO;
+import cn.iocoder.yudao.module.mes.controller.admin.em.record.vo.MesEmRecordRespVO;
+import cn.iocoder.yudao.module.mes.controller.admin.em.record.vo.MesEmRecordSaveReqVO;
+import cn.iocoder.yudao.module.mes.dal.dataobject.em.record.MesEmRecordDO;
+
+import java.time.LocalDate;
+import java.util.List;
+
+/**
+ * MES 鑳借�楁妱琛ㄨ褰� Service
+ *
+ * @author 瓒呯骇绠$悊鍛�
+ */
+public interface MesEmRecordService {
+
+ Long createRecord(MesEmRecordSaveReqVO createReqVO);
+
+ void updateRecord(MesEmRecordSaveReqVO updateReqVO);
+
+ void deleteRecord(Long id);
+
+ MesEmRecordDO getRecord(Long id);
+
+ PageResult<MesEmRecordDO> getRecordPage(MesEmRecordPageReqVO pageReqVO);
+
+ List<MesEmRecordRespVO> getRecordRespVOList(List<MesEmRecordDO> list);
+
+ MesEmLastReadingRespVO getLastReading(Long meterId, LocalDate recordDate, Long excludeId);
+
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/em/record/MesEmRecordServiceImpl.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/em/record/MesEmRecordServiceImpl.java
new file mode 100644
index 0000000..547b93b
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/em/record/MesEmRecordServiceImpl.java
@@ -0,0 +1,178 @@
+package cn.iocoder.yudao.module.mes.service.em.record;
+
+import cn.hutool.core.collection.CollUtil;
+import cn.hutool.core.util.ObjUtil;
+import cn.iocoder.yudao.framework.common.pojo.PageResult;
+import cn.iocoder.yudao.framework.common.util.object.BeanUtils;
+import cn.iocoder.yudao.module.mes.controller.admin.em.record.vo.MesEmLastReadingRespVO;
+import cn.iocoder.yudao.module.mes.controller.admin.em.record.vo.MesEmRecordPageReqVO;
+import cn.iocoder.yudao.module.mes.controller.admin.em.record.vo.MesEmRecordRespVO;
+import cn.iocoder.yudao.module.mes.controller.admin.em.record.vo.MesEmRecordSaveReqVO;
+import cn.iocoder.yudao.module.mes.dal.dataobject.em.meter.MesEmMeterDO;
+import cn.iocoder.yudao.module.mes.dal.dataobject.em.record.MesEmRecordDO;
+import cn.iocoder.yudao.module.mes.dal.mysql.em.record.MesEmRecordMapper;
+import cn.iocoder.yudao.module.mes.enums.em.MesEmEnergyTypeEnum;
+import cn.iocoder.yudao.module.mes.enums.em.MesEmRecordSourceEnum;
+import cn.iocoder.yudao.module.mes.service.em.alert.MesEmAlertService;
+import cn.iocoder.yudao.module.mes.service.em.meter.MesEmMeterService;
+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.util.Collections;
+import java.util.List;
+
+import static cn.iocoder.yudao.framework.common.exception.util.ServiceExceptionUtil.exception;
+import static cn.iocoder.yudao.module.mes.enums.ErrorCodeConstants.*;
+
+/**
+ * MES 鑳借�楁妱琛ㄨ褰� Service 瀹炵幇绫�
+ *
+ * @author 瓒呯骇绠$悊鍛�
+ */
+@Service
+@Validated
+public class MesEmRecordServiceImpl implements MesEmRecordService {
+
+ @Resource
+ private MesEmRecordMapper recordMapper;
+ @Resource
+ private MesEmMeterService meterService;
+ @Resource
+ private MesEmAlertService alertService;
+
+ @Override
+ public Long createRecord(MesEmRecordSaveReqVO createReqVO) {
+ MesEmMeterDO meter = meterService.getMeter(createReqVO.getMeterId());
+ if (meter == null) {
+ throw exception(EM_METER_NOT_EXISTS);
+ }
+ validateRecordDateUnique(null, createReqVO.getMeterId(), createReqVO.getRecordDate());
+
+ MesEmRecordDO record = buildRecord(createReqVO, meter, null);
+ recordMapper.insert(record);
+ // 鍐欏叆鍚庢寜瀹氶銆佺幆姣斻�佸悓姣斻�佽窇鍐掓淮婕忚鍒欐娴嬮璀�
+ alertService.checkRecord(record);
+ return record.getId();
+ }
+
+ @Override
+ public void updateRecord(MesEmRecordSaveReqVO updateReqVO) {
+ validateRecordExists(updateReqVO.getId());
+ MesEmMeterDO meter = meterService.getMeter(updateReqVO.getMeterId());
+ if (meter == null) {
+ throw exception(EM_METER_NOT_EXISTS);
+ }
+ validateRecordDateUnique(updateReqVO.getId(), updateReqVO.getMeterId(), updateReqVO.getRecordDate());
+
+ MesEmRecordDO record = buildRecord(updateReqVO, meter, updateReqVO.getId());
+ recordMapper.updateById(record);
+ alertService.checkRecord(record);
+ }
+
+ @Override
+ public void deleteRecord(Long id) {
+ MesEmRecordDO record = validateRecordExists(id);
+ recordMapper.deleteById(id);
+ // 鍚屾娓呯悊璇ヨ褰曚骇鐢熺殑鐜瘮/鍚屾瘮/璺戝啋婊存紡棰勮
+ alertService.deleteMeterAlerts(record.getMeterId(), record.getRecordDate());
+ }
+
+ @Override
+ public MesEmRecordDO getRecord(Long id) {
+ return recordMapper.selectById(id);
+ }
+
+ private MesEmRecordDO validateRecordExists(Long id) {
+ MesEmRecordDO record = recordMapper.selectById(id);
+ if (record == null) {
+ throw exception(EM_RECORD_NOT_EXISTS);
+ }
+ return record;
+ }
+
+ private void validateRecordDateUnique(Long id, Long meterId, LocalDate recordDate) {
+ MesEmRecordDO record = recordMapper.selectByMeterIdAndDate(meterId, recordDate);
+ if (record != null && ObjUtil.notEqual(record.getId(), id)) {
+ throw exception(EM_RECORD_DATE_DUPLICATE);
+ }
+ }
+
+ /**
+ * 鏋勫缓鎶勮〃璁板綍锛氳嚜鍔ㄨ绠楃敤閲忎笌璐圭敤锛屽苟鍐椾綑璁¢噺鐐�/杞﹂棿/浜х嚎/璁惧蹇収
+ */
+ private MesEmRecordDO buildRecord(MesEmRecordSaveReqVO reqVO, MesEmMeterDO meter, Long id) {
+ // 鏈熷垵璇绘暟锛氭湭濉啓鏃跺彇涓婁竴鏉¤褰曡鏁帮紝娌℃湁鍘嗗彶璁板綍鍒欏彇璁¢噺鐐瑰垵濮嬭鏁�
+ BigDecimal prevReading = reqVO.getPrevReading();
+ if (prevReading == null) {
+ MesEmRecordDO lastRecord = recordMapper.selectLastByMeterId(
+ reqVO.getMeterId(), reqVO.getRecordDate(), id);
+ prevReading = lastRecord != null ? lastRecord.getReading() : meter.getInitialReading();
+ }
+ if (prevReading == null) {
+ prevReading = BigDecimal.ZERO;
+ }
+ if (reqVO.getReading().compareTo(prevReading) < 0) {
+ throw exception(EM_RECORD_READING_INVALID);
+ }
+ BigDecimal ratio = meter.getRatio() == null ? BigDecimal.ONE : meter.getRatio();
+ BigDecimal usage = reqVO.getReading().subtract(prevReading).multiply(ratio);
+ BigDecimal price = reqVO.getPrice() == null ? BigDecimal.ZERO : reqVO.getPrice();
+ BigDecimal cost = usage.multiply(price).setScale(2, RoundingMode.HALF_UP);
+
+ MesEmRecordDO record = BeanUtils.toBean(reqVO, MesEmRecordDO.class);
+ record.setId(id);
+ record.setMeterCode(meter.getCode());
+ record.setMeterName(meter.getName());
+ record.setEnergyType(meter.getEnergyType());
+ record.setUnit(meter.getUnit());
+ record.setRatio(ratio);
+ record.setCoalFactor(meter.getCoalFactor());
+ record.setWorkshopId(meter.getWorkshopId());
+ record.setWorkshopName(meter.getWorkshopName());
+ record.setLineId(meter.getLineId());
+ record.setLineName(meter.getLineName());
+ record.setMachineryId(meter.getMachineryId());
+ record.setMachineryName(meter.getMachineryName());
+ record.setPrevReading(prevReading);
+ record.setUsageAmount(usage);
+ record.setPrice(price);
+ record.setCost(cost);
+ record.setSource(reqVO.getSource() == null ? MesEmRecordSourceEnum.MANUAL.getSource() : reqVO.getSource());
+ return record;
+ }
+
+ @Override
+ public PageResult<MesEmRecordDO> getRecordPage(MesEmRecordPageReqVO pageReqVO) {
+ return recordMapper.selectPage(pageReqVO);
+ }
+
+ @Override
+ public List<MesEmRecordRespVO> getRecordRespVOList(List<MesEmRecordDO> list) {
+ if (CollUtil.isEmpty(list)) {
+ return Collections.emptyList();
+ }
+ return BeanUtils.toBean(list, MesEmRecordRespVO.class, vo -> {
+ vo.setEnergyTypeName(MesEmEnergyTypeEnum.getName(vo.getEnergyType()));
+ vo.setSourceName(MesEmRecordSourceEnum.getName(vo.getSource()));
+ });
+ }
+
+ @Override
+ public MesEmLastReadingRespVO getLastReading(Long meterId, LocalDate recordDate, Long excludeId) {
+ MesEmRecordDO lastRecord = recordMapper.selectLastByMeterId(meterId, recordDate, excludeId);
+ if (lastRecord != null) {
+ return new MesEmLastReadingRespVO(lastRecord.getReading(), lastRecord.getRecordDate());
+ }
+ MesEmMeterDO meter = meterService.getMeter(meterId);
+ if (meter == null) {
+ throw exception(EM_METER_NOT_EXISTS);
+ }
+ return new MesEmLastReadingRespVO(
+ meter.getInitialReading() == null ? BigDecimal.ZERO : meter.getInitialReading(), null);
+ }
+
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/em/statistics/MesEmStatisticsService.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/em/statistics/MesEmStatisticsService.java
new file mode 100644
index 0000000..6be7094
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/em/statistics/MesEmStatisticsService.java
@@ -0,0 +1,19 @@
+package cn.iocoder.yudao.module.mes.service.em.statistics;
+
+import cn.iocoder.yudao.module.mes.controller.admin.em.statistics.vo.MesEmOverviewRespVO;
+import cn.iocoder.yudao.module.mes.controller.admin.em.statistics.vo.MesEmReportRespVO;
+
+import java.time.LocalDate;
+
+/**
+ * MES 鑳借�楃粺璁� Service
+ *
+ * @author 瓒呯骇绠$悊鍛�
+ */
+public interface MesEmStatisticsService {
+
+ MesEmOverviewRespVO getOverview(LocalDate beginDate, LocalDate endDate);
+
+ MesEmReportRespVO getReport(String period);
+
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/em/statistics/MesEmStatisticsServiceImpl.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/em/statistics/MesEmStatisticsServiceImpl.java
new file mode 100644
index 0000000..13f8694
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/em/statistics/MesEmStatisticsServiceImpl.java
@@ -0,0 +1,331 @@
+package cn.iocoder.yudao.module.mes.service.em.statistics;
+
+import cn.hutool.core.convert.Convert;
+import cn.hutool.core.util.StrUtil;
+import cn.iocoder.yudao.framework.mybatis.core.query.LambdaQueryWrapperX;
+import cn.iocoder.yudao.module.mes.controller.admin.em.statistics.vo.MesEmOverviewRespVO;
+import cn.iocoder.yudao.module.mes.controller.admin.em.statistics.vo.MesEmReportRespVO;
+import cn.iocoder.yudao.module.mes.dal.dataobject.em.alert.MesEmAlertDO;
+import cn.iocoder.yudao.module.mes.dal.dataobject.em.meter.MesEmMeterDO;
+import cn.iocoder.yudao.module.mes.dal.mysql.em.alert.MesEmAlertMapper;
+import cn.iocoder.yudao.module.mes.dal.mysql.em.meter.MesEmMeterMapper;
+import cn.iocoder.yudao.module.mes.dal.mysql.em.record.MesEmRecordMapper;
+import cn.iocoder.yudao.module.mes.enums.em.*;
+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.YearMonth;
+import java.util.*;
+
+/**
+ * MES 鑳借�楃粺璁� Service 瀹炵幇绫�
+ *
+ * @author 瓒呯骇绠$悊鍛�
+ */
+@Service
+@Validated
+public class MesEmStatisticsServiceImpl implements MesEmStatisticsService {
+
+ private static final BigDecimal ZERO = BigDecimal.ZERO;
+ private static final BigDecimal HUNDRED = new BigDecimal("100");
+
+ @Resource
+ private MesEmRecordMapper recordMapper;
+ @Resource
+ private MesEmMeterMapper meterMapper;
+ @Resource
+ private MesEmAlertMapper alertMapper;
+
+ @Override
+ public MesEmOverviewRespVO getOverview(LocalDate beginDate, LocalDate endDate) {
+ LocalDate begin = beginDate == null ? LocalDate.now().withDayOfMonth(1) : beginDate;
+ LocalDate end = endDate == null ? LocalDate.now() : endDate;
+ if (begin.isAfter(end)) {
+ LocalDate temp = begin;
+ begin = end;
+ end = temp;
+ }
+
+ MesEmOverviewRespVO respVO = new MesEmOverviewRespVO();
+ // 1. 鑳芥簮绫诲瀷缁熻
+ Map<Integer, Map<String, Object>> typeMap = toMapBy(recordMapper.selectTypeStats(begin, end), "energyType");
+ List<MesEmOverviewRespVO.TypeStat> typeStats = new ArrayList<>();
+ BigDecimal totalTce = ZERO;
+ BigDecimal totalCost = ZERO;
+ for (MesEmEnergyTypeEnum energyType : MesEmEnergyTypeEnum.values()) {
+ Map<String, Object> row = typeMap.getOrDefault(energyType.getType(), Collections.emptyMap());
+ MesEmOverviewRespVO.TypeStat stat = new MesEmOverviewRespVO.TypeStat();
+ stat.setEnergyType(energyType.getType());
+ stat.setEnergyTypeName(energyType.getName());
+ stat.setUnit(energyType.getUnit());
+ stat.setUsage(toDecimal(row, "usageAmount"));
+ stat.setCost(toDecimal(row, "costAmount"));
+ stat.setTce(toDecimal(row, "tce"));
+ typeStats.add(stat);
+ totalTce = totalTce.add(stat.getTce());
+ totalCost = totalCost.add(stat.getCost());
+ }
+ respVO.setTypeStats(typeStats);
+ respVO.setTotalTce(scale(totalTce));
+ respVO.setTotalCost(scale(totalCost));
+
+ // 2. 杞﹂棿缁熻
+ respVO.setWorkshopStats(parseWorkshopStats(recordMapper.selectWorkshopStats(begin, end)));
+
+ // 3. 鑳借�楄秼鍔�
+ respVO.setTrend(parseTrend(recordMapper.selectTrendRows(begin, end)));
+
+ // 4. 閲嶇偣鐢ㄨ兘璁惧鎺掕
+ respVO.setTopMeters(parseTopMeters(recordMapper.selectTopMeterStats(begin, end, 10)));
+
+ // 5. 棰勮姒傝
+ respVO.setMeterCount(Math.toIntExact(meterMapper.selectCount(
+ new LambdaQueryWrapperX<MesEmMeterDO>()
+ .eq(MesEmMeterDO::getStatus, MesEmMeterStatusEnum.ENABLE.getStatus()))));
+ respVO.setPendingAlertCount(Math.toIntExact(alertMapper.selectPendingCount()));
+ respVO.setRecentAlerts(parseRecentAlerts(alertMapper.selectRecent(begin, end, 5)));
+ return respVO;
+ }
+
+ @Override
+ public MesEmReportRespVO getReport(String period) {
+ YearMonth yearMonth = StrUtil.isBlank(period) ? YearMonth.now() : YearMonth.parse(period);
+ LocalDate begin = yearMonth.atDay(1);
+ LocalDate end = yearMonth.atEndOfMonth();
+ YearMonth lastMonth = yearMonth.minusMonths(1);
+ YearMonth lastYear = yearMonth.minusYears(1);
+
+ Map<Integer, Map<String, Object>> currentTypeMap = toMapBy(recordMapper.selectTypeStats(begin, end), "energyType");
+ Map<Integer, Map<String, Object>> lastMonthTypeMap = toMapBy(
+ recordMapper.selectTypeStats(lastMonth.atDay(1), lastMonth.atEndOfMonth()), "energyType");
+ Map<Integer, Map<String, Object>> lastYearTypeMap = toMapBy(
+ recordMapper.selectTypeStats(lastYear.atDay(1), lastYear.atEndOfMonth()), "energyType");
+
+ MesEmReportRespVO respVO = new MesEmReportRespVO();
+ respVO.setPeriod(yearMonth.toString());
+ respVO.setBeginDate(begin);
+ respVO.setEndDate(end);
+
+ // 1. 鎸夎兘婧愮被鍨�
+ List<MesEmReportRespVO.TypeRow> typeRows = new ArrayList<>();
+ BigDecimal totalTce = ZERO;
+ BigDecimal totalCost = ZERO;
+ BigDecimal lastMonthTce = ZERO;
+ BigDecimal lastYearTce = ZERO;
+ for (MesEmEnergyTypeEnum energyType : MesEmEnergyTypeEnum.values()) {
+ Map<String, Object> current = currentTypeMap.getOrDefault(energyType.getType(), Collections.emptyMap());
+ Map<String, Object> lastMonthRow = lastMonthTypeMap.getOrDefault(energyType.getType(), Collections.emptyMap());
+ Map<String, Object> lastYearRow = lastYearTypeMap.getOrDefault(energyType.getType(), Collections.emptyMap());
+
+ MesEmReportRespVO.TypeRow row = new MesEmReportRespVO.TypeRow();
+ row.setEnergyType(energyType.getType());
+ row.setEnergyTypeName(energyType.getName());
+ row.setUnit(energyType.getUnit());
+ row.setUsage(toDecimal(current, "usageAmount"));
+ row.setCost(toDecimal(current, "costAmount"));
+ row.setTce(toDecimal(current, "tce"));
+ row.setLastMonthUsage(toDecimal(lastMonthRow, "usageAmount"));
+ row.setMomRate(rate(row.getUsage(), row.getLastMonthUsage()));
+ row.setLastYearUsage(toDecimal(lastYearRow, "usageAmount"));
+ row.setYoyRate(rate(row.getUsage(), row.getLastYearUsage()));
+ typeRows.add(row);
+
+ totalTce = totalTce.add(row.getTce());
+ totalCost = totalCost.add(row.getCost());
+ lastMonthTce = lastMonthTce.add(toDecimal(lastMonthRow, "tce"));
+ lastYearTce = lastYearTce.add(toDecimal(lastYearRow, "tce"));
+ }
+ respVO.setTypeRows(typeRows);
+
+ // 2. 鎸夎溅闂�
+ respVO.setWorkshopRows(parseReportWorkshopRows(
+ recordMapper.selectWorkshopStats(begin, end),
+ recordMapper.selectWorkshopStats(lastMonth.atDay(1), lastMonth.atEndOfMonth()),
+ recordMapper.selectWorkshopStats(lastYear.atDay(1), lastYear.atEndOfMonth())));
+
+ // 3. 鍚堣
+ respVO.setTotalTce(scale(totalTce));
+ respVO.setTotalCost(scale(totalCost));
+ respVO.setLastMonthTce(scale(lastMonthTce));
+ respVO.setMomRate(rate(totalTce, lastMonthTce));
+ respVO.setLastYearTce(scale(lastYearTce));
+ respVO.setYoyRate(rate(totalTce, lastYearTce));
+ return respVO;
+ }
+
+ // ==================== 鏁版嵁杞崲 ====================
+
+ private Map<Integer, Map<String, Object>> toMapBy(List<Map<String, Object>> rows, String key) {
+ Map<Integer, Map<String, Object>> result = new HashMap<>();
+ for (Map<String, Object> row : rows) {
+ Integer type = Convert.toInt(row.get(key));
+ if (type != null) {
+ result.put(type, row);
+ }
+ }
+ return result;
+ }
+
+ private List<MesEmOverviewRespVO.WorkshopStat> parseWorkshopStats(List<Map<String, Object>> rows) {
+ List<MesEmOverviewRespVO.WorkshopStat> result = new ArrayList<>();
+ for (Map<String, Object> row : rows) {
+ MesEmOverviewRespVO.WorkshopStat stat = new MesEmOverviewRespVO.WorkshopStat();
+ stat.setWorkshopId(Convert.toLong(row.get("workshopId")));
+ stat.setWorkshopName(Convert.toStr(row.get("workshopName")));
+ stat.setTce(scale(Convert.toBigDecimal(row.get("tce"), ZERO)));
+ stat.setCost(scale(Convert.toBigDecimal(row.get("costAmount"), ZERO)));
+ result.add(stat);
+ }
+ return result;
+ }
+
+ private List<MesEmOverviewRespVO.TrendPoint> parseTrend(List<Map<String, Object>> rows) {
+ Map<String, MesEmOverviewRespVO.TrendPoint> pointMap = new TreeMap<>();
+ for (Map<String, Object> row : rows) {
+ String date = toDateStr(row.get("recordDate"));
+ if (StrUtil.isBlank(date)) {
+ continue;
+ }
+ MesEmOverviewRespVO.TrendPoint point = pointMap.computeIfAbsent(date, key -> {
+ MesEmOverviewRespVO.TrendPoint item = new MesEmOverviewRespVO.TrendPoint();
+ item.setDate(key);
+ item.setTce(ZERO);
+ item.setCost(ZERO);
+ item.setElectricity(ZERO);
+ item.setWater(ZERO);
+ item.setFuel(ZERO);
+ item.setGas(ZERO);
+ return item;
+ });
+ Integer energyType = Convert.toInt(row.get("energyType"));
+ BigDecimal usage = Convert.toBigDecimal(row.get("usageAmount"), ZERO);
+ point.setTce(point.getTce().add(Convert.toBigDecimal(row.get("tce"), ZERO)));
+ point.setCost(point.getCost().add(Convert.toBigDecimal(row.get("costAmount"), ZERO)));
+ if (MesEmEnergyTypeEnum.ELECTRICITY.getType().equals(energyType)) {
+ point.setElectricity(usage);
+ } else if (MesEmEnergyTypeEnum.WATER.getType().equals(energyType)) {
+ point.setWater(usage);
+ } else if (MesEmEnergyTypeEnum.FUEL.getType().equals(energyType)) {
+ point.setFuel(usage);
+ } else if (MesEmEnergyTypeEnum.GAS.getType().equals(energyType)) {
+ point.setGas(usage);
+ }
+ }
+ pointMap.values().forEach(point -> {
+ point.setTce(scale(point.getTce()));
+ point.setCost(scale(point.getCost()));
+ });
+ return new ArrayList<>(pointMap.values());
+ }
+
+ private List<MesEmOverviewRespVO.MeterStat> parseTopMeters(List<Map<String, Object>> rows) {
+ List<MesEmOverviewRespVO.MeterStat> result = new ArrayList<>();
+ for (Map<String, Object> row : rows) {
+ MesEmOverviewRespVO.MeterStat stat = new MesEmOverviewRespVO.MeterStat();
+ stat.setMeterId(Convert.toLong(row.get("meterId")));
+ stat.setMeterName(Convert.toStr(row.get("meterName")));
+ stat.setEnergyType(Convert.toInt(row.get("energyType")));
+ stat.setEnergyTypeName(MesEmEnergyTypeEnum.getName(stat.getEnergyType()));
+ stat.setUnit(Convert.toStr(row.get("unit")));
+ stat.setUsage(Convert.toBigDecimal(row.get("usageAmount"), ZERO));
+ stat.setCost(scale(Convert.toBigDecimal(row.get("costAmount"), ZERO)));
+ stat.setTce(scale(Convert.toBigDecimal(row.get("tce"), ZERO)));
+ result.add(stat);
+ }
+ return result;
+ }
+
+ private List<MesEmOverviewRespVO.RecentAlert> parseRecentAlerts(List<MesEmAlertDO> alerts) {
+ List<MesEmOverviewRespVO.RecentAlert> result = new ArrayList<>();
+ for (MesEmAlertDO alert : alerts) {
+ MesEmOverviewRespVO.RecentAlert item = new MesEmOverviewRespVO.RecentAlert();
+ item.setId(alert.getId());
+ item.setContent(alert.getContent());
+ item.setAlertLevel(alert.getAlertLevel());
+ item.setAlertLevelName(MesEmAlertLevelEnum.getName(alert.getAlertLevel()));
+ item.setAlertDate(alert.getAlertDate() == null ? null : alert.getAlertDate().toString());
+ item.setStatus(alert.getStatus());
+ item.setStatusName(MesEmAlertStatusEnum.getName(alert.getStatus()));
+ result.add(item);
+ }
+ return result;
+ }
+
+ private List<MesEmReportRespVO.WorkshopRow> parseReportWorkshopRows(
+ List<Map<String, Object>> currentRows, List<Map<String, Object>> lastMonthRows,
+ List<Map<String, Object>> lastYearRows) {
+ Map<Long, Map<String, Object>> currentMap = toMapByWorkshop(currentRows);
+ Map<Long, Map<String, Object>> lastMonthMap = toMapByWorkshop(lastMonthRows);
+ Map<Long, Map<String, Object>> lastYearMap = toMapByWorkshop(lastYearRows);
+ Set<Long> workshopIds = new LinkedHashSet<>(currentMap.keySet());
+ workshopIds.addAll(lastMonthMap.keySet());
+ workshopIds.addAll(lastYearMap.keySet());
+
+ List<MesEmReportRespVO.WorkshopRow> result = new ArrayList<>();
+ for (Long workshopId : workshopIds) {
+ Map<String, Object> current = currentMap.getOrDefault(workshopId, Collections.emptyMap());
+ Map<String, Object> lastMonth = lastMonthMap.getOrDefault(workshopId, Collections.emptyMap());
+ Map<String, Object> lastYear = lastYearMap.getOrDefault(workshopId, Collections.emptyMap());
+ MesEmReportRespVO.WorkshopRow row = new MesEmReportRespVO.WorkshopRow();
+ row.setWorkshopId(workshopId);
+ row.setWorkshopName(Convert.toStr(current.getOrDefault("workshopName",
+ lastMonth.getOrDefault("workshopName", lastYear.get("workshopName")))));
+ row.setCost(scale(Convert.toBigDecimal(current.get("costAmount"), ZERO)));
+ row.setTce(scale(Convert.toBigDecimal(current.get("tce"), ZERO)));
+ row.setLastMonthTce(scale(Convert.toBigDecimal(lastMonth.get("tce"), ZERO)));
+ row.setMomRate(rate(row.getTce(), row.getLastMonthTce()));
+ row.setLastYearTce(scale(Convert.toBigDecimal(lastYear.get("tce"), ZERO)));
+ row.setYoyRate(rate(row.getTce(), row.getLastYearTce()));
+ result.add(row);
+ }
+ return result;
+ }
+
+ private Map<Long, Map<String, Object>> toMapByWorkshop(List<Map<String, Object>> rows) {
+ Map<Long, Map<String, Object>> result = new HashMap<>();
+ for (Map<String, Object> row : rows) {
+ Long workshopId = Convert.toLong(row.get("workshopId"));
+ if (workshopId != null) {
+ result.put(workshopId, row);
+ }
+ }
+ return result;
+ }
+
+ private BigDecimal toDecimal(Map<String, Object> row, String key) {
+ return scale(Convert.toBigDecimal(row.get(key), ZERO));
+ }
+
+ private String toDateStr(Object value) {
+ if (value == null) {
+ return null;
+ }
+ if (value instanceof LocalDate localDate) {
+ return localDate.toString();
+ }
+ if (value instanceof java.sql.Date sqlDate) {
+ return sqlDate.toLocalDate().toString();
+ }
+ String text = Convert.toStr(value);
+ return text != null && text.length() > 10 ? text.substring(0, 10) : text;
+ }
+
+ /**
+ * 璁$畻鐜瘮/鍚屾瘮锛�%锛夛紝鍩烘暟涓� 0 鏃惰繑鍥� null锛屽墠绔樉绀轰负 -
+ */
+ private BigDecimal rate(BigDecimal current, BigDecimal base) {
+ if (base == null || base.compareTo(ZERO) == 0) {
+ return null;
+ }
+ return current.subtract(base).multiply(HUNDRED).divide(base, 2, RoundingMode.HALF_UP);
+ }
+
+ private BigDecimal scale(BigDecimal value) {
+ return value == null ? ZERO : value.setScale(2, RoundingMode.HALF_UP);
+ }
+
+}
--
Gitblit v1.9.3