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

// Fetch schools in the defined order
$stmt = $pdo->prepare("
    SELECT school_id, name AS school_name 
    FROM schools 
    ORDER BY display_order ASC
");
$stmt->execute();
$schools = $stmt->fetchAll(PDO::FETCH_ASSOC);

// Process form submission
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    $school_id = $_POST['school_id'];
    $type = $_POST['type'];
    $location = !empty($_POST['location']) ? $_POST['location'] : "Unknown location";
    $message = !empty($_POST['message']) ? $_POST['message'] : "No message";

    // Check if the school_id is valid
    if ($school_id && in_array($school_id, array_column($schools, 'school_id'))) {
        // Insert alert into the database
        $stmt = $pdo->prepare("INSERT INTO alerts (school_id, type, location, message, status) VALUES (?, ?, ?, ?, 'active')");
        $stmt->execute([$school_id, $type, $location, $message]);

        // Redirect to dashboard after creation
        header('Location: dashboard.php');
        exit();
    } else {
        // Error if school_id is invalid or missing
        $error_message = "Invalid school selection.";
    }
}
?>

<?php include __DIR__ . '/views/header.php'; ?>

<h2>Create Alert</h2>
<div class="form-container">
    <?php if (!empty($error_message)): ?>
        <div class="error-message" style="color: red; font-size: 1.2em; font-weight: bold;">
            <?= htmlspecialchars($error_message) ?>
        </div>
    <?php endif; ?>

    <form method="POST" action="create_alert.php">
        <label for="school_id">Select School:</label>
        <select name="school_id" id="school_id" required>
            <?php foreach ($schools as $school): ?>
                <option value="<?= htmlspecialchars($school['school_id']) ?>">
                    <?= htmlspecialchars($school['school_name']) ?>
                </option>
            <?php endforeach; ?>
        </select>

        <!-- Type Selection -->
        <label for="type">Type:</label>
        <select name="type" id="type" required>
            <option value="Other">Other</option>
            <option value="Lockdown">Lockdown</option>
            <option value="Evacuation">Evacuation</option>
            <option value="Shelter in Place">Shelter in Place</option>
            <option value="Earthquake">Earthquake</option>
            <option value="Fire Drill">Fire Drill</option>
            <option value="Modified Lockdown">Modified Lockdown</option>
            <option value="Help Needed">Help Needed</option>
            <option value="Intruder">Intruder</option>
            <option value="Fight">Fight</option>
        </select>

        <label for="location">Location or Room:</label>
        <input type="text" id="location" name="location">

        <label for="message">Message:</label>
        <textarea name="message" id="message" rows="5"></textarea>

        <button type="submit" class="submit-button">Create Alert</button>
    </form>
</div>

<?php include __DIR__ . '/views/footer.php'; ?>