{
"event": "PreToolUse",
"tool_name": "Edit",
"tool_input": {
"file_path": "\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/ContentVersionRepository.php",
"old_string": " 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 }",
"new_string": " 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 LEFT JOIN content_config c ON cc.critic_id = c.id AND c.type = 'critic'\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 }"
}
}
{
"tool_response": {
"filePath": "\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/ContentVersionRepository.php",
"oldString": " 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 }",
"newString": " 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 LEFT JOIN content_config c ON cc.critic_id = c.id AND c.type = 'critic'\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 }",
"originalFile": "<?php\n\ndeclare(strict_types=1);\n\nnamespace Infrastructure\\Persistence;\n\n\/\/ @responsibility: Persistenz für Content-Versions\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",
"structuredPatch": [
{
"oldStart": 57,
"oldLines": 13,
"newStart": 57,
"newLines": 13,
"lines": [
" ",
" public function findCritiquesByVersion(int $versionId): array",
" {",
"- $stmt = $this->pdo->prepare('",
"+ $stmt = $this->pdo->prepare(\"",
" SELECT cc.*, c.name as critic_name",
" FROM content_critiques cc",
"- JOIN critics c ON cc.critic_id = c.id",
"+ LEFT JOIN content_config c ON cc.critic_id = c.id AND c.type = 'critic'",
" WHERE cc.version_id = :version_id",
" ORDER BY cc.round DESC, c.sort_order ASC",
"- ');",
"+ \");",
" $stmt->execute(['version_id' => $versionId]);",
" ",
" $results = $stmt->fetchAll();"
]
}
],
"userModified": false,
"replaceAll": false
}
}