From 53ad72732f781e6c6d5ddb3776ea47aec010af8e Mon Sep 17 00:00:00 2001
From: dujinkim <dujin.kim@dtsolution.co.kr>
Date: Mon, 4 Aug 2025 09:39:21 +0000
Subject: (최겸) PQ/실사 수정 및 개발
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

---
 lib/pq/table/import-pq-handler.tsx | 145 -------------------------------------
 1 file changed, 145 deletions(-)
 delete mode 100644 lib/pq/table/import-pq-handler.tsx

(limited to 'lib/pq/table/import-pq-handler.tsx')

diff --git a/lib/pq/table/import-pq-handler.tsx b/lib/pq/table/import-pq-handler.tsx
deleted file mode 100644
index 13431ba7..00000000
--- a/lib/pq/table/import-pq-handler.tsx
+++ /dev/null
@@ -1,145 +0,0 @@
-"use client"
-
-import { z } from "zod"
-import { createPq } from "../service" // PQ 생성 서버 액션
-
-// PQ 데이터 검증을 위한 Zod 스키마
-const pqItemSchema = z.object({
-  code: z.string().min(1, "Code is required"),
-  checkPoint: z.string().min(1, "Check point is required"),
-  groupName: z.string().min(1, "Group is required"),
-  description: z.string().optional().nullable(),
-  remarks: z.string().optional().nullable(),
-  contractInfo: z.string().optional().nullable(),
-  additionalRequirement: z.string().optional().nullable(),
-});
-
-// 지원하는 그룹 이름 목록
-const validGroupNames = [
-  "GENERAL",
-  "Quality Management System",
-  "Workshop & Environment",
-  "Warranty",
-];
-
-type ImportPqItem = z.infer<typeof pqItemSchema>;
-
-interface ProcessResult {
-  successCount: number;
-  errorCount: number;
-  errors?: Array<{ row: number; message: string }>;
-}
-
-/**
- * Excel 파일에서 가져온 PQ 데이터를 처리하는 함수
- */
-export async function processFileImport(
-  jsonData: any[],
-  projectId: number | null | undefined,
-  progressCallback?: (current: number, total: number) => void
-): Promise<ProcessResult> {
-  // 결과 카운터 초기화
-  let successCount = 0;
-  let errorCount = 0;
-  const errors: Array<{ row: number; message: string }> = [];
-  
-  // 헤더 행과 지침 행 건너뛰기
-  const dataRows = jsonData.filter(row => {
-    // 행이 문자열로만 구성된 경우 지침 행으로 간주
-    if (Object.values(row).every(val => typeof val === 'string' && !val.includes(':'))) {
-      return false;
-    }
-    // 빈 행 건너뛰기
-    if (Object.values(row).every(val => !val)) {
-      return false;
-    }
-    return true;
-  });
-  
-  // 데이터 행이 없으면 빈 결과 반환
-  if (dataRows.length === 0) {
-    return { successCount: 0, errorCount: 0 };
-  }
-  
-  // 각 행에 대해 처리
-  for (let i = 0; i < dataRows.length; i++) {
-    const row = dataRows[i];
-    const rowIndex = i + 1; // 사용자에게 표시할 행 번호는 1부터 시작
-    
-    // 진행 상황 콜백 호출
-    if (progressCallback) {
-      progressCallback(i + 1, dataRows.length);
-    }
-    
-    try {
-      // 데이터 정제
-      const cleanedRow: ImportPqItem = {
-        code: row.Code?.toString().trim() ?? "",
-        checkPoint: row["Check Point"]?.toString().trim() ?? "",
-        groupName: row["Group Name"]?.toString().trim() ?? "",
-        description: row.Description?.toString() ?? "",
-        remarks: row.Remarks?.toString() ?? "",
-        contractInfo: row["Contract Info"]?.toString() ?? "",
-        additionalRequirement: row["Additional Requirements"]?.toString() ?? "",
-      };
-      
-      // 데이터 유효성 검사
-      const validationResult = pqItemSchema.safeParse(cleanedRow);
-      
-      if (!validationResult.success) {
-        const errorMessage = validationResult.error.errors.map(
-          err => `${err.path.join('.')}: ${err.message}`
-        ).join(', ');
-        
-        errors.push({ row: rowIndex, message: errorMessage });
-        errorCount++;
-        continue;
-      }
-      
-      // 그룹 이름 유효성 검사
-      if (!validGroupNames.includes(cleanedRow.groupName)) {
-        errors.push({
-          row: rowIndex,
-          message: `Invalid group name: ${cleanedRow.groupName}. Must be one of: ${validGroupNames.join(', ')}`
-        });
-        errorCount++;
-        continue;
-      }
-      
-      // PQ 생성 서버 액션 호출
-      const createResult = await createPq({
-        ...cleanedRow,
-        projectId: projectId || 0
-      });
-      
-      if (createResult.success) {
-        successCount++;
-      } else {
-        errors.push({
-          row: rowIndex,
-          message: createResult.message || "Unknown error"
-        });
-        errorCount++;
-      }
-    } catch (error) {
-      console.error(`Row ${rowIndex} processing error:`, error);
-      errors.push({
-        row: rowIndex,
-        message: error instanceof Error ? error.message : "Unknown error"
-      });
-      errorCount++;
-    }
-    
-    // 비동기 작업 쓰로틀링
-    if (i % 5 === 0) {
-      await new Promise(resolve => setTimeout(resolve, 10));
-    }
-  }
-  
-  // 처리 결과 반환
-  return {
-    successCount,
-    errorCount,
-    errors: errors.length > 0 ? errors : undefined
-  };
-}
\ No newline at end of file
-- 
cgit v1.2.3

