Protokoll #3163

{
    "event": "PreToolUse",
    "tool_name": "Edit",
    "tool_input": {
        "file_path": "\/var\/www\/dev.campus.systemische-tools.de\/src\/Controller\/SemanticExplorerController.php",
        "old_string": "    \/\/ =========================================================================\n    \/\/ RELATIONS - CRUD\n    \/\/ =========================================================================\n\n    \/**\n     * GET \/semantic-explorer\/relationen\/new\n     *\/\n    public function relationNew(): void\n    {\n        $this->view('semantic-explorer.relationen.new', [\n            'title' => 'Neue Relation',\n            'entities' => $this->repository->getAllEntitiesSimple(),\n            'relationTypes' => $this->repository->getRelationTypesList(),\n        ]);\n    }\n\n    \/**\n     * POST \/semantic-explorer\/relationen\n     *\/\n    public function relationStore(): void\n    {\n        $input = json_decode(file_get_contents('php:\/\/input'), true);\n\n        $sourceId = (int) ($input['source_entity_id'] ?? 0);\n        $targetId = (int) ($input['target_entity_id'] ?? 0);\n        $type = trim($input['relation_type'] ?? '');\n        $strength = (float) ($input['strength'] ?? 1.0);\n\n        if ($sourceId === 0 || $targetId === 0 || $type === '') {\n            $this->json(['success' => false, 'error' => 'Alle Felder sind erforderlich'], 400);\n\n            return;\n        }\n\n        try {\n            $id = $this->repository->createRelation($sourceId, $targetId, $type, $strength);\n            $this->json(['success' => true, 'id' => $id]);\n        } catch (\\Exception $e) {\n            $this->json(['success' => false, 'error' => $e->getMessage()], 500);\n        }\n    }\n\n    \/**\n     * GET \/semantic-explorer\/relationen\/{id}\/edit\n     *\/\n    public function relationEdit(int $id): void\n    {\n        $relation = $this->repository->getRelation($id);\n\n        if ($relation === null) {\n            $this->notFound('Relation nicht gefunden');\n        }\n\n        $this->view('semantic-explorer.relationen.edit', [\n            'title' => 'Relation bearbeiten',\n            'relation' => $relation,\n            'relationTypes' => $this->repository->getRelationTypesList(),\n        ]);\n    }\n\n    \/**\n     * POST \/semantic-explorer\/relationen\/{id}\n     *\/\n    public function relationUpdate(int $id): void\n    {\n        $input = json_decode(file_get_contents('php:\/\/input'), true);\n\n        $type = trim($input['relation_type'] ?? '');\n        $strength = (float) ($input['strength'] ?? 1.0);\n\n        if ($type === '') {\n            $this->json(['success' => false, 'error' => 'Beziehungstyp ist erforderlich'], 400);\n\n            return;\n        }\n\n        try {\n            $this->repository->updateRelation($id, $type, $strength);\n            $this->json(['success' => true]);\n        } catch (\\Exception $e) {\n            $this->json(['success' => false, 'error' => $e->getMessage()], 500);\n        }\n    }\n\n    \/**\n     * POST \/semantic-explorer\/relationen\/{id}\/delete\n     *\/\n    public function relationDelete(int $id): void\n    {\n        try {\n            $this->repository->deleteRelation($id);\n            $this->json(['success' => true]);\n        } catch (\\Exception $e) {\n            $this->json(['success' => false, 'error' => $e->getMessage()], 500);\n        }\n    }\n\n    \/\/ =========================================================================\n    \/\/ TAXONOMY - CRUD\n    \/\/ =========================================================================",
        "new_string": "    \/\/ =========================================================================\n    \/\/ TAXONOMY - CRUD\n    \/\/ ========================================================================="
    }
}

