diff options
Diffstat (limited to 'lib/docu-list-rule/document-class/service.ts')
| -rw-r--r-- | lib/docu-list-rule/document-class/service.ts | 61 |
1 files changed, 41 insertions, 20 deletions
diff --git a/lib/docu-list-rule/document-class/service.ts b/lib/docu-list-rule/document-class/service.ts index a1bb14a7..91a4e053 100644 --- a/lib/docu-list-rule/document-class/service.ts +++ b/lib/docu-list-rule/document-class/service.ts @@ -3,7 +3,8 @@ import { revalidatePath } from "next/cache" import db from "@/db/db" import { documentClasses, documentClassOptions, codeGroups } from "@/db/schema/docu-list-rule" -import { eq, desc, asc, sql, and } from "drizzle-orm" +import { projects } from "@/db/schema/projects" +import { eq, desc, sql, and } from "drizzle-orm" // Document Class 목록 조회 (A Class, B Class 등) export async function getDocumentClassCodeGroups(input: { @@ -31,7 +32,8 @@ export async function getDocumentClassCodeGroups(input: { whereConditions = sql`${whereConditions} AND ( ${documentClasses.code} ILIKE ${searchTerm} OR ${documentClasses.value} ILIKE ${searchTerm} OR - ${documentClasses.description} ILIKE ${searchTerm} + ${documentClasses.description} ILIKE ${searchTerm} OR + ${projects.code} ILIKE ${searchTerm} )` } @@ -48,6 +50,8 @@ export async function getDocumentClassCodeGroups(input: { return sql`${documentClasses.value} ILIKE ${`%${value}%`}` case "description": return sql`${documentClasses.description} ILIKE ${`%${value}%`}` + case "projectCode": + return sql`${projects.code} ILIKE ${`%${value}%`}` case "isActive": return sql`${documentClasses.isActive} = ${value === "true"}` case "createdAt": @@ -73,14 +77,20 @@ export async function getDocumentClassCodeGroups(input: { if (sort && sort.length > 0) { const sortField = sort[0] // 안전성 체크: 필드가 실제 테이블에 존재하는지 확인 - if (sortField && sortField.id && typeof sortField.id === "string" && sortField.id in documentClasses) { + if (sortField && sortField.id && typeof sortField.id === "string") { const direction = sortField.desc ? sql`DESC` : sql`ASC` - const col = documentClasses[sortField.id as keyof typeof documentClasses] - orderBy = sql`${col} ${direction}` + + // 프로젝트 코드 정렬 처리 + if (sortField.id === "projectCode") { + orderBy = sql`${projects.code} ${direction}` + } else if (sortField.id in documentClasses) { + const col = documentClasses[sortField.id as keyof typeof documentClasses] + orderBy = sql`${col} ${direction}` + } } } - // 데이터 조회 + // 데이터 조회 (프로젝트 정보 포함) const data = await db .select({ id: documentClasses.id, @@ -90,32 +100,36 @@ export async function getDocumentClassCodeGroups(input: { isActive: documentClasses.isActive, createdAt: documentClasses.createdAt, updatedAt: documentClasses.updatedAt, + projectId: documentClasses.projectId, + projectCode: projects.code, + projectName: projects.name, }) .from(documentClasses) + .leftJoin(projects, eq(documentClasses.projectId, projects.id)) .where(whereConditions) .orderBy(orderBy) .limit(perPage) .offset(offset) - // 총 개수 조회 - const [{ count: total }] = await db - .select({ count: sql`count(*)` }) + // 총 개수 조회 (프로젝트 정보 포함) + const totalCountResult = await db + .select({ count: sql<number>`count(*)` }) .from(documentClasses) + .leftJoin(projects, eq(documentClasses.projectId, projects.id)) .where(whereConditions) - const pageCount = Math.ceil(Number(total) / perPage) + const totalCount = totalCountResult[0]?.count || 0 return { - success: true, data, - pageCount, + totalCount, + pageCount: Math.ceil(totalCount / perPage), } } catch (error) { console.error("Error fetching document classes:", error) return { - success: false, - error: "Failed to fetch document classes", data: [], + totalCount: 0, pageCount: 0, } } @@ -123,14 +137,15 @@ export async function getDocumentClassCodeGroups(input: { // Document Class 생성 export async function createDocumentClassCodeGroup(input: { + projectId: number // projectCode를 projectId로 변경 value: string description?: string }) { try { // Value 자동 변환: "A", "AB", "A Class", "A CLASS" 등을 "A Class", "AB Class" 형태로 변환 - const formatValue = (value: string): string => { + const formatValue = (input: string): string => { // 공백 제거 및 대소문자 정규화 - const cleaned = value.trim().toLowerCase() + const cleaned = input.trim().toLowerCase() // "class"가 포함되어 있으면 제거 const withoutClass = cleaned.replace(/\s*class\s*/g, '') @@ -139,7 +154,7 @@ export async function createDocumentClassCodeGroup(input: { const letters = withoutClass.replace(/[^a-z0-9]/g, '') if (letters.length === 0) { - return value.trim() // 변환할 수 없으면 원본 반환 + return input.trim() // 변환할 수 없으면 원본 반환 } // 첫 글자를 대문자로 변환하고 "Class" 추가 @@ -148,10 +163,11 @@ export async function createDocumentClassCodeGroup(input: { const formattedValue = formatValue(input.value) - // 자동으로 code 생성 (예: "DOC_CLASS_001", "DOC_CLASS_002" 등) + // 해당 프로젝트의 자동으로 code 생성 (예: "DOC_CLASS_001", "DOC_CLASS_002" 등) const existingClasses = await db .select({ code: documentClasses.code }) .from(documentClasses) + .where(eq(documentClasses.projectId, input.projectId)) // projectId로 변경 .orderBy(desc(documentClasses.code)) let newCode = "DOC_CLASS_001" @@ -163,11 +179,14 @@ export async function createDocumentClassCodeGroup(input: { } } - // Code Group이 존재하는지 확인 + // 해당 프로젝트의 Code Group이 존재하는지 확인 const existingCodeGroup = await db .select({ id: codeGroups.id }) .from(codeGroups) - .where(eq(codeGroups.groupId, 'DOC_CLASS')) + .where(and( + eq(codeGroups.projectId, input.projectId), // projectId로 변경 + eq(codeGroups.groupId, 'DOC_CLASS') + )) .limit(1) let codeGroupId: number | null = null @@ -177,6 +196,7 @@ export async function createDocumentClassCodeGroup(input: { const [newCodeGroup] = await db .insert(codeGroups) .values({ + projectId: input.projectId, // projectId로 변경 groupId: 'DOC_CLASS', description: 'Document Class', codeFormat: 'DOC_CLASS_###', @@ -194,6 +214,7 @@ export async function createDocumentClassCodeGroup(input: { const [newDocumentClass] = await db .insert(documentClasses) .values({ + projectId: input.projectId, // projectId로 변경 code: newCode, value: formattedValue, description: input.description || "", |