From 6f22fc9ebc8d175041aa18cf0986592e57d03f63 Mon Sep 17 00:00:00 2001
From: dujinkim <dujin.kim@dtsolution.co.kr>
Date: Thu, 3 Jul 2025 02:47:09 +0000
Subject: (최겸) 기술영업 벤더별 아이템 조회 기능 추가
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

---
 lib/tech-vendor-possible-items/repository.ts | 47 ++++++++++++++++++++++++++++
 1 file changed, 47 insertions(+)
 create mode 100644 lib/tech-vendor-possible-items/repository.ts

(limited to 'lib/tech-vendor-possible-items/repository.ts')

diff --git a/lib/tech-vendor-possible-items/repository.ts b/lib/tech-vendor-possible-items/repository.ts
new file mode 100644
index 00000000..b2588395
--- /dev/null
+++ b/lib/tech-vendor-possible-items/repository.ts
@@ -0,0 +1,47 @@
+import { eq, desc, count } from "drizzle-orm";
+import { 
+  techVendors, 
+  techVendorPossibleItems
+} from "@/db/schema/techVendors";
+
+/**
+ * 기술영업 벤더 가능 아이템 목록 조회 (조인 포함)
+ */
+export async function selectTechVendorPossibleItemsWithJoin(
+  tx: any,
+  where: any,
+  orderBy: any[],
+  offset: number,
+  limit: number
+) {
+  return await tx
+    .select({
+      id: techVendorPossibleItems.id,
+      vendorId: techVendorPossibleItems.vendorId,
+      vendorCode: techVendors.vendorCode,
+      vendorName: techVendors.vendorName,
+      techVendorType: techVendors.techVendorType,
+      itemCode: techVendorPossibleItems.itemCode,
+      createdAt: techVendorPossibleItems.createdAt,
+      updatedAt: techVendorPossibleItems.updatedAt,
+    })
+    .from(techVendorPossibleItems)
+    .innerJoin(techVendors, eq(techVendorPossibleItems.vendorId, techVendors.id))
+    .where(where)
+    .orderBy(...(orderBy || [desc(techVendorPossibleItems.createdAt)]))
+    .limit(limit)
+    .offset(offset);
+}
+
+/**
+ * 기술영업 벤더 가능 아이템 총 개수 조회 (조인 포함)
+ */
+export async function countTechVendorPossibleItemsWithJoin(tx: any, where?: any) {
+  const [result] = await tx
+    .select({ count: count() })
+    .from(techVendorPossibleItems)
+    .innerJoin(techVendors, eq(techVendorPossibleItems.vendorId, techVendors.id))
+    .where(where);
+  
+  return result.count;
+} 
\ No newline at end of file
-- 
cgit v1.2.3