feat: POA 관련 파일 추가 및 contract 스키마 수정

5 files changed, 597 insertions, 0 deletions

diff --git a/lib/poa/service.ts b/lib/poa/service.ts
new file mode 100644
index 00000000..a11cbdd8
--- /dev/null
+++ b/lib/poa/service.ts
@@ -0,0 +1,132 @@
+"use server";
+
+import db from "@/db/db";
+import { GetChangeOrderSchema } from "./validations";
+import { unstable_cache } from "@/lib/unstable-cache";
+import { filterColumns } from "@/lib/filter-columns";
+import {
+  asc,
+  desc,
+  ilike,
+  and,
+  or,
+  count,
+} from "drizzle-orm";
+
+import {
+  poaDetailView,
+} from "@/db/schema/contract";
+
+/**
+ * POA 목록 조회
+ */
+export async function getChangeOrders(input: GetChangeOrderSchema) {
+  return unstable_cache(
+    async () => {
+      try {
+        const offset = (input.page - 1) * input.perPage;
+
+        // 1. Build where clause
+        let advancedWhere;
+        try {
+          advancedWhere = filterColumns({
+            table: poaDetailView,
+            filters: input.filters,
+            joinOperator: input.joinOperator,
+          });
+        } catch (whereErr) {
+          console.error("Error building advanced where:", whereErr);
+          advancedWhere = undefined;
+        }
+
+        let globalWhere;
+        if (input.search) {
+          try {
+            const s = `%${input.search}%`;
+            globalWhere = or(
+              ilike(poaDetailView.contractNo, s),
+              ilike(poaDetailView.originalContractName, s),
+              ilike(poaDetailView.projectCode, s),
+              ilike(poaDetailView.projectName, s),
+              ilike(poaDetailView.vendorName, s)
+            );
+          } catch (searchErr) {
+            console.error("Error building search where:", searchErr);
+            globalWhere = undefined;
+          }
+        }
+
+        // 2. Combine where clauses
+        let finalWhere;
+        if (advancedWhere && globalWhere) {
+          finalWhere = and(advancedWhere, globalWhere);
+        } else {
+          finalWhere = advancedWhere || globalWhere;
+        }
+
+        // 3. Build order by
+        let orderBy;
+        try {
+          orderBy =
+            input.sort.length > 0
+              ? input.sort.map((item) =>
+                  item.desc
+                    ? desc(poaDetailView[item.id])
+                    : asc(poaDetailView[item.id])
+                )
+              : [desc(poaDetailView.createdAt)];
+        } catch (orderErr) {
+          console.error("Error building order by:", orderErr);
+          orderBy = [desc(poaDetailView.createdAt)];
+        }
+
+        // 4. Execute queries
+        let data = [];
+        let total = 0;
+
+        try {
+          const queryBuilder = db.select().from(poaDetailView);
+
+          if (finalWhere) {
+            queryBuilder.where(finalWhere);
+          }
+
+          queryBuilder.orderBy(...orderBy);
+          queryBuilder.offset(offset).limit(input.perPage);
+
+          data = await queryBuilder;
+
+          const countBuilder = db
+            .select({ count: count() })
+            .from(poaDetailView);
+
+          if (finalWhere) {
+            countBuilder.where(finalWhere);
+          }
+
+          const countResult = await countBuilder;
+          total = countResult[0]?.count || 0;
+        } catch (queryErr) {
+          console.error("Query execution failed:", queryErr);
+          throw queryErr;
+        }
+
+        const pageCount = Math.ceil(total / input.perPage);
+
+        return { data, pageCount };
+      } catch (err) {
+        console.error("Error in getChangeOrders:", err);
+        if (err instanceof Error) {
+          console.error("Error message:", err.message);
+          console.error("Error stack:", err.stack);
+        }
+        return { data: [], pageCount: 0 };
+      }
+    },
+    [JSON.stringify(input)],
+    {
+      revalidate: 3600,
+      tags: [`poa`],
+    }
+  )();
+} 
\ No newline at end of file
diff --git a/lib/poa/table/poa-table-columns.tsx b/lib/poa/table/poa-table-columns.tsx
new file mode 100644
index 00000000..b362e54c
--- /dev/null
+++ b/lib/poa/table/poa-table-columns.tsx
@@ -0,0 +1,165 @@
+"use client"
+
+import * as React from "react"
+import { type DataTableRowAction } from "@/types/table"
+import { type ColumnDef } from "@tanstack/react-table"
+import { InfoIcon, PenIcon } from "lucide-react"
+
+import { formatDate } from "@/lib/utils"
+import { Button } from "@/components/ui/button"
+import {
+  Tooltip,
+  TooltipContent,
+  TooltipProvider,
+  TooltipTrigger,
+} from "@/components/ui/tooltip"
+import { DataTableColumnHeaderSimple } from "@/components/data-table/data-table-column-simple-header"
+import { POADetail } from "@/db/schema/contract"
+import { poaColumnsConfig } from "@/config/poaColumnsConfig"
+
+interface GetColumnsProps {
+  setRowAction: React.Dispatch<React.SetStateAction<DataTableRowAction<POADetail> | null>>
+}
+
+/**
+ * tanstack table column definitions with nested headers
+ */
+export function getColumns({ setRowAction }: GetColumnsProps): ColumnDef<POADetail>[] {
+  // ----------------------------------------------------------------
+  // 1) actions column (buttons for item info)
+  // ----------------------------------------------------------------
+  const actionsColumn: ColumnDef<POADetail> = {
+    id: "actions",
+    enableHiding: false,
+    cell: function Cell({ row }) {
+      const hasSignature = row.original.hasSignature;
+      
+      return (
+        <div className="flex items-center space-x-1">
+          {/* Item Info Button */}
+          <TooltipProvider>
+            <Tooltip>
+              <TooltipTrigger asChild>
+                <Button
+                  variant="ghost"
+                  size="icon"
+                  onClick={() => setRowAction({ row, type: "items" })}
+                >
+                  <InfoIcon className="h-4 w-4" aria-hidden="true" />
+                </Button>
+              </TooltipTrigger>
+              <TooltipContent>
+                View Item Info
+              </TooltipContent>
+            </Tooltip>
+          </TooltipProvider>
+          
+          {/* Signature Request Button - only show if no signature exists */}
+          {!hasSignature && (
+            <TooltipProvider>
+              <Tooltip>
+                <TooltipTrigger asChild>
+                  <Button
+                    variant="ghost"
+                    size="icon"
+                    onClick={() => setRowAction({ row, type: "signature" })}
+                  >
+                    <PenIcon className="h-4 w-4" aria-hidden="true" />
+                  </Button>
+                </TooltipTrigger>
+                <TooltipContent>
+                  Request Electronic Signature
+                </TooltipContent>
+              </Tooltip>
+            </TooltipProvider>
+          )}
+        </div>
+      );
+    },
+    size: 80,
+  };
+
+  // ----------------------------------------------------------------
+  // 2) Regular columns grouped by group name
+  // ----------------------------------------------------------------
+  // 2-1) groupMap: { [groupName]: ColumnDef<POADetail>[] }
+  const groupMap: Record<string, ColumnDef<POADetail>[]> = {};
+
+  poaColumnsConfig.forEach((cfg) => {
+    // Use "_noGroup" if no group is specified
+    const groupName = cfg.group || "_noGroup";
+
+    if (!groupMap[groupName]) {
+      groupMap[groupName] = [];
+    }
+
+    // Child column definition
+    const childCol: ColumnDef<POADetail> = {
+      accessorKey: cfg.id,
+      enableResizing: true,
+      header: ({ column }) => (
+        <DataTableColumnHeaderSimple column={column} title={cfg.label} />
+      ),
+      meta: {
+        excelHeader: cfg.excelHeader,
+        group: cfg.group,
+        type: cfg.type,
+      },
+      cell: ({ cell }) => {
+        const value = cell.getValue();
+
+        if (cfg.type === "date") {
+          const dateVal = value as Date;
+          return (
+            <div className="text-sm">
+              {formatDate(dateVal)}
+            </div>
+          );
+        }
+        if (cfg.type === "number") {
+          const numVal = value as number;
+          return (
+            <div className="text-sm">
+              {numVal ? numVal.toLocaleString() : "-"}
+            </div>
+          );
+        }
+        return (
+          <div className="text-sm">
+            {value ?? "-"}
+          </div>
+        );
+      },
+    };
+
+    groupMap[groupName].push(childCol);
+  });
+
+  // ----------------------------------------------------------------
+  // 2-2) Create actual parent columns (groups) from the groupMap
+  // ----------------------------------------------------------------
+  const nestedColumns: ColumnDef<POADetail>[] = [];
+
+  // Order can be fixed by pre-defining group order or sorting
+  Object.entries(groupMap).forEach(([groupName, colDefs]) => {
+    if (groupName === "_noGroup") {
+      // No group → Add as top-level columns
+      nestedColumns.push(...colDefs);
+    } else {
+      // Parent column
+      nestedColumns.push({
+        id: groupName,
+        header: groupName,
+        columns: colDefs,
+      });
+    }
+  });
+
+  // ----------------------------------------------------------------
+  // 3) Final column array: nestedColumns + actionsColumn
+  // ----------------------------------------------------------------
+  return [
+    ...nestedColumns,
+    actionsColumn,
+  ];
+} 
\ No newline at end of file
diff --git a/lib/poa/table/poa-table-toolbar-actions.tsx b/lib/poa/table/poa-table-toolbar-actions.tsx
new file mode 100644
index 00000000..97a9cc55
--- /dev/null
+++ b/lib/poa/table/poa-table-toolbar-actions.tsx
@@ -0,0 +1,45 @@
+"use client"
+
+import * as React from "react"
+import { type Table } from "@tanstack/react-table"
+import { Download, RefreshCcw } from "lucide-react"
+
+import { exportTableToExcel } from "@/lib/export"
+import { Button } from "@/components/ui/button"
+import { POADetail } from "@/db/schema/contract"
+
+interface ItemsTableToolbarActionsProps {
+  table: Table<POADetail>
+}
+
+export function PoaTableToolbarActions({ table }: ItemsTableToolbarActionsProps) {
+  return (
+    <div className="flex items-center gap-2">
+      {/** Refresh 버튼 */}
+      <Button
+        variant="samsung"
+        size="sm"
+        className="gap-2"
+      >
+        <RefreshCcw className="size-4" aria-hidden="true" />
+        <span className="hidden sm:inline">Get POAs</span>
+      </Button>
+
+      {/** Export 버튼 */}
+      <Button
+        variant="outline"
+        size="sm"
+        onClick={() =>
+          exportTableToExcel(table, {
+            filename: "poa-list",
+            excludeColumns: ["select", "actions"],
+          })
+        }
+        className="gap-2"
+      >
+        <Download className="size-4" aria-hidden="true" />
+        <span className="hidden sm:inline">Export</span>
+      </Button>
+    </div>
+  )
+} 
\ No newline at end of file
diff --git a/lib/poa/table/poa-table.tsx b/lib/poa/table/poa-table.tsx
new file mode 100644
index 00000000..a5cad02a
--- /dev/null
+++ b/lib/poa/table/poa-table.tsx
@@ -0,0 +1,189 @@
+"use client"
+
+import * as React from "react"
+import type {
+  DataTableAdvancedFilterField,
+  DataTableFilterField,
+  DataTableRowAction,
+} from "@/types/table"
+
+import { useDataTable } from "@/hooks/use-data-table"
+import { DataTable } from "@/components/data-table/data-table"
+import { DataTableAdvancedToolbar } from "@/components/data-table/data-table-advanced-toolbar"
+
+import { getChangeOrders } from "../service"
+import { POADetail } from "@/db/schema/contract"
+import { getColumns } from "./poa-table-columns"
+import { PoaTableToolbarActions } from "./poa-table-toolbar-actions"
+
+interface ItemsTableProps {
+  promises: Promise<
+    [
+      Awaited<ReturnType<typeof getChangeOrders>>,
+    ]
+  >
+}
+
+export function ChangeOrderListsTable({ promises }: ItemsTableProps) {
+  const [result] = React.use(promises)
+  const { data, pageCount } = result
+    
+  const [rowAction, setRowAction] = 
+    React.useState<DataTableRowAction<POADetail> | null>(null)
+    
+  // Handle row actions
+  React.useEffect(() => {
+    if (!rowAction) return
+    
+    if (rowAction.type === "items") {
+      // Handle items view action
+      setRowAction(null)
+    }
+  }, [rowAction])
+  
+  const columns = React.useMemo(
+    () => getColumns({ setRowAction }),
+    [setRowAction]
+  )
+
+  const filterFields: DataTableFilterField<POADetail>[] = [
+    {
+      id: "contractNo",
+      label: "계약번호",
+    },
+    {
+      id: "originalContractName",
+      label: "계약명",
+    },
+    {
+      id: "approvalStatus",
+      label: "승인 상태",
+    },
+  ]
+
+  const advancedFilterFields: DataTableAdvancedFilterField<POADetail>[] = [
+    {
+      id: "contractNo",
+      label: "계약번호",
+      type: "text",
+    },
+    {
+      id: "originalContractName",
+      label: "계약명",
+      type: "text",
+    },
+    {
+      id: "projectId",
+      label: "프로젝트 ID",
+      type: "number",
+    },
+    {
+      id: "vendorId",
+      label: "벤더 ID",
+      type: "number",
+    },
+    {
+      id: "originalStatus",
+      label: "상태",
+      type: "text",
+    },
+    {
+      id: "deliveryTerms",
+      label: "납품조건",
+      type: "text",
+    },
+    {
+      id: "deliveryDate",
+      label: "납품기한",
+      type: "date",
+    },
+    {
+      id: "deliveryLocation",
+      label: "납품장소",
+      type: "text",
+    },
+    {
+      id: "currency",
+      label: "통화",
+      type: "text",
+    },
+    {
+      id: "totalAmount",
+      label: "총 금액",
+      type: "number",
+    },
+    {
+      id: "discount",
+      label: "할인",
+      type: "number",
+    },
+    {
+      id: "tax",
+      label: "세금",
+      type: "number",
+    },
+    {
+      id: "shippingFee",
+      label: "배송비",
+      type: "number",
+    },
+    {
+      id: "netTotal",
+      label: "최종 금액",
+      type: "number",
+    },
+    {
+      id: "changeReason",
+      label: "변경 사유",
+      type: "text",
+    },
+    {
+      id: "approvalStatus",
+      label: "승인 상태",
+      type: "text",
+    },
+    {
+      id: "createdAt",
+      label: "생성일",
+      type: "date",
+    },
+    {
+      id: "updatedAt",
+      label: "수정일",
+      type: "date",
+    },
+  ]
+  
+  const { table } = useDataTable({
+    data,
+    columns,
+    pageCount,
+    filterFields,
+    enablePinning: true,
+    enableAdvancedFilter: true,
+    initialState: {
+      sorting: [{ id: "createdAt", desc: true }],
+      columnPinning: { right: ["actions"] },
+    },
+    getRowId: (originalRow) => String(originalRow.id),
+    shallow: false,
+    clearOnDefault: true,
+  })
+
+  return (
+    <>
+      <DataTable
+        table={table}
+        className="h-[calc(100vh-12rem)]"
+      >
+        <DataTableAdvancedToolbar
+          table={table}
+          filterFields={advancedFilterFields}
+          shallow={false}
+        >
+          <PoaTableToolbarActions table={table} />
+        </DataTableAdvancedToolbar>
+      </DataTable>
+    </>
+  )
+} 
\ No newline at end of file
diff --git a/lib/poa/validations.ts b/lib/poa/validations.ts
new file mode 100644
index 00000000..eae1b5ab
--- /dev/null
+++ b/lib/poa/validations.ts
@@ -0,0 +1,66 @@
+import {
+  createSearchParamsCache,
+  parseAsArrayOf,
+  parseAsInteger,
+  parseAsString,
+  parseAsStringEnum,
+} from "nuqs/server"
+import * as z from "zod"
+
+import { getFiltersStateParser, getSortingStateParser } from "@/lib/parsers"
+import { POADetail } from "@/db/schema/contract"
+
+export const searchParamsCache = createSearchParamsCache({
+  // UI 모드나 플래그 관련
+  flags: parseAsArrayOf(z.enum(["advancedTable", "floatingBar"])).withDefault([]),
+
+  // 페이징
+  page: parseAsInteger.withDefault(1),
+  perPage: parseAsInteger.withDefault(10),
+
+  // 정렬 (createdAt 기준 내림차순)
+  sort: getSortingStateParser<POADetail>().withDefault([
+    { id: "createdAt", desc: true },
+  ]),
+
+  // 원본 PO 관련
+  contractNo: parseAsString.withDefault(""),
+  originalContractName: parseAsString.withDefault(""),
+  originalStatus: parseAsString.withDefault(""),
+  originalStartDate: parseAsString.withDefault(""),
+  originalEndDate: parseAsString.withDefault(""),
+
+  // 프로젝트 정보
+  projectId: parseAsString.withDefault(""),
+  projectCode: parseAsString.withDefault(""),
+  projectName: parseAsString.withDefault(""),
+
+  // 벤더 정보
+  vendorId: parseAsString.withDefault(""),
+  vendorName: parseAsString.withDefault(""),
+
+  // 납품 관련
+  deliveryTerms: parseAsString.withDefault(""),
+  deliveryDate: parseAsString.withDefault(""),
+  deliveryLocation: parseAsString.withDefault(""),
+
+  // 금액 관련
+  currency: parseAsString.withDefault(""),
+  totalAmount: parseAsString.withDefault(""),
+  discount: parseAsString.withDefault(""),
+  tax: parseAsString.withDefault(""),
+  shippingFee: parseAsString.withDefault(""),
+  netTotal: parseAsString.withDefault(""),
+
+  // 변경 사유 및 승인 상태
+  changeReason: parseAsString.withDefault(""),
+  approvalStatus: parseAsString.withDefault(""),
+
+  // 고급 필터(Advanced) & 검색
+  filters: getFiltersStateParser().withDefault([]),
+  joinOperator: parseAsStringEnum(["and", "or"]).withDefault("and"),
+  search: parseAsString.withDefault(""),
+})
+
+// 최종 타입
+export type GetChangeOrderSchema = Awaited<ReturnType<typeof searchParamsCache.parse>> 
\ No newline at end of file