From d76ab1855ec68432a1b362c5d922af7235658d10 Mon Sep 17 00:00:00 2001
From: dujinkim <dujin.kim@dtsolution.co.kr>
Date: Tue, 11 Nov 2025 08:44:22 +0000
Subject: (임수민) 구매 피드백 수정사항들 PO 금액 표시, RFQ 품목 컬럼 추가,
 스크롤 시 헤더 고정, 납기일과 SAP 한국시간, 히스토리 수정
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

---
 lib/rfq-last/service.ts | 81 +++++++++++++++++++++++++++----------------------
 1 file changed, 44 insertions(+), 37 deletions(-)

(limited to 'lib/rfq-last/service.ts')

diff --git a/lib/rfq-last/service.ts b/lib/rfq-last/service.ts
index 462b5604..52d67280 100644
--- a/lib/rfq-last/service.ts
+++ b/lib/rfq-last/service.ts
@@ -669,41 +669,48 @@ export async function getRfqItemsAction(rfqId: number) {
       .where(eq(prItemsLastView.rfqsLastId, rfqId))
       .orderBy(prItemsLastView.majorYn, prItemsLastView.rfqItem, prItemsLastView.materialCode)
 
-    const formattedItems = items.map(item => ({
-      id: item.id,
-      rfqsLastId: item.rfqsLastId,
-      rfqItem: item.rfqItem,
-      prItem: item.prItem,
-      prNo: item.prNo,
-      materialCode: item.materialCode,
-      materialCategory: item.materialCategory,
-      acc: item.acc,
-      materialDescription: item.materialDescription,
-      size: item.size,
-      deliveryDate: item.deliveryDate,
-      quantity: Number(item.quantity) || 0,  // 여기서 숫자로 변환
-      uom: item.uom,
-      grossWeight: Number(item.grossWeight) || 0,  // 여기서 숫자로 변환
-      gwUom: item.gwUom,
-      specNo: item.specNo,
-      specUrl: item.specUrl,
-      trackingNo: item.trackingNo,
-      majorYn: item.majorYn,
-      remark: item.remark,
-      projectDef: item.projectDef,
-      projectSc: item.projectSc,
-      projectKl: item.projectKl,
-      projectLc: item.projectLc,
-      projectDl: item.projectDl,
-      // RFQ 관련 정보
-      rfqCode: item.rfqCode,
-      rfqType: item.rfqType,
-      rfqTitle: item.rfqTitle,
-      itemCode: item.itemCode,
-      itemName: item.itemName,
-      projectCode: item.projectCode,
-      projectName: item.projectName,
-    }))
+    const formattedItems = items.map(item => {
+      const specification =
+        (item as { specification?: string | null }).specification ?? null
+
+      return {
+        id: item.id,
+        rfqsLastId: item.rfqsLastId,
+        rfqItem: item.rfqItem,
+        prItem: item.prItem,
+        prNo: item.prNo,
+        materialCode: item.materialCode,
+        materialCategory: item.materialCategory,
+        acc: item.acc,
+        materialDescription: item.materialDescription,
+        size: item.size,
+        deliveryDate: item.deliveryDate,
+        quantity: Number(item.quantity) || 0,  // 여기서 숫자로 변환
+        uom: item.uom,
+        grossWeight: Number(item.grossWeight) || 0,  // 여기서 숫자로 변환
+        gwUom: item.gwUom,
+        specNo: item.specNo,
+        specUrl: item.specUrl,
+        trackingNo: item.trackingNo,
+        specification,
+        majorYn: item.majorYn,
+        remark: item.remark,
+        projectDef: item.projectDef,
+        projectSc: item.projectSc,
+        projectKl: item.projectKl,
+        projectLc: item.projectLc,
+        projectDl: item.projectDl,
+        prIssueDate: item.prIssueDate ? new Date(item.prIssueDate) : null,
+        // RFQ 관련 정보
+        rfqCode: item.rfqCode,
+        rfqType: item.rfqType,
+        rfqTitle: item.rfqTitle,
+        itemCode: item.itemCode,
+        itemName: item.itemName,
+        projectCode: item.projectCode,
+        projectName: item.projectName,
+      }
+    })
 
     // 주요 품목과 일반 품목 분리 및 통계
     const majorItems = formattedItems.filter(item => item.majorYn)
@@ -5068,11 +5075,11 @@ export async function updateShortList(
             })
           );
 
-          // 2-3. RFQ 상태를 "Short List 확정"으로 업데이트
+          // 2-3. RFQ 상태를 "TBE 요청"으로 업데이트
           await tx
             .update(rfqsLast)
             .set({
-              status: "Short List 확정" as RfqStatus,
+              status: "TBE 요청" as RfqStatus,
               updatedBy: Number(session.user.id),
               updatedAt: new Date()
             })
-- 
cgit v1.2.3