AutoShell

dfhdfhhdfdfhdhfhfdhdfdhfdhfdfhhdfdfhdhfhdf AutoShell

?? Editing: out_payment.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();

// Initialize campus name
$campus_name = '';

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

// Debug: Output campus name
// echo "Debug: Campus Name - " . htmlspecialchars($campus_name) . "<br>";

// Fetch students with outstanding payments for the campus
$query = "SELECT FirstName, LastName, Email, MobileNumber, School_Fee, Total_Payment, 
          (School_Fee - Total_Payment) AS Outstanding_Payment 
          FROM tbluser 
          WHERE Campus = ? AND (School_Fee - Total_Payment) > 0";
$stmt = $con->prepare($query);
$stmt->bind_param("s", $campus_name); // Match students based on campus name
$stmt->execute();
$result = $stmt->get_result();

// Prepare the list of students with outstanding payments
$students_with_outstanding_payments = [];
if ($result->num_rows > 0) {
    while ($row = $result->fetch_assoc()) {
        $students_with_outstanding_payments[] = $row;
    }
} else {
    // Debug: Output no results found
    // echo "Debug: No outstanding payments found for campus - " . htmlspecialchars($campus_name) . "<br>";
}

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Campus Dashboard</title>
    <?php include 'header.php'; ?>
    <style>
        /* Your existing styles */
    </style>
</head>
<body>
  
  <div class="main-content">
    <h1>Outstanding Payments for <?php echo htmlspecialchars($campus_name); ?></h1> 
    
    
    <div class="table-container">
      <table>
        <thead>
          <tr>
            <th>S/N</th>
            <th>Name</th>
            <th>Email</th>
            <th>Contact</th>
            <th>School Fees</th>
            <th>Total Payment</th>
            <th>Outstanding Payment</th>
            <th>Action</th>
          </tr>
        </thead>
        <tbody>
          <?php
          if (!empty($students_with_outstanding_payments)) {
              $sn = 1;
              foreach ($students_with_outstanding_payments as $row) {
    $sn++;

$school_fee = is_numeric($row['School_Fee']) ? (float)$row['School_Fee'] : 0;
    $total_payment = is_numeric($row['Total_Payment']) ? (float)$row['Total_Payment'] : 0;
    $outstanding_payment = $school_fee - $total_payment;

echo "<tr>";
    echo "<td>{$sn}</td>";
    echo "<td>" . htmlspecialchars($row['FirstName'] . " " . $row['LastName']) . "</td>";
    echo "<td>" . htmlspecialchars($row['Email']) . "</td>";
    echo "<td>" . htmlspecialchars($row['MobileNumber']) . "</td>";
    echo "<td>" . number_format($school_fee, 2) . "</td>";
    echo "<td>" . number_format($total_payment, 2) . "</td>";
    echo "<td>" . number_format($outstanding_payment, 2) . "</td>";
    echo "<td><a href='pay.php?email=" . urlencode($row['Email']) . "' class='btn'>Pay</a></td>";
    echo "</tr>";
}
          } else {
              echo "<tr><td colspan='8'>No outstanding payments found for this campus.</td></tr>";
          }
          ?>
        </tbody>
      </table>
    </div>
  </div>
  
  <?php include 'js.php'; ?>
</body>
</html>

Path:

home / rcmewpjy / public_html / tmportal / cam /

?? Editing: out_payment.php

Path:

?? Upload