// lib/evaluation/table/evaluation-table.tsx - 최종 정리된 버전

"use client"

import * as React from "react"
import { useRouter, useSearchParams } from "next/navigation"
import { Button } from "@/components/ui/button"
import { PanelLeftClose, PanelLeftOpen, BarChart3, List, Info } from "lucide-react"
import { Card, CardContent, CardHeader, CardTitle } from "@/components/ui/card"
import { Badge } from "@/components/ui/badge"
import { Skeleton } from "@/components/ui/skeleton"
import { ToggleGroup, ToggleGroupItem } from "@/components/ui/toggle-group"
import {
  Tooltip,
  TooltipContent,
  TooltipProvider,
  TooltipTrigger,
} from "@/components/ui/tooltip"
import type {
  DataTableAdvancedFilterField,
  DataTableFilterField,
  DataTableRowAction,
} from "@/types/table"

import { useDataTable } from "@/hooks/use-data-table"
import { DataTable } from "@/components/data-table/data-table"
import { DataTableAdvancedToolbar } from "@/components/data-table/data-table-advanced-toolbar"
import { cn } from "@/lib/utils"
import { useTablePresets } from "@/components/data-table/use-table-presets"
import { TablePresetManager } from "@/components/data-table/data-table-preset"
import { PeriodicEvaluationFilterSheet } from "./evaluation-filter-sheet"
import { getPeriodicEvaluationsColumns } from "./evaluation-columns"
import { PeriodicEvaluationView, PeriodicEvaluationAggregatedView } from "@/db/schema"
import { 
  getPeriodicEvaluationsWithAggregation, 
  getPeriodicEvaluationsStats 
} from "../service"
import { PeriodicEvaluationsTableToolbarActions } from "./periodic-evaluations-toolbar-actions"
import { EvaluationDetailsDialog } from "./evaluation-details-dialog"
import { searchParamsEvaluationsCache } from "../validation"

interface PeriodicEvaluationsTableProps {
  promises: Promise<[Awaited<ReturnType<typeof getPeriodicEvaluationsWithAggregation>>]>
  evaluationYear: number
  initialViewMode?: "detailed" | "aggregated" // ✅ 페이지에서 전달받는 초기 모드
  className?: string
}

// 뷰 모드 토글 컴포넌트
function EvaluationViewToggle({
  value,
  onValueChange,
  detailedCount,
  aggregatedCount,
}: {
  value: "detailed" | "aggregated";
  onValueChange: (value: "detailed" | "aggregated") => void;
  detailedCount?: number;
  aggregatedCount?: number;
}) {
  return (
    <div className="flex items-center gap-2">
      <ToggleGroup
        type="single"
        value={value}
        onValueChange={(newValue) => {
          if (newValue) onValueChange(newValue as "detailed" | "aggregated");
        }}
        className="bg-muted p-1 rounded-lg"
      >
        <ToggleGroupItem
          value="detailed"
          aria-label="상세 뷰"
          className="flex items-center gap-2 data-[state=on]:bg-background"
        >
          <List className="h-4 w-4" />
          <span>상세 뷰</span>
          {detailedCount !== undefined && (
            <Badge variant="secondary" className="ml-1 text-xs">
              {detailedCount}
            </Badge>
          )}
        </ToggleGroupItem>
        
        <ToggleGroupItem
          value="aggregated"
          aria-label="집계 뷰"
          className="flex items-center gap-2 data-[state=on]:bg-background"
        >
          <BarChart3 className="h-4 w-4" />
          <span>집계 뷰</span>
          {aggregatedCount !== undefined && (
            <Badge variant="secondary" className="ml-1 text-xs">
              {aggregatedCount}
            </Badge>
          )}
        </ToggleGroupItem>
      </ToggleGroup>

      <TooltipProvider>
        <Tooltip>
          <TooltipTrigger asChild>
            <Button variant="ghost" size="icon" className="h-8 w-8">
              <Info className="h-4 w-4" />
            </Button>
          </TooltipTrigger>
          <TooltipContent side="bottom" className="max-w-sm">
            <div className="space-y-2 text-sm">
              <div>
                <strong>상세 뷰:</strong> 모든 평가 기록을 개별적으로 표시
              </div>
              <div>
                <strong>집계 뷰:</strong> 동일 벤더의 여러 division 평가를 평균으로 통합하여 표시
              </div>
            </div>
          </TooltipContent>
        </Tooltip>
      </TooltipProvider>
    </div>
  );
}

