Protokoll #14746

{
    "event": "PreToolUse",
    "tool_name": "Write",
    "tool_input": {
        "file_path": "\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/ChunkExplorerRepository.php",
        "content": "<?php\n\ndeclare(strict_types=1);\n\nnamespace Infrastructure\\Persistence;\n\nuse Domain\\Repository\\ChunkExplorerRepositoryInterface;\nuse Infrastructure\\Traits\\JsonDecodeTrait;\nuse PDO;\n\n\/\/ @responsibility: Persistenz für Chunk-Explorer (Chunks mit Taxonomie\/Entities)\n\nclass ChunkExplorerRepository implements ChunkExplorerRepositoryInterface\n{\n    use JsonDecodeTrait;\n\n    private PDO $pdo;\n\n    public function __construct(PDO $pdo)\n    {\n        $this->pdo = $pdo;\n    }\n\n    \/**\n     * @return array{total: int, tokens: int, analyzed: int, synced: int}\n     *\/\n    public function getChunkStats(): array\n    {\n        $result = $this->pdo->query(\n            'SELECT\n                COUNT(*) as total,\n                COALESCE(SUM(token_count), 0) as tokens,\n                SUM(CASE WHEN analysis_status = \"completed\" THEN 1 ELSE 0 END) as analyzed,\n                SUM(CASE WHEN qdrant_id IS NOT NULL THEN 1 ELSE 0 END) as synced\n             FROM dokumentation_chunks'\n        )->fetch(PDO::FETCH_ASSOC);\n\n        return $result ?: ['total' => 0, 'tokens' => 0, 'analyzed' => 0, 'synced' => 0];\n    }\n\n    public function countChunksFiltered(string $category = '', string $status = '', string $search = ''): int\n    {\n        $sql = 'SELECT COUNT(*) FROM dokumentation_chunks c\n                JOIN dokumentation d ON c.dokumentation_id = d.id\n                WHERE 1=1';\n        $params = [];\n\n        if ($category !== '') {\n            $sql .= ' AND c.taxonomy_category = :category';\n            $params['category'] = $category;\n        }\n\n        if ($status !== '') {\n            $sql .= ' AND c.analysis_status = :status';\n            $params['status'] = $status;\n        }\n\n        if ($search !== '') {\n            $sql .= ' AND (c.content LIKE :search OR c.keywords LIKE :search2)';\n            $params['search'] = '%' . $search . '%';\n            $params['search2'] = '%' . $search . '%';\n        }\n\n        $stmt = $this->pdo->prepare($sql);\n        $stmt->execute($params);\n\n        return (int) $stmt->fetchColumn();\n    }\n\n    \/**\n     * @return array<array<string, mixed>>\n     *\/\n    public function getChunksFilteredPaginated(\n        string $category = '',\n        string $status = '',\n        string $search = '',\n        int $limit = 50,\n        int $offset = 0\n    ): array {\n        $sql = 'SELECT c.id, c.chunk_index, c.content, c.token_count, c.taxonomy_category,\n                       c.analysis_status, c.qdrant_id, c.created_at,\n                       d.title as dokument_title, d.path as dokument_path\n                FROM dokumentation_chunks c\n                JOIN dokumentation d ON c.dokumentation_id = d.id\n                WHERE 1=1';\n        $params = [];\n\n        if ($category !== '') {\n            $sql .= ' AND c.taxonomy_category = :category';\n            $params['category'] = $category;\n        }\n\n        if ($status !== '') {\n            $sql .= ' AND c.analysis_status = :status';\n            $params['status'] = $status;\n        }\n\n        if ($search !== '') {\n            $sql .= ' AND (c.content LIKE :search OR c.keywords LIKE :search2)';\n            $params['search'] = '%' . $search . '%';\n            $params['search2'] = '%' . $search . '%';\n        }\n\n        $sql .= ' ORDER BY c.created_at DESC LIMIT :limit OFFSET :offset';\n\n        $stmt = $this->pdo->prepare($sql);\n        foreach ($params as $key => $value) {\n            $stmt->bindValue(':' . $key, $value);\n        }\n        $stmt->bindValue(':limit', $limit, PDO::PARAM_INT);\n        $stmt->bindValue(':offset', $offset, PDO::PARAM_INT);\n        $stmt->execute();\n\n        return $stmt->fetchAll(PDO::FETCH_ASSOC);\n    }\n\n    \/**\n     * @return array<array<string, mixed>>\n     *\/\n    public function getRecentChunks(int $limit = 5): array\n    {\n        $stmt = $this->pdo->prepare(\n            'SELECT c.id, c.content, c.taxonomy_category, c.token_count, c.created_at,\n                    d.title as dokument_title, d.path as dokument_path\n             FROM dokumentation_chunks c\n             JOIN dokumentation d ON c.dokumentation_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(PDO::FETCH_ASSOC);\n    }\n\n    \/**\n     * @return array<string, mixed>|null\n     *\/\n    public function getChunk(int $id): ?array\n    {\n        $stmt = $this->pdo->prepare(\n            'SELECT c.*, d.title as dokument_title, d.path as dokument_path, d.id as dokument_id\n             FROM dokumentation_chunks c\n             JOIN dokumentation d ON c.dokumentation_id = d.id\n             WHERE c.id = :id'\n        );\n        $stmt->execute(['id' => $id]);\n        $result = $stmt->fetch(PDO::FETCH_ASSOC);\n\n        if ($result === false) {\n            return null;\n        }\n\n        \/\/ Decode JSON fields\n        $result['entities_decoded'] = $this->decodeJsonArray($result['entities'] ?? null);\n        $result['keywords_decoded'] = $this->decodeJsonArray($result['keywords'] ?? null);\n        $result['taxonomy_path_decoded'] = $this->decodeJsonArray($result['taxonomy_path'] ?? null);\n        $result['heading_path_decoded'] = $this->decodeJsonArray($result['heading_path'] ?? null);\n\n        return $result;\n    }\n\n    \/**\n     * @return array<array<string, mixed>>\n     *\/\n    public function getChunksForDokument(int $dokumentId): array\n    {\n        $stmt = $this->pdo->prepare(\n            'SELECT id, chunk_index, content, token_count, taxonomy_category,\n                    analysis_status, qdrant_id, created_at\n             FROM dokumentation_chunks\n             WHERE dokumentation_id = :id\n             ORDER BY chunk_index'\n        );\n        $stmt->execute(['id' => $dokumentId]);\n\n        return $stmt->fetchAll(PDO::FETCH_ASSOC);\n    }\n\n    \/**\n     * @return array<array<string, mixed>>\n     *\/\n    public function getChunksDetailedForDokument(int $dokumentId): array\n    {\n        $stmt = $this->pdo->prepare(\n            'SELECT c.id, c.chunk_index, c.content, c.token_count, c.taxonomy_category,\n                    c.taxonomy_path, c.entities, c.keywords, c.analysis_status, c.qdrant_id,\n                    c.heading_path, c.analyzed_at\n             FROM dokumentation_chunks c\n             WHERE c.dokumentation_id = :id\n             ORDER BY c.chunk_index'\n        );\n        $stmt->execute(['id' => $dokumentId]);\n\n        return $stmt->fetchAll(PDO::FETCH_ASSOC);\n    }\n\n    \/**\n     * @return array<string, mixed>|null\n     *\/\n    public function getChunkByDokumentAndIndex(int $dokumentId, int $index): ?array\n    {\n        $stmt = $this->pdo->prepare(\n            'SELECT id, chunk_index, content FROM dokumentation_chunks\n             WHERE dokumentation_id = :doc_id AND chunk_index = :idx'\n        );\n        $stmt->execute(['doc_id' => $dokumentId, 'idx' => $index]);\n        $result = $stmt->fetch(PDO::FETCH_ASSOC);\n\n        return $result !== false ? $result : null;\n    }\n\n    \/**\n     * @return array<string>\n     *\/\n    public function getDistinctCategories(): array\n    {\n        return $this->pdo->query(\n            'SELECT DISTINCT taxonomy_category FROM dokumentation_chunks\n             WHERE taxonomy_category IS NOT NULL ORDER BY taxonomy_category'\n        )->fetchAll(PDO::FETCH_COLUMN);\n    }\n\n    \/**\n     * @return array<array{taxonomy_category: string, count: int}>\n     *\/\n    public function getTopTaxonomyCategories(int $limit = 10): array\n    {\n        $stmt = $this->pdo->prepare(\n            'SELECT taxonomy_category, COUNT(*) as count\n             FROM dokumentation_chunks\n             WHERE taxonomy_category IS NOT NULL\n             GROUP BY taxonomy_category\n             ORDER BY count DESC\n             LIMIT :limit'\n        );\n        $stmt->bindValue(':limit', $limit, PDO::PARAM_INT);\n        $stmt->execute();\n\n        return $stmt->fetchAll(PDO::FETCH_ASSOC);\n    }\n\n    \/**\n     * @return array<array{taxonomy_category: string, chunk_count: int, token_count: int}>\n     *\/\n    public function getCategoriesWithStats(): array\n    {\n        return $this->pdo->query(\n            'SELECT taxonomy_category, COUNT(*) as chunk_count,\n                    COALESCE(SUM(token_count), 0) as token_count\n             FROM dokumentation_chunks\n             WHERE taxonomy_category IS NOT NULL\n             GROUP BY taxonomy_category\n             ORDER BY chunk_count DESC'\n        )->fetchAll(PDO::FETCH_ASSOC);\n    }\n\n    \/**\n     * @return array<string, int>\n     *\/\n    public function getTopKeywords(int $limit = 30): array\n    {\n        $keywordsRaw = $this->pdo->query(\n            'SELECT keywords FROM dokumentation_chunks WHERE keywords IS NOT NULL'\n        )->fetchAll(PDO::FETCH_COLUMN);\n\n        $keywordCounts = [];\n        foreach ($keywordsRaw as $json) {\n            $keywords = $this->decodeJsonArray($json);\n            foreach ($keywords as $kw) {\n                $kw = strtolower(trim($kw));\n                if ($kw !== '') {\n                    $keywordCounts[$kw] = ($keywordCounts[$kw] ?? 0) + 1;\n                }\n            }\n        }\n        arsort($keywordCounts);\n\n        return array_slice($keywordCounts, 0, $limit, true);\n    }\n\n    \/**\n     * @return array<string, int>\n     *\/\n    public function getTopEntitiesRaw(int $limit = 30): array\n    {\n        $entityCounts = $this->aggregateEntities();\n        arsort($entityCounts);\n\n        return array_slice($entityCounts, 0, $limit, true);\n    }\n\n    \/**\n     * @return array{entities: array, by_type: array<string, array>, total: int}\n     *\/\n    public function getEntitiesGrouped(int $limit = 100): array\n    {\n        $entitiesRaw = $this->pdo->query(\n            'SELECT entities FROM dokumentation_chunks WHERE entities IS NOT NULL'\n        )->fetchAll(PDO::FETCH_COLUMN);\n\n        $entityCounts = [];\n        foreach ($entitiesRaw as $json) {\n            $entities = $this->decodeJsonArray($json);\n            foreach ($entities as $entity) {\n                $name = $entity['name'] ?? ... [TRUNCATED-d636797101f86b40]"
    }
}

