(대표님) 권한관리, 문서업로드, rfq첨부, SWP문서룰 등

(최겸) 입찰

12 files changed, 3802 insertions, 2173 deletions

diff --git a/lib/vendor-document-list/plant/document-stage-actions.ts b/lib/vendor-document-list/plant/document-stage-actions.ts
deleted file mode 100644
index e69de29b..00000000
--- a/lib/vendor-document-list/plant/document-stage-actions.ts
+++ /dev/null
diff --git a/lib/vendor-document-list/plant/document-stage-dialogs.tsx b/lib/vendor-document-list/plant/document-stage-dialogs.tsx
index 14035562..779d31e1 100644
--- a/lib/vendor-document-list/plant/document-stage-dialogs.tsx
+++ b/lib/vendor-document-list/plant/document-stage-dialogs.tsx
@@ -32,7 +32,7 @@ import {
 } from "@/components/ui/select"
 import { Badge } from "@/components/ui/badge"
 import { StageDocumentsView } from "@/db/schema"
-import { Upload, FileSpreadsheet, Calendar, User, Target, Loader2, AlertTriangle, Loader ,Trash, CheckCircle, Download, AlertCircle} from "lucide-react"
+import { Upload, FileSpreadsheet, Calendar, User, Target, Loader2, AlertTriangle, Loader ,Trash, CheckCircle, Download, AlertCircle, FileText, FolderOpen} from "lucide-react"
 import { toast } from "sonner"
 import {
   getDocumentNumberTypes,
@@ -60,11 +60,11 @@ import {
   DrawerTrigger,
 } from "@/components/ui/drawer"
 import { useRouter } from "next/navigation"
-import { cn, formatDate } from "@/lib/utils"
-import ExcelJS from 'exceljs'
-import { Progress } from "@/components/ui/progress"
 import { Alert, AlertDescription } from "@/components/ui/alert"
-import { Tabs, TabsContent, TabsList, TabsTrigger } from "@/components/ui/tabs"
+import { Controller, useForm, useWatch } from "react-hook-form"
+import { zodResolver } from "@hookform/resolvers/zod"
+import { z } from "zod"
+import { Card, CardContent, CardHeader, CardTitle, CardDescription } from "@/components/ui/card"
 
 const getStatusVariant = (status: string) => {
   switch (status) {
@@ -88,17 +88,24 @@ const getStatusText = (status: string) => {
 }
 
 
-// =============================================================================
-// 1. Add Document Dialog
-// =============================================================================
+// Form validation schema
+const documentFormSchema = z.object({
+  documentClassId: z.string().min(1, "Document class is required"),
+  title: z.string().min(1, "Document title is required"),
+  shiFieldValues: z.record(z.string()).optional(),
+  cpyFieldValues: z.record(z.string()).optional(),
+  planDates: z.record(z.string()).optional(),
+})
+
+type DocumentFormValues = z.infer<typeof documentFormSchema>
+
 interface AddDocumentDialogProps {
   open: boolean
   onOpenChange: (open: boolean) => void
   contractId: number
-  projectType: "ship" | "plant"
+  projectType?: string
 }
 
-
 export function AddDocumentDialog({
   open,
   onOpenChange,
@@ -106,113 +113,115 @@ export function AddDocumentDialog({
   projectType
 }: AddDocumentDialogProps) {
   const [isLoadingInitialData, setIsLoadingInitialData] = React.useState(false)
-  const [isSubmitting, setIsSubmitting] = React.useState(false)
-  const [documentNumberTypes, setDocumentNumberTypes] = React.useState<any[]>([])
   const [documentClasses, setDocumentClasses] = React.useState<any[]>([])
-  const [selectedTypeConfigs, setSelectedTypeConfigs] = React.useState<any[]>([])
-  const [comboBoxOptions, setComboBoxOptions] = React.useState<Record<number, any[]>>({})
   const [documentClassOptions, setDocumentClassOptions] = React.useState<any[]>([])
   
-  // SHI와 CPY 타입 체크
+  // SHI related states
   const [shiType, setShiType] = React.useState<any>(null)
+  const [shiTypeConfigs, setShiTypeConfigs] = React.useState<any[]>([])
+  const [shiComboBoxOptions, setShiComboBoxOptions] = React.useState<Record<number, any[]>>({})
+  
+  // CPY related states
   const [cpyType, setCpyType] = React.useState<any>(null)
-  const [activeTab, setActiveTab] = React.useState<"SHI" | "CPY">("SHI")
-  const [dataLoaded, setDataLoaded] = React.useState(false)
+  const [cpyTypeConfigs, setCpyTypeConfigs] = React.useState<any[]>([])
+  const [cpyComboBoxOptions, setCpyComboBoxOptions] = React.useState<Record<number, any[]>>({})
+
+  // Initialize react-hook-form
+  const form = useForm<DocumentFormValues>({
+    resolver: zodResolver(documentFormSchema),
+    defaultValues: {
+      documentClassId: '',
+      title: '',
+      shiFieldValues: {},
+      cpyFieldValues: {},
+      planDates: {},
+    },
+  })
 
-  console.log(dataLoaded,"dataLoaded")
+  // Watch form values for reactive updates
+  const documentClassId = useWatch({
+    control: form.control,
+    name: 'documentClassId',
+  })
 
-  const [formData, setFormData] = React.useState({
-    documentNumberTypeId: "",
-    documentClassId: "",
-    title: "",
-    fieldValues: {} as Record<string, string>,
-    planDates: {} as Record<number, string>
+  const shiFieldValues = useWatch({
+    control: form.control,
+    name: 'shiFieldValues',
   })
 
-  // Load initial data
-// Dialog가 닫힐 때 상태 초기화를 확실히 하기
-React.useEffect(() => {
-  if (!open) {
-    // Dialog가 닫힐 때만 초기화
-    resetForm()
-  } else if (!dataLoaded) {
-    // Dialog가 열리고 데이터가 로드되지 않았을 때만
-    loadInitialData()
-  }
-}, [open])
+  const cpyFieldValues = useWatch({
+    control: form.control,
+    name: 'cpyFieldValues',
+  })
 
+  // Load initial data when dialog opens
+  React.useEffect(() => {
+    if (open) {
+      loadInitialData()
+    } else {
+      // Reset form when dialog closes
+      form.reset()
+      setShiTypeConfigs([])
+      setCpyTypeConfigs([])
+      setShiComboBoxOptions({})
+      setCpyComboBoxOptions({})
+      setDocumentClassOptions([])
+    }
+  }, [open])
+
+  // Load document class options when class changes
+  React.useEffect(() => {
+    if (documentClassId) {
+      loadDocumentClassOptions(documentClassId)
+    }
+  }, [documentClassId])
 
   const loadInitialData = async () => {
     setIsLoadingInitialData(true)
-    let foundShiType = null;
-    let foundCpyType = null;
-    
     try {
       const [typesResult, classesResult] = await Promise.all([
         getDocumentNumberTypes(contractId),
         getDocumentClasses(contractId)
       ])
 
-      console.log(typesResult,"typesResult")
-  
       if (typesResult.success && typesResult.data) {
-        setDocumentNumberTypes(typesResult.data)
-        
-        // 로컬 변수에 먼저 저장
-        foundShiType = typesResult.data.find((type: any) => 
-          type.name?.toUpperCase().trim() === "SHI"
+        const foundShiType = typesResult.data.find((type: any) => 
+          type.name?.toUpperCase().trim() === 'SHI'
         )
-        foundCpyType = typesResult.data.find((type: any) => 
-          type.name?.toUpperCase().trim() === "CPY"
+        const foundCpyType = typesResult.data.find((type: any) => 
+          type.name?.toUpperCase().trim() === 'CPY'
         )
         
         setShiType(foundShiType || null)
         setCpyType(foundCpyType || null)
-        
-        // 로컬 변수 사용
+
+        // Load configs for both types
         if (foundShiType) {
-          await handleTabChange("SHI", String(foundShiType.id))
-        } else if (foundCpyType) {
-          setActiveTab("CPY")
-          await handleTabChange("CPY", String(foundCpyType.id))
+          await loadShiTypeConfigs(foundShiType.id)
+        }
+        if (foundCpyType) {
+          await loadCpyTypeConfigs(foundCpyType.id)
         }
       }
       
       if (classesResult.success) {
         setDocumentClasses(classesResult.data)
       }
-      
-      setDataLoaded(true)
     } catch (error) {
-      console.error("Error loading data:", error)
-      toast.error("Error loading data.")
+      console.error('Error loading initial data:', error)
+      toast.error('Error loading data.')
     } finally {
-      // 로컬 변수를 체크
-      if (!foundShiType && !foundCpyType) {
-        console.error("No types found after loading")
-      }
       setIsLoadingInitialData(false)
     }
   }
 
-  // 탭 변경 처리
-  const handleTabChange = async (tab: "SHI" | "CPY", typeId?: string) => {
-    setActiveTab(tab)
-    
-    const documentNumberTypeId = typeId || (tab === "SHI" ? shiType?.id : cpyType?.id)
-    
-    if (documentNumberTypeId) {
-      setFormData(prev => ({
-        ...prev,
-        documentNumberTypeId: String(documentNumberTypeId),
-        fieldValues: {}
-      }))
-      
-      const configsResult = await getDocumentNumberTypeConfigs(Number(documentNumberTypeId))
+  const loadShiTypeConfigs = async (typeId: number) => {
+    try {
+      const configsResult = await getDocumentNumberTypeConfigs(typeId)
       if (configsResult.success) {
-        setSelectedTypeConfigs(configsResult.data)
+        setShiTypeConfigs(configsResult.data)
 
-        // Pre-load combobox options
+        // Pre-load combobox options for SHI
         const comboBoxPromises = configsResult.data
           .filter(config => config.codeGroup?.controlType === 'combobox')
           .map(async (config) => {
@@ -230,62 +239,82 @@ React.useEffect(() => {
             newComboBoxOptions[result.codeGroupId] = result.options
           }
         })
-        setComboBoxOptions(newComboBoxOptions)
+        setShiComboBoxOptions(newComboBoxOptions)
       }
-    } else {
-      setSelectedTypeConfigs([])
-      setComboBoxOptions({})
+    } catch (error) {
+      console.error('Error loading SHI type configs:', error)
     }
   }
 
-  // Handle field value change
-  const handleFieldValueChange = (fieldKey: string, value: string) => {
-    setFormData({
-      ...formData,
-      fieldValues: {
-        ...formData.fieldValues,
-        [fieldKey]: value
+  const loadCpyTypeConfigs = async (typeId: number) => {
+    try {
+      const configsResult = await getDocumentNumberTypeConfigs(typeId)
+      if (configsResult.success) {
+        setCpyTypeConfigs(configsResult.data)
+
+        // Pre-load combobox options for CPY
+        const comboBoxPromises = configsResult.data
+          .filter(config => config.codeGroup?.controlType === 'combobox')
+          .map(async (config) => {
+            const optionsResult = await getComboBoxOptions(config.codeGroupId!, contractId)
+            return { 
+              codeGroupId: config.codeGroupId,
+              options: optionsResult.success ? optionsResult.data : []
+            }
+          })
+
+        const comboBoxResults = await Promise.all(comboBoxPromises)
+        const newComboBoxOptions: Record<number, any[]> = {}
+        comboBoxResults.forEach(result => {
+          if (result.codeGroupId) {
+            newComboBoxOptions[result.codeGroupId] = result.options
+          }
+        })
+        setCpyComboBoxOptions(newComboBoxOptions)
       }
-    })
+    } catch (error) {
+      console.error('Error loading CPY type configs:', error)
+    }
   }
 
-  // Handle document class change
-  const handleDocumentClassChange = async (documentClassId: string) => {
-    setFormData({
-      ...formData,
-      documentClassId,
-      planDates: {}
-    })
-
-    if (documentClassId) {
-      const optionsResult = await getDocumentClassOptions(Number(documentClassId))
+  const loadDocumentClassOptions = async (classId: string) => {
+    try {
+      const optionsResult = await getDocumentClassOptions(Number(classId))
       if (optionsResult.success) {
         setDocumentClassOptions(optionsResult.data)
+        // Reset plan dates for new class
+        form.setValue('planDates', {})
       }
-    } else {
-      setDocumentClassOptions([])
+    } catch (error) {
+      console.error('Error loading class options:', error)
     }
   }
 
-  // Handle plan date change
-  const handlePlanDateChange = (optionId: number, date: string) => {
-    setFormData({
-      ...formData,
-      planDates: {
-        ...formData.planDates,
-        [optionId]: date
+  // Generate document number preview for SHI
+  const generateShiPreview = () => {
+    if (shiTypeConfigs.length === 0) return ''
+
+    let preview = ''
+    shiTypeConfigs.forEach((config, index) => {
+      const fieldKey = `field_${config.sdq}`
+      const value = shiFieldValues?.[fieldKey] || '[value]'
+      
+      if (index > 0 && config.delimiter) {
+        preview += config.delimiter
       }
+      preview += value
     })
+    return preview
   }
 
-  // Generate document number preview
-  const generatePreviewDocNumber = () => {
-    if (selectedTypeConfigs.length === 0) return ""
+  // Generate document number preview for CPY
+  const generateCpyPreview = () => {
+    if (cpyTypeConfigs.length === 0) return ''
 
-    let preview = ""
-    selectedTypeConfigs.forEach((config, index) => {
+    let preview = ''
+    cpyTypeConfigs.forEach((config, index) => {
       const fieldKey = `field_${config.sdq}`
-      const value = formData.fieldValues[fieldKey] || "[value]"
+      const value = cpyFieldValues?.[fieldKey] || '[value]'
       
       if (index > 0 && config.delimiter) {
         preview += config.delimiter
@@ -295,228 +324,155 @@ React.useEffect(() => {
     return preview
   }
 
-  // Check if form is valid for submission
-  const isFormValid = () => {
-    if (!formData.documentNumberTypeId || !formData.documentClassId || !formData.title.trim()) {
-      return false
-    }
+  // Check if SHI fields are complete
+  const isShiComplete = () => {
+    if (!shiType || shiTypeConfigs.length === 0) return true // Skip if not configured
 
-    const requiredConfigs = selectedTypeConfigs.filter(config => config.required)
+    const requiredConfigs = shiTypeConfigs.filter(config => config.required)
     for (const config of requiredConfigs) {
       const fieldKey = `field_${config.sdq}`
-      const value = formData.fieldValues[fieldKey]
+      const value = shiFieldValues?.[fieldKey]
       if (!value || !value.trim()) {
         return false
       }
     }
 
-    const docNumber = generatePreviewDocNumber()
-    if (!docNumber || docNumber === "" || docNumber.includes("[value]")) {
-      return false
+    const preview = generateShiPreview()
+    return preview && preview !== '' && !preview.includes('[value]')
+  }
+
+  // Check if CPY fields are complete
+  const isCpyComplete = () => {
+    if (!cpyType || cpyTypeConfigs.length === 0) return true // Skip if not configured
+
+    const requiredConfigs = cpyTypeConfigs.filter(config => config.required)
+    for (const config of requiredConfigs) {
+      const fieldKey = `field_${config.sdq}`
+      const value = cpyFieldValues?.[fieldKey]
+      if (!value || !value.trim()) {
+        return false
+      }
     }
 
-    return true
+    const preview = generateCpyPreview()
+    return preview && preview !== '' && !preview.includes('[value]')
   }
 
-  const handleSubmit = async () => {
-    if (!isFormValid()) {
-      toast.error("Please fill in all required fields.")
+  const onSubmit = async (data: DocumentFormValues) => {
+    // Validate that at least one document number is configured and complete
+    if (shiType && !isShiComplete()) {
+      toast.error('Please fill in all required SHI document number fields.')
       return
     }
-
-    const generatedDocNumber = generatePreviewDocNumber()
-    if (!generatedDocNumber) {
-      toast.error("Cannot generate document number.")
+    
+    if (cpyType && !isCpyComplete()) {
+      toast.error('Please fill in all required CPY project document number fields.')
       return
     }
 
-    setIsSubmitting(true)
+    const shiDocNumber = shiType ? generateShiPreview() : ''
+    const cpyDocNumber = cpyType ? generateCpyPreview() : ''
+
     try {
-      // CPY 탭에서는 생성된 문서번호를 vendorDocNumber로 저장
       const submitData = {
         contractId,
-        documentNumberTypeId: Number(formData.documentNumberTypeId),
-        documentClassId: Number(formData.documentClassId),
-        title: formData.title,
-        docNumber: activeTab === "SHI" ? generatedDocNumber : "", // SHI는 docNumber로
-        vendorDocNumber: activeTab === "CPY" ? generatedDocNumber : "", // CPY는 vendorDocNumber로
-        fieldValues: formData.fieldValues,
-        planDates: formData.planDates,
+        documentClassId: Number(data.documentClassId),
+        title: data.title,
+        docNumber: shiDocNumber,
+        vendorDocNumber: cpyDocNumber,
+        fieldValues: {
+          ...data.shiFieldValues,
+          ...data.cpyFieldValues
+        },
+        planDates: data.planDates || {},
       }
 
       const result = await createDocument(submitData)
 
       if (result.success) {
-        toast.success("Document added successfully.")
+        toast.success('Document added successfully.')
         onOpenChange(false)
-        resetForm()
+        form.reset()
       } else {
-        toast.error(result.error || "Error adding document.")
+        toast.error(result.error || 'Error adding document.')
       }
     } catch (error) {
-      toast.error("Error adding document.")
-    } finally {
-      setIsSubmitting(false)
+      console.error('Error submitting document:', error)
+      toast.error('Error adding document.')
     }
   }
 
-  const resetForm = () => {
-    setFormData({
-      documentNumberTypeId: "",
-      documentClassId: "",
-      title: "",
-      fieldValues: {},
-      planDates: {}
-    })
-    setSelectedTypeConfigs([])
-    setComboBoxOptions({})
-    setDocumentClassOptions([])
-    setActiveTab("SHI")
-    setDataLoaded(false)
-  }
+  // Check if we have at least one type available
+  const hasAvailableTypes = shiType || cpyType
 
-  // 공통 폼 컴포넌트
-  const DocumentForm = () => (
-    <div className="grid gap-4">
-      {/* Dynamic Fields */}
-      {selectedTypeConfigs.length > 0 && (
-        <div className="border rounded-lg p-4 bg-blue-50/30 dark:bg-blue-950/30">
-          <Label className="text-sm font-medium text-blue-800 dark:text-blue-200 mb-3 block">
-            Document Number Components
-          </Label>
-          <div className="grid gap-3">
-            {selectedTypeConfigs.map((config) => (
-              <div key={config.id} className="grid gap-2">
-                <Label className="text-sm">
-                  {config.codeGroup?.description || config.description}
-                  {config.required && <span className="text-red-500 ml-1">*</span>}
-                  {config.remark && (
-                    <span className="text-xs text-gray-500 dark:text-gray-400 ml-2">({config.remark})</span>
-                  )}
-                </Label>
+  // Render field component
+  const renderField = (
+    config: any, 
+    fieldType: 'SHI' | 'CPY',
+    comboBoxOptions: Record<number, any[]>
+  ) => {
+    const fieldKey = `field_${config.sdq}`
+    const fieldName = fieldType === 'SHI' 
+      ? `shiFieldValues.${fieldKey}` 
+      : `cpyFieldValues.${fieldKey}`
 
-                {config.codeGroup?.controlType === 'combobox' ? (
-                  <Select
-                    value={formData.fieldValues[`field_${config.sdq}`] || ""}
-                    onValueChange={(value) => handleFieldValueChange(`field_${config.sdq}`, value)}
-                  >
-                    <SelectTrigger>
-                      <SelectValue placeholder="Select option" />
-                    </SelectTrigger>
-                    <SelectContent>
-                      {(comboBoxOptions[config.codeGroupId!] || []).map((option) => (
-                        <SelectItem key={option.id} value={option.code}>
-                          {option.code} - {option.description}
-                        </SelectItem>
-                      ))}
-                    </SelectContent>
-                  </Select>
-                ) : config.documentClass ? (
-                  <div className="p-2 bg-gray-100 dark:bg-gray-800 rounded text-sm">
-                    {config.documentClass.code} - {config.documentClass.description}
-                  </div>
-                ) : (
-                  <Input
-                    value={formData.fieldValues[`field_${config.sdq}`] || ""}
-                    onChange={(e) => handleFieldValueChange(`field_${config.sdq}`, e.target.value)}
-                    placeholder="Enter value"
-                  />
-                )}
-              </div>
-            ))}
-          </div>
-
-          {/* Document Number Preview */}
-          <div className="mt-3 p-2 bg-white dark:bg-gray-900 border rounded">
-            <Label className="text-xs text-gray-600 dark:text-gray-400">
-              {activeTab === "SHI" ? "Document Number" : "Project Document Number"} Preview:
-            </Label>
-            <div className="font-mono text-sm font-medium text-blue-600 dark:text-blue-400">
-              {generatePreviewDocNumber()}
-            </div>
-          </div>
-        </div>
-      )}
-
-      {/* Document Class Selection */}
-      <div className="grid gap-2">
-        <Label htmlFor="documentClassId">
-          Document Class <span className="text-red-500">*</span>
+    return (
+      <div key={config.id} className="grid gap-2">
+        <Label className="text-sm">
+          {config.codeGroup?.description || config.description}
+          {config.required && <span className="text-red-500 ml-1">*</span>}
+          {config.remark && (
+            <span className="text-xs text-gray-500 dark:text-gray-400 ml-2">
+              ({config.remark})
+            </span>
+          )}
         </Label>
-        <Select
-          value={formData.documentClassId}
-          onValueChange={handleDocumentClassChange}
-        >
-          <SelectTrigger>
-            <SelectValue placeholder="Select document class" />
-          </SelectTrigger>
-          <SelectContent>
-            {documentClasses.map((cls) => (
-              <SelectItem key={cls.id} value={String(cls.id)}>
-                {cls.value}
-              </SelectItem>
-            ))}
-          </SelectContent>
-        </Select>
-        {formData.documentClassId && (
-          <p className="text-xs text-gray-600 dark:text-gray-400">
-            Options from the selected class will be automatically created as stages.
-          </p>
-        )}
-      </div>
 
-      {/* Document Class Options with Plan Dates */}
-      {documentClassOptions.length > 0 && (
-        <div className="border rounded-lg p-4 bg-green-50/30 dark:bg-green-950/30">
-          <Label className="text-sm font-medium text-green-800 dark:text-green-200 mb-3 block">
-            Document Class Stages with Plan Dates
-          </Label>
-          <div className="grid gap-3">
-            {documentClassOptions.map((option) => (
-              <div key={option.id} className="grid grid-cols-2 gap-3 items-center">
-                <div>
-                  <Label className="text-sm font-medium">
-                    {option.optionValue}
-                  </Label>
-                  {option.optionCode && (
-                    <p className="text-xs text-gray-500 dark:text-gray-400">Code: {option.optionCode}</p>
-                  )}
-                </div>
-                <div className="grid gap-1">
-                  <Label className="text-xs text-gray-600 dark:text-gray-400">Plan Date</Label>
-                  <Input
-                    type="date"
-                    value={formData.planDates[option.id] || ""}
-                    onChange={(e) => handlePlanDateChange(option.id, e.target.value)}
-                    className="text-sm"
-                  />
+        <Controller
+          name={fieldName as any}
+          control={form.control}
+          rules={{ required: config.required }}
+          render={({ field }) => {
+            if (config.codeGroup?.controlType === 'combobox') {
+              return (
+                <Select value={field.value || ''} onValueChange={field.onChange}>
+                  <SelectTrigger>
+                    <SelectValue placeholder="Select option" />
+                  </SelectTrigger>
+                  <SelectContent>
+                    {(comboBoxOptions[config.codeGroupId!] || []).map((option) => (
+                      <SelectItem key={option.id} value={option.code}>
+                        {option.code} - {option.description}
+                      </SelectItem>
+                    ))}
+                  </SelectContent>
+                </Select>
+              )
+            } else if (config.documentClass) {
+              return (
+                <div className="p-2 bg-gray-100 dark:bg-gray-800 rounded text-sm">
+                  {config.documentClass.code} - {config.documentClass.description}
                 </div>
-              </div>
-            ))}
-          </div>
-        </div>
-      )}
-
-      {/* Document Title */}
-      <div className="grid gap-2">
-        <Label htmlFor="title">
-          Document Title <span className="text-red-500">*</span>
-        </Label>
-        <Input
-          id="title"
-          value={formData.title}
-          onChange={(e) => setFormData({ ...formData, title: e.target.value })}
-          placeholder="Enter document title"
+              )
+            } else {
+              return (
+                <Input
+                  {...field}
+                  value={field.value || ''}
+                  placeholder="Enter value"
+                />
+              )
+            }
+          }}
         />
       </div>
-    </div>
-  )
+    )
+  }
 
-  // 로딩 중이거나 데이터 체크 중일 때 표시
   if (isLoadingInitialData) {
     return (
       <Dialog open={open} onOpenChange={onOpenChange}>
-        <DialogContent className="sm:max-w-[700px] h-[80vh] flex flex-col">
+        <DialogContent className="sm:max-w-[800px] h-[80vh] flex flex-col">
           <div className="flex items-center justify-center py-8 flex-1">
             <Loader2 className="h-8 w-8 animate-spin" />
           </div>
@@ -525,98 +481,239 @@ React.useEffect(() => {
     )
   }
 
- return (
-<Dialog open={open} onOpenChange={onOpenChange}>
-  <DialogContent className="sm:max-w-[700px] max-h-[80vh] flex flex-col overflow-hidden">
-    <DialogHeader className="flex-shrink-0">
-      <DialogTitle>Add New Document</DialogTitle>
-      <DialogDescription>
-        Enter the basic information for the new document.
-      </DialogDescription>
-    </DialogHeader>
-
-    {!shiType && !cpyType ? (
-      <div className="flex-1 flex items-center justify-center">
-        <Alert className="max-w-md">
-          <AlertTriangle className="h-4 w-4" />
-          <AlertDescription>
-           Required Document Number Type (SHI, CPY) is not configured. Please configure it first in the Number Types management.
-          </AlertDescription>
-        </Alert>
-      </div>
-    ) : (
-      <>
-        <Tabs
-          value={activeTab}
-          onValueChange={(v) => handleTabChange(v as "SHI" | "CPY")}
-          className="flex-1 min-h-0 flex flex-col"
-        >
-          {/* 고정 영역 */}
-          <TabsList className="grid w-full grid-cols-2 flex-shrink-0">
-            <TabsTrigger value="SHI" disabled={!shiType}>
-              SHI (Document No.)
-              {!shiType && <AlertTriangle className="ml-2 h-3 w-3" />}
-            </TabsTrigger>
-            <TabsTrigger value="CPY" disabled={!cpyType}>
-              CPY (Project Document No.)
-              {!cpyType && <AlertTriangle className="ml-2 h-3 w-3" />}
-            </TabsTrigger>
-          </TabsList>
-
-          {/* 스크롤 영역 */}
-          <div className="flex-1 min-h-0 mt-4 overflow-y-auto pr-2">
-            <TabsContent
-              value="SHI"
-              className="data-[state=inactive]:hidden"
-            >
-              {shiType ? (
-                <DocumentForm />
-              ) : (
-                <Alert>
-                  <AlertTriangle className="h-4 w-4" />
-                  <AlertDescription>
-                   SHI Document Number Type is not configured.
-                  </AlertDescription>
-                </Alert>
+  return (
+    <Dialog open={open} onOpenChange={onOpenChange}>
+      <DialogContent className="sm:max-w-[800px] max-h-[90vh] flex flex-col overflow-hidden">
+        <DialogHeader className="flex-shrink-0">
+          <DialogTitle>Add New Document</DialogTitle>
+          <DialogDescription>
+            Enter the document information and generate document numbers.
+          </DialogDescription>
+        </DialogHeader>
+
+        {!hasAvailableTypes ? (
+          <div className="flex-1 flex items-center justify-center">
+            <Alert className="max-w-md">
+              <AlertTriangle className="h-4 w-4" />
+              <AlertDescription>
+                Required Document Number Type (SHI, CPY) is not configured. 
+                Please configure it first in the Number Types management.
+              </AlertDescription>
+            </Alert>
+          </div>
+        ) : (
+          <form onSubmit={form.handleSubmit(onSubmit)} className="flex-1 flex flex-col min-h-0">
+            <div className="flex-1 overflow-y-auto pr-2 space-y-4">
+              
+              {/* SHI Document Number Card */}
+              {shiType && (
+                <Card className="border-blue-200 dark:border-blue-800">
+                  <CardHeader className="pb-4">
+                    <CardTitle className="flex items-center gap-2 text-lg">
+                      <FileText className="h-5 w-5 text-blue-600 dark:text-blue-400" />
+                      SHI Document Number
+                    </CardTitle>
+                  </CardHeader>
+                  <CardContent className="space-y-3">
+                    {shiTypeConfigs.length > 0 ? (
+                      <>
+                        <div className="grid gap-3">
+                          {shiTypeConfigs.map((config) => 
+                            renderField(config, 'SHI', shiComboBoxOptions)
+                          )}
+                        </div>
+                        
+                        {/* SHI Preview */}
+                        <div className="mt-3 p-3 bg-blue-50 dark:bg-blue-950/50 border border-blue-200 dark:border-blue-800 rounded">
+                          <Label className="text-xs text-blue-700 dark:text-blue-300">
+                            Document Number Preview:
+                          </Label>
+                          <div className="font-mono text-sm font-medium text-blue-800 dark:text-blue-200 mt-1">
+                            {generateShiPreview()}
+                          </div>
+                        </div>
+                      </>
+                    ) : (
+                      <div className="text-sm text-gray-500">
+                        Loading SHI configuration...
+                      </div>
+                    )}
+                  </CardContent>
+                </Card>
               )}
-            </TabsContent>
 
-            <TabsContent
-              value="CPY"
-              className="data-[state=inactive]:hidden"
-            >
-              {cpyType ? (
-                <DocumentForm />
-              ) : (
-                <Alert>
-                  <AlertTriangle className="h-4 w-4" />
-                  <AlertDescription>
-                   CPY Document Number Type is not configured.
-                  </AlertDescription>
-                </Alert>
+              {/* CPY Project Document Number Card */}
+              {cpyType && (
+                <Card className="border-green-200 dark:border-green-800">
+                  <CardHeader className="pb-4">
+                    <CardTitle className="flex items-center gap-2 text-lg">
+                      <FolderOpen className="h-5 w-5 text-green-600 dark:text-green-400" />
+                      CPY Project Document Number
+                    </CardTitle>
+                  </CardHeader>
+                  <CardContent className="space-y-3">
+                    {cpyTypeConfigs.length > 0 ? (
+                      <>
+                        <div className="grid gap-3">
+                          {cpyTypeConfigs.map((config) => 
+                            renderField(config, 'CPY', cpyComboBoxOptions)
+                          )}
+                        </div>
+                        
+                        {/* CPY Preview */}
+                        <div className="mt-3 p-3 bg-green-50 dark:bg-green-950/50 border border-green-200 dark:border-green-800 rounded">
+                          <Label className="text-xs text-green-700 dark:text-green-300">
+                            Project Document Number Preview:
+                          </Label>
+                          <div className="font-mono text-sm font-medium text-green-800 dark:text-green-200 mt-1">
+                            {generateCpyPreview()}
+                          </div>
+                        </div>
+                      </>
+                    ) : (
+                      <div className="text-sm text-gray-500">
+                        Loading CPY configuration...
+                      </div>
+                    )}
+                  </CardContent>
+                </Card>
               )}
-            </TabsContent>
-          </div>
-        </Tabs>
 
-        <DialogFooter className="flex-shrink-0 border-t pt-4 mt-4">
-          <Button variant="outline" onClick={() => onOpenChange(false)} disabled={isSubmitting}>
-            Cancel
-          </Button>
-          <Button
-            onClick={handleSubmit}
-            disabled={isSubmitting || !isFormValid() || (!shiType && !cpyType)}
-          >
-            {isSubmitting ? <Loader2 className="h-4 w-4 animate-spin mr-2" /> : null}
-            Add Document
-          </Button>
-        </DialogFooter>
-      </>
-    )}
-  </DialogContent>
-</Dialog>
+              {/* Document Class Selection */}
+              <div className="space-y-2">
+                <Label htmlFor="documentClassId">
+                  Document Class <span className="text-red-500">*</span>
+                </Label>
+                <Controller
+                  name="documentClassId"
+                  control={form.control}
+                  render={({ field }) => (
+                    <Select value={field.value} onValueChange={field.onChange}>
+                      <SelectTrigger>
+                        <SelectValue placeholder="Select document class" />
+                      </SelectTrigger>
+                      <SelectContent>
+                        {documentClasses.map((cls) => (
+                          <SelectItem key={cls.id} value={String(cls.id)}>
+                            {cls.value}
+                          </SelectItem>
+                        ))}
+                      </SelectContent>
+                    </Select>
+                  )}
+                />
+                {form.formState.errors.documentClassId && (
+                  <p className="text-xs text-red-500">
+                    {form.formState.errors.documentClassId.message}
+                  </p>
+                )}
+                {documentClassId && (
+                  <p className="text-xs text-gray-600 dark:text-gray-400">
+                    Options from the selected class will be automatically created as stages.
+                  </p>
+                )}
+              </div>
+
+              {/* Document Class Options with Plan Dates */}
+              {documentClassOptions.length > 0 && (
+                <Card>
+                  <CardHeader className="pb-4">
+                    <CardTitle className="text-base">Document Stages with Plan Dates</CardTitle>
+                  </CardHeader>
+                  <CardContent>
+                    <div className="grid gap-3">
+                      {documentClassOptions.map((option) => (
+                        <div key={option.id} className="grid grid-cols-2 gap-3 items-center">
+                          <div>
+                            <Label className="text-sm font-medium">
+                              {option.optionValue}
+                            </Label>
+                            {option.optionCode && (
+                              <p className="text-xs text-gray-500 dark:text-gray-400">
+                                Code: {option.optionCode}
+                              </p>
+                            )}
+                          </div>
+                          <div className="grid gap-1">
+                            <Label className="text-xs text-gray-600 dark:text-gray-400">
+                              Plan Date
+                            </Label>
+                            <Controller
+                              name={`planDates.${option.id}`}
+                              control={form.control}
+                              render={({ field }) => (
+                                <Input
+                                  type="date"
+                                  {...field}
+                                  value={field.value || ''}
+                                  className="text-sm"
+                                />
+                              )}
+                            />
+                          </div>
+                        </div>
+                      ))}
+                    </div>
+                  </CardContent>
+                </Card>
+              )}
+
+              {/* Document Title */}
+              <div className="space-y-2">
+                <Label htmlFor="title">
+                  Document Title <span className="text-red-500">*</span>
+                </Label>
+                <Controller
+                  name="title"
+                  control={form.control}
+                  render={({ field }) => (
+                    <Input
+                      {...field}
+                      id="title"
+                      placeholder="Enter document title"
+                    />
+                  )}
+                />
+                {form.formState.errors.title && (
+                  <p className="text-xs text-red-500">
+                    {form.formState.errors.title.message}
+                  </p>
+                )}
+              </div>
+            </div>
+
+            <DialogFooter className="flex-shrink-0 border-t pt-4 mt-4">
+              <Button 
+                type="button"
+                variant="outline" 
+                onClick={() => onOpenChange(false)} 
+                disabled={form.formState.isSubmitting}
+              >
+                Cancel
+              </Button>
+              <Button
+                type="submit"
+                disabled={
+                  form.formState.isSubmitting || 
+                  !hasAvailableTypes || 
+                  (shiType && !isShiComplete()) ||
+                  (cpyType && !isCpyComplete())
+                }
+              >
+                {form.formState.isSubmitting ? (
+                  <Loader2 className="h-4 w-4 animate-spin mr-2" />
+                ) : null}
+                Add Document
+              </Button>
+            </DialogFooter>
+          </form>
+        )}
+      </DialogContent>
+    </Dialog>
   )
 }
+
+
 // =============================================================================
 // Edit Document Dialog (with improved stage plan date editing)
 // =============================================================================
@@ -690,7 +787,7 @@ export function EditDocumentDialog({
     setIsLoading(true)
     try {
       const result = await updateDocument({
-        documentId: document.id,
+        documentId: document.documentId,
         title: formData.title,
         vendorDocNumber: formData.vendorDocNumber,
         stagePlanDates: formData.stagePlanDates,
@@ -1019,361 +1116,6 @@ export function EditStageDialog({
     </Dialog>
   )
 }
-// =============================================================================
-// 4. Excel Import Dialog
-// =============================================================================
-interface ExcelImportDialogProps {
-  open: boolean
-  onOpenChange: (open: boolean) => void
-  contractId: number
-  projectType: "ship" | "plant"
-}
-
-interface ImportResult {
-  documents: any[]
-  stages: any[]
-  errors: string[]
-  warnings: string[]
-}
-
-export function ExcelImportDialog({
-  open,
-  onOpenChange,
-  contractId,
-  projectType
-}: ExcelImportDialogProps) {
-  const [file, setFile] = React.useState<File | null>(null)
-  const [isProcessing, setIsProcessing] = React.useState(false)
-  const [isDownloadingTemplate, setIsDownloadingTemplate] = React.useState(false)
-  const [importResult, setImportResult] = React.useState<ImportResult | null>(null)
-  const [processStep, setProcessStep] = React.useState<string>("")
-  const [progress, setProgress] = React.useState(0)
-  const router = useRouter()
-
-  const handleFileChange = (e: React.ChangeEvent<HTMLInputElement>) => {
-    const selectedFile = e.target.files?.[0]
-    if (selectedFile) {
-      // 파일 유효성 검사
-      if (!validateFileExtension(selectedFile)) {
-        toast.error("Excel 파일(.xlsx, .xls)만 업로드 가능합니다.")
-        return
-      }
-      
-      if (!validateFileSize(selectedFile, 10)) {
-        toast.error("파일 크기는 10MB 이하여야 합니다.")
-        return
-      }
-      
-      setFile(selectedFile)
-      setImportResult(null)
-    }
-  }
-
-  const validateFileExtension = (file: File): boolean => {
-    const allowedExtensions = ['.xlsx', '.xls']
-    const fileName = file.name.toLowerCase()
-    return allowedExtensions.some(ext => fileName.endsWith(ext))
-  }
-
-  const validateFileSize = (file: File, maxSizeMB: number): boolean => {
-    const maxSizeBytes = maxSizeMB * 1024 * 1024
-    return file.size <= maxSizeBytes
-  }
-
-  // 템플릿 다운로드
-  const handleDownloadTemplate = async () => {
-    setIsDownloadingTemplate(true)
-    try {
-      const workbook = await createImportTemplate(projectType, contractId)
-      const buffer = await workbook.xlsx.writeBuffer()
-      
-      const blob = new Blob([buffer], { 
-        type: 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet' 
-      })
-      
-      const url = window.URL.createObjectURL(blob)
-      const link = document.createElement('a')
-      link.href = url
-      link.download = `문서_임포트_템플릿_${projectType}_${new Date().toISOString().split('T')[0]}.xlsx`
-      link.click()
-      
-      window.URL.revokeObjectURL(url)
-      toast.success("템플릿 파일이 다운로드되었습니다.")
-    } catch (error) {
-      toast.error("템플릿 다운로드 중 오류가 발생했습니다: " + (error instanceof Error ? error.message : "알 수 없는 오류"))
-    } finally {
-      setIsDownloadingTemplate(false)
-    }
-  }
-
-  // 엑셀 파일 처리
-  const handleImport = async () => {
-    if (!file) {
-      toast.error("파일을 선택해주세요.")
-      return
-    }
-
-    setIsProcessing(true)
-    setProgress(0)
-    
-    try {
-      setProcessStep("파일 읽는 중...")
-      setProgress(20)
-      
-      const workbook = new ExcelJS.Workbook()
-      const buffer = await file.arrayBuffer()
-      await workbook.xlsx.load(buffer)
-      
-      setProcessStep("데이터 검증 중...")
-      setProgress(40)
-      
-      // 워크시트 확인
-      const documentsSheet = workbook.getWorksheet('Documents') || workbook.getWorksheet(1)
-      const stagesSheet = workbook.getWorksheet('Stage Plan Dates') || workbook.getWorksheet(2)
-      
-      if (!documentsSheet) {
-        throw new Error("Documents 시트를 찾을 수 없습니다.")
-      }
-      
-      setProcessStep("문서 데이터 파싱 중...")
-      setProgress(60)
-      
-      // 문서 데이터 파싱
-      const documentData = await parseDocumentsSheet(documentsSheet, projectType)
-      
-      setProcessStep("스테이지 데이터 파싱 중...")
-      setProgress(80)
-      
-      // 스테이지 데이터 파싱 (선택사항)
-      let stageData: any[] = []
-      if (stagesSheet) {
-        stageData = await parseStagesSheet(stagesSheet)
-      }
-      
-      setProcessStep("서버에 업로드 중...")
-      setProgress(90)
-      
-      // 서버로 데이터 전송
-      const result = await uploadImportData({
-        contractId,
-        documents: documentData.validData,
-        stages: stageData,
-        projectType
-      })
-      
-      if (result.success) {
-        setImportResult({
-          documents: documentData.validData,
-          stages: stageData,
-          errors: documentData.errors,
-          warnings: result.warnings || []
-        })
-        setProgress(100)
-        toast.success(`${documentData.validData.length}개 문서가 성공적으로 임포트되었습니다.`)
-      } else {
-        throw new Error(result.error || "임포트에 실패했습니다.")
-      }
-      
-    } catch (error) {
-      toast.error(error instanceof Error ? error.message : "임포트 중 오류가 발생했습니다.")
-      setImportResult({
-        documents: [],
-        stages: [],
-        errors: [error instanceof Error ? error.message : "알 수 없는 오류"],
-        warnings: []
-      })
-    } finally {
-      setIsProcessing(false)
-      setProcessStep("")
-      setProgress(0)
-    }
-  }
-
-  const handleClose = () => {
-    setFile(null)
-    setImportResult(null)
-    setProgress(0)
-    setProcessStep("")
-    onOpenChange(false)
-  }
-
-  const handleConfirmImport = () => {
-    // 페이지 새로고침하여 데이터 갱신
-    router.refresh()
-    handleClose()
-  }
-
-  return (
-    <Dialog open={open} onOpenChange={onOpenChange}>
-      <DialogContent className="sm:max-w-[600px] max-h-[90vh] flex flex-col">
-        <DialogHeader className="flex-shrink-0">
-          <DialogTitle>
-            <FileSpreadsheet className="inline w-5 h-5 mr-2" />
-            Excel 파일 임포트
-          </DialogTitle>
-          <DialogDescription>
-            Excel 파일을 사용하여 문서를 일괄 등록합니다.
-          </DialogDescription>
-        </DialogHeader>
-
-        <div className="flex-1 overflow-y-auto pr-2">
-          <div className="grid gap-4 py-4">
-            {/* 템플릿 다운로드 섹션 */}
-            <div className="border rounded-lg p-4 bg-blue-50/30 dark:bg-blue-950/30">
-              <h4 className="font-medium text-blue-800 dark:text-blue-200 mb-2">1. 템플릿 다운로드</h4>
-              <p className="text-sm text-blue-700 dark:text-blue-300 mb-3">
-                올바른 형식과 드롭다운이 적용된 템플릿을 다운로드하세요.
-              </p>
-              <Button 
-                variant="outline" 
-                size="sm"
-                onClick={handleDownloadTemplate}
-                disabled={isDownloadingTemplate}
-              >
-                {isDownloadingTemplate ? (
-                  <Loader2 className="h-4 w-4 animate-spin mr-2" />
-                ) : (
-                  <Download className="h-4 w-4 mr-2" />
-                )}
-                템플릿 다운로드
-              </Button>
-            </div>
-
-            {/* 파일 업로드 섹션 */}
-            <div className="border rounded-lg p-4">
-              <h4 className="font-medium mb-2">2. 파일 업로드</h4>
-              <div className="grid gap-2">
-                <Label htmlFor="excel-file">Excel 파일 선택</Label>
-                <Input
-                  id="excel-file"
-                  type="file"
-                  accept=".xlsx,.xls"
-                  onChange={handleFileChange}
-                  disabled={isProcessing}
-                  className="file:mr-4 file:py-2 file:px-4 file:rounded-full file:border-0 file:text-sm file:font-semibold file:bg-blue-50 file:text-blue-700 hover:file:bg-blue-100"
-                />
-                {file && (
-                  <p className="text-sm text-gray-600 dark:text-gray-400 mt-1">
-                    선택된 파일: {file.name} ({(file.size / 1024 / 1024).toFixed(2)} MB)
-                  </p>
-                )}
-              </div>
-            </div>
-
-            {/* 진행 상태 */}
-            {isProcessing && (
-              <div className="border rounded-lg p-4 bg-yellow-50/30 dark:bg-yellow-950/30">
-                <div className="flex items-center gap-2 mb-2">
-                  <Loader2 className="h-4 w-4 animate-spin text-yellow-600" />
-                  <span className="text-sm font-medium text-yellow-800 dark:text-yellow-200">처리 중...</span>
-                </div>
-                <p className="text-sm text-yellow-700 dark:text-yellow-300 mb-2">{processStep}</p>
-                <Progress value={progress} className="h-2" />
-              </div>
-            )}
-
-            {/* 임포트 결과 */}
-            {importResult && (
-              <div className="space-y-3">
-                {importResult.documents.length > 0 && (
-                  <Alert>
-                    <CheckCircle className="h-4 w-4" />
-                    <AlertDescription>
-                      <strong>{importResult.documents.length}개</strong> 문서가 성공적으로 임포트되었습니다.
-                      {importResult.stages.length > 0 && (
-                        <> ({importResult.stages.length}개 스테이지 계획날짜 포함)</>
-                      )}
-                    </AlertDescription>
-                  </Alert>
-                )}
-                
-                {importResult.warnings.length > 0 && (
-                  <Alert>
-                    <AlertCircle className="h-4 w-4" />
-                    <AlertDescription>
-                      <strong>경고:</strong>
-                      <ul className="mt-1 list-disc list-inside">
-                        {importResult.warnings.map((warning, index) => (
-                          <li key={index} className="text-sm">{warning}</li>
-                        ))}
-                      </ul>
-                    </AlertDescription>
-                  </Alert>
-                )}
-
-                {importResult.errors.length > 0 && (
-                  <Alert variant="destructive">
-                    <AlertCircle className="h-4 w-4" />
-                    <AlertDescription>
-                      <strong>오류:</strong>
-                      <ul className="mt-1 list-disc list-inside">
-                        {importResult.errors.map((error, index) => (
-                          <li key={index} className="text-sm">{error}</li>
-                        ))}
-                      </ul>
-                    </AlertDescription>
-                  </Alert>
-                )}
-              </div>
-            )}
-
-            {/* 파일 형식 가이드 */}
-            <div className="bg-gray-50 dark:bg-gray-900 border border-gray-200 dark:border-gray-700 rounded-lg p-4">
-              <h4 className="font-medium text-gray-800 dark:text-gray-200 mb-2">파일 형식 가이드</h4>
-              <div className="text-sm text-gray-700 dark:text-gray-300 space-y-1">
-                <p><strong>Documents 시트:</strong></p>
-                <ul className="ml-4 list-disc">
-                  <li>Document Number* (문서번호)</li>
-                  <li>Document Name* (문서명)</li>
-                  <li>Document Class* (문서클래스 - 드롭다운 선택)</li>
-                  {projectType === "plant" && (
-                    <li>Project Doc No. (벤더문서번호)</li>
-                  )}
-                </ul>
-                <p className="mt-2"><strong>Stage Plan Dates 시트 (선택사항):</strong></p>
-                <ul className="ml-4 list-disc">
-                  <li>Document Number* (문서번호)</li>
-                  <li>Stage Name* (스테이지명 - 드롭다운 선택, 해당 문서클래스에 맞는 스테이지만 선택)</li>
-                  <li>Plan Date (계획날짜: YYYY-MM-DD)</li>
-                </ul>
-                <p className="mt-2 text-green-600 dark:text-green-400"><strong>스마트 기능:</strong></p>
-                <ul className="ml-4 list-disc text-green-600 dark:text-green-400">
-                  <li>Document Class는 드롭다운으로 정확한 값만 선택 가능</li>
-                  <li>Stage Name도 드롭다운으로 오타 방지</li>
-                  <li>"사용 가이드" 시트에서 각 클래스별 사용 가능한 스테이지 확인 가능</li>
-                </ul>
-                <p className="mt-2 text-red-600 dark:text-red-400">* 필수 항목</p>
-              </div>
-            </div>
-          </div>
-        </div>
-
-        <DialogFooter className="flex-shrink-0">
-          <Button variant="outline" onClick={handleClose}>
-            {importResult ? "닫기" : "취소"}
-          </Button>
-          {!importResult ? (
-            <Button 
-              onClick={handleImport} 
-              disabled={!file || isProcessing}
-            >
-              {isProcessing ? (
-                <Loader2 className="h-4 w-4 animate-spin mr-2" />
-              ) : (
-                <Upload className="h-4 w-4 mr-2" />
-              )}
-              {isProcessing ? "처리 중..." : "임포트 시작"}
-            </Button>
-          ) : importResult.documents.length > 0 ? (
-            <Button onClick={handleConfirmImport}>
-              완료 및 새로고침
-            </Button>
-          ) : null}
-        </DialogFooter>
-      </DialogContent>
-    </Dialog>
-  )
-}
 
 // =============================================================================
 // 5. Delete Documents Confirmation Dialog
@@ -1399,6 +1141,7 @@ export function DeleteDocumentsDialog({
 
   function onDelete() {
     startDeleteTransition(async () => {
+
       const { error } = await deleteDocuments({
         ids: documents.map((document) => document.documentId),
       })
@@ -1500,223 +1243,3 @@ export function DeleteDocumentsDialog({
   )
 }
 
-// =============================================================================
-// Helper Functions for Excel Import
-// =============================================================================
-
-// ExcelJS 컬럼 인덱스를 문자로 변환 (A, B, C, ... Z, AA, AB, ...)
-function getExcelColumnName(index: number): string {
-  let result = ""
-  while (index > 0) {
-    index--
-    result = String.fromCharCode(65 + (index % 26)) + result
-    index = Math.floor(index / 26)
-  }
-  return result
-}
-
-// 헤더 행 스타일링 함수
-function styleHeaderRow(headerRow: ExcelJS.Row, bgColor: string = 'FF4472C4') {
-  headerRow.eachCell((cell) => {
-    cell.fill = {
-      type: 'pattern',
-      pattern: 'solid',
-      fgColor: { argb: bgColor }
-    }
-    cell.font = {
-      color: { argb: 'FFFFFFFF' },
-      bold: true
-    }
-    cell.alignment = {
-      horizontal: 'center',
-      vertical: 'middle'
-    }
-    cell.border = {
-      top: { style: 'thin' },
-      left: { style: 'thin' },
-      bottom: { style: 'thin' },
-      right: { style: 'thin' }
-    }
-    
-    if (String(cell.value).includes('*')) {
-      cell.fill = {
-        type: 'pattern',
-        pattern: 'solid',
-        fgColor: { argb: 'FFE74C3C' }
-      }
-    }
-  })
-}
-
-// 템플릿 생성 함수
-async function createImportTemplate(projectType: "ship" | "plant", contractId: number) {
-  const res = await getDocumentClassOptionsByContract(contractId);
-  if (!res.success) throw new Error(res.error || "데이터 로딩 실패");
-
-  const documentClasses = res.data.classes; // [{id, code, description}]
-  const options = res.data.options; // [{documentClassId, optionValue, ...}]
-
-  // 클래스별 옵션 맵
-  const optionsByClassId = new Map<number, string[]>();
-  for (const c of documentClasses) optionsByClassId.set(c.id, []);
-  for (const o of options) {
-    optionsByClassId.get(o.documentClassId)?.push(o.optionValue);
-  }
-
-  // 모든 스테이지 명 (유니크)
-  const allStageNames = Array.from(new Set(options.map(o => o.optionValue)));
-
-  const workbook = new ExcelJS.Workbook();
-
-  // ================= ReferenceData (hidden) =================
-  const referenceSheet = workbook.addWorksheet("ReferenceData", { state: "hidden" });
-
-  // A열: DocumentClasses
-  referenceSheet.getCell("A1").value = "DocumentClasses";
-  documentClasses.forEach((docClass, i) => {
-    referenceSheet.getCell(`A${i + 2}`).value = `${docClass.description}`;
-  });
-
-  // B열부터: 각 클래스의 Stage 옵션
-  let currentCol = 2; // B
-  for (const docClass of documentClasses) {
-    const colLetter = getExcelColumnName(currentCol);
-    referenceSheet.getCell(`${colLetter}1`).value = docClass.description;
-
-    const list = optionsByClassId.get(docClass.id) ?? [];
-    list.forEach((v, i) => {
-      referenceSheet.getCell(`${colLetter}${i + 2}`).value = v;
-    });
-
-    currentCol++;
-  }
-
-  // 마지막 열: AllStageNames
-  const allStagesCol = getExcelColumnName(currentCol);
-  referenceSheet.getCell(`${allStagesCol}1`).value = "AllStageNames";
-  allStageNames.forEach((v, i) => {
-    referenceSheet.getCell(`${allStagesCol}${i + 2}`).value = v;
-  });
-
-  // ================= Documents =================
-  const documentsSheet = workbook.addWorksheet("Documents");
-  const documentHeaders = [
-    "Document Number*",
-    "Document Name*",
-    "Document Class*",
-    ...(projectType === "plant" ? ["Project Doc No."] : []),
-    "Notes",
-  ];
-  const documentHeaderRow = documentsSheet.addRow(documentHeaders);
-  styleHeaderRow(documentHeaderRow);
-
-  const sampleDocumentData =
-    projectType === "ship"
-      ? [
-          "SH-2024-001",
-          "기본 설계 도면",
-          documentClasses[0]
-            ? `${documentClasses[0].description}`
-            : "",
-          "참고사항",
-        ]
-      : [
-          "PL-2024-001",
-          "공정 설계 도면",
-          documentClasses[0]
-            ? `${documentClasses[0].description}`
-            : "",
-          "V-001",
-          "참고사항",
-        ];
-
-  documentsSheet.addRow(sampleDocumentData);
-
-  // Document Class 드롭다운
-  const docClassColIndex = 3; // C
-  const docClassCol = getExcelColumnName(docClassColIndex);
-  documentsSheet.dataValidations.add(`${docClassCol}2:${docClassCol}1000`, {
-    type: "list",
-    allowBlank: false,
-    formulae: [`ReferenceData!$A$2:$A$${documentClasses.length + 1}`],
-  });
-
-  documentsSheet.columns = [
-    { width: 15 },
-    { width: 25 },
-    { width: 28 },
-    ...(projectType === "plant" ? [{ width: 18 }] : []),
-    { width: 24 },
-  ];
-
-  // ================= Stage Plan Dates =================
-  const stagesSheet = workbook.addWorksheet("Stage Plan Dates");
-  const stageHeaderRow = stagesSheet.addRow(["Document Number*", "Stage Name*", "Plan Date"]);
-  styleHeaderRow(stageHeaderRow, "FF27AE60");
-
-  const firstClass = documentClasses[0];
-  const firstClassOpts = firstClass ? optionsByClassId.get(firstClass.id) ?? [] : [];
-
-  const sampleStageData = [
-    [projectType === "ship" ? "SH-2024-001" : "PL-2024-001", firstClassOpts[0] ?? "", "2024-02-15"],
-    [projectType === "ship" ? "SH-2024-001" : "PL-2024-001", firstClassOpts[1] ?? "", "2024-03-01"],
-  ];
-
-  sampleStageData.forEach(row => {
-    const r = stagesSheet.addRow(row);
-    r.getCell(3).numFmt = "yyyy-mm-dd";
-  });
-
-  // Stage Name 드롭다운 (전체)
-  stagesSheet.dataValidations.add("B2:B1000", {
-    type: "list",
-    allowBlank: false,
-    formulae: [`ReferenceData!$${allStagesCol}$2:$${allStagesCol}$${allStageNames.length + 1}`],
-    promptTitle: "Stage Name 선택",
-    prompt: "Document의 Document Class에 해당하는 Stage Name을 선택하세요.",
-  });
-
-  stagesSheet.columns = [{ width: 15 }, { width: 30 }, { width: 12 }];
-
-  // ================= 사용 가이드 =================
-  const guideSheet = workbook.addWorksheet("사용 가이드");
-  const guideContent: (string[])[] = [
-    ["문서 임포트 가이드"],
-    [""],
-    ["1. Documents 시트"],
-    ["   - Document Number*: 고유한 문서 번호를 입력하세요"],
-    ["   - Document Name*: 문서명을 입력하세요"],
-    ["   - Document Class*: 드롭다운에서 문서 클래스를 선택하세요"],
-    ["   - Project Doc No.: 벤더 문서 번호"],
-    ["   - Notes: 참고사항"],
-    [""],
-    ["2. Stage Plan Dates 시트 (선택사항)"],
-    ["   - Document Number*: Documents 시트의 Document Number와 일치해야 합니다"],
-    ["   - Stage Name*: 드롭다운에서 해당 문서 클래스에 맞는 스테이지명을 선택하세요"],
-    ["   - Plan Date: 계획 날짜 (YYYY-MM-DD 형식)"],
-    [""],
-    ["3. 주의사항"],
-    ["   - * 표시는 필수 항목입니다"],
-    ["   - Document Number는 고유해야 합니다"],
-    ["   - Stage Name은 해당 Document의 Document Class에 속한 것만 유효합니다"],
-    ["   - 날짜는 YYYY-MM-DD 형식으로 입력하세요"],
-    [""],
-    ["4. Document Class별 사용 가능한 Stage Names"],
-    [""],
-  ];
-
-  for (const c of documentClasses) {
-    guideContent.push([`${c.code} - ${c.description}:`]);
-    (optionsByClassId.get(c.id) ?? []).forEach(v => guideContent.push([`   • ${v}`]));
-    guideContent.push([""]);
-  }
-
-  guideContent.forEach((row, i) => {
-    const r = guideSheet.addRow(row);
-    if (i === 0) r.getCell(1).font = { bold: true, size: 14 };
-    else if (row[0] && row[0].includes(":") && !row[0].startsWith("   ")) r.getCell(1).font = { bold: true };
-  });
-  guideSheet.getColumn(1).width = 60;
-
-  return workbook;
-}
\ No newline at end of file
diff --git a/lib/vendor-document-list/plant/document-stage-toolbar.tsx b/lib/vendor-document-list/plant/document-stage-toolbar.tsx
index ccb9e15c..f676e1fc 100644
--- a/lib/vendor-document-list/plant/document-stage-toolbar.tsx
+++ b/lib/vendor-document-list/plant/document-stage-toolbar.tsx
@@ -12,13 +12,13 @@ import { Button } from "@/components/ui/button"
 import {
   DeleteDocumentsDialog,
   AddDocumentDialog,
-  ExcelImportDialog
 } from "./document-stage-dialogs"
 import { sendDocumentsToSHI } from "./document-stages-service"
 import { useDocumentPolling } from "@/hooks/use-document-polling"
 import { cn } from "@/lib/utils"
 import { MultiUploadDialog } from "./upload/components/multi-upload-dialog"
 import { useRouter } from "next/navigation"
+import { ExcelImportDialog } from "./excel-import-stage"
 
 // 서버 액션 import (필요한 경우)
 // import { importDocumentsExcel } from "./document-stages-service"
diff --git a/lib/vendor-document-list/plant/document-stages-columns.tsx b/lib/vendor-document-list/plant/document-stages-columns.tsx
index 0b85c3f8..d71ecc0f 100644
--- a/lib/vendor-document-list/plant/document-stages-columns.tsx
+++ b/lib/vendor-document-list/plant/document-stages-columns.tsx
@@ -347,166 +347,166 @@ export function getDocumentStagesColumns({
       },
     },
 
-    {
-      accessorKey: "buyerSystemStatus",
-      header: ({ column }) => (
-        <DataTableColumnHeaderSimple column={column} title="SHI Status" />
-      ),
-      cell: ({ row }) => {
-        const doc = row.original
-        const getBuyerStatusBadge = () => {
-          if (!doc.buyerSystemStatus) {
-            return <Badge variant="outline">Not Recieved</Badge>
-          }
+    // {
+    //   accessorKey: "buyerSystemStatus",
+    //   header: ({ column }) => (
+    //     <DataTableColumnHeaderSimple column={column} title="SHI Status" />
+    //   ),
+    //   cell: ({ row }) => {
+    //     const doc = row.original
+    //     const getBuyerStatusBadge = () => {
+    //       if (!doc.buyerSystemStatus) {
+    //         return <Badge variant="outline">Not Recieved</Badge>
+    //       }
           
-          switch (doc.buyerSystemStatus) {
-            case '승인(DC)':
-              return <Badge variant="success">Approved</Badge>
-            case '검토중':
-              return <Badge variant="default">검토중</Badge>
-            case '반려':
-              return <Badge variant="destructive">반려</Badge>
-            default:
-              return <Badge variant="secondary">{doc.buyerSystemStatus}</Badge>
-          }
-        }
+    //       switch (doc.buyerSystemStatus) {
+    //         case '승인(DC)':
+    //           return <Badge variant="success">Approved</Badge>
+    //         case '검토중':
+    //           return <Badge variant="default">검토중</Badge>
+    //         case '반려':
+    //           return <Badge variant="destructive">반려</Badge>
+    //         default:
+    //           return <Badge variant="secondary">{doc.buyerSystemStatus}</Badge>
+    //       }
+    //     }
         
-        return (
-          <div className="flex flex-col gap-1">
-            {getBuyerStatusBadge()}
-            {doc.buyerSystemComment && (
-              <Tooltip>
-                <TooltipTrigger>
-                  <MessageSquare className="h-3 w-3 text-muted-foreground" />
-                </TooltipTrigger>
-                <TooltipContent>
-                  <p className="max-w-xs">{doc.buyerSystemComment}</p>
-                </TooltipContent>
-              </Tooltip>
-            )}
-          </div>
-        )
-      },
-      size: 120,
-    },
-    {
-      accessorKey: "currentStageName",
-      header: ({ column }) => (
-        <DataTableColumnHeaderSimple column={column} title="Current Stage" />
-      ),
-      cell: ({ row }) => {
-        const doc = row.original
-        // if (!doc.currentStageName) {
-        //   return (
-        //     <Button
-        //       size="sm"
-        //       variant="outline"
-        //       onClick={(e) => {
-        //         e.stopPropagation()
-        //         setRowAction({ row, type: "add_stage" })
-        //       }}
-        //       className="h-6 text-xs"
-        //     >
-        //       <Plus className="w-3 h-3 mr-1" />
-        //       Add stage
-        //     </Button>
-        //   )
-        // }
-
-        return (
-          <div className="flex items-center gap-2">
-            <span className="text-sm font-medium truncate" title={doc.currentStageName}>
-              {doc.currentStageName}
-            </span>
-            <Badge
-              variant={getStatusColor(doc.currentStageStatus || '', doc.isOverdue || false)}
-              className="text-xs px-1.5 py-0"
-            >
-              {getStatusText(doc.currentStageStatus || '')}
-            </Badge>
-            {doc.currentStageAssigneeName && (
-              <span className="text-xs text-gray-500 dark:text-gray-400 flex items-center gap-1">
-                <User className="w-3 h-3" />
-                {doc.currentStageAssigneeName}
-              </span>
-            )}
-          </div>
-        )
-      },
-      size: 180,
-      enableResizing: true,
-      meta: {
-        excelHeader: "Current Stage"
-      },
-    },
-
-    // 계획 일정 (한 줄)
-    {
-      accessorKey: "currentStagePlanDate",
-      header: ({ column }) => (
-        <DataTableColumnHeaderSimple column={column} title="Plan Date" />
-      ),
-      cell: ({ row }) => {
-        const doc = row.original
-        if (!doc.currentStagePlanDate) return <span className="text-gray-400 dark:text-gray-500">-</span>
-
-        return (
-          <div className="flex items-center gap-2">
-            <span className="text-sm">{formatDate(doc.currentStagePlanDate)}</span>
-            <DueDateInfo
-              daysUntilDue={doc.daysUntilDue}
-              isOverdue={doc.isOverdue || false}
-            />
-          </div>
-        )
-      },
-      size: 150,
-      enableResizing: true,
-      meta: {
-        excelHeader: "Plan Date"
-      },
-    },
-
-    // 우선순위 + 진행률 (콤팩트)
-    {
-      accessorKey: "progressPercentage",
-      header: ({ column }) => (
-        <DataTableColumnHeaderSimple column={column} title="Priority/Progress" />
-      ),
-      cell: ({ row }) => {
-        const doc = row.original
-        const progress = doc.progressPercentage || 0
-        const completed = doc.completedStages || 0
-        const total = doc.totalStages || 0
-
-        return (
-          <div className="flex items-center gap-2">
-            {doc.currentStagePriority && (
-              <Badge
-                variant={getPriorityColor(doc.currentStagePriority)}
-                className="text-xs px-1.5 py-0"
-              >
-                {getPriorityText(doc.currentStagePriority)}
-              </Badge>
-            )}
-            <div className="flex items-center gap-1">
-              <Progress value={progress} className="w-12 h-1.5" />
-              <span className="text-xs text-gray-600 dark:text-gray-400 min-w-[2rem]">
-                {progress}%
-              </span>
-            </div>
-            <span className="text-xs text-gray-500 dark:text-gray-400">
-              ({completed}/{total})
-            </span>
-          </div>
-        )
-      },
-      size: 140,
-      enableResizing: true,
-      meta: {
-        excelHeader: "Progress"
-      },
-    },
+    //     return (
+    //       <div className="flex flex-col gap-1">
+    //         {getBuyerStatusBadge()}
+    //         {doc.buyerSystemComment && (
+    //           <Tooltip>
+    //             <TooltipTrigger>
+    //               <MessageSquare className="h-3 w-3 text-muted-foreground" />
+    //             </TooltipTrigger>
+    //             <TooltipContent>
+    //               <p className="max-w-xs">{doc.buyerSystemComment}</p>
+    //             </TooltipContent>
+    //           </Tooltip>
+    //         )}
+    //       </div>
+    //     )
+    //   },
+    //   size: 120,
+    // },
+    // {
+    //   accessorKey: "currentStageName",
+    //   header: ({ column }) => (
+    //     <DataTableColumnHeaderSimple column={column} title="Current Stage" />
+    //   ),
+    //   cell: ({ row }) => {
+    //     const doc = row.original
+    //     // if (!doc.currentStageName) {
+    //     //   return (
+    //     //     <Button
+    //     //       size="sm"
+    //     //       variant="outline"
+    //     //       onClick={(e) => {
+    //     //         e.stopPropagation()
+    //     //         setRowAction({ row, type: "add_stage" })
+    //     //       }}
+    //     //       className="h-6 text-xs"
+    //     //     >
+    //     //       <Plus className="w-3 h-3 mr-1" />
+    //     //       Add stage
+    //     //     </Button>
+    //     //   )
+    //     // }
+
+    //     return (
+    //       <div className="flex items-center gap-2">
+    //         <span className="text-sm font-medium truncate" title={doc.currentStageName}>
+    //           {doc.currentStageName}
+    //         </span>
+    //         <Badge
+    //           variant={getStatusColor(doc.currentStageStatus || '', doc.isOverdue || false)}
+    //           className="text-xs px-1.5 py-0"
+    //         >
+    //           {getStatusText(doc.currentStageStatus || '')}
+    //         </Badge>
+    //         {doc.currentStageAssigneeName && (
+    //           <span className="text-xs text-gray-500 dark:text-gray-400 flex items-center gap-1">
+    //             <User className="w-3 h-3" />
+    //             {doc.currentStageAssigneeName}
+    //           </span>
+    //         )}
+    //       </div>
+    //     )
+    //   },
+    //   size: 180,
+    //   enableResizing: true,
+    //   meta: {
+    //     excelHeader: "Current Stage"
+    //   },
+    // },
+
+    // // 계획 일정 (한 줄)
+    // {
+    //   accessorKey: "currentStagePlanDate",
+    //   header: ({ column }) => (
+    //     <DataTableColumnHeaderSimple column={column} title="Plan Date" />
+    //   ),
+    //   cell: ({ row }) => {
+    //     const doc = row.original
+    //     if (!doc.currentStagePlanDate) return <span className="text-gray-400 dark:text-gray-500">-</span>
+
+    //     return (
+    //       <div className="flex items-center gap-2">
+    //         <span className="text-sm">{formatDate(doc.currentStagePlanDate)}</span>
+    //         <DueDateInfo
+    //           daysUntilDue={doc.daysUntilDue}
+    //           isOverdue={doc.isOverdue || false}
+    //         />
+    //       </div>
+    //     )
+    //   },
+    //   size: 150,
+    //   enableResizing: true,
+    //   meta: {
+    //     excelHeader: "Plan Date"
+    //   },
+    // },
+
+    // // 우선순위 + 진행률 (콤팩트)
+    // {
+    //   accessorKey: "progressPercentage",
+    //   header: ({ column }) => (
+    //     <DataTableColumnHeaderSimple column={column} title="Priority/Progress" />
+    //   ),
+    //   cell: ({ row }) => {
+    //     const doc = row.original
+    //     const progress = doc.progressPercentage || 0
+    //     const completed = doc.completedStages || 0
+    //     const total = doc.totalStages || 0
+
+    //     return (
+    //       <div className="flex items-center gap-2">
+    //         {doc.currentStagePriority && (
+    //           <Badge
+    //             variant={getPriorityColor(doc.currentStagePriority)}
+    //             className="text-xs px-1.5 py-0"
+    //           >
+    //             {getPriorityText(doc.currentStagePriority)}
+    //           </Badge>
+    //         )}
+    //         <div className="flex items-center gap-1">
+    //           <Progress value={progress} className="w-12 h-1.5" />
+    //           <span className="text-xs text-gray-600 dark:text-gray-400 min-w-[2rem]">
+    //             {progress}%
+    //           </span>
+    //         </div>
+    //         <span className="text-xs text-gray-500 dark:text-gray-400">
+    //           ({completed}/{total})
+    //         </span>
+    //       </div>
+    //     )
+    //   },
+    //   size: 140,
+    //   enableResizing: true,
+    //   meta: {
+    //     excelHeader: "Progress"
+    //   },
+    // },
 
     // 업데이트 일시
     {
diff --git a/lib/vendor-document-list/plant/document-stages-service.ts b/lib/vendor-document-list/plant/document-stages-service.ts
index 2c65b4e6..77a03aae 100644
--- a/lib/vendor-document-list/plant/document-stages-service.ts
+++ b/lib/vendor-document-list/plant/document-stages-service.ts
@@ -4,7 +4,7 @@
 import { revalidatePath, revalidateTag } from "next/cache"
 import { redirect } from "next/navigation"
 import db from "@/db/db"
-import {stageSubmissionView, codeGroups, comboBoxSettings, contracts, documentClassOptions, documentClasses, documentNumberTypeConfigs, documentNumberTypes, documentStagesOnlyView, documents, issueStages, stageDocuments, stageDocumentsView, stageIssueStages } from "@/db/schema"
+import { stageSubmissionView, codeGroups, comboBoxSettings, contracts, documentClassOptions, documentClasses, documentNumberTypeConfigs, documentNumberTypes, documentStagesOnlyView, documents, stageIssueStages, stageDocuments, stageDocumentsView } from "@/db/schema"
 import { and, eq, asc, desc, sql, inArray, max, ne, or, ilike } from "drizzle-orm"
 import {
   createDocumentSchema,
@@ -33,6 +33,7 @@ import { countDocumentStagesOnly, selectDocumentStagesOnly } from "../repository
 import { getServerSession } from "next-auth"
 import { authOptions } from "@/app/api/auth/[...nextauth]/route"
 import { ShiBuyerSystemAPI } from "./shi-buyer-system-api"
+import ExcelJS from 'exceljs'
 
 interface UpdateDocumentData {
   documentId: number
@@ -47,13 +48,13 @@ export async function updateDocument(data: UpdateDocumentData) {
   try {
     // 1. 문서 기본 정보 업데이트
     const [updatedDocument] = await db
-      .update(documents)
+      .update(stageDocuments)
       .set({
         title: data.title,
         vendorDocNumber: data.vendorDocNumber || null,
         updatedAt: new Date(),
       })
-      .where(eq(documents.id, data.documentId))
+      .where(eq(stageDocuments.id, data.documentId))
       .returning()
 
     if (!updatedDocument) {
@@ -63,12 +64,12 @@ export async function updateDocument(data: UpdateDocumentData) {
     // 2. 스테이지들의 plan date 업데이트
     const stageUpdatePromises = Object.entries(data.stagePlanDates).map(([stageId, planDate]) => {
       return db
-        .update(issueStages)
+        .update(stageIssueStages)
         .set({
           planDate: planDate || null,
           updatedAt: new Date(),
         })
-        .where(eq(issueStages.id, Number(stageId)))
+        .where(eq(stageIssueStages.id, Number(stageId)))
     })
 
     await Promise.all(stageUpdatePromises)
@@ -93,8 +94,8 @@ export async function deleteDocument(input: { id: number }) {
     const validatedData = deleteDocumentSchema.parse(input)
 
     // 문서 존재 확인
-    const existingDoc = await db.query.documents.findFirst({
-      where: eq(documents.id, validatedData.id)
+    const existingDoc = await db.query.stageDocuments.findFirst({
+      where: eq(stageDocuments.id, validatedData.id)
     })
 
     if (!existingDoc) {
@@ -102,8 +103,8 @@ export async function deleteDocument(input: { id: number }) {
     }
 
     // 연관된 스테이지 확인
-    const relatedStages = await db.query.issueStages.findMany({
-      where: eq(issueStages.documentId, validatedData.id)
+    const relatedStages = await db.query.stageIssueStages.findMany({
+      where: eq(stageIssueStages.documentId, validatedData.id)
     })
 
     if (relatedStages.length > 0) {
@@ -112,16 +113,12 @@ export async function deleteDocument(input: { id: number }) {
 
     // 소프트 삭제 (상태 변경)
     await db
-      .update(documents)
+      .update(stageDocuments)
       .set({
         status: "DELETED",
         updatedAt: new Date(),
       })
-      .where(eq(documents.id, validatedData.id))
-
-    // 캐시 무효화
-    revalidateTag(`documents-${existingDoc.contractId}`)
-    revalidatePath(`/contracts/${existingDoc.contractId}/documents`)
+      .where(eq(stageDocuments.id, validatedData.id))
 
     return {
       success: true,
@@ -143,16 +140,17 @@ interface DeleteDocumentsData {
 
 export async function deleteDocuments(data: DeleteDocumentsData) {
   try {
+
     if (data.ids.length === 0) {
       return { success: false, error: "삭제할 문서가 선택되지 않았습니다." }
     }
 
     /* 1. 요청한 문서가 존재하는지 확인 ------------------------------------ */
     const existingDocs = await db
-      .select({ id: documents.id, docNumber: documents.docNumber })
-      .from(documents)
+      .select({ id: stageDocuments.id, docNumber: stageDocuments.docNumber })
+      .from(stageDocuments)
       .where(and(
-        inArray(documents.id, data.ids),
+        inArray(stageDocuments.id, data.ids),
       ))
 
     if (existingDocs.length === 0) {
@@ -168,9 +166,9 @@ export async function deleteDocuments(data: DeleteDocumentsData) {
 
     /* 2. 연관 스테이지 건수 파악(로그·메시지용) --------------------------- */
     const relatedStages = await db
-      .select({ documentId: issueStages.documentId })
-      .from(issueStages)
-      .where(inArray(issueStages.documentId, data.ids))
+      .select({ documentId: stageIssueStages.documentId })
+      .from(stageIssueStages)
+      .where(inArray(stageIssueStages.documentId, data.ids))
 
     const stagesToDelete = relatedStages.length
 
@@ -178,17 +176,17 @@ export async function deleteDocuments(data: DeleteDocumentsData) {
     // ─> FK에 ON DELETE CASCADE 가 있다면 생략 가능.
     if (stagesToDelete > 0) {
       await db
-        .delete(issueStages)
-        .where(inArray(issueStages.documentId, data.ids))
+        .delete(stageIssueStages)
+        .where(inArray(stageIssueStages.documentId, data.ids))
     }
 
     /* 4. 문서 하드 삭제 --------------------------------------------------- */
     const deletedDocs = await db
-      .delete(documents)
+      .delete(stageDocuments)
       .where(and(
-        inArray(documents.id, data.ids),
+        inArray(stageDocuments.id, data.ids),
       ))
-      .returning({ id: documents.id, docNumber: documents.docNumber })
+      .returning({ id: stageDocuments.id, docNumber: stageDocuments.docNumber })
 
     /* 5. 캐시 무효화 ------------------------------------------------------ */
 
@@ -225,8 +223,8 @@ export async function createStage(input: CreateStageInput) {
     const validatedData = createStageSchema.parse(input)
 
     // 문서 존재 확인
-    const document = await db.query.documents.findFirst({
-      where: eq(documents.id, validatedData.documentId)
+    const document = await db.query.stageDocuments.findFirst({
+      where: eq(stageDocuments.id, validatedData.documentId)
     })
 
     if (!document) {
@@ -234,10 +232,10 @@ export async function createStage(input: CreateStageInput) {
     }
 
     // 스테이지명 중복 검사
-    const existingStage = await db.query.issueStages.findFirst({
+    const existingStage = await db.query.stageIssueStages.findFirst({
       where: and(
-        eq(issueStages.documentId, validatedData.documentId),
-        eq(issueStages.stageName, validatedData.stageName)
+        eq(stageIssueStages.documentId, validatedData.documentId),
+        eq(stageIssueStages.stageName, validatedData.stageName)
       )
     })
 
@@ -249,15 +247,15 @@ export async function createStage(input: CreateStageInput) {
     let stageOrder = validatedData.stageOrder
     if (stageOrder === 0 || stageOrder === undefined) {
       const maxOrderResult = await db
-        .select({ maxOrder: max(issueStages.stageOrder) })
-        .from(issueStages)
-        .where(eq(issueStages.documentId, validatedData.documentId))
+        .select({ maxOrder: max(stageIssueStages.stageOrder) })
+        .from(stageIssueStages)
+        .where(eq(stageIssueStages.documentId, validatedData.documentId))
 
       stageOrder = (maxOrderResult[0]?.maxOrder ?? -1) + 1
     }
 
     // 스테이지 생성
-    const [newStage] = await db.insert(issueStages).values({
+    const [newStage] = await db.insert(stageIssueStages).values({
       documentId: validatedData.documentId,
       stageName: validatedData.stageName,
       planDate: validatedData.planDate || null,
@@ -273,10 +271,6 @@ export async function createStage(input: CreateStageInput) {
       updatedAt: new Date(),
     }).returning()
 
-    // 캐시 무효화
-    revalidateTag(`documents-${document.contractId}`)
-    revalidateTag(`document-${validatedData.documentId}`)
-    revalidatePath(`/contracts/${document.contractId}/documents`)
 
     return {
       success: true,
@@ -301,8 +295,8 @@ export async function updateStage(input: UpdateStageInput) {
     const validatedData = updateStageSchema.parse(input)
 
     // 스테이지 존재 확인
-    const existingStage = await db.query.issueStages.findFirst({
-      where: eq(issueStages.id, validatedData.id),
+    const existingStage = await db.query.stageIssueStages.findFirst({
+      where: eq(stageIssueStages.id, validatedData.id),
       with: {
         document: true
       }
@@ -314,10 +308,10 @@ export async function updateStage(input: UpdateStageInput) {
 
     // 스테이지명 중복 검사 (스테이지명 변경 시)
     if (validatedData.stageName && validatedData.stageName !== existingStage.stageName) {
-      const duplicateStage = await db.query.issueStages.findFirst({
+      const duplicateStage = await db.query.stageIssueStages.findFirst({
         where: and(
-          eq(issueStages.documentId, existingStage.documentId),
-          eq(issueStages.stageName, validatedData.stageName)
+          eq(stageIssueStages.documentId, existingStage.documentId),
+          eq(stageIssueStages.stageName, validatedData.stageName)
         )
       })
 
@@ -328,18 +322,14 @@ export async function updateStage(input: UpdateStageInput) {
 
     // 스테이지 업데이트
     const [updatedStage] = await db
-      .update(issueStages)
+      .update(stageIssueStages)
       .set({
         ...validatedData,
         updatedAt: new Date(),
       })
-      .where(eq(issueStages.id, validatedData.id))
+      .where(eq(stageIssueStages.id, validatedData.id))
       .returning()
 
-    // 캐시 무효화
-    revalidateTag(`documents-${existingStage.document.contractId}`)
-    revalidateTag(`document-${existingStage.documentId}`)
-    revalidatePath(`/contracts/${existingStage.document.contractId}/documents`)
 
     return {
       success: true,
@@ -364,8 +354,8 @@ export async function deleteStage(input: { id: number }) {
     const validatedData = deleteStageSchema.parse(input)
 
     // 스테이지 존재 확인
-    const existingStage = await db.query.issueStages.findFirst({
-      where: eq(issueStages.id, validatedData.id),
+    const existingStage = await db.query.stageIssueStages.findFirst({
+      where: eq(stageIssueStages.id, validatedData.id),
       with: {
         document: true
       }
@@ -385,28 +375,23 @@ export async function deleteStage(input: { id: number }) {
     // }
 
     // 스테이지 삭제
-    await db.delete(issueStages).where(eq(issueStages.id, validatedData.id))
+    await db.delete(stageIssueStages).where(eq(stageIssueStages.id, validatedData.id))
 
     // 스테이지 순서 재정렬
-    const remainingStages = await db.query.issueStages.findMany({
-      where: eq(issueStages.documentId, existingStage.documentId),
-      orderBy: [issueStages.stageOrder]
+    const remainingStages = await db.query.stageIssueStages.findMany({
+      where: eq(stageIssueStages.documentId, existingStage.documentId),
+      orderBy: [stageIssueStages.stageOrder]
     })
 
     for (let i = 0; i < remainingStages.length; i++) {
       if (remainingStages[i].stageOrder !== i) {
         await db
-          .update(issueStages)
+          .update(stageIssueStages)
           .set({ stageOrder: i, updatedAt: new Date() })
-          .where(eq(issueStages.id, remainingStages[i].id))
+          .where(eq(stageIssueStages.id, remainingStages[i].id))
       }
     }
 
-    // 캐시 무효화
-    revalidateTag(`documents-${existingStage.document.contractId}`)
-    revalidateTag(`document-${existingStage.documentId}`)
-    revalidatePath(`/contracts/${existingStage.document.contractId}/documents`)
-
     return {
       success: true,
       message: "스테이지가 성공적으로 삭제되었습니다"
@@ -432,8 +417,8 @@ export async function reorderStages(input: any) {
     validateStageOrder(validatedData.stages)
 
     // 문서 존재 확인
-    const document = await db.query.documents.findFirst({
-      where: eq(documents.id, validatedData.documentId)
+    const document = await db.query.stageDocuments.findFirst({
+      where: eq(stageDocuments.id, validatedData.documentId)
     })
 
     if (!document) {
@@ -442,10 +427,10 @@ export async function reorderStages(input: any) {
 
     // 스테이지들이 해당 문서에 속하는지 확인
     const stageIds = validatedData.stages.map(s => s.id)
-    const existingStages = await db.query.issueStages.findMany({
+    const existingStages = await db.query.stageIssueStages.findMany({
       where: and(
-        eq(issueStages.documentId, validatedData.documentId),
-        inArray(issueStages.id, stageIds)
+        eq(stageIssueStages.documentId, validatedData.documentId),
+        inArray(stageIssueStages.id, stageIds)
       )
     })
 
@@ -457,19 +442,15 @@ export async function reorderStages(input: any) {
     await db.transaction(async (tx) => {
       for (const stage of validatedData.stages) {
         await tx
-          .update(issueStages)
+          .update(stageIssueStages)
           .set({
             stageOrder: stage.stageOrder,
             updatedAt: new Date()
           })
-          .where(eq(issueStages.id, stage.id))
+          .where(eq(stageIssueStages.id, stage.id))
       }
     })
 
-    // 캐시 무효화
-    revalidateTag(`documents-${document.contractId}`)
-    revalidateTag(`document-${validatedData.documentId}`)
-    revalidatePath(`/contracts/${document.contractId}/documents`)
 
     return {
       success: true,
@@ -497,7 +478,7 @@ export async function bulkCreateDocuments(input: any): Promise<ExcelImportResult
     const validatedData = bulkCreateDocumentsSchema.parse(input)
 
     const result: ExcelImportResult = {
-      totalRows: validatedData.documents.length,
+      totalRows: validatedData.stageDocuments.length,
       successCount: 0,
       failureCount: 0,
       errors: [],
@@ -506,16 +487,15 @@ export async function bulkCreateDocuments(input: any): Promise<ExcelImportResult
 
     // 트랜잭션으로 일괄 처리
     await db.transaction(async (tx) => {
-      for (let i = 0; i < validatedData.documents.length; i++) {
-        const docData = validatedData.documents[i]
+      for (let i = 0; i < validatedData.stageDocuments.length; i++) {
+        const docData = validatedData.stageDocuments[i]
 
         try {
           // 문서번호 중복 검사
-          const existingDoc = await tx.query.documents.findFirst({
+          const existingDoc = await tx.query.stageDocuments.findFirst({
             where: and(
-              eq(documents.contractId, validatedData.contractId),
-              eq(documents.docNumber, docData.docNumber),
-              eq(documents.status, "ACTIVE")
+              eq(stageDocuments.docNumber, docData.docNumber),
+              eq(stageDocuments.status, "ACTIVE")
             )
           })
 
@@ -530,7 +510,7 @@ export async function bulkCreateDocuments(input: any): Promise<ExcelImportResult
           }
 
           // 문서 생성
-          const [newDoc] = await tx.insert(documents).values({
+          const [newDoc] = await tx.insert(stageDocuments).values({
             contractId: validatedData.contractId,
             docNumber: docData.docNumber,
             title: docData.title,
@@ -566,9 +546,6 @@ export async function bulkCreateDocuments(input: any): Promise<ExcelImportResult
       }
     })
 
-    // 캐시 무효화
-    revalidateTag(`documents-${validatedData.contractId}`)
-    revalidatePath(`/contracts/${validatedData.contractId}/documents`)
 
     return result
 
@@ -586,8 +563,8 @@ export async function bulkUpdateStageStatus(input: any) {
     const validatedData = bulkUpdateStatusSchema.parse(input)
 
     // 스테이지들 존재 확인
-    const existingStages = await db.query.issueStages.findMany({
-      where: inArray(issueStages.id, validatedData.stageIds),
+    const existingStages = await db.query.stageIssueStages.findMany({
+      where: inArray(stageIssueStages.id, validatedData.stageIds),
       with: { document: true }
     })
 
@@ -597,20 +574,15 @@ export async function bulkUpdateStageStatus(input: any) {
 
     // 일괄 업데이트
     await db
-      .update(issueStages)
+      .update(stageIssueStages)
       .set({
         stageStatus: validatedData.status,
         actualDate: validatedData.actualDate || null,
         updatedAt: new Date()
       })
-      .where(inArray(issueStages.id, validatedData.stageIds))
+      .where(inArray(stageIssueStages.id, validatedData.stageIds))
 
     // 관련된 계약들의 캐시 무효화
-    const contractIds = [...new Set(existingStages.map(s => s.document.contractId))]
-    for (const contractId of contractIds) {
-      revalidateTag(`documents-${contractId}`)
-      revalidatePath(`/contracts/${contractId}/documents`)
-    }
 
     return {
       success: true,
@@ -634,8 +606,8 @@ export async function bulkAssignStages(input: any) {
     const validatedData = bulkAssignSchema.parse(input)
 
     // 스테이지들 존재 확인
-    const existingStages = await db.query.issueStages.findMany({
-      where: inArray(issueStages.id, validatedData.stageIds),
+    const existingStages = await db.query.stageIssueStages.findMany({
+      where: inArray(stageIssueStages.id, validatedData.stageIds),
       with: { document: true }
     })
 
@@ -645,20 +617,14 @@ export async function bulkAssignStages(input: any) {
 
     // 일괄 담당자 지정
     await db
-      .update(issueStages)
+      .update(stageIssueStages)
       .set({
         assigneeId: validatedData.assigneeId || null,
         assigneeName: validatedData.assigneeName || null,
         updatedAt: new Date()
       })
-      .where(inArray(issueStages.id, validatedData.stageIds))
+      .where(inArray(stageIssueStages.id, validatedData.stageIds))
 
-    // 관련된 계약들의 캐시 무효화
-    const contractIds = [...new Set(existingStages.map(s => s.document.contractId))]
-    for (const contractId of contractIds) {
-      revalidateTag(`documents-${contractId}`)
-      revalidatePath(`/contracts/${contractId}/documents`)
-    }
 
     return {
       success: true,
@@ -689,12 +655,12 @@ export async function getDocumentNumberTypes(contractId: number) {
       }
     }
 
-    console.log(project,"project")
+    console.log(project, "project")
 
     const types = await db
       .select()
       .from(documentNumberTypes)
-      .where(and (eq(documentNumberTypes.isActive, true), eq(documentNumberTypes.projectId,project.projectId)))
+      .where(and(eq(documentNumberTypes.isActive, true), eq(documentNumberTypes.projectId, project.projectId)))
       .orderBy(asc(documentNumberTypes.name))
 
     return { success: true, data: types }
@@ -735,7 +701,7 @@ export async function getDocumentNumberTypeConfigs(documentNumberTypeId: number)
       .where(
         and(
           eq(documentNumberTypeConfigs.documentNumberTypeId, documentNumberTypeId),
-          eq(documentNumberTypeConfigs.isActive, true), 
+          eq(documentNumberTypeConfigs.isActive, true),
           // eq(documentNumberTypeConfigs.projectId, project.projectId)
         )
       )
@@ -772,9 +738,9 @@ export async function getComboBoxOptions(codeGroupId: number) {
 }
 
 // 문서 클래스 목록 조회
-export async function getDocumentClasses(contractId:number) {
+export async function getDocumentClasses(contractId: number) {
   try {
-        const projectId = await db.query.contracts.findFirst({
+    const projectId = await db.query.contracts.findFirst({
       where: eq(contracts.id, contractId),
     });
 
@@ -788,10 +754,10 @@ export async function getDocumentClasses(contractId:number) {
       .select()
       .from(documentClasses)
       .where(
-      and(
-        eq(documentClasses.isActive, true),
-        eq(documentClasses.projectId, projectId.projectId)
-      )
+        and(
+          eq(documentClasses.isActive, true),
+          eq(documentClasses.projectId, projectId.projectId)
+        )
       )
       .orderBy(asc(documentClasses.description))
 
@@ -871,7 +837,7 @@ export async function getDocumentClassOptionsByContract(contractId: number) {
           eq(documentClassOptions.isActive, true)
         )
       );
-      // 필요하면 .orderBy(asc(documentClassOptions.sortOrder ?? documentClassOptions.optionValue))
+    // 필요하면 .orderBy(asc(documentClassOptions.sortOrder ?? documentClassOptions.optionValue))
 
     return { success: true, data: { classes, options } };
   } catch (error) {
@@ -924,7 +890,7 @@ export async function createDocument(data: CreateDocumentData) {
       },
     })
 
-    console.log(contract,"contract")
+    console.log(contract, "contract")
 
     if (!contract) {
       return { success: false, error: "유효하지 않은 계약(ID)입니다." }
@@ -944,7 +910,7 @@ export async function createDocument(data: CreateDocumentData) {
     /* ──────────────────────────────── 3. 문서 레코드 삽입 ─────────────────────────────── */
     const insertData = {
       // 필수
-      projectId,       
+      projectId,
       vendorId,                // ★ 새로 추가
       contractId: data.contractId,
       docNumber: data.docNumber,
@@ -954,7 +920,7 @@ export async function createDocument(data: CreateDocumentData) {
       updatedAt: new Date(),
 
       // 선택
-      vendorDocNumber: data.vendorDocNumber === null || data.vendorDocNumber ==='' ? null: data.vendorDocNumber ,
+      vendorDocNumber: data.vendorDocNumber === null || data.vendorDocNumber === '' ? null : data.vendorDocNumber,
 
     }
 
@@ -984,7 +950,7 @@ export async function createDocument(data: CreateDocumentData) {
     )
 
 
-    console.log(data.documentClassId,"documentClassId")
+    console.log(data.documentClassId, "documentClassId")
     console.log(stageOptionsResult.data)
 
     if (stageOptionsResult.success && stageOptionsResult.data.length > 0) {
@@ -1045,7 +1011,7 @@ export async function getDocumentStagesOnly(
     // 세션에서 도메인 정보 가져오기
     const session = await getServerSession(authOptions)
     const isEvcpDomain = session?.user?.domain === "evcp"
-    
+
     // 도메인별 WHERE 조건 설정
     let finalWhere
     if (isEvcpDomain) {
@@ -1065,14 +1031,14 @@ export async function getDocumentStagesOnly(
 
 
 
-       // 정렬 처리
+    // 정렬 처리
     const orderBy = input.sort && input.sort.length > 0
       ? input.sort.map((item) =>
         item.desc
           ? desc(stageDocumentsView[item.id])
           : asc(stageDocumentsView[item.id])
       )
-            : [desc(stageDocumentsView.createdAt)]
+      : [desc(stageDocumentsView.createdAt)]
 
 
     // 트랜잭션 실행
@@ -1195,10 +1161,10 @@ export async function sendDocumentsToSHI(contractId: number) {
   try {
     const api = new ShiBuyerSystemAPI()
     const result = await api.sendToSHI(contractId)
-    
+
     // 캐시 무효화
     revalidatePath(`/partners/document-list-only/${contractId}`)
-    
+
     return result
   } catch (error) {
     console.error("SHI 전송 실패:", error)
@@ -1215,10 +1181,10 @@ export async function pullDocumentStatusFromSHI(
   try {
     const api = new ShiBuyerSystemAPI()
     const result = await api.pullDocumentStatus(contractId)
-    
+
     // 캐시 무효화
     revalidatePath(`/partners/document-list-only/${contractId}`)
-    
+
     return result
   } catch (error) {
     console.error("문서 상태 풀링 실패:", error)
@@ -1254,10 +1220,10 @@ export async function validateFiles(files: FileValidation[]): Promise<Validation
   if (!session?.user?.companyId) {
     throw new Error("Unauthorized")
   }
-  
+
   const vendorId = session.user.companyId
   const results: ValidationResult[] = []
-  
+
   for (const file of files) {
     // stageSubmissionView에서 매칭되는 레코드 찾기
     const match = await db
@@ -1277,7 +1243,7 @@ export async function validateFiles(files: FileValidation[]): Promise<Validation
         )
       )
       .limit(1)
-    
+
     if (match.length > 0) {
       results.push({
         projectId: file.projectId,
@@ -1298,6 +1264,238 @@ export async function validateFiles(files: FileValidation[]): Promise<Validation
       })
     }
   }
-  
+
   return results
-}
\ No newline at end of file
+}
+
+
+
+// =============================================================================
+// Type Definitions (서버와 클라이언트 공유)
+// =============================================================================
+export interface ParsedDocument {
+  docNumber: string
+  title: string
+  documentClass: string
+  vendorDocNumber?: string
+  notes?: string
+}
+
+export interface ParsedStage {
+  docNumber: string
+  stageName: string
+  planDate?: string
+}
+
+interface UploadData {
+  contractId: number
+  documents: ParsedDocument[]
+  stages: ParsedStage[]
+  projectType: "ship" | "plant"
+}
+
+// =============================================================================
+// Upload Import Data (서버 액션)
+// =============================================================================
+export async function uploadImportData(data: UploadData) {
+  const { contractId, documents, stages, projectType } = data
+  const warnings: string[] = []
+  const createdDocumentIds: number[] = []
+  const documentIdMap = new Map<string, number>() // docNumber -> documentId
+
+  try {
+    const contract = await db.query.contracts.findFirst({
+      where: eq(contracts.id, contractId),
+    });
+
+    if (!contract ) {
+      throw new Error("Contract not found")
+    }
+
+
+    // 2. Document Class 매핑 가져오기 (트랜잭션 밖에서)
+    const documentClassesData = await db
+      .select({
+        id: documentClasses.id,
+        value: documentClasses.value,
+        description: documentClasses.description,
+      })
+      .from(documentClasses)
+      .where(and(eq(documentClasses.projectId, contract.projectId), eq(documentClasses.isActive, true)))
+
+    const classMap = new Map(
+      documentClassesData.map(dc => [dc.value, dc.id])
+    )
+
+    console.log(classMap)
+
+    // 3. 각 문서를 개별적으로 처리 (개별 트랜잭션)
+    for (const doc of documents) {
+      console.log(doc)
+      const documentClassId = classMap.get(doc.documentClass)
+
+      if (!documentClassId) {
+        warnings.push(`Document Class "${doc.documentClass}"를 찾을 수 없습니다 (문서: ${doc.docNumber})`)
+        continue
+      }
+
+      try {
+        // 개별 트랜잭션으로 각 문서 처리
+        const result = await db.transaction(async (tx) => {
+          // 먼저 문서가 이미 존재하는지 확인
+          const [existingDoc] = await tx
+            .select({ id: stageDocuments.id })
+            .from(stageDocuments)
+            .where(
+              and(
+                eq(stageDocuments.projectId, contract.projectId),
+                eq(stageDocuments.docNumber, doc.docNumber),
+                eq(stageDocuments.status, "ACTIVE")
+              )
+            )
+            .limit(1)
+
+          if (existingDoc) {
+            throw new Error(`문서번호 "${doc.docNumber}"가 이미 존재합니다`)
+          }
+
+          // 3-1. 문서 생성
+          const [newDoc] = await tx
+            .insert(stageDocuments)
+            .values({
+              docNumber: doc.docNumber,
+              title: doc.title,
+              vendorDocNumber: doc.vendorDocNumber || null,
+              projectId:contract.projectId,
+              vendorId:contract.vendorId,
+              contractId,
+              status: "ACTIVE",
+              syncStatus: "pending",
+              syncVersion: 0,
+            })
+            .returning({ id: stageDocuments.id })
+
+          if (!newDoc) {
+            throw new Error(`문서 생성 실패: ${doc.docNumber}`)
+          }
+
+          // 3-2. Document Class Options에서 스테이지 자동 생성
+          const classOptions = await db
+            .select()
+            .from(documentClassOptions)
+            .where(
+              and(
+                eq(documentClassOptions.documentClassId, documentClassId),
+                eq(documentClassOptions.isActive, true)
+              )
+            )
+            .orderBy(asc(documentClassOptions.sdq))
+
+
+          // 3-3. 각 옵션에 대해 스테이지 생성
+          const stageInserts = []
+
+          console.log(documentClassId, "documentClassId")
+          console.log(classOptions, "classOptions")
+
+          for (const option of classOptions) {
+            // stages 배열에서 해당 스테이지의 plan date 찾기
+            const stageData = stages.find(
+              s => s.docNumber === doc.docNumber && s.stageName === option.description
+            )
+
+            stageInserts.push({
+              documentId: newDoc.id,
+              stageName: option.description,
+              stageOrder: option.sdq,
+              stageStatus: "PLANNED" as const,
+              priority: "MEDIUM" as const,
+              planDate: stageData?.planDate || null,
+              reminderDays: 3,
+            })
+          }
+
+          // 모든 스테이지를 한번에 삽입
+          if (stageInserts.length > 0) {
+            await tx.insert(stageIssueStages).values(stageInserts)
+          }
+
+          return newDoc.id
+        })
+
+        createdDocumentIds.push(result)
+        documentIdMap.set(doc.docNumber, result)
+
+      } catch (error) {
+        console.error(`Error creating document ${doc.docNumber}:`, error)
+        warnings.push(`문서 생성 중 오류: ${doc.docNumber} - ${error instanceof Error ? error.message : 'Unknown error'}`)
+      }
+    }
+
+    // 4. 기존 문서의 Plan Date 업데이트 (신규 생성된 문서는 제외)
+    const processedDocNumbers = new Set(documents.map(d => d.docNumber))
+
+    for (const stage of stages) {
+      if (!stage.planDate) continue
+
+      // 이미 처리된 신규 문서는 제외
+      if (processedDocNumbers.has(stage.docNumber)) continue
+
+      try {
+        // 기존 문서 찾기
+        const [existingDoc] = await db
+          .select({ id: stageDocuments.id })
+          .from(stageDocuments)
+          .where(
+            and(
+              eq(stageDocuments.projectId, contract.projectId),
+              eq(stageDocuments.docNumber, stage.docNumber),
+              eq(stageDocuments.status, "ACTIVE")
+            )
+          )
+          .limit(1)
+
+        if (!existingDoc) {
+          warnings.push(`스테이지 업데이트 실패: 문서 "${stage.docNumber}"를 찾을 수 없습니다`)
+          continue
+        }
+
+        // 스테이지 plan date 업데이트
+        await db
+          .update(stageIssueStages)
+          .set({
+            planDate: stage.planDate,
+            updatedAt: new Date()
+          })
+          .where(
+            and(
+              eq(stageIssueStages.documentId, existingDoc.id),
+              eq(stageIssueStages.stageName, stage.stageName)
+            )
+          )
+      } catch (error) {
+        console.error(`Error updating stage for document ${stage.docNumber}:`, error)
+        warnings.push(`스테이지 "${stage.stageName}" 업데이트 실패 (문서: ${stage.docNumber})`)
+      }
+    }
+
+    return {
+      success: true,
+      data: {
+        success: true,
+        createdCount: createdDocumentIds.length,
+        documentIds: createdDocumentIds
+      },
+      warnings,
+      message: `${createdDocumentIds.length}개 문서가 성공적으로 생성되었습니다`
+    }
+
+  } catch (error) {
+    console.error("Upload import data error:", error)
+    return {
+      success: false,
+      error: error instanceof Error ? error.message : "데이터 업로드 중 오류가 발생했습니다",
+      warnings
+    }
+  }
+}
diff --git a/lib/vendor-document-list/plant/document-stages-table.tsx b/lib/vendor-document-list/plant/document-stages-table.tsx
index 50d54a92..6cc112e3 100644
--- a/lib/vendor-document-list/plant/document-stages-table.tsx
+++ b/lib/vendor-document-list/plant/document-stages-table.tsx
@@ -14,11 +14,11 @@ import { DataTableAdvancedToolbar } from "@/components/data-table/data-table-adv
 import { Badge } from "@/components/ui/badge"
 import { Card, CardContent, CardHeader, CardTitle } from "@/components/ui/card"
 import {
-  AlertTriangle,
-  Clock,
-  TrendingUp,
-  Target,
-  Users,
+  FileText,
+  Send,
+  Search,
+  CheckCircle2,
+  XCircle,
   Plus,
   FileSpreadsheet
 } from "lucide-react"
@@ -32,7 +32,6 @@ import { DocumentStagesExpandedContent } from "./document-stages-expanded-conten
 import { AddDocumentDialog, DeleteDocumentsDialog } from "./document-stage-dialogs"
 import { EditDocumentDialog } from "./document-stage-dialogs"
 import { EditStageDialog } from "./document-stage-dialogs"
-import { ExcelImportDialog } from "./document-stage-dialogs"
 import { DocumentsTableToolbarActions } from "./document-stage-toolbar"
 import { useSession } from "next-auth/react"
 
@@ -51,7 +50,6 @@ export function DocumentStagesTable({
 
   const { data: session } = useSession()
 
-
   // URL에서 언어 파라미터 가져오기
   const params = useParams()
   const lng = (params?.lng as string) || 'ko'
@@ -63,7 +61,7 @@ export function DocumentStagesTable({
   // 상태 관리
   const [rowAction, setRowAction] = React.useState<DataTableRowAction<StageDocumentsView> | null>(null)
   const [expandedRows, setExpandedRows] = React.useState<Set<string>>(new Set())
-  const [quickFilter, setQuickFilter] = React.useState<'all' | 'overdue' | 'due_soon' | 'in_progress' | 'high_priority'>('all')
+  const [quickFilter, setQuickFilter] = React.useState<'all' | 'submitted' | 'under_review' | 'approved' | 'rejected'>('all')
 
   // 다이얼로그 상태들
   const [addDocumentOpen, setAddDocumentOpen] = React.useState(false)
@@ -112,52 +110,41 @@ export function DocumentStagesTable({
     [expandedRows, projectType, currentDomain]
   )
 
-  // 통계 계산
+  // 문서 상태별 통계 계산
   const stats = React.useMemo(() => {
-    console.log('DocumentStagesTable - data:', data)
-    console.log('DocumentStagesTable - data length:', data?.length)
-
     const totalDocs = data?.length || 0
-    const overdue = data?.filter(doc => doc.isOverdue)?.length || 0
-    const dueSoon = data?.filter(doc =>
-      doc.daysUntilDue !== null &&
-      doc.daysUntilDue >= 0 &&
-      doc.daysUntilDue <= 3
+    const submitted = data?.filter(doc => doc.status === 'SUBMITTED')?.length || 0
+    const underReview = data?.filter(doc => doc.status === 'UNDER_REVIEW')?.length || 0
+    const approved = data?.filter(doc => doc.status === 'APPROVED')?.length || 0
+    const rejected = data?.filter(doc => doc.status === 'REJECTED')?.length || 0
+    const notSubmitted = data?.filter(doc => 
+      !doc.status || !['SUBMITTED', 'UNDER_REVIEW', 'APPROVED', 'REJECTED'].includes(doc.status)
     )?.length || 0
-    const inProgress = data?.filter(doc => doc.currentStageStatus === 'IN_PROGRESS')?.length || 0
-    const highPriority = data?.filter(doc => doc.currentStagePriority === 'HIGH')?.length || 0
-    const avgProgress = totalDocs > 0
-      ? Math.round((data?.reduce((sum, doc) => sum + (doc.progressPercentage || 0), 0) || 0) / totalDocs)
-      : 0
 
-    const result = {
+    return {
       total: totalDocs,
-      overdue,
-      dueSoon,
-      inProgress,
-      highPriority,
-      avgProgress
+      submitted,
+      underReview,
+      approved,
+      rejected,
+      notSubmitted,
+      approvalRate: totalDocs > 0 
+        ? Math.round((approved / totalDocs) * 100) 
+        : 0
     }
-
-    console.log('DocumentStagesTable - stats:', result)
-    return result
   }, [data])
 
   // 빠른 필터링
   const filteredData = React.useMemo(() => {
     switch (quickFilter) {
-      case 'overdue':
-        return data.filter(doc => doc.isOverdue)
-      case 'due_soon':
-        return data.filter(doc =>
-          doc.daysUntilDue !== null &&
-          doc.daysUntilDue >= 0 &&
-          doc.daysUntilDue <= 3
-        )
-      case 'in_progress':
-        return data.filter(doc => doc.currentStageStatus === 'IN_PROGRESS')
-      case 'high_priority':
-        return data.filter(doc => doc.currentStagePriority === 'HIGH')
+      case 'submitted':
+        return data.filter(doc => doc.status === 'SUBMITTED')
+      case 'under_review':
+        return data.filter(doc => doc.status === 'UNDER_REVIEW')
+      case 'approved':
+        return data.filter(doc => doc.status === 'APPROVED')
+      case 'rejected':
+        return data.filter(doc => doc.status === 'REJECTED')
       default:
         return data
     }
@@ -172,24 +159,6 @@ export function DocumentStagesTable({
     setExcelImportOpen(true)
   }
 
-  const handleBulkAction = async (action: string, selectedRows: any[]) => {
-    try {
-      if (action === 'bulk_complete') {
-        const stageIds = selectedRows
-          .map(row => row.original.currentStageId)
-          .filter(Boolean)
-
-        if (stageIds.length > 0) {
-          toast.success(t('documentList.messages.stageCompletionSuccess', { count: stageIds.length }))
-        }
-      } else if (action === 'bulk_assign') {
-        toast.info(t('documentList.messages.bulkAssignPending'))
-      }
-    } catch (error) {
-      toast.error(t('documentList.messages.bulkActionError'))
-    }
-  }
-
   const closeAllDialogs = () => {
     setAddDocumentOpen(false)
     setEditDocumentOpen(false)
@@ -201,8 +170,7 @@ export function DocumentStagesTable({
   }
 
   // 필터 필드 정의
-  const filterFields: DataTableFilterField<StageDocumentsView>[] = [
-  ]
+  const filterFields: DataTableFilterField<StageDocumentsView>[] = []
 
   const advancedFilterFields: DataTableAdvancedFilterField<StageDocumentsView>[] = [
     {
@@ -216,37 +184,18 @@ export function DocumentStagesTable({
       type: "text",
     },
     {
-      id: "currentStageStatus",
-      label: "스테이지 상태",
+      id: "status",
+      label: "문서 상태",
       type: "select",
       options: [
-        { label: "계획됨", value: "PLANNED" },
-        { label: "진행중", value: "IN_PROGRESS" },
         { label: "제출됨", value: "SUBMITTED" },
-        { label: "완료됨", value: "COMPLETED" },
-      ],
-    },
-    {
-      id: "currentStagePriority",
-      label: "우선순위",
-      type: "select",
-      options: [
-        { label: "높음", value: "HIGH" },
-        { label: "보통", value: "MEDIUM" },
-        { label: "낮음", value: "LOW" },
-      ],
-    },
-    {
-      id: "isOverdue",
-      label: "지연 여부",
-      type: "select",
-      options: [
-        { label: "지연됨", value: "true" },
-        { label: "정상", value: "false" },
+        { label: "검토중", value: "UNDER_REVIEW" },
+        { label: "승인됨", value: "APPROVED" },
+        { label: "반려됨", value: "REJECTED" },
       ],
     },
     {
-      id: "currentStageAssigneeName",
+      id: "pic",
       label: "담당자",
       type: "text",
     },
@@ -276,95 +225,111 @@ export function DocumentStagesTable({
 
   return (
     <div className="space-y-6">
-      {/* 통계 대시보드 */}
+      {/* 문서 상태 대시보드 */}
       <div className="grid grid-cols-2 md:grid-cols-4 gap-4">
+        {/* 전체 문서 */}
         <Card className="cursor-pointer hover:shadow-md transition-shadow" onClick={() => setQuickFilter('all')}>
           <CardHeader className="flex flex-row items-center justify-between space-y-0 pb-2">
-            <CardTitle className="text-sm font-medium">{t('documentList.dashboard.totalDocuments')}</CardTitle>
-            <TrendingUp className="h-4 w-4 text-muted-foreground" />
+            <CardTitle className="text-sm font-medium">Total Documents</CardTitle>
+            <FileText className="h-4 w-4 text-muted-foreground" />
           </CardHeader>
           <CardContent>
             <div className="text-2xl font-bold">{stats.total}</div>
             <p className="text-xs text-muted-foreground">
-              {t('documentList.dashboard.totalDocumentCount', { total: stats.total })}
+              전체 등록 문서
             </p>
           </CardContent>
         </Card>
 
-        <Card className="cursor-pointer hover:shadow-md transition-shadow" onClick={() => setQuickFilter('overdue')}>
+        {/* 제출됨 */}
+        <Card className="cursor-pointer hover:shadow-md transition-shadow" onClick={() => setQuickFilter('submitted')}>
           <CardHeader className="flex flex-row items-center justify-between space-y-0 pb-2">
-            <CardTitle className="text-sm font-medium">{t('documentList.dashboard.overdueDocuments')}</CardTitle>
-            <AlertTriangle className="h-4 w-4 text-red-500" />
+            <CardTitle className="text-sm font-medium">Submitted</CardTitle>
+            <Send className="h-4 w-4 text-blue-500" />
           </CardHeader>
           <CardContent>
-            <div className="text-2xl font-bold text-red-600 dark:text-red-400">{stats.overdue}</div>
-            <p className="text-xs text-muted-foreground">{t('documentList.dashboard.checkImmediately')}</p>
+            <div className="text-2xl font-bold text-blue-600 dark:text-blue-400">{stats.submitted}</div>
+            <p className="text-xs text-muted-foreground">제출 대기중</p>
           </CardContent>
         </Card>
 
-        <Card className="cursor-pointer hover:shadow-md transition-shadow" onClick={() => setQuickFilter('due_soon')}>
+        {/* 검토중 */}
+        {/* <Card className="cursor-pointer hover:shadow-md transition-shadow" onClick={() => setQuickFilter('under_review')}>
           <CardHeader className="flex flex-row items-center justify-between space-y-0 pb-2">
-            <CardTitle className="text-sm font-medium">{t('documentList.dashboard.dueSoonDocuments')}</CardTitle>
-            <Clock className="h-4 w-4 text-orange-500" />
+            <CardTitle className="text-sm font-medium">Under Review</CardTitle>
+            <Search className="h-4 w-4 text-orange-500" />
           </CardHeader>
           <CardContent>
-            <div className="text-2xl font-bold text-orange-600 dark:text-orange-400">{stats.dueSoon}</div>
-            <p className="text-xs text-muted-foreground">{t('documentList.dashboard.dueInDays')}</p>
+            <div className="text-2xl font-bold text-orange-600 dark:text-orange-400">{stats.underReview}</div>
+            <p className="text-xs text-muted-foreground">검토 진행중</p>
+          </CardContent>
+        </Card> */}
+
+        {/* 승인됨 */}
+        <Card className="cursor-pointer hover:shadow-md transition-shadow" onClick={() => setQuickFilter('approved')}>
+          <CardHeader className="flex flex-row items-center justify-between space-y-0 pb-2">
+            <CardTitle className="text-sm font-medium">Approved</CardTitle>
+            <CheckCircle2 className="h-4 w-4 text-green-500" />
+          </CardHeader>
+          <CardContent>
+            <div className="text-2xl font-bold text-green-600 dark:text-green-400">{stats.approved}</div>
+            <p className="text-xs text-muted-foreground">승인 완료 ({stats.approvalRate}%)</p>
           </CardContent>
         </Card>
 
-        <Card>
+        <Card className="cursor-pointer hover:shadow-md transition-shadow border-red-200 dark:border-red-800" 
+              onClick={() => setQuickFilter('rejected')}>
           <CardHeader className="flex flex-row items-center justify-between space-y-0 pb-2">
-            <CardTitle className="text-sm font-medium">{t('documentList.dashboard.averageProgress')}</CardTitle>
-            <Target className="h-4 w-4 text-green-500" />
+            <CardTitle className="text-sm font-medium">Rejected</CardTitle>
+            <XCircle className="h-4 w-4 text-red-500" />
           </CardHeader>
           <CardContent>
-            <div className="text-2xl font-bold text-green-600 dark:text-green-400">{stats.avgProgress}%</div>
-            <p className="text-xs text-muted-foreground">{t('documentList.dashboard.overallProgress')}</p>
+            <div className="text-2xl font-bold text-red-600 dark:text-red-400">{stats.rejected}</div>
+            <p className="text-xs text-muted-foreground">재작업 필요</p>
           </CardContent>
         </Card>
       </div>
 
-      {/* 빠른 필터 */}
+      {/* 빠른 필터 뱃지 */}
       <div className="flex gap-2 overflow-x-auto pb-2">
         <Badge
           variant={quickFilter === 'all' ? 'default' : 'outline'}
           className="cursor-pointer hover:bg-primary hover:text-primary-foreground whitespace-nowrap"
           onClick={() => setQuickFilter('all')}
         >
-          {t('documentList.quickFilters.all')} ({stats.total})
+          전체 ({stats.total})
         </Badge>
         <Badge
-          variant={quickFilter === 'overdue' ? 'destructive' : 'outline'}
-          className="cursor-pointer hover:bg-destructive hover:text-destructive-foreground whitespace-nowrap"
-          onClick={() => setQuickFilter('overdue')}
+          variant={quickFilter === 'submitted' ? 'default' : 'outline'}
+          className="cursor-pointer hover:bg-blue-500 hover:text-white dark:hover:bg-blue-600 whitespace-nowrap"
+          onClick={() => setQuickFilter('submitted')}
         >
-          <AlertTriangle className="w-3 h-3 mr-1" />
-          {t('documentList.quickFilters.overdue')} ({stats.overdue})
+          <Send className="w-3 h-3 mr-1" />
+          제출됨 ({stats.submitted})
         </Badge>
         <Badge
-          variant={quickFilter === 'due_soon' ? 'default' : 'outline'}
+          variant={quickFilter === 'under_review' ? 'default' : 'outline'}
           className="cursor-pointer hover:bg-orange-500 hover:text-white dark:hover:bg-orange-600 whitespace-nowrap"
-          onClick={() => setQuickFilter('due_soon')}
+          onClick={() => setQuickFilter('under_review')}
         >
-          <Clock className="w-3 h-3 mr-1" />
-          {t('documentList.quickFilters.dueSoon')} ({stats.dueSoon})
+          <Search className="w-3 h-3 mr-1" />
+          검토중 ({stats.underReview})
         </Badge>
         <Badge
-          variant={quickFilter === 'in_progress' ? 'default' : 'outline'}
-          className="cursor-pointer hover:bg-blue-500 hover:text-white dark:hover:bg-blue-600 whitespace-nowrap"
-          onClick={() => setQuickFilter('in_progress')}
+          variant={quickFilter === 'approved' ? 'success' : 'outline'}
+          className="cursor-pointer hover:bg-green-500 hover:text-white dark:hover:bg-green-600 whitespace-nowrap"
+          onClick={() => setQuickFilter('approved')}
         >
-          <Users className="w-3 h-3 mr-1" />
-          {t('documentList.quickFilters.inProgress')} ({stats.inProgress})
+          <CheckCircle2 className="w-3 h-3 mr-1" />
+          승인됨 ({stats.approved})
         </Badge>
         <Badge
-          variant={quickFilter === 'high_priority' ? 'destructive' : 'outline'}
+          variant={quickFilter === 'rejected' ? 'destructive' : 'outline'}
           className="cursor-pointer hover:bg-destructive hover:text-destructive-foreground whitespace-nowrap"
-          onClick={() => setQuickFilter('high_priority')}
+          onClick={() => setQuickFilter('rejected')}
         >
-          <Target className="w-3 h-3 mr-1" />
-          {t('documentList.quickFilters.highPriority')} ({stats.highPriority})
+          <XCircle className="w-3 h-3 mr-1" />
+          반려됨 ({stats.rejected})
         </Badge>
       </div>
 
@@ -375,6 +340,7 @@ export function DocumentStagesTable({
             table={table}
             expandable={true}
             expandedRows={expandedRows}
+            simpleExpansion={true} 
             setExpandedRows={setExpandedRows}
             renderExpandedContent={(document) => (
               <DocumentStagesExpandedContent
@@ -440,25 +406,13 @@ export function DocumentStagesTable({
         stageId={selectedStageId}
       />
 
-      <ExcelImportDialog
-        open={excelImportOpen}
-        onOpenChange={(open) => {
-          if (!open) closeAllDialogs()
-          else setExcelImportOpen(open)
-        }}
-        contractId={contractId}
-        projectType={projectType}
-      />
-
       <DeleteDocumentsDialog
         open={rowAction?.type === "delete"}
         onOpenChange={() => setRowAction(null)}
         showTrigger={false}
-        documents={rowAction?.row.original ? [rowAction?.row.original] : []} // 전체 문서 배열
+        documents={rowAction?.row.original ? [rowAction?.row.original] : []}
         onSuccess={() => rowAction?.row.toggleSelected(false)}
       />
-
-
     </div>
   )
 }
\ No newline at end of file
diff --git a/lib/vendor-document-list/plant/excel-import-export.ts b/lib/vendor-document-list/plant/excel-import-export.ts
deleted file mode 100644
index c1409205..00000000
--- a/lib/vendor-document-list/plant/excel-import-export.ts
+++ /dev/null
@@ -1,788 +0,0 @@
-// excel-import-export.ts
-"use client"
-
-import ExcelJS from 'exceljs'
-import { 
-  excelDocumentRowSchema, 
-  excelStageRowSchema,
-  type ExcelDocumentRow,
-  type ExcelStageRow,
-  type ExcelImportResult,
-  type CreateDocumentInput
-} from './document-stage-validations'
-import { StageDocumentsView } from '@/db/schema'
-
-// =============================================================================
-// 1. 엑셀 템플릿 생성 및 다운로드
-// =============================================================================
-
-// 문서 템플릿 생성
-export async function createDocumentTemplate(projectType: "ship" | "plant") {
-  const workbook = new ExcelJS.Workbook()
-  const worksheet = workbook.addWorksheet("문서목록", {
-    properties: { defaultColWidth: 15 }
-  })
-  
-  const baseHeaders = [
-    "문서번호*",
-    "문서명*", 
-    "문서종류*",
-    "PIC",
-    "발행일",
-    "설명"
-  ]
-  
-  const plantHeaders = [
-    "벤더문서번호",
-    "벤더명",
-    "벤더코드"
-  ]
-  
-  const b4Headers = [
-    "C구분",
-    "D구분", 
-    "Degree구분",
-    "부서구분",
-    "S구분",
-    "J구분"
-  ]
-  
-  const headers = [
-    ...baseHeaders,
-    ...(projectType === "plant" ? plantHeaders : []),
-    ...b4Headers
-  ]
-  
-  // 헤더 행 추가 및 스타일링
-  const headerRow = worksheet.addRow(headers)
-  headerRow.eachCell((cell, colNumber) => {
-    cell.fill = {
-      type: 'pattern',
-      pattern: 'solid',
-      fgColor: { argb: 'FF4472C4' }
-    }
-    cell.font = {
-      color: { argb: 'FFFFFFFF' },
-      bold: true,
-      size: 11
-    }
-    cell.alignment = {
-      horizontal: 'center',
-      vertical: 'middle'
-    }
-    cell.border = {
-      top: { style: 'thin' },
-      left: { style: 'thin' },
-      bottom: { style: 'thin' },
-      right: { style: 'thin' }
-    }
-    
-    // 필수 필드 표시
-    if (cell.value && String(cell.value).includes('*')) {
-      cell.fill = {
-        type: 'pattern',
-        pattern: 'solid',
-        fgColor: { argb: 'FFE74C3C' }
-      }
-    }
-  })
-  
-  // 샘플 데이터 추가
-  const sampleData = projectType === "ship" ? [
-    "SH-2024-001",
-    "기본 설계 도면",
-    "B3",
-    "김철수",
-    new Date("2024-01-15"),
-    "선박 기본 설계 관련 문서",
-    "", "", "", "", "", "" // B4 필드들
-  ] : [
-    "PL-2024-001", 
-    "공정 설계 도면",
-    "B4",
-    "이영희",
-    new Date("2024-01-15"), 
-    "플랜트 공정 설계 관련 문서",
-    "V-001", // 벤더문서번호
-    "삼성엔지니어링", // 벤더명
-    "SENG", // 벤더코드
-    "C1", "D1", "DEG1", "DEPT1", "S1", "J1" // B4 필드들
-  ]
-  
-  const sampleRow = worksheet.addRow(sampleData)
-  sampleRow.eachCell((cell, colNumber) => {
-    cell.border = {
-      top: { style: 'thin' },
-      left: { style: 'thin' },
-      bottom: { style: 'thin' },
-      right: { style: 'thin' }
-    }
-    
-    // 날짜 형식 설정
-    if (cell.value instanceof Date) {
-      cell.numFmt = 'yyyy-mm-dd'
-    }
-  })
-  
-  // 컬럼 너비 자동 조정
-  worksheet.columns.forEach((column, index) => {
-    if (index < 6) {
-      column.width = headers[index].length + 5
-    } else {
-      column.width = 12
-    }
-  })
-  
-  // 문서종류 드롭다운 설정
-  const docTypeCol = headers.indexOf("문서종류*") + 1
-  worksheet.dataValidations.add(`${String.fromCharCode(64 + docTypeCol)}2:${String.fromCharCode(64 + docTypeCol)}1000`, {
-    type: 'list',
-    allowBlank: false,
-    formulae: ['"B3,B4,B5"']
-  })
-  
-  // Plant 프로젝트의 경우 우선순위 드롭다운 추가
-  if (projectType === "plant") {
-    // 여기에 추가적인 드롭다운들을 설정할 수 있습니다
-  }
-  
-  return workbook
-}
-
-// 스테이지 템플릿 생성
-export async function createStageTemplate() {
-  const workbook = new ExcelJS.Workbook()
-  const worksheet = workbook.addWorksheet("스테이지목록", {
-    properties: { defaultColWidth: 15 }
-  })
-  
-  const headers = [
-    "문서번호*",
-    "스테이지명*",
-    "계획일",
-    "우선순위",
-    "담당자",
-    "설명",
-    "스테이지순서"
-  ]
-  
-  // 헤더 행 추가 및 스타일링
-  const headerRow = worksheet.addRow(headers)
-  headerRow.eachCell((cell, colNumber) => {
-    cell.fill = {
-      type: 'pattern',
-      pattern: 'solid',
-      fgColor: { argb: 'FF27AE60' }
-    }
-    cell.font = {
-      color: { argb: 'FFFFFFFF' },
-      bold: true,
-      size: 11
-    }
-    cell.alignment = {
-      horizontal: 'center',
-      vertical: 'middle'
-    }
-    cell.border = {
-      top: { style: 'thin' },
-      left: { style: 'thin' },
-      bottom: { style: 'thin' },
-      right: { style: 'thin' }
-    }
-    
-    // 필수 필드 표시
-    if (cell.value && String(cell.value).includes('*')) {
-      cell.fill = {
-        type: 'pattern',
-        pattern: 'solid',
-        fgColor: { argb: 'FFE74C3C' }
-      }
-    }
-  })
-  
-  // 샘플 데이터 추가
-  const sampleData = [
-    [
-      "SH-2024-001",
-      "초기 설계 검토",
-      new Date("2024-02-15"),
-      "HIGH",
-      "김철수",
-      "초기 설계안 검토 및 승인",
-      0
-    ],
-    [
-      "SH-2024-001", 
-      "상세 설계",
-      new Date("2024-03-15"),
-      "MEDIUM",
-      "이영희",
-      "상세 설계 작업 수행",
-      1
-    ]
-  ]
-  
-  sampleData.forEach(rowData => {
-    const row = worksheet.addRow(rowData)
-    row.eachCell((cell, colNumber) => {
-      cell.border = {
-        top: { style: 'thin' },
-        left: { style: 'thin' },
-        bottom: { style: 'thin' },
-        right: { style: 'thin' }
-      }
-      
-      // 날짜 형식 설정
-      if (cell.value instanceof Date) {
-        cell.numFmt = 'yyyy-mm-dd'
-      }
-    })
-  })
-  
-  // 컬럼 너비 설정
-  worksheet.columns = [
-    { width: 15 }, // 문서번호
-    { width: 20 }, // 스테이지명
-    { width: 12 }, // 계획일
-    { width: 10 }, // 우선순위
-    { width: 15 }, // 담당자
-    { width: 30 }, // 설명
-    { width: 12 }, // 스테이지순서
-  ]
-  
-  // 우선순위 드롭다운 설정
-  worksheet.dataValidations.add('D2:D1000', {
-    type: 'list',
-    allowBlank: true,
-    formulae: ['"HIGH,MEDIUM,LOW"']
-  })
-  
-  return workbook
-}
-
-// 템플릿 다운로드 함수
-export async function downloadTemplate(type: "documents" | "stages", projectType: "ship" | "plant") {
-  const workbook = await (type === "documents" 
-    ? createDocumentTemplate(projectType)
-    : createStageTemplate())
-    
-  const filename = type === "documents" 
-    ? `문서_임포트_템플릿_${projectType}.xlsx`
-    : `스테이지_임포트_템플릿.xlsx`
-  
-  // 브라우저에서 다운로드
-  const buffer = await workbook.xlsx.writeBuffer()
-  const blob = new Blob([buffer], { 
-    type: 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet' 
-  })
-  
-  const url = window.URL.createObjectURL(blob)
-  const link = document.createElement('a')
-  link.href = url
-  link.download = filename
-  link.click()
-  
-  // 메모리 정리
-  window.URL.revokeObjectURL(url)
-}
-
-// =============================================================================
-// 2. 엑셀 파일 읽기 및 파싱
-// =============================================================================
-
-// 엑셀 파일을 읽어서 JSON으로 변환
-export async function readExcelFile(file: File): Promise<any[]> {
-  return new Promise((resolve, reject) => {
-    const reader = new FileReader()
-    
-    reader.onload = async (e) => {
-      try {
-        const buffer = e.target?.result as ArrayBuffer
-        const workbook = new ExcelJS.Workbook()
-        await workbook.xlsx.load(buffer)
-        
-        const worksheet = workbook.getWorksheet(1) // 첫 번째 워크시트
-        if (!worksheet) {
-          throw new Error('워크시트를 찾을 수 없습니다')
-        }
-        
-        const jsonData: any[] = []
-        
-        worksheet.eachRow({ includeEmpty: false }, (row, rowNumber) => {
-          const rowData: any[] = []
-          row.eachCell({ includeEmpty: true }, (cell, colNumber) => {
-            let value = cell.value
-            
-            // 날짜 처리
-            if (cell.type === ExcelJS.ValueType.Date) {
-              value = cell.value as Date
-            }
-            // 수식 결과값 처리
-            else if (cell.type === ExcelJS.ValueType.Formula && cell.result) {
-              value = cell.result
-            }
-            // 하이퍼링크 처리
-            else if (cell.type === ExcelJS.ValueType.Hyperlink) {
-              value = cell.value?.text || cell.value
-            }
-            
-            rowData[colNumber - 1] = value || ""
-          })
-          
-          jsonData.push(rowData)
-        })
-        
-        resolve(jsonData)
-      } catch (error) {
-        reject(new Error('엑셀 파일을 읽는 중 오류가 발생했습니다: ' + error))
-      }
-    }
-    
-    reader.onerror = () => {
-      reject(new Error('파일을 읽을 수 없습니다'))
-    }
-    
-    reader.readAsArrayBuffer(file)
-  })
-}
-
-// 문서 데이터 유효성 검사 및 변환
-export function validateDocumentRows(
-  rawData: any[], 
-  contractId: number,
-  projectType: "ship" | "plant"
-): { validData: CreateDocumentInput[], errors: any[] } {
-  if (rawData.length < 2) {
-    throw new Error('데이터가 없습니다. 최소 헤더와 1개 행이 필요합니다.')
-  }
-  
-  const headers = rawData[0] as string[]
-  const rows = rawData.slice(1)
-  
-  const validData: CreateDocumentInput[] = []
-  const errors: any[] = []
-  
-  // 필수 헤더 검사
-  const requiredHeaders = ["문서번호", "문서명", "문서종류"]
-  const missingHeaders = requiredHeaders.filter(h => 
-    !headers.some(header => header.includes(h.replace("*", "")))
-  )
-  
-  if (missingHeaders.length > 0) {
-    throw new Error(`필수 헤더가 누락되었습니다: ${missingHeaders.join(", ")}`)
-  }
-  
-  // 헤더 인덱스 매핑
-  const headerMap: Record<string, number> = {}
-  headers.forEach((header, index) => {
-    const cleanHeader = header.replace("*", "").trim()
-    headerMap[cleanHeader] = index
-  })
-  
-  // 각 행 처리
-  rows.forEach((row: any[], rowIndex) => {
-    try {
-      // 빈 행 스킵
-      if (row.every(cell => !cell || String(cell).trim() === "")) {
-        return
-      }
-      
-      const rowData: any = {
-        contractId,
-        docNumber: String(row[headerMap["문서번호"]] || "").trim(),
-        title: String(row[headerMap["문서명"]] || "").trim(),
-        drawingKind: String(row[headerMap["문서종류"]] || "").trim(),
-        pic: String(row[headerMap["PIC"]] || "").trim() || undefined,
-        issuedDate: row[headerMap["발행일"]] ? 
-          formatExcelDate(row[headerMap["발행일"]]) : undefined,
-      }
-      
-      // Plant 프로젝트 전용 필드
-      if (projectType === "plant") {
-        rowData.vendorDocNumber = String(row[headerMap["벤더문서번호"]] || "").trim() || undefined
-      }
-      
-      // B4 전용 필드들
-      const b4Fields = ["C구분", "D구분", "Degree구분", "부서구분", "S구분", "J구분"]
-      const b4FieldMap = {
-        "C구분": "cGbn",
-        "D구분": "dGbn", 
-        "Degree구분": "degreeGbn",
-        "부서구분": "deptGbn",
-        "S구분": "sGbn",
-        "J구분": "jGbn"
-      }
-      
-      b4Fields.forEach(field => {
-        if (headerMap[field] !== undefined) {
-          const value = String(row[headerMap[field]] || "").trim()
-          if (value) {
-            rowData[b4FieldMap[field as keyof typeof b4FieldMap]] = value
-          }
-        }
-      })
-      
-      // 유효성 검사
-      const validatedData = excelDocumentRowSchema.parse({
-        "문서번호": rowData.docNumber,
-        "문서명": rowData.title,
-        "문서종류": rowData.drawingKind,
-        "벤더문서번호": rowData.vendorDocNumber,
-        "PIC": rowData.pic,
-        "발행일": rowData.issuedDate,
-        "C구분": rowData.cGbn,
-        "D구분": rowData.dGbn,
-        "Degree구분": rowData.degreeGbn,
-        "부서구분": rowData.deptGbn,
-        "S구분": rowData.sGbn,
-        "J구분": rowData.jGbn,
-      })
-      
-      // CreateDocumentInput 형태로 변환
-      const documentInput: CreateDocumentInput = {
-        contractId,
-        docNumber: validatedData["문서번호"],
-        title: validatedData["문서명"],
-        drawingKind: validatedData["문서종류"],
-        vendorDocNumber: validatedData["벤더문서번호"],
-        pic: validatedData["PIC"],
-        issuedDate: validatedData["발행일"],
-        cGbn: validatedData["C구분"],
-        dGbn: validatedData["D구분"],
-        degreeGbn: validatedData["Degree구분"],
-        deptGbn: validatedData["부서구분"],
-        sGbn: validatedData["S구분"],
-        jGbn: validatedData["J구분"],
-      }
-      
-      validData.push(documentInput)
-      
-    } catch (error) {
-      errors.push({
-        row: rowIndex + 2, // 엑셀 행 번호 (헤더 포함)
-        message: error instanceof Error ? error.message : "알 수 없는 오류",
-        data: row
-      })
-    }
-  })
-  
-  return { validData, errors }
-}
-
-// 엑셀 날짜 형식 변환
-function formatExcelDate(value: any): string | undefined {
-  if (!value) return undefined
-  
-  // ExcelJS에서 Date 객체로 처리된 경우
-  if (value instanceof Date) {
-    return value.toISOString().split('T')[0]
-  }
-  
-  // 이미 문자열 날짜 형식인 경우
-  if (typeof value === 'string') {
-    const dateMatch = value.match(/^\d{4}-\d{2}-\d{2}$/)
-    if (dateMatch) return value
-    
-    // 다른 형식 시도
-    const date = new Date(value)
-    if (!isNaN(date.getTime())) {
-      return date.toISOString().split('T')[0]
-    }
-  }
-  
-  // 엑셀 시리얼 날짜인 경우
-  if (typeof value === 'number') {
-    // ExcelJS는 이미 Date 객체로 변환해주므로 이 경우는 드물지만
-    // 1900년 1월 1일부터의 일수로 계산
-    const excelEpoch = new Date(1900, 0, 1)
-    const date = new Date(excelEpoch.getTime() + (value - 2) * 24 * 60 * 60 * 1000)
-    if (!isNaN(date.getTime())) {
-      return date.toISOString().split('T')[0]
-    }
-  }
-  
-  return undefined
-}
-
-// =============================================================================
-// 3. 데이터 익스포트
-// =============================================================================
-
-// 문서 데이터를 엑셀로 익스포트
-export function exportDocumentsToExcel(
-  documents: StageDocumentsView[], 
-  projectType: "ship" | "plant"
-) {
-  const headers = [
-    "문서번호",
-    "문서명",
-    "문서종류",
-    "PIC", 
-    "발행일",
-    "현재스테이지",
-    "스테이지상태",
-    "계획일",
-    "담당자",
-    "우선순위",
-    "진행률(%)",
-    "완료스테이지",
-    "전체스테이지",
-    "지연여부",
-    "남은일수",
-    "생성일",
-    "수정일"
-  ]
-  
-  // Plant 프로젝트 전용 헤더 추가
-  if (projectType === "plant") {
-    headers.splice(3, 0, "벤더문서번호", "벤더명", "벤더코드")
-  }
-  
-  const data = documents.map(doc => {
-    const baseData = [
-      doc.docNumber,
-      doc.title,
-      doc.drawingKind || "",
-      doc.pic || "",
-      doc.issuedDate || "",
-      doc.currentStageName || "",
-      getStatusText(doc.currentStageStatus || ""),
-      doc.currentStagePlanDate || "",
-      doc.currentStageAssigneeName || "",
-      getPriorityText(doc.currentStagePriority || ""),
-      doc.progressPercentage || 0,
-      doc.completedStages || 0,
-      doc.totalStages || 0,
-      doc.isOverdue ? "예" : "아니오",
-      doc.daysUntilDue || "",
-      doc.createdAt ? new Date(doc.createdAt).toLocaleDateString() : "",
-      doc.updatedAt ? new Date(doc.updatedAt).toLocaleDateString() : ""
-    ]
-    
-    // Plant 프로젝트 데이터 추가
-    if (projectType === "plant") {
-      baseData.splice(3, 0, 
-        doc.vendorDocNumber || "",
-        doc.vendorName || "",
-        doc.vendorCode || ""
-      )
-    }
-    
-    return baseData
-  })
-  
-  const worksheet = XLSX.utils.aoa_to_sheet([headers, ...data])
-  
-  // 컬럼 너비 설정
-  const colWidths = [
-    { wch: 15 }, // 문서번호
-    { wch: 30 }, // 문서명
-    { wch: 10 }, // 문서종류
-    ...(projectType === "plant" ? [
-      { wch: 15 }, // 벤더문서번호
-      { wch: 20 }, // 벤더명
-      { wch: 10 }, // 벤더코드
-    ] : []),
-    { wch: 10 }, // PIC
-    { wch: 12 }, // 발행일
-    { wch: 15 }, // 현재스테이지
-    { wch: 10 }, // 스테이지상태
-    { wch: 12 }, // 계획일
-    { wch: 10 }, // 담당자
-    { wch: 8 },  // 우선순위
-    { wch: 8 },  // 진행률
-    { wch: 8 },  // 완료스테이지
-    { wch: 8 },  // 전체스테이지
-    { wch: 8 },  // 지연여부
-    { wch: 8 },  // 남은일수
-    { wch: 12 }, // 생성일
-    { wch: 12 }, // 수정일
-  ]
-  
-  worksheet['!cols'] = colWidths
-  
-  const workbook = XLSX.utils.book_new()
-  XLSX.utils.book_append_sheet(workbook, worksheet, "문서목록")
-  
-  const filename = `문서목록_${new Date().toISOString().split('T')[0]}.xlsx`
-  XLSX.writeFile(workbook, filename)
-}
-
-// 스테이지 상세 데이터를 엑셀로 익스포트
-export function exportStageDetailsToExcel(documents: StageDocumentsView[]) {
-  const headers = [
-    "문서번호",
-    "문서명",
-    "스테이지명",
-    "스테이지상태", 
-    "스테이지순서",
-    "계획일",
-    "담당자",
-    "우선순위",
-    "설명",
-    "노트",
-    "알림일수"
-  ]
-  
-  const data: any[] = []
-  
-  documents.forEach(doc => {
-    if (doc.allStages && doc.allStages.length > 0) {
-      doc.allStages.forEach(stage => {
-        data.push([
-          doc.docNumber,
-          doc.title,
-          stage.stageName,
-          getStatusText(stage.stageStatus),
-          stage.stageOrder,
-          stage.planDate || "",
-          stage.assigneeName || "",
-          getPriorityText(stage.priority),
-          stage.description || "",
-          stage.notes || "",
-          stage.reminderDays || ""
-        ])
-      })
-    } else {
-      // 스테이지가 없는 문서도 포함
-      data.push([
-        doc.docNumber,
-        doc.title,
-        "", "", "", "", "", "", "", "", ""
-      ])
-    }
-  })
-  
-  const worksheet = XLSX.utils.aoa_to_sheet([headers, ...data])
-  
-  // 컬럼 너비 설정
-  worksheet['!cols'] = [
-    { wch: 15 }, // 문서번호
-    { wch: 30 }, // 문서명
-    { wch: 20 }, // 스테이지명
-    { wch: 12 }, // 스테이지상태
-    { wch: 8 },  // 스테이지순서
-    { wch: 12 }, // 계획일
-    { wch: 10 }, // 담당자
-    { wch: 8 },  // 우선순위
-    { wch: 25 }, // 설명
-    { wch: 25 }, // 노트
-    { wch: 8 },  // 알림일수
-  ]
-  
-  const workbook = XLSX.utils.book_new()
-  XLSX.utils.book_append_sheet(workbook, worksheet, "스테이지상세")
-  
-  const filename = `스테이지상세_${new Date().toISOString().split('T')[0]}.xlsx`
-  XLSX.writeFile(workbook, filename)
-}
-
-// =============================================================================
-// 4. 유틸리티 함수들
-// =============================================================================
-
-function getStatusText(status: string): string {
-  switch (status) {
-    case 'PLANNED': return '계획됨'
-    case 'IN_PROGRESS': return '진행중'
-    case 'SUBMITTED': return '제출됨'
-    case 'UNDER_REVIEW': return '검토중'
-    case 'APPROVED': return '승인됨'
-    case 'REJECTED': return '반려됨'
-    case 'COMPLETED': return '완료됨'
-    default: return status
-  }
-}
-
-function getPriorityText(priority: string): string {
-  switch (priority) {
-    case 'HIGH': return '높음'
-    case 'MEDIUM': return '보통'
-    case 'LOW': return '낮음'
-    default: return priority
-  }
-}
-
-// 파일 크기 검증
-export function validateFileSize(file: File, maxSizeMB: number = 10): boolean {
-  const maxSizeBytes = maxSizeMB * 1024 * 1024
-  return file.size <= maxSizeBytes
-}
-
-// 파일 확장자 검증
-export function validateFileExtension(file: File): boolean {
-  const allowedExtensions = ['.xlsx', '.xls']
-  const fileName = file.name.toLowerCase()
-  return allowedExtensions.some(ext => fileName.endsWith(ext))
-}
-
-// ExcelJS 워크북의 유효성 검사
-export async function validateExcelWorkbook(file: File): Promise<{ 
-  isValid: boolean
-  error?: string 
-  worksheetCount?: number
-  firstWorksheetName?: string
-}> {
-  try {
-    const buffer = await file.arrayBuffer()
-    const workbook = new ExcelJS.Workbook()
-    await workbook.xlsx.load(buffer)
-    
-    const worksheets = workbook.worksheets
-    if (worksheets.length === 0) {
-      return {
-        isValid: false,
-        error: '워크시트가 없는 파일입니다'
-      }
-    }
-    
-    const firstWorksheet = worksheets[0]
-    if (firstWorksheet.rowCount < 2) {
-      return {
-        isValid: false,
-        error: '데이터가 없습니다. 최소 헤더와 1개 행이 필요합니다'
-      }
-    }
-    
-    return {
-      isValid: true,
-      worksheetCount: worksheets.length,
-      firstWorksheetName: firstWorksheet.name
-    }
-  } catch (error) {
-    return {
-      isValid: false,
-      error: `파일을 읽을 수 없습니다: ${error instanceof Error ? error.message : '알 수 없는 오류'}`
-    }
-  }
-}
-
-// 셀 값을 안전하게 문자열로 변환
-export function getCellValueAsString(cell: ExcelJS.Cell): string {
-  if (!cell.value) return ""
-  
-  if (cell.value instanceof Date) {
-    return cell.value.toISOString().split('T')[0]
-  }
-  
-  if (typeof cell.value === 'object' && 'text' in cell.value) {
-    return cell.value.text || ""
-  }
-  
-  if (typeof cell.value === 'object' && 'result' in cell.value) {
-    return String(cell.value.result || "")
-  }
-  
-  return String(cell.value)
-}
-
-// 엑셀 컬럼 인덱스를 문자로 변환 (A, B, C, ... Z, AA, AB, ...)
-export function getExcelColumnName(index: number): string {
-  let result = ""
-  while (index > 0) {
-    index--
-    result = String.fromCharCode(65 + (index % 26)) + result
-    index = Math.floor(index / 26)
-  }
-  return result
-}
\ No newline at end of file
diff --git a/lib/vendor-document-list/plant/excel-import-stage copy 2.tsx b/lib/vendor-document-list/plant/excel-import-stage copy 2.tsx
new file mode 100644
index 00000000..8dc85c51
--- /dev/null
+++ b/lib/vendor-document-list/plant/excel-import-stage copy 2.tsx
@@ -0,0 +1,899 @@
+"use client"
+
+import React from "react"
+import { Dialog, DialogContent, DialogDescription, DialogFooter, DialogHeader, DialogTitle } from "@/components/ui/dialog"
+import { Button } from "@/components/ui/button"
+import { Input } from "@/components/ui/input"
+import { Label } from "@/components/ui/label"
+import { Progress } from "@/components/ui/progress"
+import { Alert, AlertDescription } from "@/components/ui/alert"
+import { Upload, FileSpreadsheet, Loader2, Download, CheckCircle, AlertCircle } from "lucide-react"
+import { toast } from "sonner"
+import { useRouter } from "next/navigation"
+import ExcelJS from "exceljs"
+import {
+  getDocumentClassOptionsByContract,
+  uploadImportData,
+} from "./document-stages-service"
+
+// =============================================================================
+// Type Definitions
+// =============================================================================
+interface ExcelImportDialogProps {
+  open: boolean
+  onOpenChange: (open: boolean) => void
+  contractId: number
+  projectType: "ship" | "plant"
+}
+
+interface ImportResult {
+  documents: any[]
+  stages: any[]
+  errors: string[]
+  warnings: string[]
+}
+
+interface ParsedDocument {
+  docNumber: string
+  title: string
+  documentClass: string
+  vendorDocNumber?: string
+  notes?: string
+  stages?: { stageName: string; planDate: string }[]
+}
+
+// =============================================================================
+// Main Component
+// =============================================================================
+export function ExcelImportDialog({
+  open,
+  onOpenChange,
+  contractId,
+  projectType
+}: ExcelImportDialogProps) {
+  const [file, setFile] = React.useState<File | null>(null)
+  const [isProcessing, setIsProcessing] = React.useState(false)
+  const [isDownloadingTemplate, setIsDownloadingTemplate] = React.useState(false)
+  const [importResult, setImportResult] = React.useState<ImportResult | null>(null)
+  const [processStep, setProcessStep] = React.useState<string>("")
+  const [progress, setProgress] = React.useState(0)
+  const router = useRouter()
+
+  const handleFileChange = (e: React.ChangeEvent<HTMLInputElement>) => {
+    const selectedFile = e.target.files?.[0]
+    if (selectedFile) {
+      if (!validateFileExtension(selectedFile)) {
+        toast.error("Excel 파일(.xlsx, .xls)만 업로드 가능합니다.")
+        return
+      }
+      if (!validateFileSize(selectedFile, 10)) {
+        toast.error("파일 크기는 10MB 이하여야 합니다.")
+        return
+      }
+      setFile(selectedFile)
+      setImportResult(null)
+    }
+  }
+
+  const handleDownloadTemplate = async () => {
+    setIsDownloadingTemplate(true)
+    try {
+      const workbook = await createImportTemplate(projectType, contractId)
+      const buffer = await workbook.xlsx.writeBuffer()
+      const blob = new Blob([buffer], { type: "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" })
+      const url = window.URL.createObjectURL(blob)
+      const link = document.createElement("a")
+      link.href = url
+      link.download = `문서_임포트_템플릿_${projectType}_${new Date().toISOString().split("T")[0]}.xlsx`
+      link.click()
+      window.URL.revokeObjectURL(url)
+      toast.success("템플릿 파일이 다운로드되었습니다.")
+    } catch (error) {
+      toast.error("템플릿 다운로드 중 오류가 발생했습니다: " + (error instanceof Error ? error.message : "알 수 없는 오류"))
+    } finally {
+      setIsDownloadingTemplate(false)
+    }
+  }
+
+  const handleImport = async () => {
+    if (!file) {
+      toast.error("파일을 선택해주세요.")
+      return
+    }
+    setIsProcessing(true)
+    setProgress(0)
+    try {
+      setProcessStep("파일 읽는 중...")
+      setProgress(20)
+      const workbook = new ExcelJS.Workbook()
+      const buffer = await file.arrayBuffer()
+      await workbook.xlsx.load(buffer)
+
+      setProcessStep("데이터 검증 중...")
+      setProgress(40)
+      const worksheet = workbook.getWorksheet("Documents") || workbook.getWorksheet(1)
+      if (!worksheet) throw new Error("Documents 시트를 찾을 수 없습니다.")
+
+      setProcessStep("문서 및 스테이지 데이터 파싱 중...")
+      setProgress(60)
+      const parseResult = await parseDocumentsWithStages(worksheet, projectType, contractId)
+
+      setProcessStep("서버에 업로드 중...")
+      setProgress(90)
+      const allStages: any[] = []
+      parseResult.validData.forEach((doc) => {
+        if (doc.stages) {
+          doc.stages.forEach((stage) => {
+            allStages.push({
+              docNumber: doc.docNumber,
+              stageName: stage.stageName,
+              planDate: stage.planDate,
+            })
+          })
+        }
+      })
+
+      const result = await uploadImportData({
+        contractId,
+        documents: parseResult.validData,
+        stages: allStages,
+        projectType,
+      })
+
+      if (result.success) {
+        setImportResult({
+          documents: parseResult.validData,
+          stages: allStages,
+          errors: parseResult.errors,
+          warnings: result.warnings || [],
+        })
+        setProgress(100)
+        toast.success(`${parseResult.validData.length}개 문서가 성공적으로 임포트되었습니다.`)
+      } else {
+        throw new Error(result.error || "임포트에 실패했습니다.")
+      }
+    } catch (error) {
+      toast.error(error instanceof Error ? error.message : "임포트 중 오류가 발생했습니다.")
+      setImportResult({
+        documents: [],
+        stages: [],
+        errors: [error instanceof Error ? error.message : "알 수 없는 오류"],
+        warnings: [],
+      })
+    } finally {
+      setIsProcessing(false)
+      setProcessStep("")
+      setProgress(0)
+    }
+  }
+
+  const handleClose = () => {
+    setFile(null)
+    setImportResult(null)
+    setProgress(0)
+    setProcessStep("")
+    onOpenChange(false)
+  }
+
+  const handleConfirmImport = () => {
+    router.refresh()
+    handleClose()
+  }
+
+  return (
+    <Dialog open={open} onOpenChange={onOpenChange}>
+      <DialogContent className="sm:max-w-[700px] max-h-[90vh] flex flex-col">
+        <DialogHeader className="flex-shrink-0">
+          <DialogTitle>
+            <FileSpreadsheet className="inline w-5 h-5 mr-2" />
+            Excel 파일 임포트
+          </DialogTitle>
+          <DialogDescription>
+            Excel 파일을 사용하여 문서와 스테이지 계획을 일괄 등록합니다.
+          </DialogDescription>
+        </DialogHeader>
+
+        <div className="flex-1 overflow-y-auto pr-2">
+          <div className="grid gap-4 py-4">
+            {/* 템플릿 다운로드 섹션 */}
+            <div className="border rounded-lg p-4 bg-blue-50/30 dark:bg-blue-950/30">
+              <h4 className="font-medium text-blue-800 dark:text-blue-200 mb-2">1. 템플릿 다운로드</h4>
+              <p className="text-sm text-blue-700 dark:text-blue-300 mb-3">
+                올바른 형식과 스마트 검증이 적용된 템플릿을 다운로드하세요.
+              </p>
+              <Button variant="outline" size="sm" onClick={handleDownloadTemplate} disabled={isDownloadingTemplate}>
+                {isDownloadingTemplate ? <Loader2 className="h-4 w-4 animate-spin mr-2" /> : <Download className="h-4 w-4 mr-2" />}
+                템플릿 다운로드
+              </Button>
+            </div>
+
+            {/* 파일 업로드 섹션 */}
+            <div className="border rounded-lg p-4">
+              <h4 className="font-medium mb-2">2. 파일 업로드</h4>
+              <div className="grid gap-2">
+                <Label htmlFor="excel-file">Excel 파일 선택</Label>
+                <Input
+                  id="excel-file"
+                  type="file"
+                  accept=".xlsx,.xls"
+                  onChange={handleFileChange}
+                  disabled={isProcessing}
+                  className="file:mr-4 file:py-2 file:px-4 file:rounded-full file:border-0 file:text-sm file:font-semibold file:bg-blue-50 file:text-blue-700 hover:file:bg-blue-100"
+                />
+                {file && (
+                  <p className="text-sm text-gray-600 dark:text-gray-400 mt-1">
+                    선택된 파일: {file.name} ({(file.size / 1024 / 1024).toFixed(2)} MB)
+                  </p>
+                )}
+              </div>
+            </div>
+
+            {/* 진행 상태 */}
+            {isProcessing && (
+              <div className="border rounded-lg p-4 bg-yellow-50/30 dark:bg-yellow-950/30">
+                <div className="flex items-center gap-2 mb-2">
+                  <Loader2 className="h-4 w-4 animate-spin text-yellow-600" />
+                  <span className="text-sm font-medium text-yellow-800 dark:text-yellow-200">처리 중...</span>
+                </div>
+                <p className="text-sm text-yellow-700 dark:text-yellow-300 mb-2">{processStep}</p>
+                <Progress value={progress} className="h-2" />
+              </div>
+            )}
+
+            {/* 임포트 결과 */}
+            {importResult && <ImportResultDisplay importResult={importResult} />}
+
+            {/* 파일 형식 가이드 */}
+            <FileFormatGuide projectType={projectType} />
+          </div>
+        </div>
+
+        <DialogFooter className="flex-shrink-0">
+          <Button variant="outline" onClick={handleClose}>
+            {importResult ? "닫기" : "취소"}
+          </Button>
+          {!importResult ? (
+            <Button onClick={handleImport} disabled={!file || isProcessing}>
+              {isProcessing ? <Loader2 className="h-4 w-4 animate-spin mr-2" /> : <Upload className="h-4 w-4 mr-2" />}
+              {isProcessing ? "처리 중..." : "임포트 시작"}
+            </Button>
+          ) : importResult.documents.length > 0 ? (
+            <Button onClick={handleConfirmImport}>완료 및 새로고침</Button>
+          ) : null}
+        </DialogFooter>
+      </DialogContent>
+    </Dialog>
+  )
+}
+
+// =============================================================================
+// Sub Components
+// =============================================================================
+function ImportResultDisplay({ importResult }: { importResult: ImportResult }) {
+  return (
+    <div className="space-y-3">
+      {importResult.documents.length > 0 && (
+        <Alert>
+          <CheckCircle className="h-4 w-4" />
+          <AlertDescription>
+            <strong>{importResult.documents.length}개</strong> 문서가 성공적으로 임포트되었습니다.
+            {importResult.stages.length > 0 && <> ({importResult.stages.length}개 스테이지 계획날짜 포함)</>}
+          </AlertDescription>
+        </Alert>
+      )}
+
+      {importResult.warnings.length > 0 && (
+        <Alert>
+          <AlertCircle className="h-4 w-4" />
+          <AlertDescription>
+            <strong>경고:</strong>
+            <ul className="mt-1 list-disc list-inside">
+              {importResult.warnings.map((warning, index) => (
+                <li key={index} className="text-sm">
+                  {warning}
+                </li>
+              ))}
+            </ul>
+          </AlertDescription>
+        </Alert>
+      )}
+
+      {importResult.errors.length > 0 && (
+        <Alert variant="destructive">
+          <AlertCircle className="h-4 w-4" />
+          <AlertDescription>
+            <strong>오류:</strong>
+            <ul className="mt-1 list-disc list-inside">
+              {importResult.errors.map((error, index) => (
+                <li key={index} className="text-sm">
+                  {error}
+                </li>
+              ))}
+            </ul>
+          </AlertDescription>
+        </Alert>
+      )}
+    </div>
+  )
+}
+
+function FileFormatGuide({ projectType }: { projectType: "ship" | "plant" }) {
+  return (
+    <div className="bg-gray-50 dark:bg-gray-900 border border-gray-200 dark:border-gray-700 rounded-lg p-4">
+      <h4 className="font-medium text-gray-800 dark:text-gray-200 mb-2">파일 형식 가이드</h4>
+      <div className="text-sm text-gray-700 dark:text-gray-300 space-y-1">
+        <p>
+          <strong>통합 Documents 시트:</strong>
+        </p>
+        <ul className="ml-4 list-disc">
+          <li>Document Number* (문서번호)</li>
+          <li>Document Name* (문서명)</li>
+          <li>Document Class* (문서클래스 - 드롭다운 선택)</li>
+          <li>Project Doc No.* (프로젝트 문서번호)</li>
+          <li>각 Stage Name 컬럼 (계획날짜 입력: YYYY-MM-DD)</li>
+        </ul>
+        <p className="mt-2 text-green-600 dark:text-green-400">
+          <strong>스마트 검증 기능:</strong>
+        </p>
+        <ul className="ml-4 list-disc text-green-600 dark:text-green-400">
+          <li>Document Class 드롭다운으로 정확한 값 선택</li>
+          <li>선택한 Class에 맞지 않는 Stage는 자동으로 회색 처리</li>
+          <li>잘못된 Stage에 날짜 입력시 빨간색으로 경고</li>
+          <li>날짜 형식 자동 검증</li>
+        </ul>
+        <p className="mt-2 text-yellow-600 dark:text-yellow-400">
+          <strong>색상 가이드:</strong>
+        </p>
+        <ul className="ml-4 list-disc text-yellow-600 dark:text-yellow-400">
+          <li>🟦 파란색 헤더: 필수 입력 항목</li>
+          <li>🟩 초록색 헤더: 해당 Class의 유효한 Stage</li>
+          <li>⬜ 회색 셀: 해당 Class에서 사용 불가능한 Stage</li>
+          <li>🟥 빨간색 셀: 잘못된 입력 (검증 실패)</li>
+        </ul>
+        <p className="mt-2 text-red-600 dark:text-red-400">* 필수 항목</p>
+      </div>
+    </div>
+  )
+}
+
+// =============================================================================
+// Helper Functions
+// =============================================================================
+function validateFileExtension(file: File): boolean {
+  const allowedExtensions = [".xlsx", ".xls"]
+  const fileName = file.name.toLowerCase()
+  return allowedExtensions.some((ext) => fileName.endsWith(ext))
+}
+
+function validateFileSize(file: File, maxSizeMB: number): boolean {
+  const maxSizeBytes = maxSizeMB * 1024 * 1024
+  return file.size <= maxSizeBytes
+}
+
+function getExcelColumnName(index: number): string {
+  let result = ""
+  while (index > 0) {
+    index--
+    result = String.fromCharCode(65 + (index % 26)) + result
+    index = Math.floor(index / 26)
+  }
+  return result
+}
+
+function styleHeaderRow(
+  headerRow: ExcelJS.Row,
+  bgColor: string = "FF4472C4",
+  startCol?: number,
+  endCol?: number
+) {
+  const start = startCol || 1
+  const end = endCol || headerRow.cellCount
+
+  for (let i = start; i <= end; i++) {
+    const cell = headerRow.getCell(i)
+    cell.fill = {
+      type: "pattern",
+      pattern: "solid",
+      fgColor: { argb: bgColor },
+    }
+    cell.font = {
+      color: { argb: "FFFFFFFF" },
+      bold: true,
+    }
+    cell.alignment = {
+      horizontal: "center",
+      vertical: "middle",
+    }
+    cell.border = {
+      top: { style: "thin" },
+      left: { style: "thin" },
+      bottom: { style: "thin" },
+      right: { style: "thin" },
+    }
+  }
+  headerRow.height = 20
+}
+
+// =============================================================================
+// Template Creation - 통합 시트 + 조건부서식/검증
+// =============================================================================
+async function createImportTemplate(projectType: "ship" | "plant", contractId: number) {
+  const res = await getDocumentClassOptionsByContract(contractId)
+  if (!res.success) throw new Error(res.error || "데이터 로딩 실패")
+
+  const documentClasses = res.data.classes as Array<{ id: number; code: string; description: string }>
+  const options = res.data.options as Array<{ documentClassId: number; optionValue: string }>
+
+  // 클래스별 옵션 맵
+  const optionsByClassId = new Map<number, string[]>()
+  for (const c of documentClasses) optionsByClassId.set(c.id, [])
+  for (const o of options) optionsByClassId.get(o.documentClassId)!.push(o.optionValue)
+
+  // 유니크 Stage
+  const allStageNames = Array.from(new Set(options.map((o) => o.optionValue)))
+
+  const workbook = new ExcelJS.Workbook()
+  // 파일 열 때 강제 전체 계산
+  workbook.calcProperties.fullCalcOnLoad = true
+
+  // ================= Documents 시트 =================
+  const worksheet = workbook.addWorksheet("Documents")
+
+  const headers = [
+    "Document Number*",
+    "Document Name*",
+    "Document Class*",
+    ...(projectType === "plant" ? ["Project Doc No.*"] : []),
+    ...allStageNames,
+  ]
+  const headerRow = worksheet.addRow(headers)
+
+  // 필수 헤더 (파랑)
+  const requiredCols = projectType === "plant" ? 4 : 3
+  styleHeaderRow(headerRow, "FF4472C4", 1, requiredCols)
+  // Stage 헤더 (초록)
+  styleHeaderRow(headerRow, "FF27AE60", requiredCols + 1, headers.length)
+
+  // 샘플 데이터
+  const firstClass = documentClasses[0]
+  const firstClassStages = firstClass ? optionsByClassId.get(firstClass.id) ?? [] : []
+  const sampleRow = [
+    projectType === "ship" ? "SH-2024-001" : "PL-2024-001",
+    "샘플 문서명",
+    firstClass ? firstClass.description : "",
+    ...(projectType === "plant" ? ["V-001"] : []),
+    ...allStageNames.map((s) => (firstClassStages.includes(s) ? "2024-03-01" : "")),
+  ]
+  worksheet.addRow(sampleRow)
+
+  const docNumberColIndex = 1; // A: Document Number*
+  const docNameColIndex = 2; // B: Document Name*
+  const docNumberColLetter = getExcelColumnName(docNumberColIndex);
+  const docNameColLetter = getExcelColumnName(docNameColIndex);
+
+  worksheet.dataValidations.add(`${docNumberColLetter}2:${docNumberColLetter}1000`, {
+    type: "textLength",
+    operator: "greaterThan",
+    formulae: [0],
+    allowBlank: false,
+    showErrorMessage: true,
+    errorTitle: "필수 입력",
+    error: "Document Number는 필수 항목입니다.",
+  });
+
+  // 1) 빈값 금지 (길이 > 0)
+  worksheet.dataValidations.add(`${docNumberColLetter}2:${docNumberColLetter}1000`, {
+    type: "textLength",
+    operator: "greaterThan",
+    formulae: [0],
+    allowBlank: false,
+    showErrorMessage: true,
+    errorTitle: "필수 입력",
+    error: "Document Number는 필수 항목입니다.",
+  });
+
+
+  // 드롭다운: Document Class
+  const docClassColIndex = 3 // "Document Class*"는 항상 3열
+  const docClassColLetter = getExcelColumnName(docClassColIndex)
+  worksheet.dataValidations.add(`${docClassColLetter}2:${docClassColLetter}1000`, {
+    type: "list",
+    allowBlank: false,
+    formulae: [`ReferenceData!$A$2:$A${documentClasses.length + 1}`],
+    showErrorMessage: true,
+    errorTitle: "잘못된 입력",
+    error: "드롭다운 목록에서 Document Class를 선택하세요.",
+  })
+
+    // 2) 중복 금지 (COUNTIF로 현재 값이 범위에서 1회만 등장해야 함)
+  //   - Validation은 한 셀에 1개만 가능하므로, 중복 검증은 "Custom" 하나로 통합하는 방법도 있음.
+  //   - 여기서는 '중복 금지'를 추가적으로 **Guidance용**으로 Conditional Formatting(빨간색)으로 가시화합니다.
+  worksheet.addConditionalFormatting({
+    ref: `${docNumberColLetter}2:${docNumberColLetter}1000`,
+    rules: [
+      // 빈값 빨간
+      {
+        type: "expression",
+        formulae: [`LEN(${docNumberColLetter}2)=0`],
+        style: {
+          fill: { type: "pattern", pattern: "solid", bgColor: { argb: "FFFFC7CE" } },
+        },
+      },
+      // 중복 빨간: COUNTIF($A$2:$A$1000, A2) > 1
+      {
+        type: "expression",
+        formulae: [`COUNTIF($${docNumberColLetter}$2:$${docNumberColLetter}$1000,${docNumberColLetter}2)>1`],
+        style: {
+          fill: { type: "pattern", pattern: "solid", bgColor: { argb: "FFFFC7CE" } },
+        },
+      },
+    ],
+  });
+
+
+  // ===== Document Name* (B열): 빈값 금지 + 빈칸 빨간 =====
+worksheet.dataValidations.add(`${docNameColLetter}2:${docNameColLetter}1000`, {
+  type: "textLength",
+  operator: "greaterThan",
+  formulae: [0],
+  allowBlank: false,
+  showErrorMessage: true,
+  errorTitle: "필수 입력",
+  error: "Document Name은 필수 항목입니다.",
+});
+
+worksheet.addConditionalFormatting({
+  ref: `${docNameColLetter}2:${docNameColLetter}1000`,
+  rules: [
+    {
+      type: "expression",
+      formulae: [`LEN(${docNameColLetter}2)=0`],
+      style: {
+        fill: { type: "pattern", pattern: "solid", bgColor: { argb: "FFFFC7CE" } },
+      },
+    },
+  ],
+});
+
+// ===== Document Class* (C열): 드롭다운 + allowBlank:false로 차단은 되어 있음 → 빈칸 빨간만 추가 =====
+worksheet.addConditionalFormatting({
+  ref: `${docClassColLetter}2:${docClassColLetter}1000`,
+  rules: [
+    {
+      type: "expression",
+      formulae: [`LEN(${docClassColLetter}2)=0`],
+      style: {
+        fill: { type: "pattern", pattern: "solid", bgColor: { argb: "FFFFC7CE" } },
+      },
+    },
+  ],
+});
+
+// ===== Project Doc No.* (Plant 전용): (이미 작성하신 코드 유지) =====
+if (projectType === "plant") {
+  const vendorDocColIndex = 4; // D
+  const vendorDocColLetter = getExcelColumnName(vendorDocColIndex);
+
+  worksheet.dataValidations.add(`${vendorDocColLetter}2:${vendorDocColLetter}1000`, {
+    type: "textLength",
+    operator: "greaterThan",
+    formulae: [0],
+    allowBlank: false,
+    showErrorMessage: true,
+    errorTitle: "필수 입력",
+    error: "Project Doc No.는 필수 항목입니다.",
+  });
+
+  worksheet.addConditionalFormatting({
+    ref: `${vendorDocColLetter}2:${vendorDocColLetter}1000`,
+    rules: [
+      {
+        type: "expression",
+        formulae: [`LEN(${vendorDocColLetter}2)=0`],
+        style: {
+          fill: { type: "pattern", pattern: "solid", bgColor: { argb: "FFFFC7CE" } },
+        },
+      },
+        // 중복 빨간: COUNTIF($A$2:$A$1000, A2) > 1
+        {
+          type: "expression",
+          formulae: [`COUNTIF($${vendorDocColLetter}$2:$${vendorDocColLetter}$1000,${vendorDocColLetter}2)>1`],
+          style: {
+            fill: { type: "pattern", pattern: "solid", bgColor: { argb: "FFFFC7CE" } },
+          },
+        },
+    ],
+  });
+
+}
+
+  if (projectType === "plant") {
+    const vendorDocColIndex = 4; // Document Number, Name, Class 다음이 Project Doc No.*
+    const vendorDocColLetter = getExcelColumnName(vendorDocColIndex);
+
+    // 공백 불가: 글자수 > 0
+    worksheet.dataValidations.add(`${vendorDocColLetter}2:${vendorDocColLetter}1000`, {
+      type: "textLength",
+      operator: "greaterThan",
+      formulae: [0],
+      allowBlank: false,
+      showErrorMessage: true,
+      errorTitle: "필수 입력",
+      error: "Project Doc No.는 필수 항목입니다.",
+    });
+
+    // UX: 비어있으면 빨간 배경으로 표시 (조건부 서식)
+    worksheet.addConditionalFormatting({
+      ref: `${vendorDocColLetter}2:${vendorDocColLetter}1000`,
+      rules: [
+        {
+          type: "expression",
+          formulae: [`LEN(${vendorDocColLetter}2)=0`],
+          style: {
+            fill: { type: "pattern", pattern: "solid", bgColor: { argb: "FFFFC7CE" } }, // 연한 빨강
+          },
+        },
+      ],
+    });
+  }
+
+  // 날짜 셀 형식 + 검증/조건부서식
+  const stageStartCol = requiredCols + 1
+  const stageEndCol = stageStartCol + allStageNames.length - 1
+
+  // ================= 매트릭스 시트 (Class-Stage Matrix) =================
+  const matrixSheet = workbook.addWorksheet("Class-Stage Matrix")
+  const matrixHeaders = ["Document Class", ...allStageNames]
+  const matrixHeaderRow = matrixSheet.addRow(matrixHeaders)
+  styleHeaderRow(matrixHeaderRow, "FF34495E")
+  for (const docClass of documentClasses) {
+    const validStages = new Set(optionsByClassId.get(docClass.id) ?? [])
+    const row = [docClass.description, ...allStageNames.map((stage) => (validStages.has(stage) ? "✓" : ""))]
+    const dataRow = matrixSheet.addRow(row)
+    allStageNames.forEach((stage, idx) => {
+      const cell = dataRow.getCell(idx + 2)
+      if (validStages.has(stage)) {
+        cell.fill = { type: "pattern", pattern: "solid", fgColor: { argb: "FFD4EDDA" } }
+        cell.font = { color: { argb: "FF28A745" } }
+      }
+    })
+  }
+  matrixSheet.columns = [{ width: 30 }, ...allStageNames.map(() => ({ width: 15 }))]
+
+  // 매트릭스 범위 계산 (B ~ 마지막 Stage 열)
+  const matrixStageFirstColLetter = "B"
+  const matrixStageLastColLetter = getExcelColumnName(1 + allStageNames.length) // 1:A, 2:B ... (A는 Class, B부터 Stage)
+  const matrixClassCol = "$A:$A"
+  const matrixHeaderRowRange = "$1:$1"
+  const matrixBodyRange = `$${matrixStageFirstColLetter}:$${matrixStageLastColLetter}`
+
+  // ================= 가이드 시트 =================
+  const guideSheet = workbook.addWorksheet("사용 가이드")
+  const guideContent: string[][] = [
+    ["📋 통합 문서 임포트 가이드"],
+    [""],
+    ["1. 하나의 시트에서 모든 정보 관리"],
+    ["   • Document Number*: 고유한 문서 번호"],
+    ["   • Document Name*: 문서명"],
+    ["   • Document Class*: 드롭다운에서 선택"],
+    ...(projectType === "plant" ? [["   • Project Doc No.: 벤더 문서 번호"]] : []),
+    ["   • Stage 컬럼들: 각 스테이지의 계획 날짜 (YYYY-MM-DD)"],
+    [""],
+    ["2. 스마트 검증 기능"],
+    ["   • Document Class를 선택하면 해당하지 않는 Stage는 자동으로 비활성화(회색)"],
+    ["   • 비유효 Stage에 날짜 입력 시 입력 자체가 막히고 경고 표시"],
+    ["   • 날짜 형식 자동 검증"],
+    [""],
+    ["3. Class-Stage Matrix 시트 활용"],
+    ["   • 각 Document Class별로 사용 가능한 Stage 확인"],
+    ["   • ✓ 표시가 있는 Stage만 해당 Class에서 사용 가능"],
+    [""],
+    ["4. 작성 순서"],
+    ["   ① Document Number, Name 입력"],
+    ["   ② Document Class 드롭다운에서 선택"],
+    ["   ③ Class-Stage Matrix 확인하여 유효한 Stage 파악"],
+    ["   ④ 해당 Stage 컬럼에만 날짜 입력"],
+    [""],
+    ["5. 주의사항"],
+    ["   • * 표시는 필수 항목"],
+    ["   • Document Number는 중복 불가"],
+    ["   • 해당 Class에 맞지 않는 Stage에 날짜 입력 시 무시/차단"],
+    ["   • 날짜는 YYYY-MM-DD 형식 준수"],
+  ]
+  guideContent.forEach((row, i) => {
+    const r = guideSheet.addRow(row)
+    if (i === 0) r.getCell(1).font = { bold: true, size: 14 }
+    else if (row[0] && !row[0].startsWith("   ")) r.getCell(1).font = { bold: true }
+  })
+  guideSheet.getColumn(1).width = 70
+
+  // ================= ReferenceData (숨김) =================
+  const referenceSheet = workbook.addWorksheet("ReferenceData", { state: "hidden" })
+  referenceSheet.getCell("A1").value = "DocumentClasses"
+  documentClasses.forEach((dc, idx) => {
+    referenceSheet.getCell(`A${idx + 2}`).value = dc.description
+  })
+
+  // ================= Stage 열별 서식/검증 =================
+  // 문서 시트 컬럼 너비
+  worksheet.columns = [
+    { width: 18 }, // Doc Number
+    { width: 30 }, // Doc Name
+    { width: 30 }, // Doc Class
+    ...(projectType === "plant" ? [{ width: 18 }] : []),
+    ...allStageNames.map(() => ({ width: 12 })),
+  ]
+
+  // 각 Stage 열 처리
+  for (let stageIdx = 0; stageIdx < allStageNames.length; stageIdx++) {
+    const colIndex = stageStartCol + stageIdx
+    const colLetter = getExcelColumnName(colIndex)
+
+    // 날짜 표시 형식
+    for (let row = 2; row <= 1000; row++) {
+      worksheet.getCell(`${colLetter}${row}`).numFmt = "yyyy-mm-dd"
+    }
+
+    // ---- 커스텀 데이터 검증 (빈칸 OR (해당 Class에 유효한 Stage AND 숫자(=날짜))) ----
+    // INDEX('Class-Stage Matrix'!$B:$ZZ, MATCH($C2,'Class-Stage Matrix'!$A:$A,0), MATCH(H$1,'Class-Stage Matrix'!$1:$1,0))
+    const validationFormula =
+      `=OR(` +
+      `LEN(${colLetter}2)=0,` +
+      `AND(` +
+      `INDEX('Class-Stage Matrix'!$${matrixStageFirstColLetter}:$${matrixStageLastColLetter},` +
+      `MATCH($${docClassColLetter}2,'Class-Stage Matrix'!${matrixClassCol},0),` +
+      `MATCH(${colLetter}$1,'Class-Stage Matrix'!${matrixHeaderRowRange},0)` +
+      `)<>\"\",` +
+      `ISNUMBER(${colLetter}2)` +
+      `)` +
+      `)`
+    worksheet.dataValidations.add(`${colLetter}2:${colLetter}1000`, {
+      type: "custom",
+      allowBlank: true,
+      formulae: [validationFormula],
+      showErrorMessage: true,
+      errorTitle: "허용되지 않은 입력",
+      error: "이 Stage는 선택한 Document Class에서 사용할 수 없거나 날짜 형식이 아닙니다.",
+    })
+
+    // ---- 조건부 서식 (유효하지 않은 Stage → 회색 배경) ----
+    // TRUE이면 서식 적용: INDEX(...)=""  -> 유효하지 않음
+    const cfFormula =
+      `IFERROR(` +
+      `INDEX('Class-Stage Matrix'!$${matrixStageFirstColLetter}:$${matrixStageLastColLetter},` +
+      `MATCH($${docClassColLetter}2,'Class-Stage Matrix'!${matrixClassCol},0),` +
+      `MATCH(${colLetter}$1,'Class-Stage Matrix'!${matrixHeaderRowRange},0)` +
+      `)=\"\",` +
+      `TRUE` + // 매치 실패 등 오류 시에도 회색 처리
+      `)`
+    worksheet.addConditionalFormatting({
+      ref: `${colLetter}2:${colLetter}1000`,
+      rules: [
+        {
+          type: "expression",
+          formulae: [cfFormula],
+          style: {
+            fill: { type: "pattern", pattern: "solid", bgColor: { argb: "FFEFEFEF" } }, // 연회색
+          },
+        },
+      ],
+    })
+  }
+
+  return workbook
+}
+
+// =============================================================================
+// Parse Documents with Stages - 통합 파싱
+// =============================================================================
+async function parseDocumentsWithStages(
+  worksheet: ExcelJS.Worksheet,
+  projectType: "ship" | "plant",
+  contractId: number
+): Promise<{ validData: ParsedDocument[]; errors: string[] }> {
+  const documents: ParsedDocument[] = []
+  const errors: string[] = []
+  const seenDocNumbers = new Set<string>()
+
+  const res = await getDocumentClassOptionsByContract(contractId)
+  if (!res.success) {
+    errors.push("Document Class 정보를 불러올 수 없습니다")
+    return { validData: [], errors }
+  }
+  const documentClasses = res.data.classes as Array<{ id: number; description: string }>
+  const options = res.data.options as Array<{ documentClassId: number; optionValue: string }>
+
+  // 클래스별 유효한 스테이지 맵
+  const validStagesByClass = new Map<string, Set<string>>()
+  for (const c of documentClasses) {
+    const stages = options.filter((o) => o.documentClassId === c.id).map((o) => o.optionValue)
+    validStagesByClass.set(c.description, new Set(stages))
+  }
+
+  // 헤더 파싱
+  const headerRow = worksheet.getRow(1)
+  const headers: string[] = []
+  headerRow.eachCell((cell, colNumber) => {
+    headers[colNumber - 1] = String(cell.value || "").trim()
+  })
+
+  const docNumberIdx = headers.findIndex((h) => h.includes("Document Number"))
+  const docNameIdx = headers.findIndex((h) => h.includes("Document Name"))
+  const docClassIdx = headers.findIndex((h) => h.includes("Document Class"))
+  const vendorDocNoIdx = projectType === "plant" ? headers.findIndex((h) => h.includes("Project Doc No")) : -1
+
+  if (docNumberIdx === -1 || docNameIdx === -1 || docClassIdx === -1) {
+    errors.push("필수 헤더가 누락되었습니다")
+    return { validData: [], errors }
+  }
+
+  const stageStartIdx = projectType === "plant" ? 4 : 3 // headers slice 기준(0-index)
+  const stageHeaders = headers.slice(stageStartIdx)
+
+  // 데이터 행 파싱
+  worksheet.eachRow((row, rowNumber) => {
+    if (rowNumber === 1) return
+    const docNumber = String(row.getCell(docNumberIdx + 1).value || "").trim()
+    const docName = String(row.getCell(docNameIdx + 1).value || "").trim()
+    const docClass = String(row.getCell(docClassIdx + 1).value || "").trim()
+    const vendorDocNo = vendorDocNoIdx >= 0 ? String(row.getCell(vendorDocNoIdx + 1).value || "").trim() : undefined
+
+    if (!docNumber && !docName) return
+    if (!docNumber) {
+      errors.push(`행 ${rowNumber}: Document Number가 없습니다`)
+      return
+    }
+    if (!docName) {
+      errors.push(`행 ${rowNumber}: Document Name이 없습니다`)
+      return
+    }
+    if (!docClass) {
+      errors.push(`행 ${rowNumber}: Document Class가 없습니다`)
+      return
+    }
+    if (projectType === "plant" && !vendorDocNo) {
+      errors.push(`행 ${rowNumber}: Project Doc No.가 없습니다`)
+      return
+    }
+    if (seenDocNumbers.has(docNumber)) {
+      errors.push(`행 ${rowNumber}: 중복된 Document Number: ${docNumber}`)
+      return
+    }
+    seenDocNumbers.add(docNumber)
+
+    const validStages = validStagesByClass.get(docClass)
+    if (!validStages) {
+      errors.push(`행 ${rowNumber}: 유효하지 않은 Document Class: ${docClass}`)
+      return
+    }
+
+
+
+    const stages: { stageName: string; planDate: string }[] = []
+    stageHeaders.forEach((stageName, idx) => {
+      if (validStages.has(stageName)) {
+        const cell = row.getCell(stageStartIdx + idx + 1)
+        let planDate = ""
+        if (cell.value) {
+          if (cell.value instanceof Date) {
+            planDate = cell.value.toISOString().split("T")[0]
+          } else {
+            const dateStr = String(cell.value).trim()
+            if (/^\d{4}-\d{2}-\d{2}$/.test(dateStr)) planDate = dateStr
+          }
+          if (planDate) stages.push({ stageName, planDate })
+        }
+      }
+    })
+
+    documents.push({
+      docNumber,
+      title: docName,
+      documentClass: docClass,
+      vendorDocNumber: vendorDocNo,
+      stages,
+    })
+  })
+
+  return { validData: documents, errors }
+}
diff --git a/lib/vendor-document-list/plant/excel-import-stage copy.tsx b/lib/vendor-document-list/plant/excel-import-stage copy.tsx
new file mode 100644
index 00000000..068383af
--- /dev/null
+++ b/lib/vendor-document-list/plant/excel-import-stage copy.tsx
@@ -0,0 +1,908 @@
+
+
+"use client"
+
+import React from "react"
+import { Dialog, DialogContent, DialogDescription, DialogFooter, DialogHeader, DialogTitle } from "@/components/ui/dialog"
+import { Button } from "@/components/ui/button"
+import { Input } from "@/components/ui/input"
+import { Label } from "@/components/ui/label"
+import { Progress } from "@/components/ui/progress"
+import { Alert, AlertDescription } from "@/components/ui/alert"
+import { Upload, FileSpreadsheet, Loader2, Download, CheckCircle, AlertCircle } from "lucide-react"
+import { toast } from "sonner"
+import { useRouter } from "next/navigation"
+import ExcelJS from 'exceljs'
+import {
+  getDocumentClassOptionsByContract,
+  // These functions need to be implemented in document-stages-service
+  uploadImportData,
+} from "./document-stages-service"
+
+// =============================================================================
+// Type Definitions
+// =============================================================================
+interface ExcelImportDialogProps {
+  open: boolean
+  onOpenChange: (open: boolean) => void
+  contractId: number
+  projectType: "ship" | "plant"
+}
+
+interface ImportResult {
+  documents: any[]
+  stages: any[]
+  errors: string[]
+  warnings: string[]
+}
+
+// =============================================================================
+// Main Component
+// =============================================================================
+export function ExcelImportDialog({
+  open,
+  onOpenChange,
+  contractId,
+  projectType
+}: ExcelImportDialogProps) {
+  const [file, setFile] = React.useState<File | null>(null)
+  const [isProcessing, setIsProcessing] = React.useState(false)
+  const [isDownloadingTemplate, setIsDownloadingTemplate] = React.useState(false)
+  const [importResult, setImportResult] = React.useState<ImportResult | null>(null)
+  const [processStep, setProcessStep] = React.useState<string>("")
+  const [progress, setProgress] = React.useState(0)
+  const router = useRouter()
+
+  const handleFileChange = (e: React.ChangeEvent<HTMLInputElement>) => {
+    const selectedFile = e.target.files?.[0]
+    if (selectedFile) {
+      // 파일 유효성 검사
+      if (!validateFileExtension(selectedFile)) {
+        toast.error("Excel 파일(.xlsx, .xls)만 업로드 가능합니다.")
+        return
+      }
+      
+      if (!validateFileSize(selectedFile, 10)) {
+        toast.error("파일 크기는 10MB 이하여야 합니다.")
+        return
+      }
+      
+      setFile(selectedFile)
+      setImportResult(null)
+    }
+  }
+
+  const handleDownloadTemplate = async () => {
+    setIsDownloadingTemplate(true)
+    try {
+      const workbook = await createImportTemplate(projectType, contractId)
+      const buffer = await workbook.xlsx.writeBuffer()
+      
+      const blob = new Blob([buffer], { 
+        type: 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet' 
+      })
+      
+      const url = window.URL.createObjectURL(blob)
+      const link = document.createElement('a')
+      link.href = url
+      link.download = `문서_임포트_템플릿_${projectType}_${new Date().toISOString().split('T')[0]}.xlsx`
+      link.click()
+      
+      window.URL.revokeObjectURL(url)
+      toast.success("템플릿 파일이 다운로드되었습니다.")
+    } catch (error) {
+      toast.error("템플릿 다운로드 중 오류가 발생했습니다: " + (error instanceof Error ? error.message : "알 수 없는 오류"))
+    } finally {
+      setIsDownloadingTemplate(false)
+    }
+  }
+
+  const handleImport = async () => {
+    if (!file) {
+      toast.error("파일을 선택해주세요.")
+      return
+    }
+
+    setIsProcessing(true)
+    setProgress(0)
+    
+    try {
+      setProcessStep("파일 읽는 중...")
+      setProgress(20)
+      
+      const workbook = new ExcelJS.Workbook()
+      const buffer = await file.arrayBuffer()
+      await workbook.xlsx.load(buffer)
+      
+      setProcessStep("데이터 검증 중...")
+      setProgress(40)
+      
+      // 워크시트 확인
+      const documentsSheet = workbook.getWorksheet('Documents') || workbook.getWorksheet(1)
+      const stagesSheet = workbook.getWorksheet('Stage Plan Dates') || workbook.getWorksheet(2)
+      
+      if (!documentsSheet) {
+        throw new Error("Documents 시트를 찾을 수 없습니다.")
+      }
+      
+      setProcessStep("문서 데이터 파싱 중...")
+      setProgress(60)
+      
+      // 문서 데이터 파싱
+      const documentData = await parseDocumentsSheet(documentsSheet, projectType)
+      
+      setProcessStep("스테이지 데이터 파싱 중...")
+      setProgress(80)
+      
+      // 스테이지 데이터 파싱 (선택사항)
+      let stageData: any[] = []
+      if (stagesSheet) {
+        stageData = await parseStagesSheet(stagesSheet)
+      }
+      
+      setProcessStep("서버에 업로드 중...")
+      setProgress(90)
+      
+      // 서버로 데이터 전송
+      const result = await uploadImportData({
+        contractId,
+        documents: documentData.validData,
+        stages: stageData,
+        projectType
+      })
+      
+      if (result.success) {
+        setImportResult({
+          documents: documentData.validData,
+          stages: stageData,
+          errors: documentData.errors,
+          warnings: result.warnings || []
+        })
+        setProgress(100)
+        toast.success(`${documentData.validData.length}개 문서가 성공적으로 임포트되었습니다.`)
+      } else {
+        throw new Error(result.error || "임포트에 실패했습니다.")
+      }
+      
+    } catch (error) {
+      toast.error(error instanceof Error ? error.message : "임포트 중 오류가 발생했습니다.")
+      setImportResult({
+        documents: [],
+        stages: [],
+        errors: [error instanceof Error ? error.message : "알 수 없는 오류"],
+        warnings: []
+      })
+    } finally {
+      setIsProcessing(false)
+      setProcessStep("")
+      setProgress(0)
+    }
+  }
+
+  const handleClose = () => {
+    setFile(null)
+    setImportResult(null)
+    setProgress(0)
+    setProcessStep("")
+    onOpenChange(false)
+  }
+
+  const handleConfirmImport = () => {
+    router.refresh()
+    handleClose()
+  }
+
+  return (
+    <Dialog open={open} onOpenChange={onOpenChange}>
+      <DialogContent className="sm:max-w-[600px] max-h-[90vh] flex flex-col">
+        <DialogHeader className="flex-shrink-0">
+          <DialogTitle>
+            <FileSpreadsheet className="inline w-5 h-5 mr-2" />
+            Excel 파일 임포트
+          </DialogTitle>
+          <DialogDescription>
+            Excel 파일을 사용하여 문서를 일괄 등록합니다.
+          </DialogDescription>
+        </DialogHeader>
+
+        <div className="flex-1 overflow-y-auto pr-2">
+          <div className="grid gap-4 py-4">
+            {/* 템플릿 다운로드 섹션 */}
+            <div className="border rounded-lg p-4 bg-blue-50/30 dark:bg-blue-950/30">
+              <h4 className="font-medium text-blue-800 dark:text-blue-200 mb-2">1. 템플릿 다운로드</h4>
+              <p className="text-sm text-blue-700 dark:text-blue-300 mb-3">
+                올바른 형식과 드롭다운이 적용된 템플릿을 다운로드하세요.
+              </p>
+              <Button 
+                variant="outline" 
+                size="sm"
+                onClick={handleDownloadTemplate}
+                disabled={isDownloadingTemplate}
+              >
+                {isDownloadingTemplate ? (
+                  <Loader2 className="h-4 w-4 animate-spin mr-2" />
+                ) : (
+                  <Download className="h-4 w-4 mr-2" />
+                )}
+                템플릿 다운로드
+              </Button>
+            </div>
+
+            {/* 파일 업로드 섹션 */}
+            <div className="border rounded-lg p-4">
+              <h4 className="font-medium mb-2">2. 파일 업로드</h4>
+              <div className="grid gap-2">
+                <Label htmlFor="excel-file">Excel 파일 선택</Label>
+                <Input
+                  id="excel-file"
+                  type="file"
+                  accept=".xlsx,.xls"
+                  onChange={handleFileChange}
+                  disabled={isProcessing}
+                  className="file:mr-4 file:py-2 file:px-4 file:rounded-full file:border-0 file:text-sm file:font-semibold file:bg-blue-50 file:text-blue-700 hover:file:bg-blue-100"
+                />
+                {file && (
+                  <p className="text-sm text-gray-600 dark:text-gray-400 mt-1">
+                    선택된 파일: {file.name} ({(file.size / 1024 / 1024).toFixed(2)} MB)
+                  </p>
+                )}
+              </div>
+            </div>
+
+            {/* 진행 상태 */}
+            {isProcessing && (
+              <div className="border rounded-lg p-4 bg-yellow-50/30 dark:bg-yellow-950/30">
+                <div className="flex items-center gap-2 mb-2">
+                  <Loader2 className="h-4 w-4 animate-spin text-yellow-600" />
+                  <span className="text-sm font-medium text-yellow-800 dark:text-yellow-200">처리 중...</span>
+                </div>
+                <p className="text-sm text-yellow-700 dark:text-yellow-300 mb-2">{processStep}</p>
+                <Progress value={progress} className="h-2" />
+              </div>
+            )}
+
+            {/* 임포트 결과 */}
+            {importResult && (
+              <ImportResultDisplay importResult={importResult} />
+            )}
+
+            {/* 파일 형식 가이드 */}
+            <FileFormatGuide projectType={projectType} />
+          </div>
+        </div>
+
+        <DialogFooter className="flex-shrink-0">
+          <Button variant="outline" onClick={handleClose}>
+            {importResult ? "닫기" : "취소"}
+          </Button>
+          {!importResult ? (
+            <Button 
+              onClick={handleImport} 
+              disabled={!file || isProcessing}
+            >
+              {isProcessing ? (
+                <Loader2 className="h-4 w-4 animate-spin mr-2" />
+              ) : (
+                <Upload className="h-4 w-4 mr-2" />
+              )}
+              {isProcessing ? "처리 중..." : "임포트 시작"}
+            </Button>
+          ) : importResult.documents.length > 0 ? (
+            <Button onClick={handleConfirmImport}>
+              완료 및 새로고침
+            </Button>
+          ) : null}
+        </DialogFooter>
+      </DialogContent>
+    </Dialog>
+  )
+}
+
+// =============================================================================
+// Sub Components
+// =============================================================================
+function ImportResultDisplay({ importResult }: { importResult: ImportResult }) {
+  return (
+    <div className="space-y-3">
+      {importResult.documents.length > 0 && (
+        <Alert>
+          <CheckCircle className="h-4 w-4" />
+          <AlertDescription>
+            <strong>{importResult.documents.length}개</strong> 문서가 성공적으로 임포트되었습니다.
+            {importResult.stages.length > 0 && (
+              <> ({importResult.stages.length}개 스테이지 계획날짜 포함)</>
+            )}
+          </AlertDescription>
+        </Alert>
+      )}
+      
+      {importResult.warnings.length > 0 && (
+        <Alert>
+          <AlertCircle className="h-4 w-4" />
+          <AlertDescription>
+            <strong>경고:</strong>
+            <ul className="mt-1 list-disc list-inside">
+              {importResult.warnings.map((warning, index) => (
+                <li key={index} className="text-sm">{warning}</li>
+              ))}
+            </ul>
+          </AlertDescription>
+        </Alert>
+      )}
+
+      {importResult.errors.length > 0 && (
+        <Alert variant="destructive">
+          <AlertCircle className="h-4 w-4" />
+          <AlertDescription>
+            <strong>오류:</strong>
+            <ul className="mt-1 list-disc list-inside">
+              {importResult.errors.map((error, index) => (
+                <li key={index} className="text-sm">{error}</li>
+              ))}
+            </ul>
+          </AlertDescription>
+        </Alert>
+      )}
+    </div>
+  )
+}
+
+function FileFormatGuide({ projectType }: { projectType: "ship" | "plant" }) {
+  return (
+    <div className="bg-gray-50 dark:bg-gray-900 border border-gray-200 dark:border-gray-700 rounded-lg p-4">
+      <h4 className="font-medium text-gray-800 dark:text-gray-200 mb-2">파일 형식 가이드</h4>
+      <div className="text-sm text-gray-700 dark:text-gray-300 space-y-1">
+        <p><strong>Documents 시트:</strong></p>
+        <ul className="ml-4 list-disc">
+          <li>Document Number* (문서번호)</li>
+          <li>Document Name* (문서명)</li>
+          <li>Document Class* (문서클래스 - 드롭다운 선택)</li>
+          {projectType === "plant" && (
+            <li>Project Doc No. (벤더문서번호)</li>
+          )}
+        </ul>
+        <p className="mt-2"><strong>Stage Plan Dates 시트 (선택사항):</strong></p>
+        <ul className="ml-4 list-disc">
+          <li>Document Number* (문서번호)</li>
+          <li>Stage Name* (스테이지명 - 드롭다운 선택)</li>
+          <li>Plan Date (계획날짜: YYYY-MM-DD)</li>
+        </ul>
+        <p className="mt-2 text-green-600 dark:text-green-400"><strong>스마트 기능:</strong></p>
+        <ul className="ml-4 list-disc text-green-600 dark:text-green-400">
+          <li>Document Class는 드롭다운으로 정확한 값만 선택 가능</li>
+          <li>Stage Name도 드롭다운으로 오타 방지</li>
+          <li>"사용 가이드" 시트에서 각 클래스별 사용 가능한 스테이지 확인 가능</li>
+        </ul>
+        <p className="mt-2 text-red-600 dark:text-red-400">* 필수 항목</p>
+      </div>
+    </div>
+  )
+}
+
+// =============================================================================
+// Helper Functions
+// =============================================================================
+function validateFileExtension(file: File): boolean {
+  const allowedExtensions = ['.xlsx', '.xls']
+  const fileName = file.name.toLowerCase()
+  return allowedExtensions.some(ext => fileName.endsWith(ext))
+}
+
+function validateFileSize(file: File, maxSizeMB: number): boolean {
+  const maxSizeBytes = maxSizeMB * 1024 * 1024
+  return file.size <= maxSizeBytes
+}
+
+// ExcelJS 컬럼 인덱스를 문자로 변환 (A, B, C, ... Z, AA, AB, ...)
+function getExcelColumnName(index: number): string {
+  let result = ""
+  while (index > 0) {
+    index--
+    result = String.fromCharCode(65 + (index % 26)) + result
+    index = Math.floor(index / 26)
+  }
+  return result
+}
+
+// 헤더 행 스타일링 함수
+function styleHeaderRow(headerRow: ExcelJS.Row, bgColor: string = 'FF4472C4') {
+  headerRow.eachCell((cell) => {
+    cell.fill = {
+      type: 'pattern',
+      pattern: 'solid',
+      fgColor: { argb: bgColor }
+    }
+    cell.font = {
+      color: { argb: 'FFFFFFFF' },
+      bold: true
+    }
+    cell.alignment = {
+      horizontal: 'center',
+      vertical: 'middle'
+    }
+    cell.border = {
+      top: { style: 'thin' },
+      left: { style: 'thin' },
+      bottom: { style: 'thin' },
+      right: { style: 'thin' }
+    }
+    
+    if (String(cell.value).includes('*')) {
+      cell.fill = {
+        type: 'pattern',
+        pattern: 'solid',
+        fgColor: { argb: 'FFE74C3C' }
+      }
+    }
+  })
+}
+
+// 템플릿 생성 함수 - Stage Plan Dates 부분 수정
+async function createImportTemplate(projectType: "ship" | "plant", contractId: number) {
+  const res = await getDocumentClassOptionsByContract(contractId)
+  if (!res.success) throw new Error(res.error || "데이터 로딩 실패")
+
+  const documentClasses = res.data.classes // [{id, code, description}]
+  const options = res.data.options // [{documentClassId, optionValue, ...}]
+
+  // 클래스별 옵션 맵
+  const optionsByClassId = new Map<number, string[]>()
+  for (const c of documentClasses) optionsByClassId.set(c.id, [])
+  for (const o of options) {
+    optionsByClassId.get(o.documentClassId)?.push(o.optionValue)
+  }
+
+  // 모든 스테이지 명 (유니크)
+  const allStageNames = Array.from(new Set(options.map(o => o.optionValue)))
+
+  const workbook = new ExcelJS.Workbook()
+
+  // ================= Documents (첫 번째 시트) =================
+  const documentsSheet = workbook.addWorksheet("Documents")
+  const documentHeaders = [
+    "Document Number*",
+    "Document Name*",
+    "Document Class*",
+    ...(projectType === "plant" ? ["Project Doc No."] : []),
+    "Notes",
+  ]
+  const documentHeaderRow = documentsSheet.addRow(documentHeaders)
+  styleHeaderRow(documentHeaderRow)
+
+  const sampleDocumentData =
+    projectType === "ship"
+      ? [
+          "SH-2024-001",
+          "기본 설계 도면",
+          documentClasses[0] ? `${documentClasses[0].description}` : "",
+          "참고사항",
+        ]
+      : [
+          "PL-2024-001",
+          "공정 설계 도면",
+          documentClasses[0] ? `${documentClasses[0].description}` : "",
+          "V-001",
+          "참고사항",
+        ]
+
+  documentsSheet.addRow(sampleDocumentData)
+
+  // Document Class 드롭다운
+  const docClassColIndex = 3 // C
+  const docClassCol = getExcelColumnName(docClassColIndex)
+  documentsSheet.dataValidations.add(`${docClassCol}2:${docClassCol}1000`, {
+    type: "list",
+    allowBlank: false,
+    formulae: [`ReferenceData!$A$2:$A${documentClasses.length + 1}`],
+  })
+
+  documentsSheet.columns = [
+    { width: 15 },
+    { width: 25 },
+    { width: 28 },
+    ...(projectType === "plant" ? [{ width: 18 }] : []),
+    { width: 24 },
+  ]
+
+  // ================= Stage Plan Dates (두 번째 시트) - 수정됨 =================
+  const stagesSheet = workbook.addWorksheet("Stage Plan Dates")
+  
+  // Document Class Helper 컬럼과 Valid Stage Helper 컬럼 추가
+  const stageHeaderRow = stagesSheet.addRow([
+    "Document Number*", 
+    "Document Class",  // Helper 컬럼 - 자동으로 채워짐
+    "Stage Name*", 
+    "Plan Date",
+    "Valid Stages"  // Helper 컬럼 - 유효한 스테이지 목록
+  ])
+  styleHeaderRow(stageHeaderRow, "FF27AE60")
+
+  const firstClass = documentClasses[0]
+  const firstClassOpts = firstClass ? optionsByClassId.get(firstClass.id) ?? [] : []
+
+  // 샘플 데이터
+  const sampleStageData = [
+    [
+      projectType === "ship" ? "SH-2024-001" : "PL-2024-001",
+      firstClass ? firstClass.description : "",
+      firstClassOpts[0] ?? "", 
+      "2024-02-15",
+      firstClassOpts.join(", ")  // 유효한 스테이지 목록
+    ],
+    [
+      projectType === "ship" ? "SH-2024-001" : "PL-2024-001",
+      firstClass ? firstClass.description : "",
+      firstClassOpts[1] ?? "", 
+      "2024-03-01",
+      firstClassOpts.join(", ")  // 유효한 스테이지 목록
+    ],
+  ]
+
+  sampleStageData.forEach(row => {
+    const r = stagesSheet.addRow(row)
+    r.getCell(4).numFmt = "yyyy-mm-dd"
+  })
+
+  // B열(Document Class)에 VLOOKUP 수식 추가
+  for (let i = 3; i <= 1000; i++) {
+    const cell = stagesSheet.getCell(`B${i}`)
+    cell.value = {
+      formula: `IFERROR(VLOOKUP(A${i},Documents!A:C,3,FALSE),"")`,
+      result: ""
+    }
+  }
+
+
+  // E열(Valid Stages)에 수식 추가 - Document Class에 해당하는 스테이지 목록 표시
+  // MATCH와 OFFSET을 사용한 동적 참조
+
+
+  // Helper 컬럼 숨기기 옵션 (B, E열)
+  stagesSheet.getColumn(2).hidden = false  // Document Class는 보이도록 (확인용)
+  stagesSheet.getColumn(5).hidden = false  // Valid Stages도 보이도록 (가이드용)
+  
+  // Helper 컬럼 스타일링
+  stagesSheet.getColumn(2).eachCell((cell, rowNumber) => {
+    if (rowNumber > 1) {
+      cell.fill = {
+        type: 'pattern',
+        pattern: 'solid',
+        fgColor: { argb: 'FFF0F0F0' }  // 연한 회색 배경
+      }
+      cell.protection = { locked: true }  // 편집 방지
+    }
+  })
+  
+  stagesSheet.getColumn(5).eachCell((cell, rowNumber) => {
+    if (rowNumber > 1) {
+      cell.fill = {
+        type: 'pattern',
+        pattern: 'solid',
+        fgColor: { argb: 'FFFFF0E0' }  // 연한 주황색 배경
+      }
+      cell.font = { size: 9, italic: true }
+    }
+  })
+
+  // Stage Name 드롭다운 - 전체 스테이지 목록 사용 (ExcelJS 제약으로 인해)
+  // 하지만 조건부 서식으로 잘못된 선택 강조
+  const allStagesCol = getExcelColumnName(documentClasses.length + 2)
+  stagesSheet.dataValidations.add("C3:C1000", {
+    type: "list",
+    allowBlank: false,
+    formulae: [`ReferenceData!${allStagesCol}$2:${allStagesCol}${allStageNames.length + 1}`],
+    promptTitle: "Stage Name 선택",
+    prompt: "Valid Stages 컬럼을 참고하여 올바른 Stage를 선택하세요",
+    showErrorMessage: true,
+    errorTitle: "Stage 선택 확인",
+    error: "Valid Stages 컬럼에 있는 Stage만 유효합니다"
+  })
+
+  // 조건부 서식 추가 - 잘못된 Stage 선택시 빨간색 표시
+  for (let i = 3; i <= 100; i++) {
+    try {
+      // COUNTIF를 사용하여 선택한 Stage가 Valid Stages에 포함되는지 확인
+      const rule = {
+        type: 'expression',
+        formulae: [`ISERROR(SEARCH(C${i},E${i}))`],
+        style: {
+          fill: {
+            type: 'pattern',
+            pattern: 'solid',
+            bgColor: { argb: 'FFFF0000' }  // 빨간색 배경
+          },
+          font: {
+            color: { argb: 'FFFFFFFF' }  // 흰색 글자
+          }
+        }
+      }
+      stagesSheet.addConditionalFormatting({
+        ref: `C${i}`,
+        rules: [rule]
+      })
+    } catch (e) {
+      console.warn(`Row ${i}: 조건부 서식 추가 실패`)
+    }
+  }
+
+  stagesSheet.columns = [
+    { width: 15 },  // Document Number
+    { width: 20 },  // Document Class (Helper)
+    { width: 30 },  // Stage Name
+    { width: 12 },  // Plan Date
+    { width: 50 }   // Valid Stages (Helper)
+  ]
+
+  // ================= 사용 가이드 (세 번째 시트) - 수정됨 =================
+  const guideSheet = workbook.addWorksheet("사용 가이드")
+  const guideContent: (string[])[] = [
+    ["문서 임포트 가이드"],
+    [""],
+    ["1. Documents 시트"],
+    ["   - Document Number*: 고유한 문서 번호를 입력하세요"],
+    ["   - Document Name*: 문서명을 입력하세요"],
+    ["   - Document Class*: 드롭다운에서 문서 클래스를 선택하세요"],
+    ["   - Project Doc No.: 벤더 문서 번호 (Plant 프로젝트만)"],
+    ["   - Notes: 참고사항"],
+    [""],
+    ["2. Stage Plan Dates 시트 (선택사항)"],
+    ["   - Document Number*: Documents 시트의 Document Number와 일치해야 합니다"],
+    ["   - Document Class: Document Number 입력시 자동으로 표시됩니다 (회색 배경)"],
+    ["   - Stage Name*: Valid Stages 컬럼을 참고하여 해당 클래스의 스테이지를 선택하세요"],
+    ["   - Plan Date: 계획 날짜 (YYYY-MM-DD 형식)"],
+    ["   - Valid Stages: 해당 Document Class에서 선택 가능한 스테이지 목록 (주황색 배경)"],
+    [""],
+    ["3. Stage Name 선택 방법"],
+    ["   ① Document Number를 먼저 입력합니다"],
+    ["   ② Document Class가 자동으로 표시됩니다"],
+    ["   ③ Valid Stages 컬럼에서 사용 가능한 스테이지를 확인합니다"],
+    ["   ④ Stage Name 드롭다운에서 Valid Stages에 있는 항목만 선택합니다"],
+    ["   ⑤ 잘못된 스테이지 선택시 셀이 빨간색으로 표시됩니다"],
+    [""],
+    ["4. 주의사항"],
+    ["   - * 표시는 필수 항목입니다"],
+    ["   - Document Number는 고유해야 합니다"],
+    ["   - Stage Name은 Valid Stages에 표시된 것만 유효합니다"],
+    ["   - 빨간색으로 표시된 Stage Name은 잘못된 선택입니다"],
+    ["   - 날짜는 YYYY-MM-DD 형식으로 입력하세요"],
+    [""],
+    ["5. Document Class별 사용 가능한 Stage Names"],
+    [""],
+  ]
+
+  for (const c of documentClasses) {
+    guideContent.push([`${c.code} - ${c.description}:`])
+    ;(optionsByClassId.get(c.id) ?? []).forEach(v => guideContent.push([`   • ${v}`]))
+    guideContent.push([""])
+  }
+
+  guideContent.forEach((row, i) => {
+    const r = guideSheet.addRow(row)
+    if (i === 0) r.getCell(1).font = { bold: true, size: 14 }
+    else if (row[0] && row[0].includes(":") && !row[0].startsWith("   ")) r.getCell(1).font = { bold: true }
+  })
+  guideSheet.getColumn(1).width = 60
+
+  // ================= ReferenceData (마지막 시트, hidden) =================
+  const referenceSheet = workbook.addWorksheet("ReferenceData", { state: "hidden" })
+
+  let joinColStart = /* A=1 기준, 빈 안전한 위치 선택 */ documentClasses.length + 3; 
+const keyCol = getExcelColumnName(joinColStart);      // 예: X
+const joinedCol = getExcelColumnName(joinColStart+1); // 예: Y
+referenceSheet.getCell(`${keyCol}1`).value = "DocClass";
+referenceSheet.getCell(`${joinedCol}1`).value = "JoinedStages";
+
+  // A열: DocumentClasses
+  referenceSheet.getCell("A1").value = "DocumentClasses"
+  documentClasses.forEach((dc, idx) => {
+    referenceSheet.getCell(`${keyCol}${idx+2}`).value = dc.description;
+    const stages = (optionsByClassId.get(dc.id) ?? []).join(", ");
+    referenceSheet.getCell(`${joinedCol}${idx+2}`).value = stages;
+  });
+
+  for (let i = 3; i <= 1000; i++) {
+    stagesSheet.getCell(`E${i}`).value = {
+      formula: `IFERROR("유효한 스테이지: "&VLOOKUP(B${i},ReferenceData!$${keyCol}$2:$${joinedCol}$${documentClasses.length+1},2,FALSE),"Document Number를 먼저 입력하세요")`,
+      result: ""
+    };
+  }
+
+
+  // B열부터: 각 클래스의 Stage 옵션
+  let currentCol = 2 // B
+  for (const docClass of documentClasses) {
+    const colLetter = getExcelColumnName(currentCol)
+    referenceSheet.getCell(`${colLetter}1`).value = docClass.description
+
+    const list = optionsByClassId.get(docClass.id) ?? []
+    list.forEach((v, i) => {
+      referenceSheet.getCell(`${colLetter}${i + 2}`).value = v
+    })
+
+    currentCol++
+  }
+
+  // 마지막 열: AllStageNames
+  referenceSheet.getCell(`${allStagesCol}1`).value = "AllStageNames"
+  allStageNames.forEach((v, i) => {
+    referenceSheet.getCell(`${allStagesCol}${i + 2}`).value = v
+  })
+
+  return workbook
+}
+
+// =============================================================================
+// Type Definitions
+// =============================================================================
+interface ParsedDocument {
+    docNumber: string
+    title: string
+    documentClass: string
+    vendorDocNumber?: string
+    notes?: string
+  }
+  
+  interface ParsedStage {
+    docNumber: string
+    stageName: string
+    planDate?: string
+  }
+  
+  interface ParseResult {
+    validData: ParsedDocument[]
+    errors: string[]
+  }
+
+
+// =============================================================================
+// 1. Parse Documents Sheet
+// =============================================================================
+export async function parseDocumentsSheet(
+    worksheet: ExcelJS.Worksheet, 
+    projectType: "ship" | "plant"
+  ): Promise<ParseResult> {
+    const documents: ParsedDocument[] = []
+    const errors: string[] = []
+    const seenDocNumbers = new Set<string>()
+  
+    // 헤더 행 확인
+    const headerRow = worksheet.getRow(1)
+    const headers: string[] = []
+    headerRow.eachCell((cell, colNumber) => {
+      headers[colNumber - 1] = String(cell.value || "").trim()
+    })
+  
+    // 헤더 인덱스 찾기
+    const docNumberIdx = headers.findIndex(h => h.includes("Document Number"))
+    const docNameIdx = headers.findIndex(h => h.includes("Document Name"))
+    const docClassIdx = headers.findIndex(h => h.includes("Document Class"))
+    const vendorDocNoIdx = projectType === "plant" 
+      ? headers.findIndex(h => h.includes("Project Doc No"))
+      : -1
+    const notesIdx = headers.findIndex(h => h.includes("Notes"))
+  
+    if (docNumberIdx === -1 || docNameIdx === -1 || docClassIdx === -1) {
+      errors.push("필수 헤더가 누락되었습니다: Document Number, Document Name, Document Class")
+      return { validData: [], errors }
+    }
+  
+    // 데이터 행 파싱
+    worksheet.eachRow((row, rowNumber) => {
+      if (rowNumber === 1) return // 헤더 행 스킵
+  
+      const docNumber = String(row.getCell(docNumberIdx + 1).value || "").trim()
+      const docName = String(row.getCell(docNameIdx + 1).value || "").trim()
+      const docClass = String(row.getCell(docClassIdx + 1).value || "").trim()
+      const vendorDocNo = vendorDocNoIdx >= 0 
+        ? String(row.getCell(vendorDocNoIdx + 1).value || "").trim()
+        : undefined
+      const notes = notesIdx >= 0
+        ? String(row.getCell(notesIdx + 1).value || "").trim()
+        : undefined
+  
+      // 빈 행 스킵
+      if (!docNumber && !docName) return
+  
+      // 유효성 검사
+      if (!docNumber) {
+        errors.push(`행 ${rowNumber}: Document Number가 없습니다`)
+        return
+      }
+      if (!docName) {
+        errors.push(`행 ${rowNumber}: Document Name이 없습니다`)
+        return
+      }
+      if (!docClass) {
+        errors.push(`행 ${rowNumber}: Document Class가 없습니다`)
+        return
+      }
+  
+      // 중복 체크
+      if (seenDocNumbers.has(docNumber)) {
+        errors.push(`행 ${rowNumber}: 중복된 Document Number: ${docNumber}`)
+        return
+      }
+      seenDocNumbers.add(docNumber)
+  
+      documents.push({
+        docNumber,
+        title: docName,
+        documentClass: docClass,
+        vendorDocNumber: vendorDocNo || undefined,
+        notes: notes || undefined
+      })
+    })
+  
+    return { validData: documents, errors }
+  }
+  
+
+
+// parseStagesSheet 함수도 수정이 필요합니다
+export async function parseStagesSheet(worksheet: ExcelJS.Worksheet): Promise<ParsedStage[]> {
+  const stages: ParsedStage[] = []
+
+  // 헤더 행 확인
+  const headerRow = worksheet.getRow(1)
+  const headers: string[] = []
+  headerRow.eachCell((cell, colNumber) => {
+    headers[colNumber - 1] = String(cell.value || "").trim()
+  })
+
+  // 헤더 인덱스 찾기 (Helper 컬럼들 고려)
+  const docNumberIdx = headers.findIndex(h => h.includes("Document Number"))
+  // Stage Name 찾기 - "Stage Name*" 또는 "Stage Name"을 찾음
+  const stageNameIdx = headers.findIndex(h => h.includes("Stage Name") && !h.includes("Valid"))
+  const planDateIdx = headers.findIndex(h => h.includes("Plan Date"))
+
+  if (docNumberIdx === -1 || stageNameIdx === -1) {
+    console.error("Stage Plan Dates 시트에 필수 헤더가 없습니다")
+    return []
+  }
+
+  // 데이터 행 파싱
+  worksheet.eachRow((row, rowNumber) => {
+    if (rowNumber === 1) return // 헤더 행 스킵
+
+    const docNumber = String(row.getCell(docNumberIdx + 1).value || "").trim()
+    const stageName = String(row.getCell(stageNameIdx + 1).value || "").trim()
+    let planDate: string | undefined
+
+    // Plan Date 파싱
+    if (planDateIdx >= 0) {
+      const planDateCell = row.getCell(planDateIdx + 1)
+      
+      if (planDateCell.value) {
+        // Date 객체인 경우
+        if (planDateCell.value instanceof Date) {
+          planDate = planDateCell.value.toISOString().split('T')[0]
+        }
+        // 문자열인 경우
+        else {
+          const dateStr = String(planDateCell.value).trim()
+          // YYYY-MM-DD 형식 검증
+          if (/^\d{4}-\d{2}-\d{2}$/.test(dateStr)) {
+            planDate = dateStr
+          }
+        }
+      }
+    }
+
+    // 빈 행 스킵
+    if (!docNumber && !stageName) return
+
+    // 유효성 검사
+    if (!docNumber || !stageName) {
+      console.warn(`행 ${rowNumber}: Document Number 또는 Stage Name이 누락됨`)
+      return
+    }
+
+    stages.push({
+      docNumber,
+      stageName,
+      planDate
+    })
+  })
+
+  return stages
+}
\ No newline at end of file
diff --git a/lib/vendor-document-list/plant/excel-import-stage.tsx b/lib/vendor-document-list/plant/excel-import-stage.tsx
new file mode 100644
index 00000000..8dc85c51
--- /dev/null
+++ b/lib/vendor-document-list/plant/excel-import-stage.tsx
@@ -0,0 +1,899 @@
+"use client"
+
+import React from "react"
+import { Dialog, DialogContent, DialogDescription, DialogFooter, DialogHeader, DialogTitle } from "@/components/ui/dialog"
+import { Button } from "@/components/ui/button"
+import { Input } from "@/components/ui/input"
+import { Label } from "@/components/ui/label"
+import { Progress } from "@/components/ui/progress"
+import { Alert, AlertDescription } from "@/components/ui/alert"
+import { Upload, FileSpreadsheet, Loader2, Download, CheckCircle, AlertCircle } from "lucide-react"
+import { toast } from "sonner"
+import { useRouter } from "next/navigation"
+import ExcelJS from "exceljs"
+import {
+  getDocumentClassOptionsByContract,
+  uploadImportData,
+} from "./document-stages-service"
+
+// =============================================================================
+// Type Definitions
+// =============================================================================
+interface ExcelImportDialogProps {
+  open: boolean
+  onOpenChange: (open: boolean) => void
+  contractId: number
+  projectType: "ship" | "plant"
+}
+
+interface ImportResult {
+  documents: any[]
+  stages: any[]
+  errors: string[]
+  warnings: string[]
+}
+
+interface ParsedDocument {
+  docNumber: string
+  title: string
+  documentClass: string
+  vendorDocNumber?: string
+  notes?: string
+  stages?: { stageName: string; planDate: string }[]
+}
+
+// =============================================================================
+// Main Component
+// =============================================================================
+export function ExcelImportDialog({
+  open,
+  onOpenChange,
+  contractId,
+  projectType
+}: ExcelImportDialogProps) {
+  const [file, setFile] = React.useState<File | null>(null)
+  const [isProcessing, setIsProcessing] = React.useState(false)
+  const [isDownloadingTemplate, setIsDownloadingTemplate] = React.useState(false)
+  const [importResult, setImportResult] = React.useState<ImportResult | null>(null)
+  const [processStep, setProcessStep] = React.useState<string>("")
+  const [progress, setProgress] = React.useState(0)
+  const router = useRouter()
+
+  const handleFileChange = (e: React.ChangeEvent<HTMLInputElement>) => {
+    const selectedFile = e.target.files?.[0]
+    if (selectedFile) {
+      if (!validateFileExtension(selectedFile)) {
+        toast.error("Excel 파일(.xlsx, .xls)만 업로드 가능합니다.")
+        return
+      }
+      if (!validateFileSize(selectedFile, 10)) {
+        toast.error("파일 크기는 10MB 이하여야 합니다.")
+        return
+      }
+      setFile(selectedFile)
+      setImportResult(null)
+    }
+  }
+
+  const handleDownloadTemplate = async () => {
+    setIsDownloadingTemplate(true)
+    try {
+      const workbook = await createImportTemplate(projectType, contractId)
+      const buffer = await workbook.xlsx.writeBuffer()
+      const blob = new Blob([buffer], { type: "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" })
+      const url = window.URL.createObjectURL(blob)
+      const link = document.createElement("a")
+      link.href = url
+      link.download = `문서_임포트_템플릿_${projectType}_${new Date().toISOString().split("T")[0]}.xlsx`
+      link.click()
+      window.URL.revokeObjectURL(url)
+      toast.success("템플릿 파일이 다운로드되었습니다.")
+    } catch (error) {
+      toast.error("템플릿 다운로드 중 오류가 발생했습니다: " + (error instanceof Error ? error.message : "알 수 없는 오류"))
+    } finally {
+      setIsDownloadingTemplate(false)
+    }
+  }
+
+  const handleImport = async () => {
+    if (!file) {
+      toast.error("파일을 선택해주세요.")
+      return
+    }
+    setIsProcessing(true)
+    setProgress(0)
+    try {
+      setProcessStep("파일 읽는 중...")
+      setProgress(20)
+      const workbook = new ExcelJS.Workbook()
+      const buffer = await file.arrayBuffer()
+      await workbook.xlsx.load(buffer)
+
+      setProcessStep("데이터 검증 중...")
+      setProgress(40)
+      const worksheet = workbook.getWorksheet("Documents") || workbook.getWorksheet(1)
+      if (!worksheet) throw new Error("Documents 시트를 찾을 수 없습니다.")
+
+      setProcessStep("문서 및 스테이지 데이터 파싱 중...")
+      setProgress(60)
+      const parseResult = await parseDocumentsWithStages(worksheet, projectType, contractId)
+
+      setProcessStep("서버에 업로드 중...")
+      setProgress(90)
+      const allStages: any[] = []
+      parseResult.validData.forEach((doc) => {
+        if (doc.stages) {
+          doc.stages.forEach((stage) => {
+            allStages.push({
+              docNumber: doc.docNumber,
+              stageName: stage.stageName,
+              planDate: stage.planDate,
+            })
+          })
+        }
+      })
+
+      const result = await uploadImportData({
+        contractId,
+        documents: parseResult.validData,
+        stages: allStages,
+        projectType,
+      })
+
+      if (result.success) {
+        setImportResult({
+          documents: parseResult.validData,
+          stages: allStages,
+          errors: parseResult.errors,
+          warnings: result.warnings || [],
+        })
+        setProgress(100)
+        toast.success(`${parseResult.validData.length}개 문서가 성공적으로 임포트되었습니다.`)
+      } else {
+        throw new Error(result.error || "임포트에 실패했습니다.")
+      }
+    } catch (error) {
+      toast.error(error instanceof Error ? error.message : "임포트 중 오류가 발생했습니다.")
+      setImportResult({
+        documents: [],
+        stages: [],
+        errors: [error instanceof Error ? error.message : "알 수 없는 오류"],
+        warnings: [],
+      })
+    } finally {
+      setIsProcessing(false)
+      setProcessStep("")
+      setProgress(0)
+    }
+  }
+
+  const handleClose = () => {
+    setFile(null)
+    setImportResult(null)
+    setProgress(0)
+    setProcessStep("")
+    onOpenChange(false)
+  }
+
+  const handleConfirmImport = () => {
+    router.refresh()
+    handleClose()
+  }
+
+  return (
+    <Dialog open={open} onOpenChange={onOpenChange}>
+      <DialogContent className="sm:max-w-[700px] max-h-[90vh] flex flex-col">
+        <DialogHeader className="flex-shrink-0">
+          <DialogTitle>
+            <FileSpreadsheet className="inline w-5 h-5 mr-2" />
+            Excel 파일 임포트
+          </DialogTitle>
+          <DialogDescription>
+            Excel 파일을 사용하여 문서와 스테이지 계획을 일괄 등록합니다.
+          </DialogDescription>
+        </DialogHeader>
+
+        <div className="flex-1 overflow-y-auto pr-2">
+          <div className="grid gap-4 py-4">
+            {/* 템플릿 다운로드 섹션 */}
+            <div className="border rounded-lg p-4 bg-blue-50/30 dark:bg-blue-950/30">
+              <h4 className="font-medium text-blue-800 dark:text-blue-200 mb-2">1. 템플릿 다운로드</h4>
+              <p className="text-sm text-blue-700 dark:text-blue-300 mb-3">
+                올바른 형식과 스마트 검증이 적용된 템플릿을 다운로드하세요.
+              </p>
+              <Button variant="outline" size="sm" onClick={handleDownloadTemplate} disabled={isDownloadingTemplate}>
+                {isDownloadingTemplate ? <Loader2 className="h-4 w-4 animate-spin mr-2" /> : <Download className="h-4 w-4 mr-2" />}
+                템플릿 다운로드
+              </Button>
+            </div>
+
+            {/* 파일 업로드 섹션 */}
+            <div className="border rounded-lg p-4">
+              <h4 className="font-medium mb-2">2. 파일 업로드</h4>
+              <div className="grid gap-2">
+                <Label htmlFor="excel-file">Excel 파일 선택</Label>
+                <Input
+                  id="excel-file"
+                  type="file"
+                  accept=".xlsx,.xls"
+                  onChange={handleFileChange}
+                  disabled={isProcessing}
+                  className="file:mr-4 file:py-2 file:px-4 file:rounded-full file:border-0 file:text-sm file:font-semibold file:bg-blue-50 file:text-blue-700 hover:file:bg-blue-100"
+                />
+                {file && (
+                  <p className="text-sm text-gray-600 dark:text-gray-400 mt-1">
+                    선택된 파일: {file.name} ({(file.size / 1024 / 1024).toFixed(2)} MB)
+                  </p>
+                )}
+              </div>
+            </div>
+
+            {/* 진행 상태 */}
+            {isProcessing && (
+              <div className="border rounded-lg p-4 bg-yellow-50/30 dark:bg-yellow-950/30">
+                <div className="flex items-center gap-2 mb-2">
+                  <Loader2 className="h-4 w-4 animate-spin text-yellow-600" />
+                  <span className="text-sm font-medium text-yellow-800 dark:text-yellow-200">처리 중...</span>
+                </div>
+                <p className="text-sm text-yellow-700 dark:text-yellow-300 mb-2">{processStep}</p>
+                <Progress value={progress} className="h-2" />
+              </div>
+            )}
+
+            {/* 임포트 결과 */}
+            {importResult && <ImportResultDisplay importResult={importResult} />}
+
+            {/* 파일 형식 가이드 */}
+            <FileFormatGuide projectType={projectType} />
+          </div>
+        </div>
+
+        <DialogFooter className="flex-shrink-0">
+          <Button variant="outline" onClick={handleClose}>
+            {importResult ? "닫기" : "취소"}
+          </Button>
+          {!importResult ? (
+            <Button onClick={handleImport} disabled={!file || isProcessing}>
+              {isProcessing ? <Loader2 className="h-4 w-4 animate-spin mr-2" /> : <Upload className="h-4 w-4 mr-2" />}
+              {isProcessing ? "처리 중..." : "임포트 시작"}
+            </Button>
+          ) : importResult.documents.length > 0 ? (
+            <Button onClick={handleConfirmImport}>완료 및 새로고침</Button>
+          ) : null}
+        </DialogFooter>
+      </DialogContent>
+    </Dialog>
+  )
+}
+
+// =============================================================================
+// Sub Components
+// =============================================================================
+function ImportResultDisplay({ importResult }: { importResult: ImportResult }) {
+  return (
+    <div className="space-y-3">
+      {importResult.documents.length > 0 && (
+        <Alert>
+          <CheckCircle className="h-4 w-4" />
+          <AlertDescription>
+            <strong>{importResult.documents.length}개</strong> 문서가 성공적으로 임포트되었습니다.
+            {importResult.stages.length > 0 && <> ({importResult.stages.length}개 스테이지 계획날짜 포함)</>}
+          </AlertDescription>
+        </Alert>
+      )}
+
+      {importResult.warnings.length > 0 && (
+        <Alert>
+          <AlertCircle className="h-4 w-4" />
+          <AlertDescription>
+            <strong>경고:</strong>
+            <ul className="mt-1 list-disc list-inside">
+              {importResult.warnings.map((warning, index) => (
+                <li key={index} className="text-sm">
+                  {warning}
+                </li>
+              ))}
+            </ul>
+          </AlertDescription>
+        </Alert>
+      )}
+
+      {importResult.errors.length > 0 && (
+        <Alert variant="destructive">
+          <AlertCircle className="h-4 w-4" />
+          <AlertDescription>
+            <strong>오류:</strong>
+            <ul className="mt-1 list-disc list-inside">
+              {importResult.errors.map((error, index) => (
+                <li key={index} className="text-sm">
+                  {error}
+                </li>
+              ))}
+            </ul>
+          </AlertDescription>
+        </Alert>
+      )}
+    </div>
+  )
+}
+
+function FileFormatGuide({ projectType }: { projectType: "ship" | "plant" }) {
+  return (
+    <div className="bg-gray-50 dark:bg-gray-900 border border-gray-200 dark:border-gray-700 rounded-lg p-4">
+      <h4 className="font-medium text-gray-800 dark:text-gray-200 mb-2">파일 형식 가이드</h4>
+      <div className="text-sm text-gray-700 dark:text-gray-300 space-y-1">
+        <p>
+          <strong>통합 Documents 시트:</strong>
+        </p>
+        <ul className="ml-4 list-disc">
+          <li>Document Number* (문서번호)</li>
+          <li>Document Name* (문서명)</li>
+          <li>Document Class* (문서클래스 - 드롭다운 선택)</li>
+          <li>Project Doc No.* (프로젝트 문서번호)</li>
+          <li>각 Stage Name 컬럼 (계획날짜 입력: YYYY-MM-DD)</li>
+        </ul>
+        <p className="mt-2 text-green-600 dark:text-green-400">
+          <strong>스마트 검증 기능:</strong>
+        </p>
+        <ul className="ml-4 list-disc text-green-600 dark:text-green-400">
+          <li>Document Class 드롭다운으로 정확한 값 선택</li>
+          <li>선택한 Class에 맞지 않는 Stage는 자동으로 회색 처리</li>
+          <li>잘못된 Stage에 날짜 입력시 빨간색으로 경고</li>
+          <li>날짜 형식 자동 검증</li>
+        </ul>
+        <p className="mt-2 text-yellow-600 dark:text-yellow-400">
+          <strong>색상 가이드:</strong>
+        </p>
+        <ul className="ml-4 list-disc text-yellow-600 dark:text-yellow-400">
+          <li>🟦 파란색 헤더: 필수 입력 항목</li>
+          <li>🟩 초록색 헤더: 해당 Class의 유효한 Stage</li>
+          <li>⬜ 회색 셀: 해당 Class에서 사용 불가능한 Stage</li>
+          <li>🟥 빨간색 셀: 잘못된 입력 (검증 실패)</li>
+        </ul>
+        <p className="mt-2 text-red-600 dark:text-red-400">* 필수 항목</p>
+      </div>
+    </div>
+  )
+}
+
+// =============================================================================
+// Helper Functions
+// =============================================================================
+function validateFileExtension(file: File): boolean {
+  const allowedExtensions = [".xlsx", ".xls"]
+  const fileName = file.name.toLowerCase()
+  return allowedExtensions.some((ext) => fileName.endsWith(ext))
+}
+
+function validateFileSize(file: File, maxSizeMB: number): boolean {
+  const maxSizeBytes = maxSizeMB * 1024 * 1024
+  return file.size <= maxSizeBytes
+}
+
+function getExcelColumnName(index: number): string {
+  let result = ""
+  while (index > 0) {
+    index--
+    result = String.fromCharCode(65 + (index % 26)) + result
+    index = Math.floor(index / 26)
+  }
+  return result
+}
+
+function styleHeaderRow(
+  headerRow: ExcelJS.Row,
+  bgColor: string = "FF4472C4",
+  startCol?: number,
+  endCol?: number
+) {
+  const start = startCol || 1
+  const end = endCol || headerRow.cellCount
+
+  for (let i = start; i <= end; i++) {
+    const cell = headerRow.getCell(i)
+    cell.fill = {
+      type: "pattern",
+      pattern: "solid",
+      fgColor: { argb: bgColor },
+    }
+    cell.font = {
+      color: { argb: "FFFFFFFF" },
+      bold: true,
+    }
+    cell.alignment = {
+      horizontal: "center",
+      vertical: "middle",
+    }
+    cell.border = {
+      top: { style: "thin" },
+      left: { style: "thin" },
+      bottom: { style: "thin" },
+      right: { style: "thin" },
+    }
+  }
+  headerRow.height = 20
+}
+
+// =============================================================================
+// Template Creation - 통합 시트 + 조건부서식/검증
+// =============================================================================
+async function createImportTemplate(projectType: "ship" | "plant", contractId: number) {
+  const res = await getDocumentClassOptionsByContract(contractId)
+  if (!res.success) throw new Error(res.error || "데이터 로딩 실패")
+
+  const documentClasses = res.data.classes as Array<{ id: number; code: string; description: string }>
+  const options = res.data.options as Array<{ documentClassId: number; optionValue: string }>
+
+  // 클래스별 옵션 맵
+  const optionsByClassId = new Map<number, string[]>()
+  for (const c of documentClasses) optionsByClassId.set(c.id, [])
+  for (const o of options) optionsByClassId.get(o.documentClassId)!.push(o.optionValue)
+
+  // 유니크 Stage
+  const allStageNames = Array.from(new Set(options.map((o) => o.optionValue)))
+
+  const workbook = new ExcelJS.Workbook()
+  // 파일 열 때 강제 전체 계산
+  workbook.calcProperties.fullCalcOnLoad = true
+
+  // ================= Documents 시트 =================
+  const worksheet = workbook.addWorksheet("Documents")
+
+  const headers = [
+    "Document Number*",
+    "Document Name*",
+    "Document Class*",
+    ...(projectType === "plant" ? ["Project Doc No.*"] : []),
+    ...allStageNames,
+  ]
+  const headerRow = worksheet.addRow(headers)
+
+  // 필수 헤더 (파랑)
+  const requiredCols = projectType === "plant" ? 4 : 3
+  styleHeaderRow(headerRow, "FF4472C4", 1, requiredCols)
+  // Stage 헤더 (초록)
+  styleHeaderRow(headerRow, "FF27AE60", requiredCols + 1, headers.length)
+
+  // 샘플 데이터
+  const firstClass = documentClasses[0]
+  const firstClassStages = firstClass ? optionsByClassId.get(firstClass.id) ?? [] : []
+  const sampleRow = [
+    projectType === "ship" ? "SH-2024-001" : "PL-2024-001",
+    "샘플 문서명",
+    firstClass ? firstClass.description : "",
+    ...(projectType === "plant" ? ["V-001"] : []),
+    ...allStageNames.map((s) => (firstClassStages.includes(s) ? "2024-03-01" : "")),
+  ]
+  worksheet.addRow(sampleRow)
+
+  const docNumberColIndex = 1; // A: Document Number*
+  const docNameColIndex = 2; // B: Document Name*
+  const docNumberColLetter = getExcelColumnName(docNumberColIndex);
+  const docNameColLetter = getExcelColumnName(docNameColIndex);
+
+  worksheet.dataValidations.add(`${docNumberColLetter}2:${docNumberColLetter}1000`, {
+    type: "textLength",
+    operator: "greaterThan",
+    formulae: [0],
+    allowBlank: false,
+    showErrorMessage: true,
+    errorTitle: "필수 입력",
+    error: "Document Number는 필수 항목입니다.",
+  });
+
+  // 1) 빈값 금지 (길이 > 0)
+  worksheet.dataValidations.add(`${docNumberColLetter}2:${docNumberColLetter}1000`, {
+    type: "textLength",
+    operator: "greaterThan",
+    formulae: [0],
+    allowBlank: false,
+    showErrorMessage: true,
+    errorTitle: "필수 입력",
+    error: "Document Number는 필수 항목입니다.",
+  });
+
+
+  // 드롭다운: Document Class
+  const docClassColIndex = 3 // "Document Class*"는 항상 3열
+  const docClassColLetter = getExcelColumnName(docClassColIndex)
+  worksheet.dataValidations.add(`${docClassColLetter}2:${docClassColLetter}1000`, {
+    type: "list",
+    allowBlank: false,
+    formulae: [`ReferenceData!$A$2:$A${documentClasses.length + 1}`],
+    showErrorMessage: true,
+    errorTitle: "잘못된 입력",
+    error: "드롭다운 목록에서 Document Class를 선택하세요.",
+  })
+
+    // 2) 중복 금지 (COUNTIF로 현재 값이 범위에서 1회만 등장해야 함)
+  //   - Validation은 한 셀에 1개만 가능하므로, 중복 검증은 "Custom" 하나로 통합하는 방법도 있음.
+  //   - 여기서는 '중복 금지'를 추가적으로 **Guidance용**으로 Conditional Formatting(빨간색)으로 가시화합니다.
+  worksheet.addConditionalFormatting({
+    ref: `${docNumberColLetter}2:${docNumberColLetter}1000`,
+    rules: [
+      // 빈값 빨간
+      {
+        type: "expression",
+        formulae: [`LEN(${docNumberColLetter}2)=0`],
+        style: {
+          fill: { type: "pattern", pattern: "solid", bgColor: { argb: "FFFFC7CE" } },
+        },
+      },
+      // 중복 빨간: COUNTIF($A$2:$A$1000, A2) > 1
+      {
+        type: "expression",
+        formulae: [`COUNTIF($${docNumberColLetter}$2:$${docNumberColLetter}$1000,${docNumberColLetter}2)>1`],
+        style: {
+          fill: { type: "pattern", pattern: "solid", bgColor: { argb: "FFFFC7CE" } },
+        },
+      },
+    ],
+  });
+
+
+  // ===== Document Name* (B열): 빈값 금지 + 빈칸 빨간 =====
+worksheet.dataValidations.add(`${docNameColLetter}2:${docNameColLetter}1000`, {
+  type: "textLength",
+  operator: "greaterThan",
+  formulae: [0],
+  allowBlank: false,
+  showErrorMessage: true,
+  errorTitle: "필수 입력",
+  error: "Document Name은 필수 항목입니다.",
+});
+
+worksheet.addConditionalFormatting({
+  ref: `${docNameColLetter}2:${docNameColLetter}1000`,
+  rules: [
+    {
+      type: "expression",
+      formulae: [`LEN(${docNameColLetter}2)=0`],
+      style: {
+        fill: { type: "pattern", pattern: "solid", bgColor: { argb: "FFFFC7CE" } },
+      },
+    },
+  ],
+});
+
+// ===== Document Class* (C열): 드롭다운 + allowBlank:false로 차단은 되어 있음 → 빈칸 빨간만 추가 =====
+worksheet.addConditionalFormatting({
+  ref: `${docClassColLetter}2:${docClassColLetter}1000`,
+  rules: [
+    {
+      type: "expression",
+      formulae: [`LEN(${docClassColLetter}2)=0`],
+      style: {
+        fill: { type: "pattern", pattern: "solid", bgColor: { argb: "FFFFC7CE" } },
+      },
+    },
+  ],
+});
+
+// ===== Project Doc No.* (Plant 전용): (이미 작성하신 코드 유지) =====
+if (projectType === "plant") {
+  const vendorDocColIndex = 4; // D
+  const vendorDocColLetter = getExcelColumnName(vendorDocColIndex);
+
+  worksheet.dataValidations.add(`${vendorDocColLetter}2:${vendorDocColLetter}1000`, {
+    type: "textLength",
+    operator: "greaterThan",
+    formulae: [0],
+    allowBlank: false,
+    showErrorMessage: true,
+    errorTitle: "필수 입력",
+    error: "Project Doc No.는 필수 항목입니다.",
+  });
+
+  worksheet.addConditionalFormatting({
+    ref: `${vendorDocColLetter}2:${vendorDocColLetter}1000`,
+    rules: [
+      {
+        type: "expression",
+        formulae: [`LEN(${vendorDocColLetter}2)=0`],
+        style: {
+          fill: { type: "pattern", pattern: "solid", bgColor: { argb: "FFFFC7CE" } },
+        },
+      },
+        // 중복 빨간: COUNTIF($A$2:$A$1000, A2) > 1
+        {
+          type: "expression",
+          formulae: [`COUNTIF($${vendorDocColLetter}$2:$${vendorDocColLetter}$1000,${vendorDocColLetter}2)>1`],
+          style: {
+            fill: { type: "pattern", pattern: "solid", bgColor: { argb: "FFFFC7CE" } },
+          },
+        },
+    ],
+  });
+
+}
+
+  if (projectType === "plant") {
+    const vendorDocColIndex = 4; // Document Number, Name, Class 다음이 Project Doc No.*
+    const vendorDocColLetter = getExcelColumnName(vendorDocColIndex);
+
+    // 공백 불가: 글자수 > 0
+    worksheet.dataValidations.add(`${vendorDocColLetter}2:${vendorDocColLetter}1000`, {
+      type: "textLength",
+      operator: "greaterThan",
+      formulae: [0],
+      allowBlank: false,
+      showErrorMessage: true,
+      errorTitle: "필수 입력",
+      error: "Project Doc No.는 필수 항목입니다.",
+    });
+
+    // UX: 비어있으면 빨간 배경으로 표시 (조건부 서식)
+    worksheet.addConditionalFormatting({
+      ref: `${vendorDocColLetter}2:${vendorDocColLetter}1000`,
+      rules: [
+        {
+          type: "expression",
+          formulae: [`LEN(${vendorDocColLetter}2)=0`],
+          style: {
+            fill: { type: "pattern", pattern: "solid", bgColor: { argb: "FFFFC7CE" } }, // 연한 빨강
+          },
+        },
+      ],
+    });
+  }
+
+  // 날짜 셀 형식 + 검증/조건부서식
+  const stageStartCol = requiredCols + 1
+  const stageEndCol = stageStartCol + allStageNames.length - 1
+
+  // ================= 매트릭스 시트 (Class-Stage Matrix) =================
+  const matrixSheet = workbook.addWorksheet("Class-Stage Matrix")
+  const matrixHeaders = ["Document Class", ...allStageNames]
+  const matrixHeaderRow = matrixSheet.addRow(matrixHeaders)
+  styleHeaderRow(matrixHeaderRow, "FF34495E")
+  for (const docClass of documentClasses) {
+    const validStages = new Set(optionsByClassId.get(docClass.id) ?? [])
+    const row = [docClass.description, ...allStageNames.map((stage) => (validStages.has(stage) ? "✓" : ""))]
+    const dataRow = matrixSheet.addRow(row)
+    allStageNames.forEach((stage, idx) => {
+      const cell = dataRow.getCell(idx + 2)
+      if (validStages.has(stage)) {
+        cell.fill = { type: "pattern", pattern: "solid", fgColor: { argb: "FFD4EDDA" } }
+        cell.font = { color: { argb: "FF28A745" } }
+      }
+    })
+  }
+  matrixSheet.columns = [{ width: 30 }, ...allStageNames.map(() => ({ width: 15 }))]
+
+  // 매트릭스 범위 계산 (B ~ 마지막 Stage 열)
+  const matrixStageFirstColLetter = "B"
+  const matrixStageLastColLetter = getExcelColumnName(1 + allStageNames.length) // 1:A, 2:B ... (A는 Class, B부터 Stage)
+  const matrixClassCol = "$A:$A"
+  const matrixHeaderRowRange = "$1:$1"
+  const matrixBodyRange = `$${matrixStageFirstColLetter}:$${matrixStageLastColLetter}`
+
+  // ================= 가이드 시트 =================
+  const guideSheet = workbook.addWorksheet("사용 가이드")
+  const guideContent: string[][] = [
+    ["📋 통합 문서 임포트 가이드"],
+    [""],
+    ["1. 하나의 시트에서 모든 정보 관리"],
+    ["   • Document Number*: 고유한 문서 번호"],
+    ["   • Document Name*: 문서명"],
+    ["   • Document Class*: 드롭다운에서 선택"],
+    ...(projectType === "plant" ? [["   • Project Doc No.: 벤더 문서 번호"]] : []),
+    ["   • Stage 컬럼들: 각 스테이지의 계획 날짜 (YYYY-MM-DD)"],
+    [""],
+    ["2. 스마트 검증 기능"],
+    ["   • Document Class를 선택하면 해당하지 않는 Stage는 자동으로 비활성화(회색)"],
+    ["   • 비유효 Stage에 날짜 입력 시 입력 자체가 막히고 경고 표시"],
+    ["   • 날짜 형식 자동 검증"],
+    [""],
+    ["3. Class-Stage Matrix 시트 활용"],
+    ["   • 각 Document Class별로 사용 가능한 Stage 확인"],
+    ["   • ✓ 표시가 있는 Stage만 해당 Class에서 사용 가능"],
+    [""],
+    ["4. 작성 순서"],
+    ["   ① Document Number, Name 입력"],
+    ["   ② Document Class 드롭다운에서 선택"],
+    ["   ③ Class-Stage Matrix 확인하여 유효한 Stage 파악"],
+    ["   ④ 해당 Stage 컬럼에만 날짜 입력"],
+    [""],
+    ["5. 주의사항"],
+    ["   • * 표시는 필수 항목"],
+    ["   • Document Number는 중복 불가"],
+    ["   • 해당 Class에 맞지 않는 Stage에 날짜 입력 시 무시/차단"],
+    ["   • 날짜는 YYYY-MM-DD 형식 준수"],
+  ]
+  guideContent.forEach((row, i) => {
+    const r = guideSheet.addRow(row)
+    if (i === 0) r.getCell(1).font = { bold: true, size: 14 }
+    else if (row[0] && !row[0].startsWith("   ")) r.getCell(1).font = { bold: true }
+  })
+  guideSheet.getColumn(1).width = 70
+
+  // ================= ReferenceData (숨김) =================
+  const referenceSheet = workbook.addWorksheet("ReferenceData", { state: "hidden" })
+  referenceSheet.getCell("A1").value = "DocumentClasses"
+  documentClasses.forEach((dc, idx) => {
+    referenceSheet.getCell(`A${idx + 2}`).value = dc.description
+  })
+
+  // ================= Stage 열별 서식/검증 =================
+  // 문서 시트 컬럼 너비
+  worksheet.columns = [
+    { width: 18 }, // Doc Number
+    { width: 30 }, // Doc Name
+    { width: 30 }, // Doc Class
+    ...(projectType === "plant" ? [{ width: 18 }] : []),
+    ...allStageNames.map(() => ({ width: 12 })),
+  ]
+
+  // 각 Stage 열 처리
+  for (let stageIdx = 0; stageIdx < allStageNames.length; stageIdx++) {
+    const colIndex = stageStartCol + stageIdx
+    const colLetter = getExcelColumnName(colIndex)
+
+    // 날짜 표시 형식
+    for (let row = 2; row <= 1000; row++) {
+      worksheet.getCell(`${colLetter}${row}`).numFmt = "yyyy-mm-dd"
+    }
+
+    // ---- 커스텀 데이터 검증 (빈칸 OR (해당 Class에 유효한 Stage AND 숫자(=날짜))) ----
+    // INDEX('Class-Stage Matrix'!$B:$ZZ, MATCH($C2,'Class-Stage Matrix'!$A:$A,0), MATCH(H$1,'Class-Stage Matrix'!$1:$1,0))
+    const validationFormula =
+      `=OR(` +
+      `LEN(${colLetter}2)=0,` +
+      `AND(` +
+      `INDEX('Class-Stage Matrix'!$${matrixStageFirstColLetter}:$${matrixStageLastColLetter},` +
+      `MATCH($${docClassColLetter}2,'Class-Stage Matrix'!${matrixClassCol},0),` +
+      `MATCH(${colLetter}$1,'Class-Stage Matrix'!${matrixHeaderRowRange},0)` +
+      `)<>\"\",` +
+      `ISNUMBER(${colLetter}2)` +
+      `)` +
+      `)`
+    worksheet.dataValidations.add(`${colLetter}2:${colLetter}1000`, {
+      type: "custom",
+      allowBlank: true,
+      formulae: [validationFormula],
+      showErrorMessage: true,
+      errorTitle: "허용되지 않은 입력",
+      error: "이 Stage는 선택한 Document Class에서 사용할 수 없거나 날짜 형식이 아닙니다.",
+    })
+
+    // ---- 조건부 서식 (유효하지 않은 Stage → 회색 배경) ----
+    // TRUE이면 서식 적용: INDEX(...)=""  -> 유효하지 않음
+    const cfFormula =
+      `IFERROR(` +
+      `INDEX('Class-Stage Matrix'!$${matrixStageFirstColLetter}:$${matrixStageLastColLetter},` +
+      `MATCH($${docClassColLetter}2,'Class-Stage Matrix'!${matrixClassCol},0),` +
+      `MATCH(${colLetter}$1,'Class-Stage Matrix'!${matrixHeaderRowRange},0)` +
+      `)=\"\",` +
+      `TRUE` + // 매치 실패 등 오류 시에도 회색 처리
+      `)`
+    worksheet.addConditionalFormatting({
+      ref: `${colLetter}2:${colLetter}1000`,
+      rules: [
+        {
+          type: "expression",
+          formulae: [cfFormula],
+          style: {
+            fill: { type: "pattern", pattern: "solid", bgColor: { argb: "FFEFEFEF" } }, // 연회색
+          },
+        },
+      ],
+    })
+  }
+
+  return workbook
+}
+
+// =============================================================================
+// Parse Documents with Stages - 통합 파싱
+// =============================================================================
+async function parseDocumentsWithStages(
+  worksheet: ExcelJS.Worksheet,
+  projectType: "ship" | "plant",
+  contractId: number
+): Promise<{ validData: ParsedDocument[]; errors: string[] }> {
+  const documents: ParsedDocument[] = []
+  const errors: string[] = []
+  const seenDocNumbers = new Set<string>()
+
+  const res = await getDocumentClassOptionsByContract(contractId)
+  if (!res.success) {
+    errors.push("Document Class 정보를 불러올 수 없습니다")
+    return { validData: [], errors }
+  }
+  const documentClasses = res.data.classes as Array<{ id: number; description: string }>
+  const options = res.data.options as Array<{ documentClassId: number; optionValue: string }>
+
+  // 클래스별 유효한 스테이지 맵
+  const validStagesByClass = new Map<string, Set<string>>()
+  for (const c of documentClasses) {
+    const stages = options.filter((o) => o.documentClassId === c.id).map((o) => o.optionValue)
+    validStagesByClass.set(c.description, new Set(stages))
+  }
+
+  // 헤더 파싱
+  const headerRow = worksheet.getRow(1)
+  const headers: string[] = []
+  headerRow.eachCell((cell, colNumber) => {
+    headers[colNumber - 1] = String(cell.value || "").trim()
+  })
+
+  const docNumberIdx = headers.findIndex((h) => h.includes("Document Number"))
+  const docNameIdx = headers.findIndex((h) => h.includes("Document Name"))
+  const docClassIdx = headers.findIndex((h) => h.includes("Document Class"))
+  const vendorDocNoIdx = projectType === "plant" ? headers.findIndex((h) => h.includes("Project Doc No")) : -1
+
+  if (docNumberIdx === -1 || docNameIdx === -1 || docClassIdx === -1) {
+    errors.push("필수 헤더가 누락되었습니다")
+    return { validData: [], errors }
+  }
+
+  const stageStartIdx = projectType === "plant" ? 4 : 3 // headers slice 기준(0-index)
+  const stageHeaders = headers.slice(stageStartIdx)
+
+  // 데이터 행 파싱
+  worksheet.eachRow((row, rowNumber) => {
+    if (rowNumber === 1) return
+    const docNumber = String(row.getCell(docNumberIdx + 1).value || "").trim()
+    const docName = String(row.getCell(docNameIdx + 1).value || "").trim()
+    const docClass = String(row.getCell(docClassIdx + 1).value || "").trim()
+    const vendorDocNo = vendorDocNoIdx >= 0 ? String(row.getCell(vendorDocNoIdx + 1).value || "").trim() : undefined
+
+    if (!docNumber && !docName) return
+    if (!docNumber) {
+      errors.push(`행 ${rowNumber}: Document Number가 없습니다`)
+      return
+    }
+    if (!docName) {
+      errors.push(`행 ${rowNumber}: Document Name이 없습니다`)
+      return
+    }
+    if (!docClass) {
+      errors.push(`행 ${rowNumber}: Document Class가 없습니다`)
+      return
+    }
+    if (projectType === "plant" && !vendorDocNo) {
+      errors.push(`행 ${rowNumber}: Project Doc No.가 없습니다`)
+      return
+    }
+    if (seenDocNumbers.has(docNumber)) {
+      errors.push(`행 ${rowNumber}: 중복된 Document Number: ${docNumber}`)
+      return
+    }
+    seenDocNumbers.add(docNumber)
+
+    const validStages = validStagesByClass.get(docClass)
+    if (!validStages) {
+      errors.push(`행 ${rowNumber}: 유효하지 않은 Document Class: ${docClass}`)
+      return
+    }
+
+
+
+    const stages: { stageName: string; planDate: string }[] = []
+    stageHeaders.forEach((stageName, idx) => {
+      if (validStages.has(stageName)) {
+        const cell = row.getCell(stageStartIdx + idx + 1)
+        let planDate = ""
+        if (cell.value) {
+          if (cell.value instanceof Date) {
+            planDate = cell.value.toISOString().split("T")[0]
+          } else {
+            const dateStr = String(cell.value).trim()
+            if (/^\d{4}-\d{2}-\d{2}$/.test(dateStr)) planDate = dateStr
+          }
+          if (planDate) stages.push({ stageName, planDate })
+        }
+      }
+    })
+
+    documents.push({
+      docNumber,
+      title: docName,
+      documentClass: docClass,
+      vendorDocNumber: vendorDocNo,
+      stages,
+    })
+  })
+
+  return { validData: documents, errors }
+}
diff --git a/lib/vendor-document-list/plant/upload/columns.tsx b/lib/vendor-document-list/plant/upload/columns.tsx
index c0f17afc..01fc61df 100644
--- a/lib/vendor-document-list/plant/upload/columns.tsx
+++ b/lib/vendor-document-list/plant/upload/columns.tsx
@@ -25,7 +25,8 @@ import {
   CheckCircle2, 
   XCircle, 
   AlertCircle,
-  Clock
+  Clock,
+  Download 
 } from "lucide-react"
 
 interface GetColumnsProps {
@@ -360,6 +361,16 @@ export function getColumns({
                 </>
               )}
               
+
+                {/* ✅ 커버 페이지 다운로드 */}
+  <DropdownMenuItem
+    onSelect={() => setRowAction({ row, type: "downloadCover" })}
+    className="gap-2"
+  >
+    <Download className="h-4 w-4" />
+    Download Cover Page
+  </DropdownMenuItem>
+
               <DropdownMenuSeparator />
               
               <DropdownMenuItem
diff --git a/lib/vendor-document-list/plant/upload/table.tsx b/lib/vendor-document-list/plant/upload/table.tsx
index 92507900..84b04092 100644
--- a/lib/vendor-document-list/plant/upload/table.tsx
+++ b/lib/vendor-document-list/plant/upload/table.tsx
@@ -20,6 +20,7 @@ import { ProjectFilter } from "./components/project-filter"
 import { SingleUploadDialog } from "./components/single-upload-dialog"
 import { HistoryDialog } from "./components/history-dialog"
 import { ViewSubmissionDialog } from "./components/view-submission-dialog"
+import { toast } from "sonner"
 
 interface StageSubmissionsTableProps {
   promises: Promise<[
@@ -159,6 +160,30 @@ export function StageSubmissionsTable({ promises, selectedProjectId }: StageSubm
     columnResizeMode: "onEnd",
   })
 
+
+  React.useEffect(() => {
+    if (!rowAction) return;
+  
+    const { type, row } = rowAction;
+  
+    if (type === "downloadCover") {
+       // 2) 서버에서 생성 후 다운로드 (예: API 호출)
+      (async () => {
+        try {
+          const res = await fetch(`/api/stages/${row.original.stageId}/cover`, { method: "POST" });
+          if (!res.ok) throw new Error("failed");
+          const { fileUrl } = await res.json(); // 서버 응답: { fileUrl: string }
+          window.open(fileUrl, "_blank", "noopener,noreferrer");
+        } catch (e) {
+          toast.error("커버 페이지 생성에 실패했습니다.");
+          console.error(e);
+        } finally {
+          setRowAction(null);
+        }
+      })();
+    }
+  }, [rowAction, setRowAction]);
+
   return (
     <>
       <DataTable table={table}>