获取楼盘相关集合数据查询调整（改成sql会导致内存溢出）

zrj

2024-07-02 96916fb34cdc4907a194d0bafae22a5e2bf378bf

 src/main/java/org/springblade/modules/doorplateAddress/mapper/DoorplateAddressMapper.java

@@ -55,28 +55,32 @@
    * @return
    */
    List<TreeStringNode> getRegionListByGroupTwon(@Param("houseParam") HouseParam houseParam,
                                                  @Param("list") List<String> list);
                                                  @Param("list") List<String> list,
                                                  @Param("communityList") List<String> communityList);

   /**
    * 查询社区数据
    * @return
    */
    List<TreeStringNode> getRegionListByGroupNei(@Param("houseParam") HouseParam houseParam,
                                                 @Param("list") List<String> list);
                                                 @Param("list") List<String> list,
                                                 @Param("communityList") List<String> communityList);

   /**
    * 根据社区名称查询小区集合
    * @param houseParam
    * @param list
    * @param list 网格编号
    * @param communityList 社区编号
    * @return
    */
    List<TreeStringNode> getDistrictList(@Param("houseParam") HouseParam houseParam,
                                         @Param("list") List<String> list);
                                         @Param("list") List<String> list,
                                         @Param("communityList") List<String> communityList);

   /**
    * 根据社区名称查询楼栋集合
    * @param houseParam
    * @param list
    * @param list 网格编号集合
    * @return
    */
   List<TreeStringNode> getBuildingList(@Param("houseParam") HouseParam houseParam,
@@ -144,10 +148,10 @@

   /**
    * 查询社区信息
    * @param name
    * @param doorplateAddressEntity
    * @return
    */
   List<DoorplateAddressEntity> getAllDoorplateAddress(@Param("name") String name);
   List<DoorplateAddressEntity> getAllDoorplateAddress(@Param("doorplateAddressEntity") DoorplateAddressEntity doorplateAddressEntity);

   /**
    * 获取房屋树
@@ -160,9 +164,10 @@
                                        @Param("list") List<String> list);
   /**
    * 查询所有户室数据
    * @param townName
    * @return
    */
   List<DoorplateAddressEntity> getHouseList();
   List<DoorplateAddressEntity> getHouseList(@Param("townName") String townName);

   /**
    * 查询商超
@@ -192,8 +197,78 @@
   List<Long> getAoiCodeList();

   /**
    * 查询所有的地址表和场所表差集集合
    * 查询所有的地址表和场所表差集集合(没有入库的)
    * @return
    */
   List<DoorplateAddressEntity> getPlaceList();
   List<DoorplateAddressEntity> getNotInPlaceList(@Param("townName") String townName);

   /**
    * 查询场所标准地址数据
    * @param doorplateAddressVO
    * @param size
    * @return
    */
   List<DoorplateAddressEntity> getPlaceList(@Param("doorplateAddress") DoorplateAddressVO doorplateAddressVO,
                                   @Param("size")  Integer size,
                                   @Param("gridCodeList") List<String> gridCodeList,
                                   @Param("regionChildCodesList") List<String> regionChildCodesList,
                                   @Param("isAdministrator") Integer isAdministrator);

   /**
    * 查询详情
    * @param doorplateAddress
    * @return
    */
   DoorplateAddressVO getDoorplateAddressVODetail(@Param("doorplateAddress") DoorplateAddressVO doorplateAddress);

   /**
    * 查询所有的社区集合信息
    * @return
    */
    List<DoorplateAddressEntity> getAllCommunityList();

   /**
    * 通过小区id 查询楼栋编码
    * @param districtId
    * @return
    */
   List<DoorplateAddressVO>  getHouseBuildingCode(String districtId);

   /**
    * 查询绑定房屋总数
    * @param townName
    * @return
    */
   Integer getNotHouseListCount(@Param("townName") String townName);

   /**
    * 查询网格范围表未绑定的地址表信息数量
    * @param townName
    * @return
    */
   Integer getNotBindGridRangeDoorListCount(@Param("townName") String townName,
                                  @Param("communityName") String communityName);

   /**
    * 查询所有未匹配的网格范围地址数据
    * @param townName
    * @param communityName
    * @return
    */
   List<DoorplateAddressEntity> getNotBindGridRangeDoorList(@Param("townName") String townName,
                                              @Param("communityName") String communityName);

   /**
    * 根据房屋id 查询对应的地址信息
    * @param houseId
    * @return
    */
   DoorplateAddressVO getDoorplateAddressDetailByHouseId(@Param("houseId") Long houseId);

   /**
    * 查询未入库的场所
    * @param townName
    * @return
    */
   Integer getNotPlaceListCount(@Param("townName") String townName);
}