import { useState } from "react";
import { useClient } from "urql";
import { graphql, type ResultOf, type VariablesOf } from "@/graphql";
import { useToast } from "@/hooks/use-toast";
import { fetchAllPages } from "@/lib/fetch-all-pages";
import { toDateInputValue } from "@/lib/format-date";
import { csvTimestamp, downloadCsv, toCsv, type CsvColumn } from "@/lib/to-csv";

/** CSV export for the Items dashboard (issue #605). */
const ItemsCsvQuery = graphql(`
  query ItemsCsv($first: Int, $after: String, $order: [ItemOrderInput], $query: ItemQueryInput) {
    items(first: $first, after: $after, order: $order, query: $query) {
      pageInfo {
        hasNextPage
        endCursor
      }
      edges {
        node {
          sku
          name
          status
          createdAt
          unit {
            name
          }
        }
      }
    }
  }
`);

type CsvVariables = VariablesOf<typeof ItemsCsvQuery>;
type CsvResult = ResultOf<typeof ItemsCsvQuery>;
type ItemCsvRow = NonNullable<NonNullable<CsvResult["items"]>["edges"]>[number]["node"];

const columns: CsvColumn<ItemCsvRow>[] = [
  { header: "SKU", value: (r) => r.sku },
  { header: "Name", value: (r) => r.name },
  { header: "Unit", value: (r) => r.unit?.name },
  { header: "Status", value: (r) => r.status },
  { header: "Created Date", value: (r) => toDateInputValue(r.createdAt) },
];

export function useExportItemsCsv() {
  const client = useClient();
  const toast = useToast();
  const [isExporting, setIsExporting] = useState(false);

  async function exportCsv(order: CsvVariables["order"], query: CsvVariables["query"]) {
    if (isExporting) return;
    setIsExporting(true);
    try {
      const rows = await fetchAllPages(client, ItemsCsvQuery, { order, query }, (d) => d.items);
      if (rows.length === 0) {
        toast.error("No items to export");
        return;
      }
      downloadCsv(toCsv(rows, columns), `items-${csvTimestamp()}.csv`);
      toast.success(`${rows.length.toLocaleString()} rows exported`);
    } catch (err) {
      console.error("CSV export failed:", err);
      toast.error("Failed to export CSV");
    } finally {
      setIsExporting(false);
    }
  }

  return { exportCsv, isExporting };
}