Method create

packages/server/src/services/task.service.ts:403–438

* 创建任务 * - 校验项目存在 * - 自动计算 position（同状态下最大 position + 1）

(projectId: string, input: CreateTaskInput)

          latestAgentType: preferredWorkspace.agentType as import('@agent-tower/shared').AgentType,
        } : {}),
        ...(hasRunningSession ? { hasRunningSession: true as const } : {}),
        updatedAt: task.updatedAt.getTime(),
      };
    });

    return {
      data,
      total,
      page,
      limit,
      totalPages: Math.ceil(total / limit),
    };
  }

  /**
   * 获取项目的任务列表（支持按状态过滤和分页）
   */
  async findByProjectId(projectId: string, params: FindTasksParams = {}) {
    // 校验项目存在
    const project = await prisma.project.findUnique({
      where: { id: projectId },
    });
    if (!project) {
      throw new NotFoundError('Project', projectId);
    }

    const page = Math.max(1, params.page || 1);
    const limit = Math.min(1000, Math.max(1, params.limit || 200));
    const skip = (page - 1) * limit;

    const where: any = { projectId, deletedAt: null };
    if (params.status) {
      where.status = params.status;
    }

    // Active tasks first (IN_PROGRESS → IN_REVIEW → TODO), then completed (DONE → CANCELLED).
    // Raw SQL CASE needed because Prisma orderBy doesn't support custom sort functions.
    const statusOrder: Record<string, number> = {
      [TaskStatus.IN_PROGRESS]: 0,