From ee57cc221ff2edafd3c0f12a181214c602ed257e Mon Sep 17 00:00:00 2001 From: dujinkim Date: Tue, 22 Jul 2025 02:57:00 +0000 Subject: (대표님, 최겸) 이메일 템플릿, 벤더데이터 변경사항 대응, 기술영업 변경요구사항 구현 MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit --- lib/vendor-document-list/enhanced-document-service.ts | 11 ++++++----- 1 file changed, 6 insertions(+), 5 deletions(-) (limited to 'lib/vendor-document-list/enhanced-document-service.ts') 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 } -- cgit v1.2.3