0) { $i = floor(log($bytes) / log(1024)); $sizes = ['B', 'KB', 'MB', 'GB', 'TB']; return sprintf('%.0' . $precision . 'F', $bytes / pow(1024, $i)) * 1 . ' ' . $sizes[$i]; } else { return '0 B'; } } /** * Formats a timestamp string to 'Y-m-d H:i:s'. * @param string|null $timestamp The timestamp string to format. * @return string The formatted timestamp or the original string if invalid. */ function format_timestamp($timestamp) { if (!$timestamp || $timestamp === 'No records') { return $timestamp; } try { return (new DateTime($timestamp))->format('Y-m-d H:i:s'); } catch (Exception $e) { return $timestamp; } } // Initialize arrays for data $stats = [ 'db_size' => 'N/A', 'db_name' => 'N/A', 'tables' => [ 'REPOSITORY' => ['count' => 0, 'latest' => 'No records'], 'PROJECT' => ['count' => 0, 'latest' => 'No records'], 'COMPONENT' => ['count' => 0, 'latest' => 'No records'], 'FILE' => ['count' => 0, 'latest' => 'No records'] ] ]; $recent_activity = []; $search_results = []; $error_message = null; // FIX: Use a more robust check that allows searching for '0' and handles empty submission. $search_query = isset($_GET['search_query']) ? trim($_GET['search_query']) : ''; $has_query = array_key_exists('search_query', $_GET) && $search_query !== ''; try { if ($has_query) { // FIX: Escape special LIKE characters for a literal search $needle = str_replace(['\\', '%', '_'], ['\\\\', '\\%', '\\_'], $search_query); // FIX: Use ILIKE for case-insensitivity and encode() for safe BYTEA handling in SQL $stmt = $conn->prepare(' SELECT f."FILE_ID", f."FILE_NAME", encode(f."CODE", \'escape\') AS "CODE", -- Let BYTEA return as readable text f."CREATED_AT", c."COMPONENT_NAME", c."COMPONENT_ID", p."PROJECT_NAME", p."PROJECT_ID", r."REPOSITORY_NAME", r."REPOSITORY_ID" FROM "FILE" f LEFT JOIN "COMPONENT" c ON f."COMPONENT_ID" = c."COMPONENT_ID" LEFT JOIN "PROJECT" p ON c."PROJECT_ID" = p."PROJECT_ID" LEFT JOIN "REPOSITORY" r ON p."REPOSITORY_ID" = r."REPOSITORY_ID" WHERE f."FILE_NAME" ILIKE :q ESCAPE \'\\\' ORDER BY f."CREATED_AT" DESC LIMIT 100 '); $stmt->bindValue(':q', "%{$needle}%", PDO::PARAM_STR); $stmt->execute(); $search_results = $stmt->fetchAll(PDO::FETCH_ASSOC); } else { // --- If no search, fetch dashboard data --- // 1. Fetch Summary Statistics $db_name_stmt = $conn->query('SELECT current_database()'); $stats['db_name'] = $db_name_stmt->fetchColumn(); if ($stats['db_name']) { $size_stmt = $conn->prepare('SELECT pg_database_size(?)'); $size_stmt->bindParam(1, $stats['db_name'], PDO::PARAM_STR); $size_stmt->execute(); $stats['db_size'] = format_bytes($size_stmt->fetchColumn()); } foreach ($stats['tables'] as $table_name => &$table_data) { $table_data['count'] = $conn->query("SELECT COUNT(*) FROM \"{$table_name}\"")->fetchColumn(); $latest = $conn->query("SELECT MAX(\"CREATED_AT\") FROM \"{$table_name}\"")->fetchColumn(); if ($latest) $table_data['latest'] = $latest; } unset($table_data); // 2. Fetch Recent Activity $activity_tables = [ 'REPOSITORY' => 'REPOSITORY_NAME', 'PROJECT' => 'PROJECT_NAME', 'COMPONENT' => 'COMPONENT_NAME', 'FILE' => 'FILE_NAME' ]; foreach ($activity_tables as $table_name => $name_col) { $stmt = $conn->query("SELECT \"{$name_col}\" AS name, \"CREATED_AT\" FROM \"{$table_name}\" ORDER BY \"CREATED_AT\" DESC LIMIT 30"); $recent_activity[$table_name]['records'] = $stmt->fetchAll(PDO::FETCH_ASSOC); } } } catch (PDOException $e) { $error_message = "Database query failed: " . htmlspecialchars($e->getMessage(), ENT_QUOTES, 'UTF-8'); } // SVG icons for dashboard cards and activity lists $icons = [ 'db_size' => '', 'REPOSITORY' => '', 'PROJECT' => '', 'COMPONENT' => '', 'FILE' => '' ]; //$icon_colors = ['#00aaff', '#66d9ff', '#66ffc2', '#ffc966', '#ffb366']; $icon_colors = ['#00aaff', '#66d9ff', '#66ffc2', '#dd6b20', '#805ad5']; ?> Database Dashboard & File Search

Search

File Path
Content (Click to Copy)
Timestamp
/ / /
Decrypting…
No files found matching your search criteria.

Database Summary

Total Database Size
Database:
$data): ?>
Last entry:

Recent Activity

$data): ?>