opt: 更新工单结果

linwei

2026-04-08 a837aade3a9245b27bc9a578984f2e54dd080b84

opt: 更新工单结果

 drone-service/drone-gd/src/main/java/org/sxkj/gd/workorder/mapper/GdTaskResultMapper.java

@@ -53,4 +53,12 @@
     */
    List<GdTaskResultExcel> exportGdTaskResult(@Param("ew") Wrapper<GdTaskResultEntity> queryWrapper);

    /**
     * 根据ID更新成果信息（更新所有字段）
     *
     * @param taskResult 成果实体
     * @return 影响行数
     */
    int updateTaskResultById(GdTaskResultEntity taskResult);

}

 drone-service/drone-gd/src/main/java/org/sxkj/gd/workorder/mapper/GdTaskResultMapper.xml

@@ -66,4 +66,23 @@
        SELECT * FROM ja_gd_task_result ${ew.customSqlSegment}
    </select>

    <!-- 根据ID更新成果信息（更新所有字段） -->
    <update id="updateTaskResultById">
        UPDATE ja_gd_task_result
        SET patrol_task_id = #{patrolTaskId},
            result_code = #{resultCode},
            result_url = #{resultUrl},
            shoot_time = #{shootTime},
            photo_data = #{photoData}::jsonb,
            longitude = #{longitude},
            latitude = #{latitude},
            distribute_status = #{distributeStatus},
            area_code = #{areaCode},
            update_user = #{updateUser},
            update_time = #{updateTime},
            status = #{status},
            is_deleted = #{isDeleted}
        WHERE id = #{id}
    </update>

</mapper>

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

@@ -57,4 +57,12 @@
     * @return
     */
    boolean saveBatchTaskResult(List<GdTaskResultEntity> gdTaskResultEntities);

    /**
     * 根据ID更新成果信息（更新所有字段）
     *
     * @param taskResult 成果实体
     * @return 是否成功
     */
    boolean updateTaskResultById(GdTaskResultEntity taskResult);
}

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

@@ -141,7 +141,7 @@
        taskResult.setDistributeStatus(1);
        taskResult.setUpdateUser(AuthUtil.getUserId());
        taskResult.setUpdateTime(new Date());
        if (!gdTaskResultService.updateById(taskResult)) {
        if (!gdTaskResultService.updateTaskResultById(taskResult)) {
            throw new RuntimeException("成果状态更新失败");
        }
        return true;
@@ -172,10 +172,11 @@
        if (taskResult == null || (taskResult.getIsDeleted() != null && taskResult.getIsDeleted() != 0)) {
            throw new RuntimeException("成果不存在");
        }
        // 使用XML方式更新成果信息（更新所有字段）
        taskResult.setDistributeStatus(targetStatus);
        taskResult.setUpdateUser(AuthUtil.getUserId());
        taskResult.setUpdateTime(new Date());
        if (!gdTaskResultService.updateById(taskResult)) {
        if (!gdTaskResultService.updateTaskResultById(taskResult)) {
            throw new RuntimeException("成果状态更新失败");
        }
        return true;

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

@@ -72,6 +72,12 @@
        return saveBatch(gdTaskResultEntities);
    }

    @Override
    public boolean updateTaskResultById(GdTaskResultEntity taskResult) {
        int result = baseMapper.updateTaskResultById(taskResult);
        return result > 0;
    }

    /**
     * 将URL中的HTML/XML转义字符还原为原始字符
     * 主要处理 &amp; 转换为 &