(김준회) ITB 및 일반견적 선택시 구매담당자 선택을 구매그룹코드로 처리하도록 변경, 오라클 연결 불가한 경우 하드코딩된 폴백데이터 제공처리

1 files changed, 370 insertions, 0 deletions

diff --git a/components/common/selectors/purchase-group-code/purchase-group-code-single-selector.tsx b/components/common/selectors/purchase-group-code/purchase-group-code-single-selector.tsx
new file mode 100644
index 00000000..47a2c5f0
--- /dev/null
+++ b/components/common/selectors/purchase-group-code/purchase-group-code-single-selector.tsx
@@ -0,0 +1,370 @@
+'use client'
+
+/**
+ * 구매그룹코드 단일 선택 다이얼로그
+ * 
+ * @description
+ * - 구매그룹코드를 하나만 선택할 수 있는 다이얼로그
+ * - 트리거 버튼과 다이얼로그가 분리된 구조
+ * - 외부에서 open 상태를 제어 가능
+ * - 선택 시 사용자 정보도 함께 반환
+ */
+
+import { useState, useCallback, useMemo, useTransition, useEffect } 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 { Search, Check, X } 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 { 
+  getPurchaseGroupCodes, 
+  addUsersToCodesAsync,
+  PurchaseGroupCode, 
+  PurchaseGroupCodeWithUser
+} from './purchase-group-code-service'
+import { toast } from 'sonner'
+
+export interface PurchaseGroupCodeSingleSelectorProps {
+  open: boolean
+  onOpenChange: (open: boolean) => void
+  selectedCode?: PurchaseGroupCodeWithUser
+  onCodeSelect: (code: PurchaseGroupCodeWithUser) => void
+  onConfirm?: (code: PurchaseGroupCodeWithUser | undefined) => void
+  onCancel?: () => void
+  title?: string
+  description?: string
+  showConfirmButtons?: boolean
+}
+
+export function PurchaseGroupCodeSingleSelector({ 
+  open,
+  onOpenChange,
+  selectedCode, 
+  onCodeSelect, 
+  onConfirm,
+  onCancel,
+  title = "구매그룹코드 선택",
+  description = "구매그룹코드를 선택하세요",
+  showConfirmButtons = false
+}: PurchaseGroupCodeSingleSelectorProps) {
+  const [codes, setCodes] = useState<PurchaseGroupCode[]>([])
+  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 [tempSelectedCode, setTempSelectedCode] = useState<PurchaseGroupCodeWithUser | undefined>(selectedCode)
+
+  // 구매그룹코드 선택 핸들러
+  const handleCodeSelect = useCallback(async (code: PurchaseGroupCode) => {
+    try {
+      // 사용자 정보 추가
+      const [codeWithUser] = await addUsersToCodesAsync(code)
+      if (showConfirmButtons) {
+        setTempSelectedCode(codeWithUser)
+      } else {
+        onCodeSelect(codeWithUser)
+        onOpenChange(false)
+      }
+    } catch (error) {
+      console.error('구매그룹코드 선택 오류:', error)
+      toast.error('구매그룹코드 선택 중 오류가 발생했습니다.')
+    }
+  }, [onCodeSelect, onOpenChange, showConfirmButtons])
+
+  // 확인 버튼 핸들러
+  const handleConfirm = useCallback(() => {
+    if (tempSelectedCode) {
+      onCodeSelect(tempSelectedCode)
+    }
+    onConfirm?.(tempSelectedCode)
+    onOpenChange(false)
+  }, [tempSelectedCode, onCodeSelect, onConfirm, onOpenChange])
+
+  // 취소 버튼 핸들러
+  const handleCancel = useCallback(() => {
+    setTempSelectedCode(selectedCode)
+    onCancel?.()
+    onOpenChange(false)
+  }, [selectedCode, onCancel, onOpenChange])
+
+  // 테이블 컬럼 정의
+  const columns: ColumnDef<PurchaseGroupCode>[] = useMemo(() => [
+    {
+      accessorKey: 'PURCHASE_GROUP_CODE',
+      header: '구매그룹코드',
+      cell: ({ row }) => (
+        <div className="font-mono text-sm">{row.getValue('PURCHASE_GROUP_CODE')}</div>
+      ),
+    },
+    {
+      accessorKey: 'DISPLAY_NAME',
+      header: '이름',
+      cell: ({ row }) => (
+        <div className="max-w-[200px] truncate">{row.getValue('DISPLAY_NAME')}</div>
+      ),
+    },
+    {
+      accessorKey: 'EMPLOYEE_NUMBER',
+      header: '사번',
+      cell: ({ row }) => (
+        <div className="font-mono text-sm">{row.getValue('EMPLOYEE_NUMBER')}</div>
+      ),
+    },
+    {
+      id: 'actions',
+      header: '선택',
+      cell: ({ row }) => {
+        const isSelected = showConfirmButtons 
+          ? tempSelectedCode?.PURCHASE_GROUP_CODE === row.original.PURCHASE_GROUP_CODE
+          : selectedCode?.PURCHASE_GROUP_CODE === row.original.PURCHASE_GROUP_CODE
+        
+        return (
+          <Button
+            variant={isSelected ? "default" : "ghost"}
+            size="sm"
+            onClick={(e) => {
+              e.stopPropagation()
+              handleCodeSelect(row.original)
+            }}
+          >
+            <Check className="h-4 w-4" />
+          </Button>
+        )
+      },
+    },
+  ], [handleCodeSelect, selectedCode, tempSelectedCode, showConfirmButtons])
+
+  // 구매그룹코드 테이블 설정
+  const table = useReactTable({
+    data: codes,
+    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 loadCodes = useCallback(async () => {
+    startTransition(async () => {
+      try {
+        const result = await getPurchaseGroupCodes()
+        
+        if (result.success) {
+          setCodes(result.data)
+          
+          // 폴백 데이터를 사용하는 경우 알림
+          if (result.isUsingFallback) {
+            toast.info('Oracle 연결 실패', {
+              description: '테스트 데이터를 사용합니다.',
+              duration: 4000,
+            })
+          }
+        } else {
+          toast.error(result.error || '구매그룹코드를 불러오는데 실패했습니다.')
+          setCodes([])
+        }
+      } catch (error) {
+        console.error('구매그룹코드 목록 로드 실패:', error)
+        toast.error('구매그룹코드를 불러오는 중 오류가 발생했습니다.')
+        setCodes([])
+      }
+    })
+  }, [])
+
+  // 다이얼로그 열릴 때 코드 로드 (open prop 변화 감지)
+  useEffect(() => {
+    if (open) {
+      setTempSelectedCode(selectedCode)
+      if (codes.length === 0) {
+        console.log('🚀 [PurchaseGroupCodeSingleSelector] 다이얼로그 열림 - loadCodes 호출')
+        loadCodes()
+      } else {
+        console.log('📦 [PurchaseGroupCodeSingleSelector] 다이얼로그 열림 - 기존 데이터 사용 (' + codes.length + '건)')
+      }
+    }
+  }, [open, selectedCode, loadCodes, codes.length])
+
+  // 검색어 변경 핸들러 (클라이언트 사이드 필터링)
+  const handleSearchChange = useCallback((value: string) => {
+    setGlobalFilter(value)
+  }, [])
+
+  const currentSelectedCode = showConfirmButtons ? tempSelectedCode : selectedCode
+
+  return (
+    <Dialog open={open} onOpenChange={onOpenChange}>
+      <DialogContent className="max-w-5xl max-h-[80vh]">
+        <DialogHeader>
+          <DialogTitle>{title}</DialogTitle>
+          <div className="text-sm text-muted-foreground">
+            {description}
+          </div>
+        </DialogHeader>
+        
+        <div className="space-y-4">
+          {/* 현재 선택된 구매그룹코드 표시 */}
+          {currentSelectedCode && (
+            <div className="p-3 bg-muted rounded-md">
+              <div className="text-sm font-medium">선택된 구매그룹코드:</div>
+              <div className="flex items-center gap-2 mt-1">
+                <span className="font-mono text-sm">[{currentSelectedCode.PURCHASE_GROUP_CODE}]</span>
+                <span>{currentSelectedCode.DISPLAY_NAME}</span>
+                {currentSelectedCode.user && (
+                  <span className="text-muted-foreground">({currentSelectedCode.user.name})</span>
+                )}
+              </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 isRowSelected = currentSelectedCode?.PURCHASE_GROUP_CODE === row.original.PURCHASE_GROUP_CODE
+                      return (
+                        <TableRow
+                          key={row.id}
+                          data-state={isRowSelected && "selected"}
+                          className={`cursor-pointer hover:bg-muted/50 ${
+                            isRowSelected ? 'bg-muted' : ''
+                          }`}
+                          onClick={() => handleCodeSelect(row.original)}
+                        >
+                          {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>
+
+        {showConfirmButtons && (
+          <DialogFooter>
+            <Button variant="outline" onClick={handleCancel}>
+              <X className="h-4 w-4 mr-2" />
+              취소
+            </Button>
+            <Button onClick={handleConfirm} disabled={!tempSelectedCode}>
+              <Check className="h-4 w-4 mr-2" />
+              확인
+            </Button>
+          </DialogFooter>
+        )}
+      </DialogContent>
+    </Dialog>
+  )
+}
+