From d23e59b405b0be567592ce967793356d1b11d559 Mon Sep 17 00:00:00 2001
From: joonhoekim <26rote@gmail.com>
Date: Tue, 8 Jul 2025 11:27:11 +0000
Subject: (김준회) 벤더 신용평가 조회 화면 fix
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

---
 lib/oracle-db/nonsap/services/creditService.ts | 17 +++++++----------
 1 file changed, 7 insertions(+), 10 deletions(-)

(limited to 'lib/oracle-db/nonsap')

diff --git a/lib/oracle-db/nonsap/services/creditService.ts b/lib/oracle-db/nonsap/services/creditService.ts
index 60e4f287..0b83e192 100644
--- a/lib/oracle-db/nonsap/services/creditService.ts
+++ b/lib/oracle-db/nonsap/services/creditService.ts
@@ -4,6 +4,7 @@ import { oracleKnex, getOracleConnection } from "@/lib/oracle-db/db";
 import { readFileSync } from "fs";
 import { join } from "path";
 import creditServiceMapping from "./creditServiceMapping.json";
+import { getTaxIdByVendorId } from "@/lib/vendors/repository";
 
 // SQL 파일 읽기
 const getCreditQuerySQL = () => {
@@ -31,23 +32,19 @@ const convertCreditGbToCode = (creditGb: string): string => {
 
 // 방법 1: knex.raw() 사용 (네임드 바인드 변수)
 // reno: 사업자번호, credit_gb: 신용평가사 코드
-export const getCreditInfo = async (reno: string, credit_gb: string) => {
+export const getCreditInfo = async (id: string, credit_gb: string) => {
     const query = getCreditQuerySQL();
-    const creditGbCode = convertCreditGbToCode(credit_gb);
+    const bindParameters = {
+        reno: await getTaxIdByVendorId(id),
+        credit_gb: convertCreditGbToCode(credit_gb)
+    }
     
-    const result = await oracleKnex.raw(query, {
-        reno: reno,
-        credit_gb: creditGbCode
-    });
+    const result = await oracleKnex.raw(query, bindParameters);
     
     // Oracle knex raw 결과에서 실제 rows 추출
     const rows = Array.isArray(result) ? result : result.rows || [];
     
     return rows;
-    
-    // UI 테스트용 목업 데이터 (필요시 주석 해제)
-    // const mockData = getMockCreditData(reno, credit_gb);
-    // return [mockData];
 };
 
 // 방법 2: oracledb 직접 사용 (네임드 바인드 변수)
-- 
cgit v1.2.3