(김준회) AVL 구매요구사항 수정

- AVL 상세 엑셀 익스포트 추가
- 레코드 이동 멀티선택 추가
- 최종확정처리 오류 수정
- 프로젝트 AVL에 H/T 구분 추가

1 files changed, 51 insertions, 3 deletions

diff --git a/lib/avl/table/columns-detail.tsx b/lib/avl/table/columns-detail.tsx
index b354dccd..f70f3c97 100644
--- a/lib/avl/table/columns-detail.tsx
+++ b/lib/avl/table/columns-detail.tsx
@@ -16,6 +16,9 @@ export const columns: ColumnDef<AvlDetailItem>[] = [
           <DataTableColumnHeaderSimple column={column} title="No." />
         ),
         size: 60,
+        meta: {
+          excelHeader: "No.",
+        },
       },
       {
         accessorKey: "equipBulkDivision",
@@ -31,6 +34,9 @@ export const columns: ColumnDef<AvlDetailItem>[] = [
           )
         },
         size: 120,
+        meta: {
+          excelHeader: "Equip/Bulk 구분",
+        },
       },
       {
         accessorKey: "disciplineName",
@@ -42,6 +48,9 @@ export const columns: ColumnDef<AvlDetailItem>[] = [
           return <span>{value || "-"}</span>
         },
         size: 120,
+        meta: {
+          excelHeader: "설계공종",
+        },
       },
       {
         accessorKey: "materialNameCustomerSide",
@@ -53,6 +62,9 @@ export const columns: ColumnDef<AvlDetailItem>[] = [
           return <span>{value || "-"}</span>
         },
         size: 150,
+        meta: {
+          excelHeader: "고객사 AVL 자재명",
+        },
       },
       {
         accessorKey: "packageName",
@@ -64,6 +76,9 @@ export const columns: ColumnDef<AvlDetailItem>[] = [
           return <span>{value || "-"}</span>
         },
         size: 130,
+        meta: {
+          excelHeader: "패키지 정보",
+        },
       },
       {
         accessorKey: "materialGroupCode",
@@ -75,6 +90,9 @@ export const columns: ColumnDef<AvlDetailItem>[] = [
           return <span>{value || "-"}</span>
         },
         size: 120,
+        meta: {
+          excelHeader: "자재그룹코드",
+        },
       },
       {
         accessorKey: "materialGroupName",
@@ -86,6 +104,9 @@ export const columns: ColumnDef<AvlDetailItem>[] = [
           return <span>{value || "-"}</span>
         },
         size: 130,
+        meta: {
+          excelHeader: "자재그룹명",
+        },
       },
       {
         accessorKey: "vendorCode",
@@ -97,6 +118,9 @@ export const columns: ColumnDef<AvlDetailItem>[] = [
           return <span>{value || "-"}</span>
         },
         size: 120,
+        meta: {
+          excelHeader: "협력업체코드",
+        },
       },
       {
         accessorKey: "vendorName",
@@ -108,6 +132,9 @@ export const columns: ColumnDef<AvlDetailItem>[] = [
           return <span className="font-medium">{value || "-"}</span>
         },
         size: 140,
+        meta: {
+          excelHeader: "협력업체명",
+        },
       },
       {
         accessorKey: "avlVendorName",
@@ -119,6 +146,9 @@ export const columns: ColumnDef<AvlDetailItem>[] = [
           return <span>{value || "-"}</span>
         },
         size: 140,
+        meta: {
+          excelHeader: "AVL 등재업체명",
+        },
       },
       {
         accessorKey: "tier",
@@ -128,13 +158,13 @@ export const columns: ColumnDef<AvlDetailItem>[] = [
         cell: ({ row }) => {
           const value = row.getValue("tier") as string
           if (!value) return <span>-</span>
-          
+
           const tierColor = {
             "Tier 1": "bg-green-100 text-green-800",
-            "Tier 2": "bg-yellow-100 text-yellow-800", 
+            "Tier 2": "bg-yellow-100 text-yellow-800",
             "Tier 3": "bg-red-100 text-red-800"
           }[value] || "bg-gray-100 text-gray-800"
-          
+
           return (
             <Badge className={tierColor}>
               {value}
@@ -142,6 +172,9 @@ export const columns: ColumnDef<AvlDetailItem>[] = [
           )
         },
         size: 100,
+        meta: {
+          excelHeader: "등급 (Tier)",
+        },
       },
     ],
   },
@@ -163,6 +196,9 @@ export const columns: ColumnDef<AvlDetailItem>[] = [
           )
         },
         size: 80,
+        meta: {
+          excelHeader: "FA 대상",
+        },
       },
       {
         accessorKey: "faStatus",
@@ -174,6 +210,9 @@ export const columns: ColumnDef<AvlDetailItem>[] = [
           return <span>{value || "-"}</span>
         },
         size: 100,
+        meta: {
+          excelHeader: "FA 현황",
+        },
       },
     ],
   },
@@ -195,6 +234,9 @@ export const columns: ColumnDef<AvlDetailItem>[] = [
           )
         },
         size: 80,
+        meta: {
+          excelHeader: "AVL",
+        },
       },
       {
         accessorKey: "shiBlacklist",
@@ -210,6 +252,9 @@ export const columns: ColumnDef<AvlDetailItem>[] = [
           )
         },
         size: 100,
+        meta: {
+          excelHeader: "Blacklist",
+        },
       },
       {
         accessorKey: "shiBcc",
@@ -225,6 +270,9 @@ export const columns: ColumnDef<AvlDetailItem>[] = [
           )
         },
         size: 80,
+        meta: {
+          excelHeader: "BCC",
+        },
       },
     ],
   },