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, biddingId, biddingCompanyId } = 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()}-${biddingId || '0'}-${String(vendorId).padStart(4, '0')}-${Date.now()}`,
    };

    return NextResponse.json({
      template,
      templateData
    });

  } catch (error) {
    console.log("템플릿 준비 실패:", error);
    return NextResponse.json(
      { error: "템플릿 준비 중 오류가 발생했습니다." },
      { status: 500 }
    );
  }
}