import prisma from "@/lib/prisma";
import { getSessionUser } from "@/lib/auth";
import { StatCard } from "@/components/dashboard/StatCard";
import { PageHeader } from "@/components/layout/PageHeader";
import { Card, CardHeader, CardTitle, CardContent } from "@/components/ui/card";
import { Badge } from "@/components/ui/badge";
import { formatDateID } from "@/lib/utils";
import Link from "next/link";
import {
  Users,
  GraduationCap,
  Layers,
  BookOpen,
  ClipboardList,
  FileText,
  Activity,
  ArrowRight,
  CheckCircle2,
  AlertCircle,
  TrendingUp,
} from "lucide-react";

export default async function AdminDashboardPage() {
  const user = await getSessionUser();

  // Aggregate stats directly from PostgreSQL
  const [
    studentCount,
    teacherCount,
    classCount,
    subjectCount,
    materialCount,
    assignmentCount,
    submissionCount,
    recentLogs,
    activeAcademicYear,
    announcements,
  ] = await Promise.all([
    prisma.student.count(),
    prisma.teacher.count(),
    prisma.class.count(),
    prisma.subject.count(),
    prisma.material.count(),
    prisma.assignment.count(),
    prisma.assignmentSubmission.count(),
    prisma.activityLog.findMany({
      take: 6,
      orderBy: { createdAt: "desc" },
      include: { user: true },
    }),
    prisma.academicYear.findFirst({
      where: { isActive: true },
      include: { semesters: { where: { isActive: true } } },
    }),
    prisma.announcement.findMany({
      take: 3,
      orderBy: { createdAt: "desc" },
    }),
  ]);

  const activeSemester = activeAcademicYear?.semesters[0];

  return (
    <div className="space-y-6">
      {/* Header */}
      <PageHeader
        title="Dashboard Administrator"
        description={`Pusat Kendali Akademik LMS SMAN 3 OKU - Tahun Ajaran ${
          activeAcademicYear?.name || "2026/2027"
        } (${activeSemester?.name || "Semester Ganjil"})`}
      >
        <div className="flex items-center gap-2">
          <Link
            href="/admin/reports"
            className="inline-flex items-center gap-2 px-3.5 py-2 rounded-lg bg-blue-600 hover:bg-blue-700 text-white text-xs font-bold shadow-sm transition-all"
          >
            <TrendingUp className="h-4 w-4" />
            Rekap & Ekspor Laporan
          </Link>
        </div>
      </PageHeader>

      {/* METRIC CARDS */}
      <div className="grid grid-cols-2 lg:grid-cols-3 xl:grid-cols-6 gap-4">
        <StatCard
          title="Total Siswa"
          value={studentCount}
          subtitle="Aktif di rombel"
          iconName="users"
          colorScheme="blue"
        />
        <StatCard
          title="Tenaga Pendidik"
          value={teacherCount}
          subtitle="Guru pengampu"
          iconName="teacher"
          colorScheme="emerald"
        />
        <StatCard
          title="Rombongan Belajar"
          value={classCount}
          subtitle="Fase E & Fase F"
          iconName="users"
          colorScheme="purple"
        />
        <StatCard
          title="Mata Pelajaran"
          value={subjectCount}
          subtitle="Kurikulum Merdeka"
          iconName="subject"
          colorScheme="amber"
        />
        <StatCard
          title="Modul & Materi"
          value={materialCount}
          subtitle="Diterbitkan guru"
          iconName="subject"
          colorScheme="blue"
        />
        <StatCard
          title="Tugas Pembelajaran"
          value={assignmentCount}
          subtitle={`${submissionCount} tugas masuk`}
          iconName="assignment"
          colorScheme="rose"
        />
      </div>

      {/* CHARTS & SUMMARY ROW */}
      <div className="grid grid-cols-1 lg:grid-cols-3 gap-6">
        {/* Attendance Rate Visual Summary */}
        <Card className="lg:col-span-2">
          <CardHeader className="flex flex-row items-center justify-between pb-2">
            <div>
              <CardTitle>Tingkat Kehadiran & Partisipasi Siswa</CardTitle>
              <p className="text-xs text-slate-500 mt-1">
                Persentase rata-rata presensi per rombel minggu ini
              </p>
            </div>
            <Badge variant="success">Kehadiran 94.2%</Badge>
          </CardHeader>
          <CardContent className="space-y-4 pt-4">
            {/* Visual Bar Items */}
            <div className="space-y-3">
              <div>
                <div className="flex justify-between text-xs font-semibold mb-1">
                  <span className="text-slate-700">Kelas X.1 (Fase E - Binaan Drs. H. Ahmad Dahlan)</span>
                  <span className="text-blue-600 font-bold">96.7% (29/30 Hadir)</span>
                </div>
                <div className="h-3 w-full rounded-full bg-slate-100 overflow-hidden">
                  <div className="h-full bg-gradient-to-r from-blue-500 to-indigo-600 rounded-full" style={{ width: "96.7%" }} />
                </div>
              </div>

              <div>
                <div className="flex justify-between text-xs font-semibold mb-1">
                  <span className="text-slate-700">Kelas X.2 (Fase E)</span>
                  <span className="text-blue-600 font-bold">93.3% (28/30 Hadir)</span>
                </div>
                <div className="h-3 w-full rounded-full bg-slate-100 overflow-hidden">
                  <div className="h-full bg-gradient-to-r from-emerald-500 to-teal-600 rounded-full" style={{ width: "93.3%" }} />
                </div>
              </div>

              <div>
                <div className="flex justify-between text-xs font-semibold mb-1">
                  <span className="text-slate-700">Kelas XI IPA 1 (Fase F)</span>
                  <span className="text-blue-600 font-bold">92.8%</span>
                </div>
                <div className="h-3 w-full rounded-full bg-slate-100 overflow-hidden">
                  <div className="h-full bg-gradient-to-r from-amber-500 to-orange-600 rounded-full" style={{ width: "92.8%" }} />
                </div>
              </div>
            </div>

            {/* Submissions stats bar */}
            <div className="mt-6 pt-4 border-t border-slate-100 grid grid-cols-3 gap-4 text-center">
              <div className="p-3 rounded-xl bg-slate-50 border border-slate-100">
                <p className="text-[11px] text-slate-500 font-medium">Pengumpulan Tugas</p>
                <p className="text-lg font-bold text-slate-800 mt-0.5">88.5%</p>
                <span className="text-[10px] text-emerald-600 font-semibold">+4.2% dari pekan lalu</span>
              </div>
              <div className="p-3 rounded-xl bg-slate-50 border border-slate-100">
                <p className="text-[11px] text-slate-500 font-medium">Kuis / CBT Diselesaikan</p>
                <p className="text-lg font-bold text-slate-800 mt-0.5">92.0%</p>
                <span className="text-[10px] text-blue-600 font-semibold">Tepat Waktu</span>
              </div>
              <div className="p-3 rounded-xl bg-slate-50 border border-slate-100">
                <p className="text-[11px] text-slate-500 font-medium">Rata-rata Nilai ASTS</p>
                <p className="text-lg font-bold text-slate-800 mt-0.5">85.4</p>
                <span className="text-[10px] text-purple-600 font-semibold">Predikat Baik (B+)</span>
              </div>
            </div>
          </CardContent>
        </Card>

        {/* School Announcements Preview */}
        <Card>
          <CardHeader className="flex flex-row items-center justify-between pb-2">
            <CardTitle>Pengumuman Sekolah</CardTitle>
            <Link
              href="/admin/announcements"
              className="text-xs font-semibold text-blue-600 hover:underline flex items-center gap-1"
            >
              Kelola &rarr;
            </Link>
          </CardHeader>
          <CardContent className="space-y-3 pt-2">
            {announcements.map((a) => (
              <div
                key={a.id}
                className="p-3 rounded-xl bg-slate-50 border border-slate-100 space-y-1.5"
              >
                <div className="flex items-center justify-between">
                  <Badge
                    variant={
                      a.priority === "URGENT"
                        ? "danger"
                        : a.priority === "IMPORTANT"
                        ? "warning"
                        : "secondary"
                    }
                  >
                    {a.priority}
                  </Badge>
                  <span className="text-[10px] text-slate-400">
                    {formatDateID(a.createdAt)}
                  </span>
                </div>
                <h5 className="text-xs font-bold text-slate-800 line-clamp-1">
                  {a.title}
                </h5>
                <p className="text-[11px] text-slate-500 line-clamp-2">
                  {a.content}
                </p>
              </div>
            ))}
          </CardContent>
        </Card>
      </div>

      {/* RECENT ACTIVITY LOGS TABLE */}
      <Card>
        <CardHeader className="flex flex-row items-center justify-between">
          <div>
            <CardTitle>Log Aktivitas Sistem (Audit Trail)</CardTitle>
            <p className="text-xs text-slate-500 mt-1">
              Pencatatan aksi operasional login, materi, tugas, dan nilai
            </p>
          </div>
          <Link
            href="/admin/audit-logs"
            className="text-xs font-bold text-blue-600 hover:text-blue-700"
          >
            Lihat Semua Log &rarr;
          </Link>
        </CardHeader>
        <CardContent>
          <div className="overflow-x-auto">
            <table className="w-full text-xs text-left">
              <thead className="bg-slate-50 text-slate-600 font-semibold border-y border-slate-200">
                <tr>
                  <th className="py-2.5 px-4">Waktu</th>
                  <th className="py-2.5 px-4">Pengguna</th>
                  <th className="py-2.5 px-4">Aksi</th>
                  <th className="py-2.5 px-4">Sumber Daya</th>
                  <th className="py-2.5 px-4">IP Address</th>
                </tr>
              </thead>
              <tbody className="divide-y divide-slate-100">
                {recentLogs.map((log) => (
                  <tr key={log.id} className="hover:bg-slate-50/80 transition-colors">
                    <td className="py-3 px-4 font-mono text-slate-500">
                      {formatDateID(log.createdAt, true)}
                    </td>
                    <td className="py-3 px-4 font-semibold text-slate-800">
                      {log.user ? `${log.user.username} (${log.user.role})` : "Sistem"}
                    </td>
                    <td className="py-3 px-4">
                      <span className="px-2 py-0.5 rounded font-mono font-medium bg-blue-50 text-blue-700 border border-blue-200">
                        {log.action}
                      </span>
                    </td>
                    <td className="py-3 px-4 font-mono text-slate-600">
                      {log.resource}
                    </td>
                    <td className="py-3 px-4 text-slate-400 font-mono">
                      {log.ipAddress || "127.0.0.1"}
                    </td>
                  </tr>
                ))}
              </tbody>
            </table>
          </div>
        </CardContent>
      </Card>
    </div>
  );
}