import { vendorInvestigationsView } from "@/db/schema/vendors"

/**
 * Drizzle will infer `contacts` and `possibleItems` as a JSON string or `unknown`.
 * We override those with arrays that have the structure we built in the view.
 */
export type ContactItem = {
  id: number
  contactName: string
  contactEmail: string
  contactPhone: string | null
  contactPosition: string | null
  isPrimary: boolean
  createdAt: Date
  updatedAt: Date
}

export type PossibleItem = {
  id: number
  vendorId: number
  itemCode: string
  itemName: string
  createdAt: Date
  updatedAt: Date
}

// Drizzle-based type for the rest of the columns
type VendorInvestigationsViewRaw = typeof vendorInvestigationsView.$inferSelect

/**
 * Combine the Drizzle-inferred type with typed arrays
 */
export interface VendorInvestigationsViewWithContacts
  extends Omit<
    VendorInvestigationsViewRaw,
    "contacts" | "possibleItems"
  > {
  contacts: ContactItem[]
  possibleItems: PossibleItem[]
}

export interface VendorInvestigationsColumnConfig {
    id: keyof VendorInvestigationsViewWithContacts
    label: string
    group?: string
    excelHeader?: string
    type?: string
  }
  
  // Example column config for vendorInvestigationsView
  export const vendorInvestigationsColumnsConfig: VendorInvestigationsColumnConfig[] = [
    {
      id: "investigationId",
      label: "Investigation ID",
      excelHeader: "Investigation ID",
      group: "Investigation",
    },
    {
      id: "investigationStatus",
      label: "Status",
      excelHeader: "Status",
      group: "Investigation",
    },
    {
      id: "scheduledStartAt",
      label: "Scheduled Start",
      excelHeader: "Scheduled Start",
      group: "Investigation",
    },
    {
      id: "scheduledEndAt",
      label: "Scheduled End",
      excelHeader: "Scheduled End",
      group: "Investigation",
    },
    {
      id: "completedAt",
      label: "Completed At",
      excelHeader: "Completed At",
      group: "Investigation",
    },
    {
      id: "investigationNotes",
      label: "Notes",
      excelHeader: "Investigation Notes",
      group: "Investigation",
    },
    {
      id: "vendorName",
      label: "Vendor Name",
      excelHeader: "Vendor Name",
      group: "Vendor Info",
    },
    {
      id: "vendorCode",
      label: "Vendor Code",
      excelHeader: "Vendor Code",
      group: "Vendor Info",
    },
    {
      id: "vendorEmail",
      label: "Email",
      excelHeader: "Email",
      group: "Vendor Info",
    },
    {
      id: "vendorPhone",
      label: "Phone",
      excelHeader: "Phone",
      group: "Vendor Info",
    },
    // ... add more as needed ...
    {
      id: "investigationCreatedAt",
      label: "Created At",
      excelHeader: "Created At",
      // group: "Metadata",
    },
    {
      id: "investigationUpdatedAt",
      label: "Updated At",
      excelHeader: "Updated At",
      // group: "Metadata",
    },
  ]