Protokoll #3649

{
    "event": "PreToolUse",
    "tool_name": "Edit",
    "tool_input": {
        "file_path": "\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/SystemExplorerRepository.php",
        "old_string": "    \/**\n     * @return array<string, array{count: int, type: string}>\n     *\/\n    public function getTopEntities(int $limit = 30): 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'] ?? '';\n                $type = $entity['type'] ?? 'OTHER';\n                if ($name !== '') {\n                    $key = $name . '|' . $type;\n                    $entityCounts[$key] = ($entityCounts[$key] ?? 0) + 1;\n                }\n            }\n        }\n        arsort($entityCounts);\n\n        $result = [];\n        foreach (array_slice($entityCounts, 0, $limit, true) as $key => $count) {\n            [$name, $type] = explode('|', $key);\n            $result[$name] = ['count' => $count, 'type' => $type];\n        }\n\n        return $result;\n    }\n}",
        "new_string": "    \/**\n     * @return array<string, array{count: int, type: string}>\n     *\/\n    public function getTopEntities(int $limit = 30): 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'] ?? '';\n                $type = $entity['type'] ?? 'OTHER';\n                if ($name !== '') {\n                    $key = $name . '|' . $type;\n                    $entityCounts[$key] = ($entityCounts[$key] ?? 0) + 1;\n                }\n            }\n        }\n        arsort($entityCounts);\n\n        $result = [];\n        foreach (array_slice($entityCounts, 0, $limit, true) as $key => $count) {\n            [$name, $type] = explode('|', $key);\n            $result[$name] = ['count' => $count, 'type' => $type];\n        }\n\n        return $result;\n    }\n\n    \/**\n     * Get entities with grouping by type (for API).\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'] ?? '';\n                $type = $entity['type'] ?? 'OTHER';\n                if ($name !== '') {\n                    $key = $name . '|' . $type;\n                    if (!isset($entityCounts[$key])) {\n                        $entityCounts[$key] = [\n                            'name' => $name,\n                            'type' => $type,\n                            'count' => 0,\n                        ];\n                    }\n                    $entityCounts[$key]['count']++;\n                }\n            }\n        }\n\n        \/\/ Sort by count\n        usort($entityCounts, fn ($a, $b) => $b['count'] <=> $a['count']);\n\n        \/\/ Group by type\n        $byType = [];\n        foreach ($entityCounts as $entity) {\n            $type = $entity['type'];\n            if (!isset($byType[$type])) {\n                $byType[$type] = [];\n            }\n            $byType[$type][] = $entity;\n        }\n\n        return [\n            'entities' => array_slice($entityCounts, 0, $limit),\n            'by_type' => $byType,\n            'total' => count($entityCounts),\n        ];\n    }\n}"
    }
}

