diff options
| author | dujinkim <dujin.kim@dtsolution.co.kr> | 2025-10-01 06:27:55 +0000 |
|---|---|---|
| committer | dujinkim <dujin.kim@dtsolution.co.kr> | 2025-10-01 06:27:55 +0000 |
| commit | b4e80d7fe2e2873b5af551947a0e323f4bf357e4 (patch) | |
| tree | 6990af37f16cb21e6fcb2f22e9d02f140059efca /lib/evaluation-target-list/service.ts | |
| parent | d689608ca2a54cab2cd12a12f0b6007a1be39ab2 (diff) | |
(최겸) 구메 정기평가 수정, menuconfig tbe 주석처리
Diffstat (limited to 'lib/evaluation-target-list/service.ts')
| -rw-r--r-- | lib/evaluation-target-list/service.ts | 5 |
1 files changed, 4 insertions, 1 deletions
diff --git a/lib/evaluation-target-list/service.ts b/lib/evaluation-target-list/service.ts index 572a9006..00d0d294 100644 --- a/lib/evaluation-target-list/service.ts +++ b/lib/evaluation-target-list/service.ts @@ -13,6 +13,7 @@ import { isNotNull, lte, or, + ne, sql, type SQL, } from 'drizzle-orm'; @@ -686,8 +687,10 @@ export async function getAvailableReviewers(departmentCode?: string) { // departmentName: "API로 추후", // ✅ 부서명도 반환 }) .from(users) + .where(ne(users.domain, "partners")) .orderBy(users.name) // .limit(100); + //partners가 아닌 domain에 따라서 필터링 return reviewers; } catch (error) { @@ -1857,7 +1860,7 @@ export async function importEvalTargetExcel(file: File): Promise<{ const { userList } = await db.transaction(async (tx) => { const selectRes = await selectUsers(tx, { - where: and(eq(users.email, managerEmail), eq(users.isActive, true), isNotNull(users.userCode)), + where: and(eq(users.email, managerEmail), eq(users.isActive, true), ne(users.domain, "partners")), orderBy: [asc(users.name)], }); |
