From 519d01ed0a2e40c353d0afcccd4b7a83483f7eaf Mon Sep 17 00:00:00 2001
From: joonhoekim <26rote@gmail.com>
Date: Wed, 12 Nov 2025 18:58:10 +0900
Subject: (김준회) Document Numbering Rule(해양): DOC_CLASS 1글자로 제한 (SWP측
 제약), DOC_CLASS에서 코드 컬럼 제거
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

---
 lib/docu-list-rule/document-class/service.ts | 8 ++------
 1 file changed, 2 insertions(+), 6 deletions(-)

(limited to 'lib/docu-list-rule/document-class/service.ts')

diff --git a/lib/docu-list-rule/document-class/service.ts b/lib/docu-list-rule/document-class/service.ts
index 9d3ff23a..0dc4a4f4 100644
--- a/lib/docu-list-rule/document-class/service.ts
+++ b/lib/docu-list-rule/document-class/service.ts
@@ -4,7 +4,7 @@ import { revalidatePath } from "next/cache"
 import db from "@/db/db"
 import { documentClasses, documentClassOptions, codeGroups } from "@/db/schema/docu-list-rule"
 import { projects } from "@/db/schema/projects"
-import { eq, desc, sql, and } from "drizzle-orm"
+import { eq, sql, and } from "drizzle-orm"
 
 // Document Class 목록 조회 (A Class, B Class 등)
 export async function getDocumentClassCodeGroups(input: {
@@ -36,7 +36,6 @@ export async function getDocumentClassCodeGroups(input: {
     if (search) {
       const searchTerm = `%${search}%`
       whereConditions = sql`${whereConditions} AND (
-        ${documentClasses.code} ILIKE ${searchTerm} OR
         ${documentClasses.value} ILIKE ${searchTerm} OR
         ${documentClasses.description} ILIKE ${searchTerm} OR
         ${projects.code} ILIKE ${searchTerm}
@@ -50,8 +49,6 @@ export async function getDocumentClassCodeGroups(input: {
         if (!value) return null
         
         switch (id) {
-          case "code":
-            return sql`${documentClasses.code} ILIKE ${`%${value}%`}`
           case "value":
             return sql`${documentClasses.value} ILIKE ${`%${value}%`}`
           case "description":
@@ -79,7 +76,7 @@ export async function getDocumentClassCodeGroups(input: {
     }
 
     // 정렬 (안전한 필드 체크 적용)
-    let orderBy = sql`${documentClasses.code} ASC`
+    let orderBy = sql`${documentClasses.value} ASC`
     if (sort && sort.length > 0) {
       const sortField = sort[0]
       // 안전성 체크: 필드가 실제 테이블에 존재하는지 확인
@@ -100,7 +97,6 @@ export async function getDocumentClassCodeGroups(input: {
     const data = await db
       .select({
         id: documentClasses.id,
-        code: documentClasses.code,
         value: documentClasses.value,
         description: documentClasses.description,
         isActive: documentClasses.isActive,
-- 
cgit v1.2.3