Protokoll #3597

{
    "event": "PreToolUse",
    "tool_name": "Read",
    "tool_input": {
        "file_path": "\/var\/www\/dev.campus.systemische-tools.de\/src\/Controller\/SystemExplorerController.php",
        "offset": 25,
        "limit": 80
    }
}

{
    "tool_response": {
        "type": "text",
        "file": {
            "filePath": "\/var\/www\/dev.campus.systemische-tools.de\/src\/Controller\/SystemExplorerController.php",
            "content": "    \/**\n     * GET \/explorer\n     * Dashboard mit Statistiken\n     *\/\n    public function index(): void\n    {\n        \/\/ Dokumente (depth=0) = Hauptbereiche\n        $dokumenteCount = $this->db->query(\n            'SELECT COUNT(*) FROM dokumentation WHERE depth = 0'\n        )->fetchColumn();\n\n        \/\/ Seiten (depth>0) = Unterseiten\n        $seitenCount = $this->db->query(\n            'SELECT COUNT(*) FROM dokumentation WHERE depth > 0'\n        )->fetchColumn();\n\n        \/\/ Chunk-Statistiken\n        $chunkStats = $this->db->query(\n            'SELECT\n                COUNT(*) as total,\n                COALESCE(SUM(token_count), 0) as tokens,\n                SUM(CASE WHEN analysis_status = \"completed\" THEN 1 ELSE 0 END) as analyzed,\n                SUM(CASE WHEN qdrant_id IS NOT NULL THEN 1 ELSE 0 END) as synced\n             FROM dokumentation_chunks'\n        )->fetch();\n\n        \/\/ Taxonomie-Kategorien\n        $taxonomyCategories = $this->db->query(\n            'SELECT taxonomy_category, COUNT(*) as count\n             FROM dokumentation_chunks\n             WHERE taxonomy_category IS NOT NULL\n             GROUP BY taxonomy_category\n             ORDER BY count DESC\n             LIMIT 10'\n        )->fetchAll();\n\n        \/\/ Dokumente (Hauptbereiche)\n        $dokumente = $this->db->query(\n            'SELECT d.id, d.title, d.path,\n                    (SELECT COUNT(*) FROM dokumentation WHERE parent_id = d.id) as seiten_count,\n                    (SELECT COUNT(*) FROM dokumentation_chunks WHERE dokumentation_id = d.id) as chunks_count\n             FROM dokumentation d\n             WHERE d.depth = 0\n             ORDER BY d.title'\n        )->fetchAll();\n\n        \/\/ Neueste Chunks\n        $recentChunks = $this->db->query(\n            'SELECT c.id, c.content, c.taxonomy_category, c.token_count, c.created_at,\n                    d.title as dokument_title, d.path as dokument_path\n             FROM dokumentation_chunks c\n             JOIN dokumentation d ON c.dokumentation_id = d.id\n             ORDER BY c.created_at DESC\n             LIMIT 5'\n        )->fetchAll();\n\n        $this->view('system-explorer.index', [\n            'title' => 'Doc2Vector Explorer',\n            'dokumenteCount' => $dokumenteCount,\n            'seitenCount' => $seitenCount,\n            'chunkStats' => $chunkStats,\n            'taxonomyCategories' => $taxonomyCategories,\n            'dokumente' => $dokumente,\n            'recentChunks' => $recentChunks,\n        ]);\n    }\n\n    \/**\n     * GET \/explorer\/dokumente\n     * Liste aller Hauptbereiche (depth=0)\n     *\/\n    public function dokumente(): void\n    {\n        $dokumente = $this->db->query(\n            'SELECT d.id, d.title, d.path, d.content, d.created_at, d.updated_at,\n                    (SELECT COUNT(*) FROM dokumentation WHERE parent_id = d.id) as seiten_count,\n                    (SELECT COUNT(*) FROM dokumentation_chunks WHERE dokumentation_id IN\n                        (SELECT id FROM dokumentation WHERE parent_id = d.id OR id = d.id)) as total_chunks,\n                    (SELECT COALESCE(SUM(token_count), 0) FROM dokumentation_chunks WHERE dokumentation_id IN\n                        (SELECT id FROM dokumentation WHERE parent_id = d.id OR id = d.id)) as total_tokens",
            "numLines": 80,
            "startLine": 25,
            "totalLines": 536
        }
    }
}