query("SELECT COUNT(*) as total_orders FROM orders"); $total_orders = $stmt->fetch()['total_orders']; // Total Revenue (across all branches) $stmt = $pdo->query("SELECT SUM(total_amount) as total_revenue FROM orders"); $total_revenue = $stmt->fetch()['total_revenue'] ?? 0; // Current Day Revenue (across all branches) $stmt = $pdo->query("SELECT SUM(total_amount) as today_revenue FROM orders WHERE DATE(order_date) = CURDATE()"); $today_revenue = $stmt->fetch()['today_revenue'] ?? 0; // Total Food Items (across all branches) $stmt = $pdo->query("SELECT COUNT(*) as total_foods FROM foods"); $total_foods = $stmt->fetch()['total_foods']; // Pending Orders (across all branches) $stmt = $pdo->query("SELECT COUNT(*) as pending_orders FROM orders WHERE status = 'pending'"); $pending_orders = $stmt->fetch()['pending_orders']; // Total Branches $stmt = $pdo->query("SELECT COUNT(*) as total_branches FROM branches"); $total_branches = $stmt->fetch()['total_branches']; // Last 30 days orders (across all branches) $stmt = $pdo->query("SELECT COUNT(*) as last_30_days_orders FROM orders WHERE order_date >= DATE_SUB(CURDATE(), INTERVAL 30 DAY)"); $last_30_days_orders = $stmt->fetch()['last_30_days_orders']; // Last 30 days revenue (across all branches) $stmt = $pdo->query("SELECT SUM(total_amount) as last_30_days_revenue FROM orders WHERE order_date >= DATE_SUB(CURDATE(), INTERVAL 30 DAY)"); $last_30_days_revenue = $stmt->fetch()['last_30_days_revenue'] ?? 0; // Total Categories (across all branches) $stmt = $pdo->query("SELECT COUNT(*) as total_categories FROM food_categories"); $total_categories = $stmt->fetch()['total_categories']; // Data for Order Statistics Chart (last 30 days, grouped by day) $stmt = $pdo->query(" SELECT DATE(order_date) as order_day, SUM(total_amount) as daily_revenue FROM orders WHERE order_date >= DATE_SUB(CURDATE(), INTERVAL 30 DAY) GROUP BY DATE(order_date) ORDER BY order_day "); $chart_data = $stmt->fetchAll(); $chart_labels = []; $chart_revenues = []; foreach ($chart_data as $data) { $chart_labels[] = date('d M', strtotime($data['order_day'])); $chart_revenues[] = $data['daily_revenue']; } $chart_labels_json = json_encode($chart_labels); $chart_revenues_json = json_encode($chart_revenues); } catch (PDOException $e) { die("Error fetching statistics: " . $e->getMessage()); } // Include chart script (ApexCharts for visualization) $script = ' '; ?>
Admin Dashboard

Total Orders

+ Last 30 days

Total Revenue

₹

+₹ Last 30 days

Today's Revenue

₹

+₹ Current day

Pending Orders

+ Current pending

Total Branches

+0 Last 30 days

All Branches
Add Branch
query("SELECT branch_name, address, city, image_url FROM branches ORDER BY branch_name LIMIT 5"); $branches = $stmt->fetchAll(); foreach ($branches as $branch) { echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; } } catch (PDOException $e) { echo ''; } ?>
Branch Name Address City Image
' . htmlspecialchars($branch['branch_name']) . '' . htmlspecialchars($branch['address']) . '' . htmlspecialchars($branch['city']) . ''; if ($branch['image_url']) { echo 'Branch Image'; } echo '
Error loading branches: ' . $e->getMessage() . '
View All Branches
Order Statistics (All Branches)
₹
10% + ₹ Per Day
Food Categories

Total Categories

Manage Categories
Recent Orders (All Branches)
View All
query(" SELECT o.order_id, o.customer_name, o.customer_contact, o.order_date, o.total_amount, o.status, b.branch_name FROM orders o JOIN branches b ON o.branch_id = b.branch_id ORDER BY o.order_date DESC LIMIT 5 "); $orders = $stmt->fetchAll(); foreach ($orders as $order) { echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; } } catch (PDOException $e) { echo ''; } ?>
Branch Customer Order Date Total Amount Status
' . htmlspecialchars($order['branch_name']) . ''; echo '
'; echo '
' . htmlspecialchars($order['customer_name']) . '
'; echo '' . htmlspecialchars($order['customer_contact']) . ''; echo '
'; echo '		' . date('d M Y', strtotime($order['order_date'])) . '₹' . number_format($order['total_amount'], 2) . ''; $status_class = $order['status'] === 'pending' ? 'bg-warning-focus text-warning-main' : ($order['status'] === 'completed' ? 'bg-success-focus text-success-main' : 'bg-danger-focus text-danger-main'); echo '' . ucfirst($order['status']) . ''; echo '
Error loading orders: ' . $e->getMessage() . '
Tax Rates (Latest)
query(" SELECT t.cgst_rate, t.sgst_rate FROM taxes t WHERE t.effective_date = ( SELECT MAX(effective_date) FROM taxes ) LIMIT 1 "); $tax = $stmt->fetch(); if ($tax) { echo ''; echo ''; } else { echo ''; } } catch (PDOException $e) { echo ''; } ?>
Tax Type Rate
CGST' . number_format($tax['cgst_rate'], 2) . '%
SGST' . number_format($tax['sgst_rate'], 2) . '%
No tax rates defined
Error loading tax rates: ' . $e->getMessage() . '
Manage Taxes