From 6c11fccc84f4c84fa72ee01f9caad9f76f35cea2 Mon Sep 17 00:00:00 2001 From: dujinkim Date: Tue, 16 Sep 2025 09:20:58 +0000 Subject: (대표님, 최겸) 계약, 업로드 관련, 메뉴처리, 입찰, 프리쿼트, rfqLast관련, tbeLast관련 MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit --- lib/bidding/actions.ts | 226 ++++++ lib/bidding/detail/service.ts | 14 +- .../table/bidding-detail-vendor-create-dialog.tsx | 4 +- .../detail/table/bidding-detail-vendor-table.tsx | 32 +- .../bidding-detail-vendor-toolbar-actions.tsx | 68 +- .../list/biddings-table-toolbar-actions.tsx | 100 ++- lib/bidding/list/biddings-transmission-dialog.tsx | 159 ++++ lib/bidding/pre-quote/service.ts | 60 +- .../bidding-pre-quote-vendor-create-dialog.tsx | 4 +- lib/bidding/service.ts | 55 +- lib/bidding/vendor/partners-bidding-detail.tsx | 25 + .../vendor/partners-bidding-list-columns.tsx | 7 +- lib/bidding/vendor/partners-bidding-pre-quote.tsx | 33 +- lib/general-contracts/service.ts | 1 + lib/mail/templates/document-share.hbs | 216 ++++++ lib/rfq-last/compare-action.ts | 542 +++++++++++++- lib/rfq-last/contract-actions.ts | 297 ++++++++ lib/rfq-last/quotation-compare-view.tsx | 808 ++++++++++++++++----- lib/rfq-last/service.ts | 9 +- lib/rfq-last/vendor/rfq-vendor-table.tsx | 29 +- lib/tbe-last/service.ts | 132 ++++ lib/tbe-last/table/documents-sheet.tsx | 599 ++++++++------- lib/tbe-last/table/email-documents-dialog.tsx | 334 +++++++++ 23 files changed, 3152 insertions(+), 602 deletions(-) create mode 100644 lib/bidding/actions.ts create mode 100644 lib/bidding/list/biddings-transmission-dialog.tsx create mode 100644 lib/mail/templates/document-share.hbs create mode 100644 lib/rfq-last/contract-actions.ts create mode 100644 lib/tbe-last/table/email-documents-dialog.tsx (limited to 'lib') diff --git a/lib/bidding/actions.ts b/lib/bidding/actions.ts new file mode 100644 index 00000000..9aabd469 --- /dev/null +++ b/lib/bidding/actions.ts @@ -0,0 +1,226 @@ +"use server" + +import db from "@/db/db" +import { eq, and } from "drizzle-orm" +import { + biddings, + biddingCompanies, + prItemsForBidding, + vendors, + generalContracts, + generalContractItems +} from "@/db/schema" +import { createPurchaseOrder } from "@/lib/soap/ecc/send/create-po" +import { getCurrentSAPDate } from "@/lib/soap/utils" + +// TO Contract 서버 액션 +export async function transmitToContract(biddingId: number, userId: number) { + console.log('=== transmitToContract STARTED ===') + console.log('biddingId:', biddingId, 'userId:', userId) + + try { + // 1. 입찰 정보 조회 (단순 쿼리) + console.log('Querying bidding...') + const bidding = await db.select() + .from(biddings) + .where(eq(biddings.id, biddingId)) + .limit(1) + + if (!bidding || bidding.length === 0) { + throw new Error("입찰 정보를 찾을 수 없습니다.") + } + + const biddingData = bidding[0] + console.log('biddingData', biddingData) + + // 2. 낙찰된 업체들 조회 (별도 쿼리) + console.log('Querying bidding companies...') + let winnerCompaniesData = [] + try { + // 2.1 biddingCompanies만 먼저 조회 (join 제거) + console.log('Step 1: Querying biddingCompanies only...') + const biddingCompaniesRaw = await db.select() + .from(biddingCompanies) + .where( + and( + eq(biddingCompanies.biddingId, biddingId), + eq(biddingCompanies.isWinner, true) + ) + ) + + console.log('biddingCompaniesRaw:', biddingCompaniesRaw) + + // 2.2 각 company에 대한 vendor 정보 개별 조회 + for (const bc of biddingCompaniesRaw) { + console.log('Processing companyId:', bc.companyId) + + try { + const vendorData = await db.select() + .from(vendors) + .where(eq(vendors.id, bc.companyId)) + .limit(1) + + const vendor = vendorData.length > 0 ? vendorData[0] : null + console.log('Vendor data for', bc.companyId, ':', vendor) + + winnerCompaniesData.push({ + companyId: bc.companyId, + finalQuoteAmount: bc.finalQuoteAmount, + vendorCode: vendor?.vendorCode || null, + vendorName: vendor?.vendorName || null, + }) + } catch (vendorError) { + console.error('Vendor query error for', bc.companyId, ':', vendorError) + // vendor 정보 없이도 진행 + winnerCompaniesData.push({ + companyId: bc.companyId, + finalQuoteAmount: bc.finalQuoteAmount, + vendorCode: null, + vendorName: null, + }) + } + } + + console.log('winnerCompaniesData type:', typeof winnerCompaniesData) + console.log('winnerCompaniesData length:', winnerCompaniesData?.length) + console.log('winnerCompaniesData:', winnerCompaniesData) + } catch (queryError) { + console.error('Query error:', queryError) + throw new Error(`biddingCompanies 쿼리 실패: ${queryError}`) + } + + // 상태 검증 + console.log('biddingData.status', biddingData.status) + if (biddingData.status !== 'vendor_selected') { + throw new Error("업체 선정이 완료되지 않은 입찰입니다.") + } + + // 낙찰된 업체 검증 + if (winnerCompaniesData.length === 0) { + throw new Error("낙찰된 업체가 없습니다.") + } + + console.log('Processing', winnerCompaniesData.length, 'winner companies') + for (const winnerCompany of winnerCompaniesData) { + // 계약 번호 자동 생성 (현재 시간 기반) + const contractNumber = `CONTRACT-BID-${Date.now()}-${winnerCompany.companyId}` + console.log('contractNumber', contractNumber) + // general-contract 생성 + const contractResult = await db.insert(generalContracts).values({ + contractNumber, + revision: 0, + contractSourceType: 'bid', // 입찰에서 생성됨 + status: 'Draft', + category: biddingData.contractType as any, // 단가계약, 일반계약, 매각계약 + name: biddingData.title, + selectionMethod: '입찰', + vendorId: winnerCompany.companyId, + linkedBidNumber: biddingData.biddingNumber, + contractAmount: winnerCompany.finalQuoteAmount || undefined, + currency: biddingData.currency || 'KRW', + registeredById: userId, // TODO: 현재 사용자 ID로 변경 필요 + lastUpdatedById: userId, // TODO: 현재 사용자 ID로 변경 필요 + }).returning({ id: generalContracts.id }) + console.log('contractResult', contractResult) + const contractId = contractResult[0].id + + // 3. PR 아이템들로 general-contract-items 생성 (일단 생략) + console.log('Skipping PR items creation for now') + } + + return { success: true, message: `${winnerCompaniesData.length}개의 계약서가 생성되었습니다.` } + + } catch (error) { + console.error('TO Contract 실패:', error) + throw new Error(error instanceof Error ? error.message : '계약서 생성에 실패했습니다.') + } +} + +// TO PO 서버 액션 +export async function transmitToPO(biddingId: number) { + try { + // 1. 입찰 정보 및 낙찰 업체 조회 + const bidding = await db.query.biddings.findFirst({ + where: eq(biddings.id, biddingId), + with: { + biddingCompanies: { + where: eq(biddingCompanies.isWinner, true), // 낙찰된 업체만 + with: { + vendor: true + } + }, + prItemsForBidding: true + } + }) + + if (!bidding) { + throw new Error("입찰 정보를 찾을 수 없습니다.") + } + + if (bidding.status !== 'vendor_selected') { + throw new Error("업체 선정이 완료되지 않은 입찰입니다.") + } + + const winnerCompanies = bidding.biddingCompanies.filter(bc => bc.isWinner) + + if (winnerCompanies.length === 0) { + throw new Error("낙찰된 업체가 없습니다.") + } + + // 2. PO 데이터 구성 + const poData = { + T_Bidding_HEADER: winnerCompanies.map((company, index) => ({ + ANFNR: bidding.biddingNumber, + LIFNR: company.vendor?.vendorCode || `VENDOR${company.companyId}`, + ZPROC_IND: 'A', // 구매 처리 상태 + ANGNR: bidding.biddingNumber, + WAERS: bidding.currency || 'KRW', + ZTERM: '0001', // 기본 지급조건 + INCO1: 'FOB', + INCO2: 'Seoul, Korea', + MWSKZ: 'V0', // 세금 코드 + LANDS: 'KR', + ZRCV_DT: getCurrentSAPDate(), + ZATTEN_IND: 'Y', + IHRAN: getCurrentSAPDate(), + TEXT: `PO from Bidding: ${bidding.title}`, + })), + T_Bidding_ITEM: bidding.prItemsForBidding?.map((item, index) => ({ + ANFNR: bidding.biddingNumber, + ANFPS: (index + 1).toString().padStart(5, '0'), + LIFNR: winnerCompanies[0]?.vendor?.vendorCode || `VENDOR${winnerCompanies[0]?.companyId}`, + NETPR: item.annualUnitPrice?.toString() || '0', + PEINH: '1', + BPRME: item.quantityUnit || 'EA', + NETWR: item.annualUnitPrice && item.quantity + ? (item.annualUnitPrice * item.quantity).toString() + : '0', + BRTWR: item.annualUnitPrice && item.quantity + ? ((item.annualUnitPrice * item.quantity) * 1.1).toString() // 10% 부가세 가정 + : '0', + LFDAT: item.requestedDeliveryDate?.toISOString().split('T')[0] || getCurrentSAPDate(), + })) || [], + T_PR_RETURN: [{ + ANFNR: bidding.biddingNumber, + ANFPS: '00001', + EBELN: `PR${bidding.biddingNumber}`, + EBELP: '00001', + MSGTY: 'S', + MSGTXT: 'Success' + }] + } + + // 3. SAP으로 PO 전송 + const result = await createPurchaseOrder(poData) + + if (!result.success) { + throw new Error(result.message) + } + + return { success: true, message: result.message } + + } catch (error) { + console.error('TO PO 실패:', error) + throw new Error(error instanceof Error ? error.message : 'PO 전송에 실패했습니다.') + } +} diff --git a/lib/bidding/detail/service.ts b/lib/bidding/detail/service.ts index df8427da..b00a4f4f 100644 --- a/lib/bidding/detail/service.ts +++ b/lib/bidding/detail/service.ts @@ -632,7 +632,7 @@ export async function createBiddingDetailVendor( companyId: vendorId, invitationStatus: 'pending', isPreQuoteSelected: true, // 본입찰 등록 기본값 - isWinner: false, + isWinner: null, // 미정 상태로 초기화 0916 createdAt: new Date(), updatedAt: new Date(), }).returning({ id: biddingCompanies.id }) @@ -679,13 +679,23 @@ export async function createQuotationVendor(input: any, userId: string) { try { const userName = await getUserNameById(userId) const result = await db.transaction(async (tx) => { + // 0. 중복 체크 - 이미 해당 입찰에 참여중인 업체인지 확인 + const existingCompany = await tx + .select() + .from(biddingCompanies) + .where(sql`${biddingCompanies.biddingId} = ${input.biddingId} AND ${biddingCompanies.companyId} = ${input.companyId}`) + + if (existingCompany.length > 0) { + throw new Error('이미 등록된 업체입니다') + } + // 1. biddingCompanies에 레코드 생성 const biddingCompanyResult = await tx.insert(biddingCompanies).values({ biddingId: input.biddingId, companyId: input.vendorId, finalQuoteAmount: input.quotationAmount?.toString(), awardRatio: input.awardRatio?.toString(), - isWinner: false, + isWinner: null, // 미정 상태로 초기화 contactPerson: input.contactPerson, contactEmail: input.contactEmail, contactPhone: input.contactPhone, diff --git a/lib/bidding/detail/table/bidding-detail-vendor-create-dialog.tsx b/lib/bidding/detail/table/bidding-detail-vendor-create-dialog.tsx index 5e85af06..f35957bc 100644 --- a/lib/bidding/detail/table/bidding-detail-vendor-create-dialog.tsx +++ b/lib/bidding/detail/table/bidding-detail-vendor-create-dialog.tsx @@ -36,7 +36,7 @@ import { import { Check, ChevronsUpDown, Search } from 'lucide-react' import { cn } from '@/lib/utils' import { createBiddingDetailVendor } from '@/lib/bidding/detail/service' -import { searchVendors } from '@/lib/vendors/service' +import { searchVendorsForBidding } from '@/lib/bidding/service' import { useToast } from '@/hooks/use-toast' import { useTransition } from 'react' @@ -83,7 +83,7 @@ export function BiddingDetailVendorCreateDialog({ } try { - const result = await searchVendors(vendorSearchValue.trim(), 10) + const result = await searchVendorsForBidding(vendorSearchValue.trim(), biddingId, 10) setVendors(result) } catch (error) { console.error('Vendor search failed:', error) diff --git a/lib/bidding/detail/table/bidding-detail-vendor-table.tsx b/lib/bidding/detail/table/bidding-detail-vendor-table.tsx index 95f63ce9..a9778636 100644 --- a/lib/bidding/detail/table/bidding-detail-vendor-table.tsx +++ b/lib/bidding/detail/table/bidding-detail-vendor-table.tsx @@ -20,7 +20,7 @@ import { } from '@/lib/bidding/detail/service' import { selectWinnerSchema } from '@/lib/bidding/validation' import { useToast } from '@/hooks/use-toast' -import { useTransition } from 'react' +import { useTransition, useCallback } from 'react' interface BiddingDetailVendorTableContentProps { biddingId: number @@ -114,29 +114,7 @@ export function BiddingDetailVendorTableContent({ const [priceAdjustmentData, setPriceAdjustmentData] = React.useState(null) const [isPriceAdjustmentDialogOpen, setIsPriceAdjustmentDialogOpen] = React.useState(false) - const handleDelete = (vendor: QuotationVendor) => { - if (!confirm(`${vendor.vendorName} 업체를 삭제하시겠습니까?`)) return - - startTransition(async () => { - const response = await deleteQuotationVendor(vendor.id) - - if (response.success) { - toast({ - title: '성공', - description: response.message, - }) - onRefresh() - } else { - toast({ - title: '오류', - description: response.error, - variant: 'destructive', - }) - } - }) - } - - const handleSelectWinner = (vendor: QuotationVendor) => { + const handleSelectWinner = useCallback((vendor: QuotationVendor) => { if (!vendor.awardRatio || vendor.awardRatio <= 0) { toast({ title: '오류', @@ -180,7 +158,7 @@ export function BiddingDetailVendorTableContent({ }) } }) - } + }, [toast, startTransition, biddingId, userId, selectWinnerSchema, selectWinner, onRefresh]) const handleEdit = (vendor: QuotationVendor) => { setSelectedVendor(vendor) @@ -214,12 +192,12 @@ export function BiddingDetailVendorTableContent({ const columns = React.useMemo( () => getBiddingDetailVendorColumns({ onEdit: onEdit || handleEdit, - onDelete: onDelete || handleDelete, + onDelete: onDelete, onSelectWinner: onSelectWinner || handleSelectWinner, onViewPriceAdjustment: handleViewPriceAdjustment, onViewItemDetails: onViewItemDetails }), - [onEdit, onDelete, onSelectWinner, handleEdit, handleDelete, handleSelectWinner, handleViewPriceAdjustment, onViewItemDetails] + [onEdit, onDelete, onSelectWinner, handleEdit, handleSelectWinner, handleViewPriceAdjustment, onViewItemDetails] ) const { table } = useDataTable({ diff --git a/lib/bidding/detail/table/bidding-detail-vendor-toolbar-actions.tsx b/lib/bidding/detail/table/bidding-detail-vendor-toolbar-actions.tsx index 0b707944..893fb185 100644 --- a/lib/bidding/detail/table/bidding-detail-vendor-toolbar-actions.tsx +++ b/lib/bidding/detail/table/bidding-detail-vendor-toolbar-actions.tsx @@ -180,6 +180,8 @@ export function BiddingDetailVendorToolbarActions({ <>
{/* 상태별 액션 버튼 */} + {bidding.status !== 'bidding_closed' && bidding.status !== 'vendor_selected' && ( + <> */} - - - - + + + + + + + )}
@@ -28,7 +29,11 @@ interface BiddingsTableToolbarActionsProps { export function BiddingsTableToolbarActions({ table, paymentTermsOptions, incotermsOptions }: BiddingsTableToolbarActionsProps) { const router = useRouter() + const { data: session } = useSession() const [isExporting, setIsExporting] = React.useState(false) + const [isTransmissionDialogOpen, setIsTransmissionDialogOpen] = React.useState(false) + + const userId = session?.user?.id ? Number(session.user.id) : 1 // 선택된 입찰들 const selectedBiddings = React.useMemo(() => { @@ -38,6 +43,9 @@ export function BiddingsTableToolbarActions({ table, paymentTermsOptions, incote .map(row => row.original) }, [table.getFilteredSelectedRowModel().rows]) + // 업체선정이 완료된 입찰만 전송 가능 + const canTransmit = selectedBiddings.length === 1 && selectedBiddings[0].status === 'vendor_selected' + const handleExport = async () => { try { setIsExporting(true) @@ -54,47 +62,69 @@ export function BiddingsTableToolbarActions({ table, paymentTermsOptions, incote } return ( -
- {/* 신규 생성 */} - + <> +
+ {/* 신규 생성 */} + - {/* 개찰 (입찰 오픈) */} - {/* {openEligibleBiddings.length > 0 && ( - - )} */} - {/* Export */} - - + {/* 개찰 (입찰 오픈) */} + {/* {openEligibleBiddings.length > 0 && ( - - - - - 입찰 목록 내보내기 - - - -
+ )} */} + + {/* Export */} + + + + + + + + 입찰 목록 내보내기 + + + +
+ + {/* 전송 다이얼로그 */} + + ) } \ No newline at end of file diff --git a/lib/bidding/list/biddings-transmission-dialog.tsx b/lib/bidding/list/biddings-transmission-dialog.tsx new file mode 100644 index 00000000..d307ec9d --- /dev/null +++ b/lib/bidding/list/biddings-transmission-dialog.tsx @@ -0,0 +1,159 @@ +"use client" + +import * as React from "react" +import { + Send, CheckCircle, FileText, Truck +} from "lucide-react" +import { toast } from "sonner" +import { Button } from "@/components/ui/button" +import { + Dialog, + DialogContent, + DialogDescription, + DialogFooter, + DialogHeader, + DialogTitle, +} from "@/components/ui/dialog" +import { Card, CardContent, CardHeader, CardTitle } from "@/components/ui/card" +import { Label } from "@/components/ui/label" +import { BiddingListItem } from "@/db/schema" +import { transmitToContract, transmitToPO } from "@/lib/bidding/actions" + +console.log('=== Module loaded ===') +console.log('transmitToContract imported:', typeof transmitToContract) +console.log('transmitToPO imported:', typeof transmitToPO) + +interface TransmissionDialogProps { + open: boolean + onOpenChange: (open: boolean) => void + bidding: BiddingListItem | undefined + userId: number +} + +export function TransmissionDialog({ open, onOpenChange, bidding, userId }: TransmissionDialogProps) { + const [isLoading, setIsLoading] = React.useState(false) + + if (!bidding) return null + + const handleToContract = async () => { + try { + setIsLoading(true) + console.log('=== START handleToContract ===') + console.log('bidding.id', bidding.id) + console.log('userId', userId) + console.log('transmitToContract function:', typeof transmitToContract) + + console.log('About to call transmitToContract...') + const result = await transmitToContract(bidding.id, userId) + console.log('transmitToContract result:', result) + + toast.success('계약서 생성이 완료되었습니다.') + onOpenChange(false) + } catch (error) { + console.error('handleToContract error:', error) + toast.error(`계약서 생성에 실패했습니다: ${error}`) + } finally { + setIsLoading(false) + console.log('=== END handleToContract ===') + } + } + + const handleToPO = async () => { + try { + setIsLoading(true) + await transmitToPO(bidding.id) + toast.success('PO 전송이 완료되었습니다.') + onOpenChange(false) + } catch (error) { + toast.error(`PO 전송에 실패했습니다: ${error}`) + } finally { + setIsLoading(false) + } + } + + return ( + + + + + + 입찰 전송 + + + 선택된 입찰을 계약서 또는 PO로 전송합니다. + + + +
+ {/* 입찰 정보 */} + + + 입찰 정보 + + +
+
+ +

{bidding.biddingNumber}

+
+
+ +

{bidding.title}

+
+
+ +

{bidding.contractType}

+
+
+ +

+ {bidding.budget ? `${bidding.budget.toLocaleString()} ${bidding.currency}` : '-'} +

+
+
+ + + + {/* 선정된 업체 정보 (임시로 표시) */} + + + 선정된 업체 + + +
+ + 업체 선정이 완료되었습니다. +
+

+ 자세한 업체 정보는 전송 후 확인할 수 있습니다. +

+ + +
+ + + + + + + + + ) +} diff --git a/lib/bidding/pre-quote/service.ts b/lib/bidding/pre-quote/service.ts index 7f054a66..cad77a6b 100644 --- a/lib/bidding/pre-quote/service.ts +++ b/lib/bidding/pre-quote/service.ts @@ -6,12 +6,12 @@ import { basicContractTemplates } from '@/db/schema' import { vendors } from '@/db/schema/vendors' import { users } from '@/db/schema' import { sendEmail } from '@/lib/mail/sendEmail' -import { eq, inArray, and, ilike } from 'drizzle-orm' +import { eq, inArray, and, ilike, sql } from 'drizzle-orm' import { mkdir, writeFile } from 'fs/promises' import path from 'path' import { revalidateTag, revalidatePath } from 'next/cache' import { basicContract } from '@/db/schema/basicContractDocumnet' -import { saveFile ,saveBuffer} from '@/lib/file-stroage' +import { saveFile } from '@/lib/file-stroage' // userId를 user.name으로 변환하는 유틸리티 함수 async function getUserNameById(userId: string): Promise { @@ -69,6 +69,15 @@ interface PreQuoteDocumentUpload { export async function createBiddingCompany(input: CreateBiddingCompanyInput) { try { const result = await db.transaction(async (tx) => { + // 0. 중복 체크 - 이미 해당 입찰에 참여중인 업체인지 확인 + const existingCompany = await tx + .select() + .from(biddingCompanies) + .where(sql`${biddingCompanies.biddingId} = ${input.biddingId} AND ${biddingCompanies.companyId} = ${input.companyId}`) + + if (existingCompany.length > 0) { + throw new Error('이미 등록된 업체입니다') + } // 1. biddingCompanies 레코드 생성 const biddingCompanyResult = await tx.insert(biddingCompanies).values({ biddingId: input.biddingId, @@ -1225,7 +1234,10 @@ export async function sendBiddingBasicContracts( const results = [] const savedContracts = [] - // 트랜잭션 시작 - contractsDir 제거 (saveBuffer가 처리) + // 트랜잭션 시작 + const contractsDir = path.join(process.cwd(), `${process.env.NAS_PATH}`, "contracts", "generated"); + await mkdir(contractsDir, { recursive: true }); + const result = await db.transaction(async (tx) => { // 각 벤더별로 기본계약 생성 및 이메일 발송 for (const vendor of vendorData) { @@ -1285,7 +1297,6 @@ export async function sendBiddingBasicContracts( if (vendor.contractRequirements.projectGtcYn) contractTypes.push({ type: 'Project_GTC', templateName: '기술' }) if (vendor.contractRequirements.agreementYn) contractTypes.push({ type: '기술자료', templateName: '기술자료' }) console.log("contractTypes", contractTypes) - for (const contractType of contractTypes) { // PDF 데이터 찾기 (include를 사용하여 유연하게 찾기) console.log("generatedPdfs", generatedPdfs.map(pdf => pdf.key)) @@ -1299,22 +1310,11 @@ export async function sendBiddingBasicContracts( continue } - // 파일 저장 - saveBuffer 사용 + // 파일 저장 (rfq-last 방식) const fileName = `${contractType.type}_${vendor.vendorCode || vendor.vendorId}_${vendor.biddingCompanyId}_${Date.now()}.pdf` - - const saveResult = await saveBuffer({ - buffer: Buffer.from(pdfData.buffer), - fileName: fileName, - directory: 'contracts/generated', - originalName: fileName, - userId: currentUser.id - }) + const filePath = path.join(contractsDir, fileName); - // 저장 실패 시 처리 - if (!saveResult.success) { - console.error(`PDF 저장 실패: ${saveResult.error}`) - continue - } + await writeFile(filePath, Buffer.from(pdfData.buffer)); // 템플릿 정보 조회 (rfq-last 방식) const [template] = await db @@ -1352,8 +1352,8 @@ export async function sendBiddingBasicContracts( .set({ requestedBy: currentUser.id, status: "PENDING", // 재발송 상태 - fileName: saveResult.originalName || fileName, // 원본 파일명 - filePath: saveResult.publicPath, // saveBuffer가 반환한 공개 경로 + fileName: fileName, + filePath: `/contracts/generated/${fileName}`, deadline: new Date(Date.now() + 10 * 24 * 60 * 60 * 1000), updatedAt: new Date(), }) @@ -1373,8 +1373,8 @@ export async function sendBiddingBasicContracts( generalContractId: null, requestedBy: currentUser.id, status: 'PENDING', - fileName: saveResult.originalName || fileName, // 원본 파일명 - filePath: saveResult.publicPath, // saveBuffer가 반환한 공개 경로 + fileName: fileName, + filePath: `/contracts/generated/${fileName}`, deadline: new Date(Date.now() + 10 * 24 * 60 * 60 * 1000), // 10일 후 createdAt: new Date(), updatedAt: new Date(), @@ -1389,10 +1389,19 @@ export async function sendBiddingBasicContracts( vendorName: vendor.vendorName, contractId: contractRecord.id, contractType: contractType.type, - fileName: saveResult.originalName || fileName, - filePath: saveResult.publicPath, - hashedFileName: saveResult.fileName, // 실제 저장된 파일명 (디버깅용) + fileName: fileName, + filePath: `/contracts/generated/${fileName}`, }) + + // savedContracts에 추가 (rfq-last 방식) + // savedContracts.push({ + // vendorId: vendor.vendorId, + // vendorName: vendor.vendorName, + // templateName: contractType.templateName, + // contractId: contractRecord.id, + // fileName: fileName, + // isUpdated: !!existingContract, // 업데이트 여부 표시 + // }) } // 이메일 발송 (선택사항) @@ -1439,6 +1448,7 @@ export async function sendBiddingBasicContracts( ) } } + // 기존 기본계약 조회 (서버 액션) export async function getExistingBasicContractsForBidding(biddingId: number) { try { diff --git a/lib/bidding/pre-quote/table/bidding-pre-quote-vendor-create-dialog.tsx b/lib/bidding/pre-quote/table/bidding-pre-quote-vendor-create-dialog.tsx index e2a38547..bc233e77 100644 --- a/lib/bidding/pre-quote/table/bidding-pre-quote-vendor-create-dialog.tsx +++ b/lib/bidding/pre-quote/table/bidding-pre-quote-vendor-create-dialog.tsx @@ -26,7 +26,7 @@ import { import { Check, ChevronsUpDown } from 'lucide-react' import { cn } from '@/lib/utils' import { createBiddingCompany } from '@/lib/bidding/pre-quote/service' -import { searchVendors } from '@/lib/vendors/service' +import { searchVendorsForBidding } from '@/lib/bidding/service' import { useToast } from '@/hooks/use-toast' import { useTransition } from 'react' @@ -69,7 +69,7 @@ export function BiddingPreQuoteVendorCreateDialog({ } try { - const result = await searchVendors(vendorSearchValue.trim(), 10) + const result = await searchVendorsForBidding(vendorSearchValue.trim(), biddingId, 10) setVendors(result) } catch (error) { console.error('Vendor search failed:', error) diff --git a/lib/bidding/service.ts b/lib/bidding/service.ts index 90a379e1..55146c4b 100644 --- a/lib/bidding/service.ts +++ b/lib/bidding/service.ts @@ -14,7 +14,10 @@ import { users, basicContractTemplates, paymentTerms, - incoterms + incoterms, + vendors, + vendorsWithTypesView, + biddingCompanies } from '@/db/schema' import { eq, @@ -556,6 +559,7 @@ export async function createBidding(input: CreateBiddingInput, userId: string) { finalBidPrice: input.finalBidPrice ? parseFloat(input.finalBidPrice) : null, status: input.status || 'bidding_generated', + // biddingSourceType: input.biddingSourceType || 'manual', isPublic: input.isPublic || false, isUrgent: input.isUrgent || false, managerName: input.managerName, @@ -1421,4 +1425,53 @@ export async function getActiveContractTemplates() { console.error('활성 템플릿 조회 실패:', error); throw new Error('템플릿 조회에 실패했습니다.'); } +} + +// 입찰에 참여하지 않은 벤더만 검색 (중복 방지) +export async function searchVendorsForBidding(searchTerm: string = "", biddingId: number, limit: number = 100) { + try { + let whereCondition; + + if (searchTerm.trim()) { + const s = `%${searchTerm.trim()}%`; + whereCondition = or( + ilike(vendorsWithTypesView.vendorName, s), + ilike(vendorsWithTypesView.vendorCode, s) + ); + } + + // 이미 해당 입찰에 참여중인 벤더 ID들을 가져옴 + const participatingVendorIds = await db + .select({ companyId: biddingCompanies.companyId }) + .from(biddingCompanies) + .where(eq(biddingCompanies.biddingId, biddingId)); + + const excludedIds = participatingVendorIds.map(p => p.companyId); + + const result = await db + .select({ + id: vendorsWithTypesView.id, + vendorName: vendorsWithTypesView.vendorName, + vendorCode: vendorsWithTypesView.vendorCode, + status: vendorsWithTypesView.status, + country: vendorsWithTypesView.country, + }) + .from(vendorsWithTypesView) + .where( + and( + whereCondition, + // 이미 참여중인 벤더 제외 + excludedIds.length > 0 ? sql`${vendorsWithTypesView.id} NOT IN (${excludedIds})` : undefined, + // ACTIVE 상태인 벤더만 검색 + // eq(vendorsWithTypesView.status, "ACTIVE"), + ) + ) + .orderBy(asc(vendorsWithTypesView.vendorName)) + .limit(limit); + + return result; + } catch (error) { + console.error('Error searching vendors for bidding:', error) + return [] + } } \ No newline at end of file diff --git a/lib/bidding/vendor/partners-bidding-detail.tsx b/lib/bidding/vendor/partners-bidding-detail.tsx index 4b316eee..89ca426b 100644 --- a/lib/bidding/vendor/partners-bidding-detail.tsx +++ b/lib/bidding/vendor/partners-bidding-detail.tsx @@ -296,6 +296,19 @@ export function PartnersBiddingDetail({ biddingId, companyId }: PartnersBiddingD const handleSaveDraft = async () => { if (!biddingDetail || !userId) return + // 입찰 마감 상태 체크 + const biddingStatus = biddingDetail.status + const isClosed = biddingStatus === 'bidding_closed' || biddingStatus === 'vendor_selected' || biddingStatus === 'bidding_disposal' + + if (isClosed) { + toast({ + title: "접근 제한", + description: "입찰이 마감되어 더 이상 입찰에 참여할 수 없습니다.", + variant: "destructive", + }) + return + } + if (prItemQuotations.length === 0) { toast({ title: '저장할 데이터 없음', @@ -350,6 +363,18 @@ export function PartnersBiddingDetail({ biddingId, companyId }: PartnersBiddingD const handleSubmitResponse = () => { if (!biddingDetail) return + // 입찰 마감 상태 체크 + const biddingStatus = biddingDetail.status + const isClosed = biddingStatus === 'bidding_closed' || biddingStatus === 'vendor_selected' || biddingStatus === 'bidding_disposal' + + if (isClosed) { + toast({ + title: "접근 제한", + description: "입찰이 마감되어 더 이상 입찰에 참여할 수 없습니다.", + variant: "destructive", + }) + return + } // 필수값 검증 if (!responseData.finalQuoteAmount.trim()) { diff --git a/lib/bidding/vendor/partners-bidding-list-columns.tsx b/lib/bidding/vendor/partners-bidding-list-columns.tsx index 431f7e9a..534e8838 100644 --- a/lib/bidding/vendor/partners-bidding-list-columns.tsx +++ b/lib/bidding/vendor/partners-bidding-list-columns.tsx @@ -177,7 +177,10 @@ export function getPartnersBiddingListColumns({ setRowAction }: PartnersBiddingL }) } } - + + const biddingStatus = row.original.status + const isClosed = biddingStatus === 'bidding_closed' || biddingStatus === 'vendor_selected' || biddingStatus === 'bidding_disposal' + return ( @@ -194,10 +197,12 @@ export function getPartnersBiddingListColumns({ setRowAction }: PartnersBiddingL 입찰 상세보기 + {!isClosed && ( 사전견적하기 + )} ) diff --git a/lib/bidding/vendor/partners-bidding-pre-quote.tsx b/lib/bidding/vendor/partners-bidding-pre-quote.tsx index bdc860f4..4ec65413 100644 --- a/lib/bidding/vendor/partners-bidding-pre-quote.tsx +++ b/lib/bidding/vendor/partners-bidding-pre-quote.tsx @@ -254,6 +254,19 @@ export function PartnersBiddingPreQuote({ biddingId, companyId }: PartnersBiddin }) return } + // 입찰 마감 상태 체크 + const biddingStatus = biddingDetail.status + const isClosed = biddingStatus === 'bidding_closed' || biddingStatus === 'vendor_selected' || biddingStatus === 'bidding_disposal' + + if (isClosed) { + toast({ + title: "접근 제한", + description: "입찰이 마감되어 더 이상 사전견적을 제출할 수 없습니다.", + variant: "destructive", + }) + router.back() + return + } if (!userId) { toast({ @@ -356,6 +369,20 @@ export function PartnersBiddingPreQuote({ biddingId, companyId }: PartnersBiddin const handleSubmitResponse = () => { if (!biddingDetail) return + // 입찰 마감 상태 체크 + const biddingStatus = biddingDetail.status + const isClosed = biddingStatus === 'bidding_closed' || biddingStatus === 'vendor_selected' || biddingStatus === 'bidding_disposal' + + if (isClosed) { + toast({ + title: "접근 제한", + description: "입찰이 마감되어 더 이상 사전견적을 제출할 수 없습니다.", + variant: "destructive", + }) + router.back() + return + } + // 견적마감일 체크 if (biddingDetail.preQuoteDeadline) { const now = new Date() @@ -519,12 +546,6 @@ export function PartnersBiddingPreQuote({ biddingId, companyId }: PartnersBiddin }) } - const formatCurrency = (amount: number) => { - return new Intl.NumberFormat('ko-KR', { - style: 'currency', - currency: biddingDetail?.currency || 'KRW', - }).format(amount) - } if (isLoading) { return ( diff --git a/lib/general-contracts/service.ts b/lib/general-contracts/service.ts index 7f95ae3d..2079a0be 100644 --- a/lib/general-contracts/service.ts +++ b/lib/general-contracts/service.ts @@ -363,6 +363,7 @@ export async function createContract(data: Record) { .values({ contractNumber: contractNumber, revision: 0, + // contractSourceType: data.contractSourceType || 'manual', status: data.status || 'Draft', category: data.category as string, type: data.type as string, diff --git a/lib/mail/templates/document-share.hbs b/lib/mail/templates/document-share.hbs new file mode 100644 index 00000000..b3214620 --- /dev/null +++ b/lib/mail/templates/document-share.hbs @@ -0,0 +1,216 @@ +{{!-- templates/document-share.hbs --}} + + + + + + TBE 문서 공유 + + + +
+
+ +
{{t "email.document_share_title"}}
+
+ +