// 통계 카드 컴포넌트
function PeriodicEvaluationsStats({ 
  evaluationYear, 
  viewMode 
}: { 
  evaluationYear: number;
  viewMode: "detailed" | "aggregated";
}) {
  const [stats, setStats] = React.useState<any>(null)
  const [isLoading, setIsLoading] = React.useState(true)
  const [error, setError] = React.useState<string | null>(null)

  React.useEffect(() => {
    let isMounted = true

    async function fetchStats() {
      try {
        setIsLoading(true)
        setError(null)

        // 뷰 모드에 따라 다른 통계 함수 호출
        const statsData = await getPeriodicEvaluationsStats(
          evaluationYear, 
          viewMode === "aggregated"
        )

        if (isMounted) {
          setStats(statsData)
        }
      } catch (err) {
        if (isMounted) {
          setError(err instanceof Error ? err.message : 'Failed to fetch stats')
          console.error('Error fetching periodic evaluations stats:', err)
        }
      } finally {
        if (isMounted) {
          setIsLoading(false)
        }
      }
    }

    fetchStats()

    return () => {
      isMounted = false
    }
  }, [evaluationYear, viewMode])

  if (isLoading) {
    return (
      <div className="grid gap-4 md:grid-cols-2 lg:grid-cols-4 mb-6">
        {Array.from({ length: 4 }).map((_, i) => (
          <Card key={i}>
            <CardHeader className="flex flex-row items-center justify-between space-y-0 pb-2">
              <Skeleton className="h-4 w-20" />
            </CardHeader>
            <CardContent>
              <Skeleton className="h-8 w-16" />
            </CardContent>
          </Card>
        ))}
      </div>
    )
  }

  if (error || !stats) {
    return (
      <div className="grid gap-4 md:grid-cols-2 lg:grid-cols-4 mb-6">
        <Card className="col-span-full">
          <CardContent className="pt-6">
            <div className="text-center text-sm text-muted-foreground">
              {error ? `통계 데이터를 불러올 수 없습니다: ${error}` : "통계 데이터가 없습니다."}
            </div>
          </CardContent>
        </Card>
      </div>
    )
  }

  const totalEvaluations = stats.total || 0
  const pendingSubmission = stats.pendingSubmission || 0
  const inProgress = (stats.submitted || 0) + (stats.inReview || 0) + (stats.reviewCompleted || 0)
  const finalized = stats.finalized || 0
  const completionRate = stats.completionRate || 0

  return (
    <div className="grid gap-4 md:grid-cols-2 lg:grid-cols-4 mb-6">
      {/* 총 평가 */}
      <Card>
        <CardHeader className="flex flex-row items-center justify-between space-y-0 pb-2">
          <CardTitle className="text-sm font-medium">
            총 {viewMode === "aggregated" ? "벤더" : "평가"}
          </CardTitle>
          <div className="flex items-center gap-1">
            <Badge variant="outline">{evaluationYear}년</Badge>
            {viewMode === "aggregated" && (
              <Badge variant="secondary" className="text-xs">집계</Badge>
            )}
          </div>
        </CardHeader>
        <CardContent>
          <div className="text-2xl font-bold">{totalEvaluations.toLocaleString()}</div>
          <div className="text-xs text-muted-foreground mt-1">
            평균점수 {stats.averageScore?.toFixed(1) || 0}점
            {viewMode === "aggregated" && stats.totalEvaluationCount && (
              <span className="ml-2">
                (총 {stats.totalEvaluationCount}개 평가)
              </span>
            )}
          </div>
        </CardContent>
      </Card>

      {/* 제출대기 */}
      <Card>
        <CardHeader className="flex flex-row items-center justify-between space-y-0 pb-2">
          <CardTitle className="text-sm font-medium">제출대기</CardTitle>
          <Badge variant="outline">대기</Badge>
        </CardHeader>
        <CardContent>
          <div className="text-2xl font-bold text-orange-600">{pendingSubmission.toLocaleString()}</div>
          <div className="text-xs text-muted-foreground mt-1">
            {totalEvaluations > 0 ? Math.round((pendingSubmission / totalEvaluations) * 100) : 0}% of total
          </div>
        </CardContent>
      </Card>

      {/* 진행중 */}
      <Card>
        <CardHeader className="flex flex-row items-center justify-between space-y-0 pb-2">
          <CardTitle className="text-sm font-medium">진행중</CardTitle>
          <Badge variant="secondary">진행</Badge>
        </CardHeader>
        <CardContent>
          <div className="text-2xl font-bold text-blue-600">{inProgress.toLocaleString()}</div>
          <div className="text-xs text-muted-foreground mt-1">
            {totalEvaluations > 0 ? Math.round((inProgress / totalEvaluations) * 100) : 0}% of total
          </div>
        </CardContent>
      </Card>

      {/* 완료율 */}
      <Card>
        <CardHeader className="flex flex-row items-center justify-between space-y-0 pb-2">
          <CardTitle className="text-sm font-medium">완료율</CardTitle>
          <Badge variant={completionRate >= 80 ? "default" : completionRate >= 60 ? "secondary" : "destructive"}>
            {completionRate}%
          </Badge>
        </CardHeader>
        <CardContent>
          <div className="text-2xl font-bold text-green-600">{finalized.toLocaleString()}</div>
          <div className="text-xs text-muted-foreground mt-1">
            최종확정 완료
          </div>
        </CardContent>
      </Card>
    </div>
  )
}

