diff options
| author | joonhoekim <26rote@gmail.com> | 2025-09-22 12:42:44 +0900 |
|---|---|---|
| committer | joonhoekim <26rote@gmail.com> | 2025-09-22 12:42:44 +0900 |
| commit | 92b8d91b5879ca91e3f5b96f0f7115e1e2b79d83 (patch) | |
| tree | 7ee0ed85d533d6b976dd53cd2c882b391fea9d6d | |
| parent | bd3df05b4bdc07cef1bd79cf23c08a757e9ee6eb (diff) | |
(김준회) 프로젝트 수신시 타입 이름 겹치는 문제 처리
| -rw-r--r-- | db/schema/projects.ts | 2 | ||||
| -rw-r--r-- | lib/soap/mdg/mapper/project-mapper.ts | 4 |
2 files changed, 3 insertions, 3 deletions
diff --git a/db/schema/projects.ts b/db/schema/projects.ts index 81f4043b..30bc60b6 100644 --- a/db/schema/projects.ts +++ b/db/schema/projects.ts @@ -82,7 +82,7 @@ export const projects = pgTable("projects", { STDT: varchar("STDT", { length: 1000 }), // 시작일자 SYS_ACOT_CLSD_DT: varchar("SYS_ACOT_CLSD_DT", { length: 1000 }), // 시스템회계마감일자 TOT_CNRT_CNT: varchar("TOT_CNRT_CNT", { length: 1000 }), // 전체 계약 대수 - TYPE: varchar("TYPE", { length: 1000 }), // 프로젝트 Top/Hull (원본 TYPE 컬럼) + TYPE_MDG: varchar("TYPE_MDG", { length: 1000 }), // 프로젝트 Top/Hull (원본 TYPE 컬럼) WP_PROJ_TP: varchar("WP_PROJ_TP", { length: 1000 }), // (풍력)프로젝트타입 createdAt: timestamp("created_at").defaultNow().notNull(), diff --git a/lib/soap/mdg/mapper/project-mapper.ts b/lib/soap/mdg/mapper/project-mapper.ts index de189047..a4000bc0 100644 --- a/lib/soap/mdg/mapper/project-mapper.ts +++ b/lib/soap/mdg/mapper/project-mapper.ts @@ -171,7 +171,7 @@ function mapMDGToProject(mdgProject: MDGProjectData): ProjectData | null { STDT: mdgProject.STDT || null, SYS_ACOT_CLSD_DT: mdgProject.SYS_ACOT_CLSD_DT || null, TOT_CNRT_CNT: mdgProject.TOT_CNRT_CNT || null, - TYPE: mdgProject.TYPE || null, // 원본 TYPE 컬럼 + TYPE_MDG: mdgProject.TYPE || null, // 원본 TYPE 컬럼 WP_PROJ_TP: mdgProject.WP_PROJ_TP || null, // id, createdAt, updatedAt는 자동 생성 @@ -293,7 +293,7 @@ async function saveProjectsToDatabase(mappedProjects: ProjectData[]): Promise<vo STDT: project.STDT, SYS_ACOT_CLSD_DT: project.SYS_ACOT_CLSD_DT, TOT_CNRT_CNT: project.TOT_CNRT_CNT, - TYPE: project.TYPE, + TYPE_MDG: project.TYPE_MDG, WP_PROJ_TP: project.WP_PROJ_TP, updatedAt: new Date(), }) |