Protokoll #3639

{
    "event": "PreToolUse",
    "tool_name": "Edit",
    "tool_input": {
        "file_path": "\/var\/www\/dev.campus.systemische-tools.de\/src\/Controller\/Api\/ExplorerController.php",
        "old_string": "    \/**\n     * GET \/api\/v1\/explorer\/stats\n     *\/\n    public function stats(): void\n    {\n        try {\n            \/\/ Dokumente (depth=0)\n            $dokumenteCount = (int) $this->db->query(\n                'SELECT COUNT(*) FROM dokumentation WHERE depth = 0'\n            )->fetchColumn();\n\n            \/\/ Seiten (depth>0)\n            $seitenCount = (int) $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            )->fetchAll();\n\n            $this->json([\n                'success' => true,\n                'data' => [\n                    'dokumente' => $dokumenteCount,\n                    'seiten' => $seitenCount,\n                    'chunks' => [\n                        'total' => (int) $chunkStats['total'],\n                        'tokens' => (int) $chunkStats['tokens'],\n                        'analyzed' => (int) $chunkStats['analyzed'],\n                        'synced' => (int) $chunkStats['synced'],\n                    ],\n                    'taxonomy_categories' => $taxonomyCategories,\n                ],\n            ]);\n        } catch (\\Exception $e) {\n            $this->jsonError($e->getMessage());\n        }\n    }",
        "new_string": "    \/**\n     * GET \/api\/v1\/explorer\/stats\n     *\/\n    public function stats(): void\n    {\n        try {\n            $chunkStats = $this->repository->getChunkStats();\n\n            $this->json([\n                'success' => true,\n                'data' => [\n                    'dokumente' => $this->repository->countDokumente(),\n                    'seiten' => $this->repository->countSeiten(),\n                    'chunks' => $chunkStats,\n                    'taxonomy_categories' => $this->repository->getTopTaxonomyCategories(100),\n                ],\n            ]);\n        } catch (\\Exception $e) {\n            $this->jsonError($e->getMessage());\n        }\n    }"
    }
}

