From 208ed7ff11d0f822d3d243c5833d31973904349e Mon Sep 17 00:00:00 2001 From: joonhoekim <26rote@gmail.com> Date: Wed, 5 Nov 2025 16:07:43 +0900 Subject: (김준회) vendor-pool: excel-import 코드기반검색처리, 템플릿 변경 (구매 김수진 프로 요청사항) MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit --- components/common/vendor/vendor-service.ts | 38 ++++++++++++++++++++++++++++++ 1 file changed, 38 insertions(+) (limited to 'components') diff --git a/components/common/vendor/vendor-service.ts b/components/common/vendor/vendor-service.ts index 1c59843c..8c440df2 100644 --- a/components/common/vendor/vendor-service.ts +++ b/components/common/vendor/vendor-service.ts @@ -198,6 +198,44 @@ export async function getAllVendors(): Promise<{ } } +/** + * 벤더 코드로 조회 + */ +export async function getVendorByCode(vendorCode: string): Promise { + if (!vendorCode.trim()) { + return null + } + + try { + const result = await db + .select({ + id: vendors.id, + vendorName: vendors.vendorName, + vendorCode: vendors.vendorCode, + taxId: vendors.taxId, + status: vendors.status, + }) + .from(vendors) + .where(eq(vendors.vendorCode, vendorCode.trim())) + .limit(1) + + if (result.length === 0) { + return null + } + + const vendor = result[0] + return { + ...vendor, + displayText: vendor.vendorCode + ? `${vendor.vendorName} (${vendor.vendorCode})` + : vendor.vendorName + } + } catch (error) { + console.error('Error fetching vendor by code:', error) + return null + } +} + /** * 특정 벤더 조회 (ID로) */ -- cgit v1.2.3