Protokoll #3953

{
    "event": "PreToolUse",
    "tool_name": "Read",
    "tool_input": {
        "file_path": "\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/SemanticExplorerRepository.php",
        "limit": 100
    }
}

{
    "tool_response": {
        "type": "text",
        "file": {
            "filePath": "\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/SemanticExplorerRepository.php",
            "content": "<?php\n\nnamespace Infrastructure;\n\nuse Infrastructure\\Config\\DatabaseFactory;\n\n\/**\n * SemanticExplorerRepository - Database Access for Semantic Explorer\n *\n * Handles all database operations for documents, chunks, entities,\n * relations, taxonomy, ontology, and semantics.\n *\/\nclass SemanticExplorerRepository\n{\n    private \\PDO $db;\n\n    public function __construct()\n    {\n        $this->db = 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",
            "numLines": 100,
            "startLine": 1,
            "totalLines": 798
        }
    }
}