query("
SELECT
DATE(created_at) as sale_date,
COUNT(id) as total_orders,
SUM(total_amount) as total_revenue
FROM orders
WHERE status = 'completed'
GROUP BY DATE(created_at)
ORDER BY sale_date DESC
")->fetchAll();
// 2. FETCH MONTHLY SALES (For Summary)
$monthly_sales = $pdo->query("
SELECT
DATE_FORMAT(created_at, '%Y-%m') as sale_month,
COUNT(id) as total_orders,
SUM(total_amount) as total_revenue
FROM orders
WHERE status = 'completed'
GROUP BY sale_month
ORDER BY sale_month DESC
LIMIT 6
")->fetchAll();
?>
Sales History