Admin Dashboard

The admin dashboard at /admin provides a comprehensive overview of business operations including sales metrics, order status breakdowns, inventory alerts, customer growth, and quick action shortcuts.

Architecture

Dashboard Stats

The dashboard fetches all stats in parallel using Promise.all for optimal load time:

const [
  totalOrders,
  totalUsers,
  totalProducts,
  totalLocations,
  totalReviews,
  recentOrders,
  lowStockProducts,
  recentUsers,
  ordersByStatus,
] = await Promise.all([
  prisma.order.count(),
  prisma.user.count(),
  prisma.product.count(),
  prisma.retailLocation.count(),
  prisma.review.count(),
  // ... detail queries
])

Dashboard Widgets

Stats Cards

Top-level KPIs displayed as StatsCard components:

Sales Overview

The SalesOverview component renders a 6-month sales trend chart using raw SQL:

SELECT
  to_char(date_trunc('month', "createdAt"), 'Mon') AS month,
  SUM(CASE WHEN status != 'CANCELLED' THEN total ELSE 0 END) AS sales,
  COUNT(*) AS orders
FROM orders
WHERE "createdAt" ≥ date_trunc('month', NOW()) - interval '6 months'
GROUP BY date_trunc('month', "createdAt")
ORDER BY date_trunc('month', "createdAt") ASC

Top Products Table

Shows the 5 best-selling products by unit quantity, with revenue totals.

Order Status Breakdown

Groups orders by status with counts, rendered as a breakdown chart.

Inventory Alert Widget

Displays the 5 products with lowest stock (inventory ≤ 10, active only), sorted ascending by inventory count.

Customer Growth Chart

Visualizes new customer registrations over time.

Recent Activity Feed

Shows the 3 most recent orders with customer name and total.

Quick Actions Grid

Shortcuts to common admin tasks (create product, view orders, manage inventory, etc.).

Admin Sections

The admin layout provides navigation to: