From 7cdedf2cf8e807eeea9134888dc9bd1586978ea8 Mon Sep 17 00:00:00 2001 From: 0-Zz-ang Date: Fri, 8 Aug 2025 17:15:22 +0900 Subject: (박서영)combo box 옵션 및 number type config Add에러 수정 MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit --- lib/docu-list-rule/combo-box-settings/service.ts | 18 ++++--- .../table/combo-box-options-add-dialog.tsx | 6 ++- .../table/combo-box-options-detail-sheet.tsx | 4 ++ lib/docu-list-rule/number-type-configs/service.ts | 55 +++++++++++++++++++--- 4 files changed, 70 insertions(+), 13 deletions(-) (limited to 'lib/docu-list-rule') diff --git a/lib/docu-list-rule/combo-box-settings/service.ts b/lib/docu-list-rule/combo-box-settings/service.ts index 96daefe4..7a003327 100644 --- a/lib/docu-list-rule/combo-box-settings/service.ts +++ b/lib/docu-list-rule/combo-box-settings/service.ts @@ -4,7 +4,7 @@ import { revalidatePath } from "next/cache" import db from "@/db/db" import { codeGroups, comboBoxSettings } from "@/db/schema/docu-list-rule" import { projects } from "@/db/schema/projects" -import { eq, sql, count } from "drizzle-orm" +import { eq, sql } from "drizzle-orm" import { unstable_noStore } from "next/cache" // Control Type이 combobox인 Code Groups 목록 조회 @@ -153,7 +153,7 @@ export async function getComboBoxOptions(codeGroupId: number, input?: { const { page = 1, perPage = 10, sort, search } = input || {} const offset = (page - 1) * perPage - // 기본 조건: codeGroupId + // 기본 조건: codeGroupId만으로 조회 (projectId는 codeGroups를 통해 간접 참조) let whereConditions = eq(comboBoxSettings.codeGroupId, codeGroupId) // 검색 조건 @@ -195,12 +195,12 @@ export async function getComboBoxOptions(codeGroupId: number, input?: { remark: comboBoxSettings.remark, createdAt: comboBoxSettings.createdAt, updatedAt: comboBoxSettings.updatedAt, - projectId: comboBoxSettings.projectId, projectCode: projects.code, projectName: projects.name, }) .from(comboBoxSettings) - .leftJoin(projects, eq(comboBoxSettings.projectId, projects.id)) + .leftJoin(codeGroups, eq(comboBoxSettings.codeGroupId, codeGroups.id)) + .leftJoin(projects, eq(codeGroups.projectId, projects.id)) .where(whereConditions) .orderBy(orderBy) .limit(perPage) @@ -210,12 +210,14 @@ export async function getComboBoxOptions(codeGroupId: number, input?: { const totalCountResult = await db .select({ count: sql`count(*)` }) .from(comboBoxSettings) - .leftJoin(projects, eq(comboBoxSettings.projectId, projects.id)) + .leftJoin(codeGroups, eq(comboBoxSettings.codeGroupId, codeGroups.id)) + .leftJoin(projects, eq(codeGroups.projectId, projects.id)) .where(whereConditions) const totalCount = totalCountResult[0]?.count || 0 return { + success: true, data, totalCount, pageCount: Math.ceil(totalCount / perPage), @@ -223,9 +225,11 @@ export async function getComboBoxOptions(codeGroupId: number, input?: { } catch (error) { console.error("Error fetching combo box options:", error) return { + success: false, data: [], totalCount: 0, pageCount: 0, + error: "Failed to fetch combo box options" } } } @@ -240,7 +244,9 @@ export async function createComboBoxOption(input: { try { // 해당 Code Group의 정보 가져오기 const codeGroup = await db - .select({ description: codeGroups.description }) + .select({ + description: codeGroups.description + }) .from(codeGroups) .where(eq(codeGroups.id, input.codeGroupId)) .limit(1) diff --git a/lib/docu-list-rule/combo-box-settings/table/combo-box-options-add-dialog.tsx b/lib/docu-list-rule/combo-box-settings/table/combo-box-options-add-dialog.tsx index a0535b43..9a3f8a86 100644 --- a/lib/docu-list-rule/combo-box-settings/table/combo-box-options-add-dialog.tsx +++ b/lib/docu-list-rule/combo-box-settings/table/combo-box-options-add-dialog.tsx @@ -59,6 +59,7 @@ export function ComboBoxOptionsAddDialog({ codeGroupId, onSuccess }: ComboBoxOpt const handleCodeChange = (value: string) => { form.setValue("code", value) form.setValue("description", value) // 코드값을 description에도 자동 설정 + form.trigger() // 폼 유효성 검사 트리거 } const handleSubmit = (data: CreateOptionSchema) => { @@ -155,7 +156,10 @@ export function ComboBoxOptionsAddDialog({ codeGroupId, onSuccess }: ComboBoxOpt - diff --git a/lib/docu-list-rule/combo-box-settings/table/combo-box-options-detail-sheet.tsx b/lib/docu-list-rule/combo-box-settings/table/combo-box-options-detail-sheet.tsx index 22806ae8..286acfbf 100644 --- a/lib/docu-list-rule/combo-box-settings/table/combo-box-options-detail-sheet.tsx +++ b/lib/docu-list-rule/combo-box-settings/table/combo-box-options-detail-sheet.tsx @@ -61,16 +61,20 @@ export function ComboBoxOptionsDetailSheet({ filters: [], joinOperator: "and", }) + console.log("getComboBoxOptions result:", result) if (result.success && result.data) { // isActive 필드가 없는 경우 기본값 true로 설정 const optionsWithIsActive = result.data.map(option => ({ ...option, isActive: (option as any).isActive ?? true })) + console.log("Processed data:", optionsWithIsActive) setRawData({ data: optionsWithIsActive, pageCount: result.pageCount || 1 }) + } else { + console.log("No data or error:", result) } } catch (error) { console.error("Error refreshing data:", error) diff --git a/lib/docu-list-rule/number-type-configs/service.ts b/lib/docu-list-rule/number-type-configs/service.ts index ef25aecb..14cfc2f0 100644 --- a/lib/docu-list-rule/number-type-configs/service.ts +++ b/lib/docu-list-rule/number-type-configs/service.ts @@ -3,7 +3,7 @@ import { revalidatePath } from "next/cache" import db from "@/db/db" import { unstable_noStore } from "next/cache" -import { documentNumberTypeConfigs, codeGroups } from "@/db/schema/docu-list-rule" +import { documentNumberTypeConfigs, codeGroups, documentNumberTypes } from "@/db/schema/docu-list-rule" import { projects } from "@/db/schema/projects" import { asc, eq, sql, and } from "drizzle-orm" import { GetNumberTypeConfigsSchema } from "./validation" @@ -122,13 +122,12 @@ export async function getNumberTypeConfigs(input: GetNumberTypeConfigsSchema) { updatedAt: documentNumberTypeConfigs.updatedAt, codeGroupName: codeGroups.description, codeGroupControlType: codeGroups.controlType, - projectId: documentNumberTypeConfigs.projectId, projectCode: projects.code, projectName: projects.name, }) .from(documentNumberTypeConfigs) .leftJoin(codeGroups, eq(documentNumberTypeConfigs.codeGroupId, codeGroups.id)) - .leftJoin(projects, eq(documentNumberTypeConfigs.projectId, projects.id)) + .leftJoin(projects, eq(codeGroups.projectId, projects.id)) .where(whereConditions) .orderBy(orderBy) .limit(perPage) @@ -139,7 +138,7 @@ export async function getNumberTypeConfigs(input: GetNumberTypeConfigsSchema) { .select({ count: sql`count(*)` }) .from(documentNumberTypeConfigs) .leftJoin(codeGroups, eq(documentNumberTypeConfigs.codeGroupId, codeGroups.id)) - .leftJoin(projects, eq(documentNumberTypeConfigs.projectId, projects.id)) + .leftJoin(projects, eq(codeGroups.projectId, projects.id)) .where(whereConditions) const totalCount = totalCountResult[0]?.count || 0 @@ -166,9 +165,24 @@ export async function createNumberTypeConfig(input: { sdq: number description?: string remark?: string - projectId: number }) { try { + // 중복 체크: 같은 documentNumberTypeId와 sdq 조합이 이미 존재하는지 확인 + const existingConfig = await db + .select({ id: documentNumberTypeConfigs.id }) + .from(documentNumberTypeConfigs) + .where( + sql`${documentNumberTypeConfigs.documentNumberTypeId} = ${input.documentNumberTypeId} AND ${documentNumberTypeConfigs.sdq} = ${input.sdq}` + ) + .limit(1) + + if (existingConfig.length > 0) { + return { + success: false, + error: "이미 존재하는 순서 번호입니다." + } + } + const [result] = await db .insert(documentNumberTypeConfigs) .values({ @@ -177,7 +191,6 @@ export async function createNumberTypeConfig(input: { sdq: input.sdq, description: input.description, remark: input.remark, - projectId: input.projectId, }) .returning({ id: documentNumberTypeConfigs.id }) @@ -206,6 +219,36 @@ export async function updateNumberTypeConfig(input: { remark?: string }) { try { + // 현재 수정 중인 항목의 documentNumberTypeId 가져오기 + const currentConfig = await db + .select({ documentNumberTypeId: documentNumberTypeConfigs.documentNumberTypeId }) + .from(documentNumberTypeConfigs) + .where(eq(documentNumberTypeConfigs.id, input.id)) + .limit(1) + + if (currentConfig.length === 0) { + return { + success: false, + error: "Config not found" + } + } + + // 중복 체크: 같은 documentNumberTypeId와 sdq 조합이 이미 존재하는지 확인 (현재 수정 중인 항목 제외) + const existingConfig = await db + .select({ id: documentNumberTypeConfigs.id }) + .from(documentNumberTypeConfigs) + .where( + sql`${documentNumberTypeConfigs.documentNumberTypeId} = ${currentConfig[0].documentNumberTypeId} AND ${documentNumberTypeConfigs.sdq} = ${input.sdq} AND ${documentNumberTypeConfigs.id} != ${input.id}` + ) + .limit(1) + + if (existingConfig.length > 0) { + return { + success: false, + error: "이미 존재하는 순서 번호입니다." + } + } + const [result] = await db .update(documentNumberTypeConfigs) .set({ -- cgit v1.2.3