AutoShell

dfhdfhhdfdfhdhfhfdhdfdhfdhfdfhhdfdfhdhfhdf AutoShell

?? Editing: mail_reminder.php

<?php
// Database connection
include 'dbconnection.php';

// Fetch campus details (adjust this if necessary)
$query = "SELECT id, name, email FROM campuses";
$result = $con->query($query);

if ($result->num_rows > 0) {
    // Loop through each campus and fetch outstanding students
    while ($campus = $result->fetch_assoc()) {
        $campus_name = $campus['name'];
        $admin_email = $campus['email'];

// Fetch students with outstanding payments for the campus
        $query_students = "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_students);
        $stmt->bind_param("s", $campus_name);
        $stmt->execute();
        $result_students = $stmt->get_result();

// Prepare the list of students with outstanding payments
        $students_with_outstanding_payments = [];
        if ($result_students->num_rows > 0) {
            while ($row = $result_students->fetch_assoc()) {
                $students_with_outstanding_payments[] = $row;
            }
        }

// Send email to the campus admin if there are outstanding payments
        if (!empty($students_with_outstanding_payments)) {
            sendEmailNotification($admin_email, $students_with_outstanding_payments, $campus_name);
        }
    }
}

// Function to send an email to the campus admin
function sendEmailNotification($admin_email, $students_with_outstanding_payments, $campus_name) {
    $subject = "Outstanding Student Payments for Campus: $campus_name";
    $message = "Dear Campus Admin,\n\nThe following students have outstanding payments:\n\n";
    
    // Build the message content
    foreach ($students_with_outstanding_payments as $student) {
        $message .= "Name: " . $student['FirstName'] . " " . $student['LastName'] . "\n";
        $message .= "Email: " . $student['Email'] . "\n";
        $message .= "Outstanding Amount: " . number_format($student['Outstanding_Payment'], 2) . "\n\n";
    }
    
    $message .= "Please take action to remind the students.\n\nBest regards,\nRCM External Study Department";
    
    // Headers for the email
    $headers = "From: RCM External Campus <externalstudies@rcm.edu.ng>\r\n";
    $headers .= "Reply-To: externalstudies@rcm.edu.ng\r\n";
    $headers .= "Content-Type: text/plain; charset=UTF-8\r\n";
    
    // Send the email
    mail($admin_email, $subject, $message, $headers);
}
?>

Path:

home / rcmewpjy / public_html / tmportal / cam /

?? Editing: mail_reminder.php

Path:

?? Upload