From 8dba4d53d763bf9e1302a84a8fc65727425219ee Mon Sep 17 00:00:00 2001
From: joonhoekim <26rote@gmail.com>
Date: Tue, 18 Nov 2025 20:50:14 +0900
Subject: (김준회) 견적목록관리: 선급 누락 문제 처리 (뷰테이블 컬럼 추가)
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

---
 db/schema/rfqLast.ts | 13 +++++++++++++
 1 file changed, 13 insertions(+)

(limited to 'db')

diff --git a/db/schema/rfqLast.ts b/db/schema/rfqLast.ts
index 7374538f..7ab03c30 100644
--- a/db/schema/rfqLast.ts
+++ b/db/schema/rfqLast.ts
@@ -54,6 +54,7 @@ export const rfqsLast = pgTable(
         rfqSealedYn: boolean("rfq_sealed_yn").default(false),
 
         EngPicName: varchar("eng_pic_name", { length: 50 }),
+        EngPicEmployeeNumber: varchar("eng_pic_employee_number", { length: 50 }),
 
         packageNo: varchar("package_no", { length: 50 }),
         packageName: varchar("package_name", { length: 255 }),
@@ -322,6 +323,17 @@ export const rfqsLastView = pgView("rfqs_last_view").as((qb) => {
             projectId: sql<number | null>`${rfqsLast.projectId}`.as("project_id"),
             projectCode: sql<string | null>`${projects.code}`.as("project_code"),
             projectName: sql<string | null>`${projects.name}`.as("project_name"),
+            
+            // Classification (선급)
+            classNo: sql<string | null>`
+                CASE 
+                    WHEN ${projects.CLS_1} IS NOT NULL AND ${projects.CLS_2} IS NOT NULL 
+                        THEN CONCAT(${projects.CLS_1}, '-', ${projects.CLS_2})
+                    WHEN ${projects.CLS_1} IS NOT NULL 
+                        THEN ${projects.CLS_1}
+                    ELSE NULL
+                END
+            `.as("class_no"),
 
             // Item information
             itemCode: sql<string | null>`${rfqsLast.itemCode}`.as("item_code"),
@@ -333,6 +345,7 @@ export const rfqsLastView = pgView("rfqs_last_view").as((qb) => {
 
             // Engineering PIC
             engPicName: sql<string | null>`${rfqsLast.EngPicName}`.as("eng_pic_name"),
+            engPicEmployeeNumber: sql<string | null>`${rfqsLast.EngPicEmployeeNumber}`.as("eng_pic_employee_number"),
 
             // Status and dates
             status: sql<string>`${rfqsLast.status}`.as("status"),
-- 
cgit v1.2.3