<?php
session_start();
require 'config/db.php';

// Ensure the user is logged in
if (!isset($_SESSION['user_id'])) {
    echo json_encode([]);  // Return an empty array if not logged in
    exit();
}

// Get the school_id from the session
$school_id = $_SESSION['school_id']; // Assuming school_id is stored in the session

// Fetch active alerts for this user's school
$stmt = $pdo->prepare("SELECT alert_id, type, message, timestamp FROM alerts WHERE school_id = ? AND status = 'active' ORDER BY timestamp DESC");
$stmt->execute([$school_id]);
$alerts = $stmt->fetchAll(PDO::FETCH_ASSOC);

// Return the alerts as a JSON response
echo json_encode($alerts);
?>