// Hub d'apprentissage : annonces, cartes des cours inscrits, recommandations.
import { requireUser } from "@/lib/auth/session.ts";
import { all } from "@/lib/db/index.ts";
import { LearnHub } from "@/components/learning/learn-hub";

export const metadata = { title: "Apprendre" };

export default async function ApprendrePage() {
  const user = await requireUser();
  const courses = all<{ code: string; title: string; color: string }>(
    `SELECT c.code, c.title, c.color FROM courses c JOIN enrollments e ON e.course_code = c.code
     WHERE e.user_id = ? AND c.active = 1 ORDER BY c.code`,
    user.id
  );
  return <LearnHub courses={courses} displayName={user.display_name || user.username} />;
}