(대표님, 최겸) 이메일 템플릿, 벤더데이터 변경사항 대응, 기술영업 변경요구사항 구현

1 files changed, 6 insertions, 5 deletions

diff --git a/lib/vendor-document-list/enhanced-document-service.ts b/lib/vendor-document-list/enhanced-document-service.ts
index e01283dc..6fe8feb7 100644
--- a/lib/vendor-document-list/enhanced-document-service.ts
+++ b/lib/vendor-document-list/enhanced-document-service.ts
@@ -20,7 +20,7 @@ import type {
     Revision
   } from "@/types/enhanced-documents"
 import { GetVendorShipDcoumentsSchema } from "./validations"
-import { contracts, users } from "@/db/schema"
+import { contracts, users, vendors } from "@/db/schema"
 
 // 스키마 타입 정의
 export interface GetEnhancedDocumentsSchema {
@@ -1092,11 +1092,12 @@ export async function getDocumentDetails(documentId: number) {
         // 벤더 정보 조회
         const [vendorInfo] = await tx
           .select({
-            vendorName: simplifiedDocumentsView.vendorName,
-            vendorCode: simplifiedDocumentsView.vendorCode,
+            vendorName: vendors.vendorName,
+            vendorCode: vendors.vendorCode,
           })
-          .from(simplifiedDocumentsView)
-          .where(eq(simplifiedDocumentsView.contractId, contractIds[0]))
+          .from(contracts)
+          .leftJoin(vendors, eq(contracts.vendorId, vendors.id))
+          .where(eq(contracts.id, contractIds[0]))
           .limit(1)
   
         return { data, total, drawingKind, vendorInfo }