(김준회) 기술영업 조선 RFQ (SHI/벤더)

1 files changed, 42 insertions, 0 deletions

diff --git a/lib/vendors/service.ts b/lib/vendors/service.ts
index c9ee55be..16f57b57 100644
--- a/lib/vendors/service.ts
+++ b/lib/vendors/service.ts
@@ -2131,4 +2131,46 @@ export async function exportVendorDetails(vendorIds: number[]) {
     console.error("Failed to export vendor details:", error);
     return [];
   }
+}
+
+/**
+ * 벤더 검색 (검색어 기반, 최대 100개)
+ * RFQ 벤더 추가 시 사용
+ */
+export async function searchVendors(searchTerm: string = "", limit: number = 100) {
+  try {
+    let whereCondition;
+    
+    if (searchTerm.trim()) {
+      const s = `%${searchTerm.trim()}%`;
+      whereCondition = or(
+        ilike(vendorsWithTypesView.vendorName, s),
+        ilike(vendorsWithTypesView.vendorCode, s)
+      );
+    }
+    
+    const vendors = await db
+      .select({
+        id: vendorsWithTypesView.id,
+        vendorName: vendorsWithTypesView.vendorName,
+        vendorCode: vendorsWithTypesView.vendorCode,
+        status: vendorsWithTypesView.status,
+        country: vendorsWithTypesView.country,
+      })
+      .from(vendorsWithTypesView)
+      .where(
+        and(
+          whereCondition,
+          // ACTIVE 상태인 벤더만 검색
+          // eq(vendorsWithTypesView.status, "ACTIVE"),
+        )
+      )
+      .orderBy(asc(vendorsWithTypesView.vendorName))
+      .limit(limit);
+    
+    return vendors;
+  } catch (error) {
+    console.error("벤더 검색 오류:", error);
+    return [];
+  }
 }
\ No newline at end of file