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/device/service/IFwDeviceService.java |   42 ++++++++++++++++++++++++++++++++++++++----
 1 files changed, 38 insertions(+), 4 deletions(-)

diff --git a/drone-service/drone-fw/src/main/java/org/sxkj/fw/device/service/IFwDeviceService.java b/drone-service/drone-fw/src/main/java/org/sxkj/fw/device/service/IFwDeviceService.java
index 2a290f8..ff9e76f 100644
--- a/drone-service/drone-fw/src/main/java/org/sxkj/fw/device/service/IFwDeviceService.java
+++ b/drone-service/drone-fw/src/main/java/org/sxkj/fw/device/service/IFwDeviceService.java
@@ -20,6 +20,7 @@
 import org.sxkj.fw.cockpit.vo.AlarmStatisticsVO;
 import org.sxkj.fw.cockpit.vo.DeviceStatisticsVO;
 import org.sxkj.fw.device.dto.FwDeviceDTO;
+import org.sxkj.fw.device.dto.FwDevicePolygonQueryDTO;
 import org.sxkj.fw.device.entity.FwDeviceEntity;
 import org.sxkj.fw.device.param.FwDevicePageParam;
 import org.sxkj.fw.device.vo.CockpitFwDeviceVO;
@@ -62,10 +63,19 @@
 	 *
 	 * @param isAreaSelect 是否过滤区域
 	 * @param areaId 设备被关联区域id
+	 * @param areaIds 设备被关联区域id集合
 	 * @param status 设备状态
 	 * @return
 	 */
-	List<FwDeviceEntity> selectFwDeviceList(Integer isAreaSelect, Long areaId, Integer status, Integer isTrack);
+	List<FwDeviceEntity> selectFwDeviceList(Integer isAreaSelect, Long areaId, List<Long> areaIds, Integer status, Integer isTrack);
+
+	/**
+	 * 根据多边形查询设备列表
+	 *
+	 * @param query 查询条件
+	 * @return 设备列表
+	 */
+	List<FwDeviceEntity> selectFwDeviceListByPolygons(FwDevicePolygonQueryDTO query);
 
 
 	/**
@@ -80,7 +90,7 @@
 	 * 设备类型统计
 	 * @return
 	 */
-	List<DeviceStatisticsVO> statisticalDeviceType(List<Long> deptList);
+	List<DeviceStatisticsVO> statisticalDeviceType(String regionCode, String currentDeptId);
 
 	/**
 	 * 设备统计 - 按类型统计
@@ -104,7 +114,7 @@
 	 * 设备报警统计
 	 * @return
 	 */
-	AlarmStatisticsVO statisticalDeviceAtt(List<Long> deptList);
+	AlarmStatisticsVO statisticalDeviceAtt(String regionCode, String currentDeptId);
 
 	/**
 	 * 驾驶舱获取设备列表
@@ -131,6 +141,14 @@
 	boolean existsAreaBindByDeviceId(Long deviceId);
 
 	/**
+	 * 获取设备绑定区域名称
+	 *
+	 * @param deviceId
+	 * @return 未绑定时返回空字符串
+	 */
+	String selectAreaBindNameByDeviceId(Long deviceId);
+
+	/**
 	 * 新增或修改设备
 	 * @param fwDeviceEntity
 	 * @return
@@ -144,5 +162,21 @@
 	 * @param trackStatus 出入库状态
 	 * @return 是否更新成功
 	 */
-	boolean updateTrackStatusByDeviceId(Long deviceId, Integer trackStatus);
+	boolean updateTrackStatusByDeviceId(Long deviceId, Integer trackStatus, String outTarget, String outTargetCode);
+
+	/**
+	 * 查询非本部门区域的设备
+	 *
+	 * @param regionCode 区域编码，用于查询不在该区域内的设备
+	 * @param deptId 机构ID，用于限定查询范围
+	 * @return 设备列表
+	 */
+	List<FwDeviceVO> getNonDeptAreaDevices(String regionCode, String deptId);
+
+	/**
+	 *
+	 * @param fwDeviceDTO
+	 * @return
+	 */
+	List<DeviceStatisticsVO> getDeviceStatistics(FwDeviceDTO fwDeviceDTO);
 }

--
Gitblit v1.9.3