From 8b7258c9427882bb1798f1502eaa35184c6e374e Mon Sep 17 00:00:00 2001
From: linwe <872216996@qq.com>
Date: Fri, 09 Aug 2024 14:29:18 +0800
Subject: [PATCH] 短信指定楼栋发送
---
src/main/java/org/springblade/modules/grid/mapper/GridMapper.java | 78 +++++++++++++++++++++++++++++++++++++--
1 files changed, 74 insertions(+), 4 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 ee4d8c4..fe41db7 100644
--- a/src/main/java/org/springblade/modules/grid/mapper/GridMapper.java
+++ b/src/main/java/org/springblade/modules/grid/mapper/GridMapper.java
@@ -19,7 +19,9 @@
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;
@@ -43,26 +45,29 @@
* @param grid
* @return
*/
- List<GridVO> selectGridPage(IPage page,@Param("grid") GridVO grid);
+ List<GridVO> selectGridPage(IPage page,
+ @Param("grid") GridVO grid,
+ @Param("regionChildCodesList") List<String> regionChildCodesList,
+ @Param("isAdministrator") Integer isAdministrator);
/**
* 根据地址编号查询网格数据
* @param houseCode
* @return
*/
- GridVO getGridDetailByHouseCode(@Param("houseCode") String houseCode);
+ GridVO getPlaceGridDetailByHouseCode(@Param("houseCode") String houseCode);
/**
* 根据用户id(网格员)查询对应的房屋地址code
* @param userId
* @return
*/
- List<String> getAddressCodeListByUserId(@Param("userId") Long userId);
+ List<String> getAddressCodeListByUserId(@Param("userId") Long userId,@Param("addressCode") String addressCode);
/**
* 空间分析 mysql 5.7 点落面
*/
- GridEntity spatialAnalysis(@Param("point")String point);
+ List<GridEntity> spatialAnalysis(@Param("point")String point);
/**
* 根据参数查询网格数据
@@ -90,4 +95,69 @@
*/
@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);
+
+ /**
+ * 查询对应网格人对应的网格
+ * @param userId
+ * @return
+ */
+ GridEntity getGridByUserId(@Param("userId") Long userId);
+
+ /**
+ * 根据网格名称，社区名称查询对应的网格
+ * @param gridName
+ * @param communityName
+ * @return
+ */
+ GridEntity getGridByNames(@Param("gridName") String gridName,
+ @Param("communityName") String communityName);
+
+ /**
+ * 查询用户对应的网格
+ * @param userId
+ * @return
+ */
+ List<String> getGridListByUserId(@Param("userId") String userId);
+
+ /**
+ * 查询对应的房屋地址code(更加网格编号集合）
+ * @param gridCodeList
+ * @return
+ */
+ List<String> getAddressCodeListByGridCodeList(@Param("communityCode")String communityCode,@Param("gridCodeList")List<String> gridCodeList);
+
+ /**
+ * 根据社区编号及网格编号集合查询对应的网格信息
+ * @param communityCode
+ * @param gridCodeList
+ * @return
+ */
+ List<GridVO> getGridListByComAndList(@Param("communityCode")String communityCode,
+ @Param("gridCodeList") List<String> gridCodeList);
+
+ /**
+ * 根据社区名称和网格名称查询对应的网格信息
+ * @param communityName
+ * @param gridName
+ * @return
+ */
+ GridEntity getGridInfoByParam(@Param("communityName")String communityName,@Param("gridName") String gridName);
}
--
Gitblit v1.9.3