Merge remote-tracking branch 'origin/sec-patch' into table-v2

1 files changed, 13 insertions, 2 deletions

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