From 25749225689c3934bc10ad1e8285e13020b61282 Mon Sep 17 00:00:00 2001
From: dujinkim <dujin.kim@dtsolution.co.kr>
Date: Thu, 4 Dec 2025 09:04:09 +0000
Subject: (최겸)구매 입찰, 계약 수정
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

---
 lib/bidding/manage/project-utils.ts | 87 +++++++++++++++++++++++++++++++++++++
 1 file changed, 87 insertions(+)
 create mode 100644 lib/bidding/manage/project-utils.ts

(limited to 'lib/bidding/manage/project-utils.ts')

diff --git a/lib/bidding/manage/project-utils.ts b/lib/bidding/manage/project-utils.ts
new file mode 100644
index 00000000..92744695
--- /dev/null
+++ b/lib/bidding/manage/project-utils.ts
@@ -0,0 +1,87 @@
+'use server'
+
+import db from '@/db/db'
+import { projects } from '@/db/schema'
+import { eq, and, inArray } from 'drizzle-orm'
+
+/**
+ * 프로젝트 ID로 프로젝트 코드 조회
+ */
+export async function getProjectCodeById(projectId: number): Promise<string | null> {
+  try {
+    const result = await db
+      .select({ code: projects.code })
+      .from(projects)
+      .where(eq(projects.id, projectId))
+      .limit(1)
+
+    return result[0]?.code || null
+  } catch (error) {
+    console.error('Failed to get project code by id:', error)
+    return null
+  }
+}
+
+/**
+ * 프로젝트 코드와 이름으로 프로젝트 ID 조회
+ */
+export async function getProjectIdByCodeAndName(
+  projectCode: string,
+  projectName: string
+): Promise<number | null> {
+  try {
+    if (!projectCode || !projectName) {
+      return null
+    }
+
+    const result = await db
+      .select({ id: projects.id })
+      .from(projects)
+      .where(
+        and(
+          eq(projects.code, projectCode.trim()),
+          eq(projects.name, projectName.trim())
+        )
+      )
+      .limit(1)
+
+    return result[0]?.id || null
+  } catch (error) {
+    console.error('Failed to get project id by code and name:', error)
+    return null
+  }
+}
+
+/**
+ * 여러 프로젝트 ID로 프로젝트 코드 맵 조회 (성능 최적화)
+ */
+export async function getProjectCodesByIds(
+  projectIds: number[]
+): Promise<Map<number, string>> {
+  try {
+    if (projectIds.length === 0) {
+      return new Map()
+    }
+
+    const uniqueIds = [...new Set(projectIds.filter(id => id != null))]
+    if (uniqueIds.length === 0) {
+      return new Map()
+    }
+
+    const result = await db
+      .select({ id: projects.id, code: projects.code })
+      .from(projects)
+      .where(inArray(projects.id, uniqueIds))
+
+    const map = new Map<number, string>()
+    result.forEach((project) => {
+      map.set(project.id, project.code)
+    })
+
+    return map
+  } catch (error) {
+    console.error('Failed to get project codes by ids:', error)
+    return new Map()
+  }
+}
+
-- 
cgit v1.2.3