(최겸) 기술영업 RFQ 견적 프로젝트별 생성 기능 추가

4 files changed, 80 insertions, 8 deletions

diff --git a/lib/techsales-rfq/service.ts b/lib/techsales-rfq/service.ts
index e658747b..d5cb8efe 100644
--- a/lib/techsales-rfq/service.ts
+++ b/lib/techsales-rfq/service.ts
@@ -39,7 +39,12 @@ import { decryptWithServerAction } from "@/components/drm/drmUtils";
 // eslint-disable-next-line @typescript-eslint/no-explicit-any
 type OrderByType = any;
 
-
+export type Project = {
+  id: number;
+  projectCode: string;
+  projectName: string;
+  pjtType: "SHIP" | "TOP" | "HULL";
+}
 
 /**
  * 연도별 순차 RFQ 코드 생성 함수 (다중 생성 지원)
@@ -2745,6 +2750,40 @@ export async function addTechVendorsToTechSalesRfq(input: {
             })
             .returning({ id: techSalesVendorQuotations.id });
 
+          // 🆕 RFQ의 아이템 코드들을 tech_vendor_possible_items에 추가
+          try {
+            // RFQ의 아이템들 조회
+            const rfqItemsResult = await getTechSalesRfqItems(input.rfqId);
+            
+            if (rfqItemsResult.data && rfqItemsResult.data.length > 0) {
+              const itemCodes = rfqItemsResult.data
+                .map(item => item.itemCode)
+                .filter(code => code); // 빈 코드 제외
+
+              // 각 아이템 코드에 대해 tech_vendor_possible_items에 추가 (중복 체크)
+              for (const itemCode of itemCodes) {
+                // 이미 존재하는지 확인
+                const existing = await tx.query.techVendorPossibleItems.findFirst({
+                  where: and(
+                    eq(techVendorPossibleItems.vendorId, vendorId),
+                    eq(techVendorPossibleItems.itemCode, itemCode)
+                  )
+                });
+
+                // 존재하지 않으면 추가
+                if (!existing) {
+                  await tx.insert(techVendorPossibleItems).values({
+                    vendorId: vendorId,
+                    itemCode: itemCode,
+                  });
+                }
+              }
+            }
+          } catch (possibleItemError) {
+            // tech_vendor_possible_items 추가 실패는 전체 실패로 처리하지 않음
+            console.warn(`벤더 ${vendorId}의 가능 아이템 추가 실패:`, possibleItemError);
+          }
+
           results.push({ id: quotation.id, vendorId, vendorName: vendor.vendorName });
         } catch (vendorError) {
           console.error(`Error adding vendor ${vendorId}:`, vendorError);
@@ -3379,4 +3418,37 @@ export async function getAcceptedTechSalesVendorQuotations(input: {
     console.error("getAcceptedTechSalesVendorQuotations 오류:", error);
     throw new Error(`Accepted quotations 조회 실패: ${getErrorMessage(error)}`);
   }
+}
+
+export async function getBidProjects(pjtType: 'SHIP' | 'TOP' | 'HULL'): Promise<Project[]> {
+  try {
+    // 트랜잭션을 사용하여 프로젝트 데이터 조회
+    const projectList = await db.transaction(async (tx) => {
+      // 기본 쿼리 구성
+      const query = tx
+        .select({
+          id: biddingProjects.id,
+          projectCode: biddingProjects.pspid,
+          projectName: biddingProjects.projNm,
+          pjtType: biddingProjects.pjtType,
+        })
+        .from(biddingProjects)
+        .where(eq(biddingProjects.pjtType, pjtType));
+      
+      const results = await query.orderBy(biddingProjects.id);
+      return results;
+    });
+    
+    // Handle null projectName values and ensure pjtType is not null
+    const validProjectList = projectList.map(project => ({
+      ...project,
+      projectName: project.projectName || '', // Replace null with empty string
+      pjtType: project.pjtType as "SHIP" | "TOP" | "HULL" // Type assertion since WHERE filters ensure non-null
+    }));
+
+    return validProjectList;
+  } catch (error) {
+    console.error("프로젝트 목록 가져오기 실패:", error);
+    return []; // 오류 발생 시 빈 배열 반환
+  }
 }
\ No newline at end of file
diff --git a/lib/techsales-rfq/table/create-rfq-hull-dialog.tsx b/lib/techsales-rfq/table/create-rfq-hull-dialog.tsx
index 7bbbfa75..23c57491 100644
--- a/lib/techsales-rfq/table/create-rfq-hull-dialog.tsx
+++ b/lib/techsales-rfq/table/create-rfq-hull-dialog.tsx
@@ -57,7 +57,7 @@ import {
   getOffshoreHullWorkTypes,
   getAllOffshoreHullItemsForCache,
   type OffshoreHullWorkType,
-  type OffshoreHullTechItem
+  type OffshoreHullTechItem,
 } from "@/lib/items-tech/service"
 
 // 해양 HULL 아이템 타입 정의 (이미 service에서 import하므로 제거)
@@ -83,7 +83,6 @@ type CreateHullRfqFormValues = z.infer<typeof createHullRfqSchema>
 interface WorkTypeOption {
   code: OffshoreHullWorkType
   name: string
-  description: string
 }
 
 interface CreateHullRfqDialogProps {
@@ -355,6 +354,7 @@ export function CreateHullRfqDialog({ onCreated }: CreateHullRfqDialogProps) {
                           selectedProjectId={field.value}
                           onProjectSelect={handleProjectSelect}
                           placeholder="입찰 프로젝트를 선택하세요"
+                          pjtType="HULL"
                         />
                       </FormControl>
                       <FormMessage />
diff --git a/lib/techsales-rfq/table/create-rfq-ship-dialog.tsx b/lib/techsales-rfq/table/create-rfq-ship-dialog.tsx
index b616f526..efa4e164 100644
--- a/lib/techsales-rfq/table/create-rfq-ship-dialog.tsx
+++ b/lib/techsales-rfq/table/create-rfq-ship-dialog.tsx
@@ -50,7 +50,7 @@ import {
   getAllShipbuildingItemsForCache,
   getShipTypes,
   type ShipbuildingItem,
-  type WorkType 
+  type ShipbuildingWorkType 
 } from "@/lib/items-tech/service"
 
 
@@ -73,9 +73,8 @@ type CreateShipRfqFormValues = z.infer<typeof createShipRfqSchema>
 
 // 공종 타입 정의
 interface WorkTypeOption {
-  code: WorkType
+  code: ShipbuildingWorkType
   name: string
-  description: string
 }
 
 interface CreateShipRfqDialogProps {
@@ -90,7 +89,7 @@ export function CreateShipRfqDialog({ onCreated }: CreateShipRfqDialogProps) {
   
   // 검색 및 필터링 상태
   const [itemSearchQuery, setItemSearchQuery] = React.useState("")
-  const [selectedWorkType, setSelectedWorkType] = React.useState<WorkType | null>(null)
+  const [selectedWorkType, setSelectedWorkType] = React.useState<ShipbuildingWorkType | null>(null)
   const [selectedShipType, setSelectedShipType] = React.useState<string | null>(null)
   const [selectedItems, setSelectedItems] = React.useState<ShipbuildingItem[]>([])
   
@@ -370,6 +369,7 @@ export function CreateShipRfqDialog({ onCreated }: CreateShipRfqDialogProps) {
                           selectedProjectId={field.value}
                           onProjectSelect={handleProjectSelect}
                           placeholder="입찰 프로젝트를 선택하세요"
+                          pjtType="SHIP"
                         />
                       </FormControl>
                       <FormMessage />
diff --git a/lib/techsales-rfq/table/create-rfq-top-dialog.tsx b/lib/techsales-rfq/table/create-rfq-top-dialog.tsx
index 6536e230..ef2229ac 100644
--- a/lib/techsales-rfq/table/create-rfq-top-dialog.tsx
+++ b/lib/techsales-rfq/table/create-rfq-top-dialog.tsx
@@ -75,7 +75,6 @@ type CreateTopRfqFormValues = z.infer<typeof createTopRfqSchema>
 interface WorkTypeOption {
   code: OffshoreTopWorkType
   name: string
-  description: string
 }
 
 interface CreateTopRfqDialogProps {
@@ -346,6 +345,7 @@ export function CreateTopRfqDialog({ onCreated }: CreateTopRfqDialogProps) {
                           selectedProjectId={field.value}
                           onProjectSelect={handleProjectSelect}
                           placeholder="입찰 프로젝트를 선택하세요"
+                          pjtType="TOP"
                         />
                       </FormControl>
                       <FormMessage />