From c10d6358b9f014375a13821465bc978d0c0da22e Mon Sep 17 00:00:00 2001
From: linwe <872216996@qq.com>
Date: Wed, 29 May 2024 17:17:08 +0800
Subject: [PATCH] 通过E呼即办数据统计
---
src/main/java/org/springblade/modules/house/mapper/HouseMapper.java | 45 ++++++++++++++++++++++++++++++++++++++++++++-
1 files changed, 44 insertions(+), 1 deletions(-)
diff --git a/src/main/java/org/springblade/modules/house/mapper/HouseMapper.java b/src/main/java/org/springblade/modules/house/mapper/HouseMapper.java
index 92ba0e9..638887e 100644
--- a/src/main/java/org/springblade/modules/house/mapper/HouseMapper.java
+++ b/src/main/java/org/springblade/modules/house/mapper/HouseMapper.java
@@ -80,7 +80,14 @@
Integer getHouseStatisticsOne(String code, Long userId, String aoiCode, String buildingCode, String unitCode, String roleType);
- Integer getHouseStatisticsTwo(String code, Long userId, String aoiCode, String buildingCode, String unitCode, String roleType);
+ Integer getHouseStatisticsTwo(@Param("code") String code,
+ @Param("aoiCode") String aoiCode,
+ @Param("buildingCode") String buildingCode,
+ @Param("unitCode") String unitCode,
+ @Param("house") HouseVO house,
+ @Param("isAdministrator") Integer isAdministrator,
+ @Param("regionChildCodesList")List<String> regionChildCodesList,
+ @Param("gridCodeList")List<String> gridCodeList);
Integer getHouseStatisticsThree(String code, Long userId, String aoiCode, String buildingCode, String unitCode, String roleType);
@@ -123,4 +130,40 @@
@Param("isAdministrator") Integer isAdministrator,
@Param("regionChildCodesList")List<String> regionChildCodesList,
@Param("gridCodeList")List<String> gridCodeList);
+
+ /**
+ * 查询对应的社区编号
+ * @param id
+ * @return
+ */
+ String getCommunityCode(@Param("id") Long id);
+
+ /**
+ * 查询所有房屋总数
+ * @return
+ */
+ int getAllListTotal();
+
+ /**
+ * 查询所有的房屋
+ * @param i
+ * @param size
+ * @return
+ */
+ List<HouseVO> getAllList(@Param("i") int i,@Param("size") int size);
+
+ /**
+ * 查询无房屋状态的房屋数量
+ * @param house
+ * @return
+ */
+ int getNotBindLabelHouseNum(HouseVO house);
+
+ /**
+ * 查询无房屋状态的房屋列表集合
+ * @param i
+ * @param size
+ * @return
+ */
+ List<HouseVO> getNotBindLabelHouseList(@Param("i") int i,@Param("size") int size);
}
--
Gitblit v1.9.3