住户删除，场所删除，三色任务执行修改

zhongrj

2024-01-12 ed28663eebdcc20325474e70be42e10e91fad930

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

@@ -19,6 +19,7 @@
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import liquibase.repackaged.org.apache.commons.lang3.StringUtils;
import org.apache.logging.log4j.util.Strings;
import org.springblade.common.node.TreeStringNode;
import org.springblade.common.utils.IdUtils;
@@ -33,6 +34,9 @@
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.HouseholdEntity;
import org.springblade.modules.house.entity.UserHouseLabelEntity;
import org.springblade.modules.house.service.IHouseholdService;
import org.springblade.modules.place.entity.*;
import org.springblade.modules.place.excel.PlaceAndRelExcel;
import org.springblade.modules.place.excel.PlaceExcel;
@@ -91,6 +95,9 @@
   @Autowired
   private GridMapper gridMapper;

   @Autowired
   private IHouseholdService householdService;

   /**
    * 自定义列表查询
    * @param page
@@ -108,10 +115,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 +124,6 @@
         GridVO gridVO = gridService.getGridDetailByHouseCode(placeVO.getHouseCode());
         if (null!= gridVO){
            placeVO.setGridName(gridVO.getGridName());
//            placeVO.setNeiName(gridVO.getCommunityName());
//            placeVO.setTownStreetName(gridVO.getTownStreetName());
         }
      }
      // 返回
@@ -454,13 +455,8 @@
      PlaceExtEntity one = placeExtService.getOne(wrapper);
      if (null == one) {
         placeExtEntity.setPlaceId(placeVO.getId());
         if (!Strings.isBlank(placeVO.getPrincipalPhone())) {
            // 待审核
            placeExtEntity.setConfirmFlag(1);
         }else {
            // 待完善
            placeExtEntity.setConfirmFlag(4);
         }
         // 默认给待完善状态
         placeExtEntity.setConfirmFlag(4);
         placeExtEntity.setCreateTime(new Date());
         placeExtEntity.setUpdateTime(new Date());
         placeExtEntity.setCreateUser(AuthUtil.getUserId());
@@ -553,6 +549,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 {
               // 通过定位点落面分析网格位置，反向推出社区派出所相关数据

@@ -830,4 +830,129 @@
      }
      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) {
      // 删除场所负责人对应的用户
      removeUser(longs);
      // 删除
      boolean removeByIds = removeByIds(longs);
      // 删除对应的详情
      removePlaceExt(longs);
      // 删除对应的标签绑定信息
      removePlaceLabel(longs);
      // 返回
      return removeByIds;
   }

   /**
    * 删除场所负责人对应的用户
    * @param longs
    */
   public void removeUser(List<Long> longs) {
      // 遍历
      for (Long id : longs) {
         PlaceEntity placeEntity = getById(id);
         if (null!=placeEntity.getPrincipalUserId()){
            User user = userService.getById(placeEntity.getPrincipalUserId());
            // 查询场所判断是否还绑定有其他的场所
            QueryWrapper<PlaceEntity> queryWrapper = new QueryWrapper<>();
            queryWrapper.eq("is_deleted",0).eq("principal_user_id",user.getId());
            List<PlaceEntity> placeEntityList = list(queryWrapper);
            // 如果没有（1个 当前的还没有删除）
            if (placeEntityList.size()==1){
               // 判断角色
               if (!Strings.isBlank(user.getRoleId())){
                  // 判断是否还绑定其他的房屋，如果有，则不操作用户
                  QueryWrapper<HouseholdEntity> wrapper = new QueryWrapper<>();
                  wrapper.eq("is_deleted",0).eq("associated_user_id",user.getId());
                  List<HouseholdEntity> householdEntityList = householdService.list(wrapper);
                  // 即没有房屋和场所了就删除对应的居民角色
                  if (householdEntityList.size()==0) {
                     List<String> stringList = Arrays.asList(user.getRoleId().split(","));
                     // 查看当前用户的角色是否只有一个
                     if (stringList.size() > 1) {
                        // 查询是否对应有场所负责人，如果有则不删除，如果没有则删除对应的角色
                        List<String> arrayList = new ArrayList<>();
                        for (String roleId : stringList) {
                           if (!roleId.equals("1717429059648606209")) {
                              arrayList.add(roleId);
                           }
                        }
                        user.setRoleId(StringUtils.join(arrayList, ","));
                        // 更新用户
                        userService.updateById(user);
                     } else {
                        // 删除当前用户
                        userService.removeById(user.getId());
                     }
                  }
               }
            }
         }
      }
   }

   /**
    * 删除场所对应的详情
    * @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);
      }
   }
}