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/HouseholdMapper.java | 143 ++++++++++++++++++++++++++++++++++++++++++++---
1 files changed, 134 insertions(+), 9 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 f835dcb..8e49f1a 100644
--- a/src/main/java/org/springblade/modules/house/mapper/HouseholdMapper.java
+++ b/src/main/java/org/springblade/modules/house/mapper/HouseholdMapper.java
@@ -16,15 +16,21 @@
*/
package org.springblade.modules.house.mapper;
-import org.apache.ibatis.annotations.Param;
-import org.springblade.common.node.TreeNode;
-import org.springblade.modules.house.entity.HouseholdEntity;
-import org.springblade.modules.house.vo.HouseholdVO;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
-import org.springblade.modules.house.excel.HouseHoldExcel;
+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.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;
import java.util.List;
+import java.util.Map;
/**
* 住户 Mapper 接口
@@ -41,29 +47,148 @@
* @param household
* @return
*/
- List<HouseholdVO> selectHouseholdPage(IPage page,@Param("household") HouseholdVO household);
+ List<HouseholdVO> selectHouseholdPage(IPage page,
+ @Param("household") HouseholdVO household,
+ @Param("isAdministrator") Integer isAdministrator,
+ @Param("regionChildCodesList") List<String> regionChildCodesList,
+ @Param("gridCodeList") List<String> gridCodeList);
+
+ /**
+ * 获取全部
+ *
+ * @param household
+ * @return
+ */
+ List<HouseholdVO> getAllHouseHold(@Param("household") HouseholdVO household);
/**
* 查询房屋集合信息
+ *
* @param userId
* @return
*/
- List<TreeNode> 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);
- List<HouseHoldExcel> export(HouseholdVO household);
+ /**
+ * 导出住户信息
+ *
+ * @param household
+ * @return
+ */
+ List<ExportHouseholdExcel> export(@Param("household") HouseholdVO household,
+ @Param("isAdministrator") Integer isAdministrator,
+ @Param("regionChildCodesList") List<String> regionChildCodesList,
+ @Param("gridCodeList") List<String> gridCodeList);
+
+ 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);
+
+ /**
+ * 查询网格
+ *
+ * @param household
+ * @return
+ */
+ HouseholdOtherVO getGrid(@Param("household") HouseholdVO household);
+
+ /**
+ * 查询公安信息
+ *
+ * @param household
+ * @return
+ */
+ HouseholdOtherVO getSecurity(@Param("household") HouseholdVO household);
+
+ List<Map<String, Object>> getHouseHoldStatistics(List<String> communityCodeList, Long userId, String roleType);
+
+ List<Map<String, Object>> getHouseHoldStatisticsAge(List<String> communityCodeList, Long userId, String roleType);
+
+ /**
+ * 查询所有未入库的业主信息
+ *
+ * @return
+ */
+ List<HouseholdEntity> getNotInsertUserHousehold();
+
+ /**
+ * 住户列表查询
+ *
+ * @param household
+ * @return
+ */
+ List<HouseholdVO> selectHouseholdList(@Param("household") HouseholdVO household);
+
+ List<HouseholdVO> getKeynotePersonnelPage(IPage<HouseholdVO> page, @Param("household") HouseholdVO household);
+
+ /**
+ * 根据人员标签编号集合查询对应的住户（按颜色区分近多少天没有发过任务的住户）
+ *
+ * @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