{
    "tool_response": {
        "filePath": "\/var\/www\/dev.campus.systemische-tools.de\/src\/Controller\/Api\/ExplorerController.php",
        "oldString": "    \/**\n     * GET \/api\/v1\/explorer\/stats\n     *\/\n    public function stats(): void\n    {\n        try {\n            \/\/ Dokumente (depth=0)\n            $dokumenteCount = (int) $this->db->query(\n                'SELECT COUNT(*) FROM dokumentation WHERE depth = 0'\n            )->fetchColumn();\n\n            \/\/ Seiten (depth>0)\n            $seitenCount = (int) $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            )->fetchAll();\n\n            $this->json([\n                'success' => true,\n                'data' => [\n                    'dokumente' => $dokumenteCount,\n                    'seiten' => $seitenCount,\n                    'chunks' => [\n                        'total' => (int) $chunkStats['total'],\n                        'tokens' => (int) $chunkStats['tokens'],\n                        'analyzed' => (int) $chunkStats['analyzed'],\n                        'synced' => (int) $chunkStats['synced'],\n                    ],\n                    'taxonomy_categories' => $taxonomyCategories,\n                ],\n            ]);\n        } catch (\\Exception $e) {\n            $this->jsonError($e->getMessage());\n        }\n    }",
        "newString": "    \/**\n     * GET \/api\/v1\/explorer\/stats\n     *\/\n    public function stats(): void\n    {\n        try {\n            $chunkStats = $this->repository->getChunkStats();\n\n            $this->json([\n                'success' => true,\n                'data' => [\n                    'dokumente' => $this->repository->countDokumente(),\n                    'seiten' => $this->repository->countSeiten(),\n                    'chunks' => $chunkStats,\n                    'taxonomy_categories' => $this->repository->getTopTaxonomyCategories(100),\n                ],\n            ]);\n        } catch (\\Exception $e) {\n            $this->jsonError($e->getMessage());\n        }\n    }",
        "originalFile": "<?php\n\nnamespace Controller\\Api;\n\nuse Framework\\Controller;\nuse Infrastructure\\Config\\DatabaseFactory;\nuse Infrastructure\\Docs\\HybridSearchService;\nuse Infrastructure\\Persistence\\SystemExplorerRepository;\n\n\/**\n * ExplorerController - REST-API für Doc2Vector Pipeline\n *\n * Endpoints für Dokumente, Seiten, Chunks, Taxonomie und Suche.\n * Uses ki_dev database for dokumentation tables.\n *\/\nclass ExplorerController extends Controller\n{\n    private \\PDO $db;\n    private SystemExplorerRepository $repository;\n\n    public function __construct()\n    {\n        $this->db = DatabaseFactory::dev();\n        $this->repository = new SystemExplorerRepository();\n    }\n\n    \/**\n     * GET \/api\/v1\/explorer\/stats\n     *\/\n    public function stats(): void\n    {\n        try {\n            \/\/ Dokumente (depth=0)\n            $dokumenteCount = (int) $this->db->query(\n                'SELECT COUNT(*) FROM dokumentation WHERE depth = 0'\n            )->fetchColumn();\n\n            \/\/ Seiten (depth>0)\n            $seitenCount = (int) $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            )->fetchAll();\n\n            $this->json([\n                'success' => true,\n                'data' => [\n                    'dokumente' => $dokumenteCount,\n                    'seiten' => $seitenCount,\n                    'chunks' => [\n                        'total' => (int) $chunkStats['total'],\n                        'tokens' => (int) $chunkStats['tokens'],\n                        'analyzed' => (int) $chunkStats['analyzed'],\n                        'synced' => (int) $chunkStats['synced'],\n                    ],\n                    'taxonomy_categories' => $taxonomyCategories,\n                ],\n            ]);\n        } catch (\\Exception $e) {\n            $this->jsonError($e->getMessage());\n        }\n    }\n\n    \/**\n     * GET \/api\/v1\/explorer\/dokumente\n     *\/\n    public function listDokumente(): void\n    {\n        try {\n            $dokumente = $this->db->query(\n                'SELECT d.id, d.title, d.path, 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\n                 FROM dokumentation d\n                 WHERE d.depth = 0\n                 ORDER BY d.title'\n            )->fetchAll();\n\n            $this->json([\n                'success' => true,\n                'data' => $dokumente,\n                'meta' => [\n                    'total' => count($dokumente),\n                ],\n            ]);\n        } catch (\\Exception $e) {\n            $this->jsonError($e->getMessage());\n        }\n    }\n\n    \/**\n     * GET \/api\/v1\/explorer\/dokumente\/{id}\n     *\/\n    public function getDokument(string $id): void\n    {\n        try {\n            $stmt = $this->db->prepare(\n                'SELECT * FROM dokumentation WHERE id = :id AND depth = 0'\n            );\n            $stmt->execute(['id' => (int) $id]);\n            $dokument = $stmt->fetch();\n\n            if ($dokument === false) {\n                $this->json(['success' => false, 'error' => 'Dokument nicht gefunden'], 404);\n\n                return;\n            }\n\n            \/\/ Seiten\n            $stmt = $this->db->prepare(\n                'SELECT s.id, s.title, s.path, s.depth,\n                        (SELECT COUNT(*) FROM dokumentation_chunks WHERE dokumentation_id = s.id) as chunks_count,\n                        (SELECT COALESCE(SUM(token_count), 0) FROM dokumentation_chunks WHERE dokumentation_id = s.id) as token_count\n                 FROM dokumentation s\n                 WHERE s.parent_id = :id\n                 ORDER BY s.title'\n            );\n            $stmt->execute(['id' => (int) $id]);\n            $seiten = $stmt->fetchAll();\n\n            \/\/ Taxonomie\n            $stmt = $this->db->prepare(\n                'SELECT taxonomy_category, COUNT(*) as count\n                 FROM dokumentation_chunks\n                 WHERE dokumentation_id IN (\n                     SELECT id FROM dokumentation WHERE id = :id OR parent_id = :id2\n                 )\n                 AND taxonomy_category IS NOT NULL\n                 GROUP BY taxonomy_category\n                 ORDER BY count DESC'\n            );\n            $stmt->execute(['id' => (int) $id, 'id2' => (int) $id]);\n            $taxonomy = $stmt->fetchAll();\n\n            $this->json([\n                'success' => true,\n                'data' => [\n                    'dokument' => $dokument,\n                    'seiten' => $seiten,\n                    'taxonomy' => $taxonomy,\n                ],\n            ]);\n        } catch (\\Exception $e) {\n            $this->jsonError($e->getMessage());\n        }\n    }\n\n    \/**\n     * GET \/api\/v1\/explorer\/seiten\n     *\/\n    public function listSeiten(): void\n    {\n        try {\n            $search = $this->getString('search');\n            $parentId = $this->getString('parent_id');\n            $limit = $this->getLimit(100, 50);\n            $offset = $this->getInt('offset');\n\n            $sql = 'SELECT s.id, s.title, s.path, s.depth, s.parent_id,\n                           p.title as parent_title,\n                           (SELECT COUNT(*) FROM dokumentation_chunks WHERE dokumentation_id = s.id) as chunks_count,\n                           (SELECT COALESCE(SUM(token_count), 0) FROM dokumentation_chunks WHERE dokumentation_id = s.id) as token_count\n                    FROM dokumentation s\n                    LEFT JOIN dokumentation p ON s.parent_id = p.id\n                    WHERE s.depth > 0';\n\n            $countSql = 'SELECT COUNT(*) FROM dokumentation s WHERE s.depth > 0';\n            $params = [];\n\n            if ($search !== '') {\n                $sql .= ' AND (s.title LIKE :search OR s.path LIKE :search2)';\n                $countSql .= ' AND (s.title LIKE :search OR s.path LIKE :search2)';\n                $params['search'] = '%' . $search . '%';\n                $params['search2'] = '%' . $search . '%';\n            }\n\n            if ($parentId !== '') {\n                $sql .= ' AND s.parent_id = :parent';\n                $countSql .= ' AND s.parent_id = :parent';\n                $params['parent'] = (int) $parentId;\n            }\n\n            $stmt = $this->db->prepare($countSql);\n            $stmt->execute($params);\n            $total = (int) $stmt->fetchColumn();\n\n            $sql .= ' ORDER BY p.title, s.depth, s.title LIMIT :limit OFFSET :offset';\n            $params['limit'] = $limit;\n            $params['offset'] = $offset;\n\n            $stmt = $this->db->prepare($sql);\n            foreach ($params as $key => $value) {\n                $stmt->bindValue($key, $value, is_int($value) ? \\PDO::PARAM_INT : \\PDO::PARAM_STR);\n            }\n            $stmt->execute();\n            $seiten = $stmt->fetchAll();\n\n            $this->json([\n                'success' => true,\n                'data' => $seiten,\n                'meta' => [\n                    'total' => $total,\n                    'limit' => $limit,\n                    'offset' => $offset,\n                ],\n            ]);\n        } catch (\\Exception $e) {\n            $this->jsonError($e->getMessage());\n        }\n    }\n\n    \/**\n     * GET \/api\/v1\/explorer\/seiten\/{id}\n     *\/\n    public function getSeite(string $id): void\n    {\n        try {\n            $stmt = $this->db->prepare(\n                'SELECT s.*, p.title as parent_title, p.path as parent_path\n                 FROM dokumentation s\n                 LEFT JOIN dokumentation p ON s.parent_id = p.id\n                 WHERE s.id = :id'\n            );\n            $stmt->execute(['id' => (int) $id]);\n            $seite = $stmt->fetch();\n\n            if ($seite === false) {\n                $this->json(['success' => false, 'error' => 'Seite nicht gefunden'], 404);\n\n                return;\n            }\n\n            \/\/ Chunks\n            $stmt = $this->db->prepare(\n                'SELECT c.id, c.chunk_index, c.content, c.token_count, c.taxonomy_category,\n                        c.taxonomy_path, c.entities, c.keywords, c.analysis_status, c.qdrant_id\n                 FROM dokumentation_chunks c\n                 WHERE c.dokumentation_id = :id\n                 ORDER BY c.chunk_index'\n            );\n            $stmt->execute(['id' => (int) $id]);\n            $chunks = $stmt->fetchAll();\n\n            \/\/ Decode JSON\n            foreach ($chunks as &$c) {\n                $c['entities'] = $this->decodeJson($c['entities'] ?? null);\n                $c['keywords'] = $this->decodeJson($c['keywords'] ?? null);\n                $c['taxonomy_path'] = $this->decodeJson($c['taxonomy_path'] ?? null);\n            }\n\n            \/\/ Unterseiten\n            $stmt = $this->db->prepare(\n                'SELECT id, title, path, depth FROM dokumentation WHERE parent_id = :id ORDER BY title'\n            );... [TRUNCATED-c439946b6a6e6c87]",
        "structuredPatch": [
            {
                "oldStart": 30,
                "oldLines": 47,
                "newStart": 30,
                "newLines": 15,
                "lines": [
                    "     public function stats(): void",
                    "     {",
                    "         try {",
                    "-            \/\/ Dokumente (depth=0)",
                    "-            $dokumenteCount = (int) $this->db->query(",
                    "-                'SELECT COUNT(*) FROM dokumentation WHERE depth = 0'",
                    "-            )->fetchColumn();",
                    "+            $chunkStats = $this->repository->getChunkStats();",
                    " ",
                    "-            \/\/ Seiten (depth>0)",
                    "-            $seitenCount = (int) $this->db->query(",
                    "-                'SELECT COUNT(*) FROM dokumentation WHERE depth > 0'",
                    "-            )->fetchColumn();",
                    "-",
                    "-            \/\/ Chunk-Statistiken",
                    "-            $chunkStats = $this->db->query(",
                    "-                'SELECT",
                    "-                    COUNT(*) as total,",
                    "-                    COALESCE(SUM(token_count), 0) as tokens,",
                    "-                    SUM(CASE WHEN analysis_status = \"completed\" THEN 1 ELSE 0 END) as analyzed,",
                    "-                    SUM(CASE WHEN qdrant_id IS NOT NULL THEN 1 ELSE 0 END) as synced",
                    "-                 FROM dokumentation_chunks'",
                    "-            )->fetch();",
                    "-",
                    "-            \/\/ Taxonomie-Kategorien",
                    "-            $taxonomyCategories = $this->db->query(",
                    "-                'SELECT taxonomy_category, COUNT(*) as count",
                    "-                 FROM dokumentation_chunks",
                    "-                 WHERE taxonomy_category IS NOT NULL",
                    "-                 GROUP BY taxonomy_category",
                    "-                 ORDER BY count DESC'",
                    "-            )->fetchAll();",
                    "-",
                    "             $this->json([",
                    "                 'success' => true,",
                    "                 'data' => [",
                    "-                    'dokumente' => $dokumenteCount,",
                    "-                    'seiten' => $seitenCount,",
                    "-                    'chunks' => [",
                    "-                        'total' => (int) $chunkStats['total'],",
                    "-                        'tokens' => (int) $chunkStats['tokens'],",
                    "-                        'analyzed' => (int) $chunkStats['analyzed'],",
                    "-                        'synced' => (int) $chunkStats['synced'],",
                    "-                    ],",
                    "-                    'taxonomy_categories' => $taxonomyCategories,",
                    "+                    'dokumente' => $this->repository->countDokumente(),",
                    "+                    'seiten' => $this->repository->countSeiten(),",
                    "+                    'chunks' => $chunkStats,",
                    "+                    'taxonomy_categories' => $this->repository->getTopTaxonomyCategories(100),",
                    "                 ],",
                    "             ]);",
                    "         } catch (\\Exception $e) {"
                ]
            }
        ],
        "userModified": false,
        "replaceAll": false
    }
}