From 08ddfad4530a014094c06fe68b8c2d9a0753403a Mon Sep 17 00:00:00 2001
From: linwei <872216696@qq.com>
Date: Wed, 05 Aug 2026 14:09:29 +0800
Subject: [PATCH] fix(gd): 修复线索事件查询中的SQL语法错误

---
 drone-service/drone-fw/src/main/java/org/sxkj/fw/detection/mapper/FwDeviceConfigMapper.java |   35 ++++++++++++++++++++++++++++++++++-
 1 files changed, 34 insertions(+), 1 deletions(-)

diff --git a/drone-service/drone-fw/src/main/java/org/sxkj/fw/detection/mapper/FwDeviceConfigMapper.java b/drone-service/drone-fw/src/main/java/org/sxkj/fw/detection/mapper/FwDeviceConfigMapper.java
index 775353d..157dc7c 100644
--- a/drone-service/drone-fw/src/main/java/org/sxkj/fw/detection/mapper/FwDeviceConfigMapper.java
+++ b/drone-service/drone-fw/src/main/java/org/sxkj/fw/detection/mapper/FwDeviceConfigMapper.java
@@ -29,7 +29,7 @@
  * 设备配置表 Mapper 接口
  *
  * @author lw
- * @since 2026-01-07
+ * @since 2026-01-08
  */
 public interface FwDeviceConfigMapper extends BaseMapper<FwDeviceConfigEntity> {
 
@@ -42,6 +42,39 @@
 	 */
 	List<FwDeviceConfigVO> selectFwDeviceConfigPage(IPage page, FwDeviceConfigVO fwDeviceConfig);
 
+	/**
+	 * 获取最新配置
+	 *
+	 * @param deviceId
+	 * @return
+	 */
+	FwDeviceConfigEntity selectLatestByDeviceId(@Param("deviceId") Long deviceId);
+
+	/**
+	 * 获取最新版本配置
+	 *
+	 * @param deviceId
+	 * @return
+	 */
+	FwDeviceConfigEntity selectLatestVersionByDeviceId(@Param("deviceId") Long deviceId);
+
+	/**
+	 * 获取最新版本号
+	 *
+	 * @param deviceId
+	 * @return
+	 */
+	Integer selectMaxConfigVersion(@Param("deviceId") Long deviceId);
+
+	/**
+	 * 重置最新标记
+	 *
+	 * @param deviceId
+	 * @param excludeId
+	 * @return
+	 */
+	int resetLatestByDeviceId(@Param("deviceId") Long deviceId, @Param("excludeId") Long excludeId);
+
 
 	/**
 	 * 获取导出数据

--
Gitblit v1.9.3