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/service/IFwAreaDivideService.java | 28 +++++++++++++++++++++++++++- 1 files changed, 27 insertions(+), 1 deletions(-) diff --git a/drone-service/drone-fw/src/main/java/org/sxkj/fw/area/service/IFwAreaDivideService.java b/drone-service/drone-fw/src/main/java/org/sxkj/fw/area/service/IFwAreaDivideService.java index 978ed07..eb5eb87 100644 --- a/drone-service/drone-fw/src/main/java/org/sxkj/fw/area/service/IFwAreaDivideService.java +++ b/drone-service/drone-fw/src/main/java/org/sxkj/fw/area/service/IFwAreaDivideService.java @@ -20,6 +20,8 @@ import org.sxkj.fw.area.dto.FwAreaDivideDTO; import org.sxkj.fw.area.dto.FwAreaDivideStatisticsDTO; import org.sxkj.fw.area.entity.FwAreaDivideEntity; +import org.sxkj.fw.area.entity.FwAreaDivideExtEntity; +import org.sxkj.fw.area.param.FwAreaDivideListParam; import org.sxkj.fw.area.vo.FwAreaDivideVO; import org.sxkj.fw.area.vo.FwAreaDivideStatisticsVO; import org.sxkj.fw.area.excel.FwAreaDivideExcel; @@ -51,7 +53,7 @@ * @param sceneId * @return */ - List<FwAreaDivideVO> selectFwAreaDivideList(Integer filterSelected, Long sceneId); + List<FwAreaDivideVO> selectFwAreaDivideList(Integer filterSelected, Long sceneId, String areaTypeKeys, Integer isSetSceneManage, java.time.LocalDateTime flyTime); /** * 根据设备ID获取关联场景名称 @@ -68,6 +70,14 @@ * @return */ boolean existsAreaByDeviceId(Long deviceId); + + /** + * 根据设备ID查询绑定区域名称 + * + * @param deviceId + * @return 未绑定时返回空字符串 + */ + String selectAreaNameByDeviceId(Long deviceId); /** * 统计分页 @@ -102,4 +112,20 @@ */ List<FwAreaDivideExcel> exportFwAreaDivide(Wrapper<FwAreaDivideEntity> queryWrapper); + /** + * 新增或修改（主表 + 扩展表批量） + * + * @param fwAreaDivide + * @param fwAreaDivideExtList + * @return + */ + boolean saveOrUpdateWithExt(FwAreaDivideEntity fwAreaDivide, List<FwAreaDivideExtEntity> fwAreaDivideExtList); + + /** + * + * @param param + * @return + */ + List<FwAreaDivideVO> selectFwAreaDivideList(FwAreaDivideListParam param); + } -- Gitblit v1.9.3