(김준회) 조달담당자 선택기 구현 및 users 테이블에 조달담당자 컬럼 추가

1 files changed, 466 insertions, 0 deletions

diff --git a/components/common/selectors/procurement-manager/procurement-manager-multi-selector.tsx b/components/common/selectors/procurement-manager/procurement-manager-multi-selector.tsx
new file mode 100644
index 00000000..8d2f2afa
--- /dev/null
+++ b/components/common/selectors/procurement-manager/procurement-manager-multi-selector.tsx
@@ -0,0 +1,466 @@
+'use client'
+
+/**
+ * 조달담당자 다중 선택 다이얼로그
+ * 
+ * @description
+ * - 여러 조달담당자를 선택할 수 있는 다이얼로그
+ * - 체크박스를 통한 다중 선택
+ * - 선택된 조달담당자들을 상단에 표시
+ * - 확인/취소 버튼으로 선택 확정
+ * - 선택 시 각 담당자에 대한 사용자 정보도 함께 반환
+ */
+
+import { useState, useCallback, useMemo, useTransition } from 'react'
+import { Button } from '@/components/ui/button'
+import { Dialog, DialogContent, DialogHeader, DialogTitle, DialogFooter } from '@/components/ui/dialog'
+import { Input } from '@/components/ui/input'
+import { Checkbox } from '@/components/ui/checkbox'
+import { Badge } from '@/components/ui/badge'
+import { Search, Check, X, Trash2 } from 'lucide-react'
+import { 
+  ColumnDef,
+  flexRender,
+  getCoreRowModel,
+  getFilteredRowModel,
+  getPaginationRowModel,
+  getSortedRowModel,
+  useReactTable,
+  SortingState,
+  ColumnFiltersState,
+  VisibilityState,
+  RowSelectionState,
+} from '@tanstack/react-table'
+import {
+  Table,
+  TableBody,
+  TableCell,
+  TableHead,
+  TableHeader,
+  TableRow,
+} from '@/components/ui/table'
+import { 
+  getProcurementManagers, 
+  addUsersToManagersAsync,
+  ProcurementManager, 
+  ProcurementManagerWithUser
+} from './procurement-manager-service'
+import { toast } from 'sonner'
+
+// 간단한 디바운스 함수
+function debounce<T extends (...args: unknown[]) => void>(func: T, delay: number): T {
+  let timeoutId: NodeJS.Timeout
+  return ((...args: Parameters<T>) => {
+    clearTimeout(timeoutId)
+    timeoutId = setTimeout(() => func(...args), delay)
+  }) as T
+}
+
+export interface ProcurementManagerMultiSelectorProps {
+  open: boolean
+  onOpenChange: (open: boolean) => void
+  selectedManagers?: ProcurementManagerWithUser[]
+  onManagersSelect: (managers: ProcurementManagerWithUser[]) => void
+  onConfirm?: (managers: ProcurementManagerWithUser[]) => void
+  onCancel?: () => void
+  title?: string
+  description?: string
+  maxSelection?: number
+}
+
+export function ProcurementManagerMultiSelector({ 
+  open,
+  onOpenChange,
+  selectedManagers = [], 
+  onManagersSelect, 
+  onConfirm,
+  onCancel,
+  title = "조달담당자 다중 선택",
+  description = "여러 조달담당자를 선택하세요",
+  maxSelection
+}: ProcurementManagerMultiSelectorProps) {
+  const [managers, setManagers] = useState<ProcurementManager[]>([])
+  const [sorting, setSorting] = useState<SortingState>([])
+  const [columnFilters, setColumnFilters] = useState<ColumnFiltersState>([])
+  const [columnVisibility, setColumnVisibility] = useState<VisibilityState>({})
+  const [rowSelection, setRowSelection] = useState<RowSelectionState>({})
+  const [globalFilter, setGlobalFilter] = useState('')
+  const [isPending, startTransition] = useTransition()
+  const [tempSelectedManagers, setTempSelectedManagers] = useState<ProcurementManager[]>(
+    selectedManagers.map(m => ({
+      PROCUREMENT_MANAGER_CODE: m.PROCUREMENT_MANAGER_CODE,
+      DISPLAY_NAME: m.DISPLAY_NAME,
+      DEPARTMENT_NAME: m.DEPARTMENT_NAME,
+      EMPLOYEE_NUMBER: m.EMPLOYEE_NUMBER,
+      DEPARTMENT_CODE: m.DEPARTMENT_CODE,
+      IS_ACTIVE: m.IS_ACTIVE
+    }))
+  )
+
+  // 조달담당자 선택/해제 핸들러
+  const handleManagerToggle = useCallback((manager: ProcurementManager, checked: boolean) => {
+    setTempSelectedManagers(prev => {
+      if (checked) {
+        // 최대 선택 수 제한 확인
+        if (maxSelection && prev.length >= maxSelection) {
+          toast.warning(`최대 ${maxSelection}개까지 선택할 수 있습니다.`)
+          return prev
+        }
+        // 이미 선택된 담당자인지 확인
+        if (prev.some(m => m.PROCUREMENT_MANAGER_CODE === manager.PROCUREMENT_MANAGER_CODE)) {
+          return prev
+        }
+        return [...prev, manager]
+      } else {
+        return prev.filter(m => m.PROCUREMENT_MANAGER_CODE !== manager.PROCUREMENT_MANAGER_CODE)
+      }
+    })
+  }, [maxSelection])
+
+  // 개별 담당자 제거 핸들러
+  const handleRemoveManager = useCallback((procurementManagerCode: string) => {
+    setTempSelectedManagers(prev => prev.filter(m => m.PROCUREMENT_MANAGER_CODE !== procurementManagerCode))
+  }, [])
+
+  // 모든 선택 해제 핸들러
+  const handleClearAll = useCallback(() => {
+    setTempSelectedManagers([])
+  }, [])
+
+  // 확인 버튼 핸들러 (사용자 정보 포함하여 반환)
+  const handleConfirm = useCallback(async () => {
+    try {
+      // 선택된 담당자들에 대해 사용자 정보 추가
+      const managersWithUsers = await addUsersToManagersAsync(tempSelectedManagers)
+      
+      onManagersSelect(managersWithUsers)
+      onConfirm?.(managersWithUsers)
+      onOpenChange(false)
+    } catch (error) {
+      console.error('조달담당자 정보 조회 오류:', error)
+      toast.error('조달담당자 정보를 가져오는 중 오류가 발생했습니다.')
+    }
+  }, [tempSelectedManagers, onManagersSelect, onConfirm, onOpenChange])
+
+  // 취소 버튼 핸들러
+  const handleCancel = useCallback(() => {
+    setTempSelectedManagers(
+      selectedManagers.map(m => ({
+        PROCUREMENT_MANAGER_CODE: m.PROCUREMENT_MANAGER_CODE,
+        DISPLAY_NAME: m.DISPLAY_NAME,
+        DEPARTMENT_NAME: m.DEPARTMENT_NAME,
+        EMPLOYEE_NUMBER: m.EMPLOYEE_NUMBER,
+        DEPARTMENT_CODE: m.DEPARTMENT_CODE,
+        IS_ACTIVE: m.IS_ACTIVE
+      }))
+    )
+    onCancel?.()
+    onOpenChange(false)
+  }, [selectedManagers, onCancel, onOpenChange])
+
+  // 테이블 컬럼 정의
+  const columns: ColumnDef<ProcurementManager>[] = useMemo(() => [
+    {
+      id: 'select',
+      header: ({ table }) => (
+        <Checkbox
+          checked={table.getIsAllPageRowsSelected()}
+          onCheckedChange={(value) => {
+            if (value) {
+              // 페이지의 모든 행을 선택하되, 최대 선택 수 제한 확인
+              const currentPageRows = table.getRowModel().rows
+              const newSelections = currentPageRows
+                .map(row => row.original)
+                .filter(manager => !tempSelectedManagers.some(m => m.PROCUREMENT_MANAGER_CODE === manager.PROCUREMENT_MANAGER_CODE))
+              
+              if (maxSelection) {
+                const remainingSlots = maxSelection - tempSelectedManagers.length
+                if (newSelections.length > remainingSlots) {
+                  toast.warning(`최대 ${maxSelection}개까지 선택할 수 있습니다.`)
+                  return
+                }
+              }
+              
+              setTempSelectedManagers(prev => [...prev, ...newSelections])
+            } else {
+              // 페이지의 모든 행 선택 해제
+              const currentPageCodes = table.getRowModel().rows.map(row => row.original.PROCUREMENT_MANAGER_CODE)
+              setTempSelectedManagers(prev => prev.filter(m => !currentPageCodes.includes(m.PROCUREMENT_MANAGER_CODE)))
+            }
+          }}
+          aria-label="모든 행 선택"
+        />
+      ),
+      cell: ({ row }) => {
+        const isSelected = tempSelectedManagers.some(m => m.PROCUREMENT_MANAGER_CODE === row.original.PROCUREMENT_MANAGER_CODE)
+        return (
+          <Checkbox
+            checked={isSelected}
+            onCheckedChange={(value) => handleManagerToggle(row.original, !!value)}
+            aria-label="행 선택"
+          />
+        )
+      },
+      enableSorting: false,
+      enableHiding: false,
+    },
+    {
+      accessorKey: 'PROCUREMENT_MANAGER_CODE',
+      header: '조달담당자코드',
+      cell: ({ row }) => (
+        <div className="font-mono text-sm">{row.getValue('PROCUREMENT_MANAGER_CODE')}</div>
+      ),
+    },
+    {
+      accessorKey: 'DISPLAY_NAME',
+      header: '담당자명',
+      cell: ({ row }) => (
+        <div>{row.getValue('DISPLAY_NAME')}</div>
+      ),
+    },
+    {
+      accessorKey: 'DEPARTMENT_NAME',
+      header: '부서명',
+      cell: ({ row }) => (
+        <div className="text-sm text-muted-foreground">{row.getValue('DEPARTMENT_NAME')}</div>
+      ),
+    },
+  ], [handleManagerToggle, tempSelectedManagers, maxSelection])
+
+  // 조달담당자 테이블 설정
+  const table = useReactTable({
+    data: managers,
+    columns,
+    onSortingChange: setSorting,
+    onColumnFiltersChange: setColumnFilters,
+    onColumnVisibilityChange: setColumnVisibility,
+    onRowSelectionChange: setRowSelection,
+    onGlobalFilterChange: setGlobalFilter,
+    getCoreRowModel: getCoreRowModel(),
+    getPaginationRowModel: getPaginationRowModel(),
+    getSortedRowModel: getSortedRowModel(),
+    getFilteredRowModel: getFilteredRowModel(),
+    state: {
+      sorting,
+      columnFilters,
+      columnVisibility,
+      rowSelection,
+      globalFilter,
+    },
+  })
+
+  // 서버에서 조달담당자 전체 목록 로드 (한 번만)
+  const loadManagers = useCallback(async () => {
+    startTransition(async () => {
+      try {
+        const result = await getProcurementManagers()
+        
+        if (result.success) {
+          setManagers(result.data)
+        } else {
+          toast.error(result.error || '조달담당자를 불러오는데 실패했습니다.')
+          setManagers([])
+        }
+      } catch (error) {
+        console.error('조달담당자 목록 로드 실패:', error)
+        toast.error('조달담당자를 불러오는 중 오류가 발생했습니다.')
+        setManagers([])
+      }
+    })
+  }, [])
+
+  // 다이얼로그 열기/닫기 핸들러
+  const handleDialogOpenChange = useCallback((newOpen: boolean) => {
+    onOpenChange(newOpen)
+    if (newOpen) {
+      setTempSelectedManagers(
+        selectedManagers.map(m => ({
+          PROCUREMENT_MANAGER_CODE: m.PROCUREMENT_MANAGER_CODE,
+          DISPLAY_NAME: m.DISPLAY_NAME,
+          DEPARTMENT_NAME: m.DEPARTMENT_NAME,
+          EMPLOYEE_NUMBER: m.EMPLOYEE_NUMBER,
+          DEPARTMENT_CODE: m.DEPARTMENT_CODE,
+          IS_ACTIVE: m.IS_ACTIVE
+        }))
+      )
+      if (managers.length === 0) {
+        loadManagers()
+      }
+    }
+  }, [onOpenChange, selectedManagers, loadManagers, managers.length])
+
+  // 검색어 변경 핸들러 (클라이언트 사이드 필터링)
+  const handleSearchChange = useCallback((value: string) => {
+    setGlobalFilter(value)
+  }, [])
+
+  return (
+    <Dialog open={open} onOpenChange={handleDialogOpenChange}>
+      <DialogContent className="max-w-6xl max-h-[85vh]">
+        <DialogHeader>
+          <DialogTitle>{title}</DialogTitle>
+          <div className="text-sm text-muted-foreground">
+            {description}
+            {maxSelection && ` (최대 ${maxSelection}개)`}
+          </div>
+        </DialogHeader>
+        
+        <div className="space-y-4">
+          {/* 선택된 조달담당자들 표시 */}
+          {tempSelectedManagers.length > 0 && (
+            <div className="space-y-2">
+              <div className="flex items-center justify-between">
+                <div className="text-sm font-medium">
+                  선택된 조달담당자 ({tempSelectedManagers.length}개)
+                  {maxSelection && ` / ${maxSelection}`}
+                </div>
+                <Button
+                  variant="outline"
+                  size="sm"
+                  onClick={handleClearAll}
+                  disabled={tempSelectedManagers.length === 0}
+                >
+                  <Trash2 className="h-4 w-4 mr-2" />
+                  모두 제거
+                </Button>
+              </div>
+              <div className="flex flex-wrap gap-2 max-h-24 overflow-y-auto p-2 border rounded-md bg-muted/30">
+                {tempSelectedManagers.map((manager) => (
+                  <Badge
+                    key={manager.PROCUREMENT_MANAGER_CODE}
+                    variant="secondary"
+                    className="text-xs"
+                  >
+                    [{manager.PROCUREMENT_MANAGER_CODE}] {manager.DISPLAY_NAME}
+                    {manager.DEPARTMENT_NAME && ` - ${manager.DEPARTMENT_NAME}`}
+                    <button
+                      onClick={() => handleRemoveManager(manager.PROCUREMENT_MANAGER_CODE)}
+                      className="ml-1 hover:text-destructive"
+                    >
+                      <X className="h-3 w-3" />
+                    </button>
+                  </Badge>
+                ))}
+              </div>
+            </div>
+          )}
+
+          <div className="flex items-center space-x-2">
+            <Search className="h-4 w-4" />
+            <Input
+              placeholder="조달담당자코드, 담당자명, 부서명으로 검색..."
+              value={globalFilter}
+              onChange={(e) => handleSearchChange(e.target.value)}
+              className="flex-1"
+            />
+          </div>
+
+          {isPending ? (
+            <div className="flex justify-center py-8">
+              <div className="text-sm text-muted-foreground">조달담당자를 불러오는 중...</div>
+            </div>
+          ) : (
+            <div className="border rounded-md">
+              <Table>
+                <TableHeader>
+                  {table.getHeaderGroups().map((headerGroup) => (
+                    <TableRow key={headerGroup.id}>
+                      {headerGroup.headers.map((header) => (
+                        <TableHead key={header.id}>
+                          {header.isPlaceholder
+                            ? null
+                            : flexRender(
+                                header.column.columnDef.header,
+                                header.getContext()
+                              )}
+                        </TableHead>
+                      ))}
+                    </TableRow>
+                  ))}
+                </TableHeader>
+                <TableBody>
+                  {table.getRowModel().rows?.length ? (
+                    table.getRowModel().rows.map((row) => {
+                      const isSelected = tempSelectedManagers.some(m => m.PROCUREMENT_MANAGER_CODE === row.original.PROCUREMENT_MANAGER_CODE)
+                      return (
+                        <TableRow
+                          key={row.id}
+                          data-state={isSelected && "selected"}
+                          className={`cursor-pointer hover:bg-muted/50 ${
+                            isSelected ? 'bg-muted/30' : ''
+                          }`}
+                          onClick={() => {
+                            const isCurrentlySelected = tempSelectedManagers.some(m => m.PROCUREMENT_MANAGER_CODE === row.original.PROCUREMENT_MANAGER_CODE)
+                            handleManagerToggle(row.original, !isCurrentlySelected)
+                          }}
+                        >
+                          {row.getVisibleCells().map((cell) => (
+                            <TableCell key={cell.id}>
+                              {flexRender(
+                                cell.column.columnDef.cell,
+                                cell.getContext()
+                              )}
+                            </TableCell>
+                          ))}
+                        </TableRow>
+                      )
+                    })
+                  ) : (
+                    <TableRow>
+                      <TableCell
+                        colSpan={columns.length}
+                        className="h-24 text-center"
+                      >
+                        검색 결과가 없습니다.
+                      </TableCell>
+                    </TableRow>
+                  )}
+                </TableBody>
+              </Table>
+            </div>
+          )}
+
+          <div className="flex items-center justify-between">
+            <div className="text-sm text-muted-foreground">
+              총 {table.getFilteredRowModel().rows.length}개 조달담당자
+            </div>
+            <div className="flex items-center space-x-2">
+              <Button
+                variant="outline"
+                size="sm"
+                onClick={() => table.previousPage()}
+                disabled={!table.getCanPreviousPage()}
+              >
+                이전
+              </Button>
+              <div className="text-sm">
+                {table.getState().pagination.pageIndex + 1} / {table.getPageCount()}
+              </div>
+              <Button
+                variant="outline"
+                size="sm"
+                onClick={() => table.nextPage()}
+                disabled={!table.getCanNextPage()}
+              >
+                다음
+              </Button>
+            </div>
+          </div>
+        </div>
+
+        <DialogFooter>
+          <Button variant="outline" onClick={handleCancel}>
+            <X className="h-4 w-4 mr-2" />
+            취소
+          </Button>
+          <Button onClick={handleConfirm}>
+            <Check className="h-4 w-4 mr-2" />
+            확인 ({tempSelectedManagers.length}개 선택)
+          </Button>
+        </DialogFooter>
+      </DialogContent>
+    </Dialog>
+  )
+}
+
+