短信指定楼栋发送

linwe

2024-08-09 8b7258c9427882bb1798f1502eaa35184c6e374e

 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,31 +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(Long userId);
   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);
}