<?php
// api/campuses.php
require_once __DIR__ . '/../config/database.php';
require_once __DIR__ . '/session_auth.php';
rvu_audit_context_from_request($pdo);
header('Content-Type: application/json; charset=UTF-8');

function campusRespond($code, $body = null) {
    http_response_code($code);
    if ($body !== null) echo json_encode($body);
    exit;
}

$method = $_SERVER['REQUEST_METHOD'];
$parts = explode('/', trim($_SERVER['PATH_INFO'] ?? '', '/'));
$id = $parts[0] !== '' ? $parts[0] : null;
if (count($parts) > 1 || ($id !== null && (!ctype_digit($id) || (int)$id <= 0))) {
    campusRespond(400, ['detail' => 'Invalid campus ID or route.']);
}

try {
    if ($method === 'GET' && $id === null) {
        $stmt = $pdo->query('SELECT * FROM campuses ORDER BY name ASC');
        campusRespond(200, $stmt->fetchAll(PDO::FETCH_ASSOC));
    }

    if ($method === 'POST' || $method === 'PUT') {
        $raw = file_get_contents('php://input');
        $decoded = json_decode($raw);
        if (json_last_error() !== JSON_ERROR_NONE || !is_object($decoded)) {
            campusRespond(400, ['detail' => 'Supply a valid JSON object.']);
        }
        $input = (array)$decoded;
        foreach (array_keys($input) as $key) {
            if (!in_array($key, ['name', 'description'], true)) {
                campusRespond(400, ['detail' => 'Unsupported campus field: ' . $key]);
            }
        }
        if ($method === 'POST' || array_key_exists('name', $input)) {
            if (!is_string($input['name'] ?? null) || trim($input['name']) === '') {
                campusRespond(400, ['detail' => 'Campus name is required.']);
            }
            $input['name'] = trim($input['name']);
        }
        if (array_key_exists('description', $input)) {
            if ($input['description'] !== null && !is_string($input['description'])) {
                campusRespond(400, ['detail' => 'Description must be text.']);
            }
            $input['description'] = trim($input['description'] ?? '');
        }
    }

    if ($method === 'POST' && $id === null) {
        $stmt = $pdo->prepare('INSERT INTO campuses (name, description) VALUES (?, ?)');
        $stmt->execute([$input['name'], $input['description'] ?? '']);
        campusRespond(201, ['message' => 'Campus created', 'id' => $pdo->lastInsertId()]);
    }

    if (($method === 'PUT' || $method === 'DELETE') && $id !== null) {
        if ($method === 'PUT' && empty($input)) {
            campusRespond(400, ['detail' => 'No campus changes supplied.']);
        }
        // Lock and check existence to avoid reporting success for a missing ID.
        $pdo->beginTransaction();
        $check = $pdo->prepare('SELECT id FROM campuses WHERE id = ? FOR UPDATE');
        $check->execute([$id]);
        if ($check->fetchColumn() === false) {
            $pdo->rollBack();
            campusRespond(404, ['detail' => 'Campus not found. Reload the directory.']);
        }
        if ($method === 'PUT') {
            $fields = [];
            $params = [];
            foreach ($input as $key => $value) {
                $fields[] = "$key = ?";
                $params[] = $value;
            }
            $params[] = $id;
            $stmt = $pdo->prepare('UPDATE campuses SET ' . implode(', ', $fields) . ' WHERE id = ?');
            $stmt->execute($params);
            $pdo->commit();
            campusRespond(200, ['message' => 'Campus updated']);
        }
        $pdo->prepare('DELETE FROM campuses WHERE id = ?')->execute([$id]);
        $pdo->commit();
        campusRespond(204);
    }
    campusRespond(405, ['detail' => 'Unsupported method or missing campus ID.']);
} catch (PDOException $error) {
    if ($pdo->inTransaction()) $pdo->rollBack();
    $sqlState = (string)$error->getCode();
    if (in_array($sqlState, ['23503', '23000'], true) && $method === 'DELETE') {
        campusRespond(409, ['detail' => 'This campus is linked to other records and cannot be deleted.']);
    }
    if ($sqlState === '23505') {
        campusRespond(409, ['detail' => 'A campus record with these unique details already exists.']);
    }
    campusRespond(500, ['detail' => 'Database error: ' . $error->getMessage()]);
}
