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

zrj

2024-07-02 96916fb34cdc4907a194d0bafae22a5e2bf378bf

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

@@ -16,14 +16,17 @@
 */
package org.springblade.modules.doorplateAddress.mapper;

import com.baomidou.mybatisplus.annotation.InterceptorIgnore;
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.TreeNode;
import org.springblade.common.node.TreeStringNode;
import org.springblade.modules.doorplateAddress.entity.DoorplateAddressEntity;
import org.springblade.modules.doorplateAddress.vo.DoorplateAddressVOTree;
import org.springblade.modules.doorplateAddress.vo.DoorplateAddressVO;
import org.springblade.modules.doorplateAddress.vo.FuncNode;
import org.springblade.modules.house.vo.HouseParam;

import java.util.List;
import java.util.Map;
@@ -48,40 +51,49 @@


   /**
    * 查询区域数据
    * 查询街道数据
    * @return
    */
    List<TreeNode> getRegionListByGrouyTwon();
    List<TreeStringNode> getRegionListByGroupTwon(@Param("houseParam") HouseParam houseParam,
                                                  @Param("list") List<String> list,
                                                  @Param("communityList") List<String> communityList);

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

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

   /**
    * 根据社区名称查询楼栋集合
    * @param name
    * @param code
    * @param houseParam
    * @param list 网格编号集合
    * @return
    */
   List<TreeNode> getBuildingList(@Param("name") String name,@Param("code") String code);
   List<TreeStringNode> getBuildingList(@Param("houseParam") HouseParam houseParam,
                                         @Param("list") List<String> list);

   /**
    *  查询户室及住户相关信息，单元中包含住户
    * @param name
    * @param code
    * @param houseParam
    * @param list
    * @return
    */
   List<FuncNode> getUnitHouseholdList(@Param("name") String name, @Param("code") String code);
   List<FuncNode> getUnitHouseholdList(@Param("houseParam") HouseParam houseParam,
                              @Param("list") List<String> list);

   /**
    * 先查询门牌信息
@@ -89,4 +101,174 @@
    * @return
    */
    DoorplateAddressVO getDoorplateAddressDetailByCode(@Param("code") String code);

   List<DoorplateAddressVOTree> getTownStreetVOTreeList();

   List<DoorplateAddressVOTree> getNeiVOTreeList(@Param("code") String code);

   List<DoorplateAddressVOTree> getStreetRuVOTreeList(@Param("code") String code);


   List<DoorplateAddressVOTree> getDistrictVOTreeList(@Param("code") String code);

   List<DoorplateAddressVOTree> getBuildingVOTreeList(@Param("code") String code);

   /**
    * 查询街路巷
    * @param houseParam
    * @param list
    * @return
    */
   List<TreeStringNode> getStreetRuList(@Param("houseParam") HouseParam houseParam,
                                         @Param("list") List<String> list);

   /**
    * 根据街路巷编号查询街路巷门牌名称集合
    * @param houseParam name/code 该处当社区编号用/ 街路巷编号
    * @param list
    * @return
    */
   List<FuncNode> getDoorplateNameList(@Param("houseParam") HouseParam houseParam,
                              @Param("list") List<String> list);

   /**
    * 根据参数获取地址详情
    * @param doorplateAddressVO
    * @return
    */
   @InterceptorIgnore(tenantLine = "true")
    DoorplateAddressVO getDoorplateAddressDetail(@Param("vo") DoorplateAddressVO doorplateAddressVO);

   /**
    * 根据参数获取地址详情
    * @param doorplateAddressVO
    * @return
    */
   DoorplateAddressVO getDoorplateAddressList(@Param("vo") DoorplateAddressVO doorplateAddressVO);

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

   /**
    * 获取房屋树
    * @param houseParam
    * @param list
    * @return
    */
   @MapKey("code")
    Map<String, DoorplateAddressVOTree> getHouseTree(@Param("houseParam") HouseParam houseParam,
                                        @Param("list") List<String> list);
   /**
    * 查询所有户室数据
    * @param townName
    * @return
    */
   List<DoorplateAddressEntity> getHouseList(@Param("townName") String townName);

   /**
    * 查询商超
    * @param houseParam
    * @return
    */
   List<TreeStringNode> getPlaceRelList(@Param("houseParam") HouseParam houseParam);

   /**
    * 查询商超详情集合
    * @param houseParam
    * @return
    */
   List<FuncNode> getPlaceRelDetailList(@Param("houseParam") HouseParam houseParam);

   /**
    * 查询小区集合
    * @param list
    * @return
    */
   List<DoorplateAddressEntity> getAoiList(@Param("list") List<Long> list);

   /**
    * 查询所有的地址表id集合
    * @return
    */
   List<Long> getAoiCodeList();

   /**
    * 查询所有的地址表和场所表差集集合(没有入库的)
    * @return
    */
   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);
}