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/house/mapper/HouseMapper.java | 94 ++++++++++++++++++++++++++++++++++++++++++++--
1 files changed, 89 insertions(+), 5 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 a04b877..2bce2d3 100644
--- a/src/main/java/org/springblade/modules/house/mapper/HouseMapper.java
+++ b/src/main/java/org/springblade/modules/house/mapper/HouseMapper.java
@@ -25,6 +25,7 @@
import org.springblade.modules.house.vo.HouseParam;
import org.springblade.modules.house.vo.HouseTree;
import org.springblade.modules.house.vo.HouseVO;
+import org.springblade.modules.label.vo.LabelVO;
import java.util.List;
import java.util.Map;
@@ -47,17 +48,20 @@
List<HouseVO> selectHousePage(IPage page,
@Param("house") HouseVO house,
@Param("regionChildCodesList") List<String> regionChildCodesList,
+ @Param("gridCodeList") List<String> gridCodeList,
@Param("isAdministrator") Integer isAdministrator);
/**
* 房屋自定义详情查询
+ *
* @param house
* @return
*/
- HouseVO getHouseDetail(@Param("house") HouseVO house);
+ HouseVO getHouseDetail(@Param("house") HouseVO house);
/**
* 导出房屋数据
+ *
* @param house
* @return
*/
@@ -74,15 +78,95 @@
Map<String, HouseTree> getHouseTree(@Param("houseParam") HouseParam houseParam,
@Param("list") List<String> list);
- Integer getHouseStatisticsOne(String code, Long userId, String aoiCode, String buildingCode, String unitCode, String roleType);
+ Integer getHouseStatisticsOne(List<String> communityCodeList, 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("communityCodeList") List<String> communityCodeList,
+ @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);
+ Integer getHouseStatisticsThree(List<String> communityCodeList, Long userId, String aoiCode, String buildingCode, String unitCode, String roleType);
- Integer getHouseStatisticsFour(String code, Long userId, String aoiCode, String buildingCode, String unitCode, String roleType);
+ Integer getHouseStatisticsFour(List<String> communityCodeList, Long userId, String aoiCode, String buildingCode, String unitCode, String roleType);
List<String> getHouseBuilding(String districtCode);
List<String> getHouseUnit(String districtCode, String building);
+
+ @MapKey("id")
+ List<Map<String, Object>> labelStatistics(@Param("house") HouseVO house,
+ @Param("regionChildCodesList") List<String> regionChildCodesList,
+ @Param("isAdministrator") Integer isAdministrator);
+
+ @MapKey("id")
+ List<Map<String, Object>> labelCommunityStatistics(@Param("house") HouseVO house,
+ @Param("regionChildCodesList") List<String> regionChildCodesList);
+
+ List<LabelVO> getlabelCount(@Param("house") HouseVO house,
+ @Param("regionChildCodesList") List<String> regionChildCodesList,
+ @Param("isAdministrator") Integer isAdministrator,
+ @Param("streetCode") String streetCode);
+
+ /**
+ * 查询未绑定网格或警格的数据
+ * @param type 1:网格 2：警格
+ * @return
+ */
+ List<HouseEntity> getNotBindGridOrJwGridList(@Param("type") Integer type);
+
+ /**
+ * 按房屋标签统计
+ * @param house
+ * @param regionChildCodesList
+ * @return
+ */
+ List<Map<String, Object>> getHouseLabelStatistic(@Param("house") HouseVO house,
+ @Param("communityCodeList")List<String> regionChildCodesList);
+
+ /**
+ * 查询对应的社区编号
+ * @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);
+
+ /**
+ *
+ * @param aoiCodeList
+ * @return
+ */
+ Map<String, Object> getHoseTotalAndAreaTotalByDistrictCode(List<String> aoiCodeList);
}
--
Gitblit v1.9.3