(최겸)구매 결재일 기준 공고 수정

1 files changed, 404 insertions, 404 deletions

diff --git a/lib/bidding/receive/biddings-receive-columns.tsx b/lib/bidding/receive/biddings-receive-columns.tsx
index 9650574a..f2e2df17 100644
--- a/lib/bidding/receive/biddings-receive-columns.tsx
+++ b/lib/bidding/receive/biddings-receive-columns.tsx
@@ -1,404 +1,404 @@
-"use client"

-

-import * as React from "react"

-import { type ColumnDef } from "@tanstack/react-table"

-import { Badge } from "@/components/ui/badge"

-import { Button } from "@/components/ui/button"

-import { Checkbox } from "@/components/ui/checkbox"

-import {

-  Eye, Calendar, Users, CheckCircle, XCircle, Clock, AlertTriangle

-} from "lucide-react"

-import {

-  Tooltip,

-  TooltipContent,

-  TooltipProvider,

-  TooltipTrigger,

-} from "@/components/ui/tooltip"

-import {

-  DropdownMenu,

-  DropdownMenuContent,

-  DropdownMenuItem,

-  DropdownMenuSeparator,

-  DropdownMenuTrigger,

-} from "@/components/ui/dropdown-menu"

-import { DataTableColumnHeaderSimple } from "@/components/data-table/data-table-column-simple-header"

-import {

-  biddingStatusLabels,

-  contractTypeLabels,

-} from "@/db/schema"

-import { formatDate } from "@/lib/utils"

-import { DataTableRowAction } from "@/types/table"

-

-type BiddingReceiveItem = {

-  id: number

-  biddingNumber: string

-  originalBiddingNumber: string | null

-  title: string

-  status: string

-  contractType: string

-  prNumber: string | null

-  submissionStartDate: Date | null

-  submissionEndDate: Date | null

-  bidPicName: string | null

-  supplyPicName: string | null

-  createdBy: string | null

-  createdAt: Date | null

-  updatedAt: Date | null

-

-  // 참여 현황

-  participantExpected: number

-  participantParticipated: number

-  participantDeclined: number

-  participantPending: number

-

-  // 개찰 정보

-  openedAt: Date | null

-  openedBy: string | null

-}

-

-interface GetColumnsProps {

-  setRowAction: React.Dispatch<React.SetStateAction<DataTableRowAction<BiddingReceiveItem> | null>>

-  onParticipantClick?: (biddingId: number, participantType: 'expected' | 'participated' | 'declined' | 'pending') => void

-}

-

-// 상태별 배지 색상

-const getStatusBadgeVariant = (status: string) => {

-  switch (status) {

-    case 'received_quotation':

-      return 'secondary'

-    case 'bidding_opened':

-      return 'default'

-    case 'bidding_closed':

-      return 'outline'

-    default:

-      return 'outline'

-  }

-}

-

-// 금액 포맷팅

-const formatCurrency = (amount: string | number | null, currency = 'KRW') => {

-  if (!amount) return '-'

-

-  const numAmount = typeof amount === 'string' ? parseFloat(amount) : amount

-  if (isNaN(numAmount)) return '-'

-

-  return new Intl.NumberFormat('ko-KR', {

-    style: 'currency',

-    currency: currency,

-    minimumFractionDigits: 0,

-    maximumFractionDigits: 0,

-  }).format(numAmount)

-}

-

