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