<?php
// api/chat_media_common.php
// Shared helpers for Rockview Messages media stored by PHP/XAMPP.

require_once __DIR__ . '/session_auth.php';

function rvu_chat_media_cors(): void {
    $origin = trim((string)($_SERVER['HTTP_ORIGIN'] ?? ''));
    if ($origin !== '') {
        header('Access-Control-Allow-Origin: ' . $origin);
        header('Vary: Origin');
    }
    header('Access-Control-Allow-Headers: Authorization, Content-Type, Accept');
    header('Access-Control-Allow-Methods: GET, POST, DELETE, OPTIONS');
    header('Access-Control-Max-Age: 86400');
}

function rvu_chat_media_json(array $payload, int $status = 200): never {
    while (ob_get_level() > 0) {
        @ob_end_clean();
    }
    http_response_code($status);
    header('Content-Type: application/json; charset=utf-8');
    header('Cache-Control: no-store');
    echo json_encode($payload, JSON_UNESCAPED_SLASHES | JSON_UNESCAPED_UNICODE);
    exit;
}

function rvu_chat_media_require_user(PDO $pdo): array {
    $user = rvu_current_user($pdo);
    if (!$user) {
        rvu_chat_media_json(['detail' => 'Authentication required. Please sign in again.'], 401);
    }
    return $user;
}

function rvu_chat_media_role_is_admin(string $role): bool {
    $value = strtolower(trim(str_replace(['-', ' '], '_', $role)));
    return in_array($value, ['admin', 'administrator', 'superadmin', 'super_admin'], true);
}

function rvu_ensure_chat_media_table(PDO $pdo): void {
    $pdo->exec("CREATE TABLE IF NOT EXISTS chat_media_uploads (
        id BIGSERIAL PRIMARY KEY,
        access_token CHAR(64) NOT NULL UNIQUE,
        chat_id VARCHAR(180) NOT NULL,
        sender_user_id BIGINT NOT NULL,
        sender_email VARCHAR(255) NULL,
        original_name VARCHAR(255) NOT NULL,
        stored_name VARCHAR(255) NOT NULL,
        relative_path TEXT NOT NULL,
        mime_type VARCHAR(160) NOT NULL,
        extension VARCHAR(20) NOT NULL,
        media_type VARCHAR(20) NOT NULL,
        size_bytes BIGINT NOT NULL,
        created_at TIMESTAMPTZ NOT NULL DEFAULT CURRENT_TIMESTAMP,
        deleted_at TIMESTAMPTZ NULL
    )");
    $pdo->exec("CREATE INDEX IF NOT EXISTS idx_chat_media_chat_id ON chat_media_uploads (chat_id)");
    $pdo->exec("CREATE INDEX IF NOT EXISTS idx_chat_media_sender ON chat_media_uploads (sender_user_id)");
    $pdo->exec("CREATE INDEX IF NOT EXISTS idx_chat_media_created ON chat_media_uploads (created_at DESC)");
}

function rvu_chat_media_clean_filename(string $name): string {
    $name = str_replace(["\0", "\r", "\n", '/', '\\'], '', trim($name));
    if ($name === '') return 'attachment';
    if (function_exists('mb_substr')) {
        $name = mb_substr($name, 0, 220, 'UTF-8');
    } else {
        $name = substr($name, 0, 220);
    }
    return $name;
}

function rvu_chat_media_classify(string $extension, string $mime): array {
    $extension = strtolower($extension);
    $mime = strtolower(trim($mime));

    $imageMimes = [
        'jpg' => ['image/jpeg'],
        'jpeg' => ['image/jpeg'],
        'png' => ['image/png'],
        'webp' => ['image/webp'],
        'gif' => ['image/gif'],
    ];
    if (isset($imageMimes[$extension]) && in_array($mime, $imageMimes[$extension], true)) {
        return ['type' => 'image', 'max' => 10 * 1024 * 1024];
    }

    $videoExt = ['mp4', 'mov', 'webm', 'mkv'];
    $videoMimes = [
        'video/mp4', 'video/quicktime', 'video/webm', 'video/x-matroska',
        'application/octet-stream'
    ];
    if (in_array($extension, $videoExt, true) && in_array($mime, $videoMimes, true)) {
        return ['type' => 'video', 'max' => 30 * 1024 * 1024];
    }

    $audioExt = ['mp3', 'wav', 'ogg', 'm4a', 'aac'];
    $audioMimes = [
        'audio/mpeg', 'audio/wav', 'audio/x-wav', 'audio/ogg', 'audio/mp4',
        'audio/aac', 'application/octet-stream'
    ];
    if (in_array($extension, $audioExt, true) && in_array($mime, $audioMimes, true)) {
        return ['type' => 'audio', 'max' => 20 * 1024 * 1024];
    }

    $docExt = [
        'pdf', 'txt', 'csv', 'doc', 'docx', 'xls', 'xlsx', 'ppt', 'pptx',
        'zip', 'rar', '7z'
    ];
    $docMimes = [
        'application/pdf', 'text/plain', 'text/csv', 'application/csv',
        'application/msword',
        'application/vnd.openxmlformats-officedocument.wordprocessingml.document',
        'application/vnd.ms-excel',
        'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet',
        'application/vnd.ms-powerpoint',
        'application/x-ole-storage', 'application/vnd.ms-office',
        'application/vnd.openxmlformats-officedocument.presentationml.presentation',
        'application/zip', 'application/x-zip-compressed',
        'application/vnd.rar', 'application/x-rar-compressed',
        'application/x-7z-compressed', 'application/octet-stream'
    ];
    if (in_array($extension, $docExt, true) && in_array($mime, $docMimes, true)) {
        return ['type' => 'document', 'max' => 20 * 1024 * 1024];
    }

    throw new RuntimeException('Unsupported file type. Allowed: images, PDF/Office/text/archive documents, audio, and common video formats.');
}

function rvu_chat_media_download_url(string $token, bool $inline = false): string {
    $scheme = (!empty($_SERVER['HTTPS']) && strtolower((string)$_SERVER['HTTPS']) !== 'off') ? 'https' : 'http';
    $host = trim((string)($_SERVER['HTTP_HOST'] ?? '127.0.0.1'));
    $scriptName = str_replace('\\', '/', (string)($_SERVER['SCRIPT_NAME'] ?? '/api/chat_media.php'));
    $dir = rtrim(dirname($scriptName), '/.');
    $query = 'token=' . rawurlencode($token) . ($inline ? '&inline=1' : '');
    return $scheme . '://' . $host . $dir . '/chat_media_download.php?' . $query;
}

function rvu_chat_media_delete_file(string $relativePath): void {
    $root = realpath(__DIR__ . '/..');
    if (!$root) return;
    $relative = str_replace('\\', '/', $relativePath);
    $relative = ltrim(str_replace('..', '', $relative), '/');
    $full = $root . DIRECTORY_SEPARATOR . str_replace('/', DIRECTORY_SEPARATOR, $relative);
    if (is_file($full)) {
        @unlink($full);
    }
}