-export function getBiddingsReceiveColumns({ setRowAction, onParticipantClick }: GetColumnsProps): ColumnDef<BiddingReceiveItem>[] {

-

-  return [

-    // ░░░ 선택 ░░░

-    {

-      id: "select",

-      header: "",

-      cell: ({ row }) => (

-        <Checkbox

-          checked={row.getIsSelected()}

-          onCheckedChange={(value) => {

-            // single select 모드에서는 다른 행들의 선택을 해제

-            row.toggleSelected(!!value)

-          }}

-          aria-label="행 선택"

-        />

-      ),

-      size: 50,

-      enableSorting: false,

-      enableHiding: false,

-    },

-

-    // ░░░ 입찰번호 ░░░

-    {

-      accessorKey: "biddingNumber",

-      header: ({ column }) => <DataTableColumnHeaderSimple column={column} title="입찰번호" />,

-      cell: ({ row }) => (

-        <div className="font-mono text-sm">

-          {row.original.biddingNumber}

-        </div>

-      ),

-      size: 120,

-      meta: { excelHeader: "입찰번호" },

-    },

-

-    // ░░░ 입찰명 ░░░

-    {

-      accessorKey: "title",

-      header: ({ column }) => <DataTableColumnHeaderSimple column={column} title="입찰명" />,

-      cell: ({ row }) => (

-        <div className="truncate max-w-[200px]" title={row.original.title}>

-          {/* <Button

-            variant="link"

-            className="p-0 h-auto text-left justify-start font-bold underline"

-            onClick={() => setRowAction({ row, type: "view" })}

-          >

-            <div className="whitespace-pre-line">

-              {row.original.title}

-            </div>

-          </Button> */}

-          {row.original.title}

-        </div>

-      ),

-      size: 200,

-      meta: { excelHeader: "입찰명" },

-    },

-

-    // ░░░ 원입찰번호 ░░░

-    {

-      accessorKey: "originalBiddingNumber",

-      header: ({ column }) => <DataTableColumnHeaderSimple column={column} title="원입찰번호" />,

-      cell: ({ row }) => (

-        <div className="font-mono text-sm">

-          {row.original.originalBiddingNumber || '-'}

-        </div>

-      ),

-      size: 120,

-      meta: { excelHeader: "원입찰번호" },

-    },

-

-    // ░░░ 진행상태 ░░░

-    {

-      accessorKey: "status",

-      header: ({ column }) => <DataTableColumnHeaderSimple column={column} title="진행상태" />,

-      cell: ({ row }) => (

-        <Badge variant={getStatusBadgeVariant(row.original.status)}>

-          {biddingStatusLabels[row.original.status]}

-        </Badge>

-      ),

-      size: 120,

-      meta: { excelHeader: "진행상태" },

-    },

-

-    // ░░░ 계약구분 ░░░

-    {

-      accessorKey: "contractType",

-      header: ({ column }) => <DataTableColumnHeaderSimple column={column} title="계약구분" />,

-      cell: ({ row }) => (

-        <Badge variant="outline">

-          {contractTypeLabels[row.original.contractType]}

-        </Badge>

-      ),

-      size: 100,

-      meta: { excelHeader: "계약구분" },

-    },

-

-    // ░░░ 입찰서제출기간 ░░░

-    {

-      id: "submissionPeriod",

-      header: ({ column }) => <DataTableColumnHeaderSimple column={column} title="입찰서제출기간" />,

-      cell: ({ row }) => {

-        const startDate = row.original.submissionStartDate

-        const endDate = row.original.submissionEndDate

-        

-        if (!startDate || !endDate) return <span className="text-muted-foreground">-</span>

-        

-        const startObj = new Date(startDate)

-        const endObj = new Date(endDate)

-

-        // UI 표시용 KST 변환

-        const formatKst = (d: Date) => new Date(d.getTime() + 9 * 60 * 60 * 1000).toISOString().slice(0, 16).replace('T', ' ')

-        

-        return (

-          <div className="text-xs">

-            <div>

-              {formatKst(startObj)} ~ {formatKst(endObj)}

-            </div>

-          </div>

-        )

-      },

-      size: 140,

-      meta: { excelHeader: "입찰서제출기간" },

-    },

-

-    // ░░░ P/R번호 ░░░

-    {

-      accessorKey: "prNumber",

-      header: ({ column }) => <DataTableColumnHeaderSimple column={column} title="P/R번호" />,

-      cell: ({ row }) => (

-        <span className="font-mono text-sm">{row.original.prNumber || '-'}</span>

-      ),

-      size: 100,

-      meta: { excelHeader: "P/R번호" },

-    },

-

-    // ░░░ 입찰담당자 ░░░

-    {

-      accessorKey: "bidPicName",

-      header: ({ column }) => <DataTableColumnHeaderSimple column={column} title="입찰담당자" />,

-      cell: ({ row }) => {

-        const bidPic = row.original.bidPicName

-        const supplyPic = row.original.supplyPicName

-

-        const displayName = bidPic || supplyPic || "-"

-        return <span className="text-sm">{displayName}</span>

-      },

-      size: 100,

-      meta: { excelHeader: "입찰담당자" },

-    },

-

-    // ░░░ 참여예정협력사 ░░░

-    {

-      id: "participantExpected",

-      header: ({ column }) => <DataTableColumnHeaderSimple column={column} title="참여예정협력사" />,

-      cell: ({ row }) => (

-        <Button

-          variant="ghost"

-          size="sm"

-          className="h-auto p-1 hover:bg-blue-50"

-          onClick={() => onParticipantClick?.(row.original.id, 'expected')}

-          disabled={row.original.participantExpected === 0}

-        >

-          <div className="flex items-center gap-1">

-            <Users className="h-4 w-4 text-blue-500" />

-            <span className="text-sm font-medium">{row.original.participantExpected}</span>

-          </div>

-        </Button>

-      ),

-      size: 100,

-      meta: { excelHeader: "참여예정협력사" },

-    },

-

-    // ░░░ 참여협력사 ░░░

-    {

-      id: "participantParticipated",

-      header: ({ column }) => <DataTableColumnHeaderSimple column={column} title="참여협력사" />,

-      cell: ({ row }) => (

-        <Button

-          variant="ghost"

-          size="sm"

-          className="h-auto p-1 hover:bg-green-50"

-          onClick={() => onParticipantClick?.(row.original.id, 'participated')}

-          disabled={row.original.participantParticipated === 0}

-        >

-          <div className="flex items-center gap-1">

-            <CheckCircle className="h-4 w-4 text-green-500" />

-            <span className="text-sm font-medium">{row.original.participantParticipated}</span>

-          </div>

-        </Button>

-      ),

-      size: 100,

-      meta: { excelHeader: "참여협력사" },

-    },

-

-    // ░░░ 포기협력사 ░░░

-    {

-      id: "participantDeclined",

-      header: ({ column }) => <DataTableColumnHeaderSimple column={column} title="포기협력사" />,

-      cell: ({ row }) => (

-        <Button

-          variant="ghost"

-          size="sm"

-          className="h-auto p-1 hover:bg-red-50"

-          onClick={() => onParticipantClick?.(row.original.id, 'declined')}

-          disabled={row.original.participantDeclined === 0}

-        >

-          <div className="flex items-center gap-1">

-            <XCircle className="h-4 w-4 text-red-500" />

-            <span className="text-sm font-medium">{row.original.participantDeclined}</span>

-          </div>

-        </Button>

-      ),

-      size: 100,

-      meta: { excelHeader: "포기협력사" },

-    },

-

-    // ░░░ 미제출협력사 ░░░

-    {

-      id: "participantPending",

-      header: ({ column }) => <DataTableColumnHeaderSimple column={column} title="미제출협력사" />,

-      cell: ({ row }) => (

-        <Button

-          variant="ghost"

-          size="sm"

-          className="h-auto p-1 hover:bg-yellow-50"

-          onClick={() => onParticipantClick?.(row.original.id, 'pending')}

-          disabled={row.original.participantPending === 0}

-        >

-          <div className="flex items-center gap-1">

-            <Clock className="h-4 w-4 text-yellow-500" />

-            <span className="text-sm font-medium">{row.original.participantPending}</span>

-          </div>

-        </Button>

-      ),

-      size: 100,

-      meta: { excelHeader: "미제출협력사" },

-    },

-

-    // ░░░ 개찰자명 ░░░

-    {

-      id: "openedBy",

-      header: ({ column }) => <DataTableColumnHeaderSimple column={column} title="개찰자명" />,

-      cell: ({ row }) => {

-        const openedBy = row.original.openedBy

-        return <span className="text-sm">{openedBy || '-'}</span>

-      },

-      size: 100,

-      meta: { excelHeader: "개찰자명" },

-    },

-

-    // ░░░ 개찰일 ░░░

-    {

-      id: "openedAt",

-      header: ({ column }) => <DataTableColumnHeaderSimple column={column} title="개찰일" />,

-      cell: ({ row }) => {

-        const openedAt = row.original.openedAt

-        return <span className="text-sm">{openedAt ? formatDate(openedAt, "KR") : '-'}</span>

-      },

-      size: 100,

-      meta: { excelHeader: "개찰일" },

-    },

-

-    // ░░░ 등록자 ░░░

-    {

-      accessorKey: "createdBy",

-      header: ({ column }) => <DataTableColumnHeaderSimple column={column} title="등록자" />,

-      cell: ({ row }) => (

-        <span className="text-sm">{row.original.createdBy || '-'}</span>

-      ),

-      size: 100,

-      meta: { excelHeader: "등록자" },

-    },

-

-    // ░░░ 등록일시 ░░░

-    {

-      accessorKey: "createdAt",

-      header: ({ column }) => <DataTableColumnHeaderSimple column={column} title="등록일시" />,

-      cell: ({ row }) => (

-        <span className="text-sm">{row.original.createdAt ? formatDate(row.original.createdAt, "KR") : '-'}</span>

-      ),

-      size: 100,

-      meta: { excelHeader: "등록일시" },

-    },

-

-    // ═══════════════════════════════════════════════════════════════

-    // 액션

-    // ═══════════════════════════════════════════════════════════════

-    // {

-    //   id: "actions",

-    //   header: "액션",

-    //   cell: ({ row }) => (

-    //     <DropdownMenu>

-    //       <DropdownMenuTrigger asChild>

-    //         <Button variant="ghost" className="h-8 w-8 p-0">

-    //           <span className="sr-only">메뉴 열기</span>

-    //           <AlertTriangle className="h-4 w-4" />

-    //         </Button>

-    //       </DropdownMenuTrigger>

-    //       <DropdownMenuContent align="end">

-    //         <DropdownMenuItem onClick={() => setRowAction({ row, type: "view" })}>

-    //           <Eye className="mr-2 h-4 w-4" />

-    //           상세보기

-    //         </DropdownMenuItem>

-    //       </DropdownMenuContent>

-    //     </DropdownMenu>

-    //   ),

-    //   size: 50,

-    //   enableSorting: false,

-    //   enableHiding: false,

-    // },

-  ]

-}

