feat(utils): 添加几何数据处理和区域编码转换功能

linwei

2026-06-05 f3104f14213028277c883e19301b820ae724bd70

 drone-service/drone-gd/src/main/java/org/sxkj/gd/workorder/service/impl/GdWorkOrderServiceImpl.java

@@ -1,10 +1,11 @@
package org.sxkj.gd.workorder.service.impl;

import com.alibaba.druid.support.json.JSONUtils;
import com.alibaba.fastjson.JSON;
import com.alibaba.fastjson.JSONObject;
import com.baomidou.mybatisplus.core.conditions.Wrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
import lombok.extern.slf4j.Slf4j;
import org.apache.commons.lang3.StringUtils;
import org.springblade.core.mp.base.BaseServiceImpl;
import org.springblade.core.secure.utils.AuthUtil;
@@ -14,6 +15,7 @@
import org.springframework.transaction.annotation.Transactional;
import org.sxkj.common.constant.CommonConstant;
import org.sxkj.common.constant.WordOrderConstant;
import org.sxkj.common.utils.AmapUtils;
import org.sxkj.common.utils.GeomUtils;
import org.sxkj.common.utils.OrderNumUtils;
import org.sxkj.gd.workorder.entity.GdPatrolTaskEntity;
@@ -33,9 +35,7 @@
import org.sxkj.gd.workorder.vo.GdWorkOrderVO;
import org.sxkj.system.cache.SysCache;

import java.util.Date;
import java.util.List;
import java.util.Objects;
import java.util.*;

/**
 * 工单任务表 服务实现类
@@ -43,6 +43,7 @@
 * @author lw
 * @since 2026-01-14
 */
@Slf4j
@Service
public class GdWorkOrderServiceImpl extends BaseServiceImpl<GdWorkOrderMapper, GdWorkOrderEntity> implements IGdWorkOrderService {

@@ -52,14 +53,17 @@
   private IGdPatrolTaskService gdPatrolTaskService;

   @Override
   public GdWorkOrderEntity getWorkOrderDetail(GdWorkOrderEntity gdWorkOrder) {
   public GdWorkOrderVO getWorkOrderDetail(GdWorkOrderEntity gdWorkOrder) {
      return baseMapper.getWorkOrderDetail(gdWorkOrder);
   }

   @Override
   public IPage<GdWorkOrderVO> selectGdWorkOrderPage(IPage<GdWorkOrderVO> page, WorkOrderPageParam gdWorkOrder) {
      if (gdWorkOrder.getIsQueryAll()) {
         List<Long> deptList = SysCache.getDeptChildIds(Long.valueOf(AuthUtil.getDeptId()));
         List<Long> deptList = new ArrayList<>();
         if (!AuthUtil.isAdministrator() || !AuthUtil.isAdmin()) {
            deptList = SysCache.getDeptChildIds(Long.valueOf(AuthUtil.getDeptId()));
         }
         gdWorkOrder.setDeptList(deptList);
      }
      return page.setRecords(baseMapper.selectGdWorkOrderPage(page, gdWorkOrder));
@@ -75,12 +79,6 @@
      return gdWorkOrderList;
   }

   /**
    * 保存工单任务表
    *
    * @param workOrderParam
    * @return
    */
   @Override
   @Transactional(rollbackFor = Exception.class)
   public boolean saveOrUpdateWorkOrder(WorkOrderAddParam workOrderParam) {
@@ -94,6 +92,13 @@
      }
      entity.setGeom(validatedGeom);

      // 从几何数据中提取中心点坐标，用于获取行政区划编码
      double[] centerCoords = GeomUtils.extractCenterPoint(validatedGeom);
      if (centerCoords == null || centerCoords.length < 2) {
         return false;
      }
      String areaCodePrefix = getDistrictCodeByLocation(centerCoords[0], centerCoords[1]);
      entity.setAreaCode(areaCodePrefix);
      // 生成工单编号
      if (StringUtils.isBlank(entity.getWorkOrderCode())) {
         String timestamp = OrderNumUtils.initOrderNum(WordOrderConstant.ORDER_REDIS_KEY);
@@ -114,10 +119,6 @@
               entity.setWorkOrderStatus(WorkOrderStatusEnum.PUBLISHING_ACCEPTING.getCode());
               newStatusEnum = WorkOrderStatusEnum.PUBLISHING_ACCEPTING;
               break;
            // case "24": // 响应中_拒绝取消 → 响应中_申请取消
            //    entity.setWorkOrderStatus(WorkOrderStatusEnum.RESPONDING_APPLY_CANCEL.getCode());
            //    newStatusEnum = WorkOrderStatusEnum.RESPONDING_APPLY_CANCEL;
            //    break;
            case "20": // 响应中_待拆分 → 响应中_申请修改
               entity.setWorkOrderStatus(WorkOrderStatusEnum.RESPONDING_APPLY_MODIFY.getCode());
               newStatusEnum = WorkOrderStatusEnum.RESPONDING_APPLY_MODIFY;
@@ -126,10 +127,6 @@
               // 直接生成快照，无需处理geom字段
               entity.setFullSnapshot(JSON.toJSONString(orderEntity));
               break;
            // case "25": // 响应中_拒绝修改 → 响应中_申请修改
            //    entity.setWorkOrderStatus(WorkOrderStatusEnum.RESPONDING_APPLY_MODIFY.getCode());
            //    newStatusEnum = WorkOrderStatusEnum.RESPONDING_APPLY_MODIFY;
            //    break;
         }
         saveResult = updateById(entity);
      } else {
@@ -149,9 +146,11 @@
         flowEntity.setCreateUser(AuthUtil.getUserId());
         flowEntity.setWorkOrderId(entity.getId());
         flowEntity.setFlowName(newStatusEnum.getStageDesc());
         flowEntity.setFlowDesc(String.format("%s %s", AuthUtil.getUserName(), org.springblade.core.tool.utils.DateUtil.format(now, "yyyy-MM-dd HH:mm:ss")));
         flowEntity.setOperator(AuthUtil.getUserName());
         flowEntity.setFlowDesc(newStatusEnum.getDesc());
         flowEntity.setOperator(AuthUtil.getNickName());
         flowEntity.setType(WorkOrderTypeEnum.WORK_ORDER_TASK.getValue());
         flowEntity.setFlowStatus(newStatusEnum.getMaxCode());
         flowEntity.setWorkStatus(newStatusEnum.getCode());
         flowEntity.setAreaCode(entity.getAreaCode());
         flowEntity.setCreateDept(Long.valueOf(AuthUtil.getDeptId()));
         return gdWorkOrderFlowService.save(flowEntity);
@@ -243,28 +242,79 @@
      }
      boolean updateResult = updateById(workOrder);

