Protokoll #14745

{
    "event": "PreToolUse",
    "tool_name": "Write",
    "tool_input": {
        "file_path": "\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/SeiteExplorerRepository.php",
        "content": "<?php\n\ndeclare(strict_types=1);\n\nnamespace Infrastructure\\Persistence;\n\nuse Domain\\Repository\\SeiteExplorerRepositoryInterface;\nuse PDO;\n\n\/\/ @responsibility: Persistenz für Seiten-Explorer (Unterseiten mit Stats)\n\nclass SeiteExplorerRepository implements SeiteExplorerRepositoryInterface\n{\n    private PDO $pdo;\n\n    public function __construct(PDO $pdo)\n    {\n        $this->pdo = $pdo;\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    public function countSeitenFiltered(string $search = '', string $parentId = ''): int\n    {\n        $sql = 'SELECT COUNT(*) FROM dokumentation s 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';\n            $params['parent'] = (int) $parentId;\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 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 getSeitenPaginated(\n        string $search = '',\n        string $parentId = '',\n        int $limit = 50,\n        int $offset = 0\n    ): array {\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';\n            $params['parent'] = (int) $parentId;\n        }\n\n        $sql .= ' ORDER BY p.title, s.depth, s.title LIMIT :limit OFFSET :offset';\n\n        $stmt = $this->pdo->prepare($sql);\n        foreach ($params as $key => $value) {\n            $stmt->bindValue(':' . $key, $value, is_int($value) ? PDO::PARAM_INT : PDO::PARAM_STR);\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<string, mixed>|null\n     *\/\n    public function getSeiteWithParent(int $id): ?array\n    {\n        $stmt = $this->pdo->prepare(\n            'SELECT s.*, p.title as parent_title, p.path as parent_path\n             FROM dokumentation s\n             LEFT JOIN dokumentation p ON s.parent_id = p.id\n             WHERE s.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    \/**\n     * @return array<array<string, mixed>>\n     *\/\n    public function getSeitenWithStatsForParent(int $parentId): array\n    {\n        $stmt = $this->pdo->prepare(\n            'SELECT s.id, s.title, s.path, s.depth,\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             WHERE s.parent_id = :id\n             ORDER BY s.title'\n        );\n        $stmt->execute(['id' => $parentId]);\n\n        return $stmt->fetchAll(PDO::FETCH_ASSOC);\n    }\n\n    \/**\n     * @return array<array<string, mixed>>\n     *\/\n    public function getUnterseiten(int $parentId): array\n    {\n        $stmt = $this->pdo->prepare(\n            'SELECT id, title, path, depth FROM dokumentation WHERE parent_id = :id ORDER BY title'\n        );\n        $stmt->execute(['id' => $parentId]);\n\n        return $stmt->fetchAll(PDO::FETCH_ASSOC);\n    }\n\n    \/**\n     * @param array<string, mixed> $seite\n     * @return array<array{id: int, title: string, path: string, depth: int}>\n     *\/\n    public function buildBreadcrumb(array $seite): array\n    {\n        $breadcrumb = [];\n        $current = $seite;\n\n        while ($current !== null && $current !== false) {\n            array_unshift($breadcrumb, [\n                'id' => $current['id'],\n                'title' => $current['title'],\n                'path' => $current['path'],\n                'depth' => $current['depth'],\n            ]);\n\n            if ($current['parent_id'] === null) {\n                break;\n            }\n\n            $stmt = $this->pdo->prepare('SELECT * FROM dokumentation WHERE id = :id');\n            $stmt->execute(['id' => $current['parent_id']]);\n            $current = $stmt->fetch(PDO::FETCH_ASSOC);\n        }\n\n        return $breadcrumb;\n    }\n\n    \/**\n     * @return array<array{taxonomy_category: string, count: int}>\n     *\/\n    public function getTaxonomyForDokumentTree(int $dokumentId): array\n    {\n        $stmt = $this->pdo->prepare(\n            'SELECT taxonomy_category, COUNT(*) as count\n             FROM dokumentation_chunks\n             WHERE dokumentation_id IN (\n                 SELECT id FROM dokumentation WHERE id = :id OR parent_id = :id2\n             )\n             AND taxonomy_category IS NOT NULL\n             GROUP BY taxonomy_category\n             ORDER BY count DESC'\n        );\n        $stmt->execute(['id' => $dokumentId, 'id2' => $dokumentId]);\n\n        return $stmt->fetchAll(PDO::FETCH_ASSOC);\n    }\n}\n"
    }
}

