1 files changed, 69 insertions, 0 deletions
diff --git a/lib/bidding/selection/actions.ts b/lib/bidding/selection/actions.ts
index f19fbe6d..91550960 100644
--- a/lib/bidding/selection/actions.ts
+++ b/lib/bidding/selection/actions.ts
@@ -131,6 +131,75 @@ export async function saveSelectionResult(data: SaveSelectionResultData) {
   }
 }
 
+// 선정결과 조회
+export async function getSelectionResult(biddingId: number) {
+  try {
+    // 선정결과 조회 (selectedCompanyId가 null인 레코드)
+    const allResults = await db
+      .select()
+      .from(vendorSelectionResults)
+      .where(eq(vendorSelectionResults.biddingId, biddingId))
+
+    // @ts-ignore
+    const existingResult = allResults.filter((result: any) => result.selectedCompanyId === null).slice(0, 1)
+
+    if (existingResult.length === 0) {
+      return {
+        success: true,
+        data: {
+          summary: '',
+          attachments: []
+        }
+      }
+    }
+
+    const result = existingResult[0]
+
+    // 첨부파일 조회
+    const documents = await db
+      .select({
+        id: biddingDocuments.id,
+        fileName: biddingDocuments.fileName,
+        originalFileName: biddingDocuments.originalFileName,
+        fileSize: biddingDocuments.fileSize,
+        mimeType: biddingDocuments.mimeType,
+        filePath: biddingDocuments.filePath,
+        uploadedAt: biddingDocuments.uploadedAt
+      })
+      .from(biddingDocuments)
+      .where(and(
+        eq(biddingDocuments.biddingId, biddingId),
+        eq(biddingDocuments.documentType, 'selection_result')
+      ))
+
+    return {
+      success: true,
+      data: {
+        summary: result.evaluationSummary || '',
+        attachments: documents.map(doc => ({
+          id: doc.id,
+          fileName: doc.fileName || doc.originalFileName || '',
+          originalFileName: doc.originalFileName || '',
+          fileSize: doc.fileSize || 0,
+          mimeType: doc.mimeType || '',
+          filePath: doc.filePath || '',
+          uploadedAt: doc.uploadedAt
+        }))
+      }
+    }
+  } catch (error) {
+    console.error('Failed to get selection result:', error)
+    return {
+      success: false,
+      error: '선정결과 조회 중 오류가 발생했습니다.',
+      data: {
+        summary: '',
+        attachments: []
+      }
+    }
+  }
+}
+
 // 견적 히스토리 조회
 export async function getQuotationHistory(biddingId: number, vendorId: number) {
   try {