From 75249e6fa46864f49d4eb91bd755171b6b65eaae Mon Sep 17 00:00:00 2001
From: joonhoekim <26rote@gmail.com>
Date: Mon, 28 Jul 2025 12:10:39 +0000
Subject: (김준회) 공통모듈 - Knox 결재 모듈 구현, 유저 선택기 구현, 상신 결재
 저장을 위한 DB 스키마 및 서비스 추가, spreadjs 라이센스 환경변수 통일, 유저
 테이블에 epId 컬럼 추가
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

---
 lib/knox-sync/employee-sync-service.ts | 3 +++
 lib/knox-sync/master-sync-service.ts   | 2 +-
 2 files changed, 4 insertions(+), 1 deletion(-)

(limited to 'lib/knox-sync')

diff --git a/lib/knox-sync/employee-sync-service.ts b/lib/knox-sync/employee-sync-service.ts
index 3e8b048e..b7f2a323 100644
--- a/lib/knox-sync/employee-sync-service.ts
+++ b/lib/knox-sync/employee-sync-service.ts
@@ -198,6 +198,7 @@ async function syncEmployeesToUsers(): Promise<void> {
         departmentCode: employeeTable.departmentCode,
         departmentName: employeeTable.departmentName,
         companyCode: employeeTable.companyCode,
+        epId: employeeTable.epId,
       })
       .from(employeeTable)
       .where(
@@ -271,6 +272,7 @@ async function syncEmployeesToUsers(): Promise<void> {
               deptCode: employee.departmentCode,
               deptName: employee.departmentName,
               domain: assignedDomain as UserDomainType,
+              epId: employee.epId,
               updatedAt: new Date(),
             })
             .where(eq(users.id, existingUsers[0].id));
@@ -295,6 +297,7 @@ async function syncEmployeesToUsers(): Promise<void> {
                 deptCode: employee.departmentCode,
                 deptName: employee.departmentName,
                 domain: assignedDomain as UserDomainType,
+                epId: employee.epId,
               });
             
             insertCount++;
diff --git a/lib/knox-sync/master-sync-service.ts b/lib/knox-sync/master-sync-service.ts
index 5cabe9ed..ed77a3fd 100644
--- a/lib/knox-sync/master-sync-service.ts
+++ b/lib/knox-sync/master-sync-service.ts
@@ -67,6 +67,6 @@ export async function startKnoxMasterSyncScheduler() {
     syncAllKnoxData().catch(console.error);
   });
 
+  // 직급 정보 기반으로, 각 직급마다 임직원 조회 (Knox API 구조상 제한으로 직급 및 부서마다 조회 가능하며, 직급이 수가 더 적음(600 vs 2400))
   logSchedulerInfo('통합(직급→조직→임직원)', CRON_STRING);
-  console.log('[KNOX-SYNC] 💡 순차 실행으로 의존성 문제 해결 (직급 완료 → 조직 완료 → 임직원 완료)');
 } 
\ No newline at end of file
-- 
cgit v1.2.3