From fe59ae00aef5cdbc39c6d1b29c84af25071a32ff Mon Sep 17 00:00:00 2001
From: lin <sbla5888@163.com>
Date: Fri, 10 May 2024 16:42:46 +0800
Subject: [PATCH] 防诈宣传优化
---
src/main/java/org/springblade/modules/doorplateAddress/mapper/DoorplateAddressMapper.java | 24 ++++++++++++++++++++++++
1 files changed, 24 insertions(+), 0 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 8c08035..db50ef8 100644
--- a/src/main/java/org/springblade/modules/doorplateAddress/mapper/DoorplateAddressMapper.java
+++ b/src/main/java/org/springblade/modules/doorplateAddress/mapper/DoorplateAddressMapper.java
@@ -239,4 +239,28 @@
* @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);
}
--
Gitblit v1.9.3