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

export interface Namespace {
  "main-db": {
    AcquisitionCostAdjustment: {
      id: Generated<string>;
      sourceType: "ACCOUNT_PAYABLE_DOCUMENT" | "PURCHASE_ORDER_REVISION" | "INVENTORY_LEDGER";
      sourceId: string;
      sourceLineId: string | null;
      purchaseOrderId: string;
      purchaseOrderLineId: string;
      amount: string;
      kind: "INVOICE_PRICE" | "ORDER_PRICE" | "REDISTRIBUTION";
      effectiveDate: Timestamp;
      createdAt: Generated<Timestamp>;
    }

    AcquisitionCostAdjustmentAllocation: {
      id: Generated<string>;
      acquisitionCostAdjustmentId: string;
      costLayerId: string;
      amount: string;
      varianceKind: "INVOICE_PRICE" | "ORDER_PRICE";
      createdAt: Generated<Timestamp>;
    }

    AverageCost: {
      id: Generated<string>;
      itemId: string;
      companyId: string;
      sequence: number;
      eventType: "RECEIPT" | "ISSUE" | "COST_ADJUSTMENT";
      quantityBefore: string;
      unitCostBefore: string;
      quantity: string;
      unitCost: string | null;
      quantityAfter: string;
      unitCostAfter: string;
      createdAt: Generated<Timestamp>;
    }

    CostLayer: {
      id: Generated<string>;
      itemId: string;
      companyId: string;
      ledgerEntryId: string;
      effectiveDate: Timestamp;
      quantity: string;
      remainingQuantity: string;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    CostLayerConsumption: {
      id: Generated<string>;
      costLayerId: string;
      ledgerEntryId: string;
      quantity: string;
      createdAt: Generated<Timestamp>;
    }

    FifoCost: {
      id: Generated<string>;
      costLayerId: string;
      version: number;
      unitCost: string;
      createdAt: Generated<Timestamp>;
    }

    InventoryLedger: {
      id: Generated<string>;
      sourceType: "INBOUND_SHIPMENT" | "OUTBOUND_SHIPMENT" | "TRANSFER_ORDER" | "STOCK_ADJUSTMENT";
      sourceId: string;
      sourceLineId: string | null;
      orderDocumentType: "PURCHASE_ORDER" | "SALES_ORDER" | "TRANSFER_ORDER" | null;
      orderDocumentId: string | null;
      orderDocumentLineId: string | null;
      direction: "IN" | "OUT";
      action: "QUANTITY_CHANGE" | "TRANSFER" | "STOCK_TYPE_CHANGE";
      itemId: string;
      storageLocationId: string;
      stockType: "AVAILABLE" | "BLOCKED" | "IN_TRANSIT";
      quantity: string;
      executedAt: Timestamp;
      effectiveDate: Timestamp;
      createdAt: Generated<Timestamp>;
    }

    InventorySupplyPlan: {
      id: Generated<string>;
      sourceType: "PURCHASE_ORDER" | "TRANSFER_ORDER";
      sourceId: string;
      sourceLineId: string;
      itemId: string;
      siteId: string;
      expectedQuantity: string;
      receivedQuantity: string;
      status: "OPEN" | "CLOSED";
      expectedDate: Timestamp;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    ItemValuation: {
      id: Generated<string>;
      itemId: string;
      companyId: string;
      valuationPolicyId: string;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    StandardCost: {
      id: Generated<string>;
      itemId: string;
      version: number;
      unitCost: string;
      createdAt: Generated<Timestamp>;
    }

    StockAdjustment: {
      id: Generated<string>;
      adjustmentType: "CORRECTION" | "SCRAP" | "BLOCK" | "UNBLOCK";
      status: "DRAFT" | "SUBMITTED" | "CANCELLED" | "CONFIRMED" | "REJECTED";
      reasonCode: string;
      adjustmentDate: Timestamp;
      rejectionReason: string | null;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    StockAdjustmentLine: {
      id: Generated<string>;
      stockAdjustmentId: string;
      itemId: string;
      storageLocationId: string;
      quantity: string;
      adjustmentDirection: "INCREASE" | "DECREASE" | null;
      fromStockCategory: "AVAILABLE" | "BLOCKED" | null;
      unitCost: string | null;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    StockLevel: {
      id: Generated<string>;
      itemId: string;
      storageLocationId: string;
      stockType: "AVAILABLE" | "BLOCKED" | "IN_TRANSIT";
      quantity: string;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    StockReservation: {
      id: Generated<string>;
      sourceType: "SALES_ORDER" | "TRANSFER_ORDER";
      sourceId: string;
      sourceLineId: string;
      itemId: string;
      siteId: string;
      storageLocationId: string | null;
      reservedQuantity: string;
      consumedQuantity: string;
      status: "OPEN" | "CLOSED";
      requiredDate: Timestamp;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    StorageLocation: {
      id: Generated<string>;
      name: string;
      code: string | null;
      siteId: string;
      storageCondition: string | null;
      capacity: string | null;
      status: "ACTIVE" | "INACTIVE";
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    TransferOrder: {
      id: Generated<string>;
      sourceSiteId: string;
      destinationSiteId: string;
      plannedShipmentDate: Timestamp;
      expectedReceiptDate: Timestamp;
      status: "DRAFT" | "OPEN" | "CLOSED";
      closedAt: Timestamp | null;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    TransferOrderLine: {
      id: Generated<string>;
      transferOrderId: string;
      itemId: string;
      unitId: string;
      orderedQuantity: string;
      shippedQuantity: string;
      receivedQuantity: string;
      createdAt: Generated<Timestamp>;
      updatedAt: Generated<Timestamp>;
    }

    ValuationPolicy: {
      id: Generated<string>;
      name: string;
      companyId: string;
      costingMethod: "STANDARD" | "FIFO" | "AVERAGE";
      defaultCompanyId: string | null;
      inventoryAccountId: string;
      accrualAccountId: string;
      invoicePriceVarianceAccountId: string;
      cogsAccountId: string;
      ppvAccountId: string;
      adjustmentAccountId: string;
      standardCostAdjustmentAccountId: string;
      consumedPriceVarianceAccountId: 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>;