<?php
// Shared helpers for the Rockview University asset register.
declare(strict_types=1);

require_once __DIR__ . '/../config/database.php';
require_once __DIR__ . '/session_auth.php';

function assets_json(array $body, int $status = 200): void {
    http_response_code($status);
    header('Content-Type: application/json; charset=UTF-8');
    header('Cache-Control: no-store');
    echo json_encode($body, JSON_UNESCAPED_UNICODE | JSON_UNESCAPED_SLASHES);
    exit;
}

function assets_input(): array {
    $raw = file_get_contents('php://input');
    if ($raw === false || trim($raw) === '') return [];
    $data = json_decode($raw, true);
    if (json_last_error() !== JSON_ERROR_NONE || !is_array($data)) {
        assets_json(['detail' => 'Supply a valid JSON object.'], 400);
    }
    return $data;
}

function assets_clean(mixed $value, int $max = 500): string {
    if ($value !== null && !is_scalar($value)) return '';
    $text = trim((string)($value ?? ''));
    if (mb_strlen($text) > $max) $text = mb_substr($text, 0, $max);
    return $text;
}

function assets_user(PDO $pdo): array {
    $user = rvu_current_user($pdo);
    if (!$user) assets_json(['detail' => 'Your session has expired. Please sign in again.'], 401);
    $user['id'] = (int)$user['id'];
    $user['role'] = strtolower(assets_clean($user['role'] ?? '', 40));
    return $user;
}

function assets_admin(array $user): void {
    if ($user['role'] !== 'admin') {
        assets_json(['detail' => 'Only administrators can manage university assets.'], 403);
    }
}

function assets_require_method(string $method): void {
    if (($_SERVER['REQUEST_METHOD'] ?? 'GET') !== $method) {
        header('Allow: ' . $method);
        assets_json(['detail' => 'Request method not allowed.'], 405);
    }
}

function assets_positive_id(mixed $value): int {
    $id = filter_var($value, FILTER_VALIDATE_INT);
    if ($id === false || $id < 1) assets_json(['detail' => 'Choose a valid record.'], 422);
    return $id;
}

function assets_date(mixed $value, string $label): ?string {
    $date = assets_clean($value, 10);
    if ($date === '') return null;
    $parsed = DateTimeImmutable::createFromFormat('!Y-m-d', $date);
    if (!$parsed || $parsed->format('Y-m-d') !== $date) {
        assets_json(['detail' => 'Enter a valid ' . $label . '.'], 422);
    }
    return $date;
}

function assets_money(mixed $value, string $label): ?float {
    if ($value === null || $value === '') return null;
    if (!is_numeric($value) || (float)$value < 0) {
        assets_json(['detail' => 'Enter a valid ' . $label . '.'], 422);
    }
    return round((float)$value, 2);
}

function assets_event(PDO $pdo, int $assetId, array $user, string $action, string $summary, array $details = []): void {
    $stmt = $pdo->prepare('INSERT INTO asset_events(asset_id,actor_user_id,action,summary,details) VALUES(?,?,?,?,CAST(? AS JSONB))');
    $stmt->execute([$assetId, $user['id'], $action, $summary, json_encode($details, JSON_UNESCAPED_UNICODE | JSON_UNESCAPED_SLASHES)]);
}

function assets_public_record(array $row): array {
    foreach (['id','created_by_user_id','assigned_to_user_id','assignment_id','open_maintenance'] as $key) {
        if (isset($row[$key])) $row[$key] = (int)$row[$key];
    }
    foreach (['purchase_cost','maintenance_cost'] as $key) {
        if (isset($row[$key])) $row[$key] = (float)$row[$key];
    }
    return $row;
}

function assets_record(PDO $pdo, int $id): ?array {
    $stmt = $pdo->prepare("SELECT a.*,aa.id AS assignment_id,aa.staff_user_id AS assigned_to_user_id,
        staff.full_name AS assigned_to_name,staff.email AS assigned_to_email,
        aa.assigned_at,aa.due_back_date,aa.assignment_note
        FROM assets a
        LEFT JOIN asset_assignments aa ON aa.asset_id=a.id AND aa.returned_at IS NULL
        LEFT JOIN users staff ON staff.id=aa.staff_user_id
        WHERE a.id=? LIMIT 1");
    $stmt->execute([$id]);
    $row = $stmt->fetch(PDO::FETCH_ASSOC);
    if (!$row) return null;
    $stmt = $pdo->prepare("SELECT e.id,e.action,e.summary,e.details,e.created_at,u.full_name AS actor_name,u.role AS actor_role
        FROM asset_events e JOIN users u ON u.id=e.actor_user_id WHERE e.asset_id=? ORDER BY e.id DESC LIMIT 40");
    $stmt->execute([$id]);
    $row['history'] = $stmt->fetchAll(PDO::FETCH_ASSOC);
    $stmt = $pdo->prepare("SELECT m.*,u.full_name AS reported_by_name FROM asset_maintenance m
        JOIN users u ON u.id=m.reported_by_user_id WHERE m.asset_id=? ORDER BY m.id DESC LIMIT 20");
    $stmt->execute([$id]);
    $row['maintenance_history'] = $stmt->fetchAll(PDO::FETCH_ASSOC);
    $stmt = $pdo->prepare('SELECT COUNT(*) FROM asset_maintenance WHERE asset_id=? AND closed_at IS NULL');
    $stmt->execute([$id]);
    $row['open_maintenance'] = (int)$stmt->fetchColumn();
    return assets_public_record($row);
}
