import {
  createGetDB,
  type Generated,
  type Timestamp,
  type ObjectColumnType,
  type ArrayColumnType,
  type NamespaceDB,
  type NamespaceInsertable,
  type NamespaceSelectable,
  type NamespaceTable,
  type NamespaceTableName,
  type NamespaceTransaction,
  type NamespaceUpdateable,
} from "@tailor-platform/sdk/kysely";

export interface Namespace {
  "main-db": {
    CalculatedTimeBlock: {
      id: Generated<string>;
      assignmentId: string;
      workDate: Timestamp;
      category: string;
      startAt: Timestamp;
      endAt: Timestamp;
      minutes: number;
      timeEntryCodeKey: string;
      payCodeKey: string;
      workRuleId: string;
      calculationTagKeys: string[];
      sourceReportedBlockIds: string[];
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    CompanyHoliday: {
      id: Generated<string>;
      calendarId: string;
      holidayDate: Timestamp;
      holidayKind: "STATUTORY" | "PRESCRIBED";
      name: string;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    EligibilityRule: {
      id: Generated<string>;
      targetType: "WORKER" | "POSITION" | "JOB_PROFILE" | "EMPLOYMENT_TYPE" | "WORK_REGIME";
      targetId: string;
      grantType: "WORK_RULE";
      workRuleId: string | null;
      effectiveStart: Timestamp;
      effectiveEnd: Timestamp | null;
      versionOf: string;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    HolidayCalendar: {
      id: Generated<string>;
      key: string;
      name: string;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    ReportedTimeBlock: {
      id: Generated<string>;
      assignmentId: string;
      workDate: Timestamp;
      blockType: "WORK" | "BREAK" | "STEP_OUT";
      sourceKind: "PUNCH_DERIVED" | "MANUAL" | "IMPORT";
      startAt: Timestamp;
      endAt: Timestamp;
      correctionReason: string | null;
      supersededByBlockId: string | null;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    TimeClockEvent: {
      id: Generated<string>;
      assignmentId: string;
      eventType: "CLOCK_IN" | "CLOCK_OUT" | "BREAK_START" | "BREAK_END" | "STEP_OUT" | "STEP_IN";
      occurredAt: Timestamp;
      source: string;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    TimeClockEventVoid: {
      id: Generated<string>;
      targetEventId: string;
      action: "VOID" | "UNVOID";
      sequence: number;
      actorId: string;
      occurredAt: Timestamp;
      reasonCode: "DUPLICATE" | "WRONG_PERSON" | "DEVICE_ERROR" | "MISTAKE" | "OTHER";
      reasonNote: string;
      authority: "SELF" | "MANAGER" | "ADMIN";
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    TimeCorrectionLog: {
      id: Generated<string>;
      timecardId: string;
      targetReportedBlockId: string | null;
      field: string;
      previousValue: string;
      newValue: string;
      reason: string;
      correctedBy: string;
      correctedAt: Timestamp;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    TimeEntryCode: {
      id: Generated<string>;
      key: string;
      category: string;
      displayName: string;
      payMapKey: string;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    Timecard: {
      id: Generated<string>;
      assignmentId: string;
      periodStart: Timestamp;
      periodEnd: Timestamp;
      status: "OPEN" | "SUBMITTED" | "APPROVED" | "LOCKED";
      categoryTotals: {
        category: string;
        minutes: number;
      }[];
      submittedAt: Timestamp | null;
      approvedAt: Timestamp | null;
      approvedBy: string | null;
      lockedAt: Timestamp | null;
      lockedBy: string | null;
      historicalCorrection: boolean;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    WorkRule: {
      id: Generated<string>;
      displayName: string;
      holidayCalendarId: string | null;
      clockInRoundingUnitMinutes: number;
      clockInRoundingDirection: "UP" | "DOWN" | "NEAREST";
      clockOutRoundingUnitMinutes: number;
      clockOutRoundingDirection: "UP" | "DOWN" | "NEAREST";
      breakRoundingUnitMinutes: number;
      breakRoundingDirection: "UP" | "DOWN" | "NEAREST";
      breakDeductionMinutes: number;
      dailyOvertimeThresholdMinutes: number;
      nightWindowStart: number;
      nightWindowEnd: number;
      premiumRatePercent: ArrayColumnType<ObjectColumnType<{
        category: string;
        key?: string | null;
      }>>;
      effectiveStart: Timestamp;
      effectiveEnd: Timestamp | null;
      versionOf: string;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    WorkRuleAssignment: {
      id: Generated<string>;
      targetType: "WORKER" | "POSITION" | "JOB_PROFILE" | "EMPLOYMENT_TYPE" | "WORK_REGIME";
      targetId: string;
      workRuleId: string;
      effectiveStart: Timestamp;
      effectiveEnd: Timestamp | null;
      versionOf: string;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }
  }
}

export const getDB = createGetDB<Namespace>();

export type DB<N extends keyof Namespace = keyof Namespace> = NamespaceDB<Namespace, N>;

export type Transaction<K extends keyof Namespace | DB = keyof Namespace> =
  NamespaceTransaction<Namespace, K>;

type TableName = NamespaceTableName<Namespace>;
export type Table<T extends TableName> = NamespaceTable<Namespace, T>;

export type Insertable<T extends TableName> = NamespaceInsertable<Namespace, T>;
export type Selectable<T extends TableName> = NamespaceSelectable<Namespace, T>;
export type Updateable<T extends TableName> = NamespaceUpdateable<Namespace, T>;