From e9897d416b3e7327bbd4d4aef887eee37751ae82 Mon Sep 17 00:00:00 2001 From: dujinkim Date: Fri, 27 Jun 2025 01:16:20 +0000 Subject: (대표님) 20250627 오전 10시 작업사항 MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit --- lib/vendor-document-list/service.ts | 18 +++++++++++++++++- 1 file changed, 17 insertions(+), 1 deletion(-) (limited to 'lib/vendor-document-list/service.ts') diff --git a/lib/vendor-document-list/service.ts b/lib/vendor-document-list/service.ts index f3b2b633..de6f0488 100644 --- a/lib/vendor-document-list/service.ts +++ b/lib/vendor-document-list/service.ts @@ -3,7 +3,7 @@ import { eq, SQL } from "drizzle-orm" import db from "@/db/db" import { documents, documentStagesView, issueStages } from "@/db/schema/vendorDocu" -import { contracts } from "@/db/schema/vendorData" +import { contracts } from "@/db/schema" import { GetVendorDcoumentsSchema } from "./validations" import { unstable_cache } from "@/lib/unstable-cache"; import { filterColumns } from "@/lib/filter-columns"; @@ -293,3 +293,19 @@ export async function modifyDocument(input: ModifyDocumentInputType) { }; } } + + +export async function getContractIdsByVendor(vendorId: number): Promise { + try { + const contractsData = await db + .select({ id: contracts.id }) + .from(contracts) + .where(eq(contracts.vendorId, vendorId)) + .orderBy(contracts.id) + + return contractsData.map(contract => contract.id) + } catch (error) { + console.error('Error fetching contract IDs by vendor:', error) + return [] + } +} \ No newline at end of file -- cgit v1.2.3