{
"event": "PreToolUse",
"tool_name": "Read",
"tool_input": {
"file_path": "\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/DokumentationRepository.php",
"limit": 150
}
}
{
"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;\nuse Infrastructure\\Config\\DatabaseFactory;\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');",
"numLines": 150,
"startLine": 1,
"totalLines": 317
}
}
}