AutoShell

dfhdfhhdfdfhdhfhfdhdfdhfdhfdfhhdfdfhdhfhdf AutoShell

?? Editing: dashboard.php

<?php
session_start();

// Check if the user is logged in
if (!isset($_SESSION['email'])) {
    header("Location: index.php");
    exit();
}

// Database connection
include 'dbconnection.php';

// Fetch the logged-in campus admin's email from the session
$admin_email = $_SESSION['email'];

// Fetch province_id and state_id from the session
$province_id = $_SESSION['province_id'] ?? 'N/A'; // Default to 'N/A' if not set
$state_id = $_SESSION['state_id'] ?? 'N/A'; // Default to 'N/A' if not set

// Fetch the campus details for the logged-in admin
$query = "SELECT id, name FROM campuses WHERE email = ?";
$stmt = $con->prepare($query);
$stmt->bind_param("s", $admin_email);
$stmt->execute();
$result = $stmt->get_result();

if ($result->num_rows > 0) {
    $campus = $result->fetch_assoc();
    $campus_name = $campus['name'];
} else {
    die("Campus not found for the logged-in admin.");
}

// Fetch total students, total payments, and total outstanding payments for the campus
$query = "SELECT COUNT(*) AS total_students, 
                 SUM(School_Fee) AS total_fee,
                 SUM(Total_Payment) AS total_paid
          FROM tbluser 
          WHERE Campus = ?";
$stmt = $con->prepare($query);

if (!$stmt) {
    die("Error preparing the student query: " . $con->error);
}

$stmt->bind_param("s", $campus_name); // Match students based on campus name
$stmt->execute();
$result = $stmt->get_result();

$totals = $result->fetch_assoc();
$total_students = $totals['total_students'] ?? 0;
$total_paid = $totals['total_paid'] ?? 0;
$total_fee = $totals['total_fee'] ?? 0;
$total_outstanding = $total_fee - $total_paid; // Calculate total outstanding payments

// Close the prepared statement and connection
$stmt->close();
$con->close();
?>
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Campus Admin Dashboard</title>
    <?php include 'header.php'; ?>

<style>
        body {
            font-family: 'Arial', sans-serif;
            background-color: #f4f7fc;
            color: #333;
            margin: 0;
            padding: 0;
        }

.container {
            max-width: 1200px;
            margin: 0 auto;
            padding: 40px;
        }

.dashboard-title {
            text-align: center;
            font-size: 36px;
            font-weight: 600;
            color: #4a76a8;
            margin-bottom: 20px;
        }

.dashboard-subtitle {
            text-align: center;
            font-size: 18px;
            color: #777;
            margin-bottom: 40px;
        }

.summary {
            display: flex;
            justify-content: space-around;
            flex-wrap: wrap;
        }

.card {
            background-color: white;
            border-radius: 10px;
            box-shadow: 0 4px 8px rgba(0, 0, 0, 0.1);
            padding: 20px;
            text-align: center;
            width: 300px;
            margin: 20px;
            transition: transform 0.3s ease-in-out;
        }

.card:hover {
            transform: translateY(-10px);
        }

.card h2 {
            font-size: 24px;
            color: #333;
        }

.card p {
            font-size: 48px;
            font-weight: bold;
            color: #4a76a8;
            margin: 10px 0;
        }

.card p.outstanding {
            color: #e74c3c;
        }

.card-icon {
            font-size: 48px;
            color: #4a76a8;
            margin-bottom: 10px;
        }

@media (max-width: 768px) {
            .summary {
                flex-direction: column;
                align-items: center;
            }

.card {
                width: 90%;
            }
        }
    </style>
</head>
<body>

<div class="container">
        <h1 class="dashboard-title">Campus Admin Dashboard</h1>
        <h2 class="dashboard-subtitle">Welcome to the <?php echo $campus_name; ?> Dashboard</h2>

<div class="dashboard-subtitle">
            Province: <?php echo $province_id; ?> | State: <?php echo $state_id; ?>
        </div>

<div class="summary">
            
            <div class="card">
                <div class="card-icon">👥</div>
                <h2>Total Students</h2>
                <p><?php echo $total_students; ?></p>
            </div>

<div class="card">
                <div class="card-icon">💰</div>
                <h2>Total Payments Made</h2>
                <p>₦<?php echo number_format($total_paid, 2); ?></p>
            </div>

<div class="card">
                <div class="card-icon">📉</div>
                <h2>Total Outstanding Payments</h2>
                <p class="outstanding">₦<?php echo number_format($total_outstanding, 2); ?></p>
            </div>
        </div>
    </div>

<?php include 'js.php'; ?> 
</body>
</html>

Path:

home / rcmewpjy / public_html / tmportal / cam /

?? Editing: dashboard.php

Path:

?? Upload