1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
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, 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 }
);
}
}
|
