1 files changed, 6 insertions, 9 deletions
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