From b9a2081a76e669688d5884f20482b37cc8acca22 Mon Sep 17 00:00:00 2001
From: dujinkim <dujin.kim@dtsolution.co.kr>
Date: Mon, 13 Oct 2025 08:56:27 +0000
Subject: (최겸, 임수민) 구매 입찰, 견적(그룹코드, tbe에러) 수정, data-room
 수정
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

---
 lib/bidding/service.ts | 16 ++++++++++++++++
 1 file changed, 16 insertions(+)

(limited to 'lib/bidding/service.ts')

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'
-- 
cgit v1.2.3