From bf2db28586569499e44b58999f2e0f33ed4cdeb5 Mon Sep 17 00:00:00 2001 From: joonhoekim <26rote@gmail.com> Date: Wed, 24 Sep 2025 17:36:08 +0900 Subject: (김준회) 구매 요청사항 반영 - vendor-pool 및 avl detail (이진용 프로) MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit --- components/common/project/project-service.ts | 10 +++++++++- 1 file changed, 9 insertions(+), 1 deletion(-) (limited to 'components/common/project') diff --git a/components/common/project/project-service.ts b/components/common/project/project-service.ts index 6c103c6f..510d7527 100644 --- a/components/common/project/project-service.ts +++ b/components/common/project/project-service.ts @@ -28,6 +28,10 @@ export interface ProjectInfo { shipType?: string | null projectMsrm?: string | null projectHtDivision?: string | null + type?: string | null // projects 테이블의 type 필드 + sector?: string | null // biddingProjects 테이블의 sector 필드 + typeMdg?: string | null // projects 테이블의 TYPE_MDG 필드 + pjtType?: string | null // biddingProjects 테이블의 pjtType 필드 source: 'projects' | 'biddingProjects' } @@ -145,13 +149,15 @@ export async function getProjectInfoByCode(projectCode: string, searchFrom: 'bot if (searchFrom === 'both' || searchFrom === 'projects') { try { const projectInfo = await db.select().from(projects).where(eq(projects.code, projectCode)).limit(1) - + if (projectInfo && projectInfo.length > 0) { return { projectCode: projectInfo[0].code, projectName: projectInfo[0].name, shipType: projectInfo[0].SKND || undefined, projectHtDivision: projectInfo[0].type || undefined, + type: projectInfo[0].type || undefined, + typeMdg: projectInfo[0].TYPE_MDG || undefined, source: 'projects' } } @@ -180,6 +186,8 @@ export async function getProjectInfoByCode(projectCode: string, searchFrom: 'bot projectName: projectInfo[0].projNm, projectMsrm: projectInfo[0].ptypeNm, projectHtDivision, + sector: projectInfo[0].sector || undefined, + pjtType: projectInfo[0].pjtType || undefined, source: 'biddingProjects' } } -- cgit v1.2.3