⚡ 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, eq } from "drizzle-orm";
import { HTTPException } from "hono/http-exception";
import db from "../../database";
import { userTable, workspaceUserTable } from "../../database/schema";
import { isOwnerRole } from "../../project-access/is-owner-role";
import type { AdminAuditRequest } from "../audit/admin-audit-request";
import { recordWorkspaceMemberAction } from "../audit/record-workspace-member-action";
import { handleMemberRemoved } from "../../workspace-members/handle-member-removed";
import { lockWorkspace } from "../lock-workspace";
import listWorkspaceMembers from "./list-workspace-members";
async function removeWorkspaceMember(
request: {
workspaceId: string;
userId: string;
},
audit: AdminAuditRequest,
) {
const { workspaceId, userId } = request;
await db.transaction(async (tx) => {
const members = await lockWorkspace(tx, workspaceId);
const member = members.find((candidate) => candidate.userId === userId);
if (!member) {
throw new HTTPException(404, { message: "Member not found" });
}
const owners = members.filter((candidate) => isOwnerRole(candidate.role));
if (isOwnerRole(member.role) && owners.length === 1) {
throw new HTTPException(409, {
message:
"Transfer ownership to another member before removing the only owner",
});
}
await tx
.delete(workspaceUserTable)
.where(
and(
eq(workspaceUserTable.workspaceId, workspaceId),
eq(workspaceUserTable.userId, userId),
),
);
await recordWorkspaceMemberAction(tx, audit, {
action: "workspace.member_removed",
workspaceId,
userId,
metadata: { role: member.role },
});
});
const [user] = await db
.select({ role: userTable.role })
.from(userTable)
.where(eq(userTable.id, userId))
.limit(1);
await handleMemberRemoved({ workspaceId, userId, userRole: user?.role });
return listWorkspaceMembers(workspaceId);
}
export default removeWorkspaceMember;