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/doorplateAddress/mapper/DoorplateAddressMapper.java | 210 +++++++++++++++++++++++++++++++++++++++++++++++++---
1 files changed, 196 insertions(+), 14 deletions(-)
diff --git a/src/main/java/org/springblade/modules/doorplateAddress/mapper/DoorplateAddressMapper.java b/src/main/java/org/springblade/modules/doorplateAddress/mapper/DoorplateAddressMapper.java
index c5d8ea8..196d931 100644
--- a/src/main/java/org/springblade/modules/doorplateAddress/mapper/DoorplateAddressMapper.java
+++ b/src/main/java/org/springblade/modules/doorplateAddress/mapper/DoorplateAddressMapper.java
@@ -16,14 +16,17 @@
*/
package org.springblade.modules.doorplateAddress.mapper;
+import com.baomidou.mybatisplus.annotation.InterceptorIgnore;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import org.apache.ibatis.annotations.MapKey;
import org.apache.ibatis.annotations.Param;
-import org.springblade.common.node.TreeNode;
+import org.springblade.common.node.TreeStringNode;
import org.springblade.modules.doorplateAddress.entity.DoorplateAddressEntity;
+import org.springblade.modules.doorplateAddress.vo.DoorplateAddressVOTree;
import org.springblade.modules.doorplateAddress.vo.DoorplateAddressVO;
import org.springblade.modules.doorplateAddress.vo.FuncNode;
+import org.springblade.modules.house.vo.HouseParam;
import java.util.List;
import java.util.Map;
@@ -48,40 +51,49 @@
/**
- * 查询区域数据
+ * 查询街道数据
* @return
*/
- List<TreeNode> getRegionListByGrouyTwon();
+ List<TreeStringNode> getRegionListByGroupTwon(@Param("houseParam") HouseParam houseParam,
+ @Param("list") List<String> list,
+ @Param("communityList") List<String> communityList);
/**
- * 查询区域数据
+ * 查询社区数据
* @return
*/
- List<TreeNode> getRegionListByGrouyNei();
+ List<TreeStringNode> getRegionListByGroupNei(@Param("houseParam") HouseParam houseParam,
+ @Param("list") List<String> list,
+ @Param("communityList") List<String> communityList);
/**
* 根据社区名称查询小区集合
- * @param name
- * @param code
+ * @param houseParam
+ * @param list 网格编号
+ * @param communityList 社区编号
* @return
*/
- List<TreeNode> getDistrictList(@Param("name") String name,@Param("code") String code);
+ List<TreeStringNode> getDistrictList(@Param("houseParam") HouseParam houseParam,
+ @Param("list") List<String> list,
+ @Param("communityList") List<String> communityList);
/**
* 根据社区名称查询楼栋集合
- * @param name
- * @param code
+ * @param houseParam
+ * @param list 网格编号集合
* @return
*/
- List<TreeNode> getBuildingList(@Param("name") String name,@Param("code") String code);
+ List<TreeStringNode> getBuildingList(@Param("houseParam") HouseParam houseParam,
+ @Param("list") List<String> list);
/**
* 查询户室及住户相关信息，单元中包含住户
- * @param name
- * @param code
+ * @param houseParam
+ * @param list
* @return
*/
- List<FuncNode> getUnitHouseholdList(@Param("name") String name, @Param("code") String code);
+ List<FuncNode> getUnitHouseholdList(@Param("houseParam") HouseParam houseParam,
+ @Param("list") List<String> list);
/**
* 先查询门牌信息
@@ -89,4 +101,174 @@
* @return
*/
DoorplateAddressVO getDoorplateAddressDetailByCode(@Param("code") String code);
+
+ List<DoorplateAddressVOTree> getTownStreetVOTreeList();
+
+ List<DoorplateAddressVOTree> getNeiVOTreeList(@Param("code") String code);
+
+ List<DoorplateAddressVOTree> getStreetRuVOTreeList(@Param("code") String code);
+
+
+ List<DoorplateAddressVOTree> getDistrictVOTreeList(@Param("code") String code);
+
+ List<DoorplateAddressVOTree> getBuildingVOTreeList(@Param("code") String code);
+
+ /**
+ * 查询街路巷
+ * @param houseParam
+ * @param list
+ * @return
+ */
+ List<TreeStringNode> getStreetRuList(@Param("houseParam") HouseParam houseParam,
+ @Param("list") List<String> list);
+
+ /**
+ * 根据街路巷编号查询街路巷门牌名称集合
+ * @param houseParam name/code 该处当社区编号用/ 街路巷编号
+ * @param list
+ * @return
+ */
+ List<FuncNode> getDoorplateNameList(@Param("houseParam") HouseParam houseParam,
+ @Param("list") List<String> list);
+
+ /**
+ * 根据参数获取地址详情
+ * @param doorplateAddressVO
+ * @return
+ */
+ @InterceptorIgnore(tenantLine = "true")
+ DoorplateAddressVO getDoorplateAddressDetail(@Param("vo") DoorplateAddressVO doorplateAddressVO);
+
+ /**
+ * 根据参数获取地址详情
+ * @param doorplateAddressVO
+ * @return
+ */
+ DoorplateAddressVO getDoorplateAddressList(@Param("vo") DoorplateAddressVO doorplateAddressVO);
+
+ /**
+ * 查询社区信息
+ * @param doorplateAddressEntity
+ * @return
+ */
+ List<DoorplateAddressEntity> getAllDoorplateAddress(@Param("doorplateAddressEntity") DoorplateAddressEntity doorplateAddressEntity);
+
+ /**
+ * 获取房屋树
+ * @param houseParam
+ * @param list
+ * @return
+ */
+ @MapKey("code")
+ Map<String, DoorplateAddressVOTree> getHouseTree(@Param("houseParam") HouseParam houseParam,
+ @Param("list") List<String> list);
+ /**
+ * 查询所有户室数据
+ * @param townName
+ * @return
+ */
+ List<DoorplateAddressEntity> getHouseList(@Param("townName") String townName);
+
+ /**
+ * 查询商超
+ * @param houseParam
+ * @return
+ */
+ List<TreeStringNode> getPlaceRelList(@Param("houseParam") HouseParam houseParam);
+
+ /**
+ * 查询商超详情集合
+ * @param houseParam
+ * @return
+ */
+ List<FuncNode> getPlaceRelDetailList(@Param("houseParam") HouseParam houseParam);
+
+ /**
+ * 查询小区集合
+ * @param list
+ * @return
+ */
+ List<DoorplateAddressEntity> getAoiList(@Param("list") List<Long> list);
+
+ /**
+ * 查询所有的地址表id集合
+ * @return
+ */
+ List<Long> getAoiCodeList();
+
+ /**
+ * 查询所有的地址表和场所表差集集合(没有入库的)
+ * @return
+ */
+ List<DoorplateAddressEntity> getNotInPlaceList(@Param("townName") String townName);
+
+ /**
+ * 查询场所标准地址数据
+ * @param doorplateAddressVO
+ * @param size
+ * @return
+ */
+ List<DoorplateAddressEntity> getPlaceList(@Param("doorplateAddress") DoorplateAddressVO doorplateAddressVO,
+ @Param("size") Integer size,
+ @Param("gridCodeList") List<String> gridCodeList,
+ @Param("regionChildCodesList") List<String> regionChildCodesList,
+ @Param("isAdministrator") Integer isAdministrator);
+
+ /**
+ * 查询详情
+ * @param doorplateAddress
+ * @return
+ */
+ DoorplateAddressVO getDoorplateAddressVODetail(@Param("doorplateAddress") DoorplateAddressVO doorplateAddress);
+
+ /**
+ * 查询所有的社区集合信息
+ * @return
+ */
+ List<DoorplateAddressEntity> getAllCommunityList();
+
+ /**
+ * 通过小区id 查询楼栋编码
+ * @param districtId
+ * @return
+ */
+ List<DoorplateAddressVO> getHouseBuildingCode(String districtId);
+
+ /**
+ * 查询绑定房屋总数
+ * @param townName
+ * @return
+ */
+ Integer getNotHouseListCount(@Param("townName") String townName);
+
+ /**
+ * 查询网格范围表未绑定的地址表信息数量
+ * @param townName
+ * @return
+ */
+ Integer getNotBindGridRangeDoorListCount(@Param("townName") String townName,
+ @Param("communityName") String communityName);
+
+ /**
+ * 查询所有未匹配的网格范围地址数据
+ * @param townName
+ * @param communityName
+ * @return
+ */
+ List<DoorplateAddressEntity> getNotBindGridRangeDoorList(@Param("townName") String townName,
+ @Param("communityName") String communityName);
+
+ /**
+ * 根据房屋id 查询对应的地址信息
+ * @param houseId
+ * @return
+ */
+ DoorplateAddressVO getDoorplateAddressDetailByHouseId(@Param("houseId") Long houseId);
+
+ /**
+ * 查询未入库的场所
+ * @param townName
+ * @return
+ */
+ Integer getNotPlaceListCount(@Param("townName") String townName);
}
--
Gitblit v1.9.3