{
    "tool_response": {
        "type": "create",
        "filePath": "\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/ChunkExplorerRepository.php",
        "content": "<?php\n\ndeclare(strict_types=1);\n\nnamespace Infrastructure\\Persistence;\n\nuse Domain\\Repository\\ChunkExplorerRepositoryInterface;\nuse Infrastructure\\Traits\\JsonDecodeTrait;\nuse PDO;\n\n\/\/ @responsibility: Persistenz für Chunk-Explorer (Chunks mit Taxonomie\/Entities)\n\nclass ChunkExplorerRepository implements ChunkExplorerRepositoryInterface\n{\n    use JsonDecodeTrait;\n\n    private PDO $pdo;\n\n    public function __construct(PDO $pdo)\n    {\n        $this->pdo = $pdo;\n    }\n\n    \/**\n     * @return array{total: int, tokens: int, analyzed: int, synced: int}\n     *\/\n    public function getChunkStats(): array\n    {\n        $result = $this->pdo->query(\n            'SELECT\n                COUNT(*) as total,\n                COALESCE(SUM(token_count), 0) as tokens,\n                SUM(CASE WHEN analysis_status = \"completed\" THEN 1 ELSE 0 END) as analyzed,\n                SUM(CASE WHEN qdrant_id IS NOT NULL THEN 1 ELSE 0 END) as synced\n             FROM dokumentation_chunks'\n        )->fetch(PDO::FETCH_ASSOC);\n\n        return $result ?: ['total' => 0, 'tokens' => 0, 'analyzed' => 0, 'synced' => 0];\n    }\n\n    public function countChunksFiltered(string $category = '', string $status = '', string $search = ''): int\n    {\n        $sql = 'SELECT COUNT(*) FROM dokumentation_chunks c\n                JOIN dokumentation d ON c.dokumentation_id = d.id\n                WHERE 1=1';\n        $params = [];\n\n        if ($category !== '') {\n            $sql .= ' AND c.taxonomy_category = :category';\n            $params['category'] = $category;\n        }\n\n        if ($status !== '') {\n            $sql .= ' AND c.analysis_status = :status';\n            $params['status'] = $status;\n        }\n\n        if ($search !== '') {\n            $sql .= ' AND (c.content LIKE :search OR c.keywords LIKE :search2)';\n            $params['search'] = '%' . $search . '%';\n            $params['search2'] = '%' . $search . '%';\n        }\n\n        $stmt = $this->pdo->prepare($sql);\n        $stmt->execute($params);\n\n        return (int) $stmt->fetchColumn();\n    }\n\n    \/**\n     * @return array<array<string, mixed>>\n     *\/\n    public function getChunksFilteredPaginated(\n        string $category = '',\n        string $status = '',\n        string $search = '',\n        int $limit = 50,\n        int $offset = 0\n    ): array {\n        $sql = 'SELECT c.id, c.chunk_index, c.content, c.token_count, c.taxonomy_category,\n                       c.analysis_status, c.qdrant_id, c.created_at,\n                       d.title as dokument_title, d.path as dokument_path\n                FROM dokumentation_chunks c\n                JOIN dokumentation d ON c.dokumentation_id = d.id\n                WHERE 1=1';\n        $params = [];\n\n        if ($category !== '') {\n            $sql .= ' AND c.taxonomy_category = :category';\n            $params['category'] = $category;\n        }\n\n        if ($status !== '') {\n            $sql .= ' AND c.analysis_status = :status';\n            $params['status'] = $status;\n        }\n\n        if ($search !== '') {\n            $sql .= ' AND (c.content LIKE :search OR c.keywords LIKE :search2)';\n            $params['search'] = '%' . $search . '%';\n            $params['search2'] = '%' . $search . '%';\n        }\n\n        $sql .= ' ORDER BY c.created_at DESC LIMIT :limit OFFSET :offset';\n\n        $stmt = $this->pdo->prepare($sql);\n        foreach ($params as $key => $value) {\n            $stmt->bindValue(':' . $key, $value);\n        }\n        $stmt->bindValue(':limit', $limit, PDO::PARAM_INT);\n        $stmt->bindValue(':offset', $offset, PDO::PARAM_INT);\n        $stmt->execute();\n\n        return $stmt->fetchAll(PDO::FETCH_ASSOC);\n    }\n\n    \/**\n     * @return array<array<string, mixed>>\n     *\/\n    public function getRecentChunks(int $limit = 5): array\n    {\n        $stmt = $this->pdo->prepare(\n            'SELECT c.id, c.content, c.taxonomy_category, c.token_count, c.created_at,\n                    d.title as dokument_title, d.path as dokument_path\n             FROM dokumentation_chunks c\n             JOIN dokumentation d ON c.dokumentation_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(PDO::FETCH_ASSOC);\n    }\n\n    \/**\n     * @return array<string, mixed>|null\n     *\/\n    public function getChunk(int $id): ?array\n    {\n        $stmt = $this->pdo->prepare(\n            'SELECT c.*, d.title as dokument_title, d.path as dokument_path, d.id as dokument_id\n             FROM dokumentation_chunks c\n             JOIN dokumentation d ON c.dokumentation_id = d.id\n             WHERE c.id = :id'\n        );\n        $stmt->execute(['id' => $id]);\n        $result = $stmt->fetch(PDO::FETCH_ASSOC);\n\n        if ($result === false) {\n            return null;\n        }\n\n        \/\/ Decode JSON fields\n        $result['entities_decoded'] = $this->decodeJsonArray($result['entities'] ?? null);\n        $result['keywords_decoded'] = $this->decodeJsonArray($result['keywords'] ?? null);\n        $result['taxonomy_path_decoded'] = $this->decodeJsonArray($result['taxonomy_path'] ?? null);\n        $result['heading_path_decoded'] = $this->decodeJsonArray($result['heading_path'] ?? null);\n\n        return $result;\n    }\n\n    \/**\n     * @return array<array<string, mixed>>\n     *\/\n    public function getChunksForDokument(int $dokumentId): array\n    {\n        $stmt = $this->pdo->prepare(\n            'SELECT id, chunk_index, content, token_count, taxonomy_category,\n                    analysis_status, qdrant_id, created_at\n             FROM dokumentation_chunks\n             WHERE dokumentation_id = :id\n             ORDER BY chunk_index'\n        );\n        $stmt->execute(['id' => $dokumentId]);\n\n        return $stmt->fetchAll(PDO::FETCH_ASSOC);\n    }\n\n    \/**\n     * @return array<array<string, mixed>>\n     *\/\n    public function getChunksDetailedForDokument(int $dokumentId): array\n    {\n        $stmt = $this->pdo->prepare(\n            'SELECT c.id, c.chunk_index, c.content, c.token_count, c.taxonomy_category,\n                    c.taxonomy_path, c.entities, c.keywords, c.analysis_status, c.qdrant_id,\n                    c.heading_path, c.analyzed_at\n             FROM dokumentation_chunks c\n             WHERE c.dokumentation_id = :id\n             ORDER BY c.chunk_index'\n        );\n        $stmt->execute(['id' => $dokumentId]);\n\n        return $stmt->fetchAll(PDO::FETCH_ASSOC);\n    }\n\n    \/**\n     * @return array<string, mixed>|null\n     *\/\n    public function getChunkByDokumentAndIndex(int $dokumentId, int $index): ?array\n    {\n        $stmt = $this->pdo->prepare(\n            'SELECT id, chunk_index, content FROM dokumentation_chunks\n             WHERE dokumentation_id = :doc_id AND chunk_index = :idx'\n        );\n        $stmt->execute(['doc_id' => $dokumentId, 'idx' => $index]);\n        $result = $stmt->fetch(PDO::FETCH_ASSOC);\n\n        return $result !== false ? $result : null;\n    }\n\n    \/**\n     * @return array<string>\n     *\/\n    public function getDistinctCategories(): array\n    {\n        return $this->pdo->query(\n            'SELECT DISTINCT taxonomy_category FROM dokumentation_chunks\n             WHERE taxonomy_category IS NOT NULL ORDER BY taxonomy_category'\n        )->fetchAll(PDO::FETCH_COLUMN);\n    }\n\n    \/**\n     * @return array<array{taxonomy_category: string, count: int}>\n     *\/\n    public function getTopTaxonomyCategories(int $limit = 10): array\n    {\n        $stmt = $this->pdo->prepare(\n            'SELECT taxonomy_category, COUNT(*) as count\n             FROM dokumentation_chunks\n             WHERE taxonomy_category IS NOT NULL\n             GROUP BY taxonomy_category\n             ORDER BY count DESC\n             LIMIT :limit'\n        );\n        $stmt->bindValue(':limit', $limit, PDO::PARAM_INT);\n        $stmt->execute();\n\n        return $stmt->fetchAll(PDO::FETCH_ASSOC);\n    }\n\n    \/**\n     * @return array<array{taxonomy_category: string, chunk_count: int, token_count: int}>\n     *\/\n    public function getCategoriesWithStats(): array\n    {\n        return $this->pdo->query(\n            'SELECT taxonomy_category, COUNT(*) as chunk_count,\n                    COALESCE(SUM(token_count), 0) as token_count\n             FROM dokumentation_chunks\n             WHERE taxonomy_category IS NOT NULL\n             GROUP BY taxonomy_category\n             ORDER BY chunk_count DESC'\n        )->fetchAll(PDO::FETCH_ASSOC);\n    }\n\n    \/**\n     * @return array<string, int>\n     *\/\n    public function getTopKeywords(int $limit = 30): array\n    {\n        $keywordsRaw = $this->pdo->query(\n            'SELECT keywords FROM dokumentation_chunks WHERE keywords IS NOT NULL'\n        )->fetchAll(PDO::FETCH_COLUMN);\n\n        $keywordCounts = [];\n        foreach ($keywordsRaw as $json) {\n            $keywords = $this->decodeJsonArray($json);\n            foreach ($keywords as $kw) {\n                $kw = strtolower(trim($kw));\n                if ($kw !== '') {\n                    $keywordCounts[$kw] = ($keywordCounts[$kw] ?? 0) + 1;\n                }\n            }\n        }\n        arsort($keywordCounts);\n\n        return array_slice($keywordCounts, 0, $limit, true);\n    }\n\n    \/**\n     * @return array<string, int>\n     *\/\n    public function getTopEntitiesRaw(int $limit = 30): array\n    {\n        $entityCounts = $this->aggregateEntities();\n        arsort($entityCounts);\n\n        return array_slice($entityCounts, 0, $limit, true);\n    }\n\n    \/**\n     * @return array{entities: array, by_type: array<string, array>, total: int}\n     *\/\n    public function getEntitiesGrouped(int $limit = 100): array\n    {\n        $entitiesRaw = $this->pdo->query(\n            'SELECT entities FROM dokumentation_chunks WHERE entities IS NOT NULL'\n        )->fetchAll(PDO::FETCH_COLUMN);\n\n        $entityCounts = [];\n        foreach ($entitiesRaw as $json) {\n            $entities = $this->decodeJsonArray($json);\n            foreach ($entities as $entity) {\n                $name = $entity['name'] ?? ... [TRUNCATED-d636797101f86b40]",
        "structuredPatch": [],
        "originalFile": null
    }
}