{
"event": "PreToolUse",
"tool_name": "Edit",
"tool_input": {
"file_path": "\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/DokumentationRepository.php",
"old_string": "namespace Infrastructure\\Persistence;\n\nuse Infrastructure\\Config\\DatabaseFactory;\n\nclass DokumentationRepository\n{",
"new_string": "namespace Infrastructure\\Persistence;\n\nuse Domain\\Repository\\DokumentationRepositoryInterface;\nuse Infrastructure\\Config\\DatabaseFactory;\n\nclass DokumentationRepository implements DokumentationRepositoryInterface\n{"
}
}
{
"tool_response": {
"filePath": "\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/DokumentationRepository.php",
"oldString": "namespace Infrastructure\\Persistence;\n\nuse Infrastructure\\Config\\DatabaseFactory;\n\nclass DokumentationRepository\n{",
"newString": "namespace Infrastructure\\Persistence;\n\nuse Domain\\Repository\\DokumentationRepositoryInterface;\nuse Infrastructure\\Config\\DatabaseFactory;\n\nclass DokumentationRepository implements DokumentationRepositoryInterface\n{",
"originalFile": "<?php\n\nnamespace Infrastructure\\Persistence;\n\nuse Infrastructure\\Config\\DatabaseFactory;\n\nclass DokumentationRepository\n{\n private \\PDO $pdo;\n\n public function __construct()\n {\n $this->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",
"structuredPatch": [
{
"oldStart": 2,
"oldLines": 9,
"newStart": 2,
"newLines": 10,
"lines": [
" ",
" namespace Infrastructure\\Persistence;",
" ",
"+use Domain\\Repository\\DokumentationRepositoryInterface;",
" use Infrastructure\\Config\\DatabaseFactory;",
" ",
"-class DokumentationRepository",
"+class DokumentationRepository implements DokumentationRepositoryInterface",
" {",
" private \\PDO $pdo;",
" "
]
}
],
"userModified": false,
"replaceAll": false
}
}