"use client"

import { AppSidebar } from "@/components/app-sidebar"
import { SiteHeader } from "@/components/site-header"
import { SidebarInset, SidebarProvider } from "@/components/ui/sidebar"
import { useEffect, useState } from "react"
import Link from "next/link"
import { useTranslation } from "react-i18next"
import { DataTableSimple } from "@/components/data-table-simple"
import { ColumnDef, VisibilityState } from "@tanstack/react-table"
import { IconSearch } from "@tabler/icons-react"
import { Input } from "@/components/ui/input"
import { useRouter } from "next/navigation"
import { Button } from "@/components/ui/button"
import { IconEye } from "@tabler/icons-react"
import {
  Select,
  SelectContent,
  SelectItem,
  SelectTrigger,
  SelectValue,
} from "@/components/ui/select"
import {
  DropdownMenu,
  DropdownMenuCheckboxItem,
  DropdownMenuContent,
  DropdownMenuTrigger,
} from "@/components/ui/dropdown-menu"

type Report = {
  id: number;
  "Contract number": string;
  "Company": string;
  "Seller Company": string;
  "Buyer Company": string;
  "Goods": string;
  "Basis": string;
  "Basis_1": string;
  "Price per mt": string;
  "Currency": string;
  "Payment Terms": string;
  "Invoice no": string;
  "Invoice date": string;
  "Invoice due date": string;
  " Invoice Quantity ": string;
  " Invoice Price ": string;
  " Invoice Total Value ": string;
  " Invoice Currency ": string;
  " Cashed in value "?: string;
  " Open amount ": string;
  " Invoice saved ": string;
  " Delay days ": string;
  " QTTY CONTRACT ": string;
  "MARGIN": string;
  " QTTY UNDER MARGIN ": string;
  "Details"?: string;
  "Cashed in date"?: string;
  "Mentions"?: string;
}

