19 lines
923 B
PHP
19 lines
923 B
PHP
<?php
|
|
require_once __DIR__ . '/../db/config.php';
|
|
require_once __DIR__ . '/../mail/MailService.php';
|
|
|
|
// Get all pending leave requests older than 24 hours
|
|
$pdo = db();
|
|
$stmt = $pdo->prepare("SELECT leave_requests.*, users.full_name AS student_name FROM leave_requests JOIN users ON leave_requests.student_id = users.id WHERE status = 'pending' AND created_at < NOW() - INTERVAL 24 HOUR");
|
|
$stmt->execute();
|
|
$requests = $stmt->fetchAll();
|
|
|
|
foreach ($requests as $request) {
|
|
// Send reminder email to teacher
|
|
$teacher_email = 'teacher@example.com'; // Hardcoded for now
|
|
$subject = 'Reminder: Pending Leave Request from ' . $request['student_name'];
|
|
$body = "<p>This is a reminder that a leave request from {$request['student_name']} is still pending your approval.</p>\n <p>Please login to the dashboard to review the request.</p>";
|
|
MailService::sendMail($teacher_email, $subject, $body);
|
|
}
|
|
|