diff options
| author | joonhoekim <26rote@gmail.com> | 2025-11-18 20:50:14 +0900 |
|---|---|---|
| committer | joonhoekim <26rote@gmail.com> | 2025-11-18 20:50:14 +0900 |
| commit | 8dba4d53d763bf9e1302a84a8fc65727425219ee (patch) | |
| tree | 35f7fd4f23b667618be9ce0242a0f8351ab2efb8 /db | |
| parent | 18a5bf7d1df331b8e554fc7fe2cabd8902cb0d19 (diff) | |
(김준회) 견적목록관리: 선급 누락 문제 처리 (뷰테이블 컬럼 추가)
Diffstat (limited to 'db')
| -rw-r--r-- | db/schema/rfqLast.ts | 13 |
1 files changed, 13 insertions, 0 deletions
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"), |