(박서영)Compliance 설문/응답 리스트 생성

5 files changed, 405 insertions, 0 deletions

diff --git a/app/[lng]/evcp/(evcp)/compliance/[templateId]/page.tsx b/app/[lng]/evcp/(evcp)/compliance/[templateId]/page.tsx
new file mode 100644
index 00000000..5dd74305
--- /dev/null
+++ b/app/[lng]/evcp/(evcp)/compliance/[templateId]/page.tsx
@@ -0,0 +1,66 @@
+import * as React from "react"
+import { notFound } from "next/navigation"
+import { Shell } from "@/components/shell"
+import { InformationButton } from "@/components/information/information-button"
+import { ComplianceTemplateDetail } from "@/lib/compliance/compliance-template-detail"
+import { ComplianceResponseStats } from "@/lib/compliance/responses/compliance-response-stats"
+import { 
+  getComplianceSurveyTemplate,
+  getComplianceQuestions,
+  getComplianceResponses,
+  getComplianceResponseStats
+} from "@/lib/compliance/services"
+
+interface TemplateDetailPageProps {
+  params: {
+    lng: string;
+    templateId: string;
+  };
+}
+
+export default async function TemplateDetailPage({ params }: TemplateDetailPageProps) {
+  const resolvedParams = await params;
+  const { templateId } = resolvedParams;
+  
+  const templateIdAsNumber = Number(templateId);
+
+    // 서버에서 데이터 미리 가져오기
+  const [template, questions, responses, stats] = await Promise.all([
+    getComplianceSurveyTemplate(templateIdAsNumber),
+    getComplianceQuestions(templateIdAsNumber),
+    getComplianceResponses(templateIdAsNumber),
+    getComplianceResponseStats(templateIdAsNumber)
+  ]);
+
+  if (!template) {
+    notFound();
+  }
+
+  return (
+    <Shell className="gap-2">
+      <div className="flex items-center justify-between space-y-2">
+        <div className="flex items-center justify-between space-y-2">
+          <div>
+            <div className="flex items-center gap-2">
+              <h2 className="text-2xl font-bold tracking-tight">
+                템플릿 상세
+              </h2>
+              <InformationButton pagePath="evcp/compliance" />
+            </div>
+            <p className="text-muted-foreground">
+              설문조사 템플릿의 질문들과 옵션을 확인할 수 있습니다.
+            </p>
+          </div>
+        </div>
+      </div>
+
+      <ComplianceTemplateDetail 
+        templateId={templateIdAsNumber} 
+        template={template}
+        questions={questions}
+        responses={responses}
+        stats={stats}
+      />
+    </Shell>
+  )
+}
diff --git a/app/[lng]/evcp/(evcp)/compliance/[templateId]/responses/[responseId]/page.tsx b/app/[lng]/evcp/(evcp)/compliance/[templateId]/responses/[responseId]/page.tsx
new file mode 100644
index 00000000..73d9bbac
--- /dev/null
+++ b/app/[lng]/evcp/(evcp)/compliance/[templateId]/responses/[responseId]/page.tsx
@@ -0,0 +1,62 @@
+import * as React from "react"
+import { Shell } from "@/components/shell"
+import { InformationButton } from "@/components/information/information-button"
+import { ComplianceResponseDetail } from "@/lib/compliance/compliance-response-detail"
+import { 
+  getComplianceResponse,
+  getComplianceResponseAnswers,
+  getComplianceResponseFiles,
+  getComplianceSurveyTemplate,
+  getComplianceQuestions
+} from "@/lib/compliance/services"
+
+interface ResponseDetailPageProps {
+  params: {
+    lng: string;
+    templateId: string;
+    responseId: string;
+  };
+}
+
+export default async function ResponseDetailPage({ params }: ResponseDetailPageProps) {
+  const resolvedParams = await params;
+  const { templateId, responseId } = resolvedParams;
+  
+  const templateIdAsNumber = Number(templateId);
+  const responseIdAsNumber = Number(responseId);
+
+  // 서버에서 데이터 미리 가져오기
+  const promises = Promise.all([
+    getComplianceResponse(responseIdAsNumber),
+    getComplianceResponseAnswers(responseIdAsNumber),
+    getComplianceResponseFiles(responseIdAsNumber),
+    getComplianceSurveyTemplate(templateIdAsNumber),
+    getComplianceQuestions(templateIdAsNumber)
+  ]);
+
+  return (
+    <Shell className="gap-2">
+      <div className="flex items-center justify-between space-y-2">
+        <div className="flex items-center justify-between space-y-2">
+          <div>
+            <div className="flex items-center gap-2">
+              <h2 className="text-2xl font-bold tracking-tight">
+                설문조사 응답 상세
+              </h2>
+              <InformationButton pagePath="evcp/compliance" />
+            </div>
+            <p className="text-muted-foreground">
+              설문조사 응답의 모든 답변과 첨부파일을 확인할 수 있습니다.
+            </p>
+          </div>
+        </div>
+      </div>
+
+      <ComplianceResponseDetail 
+        templateId={templateIdAsNumber} 
+        responseId={responseIdAsNumber}
+        promises={promises}
+      />
+    </Shell>
+  )
+}
diff --git a/app/[lng]/evcp/(evcp)/compliance/[templateId]/responses/page.tsx b/app/[lng]/evcp/(evcp)/compliance/[templateId]/responses/page.tsx
new file mode 100644
index 00000000..80e15768
--- /dev/null
+++ b/app/[lng]/evcp/(evcp)/compliance/[templateId]/responses/page.tsx
@@ -0,0 +1,119 @@
+import { Suspense } from "react";
+import { notFound } from "next/navigation";
+import { type SearchParams } from "@/types/table";
+import { getComplianceSurveyTemplate, getComplianceResponsesWithPagination, getComplianceResponseStats } from "@/lib/compliance/services";
+import { ComplianceResponsesPageClient } from "@/lib/compliance/responses/compliance-responses-page-client";
+import { Shell } from "@/components/shell";
+import { Skeleton } from "@/components/ui/skeleton";
+import { DataTableSkeleton } from "@/components/data-table/data-table-skeleton";
+import { InformationButton } from "@/components/information/information-button";
+
+interface ComplianceResponsesPageProps {
+  params: Promise<{
+    templateId: string;
+  }>;
+  searchParams: Promise<SearchParams>;
+}
+
+export default async function ComplianceResponsesPage({ params, searchParams }: ComplianceResponsesPageProps) {
+  const resolvedParams = await params;
+  const resolvedSearchParams = await searchParams;
+  const templateId = parseInt(resolvedParams.templateId);
+  
+  if (isNaN(templateId)) {
+    notFound();
+  }
+
+  // pageSize 기반으로 모드 자동 결정 (items 페이지와 동일한 로직)
+  const search = { page: 1, perPage: 10, ...resolvedSearchParams };
+  const isInfiniteMode = search.perPage >= 1_000_000;
+ 
+  // 페이지네이션 모드일 때만 서버에서 데이터 가져오기
+  // 무한 스크롤 모드에서는 클라이언트에서 SWR로 데이터 로드
+  const promises = isInfiniteMode
+     ? undefined
+     : Promise.all([
+        getComplianceSurveyTemplate(templateId),
+        getComplianceResponsesWithPagination(templateId),
+        getComplianceResponseStats(templateId),
+      ]);
+
+  if (!promises) {
+    // 무한 스크롤 모드
+    return (
+      <Shell className="gap-2">
+        <div className="flex items-center justify-between space-y-2">
+          <div className="flex items-center justify-between space-y-2">
+            <div>
+              <div className="flex items-center gap-2">
+                <h2 className="text-2xl font-bold tracking-tight">
+                  응답 현황
+                </h2>
+                <InformationButton pagePath="evcp/compliance" />
+              </div>
+              <p className="text-muted-foreground">
+                준법 설문조사 응답 현황을 확인할 수 있습니다.
+              </p>
+            </div>
+          </div>
+        </div>
+        
+        <Suspense fallback={<div>응답 목록을 불러오는 중...</div>}>
+          <ComplianceResponsesPageClient 
+            templateId={templateId}
+            promises={undefined}
+            isInfiniteMode={true}
+          />
+        </Suspense>
+      </Shell>
+    );
+  }
+
+  const [template, responses, stats] = await promises;
+
+  if (!template) {
+    notFound();
+  }
+
+  return (
+    <Shell className="gap-2">
+      <div className="flex items-center justify-between space-y-2">
+        <div className="flex items-center justify-between space-y-2">
+          <div>
+            <div className="flex items-center gap-2">
+              <h2 className="text-2xl font-bold tracking-tight">
+                응답 현황
+              </h2>
+              <InformationButton pagePath="evcp/compliance" />
+            </div>
+            <p className="text-muted-foreground">
+              템플릿: {template.name} - 준법 설문조사 응답 현황을 확인할 수 있습니다.
+            </p>
+          </div>
+        </div>
+      </div>
+
+      <Suspense fallback={<Skeleton className="h-7 w-52" />}>
+        {/* 추가 기능들 */}
+      </Suspense>
+      
+      <Suspense
+        fallback={
+          <DataTableSkeleton
+            columnCount={8}
+            searchableColumnCount={1}
+            filterableColumnCount={2}
+            cellWidths={["10rem", "12rem", "15rem", "20rem", "12rem", "10rem", "12rem", "8rem"]}
+            shrinkZero
+          />
+        }
+      >
+        <ComplianceResponsesPageClient 
+          templateId={templateId}
+          promises={Promise.resolve([responses, stats])}
+          isInfiniteMode={false}
+        />
+      </Suspense>
+    </Shell>
+  );
+}
diff --git a/app/[lng]/evcp/(evcp)/compliance/page.tsx b/app/[lng]/evcp/(evcp)/compliance/page.tsx
new file mode 100644
index 00000000..3b97ce99
--- /dev/null
+++ b/app/[lng]/evcp/(evcp)/compliance/page.tsx
@@ -0,0 +1,68 @@
+import * as React from "react"
+import { type SearchParams } from "@/types/table"
+
+import { Skeleton } from "@/components/ui/skeleton"
+import { DataTableSkeleton } from "@/components/data-table/data-table-skeleton"
+import { Shell } from "@/components/shell"
+import { getComplianceSurveyTemplatesWithPagination } from "@/lib/compliance/services"
+import { ComplianceSurveyTemplatesTable } from "@/lib/compliance/table/compliance-survey-templates-table"
+import { InformationButton } from "@/components/information/information-button"
+
+interface IndexPageProps {
+  searchParams: Promise<SearchParams>
+}
+
+export default async function IndexPage(props: IndexPageProps) {
+  const searchParams = await props.searchParams
+  
+  // pageSize 기반으로 모드 자동 결정 (items 페이지와 동일한 로직)
+  const search = { page: 1, perPage: 10, ...searchParams }
+  const isInfiniteMode = search.perPage >= 1_000_000
+ 
+  // 페이지네이션 모드일 때만 서버에서 데이터 가져오기
+  // 무한 스크롤 모드에서는 클라이언트에서 SWR로 데이터 로드
+  const promises = isInfiniteMode
+     ? undefined
+     : Promise.all([
+        getComplianceSurveyTemplatesWithPagination(),
+      ])
+
+  return (
+    <Shell className="gap-2">
+      <div className="flex items-center justify-between space-y-2">
+        <div className="flex items-center justify-between space-y-2">
+          <div>
+            <div className="flex items-center gap-2">
+              <h2 className="text-2xl font-bold tracking-tight">
+                준법 설문조사 관리
+              </h2>
+              <InformationButton pagePath="evcp/compliance" />
+            </div>
+            <p className="text-muted-foreground">
+              준법 설문조사 템플릿을 관리하고 응답 현황을 확인할 수 있습니다.
+            </p>
+          </div>
+        </div>
+        
+      </div>
+
+      <React.Suspense fallback={<Skeleton className="h-7 w-52" />}>
+        {/* DateRangePicker 등 추가 컴포넌트 */}
+      </React.Suspense>
+      
+      <React.Suspense
+        fallback={
+          <DataTableSkeleton
+            columnCount={6}
+            searchableColumnCount={1}
+            filterableColumnCount={2}
+            cellWidths={["10rem", "40rem", "12rem", "12rem", "8rem", "8rem"]}
+            shrinkZero
+          />
+        }
+      >
+        <ComplianceSurveyTemplatesTable promises={promises} />
+      </React.Suspense>
+    </Shell>
+  )
+}
diff --git a/app/api/compliance/files/download/route.ts b/app/api/compliance/files/download/route.ts
new file mode 100644
index 00000000..7bcb59cd
--- /dev/null
+++ b/app/api/compliance/files/download/route.ts
@@ -0,0 +1,90 @@
+import { NextRequest, NextResponse } from "next/server";
+import { getServerSession } from "next-auth";
+import { authOptions } from "@/lib/auth";
+import db from "@/db/db";
+import { complianceResponseFiles } from "@/db/schema/compliance";
+import { eq } from "drizzle-orm";
+import fs from "fs/promises";
+import path from "path";
+
+// MIME 타입 매핑 (기존 API와 동일)
+const getMimeType = (filePath: string): string => {
+  const ext = path.extname(filePath).toLowerCase();
+  const mimeTypes: Record<string, string> = {
+    '.pdf': 'application/pdf',
+    '.doc': 'application/msword',
+    '.docx': 'application/vnd.openxmlformats-officedocument.wordprocessingml.document',
+    '.xls': 'application/vnd.ms-excel',
+    '.xlsx': 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet',
+    '.jpg': 'image/jpeg',
+    '.jpeg': 'image/jpeg',
+    '.png': 'image/png',
+    '.gif': 'image/gif',
+    '.txt': 'text/plain',
+    '.zip': 'application/zip',
+  };
+  
+  return mimeTypes[ext] || 'application/octet-stream';
+};
+
+export async function GET(request: NextRequest) {
+  try {
+    // 인증 확인
+    const session = await getServerSession(authOptions);
+    if (!session?.user) {
+      return NextResponse.json({ error: "인증이 필요합니다." }, { status: 401 });
+    }
+
+    // 쿼리 파라미터에서 fileId 추출
+    const { searchParams } = new URL(request.url);
+    const fileId = searchParams.get("fileId");
+
+    if (!fileId) {
+      return NextResponse.json({ error: "파일 ID가 필요합니다." }, { status: 400 });
+    }
+
+    // 파일 정보 조회
+    const [file] = await db
+      .select()
+      .from(complianceResponseFiles)
+      .where(eq(complianceResponseFiles.id, parseInt(fileId)));
+
+    if (!file) {
+      return NextResponse.json({ error: "파일을 찾을 수 없습니다." }, { status: 404 });
+    }
+
+    // 파일 경로 구성 (public 폴더 기준)
+    const filePath = path.join(process.cwd(), "public", file.filePath);
+    
+    // 파일 존재 확인
+    try {
+      await fs.access(filePath);
+    } catch {
+      return NextResponse.json({ error: "파일이 서버에 존재하지 않습니다." }, { status: 404 });
+    }
+
+    // 파일 읽기
+    const fileBuffer = await fs.readFile(filePath);
+    
+    // 파일 타입 결정
+    const mimeType = file.mimeType || getMimeType(file.filePath);
+    
+    // 응답 헤더 설정
+    const headers = new Headers();
+    headers.set("Content-Type", mimeType);
+    headers.set("Content-Disposition", `attachment; filename="${encodeURIComponent(file.fileName)}"`);
+    headers.set("Content-Length", file.fileSize?.toString() || fileBuffer.length.toString());
+
+    return new NextResponse(fileBuffer, {
+      status: 200,
+      headers,
+    });
+
+  } catch (error) {
+    console.error("파일 다운로드 오류:", error);
+    return NextResponse.json(
+      { error: "파일 다운로드 중 오류가 발생했습니다." },
+      { status: 500 }
+    );
+  }
+}