{
    "tool_response": {
        "filePath": "\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/SystemExplorerRepository.php",
        "oldString": "    \/**\n     * @return array<string, array{count: int, type: string}>\n     *\/\n    public function getTopEntities(int $limit = 30): 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'] ?? '';\n                $type = $entity['type'] ?? 'OTHER';\n                if ($name !== '') {\n                    $key = $name . '|' . $type;\n                    $entityCounts[$key] = ($entityCounts[$key] ?? 0) + 1;\n                }\n            }\n        }\n        arsort($entityCounts);\n\n        $result = [];\n        foreach (array_slice($entityCounts, 0, $limit, true) as $key => $count) {\n            [$name, $type] = explode('|', $key);\n            $result[$name] = ['count' => $count, 'type' => $type];\n        }\n\n        return $result;\n    }\n}",
        "newString": "    \/**\n     * @return array<string, array{count: int, type: string}>\n     *\/\n    public function getTopEntities(int $limit = 30): 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'] ?? '';\n                $type = $entity['type'] ?? 'OTHER';\n                if ($name !== '') {\n                    $key = $name . '|' . $type;\n                    $entityCounts[$key] = ($entityCounts[$key] ?? 0) + 1;\n                }\n            }\n        }\n        arsort($entityCounts);\n\n        $result = [];\n        foreach (array_slice($entityCounts, 0, $limit, true) as $key => $count) {\n            [$name, $type] = explode('|', $key);\n            $result[$name] = ['count' => $count, 'type' => $type];\n        }\n\n        return $result;\n    }\n\n    \/**\n     * Get entities with grouping by type (for API).\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'] ?? '';\n                $type = $entity['type'] ?? 'OTHER';\n                if ($name !== '') {\n                    $key = $name . '|' . $type;\n                    if (!isset($entityCounts[$key])) {\n                        $entityCounts[$key] = [\n                            'name' => $name,\n                            'type' => $type,\n                            'count' => 0,\n                        ];\n                    }\n                    $entityCounts[$key]['count']++;\n                }\n            }\n        }\n\n        \/\/ Sort by count\n        usort($entityCounts, fn ($a, $b) => $b['count'] <=> $a['count']);\n\n        \/\/ Group by type\n        $byType = [];\n        foreach ($entityCounts as $entity) {\n            $type = $entity['type'];\n            if (!isset($byType[$type])) {\n                $byType[$type] = [];\n            }\n            $byType[$type][] = $entity;\n        }\n\n        return [\n            'entities' => array_slice($entityCounts, 0, $limit),\n            'by_type' => $byType,\n            'total' => count($entityCounts),\n        ];\n    }\n}",
        "originalFile": "<?php\n\ndeclare(strict_types=1);\n\nnamespace Infrastructure\\Persistence;\n\nuse Infrastructure\\Config\\DatabaseFactory;\nuse Infrastructure\\Traits\\JsonDecodeTrait;\nuse PDO;\n\n\/**\n * Repository for System Explorer (dokumentation + chunks).\n *\n * Provides data access for the System Explorer controller.\n *\/\nclass SystemExplorerRepository\n{\n    use JsonDecodeTrait;\n\n    private PDO $pdo;\n\n    public function __construct()\n    {\n        $this->pdo = DatabaseFactory::dev();\n    }\n\n    \/\/ ==================== Statistics ====================\n\n    public function countDokumente(): int\n    {\n        return (int) $this->pdo->query(\n            'SELECT COUNT(*) FROM dokumentation WHERE depth = 0'\n        )->fetchColumn();\n    }\n\n    public function countSeiten(): int\n    {\n        return (int) $this->pdo->query(\n            'SELECT COUNT(*) FROM dokumentation WHERE depth > 0'\n        )->fetchColumn();\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    \/**\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    \/\/ ==================== Dokumente ====================\n\n    \/**\n     * @return array<array<string, mixed>>\n     *\/\n    public function getDokumenteWithStats(): array\n    {\n        return $this->pdo->query(\n            'SELECT d.id, d.title, d.path,\n                    (SELECT COUNT(*) FROM dokumentation WHERE parent_id = d.id) as seiten_count,\n                    (SELECT COUNT(*) FROM dokumentation_chunks WHERE dokumentation_id = d.id) as chunks_count\n             FROM dokumentation d\n             WHERE d.depth = 0\n             ORDER BY d.title'\n        )->fetchAll(PDO::FETCH_ASSOC);\n    }\n\n    \/**\n     * @return array<array<string, mixed>>\n     *\/\n    public function getDokumenteWithFullStats(): array\n    {\n        return $this->pdo->query(\n            'SELECT d.id, d.title, d.path, d.content, d.created_at, d.updated_at,\n                    (SELECT COUNT(*) FROM dokumentation WHERE parent_id = d.id) as seiten_count,\n                    (SELECT COUNT(*) FROM dokumentation_chunks WHERE dokumentation_id IN\n                        (SELECT id FROM dokumentation WHERE parent_id = d.id OR id = d.id)) as total_chunks,\n                    (SELECT COALESCE(SUM(token_count), 0) FROM dokumentation_chunks WHERE dokumentation_id IN\n                        (SELECT id FROM dokumentation WHERE parent_id = d.id OR id = d.id)) as total_tokens\n             FROM dokumentation d\n             WHERE d.depth = 0\n             ORDER BY d.title'\n        )->fetchAll(PDO::FETCH_ASSOC);\n    }\n\n    \/**\n     * @return array<string, mixed>|null\n     *\/\n    public function getDokument(int $id): ?array\n    {\n        $stmt = $this->pdo->prepare(\n            'SELECT d.*, p.title as parent_title\n             FROM dokumentation d\n             LEFT JOIN dokumentation p ON d.parent_id = p.id\n             WHERE d.id = :id'\n        );\n        $stmt->execute(['id' => $id]);\n        $result = $stmt->fetch(PDO::FETCH_ASSOC);\n\n        return $result !== false ? $result : null;\n    }\n\n    \/\/ ==================== Seiten ====================\n\n    \/**\n     * @return array<array<string, mixed>>\n     *\/\n    public function getSeitenFiltered(string $search = '', string $parentId = ''): array\n    {\n        $sql = 'SELECT s.id, s.title, s.path, s.depth, s.parent_id,\n                       p.title as parent_title,\n                       (SELECT COUNT(*) FROM dokumentation_chunks WHERE dokumentation_id = s.id) as chunks_count,\n                       (SELECT COALESCE(SUM(token_count), 0) FROM dokumentation_chunks WHERE dokumentation_id = s.id) as token_count\n                FROM dokumentation s\n                LEFT JOIN dokumentation p ON s.parent_id = p.id\n                WHERE s.depth > 0';\n        $params = [];\n\n        if ($search !== '') {\n            $sql .= ' AND (s.title LIKE :search OR s.path LIKE :search2)';\n            $params['search'] = '%' . $search . '%';\n            $params['search2'] = '%' . $search . '%';\n        }\n\n        if ($parentId !== '') {\n            $sql .= ' AND s.parent_id = :parent_id';\n            $params['parent_id'] = (int) $parentId;\n        }\n\n        $sql .= ' ORDER BY s.path';\n\n        $stmt = $this->pdo->prepare($sql);\n        $stmt->execute($params);\n\n        return $stmt->fetchAll(PDO::FETCH_ASSOC);\n    }\n\n    \/**\n     * @return array<array<string, mixed>>\n     *\/\n    public function getDokumenteForFilter(): array\n    {\n        return $this->pdo->query(\n            'SELECT id, title FROM dokumentation WHERE depth = 0 ORDER BY title'\n        )->fetchAll(PDO::FETCH_ASSOC);\n    }\n\n    \/\/ ==================== Chunks ====================\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<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    \/\/ ==================== Taxonomie ====================\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, array{count: int, type: string}>\n     *\/\n    public function getTopEntities(int $limit = 30): 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 ($ent... [TRUNCATED-72e904d75838263d]",
        "structuredPatch": [
            {
                "oldStart": 321,
                "oldLines": 4,
                "newStart": 321,
                "newLines": 55,
                "lines": [
                    " ",
                    "         return $result;",
                    "     }",
                    "+",
                    "+    \/**",
                    "+     * Get entities with grouping by type (for API).",
                    "+     *",
                    "+     * @return array{entities: array, by_type: array<string, array>, total: int}",
                    "+     *\/",
                    "+    public function getEntitiesGrouped(int $limit = 100): array",
                    "+    {",
                    "+        $entitiesRaw = $this->pdo->query(",
                    "+            'SELECT entities FROM dokumentation_chunks WHERE entities IS NOT NULL'",
                    "+        )->fetchAll(PDO::FETCH_COLUMN);",
                    "+",
                    "+        $entityCounts = [];",
                    "+        foreach ($entitiesRaw as $json) {",
                    "+            $entities = $this->decodeJsonArray($json);",
                    "+            foreach ($entities as $entity) {",
                    "+                $name = $entity['name'] ?? '';",
                    "+                $type = $entity['type'] ?? 'OTHER';",
                    "+                if ($name !== '') {",
                    "+                    $key = $name . '|' . $type;",
                    "+                    if (!isset($entityCounts[$key])) {",
                    "+                        $entityCounts[$key] = [",
                    "+                            'name' => $name,",
                    "+                            'type' => $type,",
                    "+                            'count' => 0,",
                    "+                        ];",
                    "+                    }",
                    "+                    $entityCounts[$key]['count']++;",
                    "+                }",
                    "+            }",
                    "+        }",
                    "+",
                    "+        \/\/ Sort by count",
                    "+        usort($entityCounts, fn ($a, $b) => $b['count'] <=> $a['count']);",
                    "+",
                    "+        \/\/ Group by type",
                    "+        $byType = [];",
                    "+        foreach ($entityCounts as $entity) {",
                    "+            $type = $entity['type'];",
                    "+            if (!isset($byType[$type])) {",
                    "+                $byType[$type] = [];",
                    "+            }",
                    "+            $byType[$type][] = $entity;",
                    "+        }",
                    "+",
                    "+        return [",
                    "+            'entities' => array_slice($entityCounts, 0, $limit),",
                    "+            'by_type' => $byType,",
                    "+            'total' => count($entityCounts),",
                    "+        ];",
                    "+    }",
                    " }"
                ]
            }
        ],
        "userModified": false,
        "replaceAll": false
    }
}