1 files changed, 16 insertions, 0 deletions
diff --git a/lib/bidding/service.ts b/lib/bidding/service.ts
index 8cbe2a2b..5ab18ef1 100644
--- a/lib/bidding/service.ts
+++ b/lib/bidding/service.ts
@@ -31,6 +31,22 @@ import {
     like,
     notInArray
 } from 'drizzle-orm'
+
+// 사용자 이메일로 사용자 코드 조회
+export async function getUserCodeByEmail(email: string): Promise<string | null> {
+  try {
+    const user = await db
+      .select({ userCode: users.userCode })
+      .from(users)
+      .where(and(eq(users.email, email), eq(users.isActive, true)))
+      .limit(1)
+
+    return user[0]?.userCode || null
+  } catch (error) {
+    console.error('Failed to get user code by email:', error)
+    return null
+  }
+}
 import { revalidatePath } from 'next/cache'
 import { filterColumns } from '@/lib/filter-columns'
 import { CreateBiddingSchema, GetBiddingsSchema, UpdateBiddingSchema } from './validation'