Protokoll #14287

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

{
    "tool_response": {
        "filePath": "\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/ContentConfigRepository.php",
        "oldString": "\/\/ @responsibility: Persistenz für Content-Konfiguration (Profile, Contracts, Strukturen)\n\nuse Infrastructure\\Config\\DatabaseFactory;",
        "newString": "\/\/ @responsibility: Persistenz für Content-Konfiguration (Profile, Contracts, Strukturen)",
        "originalFile": "<?php\n\ndeclare(strict_types=1);\n\nnamespace Infrastructure\\Persistence;\n\n\/\/ @responsibility: Persistenz für Content-Konfiguration (Profile, Contracts, Strukturen)\n\nuse Infrastructure\\Config\\DatabaseFactory;\n\nclass ContentConfigRepository\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 parent_name\n             FROM content_config c\n             LEFT JOIN content_config p ON c.parent_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 findByIdAndType(int $id, string $type): ?array\n    {\n        $stmt = $this->pdo->prepare(\n            \"SELECT id, name, slug, content, type, status\n             FROM content_config\n             WHERE id = ? AND type = ? AND status = 'active'\"\n        );\n        $stmt->execute([$id, $type]);\n        $result = $stmt->fetch(\\PDO::FETCH_ASSOC);\n\n        return $result !== false ? $result : null;\n    }\n\n    public function findAll(?string $typeFilter = null, ?string $statusFilter = null): array\n    {\n        $sql = 'SELECT c.*, p.name as parent_name\n                FROM content_config c\n                LEFT JOIN content_config p ON c.parent_id = p.id\n                WHERE 1=1';\n        $params = [];\n\n        if ($typeFilter !== null && $typeFilter !== '') {\n            $sql .= ' AND c.type = ?';\n            $params[] = $typeFilter;\n        }\n\n        if ($statusFilter !== null && $statusFilter !== '') {\n            $sql .= ' AND c.status = ?';\n            $params[] = $statusFilter;\n        }\n\n        $sql .= ' ORDER BY c.type, c.name';\n\n        $stmt = $this->pdo->prepare($sql);\n        $stmt->execute($params);\n\n        return $stmt->fetchAll(\\PDO::FETCH_ASSOC);\n    }\n\n    public function findAllByType(string $type): array\n    {\n        $stmt = $this->pdo->prepare(\n            \"SELECT id, name, slug, content, type, status\n             FROM content_config\n             WHERE type = ? AND status = 'active'\n             ORDER BY name\"\n        );\n        $stmt->execute([$type]);\n\n        return $stmt->fetchAll(\\PDO::FETCH_ASSOC);\n    }\n\n    public function create(\n        string $type,\n        string $name,\n        string $slug,\n        ?string $description,\n        string $content,\n        string $version,\n        string $status,\n        ?int $parentId\n    ): int {\n        $stmt = $this->pdo->prepare(\n            'INSERT INTO content_config (type, name, slug, description, content, version, status, parent_id)\n             VALUES (?, ?, ?, ?, ?, ?, ?, ?)'\n        );\n        $stmt->execute([$type, $name, $slug, $description, $content, $version, $status, $parentId]);\n\n        return (int) $this->pdo->lastInsertId();\n    }\n\n    public function update(\n        int $id,\n        string $name,\n        string $slug,\n        ?string $description,\n        string $content,\n        string $version,\n        string $status,\n        ?int $parentId\n    ): void {\n        $stmt = $this->pdo->prepare(\n            'UPDATE content_config\n             SET name = ?, slug = ?, description = ?, content = ?, version = ?, status = ?, parent_id = ?\n             WHERE id = ?'\n        );\n        $stmt->execute([$name, $slug, $description, $content, $version, $status, $parentId, $id]);\n    }\n\n    public function delete(int $id): void\n    {\n        $stmt = $this->pdo->prepare('DELETE FROM content_config WHERE id = ?');\n        $stmt->execute([$id]);\n    }\n\n    public function saveHistory(int $configId, string $content, string $version, string $changedBy, string $changeDescription): void\n    {\n        $stmt = $this->pdo->prepare(\n            'INSERT INTO content_config_history (config_id, content, version, changed_by, change_description)\n             VALUES (?, ?, ?, ?, ?)'\n        );\n        $stmt->execute([$configId, $content, $version, $changedBy, $changeDescription]);\n    }\n\n    public function deleteHistory(int $configId): void\n    {\n        $stmt = $this->pdo->prepare('DELETE FROM content_config_history WHERE config_id = ?');\n        $stmt->execute([$configId]);\n    }\n\n    public function countChildren(int $parentId): int\n    {\n        $stmt = $this->pdo->prepare('SELECT COUNT(*) FROM content_config WHERE parent_id = ?');\n        $stmt->execute([$parentId]);\n\n        return (int) $stmt->fetchColumn();\n    }\n\n    public function getChildren(int $parentId): array\n    {\n        $stmt = $this->pdo->prepare('SELECT * FROM content_config WHERE parent_id = ? ORDER BY name');\n        $stmt->execute([$parentId]);\n\n        return $stmt->fetchAll(\\PDO::FETCH_ASSOC);\n    }\n\n    public function getHistory(int $configId, int $limit = 10): array\n    {\n        $stmt = $this->pdo->prepare(\n            'SELECT * FROM content_config_history WHERE config_id = ? ORDER BY created_at DESC LIMIT ?'\n        );\n        $stmt->bindValue(1, $configId, \\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 getParentOptions(?int $excludeId = null): array\n    {\n        $stmt = $this->pdo->query(\n            'SELECT id, type, name FROM content_config WHERE type IN (\"contract\", \"organization\") ORDER BY type, name'\n        );\n        $parents = [];\n        foreach ($stmt->fetchAll(\\PDO::FETCH_ASSOC) as $row) {\n            if ($excludeId !== null && (int) $row['id'] === $excludeId) {\n                continue;\n            }\n            $parents[] = $row;\n        }\n\n        return $parents;\n    }\n\n    public function getStatistics(): array\n    {\n        $stats = ['total' => 0, 'by_type' => [], 'by_status' => []];\n\n        $stmt = $this->pdo->query('SELECT type, COUNT(*) as cnt FROM content_config GROUP BY type');\n        foreach ($stmt->fetchAll(\\PDO::FETCH_ASSOC) as $row) {\n            $stats['by_type'][$row['type']] = (int) $row['cnt'];\n            $stats['total'] += (int) $row['cnt'];\n        }\n\n        $stmt = $this->pdo->query('SELECT status, COUNT(*) as cnt FROM content_config GROUP BY status');\n        foreach ($stmt->fetchAll(\\PDO::FETCH_ASSOC) as $row) {\n            $stats['by_status'][$row['status']] = (int) $row['cnt'];\n        }\n\n        return $stats;\n    }\n\n    public function getAuthorProfiles(): array\n    {\n        return $this->findAllByType('author_profile');\n    }\n\n    public function getSystemPrompts(): array\n    {\n        return $this->findAllByType('system_prompt');\n    }\n\n    public function getAuthorProfile(int $id): ?array\n    {\n        return $this->findByIdAndType($id, 'author_profile');\n    }\n\n    public function getSystemPrompt(int $id): ?array\n    {\n        return $this->findByIdAndType($id, 'system_prompt');\n    }\n\n    public function getStructures(): array\n    {\n        return $this->findAllByType('structure');\n    }\n\n    public function getStructure(int $id): ?array\n    {\n        return $this->findByIdAndType($id, 'structure');\n    }\n}\n",
        "structuredPatch": [
            {
                "oldStart": 6,
                "oldLines": 8,
                "newStart": 6,
                "newLines": 6,
                "lines": [
                    " ",
                    " \/\/ @responsibility: Persistenz für Content-Konfiguration (Profile, Contracts, Strukturen)",
                    " ",
                    "-use Infrastructure\\Config\\DatabaseFactory;",
                    "-",
                    " class ContentConfigRepository",
                    " {",
                    "     private \\PDO $pdo;"
                ]
            }
        ],
        "userModified": false,
        "replaceAll": false
    }
}