import {
  type CommonReservedFields,
  type NoReservedFields,
  defaultGqlPermission,
  defaultPermission,
} from "@tailor-platform/erp-kit/core";
import { db, type TailorAnyDBField } from "@tailor-platform/sdk";

const builtins = {
  // Stable, unique key used by WorkRule/CompanyHoliday binding — referenced by id (calendarId),
  // this key is the human-facing handle (e.g. "JP", "US-CA"); immutable once referenced.
  key: db
    .string()
    .unique()
    .description("Stable, unique calendar key; never changes after creation"),
  // Human-facing label for the calendar (e.g. "Japan National", "US Federal").
  name: db.string().description("Display name of the holiday calendar"),
};

type ReservedFields = keyof typeof builtins | CommonReservedFields;

export interface CreateHolidayCalendarTypeParams<F extends Record<string, TailorAnyDBField>> {
  fields?: NoReservedFields<F, ReservedFields>;
}

export function createHolidayCalendarType<const F extends Record<string, TailorAnyDBField>>(
  params: CreateHolidayCalendarTypeParams<F>,
) {
  return db
    .table("HolidayCalendar", {
      ...builtins,
      ...((params.fields ?? {}) as F),
      ...db.fields.timestamps(),
    })
    .permission(defaultPermission)
    .gqlPermission(defaultGqlPermission);
}

export const holidayCalendar = createHolidayCalendarType({});