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 { Timezone as TimezoneBase } from "@carbon/form";
import { useLoaderQuery } from "@carbon/query";
import type { TimezoneGroup } from "@carbon/utils";
import type { ComponentProps } from "react";
import { useMemo } from "react";
import type { getTimezoneNames } from "~/modules/shared/shared.service";
import { path } from "~/utils/path";
/**
* Timezone picker fed by the DATABASE's tzdata (pg_timezone_names via
* api/timezones) — the authoritative list for what AT TIME ZONE resolves.
* While loading (or if the fetch fails) the base component falls back to the
* runtime's Intl list.
*/
const Timezone = (props: ComponentProps<typeof TimezoneBase>) => {
const fetcher = useLoaderQuery<Awaited<ReturnType<typeof getTimezoneNames>>>(
path.to.api.timezones
);
const options = useMemo<TimezoneGroup[] | undefined>(() => {
const zones = fetcher.data?.data;
if (!zones?.length) return undefined;
const groups = new Map<string, TimezoneGroup["options"]>();
for (const { name, utcOffset } of zones) {
const [region = "Other", ...rest] = name.split("/");
const city = rest.join("/").replace(/_/g, " ");
const group = rest.length === 0 ? "Other" : region;
// pg interval text: "05:30:00" / "-06:00:00" / "00:00:00" → "±HH:MM"
// (relative-to-UTC is implied; no "UTC" prefix noise in the label)
const offset = utcOffset.startsWith("-")
? `-${utcOffset.slice(1, 6)}`
: `+${utcOffset.slice(0, 5)}`;
const label = `${city || name} (${offset})`;
const list = groups.get(group) ?? [];
list.push({ label, value: name });
groups.set(group, list);
}
const regionOrder = [
"America",
"Europe",
"Asia",
"Africa",
"Australia",
"Pacific",
"Atlantic",
"Indian",
"Antarctica",
"Arctic",
"Other"
];
return [...groups.entries()]
.sort(
([a], [b]) =>
(regionOrder.indexOf(a) + 1 || 99) -
(regionOrder.indexOf(b) + 1 || 99)
)
.map(([label, list]) => ({
label,
options: list.sort((a, b) => a.label.localeCompare(b.label))
}));
}, [fetcher.data]);
return <TimezoneBase {...props} options={options} />;
};
export default Timezone;