mirror of
https://github.com/multica-ai/multica.git
synced 2026-07-23 10:08:38 +02:00
* docs(timezone): add scheduling/viewing timezone architecture RFC * feat(db): replace daily rollups with task_usage_hourly, add user.timezone Migrations 100-104: add "user".timezone (Viewing tz), build the UTC hourly task_usage_hourly rollup with its pipeline, drop the legacy task_usage_daily / task_usage_dashboard_daily pipelines, and drop the agent_runtime.timezone column. Report queries now slice day boundaries at read time by the caller-supplied @tz instead of materialising in a fixed tz. Regenerate sqlc. * feat(server): add task_usage_hourly backfill command Replace the two legacy backfill commands (daily / dashboard_daily) with a single backfill_task_usage_hourly that loads historical task_usage into the new UTC hourly rollup, sliced per workspace. * refactor(server): resolve viewing timezone in report handlers Report handlers resolve the Viewing tz per request (?tz query param, then user.timezone, then UTC) and pass it to the hourly-rollup queries. Drop the UseDailyRollup feature flags and the old raw-scan/daily-rollup dual paths, remove the /api/usage endpoints, and stop the daemon from reporting and the runtime handler from accepting host timezone. * refactor(core): switch report queries to viewing timezone API client and dashboard/runtime queries send ?tz with each report request, the user schema/types carry the new timezone field, and the runtime timezone field/mutation is removed. * feat(views): add viewing timezone preference and UI Add the useViewingTimezone hook and a Timezone setting in Preferences; report charts and the dashboard week boundary follow the viewer tz. Remove the runtime detail timezone editor and its locale strings. * fix(test): update fixtures and stabilize tests for timezone refactor The timezone architecture refactor changed several types without updating dependent test code: - RuntimeDevice no longer has a timezone field — drop it from the create-agent-dialog runtime fixture. - User now requires a timezone field — add it to the apps/web mockUser fixture. - The PreferencesTab timezone tests asserted on the async save handler (PATCH then store update) with a bare expect, racing the mutation's settle callback, and timed out querying the Select's ~600-option IANA list on a loaded CI runner. Wrap the assertions in waitFor and extend the timeout for those three tests. * docs(timezone): document self-host migration order and trigger invariant Add a SELF-HOST UPGRADE ORDER runbook to the backfill command's package comment: applying migrations 100-104 in a single migrate-up drops the legacy daily rollups before the hourly backfill runs, leaving dashboards empty until cron catches up. Add an INVARIANT comment on trg_atq_dirty_hourly noting that agent_id must be added to the trigger's OF list if it ever becomes mutable, otherwise dirty buckets for the old agent_id are silently missed. * style(runtimes): drop trailing blank line in runtime-detail
121 lines
3.1 KiB
TypeScript
121 lines
3.1 KiB
TypeScript
"use client";
|
|
|
|
import {
|
|
Select,
|
|
SelectContent,
|
|
SelectItem,
|
|
SelectTrigger,
|
|
SelectValue,
|
|
} from "@multica/ui/components/ui/select";
|
|
|
|
// Curated fallback list used when the runtime lacks `Intl.supportedValuesOf`.
|
|
// Exported so every timezone picker draws from one source instead of
|
|
// drifting copies.
|
|
export const COMMON_TIMEZONES = [
|
|
"UTC",
|
|
"America/Los_Angeles",
|
|
"America/Denver",
|
|
"America/Chicago",
|
|
"America/New_York",
|
|
"America/Sao_Paulo",
|
|
"Europe/London",
|
|
"Europe/Berlin",
|
|
"Europe/Paris",
|
|
"Europe/Moscow",
|
|
"Africa/Cairo",
|
|
"Asia/Dubai",
|
|
"Asia/Kolkata",
|
|
"Asia/Bangkok",
|
|
"Asia/Shanghai",
|
|
"Asia/Singapore",
|
|
"Asia/Tokyo",
|
|
"Australia/Sydney",
|
|
"Pacific/Auckland",
|
|
];
|
|
|
|
let cachedBrowserTZ: string | null = null;
|
|
export function browserTimezone(): string {
|
|
if (cachedBrowserTZ !== null) return cachedBrowserTZ;
|
|
try {
|
|
cachedBrowserTZ = Intl.DateTimeFormat().resolvedOptions().timeZone || "UTC";
|
|
} catch {
|
|
cachedBrowserTZ = "UTC";
|
|
}
|
|
return cachedBrowserTZ;
|
|
}
|
|
|
|
// Clears the module-level browserTimezone() cache. Browser code never
|
|
// needs this — the tz is stable for a session — but the cache survives
|
|
// across Vitest files in the same worker, so any test that stubs
|
|
// `Intl.DateTimeFormat` (directly or via a fake timezone) MUST call this
|
|
// in `beforeEach`, otherwise a value cached by an earlier suite leaks in.
|
|
// Tests that mock the whole `./timezone-select` module are unaffected.
|
|
export function resetBrowserTimezoneCache(): void {
|
|
cachedBrowserTZ = null;
|
|
}
|
|
|
|
type IntlWithSupportedValues = typeof Intl & {
|
|
supportedValuesOf?: (key: "timeZone") => string[];
|
|
};
|
|
|
|
function supportedTimezones(): string[] {
|
|
try {
|
|
const supported = (Intl as IntlWithSupportedValues).supportedValuesOf?.(
|
|
"timeZone",
|
|
);
|
|
return supported && supported.length > 0 ? supported : COMMON_TIMEZONES;
|
|
} catch {
|
|
return COMMON_TIMEZONES;
|
|
}
|
|
}
|
|
|
|
export function timezoneOptions(current: string): string[] {
|
|
const browser = browserTimezone();
|
|
return Array.from(
|
|
new Set([current, browser, ...COMMON_TIMEZONES, ...supportedTimezones()]),
|
|
).filter(Boolean);
|
|
}
|
|
|
|
export function TimezoneSelect({
|
|
value,
|
|
onValueChange,
|
|
browserSuffix,
|
|
disabled,
|
|
triggerClassName,
|
|
}: {
|
|
value: string;
|
|
onValueChange: (next: string) => void;
|
|
browserSuffix: string;
|
|
disabled?: boolean;
|
|
triggerClassName?: string;
|
|
}) {
|
|
const browser = browserTimezone();
|
|
const options = timezoneOptions(value);
|
|
const render = (tz: string) =>
|
|
tz === browser ? `${tz}${browserSuffix}` : tz;
|
|
|
|
return (
|
|
<Select
|
|
value={value}
|
|
disabled={disabled}
|
|
onValueChange={(next) => {
|
|
if (next) onValueChange(next);
|
|
}}
|
|
>
|
|
<SelectTrigger
|
|
size="sm"
|
|
className={triggerClassName ?? "w-full rounded-md font-mono text-xs"}
|
|
>
|
|
<SelectValue>{render(value)}</SelectValue>
|
|
</SelectTrigger>
|
|
<SelectContent align="start" className="max-h-72">
|
|
{options.map((tz) => (
|
|
<SelectItem key={tz} value={tz} className="font-mono text-xs">
|
|
{render(tz)}
|
|
</SelectItem>
|
|
))}
|
|
</SelectContent>
|
|
</Select>
|
|
);
|
|
}
|