From 25749225689c3934bc10ad1e8285e13020b61282 Mon Sep 17 00:00:00 2001 From: dujinkim Date: Thu, 4 Dec 2025 09:04:09 +0000 Subject: (최겸)구매 입찰, 계약 수정 MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit --- lib/procurement-items/service.ts | 15 +++++++++++++-- 1 file changed, 13 insertions(+), 2 deletions(-) (limited to 'lib/procurement-items') diff --git a/lib/procurement-items/service.ts b/lib/procurement-items/service.ts index b62eb8df..c91959a9 100644 --- a/lib/procurement-items/service.ts +++ b/lib/procurement-items/service.ts @@ -255,8 +255,19 @@ export async function searchProcurementItems(query: string): Promise<{ itemCode: unstable_noStore() try { + // 검색어가 없으면 상위 50개 반환 if (!query || query.trim().length < 1) { - return [] + const results = await db + .select({ + itemCode: procurementItems.itemCode, + itemName: procurementItems.itemName, + }) + .from(procurementItems) + .where(eq(procurementItems.isActive, 'Y')) + .limit(50) + .orderBy(asc(procurementItems.itemCode)) + + return results } const searchQuery = `%${query.trim()}%` @@ -277,7 +288,7 @@ export async function searchProcurementItems(query: string): Promise<{ itemCode: eq(procurementItems.isActive, 'Y') ) ) - .limit(20) + .limit(50) .orderBy(asc(procurementItems.itemCode)) return results -- cgit v1.2.3