From da00bbf203534b2663289d6fe45b6ed8663e7e11 Mon Sep 17 00:00:00 2001
From: dujinkim <dujin.kim@dtsolution.co.kr>
Date: Tue, 23 Sep 2025 02:44:05 +0000
Subject: (최겸) 구매 인포메이션, 공지사항 수정
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

---
 lib/information/repository.ts | 40 +++++++++++++++++++++++++++++++++-------
 1 file changed, 33 insertions(+), 7 deletions(-)

(limited to 'lib/information/repository.ts')

diff --git a/lib/information/repository.ts b/lib/information/repository.ts
index c7c000b1..c3b82d4a 100644
--- a/lib/information/repository.ts
+++ b/lib/information/repository.ts
@@ -1,13 +1,14 @@
 import { asc, desc, eq, and } from "drizzle-orm"
 import db from "@/db/db"
-import { 
-  pageInformation, 
+import {
+  pageInformation,
   informationAttachments,
-  type PageInformation, 
+  type PageInformation,
   type NewPageInformation,
   type InformationAttachment,
   type NewInformationAttachment
 } from "@/db/schema/information"
+import { users } from "@/db/schema/users"
 
 
 
@@ -22,10 +23,22 @@ export async function updateInformation(id: number, data: Partial<NewPageInforma
   return result[0] || null
 }
 
-// 인포메이션과 첨부파일 함께 조회
+// 인포메이션과 첨부파일 함께 조회 (사용자 정보 포함)
 export async function getInformationWithAttachments(id: number) {
   const information = await db
-    .select()
+    .select({
+      id: pageInformation.id,
+      pagePath: pageInformation.pagePath,
+      pageName: pageInformation.pageName,
+      informationContent: pageInformation.informationContent,
+      isActive: pageInformation.isActive,
+      createdBy: pageInformation.createdBy,
+      createdAt: pageInformation.createdAt,
+      updatedBy: pageInformation.updatedBy,
+      updatedAt: pageInformation.updatedAt,
+      updatedByName: users.name,
+      updatedByEmail: users.email,
+    })
     .from(pageInformation)
     .where(eq(pageInformation.id, id))
     .limit(1)
@@ -44,11 +57,24 @@ export async function getInformationWithAttachments(id: number) {
   }
 }
 
-// 페이지 경로로 인포메이션과 첨부파일 함께 조회
+// 페이지 경로로 인포메이션과 첨부파일 함께 조회 (사용자 정보 포함)
 export async function getInformationByPagePathWithAttachments(pagePath: string) {
   const information = await db
-    .select()
+    .select({
+      id: pageInformation.id,
+      pagePath: pageInformation.pagePath,
+      pageName: pageInformation.pageName,
+      informationContent: pageInformation.informationContent,
+      isActive: pageInformation.isActive,
+      createdBy: pageInformation.createdBy,
+      createdAt: pageInformation.createdAt,
+      updatedBy: pageInformation.updatedBy,
+      updatedAt: pageInformation.updatedAt,
+      updatedByName: users.name,
+      updatedByEmail: users.email,
+    })
     .from(pageInformation)
+    .leftJoin(users, eq(pageInformation.updatedBy, users.id))
     .where(and(
       eq(pageInformation.pagePath, pagePath),
       eq(pageInformation.isActive, true)
-- 
cgit v1.2.3