(대표님) 20250613 16시 08분 b-rfq, document 등

1 files changed, 40 insertions, 1 deletions

diff --git a/lib/welding/service.ts b/lib/welding/service.ts
index b3a69c36..feb6272b 100644
--- a/lib/welding/service.ts
+++ b/lib/welding/service.ts
@@ -7,7 +7,7 @@ import { filterColumns } from "@/lib/filter-columns";
 import { tagClasses } from "@/db/schema/vendorData";
 import { asc, desc, ilike, inArray, and, gte, lte, not, or, eq } from "drizzle-orm";
 import { GetOcrRowSchema, UpdateOcrRowSchema } from "./validation";
-import { ocrRows } from "@/db/schema";
+import { OcrRow, ocrRows, users } from "@/db/schema";
 import { countOcrRows, selectOcrRows } from "./repository";
 import { getServerSession } from "next-auth/next"
 import { authOptions } from "@/app/api/auth/[...nextauth]/route"
@@ -153,4 +153,43 @@ export async function modifyOcrRow(input: ModifyOcrRowInput) {
       error: "OCR 행을 업데이트하는 중 오류가 발생했습니다."
     };
   }
+}
+
+
+export async function getOcrAllRows(): Promise<OcrRow[]> {
+  try {
+    const allRows = await db
+      .select({
+        // ocrRows의 모든 필드
+        id: ocrRows.id,
+        tableId: ocrRows.tableId,
+        sessionId: ocrRows.sessionId,
+        rowIndex: ocrRows.rowIndex,
+        reportNo: ocrRows.reportNo,
+        no: ocrRows.no,
+        identificationNo: ocrRows.identificationNo,
+        tagNo: ocrRows.tagNo,
+        jointNo: ocrRows.jointNo,
+        jointType: ocrRows.jointType,
+        weldingDate: ocrRows.weldingDate,
+        confidence: ocrRows.confidence,
+        sourceTable: ocrRows.sourceTable,
+        sourceRow: ocrRows.sourceRow,
+        userId: ocrRows.userId,
+        createdAt: ocrRows.createdAt,
+
+        // users 테이블의 필드
+        userName: users.name,
+        userEmail: users.email,
+      })
+      .from(ocrRows)
+      .leftJoin(users, eq(ocrRows.userId, users.id))
+      .orderBy(desc(ocrRows.createdAt))
+
+
+    return allRows
+  } catch (error) {
+    console.error("Error fetching all OCR rows:", error)
+    throw new Error("Failed to fetch all OCR data")
+  }
 }
\ No newline at end of file