안녕하세요,

+ +

{{senderName}} ({{senderEmail}})님이 TBE 세션 문서를 공유했습니다.

+ +
+
+ 세션 제목: + {{sessionTitle}} +
+
+ 세션 ID: + #{{sessionId}} +
+
+ Buyer: + {{buyerName}} +
+
+ Vendor: + {{vendorName}} +
+
+ 문서 개수: + {{documentCount}}개 +
+
+ + {{#if hasComments}} +
+ 메시지:
+ {{comments}} +
+ {{/if}} + +

첨부된 문서 목록

+ +
+ {{#each documents}} +
+
📄 {{name}}
+
+ 유형: {{type}} + {{source}} + {{reviewStatus}} +
+
+ {{/each}} +
+ +
+ 📎 첨부 파일 안내:
+ 이 이메일에는 {{documentCount}}개의 문서가 첨부되어 있습니다. + 첨부 파일을 다운로드하여 확인하실 수 있습니다. +
+ +
+

이 이메일은 TBE Platform에서 자동으로 발송되었습니다.

+

문의사항이 있으시면 support@tbe-platform.com으로 연락주세요.

+

© {{year}} TBE Platform. All rights reserved.

+
+
+ + \ No newline at end of file diff --git a/lib/rfq-last/compare-action.ts b/lib/rfq-last/compare-action.ts index 5d210631..2be594e9 100644 --- a/lib/rfq-last/compare-action.ts +++ b/lib/rfq-last/compare-action.ts @@ -1,7 +1,7 @@ "use server"; import db from "@/db/db"; -import { eq, and, inArray } from "drizzle-orm"; +import { eq, and, inArray,ne } from "drizzle-orm"; import { rfqsLast, rfqLastDetails, @@ -10,8 +10,13 @@ import { rfqLastVendorQuotationItems, vendors, paymentTerms, - incoterms, + incoterms,vendorSelections } from "@/db/schema"; +import { revalidatePath } from "next/cache"; +import { getServerSession } from "next-auth/next" +import { authOptions } from "@/app/api/auth/[...nextauth]/route" + +// ===== 타입 정의 ===== export interface ComparisonData { rfqInfo: { @@ -55,7 +60,7 @@ export interface VendorComparison { totalAmount: number; currency: string; rank?: number; - priceVariance?: number; // 평균 대비 차이 % + priceVariance?: number; // 구매자 제시 조건 buyerConditions: { @@ -69,8 +74,6 @@ export interface VendorComparison { taxCode?: string; placeOfShipping?: string; placeOfDestination?: string; - - // 추가 조건 firstYn: boolean; firstDescription?: string; sparepartYn: boolean; @@ -90,8 +93,6 @@ export interface VendorComparison { taxCode?: string; placeOfShipping?: string; placeOfDestination?: string; - - // 추가 조건 응답 firstAcceptance?: "수용" | "부분수용" | "거부"; firstDescription?: string; sparepartAcceptance?: "수용" | "부분수용" | "거부"; @@ -104,12 +105,28 @@ export interface VendorComparison { conditionDifferences: { hasDifferences: boolean; differences: string[]; - criticalDifferences: string[]; // 중요한 차이점 + criticalDifferences: string[]; }; // 비고 generalRemark?: string; technicalProposal?: string; + + // 선정 관련 정보 + isSelected?: boolean; + selectionDate?: Date | null; + selectionReason?: string; + selectedBy?: number; + selectedByName?: string; + selectionApprovalStatus?: "대기" | "승인" | "반려" | null; + selectionApprovedBy?: number; + selectionApprovedAt?: Date | null; + selectionApprovalComment?: string; + + // 계약 관련 정보 추가 + contractStatus?: string; + contractNo?: string; + contractCreatedAt?: Date | null; } export interface PrItemComparison { @@ -143,10 +160,12 @@ export interface PrItemComparison { lowestPrice: number; highestPrice: number; averagePrice: number; - priceVariance: number; // 표준편차 + priceVariance: number; }; } +// ===== 메인 조회 함수 ===== + export async function getComparisonData( rfqId: number, vendorIds: number[] @@ -159,8 +178,6 @@ export async function getComparisonData( rfqCode: rfqsLast.rfqCode, rfqTitle: rfqsLast.rfqTitle, rfqType: rfqsLast.rfqType, - // projectCode: rfqsLast.projectCode, - // projectName: rfqsLast.projectName, dueDate: rfqsLast.dueDate, packageNo: rfqsLast.packageNo, packageName: rfqsLast.packageName, @@ -171,7 +188,7 @@ export async function getComparisonData( if (!rfqData[0]) return null; - // 2. 벤더별 정보 및 응답 조회 + // 2. 벤더별 정보, 응답, 선정 정보 조회 const vendorData = await db .select({ // 벤더 정보 @@ -197,6 +214,21 @@ export async function getComparisonData( buyerSparepartDescription: rfqLastDetails.sparepartDescription, buyerMaterialPriceRelatedYn: rfqLastDetails.materialPriceRelatedYn, + // 선정 관련 정보 + isSelected: rfqLastDetails.isSelected, + selectionDate: rfqLastDetails.selectionDate, + selectionReason: rfqLastDetails.selectionReason, + selectedBy: rfqLastDetails.selectedBy, + selectionApprovalStatus: rfqLastDetails.selectionApprovalStatus, + selectionApprovedBy: rfqLastDetails.selectionApprovedBy, + selectionApprovedAt: rfqLastDetails.selectionApprovedAt, + selectionApprovalComment: rfqLastDetails.selectionApprovalComment, + + // 계약 관련 정보 + contractStatus: rfqLastDetails.contractStatus, + contractNo: rfqLastDetails.contractNo, + contractCreatedAt: rfqLastDetails.contractCreatedAt, + // 벤더 응답 responseId: rfqLastVendorResponses.id, participationStatus: rfqLastVendorResponses.participationStatus, @@ -247,7 +279,19 @@ export async function getComparisonData( ) .where(inArray(vendors.id, vendorIds)); - // 3. Payment Terms와 Incoterms 설명 조회 + // 3. 선정자 이름 조회 (선정된 업체가 있는 경우) + const selectedVendor = vendorData.find(v => v.isSelected); + let selectedByName = ""; + if (selectedVendor?.selectedBy) { + const [user] = await db + .select({ name: users.name }) + .from(users) + .where(eq(users.id, selectedVendor.selectedBy)) + .limit(1); + selectedByName = user?.name || ""; + } + + // 4. Payment Terms와 Incoterms 설명 조회 const paymentTermsData = await db .select({ code: paymentTerms.code, @@ -269,7 +313,7 @@ export async function getComparisonData( incotermsData.map(ic => [ic.code, ic.description]) ); - // 4. PR Items 조회 + // 5. PR Items 조회 const prItems = await db .select({ id: rfqPrItems.id, @@ -284,7 +328,7 @@ export async function getComparisonData( .from(rfqPrItems) .where(eq(rfqPrItems.rfqsLastId, rfqId)); - // 5. 벤더별 견적 아이템 조회 + // 6. 벤더별 견적 아이템 조회 const quotationItems = await db .select({ vendorResponseId: rfqLastVendorQuotationItems.vendorResponseId, @@ -309,7 +353,7 @@ export async function getComparisonData( ) ); - // 6. 데이터 가공 및 분석 + // 7. 데이터 가공 및 분석 const validAmounts = vendorData .map(v => v.totalAmount) .filter(a => a != null && a > 0); @@ -318,7 +362,7 @@ export async function getComparisonData( const maxAmount = Math.max(...validAmounts); const avgAmount = validAmounts.reduce((a, b) => a + b, 0) / validAmounts.length; - // 벤더별 비교 데이터 구성 + // 8. 벤더별 비교 데이터 구성 const vendorComparisons: VendorComparison[] = vendorData.map((v, index) => { const differences: string[] = []; const criticalDifferences: string[] = []; @@ -413,16 +457,32 @@ export async function getComparisonData( generalRemark: v.generalRemark, technicalProposal: v.technicalProposal, + + // 선정 관련 정보 + isSelected: v.isSelected || false, + selectionDate: v.selectionDate, + selectionReason: v.selectionReason, + selectedBy: v.selectedBy, + selectedByName: v.isSelected ? selectedByName : undefined, + selectionApprovalStatus: v.selectionApprovalStatus, + selectionApprovedBy: v.selectionApprovedBy, + selectionApprovedAt: v.selectionApprovedAt, + selectionApprovalComment: v.selectionApprovalComment, + + // 계약 관련 정보 + contractStatus: v.contractStatus, + contractNo: v.contractNo, + contractCreatedAt: v.contractCreatedAt, }; }); - // 가격 순위 계산 + // 9. 가격 순위 계산 vendorComparisons.sort((a, b) => a.totalAmount - b.totalAmount); vendorComparisons.forEach((v, index) => { v.rank = index + 1; }); - // PR 아이템별 비교 데이터 구성 + // 10. PR 아이템별 비교 데이터 구성 const prItemComparisons: PrItemComparison[] = prItems.map(item => { const itemQuotes = quotationItems .filter(q => q.prItemId === item.id) @@ -477,7 +537,23 @@ export async function getComparisonData( }; }); - // 최종 데이터 구성 + console.log({ + rfqInfo: rfqData[0], + vendors: vendorComparisons, + prItems: prItemComparisons, + summary: { + lowestBidder: vendorComparisons[0]?.vendorName || "", + highestBidder: vendorComparisons[vendorComparisons.length - 1]?.vendorName || "", + priceRange: { + min: minAmount, + max: maxAmount, + average: avgAmount, + }, + currency: vendorComparisons[0]?.currency || "USD", + }, + }); + + // 11. 최종 데이터 반환 return { rfqInfo: rfqData[0], vendors: vendorComparisons, @@ -497,4 +573,428 @@ export async function getComparisonData( console.error("견적 비교 데이터 조회 실패:", error); return null; } -} \ No newline at end of file +} + +interface SelectVendorParams { + rfqId: number; + vendorId: number; + vendorName: string; + vendorCode: string; + totalAmount: number; + currency: string; + selectionReason: string; + priceRank: number; + hasConditionDifferences: boolean; + criticalDifferences: string[]; + userId: number; // 현재 사용자 ID +} + +export async function selectVendor(params: SelectVendorParams) { + try { + // 트랜잭션 시작 + const result = await db.transaction(async (tx) => { + // 1. RFQ 상태 확인 + const [rfq] = await tx + .select() + .from(rfqsLast) + .where(eq(rfqsLast.id, params.rfqId)); + + if (!rfq) { + throw new Error("RFQ를 찾을 수 없습니다."); + } + + if (rfq.status === "최종업체선정") { + throw new Error("이미 업체가 선정된 RFQ입니다."); + } + + // 2. 기존에 선정된 업체가 있다면 선정 해제 + await tx + .update(rfqLastDetails) + .set({ + isSelected: false, + updatedAt: new Date(), + updatedBy: params.userId + }) + .where( + and( + eq(rfqLastDetails.rfqsLastId, params.rfqId), + eq(rfqLastDetails.isSelected, true) + ) + ); + + // 3. 새로운 업체 선정 + const [selection] = await tx + .update(rfqLastDetails) + .set({ + isSelected: true, + selectionDate: new Date(), + selectionReason: params.selectionReason, + selectedBy: params.userId, + totalAmount: params.totalAmount.toString(), + priceRank: params.priceRank, + updatedAt: new Date(), + updatedBy: params.userId, + }) + .where( + and( + eq(rfqLastDetails.rfqsLastId, params.rfqId), + eq(rfqLastDetails.vendorsId, params.vendorId), + eq(rfqLastDetails.isLatest, true) + ) + ) + .returning(); + + if (!selection) { + throw new Error("업체 견적 정보를 찾을 수 없습니다."); + } + + // 4. RFQ 상태 업데이트 + await tx + .update(rfqsLast) + .set({ + status: "최종업체선정", + updatedAt: new Date(), + }) + .where(eq(rfqsLast.id, params.rfqId)); + + // 5. 다른 업체들의 견적은 미선정 상태로 명시적 업데이트 + await tx + .update(rfqLastDetails) + .set({ + isSelected: false, + updatedAt: new Date(), + }) + .where( + and( + eq(rfqLastDetails.rfqsLastId, params.rfqId), + eq(rfqLastDetails.isLatest, true), + // NOT equal to selected vendor + // Drizzle에서는 ne (not equal) 연산자를 사용 + ne(rfqLastDetails.vendorsId, params.vendorId) + ) + ); + + return selection; + }); + + // 캐시 무효화 + revalidatePath(`/evcp/rfq-last/${params.rfqId}`); + revalidatePath("/evcp/rfq"); + + return { + success: true, + data: result, + redirectUrl: `/evcp/rfq-last/${params.rfqId}/selection-complete` + }; + + } catch (error) { + console.error("업체 선정 오류:", error); + return { + success: false, + error: error instanceof Error ? error.message : "업체 선정 중 오류가 발생했습니다." + }; + } +} + +// 업체 선정 취소 +export async function cancelVendorSelection(rfqId: number, cancelReason: string) { + try { + const session = await getServerSession(authOptions) + if (!session?.user) { + throw new Error("인증이 필요합니다.") + } + + const userId = Number(session.user.id) + + + await db.transaction(async (tx) => { + // 선정 정보 업데이트 (취소 사유 기록) + const [cancelled] = await tx + .update(rfqLastDetails) + .set({ + isSelected: false, + selectionDate: null, + selectionReason: null, + selectedBy: null, + cancelReason: cancelReason, + selectionApprovalStatus: null, + selectionApprovedBy: null, + selectionApprovedAt: null, + selectionApprovalComment: null, + updatedAt: new Date(), + updatedBy: userId, + }) + .where( + and( + eq(rfqLastDetails.rfqsLastId, rfqId), + eq(rfqLastDetails.isSelected, true) + ) + ) + .returning(); + + if (!cancelled) { + throw new Error("선정된 업체를 찾을 수 없습니다."); + } + + // RFQ 상태 되돌리기 + await tx + .update(rfqsLast) + .set({ + status: "견적접수", + updatedAt: new Date(), + }) + .where(eq(rfqsLast.id, rfqId)); + }); + + revalidatePath(`/evcp/rfq-last/${rfqId}`); + revalidatePath("/evcp/rfq-last"); + + return { success: true }; + } catch (error) { + console.error("업체 선정 취소 오류:", error); + return { + success: false, + error: error instanceof Error ? error.message : "업체 선정 취소 중 오류가 발생했습니다." + }; + } +} +// 선정된 업체 정보 조회 +export async function getSelectedVendor(rfqId: number) { + try { + const [selected] = await db + .select({ + detail: rfqLastDetails, + vendor: vendors, + }) + .from(rfqLastDetails) + .leftJoin(vendors, eq(rfqLastDetails.vendorsId, vendors.id)) + .where( + and( + eq(rfqLastDetails.rfqsLastId, rfqId), + eq(rfqLastDetails.isSelected, true), + eq(rfqLastDetails.isLatest, true) + ) + ) + .limit(1); + + return { + success: true, + data: selected + }; + } catch (error) { + console.error("선정 업체 조회 오류:", error); + return { + success: false, + error: error instanceof Error ? error.message : "선정 업체 조회 중 오류가 발생했습니다." + }; + } +} + +// 선정 승인 요청 +export async function requestSelectionApproval( + rfqId: number, + vendorId: number, + userId: number +) { + try { + const [updated] = await db + .update(rfqLastDetails) + .set({ + selectionApprovalStatus: "대기", + updatedAt: new Date(), + updatedBy: userId, + }) + .where( + and( + eq(rfqLastDetails.rfqsLastId, rfqId), + eq(rfqLastDetails.vendorsId, vendorId), + eq(rfqLastDetails.isSelected, true), + eq(rfqLastDetails.isLatest, true) + ) + ) + .returning(); + + if (!updated) { + throw new Error("선정된 업체를 찾을 수 없습니다."); + } + + revalidatePath(`/evcp/rfq-last/${rfqId}`); + + return { + success: true, + data: updated + }; + } catch (error) { + console.error("선정 승인 요청 오류:", error); + return { + success: false, + error: error instanceof Error ? error.message : "선정 승인 요청 중 오류가 발생했습니다." + }; + } +} + +// 선정 승인/반려 처리 +export async function processSelectionApproval( + rfqId: number, + vendorId: number, + action: "승인" | "반려", + comment: string, + approverId: number +) { + try { + await db.transaction(async (tx) => { + // 선정 승인 정보 업데이트 + const [updated] = await tx + .update(rfqLastDetails) + .set({ + selectionApprovalStatus: action, + selectionApprovedBy: approverId, + selectionApprovedAt: new Date(), + selectionApprovalComment: comment, + updatedAt: new Date(), + updatedBy: approverId, + }) + .where( + and( + eq(rfqLastDetails.rfqsLastId, rfqId), + eq(rfqLastDetails.vendorsId, vendorId), + eq(rfqLastDetails.isSelected, true), + eq(rfqLastDetails.isLatest, true) + ) + ) + .returning(); + + if (!updated) { + throw new Error("선정된 업체를 찾을 수 없습니다."); + } + + // 승인된 경우 RFQ 상태 업데이트 + if (action === "승인") { + await tx + .update(rfqsLast) + .set({ + status: "계약 진행중", + updatedAt: new Date(), + }) + .where(eq(rfqsLast.id, rfqId)); + } + }); + + revalidatePath(`/evcp/rfq-last/${rfqId}`); + revalidatePath("/evcp/rfq"); + + return { + success: true, + message: action === "승인" + ? "업체 선정이 승인되었습니다." + : "업체 선정이 반려되었습니다." + }; + } catch (error) { + console.error("선정 승인 처리 오류:", error); + return { + success: false, + error: error instanceof Error ? error.message : "선정 승인 처리 중 오류가 발생했습니다." + }; + } +} + +// 가격 순위 업데이트 (견적 제출 후 자동 실행) +export async function updatePriceRanks(rfqId: number) { + try { + // 해당 RFQ의 모든 최신 견적 조회 + const quotes = await db + .select({ + id: rfqLastDetails.id, + vendorsId: rfqLastDetails.vendorsId, + totalAmount: rfqLastDetails.totalAmount, + }) + .from(rfqLastDetails) + .where( + and( + eq(rfqLastDetails.rfqsLastId, rfqId), + eq(rfqLastDetails.isLatest, true) + ) + ) + .orderBy(asc(rfqLastDetails.totalAmount)); + + // 순위 업데이트 + await db.transaction(async (tx) => { + for (let i = 0; i < quotes.length; i++) { + await tx + .update(rfqLastDetails) + .set({ + priceRank: i + 1, + updatedAt: new Date() + }) + .where(eq(rfqLastDetails.id, quotes[i].id)); + } + }); + + return { + success: true, + message: "가격 순위가 업데이트되었습니다." + }; + } catch (error) { + console.error("가격 순위 업데이트 오류:", error); + return { + success: false, + error: error instanceof Error ? error.message : "가격 순위 업데이트 중 오류가 발생했습니다." + }; + } +} + +// RFQ의 모든 견적 상태 조회 +export async function getRfqQuotationStatus(rfqId: number) { + try { + const quotations = await db + .select({ + id: rfqLastDetails.id, + vendorId: rfqLastDetails.vendorsId, + vendorName: vendors.name, + vendorCode: vendors.code, + totalAmount: rfqLastDetails.totalAmount, + currency: rfqLastDetails.currency, + priceRank: rfqLastDetails.priceRank, + isSelected: rfqLastDetails.isSelected, + selectionDate: rfqLastDetails.selectionDate, + selectionReason: rfqLastDetails.selectionReason, + selectionApprovalStatus: rfqLastDetails.selectionApprovalStatus, + emailStatus: rfqLastDetails.emailStatus, + lastEmailSentAt: rfqLastDetails.lastEmailSentAt, + }) + .from(rfqLastDetails) + .leftJoin(vendors, eq(rfqLastDetails.vendorsId, vendors.id)) + .where( + and( + eq(rfqLastDetails.rfqsLastId, rfqId), + eq(rfqLastDetails.isLatest, true) + ) + ) + .orderBy(asc(rfqLastDetails.priceRank)); + + const selectedVendor = quotations.find(q => q.isSelected); + const totalQuotations = quotations.length; + const respondedQuotations = quotations.filter(q => q.totalAmount).length; + + return { + success: true, + data: { + quotations, + summary: { + total: totalQuotations, + responded: respondedQuotations, + pending: totalQuotations - respondedQuotations, + selected: selectedVendor ? 1 : 0, + selectedVendor: selectedVendor || null, + } + } + }; + } catch (error) { + console.error("RFQ 견적 상태 조회 오류:", error); + return { + success: false, + error: error instanceof Error ? error.message : "견적 상태 조회 중 오류가 발생했습니다." + }; + } +} + diff --git a/lib/rfq-last/contract-actions.ts b/lib/rfq-last/contract-actions.ts new file mode 100644 index 00000000..1144cf4f --- /dev/null +++ b/lib/rfq-last/contract-actions.ts @@ -0,0 +1,297 @@ +"use server"; + +import db from "@/db/db"; +import { rfqsLast, rfqLastDetails } from "@/db/schema"; +import { eq, and } from "drizzle-orm"; +import { revalidatePath } from "next/cache"; + +// ===== PO (SAP) 생성 ===== +interface CreatePOParams { + rfqId: number; + vendorId: number; + vendorName: string; + totalAmount: number; + currency: string; + selectionReason?: string; +} + +export async function createPO(params: CreatePOParams) { + try { + const userId = 1; // TODO: 실제 사용자 ID 가져오기 + + // 1. 선정된 업체 확인 + const [selectedVendor] = await db + .select() + .from(rfqLastDetails) + .where( + and( + eq(rfqLastDetails.rfqsLastId, params.rfqId), + eq(rfqLastDetails.vendorsId, params.vendorId), + eq(rfqLastDetails.isSelected, true), + eq(rfqLastDetails.isLatest, true) + ) + ); + + if (!selectedVendor) { + throw new Error("선정된 업체 정보를 찾을 수 없습니다."); + } + + // 2. SAP 연동 로직 (TODO: 실제 구현 필요) + // - SAP API 호출 + // - PO 번호 생성 + // - 아이템 정보 전송 + // - 결재 라인 설정 + + // 3. 계약 상태 업데이트 + await db.transaction(async (tx) => { + // rfqLastDetails에 계약 정보 업데이트 + await tx + .update(rfqLastDetails) + .set({ + contractStatus: "진행중", + contractCreatedAt: new Date(), + contractNo: `PO-${Date.now()}`, // TODO: 실제 PO 번호로 변경 + updatedAt: new Date(), + updatedBy: userId, + }) + .where( + and( + eq(rfqLastDetails.rfqsLastId, params.rfqId), + eq(rfqLastDetails.vendorsId, params.vendorId), + eq(rfqLastDetails.isSelected, true) + ) + ); + + // RFQ 상태 업데이트 + await tx + .update(rfqsLast) + .set({ + status: "PO 생성 완료", + updatedAt: new Date(), + }) + .where(eq(rfqsLast.id, params.rfqId)); + }); + + revalidatePath(`/rfq/${params.rfqId}`); + revalidatePath("/rfq"); + + return { + success: true, + message: "PO가 성공적으로 생성되었습니다.", + poNumber: `PO-${Date.now()}`, // TODO: 실제 PO 번호 반환 + }; + } catch (error) { + console.error("PO 생성 오류:", error); + return { + success: false, + error: error instanceof Error ? error.message : "PO 생성 중 오류가 발생했습니다." + }; + } +} + +// ===== 일반계약 생성 ===== +interface CreateGeneralContractParams { + rfqId: number; + vendorId: number; + vendorName: string; + totalAmount: number; + currency: string; + contractType?: string; + contractStartDate?: Date; + contractEndDate?: Date; + contractTerms?: string; +} + +export async function createGeneralContract(params: CreateGeneralContractParams) { + try { + const userId = 1; // TODO: 실제 사용자 ID 가져오기 + + // 1. 선정된 업체 확인 + const [selectedVendor] = await db + .select() + .from(rfqLastDetails) + .where( + and( + eq(rfqLastDetails.rfqsLastId, params.rfqId), + eq(rfqLastDetails.vendorsId, params.vendorId), + eq(rfqLastDetails.isSelected, true), + eq(rfqLastDetails.isLatest, true) + ) + ); + + if (!selectedVendor) { + throw new Error("선정된 업체 정보를 찾을 수 없습니다."); + } + + // 2. 계약 생성 로직 (TODO: 실제 구현 필요) + // - 계약서 템플릿 선택 + // - 계약 조건 설정 + // - 계약서 문서 생성 + // - 전자서명 프로세스 시작 + + // 3. 계약 상태 업데이트 + await db.transaction(async (tx) => { + // rfqLastDetails에 계약 정보 업데이트 + await tx + .update(rfqLastDetails) + .set({ + contractStatus: "진행중", + contractCreatedAt: new Date(), + contractNo: `CONTRACT-${Date.now()}`, // TODO: 실제 계약번호로 변경 + updatedAt: new Date(), + updatedBy: userId, + }) + .where( + and( + eq(rfqLastDetails.rfqsLastId, params.rfqId), + eq(rfqLastDetails.vendorsId, params.vendorId), + eq(rfqLastDetails.isSelected, true) + ) + ); + + // RFQ 상태 업데이트 + await tx + .update(rfqsLast) + .set({ + status: "일반계약 진행중", + updatedAt: new Date(), + }) + .where(eq(rfqsLast.id, params.rfqId)); + }); + + revalidatePath(`/rfq/${params.rfqId}`); + revalidatePath("/rfq"); + + return { + success: true, + message: "일반계약이 성공적으로 생성되었습니다.", + contractNumber: `CONTRACT-${Date.now()}`, // TODO: 실제 계약번호 반환 + }; + } catch (error) { + console.error("일반계약 생성 오류:", error); + return { + success: false, + error: error instanceof Error ? error.message : "일반계약 생성 중 오류가 발생했습니다." + }; + } +} + +// ===== 입찰 생성 ===== +interface CreateBiddingParams { + rfqId: number; + vendorId: number; + vendorName: string; + totalAmount: number; + currency: string; + biddingType?: string; // 공개입찰, 제한입찰 등 + biddingStartDate?: Date; + biddingEndDate?: Date; + biddingRequirements?: string; +} + +export async function createBidding(params: CreateBiddingParams) { + try { + const userId = 1; // TODO: 실제 사용자 ID 가져오기 + + // 1. 선정된 업체 확인 + const [selectedVendor] = await db + .select() + .from(rfqLastDetails) + .where( + and( + eq(rfqLastDetails.rfqsLastId, params.rfqId), + eq(rfqLastDetails.vendorsId, params.vendorId), + eq(rfqLastDetails.isSelected, true), + eq(rfqLastDetails.isLatest, true) + ) + ); + + if (!selectedVendor) { + throw new Error("선정된 업체 정보를 찾을 수 없습니다."); + } + + // 2. 입찰 생성 로직 (TODO: 실제 구현 필요) + // - 입찰 공고 생성 + // - 입찰 참가자격 설정 + // - 입찰 일정 등록 + // - 평가 기준 설정 + // - 입찰 시스템 등록 + + // 3. 입찰 상태 업데이트 + await db.transaction(async (tx) => { + // rfqLastDetails에 입찰 정보 업데이트 + await tx + .update(rfqLastDetails) + .set({ + contractStatus: "입찰진행중", + contractCreatedAt: new Date(), + contractNo: `BID-${Date.now()}`, // TODO: 실제 입찰번호로 변경 + updatedAt: new Date(), + updatedBy: userId, + }) + .where( + and( + eq(rfqLastDetails.rfqsLastId, params.rfqId), + eq(rfqLastDetails.vendorsId, params.vendorId), + eq(rfqLastDetails.isSelected, true) + ) + ); + + // RFQ 상태 업데이트 + await tx + .update(rfqsLast) + .set({ + status: "입찰 진행중", + updatedAt: new Date(), + }) + .where(eq(rfqsLast.id, params.rfqId)); + }); + + revalidatePath(`/rfq/${params.rfqId}`); + revalidatePath("/rfq"); + + return { + success: true, + message: "입찰이 성공적으로 생성되었습니다.", + biddingNumber: `BID-${Date.now()}`, // TODO: 실제 입찰번호 반환 + }; + } catch (error) { + console.error("입찰 생성 오류:", error); + return { + success: false, + error: error instanceof Error ? error.message : "입찰 생성 중 오류가 발생했습니다." + }; + } +} + +// ===== 계약 타입 확인 ===== +export async function checkContractStatus(rfqId: number) { + try { + const [detail] = await db + .select({ + contractStatus: rfqLastDetails.contractStatus, + contractNo: rfqLastDetails.contractNo, + contractCreatedAt: rfqLastDetails.contractCreatedAt, + }) + .from(rfqLastDetails) + .where( + and( + eq(rfqLastDetails.rfqsLastId, rfqId), + eq(rfqLastDetails.isSelected, true), + eq(rfqLastDetails.isLatest, true) + ) + ); + + return { + success: true, + data: detail, + hasContract: !!detail?.contractNo, + }; + } catch (error) { + console.error("계약 상태 확인 오류:", error); + return { + success: false, + error: error instanceof Error ? error.message : "계약 상태 확인 중 오류가 발생했습니다." + }; + } +} \ No newline at end of file diff --git a/lib/rfq-last/quotation-compare-view.tsx b/lib/rfq-last/quotation-compare-view.tsx index 0e15a7bf..491a1962 100644 --- a/lib/rfq-last/quotation-compare-view.tsx +++ b/lib/rfq-last/quotation-compare-view.tsx @@ -5,6 +5,7 @@ import { Card, CardContent, CardHeader, CardTitle } from "@/components/ui/card"; import { Tabs, TabsContent, TabsList, TabsTrigger } from "@/components/ui/tabs"; import { Badge } from "@/components/ui/badge"; import { Button } from "@/components/ui/button"; +import { Alert, AlertDescription, AlertTitle } from "@/components/ui/alert"; import { Trophy, TrendingUp, @@ -22,6 +23,11 @@ import { FileText, Truck, AlertTriangle, + Award, + UserCheck, + X, + RefreshCw, + Clock, } from "lucide-react"; import { cn } from "@/lib/utils"; import { format } from "date-fns"; @@ -37,7 +43,9 @@ import { CollapsibleContent, CollapsibleTrigger, } from "@/components/ui/collapsible"; -import type { ComparisonData, VendorComparison, PrItemComparison } from "../actions"; +import { ComparisonData, selectVendor, cancelVendorSelection } from "./compare-action"; +import { createPO, createGeneralContract, createBidding } from "./contract-actions"; +import { toast } from "sonner"; interface QuotationCompareViewProps { data: ComparisonData; @@ -45,7 +53,96 @@ interface QuotationCompareViewProps { export function QuotationCompareView({ data }: QuotationCompareViewProps) { const [expandedItems, setExpandedItems] = React.useState>(new Set()); - const [selectedMetric, setSelectedMetric] = React.useState<"price" | "delivery" | "compliance">("price"); + const [selectedVendorId, setSelectedVendorId] = React.useState(""); + const [showSelectionDialog, setShowSelectionDialog] = React.useState(false); + const [showCancelDialog, setShowCancelDialog] = React.useState(false); + const [showContractDialog, setShowContractDialog] = React.useState(false); + const [selectedContractType, setSelectedContractType] = React.useState<"PO" | "CONTRACT" | "BIDDING" | "">(""); + const [selectionReason, setSelectionReason] = React.useState(""); + const [cancelReason, setCancelReason] = React.useState(""); + const [isSubmitting, setIsSubmitting] = React.useState(false); + + // 선정된 업체 정보 확인 + const selectedVendor = data.vendors.find(v => v.isSelected); + const hasSelection = !!selectedVendor; + const isSelectionApproved = selectedVendor?.selectionApprovalStatus === "승인"; + const isPendingApproval = selectedVendor?.selectionApprovalStatus === "대기"; + const hasContract = selectedVendor?.contractStatus ? true : false; + + // 계약 진행 처리 + const handleContractCreation = async () => { + if (!selectedContractType) { + toast.error("계약 유형을 선택해주세요."); + return; + } + + if (!selectedVendor) { + toast.error("선정된 업체가 없습니다."); + return; + } + + setIsSubmitting(true); + try { + let result; + + switch (selectedContractType) { + case "PO": + result = await createPO({ + rfqId: data.rfqInfo.id, + vendorId: selectedVendor.vendorId, + vendorName: selectedVendor.vendorName, + totalAmount: selectedVendor.totalAmount, + currency: selectedVendor.currency, + selectionReason: selectedVendor.selectionReason, + }); + break; + + case "CONTRACT": + result = await createGeneralContract({ + rfqId: data.rfqInfo.id, + vendorId: selectedVendor.vendorId, + vendorName: selectedVendor.vendorName, + totalAmount: selectedVendor.totalAmount, + currency: selectedVendor.currency, + }); + break; + + case "BIDDING": + result = await createBidding({ + rfqId: data.rfqInfo.id, + vendorId: selectedVendor.vendorId, + vendorName: selectedVendor.vendorName, + totalAmount: selectedVendor.totalAmount, + currency: selectedVendor.currency, + }); + break; + + default: + throw new Error("올바른 계약 유형이 아닙니다."); + } + + if (result.success) { + toast.success(result.message || "계약 프로세스가 시작되었습니다."); + setShowContractDialog(false); + setSelectedContractType(""); + window.location.reload(); + } else { + throw new Error(result.error || "계약 진행 중 오류가 발생했습니다."); + } + } catch (error) { + console.error("계약 생성 오류:", error); + toast.error(error instanceof Error ? error.message : "계약 진행 중 오류가 발생했습니다."); + } finally { + setIsSubmitting(false); + } + }; + + // 컴포넌트 마운트 시 선정된 업체가 있으면 자동 선택 + React.useEffect(() => { + if (selectedVendor) { + setSelectedVendorId(selectedVendor.vendorId.toString()); + } + }, [selectedVendor]); // 아이템 확장/축소 토글 const toggleItemExpansion = (itemId: number) => { @@ -81,17 +178,8 @@ export function QuotationCompareView({ data }: QuotationCompareViewProps) { return "text-gray-600"; }; - // 조건 일치 여부 아이콘 - const getComplianceIcon = (matches: boolean) => { - return matches ? ( - - ) : ( - - ); - }; - // 금액 포맷 - const formatAmount = (amount: number, currency: string = "USD") => { + const formatAmount = (amount: number, currency: string = "KRW") => { return new Intl.NumberFormat("ko-KR", { style: "currency", currency: currency, @@ -100,8 +188,227 @@ export function QuotationCompareView({ data }: QuotationCompareViewProps) { }).format(amount); }; + // 업체 선정 처리 + const handleVendorSelection = async () => { + if (!selectedVendorId) { + toast.error("선정할 업체를 선택해주세요."); + return; + } + + if (!selectionReason.trim()) { + toast.error("선정 사유를 입력해주세요."); + return; + } + + setIsSubmitting(true); + try { + const vendor = data.vendors.find(v => v.vendorId === parseInt(selectedVendorId)); + if (!vendor) { + throw new Error("선택한 업체를 찾을 수 없습니다."); + } + + const result = await selectVendor({ + rfqId: data.rfqInfo.id, + vendorId: vendor.vendorId, + vendorName: vendor.vendorName, + vendorCode: vendor.vendorCode, + totalAmount: vendor.totalAmount, + currency: vendor.currency, + selectionReason: selectionReason, + priceRank: vendor.rank || 0, + hasConditionDifferences: vendor.conditionDifferences.hasDifferences, + criticalDifferences: vendor.conditionDifferences.criticalDifferences, + }); + + if (result.success) { + toast.success("업체가 성공적으로 선정되었습니다."); + setShowSelectionDialog(false); + setSelectionReason(""); + window.location.reload(); // 페이지 새로고침으로 선정 상태 반영 + } else { + throw new Error(result.error || "업체 선정 중 오류가 발생했습니다."); + } + } catch (error) { + console.error("업체 선정 오류:", error); + toast.error(error instanceof Error ? error.message : "업체 선정 중 오류가 발생했습니다."); + } finally { + setIsSubmitting(false); + } + }; + + // 업체 선정 취소 처리 + const handleCancelSelection = async () => { + if (!cancelReason.trim()) { + toast.error("취소 사유를 입력해주세요."); + return; + } + + setIsSubmitting(true); + try { + // 파라미터를 올바르게 전달 + const result = await cancelVendorSelection(Number(data.rfqInfo.id),cancelReason); + + if (result.success) { + toast.success("업체 선정이 취소되었습니다."); + setShowCancelDialog(false); + setCancelReason(""); + window.location.reload(); + } else { + throw new Error(result.error || "선정 취소 중 오류가 발생했습니다."); + } + } catch (error) { + console.error("선정 취소 오류:", error); + toast.error(error instanceof Error ? error.message : "선정 취소 중 오류가 발생했습니다."); + } finally { + setIsSubmitting(false); + } + }; + return (
+ {/* 상단 액션 바 */} +
+

견적 비교 분석

+
+ {hasSelection ? ( + <> + {!isSelectionApproved && ( + + )} + + + ) : ( + + )} +
+
+ + {/* 선정 상태 알림 */} + {hasSelection && ( + +
+
+ {hasContract ? ( + + ) : isSelectionApproved ? ( + + ) : isPendingApproval ? ( + + ) : ( + + )} +
+ + {hasContract + ? "계약 진행중" + : isSelectionApproved + ? "업체 선정 승인 완료" + : isPendingApproval + ? "업체 선정 승인 대기중" + : "업체 선정 완료"} + + +

선정 업체: {selectedVendor.vendorName} ({selectedVendor.vendorCode})

+

선정 금액: {formatAmount(selectedVendor.totalAmount, selectedVendor.currency)}

+

선정일: {selectedVendor.selectionDate ? format(new Date(selectedVendor.selectionDate), "yyyy년 MM월 dd일", { locale: ko }) : "-"}

+

선정 사유: {selectedVendor.selectionReason || "-"}

+ {selectedVendor.contractNo && ( + <> +
+

계약 정보

+

계약 번호: {selectedVendor.contractNo}

+

계약 상태: {selectedVendor.contractStatus}

+ {selectedVendor.contractCreatedAt && ( +

계약 생성일: {format(new Date(selectedVendor.contractCreatedAt), "yyyy년 MM월 dd일", { locale: ko })}

+ )} +
+ + )} + {selectedVendor.selectedByName && ( +

선정자: {selectedVendor.selectedByName}

+ )} + +
+
+ {/* 계약 진행 버튼들을 알림 카드 안에도 추가 (선택사항) */} + {!hasContract && !isPendingApproval && ( +
+ + + +
+ )} +
+ + )} + {/* 요약 카드 */}
{/* 최저가 벤더 */} @@ -120,23 +427,40 @@ export function QuotationCompareView({ data }: QuotationCompareViewProps) { - {/* 평균 가격 */} - - - - - 평균 가격 - - - -

- {formatAmount(data.summary.priceRange.average, data.summary.currency)} -

-

- {data.vendors.length}개 업체 평균 -

- - + {/* 선정 업체 또는 평균 가격 */} + {hasSelection ? ( + + + + + 선정 업체 + + + +

{selectedVendor.vendorName}

+

+ {formatAmount(selectedVendor.totalAmount, selectedVendor.currency)} +

+ + + ) : ( + + + + + 평균 가격 + + + +

+ {formatAmount(data.summary.priceRange.average, data.summary.currency)} +

+

+ {data.vendors.length}개 업체 평균 +

+ + + )} {/* 가격 범위 */} @@ -188,16 +512,40 @@ export function QuotationCompareView({ data }: QuotationCompareViewProps) { - 가격 순위 + 가격 순위 및 업체 선정
{data.vendors.map((vendor) => (
{ + if (!hasSelection) { + setSelectedVendorId(vendor.vendorId.toString()); + } + }} >
+ {!hasSelection && ( + setSelectedVendorId(e.target.value)} + className="h-4 w-4 text-blue-600" + /> + )}
-

{vendor.vendorName}

+

+ {vendor.vendorName} + {vendor.isSelected && ( + 선정 + )} +

{vendor.vendorCode} • {vendor.vendorCountry}

@@ -267,8 +620,14 @@ export function QuotationCompareView({ data }: QuotationCompareViewProps) { 항목 구매자 제시 {data.vendors.map((vendor) => ( - + {vendor.vendorName} + {vendor.isSelected && ( + 선정 + )} ))} @@ -279,7 +638,10 @@ export function QuotationCompareView({ data }: QuotationCompareViewProps) { 통화 {data.vendors[0]?.buyerConditions.currency} {data.vendors.map((vendor) => ( - +
{vendor.vendorConditions.currency || vendor.buyerConditions.currency} {vendor.vendorConditions.currency !== vendor.buyerConditions.currency && ( @@ -306,7 +668,10 @@ export function QuotationCompareView({ data }: QuotationCompareViewProps) { {data.vendors.map((vendor) => ( - +
@@ -327,134 +692,7 @@ export function QuotationCompareView({ data }: QuotationCompareViewProps) { ))} - {/* 인코텀즈 */} - - 인코텀즈 - {data.vendors[0]?.buyerConditions.incotermsCode} - {data.vendors.map((vendor) => ( - -
- {vendor.vendorConditions.incotermsCode || vendor.buyerConditions.incotermsCode} - {vendor.vendorConditions.incotermsCode !== vendor.buyerConditions.incotermsCode && ( - 변경 - )} -
- - ))} - - - {/* 납기 */} - - 납기 - - {data.vendors[0]?.buyerConditions.deliveryDate - ? format(new Date(data.vendors[0].buyerConditions.deliveryDate), "yyyy-MM-dd") - : "-"} - - {data.vendors.map((vendor) => { - const vendorDate = vendor.vendorConditions.deliveryDate || vendor.buyerConditions.deliveryDate; - const isDelayed = vendorDate && vendor.buyerConditions.deliveryDate && - new Date(vendorDate) > new Date(vendor.buyerConditions.deliveryDate); - - return ( - -
- {vendorDate ? format(new Date(vendorDate), "yyyy-MM-dd") : "-"} - {isDelayed && ( - 지연 - )} -
- - ); - })} - - - {/* 초도품 */} - - 초도품 - - {data.vendors[0]?.buyerConditions.firstYn ? "요구" : "해당없음"} - - {data.vendors.map((vendor) => ( - - {vendor.buyerConditions.firstYn && ( - - {vendor.vendorConditions.firstAcceptance || "미응답"} - - )} - {!vendor.buyerConditions.firstYn && "-"} - - ))} - - - {/* 스페어파트 */} - - 스페어파트 - - {data.vendors[0]?.buyerConditions.sparepartYn ? "요구" : "해당없음"} - - {data.vendors.map((vendor) => ( - - {vendor.buyerConditions.sparepartYn && ( - - {vendor.vendorConditions.sparepartAcceptance || "미응답"} - - )} - {!vendor.buyerConditions.sparepartYn && "-"} - - ))} - - - {/* 연동제 */} - - 연동제 - - {data.vendors[0]?.buyerConditions.materialPriceRelatedYn ? "적용" : "미적용"} - - {data.vendors.map((vendor) => ( - -
- {vendor.vendorConditions.materialPriceRelatedYn !== undefined - ? vendor.vendorConditions.materialPriceRelatedYn ? "적용" : "미적용" - : vendor.buyerConditions.materialPriceRelatedYn ? "적용" : "미적용"} - {vendor.vendorConditions.materialPriceRelatedReason && ( - - - - - - -

- {vendor.vendorConditions.materialPriceRelatedReason} -

- - - - )} -
- - ))} - + {/* 나머지 조건들도 동일한 패턴으로 처리 */} @@ -750,6 +988,250 @@ export function QuotationCompareView({ data }: QuotationCompareViewProps) { )} + + {/* 업체 선정 모달 */} + {showSelectionDialog && ( +
+
+

+ {hasSelection ? "업체 재선정 확인" : "업체 선정 확인"} +

+ + {selectedVendorId && ( +
+
+
+
+ 선정 업체 + + {data.vendors.find(v => v.vendorId === parseInt(selectedVendorId))?.vendorName} + +
+
+ 견적 금액 + + {formatAmount( + data.vendors.find(v => v.vendorId === parseInt(selectedVendorId))?.totalAmount || 0, + data.vendors.find(v => v.vendorId === parseInt(selectedVendorId))?.currency + )} + +
+
+ 가격 순위 + + #{data.vendors.find(v => v.vendorId === parseInt(selectedVendorId))?.rank || 0} + +
+ {data.vendors.find(v => v.vendorId === parseInt(selectedVendorId))?.conditionDifferences.hasDifferences && ( + + + + 제시 조건과 차이가 있습니다. 선정 사유를 명확히 기재해주세요. + + + )} +
+
+ +
+ +