Skip to content

armgit / kaneo

Public Imported from GitHub
0

⚡ Project management that doesn't become the project. Boards, Gantt charts, and GitHub integration. Self-host it or use Kaneo Cloud.

7.9 KB
Raw Blame
import { acceptsIssue } from "../../sync/rules";
import { importIssueLabels } from "../../sync/issue-labels";
import { canSyncTask } from "../../sync/eligibility";
import { createIssueWrite } from "../../sync/dispatch-issue-write";
import { and, eq } from "drizzle-orm";
import db from "../../../database";
import { publishEvent } from "../../../events";
import {
  columnTable,
  integrationTable,
  projectTable,
  taskTable,
} from "../../../database/schema";
import { claimTaskNumber } from "../../../task/controllers/claim-task-numbers";
import type { GitHubConfig } from "../config";
import { createExternalLink, findExternalLink } from "../services/link-manager";
import { confirmedFieldLabels } from "../../sync/field-labels";
import { findAllIntegrationsByRepo } from "../services/task-service";
import {
  extractIssuePriority,
  extractIssueStatus,
} from "../utils/extract-priority";
import { formatTaskDescriptionFromIssue } from "../utils/format";
import { getGithubApp } from "../utils/github-app";
import { addLabelsToIssue } from "../utils/labels";
import { resolveTargetStatus } from "../utils/resolve-column";

type IssueOpenedPayload = {
  action: string;
  issue: {
    number: number;
    title: string;
    state?: string;
    body: string | null;
    html_url: string;
    labels?: Array<string | { name?: string; color?: string }>;
    user: { login: string } | null;
  };
  installation?: { id: number };
  repository: {
    id: number;
    owner: { login: string };
    name: string;
    full_name: string;
  };
};

export async function handleIssueOpened(
  payload: IssueOpenedPayload,
  integrationId?: string,
) {
  const githubApp = getGithubApp();
  if (!githubApp) {
    return;
  }

  const { issue, repository } = payload;

  const appName = process.env.GITHUB_APP_NAME;
  if (appName && issue.user?.login === `${appName}[bot]`) {
    console.log(
      `Issue #${issue.number} was created by the configured GitHub App, skipping task creation`,
    );
    return;
  }

  const integrations = (await findAllIntegrationsByRepo(payload)).filter(
    (integration) => !integrationId || integration.id === integrationId,
  );

  if (integrations.length === 0) {
    return;
  }

  for (const integration of integrations) {
    if (!acceptsIssue(integration.config, issue.labels)) continue;
    const config = JSON.parse(integration.config) as GitHubConfig;
    const projectId = integration.projectId;
    const closed = issue.state === "closed";

    const priority = extractIssuePriority(issue.labels);
    const status = extractIssueStatus(issue.labels);

    const result = await db.transaction(async (tx) => {
      // Use the same integration lock as resumable imports before checking the
      // link. The task and link must either both commit or both roll back.
      const [current] = await tx
        .select()
        .from(integrationTable)
        .where(eq(integrationTable.id, integration.id))
        .for("update");
      if (!current?.isActive || current.config !== integration.config)
        return null;
      const existingLink = await findExternalLink(
        integration.id,
        "issue",
        String(issue.number),
        tx,
      );
      if (existingLink) return null;
      const targetStatus = await resolveTargetStatus(
        projectId,
        closed ? "issue_closed" : "issue_opened",
        closed ? "done" : status || "to-do",
        tx,
      );
      let targetColumn = await tx.query.columnTable.findFirst({
        where: and(
          eq(columnTable.projectId, projectId),
          eq(columnTable.slug, targetStatus),
        ),
      });
      if (closed && !targetColumn?.isFinal)
        targetColumn = await tx.query.columnTable.findFirst({
          where: and(
            eq(columnTable.projectId, projectId),
            eq(columnTable.isFinal, true),
          ),
          orderBy: (column, { asc }) => [asc(column.position)],
        });
      const number = await claimTaskNumber(projectId, tx);
      const [task] = await tx
        .insert(taskTable)
        .values({
          projectId,
          userId: null,
          title: issue.title,
          description: formatTaskDescriptionFromIssue(issue.body),
          status: closed ? (targetColumn?.slug ?? "done") : targetStatus,
          columnId: targetColumn?.id ?? null,
          priority: priority ?? "low",
          number,
        })
        .returning();
      if (!task) throw new Error("Failed to create task from GitHub issue");
      const link = await createExternalLink(
        {
          taskId: task.id,
          integrationId: integration.id,
          resourceType: "issue",
          externalId: String(issue.number),
          url: issue.html_url,
          title: issue.title,
          metadata: {
            state: closed ? "closed" : "open",
            createdFrom: "github",
            author: issue.user?.login,
            ...confirmedFieldLabels(issue.labels),
          },
        },
        tx,
      );
      await importIssueLabels(
        task.id,
        integration.project.workspaceId,
        issue.labels,
        tx,
      );
      const eligible = await canSyncTask(
        task.id,
        integration.id,
        tx,
        integration.config,
      );
      return { task, link, eligible };
    });
    if (!result) continue;
    const { task: createdTask, link, eligible } = result;
    await publishEvent("task.created", {
      ...createdTask,
      taskId: createdTask.id,
      userId: createdTask.userId ?? "",
      type: "task",
      content: null,
      source: "github",
      externalId: issue.number.toString(),
      actor: issue.user?.login ?? "github-webhook",
    });
    if (!eligible) continue;
    const write = createIssueWrite(
      { id: link.id, taskId: createdTask.id, integrationId: integration.id },
      integration.config,
    );

    const project = await db.query.projectTable.findFirst({
      where: eq(projectTable.id, projectId),
    });

    if (!project) {
      console.error("Project not found for task linking comment");
      continue;
    }

    const clientUrl = process.env.KANEO_CLIENT_URL || "http://localhost:5173";
    const taskUrl = `${clientUrl}/dashboard/workspace/${project.workspaceId}/project/${projectId}/task/${createdTask.id}`;
    const taskIdentifier = `${project.slug.toUpperCase()}-${createdTask.number}`;

    try {
      let installationId = config.installationId;
      if (!installationId) {
        const { data: installation } =
          await githubApp.octokit.rest.apps.getRepoInstallation({
            owner: repository.owner.login,
            repo: repository.name,
          });
        installationId = installation.id;
      }

      const octokit = await githubApp.getInstallationOctokit(installationId);

      const existingLabels =
        issue.labels
          ?.map((label) => (typeof label === "string" ? label : label.name))
          .filter(Boolean) || [];

      const labelsToAdd: string[] = [];

      if (priority && !existingLabels.includes(`priority:${priority}`)) {
        labelsToAdd.push(`priority:${priority}`);
      }

      if (status && !existingLabels.includes(`status:${status}`)) {
        labelsToAdd.push(`status:${status}`);
      }

      if (labelsToAdd.length > 0) {
        await addLabelsToIssue(
          octokit,
          repository.owner.login,
          repository.name,
          issue.number,
          labelsToAdd,
          true,
          write,
        );
      }

      if (config.commentTaskLinkOnGitHubIssue !== false) {
        await write(() =>
          octokit.rest.issues.createComment({
            owner: repository.owner.login,
            repo: repository.name,
            issue_number: issue.number,
            body: `[${taskIdentifier}](${taskUrl})`,
          }),
        );
      }
    } catch {
      console.error("GitHub imported issue linking write failed", {
        projectId,
        taskId: createdTask.id,
        integrationId: integration.id,
        linkId: link.id,
      });
    }
  }
}