Protokoll #14285

{
    "event": "PreToolUse",
    "tool_name": "Edit",
    "tool_input": {
        "file_path": "\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/CriticsRepository.php",
        "old_string": "\/\/ @responsibility: Persistenz für Critic-Konfigurationen (Content-Bewertung)\n\nuse Infrastructure\\Config\\DatabaseFactory;",
        "new_string": "\/\/ @responsibility: Persistenz für Critic-Konfigurationen (Content-Bewertung)"
    }
}

{
    "tool_response": {
        "filePath": "\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/CriticsRepository.php",
        "oldString": "\/\/ @responsibility: Persistenz für Critic-Konfigurationen (Content-Bewertung)\n\nuse Infrastructure\\Config\\DatabaseFactory;",
        "newString": "\/\/ @responsibility: Persistenz für Critic-Konfigurationen (Content-Bewertung)",
        "originalFile": "<?php\n\ndeclare(strict_types=1);\n\nnamespace Infrastructure\\Persistence;\n\n\/\/ @responsibility: Persistenz für Critic-Konfigurationen (Content-Bewertung)\n\nuse Infrastructure\\Config\\DatabaseFactory;\n\nclass CriticsRepository\n{\n    private \\PDO $pdo;\n\n    public function __construct(?\\PDO $pdo = null)\n    {\n        $this->pdo = $pdo ?? DatabaseFactory::content();\n    }\n\n    public function findById(int $id): ?array\n    {\n        $stmt = $this->pdo->prepare('\n            SELECT c.*, p.name as prompt_name\n            FROM critics c\n            LEFT JOIN prompts p ON c.prompt_id = p.id\n            WHERE c.id = ?\n        ');\n        $stmt->execute([$id]);\n        $result = $stmt->fetch(\\PDO::FETCH_ASSOC);\n\n        return $result !== false ? $result : null;\n    }\n\n    public function findAll(): array\n    {\n        $stmt = $this->pdo->query('\n            SELECT c.*, p.name as prompt_name\n            FROM critics c\n            LEFT JOIN prompts p ON c.prompt_id = p.id\n            ORDER BY c.sort_order, c.name\n        ');\n\n        return $stmt->fetchAll(\\PDO::FETCH_ASSOC);\n    }\n\n    public function create(string $name, string $fokusJson, ?int $promptId, int $sortOrder, int $isActive): int\n    {\n        $stmt = $this->pdo->prepare('\n            INSERT INTO critics (name, fokus, prompt_id, sort_order, is_active)\n            VALUES (?, ?, ?, ?, ?)\n        ');\n        $stmt->execute([$name, $fokusJson, $promptId, $sortOrder, $isActive]);\n\n        return (int) $this->pdo->lastInsertId();\n    }\n\n    public function update(int $id, string $name, string $fokusJson, ?int $promptId, int $sortOrder, int $isActive): void\n    {\n        $stmt = $this->pdo->prepare('\n            UPDATE critics\n            SET name = ?, fokus = ?, prompt_id = ?, sort_order = ?, is_active = ?\n            WHERE id = ?\n        ');\n        $stmt->execute([$name, $fokusJson, $promptId, $sortOrder, $isActive, $id]);\n    }\n\n    public function delete(int $id): void\n    {\n        $stmt = $this->pdo->prepare('DELETE FROM critics WHERE id = ?');\n        $stmt->execute([$id]);\n    }\n\n    public function toggleActive(int $id, int $newStatus): void\n    {\n        $stmt = $this->pdo->prepare('UPDATE critics SET is_active = ? WHERE id = ?');\n        $stmt->execute([$newStatus, $id]);\n    }\n\n    public function countCritiques(int $criticId): int\n    {\n        $stmt = $this->pdo->prepare('SELECT COUNT(*) FROM content_critiques WHERE critic_id = ?');\n        $stmt->execute([$criticId]);\n\n        return (int) $stmt->fetchColumn();\n    }\n\n    public function findRecentCritiques(int $criticId, int $limit = 10): array\n    {\n        $stmt = $this->pdo->prepare('\n            SELECT cc.*, cv.version_number, co.title as order_title\n            FROM content_critiques cc\n            JOIN content_versions cv ON cc.version_id = cv.id\n            JOIN content_orders co ON cv.order_id = co.id\n            WHERE cc.critic_id = ?\n            ORDER BY cc.created_at DESC\n            LIMIT ?\n        ');\n        $stmt->bindValue(1, $criticId, \\PDO::PARAM_INT);\n        $stmt->bindValue(2, $limit, \\PDO::PARAM_INT);\n        $stmt->execute();\n\n        return $stmt->fetchAll(\\PDO::FETCH_ASSOC);\n    }\n\n    public function getStatistics(): array\n    {\n        $stats = ['total' => 0, 'active' => 0, 'inactive' => 0, 'total_critiques' => 0];\n\n        $stmt = $this->pdo->query('SELECT COUNT(*) as cnt, SUM(is_active) as active FROM critics');\n        $row = $stmt->fetch(\\PDO::FETCH_ASSOC);\n        $stats['total'] = (int) $row['cnt'];\n        $stats['active'] = (int) $row['active'];\n        $stats['inactive'] = $stats['total'] - $stats['active'];\n\n        $stmt = $this->pdo->query('SELECT COUNT(*) FROM content_critiques');\n        $stats['total_critiques'] = (int) $stmt->fetchColumn();\n\n        return $stats;\n    }\n}\n",
        "structuredPatch": [
            {
                "oldStart": 6,
                "oldLines": 8,
                "newStart": 6,
                "newLines": 6,
                "lines": [
                    " ",
                    " \/\/ @responsibility: Persistenz für Critic-Konfigurationen (Content-Bewertung)",
                    " ",
                    "-use Infrastructure\\Config\\DatabaseFactory;",
                    "-",
                    " class CriticsRepository",
                    " {",
                    "     private \\PDO $pdo;"
                ]
            }
        ],
        "userModified": false,
        "replaceAll": false
    }
}