Aegis Infrastructure AegisAES 4.1M MongoDB

"", 'database' => "", 'cloud' => "", 'code' => "", 'globe' => "" ]; $color_index = 0; $chevron_svg = ""; try { // 1. Fetch all data from the three collections $repositories = $db->REPOSITORY->find([], ['sort' => ['REPOSITORY_NAME' => 1]])->toArray(); $projects = $db->PROJECT->find([], ['sort' => ['PROJECT_NAME' => 1]])->toArray(); $components = $db->COMPONENT->find([], ['sort' => ['COMPONENT_NAME' => 1]])->toArray(); // 2. Create lookup maps for efficient hierarchy building $projectsByRepoId = []; foreach ($projects as $project) { // Group projects by their parent REPOSITORY_ID (the integer/long key) $repoIdKey = (string)$project['REPOSITORY_ID']; if (!isset($projectsByRepoId[$repoIdKey])) { $projectsByRepoId[$repoIdKey] = []; } $projectsByRepoId[$repoIdKey][] = $project; } $componentsByProjectId = []; foreach ($components as $component) { // Group components by their parent PROJECT_ID (the integer/long key) $projIdKey = (string)$component['PROJECT_ID']; if (!isset($componentsByProjectId[$projIdKey])) { $componentsByProjectId[$projIdKey] = []; } $componentsByProjectId[$projIdKey][] = $component; } // 3. Loop through repositories and render the full hierarchy foreach ($repositories as $repo) { $repoIdStr = (string)$repo['_id']; $repoName = htmlspecialchars($repo['REPOSITORY_NAME'], ENT_QUOTES, 'UTF-8'); $repoIntId = (string)$repo['REPOSITORY_ID']; // Assign icon and color (same logic as before) $color = $icon_colors[$color_index % count($icon_colors)]; $color_index++; $random_icon_key = array_rand($tech_icons); $icon_html = str_replace(' {$icon_html} {$repoName} {$chevron_svg} "; // Start projects list echo "

"; // Check if there are projects for this repository if (isset($projectsByRepoId[$repoIntId])) { foreach ($projectsByRepoId[$repoIntId] as $project) { $projectIdStr = (string)$project['_id']; $projectName = htmlspecialchars($project['PROJECT_NAME'], ENT_QUOTES, 'UTF-8'); $projectIntId = (string)$project['PROJECT_ID']; $project_icon = ""; // Output project link echo " {$project_icon} {$projectName} {$chevron_svg} "; // Start components list echo "

"; // Check if there are components for this project if (isset($componentsByProjectId[$projectIntId])) { foreach ($componentsByProjectId[$projectIntId] as $component) { $componentIdStr = (string)$component['_id']; $componentName = htmlspecialchars($component['COMPONENT_NAME'], ENT_QUOTES, 'UTF-8'); $component_icon = ""; // Output component link (final node in this view) echo " {$component_icon} {$componentName} "; } } echo "

"; // end components } } echo "

"; // end projects } } catch(MongoDB\Driver\Exception\Exception $e) { echo "数据库查询错误: " . htmlspecialchars($e->getMessage(), ENT_QUOTES, 'UTF-8'); } // ########## END: MODIFIED FOR 4-COLLECTION SCHEMA ########## ?>