summaryrefslogtreecommitdiff
path: root/lib
diff options
context:
space:
mode:
authordujinkim <dujin.kim@dtsolution.co.kr>2025-09-29 13:31:40 +0000
committerdujinkim <dujin.kim@dtsolution.co.kr>2025-09-29 13:31:40 +0000
commit4614210aa9878922cfa1e424ce677ef893a1b6b2 (patch)
tree5e7edcce05fbee207230af0a43ed08cd351d7c4f /lib
parente41e3af4e72870d44a94b03e0f3246d6ccaaca48 (diff)
(대표님) 구매 권한설정, data room 등
Diffstat (limited to 'lib')
-rw-r--r--lib/bidding/vendor/partners-bidding-list.tsx4
-rw-r--r--lib/forms/sedp-actions.ts59
-rw-r--r--lib/mail/templates/custom-rfq-invitation.hbs332
-rw-r--r--lib/permissions/permission-group-actions.ts9
-rw-r--r--lib/permissions/permission-group-assignment-actions.ts496
-rw-r--r--lib/permissions/permission-settings-actions.ts54
-rw-r--r--lib/permissions/service.ts88
-rw-r--r--lib/project-doc-templates/service.ts485
-rw-r--r--lib/project-doc-templates/table/add-project-doc-template-dialog.tsx642
-rw-r--r--lib/project-doc-templates/table/doc-template-table.tsx716
-rw-r--r--lib/project-doc-templates/table/project-doc-template-editor.tsx645
-rw-r--r--lib/project-doc-templates/table/template-detail-dialog.tsx121
-rw-r--r--lib/project-doc-templates/table/template-edit-sheet.tsx305
-rw-r--r--lib/project-doc-templates/validations.ts31
14 files changed, 3951 insertions, 36 deletions
diff --git a/lib/bidding/vendor/partners-bidding-list.tsx b/lib/bidding/vendor/partners-bidding-list.tsx
index fc3cd1f2..0f68ed68 100644
--- a/lib/bidding/vendor/partners-bidding-list.tsx
+++ b/lib/bidding/vendor/partners-bidding-list.tsx
@@ -38,10 +38,10 @@ export function PartnersBiddingList({ promises }: PartnersBiddingListProps) {
case 'view':
// 사전견적 요청 상태에서는 상세보기 제한
- if (bidding.status === 'request_for_quotation') {
+ if (bidding.status === 'request_for_quotation' || bidding.status === 'received_quotation' || bidding.status === 'set_target_price') {
toast({
title: '접근 제한',
- description: '사전견적 요청 상태에서는 본입찰을 이용할 수 없습니다.',
+ description: '사전견적 상태에서는 본입찰을 이용할 수 없습니다.',
variant: 'destructive',
})
return
diff --git a/lib/forms/sedp-actions.ts b/lib/forms/sedp-actions.ts
index 24ae2e66..d20fb9fc 100644
--- a/lib/forms/sedp-actions.ts
+++ b/lib/forms/sedp-actions.ts
@@ -74,7 +74,7 @@ export async function fetchTagDataFromSEDP(
export async function fetchTemplateFromSEDP(
projectCode: string,
formCode: string
-): Promise<SEDPTemplateData> {
+): Promise<SEDPTemplateData[]> {
try {
// Get the token
const apiKey = await getSEDPToken();
@@ -82,9 +82,8 @@ export async function fetchTemplateFromSEDP(
// Define the API base URL
const SEDP_API_BASE_URL = process.env.SEDP_API_BASE_URL || 'http://sedpwebapi.ship.samsung.co.kr/api';
- // Make the API call
- const response = await fetch(
- `${SEDP_API_BASE_URL}/Template/GetByRegisterID`,
+ const responseAdapter = await fetch(
+ `${SEDP_API_BASE_URL}/AdapterDataMapping/GetByToolID`,
{
method: 'POST',
headers: {
@@ -94,23 +93,59 @@ export async function fetchTemplateFromSEDP(
'ProjectNo': projectCode
},
body: JSON.stringify({
- WithContent: true,
ProjectNo: projectCode,
- REG_TYPE_ID: formCode
+ "TOOL_ID": "eVCP"
})
}
);
- if (!response.ok) {
- const errorText = await response.text();
- throw new Error(`SEDP Template API request failed: ${response.status} ${response.statusText} - ${errorText}`);
+ if (!responseAdapter.ok) {
+ throw new Error(`새 레지스터 요청 실패: ${responseAdapter.status} ${responseAdapter.statusText}`);
}
- const data = await response.json();
- return data as SEDPTemplateData;
+ const dataAdapter = await responseAdapter.json();
+ const templateList = dataAdapter.find(v => v.REG_TYPE_ID === formCode)?.MAP_TMPLS || [];
+
+ // 각 TMPL_ID에 대해 API 호출
+ const templatePromises = templateList.map(async (tmplId: string) => {
+ const response = await fetch(
+ `${SEDP_API_BASE_URL}/Template/GetByID`,
+ {
+ method: 'POST',
+ headers: {
+ 'Content-Type': 'application/json',
+ 'accept': '*/*',
+ 'ApiKey': apiKey,
+ 'ProjectNo': projectCode
+ },
+ body: JSON.stringify({
+ WithContent: true,
+ ProjectNo: projectCode,
+ TMPL_ID: tmplId
+ })
+ }
+ );
+
+ if (!response.ok) {
+ const errorText = await response.text();
+ throw new Error(`SEDP Template API request failed for TMPL_ID ${tmplId}: ${response.status} ${response.statusText} - ${errorText}`);
+ }
+
+ const data = await response.json();
+ return data as SEDPTemplateData;
+ });
+
+ // 모든 API 호출을 병렬로 실행하고 결과를 수집
+ const templates = await Promise.all(templatePromises);
+
+ // null이나 undefined가 아닌 값들만 필터링 (응답이 없는 경우 제외)
+ const validTemplates = templates.filter(template => template != null);
+
+ return validTemplates;
+
} catch (error: unknown) {
console.error('Error calling SEDP Template API:', error);
const errorMessage = error instanceof Error ? error.message : 'Unknown error';
throw new Error(`Failed to fetch template from SEDP API: ${errorMessage}`);
}
-}
+} \ No newline at end of file
diff --git a/lib/mail/templates/custom-rfq-invitation.hbs b/lib/mail/templates/custom-rfq-invitation.hbs
new file mode 100644
index 00000000..9303035b
--- /dev/null
+++ b/lib/mail/templates/custom-rfq-invitation.hbs
@@ -0,0 +1,332 @@
+<!DOCTYPE html>
+<html lang="{{language}}">
+<head>
+ <meta charset="UTF-8">
+ <meta name="viewport" content="width=device-width, initial-scale=1.0">
+ <title>RFQ 견적 요청</title>
+ <style>
+ body {
+ font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Roboto, 'Helvetica Neue', Arial, sans-serif;
+ line-height: 1.8;
+ color: #333;
+ max-width: 900px;
+ margin: 0 auto;
+ padding: 20px;
+ background-color: #f8fafc;
+ }
+ .container {
+ background-color: white;
+ border-radius: 12px;
+ padding: 40px;
+ box-shadow: 0 4px 20px rgba(0,0,0,0.08);
+ border: 1px solid #e2e8f0;
+ }
+ .header {
+ border-bottom: 4px solid #1e40af;
+ padding-bottom: 30px;
+ margin-bottom: 40px;
+ text-align: center;
+ }
+ .company-logo {
+ font-size: 28px;
+ font-weight: bold;
+ color: #1e40af;
+ margin-bottom: 10px;
+ letter-spacing: -0.5px;
+ }
+ .greeting {
+ font-size: 18px;
+ color: #1f2937;
+ margin-bottom: 30px;
+ line-height: 1.6;
+ }
+ .rfq-info {
+ background: linear-gradient(135deg, #3b82f6 0%, #1e40af 100%);
+ color: white;
+ padding: 25px;
+ border-radius: 10px;
+ margin: 30px 0;
+ text-align: center;
+ }
+ .rfq-title {
+ font-size: 24px;
+ font-weight: bold;
+ margin-bottom: 10px;
+ }
+ .rfq-code {
+ font-size: 18px;
+ font-weight: 600;
+ opacity: 0.9;
+ }
+ .project-section, .rfq-section, .contract-section, .notice-section {
+ margin: 30px 0;
+ padding: 25px;
+ background-color: #f8fafc;
+ border-radius: 8px;
+ border-left: 5px solid #3b82f6;
+ }
+ .section-title {
+ font-size: 20px;
+ font-weight: bold;
+ color: #1e40af;
+ margin-bottom: 20px;
+ padding-bottom: 10px;
+ border-bottom: 2px solid #e2e8f0;
+ }
+ .info-grid {
+ display: grid;
+ grid-template-columns: 1fr 2fr;
+ gap: 15px;
+ margin: 20px 0;
+ }
+ .info-item {
+ display: flex;
+ margin-bottom: 12px;
+ }
+ .info-label {
+ font-weight: 600;
+ color: #4b5563;
+ min-width: 120px;
+ margin-right: 15px;
+ }
+ .info-value {
+ color: #111827;
+ flex: 1;
+ }
+ .warranty-box {
+ background-color: #f0f9ff;
+ border: 2px solid #3b82f6;
+ padding: 20px;
+ border-radius: 8px;
+ margin: 20px 0;
+ font-style: italic;
+ }
+ .requirements-list {
+ background-color: #fef3c7;
+ border-left: 4px solid #f59e0b;
+ padding: 20px;
+ margin: 20px 0;
+ border-radius: 6px;
+ }
+ .requirements-list ul {
+ margin: 0;
+ padding-left: 20px;
+ }
+ .requirements-list li {
+ margin: 8px 0;
+ line-height: 1.6;
+ }
+ .contract-badges {
+ display: flex;
+ flex-wrap: wrap;
+ gap: 10px;
+ margin: 15px 0;
+ }
+ .contract-badge {
+ background-color: #dcfce7;
+ color: #166534;
+ padding: 8px 16px;
+ border-radius: 20px;
+ font-size: 14px;
+ font-weight: 600;
+ border: 2px solid #bbf7d0;
+ }
+ .contract-badge::before {
+ content: "📄 ";
+ }
+ .notice-section {
+ background-color: #fef2f2;
+ border-left-color: #ef4444;
+ border: 2px solid #fecaca;
+ }
+ .notice-list {
+ list-style: disc;
+ padding-left: 20px;
+ margin: 15px 0;
+ }
+ .notice-list li {
+ margin: 10px 0;
+ line-height: 1.6;
+ color: #7f1d1d;
+ }
+ .closing {
+ margin-top: 40px;
+ padding: 30px;
+ background: linear-gradient(135deg, #f8fafc 0%, #e2e8f0 100%);
+ border-radius: 10px;
+ text-align: center;
+ font-style: italic;
+ color: #4b5563;
+ }
+ .highlight-arrow {
+ font-size: 18px;
+ font-weight: bold;
+ color: #dc2626;
+ text-align: center;
+ margin: 20px 0;
+ background-color: #fef2f2;
+ padding: 10px;
+ border-radius: 6px;
+ display: inline-block;
+ }
+ .footer-note {
+ margin-top: 30px;
+ padding: 20px;
+ background-color: #f9fafb;
+ border-radius: 6px;
+ font-size: 14px;
+ color: #6b7280;
+ border: 1px solid #e5e7eb;
+ }
+ </style>
+</head>
+<body>
+ <div class="container">
+ <!-- Header -->
+ <div class="header">
+ <div class="company-logo">{{t 'email.company_name'}}</div>
+ </div>
+
+ <!-- Greeting -->
+ <div class="greeting">
+ 안녕하세요.<br><br>
+ 귀사 일익 번창하심을 기원합니다.<br><br>
+ 폐사는 귀사와 표제 프로젝트의 품목에 대한 거래를 위해<br>
+ 다음 품목에 대해 귀사의 견적 제출을 요청하오니 아래 내용 및 당사 시스템 접속하시어<br>
+ 견적의 상세 내용 확인하신 뒤 견적마감일까지 견적 제출 바랍니다.<br><br>
+ 귀사의 견적은 반드시 견적마감일 이전에 폐사로 제출되어야 하며,<br>
+ 견적마감일 전 별도의 지연 통보 없이 미제출될 경우에는 대상에서 제외될 수 있습니다.
+ </div>
+
+ <!-- RFQ Information -->
+ <div class="rfq-info">
+ <div class="rfq-title">{{rfqTitle}}</div>
+ <div class="rfq-code">RFQ No: {{rfqCode}}</div>
+ </div>
+
+ <!-- 1. 프로젝트 정보 -->
+ <div class="project-section">
+ <div class="section-title">1. 프로젝트 정보</div>
+ <div class="info-grid">
+ <div class="info-item">
+ <div class="info-label">프로젝트정보</div>
+ <div class="info-value">[{{projectCode}}] {{projectName}}</div>
+ </div>
+ <div class="info-item">
+ <div class="info-label">고객정보</div>
+ <div class="info-value">{{customerName}} ({{customerCode}})</div>
+ </div>
+ <div class="info-item">
+ <div class="info-label">선종</div>
+ <div class="info-value">{{shipType}} ({{shipClass}})</div>
+ </div>
+ <div class="info-item">
+ <div class="info-label">척수</div>
+ <div class="info-value">{{shipCount}}척</div>
+ </div>
+ <div class="info-item">
+ <div class="info-label">선급</div>
+ <div class="info-value">{{projectFlag}}</div>
+ </div>
+ <div class="info-item">
+ <div class="info-label">국적</div>
+ <div class="info-value">{{flag}}</div>
+ </div>
+ <div class="info-item">
+ <div class="info-label">계약발효일</div>
+ <div class="info-value">{{contractStartDate}} - {{contractEndDate}}</div>
+ </div>
+ <div class="info-item">
+ <div class="info-label">Key Event</div>
+ <div class="info-value">(S/C) {{scDate}} - (D/L) {{dlDate}}</div>
+ </div>
+ </div>
+ </div>
+
+ <!-- 2. 견적요청 정보 -->
+ <div class="rfq-section">
+ <div class="section-title">2. 견적요청 정보</div>
+ <div class="info-grid">
+ <div class="info-item">
+ <div class="info-label">PKG 정보</div>
+ <div class="info-value">[{{packageNo}}] {{packageName}}</div>
+ </div>
+ <div class="info-item">
+ <div class="info-label">자재그룹 정보</div>
+ <div class="info-value">[{{materialGroup}}] {{materialGroupDesc}}</div>
+ </div>
+ <div class="info-item">
+ <div class="info-label">품목</div>
+ <div class="info-value">{{#if itemCode}}{{itemCode}} - {{/if}}{{itemName}}</div>
+ </div>
+ <div class="info-item">
+ <div class="info-label">품목 수</div>
+ <div class="info-value">{{itemCount}}개</div>
+ </div>
+ <div class="info-item">
+ <div class="info-label">PR 번호</div>
+ <div class="info-value">{{#if prNumber}}{{prNumber}}{{else}}해당없음{{/if}}</div>
+ </div>
+ <div class="info-item">
+ <div class="info-label">PR 발행일</div>
+ <div class="info-value">{{#if prIssueDate}}{{prIssueDate}}{{else}}해당없음{{/if}}</div>
+ </div>
+ </div>
+
+ <div class="warranty-box">
+ <strong>Warranty</strong> {{warrantyDescription}}<br>
+ {{repairDescription}}<br>
+ {{totalWarrantyDescription}}
+ </div>
+
+ <div class="requirements-list">
+ <strong>필수제출정보</strong>
+ <ul>
+ {{#each requiredDocuments}}
+ <li>{{this}}</li>
+ {{/each}}
+ </ul>
+ </div>
+ </div>
+
+ <!-- 3. 필수 기본계약 -->
+ <div class="contract-section">
+ <div class="section-title">3. 필수 기본계약</div>
+ <div class="contract-badges">
+ {{#if contractRequirements.hasNda}}<span class="contract-badge">{{contractRequirements.ndaDescription}}</span>{{/if}}
+ {{#if contractRequirements.hasGeneralGtc}}<span class="contract-badge">{{contractRequirements.generalGtcDescription}}</span>{{/if}}
+ {{#if contractRequirements.hasProjectGtc}}<span class="contract-badge">{{contractRequirements.projectGtcDescription}}</span>{{/if}}
+ {{#if contractRequirements.hasAgreement}}<span class="contract-badge">{{contractRequirements.agreementDescription}}</span>{{/if}}
+ </div>
+
+ </div>
+
+ <!-- 4. 유의사항 -->
+ <div class="notice-section">
+ <div class="section-title">4. 유의사항</div>
+ <ul class="notice-list">
+ <li>발주자는 최저가 견적을 제출하지 않은 협력사를 선정할 수 있으며, 견적의 일부 또는 전부를 승인하거나 거절할 수 있고 거부하는 경우 별도 통보할 의무가 없다. 또한, 최종 탈락 사실을 통보할 의무도 없다.</li>
+ <li>협력사는 견적 제출을 위해 소요되는 비용 일체를 부담하며, 최종 계약자로 선정되지 못한 경우에도 발주자에게 보상을 청구할 수 없다. 또한, 선주 승인조건으로 선정된 협력사는 반드시 선주 승인을 득한 후 작업에 착수하여야 하며, 승인 거절 시 계약은 미 체결, 해제될 수 있고 이 경우 협력사는 어떠한 보상도 청구할 수 없다.</li>
+ </ul>
+ </div>
+
+ <!-- Closing -->
+ <div class="closing">
+ 이번 기회를 통하여 귀사와의 협업으로 다가올 미래 조선/해양산업 시장에서 함께 성장해 나갈 수 있기를 기대합니다.
+ </div>
+
+ <!-- Footer Note -->
+ <div class="footer-note">
+ <p><strong>📧 발송 정보:</strong></p>
+ <p>수신: {{vendorName}} ({{vendorCountry}})</p>
+ <p>발신: {{companyName}} {{picName}} 프로 {{picTeam}}</p>
+ <p>견적마감일: {{formattedDueDate}}</p>
+ <p>발송일시: {{formatDate now 'YYYY-MM-DD HH:mm:ss'}}</p>
+ <p>시스템: {{systemName}}</p>
+ {{#if hasAttachments}}
+ <p>첨부파일: {{attachmentsCount}}개 포함</p>
+ {{/if}}
+ </div>
+ </div>
+</body>
+</html>
diff --git a/lib/permissions/permission-group-actions.ts b/lib/permissions/permission-group-actions.ts
index 51e3c2c0..474dc21b 100644
--- a/lib/permissions/permission-group-actions.ts
+++ b/lib/permissions/permission-group-actions.ts
@@ -117,10 +117,13 @@ export async function updatePermissionGroup(id: number, data: any) {
// 권한 그룹 삭제
export async function deletePermissionGroup(id: number) {
- const currentUser = await getCurrentUser();
- if (!currentUser) throw new Error("Unauthorized");
+ const session = await getServerSession(authOptions)
+ if (!session?.user?.id) {
+ throw new Error("인증이 필요합니다.")
+ }
+ const currentUserId = Number(session.user.id)
- if (!await checkUserPermission(currentUser.id, "admin.permissions.manage")) {
+ if (!await checkUserPermission(currentUserId, "admin.permissions.manage")) {
throw new Error("권한 관리 권한이 없습니다.");
}
diff --git a/lib/permissions/permission-group-assignment-actions.ts b/lib/permissions/permission-group-assignment-actions.ts
new file mode 100644
index 00000000..d1311559
--- /dev/null
+++ b/lib/permissions/permission-group-assignment-actions.ts
@@ -0,0 +1,496 @@
+// app/actions/permission-group-assignment-actions.ts
+
+"use server";
+
+import db from "@/db/db";
+import { eq, and, inArray, sql, ne, notInArray, or } from "drizzle-orm";
+import {
+ permissionGroups,
+ permissionGroupMembers,
+ permissions,
+ rolePermissions,
+ userPermissions,
+ roles,
+ users,
+ userRoles,
+ permissionAuditLogs
+} from "@/db/schema";
+import { checkUserPermission } from "./service";
+import { getServerSession } from "next-auth/next";
+import { authOptions } from "@/app/api/auth/[...nextauth]/route";
+
+// 권한 그룹 할당 정보 조회
+export async function getPermissionGroupAssignments(groupId?: number) {
+ try {
+ if (!groupId) {
+ // 모든 그룹 목록 반환
+ const groups = await db
+ .select({
+ id: permissionGroups.id,
+ groupKey: permissionGroups.groupKey,
+ name: permissionGroups.name,
+ description: permissionGroups.description,
+ domain: permissionGroups.domain,
+ isActive: permissionGroups.isActive,
+ permissionCount: sql<number>`count(distinct ${permissionGroupMembers.permissionId})`.mapWith(Number),
+ })
+ .from(permissionGroups)
+ .leftJoin(permissionGroupMembers, eq(permissionGroupMembers.groupId, permissionGroups.id))
+ .where(eq(permissionGroups.isActive, true))
+ .groupBy(permissionGroups.id)
+ .orderBy(permissionGroups.name);
+
+ return { groups };
+ }
+
+ // 특정 그룹의 할당 정보 조회
+ // 그룹에 속한 모든 권한 ID 조회
+ const groupPermissionIds = await db
+ .select({ permissionId: permissionGroupMembers.permissionId })
+ .from(permissionGroupMembers)
+ .where(eq(permissionGroupMembers.groupId, groupId));
+
+ const permissionIds = groupPermissionIds.map(p => p.permissionId);
+
+ if (permissionIds.length === 0) {
+ return { roles: [], users: [] };
+ }
+
+ // 해당 그룹의 권한들이 할당된 역할 조회
+ const assignedRoles = await db
+ .selectDistinct({
+ id: roles.id,
+ name: roles.name,
+ domain: roles.domain,
+ grantedAt: rolePermissions.grantedAt,
+ grantedBy: rolePermissions.grantedBy,
+ })
+ .from(rolePermissions)
+ .innerJoin(roles, eq(roles.id, rolePermissions.roleId))
+ .where(
+ and(
+ eq(rolePermissions.permissionGroupId, groupId),
+ eq(rolePermissions.isActive, true)
+ )
+ );
+
+ // 역할별 사용자 수 조회
+ const rolesWithUserCount = await Promise.all(
+ assignedRoles.map(async (role) => {
+ const userCount = await db
+ .select({ count: sql<number>`count(*)`.mapWith(Number) })
+ .from(userRoles)
+ .where(eq(userRoles.roleId, role.id));
+
+ // grantedBy가 userId인 경우 사용자 정보 조회
+ let assignedBy = 'system';
+ if (role.grantedBy) {
+ const [user] = await db
+ .select({ name: users.name })
+ .from(users)
+ .where(eq(users.id, role.grantedBy));
+ if (user) assignedBy = user.name;
+ }
+
+ return {
+ ...role,
+ userCount: userCount[0]?.count || 0,
+ assignedAt: role.grantedAt,
+ assignedBy
+ };
+ })
+ );
+
+ // 해당 그룹의 권한들이 직접 할당된 사용자 조회
+ const assignedUsers = await db
+ .selectDistinct({
+ id: users.id,
+ name: users.name,
+ email: users.email,
+ imageUrl: users.imageUrl,
+ domain: users.domain,
+ grantedAt: userPermissions.grantedAt,
+ grantedBy: userPermissions.grantedBy,
+ })
+ .from(userPermissions)
+ .innerJoin(users, eq(users.id, userPermissions.userId))
+ .where(
+ and(
+ eq(userPermissions.permissionGroupId, groupId),
+ eq(userPermissions.isActive, true),
+ eq(userPermissions.isGrant, true)
+ )
+ );
+
+ // 사용자별 회사 정보 및 할당자 정보 추가
+ const usersWithDetails = await Promise.all(
+ assignedUsers.map(async (user) => {
+ // 회사 정보는 companyId로 조회 (vendors 테이블 필요)
+ let assignedBy = 'system';
+ if (user.grantedBy) {
+ const [grantUser] = await db
+ .select({ name: users.name })
+ .from(users)
+ .where(eq(users.id, user.grantedBy));
+ if (grantUser) assignedBy = grantUser.name;
+ }
+
+ return {
+ ...user,
+ companyName: null, // 필요시 vendors 테이블 조인
+ assignedAt: user.grantedAt,
+ assignedBy
+ };
+ })
+ );
+
+ return {
+ roles: rolesWithUserCount,
+ users: usersWithDetails
+ };
+ } catch (error) {
+ console.error('Failed to get permission group assignments:', error);
+ throw new Error('권한 그룹 할당 정보 조회에 실패했습니다.');
+ }
+}
+
+// 역할 검색 (그룹에 아직 할당되지 않은)
+export async function searchRoles(groupId: number) {
+ try {
+ // 이미 해당 그룹이 할당된 역할 ID 조회
+ const assignedRoleIds = await db
+ .selectDistinct({ roleId: rolePermissions.roleId })
+ .from(rolePermissions)
+ .where(
+ and(
+ eq(rolePermissions.permissionGroupId, groupId),
+ eq(rolePermissions.isActive, true)
+ )
+ );
+
+ const assignedIds = assignedRoleIds.map(r => r.roleId);
+
+ // 할당되지 않은 역할 조회
+ const availableRoles = await db
+ .select({
+ id: roles.id,
+ name: roles.name,
+ domain: roles.domain,
+ })
+ .from(roles)
+ .where(
+ assignedIds.length > 0
+ ? notInArray(roles.id, assignedIds)
+ : undefined
+ );
+
+ // 역할별 사용자 수 추가
+ const rolesWithUserCount = await Promise.all(
+ availableRoles.map(async (role) => {
+ const userCount = await db
+ .select({ count: sql<number>`count(*)`.mapWith(Number) })
+ .from(userRoles)
+ .where(eq(userRoles.roleId, role.id));
+
+ return {
+ ...role,
+ userCount: userCount[0]?.count || 0
+ };
+ })
+ );
+
+ return rolesWithUserCount;
+ } catch (error) {
+ console.error('Failed to search roles:', error);
+ throw new Error('역할 검색에 실패했습니다.');
+ }
+}
+
+// 사용자 검색 (그룹에 아직 할당되지 않은)
+export async function searchUsers(query: string, groupId: number) {
+ try {
+ // 이미 해당 그룹이 할당된 사용자 ID 조회
+ const assignedUserIds = await db
+ .selectDistinct({ userId: userPermissions.userId })
+ .from(userPermissions)
+ .where(
+ and(
+ eq(userPermissions.permissionGroupId, groupId),
+ eq(userPermissions.isActive, true),
+ eq(userPermissions.isGrant, true)
+ )
+ );
+
+ const assignedIds = assignedUserIds.map(u => u.userId);
+
+ // 할당되지 않은 사용자 검색
+ const availableUsers = await db
+ .select({
+ id: users.id,
+ name: users.name,
+ email: users.email,
+ imageUrl: users.imageUrl,
+ domain: users.domain,
+ })
+ .from(users)
+ .where(
+ and(
+ or(
+ sql`${users.name} ILIKE ${`%${query}%`}`,
+ sql`${users.email} ILIKE ${`%${query}%`}`
+ ),
+ eq(users.isActive, true),
+ assignedIds.length > 0
+ ? notInArray(users.id, assignedIds)
+ : undefined
+ )
+ )
+ .limit(20);
+
+ return availableUsers.map(user => ({
+ ...user,
+ companyName: null // 필요시 vendors 테이블 조인
+ }));
+ } catch (error) {
+ console.error('Failed to search users:', error);
+ throw new Error('사용자 검색에 실패했습니다.');
+ }
+}
+
+// 그룹을 역할에 할당
+export async function assignGroupToRoles(groupId: number, roleIds: number[]) {
+ const session = await getServerSession(authOptions);
+ if (!session?.user?.id) {
+ throw new Error("인증이 필요합니다.");
+ }
+ const currentUserId = Number(session.user.id);
+
+ if (!await checkUserPermission(currentUserId, "admin.permissions.manage")) {
+ throw new Error("권한 관리 권한이 없습니다.");
+ }
+
+ try {
+ // 그룹에 속한 모든 권한 ID 조회
+ const groupPermissions = await db
+ .select({ permissionId: permissionGroupMembers.permissionId })
+ .from(permissionGroupMembers)
+ .where(eq(permissionGroupMembers.groupId, groupId));
+
+ if (groupPermissions.length === 0) {
+ throw new Error("그룹에 권한이 없습니다.");
+ }
+
+ await db.transaction(async (tx) => {
+ for (const roleId of roleIds) {
+ // 각 역할에 대해 그룹의 모든 권한 할당
+ for (const { permissionId } of groupPermissions) {
+ // 기존 할당 확인 (중복 방지)
+ const existing = await tx
+ .select()
+ .from(rolePermissions)
+ .where(
+ and(
+ eq(rolePermissions.roleId, roleId),
+ eq(rolePermissions.permissionId, permissionId),
+ eq(rolePermissions.permissionGroupId, groupId)
+ )
+ )
+ .limit(1);
+
+ if (existing.length === 0) {
+ await tx.insert(rolePermissions).values({
+ roleId,
+ permissionId,
+ permissionGroupId: groupId,
+ grantedBy: currentUserId,
+ grantedAt: new Date(),
+ isActive: true
+ });
+ }
+ }
+
+ // 감사 로그 추가
+ await tx.insert(permissionAuditLogs).values({
+ targetType: 'role',
+ targetId: roleId,
+ permissionGroupId: groupId,
+ action: 'grant',
+ performedBy: currentUserId,
+ reason: `권한 그룹 ${groupId} 할당`
+ });
+ }
+ });
+
+ return { success: true, count: roleIds.length };
+ } catch (error) {
+ console.error('Failed to assign group to roles:', error);
+ throw new Error('역할에 권한 그룹 할당에 실패했습니다.');
+ }
+}
+
+// 그룹을 사용자에 할당
+export async function assignGroupToUsers(groupId: number, userIds: number[]) {
+ const session = await getServerSession(authOptions);
+ if (!session?.user?.id) {
+ throw new Error("인증이 필요합니다.");
+ }
+ const currentUserId = Number(session.user.id);
+
+ if (!await checkUserPermission(currentUserId, "admin.permissions.manage")) {
+ throw new Error("권한 관리 권한이 없습니다.");
+ }
+
+ try {
+ // 그룹에 속한 모든 권한 ID 조회
+ const groupPermissions = await db
+ .select({ permissionId: permissionGroupMembers.permissionId })
+ .from(permissionGroupMembers)
+ .where(eq(permissionGroupMembers.groupId, groupId));
+
+ if (groupPermissions.length === 0) {
+ throw new Error("그룹에 권한이 없습니다.");
+ }
+
+ await db.transaction(async (tx) => {
+ for (const userId of userIds) {
+ // 각 사용자에 대해 그룹의 모든 권한 할당
+ for (const { permissionId } of groupPermissions) {
+ // 기존 할당 확인 (중복 방지)
+ const existing = await tx
+ .select()
+ .from(userPermissions)
+ .where(
+ and(
+ eq(userPermissions.userId, userId),
+ eq(userPermissions.permissionId, permissionId)
+ )
+ )
+ .limit(1);
+
+ if (existing.length === 0) {
+ await tx.insert(userPermissions).values({
+ userId,
+ permissionId,
+ permissionGroupId: groupId,
+ isGrant: true,
+ grantedBy: currentUserId,
+ grantedAt: new Date(),
+ isActive: true
+ });
+ } else if (existing[0].permissionGroupId !== groupId) {
+ // 다른 그룹으로 할당되어 있다면 업데이트
+ await tx.update(userPermissions)
+ .set({
+ permissionGroupId: groupId,
+ grantedBy: currentUserId,
+ grantedAt: new Date()
+ })
+ .where(
+ and(
+ eq(userPermissions.userId, userId),
+ eq(userPermissions.permissionId, permissionId)
+ )
+ );
+ }
+ }
+
+ // 감사 로그 추가
+ await tx.insert(permissionAuditLogs).values({
+ targetType: 'user',
+ targetId: userId,
+ permissionGroupId: groupId,
+ action: 'grant',
+ performedBy: currentUserId,
+ reason: `권한 그룹 ${groupId} 할당`
+ });
+ }
+ });
+
+ return { success: true, count: userIds.length };
+ } catch (error) {
+ console.error('Failed to assign group to users:', error);
+ throw new Error('사용자에게 권한 그룹 할당에 실패했습니다.');
+ }
+}
+
+// 역할에서 그룹 제거
+export async function removeGroupFromRole(groupId: number, roleId: number) {
+ const session = await getServerSession(authOptions);
+ if (!session?.user?.id) {
+ throw new Error("인증이 필요합니다.");
+ }
+ const currentUserId = Number(session.user.id);
+
+ if (!await checkUserPermission(currentUserId, "admin.permissions.manage")) {
+ throw new Error("권한 관리 권한이 없습니다.");
+ }
+
+ try {
+ await db.transaction(async (tx) => {
+ // 해당 그룹으로 할당된 모든 권한 제거
+ await tx.delete(rolePermissions)
+ .where(
+ and(
+ eq(rolePermissions.roleId, roleId),
+ eq(rolePermissions.permissionGroupId, groupId)
+ )
+ );
+
+ // 감사 로그 추가
+ await tx.insert(permissionAuditLogs).values({
+ targetType: 'role',
+ targetId: roleId,
+ permissionGroupId: groupId,
+ action: 'revoke',
+ performedBy: currentUserId,
+ reason: `권한 그룹 ${groupId} 제거`
+ });
+ });
+
+ return { success: true };
+ } catch (error) {
+ console.error('Failed to remove group from role:', error);
+ throw new Error('역할에서 권한 그룹 제거에 실패했습니다.');
+ }
+}
+
+// 사용자에서 그룹 제거
+export async function removeGroupFromUser(groupId: number, userId: number) {
+ const session = await getServerSession(authOptions);
+ if (!session?.user?.id) {
+ throw new Error("인증이 필요합니다.");
+ }
+ const currentUserId = Number(session.user.id);
+
+ if (!await checkUserPermission(currentUserId, "admin.permissions.manage")) {
+ throw new Error("권한 관리 권한이 없습니다.");
+ }
+
+ try {
+ await db.transaction(async (tx) => {
+ // 해당 그룹으로 할당된 모든 권한 제거
+ await tx.delete(userPermissions)
+ .where(
+ and(
+ eq(userPermissions.userId, userId),
+ eq(userPermissions.permissionGroupId, groupId)
+ )
+ );
+
+ // 감사 로그 추가
+ await tx.insert(permissionAuditLogs).values({
+ targetType: 'user',
+ targetId: userId,
+ permissionGroupId: groupId,
+ action: 'revoke',
+ performedBy: currentUserId,
+ reason: `권한 그룹 ${groupId} 제거`
+ });
+ });
+
+ return { success: true };
+ } catch (error) {
+ console.error('Failed to remove group from user:', error);
+ throw new Error('사용자에서 권한 그룹 제거에 실패했습니다.');
+ }
+} \ No newline at end of file
diff --git a/lib/permissions/permission-settings-actions.ts b/lib/permissions/permission-settings-actions.ts
index 5d04a1d3..bb82b456 100644
--- a/lib/permissions/permission-settings-actions.ts
+++ b/lib/permissions/permission-settings-actions.ts
@@ -12,6 +12,37 @@ import {
import { getServerSession } from "next-auth/next"
import { authOptions } from "@/app/api/auth/[...nextauth]/route"
import { checkUserPermission } from "./service";
+import fs from 'fs/promises';
+import path from 'path';
+
+// i18n 번역 파일을 읽어오는 헬퍼 함수
+async function getTranslations(locale: string = 'ko') {
+ try {
+ const filePath = path.join(process.cwd(), 'i18n', 'locales', locale, 'menu.json');
+ const fileContent = await fs.readFile(filePath, 'utf-8');
+ return JSON.parse(fileContent);
+ } catch (error) {
+ console.error(`Failed to load translations for ${locale}:`, error);
+ return {};
+ }
+}
+
+// 중첩된 객체에서 키로 값을 가져오는 헬퍼 함수
+function getNestedValue(obj: any, key: string): string {
+ const keys = key.split('.');
+ let value = obj;
+
+ for (const k of keys) {
+ if (value && typeof value === 'object' && k in value) {
+ value = value[k];
+ } else {
+ return key; // 키를 찾지 못하면 원본 키를 반환
+ }
+ }
+
+ return typeof value === 'string' ? value : key;
+}
+
// 모든 권한 조회
export async function getAllPermissions() {
@@ -110,7 +141,11 @@ export async function deletePermission(id: number) {
}
// 메뉴 권한 분석
+
export async function analyzeMenuPermissions() {
+ // 한국어 번역 파일 로드
+ const translations = await getTranslations('ko');
+
const menus = await db.select().from(menuAssignments);
const analysis = await Promise.all(
@@ -126,20 +161,26 @@ export async function analyzeMenuPermissions() {
.innerJoin(permissions, eq(permissions.id, menuRequiredPermissions.permissionId))
.where(eq(menuRequiredPermissions.menuPath, menu.menuPath));
+ // i18n 키를 실제 텍스트로 변환
+ const menuTitleTranslated = getNestedValue(translations, menu.menuTitle);
+ const menuDescriptionTranslated = menu.menuDescription
+ ? getNestedValue(translations, menu.menuDescription)
+ : '';
+
// 제안할 권한 생성
const suggestedPermissions = [];
const resourceName = menu.menuPath.split('/').pop() || 'unknown';
- // 기본 메뉴 접근 권한
+ // 기본 메뉴 접근 권한 (번역된 제목 사용)
suggestedPermissions.push({
permissionKey: `${resourceName}.menu_access`,
- name: `${menu.menuTitle} 접근`,
+ name: `${menuTitleTranslated} 접근`,
permissionType: "menu_access",
action: "access",
scope: "assigned",
});
- // CRUD 권한 제안
+ // CRUD 권한 제안 (번역된 제목 사용)
const actions = [
{ action: "view", name: "조회", type: "data_read" },
{ action: "create", name: "생성", type: "data_write" },
@@ -150,7 +191,7 @@ export async function analyzeMenuPermissions() {
actions.forEach(({ action, name, type }) => {
suggestedPermissions.push({
permissionKey: `${resourceName}.${action}`,
- name: `${menu.menuTitle} ${name}`,
+ name: `${menuTitleTranslated} ${name}`,
permissionType: type,
action,
scope: "assigned",
@@ -159,7 +200,9 @@ export async function analyzeMenuPermissions() {
return {
menuPath: menu.menuPath,
- menuTitle: menu.menuTitle,
+ menuTitle: menuTitleTranslated, // 번역된 제목
+ menuTitleKey: menu.menuTitle, // 원본 i18n 키 (필요한 경우)
+ menuDescription: menuDescriptionTranslated, // 번역된 설명
domain: menu.domain,
existingPermissions: existing,
suggestedPermissions: suggestedPermissions.filter(
@@ -172,6 +215,7 @@ export async function analyzeMenuPermissions() {
return analysis;
}
+
// 메뉴 기반 권한 생성
export async function generateMenuPermissions(
permissionsToCreate: Array<{
diff --git a/lib/permissions/service.ts b/lib/permissions/service.ts
index 3ef1ff04..b3e6b4bc 100644
--- a/lib/permissions/service.ts
+++ b/lib/permissions/service.ts
@@ -3,7 +3,7 @@
"use server";
import db from "@/db/db";
-import { eq, and, inArray, or, ilike } from "drizzle-orm";
+import { eq, and, inArray, or, ilike, sql } from "drizzle-orm";
import {
permissions,
rolePermissions,
@@ -70,21 +70,58 @@ export async function assignPermissionsToRole(
// 역할의 권한 목록 조회
+// 역할 권한 조회 (기존 함수)
export async function getRolePermissions(roleId: number) {
- const allPermissions = await db.select().from(permissions)
- .where(eq(permissions.isActive, true));
-
- const rolePerms = await db.select({
- permissionId: rolePermissions.permissionId,
- })
+ try {
+ // 역할에 할당된 권한 조회
+ const assignedPermissions = await db
+ .select({
+ id: permissions.id,
+ permissionKey: permissions.permissionKey,
+ name: permissions.name,
+ description: permissions.description,
+ resource: permissions.resource,
+ action: permissions.action,
+ permissionType: permissions.permissionType,
+ scope: permissions.scope,
+ menuPath: permissions.menuPath,
+ })
.from(rolePermissions)
- .where(eq(rolePermissions.roleId, roleId));
-
- return {
+ .innerJoin(permissions, eq(permissions.id, rolePermissions.permissionId))
+ .where(
+ and(
+ eq(rolePermissions.roleId, roleId),
+ eq(rolePermissions.isActive, true)
+ )
+ );
+
+ // 모든 활성 권한 조회
+ const allPermissions = await db
+ .select({
+ id: permissions.id,
+ permissionKey: permissions.permissionKey,
+ name: permissions.name,
+ description: permissions.description,
+ resource: permissions.resource,
+ action: permissions.action,
+ permissionType: permissions.permissionType,
+ scope: permissions.scope,
+ menuPath: permissions.menuPath,
+ })
+ .from(permissions)
+ .where(eq(permissions.isActive, true))
+ .orderBy(permissions.resource, permissions.name);
+
+ return {
permissions: allPermissions,
- assignedPermissionIds: rolePerms.map(rp => rp.permissionId),
- };
-}
+ assignedPermissionIds: assignedPermissions.map(p => p.id)
+ };
+ } catch (error) {
+ console.error('Failed to get role permissions:', error);
+ throw new Error('역할 권한 조회에 실패했습니다.');
+ }
+ }
+
// 권한 체크 함수
export async function checkUserPermission(
@@ -431,4 +468,27 @@ export async function updateMenuPermissions(
);
}
});
-} \ No newline at end of file
+}
+
+// 역할 목록 조회
+export async function getRoles() {
+ try {
+ const rolesData = await db
+ .select({
+ id: roles.id,
+ name: roles.name,
+ domain: roles.domain,
+ description: roles.description,
+ userCount: sql<number>`count(distinct ${userRoles.userId})`.mapWith(Number),
+ })
+ .from(roles)
+ .leftJoin(userRoles, eq(userRoles.roleId, roles.id))
+ .groupBy(roles.id)
+ .orderBy(roles.domain, roles.name);
+
+ return rolesData;
+ } catch (error) {
+ console.log('Failed to get roles:', error);
+ throw new Error('역할 목록 조회에 실패했습니다.');
+ }
+ } \ No newline at end of file
diff --git a/lib/project-doc-templates/service.ts b/lib/project-doc-templates/service.ts
new file mode 100644
index 00000000..a5bccce5
--- /dev/null
+++ b/lib/project-doc-templates/service.ts
@@ -0,0 +1,485 @@
+// lib/project-doc-templates/service.ts
+"use server";
+
+import db from "@/db/db";
+import { projectDocTemplates, projectDocTemplateUsage, projects, type NewProjectDocTemplate, type DocTemplateVariable } from "@/db/schema";
+import { eq, and, desc, asc, isNull, sql, inArray, count, or, ilike } from "drizzle-orm";
+import { revalidatePath, revalidateTag } from "next/cache";
+import { GetDOCTemplatesSchema } from "./validations";
+import { filterColumns } from "@/lib/filter-columns";
+import { getServerSession } from "next-auth/next"
+import { authOptions } from "@/app/api/auth/[...nextauth]/route"
+
+// 기본 변수 정의
+const DEFAULT_VARIABLES: DocTemplateVariable[] = [
+ {
+ name: "document_number",
+ displayName: "문서번호",
+ type: "text",
+ required: true,
+ description: "문서 고유 번호",
+ },
+ {
+ name: "project_code",
+ displayName: "프로젝트 코드",
+ type: "text",
+ required: true,
+ description: "프로젝트 식별 코드",
+ },
+ {
+ name: "project_name",
+ displayName: "프로젝트명",
+ type: "text",
+ required: true,
+ description: "프로젝트 이름",
+ },
+ {
+ name: "created_date",
+ displayName: "작성일",
+ type: "date",
+ required: false,
+ defaultValue: "{{today}}",
+ description: "문서 작성 날짜",
+ },
+ {
+ name: "author_name",
+ displayName: "작성자",
+ type: "text",
+ required: false,
+ description: "문서 작성자 이름",
+ },
+ {
+ name: "department",
+ displayName: "부서명",
+ type: "text",
+ required: false,
+ description: "작성 부서",
+ },
+];
+
+
+export async function getProjectDocTemplates(
+ input: GetDOCTemplatesSchema
+) {
+ try {
+ const offset = (input.page - 1) * input.perPage;
+
+ // 고급 필터 조건
+ const advancedWhere = filterColumns({
+ table: projectDocTemplates,
+ filters: input.filters,
+ joinOperator: input.joinOperator,
+ });
+
+ // 전역 검색 조건 (중복 제거됨)
+ let globalWhere: SQL | undefined = undefined;
+ if (input.search?.trim()) {
+ const searchTerm = `%${input.search.trim()}%`;
+ globalWhere = or(
+ ilike(projectDocTemplates.templateName, searchTerm),
+ ilike(projectDocTemplates.templateCode, searchTerm),
+ ilike(projectDocTemplates.projectCode, searchTerm),
+ ilike(projectDocTemplates.projectName, searchTerm),
+ ilike(projectDocTemplates.documentType, searchTerm),
+ ilike(projectDocTemplates.fileName, searchTerm), // 중복 제거
+ ilike(projectDocTemplates.createdByName, searchTerm),
+ ilike(projectDocTemplates.updatedByName, searchTerm),
+ ilike(projectDocTemplates.status, searchTerm),
+ ilike(projectDocTemplates.description, searchTerm) // 추가 고려
+ );
+ }
+
+ // WHERE 조건 결합
+ const whereCondition = and(advancedWhere, globalWhere, eq(projectDocTemplates.isLatest,true));
+
+ // 정렬 조건 (타입 안정성 개선)
+ const orderBy = input.sort.length > 0
+ ? input.sort.map((item) => {
+ const column = projectDocTemplates[item.id as keyof typeof projectDocTemplates];
+ if (!column) {
+ console.warn(`Invalid sort column: ${item.id}`);
+ return null;
+ }
+ return item.desc ? desc(column) : asc(column);
+ }).filter(Boolean) as SQL[]
+ : [desc(projectDocTemplates.createdAt)];
+
+ // 데이터 조회 (프로젝트 정보 조인 추가 고려)
+ const [data, totalCount] = await Promise.all([
+ db
+ .select({
+ ...projectDocTemplates,
+ // 프로젝트 정보가 필요한 경우
+ // project: projects
+ })
+ .from(projectDocTemplates)
+ // .leftJoin(projects, eq(projectDocTemplates.projectId, projects.id))
+ .where(whereCondition)
+ .orderBy(...orderBy)
+ .limit(input.perPage)
+ .offset(offset),
+ db
+ .select({ count: count() })
+ .from(projectDocTemplates)
+ .where(whereCondition)
+ .then((res) => res[0]?.count ?? 0),
+ ]);
+
+ const pageCount = Math.ceil(totalCount / input.perPage);
+
+ return {
+ data,
+ pageCount,
+ totalCount,
+ };
+ } catch (error) {
+ console.error("Failed to fetch project doc templates:", error);
+ throw new Error("템플릿 목록을 불러오는데 실패했습니다.");
+ }
+}
+
+// 템플릿 생성
+export async function createProjectDocTemplate(data: {
+ templateName: string;
+ templateCode?: string;
+ description?: string;
+ projectId?: number;
+ templateType: "PROJECT" | "COMPANY_WIDE";
+ documentType: string;
+ filePath: string;
+ fileName: string;
+ fileSize?: number;
+ mimeType?: string;
+ variables?: DocTemplateVariable[];
+ isPublic?: boolean;
+ requiresApproval?: boolean;
+ createdBy?: string;
+}) {
+ try {
+ // 템플릿 코드 자동 생성 (없을 경우)
+ const templateCode = data.templateCode || `TPL_${Date.now()}`;
+ const session = await getServerSession(authOptions)
+ if (!session?.user?.id) {
+ throw new Error("인증이 필요합니다.")
+ }
+
+
+ // 프로젝트 정보 조회 (projectId가 있는 경우)
+ let projectInfo = null;
+ if (data.projectId) {
+ projectInfo = await db
+ .select()
+ .from(projects)
+ .where(eq(projects.id, data.projectId))
+ .then((res) => res[0]);
+ }
+
+ // 변수 정보 설정 (기본 변수 + 사용자 정의 변수)
+ const variables = [...DEFAULT_VARIABLES, ...(data.variables || [])];
+ const requiredVariables = variables
+ .filter((v) => v.required)
+ .map((v) => v.name);
+
+ const newTemplate: NewProjectDocTemplate = {
+ templateName: data.templateName,
+ templateCode,
+ description: data.description,
+ projectId: data.projectId,
+ projectCode: projectInfo?.code,
+ projectName: projectInfo?.name,
+ templateType: data.templateType,
+ documentType: data.documentType,
+ filePath: data.filePath,
+ fileName: data.fileName,
+ fileSize: data.fileSize,
+ mimeType: data.mimeType,
+ variables,
+ requiredVariables,
+ isPublic: data.isPublic || false,
+ requiresApproval: data.requiresApproval || false,
+ status: "ACTIVE",
+ createdBy: Number(session.user.id),
+ createdByName: Number(session.user.name),
+ };
+
+ const [template] = await db
+ .insert(projectDocTemplates)
+ .values(newTemplate)
+ .returning();
+
+ revalidateTag("project-doc-templates");
+ revalidatePath("/project-doc-templates");
+
+ return { success: true, data: template };
+ } catch (error) {
+ console.error("Failed to create template:", error);
+ return { success: false, error: "템플릿 생성에 실패했습니다." };
+ }
+}
+
+// 템플릿 상세 조회
+export async function getProjectDocTemplateById(templateId: number) {
+ try {
+ const template = await db
+ .select({
+ template: projectDocTemplates,
+ project: projects,
+ })
+ .from(projectDocTemplates)
+ .leftJoin(projects, eq(projectDocTemplates.projectId, projects.id))
+ .where(eq(projectDocTemplates.id, templateId))
+ .then((res) => res[0]);
+
+ if (!template) {
+ throw new Error("템플릿을 찾을 수 없습니다.");
+ }
+
+ // 버전 히스토리 조회
+ const versionHistory = await db
+ .select()
+ .from(projectDocTemplates)
+ .where(
+ and(
+ eq(projectDocTemplates.templateCode, template.template.templateCode),
+ isNull(projectDocTemplates.deletedAt)
+ )
+ )
+ .orderBy(desc(projectDocTemplates.version));
+
+ // 사용 이력 조회 (최근 10건)
+ const usageHistory = await db
+ .select()
+ .from(projectDocTemplateUsage)
+ .where(eq(projectDocTemplateUsage.templateId, templateId))
+ .orderBy(desc(projectDocTemplateUsage.usedAt))
+ .limit(10);
+
+ return {
+ ...template.template,
+ project: template.project,
+ versionHistory,
+ usageHistory,
+ };
+ } catch (error) {
+ console.error("Failed to fetch template details:", error);
+ throw new Error("템플릿 상세 정보를 불러오는데 실패했습니다.");
+ }
+}
+
+// 템플릿 업데이트
+export async function updateProjectDocTemplate(
+ templateId: number,
+ data: Partial<{
+ templateName: string;
+ description: string;
+ documentType: string;
+ variables: TemplateVariable[];
+ isPublic: boolean;
+ requiresApproval: boolean;
+ status: string;
+ updatedBy: string;
+ }>
+) {
+ try {
+ // 변수 정보 업데이트 시 requiredVariables도 함께 업데이트
+ const updateData: any = { ...data, updatedAt: new Date() };
+
+ if (data.variables) {
+ updateData.variables = data.variables;
+ updateData.requiredVariables = data.variables
+ .filter((v) => v.required)
+ .map((v) => v.name);
+ }
+
+ const [updated] = await db
+ .update(projectDocTemplates)
+ .set(updateData)
+ .where(eq(projectDocTemplates.id, templateId))
+ .returning();
+
+ revalidateTag("project-doc-templates");
+ revalidatePath("/project-doc-templates");
+
+ return { success: true, data: updated };
+ } catch (error) {
+ console.error("Failed to update template:", error);
+ return { success: false, error: "템플릿 업데이트에 실패했습니다." };
+ }
+}
+
+// 새 버전 생성
+export async function createTemplateVersion(
+ templateId: number,
+ data: {
+ filePath: string;
+ fileName: string;
+ fileSize?: number;
+ mimeType?: string;
+ variables?: DocTemplateVariable[];
+ createdBy?: string;
+ }
+) {
+ try {
+
+ const session = await getServerSession(authOptions)
+ if (!session?.user?.id) {
+ throw new Error("인증이 필요합니다.")
+ }
+
+
+ // 기존 템플릿 조회
+ const existingTemplate = await db
+ .select()
+ .from(projectDocTemplates)
+ .where(eq(projectDocTemplates.id, templateId))
+ .then((res) => res[0]);
+
+ if (!existingTemplate) {
+ throw new Error("템플릿을 찾을 수 없습니다.");
+ }
+
+ // 모든 버전의 isLatest를 false로 업데이트
+ await db
+ .update(projectDocTemplates)
+ .set({ isLatest: false })
+ .where(eq(projectDocTemplates.templateCode, existingTemplate.templateCode));
+
+ // 새 버전 생성
+ const newVersion = existingTemplate.version + 1;
+ const variables = data.variables || existingTemplate.variables;
+
+ const [newTemplate] = await db
+ .insert(projectDocTemplates)
+ .values({
+ ...existingTemplate,
+ id: undefined, // 새 ID 자동 생성
+ version: newVersion,
+ isLatest: true,
+ parentTemplateId: templateId,
+ filePath: data.filePath,
+ fileName: data.fileName,
+ fileSize: data.fileSize,
+ mimeType: data.mimeType,
+ variables,
+ requiredVariables: variables
+ .filter((v: DocTemplateVariable) => v.required)
+ .map((v: DocTemplateVariable) => v.name),
+ createdBy:Number(session.user.id),
+ creaetedByName:session.user.name,
+ updatedBy:Number(session.user.id),
+ updatedByName:session.user.name,
+ createdAt: new Date(),
+ updatedAt: new Date(),
+ })
+ .returning();
+
+ revalidateTag("project-doc-templates");
+ revalidatePath("/project-doc-templates");
+
+ return { success: true, data: newTemplate };
+ } catch (error) {
+ console.error("Failed to create template version:", error);
+ return { success: false, error: "새 버전 생성에 실패했습니다." };
+ }
+}
+
+// 템플릿 삭제 (soft delete)
+export async function deleteProjectDocTemplate(templateId: number) {
+ try {
+ await db
+ .update(projectDocTemplates)
+ .set({
+ deletedAt: new Date(),
+ status: "ARCHIVED"
+ })
+ .where(eq(projectDocTemplates.id, templateId));
+
+ revalidateTag("project-doc-templates");
+ revalidatePath("/project-doc-templates");
+
+ return { success: true };
+ } catch (error) {
+ console.error("Failed to delete template:", error);
+ return { success: false, error: "템플릿 삭제에 실패했습니다." };
+ }
+}
+
+// 템플릿 파일 저장
+export async function tlsaveTemplateFile(
+ templateId: number,
+ formData: FormData
+) {
+ try {
+ const file = formData.get("file") as File;
+ if (!file) {
+ throw new Error("파일이 없습니다.");
+ }
+
+ // 파일 저장 로직 (실제 구현 필요)
+ const fileName = file.name;
+ const filePath = `/uploads/templates/${templateId}/${fileName}`;
+
+ // 템플릿 파일 경로 업데이트
+ await db
+ .update(projectDocTemplates)
+ .set({
+ filePath,
+ fileName,
+ updatedAt: new Date(),
+ })
+ .where(eq(projectDocTemplates.id, templateId));
+
+ revalidateTag("project-doc-templates");
+
+ return { success: true, filePath };
+ } catch (error) {
+ console.error("Failed to save template file:", error);
+ return { success: false, error: "파일 저장에 실패했습니다." };
+ }
+}
+
+// 사용 가능한 프로젝트 목록 조회
+export async function getAvailableProjects() {
+ try {
+ const projectList = await db
+ .select()
+ .from(projects)
+ // .where(eq(projects.status, "ACTIVE"))
+ .orderBy(projects.code);
+
+ return projectList;
+ } catch (error) {
+ console.error("Failed to fetch projects:", error);
+ return [];
+ }
+}
+
+// 템플릿 사용 기록 생성
+export async function recordTemplateUsage(
+ templateId: number,
+ data: {
+ generatedDocumentId: string;
+ generatedFilePath: string;
+ generatedFileName: string;
+ usedVariables: Record<string, any>;
+ usedInProjectId?: number;
+ usedInProjectCode?: string;
+ usedBy: string;
+ metadata?: any;
+ }
+) {
+ try {
+ const [usage] = await db
+ .insert(projectDocTemplateUsage)
+ .values({
+ templateId,
+ ...data,
+ })
+ .returning();
+
+ return { success: true, data: usage };
+ } catch (error) {
+ console.error("Failed to record template usage:", error);
+ return { success: false, error: "사용 기록 생성에 실패했습니다." };
+ }
+} \ No newline at end of file
diff --git a/lib/project-doc-templates/table/add-project-doc-template-dialog.tsx b/lib/project-doc-templates/table/add-project-doc-template-dialog.tsx
new file mode 100644
index 00000000..fb36aebd
--- /dev/null
+++ b/lib/project-doc-templates/table/add-project-doc-template-dialog.tsx
@@ -0,0 +1,642 @@
+"use client";
+
+import * as React from "react";
+import { zodResolver } from "@hookform/resolvers/zod";
+import { useForm } from "react-hook-form";
+import * as z from "zod";
+import { toast } from "sonner";
+import { v4 as uuidv4 } from "uuid";
+import {
+ Dialog,
+ DialogTrigger,
+ DialogContent,
+ DialogHeader,
+ DialogTitle,
+ DialogDescription,
+ DialogFooter
+} from "@/components/ui/dialog";
+import {
+ Form,
+ FormControl,
+ FormField,
+ FormItem,
+ FormLabel,
+ FormMessage,
+ FormDescription,
+} from "@/components/ui/form";
+import { Button } from "@/components/ui/button";
+import { Input } from "@/components/ui/input";
+import { Textarea } from "@/components/ui/textarea";
+import { Switch } from "@/components/ui/switch";
+import {
+ Dropzone,
+ DropzoneZone,
+ DropzoneUploadIcon,
+ DropzoneTitle,
+ DropzoneDescription,
+ DropzoneInput
+} from "@/components/ui/dropzone";
+import { Progress } from "@/components/ui/progress";
+import { Card, CardContent, CardDescription, CardHeader, CardTitle } from "@/components/ui/card";
+import { Badge } from "@/components/ui/badge";
+import { Plus, X, FileText, AlertCircle } from "lucide-react";
+import { useRouter } from "next/navigation";
+import { createProjectDocTemplate } from "@/lib/project-doc-templates/service";
+import { ProjectSelector } from "@/components/ProjectSelector";
+import type { TemplateVariable } from "@/db/schema/project-doc-templates";
+import type { Project } from "@/lib/rfqs/service";
+
+// 기본 변수들 (읽기 전용)
+const DEFAULT_VARIABLES_DISPLAY: TemplateVariable[] = [
+ { name: "document_number", displayName: "문서번호", type: "text", required: true, description: "문서 고유 번호" },
+ { name: "project_code", displayName: "프로젝트 코드", type: "text", required: true, description: "프로젝트 식별 코드" },
+ { name: "project_name", displayName: "프로젝트명", type: "text", required: true, description: "프로젝트 이름" },
+];
+
+const templateFormSchema = z.object({
+ templateName: z.string().min(1, "템플릿 이름을 입력해주세요."),
+ templateCode: z.string().optional(),
+ description: z.string().optional(),
+ projectId: z.number({
+ required_error: "프로젝트를 선택해주세요.",
+ }),
+ customVariables: z.array(z.object({
+ name: z.string().min(1, "변수명을 입력해주세요."),
+ displayName: z.string().min(1, "표시명을 입력해주세요."),
+ type: z.enum(["text", "number", "date", "select"]),
+ required: z.boolean(),
+ defaultValue: z.string().optional(),
+ description: z.string().optional(),
+ })).default([]),
+ file: z.instanceof(File, {
+ message: "파일을 업로드해주세요.",
+ }),
+})
+.refine((data) => {
+ if (data.file && data.file.size > 100 * 1024 * 1024) return false;
+ return true;
+}, {
+ message: "파일 크기는 100MB 이하여야 합니다.",
+ path: ["file"],
+})
+.refine((data) => {
+ if (data.file) {
+ const validTypes = [
+ 'application/msword',
+ 'application/vnd.openxmlformats-officedocument.wordprocessingml.document'
+ ];
+ return validTypes.includes(data.file.type);
+ }
+ return true;
+}, {
+ message: "워드 파일(.doc, .docx)만 업로드 가능합니다.",
+ path: ["file"],
+});
+
+type TemplateFormValues = z.infer<typeof templateFormSchema>;
+
+export function AddProjectDocTemplateDialog() {
+ const [open, setOpen] = React.useState(false);
+ const [isLoading, setIsLoading] = React.useState(false);
+ const [selectedFile, setSelectedFile] = React.useState<File | null>(null);
+ const [uploadProgress, setUploadProgress] = React.useState(0);
+ const [showProgress, setShowProgress] = React.useState(false);
+ const [selectedProject, setSelectedProject] = React.useState<Project | null>(null);
+ const router = useRouter();
+
+ const form = useForm<TemplateFormValues>({
+ resolver: zodResolver(templateFormSchema),
+ defaultValues: {
+ templateName: "",
+ templateCode: "",
+ description: "",
+ customVariables: [],
+ },
+ mode: "onChange",
+ });
+
+ // 프로젝트 선택 시 처리
+ const handleProjectSelect = (project: Project) => {
+ setSelectedProject(project);
+ form.setValue("projectId", project.id);
+ // 템플릿 이름 자동 설정 (원하면)
+ if (!form.getValues("templateName")) {
+ form.setValue("templateName", `${project.projectCode} 벤더문서 커버 템플릿`);
+ }
+ };
+
+ const handleFileChange = (files: File[]) => {
+ if (files.length > 0) {
+ const file = files[0];
+ setSelectedFile(file);
+ form.setValue("file", file);
+ }
+ };
+
+ // 사용자 정의 변수 추가
+ const addCustomVariable = () => {
+ const currentVars = form.getValues("customVariables");
+ form.setValue("customVariables", [
+ ...currentVars,
+ {
+ name: "",
+ displayName: "",
+ type: "text",
+ required: false,
+ defaultValue: "",
+ description: "",
+ },
+ ]);
+ };
+
+ // 사용자 정의 변수 제거
+ const removeCustomVariable = (index: number) => {
+ const currentVars = form.getValues("customVariables");
+ form.setValue("customVariables", currentVars.filter((_, i) => i !== index));
+ };
+
+ // 청크 업로드
+ const CHUNK_SIZE = 1 * 1024 * 1024;
+
+ const uploadFileInChunks = async (file: File, fileId: string) => {
+ const totalChunks = Math.ceil(file.size / CHUNK_SIZE);
+ setShowProgress(true);
+ setUploadProgress(0);
+
+ for (let chunkIndex = 0; chunkIndex < totalChunks; chunkIndex++) {
+ const start = chunkIndex * CHUNK_SIZE;
+ const end = Math.min(start + CHUNK_SIZE, file.size);
+ const chunk = file.slice(start, end);
+
+ const formData = new FormData();
+ formData.append('chunk', chunk);
+ formData.append('filename', file.name);
+ formData.append('chunkIndex', chunkIndex.toString());
+ formData.append('totalChunks', totalChunks.toString());
+ formData.append('fileId', fileId);
+
+ const response = await fetch('/api/upload/project-doc-template/chunk', {
+ method: 'POST',
+ body: formData,
+ });
+
+ if (!response.ok) {
+ throw new Error(`청크 업로드 실패: ${response.statusText}`);
+ }
+
+ const progress = Math.round(((chunkIndex + 1) / totalChunks) * 100);
+ setUploadProgress(progress);
+
+ const result = await response.json();
+ if (chunkIndex === totalChunks - 1) {
+ return result;
+ }
+ }
+ };
+
+ async function onSubmit(formData: TemplateFormValues) {
+ setIsLoading(true);
+ try {
+ // 파일 업로드
+ const fileId = uuidv4();
+ const uploadResult = await uploadFileInChunks(formData.file, fileId);
+
+ if (!uploadResult?.success) {
+ throw new Error("파일 업로드에 실패했습니다.");
+ }
+
+ // 템플릿 생성 (고정값들 적용)
+ const result = await createProjectDocTemplate({
+ templateName: formData.templateName,
+ templateCode: formData.templateCode,
+ description: formData.description,
+ projectId: formData.projectId,
+ templateType: "PROJECT", // 고정
+ documentType: "VENDOR_DOC_COVER", // 벤더문서 커버로 고정
+ filePath: uploadResult.filePath,
+ fileName: uploadResult.fileName,
+ fileSize: formData.file.size,
+ mimeType: formData.file.type,
+ variables: formData.customVariables,
+ isPublic: false, // 고정
+ requiresApproval: false, // 고정
+ });
+
+ if (!result.success) {
+ throw new Error(result.error || "템플릿 생성에 실패했습니다.");
+ }
+
+ toast.success("템플릿이 성공적으로 추가되었습니다.");
+ form.reset();
+ setSelectedFile(null);
+ setSelectedProject(null);
+ setOpen(false);
+ setShowProgress(false);
+ router.refresh();
+ } catch (error) {
+ console.error("Submit error:", error);
+ toast.error(error instanceof Error ? error.message : "템플릿 추가 중 오류가 발생했습니다.");
+ } finally {
+ setIsLoading(false);
+ }
+ }
+
+ const customVariables = form.watch("customVariables");
+
+ // 다이얼로그 닫을 때 폼 초기화
+ React.useEffect(() => {
+ if (!open) {
+ form.reset();
+ setSelectedFile(null);
+ setSelectedProject(null);
+ setShowProgress(false);
+ setUploadProgress(0);
+ }
+ }, [open, form]);
+
+ return (
+ <Dialog open={open} onOpenChange={setOpen}>
+ <DialogTrigger asChild>
+ <Button variant="default" size="sm">
+ <Plus className="mr-2 h-4 w-4" />
+ 템플릿 추가
+ </Button>
+ </DialogTrigger>
+ <DialogContent className="max-w-4xl h-[90vh] flex flex-col p-0">
+ {/* 헤더 - 고정 */}
+ <DialogHeader className="px-6 py-4 border-b">
+ <DialogTitle>프로젝트 벤더문서 커버 템플릿 추가</DialogTitle>
+ <DialogDescription>
+ 프로젝트별 벤더문서 커버 템플릿을 등록합니다. 기본 변수(document_number, project_code, project_name)는 자동으로 포함됩니다.
+ </DialogDescription>
+ </DialogHeader>
+
+ {/* 본문 - 스크롤 영역 */}
+ <div className="flex-1 overflow-y-auto px-6 py-4">
+ <Form {...form}>
+ <form onSubmit={form.handleSubmit(onSubmit)} className="space-y-6">
+ {/* 프로젝트 선택 및 기본 정보 */}
+ <Card>
+ <CardHeader>
+ <CardTitle className="text-lg">기본 정보</CardTitle>
+ </CardHeader>
+ <CardContent className="space-y-4">
+ {/* 프로젝트 선택 - 필수 */}
+ <FormField
+ control={form.control}
+ name="projectId"
+ render={() => (
+ <FormItem>
+ <FormLabel>
+ 프로젝트 <span className="text-red-500">*</span>
+ </FormLabel>
+ <FormControl>
+ <ProjectSelector
+ selectedProjectId={selectedProject?.id}
+ onProjectSelect={handleProjectSelect}
+ placeholder="프로젝트를 선택하세요..."
+ filterType="plant" // 또는 필요한 타입
+ />
+ </FormControl>
+ <FormDescription>
+ 템플릿을 적용할 프로젝트를 선택하세요.
+ </FormDescription>
+ <FormMessage />
+ </FormItem>
+ )}
+ />
+
+ {selectedProject && (
+ <div className="p-3 bg-muted rounded-lg">
+ <p className="text-sm">
+ <span className="font-medium">선택된 프로젝트:</span> {selectedProject.projectCode} - {selectedProject.projectName}
+ </p>
+ </div>
+ )}
+
+ <div className="grid grid-cols-2 gap-4">
+ <FormField
+ control={form.control}
+ name="templateName"
+ render={({ field }) => (
+ <FormItem>
+ <FormLabel>
+ 템플릿 이름 <span className="text-red-500">*</span>
+ </FormLabel>
+ <FormControl>
+ <Input placeholder="예: S123 벤더문서 커버 템플릿" {...field} />
+ </FormControl>
+ <FormMessage />
+ </FormItem>
+ )}
+ />
+
+ <FormField
+ control={form.control}
+ name="templateCode"
+ render={({ field }) => (
+ <FormItem>
+ <FormLabel>템플릿 코드</FormLabel>
+ <FormControl>
+ <Input placeholder="자동 생성됨 (선택사항)" {...field} />
+ </FormControl>
+ <FormDescription>비워두면 자동으로 생성됩니다.</FormDescription>
+ <FormMessage />
+ </FormItem>
+ )}
+ />
+ </div>
+
+ <FormField
+ control={form.control}
+ name="description"
+ render={({ field }) => (
+ <FormItem>
+ <FormLabel>설명</FormLabel>
+ <FormControl>
+ <Textarea
+ placeholder="템플릿에 대한 설명을 입력하세요."
+ className="min-h-[80px]"
+ {...field}
+ />
+ </FormControl>
+ <FormMessage />
+ </FormItem>
+ )}
+ />
+
+ {/* 고정 정보 표시 */}
+ <div className="flex gap-2">
+ <Badge variant="outline">템플릿 타입: 프로젝트</Badge>
+ <Badge variant="outline">문서 타입: 벤더문서 커버</Badge>
+ </div>
+ </CardContent>
+ </Card>
+
+ {/* 변수 설정 */}
+ <Card>
+ <CardHeader>
+ <CardTitle className="text-lg">템플릿 변수</CardTitle>
+ <CardDescription>
+ 문서에서 사용할 변수를 정의합니다. 템플릿에서 {'{{변수명}}'} 형식으로 사용됩니다.
+ </CardDescription>
+ </CardHeader>
+ <CardContent className="space-y-4">
+ {/* 기본 변수 표시 */}
+ <div>
+ <div className="flex items-center mb-2">
+ <Badge variant="outline" className="text-xs">
+ 기본 변수 (자동 포함)
+ </Badge>
+ </div>
+ <div className="space-y-2">
+ {DEFAULT_VARIABLES_DISPLAY.map((variable) => (
+ <div key={variable.name} className="flex items-center gap-2 p-2 bg-muted/50 rounded">
+ <Badge variant="secondary">
+ {`{{${variable.name}}}`}
+ </Badge>
+ <span className="text-sm">{variable.displayName}</span>
+ <span className="text-xs text-muted-foreground">({variable.description})</span>
+ {variable.required && (
+ <Badge variant="destructive" className="text-xs">필수</Badge>
+ )}
+ </div>
+ ))}
+ </div>
+ </div>
+
+ {/* 사용자 정의 변수 */}
+ <div>
+ <div className="flex items-center justify-between mb-2">
+ <Badge variant="outline" className="text-xs">
+ 사용자 정의 변수
+ </Badge>
+ <Button
+ type="button"
+ variant="outline"
+ size="sm"
+ onClick={addCustomVariable}
+ >
+ <Plus className="mr-2 h-4 w-4" />
+ 변수 추가
+ </Button>
+ </div>
+
+ {customVariables.length > 0 ? (
+ <div className="space-y-3">
+ {customVariables.map((_, index) => (
+ <div key={index} className="p-3 border rounded-lg space-y-3">
+ <div className="flex items-center justify-between">
+ <span className="text-sm font-medium">변수 #{index + 1}</span>
+ <Button
+ type="button"
+ variant="ghost"
+ size="sm"
+ onClick={() => removeCustomVariable(index)}
+ >
+ <X className="h-4 w-4" />
+ </Button>
+ </div>
+
+ <div className="grid grid-cols-3 gap-3">
+ <FormField
+ control={form.control}
+ name={`customVariables.${index}.name`}
+ render={({ field }) => (
+ <FormItem>
+ <FormLabel>변수명</FormLabel>
+ <FormControl>
+ <Input placeholder="예: vendor_name" {...field} />
+ </FormControl>
+ <FormMessage />
+ </FormItem>
+ )}
+ />
+
+ <FormField
+ control={form.control}
+ name={`customVariables.${index}.displayName`}
+ render={({ field }) => (
+ <FormItem>
+ <FormLabel>표시명</FormLabel>
+ <FormControl>
+ <Input placeholder="예: 벤더명" {...field} />
+ </FormControl>
+ <FormMessage />
+ </FormItem>
+ )}
+ />
+
+ <FormField
+ control={form.control}
+ name={`customVariables.${index}.type`}
+ render={({ field }) => (
+ <FormItem>
+ <FormLabel>타입</FormLabel>
+ <FormControl>
+ <select
+ className="w-full rounded-md border border-input bg-background px-3 py-2 text-sm ring-offset-background"
+ {...field}
+ >
+ <option value="text">텍스트</option>
+ <option value="number">숫자</option>
+ <option value="date">날짜</option>
+ <option value="select">선택</option>
+ </select>
+ </FormControl>
+ <FormMessage />
+ </FormItem>
+ )}
+ />
+ </div>
+
+ <div className="grid grid-cols-2 gap-3">
+ <FormField
+ control={form.control}
+ name={`customVariables.${index}.defaultValue`}
+ render={({ field }) => (
+ <FormItem>
+ <FormLabel>기본값</FormLabel>
+ <FormControl>
+ <Input placeholder="선택사항" {...field} />
+ </FormControl>
+ <FormMessage />
+ </FormItem>
+ )}
+ />
+
+ <FormField
+ control={form.control}
+ name={`customVariables.${index}.required`}
+ render={({ field }) => (
+ <FormItem className="flex flex-row items-center justify-between rounded-lg border p-2">
+ <FormLabel className="text-sm">필수</FormLabel>
+ <FormControl>
+ <Switch
+ checked={field.value}
+ onCheckedChange={field.onChange}
+ />
+ </FormControl>
+ </FormItem>
+ )}
+ />
+ </div>
+
+ <FormField
+ control={form.control}
+ name={`customVariables.${index}.description`}
+ render={({ field }) => (
+ <FormItem>
+ <FormLabel>설명</FormLabel>
+ <FormControl>
+ <Input placeholder="변수 설명 (선택사항)" {...field} />
+ </FormControl>
+ <FormMessage />
+ </FormItem>
+ )}
+ />
+ </div>
+ ))}
+ </div>
+ ) : (
+ <div className="text-center py-4 text-sm text-muted-foreground">
+ 추가된 사용자 정의 변수가 없습니다.
+ </div>
+ )}
+ </div>
+ </CardContent>
+ </Card>
+
+ {/* 파일 업로드 */}
+ <Card>
+ <CardHeader>
+ <CardTitle className="text-lg">템플릿 파일</CardTitle>
+ <CardDescription>
+ 워드 파일(.doc, .docx)을 업로드하세요. 파일 내 {'{{변수명}}'} 형식으로 변수를 사용할 수 있습니다.
+ </CardDescription>
+ </CardHeader>
+ <CardContent>
+ <FormField
+ control={form.control}
+ name="file"
+ render={() => (
+ <FormItem>
+ <FormControl>
+ <Dropzone
+ onDrop={handleFileChange}
+ accept={{
+ 'application/msword': ['.doc'],
+ 'application/vnd.openxmlformats-officedocument.wordprocessingml.document': ['.docx']
+ }}
+ >
+ <DropzoneZone>
+ <DropzoneUploadIcon className="h-10 w-10 text-muted-foreground" />
+ <DropzoneTitle>
+ {selectedFile ? selectedFile.name : "워드 파일을 여기에 드래그하세요"}
+ </DropzoneTitle>
+ <DropzoneDescription>
+ {selectedFile
+ ? `파일 크기: ${(selectedFile.size / (1024 * 1024)).toFixed(2)} MB`
+ : "또는 클릭하여 파일을 선택하세요 (최대 100MB)"}
+ </DropzoneDescription>
+ <DropzoneInput />
+ </DropzoneZone>
+ </Dropzone>
+ </FormControl>
+ <FormMessage />
+ </FormItem>
+ )}
+ />
+
+ {showProgress && (
+ <div className="space-y-2 mt-4">
+ <div className="flex justify-between text-sm">
+ <span>업로드 진행률</span>
+ <span>{uploadProgress}%</span>
+ </div>
+ <Progress value={uploadProgress} />
+ </div>
+ )}
+
+ {/* 변수 사용 안내 */}
+ <div className="mt-4 p-3 bg-blue-50 rounded-lg">
+ <div className="flex items-start">
+ <AlertCircle className="h-4 w-4 text-blue-600 mt-0.5 mr-2 flex-shrink-0" />
+ <div className="text-sm text-blue-900">
+ <p className="font-medium mb-1">변수 사용 방법</p>
+ <ul className="list-disc list-inside space-y-1 text-xs">
+ <li>워드 문서에서 {'{{변수명}}'} 형식으로 변수를 삽입하세요.</li>
+ <li>예시: {'{{document_number}}'}, {'{{project_code}}'}, {'{{project_name}}'}</li>
+ <li>문서 생성 시 변수가 실제 값으로 치환됩니다.</li>
+ </ul>
+ </div>
+ </div>
+ </div>
+ </CardContent>
+ </Card>
+ </form>
+ </Form>
+ </div>
+
+ {/* 푸터 - 고정 */}
+ <DialogFooter className="px-6 py-4 border-t">
+ <Button
+ type="button"
+ variant="outline"
+ onClick={() => setOpen(false)}
+ disabled={isLoading}
+ >
+ 취소
+ </Button>
+ <Button
+ type="button"
+ onClick={form.handleSubmit(onSubmit)}
+ disabled={isLoading || !form.watch("file") || !form.watch("projectId")}
+ >
+ {isLoading ? "처리 중..." : "템플릿 추가"}
+ </Button>
+ </DialogFooter>
+ </DialogContent>
+ </Dialog>
+ );
+} \ No newline at end of file
diff --git a/lib/project-doc-templates/table/doc-template-table.tsx b/lib/project-doc-templates/table/doc-template-table.tsx
new file mode 100644
index 00000000..7d8210d8
--- /dev/null
+++ b/lib/project-doc-templates/table/doc-template-table.tsx
@@ -0,0 +1,716 @@
+"use client";
+
+import * as React from "react";
+import { useRouter } from "next/navigation";
+import { type ColumnDef } from "@tanstack/react-table";
+import {
+ Download,
+ Ellipsis,
+ Paperclip,
+ Eye,
+ Copy,
+ GitBranch,
+ Globe,
+ Lock,
+ FolderOpen,
+ FileText
+} from "lucide-react";
+import { toast } from "sonner";
+import { formatDateTime } from "@/lib/utils";
+import { Badge } from "@/components/ui/badge";
+import { Button } from "@/components/ui/button";
+import { Checkbox } from "@/components/ui/checkbox";
+import {
+ DropdownMenu,
+ DropdownMenuContent,
+ DropdownMenuItem,
+ DropdownMenuSeparator,
+ DropdownMenuTrigger,
+} from "@/components/ui/dropdown-menu";
+import { DataTable } from "@/components/data-table/data-table";
+import { useDataTable } from "@/hooks/use-data-table";
+import { DataTableAdvancedToolbar } from "@/components/data-table/data-table-advanced-toolbar";
+import { DataTableColumnHeaderSimple } from "@/components/data-table/data-table-column-simple-header";
+import type {
+ DataTableAdvancedFilterField,
+ DataTableRowAction,
+} from "@/types/table";
+import {
+ getProjectDocTemplates,
+ deleteProjectDocTemplate,
+ createTemplateVersion
+} from "@/lib/project-doc-templates/service";
+import type { ProjectDocTemplate } from "@/db/schema/project-doc-templates";
+import { quickDownload } from "@/lib/file-download";
+import { AddProjectDocTemplateDialog } from "./add-project-doc-template-dialog";
+import { Dialog, DialogContent, DialogDescription, DialogFooter, DialogHeader, DialogTitle } from "@/components/ui/dialog";
+import { Label } from "@/components/ui/label";
+import { Input } from "@/components/ui/input";
+import { Progress } from "@/components/ui/progress";
+import { AlertCircle, RefreshCw } from "lucide-react";
+import { TemplateDetailDialog } from "./template-detail-dialog";
+import { TemplateEditSheet } from "./template-edit-sheet";
+
+// 문서 타입 라벨 매핑
+const DOCUMENT_TYPE_LABELS: Record<string, string> = {
+ CONTRACT: "계약서",
+ SPECIFICATION: "사양서",
+ REPORT: "보고서",
+ DRAWING: "도면",
+ MANUAL: "매뉴얼",
+ PROCEDURE: "절차서",
+ STANDARD: "표준문서",
+ OTHER: "기타",
+};
+
+// 파일 다운로드 함수
+const handleFileDownload = async (filePath: string, fileName: string) => {
+ try {
+ await quickDownload(filePath, fileName);
+ } catch (error) {
+ console.error("파일 다운로드 오류:", error);
+ toast.error("파일 다운로드 중 오류가 발생했습니다.");
+ }
+};
+
+// 컬럼 정의 함수 - 핸들러들을 props로 받음
+export function getColumns({
+ onViewDetail,
+ onEdit,
+ onDelete,
+ onCreateVersion,
+}: {
+ onViewDetail: (template: ProjectDocTemplate) => void;
+ onEdit: (template: ProjectDocTemplate) => void;
+ onDelete: (template: ProjectDocTemplate) => void;
+ onCreateVersion: (template: ProjectDocTemplate) => void;
+}): ColumnDef<ProjectDocTemplate>[] {
+
+ // 체크박스 컬럼
+ const selectColumn: ColumnDef<ProjectDocTemplate> = {
+ id: "select",
+ header: ({ table }) => (
+ <Checkbox
+ checked={
+ table.getIsAllPageRowsSelected() ||
+ (table.getIsSomePageRowsSelected() && "indeterminate")
+ }
+ onCheckedChange={(value) => table.toggleAllPageRowsSelected(!!value)}
+ aria-label="Select all"
+ className="translate-y-0.5"
+ />
+ ),
+ cell: ({ row }) => (
+ <Checkbox
+ checked={row.getIsSelected()}
+ onCheckedChange={(value) => row.toggleSelected(!!value)}
+ aria-label="Select row"
+ className="translate-y-0.5"
+ />
+ ),
+ maxSize: 30,
+ enableSorting: false,
+ enableHiding: false,
+ };
+
+ // 다운로드 컬럼
+ const downloadColumn: ColumnDef<ProjectDocTemplate> = {
+ id: "download",
+ header: "",
+ cell: ({ row }) => {
+ const template = row.original;
+ return (
+ <Button
+ variant="ghost"
+ size="icon"
+ onClick={() => handleFileDownload(template.filePath, template.fileName)}
+ title={`${template.fileName} 다운로드`}
+ className="hover:bg-muted"
+ >
+ <Paperclip className="h-4 w-4" />
+ <span className="sr-only">다운로드</span>
+ </Button>
+ );
+ },
+ maxSize: 30,
+ enableSorting: false,
+ };
+
+ // 액션 컬럼
+ const actionsColumn: ColumnDef<ProjectDocTemplate> = {
+ id: "actions",
+ enableHiding: false,
+ cell: ({ row }) => {
+ const template = row.original;
+
+ return (
+ <DropdownMenu>
+ <DropdownMenuTrigger asChild>
+ <Button
+ aria-label="Open menu"
+ variant="ghost"
+ className="flex size-8 p-0 data-[state=open]:bg-muted"
+ >
+ <Ellipsis className="size-4" aria-hidden="true" />
+ </Button>
+ </DropdownMenuTrigger>
+ <DropdownMenuContent align="end" className="w-44">
+ <DropdownMenuItem onSelect={() => onViewDetail(template)}>
+ <Eye className="mr-2 h-4 w-4" />
+ 상세보기
+ </DropdownMenuItem>
+
+ <DropdownMenuItem onSelect={() => onEdit(template)}>
+ 수정하기
+ </DropdownMenuItem>
+
+ <DropdownMenuSeparator />
+
+ <DropdownMenuItem onSelect={() => onCreateVersion(template)}>
+ <GitBranch className="mr-2 h-4 w-4" />
+ 새 버전 생성
+ </DropdownMenuItem>
+
+ <DropdownMenuSeparator />
+
+ <DropdownMenuItem
+ onSelect={() => onDelete(template)}
+ className="text-destructive"
+ >
+ 삭제하기
+ </DropdownMenuItem>
+ </DropdownMenuContent>
+ </DropdownMenu>
+ );
+ },
+ maxSize: 30,
+ };
+
+ // 데이터 컬럼들
+ const dataColumns: ColumnDef<ProjectDocTemplate>[] = [
+ {
+ accessorKey: "status",
+ header: ({ column }) => <DataTableColumnHeaderSimple column={column} title="상태" />,
+ cell: ({ row }) => {
+ const status = row.getValue("status") as string;
+ const statusMap: Record<string, { label: string; variant: "default" | "secondary" | "destructive" | "outline" }> = {
+ ACTIVE: { label: "활성", variant: "default" },
+ INACTIVE: { label: "비활성", variant: "secondary" },
+ DRAFT: { label: "초안", variant: "outline" },
+ ARCHIVED: { label: "보관", variant: "secondary" },
+ };
+ const statusInfo = statusMap[status] || { label: status, variant: "outline" };
+ return (
+ <Badge variant={statusInfo.variant}>
+ {statusInfo.label}
+ </Badge>
+ );
+ },
+ size: 80,
+ enableResizing: true,
+ },
+ {
+ accessorKey: "templateName",
+ header: ({ column }) => <DataTableColumnHeaderSimple column={column} title="템플릿명" />,
+ cell: ({ row }) => {
+ const template = row.original;
+
+ return (
+ <div className="flex flex-col min-w-0">
+ <button
+ onClick={() => onViewDetail(template)}
+ className="truncate text-left hover:text-blue-600 hover:underline cursor-pointer transition-colors"
+ title="클릭하여 상세보기"
+ >
+ {template.templateName}
+ </button>
+ {template.templateCode && (
+ <span className="text-xs text-muted-foreground">{template.templateCode}</span>
+ )}
+ </div>
+ );
+ },
+ size: 250,
+ enableResizing: true,
+ },
+ {
+ accessorKey: "projectCode",
+ header: ({ column }) => <DataTableColumnHeaderSimple column={column} title="프로젝트" />,
+ cell: ({ row }) => {
+ const template = row.original;
+ if (!template.projectCode) return <span className="text-muted-foreground">-</span>;
+
+ return (
+ <div className="flex flex-col min-w-0">
+ <span className="font-medium truncate">{template.projectCode}</span>
+ {template.projectName && (
+ <span className="text-xs text-muted-foreground truncate">{template.projectName}</span>
+ )}
+ </div>
+ );
+ },
+ size: 150,
+ enableResizing: true,
+ },
+ {
+ accessorKey: "version",
+ header: ({ column }) => <DataTableColumnHeaderSimple column={column} title="버전" />,
+ cell: ({ row }) => {
+ const template = row.original;
+ return (
+ <div className="flex items-center gap-2">
+ <Badge variant="outline" className="text-xs">
+ v{template.version}
+ </Badge>
+ {template.isLatest && (
+ <Badge variant="secondary" className="text-xs">
+ 최신
+ </Badge>
+ )}
+ </div>
+ );
+ },
+ size: 100,
+ enableResizing: true,
+ },
+ {
+ id: "variables",
+ header: ({ column }) => <DataTableColumnHeaderSimple column={column} title="변수" />,
+ cell: ({ row }) => {
+ const template = row.original;
+ const variableCount = template.variables?.length || 0;
+ const requiredCount = template.requiredVariables?.length || 0;
+
+ return (
+ <div className="text-xs">
+ <span>{variableCount}개</span>
+ {requiredCount > 0 && (
+ <span className="text-muted-foreground ml-1">
+ (필수: {requiredCount})
+ </span>
+ )}
+ </div>
+ );
+ },
+ size: 100,
+ enableResizing: true,
+ },
+ {
+ accessorKey: "fileName",
+ header: ({ column }) => <DataTableColumnHeaderSimple column={column} title="파일명" />,
+ cell: ({ row }) => {
+ const fileName = row.getValue("fileName") as string;
+ const template = row.original;
+ const fileSizeMB = template.fileSize ? (template.fileSize / (1024 * 1024)).toFixed(2) : null;
+
+ return (
+ <div className="min-w-0 max-w-full">
+ <span className="block truncate text-sm" title={fileName}>
+ {fileName}
+ </span>
+ {fileSizeMB && (
+ <span className="text-xs text-muted-foreground">{fileSizeMB} MB</span>
+ )}
+ </div>
+ );
+ },
+ size: 200,
+ enableResizing: true,
+ },
+ {
+ accessorKey: "createdAt",
+ header: ({ column }) => <DataTableColumnHeaderSimple column={column} title="생성일" />,
+ cell: ({ row }) => {
+ const date = row.getValue("createdAt") as Date;
+ const template = row.original;
+ return (
+ <div className="text-xs">
+ <div>{date ? formatDateTime(date, "KR") : "-"}</div>
+ {template.createdByName && (
+ <span className="text-muted-foreground">{template.createdByName}</span>
+ )}
+ </div>
+ );
+ },
+ size: 140,
+ enableResizing: true,
+ },
+ {
+ accessorKey: "updatedAt",
+ header: ({ column }) => <DataTableColumnHeaderSimple column={column} title="수정일" />,
+ cell: ({ row }) => {
+ const date = row.getValue("updatedAt") as Date;
+ const template = row.original;
+ return (
+ <div className="text-xs">
+ <div>{date ? formatDateTime(date, "KR") : "-"}</div>
+ {template.updatedByName && (
+ <span className="text-muted-foreground">{template.updatedByName}</span>
+ )}
+ </div>
+ );
+ },
+ size: 140,
+ enableResizing: true,
+ },
+ ];
+
+ return [selectColumn, downloadColumn, ...dataColumns, actionsColumn];
+}
+
+// 메인 테이블 컴포넌트
+interface ProjectDocTemplateTableProps {
+ promises: Promise<
+ [
+ Awaited<ReturnType<typeof getProjectDocTemplates>>,
+ ]
+>
+}
+
+export function ProjectDocTemplateTable({
+ promises
+}: ProjectDocTemplateTableProps) {
+ const router = useRouter();
+ const [selectedTemplate, setSelectedTemplate] = React.useState<ProjectDocTemplate | null>(null);
+ const [detailOpen, setDetailOpen] = React.useState(false);
+ const [editOpen, setEditOpen] = React.useState(false);
+ const [versionTemplate, setVersionTemplate] = React.useState<ProjectDocTemplate | null>(null);
+ const [versionOpen, setVersionOpen] = React.useState(false);
+
+ const [{ data, pageCount }] = React.use(promises);
+
+ // 액션 핸들러들
+ const handleViewDetail = (template: ProjectDocTemplate) => {
+ setSelectedTemplate(template);
+ setDetailOpen(true);
+ };
+
+ const handleEdit = (template: ProjectDocTemplate) => {
+ setSelectedTemplate(template);
+ setEditOpen(true);
+ };
+
+ const handleDelete = async (template: ProjectDocTemplate) => {
+ if (confirm("정말로 이 템플릿을 삭제하시겠습니까?")) {
+ const result = await deleteProjectDocTemplate(template.id);
+ if (result.success) {
+ toast.success("템플릿이 삭제되었습니다.");
+ router.refresh();
+ } else {
+ toast.error(result.error || "삭제에 실패했습니다.");
+ }
+ }
+ };
+
+ const handleCreateVersion = (template: ProjectDocTemplate) => {
+ setVersionTemplate(template);
+ setVersionOpen(true);
+ };
+
+ // 컬럼 설정 - 핸들러들을 전달
+ const columns = React.useMemo(
+ () => getColumns({
+ onViewDetail: handleViewDetail,
+ onEdit: handleEdit,
+ onDelete: handleDelete,
+ onCreateVersion: handleCreateVersion,
+ }),
+ []
+ );
+
+ // 필터 필드 설정
+ const advancedFilterFields: DataTableAdvancedFilterField<ProjectDocTemplate>[] = [
+ { id: "templateName", label: "템플릿명", type: "text" },
+ {
+ id: "status",
+ label: "상태",
+ type: "select",
+ options: [
+ { label: "활성", value: "ACTIVE" },
+ { label: "비활성", value: "INACTIVE" },
+ { label: "초안", value: "DRAFT" },
+ { label: "보관", value: "ARCHIVED" },
+ ],
+ },
+ { id: "projectCode", label: "프로젝트 코드", type: "text" },
+ { id: "createdAt", label: "생성일", type: "date" },
+ { id: "updatedAt", label: "수정일", type: "date" },
+ ];
+
+ const { table } = useDataTable({
+ data,
+ columns,
+ pageCount,
+ filterFields: advancedFilterFields,
+ enablePinning: true,
+ enableAdvancedFilter: true,
+ initialState: {
+ sorting: [{ id: "createdAt", desc: true }],
+ columnPinning: { right: ["actions"] },
+ },
+ getRowId: (originalRow) => String(originalRow.id),
+ shallow: false,
+ clearOnDefault: true,
+ });
+
+ return (
+ <>
+ <DataTable table={table}>
+ <DataTableAdvancedToolbar
+ table={table}
+ filterFields={advancedFilterFields}
+ shallow={false}
+ >
+ <div className="flex items-center gap-2">
+ <AddProjectDocTemplateDialog />
+ {table.getFilteredSelectedRowModel().rows.length > 0 && (
+ <Button
+ variant="outline"
+ size="sm"
+ onClick={() => {
+ const selectedRows = table.getFilteredSelectedRowModel().rows;
+ console.log("Selected templates:", selectedRows.map(r => r.original));
+ toast.info(`${selectedRows.length}개 템플릿 선택됨`);
+ }}
+ >
+ 선택 항목 처리 ({table.getFilteredSelectedRowModel().rows.length})
+ </Button>
+ )}
+ </div>
+ </DataTableAdvancedToolbar>
+ </DataTable>
+
+ {/* 상세보기 다이얼로그 */}
+ {selectedTemplate && (
+ <TemplateDetailDialog
+ template={selectedTemplate}
+ open={detailOpen}
+ onOpenChange={setDetailOpen}
+ />
+ )}
+
+ {/* 수정 Sheet */}
+ {selectedTemplate && (
+ <TemplateEditSheet
+ template={selectedTemplate}
+ open={editOpen}
+ onOpenChange={setEditOpen}
+ onSuccess={() => {
+ router.refresh();
+ }}
+ />
+ )}
+
+ {/* 새 버전 생성 다이얼로그 */}
+ {versionTemplate && (
+ <CreateVersionDialog
+ template={versionTemplate}
+ open={versionOpen}
+ onOpenChange={(open) => {
+ setVersionOpen(open);
+ if (!open) setVersionTemplate(null);
+ }}
+ onSuccess={() => {
+ setVersionOpen(false);
+ setVersionTemplate(null);
+ router.refresh();
+ toast.success("새 버전이 생성되었습니다.");
+ }}
+ />
+ )}
+ </>
+ );
+}
+
+// 새 버전 생성 다이얼로그 컴포넌트
+interface CreateVersionDialogProps {
+ template: ProjectDocTemplate;
+ open: boolean;
+ onOpenChange: (open: boolean) => void;
+ onSuccess: () => void;
+}
+
+
+function CreateVersionDialog({ template, onClose, onSuccess }: CreateVersionDialogProps) {
+ const [isLoading, setIsLoading] = React.usseState(false);
+ const [selectedFile, setSelectedFile] = React.useState<File | null>(null);
+ const [uploadProgress, setUploadProgress] = React.useState(0);
+ const [showProgress, setShowProgress] = React.useState(false);
+
+ // 청크 업로드 함수
+ const CHUNK_SIZE = 1 * 1024 * 1024; // 1MB
+
+ const uploadFileInChunks = async (file: File, fileId: string) => {
+ const totalChunks = Math.ceil(file.size / CHUNK_SIZE);
+ setShowProgress(true);
+ setUploadProgress(0);
+
+ for (let chunkIndex = 0; chunkIndex < totalChunks; chunkIndex++) {
+ const start = chunkIndex * CHUNK_SIZE;
+ const end = Math.min(start + CHUNK_SIZE, file.size);
+ const chunk = file.slice(start, end);
+
+ const formData = new FormData();
+ formData.append('chunk', chunk);
+ formData.append('filename', file.name);
+ formData.append('chunkIndex', chunkIndex.toString());
+ formData.append('totalChunks', totalChunks.toString());
+ formData.append('fileId', fileId);
+
+ const response = await fetch('/api/upload/project-doc-template/chunk', {
+ method: 'POST',
+ body: formData,
+ });
+
+ if (!response.ok) {
+ throw new Error(`청크 업로드 실패: ${response.statusText}`);
+ }
+
+ const progress = Math.round(((chunkIndex + 1) / totalChunks) * 100);
+ setUploadProgress(progress);
+
+ const result = await response.json();
+ if (chunkIndex === totalChunks - 1) {
+ return result;
+ }
+ }
+ };
+
+ const handleSubmit = async () => {
+ if (!selectedFile) {
+ toast.error("파일을 선택해주세요.");
+ return;
+ }
+
+ setIsLoading(true);
+ try {
+ // 1. 파일 업로드 (청크 방식)
+ const fileId = `version_${template.id}_${Date.now()}`;
+ const uploadResult = await uploadFileInChunks(selectedFile, fileId);
+
+ if (!uploadResult?.success) {
+ throw new Error("파일 업로드에 실패했습니다.");
+ }
+
+ // 2. 업로드된 파일 정보로 새 버전 생성
+ const result = await createTemplateVersion(template.id, {
+ filePath: uploadResult.filePath,
+ fileName: uploadResult.fileName,
+ fileSize: uploadResult.fileSize || selectedFile.size,
+ mimeType: uploadResult.mimeType || selectedFile.type,
+ variables: template.variables, // 기존 변수 유지
+ });
+
+ if (result.success) {
+ toast.success(`버전 ${template.version + 1}이 생성되었습니다.`);
+ onSuccess();
+ } else {
+ throw new Error(result.error);
+ }
+ } catch (error) {
+ console.error("Failed to create version:", error);
+ toast.error(error instanceof Error ? error.message : "새 버전 생성에 실패했습니다.");
+ } finally {
+ setIsLoading(false);
+ setShowProgress(false);
+ setUploadProgress(0);
+ }
+ };
+
+ return (
+ <Dialog open={true} onOpenChange={onClose}>
+ <DialogContent className="sm:max-w-md">
+ <DialogHeader>
+ <DialogTitle>새 버전 생성</DialogTitle>
+ <DialogDescription>
+ {template.templateName}의 새 버전을 생성합니다.
+ </DialogDescription>
+ </DialogHeader>
+
+ <div className="space-y-4">
+ {/* 버전 정보 표시 */}
+ <div className="rounded-lg border p-3 bg-muted/50">
+ <div className="flex items-center justify-between">
+ <span className="text-sm font-medium">현재 버전</span>
+ <Badge variant="outline">v{template.version}</Badge>
+ </div>
+ <div className="flex items-center justify-between mt-2">
+ <span className="text-sm font-medium">새 버전</span>
+ <Badge variant="default">v{template.version + 1}</Badge>
+ </div>
+ </div>
+
+ {/* 파일 선택 */}
+ <div>
+ <Label htmlFor="file">
+ 새 템플릿 파일 <span className="text-red-500">*</span>
+ </Label>
+ <div className="mt-2">
+ <Input
+ id="file"
+ type="file"
+ accept=".doc,.docx"
+ onChange={(e) => setSelectedFile(e.target.files?.[0] || null)}
+ disabled={isLoading}
+ />
+ </div>
+ {selectedFile && (
+ <p className="mt-2 text-sm text-muted-foreground">
+ 선택된 파일: {selectedFile.name} ({(selectedFile.size / 1024 / 1024).toFixed(2)} MB)
+ </p>
+ )}
+ </div>
+
+ {/* 업로드 진행률 */}
+ {showProgress && (
+ <div className="space-y-2">
+ <div className="flex justify-between text-sm">
+ <span>업로드 진행률</span>
+ <span>{uploadProgress}%</span>
+ </div>
+ <Progress value={uploadProgress} />
+ </div>
+ )}
+
+ {/* 안내 메시지 */}
+ <div className="rounded-lg border border-yellow-200 bg-yellow-50 p-3">
+ <div className="flex">
+ <AlertCircle className="h-4 w-4 text-yellow-600 mr-2 flex-shrink-0 mt-0.5" />
+ <div className="text-sm text-yellow-800">
+ <p className="font-medium">주의사항</p>
+ <ul className="mt-1 list-disc list-inside text-xs space-y-1">
+ <li>새 버전 생성 후에는 이전 버전으로 되돌릴 수 없습니다.</li>
+ <li>기존 변수 설정은 그대로 유지됩니다.</li>
+ <li>파일 형식은 기존과 동일해야 합니다 (.doc/.docx).</li>
+ </ul>
+ </div>
+ </div>
+ </div>
+ </div>
+
+ <DialogFooter>
+ <Button
+ variant="outline"
+ onClick={onClose}
+ disabled={isLoading}
+ >
+ 취소
+ </Button>
+ <Button
+ onClick={handleSubmit}
+ disabled={isLoading || !selectedFile}
+ >
+ {isLoading ? (
+ <>
+ <RefreshCw className="mr-2 h-4 w-4 animate-spin" />
+ 생성 중...
+ </>
+ ) : (
+ '버전 생성'
+ )}
+ </Button>
+ </DialogFooter>
+ </DialogContent>
+ </Dialog>
+ );
+} \ No newline at end of file
diff --git a/lib/project-doc-templates/table/project-doc-template-editor.tsx b/lib/project-doc-templates/table/project-doc-template-editor.tsx
new file mode 100644
index 00000000..e4f798a9
--- /dev/null
+++ b/lib/project-doc-templates/table/project-doc-template-editor.tsx
@@ -0,0 +1,645 @@
+"use client";
+
+import * as React from "react";
+import { Button } from "@/components/ui/button";
+import { toast } from "sonner";
+import {
+ Save,
+ RefreshCw,
+ Type,
+ FileText,
+ AlertCircle,
+ Copy,
+ Download,
+ Settings,
+ ChevronDown,
+ ChevronUp
+} from "lucide-react";
+import type { WebViewerInstance } from "@pdftron/webviewer";
+import { Badge } from "@/components/ui/badge";
+import {
+ Tooltip,
+ TooltipContent,
+ TooltipProvider,
+ TooltipTrigger
+} from "@/components/ui/tooltip";
+import {
+ Card,
+ CardContent,
+ CardDescription,
+ CardHeader,
+ CardTitle,
+} from "@/components/ui/card";
+import {
+ Collapsible,
+ CollapsibleContent,
+ CollapsibleTrigger,
+} from "@/components/ui/collapsible";
+import {
+ getProjectDocTemplateById,
+ updateProjectDocTemplate,
+ type DocTemplateVariable
+} from "@/lib/project-doc-templates/service";
+import type { ProjectDocTemplate } from "@/db/schema/project-doc-templates";
+import { BasicContractTemplateViewer } from "@/lib/basic-contract/template/basic-contract-template-viewer";
+import { v4 as uuidv4 } from 'uuid';
+import { Progress } from "@/components/ui/progress";
+
+interface ProjectDocTemplateEditorProps {
+ templateId: string | number;
+ filePath: string;
+ fileName: string;
+ refreshAction?: () => Promise<void>;
+ mode?: "view" | "edit";
+}
+
+// 변수별 한글 설명 매핑은 기존과 동일
+const VARIABLE_DESCRIPTION_MAP: Record<string, string> = {
+ "document_number": "문서번호",
+ "project_code": "프로젝트 코드",
+ "project_name": "프로젝트명",
+ "created_date": "작성일",
+ "author_name": "작성자",
+ "department": "부서명",
+ "company_name": "회사명",
+ "company_address": "회사주소",
+ "representative_name": "대표자명",
+ "signature_date": "서명날짜",
+ "today_date": "오늘날짜",
+ "tax_id": "사업자등록번호",
+ "phone_number": "전화번호",
+ "email": "이메일",
+};
+
+const VARIABLE_PATTERN = /\{\{([^}]+)\}\}/g;
+
+export function ProjectDocTemplateEditor({
+ templateId,
+ filePath,
+ fileName,
+ refreshAction,
+ mode = "edit",
+}: ProjectDocTemplateEditorProps) {
+ const [instance, setInstance] = React.useState<WebViewerInstance | null>(null);
+ const [isSaving, setIsSaving] = React.useState(false);
+ const [documentVariables, setDocumentVariables] = React.useState<string[]>([]);
+ const [templateInfo, setTemplateInfo] = React.useState<ProjectDocTemplate | null>(null);
+ const [predefinedVariables, setPredefinedVariables] = React.useState<DocTemplateVariable[]>([]);
+ const [isVariablePanelOpen, setIsVariablePanelOpen] = React.useState(false); // 변수 패널 접기/펴기 상태
+ const [uploadProgress, setUploadProgress] = React.useState(0);
+ const [showProgress, setShowProgress] = React.useState(false);
+
+ // 템플릿 정보 로드
+ React.useEffect(() => {
+ const loadTemplateInfo = async () => {
+ try {
+ const data = await getProjectDocTemplateById(Number(templateId));
+ setTemplateInfo(data as ProjectDocTemplate);
+ setPredefinedVariables(data.variables || []);
+
+ console.log("📋 템플릿 정보:", data);
+ console.log("📝 정의된 변수들:", data.variables);
+ } catch (error) {
+ console.error("템플릿 정보 로드 오류:", error);
+ toast.error("템플릿 정보를 불러오는데 실패했습니다.");
+ }
+ };
+
+ if (templateId) {
+ loadTemplateInfo();
+ }
+ }, [templateId]);
+
+ // 문서에서 변수 추출 - 기존과 동일
+ const extractVariablesFromDocument = async () => {
+ if (!instance) return;
+
+ try {
+ const { documentViewer } = instance.Core;
+ const doc = documentViewer.getDocument();
+
+ if (!doc) return;
+
+ const textContent = await doc.getDocumentCompletePromise().then(async () => {
+ const pageCount = doc.getPageCount();
+ let fullText = "";
+
+ for (let i = 1; i <= pageCount; i++) {
+ try {
+ const pageText = await doc.loadPageText(i);
+ fullText += pageText + " ";
+ } catch (error) {
+ console.warn(`페이지 ${i} 텍스트 추출 실패:`, error);
+ }
+ }
+
+ return fullText;
+ });
+
+ const matches = textContent.match(VARIABLE_PATTERN);
+ const variables = matches
+ ? [...new Set(matches.map(match => match.replace(/[{}]/g, '')))]
+ : [];
+
+ setDocumentVariables(variables);
+
+ if (variables.length > 0) {
+ console.log("🔍 문서에서 발견된 변수들:", variables);
+
+ const undefinedVars = variables.filter(
+ v => !predefinedVariables.find(pv => pv.name === v)
+ );
+
+ if (undefinedVars.length > 0) {
+ toast.warning(
+ `정의되지 않은 변수가 발견되었습니다: ${undefinedVars.join(", ")}`,
+ { duration: 5000 }
+ );
+ }
+ }
+
+ } catch (error) {
+ console.error("변수 추출 중 오류:", error);
+ }
+ };
+
+ // 청크 업로드 함수
+ const CHUNK_SIZE = 1 * 1024 * 1024; // 1MB
+
+ const uploadFileInChunks = async (file: Blob, fileName: string, fileId: string) => {
+ const totalChunks = Math.ceil(file.size / CHUNK_SIZE);
+ setShowProgress(true);
+ setUploadProgress(0);
+
+ for (let chunkIndex = 0; chunkIndex < totalChunks; chunkIndex++) {
+ const start = chunkIndex * CHUNK_SIZE;
+ const end = Math.min(start + CHUNK_SIZE, file.size);
+ const chunk = file.slice(start, end);
+
+ const formData = new FormData();
+ formData.append('chunk', chunk);
+ formData.append('filename', fileName);
+ formData.append('chunkIndex', chunkIndex.toString());
+ formData.append('totalChunks', totalChunks.toString());
+ formData.append('fileId', fileId);
+
+ const response = await fetch('/api/upload/project-doc-template/chunk', {
+ method: 'POST',
+ body: formData,
+ });
+
+ if (!response.ok) {
+ throw new Error(`청크 업로드 실패: ${response.statusText}`);
+ }
+
+ const progress = Math.round(((chunkIndex + 1) / totalChunks) * 100);
+ setUploadProgress(progress);
+
+ const result = await response.json();
+ if (chunkIndex === totalChunks - 1) {
+ return result;
+ }
+ }
+ };
+
+ // 문서 저장 - 개선된 버전
+ const handleSave = async () => {
+ if (!instance || mode === "view") {
+ toast.error(mode === "view" ? "읽기 전용 모드입니다." : "뷰어가 준비되지 않았습니다.");
+ return;
+ }
+
+ setIsSaving(true);
+ try {
+ const { documentViewer } = instance.Core;
+ const doc = documentViewer.getDocument();
+
+ if (!doc) {
+ throw new Error("문서를 찾을 수 없습니다.");
+ }
+
+ // Word 문서 데이터 추출
+ const data = await doc.getFileData({
+ downloadType: "office",
+ includeAnnotations: true
+ });
+
+ // Blob 생성
+ const fileBlob = new Blob([data], {
+ type: 'application/vnd.openxmlformats-officedocument.wordprocessingml.document'
+ });
+
+ // 파일 업로드 (청크 방식)
+ const fileId = `template_${templateId}_${Date.now()}`;
+ const uploadResult = await uploadFileInChunks(fileBlob, fileName, fileId);
+
+ if (!uploadResult?.success) {
+ throw new Error("파일 업로드에 실패했습니다.");
+ }
+
+ // 서버에 파일 경로 업데이트
+ const updateResult = await updateProjectDocTemplate(Number(templateId), {
+ filePath: uploadResult.filePath,
+ fileName: uploadResult.fileName,
+ fileSize: uploadResult.fileSize,
+ variables: documentVariables.length > 0 ?
+ documentVariables.map(varName => {
+ const existing = predefinedVariables.find(v => v.name === varName);
+ return existing || {
+ name: varName,
+ displayName: VARIABLE_DESCRIPTION_MAP[varName] || varName,
+ type: "text" as const,
+ required: false,
+ description: ""
+ };
+ }) : predefinedVariables
+ });
+
+ if (!updateResult.success) {
+ throw new Error(updateResult.error || "템플릿 업데이트에 실패했습니다.");
+ }
+
+ toast.success("템플릿이 성공적으로 저장되었습니다.");
+
+ // 변수 재추출
+ await extractVariablesFromDocument();
+
+ // 페이지 새로고침
+ if (refreshAction) {
+ await refreshAction();
+ }
+
+ } catch (error) {
+ console.error("저장 오류:", error);
+ toast.error(error instanceof Error ? error.message : "저장 중 오류가 발생했습니다.");
+ } finally {
+ setIsSaving(false);
+ setShowProgress(false);
+ setUploadProgress(0);
+ }
+ };
+
+ // 나머지 함수들은 기존과 동일
+ React.useEffect(() => {
+ if (instance) {
+ const { documentViewer } = instance.Core;
+
+ const onDocumentLoaded = () => {
+ setTimeout(() => extractVariablesFromDocument(), 1000);
+ };
+
+ documentViewer.addEventListener("documentLoaded", onDocumentLoaded);
+
+ return () => {
+ documentViewer.removeEventListener("documentLoaded", onDocumentLoaded);
+ };
+ }
+ }, [instance, predefinedVariables]);
+
+ const insertVariable = async (variable: DocTemplateVariable) => {
+ if (!instance) {
+ toast.error("뷰어가 준비되지 않았습니다.");
+ return;
+ }
+
+ const textToInsert = `{{${variable.name}}}`; // variable.name으로 수정
+
+ try {
+ // textarea를 보이는 위치에 잠시 생성
+ const tempTextArea = document.createElement('textarea');
+ tempTextArea.value = textToInsert;
+ tempTextArea.style.position = 'fixed';
+ tempTextArea.style.top = '20px';
+ tempTextArea.style.left = '20px';
+ tempTextArea.style.width = '200px';
+ tempTextArea.style.height = '30px';
+ tempTextArea.style.fontSize = '12px';
+ tempTextArea.style.zIndex = '10000';
+ tempTextArea.style.opacity = '0.01'; // 거의 투명하게
+
+ document.body.appendChild(tempTextArea);
+
+ // 포커스와 선택을 확실하게
+ tempTextArea.focus();
+ tempTextArea.select();
+ tempTextArea.setSelectionRange(0, tempTextArea.value.length); // 전체 선택 보장
+
+ let successful = false;
+ try {
+ successful = document.execCommand('copy');
+ console.log('복사 시도 결과:', successful, '복사된 텍스트:', textToInsert);
+ } catch (err) {
+ console.error('execCommand 실패:', err);
+ }
+
+ // 잠시 후 제거 (즉시 제거하면 복사가 안될 수 있음)
+ setTimeout(() => {
+ document.body.removeChild(tempTextArea);
+ }, 100);
+
+ if (successful) {
+ toast.success(
+ <div>
+ <p className="font-medium">{variable.displayName} 변수가 복사되었습니다.</p>
+ <code className="bg-gray-100 px-1 rounded text-xs">{textToInsert}</code>
+ <p className="text-sm text-muted-foreground mt-1">
+ 문서에서 원하는 위치에 Ctrl+V로 붙여넣기 하세요.
+ </p>
+ </div>,
+ { duration: 3000 }
+ );
+
+ // 복사 확인용 - 개발 중에만 사용
+ if (process.env.NODE_ENV === 'development') {
+ navigator.clipboard.readText().then(text => {
+ console.log('클립보드 내용:', text);
+ }).catch(err => {
+ console.log('클립보드 읽기 실패:', err);
+ });
+ }
+ } else {
+ // 복사 실패 시 대안 제공
+ const fallbackInput = document.createElement('input');
+ fallbackInput.value = textToInsert;
+ fallbackInput.style.position = 'fixed';
+ fallbackInput.style.top = '50%';
+ fallbackInput.style.left = '50%';
+ fallbackInput.style.transform = 'translate(-50%, -50%)';
+ fallbackInput.style.zIndex = '10001';
+ fallbackInput.style.padding = '8px';
+ fallbackInput.style.border = '2px solid #3b82f6';
+ fallbackInput.style.borderRadius = '4px';
+ fallbackInput.style.backgroundColor = 'white';
+
+ document.body.appendChild(fallbackInput);
+ fallbackInput.select();
+
+ toast.error(
+ <div>
+ <p className="font-medium">자동 복사 실패</p>
+ <p className="text-sm">표시된 텍스트를 Ctrl+C로 복사하세요.</p>
+ </div>,
+ {
+ duration: 5000,
+ onDismiss: () => {
+ if (document.body.contains(fallbackInput)) {
+ document.body.removeChild(fallbackInput);
+ }
+ }
+ }
+ );
+ }
+
+ } catch (error) {
+ console.error("변수 삽입 오류:", error);
+ toast.error("변수 삽입 중 오류가 발생했습니다.");
+ }
+ };
+
+ const handleDownload = async () => {
+ try {
+ const response = await fetch(filePath);
+ const blob = await response.blob();
+ const url = window.URL.createObjectURL(blob);
+ const a = document.createElement('a');
+ a.style.display = 'none';
+ a.href = url;
+ a.download = fileName;
+ document.body.appendChild(a);
+ a.click();
+ window.URL.revokeObjectURL(url);
+ toast.success("파일이 다운로드되었습니다.");
+ } catch (error) {
+ console.error("다운로드 오류:", error);
+ toast.error("파일 다운로드 중 오류가 발생했습니다.");
+ }
+ };
+
+ const handleRefresh = () => {
+ window.location.reload();
+ };
+
+ const isReadOnly = mode === "view";
+
+ return (
+ <div className="h-full flex flex-col">
+ {/* 상단 도구 모음 */}
+ <div className="border-b bg-gray-50 p-3">
+ <div className="flex items-center justify-between">
+ <div className="flex items-center space-x-2">
+ {!isReadOnly && (
+ <Button
+ variant="outline"
+ size="sm"
+ onClick={handleSave}
+ disabled={isSaving || !instance}
+ >
+ {isSaving ? (
+ <>
+ <RefreshCw className="mr-2 h-4 w-4 animate-spin" />
+ 저장 중...
+ </>
+ ) : (
+ <>
+ <Save className="mr-2 h-4 w-4" />
+ 저장
+ </>
+ )}
+ </Button>
+ )}
+
+ <Button
+ variant="outline"
+ size="sm"
+ onClick={handleDownload}
+ >
+ <Download className="mr-2 h-4 w-4" />
+ 다운로드
+ </Button>
+
+ <Button
+ variant="outline"
+ size="sm"
+ onClick={handleRefresh}
+ >
+ <RefreshCw className="mr-2 h-4 w-4" />
+ 새로고침
+ </Button>
+ </div>
+
+ <div className="flex items-center space-x-2">
+ {templateInfo?.projectCode && (
+ <Badge variant="outline">
+ <FileText className="mr-1 h-3 w-3" />
+ {templateInfo.projectCode}
+ </Badge>
+ )}
+ <Badge variant="secondary">
+ {fileName}
+ </Badge>
+ {documentVariables.length > 0 && (
+ <Badge variant="secondary">
+ <Type className="mr-1 h-3 w-3" />
+ 변수 {documentVariables.length}개
+ </Badge>
+ )}
+ </div>
+ </div>
+
+
+ {/* 변수 도구 - Collapsible로 변경 */}
+ {(predefinedVariables.length > 0 || documentVariables.length > 0) && (
+ <Collapsible
+ open={isVariablePanelOpen}
+ onOpenChange={setIsVariablePanelOpen}
+ className="mt-3"
+ >
+ <Card>
+ <CardHeader className="pb-3">
+ <div className="flex items-center justify-between">
+ <CardTitle className="text-sm flex items-center">
+ <Type className="mr-2 h-4 w-4 text-blue-500" />
+ 템플릿 변수 관리
+ {documentVariables.length > 0 && (
+ <Badge variant="secondary" className="ml-2">
+ {documentVariables.length}개
+ </Badge>
+ )}
+ </CardTitle>
+ <CollapsibleTrigger asChild>
+ <Button variant="ghost" size="sm">
+ {isVariablePanelOpen ? (
+ <>
+ <ChevronUp className="h-4 w-4 mr-1" />
+ 접기
+ </>
+ ) : (
+ <>
+ <ChevronDown className="h-4 w-4 mr-1" />
+ 펼치기
+ </>
+ )}
+ </Button>
+ </CollapsibleTrigger>
+ </div>
+ </CardHeader>
+
+ <CollapsibleContent>
+ <CardContent className="space-y-3">
+ {/* 정의된 변수들 */}
+ {predefinedVariables.length > 0 && (
+ <div>
+ <p className="text-xs text-muted-foreground mb-2">정의된 템플릿 변수 (클릭하여 복사):</p>
+ <TooltipProvider>
+ <div className="flex flex-wrap gap-1">
+ {predefinedVariables.map((variable, index) => (
+ <Tooltip key={index}>
+ <TooltipTrigger asChild>
+ <Button
+ variant="ghost"
+ size="sm"
+ className="h-7 px-2 text-xs hover:bg-blue-50"
+ onClick={() => !isReadOnly && insertVariable(variable)}
+ disabled={isReadOnly}
+ >
+ <span className="font-mono">
+ {`{{${variable.name}}}`}
+ </span>
+ {variable.required && (
+ <span className="ml-1 text-red-500">*</span>
+ )}
+ </Button>
+ </TooltipTrigger>
+ <TooltipContent>
+ <div className="space-y-1">
+ <p className="font-medium">{variable.displayName}</p>
+ {variable.description && (
+ <p className="text-xs">{variable.description}</p>
+ )}
+ {variable.defaultValue && (
+ <p className="text-xs">기본값: {variable.defaultValue}</p>
+ )}
+ <p className="text-xs text-muted-foreground">
+ 타입: {variable.type} {variable.required && "(필수)"}
+ </p>
+ </div>
+ </TooltipContent>
+ </Tooltip>
+ ))}
+ </div>
+ </TooltipProvider>
+ </div>
+ )}
+
+ {/* 문서에서 발견된 변수들 */}
+ {documentVariables.length > 0 && (
+ <div>
+ <p className="text-xs text-muted-foreground mb-2">문서에서 발견된 변수:</p>
+ <div className="flex flex-wrap gap-1">
+ {documentVariables.map((variable, index) => {
+ const isDefined = predefinedVariables.find(v => v.name === variable);
+ return (
+ <Badge
+ key={index}
+ variant={isDefined ? "secondary" : "destructive"}
+ className="text-xs"
+ >
+ {`{{${variable}}}`}
+ {!isDefined && (
+ <AlertCircle className="ml-1 h-3 w-3" />
+ )}
+ </Badge>
+ );
+ })}
+ </div>
+ </div>
+ )}
+
+ {/* 변수 사용 안내 */}
+ <div className="mt-3 p-2 bg-blue-50 rounded-lg">
+ <div className="flex items-start">
+ <AlertCircle className="h-4 w-4 text-blue-600 mt-0.5 mr-2 flex-shrink-0" />
+ <div className="text-xs text-blue-900 space-y-1">
+ <p className="font-medium">변수 사용 안내</p>
+ <ul className="list-disc list-inside space-y-0.5">
+ <li>{'{{변수명}}'} 형식으로 문서에 변수를 삽입하세요.</li>
+ <li>필수 변수(*)는 반드시 값이 입력되어야 합니다.</li>
+ <li>한글 입력 제한 시 외부 에디터에서 작성 후 붙여넣기 하세요.</li>
+ </ul>
+ </div>
+ </div>
+ </div>
+ </CardContent>
+ </CollapsibleContent>
+ </Card>
+ </Collapsible>
+ )}
+
+ {/* 업로드 진행률 */}
+ {showProgress && (
+ <div className="mt-3 p-3 bg-white rounded border">
+ <div className="space-y-2">
+ <div className="flex justify-between text-sm">
+ <span>저장 진행률</span>
+ <span>{uploadProgress}%</span>
+ </div>
+ <Progress value={uploadProgress} />
+ </div>
+ </div>
+ )}
+ </div>
+
+ {/* 뷰어 영역 */}
+ <div className="flex-1 relative overflow-hidden">
+ <div className="absolute inset-0">
+ <BasicContractTemplateViewer
+ templateId={templateId}
+ filePath={filePath}
+ instance={instance}
+ setInstance={setInstance}
+ />
+ </div>
+ </div>
+ </div>
+ );
+} \ No newline at end of file
diff --git a/lib/project-doc-templates/table/template-detail-dialog.tsx b/lib/project-doc-templates/table/template-detail-dialog.tsx
new file mode 100644
index 00000000..0810a58a
--- /dev/null
+++ b/lib/project-doc-templates/table/template-detail-dialog.tsx
@@ -0,0 +1,121 @@
+// lib/project-doc-template/template-detail-dialog.tsx
+"use client";
+
+import * as React from "react";
+import {
+ Dialog,
+ DialogContent,
+ DialogHeader,
+ DialogTitle,
+} from "@/components/ui/dialog";
+import { Badge } from "@/components/ui/badge";
+import { Tabs, TabsContent, TabsList, TabsTrigger } from "@/components/ui/tabs";
+import { Card, CardContent, CardDescription, CardHeader, CardTitle } from "@/components/ui/card";
+import { ProjectDocTemplateEditor } from "./project-doc-template-editor";
+import { getProjectDocTemplateById } from "@/lib/project-doc-templates/service";
+import type { ProjectDocTemplate } from "@/db/schema/project-doc-templates";
+import { formatDateTime } from "@/lib/utils";
+import { FileText, Clock, User, GitBranch, Variable } from "lucide-react";
+
+interface TemplateDetailDialogProps {
+ template: ProjectDocTemplate;
+ open: boolean;
+ onOpenChange: (open: boolean) => void;
+}
+
+export function TemplateDetailDialog({
+ template,
+ open,
+ onOpenChange,
+}: TemplateDetailDialogProps) {
+ const [templateDetail, setTemplateDetail] = React.useState<any>(null);
+ const [isLoading, setIsLoading] = React.useState(true);
+
+ // 템플릿 상세 정보 로드
+ React.useEffect(() => {
+ if (open && template.id) {
+ setIsLoading(true);
+ getProjectDocTemplateById(template.id)
+ .then(setTemplateDetail)
+ .catch(console.error)
+ .finally(() => setIsLoading(false));
+ }
+ }, [open, template.id]);
+
+ return (
+ <Dialog open={open} onOpenChange={onOpenChange}>
+ <DialogContent className="max-w-7xl h-[90vh] p-0 flex flex-col">
+ <DialogHeader className="px-6 py-4 border-b">
+ <DialogTitle className="flex items-center justify-between">
+ <div className="flex items-center gap-2">
+ <FileText className="h-5 w-5" />
+ {template.templateName}
+ </div>
+ <div className="flex gap-2">
+ <Badge variant="outline">v{template.version}</Badge>
+ {template.isLatest && <Badge variant="default">최신</Badge>}
+ <Badge variant="secondary">{template.status}</Badge>
+ </div>
+ </DialogTitle>
+ </DialogHeader>
+
+ <Tabs defaultValue="viewer" className="flex-1 flex flex-col">
+ <TabsList className="mx-6 mt-2">
+ <TabsTrigger value="viewer">문서 보기</TabsTrigger>
+ <TabsTrigger value="history">버전 히스토리</TabsTrigger>
+ </TabsList>
+
+ <TabsContent value="viewer" className="flex-1 mt-0">
+ <div className="h-full">
+ <ProjectDocTemplateEditor
+ templateId={template.id}
+ filePath={template.filePath}
+ fileName={template.fileName}
+ // mode="view" // 읽기 전용 모드
+ />
+ </div>
+ </TabsContent>
+
+
+ <TabsContent value="history" className="flex-1 overflow-y-auto px-6">
+ <div className="space-y-4 py-4">
+ {templateDetail?.versionHistory && templateDetail.versionHistory.length > 0 ? (
+ templateDetail.versionHistory.map((version: any) => (
+ <Card key={version.id} className={version.id === template.id ? "border-primary" : ""}>
+ <CardHeader>
+ <CardTitle className="text-base flex items-center justify-between">
+ <div className="flex items-center gap-2">
+ <GitBranch className="h-4 w-4" />
+ 버전 {version.version}
+ </div>
+ <div className="flex gap-2">
+ {version.isLatest && <Badge variant="default">최신</Badge>}
+ {version.id === template.id && <Badge variant="secondary">현재</Badge>}
+ </div>
+ </CardTitle>
+ </CardHeader>
+ <CardContent>
+ <div className="text-sm space-y-1">
+ <p>
+ <span className="text-muted-foreground">생성일:</span> {formatDateTime(version.createdAt, "KR")}
+ </p>
+ <p>
+ <span className="text-muted-foreground">생성자:</span> {version.createdByName || '-'}
+ </p>
+ <p>
+ <span className="text-muted-foreground">파일:</span> {version.fileName}
+ </p>
+ </div>
+ </CardContent>
+ </Card>
+ ))
+ ) : (
+ <p className="text-sm text-muted-foreground">버전 히스토리가 없습니다.</p>
+ )}
+ </div>
+ </TabsContent>
+ </Tabs>
+ </DialogContent>
+ </Dialog>
+ );
+} \ No newline at end of file
diff --git a/lib/project-doc-templates/table/template-edit-sheet.tsx b/lib/project-doc-templates/table/template-edit-sheet.tsx
new file mode 100644
index 00000000..a745045c
--- /dev/null
+++ b/lib/project-doc-templates/table/template-edit-sheet.tsx
@@ -0,0 +1,305 @@
+// lib/project-doc-template/template-edit-sheet.tsx
+"use client";
+
+import * as React from "react";
+import {
+ Sheet,
+ SheetContent,
+ SheetDescription,
+ SheetHeader,
+ SheetTitle,
+ SheetFooter,
+} from "@/components/ui/sheet";
+import { Button } from "@/components/ui/button";
+import { Input } from "@/components/ui/input";
+import { Label } from "@/components/ui/label";
+import { Textarea } from "@/components/ui/textarea";
+import { Badge } from "@/components/ui/badge";
+import { Switch } from "@/components/ui/switch";
+import { toast } from "sonner";
+import { updateProjectDocTemplate } from "@/lib/project-doc-templates/service";
+import type { ProjectDocTemplate, DocTemplateVariable } from "@/db/schema/project-doc-templates";
+import { Plus, X, Save, Loader2 } from "lucide-react";
+
+interface TemplateEditSheetProps {
+ template: ProjectDocTemplate | null;
+ open: boolean;
+ onOpenChange: (open: boolean) => void;
+ onSuccess?: () => void;
+}
+
+export function TemplateEditSheet({
+ template,
+ open,
+ onOpenChange,
+ onSuccess,
+}: TemplateEditSheetProps) {
+ const [isLoading, setIsLoading] = React.useState(false);
+ const [formData, setFormData] = React.useState({
+ templateName: "",
+ description: "",
+ variables: [] as DocTemplateVariable[],
+ status: "ACTIVE",
+ });
+
+ // 템플릿 데이터 로드
+ React.useEffect(() => {
+ if (template && open) {
+ setFormData({
+ templateName: template.templateName || "",
+ description: template.description || "",
+ variables: template.variables || [],
+ status: template.status || "ACTIVE",
+ });
+ }
+ }, [template, open]);
+
+ // 변수 추가
+ const addVariable = () => {
+ setFormData({
+ ...formData,
+ variables: [
+ ...formData.variables,
+ {
+ name: "",
+ displayName: "",
+ type: "text",
+ required: false,
+ defaultValue: "",
+ description: "",
+ },
+ ],
+ });
+ };
+
+ // 변수 제거
+ const removeVariable = (index: number) => {
+ setFormData({
+ ...formData,
+ variables: formData.variables.filter((_, i) => i !== index),
+ });
+ };
+
+ // 변수 업데이트
+ const updateVariable = (index: number, field: string, value: any) => {
+ const updatedVariables = [...formData.variables];
+ updatedVariables[index] = {
+ ...updatedVariables[index],
+ [field]: value,
+ };
+ setFormData({
+ ...formData,
+ variables: updatedVariables,
+ });
+ };
+
+ // 저장 처리
+ const handleSave = async () => {
+ if (!template) return;
+
+ setIsLoading(true);
+ try {
+ const result = await updateProjectDocTemplate(template.id, {
+ templateName: formData.templateName,
+ description: formData.description,
+ variables: formData.variables,
+ status: formData.status,
+ });
+
+ if (result.success) {
+ toast.success("템플릿이 수정되었습니다.");
+ onOpenChange(false);
+ onSuccess?.();
+ } else {
+ throw new Error(result.error);
+ }
+ } catch (error) {
+ console.error("Failed to update template:", error);
+ toast.error(error instanceof Error ? error.message : "템플릿 수정에 실패했습니다.");
+ } finally {
+ setIsLoading(false);
+ }
+ };
+
+ return (
+ <Sheet open={open} onOpenChange={onOpenChange}>
+ <SheetContent className="w-[600px] sm:max-w-[600px] overflow-y-auto">
+ <SheetHeader>
+ <SheetTitle>템플릿 수정</SheetTitle>
+ <SheetDescription>
+ 템플릿 정보와 변수를 수정할 수 있습니다. 파일을 변경하려면 새 버전을 생성하세요.
+ </SheetDescription>
+ </SheetHeader>
+
+ <div className="space-y-6 py-6">
+ {/* 기본 정보 */}
+ <div className="space-y-4">
+ <div>
+ <Label htmlFor="templateName">템플릿 이름</Label>
+ <Input
+ id="templateName"
+ value={formData.templateName}
+ onChange={(e) => setFormData({ ...formData, templateName: e.target.value })}
+ placeholder="템플릿 이름을 입력하세요"
+ />
+ </div>
+
+ <div>
+ <Label htmlFor="description">설명</Label>
+ <Textarea
+ id="description"
+ value={formData.description}
+ onChange={(e) => setFormData({ ...formData, description: e.target.value })}
+ placeholder="템플릿 설명을 입력하세요"
+ className="min-h-[80px]"
+ />
+ </div>
+
+ <div>
+ <Label htmlFor="status">상태</Label>
+ <select
+ id="status"
+ className="w-full rounded-md border border-input bg-background px-3 py-2 text-sm"
+ value={formData.status}
+ onChange={(e) => setFormData({ ...formData, status: e.target.value })}
+ >
+ <option value="ACTIVE">활성</option>
+ <option value="INACTIVE">비활성</option>
+ <option value="DRAFT">초안</option>
+ <option value="ARCHIVED">보관</option>
+ </select>
+ </div>
+ </div>
+
+ {/* 변수 관리 */}
+ <div>
+ <div className="flex items-center justify-between mb-4">
+ <Label>템플릿 변수</Label>
+ <Button
+ type="button"
+ variant="outline"
+ size="sm"
+ onClick={addVariable}
+ >
+ <Plus className="mr-2 h-4 w-4" />
+ 변수 추가
+ </Button>
+ </div>
+
+ {/* 기본 변수 표시 */}
+ <div className="mb-4 p-3 bg-muted/50 rounded-lg">
+ <p className="text-xs font-medium mb-2">기본 변수 (수정 불가)</p>
+ <div className="space-y-1">
+ <Badge variant="secondary">document_number</Badge>
+ <Badge variant="secondary" className="ml-2">project_code</Badge>
+ <Badge variant="secondary" className="ml-2">project_name</Badge>
+ </div>
+ </div>
+
+ {/* 사용자 정의 변수 */}
+ {formData.variables.length > 0 ? (
+ <div className="space-y-3">
+ {formData.variables.map((variable, index) => (
+ <div key={index} className="p-3 border rounded-lg space-y-3">
+ <div className="flex items-center justify-between">
+ <span className="text-sm font-medium">변수 #{index + 1}</span>
+ <Button
+ type="button"
+ variant="ghost"
+ size="sm"
+ onClick={() => removeVariable(index)}
+ >
+ <X className="h-4 w-4" />
+ </Button>
+ </div>
+
+ <div className="grid grid-cols-2 gap-3">
+ <div>
+ <Label>변수명</Label>
+ <Input
+ value={variable.name}
+ onChange={(e) => updateVariable(index, "name", e.target.value)}
+ placeholder="예: vendor_name"
+ />
+ </div>
+ <div>
+ <Label>표시명</Label>
+ <Input
+ value={variable.displayName}
+ onChange={(e) => updateVariable(index, "displayName", e.target.value)}
+ placeholder="예: 벤더명"
+ />
+ </div>
+ </div>
+
+ <div className="grid grid-cols-2 gap-3">
+ <div>
+ <Label>타입</Label>
+ <select
+ className="w-full rounded-md border border-input bg-background px-3 py-2 text-sm"
+ value={variable.type}
+ onChange={(e) => updateVariable(index, "type", e.target.value)}
+ >
+ <option value="text">텍스트</option>
+ <option value="number">숫자</option>
+ <option value="date">날짜</option>
+ <option value="select">선택</option>
+ </select>
+ </div>
+ <div className="flex items-center justify-between rounded-lg border p-2">
+ <Label className="text-sm">필수</Label>
+ <Switch
+ checked={variable.required}
+ onCheckedChange={(checked) => updateVariable(index, "required", checked)}
+ />
+ </div>
+ </div>
+
+ <div>
+ <Label>설명</Label>
+ <Input
+ value={variable.description || ""}
+ onChange={(e) => updateVariable(index, "description", e.target.value)}
+ placeholder="변수 설명 (선택사항)"
+ />
+ </div>
+ </div>
+ ))}
+ </div>
+ ) : (
+ <div className="text-center py-4 text-sm text-muted-foreground">
+ 사용자 정의 변수가 없습니다.
+ </div>
+ )}
+ </div>
+ </div>
+
+ <SheetFooter>
+ <Button
+ variant="outline"
+ onClick={() => onOpenChange(false)}
+ disabled={isLoading}
+ >
+ 취소
+ </Button>
+ <Button
+ onClick={handleSave}
+ disabled={isLoading}
+ >
+ {isLoading ? (
+ <>
+ <Loader2 className="mr-2 h-4 w-4 animate-spin" />
+ 저장 중...
+ </>
+ ) : (
+ <>
+ <Save className="mr-2 h-4 w-4" />
+ 저장
+ </>
+ )}
+ </Button>
+ </SheetFooter>
+ </SheetContent>
+ </Sheet>
+ );
+} \ No newline at end of file
diff --git a/lib/project-doc-templates/validations.ts b/lib/project-doc-templates/validations.ts
new file mode 100644
index 00000000..e745c468
--- /dev/null
+++ b/lib/project-doc-templates/validations.ts
@@ -0,0 +1,31 @@
+
+import {
+ createSearchParamsCache,
+ parseAsArrayOf,
+ parseAsInteger,
+ parseAsString,
+ parseAsStringEnum,
+} from "nuqs/server";
+import * as z from "zod";
+
+import { getFiltersStateParser, getSortingStateParser } from "@/lib/parsers";
+import { ProjectDocTemplate } from "@/db/schema";
+
+export const searchParamsDOCTemplatesCache = createSearchParamsCache({
+ page: parseAsInteger.withDefault(1),
+ perPage: parseAsInteger.withDefault(10),
+ sort: getSortingStateParser<ProjectDocTemplate>().withDefault([
+ { id: "createdAt", desc: true },
+ ]),
+
+ filters: getFiltersStateParser().withDefault([]),
+ joinOperator: parseAsStringEnum(["and", "or"]).withDefault("and"),
+
+ // 검색
+ search: parseAsString.withDefault(""),
+
+});
+
+export type GetDOCTemplatesSchema = Awaited<
+ ReturnType<typeof searchParamsDOCTemplatesCache.parse>
+>;
generated by cgit v1.2.3 (git 2.39.1) at 2025-12-07 15:32:33 +0000