{
"tool_response": {
"type": "text",
"file": {
"filePath": "\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/SemanticExplorerRepository.php",
"content": "<?php\n\ndeclare(strict_types=1);\n\nnamespace Infrastructure;\n\n\/\/ @responsibility: Persistenz für Semantic-Explorer (Entitäten, Relationen, Taxonomie, Ontologie)\n\nuse Infrastructure\\Config\\DatabaseFactory;\n\nclass SemanticExplorerRepository\n{\n private \\PDO $db;\n\n public function __construct(?\\PDO $pdo = null)\n {\n $this->db = $pdo ?? DatabaseFactory::content();\n }\n\n \/\/ =========================================================================\n \/\/ DOCUMENTS\n \/\/ =========================================================================\n\n public function getDocumentStats(): array\n {\n return $this->db->query(\n 'SELECT\n COUNT(*) as total,\n SUM(CASE WHEN status = \"done\" THEN 1 ELSE 0 END) as processed,\n SUM(CASE WHEN status = \"error\" THEN 1 ELSE 0 END) as errors\n FROM documents'\n )->fetch();\n }\n\n public function getDocuments(): array\n {\n return $this->db->query(\n 'SELECT d.id, d.filename, d.folder_path, d.mime_type, d.file_size,\n d.status, d.imported_at, d.processed_at,\n (SELECT COUNT(*) FROM chunks WHERE document_id = d.id) as chunk_count\n FROM documents d\n ORDER BY d.imported_at DESC'\n )->fetchAll();\n }\n\n public function getDocumentsFiltered(string $status = '', string $search = ''): array\n {\n $sql = 'SELECT d.id, d.filename, d.folder_path, d.source_path, d.mime_type,\n d.file_size, d.status, d.imported_at, d.processed_at, d.error_message,\n (SELECT COUNT(*) FROM chunks WHERE document_id = d.id) as chunk_count,\n (SELECT COALESCE(SUM(token_count), 0) FROM chunks WHERE document_id = d.id) as token_count\n FROM documents d WHERE 1=1';\n\n $params = [];\n\n if ($status !== '') {\n $sql .= ' AND d.status = :status';\n $params['status'] = $status;\n }\n\n if ($search !== '') {\n $sql .= ' AND (d.filename LIKE :search OR d.source_path LIKE :search2)';\n $params['search'] = '%' . $search . '%';\n $params['search2'] = '%' . $search . '%';\n }\n\n $sql .= ' ORDER BY d.imported_at DESC';\n\n $stmt = $this->db->prepare($sql);\n $stmt->execute($params);\n\n return $stmt->fetchAll();\n }\n\n public function getDocument(int $id): ?array\n {\n $stmt = $this->db->prepare('SELECT * FROM documents WHERE id = :id');\n $stmt->execute(['id' => $id]);\n $result = $stmt->fetch();\n\n return $result === false ? null : $result;\n }\n\n \/\/ =========================================================================\n \/\/ CHUNKS\n \/\/ =========================================================================\n\n public function getChunkStats(): array\n {\n return $this->db->query(\n 'SELECT\n COUNT(*) as total,\n COALESCE(SUM(token_count), 0) as tokens,\n SUM(CASE WHEN qdrant_id IS NOT NULL THEN 1 ELSE 0 END) as embedded\n FROM chunks'\n )->fetch();\n }\n\n public function getSemanticStats(): array\n {\n return $this->db->query(\n 'SELECT\n (SELECT COUNT(*) FROM entities) as entities,\n (SELECT COUNT(*) FROM entity_relations) as relations,\n (SELECT COUNT(*) FROM taxonomy_terms) as taxonomy,\n (SELECT COUNT(*) FROM ontology_classes) as ontology,\n (SELECT COUNT(*) FROM chunk_semantics) as semantics'\n )->fetch();\n }\n\n public function getRecentChunks(int $limit = 5): array\n {\n $stmt = $this->db->prepare(\n 'SELECT c.id, c.content, c.token_count, c.created_at, c.qdrant_id, d.filename\n FROM chunks c\n JOIN documents d ON c.document_id = d.id\n ORDER BY c.created_at DESC\n LIMIT :limit'\n );\n $stmt->bindValue(':limit', $limit, \\PDO::PARAM_INT);\n $stmt->execute();\n\n return $stmt->fetchAll();\n }\n\n public function getChunksForDocument(int $documentId): array\n {\n $stmt = $this->db->prepare(\n 'SELECT c.id, c.chunk_index, c.content, c.token_count, c.heading_path,\n c.metadata, c.qdrant_id, c.created_at\n FROM chunks c\n WHERE c.document_id = :id\n ORDER BY c.chunk_index'\n );\n $stmt->execute(['id' => $documentId]);\n\n return $stmt->fetchAll();\n }\n\n public function getChunksFiltered(string $search = '', string $embedded = '', int $limit = 50, int $offset = 0): array\n {\n $sql = 'SELECT c.id, c.chunk_index, c.content, c.token_count, c.qdrant_id, c.created_at,\n d.filename, d.id as document_id\n FROM chunks c\n JOIN documents d ON c.document_id = d.id\n WHERE 1=1';\n\n $params = [];\n\n if ($search !== '') {",
"numLines": 150,
"startLine": 1,
"totalLines": 918
}
}
}