(김준회) Document Numbering Rule(해양): DOC_CLASS 1글자로 제한 (SWP측 제약), DOC_CLASS에서 코드 컬럼 제거

5 files changed, 47 insertions, 28 deletions

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,
diff --git a/lib/docu-list-rule/document-class/table/document-class-add-dialog.tsx b/lib/docu-list-rule/document-class/table/document-class-add-dialog.tsx
index 6e8ac686..471f2089 100644
--- a/lib/docu-list-rule/document-class/table/document-class-add-dialog.tsx
+++ b/lib/docu-list-rule/document-class/table/document-class-add-dialog.tsx
@@ -129,7 +129,7 @@ export function DocumentClassAddDialog({
                     />
                   </FormControl>
                   <div className="text-xs text-muted-foreground mt-1">
-                    💡 대문자 알파벳 또는 숫자 1자리 (A, B, 0, 1 등) - API DOC_CLASS로 전송됩니다
+                    대문자 알파벳 1자리 또는 숫자 1자리 (A, B, 0, 1 등)
                   </div>
                   <FormMessage />
                 </FormItem>
diff --git a/lib/docu-list-rule/document-class/table/document-class-edit-sheet.tsx b/lib/docu-list-rule/document-class/table/document-class-edit-sheet.tsx
index 32c1976d..03bded67 100644
--- a/lib/docu-list-rule/document-class/table/document-class-edit-sheet.tsx
+++ b/lib/docu-list-rule/document-class/table/document-class-edit-sheet.tsx
@@ -31,7 +31,10 @@ import { updateDocumentClassCodeGroup } from "@/lib/docu-list-rule/document-clas
 import { documentClasses } from "@/db/schema/docu-list-rule"
 
 const updateDocumentClassSchema = z.object({
-  value: z.string().min(1, "Value는 필수입니다."),
+  value: z.string()
+    .min(1, "Value는 필수입니다.")
+    .max(1, "Value는 1자리만 입력 가능합니다. (예: A, B, 0, 1)")
+    .regex(/^[A-Z0-9]$/, "대문자 알파벳 또는 숫자 1자리만 입력 가능합니다. (예: A, B, 0, 1)"),
   description: z.string().optional(),
 })
 
@@ -111,10 +114,19 @@ export function DocumentClassEditSheet({
               name="value"
               render={({ field }) => (
                 <FormItem>
-                  <FormLabel>Value</FormLabel>
+                  <FormLabel>Value *</FormLabel>
                   <FormControl>
-                    <Input placeholder="예: A Class" {...field} />
+                    <Input 
+                      {...field} 
+                      placeholder="예: A" 
+                      maxLength={1}
+                      className="uppercase"
+                      onChange={(e) => field.onChange(e.target.value.toUpperCase())}
+                    />
                   </FormControl>
+                  <div className="text-xs text-muted-foreground mt-1">
+                    대문자 알파벳 1자리 또는 숫자 1자리 (A, B, 0, 1 등)
+                  </div>
                   <FormMessage />
                 </FormItem>
               )}
@@ -126,8 +138,11 @@ export function DocumentClassEditSheet({
                 <FormItem>
                   <FormLabel>Description</FormLabel>
                   <FormControl>
-                    <Input placeholder="예: Document Class_1 (선택사항)" {...field} />
+                    <Input placeholder="예: General Documents (선택사항)" {...field} />
                   </FormControl>
+                  <div className="text-xs text-muted-foreground mt-1">
+                    선택사항: Document Class에 대한 추가 설명
+                  </div>
                   <FormMessage />
                 </FormItem>
               )}
diff --git a/lib/docu-list-rule/document-class/table/document-class-table-columns.tsx b/lib/docu-list-rule/document-class/table/document-class-table-columns.tsx
index 9d8d91e0..6b4a882f 100644
--- a/lib/docu-list-rule/document-class/table/document-class-table-columns.tsx
+++ b/lib/docu-list-rule/document-class/table/document-class-table-columns.tsx
@@ -110,35 +110,44 @@ export function getColumns({ setRowAction, onDetail }: GetColumnsProps): ColumnD
       accessorKey: "value",
       enableResizing: true,
       header: ({ column }) => (
-        <DataTableColumnHeaderSimple column={column} title="클래스" />
+        <DataTableColumnHeaderSimple column={column} title="DOC_CLASS" />
       ),
       meta: {
-        excelHeader: "클래스",
+        excelHeader: "DOC_CLASS",
         type: "text",
       },
       cell: ({ row }) => {
         const value = row.getValue("value") as string
+        return <span className="">{value}</span>
+      },
+      minSize: 80
+    },
+
+    {
+      accessorKey: "description",
+      enableResizing: true,
+      header: ({ column }) => (
+        <DataTableColumnHeaderSimple column={column} title="Description" />
+      ),
+      meta: {
+        excelHeader: "Description",
+        type: "text",
+      },
+      cell: ({ row }) => {
         const description = row.getValue("description") as string
-        return (
-          <div className="flex items-center gap-2">
-            <span className="font-mono font-bold text-lg">{value}</span>
-            {description && (
-              <span className="text-muted-foreground text-sm">- {description}</span>
-            )}
-          </div>
-        )
+        return <span>{description || "-"}</span>
       },
-      minSize: 250
+      minSize: 200
     },
 
     {
       accessorKey: "createdAt",
       enableResizing: true,
       header: ({ column }) => (
-        <DataTableColumnHeaderSimple column={column} title="생성일" />
+        <DataTableColumnHeaderSimple column={column} title="createdAt" />
       ),
       meta: {
-        excelHeader: "생성일",
+        excelHeader: "createdAt",
         type: "date",
       },
       cell: ({ row }) => {
diff --git a/lib/docu-list-rule/document-class/table/document-class-table.tsx b/lib/docu-list-rule/document-class/table/document-class-table.tsx
index 11ec3a3c..771e95ab 100644
--- a/lib/docu-list-rule/document-class/table/document-class-table.tsx
+++ b/lib/docu-list-rule/document-class/table/document-class-table.tsx
@@ -38,10 +38,9 @@ export function DocumentClassTable({ promises }: DocumentClassTableProps) {
 
   // 고급 필터 필드 설정
   const advancedFilterFields: DataTableAdvancedFilterField<typeof documentClasses.$inferSelect>[] = [
-    { id: "code", label: "코드", type: "text" },
-    { id: "value", label: "값", type: "text" },
-    { id: "description", label: "설명", type: "text" },
-    { id: "createdAt", label: "생성일", type: "date" },
+    { id: "value", label: "DOC_CLASS", type: "text" },
+    { id: "description", label: "Description", type: "text" },
+    { id: "createdAt", label: "createdAt", type: "date" },
   ]
 
   const { table } = useDataTable({