From fefe259f19a251d90d17d8a42e04f6332a4cad3e Mon Sep 17 00:00:00 2001
From: linwei <872216696@qq.com>
Date: Fri, 23 Jan 2026 15:37:30 +0800
Subject: [PATCH] sql 优化
---
drone-service/drone-fw/src/main/java/org/sxkj/fw/record/mapper/FwDroneAlarmRecordMapper.java | 14 +++++++++++---
1 files changed, 11 insertions(+), 3 deletions(-)
diff --git a/drone-service/drone-fw/src/main/java/org/sxkj/fw/record/mapper/FwDroneAlarmRecordMapper.java b/drone-service/drone-fw/src/main/java/org/sxkj/fw/record/mapper/FwDroneAlarmRecordMapper.java
index f317b79..01cd378 100644
--- a/drone-service/drone-fw/src/main/java/org/sxkj/fw/record/mapper/FwDroneAlarmRecordMapper.java
+++ b/drone-service/drone-fw/src/main/java/org/sxkj/fw/record/mapper/FwDroneAlarmRecordMapper.java
@@ -16,7 +16,10 @@
*/
package org.sxkj.fw.record.mapper;
+import org.sxkj.fw.cockpit.vo.AlarmStatisticsVO;
+import org.sxkj.fw.record.dto.FwDroneAlarmRecordDTO;
import org.sxkj.fw.record.entity.FwDroneAlarmRecordEntity;
+import org.sxkj.fw.record.param.FwDroneAlarmRecordExportParam;
import org.sxkj.fw.record.vo.FwDroneAlarmRecordVO;
import org.sxkj.fw.record.excel.FwDroneAlarmRecordExcel;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
@@ -40,15 +43,20 @@
* @param fwDroneAlarmRecord
* @return
*/
- List<FwDroneAlarmRecordVO> selectFwDroneAlarmRecordPage(IPage page, FwDroneAlarmRecordVO fwDroneAlarmRecord);
+ List<FwDroneAlarmRecordVO> selectFwDroneAlarmRecordPage(IPage page, FwDroneAlarmRecordDTO fwDroneAlarmRecord);
/**
* 获取导出数据
*
- * @param queryWrapper
+ * @param fwDroneAlarmRecord
* @return
*/
- List<FwDroneAlarmRecordExcel> exportFwDroneAlarmRecord(@Param("ew") Wrapper<FwDroneAlarmRecordEntity> queryWrapper);
+ List<FwDroneAlarmRecordExcel> exportFwDroneAlarmRecord( FwDroneAlarmRecordExportParam fwDroneAlarmRecord);
+ /**
+ * 告警类型统计
+ * @return
+ */
+ AlarmStatisticsVO alarmTypeStatistics();
}
--
Gitblit v1.9.3