~20250428 작업사항

1 files changed, 122 insertions, 0 deletions

diff --git a/config/bidProjectsColumnsConfig.ts b/config/bidProjectsColumnsConfig.ts
new file mode 100644
index 00000000..0a0e5c9c
--- /dev/null
+++ b/config/bidProjectsColumnsConfig.ts
@@ -0,0 +1,122 @@
+import { BiddingProjects } from "@/db/schema"
+
+export interface ProjectColumnConfig {
+  id: keyof BiddingProjects
+  label: string
+  group?: string
+  excelHeader?: string
+  type?: string
+}
+
+export const bidProjectsColumnsConfig: ProjectColumnConfig[] = [
+  {
+    id: "pspid",
+    label: "견적프로젝트번호",
+    excelHeader: "견적프로젝트번호",
+    // group: "Basic Info",
+  },
+  {
+    id: "projNm",
+    label: "견적프로젝트명",
+    excelHeader: "견적프로젝트명",
+    // group: "Basic Info",
+  },
+  {
+    id: "sector",
+    label: "부문(S / M)",
+    excelHeader: "부문(S / M)",
+    // group: "Basic Info",
+  },
+  {
+    id: "projMsrm",
+    label: "척수",
+    excelHeader: "척수",
+    // group: "Basic Info",
+  },
+  {
+    id: "kunnr",
+    label: "선주코드",
+    excelHeader: "선주코드",
+    // group: "Basic Info",
+  },
+  {
+    id: "kunnrNm",
+    label: "선주명",
+    excelHeader: "선주명",
+    // group: "Basic Info",
+  },  {
+    id: "cls1",
+    label: "선급코드",
+    excelHeader: "선급코드",
+    // group: "Basic Info",
+  },  {
+    id: "cls1Nm",
+    label: "선급명",
+    excelHeader: "선급명",
+    // group: "Basic Info",
+  },  {
+    id: "ptype",
+    label: "선종코드",
+    excelHeader: "선종코드",
+    // group: "Basic Info",
+  },  {
+    id: "ptypeNm",
+    label: "선종명",
+    excelHeader: "선종명",
+    // group: "Basic Info",
+  },  {
+    id: "pmodelCd",
+    label: "선형코드",
+    excelHeader: "선형코드",
+    // group: "Basic Info",
+  },
+  {
+    id: "pmodelNm",
+    label: "선형명",
+    excelHeader: "선형명",
+    // group: "Basic Info",
+  },
+  {
+    id: "pmodelSz",
+    label: "선형크기",
+    excelHeader: "선형크기",
+    // group: "Basic Info",
+  },
+  {
+    id: "pmodelUom",
+    label: "선형단위",
+    excelHeader: "선형단위",
+    // group: "Basic Info",
+  },
+  {
+    id: "txt04",
+    label: "견적상태코드",
+    excelHeader: "견적상태코드",
+    // group: "Basic Info",
+  },
+  {
+    id: "txt30",
+    label: "견적상태명",
+    excelHeader: "견적상태명",
+    // group: "Basic Info",
+  },
+
+  {
+    id: "estmPm",
+    label: "견적대표PM 성명",
+    excelHeader: "견적대표PM 성명",
+    // group: "Basic Info",
+  },
+  {
+    id: "createdAt",
+    label: "Created At",
+    excelHeader: "Created At",
+    // group: "Metadata",a
+  },
+  {
+    id: "updatedAt",
+    label: "Updated At",
+    excelHeader: "Updated At",
+    // group: "Metadata",
+  },
+]
\ No newline at end of file