diff options
Diffstat (limited to 'lib/tbe-last/vendor-tbe-service.ts')
| -rw-r--r-- | lib/tbe-last/vendor-tbe-service.ts | 4 |
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) => { |