AutoShell

dfhdfhhdfdfhdhfhfdhdfdhfdhfdfhhdfdfhdhfhdf AutoShell

?? Editing: pay.php

<?php
session_start();
include 'dbconnection.php';

// Check if the session contains the campus admin's information
if (!isset($_SESSION['email'])) {
    die("Campus information is missing. Please log in.");
}

$campus = $_SESSION['email'];  // Assuming campus name or identifier is stored in the session

// Get student email from URL
$student_email = $_GET['email'] ?? '';
if (empty($student_email)) {
    die("Student email is missing.");
}

// Fetch the student's first name and last name from tbluser based on their email
$query = "SELECT FirstName, LastName FROM tbluser WHERE Email = ?";
$stmt = $con->prepare($query);
$stmt->bind_param('s', $student_email);
$stmt->execute();
$result = $stmt->get_result();
$student = $result->fetch_assoc();

if (!$student) {
    die("Student not found.");
}

$first_name = $student['FirstName'];
$last_name = $student['LastName'];

if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    $amount_paid = $_POST['amount_paid'];
    $payment_purpose = $_POST['payment_purpose'];  // Get the selected payment purpose
    $payment_proof = $_FILES['payment_proof'];

// Define the folder to store payment proof
    $upload_dir = 'payment_proof/';
    $allowed_file_types = ['image/jpeg', 'image/png', 'application/pdf']; // Add file types you accept

// Check if the uploaded file is valid
    if (in_array($payment_proof['type'], $allowed_file_types) && is_uploaded_file($payment_proof['tmp_name'])) {
        $upload_file = $upload_dir . basename($payment_proof['name']);
        
        // Ensure the directory has write permission
        if (move_uploaded_file($payment_proof['tmp_name'], $upload_file)) {
            // Get the current date
            $payment_date = date('Y-m-d H:i:s');  // Format: Year-Month-Day Hour:Minute:Second

// Insert the payment details into the payments table, including the payment_purpose and payment_date
            $query = "INSERT INTO payments (student_email, amount_paid, payment_proof, status, campus, payment_date, payment_purpose) 
                      VALUES (?, ?, ?, 'Pending', ?, ?, ?)";
            $stmt = $con->prepare($query);
            $stmt->bind_param('ssssss', $student_email, $amount_paid, $upload_file, $campus, $payment_date, $payment_purpose);
            
            if ($stmt->execute()) {
                // Send email notification to the school admin
                sendEmailNotification($student_email, $first_name, $last_name, $amount_paid, $upload_file, $campus, $payment_purpose);

header("Location: payment.php");
                exit();
            } else {
                echo "Error executing query: " . $stmt->error;
            }
        } else {
            echo "Failed to move uploaded file.";
        }
    } else {
        echo "Invalid file type or upload error.";
    }
}

// Function to send email notification to the school admin
function sendEmailNotification($student_email, $first_name, $last_name, $amount_paid, $payment_proof, $campus, $payment_purpose) {
    // School admin's email (you can hardcode or fetch dynamically)
    $admin_email = 'info.rcmtentmaking@gmail.com';
    
    // Email subject
    $subject = "Payment Proof Submitted by $campus for $first_name $last_name";
    
    // Email message
    $message = "Dear Admin,\n\n";
    $message .= "The following payment proof has been submitted by the campus with email ($campus):\n\n";
    $message .= "Student Name: $first_name $last_name\n";
    $message .= "Student Email: $student_email\n";
    $message .= "Amount Paid: " . number_format($amount_paid, 2) . "\n";
    $message .= "Purpose of Payment: $payment_purpose\n";  // Include the payment purpose
    $message .= "Please review the proof of payment.\n\nBest regards,\nYour Payment System";

// Email headers
    $headers = "From: externalstudies@rcm.edu.ng\r\n";
    $headers .= "Reply-To: noreply@rcm.edu.ng\r\n";
    $headers .= "Content-Type: text/plain; charset=UTF-8\r\n";

// Send email
    mail($admin_email, $subject, $message, $headers);
}
?>

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Make a Payment</title>
    <?php include 'header.php'; ?>
    <style>
        body {
            font-family: Arial, sans-serif;
            background-color: #f4f4f4;
            margin: 0;
            padding: 0;
        }
        .main-content {
            width: 100%;
            max-width: 600px;
            margin: 0 auto;
            background-color: #fff;
            padding: 20px;
            box-shadow: 0 4px 8px rgba(0, 0, 0, 0.1);
            border-radius: 8px;
            margin-top: 50px;
        }
        h1 {
            text-align: center;
            font-size: 24px;
            margin-bottom: 20px;
            color: #333;
        }
        label {
            display: block;
            font-weight: bold;
            margin-bottom: 8px;
            color: #333;
        }
        input[type="number"],
        input[type="file"],
        select {
            width: 100%;
            padding: 10px;
            margin-bottom: 15px;
            border-radius: 4px;
            border: 1px solid #ccc;
            font-size: 16px;
        }
        input[type="submit"] {
            background-color: #28a745;
            color: white;
            padding: 12px 20px;
            border: none;
            border-radius: 5px;
            cursor: pointer;
            font-size: 16px;
            transition: background-color 0.3s ease;
            width: 100%;
        }
        input[type="submit"]:hover {
            background-color: #218838;
        }
        @media (max-width: 600px) {
            .main-content {
                padding: 15px;
            }
            h1 {
                font-size: 20px;
            }
        }
    </style>
</head>
<body>
    
    <div class="main-content">
        <h1>Submit Payment for <?php echo $first_name . ' ' . $last_name; ?></h1>
        <form action="pay.php?email=<?php echo $student_email; ?>" method="POST" enctype="multipart/form-data">
            <label for="amount_paid">Amount Paid:</label>
            <input type="number" name="amount_paid" placeholder="Enter Amount Paid" required><br><br>

<label for="payment_purpose">Payment Purpose:</label>
            <select name="payment_purpose" required>
                 <option value="">Select Payment Purpose</option>
                <option value="School Fee">School Fee</option>
                <option value="Development Levy">Development Levy</option>
                <option value="Lecture Note">Lecture Note</option>
            </select><br><br>

<label for="payment_proof">Upload Proof of Payment (jpg,png,pdf):</label>
            <input type="file" name="payment_proof" required><br><br>

Path:

home / rcmewpjy / public_html / tmportal / cam /

?? Editing: pay.php

Path:

?? Upload