35 lines
1.2 KiB
PHP
35 lines
1.2 KiB
PHP
<?php
|
|
require_once 'auth.php';
|
|
require_login('secretariat');
|
|
require_once 'db/config.php';
|
|
require_once 'mail/MailService.php';
|
|
|
|
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
|
|
$submission_id = $_POST['submission_id'] ?? null;
|
|
$status = $_POST['status'] ?? null;
|
|
|
|
if ($submission_id && $status) {
|
|
$pdo = db();
|
|
$stmt = $pdo->prepare("UPDATE submissions SET status = ? WHERE id = ?");
|
|
$stmt->execute([$status, $submission_id]);
|
|
|
|
// Fetch applicant email
|
|
$stmt = $pdo->prepare("SELECT email, full_name FROM submissions WHERE id = ?");
|
|
$stmt->execute([$submission_id]);
|
|
$submission = $stmt->fetch(PDO::FETCH_ASSOC);
|
|
|
|
if ($submission) {
|
|
$to = $submission['email'];
|
|
$subject = "Your Security Clearance Application Status";
|
|
$body = "<p>Dear " . htmlspecialchars($submission['full_name']) . ",</p>";
|
|
$body .= "<p>Your application for security clearance has been <strong>" . htmlspecialchars($status) . "</strong>.</p>";
|
|
$body .= "<p>Thank you.</p>";
|
|
|
|
MailService::sendMail($to, $subject, $body, strip_tags($body));
|
|
}
|
|
}
|
|
}
|
|
|
|
header("Location: dashboard.php");
|
|
exit;
|