"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 { useTranslation } from "react-i18next"
import { DataTableContracts } from "@/components/data-table-contracts"
import { ColumnDef, VisibilityState } from "@tanstack/react-table"
import { Badge } from "@/components/ui/badge"
import { format } from "date-fns"
import Link from "next/link"
import { Button } from "@/components/ui/button"
import { IconSearch } from "@tabler/icons-react"
import { IconCircleCheckFilled, IconLoader, IconCircleMinus, IconEye } from "@tabler/icons-react"
import { Input } from "@/components/ui/input"
import { Combobox } from "@/components/combobox"

interface Contract {
  id: number;
  contractNumber: string;
  contractDate: string;
  brokerageCompany: string;
  status: string;
  contractType?: string;
  basicInfo?: {
    sellerCompany: string;
    buyerCompany: string;
    goodsCode: string;
    goods: string;
    cropYear: string;
    origin: string;
    goodsFullDescription: string;
  };
  productInfo?: {
    quantity: number;
    executedQuantity: number;
    remainingToBeExecuted: number;
  };
  financialInfo?: {
    pricePerMt: number;
    priceCurrency: string;
  };
  transportInfo?: {
    deliveryDateFrom: string;
    deliveryDateTo: string;
  };
  otherInfo?: {
    pic: string;
  };
}

export default function OpenContractsPage() {
  const [contracts, setContracts] = useState<Contract[]>([])
  const [columnVisibility, setColumnVisibility] = useState<VisibilityState>({})
  const [search, setSearch] = useState("")
  const [selectedCompany, setSelectedCompany] = useState<string>("all")

  const { t } = useTranslation()

  useEffect(() => {
    fetch("/contracts/api/contractsdata")
      .then(res => res.json())
      .then(setContracts)
  }, [])

  const companies = [...new Set(contracts.map(c => c.brokerageCompany))]

  // ... existing code ...
// Combine filtering logic
const filteredContracts = contracts.filter(contract => {
  const matchesSearch = 
    contract.contractNumber.toLowerCase().includes(search.toLowerCase()) ||
    contract.brokerageCompany.toLowerCase().includes(search.toLowerCase());
  
  const matchesCompany = selectedCompany === "all" || contract.brokerageCompany === selectedCompany;
  const isOpen = contract.status?.toLowerCase() === "open"; // Check for open status

  return matchesSearch && matchesCompany && isOpen; // Combine filters
});

const companyOptions = [
  { value: "all", label: "All Companies" },
  ...companies.map(company => ({ value: company, label: company }))
]

  // Columns definition (copied from contracts list)
  const columns: ColumnDef<Contract>[] = [
    {
      accessorKey: "contractNumber",
      header: t("contractlist.contractnumber"),
    },
    {
      accessorKey: "brokerageCompany",
      header: t("contractlist.company"),
    },
    {
      accessorKey: "status",
      header: t("contractlist.status"),
      cell: ({ row }) => (
        <Badge variant="outline" className="text-muted-foreground px-1.5">
          {row.original.status?.toLowerCase() === "open" ? (
            <IconCircleCheckFilled className="fill-green-500 dark:fill-green-400 mr-2" />
          ) : row.original.status?.toLowerCase() === "pending" ? (
            <IconLoader className="mr-2" />
          ) : (
            <IconCircleMinus className="fill-gray-950 dark:fill-gray-950 mr-2" />
          )}
          {row.original.status}
        </Badge>
      ),
    },
    {
      accessorKey: "contractType",
      header: t("contractlist.contracttype"),
    },
    {
      accessorKey: "basicInfo.goods",
      header: t("contractlist.goods"),
      cell: ({ row }) => row.original.basicInfo?.goods || "",
    },
    {
      accessorKey: "productInfo.quantity",
      header: t("contractlist.quantity"),
      cell: ({ row }) => row.original.productInfo ? `${row.original.productInfo.quantity.toLocaleString()} MT` : "",
    },
    {
      accessorKey: "financialInfo",
      header: t("contractlist.price"),
      cell: ({ row }) => row.original.financialInfo ? `${row.original.financialInfo.priceCurrency} ${row.original.financialInfo.pricePerMt.toLocaleString()}` : "",
    },
    {
      accessorKey: "otherInfo.pic",
      header: t("contractlist.personincharge"),
      cell: ({ row }) => row.original.otherInfo?.pic || "",
    },
    {
      accessorKey: "transportInfo.deliveryDateFrom",
      header: t("contractlist.startdate"),
      cell: ({ row }) => row.original.transportInfo?.deliveryDateFrom ? format(new Date(row.original.transportInfo.deliveryDateFrom), 'dd/MM/yyyy') : "",
    },
    {
      accessorKey: "transportInfo.deliveryDateTo",
      header: t("contractlist.enddate"),
      cell: ({ row }) => row.original.transportInfo?.deliveryDateTo ? format(new Date(row.original.transportInfo.deliveryDateTo), 'dd/MM/yyyy') : "",
    },
    {
      id: "actions",
      header: t("contractlist.action"),
      cell: ({ row }) => (
        <div className="flex">
          <Link href={`/contracts/${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 title={t("contractsReportsOpenContracts.title")} />
        <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">
              <h2 className="text-2xl font-bold px-4 lg:px-6">{t("contractsReportsOpenContracts.title")}</h2>
              <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 contracts..."
                    value={search}
                    onChange={(e) => setSearch(e.target.value)}
                    className="pl-8"
                  />
                </div>
                <Combobox
                  items={companyOptions}
                  value={selectedCompany}
                  onValueChange={setSelectedCompany}
                  placeholder="Select company"
                  emptyText="No companies found"
                />
              </div>
              <div className="px-4 lg:px-6">
                <DataTableContracts
                  data={filteredContracts}
                  columns={columns}
                  columnVisibility={columnVisibility}
                  onColumnVisibilityChange={setColumnVisibility}
                />
              </div>
            </div>
          </div>
        </div>
      </SidebarInset>
    </SidebarProvider>
  )
}