export function PeriodicEvaluationsTable({ 
  promises, 
  evaluationYear, 
  initialViewMode = "detailed",
  className 
}: PeriodicEvaluationsTableProps) {
  const router = useRouter()
  const searchParams = useSearchParams()
  
  // ✅ URL에서 현재 집계 모드 상태 읽기
  const currentParams = searchParamsEvaluationsCache.parse(Object.fromEntries(searchParams.entries()))
  const [viewMode, setViewMode] = React.useState<"detailed" | "aggregated">(
    currentParams.aggregated ? "aggregated" : "detailed"
  )
  
  const [rowAction, setRowAction] = React.useState<DataTableRowAction<PeriodicEvaluationView | PeriodicEvaluationAggregatedView> | null>(null)
  const [isFilterPanelOpen, setIsFilterPanelOpen] = React.useState(false)
  const [detailedCount, setDetailedCount] = React.useState<number | undefined>(undefined)
  const [aggregatedCount, setAggregatedCount] = React.useState<number | undefined>(undefined)

  const [externalFilters, setExternalFilters] = React.useState<any[]>([]);
  const [externalJoinOperator, setExternalJoinOperator] = React.useState<"and" | "or">("and");

  // ✅ 뷰 모드 변경 시 URL 업데이트
  const handleViewModeChange = React.useCallback((newMode: "detailed" | "aggregated") => {
    setViewMode(newMode);
    
    // URL 파라미터 업데이트
    const newSearchParams = new URLSearchParams(searchParams.toString())
    if (newMode === "aggregated") {
      newSearchParams.set("aggregated", "true")
    } else {
      newSearchParams.delete("aggregated")
    }
    
    // 페이지를 1로 리셋
    newSearchParams.set("page", "1")
    
    router.push(`?${newSearchParams.toString()}`, { scroll: false })
  }, [router, searchParams])

  const handleFiltersApply = React.useCallback((filters: any[], joinOperator: "and" | "or") => {
    console.log("=== 폼에서 필터 전달받음 ===", filters, joinOperator);
    setExternalFilters(filters);
    setExternalJoinOperator(joinOperator);
    setIsFilterPanelOpen(false);
  }, []);

  // 컨테이너 위치 추적
  const containerRef = React.useRef<HTMLDivElement>(null)
  const [containerTop, setContainerTop] = React.useState(0)

  const updateContainerBounds = React.useCallback(() => {
    if (containerRef.current) {
      const rect = containerRef.current.getBoundingClientRect()
      const newTop = rect.top
      setContainerTop(prevTop => {
        if (Math.abs(prevTop - newTop) > 1) {
          return newTop
        }
        return prevTop
      })
    }
  }, [])

  React.useEffect(() => {
    updateContainerBounds()
    const throttledHandler = () => {
      let timeoutId: NodeJS.Timeout
      return () => {
        clearTimeout(timeoutId)
        timeoutId = setTimeout(updateContainerBounds, 16)
      }
    }

    const handler = throttledHandler()
    window.addEventListener('resize', updateContainerBounds)
    window.addEventListener('scroll', handler)

    return () => {
      window.removeEventListener('resize', updateContainerBounds)
      window.removeEventListener('scroll', handler)
    }
  }, [updateContainerBounds])

  // 데이터 로드
  const [promiseData] = React.use(promises)
  const tableData = promiseData

  // 테이블 설정
  const initialSettings = React.useMemo(() => ({
    page: currentParams.page || 1,
    perPage: currentParams.perPage || 10,
    sort: currentParams.sort || [{ id: "createdAt", desc: true }],
    filters: currentParams.filters || [],
    joinOperator: currentParams.joinOperator || "and",
    search: "",
    columnVisibility: {},
    columnOrder: [],
    pinnedColumns: { left: [], right: ["actions"] },
    groupBy: [],
    expandedRows: []
  }), [currentParams])

  const {
    presets,
    activePresetId,
    hasUnsavedChanges,
    isLoading: presetsLoading,
    createPreset,
    applyPreset,
    updatePreset,
    deletePreset,
    setDefaultPreset,
    renamePreset,
    getCurrentSettings,
  } = useTablePresets<PeriodicEvaluationView | PeriodicEvaluationAggregatedView>('periodic-evaluations-table', initialSettings)

  // 집계 모드에 따라 컬럼 수정
  const columns = React.useMemo(() => {
    return getPeriodicEvaluationsColumns({ 
      setRowAction, 
      viewMode 
    });
  }, [viewMode, setRowAction]);

  const filterFields: DataTableFilterField<PeriodicEvaluationView | PeriodicEvaluationAggregatedView>[] = [
    { id: "vendorCode", label: "벤더 코드" },
    { id: "vendorName", label: "벤더명" },
    { id: "status", label: "진행상태" },
  ]

  const advancedFilterFields: DataTableAdvancedFilterField<PeriodicEvaluationView | PeriodicEvaluationAggregatedView>[] = [
    { id: "evaluationYear", label: "평가년도", type: "number" },
    { id: "evaluationPeriod", label: "평가기간", type: "text" },
    {
      id: "division", label: "구분", type: "select", options: [
        { label: "해양", value: "PLANT" },
        { label: "조선", value: "SHIP" },
        ...(viewMode === "aggregated" ? [{ label: "통합", value: "BOTH" }] : []),
      ]
    },
    { id: "vendorCode", label: "벤더 코드", type: "text" },
    { id: "vendorName", label: "벤더명", type: "text" },
    {
      id: "status", label: "진행상태", type: "select", options: [
        { label: "제출대기", value: "PENDING_SUBMISSION" },
        { label: "제출완료", value: "SUBMITTED" },
        { label: "검토중", value: "IN_REVIEW" },
        { label: "검토완료", value: "REVIEW_COMPLETED" },
        { label: "최종확정", value: "FINALIZED" },
      ]
    },
    {
      id: "documentsSubmitted", label: "문서제출", type: "select", options: [
        { label: "제출완료", value: "true" },
        { label: "미제출", value: "false" },
      ]
    },
    { id: "finalScore", label: "최종점수", type: "number" },
    { id: "submissionDate", label: "제출일", type: "date" },
    { id: "reviewCompletedAt", label: "검토완료일", type: "date" },
    { id: "finalizedAt", label: "최종확정일", type: "date" },
  ]

  const currentSettings = React.useMemo(() => getCurrentSettings(), [getCurrentSettings]);

  const initialState = React.useMemo(() => ({
    sorting: initialSettings.sort.filter((s: any) => columns.some((c: any) => ("accessorKey" in c ? c.accessorKey : c.id) === s.id)),
    columnVisibility: currentSettings.columnVisibility,
    columnPinning: currentSettings.pinnedColumns,
  }), [columns, currentSettings, initialSettings.sort]);

  const { table } = useDataTable({
    data: tableData.data,
    columns,
    pageCount: tableData.pageCount,
    rowCount: tableData.total || tableData.data.length,
    filterFields,
    enablePinning: true,
    enableAdvancedFilter: true,
    initialState,
    getRowId: (originalRow) => String(originalRow.id),
    shallow: false,
    clearOnDefault: true,
  })

  const getActiveFilterCount = React.useCallback(() => {
    try {
      return currentParams.filters?.length || 0;
    } catch {
      return 0;
    }
  }, [currentParams.filters]);

  const FILTER_PANEL_WIDTH = 400;

  return (
    <>
      {/* Filter Panel */}
      <div
        className={cn(
          "fixed left-0 bg-background border-r z-50 flex flex-col transition-all duration-300 ease-in-out overflow-hidden",
          isFilterPanelOpen ? "border-r shadow-lg" : "border-r-0"
        )}
        style={{
          width: isFilterPanelOpen ? `${FILTER_PANEL_WIDTH}px` : '0px',
          top: `${containerTop}px`,
          height: `calc(100vh - ${containerTop}px)`
        }}
      >
        <div className="h-full">
          <PeriodicEvaluationFilterSheet
            isOpen={isFilterPanelOpen}
            onClose={() => setIsFilterPanelOpen(false)}
            onFiltersApply={handleFiltersApply}
            isLoading={false}
          />
        </div>
      </div>

      {/* Main Content Container */}
      <div
        ref={containerRef}
        className={cn("relative w-full overflow-hidden", className)}
      >
        <div className="flex w-full h-full">
          <div
            className="flex flex-col min-w-0 overflow-hidden transition-all duration-300 ease-in-out"
            style={{
              width: isFilterPanelOpen ? `calc(100% - ${FILTER_PANEL_WIDTH}px)` : '100%',
              marginLeft: isFilterPanelOpen ? `${FILTER_PANEL_WIDTH}px` : '0px'
            }}
          >
            {/* Header Bar with View Toggle */}
            <div className="flex items-center justify-between p-4 bg-background shrink-0">
              <div className="flex items-center gap-3">
                <Button
                  variant="outline"
                  size="sm"
                  type="button"
                  onClick={() => setIsFilterPanelOpen(!isFilterPanelOpen)}
                  className="flex items-center shadow-sm"
                >
                  {isFilterPanelOpen ? <PanelLeftClose className="size-4" /> : <PanelLeftOpen className="size-4" />}
                  {getActiveFilterCount() > 0 && (
                    <span className="ml-2 bg-primary text-primary-foreground rounded-full px-2 py-0.5 text-xs">
                      {getActiveFilterCount()}
                    </span>
                  )}
                </Button>

                {/* ✅ 뷰 모드 토글 */}
                <EvaluationViewToggle
                  value={viewMode}
                  onValueChange={handleViewModeChange}
                  detailedCount={detailedCount}
                  aggregatedCount={aggregatedCount}
                />
              </div>

              <div className="flex items-center gap-4">
                <div className="text-sm text-muted-foreground">
                  {viewMode === "detailed" ? (
                    <span>모든 평가 기록 표시</span>
                  ) : (
                    <span>벤더별 통합 평가 표시</span>
                  )}
                </div>
                
                <div className="text-sm text-muted-foreground">
                  {tableData && (
                    <span>총 {tableData.total || tableData.data.length}건</span>
                  )}
                </div>
              </div>
            </div>

            {/* 통계 카드들 */}
            <div className="px-4">
              <PeriodicEvaluationsStats 
                evaluationYear={evaluationYear} 
                viewMode={viewMode}
              />
            </div>

            {/* Table Content Area */}
            <div className="flex-1 overflow-hidden" style={{ height: 'calc(100vh - 500px)' }}>
              <div className="h-full w-full">
                <DataTable table={table} className="h-full">
                  <DataTableAdvancedToolbar
                    table={table}
                    filterFields={advancedFilterFields}
                    debounceMs={300}
                    shallow={false}
                    externalFilters={externalFilters}
                    externalJoinOperator={externalJoinOperator}
                    onFiltersChange={(filters, joinOperator) => {
                      console.log("=== 필터 변경 감지 ===", filters, joinOperator);
                    }}
                  >
                    <div className="flex items-center gap-2">
                      <TablePresetManager<PeriodicEvaluationView | PeriodicEvaluationAggregatedView>
                        presets={presets}
                        activePresetId={activePresetId}
                        currentSettings={currentSettings}
                        hasUnsavedChanges={hasUnsavedChanges}
                        isLoading={presetsLoading}
                        onCreatePreset={createPreset}
                        onUpdatePreset={updatePreset}
                        onDeletePreset={deletePreset}
                        onApplyPreset={applyPreset}
                        onSetDefaultPreset={setDefaultPreset}
                        onRenamePreset={renamePreset}
                      />

                      <PeriodicEvaluationsTableToolbarActions table={table} />
                    </div>
                  </DataTableAdvancedToolbar>
                </DataTable>

                <EvaluationDetailsDialog
                  open={rowAction?.type === "view"}
                  onOpenChange={(open) => {
                    if (!open) {
                      setRowAction(null);
                    }
                  }}
                  evaluation={rowAction?.row.original || null}
                />
              </div>
            </div>
          </div>
        </div>
      </div>
    </>
  )
}