diff options
| -rw-r--r-- | lib/rfqs/service.ts | 12 |
1 files changed, 9 insertions, 3 deletions
diff --git a/lib/rfqs/service.ts b/lib/rfqs/service.ts index 6e40f0f1..a182af49 100644 --- a/lib/rfqs/service.ts +++ b/lib/rfqs/service.ts @@ -598,8 +598,6 @@ export async function getMatchedVendors(input: GetMatchedVendorsSchema, rfqId: n return { data: [], pageCount: 0 } } - console.log(vendorIdList, "vendorIdList") - // ───────────────────────────────────────────────────── // 3) 필터/검색/정렬 // ───────────────────────────────────────────────────── @@ -627,12 +625,20 @@ export async function getMatchedVendors(input: GetMatchedVendorsSchema, rfqId: n ) } + // console.log("itemRows: ", itemRows) + // console.log("vendorIdList: ",vendorIdList) + // console.log("globalWhere: ",globalWhere) + // console.log("vendorRfqView.vendorId: ",vendorRfqView.vendorId) + // console.log("condition1: ",inArray(vendorRfqView.vendorId, vendorIdList)) + // console.log("condition2: ",eq(vendorRfqView.rfqId, rfqId)) + // console.log("finalWhere: ",finalWhere) + // (다) 최종 where // vendorId가 vendorIdList 내에 있어야 하고, // 특정 rfqId(뷰에 담긴 값)도 일치해야 함. const finalWhere = and( inArray(vendorRfqView.vendorId, vendorIdList), - eq(vendorRfqView.rfqId, rfqId), + // eq(vendorRfqView.rfqId, rfqId), advancedWhere, globalWhere ) |