import Link from "next/link"; import { ArrowUpRight } from "lucide-react"; import { requireUser } from "@/lib/auth/session"; import { createClient } from "@/lib/supabase/server"; import { Card, CardContent, CardHeader, CardTitle } from "@/components/ui/card"; import { Badge } from "@/components/ui/badge"; import { LEAD_STATUSES, LEAD_STATUS_STYLES } from "@/lib/leads/constants"; import { APPLICATION_STATUSES, APPLICATION_STATUS_STYLES, } from "@/lib/applications/constants"; import type { LeadStatus } from "@/lib/types"; type TodayFollowup = { id: string; lead_id: string; from_time: string | null; lead: { id: string; full_name: string; phone: string | null } | null; }; export default async function DashboardPage() { const user = await requireUser(); const supabase = await createClient(); const today = new Date().toISOString().slice(0, 10); // Count helper bound to the leads table. const leadCount = (status?: LeadStatus) => { let query = supabase .from("leads") .select("*", { count: "exact", head: true }); if (status) query = query.eq("lead_status", status); return query; }; // Count helper bound to the student_applications table. const appCount = (status?: string) => { let query = supabase .from("student_applications") .select("*", { count: "exact", head: true }); if (status) query = query.eq("status", status); return query; }; const [ branchRes, userRes, totalLeadsRes, newLeadsRes, todayFollowupsCountRes, statusBreakdownRes, todayFollowupsRes, totalAppsRes, visaApprovedRes, travelledRes, offersFlagRes, coachingRes, loanRes, feesRes, appStatusBreakdownRes, ] = await Promise.all([ supabase.from("branches").select("*", { count: "exact", head: true }), supabase.from("users").select("*", { count: "exact", head: true }), leadCount(), leadCount("New"), supabase .from("followups") .select("*", { count: "exact", head: true }) .eq("next_date", today) .eq("status", "pending"), Promise.all( LEAD_STATUSES.map(async (status) => { const { count } = await leadCount(status); return [status, count ?? 0] as const; }), ), supabase .from("followups") .select("id, lead_id, from_time, lead:leads(id, full_name, phone)") .eq("next_date", today) .eq("status", "pending") .order("from_time"), appCount(), // "Visa Approved" KPI counts approvals and those who have already travelled. supabase .from("student_applications") .select("*", { count: "exact", head: true }) .in("status", ["Visa Approved", "Travelled"]), appCount("Travelled"), // Offers: explicit flag OR any status at/past the offer stage. supabase .from("student_applications") .select("*", { count: "exact", head: true }) .or( "offer_received.eq.true,status.in.(Offer Received,Visa Applied,Visa Approved,Visa Rejected,Travelled)", ), supabase .from("coaching_applications") .select("*", { count: "exact", head: true }), supabase .from("education_loan_inquiries") .select("*", { count: "exact", head: true }), supabase.from("fee_payments").select("amount"), Promise.all( APPLICATION_STATUSES.map(async (status) => { const { count } = await appCount(status); return [status, count ?? 0] as const; }), ), ]); const branchCount = branchRes.count ?? 0; const userCount = userRes.count ?? 0; const totalLeads = totalLeadsRes.count ?? 0; const newLeads = newLeadsRes.count ?? 0; const todayFollowupsCount = todayFollowupsCountRes.count ?? 0; const statusBreakdown = statusBreakdownRes; const todayFollowups = (todayFollowupsRes.data ?? []) as unknown as TodayFollowup[]; const totalApps = totalAppsRes.count ?? 0; const visaApproved = visaApprovedRes.count ?? 0; const travelled = travelledRes.count ?? 0; const offers = offersFlagRes.count ?? 0; const coachingStudents = coachingRes.count ?? 0; const loanInquiries = loanRes.count ?? 0; const appStatusBreakdown = appStatusBreakdownRes; const totalFees = (feesRes.data ?? []).reduce( (sum, row) => sum + (Number((row as { amount: number | null }).amount) || 0), 0, ); const totalFeesLabel = `₹${totalFees.toLocaleString("en-IN")}`; const kpis = [ { label: "Total Leads", value: totalLeads, accent: "text-brand-blue", href: "/leads" }, { label: "Total Applications", value: totalApps, accent: "text-brand-blue", href: "/applications/student" }, { label: "Visa Approved", value: visaApproved, accent: "text-green-600", href: "/applications/visa" }, { label: "Total Fees Collected", value: totalFeesLabel, accent: "text-brand-orange", href: "/fee-payments", }, ]; const secondaryKpis = [ { label: "Offers", value: offers, accent: "text-indigo-600", href: "/applications/student" }, { label: "Coaching Students", value: coachingStudents, accent: "text-brand-blue", href: "/applications/coaching" }, { label: "Loan Inquiries", value: loanInquiries, accent: "text-brand-orange", href: "/loan-inquiry" }, { label: "Travelled", value: travelled, accent: "text-emerald-600", href: "/applications/student" }, ]; const greeting = (() => { const h = new Date().getHours(); return h < 12 ? "Good morning" : h < 17 ? "Good afternoon" : "Good evening"; })(); return (
{/* Editorial hero band — aubergine canvas with primary KPIs inset */}

{greeting}

{user.full_name.split(" ")[0]}.

{todayFollowupsCount} follow-up{todayFollowupsCount === 1 ? "" : "s"} today {" · "} {newLeads} new lead{newLeads === 1 ? "" : "s"} waiting. Keep guiding students to their dream destinations.

{kpis.map((kpi) => (
{kpi.value}
{kpi.label}
))}
✦
{/* Secondary KPIs — thin editorial cards */}
{secondaryKpis.map((kpi) => ( {kpi.label} {kpi.value} ))}
{/* Pipelines */}

Lead pipeline

{statusBreakdown.map(([status, count]) => ( {status} {count} ))}

Application pipeline

{appStatusBreakdown.map(([status, count]) => ( {status} {count} ))}
{/* Today's follow-ups + org counts */}
Today's Follow-ups {todayFollowups.length === 0 ? (

No follow-ups scheduled for today.

) : (
    {todayFollowups.map((f) => (
  • {f.lead?.full_name ?? "Unknown lead"} {f.lead?.phone ? (

    {f.lead.phone}

    ) : null}
    {f.from_time ? ( {f.from_time.slice(0, 5)} ) : null}
    • ))}
)}
Branches {branchCount} Users {userCount}
); }