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 } from "@carbon/database";
import { distinctItemText } from "@carbon/utils";
import { withRevisionSuffix } from "./revision";
export function getLineDescription(
line: Database["public"]["Views"]["purchaseOrderLines"]["Row"]
) {
switch (line?.purchaseOrderLineType) {
case "Fixed Asset":
return line?.assetName ?? "Fixed Asset";
case "G/L Account":
return line?.description;
case "Comment":
return line?.description;
default: {
// Use `||` (not `??`) so an empty-string supplier part number falls
// through. Supplier parts with no part number get backfilled onto the
// line as "", and `??` would render a blank line.
const supplierPartId =
line?.supplierPartId || line?.supplierPartIdFromSupplier;
// `itemReadableId` is the view's `readableIdWithRevision` — the only
// place the revision reaches the document, so the supplier part number
// goes beside it rather than in its place (as the sales order does with
// the customer part number).
if (!line?.itemReadableId) return supplierPartId;
return supplierPartId && supplierPartId !== line.itemReadableId
? `${line.itemReadableId} (${supplierPartId})`
: line.itemReadableId;
}
}
}
export function getLineDescriptionDetails(
line: Database["public"]["Views"]["purchaseOrderLines"]["Row"]
) {
switch (line?.purchaseOrderLineType) {
case "Fixed Asset":
return line?.description;
case "G/L Account":
return line.accountName
? `G/L Account: ${line.accountName}`
: "G/L Account";
case "Comment":
default:
// A service's readable id is its name — don't print it twice.
return [
distinctItemText(line?.itemReadableId, line?.description),
line?.itemDescription
]
.filter(Boolean)
.join("\n");
}
}
export function getLineTotal(
line: Database["public"]["Views"]["purchaseOrderLines"]["Row"]
) {
return (
(line?.purchaseQuantity ?? 0) * (line?.supplierUnitPrice ?? 0) +
(line?.supplierShippingCost ?? 0) +
(line?.supplierTaxAmount ?? 0)
);
}
export function getTotal(
lines: Database["public"]["Views"]["purchaseOrderLines"]["Row"][]
) {
return lines.reduce((total, line) => total + getLineTotal(line), 0);
}
export function getPurchaseOrderDisplayId(
purchaseOrder?: {
purchaseOrderId?: string | null;
revisionId?: number | null;
} | null
) {
return withRevisionSuffix(
purchaseOrder?.purchaseOrderId,
purchaseOrder?.revisionId
);
}