(대표님) rfq, 계약, 서명 등

1 files changed, 2 insertions, 2 deletions

diff --git a/lib/tbe-last/vendor-tbe-service.ts b/lib/tbe-last/vendor-tbe-service.ts
index 8335eb4f..858a5817 100644
--- a/lib/tbe-last/vendor-tbe-service.ts
+++ b/lib/tbe-last/vendor-tbe-service.ts
@@ -4,7 +4,7 @@
 
 import { unstable_cache } from "next/cache"
 import db from "@/db/db"
-import { and, desc, asc, eq, sql, or } from "drizzle-orm"
+import { and, desc, asc, eq, sql, ne } from "drizzle-orm"
 import { tbeLastView, rfqLastTbeSessions } from "@/db/schema"
 import { rfqPrItems } from "@/db/schema/rfqLast"
 import { getServerSession } from "next-auth"
@@ -42,7 +42,7 @@ export async function getTBEforVendor(
       const limit = input.perPage ?? 10
 
       // 벤더 필터링
-      const vendorWhere = eq(tbeLastView.vendorId, vendorId)
+      const vendorWhere =and(eq(tbeLastView.vendorId, vendorId),ne(tbeLastView.sessionStatus, "준비중")) 
 
       // 데이터 조회
       const [rows, total] = await db.transaction(async (tx) => {