{
    "tool_response": {
        "type": "create",
        "filePath": "\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/SeiteExplorerRepository.php",
        "content": "<?php\n\ndeclare(strict_types=1);\n\nnamespace Infrastructure\\Persistence;\n\nuse Domain\\Repository\\SeiteExplorerRepositoryInterface;\nuse PDO;\n\n\/\/ @responsibility: Persistenz für Seiten-Explorer (Unterseiten mit Stats)\n\nclass SeiteExplorerRepository implements SeiteExplorerRepositoryInterface\n{\n    private PDO $pdo;\n\n    public function __construct(PDO $pdo)\n    {\n        $this->pdo = $pdo;\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    public function countSeitenFiltered(string $search = '', string $parentId = ''): int\n    {\n        $sql = 'SELECT COUNT(*) FROM dokumentation s 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';\n            $params['parent'] = (int) $parentId;\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 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 getSeitenPaginated(\n        string $search = '',\n        string $parentId = '',\n        int $limit = 50,\n        int $offset = 0\n    ): array {\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';\n            $params['parent'] = (int) $parentId;\n        }\n\n        $sql .= ' ORDER BY p.title, s.depth, s.title LIMIT :limit OFFSET :offset';\n\n        $stmt = $this->pdo->prepare($sql);\n        foreach ($params as $key => $value) {\n            $stmt->bindValue(':' . $key, $value, is_int($value) ? PDO::PARAM_INT : PDO::PARAM_STR);\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<string, mixed>|null\n     *\/\n    public function getSeiteWithParent(int $id): ?array\n    {\n        $stmt = $this->pdo->prepare(\n            'SELECT s.*, p.title as parent_title, p.path as parent_path\n             FROM dokumentation s\n             LEFT JOIN dokumentation p ON s.parent_id = p.id\n             WHERE s.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    \/**\n     * @return array<array<string, mixed>>\n     *\/\n    public function getSeitenWithStatsForParent(int $parentId): array\n    {\n        $stmt = $this->pdo->prepare(\n            'SELECT s.id, s.title, s.path, s.depth,\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             WHERE s.parent_id = :id\n             ORDER BY s.title'\n        );\n        $stmt->execute(['id' => $parentId]);\n\n        return $stmt->fetchAll(PDO::FETCH_ASSOC);\n    }\n\n    \/**\n     * @return array<array<string, mixed>>\n     *\/\n    public function getUnterseiten(int $parentId): array\n    {\n        $stmt = $this->pdo->prepare(\n            'SELECT id, title, path, depth FROM dokumentation WHERE parent_id = :id ORDER BY title'\n        );\n        $stmt->execute(['id' => $parentId]);\n\n        return $stmt->fetchAll(PDO::FETCH_ASSOC);\n    }\n\n    \/**\n     * @param array<string, mixed> $seite\n     * @return array<array{id: int, title: string, path: string, depth: int}>\n     *\/\n    public function buildBreadcrumb(array $seite): array\n    {\n        $breadcrumb = [];\n        $current = $seite;\n\n        while ($current !== null && $current !== false) {\n            array_unshift($breadcrumb, [\n                'id' => $current['id'],\n                'title' => $current['title'],\n                'path' => $current['path'],\n                'depth' => $current['depth'],\n            ]);\n\n            if ($current['parent_id'] === null) {\n                break;\n            }\n\n            $stmt = $this->pdo->prepare('SELECT * FROM dokumentation WHERE id = :id');\n            $stmt->execute(['id' => $current['parent_id']]);\n            $current = $stmt->fetch(PDO::FETCH_ASSOC);\n        }\n\n        return $breadcrumb;\n    }\n\n    \/**\n     * @return array<array{taxonomy_category: string, count: int}>\n     *\/\n    public function getTaxonomyForDokumentTree(int $dokumentId): array\n    {\n        $stmt = $this->pdo->prepare(\n            'SELECT taxonomy_category, COUNT(*) as count\n             FROM dokumentation_chunks\n             WHERE dokumentation_id IN (\n                 SELECT id FROM dokumentation WHERE id = :id OR parent_id = :id2\n             )\n             AND taxonomy_category IS NOT NULL\n             GROUP BY taxonomy_category\n             ORDER BY count DESC'\n        );\n        $stmt->execute(['id' => $dokumentId, 'id2' => $dokumentId]);\n\n        return $stmt->fetchAll(PDO::FETCH_ASSOC);\n    }\n}\n",
        "structuredPatch": [],
        "originalFile": null
    }
}