Skip to content

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.

3.0 KB
Raw Blame
// 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.

/**
 * Dataset dates are day-offsets from the moment the dataset is applied, never
 * absolute strings — a template applied next year must not show last year's
 * orders. The anchor is today in the COMPANY's timezone (`Ctx.anchor`).
 *
 * Offsets were derived from the original literals against a reference date of
 * 2026-08-13, so every interval between two dates is preserved exactly.
 */

import {
  type CalendarDate,
  endOfMonth,
  startOfMonth,
  startOfWeek
} from "@internationalized/date";
import type { DayOffset } from "./types.ts";

/** "YYYY-MM-DD" for a DATE column. */
export function resolveDate(anchor: CalendarDate, offset: DayOffset): string {
  return anchor.add({ days: offset }).toString();
}

/**
 * Full ISO instant for a TIMESTAMPTZ column. `timeOfDay` is "HH:MM:SS" and is
 * treated as UTC, matching the `...Z` literals the seed used before.
 */
export function resolveTimestamp(
  anchor: CalendarDate,
  offset: DayOffset,
  timeOfDay: string
): string {
  return `${resolveDate(anchor, offset)}T${timeOfDay}Z`;
}

/** Last day of the month before the anchor's, as "YYYY-MM-DD". */
export function previousMonthEnd(anchor: CalendarDate): string {
  return endOfMonth(anchor.subtract({ months: 1 })).toString();
}

// Seeded accounting periods: trailing months ending with the anchor's. Close is
// sequential, so the oldest are Closed, the next Locked, the rest Open.
export const SEEDED_PERIOD_MONTHS = 12;
export const CLOSED_PERIOD_MONTHS_BACK = [11, 10] as const;
export const LOCKED_PERIOD_MONTHS_BACK = 9;
/**
 * Offsets ≥ this land in month anchor−9 or later, never a Closed period (whose
 * journals the period-open trigger rejects). Nine shortest months = 273 days.
 */
export const NOT_CLOSED_MIN_OFFSET = -273;
/** Offsets ≥ this land in an Open period (month anchor−8 or later; 8 shortest months = 242 days). */
export const OPEN_PERIOD_MIN_OFFSET = -242;

/** `monthsBack` 0 = the anchor's own month. */
export function monthBack(
  anchor: CalendarDate,
  monthsBack: number
): { start: CalendarDate; end: CalendarDate } {
  const month = anchor.subtract({ months: monthsBack });
  return { start: startOfMonth(month), end: endOfMonth(month) };
}

/**
 * `count` consecutive Sunday-start weeks beginning with the anchor's own week.
 * Mirrors getOrCreatePeriods' startOfWeek(today, "en-US") so the seeded periods
 * are the ones the projections loader looks up rather than duplicates.
 */
export function weekRangesFrom(
  anchor: CalendarDate,
  count: number
): { startDate: string; endDate: string }[] {
  const first = startOfWeek(anchor, "en-US");
  return Array.from({ length: count }, (_, week) => {
    const start = first.add({ weeks: week });
    return {
      startDate: start.toString(),
      endDate: start.add({ days: 6 }).toString()
    };
  });
}