(대표님) RFQ-last, tbe-last, 기본계약 템플릿 내 견적,입찰,계약 추가, env.dev NAS_PATH 수정

1 files changed, 83 insertions, 0 deletions

diff --git a/app/api/contracts/prepare-template/route.ts b/app/api/contracts/prepare-template/route.ts
new file mode 100644
index 00000000..189643b5
--- /dev/null
+++ b/app/api/contracts/prepare-template/route.ts
@@ -0,0 +1,83 @@
+import { NextRequest, NextResponse } from "next/server";
+import db from "@/db/db";
+import { basicContractTemplates, vendors } from "@/db/schema";
+import { eq, and, ilike } from "drizzle-orm";
+
+export async function POST(request: NextRequest) {
+  try {
+    const { templateName, vendorId } = await request.json();
+
+    // 템플릿 조회
+    const [template] = await db
+      .select()
+      .from(basicContractTemplates)
+      .where(
+        and(
+          ilike(basicContractTemplates.templateName, `%${templateName}%`),
+          eq(basicContractTemplates.status, "ACTIVE")
+        )
+      )
+      .limit(1);
+
+
+
+    if (!template) {
+      return NextResponse.json(
+        { error: "템플릿을 찾을 수 없습니다." },
+        { status: 404 }
+      );
+    }
+
+    // 벤더 정보 조회
+    const [vendor] = await db
+      .select()
+      .from(vendors)
+      .where(eq(vendors.id, vendorId))
+      .limit(1);
+
+    if (!vendor) {
+      return NextResponse.json(
+        { error: "벤더를 찾을 수 없습니다." },
+        { status: 404 }
+      );
+    }
+
+    // 템플릿 데이터 준비
+    const templateData = {
+      company_name: vendor.vendorName || '협력업체명',
+      company_address: vendor.address || '주소',
+      company_address_detail: vendor.addressDetail || '',
+      company_postal_code: vendor.postalCode || '',
+      company_country: vendor.country || '대한민국',
+      representative_name: vendor.representativeName || '대표자명',
+      representative_email: vendor.representativeEmail || '',
+      representative_phone: vendor.representativePhone || '',
+      tax_id: vendor.taxId || '사업자번호',
+      corporate_registration_number: vendor.corporateRegistrationNumber || '',
+      phone_number: vendor.phone || '전화번호',
+      email: vendor.email || '',
+      website: vendor.website || '',
+      signature_date: new Date().toLocaleDateString('ko-KR'),
+      contract_date: new Date().toISOString().split('T')[0],
+      effective_date: new Date().toISOString().split('T')[0],
+      expiry_date: new Date(Date.now() + 365 * 24 * 60 * 60 * 1000).toISOString().split('T')[0],
+      vendor_code: vendor.vendorCode || '',
+      business_size: vendor.businessSize || '',
+      credit_rating: vendor.creditRating || '',
+      template_type: templateName,
+      contract_number: `BC-${new Date().getFullYear()}-${String(vendorId).padStart(4, '0')}-${Date.now()}`,
+    };
+
+    return NextResponse.json({
+      template,
+      templateData
+    });
+
+  } catch (error) {
+    console.log("템플릿 준비 실패:", error);
+    return NextResponse.json(
+      { error: "템플릿 준비 중 오류가 발생했습니다." },
+      { status: 500 }
+    );
+  }
+}
\ No newline at end of file