{
"event": "PreToolUse",
"tool_name": "Write",
"tool_input": {
"file_path": "\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/ContentVersionRepository.php",
"content": "<?php\n\ndeclare(strict_types=1);\n\nnamespace Infrastructure\\Persistence;\n\n\/\/ @responsibility: Persistenz für Content-Versions und Critiques\n\nuse Domain\\Repository\\ContentVersionRepositoryInterface;\nuse Infrastructure\\Traits\\JsonDecodeTrait;\n\nclass ContentVersionRepository implements ContentVersionRepositoryInterface\n{\n use JsonDecodeTrait;\n\n private \\PDO $pdo;\n\n public function __construct(\\PDO $pdo)\n {\n $this->pdo = $pdo;\n }\n\n public function findVersionsByOrder(int $orderId): array\n {\n $stmt = $this->pdo->prepare('\n SELECT * FROM content_versions\n WHERE order_id = :order_id\n ORDER BY version_number DESC\n ');\n $stmt->execute(['order_id' => $orderId]);\n\n return $stmt->fetchAll();\n }\n\n public function findLatestVersion(int $orderId): ?array\n {\n $stmt = $this->pdo->prepare('\n SELECT * FROM content_versions\n WHERE order_id = :order_id\n ORDER BY version_number DESC\n LIMIT 1\n ');\n $stmt->execute(['order_id' => $orderId]);\n $result = $stmt->fetch();\n\n return $result !== false ? $result : null;\n }\n\n public function findVersion(int $id): ?array\n {\n $stmt = $this->pdo->prepare('SELECT * FROM content_versions WHERE id = :id');\n $stmt->execute(['id' => $id]);\n $result = $stmt->fetch();\n\n return $result !== false ? $result : null;\n }\n\n public function findCritiquesByVersion(int $versionId): array\n {\n $stmt = $this->pdo->prepare('\n SELECT cc.*, c.name as critic_name\n FROM content_critiques cc\n JOIN critics c ON cc.critic_id = c.id\n WHERE cc.version_id = :version_id\n ORDER BY cc.round DESC, c.sort_order ASC\n ');\n $stmt->execute(['version_id' => $versionId]);\n\n $results = $stmt->fetchAll();\n\n \/\/ Parse feedback JSON and merge with row\n foreach ($results as &$row) {\n if (isset($row['feedback']) && $row['feedback'] !== '') {\n $feedback = $this->decodeJsonArray($row['feedback']);\n if ($feedback !== []) {\n $row = array_merge($row, $feedback);\n }\n }\n }\n\n return $results;\n }\n}\n"
}
}