⚡ Project management that doesn't become the project. Boards, Gantt charts, and GitHub integration. Self-host it or use Kaneo Cloud.
TypeScript honoissue-managementissue-trackerjira-alternativekanbanlinear-alternativemcpproject-managementreactself-hostedtypescript
import { and, asc, eq } from "drizzle-orm";
import db from "../../../database";
import { columnTable, workflowRuleTable } from "../../../database/schema";
export async function resolveTargetStatus(
projectId: string,
eventType: string,
fallbackStatus: string,
database:
| typeof db
| Parameters<Parameters<typeof db.transaction>[0]>[0] = db,
): Promise<string> {
const projectColumns = await database
.select({
id: columnTable.id,
slug: columnTable.slug,
})
.from(columnTable)
.where(eq(columnTable.projectId, projectId))
.orderBy(asc(columnTable.position));
if (projectColumns.length === 0) {
return fallbackStatus;
}
const rule = await database.query.workflowRuleTable.findFirst({
where: and(
eq(workflowRuleTable.projectId, projectId),
eq(workflowRuleTable.integrationType, "github"),
eq(workflowRuleTable.eventType, eventType),
),
});
if (rule) {
const mappedColumn = projectColumns.find(
(column) => column.id === rule.columnId,
);
if (mappedColumn) {
return mappedColumn.slug;
}
}
const fallbackColumn = projectColumns.find(
(column) => column.slug === fallbackStatus,
);
if (fallbackColumn) {
return fallbackColumn.slug;
}
return projectColumns[0]?.slug ?? fallbackStatus;
}