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 |   33 +++++++++++++++++++++++++++++++++
 1 files changed, 33 insertions(+), 0 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 3b2932e..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
@@ -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