Merge branch 'dujinkim' of https://github.com/DTS-Development/SHI_EVCP into dujinkim

1 files changed, 6 insertions, 37 deletions

diff --git a/lib/docu-list-rule/document-class/service.ts b/lib/docu-list-rule/document-class/service.ts
index 91a4e053..2ec31ae6 100644
--- a/lib/docu-list-rule/document-class/service.ts
+++ b/lib/docu-list-rule/document-class/service.ts
@@ -23,13 +23,13 @@ export async function getDocumentClassCodeGroups(input: {
     const { page, perPage, sort, search, filters, joinOperator } = input
     const offset = (page - 1) * perPage
 
-    // 기본 조건
-    let whereConditions = sql`${documentClasses.isActive} = true`
+    // 기본 조건 (plant 타입 프로젝트만)
+    let whereConditions = sql`${documentClasses.isActive} = true AND ${projects.type} = 'plant'`
     
     // 검색 조건
     if (search) {
       const searchTerm = `%${search}%`
-      whereConditions = sql`${whereConditions} AND (
+      whereConditions = sql`${documentClasses.isActive} = true AND ${projects.type} = 'plant' AND (
         ${documentClasses.code} ILIKE ${searchTerm} OR
         ${documentClasses.value} ILIKE ${searchTerm} OR
         ${documentClasses.description} ILIKE ${searchTerm} OR
@@ -102,7 +102,8 @@ export async function getDocumentClassCodeGroups(input: {
         updatedAt: documentClasses.updatedAt,
         projectId: documentClasses.projectId,
         projectCode: projects.code,
-        projectName: projects.name,
+        projectName: projects.name, 
+        projectType: projects.type,
       })
       .from(documentClasses)
       .leftJoin(projects, eq(documentClasses.projectId, projects.id))
@@ -179,38 +180,6 @@ export async function createDocumentClassCodeGroup(input: {
       }
     }
 
-    // 해당 프로젝트의 Code Group이 존재하는지 확인
-    const existingCodeGroup = await db
-      .select({ id: codeGroups.id })
-      .from(codeGroups)
-      .where(and(
-        eq(codeGroups.projectId, input.projectId), // projectId로 변경
-        eq(codeGroups.groupId, 'DOC_CLASS')
-      ))
-      .limit(1)
-
-    let codeGroupId: number | null = null
-
-    if (existingCodeGroup.length === 0) {
-      // Code Group이 없으면 자동으로 생성
-      const [newCodeGroup] = await db
-        .insert(codeGroups)
-        .values({
-          projectId: input.projectId, // projectId로 변경
-          groupId: 'DOC_CLASS',
-          description: 'Document Class',
-          codeFormat: 'DOC_CLASS_###',
-          expressions: '^DOC_CLASS_\\d{3}$',
-          controlType: 'Combobox',
-          isActive: true,
-        })
-        .returning({ id: codeGroups.id })
-      
-      codeGroupId = newCodeGroup.id
-    } else {
-      codeGroupId = existingCodeGroup[0].id
-    }
-
     const [newDocumentClass] = await db
       .insert(documentClasses)
       .values({
@@ -218,7 +187,7 @@ export async function createDocumentClassCodeGroup(input: {
         code: newCode,
         value: formattedValue,
         description: input.description || "",
-        codeGroupId: codeGroupId,
+        codeGroupId: null, // Code Group 연결 제거
         isActive: true,
       })
       .returning({ id: documentClasses.id })