diff options
| author | joonhoekim <26rote@gmail.com> | 2025-09-25 09:20:20 +0000 |
|---|---|---|
| committer | joonhoekim <26rote@gmail.com> | 2025-09-25 09:20:20 +0000 |
| commit | 11bc8239ad474a8f31c1c73de51f7d0f101594df (patch) | |
| tree | 7e77a5808b8229ba1d7d85ce67350dae92070410 /lib/risk-management | |
| parent | d6d3bbc55a557acde7d1f07c3bd4813e367d4e86 (diff) | |
(고건) 리스크 관리 페이지 내 구매 담당자 조회 로직 수정
Diffstat (limited to 'lib/risk-management')
| -rw-r--r-- | lib/risk-management/service.ts | 4 |
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) => ({
|