⚡ 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, inArray } from "drizzle-orm";
import { schema } from "../database";
import { hasInstanceAdminRole } from "../utils/instance-admin-role";
import { roleHasWorkspacePermission } from "../utils/require-workspace-permission";
import type { DbOrTx } from "./db-or-tx";
export async function lockAccessChange(
database: DbOrTx,
change: { workspaceId: string; actorId: string; userId: string },
): Promise<{ actorAllowed: boolean; targetRole: string | null }> {
const rows = await database
.select({
userId: schema.workspaceUserTable.userId,
role: schema.workspaceUserTable.role,
})
.from(schema.workspaceUserTable)
.where(
and(
eq(schema.workspaceUserTable.workspaceId, change.workspaceId),
inArray(schema.workspaceUserTable.userId, [
change.actorId,
change.userId,
]),
),
)
.orderBy(schema.workspaceUserTable.id)
.for("update");
const roles = new Map(rows.map((row) => [row.userId, row.role]));
const actorRole = roles.get(change.actorId);
if (
actorRole &&
(await roleHasWorkspacePermission(
change.workspaceId,
actorRole,
{ member: ["update"] },
database,
))
) {
return { actorAllowed: true, targetRole: roles.get(change.userId) ?? null };
}
const [actor] = await database
.select({ role: schema.userTable.role })
.from(schema.userTable)
.where(eq(schema.userTable.id, change.actorId))
.limit(1);
const actorAllowed = hasInstanceAdminRole(actor?.role);
return { actorAllowed, targetRole: roles.get(change.userId) ?? null };
}