{
    "tool_response": {
        "filePath": "\/var\/www\/dev.campus.systemische-tools.de\/src\/Controller\/SemanticExplorerController.php",
        "oldString": "    \/\/ =========================================================================\n    \/\/ RELATIONS - CRUD\n    \/\/ =========================================================================\n\n    \/**\n     * GET \/semantic-explorer\/relationen\/new\n     *\/\n    public function relationNew(): void\n    {\n        $this->view('semantic-explorer.relationen.new', [\n            'title' => 'Neue Relation',\n            'entities' => $this->repository->getAllEntitiesSimple(),\n            'relationTypes' => $this->repository->getRelationTypesList(),\n        ]);\n    }\n\n    \/**\n     * POST \/semantic-explorer\/relationen\n     *\/\n    public function relationStore(): void\n    {\n        $input = json_decode(file_get_contents('php:\/\/input'), true);\n\n        $sourceId = (int) ($input['source_entity_id'] ?? 0);\n        $targetId = (int) ($input['target_entity_id'] ?? 0);\n        $type = trim($input['relation_type'] ?? '');\n        $strength = (float) ($input['strength'] ?? 1.0);\n\n        if ($sourceId === 0 || $targetId === 0 || $type === '') {\n            $this->json(['success' => false, 'error' => 'Alle Felder sind erforderlich'], 400);\n\n            return;\n        }\n\n        try {\n            $id = $this->repository->createRelation($sourceId, $targetId, $type, $strength);\n            $this->json(['success' => true, 'id' => $id]);\n        } catch (\\Exception $e) {\n            $this->json(['success' => false, 'error' => $e->getMessage()], 500);\n        }\n    }\n\n    \/**\n     * GET \/semantic-explorer\/relationen\/{id}\/edit\n     *\/\n    public function relationEdit(int $id): void\n    {\n        $relation = $this->repository->getRelation($id);\n\n        if ($relation === null) {\n            $this->notFound('Relation nicht gefunden');\n        }\n\n        $this->view('semantic-explorer.relationen.edit', [\n            'title' => 'Relation bearbeiten',\n            'relation' => $relation,\n            'relationTypes' => $this->repository->getRelationTypesList(),\n        ]);\n    }\n\n    \/**\n     * POST \/semantic-explorer\/relationen\/{id}\n     *\/\n    public function relationUpdate(int $id): void\n    {\n        $input = json_decode(file_get_contents('php:\/\/input'), true);\n\n        $type = trim($input['relation_type'] ?? '');\n        $strength = (float) ($input['strength'] ?? 1.0);\n\n        if ($type === '') {\n            $this->json(['success' => false, 'error' => 'Beziehungstyp ist erforderlich'], 400);\n\n            return;\n        }\n\n        try {\n            $this->repository->updateRelation($id, $type, $strength);\n            $this->json(['success' => true]);\n        } catch (\\Exception $e) {\n            $this->json(['success' => false, 'error' => $e->getMessage()], 500);\n        }\n    }\n\n    \/**\n     * POST \/semantic-explorer\/relationen\/{id}\/delete\n     *\/\n    public function relationDelete(int $id): void\n    {\n        try {\n            $this->repository->deleteRelation($id);\n            $this->json(['success' => true]);\n        } catch (\\Exception $e) {\n            $this->json(['success' => false, 'error' => $e->getMessage()], 500);\n        }\n    }\n\n    \/\/ =========================================================================\n    \/\/ TAXONOMY - CRUD\n    \/\/ =========================================================================",
        "newString": "    \/\/ =========================================================================\n    \/\/ TAXONOMY - CRUD\n    \/\/ =========================================================================",
        "originalFile": "<?php\n\nnamespace Controller;\n\nuse Framework\\Controller;\nuse Infrastructure\\SemanticExplorerRepository;\n\n\/**\n * SemanticExplorerController - Nutzdaten Explorer\n *\n * Zeigt Dokumente und Chunks aus Nextcloud (documents, chunks Tabellen).\n * Für Endnutzer - Coaching-Materialien, PDFs, später Mails.\n *\/\nclass SemanticExplorerController extends Controller\n{\n    private SemanticExplorerRepository $repository;\n\n    public function __construct()\n    {\n        $this->repository = new SemanticExplorerRepository();\n    }\n\n    \/**\n     * GET \/semantic-explorer\n     * Dashboard mit Statistiken\n     *\/\n    public function index(): void\n    {\n        $docStats = $this->repository->getDocumentStats();\n        $chunkStats = $this->repository->getChunkStats();\n        $documents = $this->repository->getDocuments();\n        $recentChunks = $this->repository->getRecentChunks(5);\n\n        $this->view('semantic-explorer.index', [\n            'title' => 'Semantic Explorer',\n            'docStats' => $docStats,\n            'chunkStats' => $chunkStats,\n            'documents' => $documents,\n            'recentChunks' => $recentChunks,\n        ]);\n    }\n\n    \/**\n     * GET \/semantic-explorer\/dokumente\n     * Liste aller Dokumente\n     *\/\n    public function dokumente(): void\n    {\n        $status = $_GET['status'] ?? '';\n        $search = $_GET['search'] ?? '';\n\n        $documents = $this->repository->getDocumentsFiltered($status, $search);\n\n        $this->view('semantic-explorer.dokumente.index', [\n            'title' => 'Dokumente',\n            'documents' => $documents,\n            'currentStatus' => $status,\n            'currentSearch' => $search,\n        ]);\n    }\n\n    \/**\n     * GET \/semantic-explorer\/dokumente\/{id}\n     * Dokument-Details mit Chunks\n     *\/\n    public function dokumentShow(int $id): void\n    {\n        $document = $this->repository->getDocument($id);\n\n        if ($document === null) {\n            $this->notFound('Dokument nicht gefunden');\n        }\n\n        $chunks = $this->repository->getChunksForDocument($id);\n\n        \/\/ Heading-Paths dekodieren\n        foreach ($chunks as &$chunk) {\n            $chunk['heading_path_decoded'] = json_decode($chunk['heading_path'] ?? '[]', true) ?: [];\n            $chunk['metadata_decoded'] = json_decode($chunk['metadata'] ?? '{}', true) ?: [];\n        }\n\n        $this->view('semantic-explorer.dokumente.show', [\n            'title' => $document['filename'],\n            'document' => $document,\n            'chunks' => $chunks,\n        ]);\n    }\n\n    \/**\n     * GET \/semantic-explorer\/chunks\n     * Liste aller Chunks\n     *\/\n    public function chunks(): void\n    {\n        $search = $_GET['search'] ?? '';\n        $embedded = $_GET['embedded'] ?? '';\n        $page = max(1, (int) ($_GET['page'] ?? 1));\n        $limit = 50;\n        $offset = ($page - 1) * $limit;\n\n        $totalCount = $this->repository->getChunksCount($search, $embedded);\n        $chunks = $this->repository->getChunksFiltered($search, $embedded, $limit, $offset);\n\n        $this->view('semantic-explorer.chunks.index', [\n            'title' => 'Chunks',\n            'chunks' => $chunks,\n            'currentSearch' => $search,\n            'currentEmbedded' => $embedded,\n            'currentPage' => $page,\n            'totalCount' => $totalCount,\n            'totalPages' => ceil($totalCount \/ $limit),\n        ]);\n    }\n\n    \/**\n     * GET \/semantic-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        \/\/ JSON-Felder dekodieren\n        $chunk['heading_path_decoded'] = json_decode($chunk['heading_path'] ?? '[]', true) ?: [];\n        $chunk['metadata_decoded'] = json_decode($chunk['metadata'] ?? '{}', true) ?: [];\n\n        \/\/ Nachbar-Chunks\n        $prevChunk = $this->repository->getChunkByDocumentAndIndex(\n            $chunk['document_id'],\n            $chunk['chunk_index'] - 1\n        );\n        $nextChunk = $this->repository->getChunkByDocumentAndIndex(\n            $chunk['document_id'],\n            $chunk['chunk_index'] + 1\n        );\n\n        $this->view('semantic-explorer.chunks.show', [\n            'title' => 'Chunk #' . $chunk['id'],\n            'chunk' => $chunk,\n            'prevChunk' => $prevChunk,\n            'nextChunk' => $nextChunk,\n        ]);\n    }\n\n    \/**\n     * GET \/semantic-explorer\/suche\n     * Semantische Suche in Nutzdaten\n     *\/\n    public function suche(): void\n    {\n        $query = $_GET['q'] ?? '';\n        $limit = min(20, max(1, (int) ($_GET['limit'] ?? 10)));\n\n        $results = [];\n\n        if ($query !== '') {\n            \/\/ Vektor-Suche via Qdrant\n            $results = $this->vectorSearch($query, $limit);\n        }\n\n        $this->view('semantic-explorer.suche', [\n            'title' => 'Semantische Suche',\n            'query' => $query,\n            'results' => $results,\n            'limit' => $limit,\n        ]);\n    }\n\n    \/**\n     * Vektor-Suche in documents Collection\n     *\/\n    private function vectorSearch(string $query, int $limit): array\n    {\n        \/\/ Embedding generieren\n        $embedding = $this->getEmbedding($query);\n        if (empty($embedding)) {\n            return [];\n        }\n\n        \/\/ Qdrant suchen\n        $response = $this->qdrantSearch($embedding, $limit);\n        if (empty($response)) {\n            return [];\n        }\n\n        \/\/ Chunk-Details aus DB laden\n        $results = [];\n        foreach ($response as $point) {\n            $chunkId = $point['payload']['chunk_id'] ?? null;\n            if ($chunkId === null) {\n                continue;\n            }\n\n            $chunk = $this->repository->getChunkById($chunkId);\n\n            if ($chunk !== null) {\n                $chunk['score'] = $point['score'];\n                $chunk['heading_path_decoded'] = json_decode($chunk['heading_path'] ?? '[]', true) ?: [];\n                $results[] = $chunk;\n            }\n        }\n\n        return $results;\n    }\n\n    \/**\n     * Embedding via Ollama\n     *\/\n    private function getEmbedding(string $text): array\n    {\n        $ch = curl_init('http:\/\/localhost:11434\/api\/embeddings');\n        curl_setopt_array($ch, [\n            CURLOPT_RETURNTRANSFER => true,\n            CURLOPT_POST => true,\n            CURLOPT_HTTPHEADER => ['Content-Type: application\/json'],\n            CURLOPT_POSTFIELDS => json_encode([\n                'model' => 'mxbai-embed-large',\n                'prompt' => $text,\n            ]),\n        ]);\n\n        $response = curl_exec($ch);\n        curl_close($ch);\n\n        $data = json_decode($response, true);\n\n        return $data['embedding'] ?? [];\n    }\n\n    \/**\n     * Qdrant-Suche\n     *\/\n    private function qdrantSearch(array $embedding, int $limit): array\n    {\n        $ch = curl_init('http:\/\/localhost:6333\/collections\/documents\/points\/search');\n        curl_setopt_array($ch, [\n            CURLOPT_RETURNTRANSFER => true,\n            CURLOPT_POST => true,\n            CURLOPT_HTTPHEADER => ['Content-Type: application\/json'],\n            CURLOPT_POSTFIELDS => json_encode([\n                'vector' => $embedding,\n                'limit' => $limit,\n                'with_payload' => true,\n            ]),\n        ]);\n\n        $response = curl_exec($ch);\n        curl_close($ch);\n\n        $data = json_decode($response, true);\n\n        return $data['result'] ?? [];\n    }\n\n    \/**\n     * GET \/semantic-explorer\/taxonomie\n     * Hierarchische Kategorisierung\n     *\/\n    public function taxonomie(): void\n    {\n        $terms = $this->repository->getTaxonomyTerms();\n        $hierarchy = $this->buildTaxonomyTree($terms);\n        $stats = $this->repository->getTaxonomyStats();\n\n        $this->view('semantic-explorer.taxonomie', [\n            'title' => 'Taxonomie',\n            'terms' => $terms,\n            'hierarchy' => $hierarchy,\n            'stats' => $stats,\n        ]);\n    }\n\n    \/**\n     * Baut Baum aus flacher Liste\n     *\/\n    private function buildTaxonomyTree(array $items, ?int $parentId = null): array\n    {\n        $tree = [];\n        foreach ($items as $item) {\n            if ($item['parent_id'] == $parentId) {\n                $item['children'] = $this->buildTaxonomyTree($items, $item['id']);\n                $tree[] = $item;\n            }\n        }\n\n        return $tree;\n    }\n\n    \/**\n     * GET \/semantic-explorer\/ontologie\n     * Konzept-Klassen\n     *\/\n    public function ontologie(): void\n    {\n        $classes = $this->repository->getOntologyClasses();\n\n        \/\/ Properties dekodieren\n        foreach ($classes as &$class) {\n            $class['properties_decoded'] = json_decode($class['properties'] ?? '{}', true) ?: [];\n        }\n\n        $stats = $this->repository->getOntologyStats();\n\n        $this->view('semantic-explorer.ontologie', [\n            'title' => 'Ontologie',\n            'classes' => $classes,\n            'stats' => $stats,\n        ]);\n    }\n\n    \/**\n     * GET \/semantic-explorer\/semantik\n     * Semantische Analyse pro Chunk\n     *\/\n    public function semantik(): void\n    {\n        $sentiment = $_GET['sentiment'] ?? '';\n        $page = max(1, (int) ($_GET['page'] ?? 1));\n        $limit = 50;\n        $offset = ($page - 1) * $limit;\n\n        $totalCount = $this->repository->getSemanticsCount($sentiment);\n        $semantics = $this->repository->getSemanticsFiltered($sentiment, $limit, $offset);\n\n        \/\/ JSON dekodieren\n        foreach ($semantics as &$s) {\n            $s['keywords_decoded'] = json_decode($s['keywords'] ?? '[]', true) ?: [];\n            $s['topics_decoded'] = json_decode($s['topics'] ?? '[]', true) ?: [];\n        }\n\n        $stats = $this->repository->getSemanticStats();\n\n        $this->view('semantic-explorer.semantik', [\n            'title' => 'Semantik',\n            'semantics' => $semantics,\n            'stats' => $stats,\n            'currentSentiment' => $sentiment,\n            'currentPage' => $page,\n            't... [TRUNCATED-bb1ccb06ea2ec2ef]",
        "structuredPatch": [
            {
                "oldStart": 346,
                "oldLines": 103,
                "newStart": 346,
                "newLines": 6,
                "lines": [
                    "     }",
                    " ",
                    "     \/\/ =========================================================================",
                    "-    \/\/ RELATIONS - CRUD",
                    "-    \/\/ =========================================================================",
                    "-",
                    "-    \/**",
                    "-     * GET \/semantic-explorer\/relationen\/new",
                    "-     *\/",
                    "-    public function relationNew(): void",
                    "-    {",
                    "-        $this->view('semantic-explorer.relationen.new', [",
                    "-            'title' => 'Neue Relation',",
                    "-            'entities' => $this->repository->getAllEntitiesSimple(),",
                    "-            'relationTypes' => $this->repository->getRelationTypesList(),",
                    "-        ]);",
                    "-    }",
                    "-",
                    "-    \/**",
                    "-     * POST \/semantic-explorer\/relationen",
                    "-     *\/",
                    "-    public function relationStore(): void",
                    "-    {",
                    "-        $input = json_decode(file_get_contents('php:\/\/input'), true);",
                    "-",
                    "-        $sourceId = (int) ($input['source_entity_id'] ?? 0);",
                    "-        $targetId = (int) ($input['target_entity_id'] ?? 0);",
                    "-        $type = trim($input['relation_type'] ?? '');",
                    "-        $strength = (float) ($input['strength'] ?? 1.0);",
                    "-",
                    "-        if ($sourceId === 0 || $targetId === 0 || $type === '') {",
                    "-            $this->json(['success' => false, 'error' => 'Alle Felder sind erforderlich'], 400);",
                    "-",
                    "-            return;",
                    "-        }",
                    "-",
                    "-        try {",
                    "-            $id = $this->repository->createRelation($sourceId, $targetId, $type, $strength);",
                    "-            $this->json(['success' => true, 'id' => $id]);",
                    "-        } catch (\\Exception $e) {",
                    "-            $this->json(['success' => false, 'error' => $e->getMessage()], 500);",
                    "-        }",
                    "-    }",
                    "-",
                    "-    \/**",
                    "-     * GET \/semantic-explorer\/relationen\/{id}\/edit",
                    "-     *\/",
                    "-    public function relationEdit(int $id): void",
                    "-    {",
                    "-        $relation = $this->repository->getRelation($id);",
                    "-",
                    "-        if ($relation === null) {",
                    "-            $this->notFound('Relation nicht gefunden');",
                    "-        }",
                    "-",
                    "-        $this->view('semantic-explorer.relationen.edit', [",
                    "-            'title' => 'Relation bearbeiten',",
                    "-            'relation' => $relation,",
                    "-            'relationTypes' => $this->repository->getRelationTypesList(),",
                    "-        ]);",
                    "-    }",
                    "-",
                    "-    \/**",
                    "-     * POST \/semantic-explorer\/relationen\/{id}",
                    "-     *\/",
                    "-    public function relationUpdate(int $id): void",
                    "-    {",
                    "-        $input = json_decode(file_get_contents('php:\/\/input'), true);",
                    "-",
                    "-        $type = trim($input['relation_type'] ?? '');",
                    "-        $strength = (float) ($input['strength'] ?? 1.0);",
                    "-",
                    "-        if ($type === '') {",
                    "-            $this->json(['success' => false, 'error' => 'Beziehungstyp ist erforderlich'], 400);",
                    "-",
                    "-            return;",
                    "-        }",
                    "-",
                    "-        try {",
                    "-            $this->repository->updateRelation($id, $type, $strength);",
                    "-            $this->json(['success' => true]);",
                    "-        } catch (\\Exception $e) {",
                    "-            $this->json(['success' => false, 'error' => $e->getMessage()], 500);",
                    "-        }",
                    "-    }",
                    "-",
                    "-    \/**",
                    "-     * POST \/semantic-explorer\/relationen\/{id}\/delete",
                    "-     *\/",
                    "-    public function relationDelete(int $id): void",
                    "-    {",
                    "-        try {",
                    "-            $this->repository->deleteRelation($id);",
                    "-            $this->json(['success' => true]);",
                    "-        } catch (\\Exception $e) {",
                    "-            $this->json(['success' => false, 'error' => $e->getMessage()], 500);",
                    "-        }",
                    "-    }",
                    "-",
                    "-    \/\/ =========================================================================",
                    "     \/\/ TAXONOMY - CRUD",
                    "     \/\/ =========================================================================",
                    " "
                ]
            }
        ],
        "userModified": false,
        "replaceAll": false
    }
}