住户删除调整

zhongrj

2024-01-12 ea2efbd460ed26706bb6c956828cbb119dd1e51b

 src/main/java/org/springblade/modules/place/service/impl/PlaceServiceImpl.java

@@ -33,6 +33,7 @@
import org.springblade.modules.grid.service.IGridService;
import org.springblade.modules.grid.service.IGridmanService;
import org.springblade.modules.grid.vo.GridVO;
import org.springblade.modules.house.entity.UserHouseLabelEntity;
import org.springblade.modules.place.entity.*;
import org.springblade.modules.place.excel.PlaceAndRelExcel;
import org.springblade.modules.place.excel.PlaceExcel;
@@ -108,10 +109,6 @@
         if (place.getRoleName().equals("网格员")){
            // 查询对应的房屋地址code
            list = gridService.getAddressCodeListByUserId(AuthUtil.getUserId());
            place.setCreateUser(AuthUtil.getUserId());
         }
         if (!place.getRoleName().equals("系统管理员")){
            place.setCreateUser(AuthUtil.getUserId());
         }
      }
      List<PlaceVO> placeVOS = baseMapper.selectPlacePage(page, place, list);
@@ -121,8 +118,6 @@
         GridVO gridVO = gridService.getGridDetailByHouseCode(placeVO.getHouseCode());
         if (null!= gridVO){
            placeVO.setGridName(gridVO.getGridName());
//            placeVO.setNeiName(gridVO.getCommunityName());
//            placeVO.setTownStreetName(gridVO.getTownStreetName());
         }
      }
      // 返回
@@ -357,8 +352,8 @@
         // 处理单个
         String labelCode = labelList.get(0);
         // 切割成三个，分别是大类，中类，小类
         String bigString = labelCode.substring(0,2);
         String midString = labelCode.substring(0,4);
         String bigString = labelCode.substring(0, 2);
         String midString = labelCode.substring(0, 4);
         // 大类
         PlacePoiLabel big = new PlacePoiLabel();
         big.setPlaceId(placeVO.getId());
@@ -372,7 +367,7 @@
         mid.setType(2);
         placePoiLabelService.save(mid);
         // 处理小类
         if (labelCode.length()>4) {
         if (labelCode.length() > 4) {
            // 小类
            PlacePoiLabel min = new PlacePoiLabel();
            min.setPlaceId(placeVO.getId());
@@ -396,7 +391,14 @@
         //根据手机号查询库里的数据
         User userParams = new User();
         userParams.setPhone(placeVO.getPrincipalPhone());
         userParams.setIsDeleted(0);
         User user = userService.getOne(Condition.getQueryWrapper(userParams));
         if (null==user){
            User userParams1 = new User();
            userParams1.setAccount(placeVO.getPrincipalPhone());
            userParams1.setIsDeleted(0);
            user = userService.getOne(Condition.getQueryWrapper(userParams1));
         }

         if (null!=user) {
            //如果用户存在，则该用户id绑定场所
@@ -447,8 +449,14 @@
      PlaceExtEntity one = placeExtService.getOne(wrapper);
      if (null == one) {
         placeExtEntity.setPlaceId(placeVO.getId());
         //新增
         placeExtService.savePlaceExt(placeExtEntity);
         // 默认给待完善状态
         placeExtEntity.setConfirmFlag(4);
         placeExtEntity.setCreateTime(new Date());
         placeExtEntity.setUpdateTime(new Date());
         placeExtEntity.setCreateUser(AuthUtil.getUserId());
         placeExtEntity.setUpdateUser(AuthUtil.getUserId());
         // 新增场所详情
         placeExtService.save(placeExtEntity);
      }
   }

@@ -527,7 +535,7 @@
               List<DoorplateAddressEntity> list = doorplateAddressService.list(wrapper);
               if (list.size() > 0) {
                  placeVO.setDoorplateAddressEntity(list.get(0));
                  placeVO.setNeiCode(list.get(0).getNeiCode().replaceAll("0+$", ""));
                  placeVO.setNeiCode(list.get(0).getNeiCode());
               }
               // 查询网格数据
               GridVO gridVO = gridService.getGridDetailByHouseCode(place.getHouseCode());
@@ -535,6 +543,10 @@
                  placeVO.setGrid(gridVO);
                  place.setGridId(gridVO.getId());
               }
               // 设置详情信息
               QueryWrapper<PlaceExtEntity> queryWrapper = new QueryWrapper<>();
               queryWrapper.eq("is_deleted",0).eq("place_id",placeVO.getId());
               placeVO.setPlaceExtEntity(placeExtService.getOne(queryWrapper));
            } else {
               // 通过定位点落面分析网格位置，反向推出社区派出所相关数据

@@ -620,6 +632,7 @@
    * @param isCovered
    */
   @Override
   @Transactional(rollbackFor = Exception.class)
   public void importAndRelPlace(List<PlaceAndRelExcel> data, Boolean isCovered) {
      for (PlaceAndRelExcel placeExcel : data) {
         // 判断是否存在，不存在则插入，否则不操作
@@ -638,6 +651,10 @@
            placeEntity.setCreateUser(AuthUtil.getUserId());
            placeEntity.setUpdateTime(new Date());
            placeEntity.setUpdateUser(AuthUtil.getUserId());
            // 并生成36位的houseCode
            placeEntity.setHouseCode(IdUtils.getIdBy36());
            // 商超数据
            placeEntity.setSource(3);
            //一个一个插入，防止同一个表中有相同的数据
            save(placeEntity);
            // 插入标签关系表
@@ -807,4 +824,79 @@
      }
      return null;
   }

   /**
    * 商超数据处理
    * @return
    */
   @Override
   public Object placeAndRelHandle() {
      // 查询未处理的商超数据
      List<PlaceEntity> placeEntityList = baseMapper.placeAndRelHandle();
      // 处理
      for (PlaceEntity placeEntity : placeEntityList) {
         if (Strings.isBlank(placeEntity.getHouseCode())){
            // 并生成36位的houseCode
            placeEntity.setHouseCode(IdUtils.getIdBy36());
            // 商超数据
            placeEntity.setSource(3);
            // 更新
            updateById(placeEntity);
         }
      }
      return null;
   }

   /**
    * 根据编号集合查询对应的场所（按颜色区分近多少天没有发过任务的场所）
    * @param stringList
    * @param tableName
    * @return
    */
   @Override
   public List<PlaceVO> getPlaceListByParam(List<String> stringList,String tableName) {
      return baseMapper.getPlaceListByParam(stringList,tableName);
   }

   /**
    * 删除
    * @param longs
    * @return
    */
   @Override
   @Transactional(rollbackFor = Exception.class)
   public boolean removePlace(List<Long> longs) {
      // 删除
      boolean removeByIds = removeByIds(longs);
      // 删除对应的详情
      removePlaceExt(longs);
      // 删除对应的标签绑定信息
      removePlaceLabel(longs);
      // 返回
      return removeByIds;
   }

   /**
    * 删除场所对应的详情
    * @param longs
    */
   public void removePlaceExt(List<Long> longs) {
      for (Long id : longs) {
         QueryWrapper<PlaceExtEntity> wrapper = new QueryWrapper<>();
         wrapper.eq("place_id",id);
         placeExtService.remove(wrapper);
      }
   }

   /**
    * 删除对应的标签绑定信息
    * @param longs
    */
   public void removePlaceLabel(List<Long> longs) {
      for (Long id : longs) {
         QueryWrapper<PlacePoiLabel> wrapper = new QueryWrapper<>();
         wrapper.eq("place_id",id);
         placePoiLabelService.remove(wrapper);
      }
   }
}