<?php
declare(strict_types=1);
require_once __DIR__ . '/../../authentication/api/connect.php';

$method = $_SERVER['REQUEST_METHOD'] ?? 'GET';
if (!in_array($method, ['GET', 'POST'], true)) { header('Allow: GET, POST'); reply(405, ['status'=>'error','message'=>'Use GET or POST.']); }
$actor = require_auth();
if (!in_array($actor['role'] ?? '', ['admin','staff'], true)) { reply(403, ['status'=>'error','message'=>'Staff or top management access is required.']); }

if ($method === 'GET') {
    if (isset($_GET['id'])) {
        $stmt = db()->prepare('SELECT id,campus_code,campus_name,location,is_active FROM campuses WHERE id=?');
        $stmt->execute([(int)$_GET['id']]); $record = $stmt->fetch();
        if (!$record) { reply(404, ['status'=>'error','message'=>'Campus not found.']); }
        $record['_version'] = hash('sha256', json_encode($record, JSON_UNESCAPED_UNICODE));
        reply(200, ['status'=>'success','record'=>$record]);
    }
    $query = substr(trim((string)($_GET['q'] ?? '')), 0, 100);
    if ($query === '') {
        $records = db()->query('SELECT id,campus_code,campus_name,location,is_active FROM campuses ORDER BY campus_name')->fetchAll();
    } else {
        $stmt = db()->prepare('SELECT id,campus_code,campus_name,location,is_active FROM campuses WHERE campus_code LIKE ? OR campus_name LIKE ? OR location LIKE ? ORDER BY campus_name');
        $like = '%' . $query . '%'; $stmt->execute([$like,$like,$like]); $records = $stmt->fetchAll();
    }
    reply(200, ['status'=>'success','records'=>$records]);
}

start_auth_session();
$token = (string)($_SERVER['HTTP_X_CSRF_TOKEN'] ?? '');
if (!isset($_SESSION['csrf_token']) || !hash_equals((string)$_SESSION['csrf_token'], $token)) { reply(403, ['status'=>'error','message'=>'Your form session expired. Refresh and try again.']); }
$data = post_data();
$action = $data['action'] ?? '';
if (!in_array($action, ['create','update','delete'], true)) { reply(422, ['status'=>'error','message'=>'Choose a valid campus action.']); }
$id = filter_var($data['id'] ?? null, FILTER_VALIDATE_INT);
if ($action !== 'create' && (!$id || $id < 1)) { reply(422, ['status'=>'error','message'=>'Select a valid campus.']); }

try {
    $database = db();
    if ($action === 'delete') {
        $stmt = $database->prepare('DELETE FROM campuses WHERE id=?'); $stmt->execute([$id]);
        if (!$stmt->rowCount()) { reply(404, ['status'=>'error','message'=>'Campus not found.']); }
        audit_event((int)$actor['id'], (string)$actor['role'], 'campus', (int)$id, 'delete', 'Deleted a campus record.');
        reply(200, ['status'=>'success','message'=>'Campus deleted.']);
    }
    $code = strtoupper(trim((string)($data['campus_code'] ?? '')));
    $name = trim((string)($data['campus_name'] ?? ''));
    $location = trim((string)($data['location'] ?? ''));
    $active = filter_var($data['is_active'] ?? 1, FILTER_VALIDATE_INT);
    if (!preg_match('/^[A-Z0-9_-]{2,20}$/', $code) || $name === '' || mb_strlen($name) > 120 || mb_strlen($location) > 150 || !in_array($active, [0,1], true)) {
        reply(422, ['status'=>'error','message'=>'Enter a valid campus code, campus name, location and status.']);
    }
    if ($action === 'create') {
        $stmt = $database->prepare('INSERT INTO campuses(campus_code,campus_name,location,is_active) VALUES(?,?,?,?)');
        $stmt->execute([$code,$name,$location === '' ? null : $location,$active]); $id = (int)$database->lastInsertId();
        audit_event((int)$actor['id'], (string)$actor['role'], 'campus', $id, 'create', 'Added a campus.');
        reply(201, ['status'=>'success','message'=>'Campus added.']);
    }
    $database->beginTransaction();
    $stmt = $database->prepare('SELECT id,campus_code,campus_name,location,is_active FROM campuses WHERE id=? FOR UPDATE');
    $stmt->execute([$id]); $old = $stmt->fetch();
    if (!$old) { $database->rollBack(); reply(404, ['status'=>'error','message'=>'Campus not found.']); }
    $version = hash('sha256', json_encode($old, JSON_UNESCAPED_UNICODE));
    if (!is_string($data['_version'] ?? null) || !hash_equals($version, $data['_version'])) { $database->rollBack(); reply(409, ['status'=>'error','message'=>'This campus changed. Reload it and try again.']); }
    $stmt = $database->prepare('UPDATE campuses SET campus_code=?,campus_name=?,location=?,is_active=? WHERE id=?');
    $stmt->execute([$code,$name,$location === '' ? null : $location,$active,$id]);
    $database->commit();
    audit_event((int)$actor['id'], (string)$actor['role'], 'campus', (int)$id, 'update', 'Updated a campus.');
    reply(200, ['status'=>'success','message'=>'Campus updated.']);
} catch (mysqli_sql_exception $error) {
    if (in_array((int)$error->getCode(), [1062, 1451], true)) { reply(409, ['status'=>'error','message'=>'Campus code must be unique. A campus assigned to students or HODs cannot be deleted.']); }
    error_log('SLPS CAMPUS MANAGEMENT: database error ' . $error->getCode());
    reply(503, ['status'=>'error','message'=>'Campus management is unavailable. Check the database configuration.']);
}
