(박서영) docu-list-rule detail sheet 컴포넌트 추가 및 검색 필터 기능 오류 수정

1 files changed, 2 insertions, 8 deletions

diff --git a/lib/docu-list-rule/code-groups/service.ts b/lib/docu-list-rule/code-groups/service.ts
index 2c30cedb..c99588a5 100644
--- a/lib/docu-list-rule/code-groups/service.ts
+++ b/lib/docu-list-rule/code-groups/service.ts
@@ -2,7 +2,7 @@
 
 import { revalidatePath } from "next/cache"
 import db from "@/db/db"
-import { codeGroups, comboBoxSettings, documentClasses } from "@/db/schema/docu-list-rule"
+import { codeGroups, comboBoxSettings } from "@/db/schema/docu-list-rule"
 import { eq, sql, count } from "drizzle-orm"
 import { unstable_noStore } from "next/cache"
 
@@ -64,7 +64,7 @@ export async function getCodeGroups(input: any) {
     }
 
     // 정렬 (안전한 필드 체크 적용)
-    let orderBy = sql`${codeGroups.createdAt} DESC`
+    let orderBy = sql`${codeGroups.groupId} ASC`
     if (input.sort && input.sort.length > 0) {
       const sortField = input.sort[0]
       // 안전성 체크: 필드가 실제 테이블에 존재하는지 확인
@@ -241,11 +241,6 @@ export async function deleteCodeGroup(id: number) {
         .where(eq(comboBoxSettings.codeGroupId, id))
     }
 
-    // Document Class가 연결된 경우 Document Class도 삭제
-    await db
-      .delete(documentClasses)
-      .where(eq(documentClasses.codeGroupId, id))
-
     // Code Group 삭제
     await db
       .delete(codeGroups)
@@ -253,7 +248,6 @@ export async function deleteCodeGroup(id: number) {
 
     revalidatePath("/evcp/docu-list-rule/code-groups")
     revalidatePath("/evcp/docu-list-rule/combo-box-settings")
-    revalidatePath("/evcp/docu-list-rule/document-class")
     
     return {
       success: true,