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/HouseholdMapper.java | 80 ++++++++++++++++++++++++++++++++++-----
1 files changed, 69 insertions(+), 11 deletions(-)
diff --git a/src/main/java/org/springblade/modules/house/mapper/HouseholdMapper.java b/src/main/java/org/springblade/modules/house/mapper/HouseholdMapper.java
index 1b504c3..4fd1d70 100644
--- a/src/main/java/org/springblade/modules/house/mapper/HouseholdMapper.java
+++ b/src/main/java/org/springblade/modules/house/mapper/HouseholdMapper.java
@@ -18,10 +18,14 @@
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.TreeIntegerNode;
import org.springblade.common.node.TreeStringNode;
import org.springblade.modules.house.entity.HouseholdEntity;
-import org.springblade.modules.house.excel.HouseHoldExcel;
+import org.springblade.modules.house.excel.ExportHouseholdExcel;
+import org.springblade.modules.house.excel.HouseTenantExcel;
+import org.springblade.modules.house.excel.ImportHouseholdExcel;
import org.springblade.modules.house.vo.HouseholdOtherVO;
import org.springblade.modules.house.vo.HouseholdVO;
@@ -45,56 +49,70 @@
*/
List<HouseholdVO> selectHouseholdPage(IPage page,
@Param("household") HouseholdVO household,
+ @Param("isAdministrator") Integer isAdministrator,
@Param("regionChildCodesList") List<String> regionChildCodesList,
- @Param("isAdministrator") Integer isAdministrator);
+ @Param("gridCodeList") List<String> gridCodeList);
/**
* 获取全部
+ *
* @param household
* @return
*/
- List<HouseholdVO> getAllHouseHold(@Param("household")HouseholdVO household);
+ List<HouseholdVO> getAllHouseHold(@Param("household") HouseholdVO household);
/**
* 查询房屋集合信息
+ *
* @param userId
* @return
*/
- List<TreeStringNode> selectHouseNodeList(@Param("userId") Long userId);
+ List<TreeStringNode> selectHouseNodeList(@Param("userId") Long userId);
/**
* 查询房屋人员情况
+ *
* @param code
* @return
*/
- List<HouseholdVO> getHouseholdListByCode(@Param("code") String code);
+ List<HouseholdVO> getHouseholdListByCode(@Param("code") String code);
/**
* 住户 自定义查询详情
+ *
* @param household
* @return
*/
HouseholdVO getHouseholdListById(@Param("household") HouseholdEntity household);
/**
- * 导出
+ * 导出住户信息
+ *
* @param household
* @return
*/
- List<HouseHoldExcel> export(@Param("household") HouseholdVO household);
+ List<ExportHouseholdExcel> export(@Param("household") HouseholdVO household,
+ @Param("isAdministrator") Integer isAdministrator,
+ @Param("regionChildCodesList") List<String> regionChildCodesList,
+ @Param("gridCodeList") List<String> gridCodeList);
- Integer statistics(Long userId,String neiCode);
+ Integer statistics(@Param("household") HouseholdVO household,
+ @Param("isAdministrator") Integer isAdministrator,
+ @Param("regionChildCodesList") List<String> regionChildCodesList,
+ @Param("gridCodeList") List<String> gridCodeList);
/**
* 查询物业
+ *
* @param household
* @return
*/
- HouseholdOtherVO getProperty(@Param("household") HouseholdVO household);
+ HouseholdOtherVO getProperty(@Param("household") HouseholdVO household);
/**
* 查询网格
+ *
* @param household
* @return
*/
@@ -102,17 +120,19 @@
/**
* 查询公安信息
+ *
* @param household
* @return
*/
HouseholdOtherVO getSecurity(@Param("household") HouseholdVO household);
- List<Map<String, Object>> getHouseHoldStatistics(String code, Long userId,String roleType);
+ List<Map<String, Object>> getHouseHoldStatistics(String code, Long userId, String roleType);
- List<Map<String, Object>> getHouseHoldStatisticsAge(String code, Long userId,String roleType);
+ List<Map<String, Object>> getHouseHoldStatisticsAge(String code, Long userId, String roleType);
/**
* 查询所有未入库的业主信息
+ *
* @return
*/
List<HouseholdEntity> getNotInsertUserHousehold();
@@ -129,8 +149,46 @@
/**
* 根据人员标签编号集合查询对应的住户（按颜色区分近多少天没有发过任务的住户）
+ *
* @param list
* @return
*/
List<HouseholdVO> getHouseholdListByParam(@Param("list") List<Integer> list);
+
+ @MapKey(value = "id")
+ Map<Integer, TreeIntegerNode> getlabelStatistics(@Param("household") HouseholdVO household);
+
+ /**
+ * 多个小区id查询用户
+ *
+ * @param list
+ * @return
+ */
+ List<HouseholdVO> getUserInfoByDistrictIds(@Param("list") List<String> list, @Param("vo") HouseholdVO householdVO, IPage<HouseholdVO> page);
+
+ /**
+ * 查询住户对应的社区编号
+ * @param id
+ * @return
+ */
+ String getCommunityCode(@Param("id") Long id);
+
+ /**
+ * 查询所有住户总数
+ * @return
+ */
+ int getAllListTotal();
+
+ /**
+ * 查询对应的住户集合
+ * @param i
+ * @param size
+ * @return
+ */
+ List<HouseholdVO> getAllList(@Param("i") int i,@Param("size") int size);
+
+ List<HouseTenantExcel> exportTenant(@Param("household") HouseholdVO household,
+ @Param("isAdministrator") Integer isAdministrator,
+ @Param("regionChildCodesList") List<String> regionChildCodesList,
+ @Param("gridCodeList") List<String> gridCodeList);
}
--
Gitblit v1.9.3