From 8e70ba35379d21d89704f1095b7fd32bf286525d Mon Sep 17 00:00:00 2001
From: joonhoekim <26rote@gmail.com>
Date: Thu, 2 Oct 2025 14:08:33 +0900
Subject: (김준회) ITB 및 일반견적 선택시 구매담당자 선택을 구매그룹코드로
 처리하도록 변경, 오라클 연결 불가한 경우 하드코딩된 폴백데이터 제공처리
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

---
 lib/users/service.ts | 24 ++++++++++++++++++++++++
 1 file changed, 24 insertions(+)

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

diff --git a/lib/users/service.ts b/lib/users/service.ts
index 96bc4719..bca28a16 100644
--- a/lib/users/service.ts
+++ b/lib/users/service.ts
@@ -1106,3 +1106,27 @@ export async function searchUsersForSelector(
   }
 }
 
+/**
+ * 사번으로 사용자 조회
+ */
+export async function getUserByEmployeeNumber(employeeNumber: string) {
+  try {
+
+    if(!employeeNumber) {
+      throw new Error(
+        '사번으로 유저 정보 반환 함수(getUserByEmployeeNumber): 받은 사번이 없음.'
+      );
+    }
+
+    const user = await db
+      .select()
+      .from(users)
+      .where(eq(users.employeeNumber, employeeNumber))
+      .limit(1)
+
+    return user[0]
+  }
+  catch (error) {
+    console.error("사용자 조회 오류:", error)
+  }
+}
\ No newline at end of file
-- 
cgit v1.2.3