From ad2ec97fe0c60eee4bb7c8cdacff7c876f280ea7 Mon Sep 17 00:00:00 2001
From: linwei <872216696@qq.com>
Date: Mon, 08 Jan 2024 11:30:18 +0800
Subject: [PATCH] 公安安全监管
---
src/main/java/org/springblade/modules/grid/mapper/GridMapper.java | 69 ++++++++++++++++++++++++++++++++++
1 files changed, 69 insertions(+), 0 deletions(-)
diff --git a/src/main/java/org/springblade/modules/grid/mapper/GridMapper.java b/src/main/java/org/springblade/modules/grid/mapper/GridMapper.java
index 2e37990..1b944a1 100644
--- a/src/main/java/org/springblade/modules/grid/mapper/GridMapper.java
+++ b/src/main/java/org/springblade/modules/grid/mapper/GridMapper.java
@@ -16,12 +16,19 @@
*/
package org.springblade.modules.grid.mapper;
+import org.apache.ibatis.annotations.MapKey;
import org.apache.ibatis.annotations.Param;
+import org.springblade.common.node.TreeStringNode;
+import org.springblade.modules.doorplateAddress.entity.DoorplateAddressEntity;
import org.springblade.modules.grid.entity.GridEntity;
+import org.springblade.modules.grid.entity.GridmanEntity;
import org.springblade.modules.grid.vo.GridVO;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
+import org.springblade.modules.place.vo.PlaceVO;
+
import java.util.List;
+import java.util.Map;
/**
* 网格表 Mapper 接口
@@ -40,5 +47,67 @@
*/
List<GridVO> selectGridPage(IPage page,@Param("grid") GridVO grid);
+ /**
+ * 根据地址编号查询网格数据
+ * @param houseCode
+ * @return
+ */
+ GridVO getGridDetailByHouseCode(@Param("houseCode") String houseCode);
+ /**
+ * 根据用户id(网格员)查询对应的房屋地址code
+ * @param userId
+ * @return
+ */
+ List<String> getAddressCodeListByUserId(@Param("userId") Long userId);
+
+ /**
+ * 空间分析 mysql 5.7 点落面
+ */
+ GridEntity spatialAnalysis(@Param("point")String point);
+
+ /**
+ * 根据参数查询网格数据
+ * @param place
+ * @return
+ */
+ GridVO getGridDetailByParam(@Param("place") PlaceVO place);
+
+ /**
+ * 网格表 自定义详情
+ * @param grid
+ * @return
+ */
+ GridVO getGridDetail(@Param("grid") GridVO grid);
+
+ /**
+ * 查询所有
+ * @return
+ */
+ List<GridEntity> selectGridAll();
+
+ /**
+ * 网格树
+ * @return
+ */
+ @MapKey(value = "id")
+ Map<String, TreeStringNode> getGridTree();
+
+ List<GridmanEntity> gridInfo(String houseCode);
+
+ List<DoorplateAddressEntity> gridAoiName(Integer id);
+
+ /**
+ * 网格集合查询
+ * @param grid
+ * @return
+ */
+ List<GridEntity> getGridList(@Param("grid") GridVO grid);
+
+ /**
+ * 查询小区网格绑定
+ * @param aoiCode 小区aoiCode
+ * @return
+ */
+ List<GridVO> getGridListByAoiCode(@Param("aoiCode") String aoiCode);
}
--
Gitblit v1.9.3