{
"tool_response": {
"filePath": "\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/SemanticSearchRepository.php",
"oldString": " \/\/ By intent\n $byIntent = $this->db->query(\n 'SELECT intent, COUNT(*) as count\n FROM chunk_text_semantics\n WHERE intent IS NOT NULL\n GROUP BY intent\n ORDER BY count DESC'\n )->fetchAll();",
"newString": " \/\/ By intent\n $byIntent = $this->db->query(\n 'SELECT intent, COUNT(*) as count\n FROM chunk_semantics\n WHERE intent IS NOT NULL\n GROUP BY intent\n ORDER BY count DESC'\n )->fetchAll();",
"originalFile": "<?php\n\ndeclare(strict_types=1);\n\nnamespace Infrastructure\\Persistence;\n\n\/\/ @responsibility: Semantik-Suche und Graph-Daten für Semantic Explorer\n\nuse Domain\\Repository\\SemanticSearchRepositoryInterface;\nuse PDO;\n\nfinal class SemanticSearchRepository implements SemanticSearchRepositoryInterface\n{\n private PDO $db;\n\n public function __construct(PDO $pdo)\n {\n $this->db = $pdo;\n }\n\n \/**\n * {@inheritDoc}\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 (SELECT COUNT(*) FROM stopwords WHERE is_active = 1) as stopwords,\n (SELECT COUNT(*) FROM entities) as total,\n (SELECT COUNT(DISTINCT type) FROM entities) as types,\n (SELECT COUNT(DISTINCT chunk_id) FROM chunk_entities) as linked_chunks,\n (SELECT COUNT(DISTINCT c.document_id) FROM chunk_entities ce JOIN chunks c ON ce.chunk_id = c.id) as linked_docs'\n )->fetch();\n }\n\n \/**\n * {@inheritDoc}\n *\/\n public function findEntitySemantics(string $search = '', string $type = '', int $limit = 50, int $offset = 0): array\n {\n \/\/ Deduplicated entities with aggregated chunk\/document counts\n $sql = 'SELECT e.id, e.name, e.canonical_name, e.type, e.description, e.status,\n COUNT(DISTINCT ce.chunk_id) as chunk_count,\n COUNT(DISTINCT c.document_id) as document_count,\n MIN(ce.chunk_id) as first_chunk_id,\n MIN(d.filename) as first_filename,\n MIN(d.id) as first_document_id\n FROM entities e\n LEFT JOIN chunk_entities ce ON e.id = ce.entity_id\n LEFT JOIN chunks c ON ce.chunk_id = c.id\n LEFT JOIN documents d ON c.document_id = d.id\n WHERE 1=1';\n\n $params = [];\n\n if ($search !== '') {\n $sql .= ' AND (e.name LIKE :search OR e.description LIKE :search2 OR e.canonical_name LIKE :search3)';\n $params['search'] = '%' . $search . '%';\n $params['search2'] = '%' . $search . '%';\n $params['search3'] = '%' . $search . '%';\n }\n\n if ($type !== '') {\n $sql .= ' AND e.type = :type';\n $params['type'] = $type;\n }\n\n $sql .= ' GROUP BY e.id, e.name, e.canonical_name, e.type, e.description, e.status';\n $sql .= ' ORDER BY e.name LIMIT ' . $limit . ' OFFSET ' . $offset;\n\n $stmt = $this->db->prepare($sql);\n $stmt->execute($params);\n\n return $stmt->fetchAll();\n }\n\n \/**\n * {@inheritDoc}\n *\/\n public function countEntitySemantics(string $search = '', string $type = ''): int\n {\n $sql = 'SELECT COUNT(DISTINCT e.id) FROM entities e WHERE 1=1';\n $params = [];\n\n if ($search !== '') {\n $sql .= ' AND (e.name LIKE :search OR e.description LIKE :search2 OR e.canonical_name LIKE :search3)';\n $params['search'] = '%' . $search . '%';\n $params['search2'] = '%' . $search . '%';\n $params['search3'] = '%' . $search . '%';\n }\n\n if ($type !== '') {\n $sql .= ' AND e.type = :type';\n $params['type'] = $type;\n }\n\n $stmt = $this->db->prepare($sql);\n $stmt->execute($params);\n\n return (int) $stmt->fetchColumn();\n }\n\n \/**\n * {@inheritDoc}\n *\/\n public function getGraphData(): array\n {\n \/\/ Get all entities\n $entities = $this->db->query(\n 'SELECT id, name, type FROM entities ORDER BY name'\n )->fetchAll();\n\n \/\/ Get all relations\n $relations = $this->db->query(\n 'SELECT source_entity_id, target_entity_id, relation_type, strength\n FROM entity_relations'\n )->fetchAll();\n\n \/\/ Build node index for link resolution\n $nodeIndex = [];\n $nodes = [];\n foreach ($entities as $i => $entity) {\n $nodeIndex[$entity['id']] = $i;\n $nodes[] = [\n 'id' => 'entity_' . $entity['id'],\n 'label' => $entity['name'],\n 'type' => strtoupper($entity['type'] ?? 'OTHER'),\n 'entityId' => (int) $entity['id'],\n ];\n }\n\n \/\/ Build links with index references\n $links = [];\n foreach ($relations as $relation) {\n $sourceId = $relation['source_entity_id'];\n $targetId = $relation['target_entity_id'];\n\n \/\/ Skip if entity not found\n if (!isset($nodeIndex[$sourceId]) || !isset($nodeIndex[$targetId])) {\n continue;\n }\n\n $links[] = [\n 'source' => $nodeIndex[$sourceId],\n 'target' => $nodeIndex[$targetId],\n 'type' => $relation['relation_type'],\n 'strength' => (float) ($relation['strength'] ?? 1.0),\n ];\n }\n\n \/\/ Get unique types for stats\n $entityTypes = array_unique(array_column($nodes, 'type'));\n $relationTypes = array_unique(array_column($links, 'type'));\n\n return [\n 'nodes' => $nodes,\n 'links' => $links,\n 'stats' => [\n 'nodes' => count($nodes),\n 'links' => count($links),\n 'entityTypes' => count($entityTypes),\n 'relationTypes' => count($relationTypes),\n ],\n ];\n }\n\n \/**\n * {@inheritDoc}\n *\/\n public function getTextSemanticStats(): array\n {\n \/\/ Coverage\n $coverage = $this->db->query(\n 'SELECT\n (SELECT COUNT(*) FROM chunk_semantics WHERE statement_form IS NOT NULL) as analyzed,\n (SELECT COUNT(*) FROM chunks) as total'\n )->fetch();\n\n $analyzed = (int) ($coverage['analyzed'] ?? 0);\n $total = (int) ($coverage['total'] ?? 1);\n\n \/\/ By statement_form\n $byStatementForm = $this->db->query(\n 'SELECT statement_form, COUNT(*) as count\n FROM chunk_semantics\n WHERE statement_form IS NOT NULL\n GROUP BY statement_form\n ORDER BY count DESC'\n )->fetchAll();\n\n \/\/ By intent\n $byIntent = $this->db->query(\n 'SELECT intent, COUNT(*) as count\n FROM chunk_text_semantics\n WHERE intent IS NOT NULL\n GROUP BY intent\n ORDER BY count DESC'\n )->fetchAll();\n\n return [\n 'analyzed' => $analyzed,\n 'total' => $total,\n 'coverage' => $total > 0 ? round($analyzed \/ $total * 100, 1) : 0.0,\n 'by_statement_form' => $byStatementForm,\n 'by_intent' => $byIntent,\n ];\n }\n\n \/**\n * {@inheritDoc}\n *\/\n public function getKnowledgeSemanticStats(): array\n {\n \/\/ Coverage\n $coverage = $this->db->query(\n 'SELECT\n (SELECT COUNT(DISTINCT entity_id) FROM entity_knowledge_semantics) as analyzed,\n (SELECT COUNT(*) FROM entities) as total'\n )->fetch();\n\n $analyzed = (int) ($coverage['analyzed'] ?? 0);\n $total = (int) ($coverage['total'] ?? 1);\n\n \/\/ By semantic_role\n $bySemanticRole = $this->db->query(\n 'SELECT semantic_role, COUNT(*) as count\n FROM entity_knowledge_semantics\n WHERE semantic_role IS NOT NULL\n GROUP BY semantic_role\n ORDER BY count DESC'\n )->fetchAll();\n\n \/\/ By functional_category\n $byFunctionalCategory = $this->db->query(\n 'SELECT functional_category, COUNT(*) as count\n FROM entity_knowledge_semantics\n WHERE functional_category IS NOT NULL\n GROUP BY functional_category\n ORDER BY count DESC'\n )->fetchAll();\n\n return [\n 'analyzed' => $analyzed,\n 'total' => $total,\n 'coverage' => $total > 0 ? round($analyzed \/ $total * 100, 1) : 0.0,\n 'by_semantic_role' => $bySemanticRole,\n 'by_functional_category' => $byFunctionalCategory,\n ];\n }\n}\n",
"structuredPatch": [
{
"oldStart": 196,
"oldLines": 7,
"newStart": 196,
"newLines": 7,
"lines": [
" \/\/ By intent",
" $byIntent = $this->db->query(",
" 'SELECT intent, COUNT(*) as count",
"- FROM chunk_text_semantics",
"+ FROM chunk_semantics",
" WHERE intent IS NOT NULL",
" GROUP BY intent",
" ORDER BY count DESC'"
]
}
],
"userModified": false,
"replaceAll": false
}
}