1 files changed, 47 insertions, 0 deletions
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