Protokoll #2477

{
    "event": "PreToolUse",
    "tool_name": "Edit",
    "tool_input": {
        "file_path": "\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/ContentRepository.php",
        "old_string": "        return $result !== false ? $result : null;\n    }\n\n    public function createOrder(array $data): int",
        "new_string": "        return $result !== false ? $result : null;\n    }\n\n    \/**\n     * Get settings from the last created order as defaults for new orders.\n     *\n     * @return array{model: string, collections: array<string>, context_limit: int, author_profile_id: int|null, contract_id: int|null, structure_id: int|null}\n     *\/\n    public function getLastOrderSettings(): array\n    {\n        $stmt = $this->pdo->query('\n            SELECT model, collections, context_limit, author_profile_id, contract_id, structure_id\n            FROM content_orders\n            ORDER BY id DESC\n            LIMIT 1\n        ');\n        $row = $stmt->fetch(\\PDO::FETCH_ASSOC);\n\n        if (!$row) {\n            return [\n                'model' => 'claude-sonnet-4-20250514',\n                'collections' => ['documents'],\n                'context_limit' => 5,\n                'author_profile_id' => null,\n                'contract_id' => null,\n                'structure_id' => null,\n            ];\n        }\n\n        return [\n            'model' => $row['model'] ?? 'claude-sonnet-4-20250514',\n            'collections' => json_decode($row['collections'] ?? '[\"documents\"]', true) ?: ['documents'],\n            'context_limit' => (int) ($row['context_limit'] ?? 5),\n            'author_profile_id' => $row['author_profile_id'] !== null ? (int) $row['author_profile_id'] : null,\n            'contract_id' => $row['contract_id'] !== null ? (int) $row['contract_id'] : null,\n            'structure_id' => $row['structure_id'] !== null ? (int) $row['structure_id'] : null,\n        ];\n    }\n\n    public function createOrder(array $data): int"
    }
}

