From 11bc8239ad474a8f31c1c73de51f7d0f101594df Mon Sep 17 00:00:00 2001
From: joonhoekim <26rote@gmail.com>
Date: Thu, 25 Sep 2025 09:20:20 +0000
Subject: (고건) 리스크 관리 페이지 내 구매 담당자 조회 로직 수정
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

---
 lib/risk-management/service.ts | 4 +++-
 1 file changed, 3 insertions(+), 1 deletion(-)

(limited to 'lib')

diff --git a/lib/risk-management/service.ts b/lib/risk-management/service.ts
index 62b18060..24826e58 100644
--- a/lib/risk-management/service.ts
+++ b/lib/risk-management/service.ts
@@ -10,6 +10,7 @@ import {
   eq,
   gte,
   ilike,
+  isNotNull,
   lte,
   or,
 } from 'drizzle-orm';
@@ -188,7 +189,8 @@ async function getProcurementManagerList() {
   try {
     return await db.transaction(async (tx) => {
       const managerData = await selectUsers(tx, {
-        where: eq(users.deptName, '구매'), // 추후 수정 필요
+        where: and(eq(users.isActive, true), isNotNull(users.userCode)),
+        orderBy: [asc(users.name)],
       });
 
       return managerData.map((user) => ({
-- 
cgit v1.2.3