+"use client"
+
+import * as React from "react"
+import { type ColumnDef } from "@tanstack/react-table"
+import { Badge } from "@/components/ui/badge"
+import { Button } from "@/components/ui/button"
+import { Checkbox } from "@/components/ui/checkbox"
+import {
+  Eye, Calendar, Users, CheckCircle, XCircle, Clock, AlertTriangle
+} from "lucide-react"
+import {
+  Tooltip,
+  TooltipContent,
+  TooltipProvider,
+  TooltipTrigger,
+} from "@/components/ui/tooltip"
+import {
+  DropdownMenu,
+  DropdownMenuContent,
+  DropdownMenuItem,
+  DropdownMenuSeparator,
+  DropdownMenuTrigger,
+} from "@/components/ui/dropdown-menu"
+import { DataTableColumnHeaderSimple } from "@/components/data-table/data-table-column-simple-header"
+import {
+  biddingStatusLabels,
+  contractTypeLabels,
+} from "@/db/schema"
+import { formatDate } from "@/lib/utils"
+import { DataTableRowAction } from "@/types/table"
+
+type BiddingReceiveItem = {
+  id: number
+  biddingNumber: string
+  originalBiddingNumber: string | null
+  title: string
+  status: string
+  contractType: string
+  prNumber: string | null
+  submissionStartDate: Date | null
+  submissionEndDate: Date | null
+  bidPicName: string | null
+  supplyPicName: string | null
+  createdBy: string | null
+  createdAt: Date | null
+  updatedAt: Date | null
+
+  // 참여 현황
+  participantExpected: number
+  participantParticipated: number
+  participantDeclined: number
+  participantPending: number
+
+  // 개찰 정보
+  openedAt: Date | null
+  openedBy: string | null
+}
+
+interface GetColumnsProps {
+  setRowAction: React.Dispatch<React.SetStateAction<DataTableRowAction<BiddingReceiveItem> | null>>
+  onParticipantClick?: (biddingId: number, participantType: 'expected' | 'participated' | 'declined' | 'pending') => void
+}
+
+// 상태별 배지 색상
+const getStatusBadgeVariant = (status: string) => {
+  switch (status) {
+    case 'received_quotation':
+      return 'secondary'
+    case 'bidding_opened':
+      return 'default'
+    case 'bidding_closed':
+      return 'outline'
+    default:
+      return 'outline'
+  }
+}
+
+// 금액 포맷팅
+const formatCurrency = (amount: string | number | null, currency = 'KRW') => {
+  if (!amount) return '-'
+
+  const numAmount = typeof amount === 'string' ? parseFloat(amount) : amount
+  if (isNaN(numAmount)) return '-'
+
+  return new Intl.NumberFormat('ko-KR', {
+    style: 'currency',
+    currency: currency,
+    minimumFractionDigits: 0,
+    maximumFractionDigits: 0,
+  }).format(numAmount)
+}
+
+export function getBiddingsReceiveColumns({ setRowAction, onParticipantClick }: GetColumnsProps): ColumnDef<BiddingReceiveItem>[] {
+
+  return [
+    // ░░░ 선택 ░░░
+    {
+      id: "select",
+      header: "",
+      cell: ({ row }) => (
+        <Checkbox
+          checked={row.getIsSelected()}
+          onCheckedChange={(value) => {
+            // single select 모드에서는 다른 행들의 선택을 해제
+            row.toggleSelected(!!value)
+          }}
+          aria-label="행 선택"
+        />
+      ),
+      size: 50,
+      enableSorting: false,
+      enableHiding: false,
+    },
+
+    // ░░░ 입찰번호 ░░░
+    {
+      accessorKey: "biddingNumber",
+      header: ({ column }) => <DataTableColumnHeaderSimple column={column} title="입찰번호" />,
+      cell: ({ row }) => (
+        <div className="font-mono text-sm">
+          {row.original.biddingNumber}
+        </div>
+      ),
+      size: 120,
+      meta: { excelHeader: "입찰번호" },
+    },
+
+    // ░░░ 입찰명 ░░░
+    {
+      accessorKey: "title",
+      header: ({ column }) => <DataTableColumnHeaderSimple column={column} title="입찰명" />,
+      cell: ({ row }) => (
+        <div className="truncate max-w-[200px]" title={row.original.title}>
+          {/* <Button
+            variant="link"
+            className="p-0 h-auto text-left justify-start font-bold underline"
+            onClick={() => setRowAction({ row, type: "view" })}
+          >
+            <div className="whitespace-pre-line">
+              {row.original.title}
+            </div>
+          </Button> */}
+          {row.original.title}
+        </div>
+      ),
+      size: 200,
+      meta: { excelHeader: "입찰명" },
+    },
+
+    // ░░░ 원입찰번호 ░░░
+    {
+      accessorKey: "originalBiddingNumber",
+      header: ({ column }) => <DataTableColumnHeaderSimple column={column} title="원입찰번호" />,
+      cell: ({ row }) => (
+        <div className="font-mono text-sm">
+          {row.original.originalBiddingNumber || '-'}
+        </div>
+      ),
+      size: 120,
+      meta: { excelHeader: "원입찰번호" },
+    },
+
+    // ░░░ 진행상태 ░░░
+    {
+      accessorKey: "status",
+      header: ({ column }) => <DataTableColumnHeaderSimple column={column} title="진행상태" />,
+      cell: ({ row }) => (
+        <Badge variant={getStatusBadgeVariant(row.original.status)}>
+          {biddingStatusLabels[row.original.status]}
+        </Badge>
+      ),
+      size: 120,
+      meta: { excelHeader: "진행상태" },
+    },
+
+    // ░░░ 계약구분 ░░░
+    {
+      accessorKey: "contractType",
+      header: ({ column }) => <DataTableColumnHeaderSimple column={column} title="계약구분" />,
+      cell: ({ row }) => (
+        <Badge variant="outline">
+          {contractTypeLabels[row.original.contractType]}
+        </Badge>
+      ),
+      size: 100,
+      meta: { excelHeader: "계약구분" },
+    },
+
+    // ░░░ 입찰서제출기간 ░░░
+    {
+      id: "submissionPeriod",
+      header: ({ column }) => <DataTableColumnHeaderSimple column={column} title="입찰서제출기간" />,
+      cell: ({ row }) => {
+        const startDate = row.original.submissionStartDate
+        const endDate = row.original.submissionEndDate
+        
+        if (!startDate || !endDate) return <span className="text-muted-foreground">-</span>
+        
+        const startObj = new Date(startDate)
+        const endObj = new Date(endDate)
+
+        // UI 표시용 KST 변환
+        const formatKst = (d: Date) => new Date(d.getTime() + 9 * 60 * 60 * 1000).toISOString().slice(0, 16).replace('T', ' ')
+        
+        return (
+          <div className="text-xs">
+            <div>
+              {formatKst(startObj)} ~ {formatKst(endObj)}
+            </div>
+          </div>
+        )
+      },
+      size: 140,
+      meta: { excelHeader: "입찰서제출기간" },
+    },
+
+    // ░░░ P/R번호 ░░░
+    {
+      accessorKey: "prNumber",
+      header: ({ column }) => <DataTableColumnHeaderSimple column={column} title="P/R번호" />,
+      cell: ({ row }) => (
+        <span className="font-mono text-sm">{row.original.prNumber || '-'}</span>
+      ),
+      size: 100,
+      meta: { excelHeader: "P/R번호" },
+    },
+
+    // ░░░ 입찰담당자 ░░░
+    {
+      accessorKey: "bidPicName",
+      header: ({ column }) => <DataTableColumnHeaderSimple column={column} title="입찰담당자" />,
+      cell: ({ row }) => {
+        const bidPic = row.original.bidPicName
+        const supplyPic = row.original.supplyPicName
+
+        const displayName = bidPic || supplyPic || "-"
+        return <span className="text-sm">{displayName}</span>
+      },
+      size: 100,
+      meta: { excelHeader: "입찰담당자" },
+    },
+
+    // ░░░ 참여예정협력사 ░░░
+    {
+      id: "participantExpected",
+      header: ({ column }) => <DataTableColumnHeaderSimple column={column} title="참여예정협력사" />,
+      cell: ({ row }) => (
+        <Button
+          variant="ghost"
+          size="sm"
+          className="h-auto p-1 hover:bg-blue-50"
+          onClick={() => onParticipantClick?.(row.original.id, 'expected')}
+          disabled={row.original.participantExpected === 0}
+        >
+          <div className="flex items-center gap-1">
+            <Users className="h-4 w-4 text-blue-500" />
+            <span className="text-sm font-medium">{row.original.participantExpected}</span>
+          </div>
+        </Button>
+      ),
+      size: 100,
+      meta: { excelHeader: "참여예정협력사" },
+    },
+
+    // ░░░ 참여협력사 ░░░
+    {
+      id: "participantParticipated",
+      header: ({ column }) => <DataTableColumnHeaderSimple column={column} title="참여협력사" />,
+      cell: ({ row }) => (
+        <Button
+          variant="ghost"
+          size="sm"
+          className="h-auto p-1 hover:bg-green-50"
+          onClick={() => onParticipantClick?.(row.original.id, 'participated')}
+          disabled={row.original.participantParticipated === 0}
+        >
+          <div className="flex items-center gap-1">
+            <CheckCircle className="h-4 w-4 text-green-500" />
+            <span className="text-sm font-medium">{row.original.participantParticipated}</span>
+          </div>
+        </Button>
+      ),
+      size: 100,
+      meta: { excelHeader: "참여협력사" },
+    },
+
+    // ░░░ 포기협력사 ░░░
+    {
+      id: "participantDeclined",
+      header: ({ column }) => <DataTableColumnHeaderSimple column={column} title="포기협력사" />,
+      cell: ({ row }) => (
+        <Button
+          variant="ghost"
+          size="sm"
+          className="h-auto p-1 hover:bg-red-50"
+          onClick={() => onParticipantClick?.(row.original.id, 'declined')}
+          disabled={row.original.participantDeclined === 0}
+        >
+          <div className="flex items-center gap-1">
+            <XCircle className="h-4 w-4 text-red-500" />
+            <span className="text-sm font-medium">{row.original.participantDeclined}</span>
+          </div>
+        </Button>
+      ),
+      size: 100,
+      meta: { excelHeader: "포기협력사" },
+    },
+
+    // ░░░ 미제출협력사 ░░░
+    {
+      id: "participantPending",
+      header: ({ column }) => <DataTableColumnHeaderSimple column={column} title="미제출협력사" />,
+      cell: ({ row }) => (
+        <Button
+          variant="ghost"
+          size="sm"
+          className="h-auto p-1 hover:bg-yellow-50"
+          onClick={() => onParticipantClick?.(row.original.id, 'pending')}
+          disabled={row.original.participantPending === 0}
+        >
+          <div className="flex items-center gap-1">
+            <Clock className="h-4 w-4 text-yellow-500" />
+            <span className="text-sm font-medium">{row.original.participantPending}</span>
+          </div>
+        </Button>
+      ),
+      size: 100,
+      meta: { excelHeader: "미제출협력사" },
+    },
+
+    // ░░░ 개찰자명 ░░░
+    {
+      id: "openedBy",
+      header: ({ column }) => <DataTableColumnHeaderSimple column={column} title="개찰자명" />,
+      cell: ({ row }) => {
+        const openedBy = row.original.openedBy
+        return <span className="text-sm">{openedBy || '-'}</span>
+      },
+      size: 100,
+      meta: { excelHeader: "개찰자명" },
+    },
+
+    // ░░░ 개찰일 ░░░
+    {
+      id: "openedAt",
+      header: ({ column }) => <DataTableColumnHeaderSimple column={column} title="개찰일" />,
+      cell: ({ row }) => {
+        const openedAt = row.original.openedAt
+        return <span className="text-sm">{openedAt ? formatDate(openedAt, "KR") : '-'}</span>
+      },
+      size: 100,
+      meta: { excelHeader: "개찰일" },
+    },
+
+    // ░░░ 등록자 ░░░
+    {
+      accessorKey: "createdBy",
+      header: ({ column }) => <DataTableColumnHeaderSimple column={column} title="등록자" />,
+      cell: ({ row }) => (
+        <span className="text-sm">{row.original.createdBy || '-'}</span>
+      ),
+      size: 100,
+      meta: { excelHeader: "등록자" },
+    },
+
+    // ░░░ 등록일시 ░░░
+    {
+      accessorKey: "createdAt",
+      header: ({ column }) => <DataTableColumnHeaderSimple column={column} title="등록일시" />,
+      cell: ({ row }) => (
+        <span className="text-sm">{row.original.createdAt ? formatDate(row.original.createdAt, "KR") : '-'}</span>
+      ),
+      size: 100,
+      meta: { excelHeader: "등록일시" },
+    },
+
+    // ═══════════════════════════════════════════════════════════════
+    // 액션
+    // ═══════════════════════════════════════════════════════════════
+    // {
+    //   id: "actions",
+    //   header: "액션",
+    //   cell: ({ row }) => (
+    //     <DropdownMenu>
+    //       <DropdownMenuTrigger asChild>
+    //         <Button variant="ghost" className="h-8 w-8 p-0">
+    //           <span className="sr-only">메뉴 열기</span>
+    //           <AlertTriangle className="h-4 w-4" />
+    //         </Button>
+    //       </DropdownMenuTrigger>
+    //       <DropdownMenuContent align="end">
+    //         <DropdownMenuItem onClick={() => setRowAction({ row, type: "view" })}>
+    //           <Eye className="mr-2 h-4 w-4" />
+    //           상세보기
+    //         </DropdownMenuItem>
+    //       </DropdownMenuContent>
+    //     </DropdownMenu>
+    //   ),
+    //   size: 50,
+    //   enableSorting: false,
+    //   enableHiding: false,
+    // },
+  ]
+}