      // 5. 保存流转记录
      // 5. 把待验收的都改为待签收状态
      if (operationType == 10) {
         return gdPatrolTaskService.update(Wrappers.<GdPatrolTaskEntity>lambdaUpdate()
            .set(GdPatrolTaskEntity::getTaskStatus, PatrolTaskStatusEnum.PENDING_SIGNING.getValue())
            .eq(GdPatrolTaskEntity::getWorkOrderId, workOrder.getId())
            .in(GdPatrolTaskEntity::getTaskStatus,
               PatrolTaskStatusEnum.AUDIT_PASSED.getValue(),
               PatrolTaskStatusEnum.PENDING_ACCEPTANCE.getValue())
         );
      }
      // 6. 保存流转记录
      if (updateResult) {
         GdWorkOrderFlowEntity flowEntity = new GdWorkOrderFlowEntity();
         flowEntity.setCreateUser(AuthUtil.getUserId());
         flowEntity.setWorkOrderId(workOrder.getId());
         flowEntity.setFlowName(newStatusEnum.getStageDesc());
         flowEntity.setFlowDesc(String.format("%s %s", AuthUtil.getUserName(), org.springblade.core.tool.utils.DateUtil.format(now, CommonConstant.YYYY_MM_DD_HH_MM_SS)));
         flowEntity.setOperator(AuthUtil.getUserName());
         flowEntity.setFlowDesc(newStatusEnum.getDesc());
         flowEntity.setOperator(AuthUtil.getNickName());
         flowEntity.setType(WorkOrderTypeEnum.WORK_ORDER_TASK.getValue());
         flowEntity.setFlowStatus(newStatusEnum.getMaxCode());
         flowEntity.setWorkStatus(newStatusEnum.getCode());
         flowEntity.setAreaCode(workOrder.getAreaCode());
         flowEntity.setCreateDept(Long.valueOf(AuthUtil.getDeptId()));
         return gdWorkOrderFlowService.save(flowEntity);
      }
      // 6. 把待验收的都改为待签收状态
      if (operationType == 10) {
         boolean update = gdPatrolTaskService.update(Wrappers.<GdPatrolTaskEntity>lambdaUpdate()
            .set(GdPatrolTaskEntity::getTaskStatus, PatrolTaskStatusEnum.PENDING_SIGNING.getValue())
            .eq(GdPatrolTaskEntity::getWorkOrderId, workOrder.getId())
            .eq(GdPatrolTaskEntity::getTaskStatus, PatrolTaskStatusEnum.PENDING_ACCEPTANCE.getValue())
         );
      }

      return false;
   }

   /**
    * 根据经纬度获取行政区划编码
    *
    * @param longitude 经度
    * @param latitude  纬度
    * @return 行政区划编码
    */
   public String getDistrictCodeByLocation(double longitude, double latitude) {
      Map<String, String> districtInfo = getDistrictInfoByLocation(longitude, latitude);
      String adcode = districtInfo.get("adcode");
      log.info("行政区划信息：{}", adcode);
      // if (adcode != null && adcode.length() >= 3) {
      //    return adcode.substring(0, 2);
      // }
      return adcode;
   }

   /**
    * 根据经纬度获取行政区划信息
    *
    * @param longitude 经度
    * @param latitude  纬度
    * @return 行政区划信息
    */
   public Map<String, String> getDistrictInfoByLocation(double longitude, double latitude) {
      // 使用高德地图工具类获取行政区划信息
      String location = longitude + "," + latitude;
      JSONObject result = AmapUtils.searchByLatLng(location);

      Map<String, String> districtInfo = new HashMap<>();
      if (result != null && "1".equals(result.getString("status"))) {
         JSONObject regeocode = result.getJSONObject("regeocode");
         if (regeocode != null) {
            JSONObject addressComponent = regeocode.getJSONObject("addressComponent");
            if (addressComponent != null) {
               districtInfo.put("province", addressComponent.getString("province"));
               districtInfo.put("city", addressComponent.getString("city"));
               districtInfo.put("district", addressComponent.getString("district"));
               districtInfo.put("adcode", addressComponent.getString("adcode"));
               districtInfo.put("township", addressComponent.getString("township"));
               districtInfo.put("formatted_address", regeocode.getString("formatted_address"));
            }
         }
      }
      return districtInfo;
   }
}