From 774c8b2ee14eef5fd10bbd46d85a180e7b19ab21 Mon Sep 17 00:00:00 2001
From: lin <sbla5888@163.com>
Date: Fri, 22 Mar 2024 14:34:12 +0800
Subject: [PATCH] 查询过滤优化
---
src/main/java/org/springblade/modules/house/mapper/HouseMapper.java | 89 +++++++++++++++++++++++++++++++++++++++++++-
1 files changed, 86 insertions(+), 3 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 178bf76..92ba0e9 100644
--- a/src/main/java/org/springblade/modules/house/mapper/HouseMapper.java
+++ b/src/main/java/org/springblade/modules/house/mapper/HouseMapper.java
@@ -16,11 +16,19 @@
*/
package org.springblade.modules.house.mapper;
-import org.springblade.modules.house.entity.HouseEntity;
-import org.springblade.modules.house.vo.HouseVO;
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.modules.house.entity.HouseEntity;
+import org.springblade.modules.house.excel.HouseExcel;
+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;
/**
* 房屋 Mapper 接口
@@ -37,7 +45,82 @@
* @param house
* @return
*/
- List<HouseVO> selectHousePage(IPage page, HouseVO house);
+ 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);
+ /**
+ * 导出房屋数据
+ *
+ * @param house
+ * @return
+ */
+ List<HouseExcel> export(@Param("house") HouseVO house);
+
+ /**
+ * 查询房屋树
+ *
+ * @param houseParam
+ * @param list
+ * @return
+ */
+ @MapKey(value = "code")
+ 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 getHouseStatisticsTwo(String code, Long userId, String aoiCode, String buildingCode, String unitCode, String roleType);
+
+ Integer getHouseStatisticsThree(String code, Long userId, String aoiCode, String buildingCode, String unitCode, String roleType);
+
+ Integer getHouseStatisticsFour(String code, 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 isAdministrator
+ * @param regionChildCodesList
+ * @param gridCodeList
+ * @return
+ */
+ List<Map<String, Object>> getHouseLabelStatistic(@Param("house") HouseVO house,
+ @Param("isAdministrator") Integer isAdministrator,
+ @Param("regionChildCodesList")List<String> regionChildCodesList,
+ @Param("gridCodeList")List<String> gridCodeList);
}
--
Gitblit v1.9.3