(김준회) 구매 요청사항 반영 - vendor-pool 및 avl detail (이진용 프로)

1 files changed, 9 insertions, 1 deletions

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'
         }
       }