From b954d7a119eb635394bf4ff3619a9ab4b4978e48 Mon Sep 17 00:00:00 2001
From: linwei <872216696@qq.com>
Date: Thu, 02 Apr 2026 09:33:34 +0800
Subject: [PATCH] sql改造首页
---
drone-service/drone-fw/src/main/java/org/sxkj/fw/area/mapper/FwDefenseSceneManageMapper.java | 19 +++++++++++++++++++
1 files changed, 19 insertions(+), 0 deletions(-)
diff --git a/drone-service/drone-fw/src/main/java/org/sxkj/fw/area/mapper/FwDefenseSceneManageMapper.java b/drone-service/drone-fw/src/main/java/org/sxkj/fw/area/mapper/FwDefenseSceneManageMapper.java
index 8491f19..c727fc0 100644
--- a/drone-service/drone-fw/src/main/java/org/sxkj/fw/area/mapper/FwDefenseSceneManageMapper.java
+++ b/drone-service/drone-fw/src/main/java/org/sxkj/fw/area/mapper/FwDefenseSceneManageMapper.java
@@ -24,6 +24,9 @@
import com.baomidou.mybatisplus.core.conditions.Wrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import org.apache.ibatis.annotations.Param;
+import org.sxkj.fw.common.FwBaseInfo;
+
+import java.util.Date;
import java.util.List;
/**
@@ -68,4 +71,20 @@
*/
List<FwDefenseSceneManageExcel> exportFwDefenseSceneManage(@Param("ew") Wrapper<FwDefenseSceneManageEntity> queryWrapper);
+ /**
+ * 根据场景管理ID获取所有相关设备ID
+ *
+ * @param id 场景管理表(ja_fw_defense_scene_manage)的主键ID
+ * @return 设备ID字符串列表，每个元素是逗号分隔的设备ID字符串
+ * @throws Exception 数据库查询异常
+ */
+ List<Long> selectDeviceId(Long id);
+
+ /**
+ *
+ * @param fwBaseInfo
+ * @param time
+ * @return
+ */
+ List<FwDefenseSceneManageVO> selectFwDefenseSceneManageCockpitList(@Param("fwBaseInfo") FwBaseInfo fwBaseInfo, @Param("time") Date time);
}
--
Gitblit v1.9.3