{
    "tool_response": {
        "filePath": "\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/ContentRepository.php",
        "oldString": "        return $result !== false ? $result : null;\n    }\n\n    public function createOrder(array $data): int",
        "newString": "        return $result !== false ? $result : null;\n    }\n\n    \/**\n     * Get settings from the last created order as defaults for new orders.\n     *\n     * @return array{model: string, collections: array<string>, context_limit: int, author_profile_id: int|null, contract_id: int|null, structure_id: int|null}\n     *\/\n    public function getLastOrderSettings(): array\n    {\n        $stmt = $this->pdo->query('\n            SELECT model, collections, context_limit, author_profile_id, contract_id, structure_id\n            FROM content_orders\n            ORDER BY id DESC\n            LIMIT 1\n        ');\n        $row = $stmt->fetch(\\PDO::FETCH_ASSOC);\n\n        if (!$row) {\n            return [\n                'model' => 'claude-sonnet-4-20250514',\n                'collections' => ['documents'],\n                'context_limit' => 5,\n                'author_profile_id' => null,\n                'contract_id' => null,\n                'structure_id' => null,\n            ];\n        }\n\n        return [\n            'model' => $row['model'] ?? 'claude-sonnet-4-20250514',\n            'collections' => json_decode($row['collections'] ?? '[\"documents\"]', true) ?: ['documents'],\n            'context_limit' => (int) ($row['context_limit'] ?? 5),\n            'author_profile_id' => $row['author_profile_id'] !== null ? (int) $row['author_profile_id'] : null,\n            'contract_id' => $row['contract_id'] !== null ? (int) $row['contract_id'] : null,\n            'structure_id' => $row['structure_id'] !== null ? (int) $row['structure_id'] : null,\n        ];\n    }\n\n    public function createOrder(array $data): int",
        "originalFile": "<?php\n\nnamespace Infrastructure\\Persistence;\n\nuse Infrastructure\\Config\\DatabaseFactory;\n\nclass ContentRepository\n{\n    private \\PDO $pdo;\n\n    public function __construct()\n    {\n        $this->pdo = DatabaseFactory::content();\n    }\n\n    \/\/ ==================== Orders ====================\n\n    public function findAllOrders(array $filters = [], int $limit = 50, int $offset = 0): array\n    {\n        $sql = 'SELECT co.*,\n                       ap.name as profile_name,\n                       cc.name as contract_name,\n                       cs.name as structure_name,\n                       (SELECT COUNT(*) FROM content_versions WHERE order_id = co.id) as version_count\n                FROM content_orders co\n                LEFT JOIN content_config ap ON co.author_profile_id = ap.id AND ap.type = \"author_profile\"\n                LEFT JOIN content_config cc ON co.contract_id = cc.id AND cc.type = \"contract\"\n                LEFT JOIN content_config cs ON co.structure_id = cs.id AND cs.type = \"structure\"\n                WHERE 1=1';\n\n        $params = [];\n\n        if (isset($filters['status']) && $filters['status'] !== '') {\n            $sql .= ' AND co.status = :status';\n            $params['status'] = $filters['status'];\n        }\n\n        if (isset($filters['profile_id']) && $filters['profile_id'] !== '') {\n            $sql .= ' AND co.author_profile_id = :profile_id';\n            $params['profile_id'] = $filters['profile_id'];\n        }\n\n        $sql .= ' ORDER BY co.updated_at DESC LIMIT :limit OFFSET :offset';\n\n        $stmt = $this->pdo->prepare($sql);\n        foreach ($params as $key => $value) {\n            $stmt->bindValue(':' . $key, $value);\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    public function findOrder(int $id): ?array\n    {\n        $stmt = $this->pdo->prepare('\n            SELECT co.*,\n                   ap.name as profile_name, ap.content as profile_config,\n                   cc.name as contract_name, cc.content as contract_config,\n                   cs.name as structure_name, cs.content as structure_config\n            FROM content_orders co\n            LEFT JOIN content_config ap ON co.author_profile_id = ap.id AND ap.type = \"author_profile\"\n            LEFT JOIN content_config cc ON co.contract_id = cc.id AND cc.type = \"contract\"\n            LEFT JOIN content_config cs ON co.structure_id = cs.id AND cs.type = \"structure\"\n            WHERE co.id = :id\n        ');\n        $stmt->execute(['id' => $id]);\n        $result = $stmt->fetch();\n\n        return $result !== false ? $result : null;\n    }\n\n    public function createOrder(array $data): int\n    {\n        $stmt = $this->pdo->prepare(\"\n            INSERT INTO content_orders\n            (title, briefing, author_profile_id, contract_id, structure_id, model, collections, context_limit, status)\n            VALUES (:title, :briefing, :profile_id, :contract_id, :structure_id, :model, :collections, :context_limit, 'draft')\n        \");\n\n        $stmt->execute([\n            'title' => $data['title'],\n            'briefing' => $data['briefing'],\n            'profile_id' => ($data['author_profile_id'] !== '' && $data['author_profile_id'] !== null) ? $data['author_profile_id'] : null,\n            'contract_id' => ($data['contract_id'] !== '' && $data['contract_id'] !== null) ? $data['contract_id'] : null,\n            'structure_id' => ($data['structure_id'] !== '' && $data['structure_id'] !== null) ? $data['structure_id'] : null,\n            'model' => $data['model'] ?? 'claude-sonnet-4-20250514',\n            'collections' => $data['collections'] ?? '[\"documents\"]',\n            'context_limit' => $data['context_limit'] ?? 5,\n        ]);\n\n        return (int) $this->pdo->lastInsertId();\n    }\n\n    public function updateOrderStatus(int $id, string $status): void\n    {\n        $stmt = $this->pdo->prepare('\n            UPDATE content_orders SET status = :status, updated_at = NOW() WHERE id = :id\n        ');\n        $stmt->execute(['id' => $id, 'status' => $status]);\n    }\n\n    public function updateOrder(int $id, array $data): bool\n    {\n        $stmt = $this->pdo->prepare('\n            UPDATE content_orders SET\n                title = :title,\n                briefing = :briefing,\n                author_profile_id = :profile_id,\n                contract_id = :contract_id,\n                structure_id = :structure_id,\n                updated_at = NOW()\n            WHERE id = :id\n        ');\n\n        return $stmt->execute([\n            'id' => $id,\n            'title' => $data['title'],\n            'briefing' => $data['briefing'],\n            'profile_id' => ($data['author_profile_id'] !== '' && $data['author_profile_id'] !== null) ? $data['author_profile_id'] : null,\n            'contract_id' => ($data['contract_id'] !== '' && $data['contract_id'] !== null) ? $data['contract_id'] : null,\n            'structure_id' => ($data['structure_id'] !== '' && $data['structure_id'] !== null) ? $data['structure_id'] : null,\n        ]);\n    }\n\n    \/\/ ==================== Versions ====================\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    \/\/ ==================== Critiques ====================\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 = json_decode($row['feedback'], true);\n                if (is_array($feedback)) {\n                    $row = array_merge($row, $feedback);\n                }\n            }\n        }\n\n        return $results;\n    }\n\n    \/\/ ==================== Sources ====================\n\n    public function findSourcesByOrder(int $orderId): array\n    {\n        $stmt = $this->pdo->prepare('\n            SELECT cs.*, c.content, d.filename as document_name\n            FROM content_sources cs\n            JOIN chunks c ON cs.chunk_id = c.id\n            JOIN documents d ON c.document_id = d.id\n            WHERE cs.order_id = :order_id\n            ORDER BY cs.relevance_score DESC\n        ');\n        $stmt->execute(['order_id' => $orderId]);\n\n        return $stmt->fetchAll();\n    }\n\n    \/\/ ==================== Profiles ====================\n\n    public function findAllProfiles(): array\n    {\n        $stmt = $this->pdo->query(\"\n            SELECT id, name, slug, content as config\n            FROM content_config\n            WHERE type = 'author_profile' AND status = 'active'\n            ORDER BY name\n        \");\n\n        return $stmt->fetchAll();\n    }\n\n    \/\/ ==================== Contracts ====================\n\n    public function findAllContracts(): array\n    {\n        $stmt = $this->pdo->query(\"\n            SELECT id, name, slug, content as config\n            FROM content_config\n            WHERE type = 'contract' AND status = 'active'\n            ORDER BY name\n        \");\n\n        return $stmt->fetchAll();\n    }\n\n    \/\/ ==================== Structures ====================\n\n    public function findAllStructures(): array\n    {\n        $stmt = $this->pdo->query(\"\n            SELECT id, name, slug, content as config\n            FROM content_config\n            WHERE type = 'structure' AND status = 'active'\n            ORDER BY name\n        \");\n\n        return $stmt->fetchAll();\n    }\n\n    \/\/ ==================== Critics ====================\n\n    public function findAllCritics(): array\n    {\n        $stmt = $this->pdo->query('\n            SELECT * FROM critics WHERE is_active = 1 ORDER BY sort_order\n        ');\n\n        return $stmt->fetchAll();\n    }\n\n    \/\/ ==================== Statistics ====================\n\n    public function getStatistics(): array\n    {\n        $stats = [];\n\n        $stmt = $this->pdo->query('SELECT COUNT(*) FROM content_orders');\n        $stats['total_orders'] = (int) $stmt->fetchColumn();\n\n        $stmt = $this->pdo->query('SELECT status, COUNT(*) as count FROM content_orders GROUP BY status');\n        $stats['by_status'] = $stmt->fetchAll(\\PDO::FETCH_KEY_PAIR);\n\n        $stmt = $this->pdo->query('SELECT COUNT(*) FROM content_versions');\n        $stats['total_versions'] = (int) $stmt->fetchColumn();\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": 72,
                "oldLines": 6,
                "newStart": 72,
                "newLines": 42,
                "lines": [
                    "         return $result !== false ? $result : null;",
                    "     }",
                    " ",
                    "+    \/**",
                    "+     * Get settings from the last created order as defaults for new orders.",
                    "+     *",
                    "+     * @return array{model: string, collections: array<string>, context_limit: int, author_profile_id: int|null, contract_id: int|null, structure_id: int|null}",
                    "+     *\/",
                    "+    public function getLastOrderSettings(): array",
                    "+    {",
                    "+        $stmt = $this->pdo->query('",
                    "+            SELECT model, collections, context_limit, author_profile_id, contract_id, structure_id",
                    "+            FROM content_orders",
                    "+            ORDER BY id DESC",
                    "+            LIMIT 1",
                    "+        ');",
                    "+        $row = $stmt->fetch(\\PDO::FETCH_ASSOC);",
                    "+",
                    "+        if (!$row) {",
                    "+            return [",
                    "+                'model' => 'claude-sonnet-4-20250514',",
                    "+                'collections' => ['documents'],",
                    "+                'context_limit' => 5,",
                    "+                'author_profile_id' => null,",
                    "+                'contract_id' => null,",
                    "+                'structure_id' => null,",
                    "+            ];",
                    "+        }",
                    "+",
                    "+        return [",
                    "+            'model' => $row['model'] ?? 'claude-sonnet-4-20250514',",
                    "+            'collections' => json_decode($row['collections'] ?? '[\"documents\"]', true) ?: ['documents'],",
                    "+            'context_limit' => (int) ($row['context_limit'] ?? 5),",
                    "+            'author_profile_id' => $row['author_profile_id'] !== null ? (int) $row['author_profile_id'] : null,",
                    "+            'contract_id' => $row['contract_id'] !== null ? (int) $row['contract_id'] : null,",
                    "+            'structure_id' => $row['structure_id'] !== null ? (int) $row['structure_id'] : null,",
                    "+        ];",
                    "+    }",
                    "+",
                    "     public function createOrder(array $data): int",
                    "     {",
                    "         $stmt = $this->pdo->prepare(\""
                ]
            }
        ],
        "userModified": false,
        "replaceAll": false
    }
}