query("SELECT SUM(total_amount) FROM orders WHERE DATE(created_at) = CURDATE() AND payment_status = 'paid'")->fetchColumn() ?: 0.00;
$monthRevenue = $db->query("SELECT SUM(total_amount) FROM orders WHERE MONTH(created_at) = MONTH(CURDATE()) AND YEAR(created_at) = YEAR(CURDATE()) AND payment_status = 'paid'")->fetchColumn() ?: 0.00;
$totalOrders = $db->query("SELECT COUNT(*) FROM orders")->fetchColumn();
$pendingOrders = $db->query("SELECT COUNT(*) FROM orders WHERE order_status = 'pending'")->fetchColumn();
// Vendor metrics
$totalVendors = $db->query("SELECT COUNT(*) FROM vendors WHERE status='approved'")->fetchColumn();
$pendingVendorApps= $db->query("SELECT COUNT(*) FROM vendor_applications WHERE status='pending'")->fetchColumn();
// Latest orders
$latestOrders = $db->query("SELECT o.*, u.fullname FROM orders o JOIN users u ON o.user_id = u.id ORDER BY o.created_at DESC LIMIT 5")->fetchAll();
// Best selling items
$bestSelling = $db->query("SELECT product_name, SUM(quantity) as total_qty, SUM(subtotal) as total_sales FROM order_items GROUP BY product_name ORDER BY total_qty DESC LIMIT 5")->fetchAll();
require_once __DIR__ . '/../../includes/admin_header.php';
?>