From f02773ab37bd911b1f3a81a93a7d5aaffd04bcad Mon Sep 17 00:00:00 2001
From: joonhoekim <26rote@gmail.com>
Date: Tue, 30 Sep 2025 19:50:09 +0900
Subject: (김준회) 스테이지 선택 로직 오류 수정 및 스크롤 처리
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

---
 lib/projects/service.ts | 15 ++++++---------
 1 file changed, 6 insertions(+), 9 deletions(-)

(limited to 'lib/projects')

diff --git a/lib/projects/service.ts b/lib/projects/service.ts
index 4685fce4..aad1856e 100644
--- a/lib/projects/service.ts
+++ b/lib/projects/service.ts
@@ -121,16 +121,13 @@ export async function getAllProjectInfoByProjectCode(projectCode: string) {
  */
 export async function getProjectCode(projectId: number): Promise<string | null> {
   try {
-    const project = await db.project.findUnique({
-      where: {
-        id: projectId,
-      },
-      select: {
-        code: true,
-      },
-    })
+    const project = await db
+      .select({ code: projects.code })
+      .from(projects)
+      .where(eq(projects.id, projectId))
+      .limit(1);
 
-    return project?.code || null
+    return project[0]?.code || null;
   } catch (error) {
     console.error("Error fetching project code:", error)
     return null
-- 
cgit v1.2.3