export default function ExecutionReportPage() {
  const [reports, setReports] = useState<Report[]>([])
  const [columnVisibility, setColumnVisibility] = useState<VisibilityState>({})
  const [search, setSearch] = useState("")
  const [selectedCompany, setSelectedCompany] = useState<string>("all")
  const { t } = useTranslation()

  useEffect(() => {
    console.log("Fetching data...");
    fetch("/execution-operations/api")
      .then(res => {
        console.log("Response status:", res.status);
        return res.json();
      })
      .then(data => {
        console.log("Received data:", data);
        setReports(data.invoices);
      })
      .catch(error => {
        console.error("Error fetching data:", error);
      });
  }, [])

  // Get unique companies for filter
  const companies = [...new Set(reports.map(c => c["Company"] || "").filter(Boolean))]
  console.log("Companies:", companies);

  // Filter reports based on search and filters
  const filteredReports = reports.filter(report => {
    const matchesSearch = 
      (report["Contract number"]?.toLowerCase() || "").includes(search.toLowerCase()) ||
      (report["Invoice no"]?.toLowerCase() || "").includes(search.toLowerCase()) ||
      (report["Company"]?.toLowerCase() || "").includes(search.toLowerCase())
    
    const matchesCompany = selectedCompany === "all" || report["Company"] === selectedCompany

    return matchesSearch && matchesCompany
  })
  console.log("Filtered reports:", filteredReports);

  const columns: ColumnDef<Report>[] = [
    {
      accessorKey: "Contract number",
      header: "Contract Number",
    },
    {
      id: "openAmount",
      header: "Open Amount",
      cell: ({ row }) => {
        const cashed = parseFloat(row.original[" Cashed in value "]?.replace(/,/g, "") || "0");
        const total = parseFloat(row.original[" Invoice Total Value "]?.replace(/,/g, "") || "0");
        return (total - cashed).toLocaleString(undefined, { maximumFractionDigits: 2 });
      },
    },
    {
      id: "delayDays",
      header: "Delay Days",
      cell: ({ row }) => {
        const due = row.original["Invoice due date"] ? new Date(row.original["Invoice due date"]) : null;
        const cashed = row.original["Cashed in date"] ? new Date(row.original["Cashed in date"]) : null;
        if (due && cashed) {
          return Math.max(0, Math.ceil((cashed.getTime() - due.getTime()) / (1000 * 60 * 60 * 24))).toString();
        }
        return "-";
      },
    },
    {
      id: "actions",
      header: "View",
      cell: ({ row }) => (
        <div className="flex">
          <Link href={`/execution-operations/executionreport/${row.original.id}`}>
            <Button size="sm" variant="outline"><IconEye className="h-4 w-4" />{t("products.view")}</Button>
          </Link>
        </div>
      ),
    },
  ]

  return (
    <SidebarProvider
      style={{
        "--sidebar-width": "calc(var(--spacing) * 72)",
        "--header-height": "calc(var(--spacing) * 12)",
      } as React.CSSProperties}
    >
      <AppSidebar variant="inset" />
      <SidebarInset>
        <SiteHeader />
        <div className="flex flex-1 flex-col">
          <div className="@container/main flex flex-1 flex-col gap-2">
            <div className="flex flex-col gap-4 py-4 md:gap-6 md:py-6">
              <div className="flex justify-between items-center px-4 lg:px-6">
                <h2 className="text-2xl font-bold">{t("executionReport.title")}</h2>
                
                <div className="flex items-center gap-2">
                  <DropdownMenu>
                    <DropdownMenuTrigger asChild>
                      <Button variant="outline">
                        Columns
                      </Button>
                    </DropdownMenuTrigger>
                    <DropdownMenuContent align="end" className="w-[150px]">
                      {columns.map((column) => {
                        const columnId = typeof column.id === 'string' ? column.id : 
                          'accessorKey' in column ? column.accessorKey as string : null;
                        if (!columnId) return null;
                        return (
                          <DropdownMenuCheckboxItem
                            key={columnId}
                            checked={columnVisibility[columnId]}
                            onCheckedChange={(value) =>
                              setColumnVisibility((prev) => ({
                                ...prev,
                                [columnId]: value,
                              }))
                            }
                          >
                            {column.header?.toString()}
                          </DropdownMenuCheckboxItem>
                        );
                      })}
                    </DropdownMenuContent>
                  </DropdownMenu>
                  <Link href="/execution-operations/executionreport/new">
                    <Button>{t("executionReport.newExecutionReport")}</Button>
                  </Link>
                </div>
              </div>
              <div className="px-4 lg:px-6 flex gap-4 items-center">
                <div className="flex-1 relative">
                  <IconSearch className="absolute left-2 top-2.5 h-4 w-4 text-muted-foreground" />
                  <Input
                    placeholder="Search reports..."
                    value={search}
                    onChange={(e) => setSearch(e.target.value)}
                    className="pl-8"
                  />
                </div>
                <Select value={selectedCompany} onValueChange={setSelectedCompany}>
                  <SelectTrigger className="w-[180px]">
                    <SelectValue placeholder="Select company" />
                  </SelectTrigger>
                  <SelectContent>
                    <SelectItem value="all">All Companies</SelectItem>
                    {companies.map(company => (
                      <SelectItem key={company} value={company}>
                        {company}
                      </SelectItem>
                    ))}
                  </SelectContent>
                </Select>
              </div>
              <div className="px-4 lg:px-6">
                {reports.length === 0 ? (
                  <div className="text-center py-4">Loading data...</div>
                ) : (
                  <DataTableSimple 
                    data={filteredReports} 
                    columns={columns}
                    columnVisibility={columnVisibility}
                    onColumnVisibilityChange={setColumnVisibility}
                  />
                )}
              </div>
            </div>
          </div>
        </div>
      </SidebarInset>
    </SidebarProvider>
  )
}