Protokoll #3839

{
    "event": "PreToolUse",
    "tool_name": "Edit",
    "tool_input": {
        "file_path": "\/var\/www\/dev.campus.systemische-tools.de\/src\/Controller\/SystemExplorerController.php",
        "old_string": "    \/**\n     * GET \/explorer\/seiten\/{id}\n     * Seiten-Details mit Chunks\n     *\/\n    public function seiteShow(int $id): void\n    {\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' => $id]);\n        $seite = $stmt->fetch();\n\n        if ($seite === false) {\n            $this->notFound('Seite nicht gefunden');\n        }\n\n        \/\/ Chunks dieser Seite\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                    c.heading_path, c.analyzed_at\n             FROM dokumentation_chunks c\n             WHERE c.dokumentation_id = :id\n             ORDER BY c.chunk_index'\n        );\n        $stmt->execute(['id' => $id]);\n        $chunks = $stmt->fetchAll();\n\n        \/\/ Unterseiten (falls depth=1)\n        $stmt = $this->db->prepare(\n            'SELECT id, title, path, depth FROM dokumentation WHERE parent_id = :id ORDER BY title'\n        );\n        $stmt->execute(['id' => $id]);\n        $unterseiten = $stmt->fetchAll();\n\n        \/\/ Breadcrumb aufbauen\n        $breadcrumb = $this->buildBreadcrumb($seite);\n\n        $this->view('system-explorer.seiten.show', [\n            'title' => $seite['title'],\n            'seite' => $seite,\n            'chunks' => $chunks,\n            'unterseiten' => $unterseiten,\n            'breadcrumb' => $breadcrumb,\n        ]);\n    }",
        "new_string": "    \/**\n     * GET \/explorer\/seiten\/{id}\n     * Seiten-Details mit Chunks\n     *\/\n    public function seiteShow(int $id): void\n    {\n        $seite = $this->repository->getSeiteWithParent($id);\n\n        if ($seite === null) {\n            $this->notFound('Seite nicht gefunden');\n        }\n\n        $this->view('system-explorer.seiten.show', [\n            'title' => $seite['title'],\n            'seite' => $seite,\n            'chunks' => $this->repository->getChunksDetailedForDokument($id),\n            'unterseiten' => $this->repository->getUnterseiten($id),\n            'breadcrumb' => $this->repository->buildBreadcrumb($seite),\n        ]);\n    }"
    }
}

