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

zrj

2024-07-02 96916fb34cdc4907a194d0bafae22a5e2bf378bf

 src/main/java/org/springblade/modules/doorplateAddress/service/impl/DoorplateAddressServiceImpl.java

@@ -276,22 +276,23 @@
         houseParam.setRoleName(roleName);
      }
      // 获取网格员对应的地址编号集合
      List<String> addressCodeList = getHouseCodeList(houseParam);
//      List<String> addressCodeList = getHouseCodeList(houseParam);
      List<String> gridCodeList = getGridCodeList(houseParam);
      List<String> communityCodeList = getCommunityCodeList(houseParam);
      // 获取网格员对应的网格信息
      getGridInfoByGridman(houseParam);
//      getGridInfoByGridman(houseParam);
      // 查小区，场所
      if (houseParam.getType() == 1) {
         // 根据社区名称查询小区集合
         list = baseMapper.getDistrictList(houseParam, addressCodeList, communityCodeList);
         list = baseMapper.getDistrictList(houseParam, gridCodeList, communityCodeList);
      }
      // 查楼栋，街路巷
      if (houseParam.getType() == 2) {
         return getBuildLevelData(houseParam, addressCodeList, map);
         return getBuildLevelData(houseParam, gridCodeList, map);
      }
      // 查户室
      if (houseParam.getType() == 3) {
         return getHouseLevelData(houseParam, addressCodeList, map);
         return getHouseLevelData(houseParam, gridCodeList, map);
      }
      return list;
   }
@@ -771,6 +772,28 @@
   }

   /**
    * 根据角色获取网格编号集合
    *
    * @param houseParam
    * @return
    */
   private List<String> getGridCodeList(HouseParam houseParam) {
      List<String> gridCodeList = new ArrayList<>();
      String userId = AuthUtil.getUserId().toString();
      houseParam.setUserId(userId);
      if (null != houseParam.getRoleName() && !houseParam.getRoleName().equals("")) {
         if ((houseParam.getRoleName().equals("wgy") || houseParam.getRoleName().equals("wzcj"))
            && !userId.equals("1726859808689696770")) {
            // 查询对应社区编号集合
            gridCodeList
               = SysCache.getGridRegionChildCodesByDeptId(AuthUtil.getDeptId(), null, houseParam.getRoleName());
         }
      }
      // 返回
      return gridCodeList;
   }

   /**
    * 房屋数据处理
    *
    * @return