From 59b5715ebb3e1fd7bd4eb02ce50399715734f865 Mon Sep 17 00:00:00 2001 From: 0-Zz-ang Date: Mon, 4 Aug 2025 14:59:15 +0900 Subject: (박서영) docu-list-rule detail sheet 컴포넌트 추가 및 검색 필터 기능 오류 수정 MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit --- lib/docu-list-rule/code-groups/service.ts | 10 ++-------- 1 file changed, 2 insertions(+), 8 deletions(-) (limited to 'lib/docu-list-rule/code-groups/service.ts') 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, -- cgit v1.2.3