{
"event": "PreToolUse",
"tool_name": "Read",
"tool_input": {
"file_path": "\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/SemanticExplorerRepository.php",
"offset": 150,
"limit": 100
}
}
{
"tool_response": {
"type": "text",
"file": {
"filePath": "\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/SemanticExplorerRepository.php",
"content": " if ($search !== '') {\n $sql .= ' AND c.content LIKE :search';\n $params['search'] = '%' . $search . '%';\n }\n\n if ($embedded === 'yes') {\n $sql .= ' AND c.qdrant_id IS NOT NULL';\n } elseif ($embedded === 'no') {\n $sql .= ' AND c.qdrant_id IS NULL';\n }\n\n $sql .= ' ORDER BY c.created_at DESC LIMIT ' . $limit . ' OFFSET ' . $offset;\n\n $stmt = $this->db->prepare($sql);\n $stmt->execute($params);\n\n return $stmt->fetchAll();\n }\n\n public function getChunksCount(string $search = '', string $embedded = ''): int\n {\n $sql = 'SELECT COUNT(*) FROM chunks c\n JOIN documents d ON c.document_id = d.id\n WHERE 1=1';\n\n $params = [];\n\n if ($search !== '') {\n $sql .= ' AND c.content LIKE :search';\n $params['search'] = '%' . $search . '%';\n }\n\n if ($embedded === 'yes') {\n $sql .= ' AND c.qdrant_id IS NOT NULL';\n } elseif ($embedded === 'no') {\n $sql .= ' AND c.qdrant_id IS NULL';\n }\n\n $stmt = $this->db->prepare($sql);\n $stmt->execute($params);\n\n return (int) $stmt->fetchColumn();\n }\n\n public function getChunk(int $id): ?array\n {\n $stmt = $this->db->prepare(\n 'SELECT c.*, d.filename, d.source_path, d.id as document_id\n FROM chunks c\n JOIN documents d ON c.document_id = d.id\n WHERE c.id = :id'\n );\n $stmt->execute(['id' => $id]);\n $result = $stmt->fetch();\n\n return $result === false ? null : $result;\n }\n\n public function getChunkByDocumentAndIndex(int $documentId, int $chunkIndex): ?array\n {\n $stmt = $this->db->prepare(\n 'SELECT id, chunk_index FROM chunks\n WHERE document_id = :doc_id AND chunk_index = :idx'\n );\n $stmt->execute(['doc_id' => $documentId, 'idx' => $chunkIndex]);\n $result = $stmt->fetch();\n\n return $result === false ? null : $result;\n }\n\n public function getChunkById(int $chunkId): ?array\n {\n $stmt = $this->db->prepare(\n 'SELECT c.*, d.filename, d.source_path\n FROM chunks c\n JOIN documents d ON c.document_id = d.id\n WHERE c.id = :id'\n );\n $stmt->execute(['id' => $chunkId]);\n $result = $stmt->fetch();\n\n return $result === false ? null : $result;\n }\n\n \/\/ =========================================================================\n \/\/ ENTITIES\n \/\/ =========================================================================\n\n public function getEntitiesFiltered(string $type = '', string $search = '', int $limit = 100): array\n {\n $sql = 'SELECT e.*,\n COUNT(DISTINCT ce.chunk_id) as chunk_count,\n COUNT(DISTINCT er.id) as relation_count\n FROM entities e\n LEFT JOIN chunk_entities ce ON e.id = ce.entity_id\n LEFT JOIN entity_relations er ON e.id = er.source_entity_id OR e.id = er.target_entity_id\n WHERE 1=1';\n\n $params = [];\n",
"numLines": 100,
"startLine": 150,
"totalLines": 918
}
}
}