Protokoll #14301

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

{
    "tool_response": {
        "type": "text",
        "file": {
            "filePath": "\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/DokumentationRepository.php",
            "content": "<?php\n\ndeclare(strict_types=1);\n\nnamespace Infrastructure\\Persistence;\n\n\/\/ @responsibility: Persistenz für Dokumentations-Baum (hierarchisch, mit Chunks)\n\nuse Domain\\Repository\\DokumentationRepositoryInterface;\n\nclass DokumentationRepository implements DokumentationRepositoryInterface\n{\n    private \\PDO $pdo;\n\n    public function __construct(?\\PDO $pdo = null)\n    {\n        $this->pdo = $pdo ?? DatabaseFactory::dev();\n    }\n\n    public function findById(int $id): ?array\n    {\n        $stmt = $this->pdo->prepare('SELECT * FROM dokumentation WHERE id = :id');\n        $stmt->execute(['id' => $id]);\n        $result = $stmt->fetch();\n\n        return $result !== false ? $result : null;\n    }\n\n    public function findByPath(string $path): ?array\n    {\n        $stmt = $this->pdo->prepare('SELECT * FROM dokumentation WHERE path = :path AND status = :status');\n        $stmt->execute(['path' => $path, 'status' => 'published']);\n        $result = $stmt->fetch();\n\n        return $result !== false ? $result : null;\n    }\n\n    public function findBySlug(string $slug, ?int $parentId = null): ?array\n    {\n        if ($parentId === null) {\n            $stmt = $this->pdo->prepare('SELECT * FROM dokumentation WHERE slug = :slug AND parent_id IS NULL AND status = :status');\n            $stmt->execute(['slug' => $slug, 'status' => 'published']);\n        } else {\n            $stmt = $this->pdo->prepare('SELECT * FROM dokumentation WHERE slug = :slug AND parent_id = :parent_id AND status = :status');\n            $stmt->execute(['slug' => $slug, 'parent_id' => $parentId, 'status' => 'published']);\n        }\n        $result = $stmt->fetch();\n\n        return $result !== false ? $result : null;\n    }\n\n    public function findDocBySlug(string $slug): ?array\n    {\n        $stmt = $this->pdo->prepare('SELECT * FROM dokumentation WHERE slug = :slug AND status = :status LIMIT 1');\n        $stmt->execute(['slug' => $slug, 'status' => 'published']);\n        $result = $stmt->fetch();\n\n        return $result !== false ? $result : null;\n    }\n\n    public function findChildren(int $parentId): array\n    {\n        $stmt = $this->pdo->prepare('\n            SELECT * FROM dokumentation\n            WHERE parent_id = :parent_id AND status = :status\n            ORDER BY sort_order ASC\n        ');\n        $stmt->execute(['parent_id' => $parentId, 'status' => 'published']);\n\n        return $stmt->fetchAll();\n    }\n\n    public function findRootDocuments(): array\n    {\n        $stmt = $this->pdo->prepare('\n            SELECT * FROM dokumentation\n            WHERE parent_id IS NULL AND status = :status\n            ORDER BY sort_order ASC\n        ');\n        $stmt->execute(['status' => 'published']);\n\n        return $stmt->fetchAll();\n    }\n\n    public function getHierarchy(): array\n    {\n        $roots = $this->findRootDocuments();\n\n        return $this->buildTree($roots);\n    }\n\n    private function buildTree(array $items): array\n    {\n        $result = [];\n        foreach ($items as $item) {\n            $children = $this->findChildren((int) $item['id']);\n            $item['children'] = $this->buildTree($children);\n            $result[] = $item;\n        }\n\n        return $result;\n    }\n\n    public function getBreadcrumb(int $docId): array\n    {\n        $breadcrumb = [];\n        $doc = $this->findById($docId);\n\n        while ($doc !== null) {\n            array_unshift($breadcrumb, [\n                'title' => $doc['title'],\n                'path' => $doc['path'],\n            ]);\n\n            if ($doc['parent_id'] !== null) {\n                $doc = $this->findById((int) $doc['parent_id']);\n            } else {\n                $doc = null;\n            }\n        }\n\n        return $breadcrumb;\n    }\n\n    public function getSiblings(int $docId): array\n    {\n        $doc = $this->findById($docId);\n        if ($doc === null) {\n            return [];\n        }\n\n        if ($doc['parent_id'] === null) {\n            return $this->findRootDocuments();\n        }\n\n        return $this->findChildren((int) $doc['parent_id']);\n    }\n\n    public function getStatistics(): array\n    {\n        $stats = [];\n\n        $stmt = $this->pdo->query('SELECT COUNT(*) FROM dokumentation');\n        $stats['total'] = (int) $stmt->fetchColumn();\n\n        $stmt = $this->pdo->query('SELECT depth, COUNT(*) as count FROM dokumentation GROUP BY depth ORDER BY depth');\n        $stats['by_depth'] = $stmt->fetchAll();\n\n        $stmt = $this->pdo->query('SELECT status, COUNT(*) as count FROM dokumentation GROUP BY status');\n        $stats['by_status'] = $stmt->fetchAll();\n\n        return $stats;\n    }\n\n    \/**\n     * Find all documents with optional filters.\n     *\/\n    public function findAll(\n        ?string $status = null,\n        ?int $parentId = null,\n        ?string $search = null,\n        int $limit = 50,\n        int $offset = 0\n    ): array {\n        $sql = 'SELECT * FROM dokumentation WHERE 1=1';\n        $params = [];\n\n        if ($status !== null) {\n            $sql .= ' AND status = :status';\n            $params['status'] = $status;\n        }\n\n        if ($parentId !== null) {\n            $sql .= ' AND parent_id = :parent_id';\n            $params['parent_id'] = $parentId;\n        }\n\n        if ($search !== null) {\n            $sql .= ' AND (title LIKE :search OR description LIKE :search2)';\n            $params['search'] = '%' . $search . '%';\n            $params['search2'] = '%' . $search . '%';\n        }\n\n        $sql .= ' ORDER BY depth ASC, sort_order ASC LIMIT :limit OFFSET :offset';\n\n        $stmt = $this->pdo->prepare($sql);\n\n        foreach ($params as $key => $value) {\n            $stmt->bindValue($key, $value);\n        }\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();\n    }\n\n    \/**\n     * Count documents with optional filters.\n     *\/\n    public function count(\n        ?string $status = null,\n        ?int $parentId = null,\n        ?string $search = null\n    ): int {\n        $sql = 'SELECT COUNT(*) FROM dokumentation WHERE 1=1';\n        $params = [];\n\n        if ($status !== null) {\n            $sql .= ' AND status = :status';\n            $params['status'] = $status;\n        }\n\n        if ($parentId !== null) {\n            $sql .= ' AND parent_id = :parent_id';\n            $params['parent_id'] = $parentId;\n        }\n\n        if ($search !== null) {\n            $sql .= ' AND (title LIKE :search OR description 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     * Create a new document.\n     *\/\n    public function create(array $data): int\n    {\n        \/\/ Determine path and depth\n        $parentId = $data['parent_id'] ?? null;\n        $slug = $data['slug'];\n\n        if ($parentId !== null) {\n            $parent = $this->findById((int) $parentId);\n            $path = ($parent['path'] ?? '') . '\/' . $slug;\n            $depth = ($parent['depth'] ?? 0) + 1;\n        } else {\n            $path = '\/' . $slug;\n            $depth = 0;\n        }\n\n        $stmt = $this->pdo->prepare('\n            INSERT INTO dokumentation (parent_id, slug, path, depth, title, description, content, content_format, status, sort_order, created_at, updated_at)\n            VALUES (:parent_id, :slug, :path, :depth, :title, :description, :content, :format, :status, :sort_order, NOW(), NOW())\n        ');\n\n        $stmt->execute([\n            'parent_id' => $parentId,\n            'slug' => $slug,\n            'path' => $path,\n            'depth' => $depth,\n            'title' => $data['title'],\n            'description' => $data['description'] ?? null,\n            'content' => $data['content'] ?? '',\n            'format' => $data['content_format'] ?? 'html',\n            'status' => $data['status'] ?? 'draft',\n            'sort_order' => $data['sort_order'] ?? 0,\n        ]);\n\n        return (int) $this->pdo->lastInsertId();\n    }\n\n    \/**\n     * Update a document.\n     *\/\n    public function update(int $id, array $data): void\n    {\n        $fields = [];\n        $params = ['id' => $id];\n\n        foreach (['title', 'content', 'description', 'status'] as $field) {\n            if (array_key_exists($field, $data)) {\n                $fields[] = \"{$field} = :{$field}\";\n                $params[$field] = $data[$field];\n            }\n        }\n\n        if (empty($fields)) {\n            return;\n        }\n\n        $fields[] = 'updated_at = NOW()';\n        $fields[] = 'version = version + 1';\n\n        $sql = 'UPDATE dokumentation SET ' . implode(', ', $fields) . ' WHERE id = :id';\n\n        $stmt = $this->pdo->prepare($sql);\n        $stmt->execute($params);\n    }\n\n    \/**\n     * Delete a document.\n     *\/\n    public function delete(int $id): void\n    {\n        $stmt = $this->pdo->prepare('DELETE FROM dokumentation WHERE id = :id');\n        $stmt->execute(['id' => $id]);\n    }\n\n    \/**\n     * Get document tree (alias for getHierarchy).\n     *\/\n    public function getTree(): array\n    {\n        return $this->getHierarchy();\n    }\n}\n",
            "numLines": 316,
            "startLine": 1,
            "totalLines": 316
        }
    }
}