(고건) 리스크 관리 페이지 내 구매 담당자 조회 로직 수정

1 files changed, 3 insertions, 1 deletions

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) => ({