diff options
Diffstat (limited to 'lib/soap/ecc/mapper/common-mapper-utils.ts')
| -rw-r--r-- | lib/soap/ecc/mapper/common-mapper-utils.ts | 7 |
1 files changed, 5 insertions, 2 deletions
diff --git a/lib/soap/ecc/mapper/common-mapper-utils.ts b/lib/soap/ecc/mapper/common-mapper-utils.ts index 526decb5..8558f058 100644 --- a/lib/soap/ecc/mapper/common-mapper-utils.ts +++ b/lib/soap/ecc/mapper/common-mapper-utils.ts @@ -24,11 +24,12 @@ import { eq } from 'drizzle-orm'; export async function findUserInfoByEKGRP(EKGRP: string | null): Promise<{ userId: number; userName: string; + userEmail: string | null; userPhone: string | null; } | null> { try { debugLog('담당자 찾기 시작', { EKGRP }); - + if (!EKGRP) { debugError('EKGRP가 null 또는 undefined', { EKGRP }); return null; @@ -36,9 +37,10 @@ export async function findUserInfoByEKGRP(EKGRP: string | null): Promise<{ // users 테이블에서 userCode로 직접 조회 const userResult = await db - .select({ + .select({ id: users.id, name: users.name, + email: users.email, phone: users.phone }) .from(users) @@ -53,6 +55,7 @@ export async function findUserInfoByEKGRP(EKGRP: string | null): Promise<{ const userInfo = { userId: userResult[0].id, userName: userResult[0].name, + userEmail: userResult[0].email, userPhone: userResult[0].phone }; debugSuccess('담당자 찾음', { EKGRP, userInfo }); |