{
    "tool_response": {
        "filePath": "\/var\/www\/dev.campus.systemische-tools.de\/src\/Controller\/SystemExplorerController.php",
        "oldString": "    \/**\n     * GET \/explorer\/seiten\/{id}\n     * Seiten-Details mit Chunks\n     *\/\n    public function seiteShow(int $id): void\n    {\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' => $id]);\n        $seite = $stmt->fetch();\n\n        if ($seite === false) {\n            $this->notFound('Seite nicht gefunden');\n        }\n\n        \/\/ Chunks dieser Seite\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                    c.heading_path, c.analyzed_at\n             FROM dokumentation_chunks c\n             WHERE c.dokumentation_id = :id\n             ORDER BY c.chunk_index'\n        );\n        $stmt->execute(['id' => $id]);\n        $chunks = $stmt->fetchAll();\n\n        \/\/ Unterseiten (falls depth=1)\n        $stmt = $this->db->prepare(\n            'SELECT id, title, path, depth FROM dokumentation WHERE parent_id = :id ORDER BY title'\n        );\n        $stmt->execute(['id' => $id]);\n        $unterseiten = $stmt->fetchAll();\n\n        \/\/ Breadcrumb aufbauen\n        $breadcrumb = $this->buildBreadcrumb($seite);\n\n        $this->view('system-explorer.seiten.show', [\n            'title' => $seite['title'],\n            'seite' => $seite,\n            'chunks' => $chunks,\n            'unterseiten' => $unterseiten,\n            'breadcrumb' => $breadcrumb,\n        ]);\n    }",
        "newString": "    \/**\n     * GET \/explorer\/seiten\/{id}\n     * Seiten-Details mit Chunks\n     *\/\n    public function seiteShow(int $id): void\n    {\n        $seite = $this->repository->getSeiteWithParent($id);\n\n        if ($seite === null) {\n            $this->notFound('Seite nicht gefunden');\n        }\n\n        $this->view('system-explorer.seiten.show', [\n            'title' => $seite['title'],\n            'seite' => $seite,\n            'chunks' => $this->repository->getChunksDetailedForDokument($id),\n            'unterseiten' => $this->repository->getUnterseiten($id),\n            'breadcrumb' => $this->repository->buildBreadcrumb($seite),\n        ]);\n    }",
        "originalFile": "<?php\n\nnamespace Controller;\n\nuse Domain\\ValueObject\\Pagination;\nuse Framework\\Controller;\nuse Infrastructure\\Config\\DatabaseFactory;\nuse Infrastructure\\Docs\\HybridSearchService;\nuse Infrastructure\\Persistence\\SystemExplorerRepository;\n\n\/**\n * SystemExplorerController - Interne System-Dokumentation\n *\n * Zeigt Code-Dokumentation, Seiten und Chunks aus der dokumentation_chunks Pipeline.\n * Für Admin\/Entwickler - System-Wissen.\n *\/\nclass SystemExplorerController extends Controller\n{\n    private \\PDO $db;\n    private SystemExplorerRepository $repository;\n\n    public function __construct()\n    {\n        $this->repository = new SystemExplorerRepository();\n        $this->db = DatabaseFactory::dev();\n    }\n\n    \/**\n     * GET \/explorer\n     * Dashboard mit Statistiken\n     *\/\n    public function index(): void\n    {\n        $this->view('system-explorer.index', [\n            'title' => 'Doc2Vector Explorer',\n            'dokumenteCount' => $this->repository->countDokumente(),\n            'seitenCount' => $this->repository->countSeiten(),\n            'chunkStats' => $this->repository->getChunkStats(),\n            'taxonomyCategories' => $this->repository->getTopTaxonomyCategories(10),\n            'dokumente' => $this->repository->getDokumenteWithStats(),\n            'recentChunks' => $this->repository->getRecentChunks(5),\n        ]);\n    }\n\n    \/**\n     * GET \/explorer\/dokumente\n     * Liste aller Hauptbereiche (depth=0)\n     *\/\n    public function dokumente(): void\n    {\n        $this->view('system-explorer.dokumente.index', [\n            'title' => 'Dokumente',\n            'dokumente' => $this->repository->getDokumenteWithFullStats(),\n        ]);\n    }\n\n    \/**\n     * GET \/explorer\/dokumente\/{id}\n     * Dokument-Details mit Seiten und Chunks\n     *\/\n    public function dokumentShow(int $id): void\n    {\n        $dokument = $this->repository->getDokumentRoot($id);\n\n        if ($dokument === null) {\n            $this->notFound('Dokument nicht gefunden');\n        }\n\n        $this->view('system-explorer.dokumente.show', [\n            'title' => $dokument['title'],\n            'dokument' => $dokument,\n            'seiten' => $this->repository->getSeitenWithStatsForParent($id),\n            'chunks' => $this->repository->getChunksForDokument($id),\n            'taxonomy' => $this->repository->getTaxonomyForDokumentTree($id),\n        ]);\n    }\n\n    \/**\n     * GET \/explorer\/seiten\n     * Liste aller Seiten (depth>0)\n     *\/\n    public function seiten(): void\n    {\n        $search = $this->getString('search');\n        $parentId = $this->getString('parent');\n\n        $this->view('system-explorer.seiten.index', [\n            'title' => 'Seiten',\n            'seiten' => $this->repository->getSeitenFiltered($search, $parentId),\n            'dokumente' => $this->repository->getDokumenteForFilter(),\n            'currentSearch' => $search,\n            'currentParent' => $parentId,\n        ]);\n    }\n\n    \/**\n     * GET \/explorer\/seiten\/{id}\n     * Seiten-Details mit Chunks\n     *\/\n    public function seiteShow(int $id): void\n    {\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' => $id]);\n        $seite = $stmt->fetch();\n\n        if ($seite === false) {\n            $this->notFound('Seite nicht gefunden');\n        }\n\n        \/\/ Chunks dieser Seite\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                    c.heading_path, c.analyzed_at\n             FROM dokumentation_chunks c\n             WHERE c.dokumentation_id = :id\n             ORDER BY c.chunk_index'\n        );\n        $stmt->execute(['id' => $id]);\n        $chunks = $stmt->fetchAll();\n\n        \/\/ Unterseiten (falls depth=1)\n        $stmt = $this->db->prepare(\n            'SELECT id, title, path, depth FROM dokumentation WHERE parent_id = :id ORDER BY title'\n        );\n        $stmt->execute(['id' => $id]);\n        $unterseiten = $stmt->fetchAll();\n\n        \/\/ Breadcrumb aufbauen\n        $breadcrumb = $this->buildBreadcrumb($seite);\n\n        $this->view('system-explorer.seiten.show', [\n            'title' => $seite['title'],\n            'seite' => $seite,\n            'chunks' => $chunks,\n            'unterseiten' => $unterseiten,\n            'breadcrumb' => $breadcrumb,\n        ]);\n    }\n\n    \/**\n     * GET \/explorer\/chunks\n     * Liste aller Chunks mit Filtern\n     *\/\n    public function chunks(): void\n    {\n        $category = $this->getString('category');\n        $status = $this->getString('status');\n        $search = $this->getString('search');\n        $pagination = Pagination::fromRequest(50);\n\n        $sql = 'SELECT c.id, c.chunk_index, c.content, c.token_count, c.taxonomy_category,\n                       c.analysis_status, c.qdrant_id, 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                WHERE 1=1';\n\n        $countSql = 'SELECT COUNT(*) FROM dokumentation_chunks c\n                     JOIN dokumentation d ON c.dokumentation_id = d.id\n                     WHERE 1=1';\n\n        $params = [];\n\n        if ($category !== '') {\n            $sql .= ' AND c.taxonomy_category = :category';\n            $countSql .= ' AND c.taxonomy_category = :category';\n            $params['category'] = $category;\n        }\n\n        if ($status !== '') {\n            $sql .= ' AND c.analysis_status = :status';\n            $countSql .= ' AND c.analysis_status = :status';\n            $params['status'] = $status;\n        }\n\n        if ($search !== '') {\n            $sql .= ' AND (c.content LIKE :search OR c.keywords LIKE :search2)';\n            $countSql .= ' AND (c.content LIKE :search OR c.keywords LIKE :search2)';\n            $params['search'] = '%' . $search . '%';\n            $params['search2'] = '%' . $search . '%';\n        }\n\n        \/\/ Count total\n        $countStmt = $this->db->prepare($countSql);\n        $countStmt->execute($params);\n        $totalCount = (int) $countStmt->fetchColumn();\n        $pagination = $pagination->withTotal($totalCount);\n\n        $sql .= ' ORDER BY c.created_at DESC LIMIT :limit OFFSET :offset';\n\n        $stmt = $this->db->prepare($sql);\n        foreach ($params as $key => $value) {\n            $stmt->bindValue(':' . $key, $value);\n        }\n        $stmt->bindValue(':limit', $pagination->limit, \\PDO::PARAM_INT);\n        $stmt->bindValue(':offset', $pagination->offset, \\PDO::PARAM_INT);\n        $stmt->execute();\n        $chunks = $stmt->fetchAll();\n\n        \/\/ Kategorien für Filter\n        $categories = $this->db->query(\n            'SELECT DISTINCT taxonomy_category FROM dokumentation_chunks\n             WHERE taxonomy_category IS NOT NULL ORDER BY taxonomy_category'\n        )->fetchAll(\\PDO::FETCH_COLUMN);\n\n        $this->view('system-explorer.chunks.index', [\n            'title' => 'Chunks',\n            'chunks' => $chunks,\n            'categories' => $categories,\n            'currentCategory' => $category,\n            'currentStatus' => $status,\n            'currentSearch' => $search,\n            'currentPage' => $pagination->page,\n            'totalCount' => $pagination->totalCount,\n            'totalPages' => $pagination->totalPages(),\n        ]);\n    }\n\n    \/**\n     * GET \/explorer\/chunks\/{id}\n     * Chunk-Details\n     *\/\n    public function chunkShow(int $id): void\n    {\n        $chunk = $this->repository->getChunk($id);\n\n        if ($chunk === null) {\n            $this->notFound('Chunk nicht gefunden');\n        }\n\n        \/\/ Nachbar-Chunks\n        $prevChunk = $this->repository->getChunkByDokumentAndIndex(\n            $chunk['dokumentation_id'],\n            $chunk['chunk_index'] - 1\n        );\n        $nextChunk = $this->repository->getChunkByDokumentAndIndex(\n            $chunk['dokumentation_id'],\n            $chunk['chunk_index'] + 1\n        );\n\n        $this->view('system-explorer.chunks.show', [\n            'title' => 'Chunk #' . $chunk['id'],\n            'chunk' => $chunk,\n            'prevChunk' => $prevChunk,\n            'nextChunk' => $nextChunk,\n        ]);\n    }\n\n    \/**\n     * GET \/explorer\/taxonomie\n     * Taxonomie-Übersicht\n     *\/\n    public function taxonomie(): void\n    {\n        $this->view('system-explorer.taxonomie', [\n            'title' => 'Taxonomie & Entities',\n            'categories' => $this->repository->getCategoriesWithStats(),\n            'topKeywords' => $this->repository->getTopKeywords(30),\n            'topEntities' => $this->repository->getTopEntitiesRaw(30),\n        ]);\n    }\n\n    \/**\n     * GET \/explorer\/suche\n     * Suche-Formular\n     *\/\n    public function suche(): void\n    {\n        $query = $this->getString('q');\n        $category = $this->getString('category');\n        $limit = $this->getLimit(20, 10);\n\n        $results = [];\n        $suggestions = [];\n\n        if ($query !== '') {\n            $filters = [];\n            if ($category !== '') {\n                $filters['taxonomy_category'] = $category;\n            }\n\n            $search = new HybridSearchService();\n            $results = $search->search($query, $filters, $limit);\n            $suggestions = $search->suggestRelatedSearches($results);\n        }\n\n        $this->view('system-explorer.suche', [\n            'title' => 'Dokumentation durchsuchen',\n            'query' => $query,\n            'results' => $results,\n            'suggestions' => $suggestions,\n            'categories' => $this->repository->getDistinctCategories(),\n            'currentCategory' => $category,\n            'limit' => $limit,\n        ]);\n    }\n\n    \/**\n     * Breadcrumb aufbauen\n     *\/\n    private function buildBreadcrumb(array $seite): ... [TRUNCATED-2c9f0e95c24d49d0]",
        "structuredPatch": [
            {
                "oldStart": 99,
                "oldLines": 47,
                "newStart": 99,
                "newLines": 18,
                "lines": [
                    "      *\/",
                    "     public function seiteShow(int $id): void",
                    "     {",
                    "-        $stmt = $this->db->prepare(",
                    "-            'SELECT s.*, p.title as parent_title, p.path as parent_path",
                    "-             FROM dokumentation s",
                    "-             LEFT JOIN dokumentation p ON s.parent_id = p.id",
                    "-             WHERE s.id = :id'",
                    "-        );",
                    "-        $stmt->execute(['id' => $id]);",
                    "-        $seite = $stmt->fetch();",
                    "+        $seite = $this->repository->getSeiteWithParent($id);",
                    " ",
                    "-        if ($seite === false) {",
                    "+        if ($seite === null) {",
                    "             $this->notFound('Seite nicht gefunden');",
                    "         }",
                    " ",
                    "-        \/\/ Chunks dieser Seite",
                    "-        $stmt = $this->db->prepare(",
                    "-            'SELECT c.id, c.chunk_index, c.content, c.token_count, c.taxonomy_category,",
                    "-                    c.taxonomy_path, c.entities, c.keywords, c.analysis_status, c.qdrant_id,",
                    "-                    c.heading_path, c.analyzed_at",
                    "-             FROM dokumentation_chunks c",
                    "-             WHERE c.dokumentation_id = :id",
                    "-             ORDER BY c.chunk_index'",
                    "-        );",
                    "-        $stmt->execute(['id' => $id]);",
                    "-        $chunks = $stmt->fetchAll();",
                    "-",
                    "-        \/\/ Unterseiten (falls depth=1)",
                    "-        $stmt = $this->db->prepare(",
                    "-            'SELECT id, title, path, depth FROM dokumentation WHERE parent_id = :id ORDER BY title'",
                    "-        );",
                    "-        $stmt->execute(['id' => $id]);",
                    "-        $unterseiten = $stmt->fetchAll();",
                    "-",
                    "-        \/\/ Breadcrumb aufbauen",
                    "-        $breadcrumb = $this->buildBreadcrumb($seite);",
                    "-",
                    "         $this->view('system-explorer.seiten.show', [",
                    "             'title' => $seite['title'],",
                    "             'seite' => $seite,",
                    "-            'chunks' => $chunks,",
                    "-            'unterseiten' => $unterseiten,",
                    "-            'breadcrumb' => $breadcrumb,",
                    "+            'chunks' => $this->repository->getChunksDetailedForDokument($id),",
                    "+            'unterseiten' => $this->repository->getUnterseiten($id),",
                    "+            'breadcrumb' => $this->repository->buildBreadcrumb($seite),",
                    "         ]);",
                    "     }",
                    " "
                ]
            }
        ],
        "userModified": false,
        "replaceAll": false
    }
}