fix(gd): 修复线索事件查询中的SQL语法错误

linwei

4 hours ago 08ddfad4530a014094c06fe68b8c2d9a0753403a

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

@@ -51,11 +51,13 @@
import org.sxkj.gd.workorder.mapper.GdWorkOrderMapper;
import org.sxkj.gd.workorder.param.GdPatrolTaskAuditParam;
import org.sxkj.gd.workorder.param.GdPatrolTaskPageParam;
import org.sxkj.gd.workorder.param.GdPatrolTaskPendingAcceptanceQueryParam;
import org.sxkj.gd.workorder.service.IGdManageDeviceService;
import org.sxkj.gd.workorder.service.IGdPatrolTaskService;
import org.sxkj.gd.workorder.service.IGdTaskResultService;
import org.sxkj.gd.workorder.service.IGdWorkOrderFlowService;
import org.sxkj.gd.workorder.utils.GdPatrolReportWordUtil;
import org.sxkj.gd.workorder.utils.WorkOrderStatusAggregator;
import org.sxkj.gd.workorder.vo.GdPatrolTaskSimpleVO;
import org.sxkj.gd.workorder.vo.GdPatrolTaskVO;
import org.sxkj.gd.xingtu.JianXingtuApiService;
@@ -102,7 +104,7 @@
   @Override
   public IPage<GdPatrolTaskVO> selectGdPatrolTaskPage(IPage<GdPatrolTaskVO> page, GdPatrolTaskPageParam gdPatrolTask) {
      List<Long> deptList = new ArrayList<>();
      if (!AuthUtil.isAdministrator() || !AuthUtil.isAdmin()) {
      if (!(AuthUtil.isAdministrator() || AuthUtil.isAdmin())) {
         deptList = SysCache.getDeptChildIds(Long.valueOf(StringUtil.isBlank(AuthUtil.getDeptId()) ? "0" : AuthUtil.getDeptId()));
      }
      gdPatrolTask.setDeptList(deptList);
@@ -276,19 +278,15 @@
         }
      }
      if (auditStatus == 3) {
         // 撤回任务操作：查询同一个工单下的所有子任务
         // 撤回任务操作：使用状态聚合工具类计算主任务状态
         List<GdPatrolTaskEntity> subTasks = list(Wrappers.<GdPatrolTaskEntity>lambdaQuery()
            .eq(GdPatrolTaskEntity::getWorkOrderId, task.getWorkOrderId()));

         // 检查是否所有子任务都已撤回
         boolean allSubTasksWithdrawn = subTasks.stream()
            .allMatch(item -> item.getTaskStatus().equals(PatrolTaskStatusEnum.WITHDRAWN.getValue()));

         // 如果所有子任务都已撤回，则将工单状态更新为"接单响应_已取消"
         if (allSubTasksWithdrawn) {
            return updateWorkOrderStatusAndFlow(task.getWorkOrderId(),
               WorkOrderStatusEnum.RESPONDING_CANCELED);
         }
         // 使用状态聚合工具类计算主任务状态
         WorkOrderStatusEnum newWorkOrderStatus = WorkOrderStatusAggregator.aggregateWorkOrderStatus(subTasks);
			
         // 更新主任务状态
         updateWorkOrderStatusAndFlow(task.getWorkOrderId(), newWorkOrderStatus);
      }
      // 7. 验收拒绝
      if (auditStatus == 7) {
@@ -793,6 +791,26 @@
   }

   /**
    * 查询待验收状态的巡查任务列表（对外接口）
    *
    * @param queryParam 查询参数，包含任务名称和时间区间
    * @return 待验收状态的巡查任务列表
    */
   @Override
   public List<GdPatrolTaskVO> selectPendingAcceptanceTasks(GdPatrolTaskPendingAcceptanceQueryParam queryParam) {
      // 1. 参数校验：防止空指针
      if (queryParam == null) {
         queryParam = new GdPatrolTaskPendingAcceptanceQueryParam();
      }

      // 2. 调用Mapper查询待验收状态的巡查任务
      List<GdPatrolTaskVO> pendingAcceptanceTasks = baseMapper.selectPendingAcceptanceTasks(queryParam);

      // 3. 返回查询结果
      return pendingAcceptanceTasks;
   }

   /**
    * 将区域编码转换为多级行政区划编码格式
    *
    * @param areaCode 区域编码（如：360802）