Open-source manufacturing ERP, MES and QMS. Quoting, MRP, inventory, shop floor, quality and lot/serial traceability on one Postgres schema, with a REST API and MCP server. Self-host or use Carbon Cloud.
TypeScript ai-agentsbill-of-materialserpinventory-managementleanmanufacturingmanufacturing-execution-systemmcp-servermesmrpopen-source-erppostgresqlproduction-planningqmsquality-management-systemreact-routerself-hostedsupabasetraceabilitytypescript
// SPDX-License-Identifier: AGPL-3.0-only
// Carbon (github.com/crbnos/carbon). Modified or adapted versions of this file,
// including ports, remain AGPLv3; serving them over a network requires releasing their source.
import type { Database, Json } from "@carbon/database";
import { getLogger } from "@carbon/logger";
import type { SupabaseClient } from "@supabase/supabase-js";
import { SUPABASE_URL } from "../config/env";
import type { Permission } from "../types";
const log = getLogger("auth");
export async function getClaims(
client: SupabaseClient<Database>,
uid: string,
company?: string
) {
return client.rpc("get_claims", { uid, company: company ?? "" });
}
export function getPermissionCacheKey(userId: string) {
return `permissions:${userId}`;
}
/**
* Does a resolved claims permission set grant `<module>_<action>` for the company?
* Honors the `"0"` all-companies wildcard, matching `requirePermissions`. `permissions`
* is the `permissions` field from `makePermissionsFromClaims` / `getUserClaims`.
*/
export function hasPermission(
permissions: Record<string, Permission> | null | undefined,
module: string,
action: keyof Permission,
companyId: string
): boolean {
const scoped = permissions?.[module]?.[action];
return scoped?.some((c) => c === companyId || c === "0") ?? false;
}
export async function getCompanies(
client: SupabaseClient<Database>,
userId: string
) {
const companies = await client
.from("companies")
.select("*")
.eq("userId", userId)
.order("name");
if (companies.error) {
return companies;
}
return {
data: companies.data.map((company) => ({
...company,
logoLightIcon: company.logoLightIcon
? `${SUPABASE_URL}/storage/v1/object/public/public/${company.logoLightIcon}`
: null,
logoDarkIcon: company.logoDarkIcon
? `${SUPABASE_URL}/storage/v1/object/public/public/${company.logoDarkIcon}`
: null,
logoLight: company.logoLight
? `${SUPABASE_URL}/storage/v1/object/public/public/${company.logoLight}`
: null,
logoDark: company.logoDark
? `${SUPABASE_URL}/storage/v1/object/public/public/${company.logoDark}`
: null
})),
error: null
};
}
export async function getCompaniesForUser(
client: SupabaseClient<Database>,
userId: string
) {
const { data, error } = await client
.from("userToCompany")
.select("companyId")
.eq("userId", userId);
if (error) {
log.error("Failed to get companies for user", { userId, error });
return [];
}
return data?.map((row) => row.companyId) ?? [];
}
export async function getUser(client: SupabaseClient<Database>, id: string) {
return client
.from("user")
.select("*")
.eq("id", id)
.eq("active", true)
.single();
}
function isClaimPermission(key: string, value: unknown) {
const action = key.split("_")[1];
return (
action !== undefined &&
["view", "create", "update", "delete"].includes(action) &&
Array.isArray(value)
);
}
export function makePermissionsFromClaims(claims: Json | null) {
if (typeof claims !== "object" || claims === null) return null;
let permissions: Record<string, Permission> = {};
let role: string | null = null;
Object.entries(claims).forEach(([key, value]) => {
if (isClaimPermission(key, value)) {
const [module, action] = key.split("_") as [string, string];
if (!(module in permissions)) {
permissions[module] = {
view: [],
create: [],
update: [],
delete: []
};
}
const perm = permissions[module]!;
switch (action) {
case "view":
// biome-ignore lint/complexity/useLiteralKeys: suppressed due to migration
perm["view"] = value as string[];
break;
case "create":
// biome-ignore lint/complexity/useLiteralKeys: suppressed due to migration
perm["create"] = value as string[];
break;
case "update":
// biome-ignore lint/complexity/useLiteralKeys: suppressed due to migration
perm["update"] = value as string[];
break;
case "delete":
// biome-ignore lint/complexity/useLiteralKeys: suppressed due to migration
perm["delete"] = value as string[];
break;
}
}
});
if ("role" in claims) {
// biome-ignore lint/complexity/useLiteralKeys: suppressed due to migration
role = claims["role"] as string;
}
if ("items" in permissions) {
// biome-ignore lint/complexity/useLiteralKeys: suppressed due to migration
delete permissions["items"];
}
return { permissions, role };
}