{
"event": "PreToolUse",
"tool_name": "Edit",
"tool_input": {
"file_path": "\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/DokumentationRepository.php",
"old_string": " 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}",
"new_string": " 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}"
}
}
{
"tool_response": {
"filePath": "\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/DokumentationRepository.php",
"oldString": " 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}",
"newString": " 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}",
"originalFile": "<?php\n\nnamespace Infrastructure\\Persistence;\n\nuse Domain\\Repository\\DokumentationRepositoryInterface;\nuse Infrastructure\\Config\\DatabaseFactory;\n\nclass DokumentationRepository implements DokumentationRepositoryInterface\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": 148,
"oldLines": 4,
"newStart": 148,
"newLines": 165,
"lines": [
" ",
" return $stats;",
" }",
"+",
"+ \/**",
"+ * Find all documents with optional filters.",
"+ *\/",
"+ public function findAll(",
"+ ?string $status = null,",
"+ ?int $parentId = null,",
"+ ?string $search = null,",
"+ int $limit = 50,",
"+ int $offset = 0",
"+ ): array {",
"+ $sql = 'SELECT * FROM dokumentation WHERE 1=1';",
"+ $params = [];",
"+",
"+ if ($status !== null) {",
"+ $sql .= ' AND status = :status';",
"+ $params['status'] = $status;",
"+ }",
"+",
"+ if ($parentId !== null) {",
"+ $sql .= ' AND parent_id = :parent_id';",
"+ $params['parent_id'] = $parentId;",
"+ }",
"+",
"+ if ($search !== null) {",
"+ $sql .= ' AND (title LIKE :search OR description LIKE :search2)';",
"+ $params['search'] = '%' . $search . '%';",
"+ $params['search2'] = '%' . $search . '%';",
"+ }",
"+",
"+ $sql .= ' ORDER BY depth ASC, sort_order ASC LIMIT :limit OFFSET :offset';",
"+",
"+ $stmt = $this->pdo->prepare($sql);",
"+",
"+ foreach ($params as $key => $value) {",
"+ $stmt->bindValue($key, $value);",
"+ }",
"+",
"+ $stmt->bindValue('limit', $limit, \\PDO::PARAM_INT);",
"+ $stmt->bindValue('offset', $offset, \\PDO::PARAM_INT);",
"+ $stmt->execute();",
"+",
"+ return $stmt->fetchAll();",
"+ }",
"+",
"+ \/**",
"+ * Count documents with optional filters.",
"+ *\/",
"+ public function count(",
"+ ?string $status = null,",
"+ ?int $parentId = null,",
"+ ?string $search = null",
"+ ): int {",
"+ $sql = 'SELECT COUNT(*) FROM dokumentation WHERE 1=1';",
"+ $params = [];",
"+",
"+ if ($status !== null) {",
"+ $sql .= ' AND status = :status';",
"+ $params['status'] = $status;",
"+ }",
"+",
"+ if ($parentId !== null) {",
"+ $sql .= ' AND parent_id = :parent_id';",
"+ $params['parent_id'] = $parentId;",
"+ }",
"+",
"+ if ($search !== null) {",
"+ $sql .= ' AND (title LIKE :search OR description LIKE :search2)';",
"+ $params['search'] = '%' . $search . '%';",
"+ $params['search2'] = '%' . $search . '%';",
"+ }",
"+",
"+ $stmt = $this->pdo->prepare($sql);",
"+ $stmt->execute($params);",
"+",
"+ return (int) $stmt->fetchColumn();",
"+ }",
"+",
"+ \/**",
"+ * Create a new document.",
"+ *\/",
"+ public function create(array $data): int",
"+ {",
"+ \/\/ Determine path and depth",
"+ $parentId = $data['parent_id'] ?? null;",
"+ $slug = $data['slug'];",
"+",
"+ if ($parentId !== null) {",
"+ $parent = $this->findById((int) $parentId);",
"+ $path = ($parent['path'] ?? '') . '\/' . $slug;",
"+ $depth = ($parent['depth'] ?? 0) + 1;",
"+ } else {",
"+ $path = '\/' . $slug;",
"+ $depth = 0;",
"+ }",
"+",
"+ $stmt = $this->pdo->prepare('",
"+ INSERT INTO dokumentation (parent_id, slug, path, depth, title, description, content, content_format, status, sort_order, created_at, updated_at)",
"+ VALUES (:parent_id, :slug, :path, :depth, :title, :description, :content, :format, :status, :sort_order, NOW(), NOW())",
"+ ');",
"+",
"+ $stmt->execute([",
"+ 'parent_id' => $parentId,",
"+ 'slug' => $slug,",
"+ 'path' => $path,",
"+ 'depth' => $depth,",
"+ 'title' => $data['title'],",
"+ 'description' => $data['description'] ?? null,",
"+ 'content' => $data['content'] ?? '',",
"+ 'format' => $data['content_format'] ?? 'html',",
"+ 'status' => $data['status'] ?? 'draft',",
"+ 'sort_order' => $data['sort_order'] ?? 0,",
"+ ]);",
"+",
"+ return (int) $this->pdo->lastInsertId();",
"+ }",
"+",
"+ \/**",
"+ * Update a document.",
"+ *\/",
"+ public function update(int $id, array $data): void",
"+ {",
"+ $fields = [];",
"+ $params = ['id' => $id];",
"+",
"+ foreach (['title', 'content', 'description', 'status'] as $field) {",
"+ if (array_key_exists($field, $data)) {",
"+ $fields[] = \"{$field} = :{$field}\";",
"+ $params[$field] = $data[$field];",
"+ }",
"+ }",
"+",
"+ if (empty($fields)) {",
"+ return;",
"+ }",
"+",
"+ $fields[] = 'updated_at = NOW()';",
"+ $fields[] = 'version = version + 1';",
"+",
"+ $sql = 'UPDATE dokumentation SET ' . implode(', ', $fields) . ' WHERE id = :id';",
"+",
"+ $stmt = $this->pdo->prepare($sql);",
"+ $stmt->execute($params);",
"+ }",
"+",
"+ \/**",
"+ * Delete a document.",
"+ *\/",
"+ public function delete(int $id): void",
"+ {",
"+ $stmt = $this->pdo->prepare('DELETE FROM dokumentation WHERE id = :id');",
"+ $stmt->execute(['id' => $id]);",
"+ }",
"+",
"+ \/**",
"+ * Get document tree (alias for getHierarchy).",
"+ *\/",
"+ public function getTree(): array",
"+ {",
"+ return $this->getHierarchy();",
"+ }",
" }"
]
}
],
"userModified": false,
"replaceAll": false
}
}