(박서영) 설계 document Numbering Rule 개발-최겸 업로드

1 files changed, 368 insertions, 0 deletions

diff --git a/lib/docu-list-rule/combo-box-settings/service.ts b/lib/docu-list-rule/combo-box-settings/service.ts
new file mode 100644
index 00000000..b603ee71
--- /dev/null
+++ b/lib/docu-list-rule/combo-box-settings/service.ts
@@ -0,0 +1,368 @@
+"use server"
+
+import { revalidatePath } from "next/cache"
+import db from "@/db/db"
+import { codeGroups, comboBoxSettings } from "@/db/schema/docu-list-rule"
+import { eq, sql, count } from "drizzle-orm"
+import { unstable_noStore } from "next/cache"
+
+// Control Type이 combobox인 Code Groups 목록 조회
+export async function getComboBoxCodeGroups(input: {
+  page: number
+  perPage: number
+  search?: string
+  sort?: Array<{ id: string; desc: boolean }>
+  filters?: Array<{ id: string; value: string }>
+  joinOperator?: "and" | "or"
+  flags?: string[]
+  groupId?: string
+  description?: string
+  isActive?: string
+}) {
+  unstable_noStore()
+  
+  try {
+    const { page, perPage, sort, search } = input
+    const offset = (page - 1) * perPage
+
+    // Control Type이 combobox인 조건
+    let whereConditions = sql`${codeGroups.controlType} = 'combobox'`
+    
+    // 검색 조건
+    if (search) {
+      const searchTerm = `%${search}%`
+      whereConditions = sql`${whereConditions} AND (
+        ${codeGroups.groupId} ILIKE ${searchTerm} OR
+        ${codeGroups.description} ILIKE ${searchTerm} OR
+        ${codeGroups.codeFormat} ILIKE ${searchTerm}
+      )`
+    }
+
+    // 정렬
+    let orderBy = sql`${codeGroups.createdAt} DESC`
+    if (sort && sort.length > 0) {
+      const sortField = sort[0]
+      const direction = sortField.desc ? sql`DESC` : sql`ASC`
+      
+      switch (sortField.id) {
+        case "groupId":
+          orderBy = sql`${codeGroups.groupId} ${direction}`
+          break
+        case "description":
+          orderBy = sql`${codeGroups.description} ${direction}`
+          break
+        case "codeFormat":
+          orderBy = sql`${codeGroups.codeFormat} ${direction}`
+          break
+        case "controlType":
+          orderBy = sql`${codeGroups.controlType} ${direction}`
+          break
+        case "isActive":
+          orderBy = sql`${codeGroups.isActive} ${direction}`
+          break
+        case "createdAt":
+          orderBy = sql`${codeGroups.createdAt} ${direction}`
+          break
+        default:
+          orderBy = sql`${codeGroups.createdAt} DESC`
+      }
+    }
+
+    // 데이터 조회
+    const data = await db
+      .select({
+        id: codeGroups.id,
+        groupId: codeGroups.groupId,
+        description: codeGroups.description,
+        codeFormat: codeGroups.codeFormat,
+        expressions: codeGroups.expressions,
+        controlType: codeGroups.controlType,
+        isActive: codeGroups.isActive,
+        createdAt: codeGroups.createdAt,
+        updatedAt: codeGroups.updatedAt,
+      })
+      .from(codeGroups)
+      .where(whereConditions)
+      .orderBy(orderBy)
+      .limit(perPage)
+      .offset(offset)
+
+    // 총 개수 조회
+    const [{ count: total }] = await db
+      .select({ count: count() })
+      .from(codeGroups)
+      .where(whereConditions)
+
+    const pageCount = Math.ceil(total / perPage)
+
+    return {
+      success: true,
+      data,
+      pageCount,
+    }
+  } catch (error) {
+    console.error("Error fetching combo box code groups:", error)
+    return {
+      success: false,
+      error: "Failed to fetch combo box code groups",
+      data: [],
+      pageCount: 0,
+    }
+  }
+}
+
+// 특정 Code Group의 Combo Box 옵션 조회
+export async function getComboBoxOptions(codeGroupId: number, input?: {
+  page?: number
+  perPage?: number
+  search?: string
+  sort?: Array<{ id: string; desc: boolean }>
+  filters?: Array<{ id: string; value: string }>
+  joinOperator?: "and" | "or"
+}) {
+  try {
+    const { page = 1, perPage = 10, sort, search } = input || {}
+    const offset = (page - 1) * perPage
+
+    // 기본 조건: codeGroupId
+    let whereConditions = eq(comboBoxSettings.codeGroupId, codeGroupId)
+    
+    // 검색 조건
+    if (search) {
+      const searchTerm = `%${search}%`
+      whereConditions = sql`${whereConditions} AND (
+        ${comboBoxSettings.code} ILIKE ${searchTerm} OR
+        ${comboBoxSettings.description} ILIKE ${searchTerm} OR
+        ${comboBoxSettings.remark} ILIKE ${searchTerm}
+      )`
+    }
+
+    // 정렬
+    let orderBy = sql`${comboBoxSettings.createdAt} DESC`
+    if (sort && sort.length > 0) {
+      const sortField = sort[0]
+      const direction = sortField.desc ? sql`DESC` : sql`ASC`
+      
+      switch (sortField.id) {
+        case "code":
+          orderBy = sql`${comboBoxSettings.code} ${direction}`
+          break
+        case "description":
+          orderBy = sql`${comboBoxSettings.description} ${direction}`
+          break
+        case "remark":
+          orderBy = sql`${comboBoxSettings.remark} ${direction}`
+          break
+        case "createdAt":
+          orderBy = sql`${comboBoxSettings.createdAt} ${direction}`
+          break
+        case "updatedAt":
+          orderBy = sql`${comboBoxSettings.updatedAt} ${direction}`
+          break
+        default:
+          orderBy = sql`${comboBoxSettings.createdAt} DESC`
+      }
+    }
+
+    // 데이터 조회
+    const data = await db
+      .select({
+        id: comboBoxSettings.id,
+        codeGroupId: comboBoxSettings.codeGroupId,
+        code: comboBoxSettings.code,
+        description: comboBoxSettings.description,
+        remark: comboBoxSettings.remark,
+        createdAt: comboBoxSettings.createdAt,
+        updatedAt: comboBoxSettings.updatedAt,
+      })
+      .from(comboBoxSettings)
+      .where(whereConditions)
+      .orderBy(orderBy)
+      .limit(perPage)
+      .offset(offset)
+
+    // 총 개수 조회
+    const [{ count: total }] = await db
+      .select({ count: count() })
+      .from(comboBoxSettings)
+      .where(whereConditions)
+
+    const pageCount = Math.ceil(total / perPage)
+
+    return {
+      success: true,
+      data,
+      pageCount,
+    }
+  } catch (error) {
+    console.error("Error fetching combo box options:", error)
+    return {
+      success: false,
+      error: "Failed to fetch combo box options",
+      data: [],
+      pageCount: 0,
+    }
+  }
+}
+
+// Combo Box 옵션 생성
+export async function createComboBoxOption(input: {
+  codeGroupId: number
+  code: string
+  description: string
+  remark?: string
+}) {
+  try {
+    // 해당 Code Group의 정보 가져오기
+    const codeGroup = await db
+      .select({ description: codeGroups.description })
+      .from(codeGroups)
+      .where(eq(codeGroups.id, input.codeGroupId))
+      .limit(1)
+
+    if (codeGroup.length === 0) {
+      return {
+        success: false,
+        error: "Code Group not found"
+      }
+    }
+
+    const codeGroupDescription = codeGroup[0].description
+
+    // 해당 Code Group의 마지막 옵션 번호 찾기
+    const lastOption = await db
+      .select({ code: comboBoxSettings.code })
+      .from(comboBoxSettings)
+      .where(eq(comboBoxSettings.codeGroupId, input.codeGroupId))
+      .orderBy(sql`CAST(SUBSTRING(${comboBoxSettings.code} FROM ${codeGroupDescription.length + 2}) AS INTEGER) DESC`)
+      .limit(1)
+
+    let nextNumber = 1
+    if (lastOption.length > 0 && lastOption[0].code) {
+      const prefix = `${codeGroupDescription}_`
+      if (lastOption[0].code.startsWith(prefix)) {
+        const lastNumber = parseInt(lastOption[0].code.replace(prefix, ''))
+        if (!isNaN(lastNumber)) {
+          nextNumber = lastNumber + 1
+        }
+      }
+    }
+
+    const newCode = `${codeGroupDescription}_${nextNumber}`
+
+    const [newOption] = await db
+      .insert(comboBoxSettings)
+      .values({
+        codeGroupId: input.codeGroupId,
+        code: newCode,
+        description: input.description,
+        remark: input.remark,
+      })
+      .returning({ id: comboBoxSettings.id })
+
+    revalidatePath("/evcp/docu-list-rule/combo-box-settings")
+    
+    return {
+      success: true,
+      data: newOption,
+      message: "Combo Box option created successfully"
+    }
+  } catch (error) {
+    console.error("Error creating combo box option:", error)
+    return {
+      success: false,
+      error: "Failed to create combo box option"
+    }
+  }
+}
+
+// Combo Box 옵션 수정
+export async function updateComboBoxOption(input: {
+  id: number
+  code: string
+  description: string
+  remark?: string
+}) {
+  try {
+    const [updatedOption] = await db
+      .update(comboBoxSettings)
+      .set({
+        code: input.code,
+        description: input.description,
+        remark: input.remark,
+        updatedAt: new Date(),
+      })
+      .where(eq(comboBoxSettings.id, input.id))
+      .returning({ id: comboBoxSettings.id })
+
+    revalidatePath("/evcp/docu-list-rule/combo-box-settings")
+    
+    return {
+      success: true,
+      data: updatedOption,
+      message: "Combo Box option updated successfully"
+    }
+  } catch (error) {
+    console.error("Error updating combo box option:", error)
+    return {
+      success: false,
+      error: "Failed to update combo box option"
+    }
+  }
+}
+
+// Combo Box 옵션 삭제
+export async function deleteComboBoxOption(id: number) {
+  try {
+    const [deletedOption] = await db
+      .delete(comboBoxSettings)
+      .where(eq(comboBoxSettings.id, id))
+      .returning({ id: comboBoxSettings.id })
+
+    if (!deletedOption) {
+      return {
+        success: false,
+        error: "Option not found"
+      }
+    }
+
+    revalidatePath("/evcp/docu-list-rule/combo-box-settings")
+    
+    return {
+      success: true,
+      message: "Combo Box option deleted successfully"
+    }
+  } catch (error) {
+    console.error("Error deleting combo box option:", error)
+    return {
+      success: false,
+      error: "Failed to delete combo box option"
+    }
+  }
+}
+
+// Code Group의 모든 Combo Box 옵션 삭제
+export async function clearComboBoxOptions(codeGroupId: number) {
+  try {
+    const deletedOptions = await db
+      .delete(comboBoxSettings)
+      .where(eq(comboBoxSettings.codeGroupId, codeGroupId))
+      .returning({ id: comboBoxSettings.id })
+
+    revalidatePath("/evcp/docu-list-rule/combo-box-settings")
+    
+    return {
+      success: true,
+      data: deletedOptions,
+      message: `Cleared ${deletedOptions.length} Combo Box options successfully`
+    }
+  } catch (error) {
+    console.error("Error clearing combo box options:", error)
+    return {
+      success: false,
+      error: "Failed to clear combo box options"
+    }
+  }
+}
+
+ 
\ No newline at end of file