{
"tool_response": {
"filePath": "\/var\/www\/dev.campus.systemische-tools.de\/docs\/plan-form-components-refactoring.md",
"oldString": "```php\n\/\/ \/src\/Infrastructure\/Persistence\/UserPreferencesRepository.php\nclass UserPreferencesRepository\n{\n public function getForUser(int $userId = 1): array\n {\n $stmt = $this->db->prepare(\"\n SELECT * FROM user_preferences WHERE user_id = ?\n \");\n $stmt->execute([$userId]);\n return $stmt->fetch() ?: $this->getDefaults();\n }\n\n public function update(int $userId, array $data): void\n {\n \/\/ UPDATE user_preferences SET ... WHERE user_id = ?\n }\n\n private function getDefaults(): array\n {\n return [\n 'default_model_id' => null,\n 'default_temperature' => 0.70,\n 'default_max_tokens' => 4096,\n 'default_collections' => '[\"documents\"]',\n 'default_context_limit' => 5,\n \/\/ ...\n ];\n }\n}",
"newString": "```php\n\/\/ \/src\/Infrastructure\/Persistence\/UserPreferencesRepository.php\nclass UserPreferencesRepository\n{\n \/\/ JSON-Felder die validiert werden müssen\n private const JSON_FIELDS = [\n 'default_collections',\n 'default_contracts',\n 'default_structures',\n ];\n\n public function getForUser(int $userId = 1): array\n {\n $stmt = $this->db->prepare(\"\n SELECT * FROM user_preferences WHERE user_id = ?\n \");\n $stmt->execute([$userId]);\n $row = $stmt->fetch();\n\n if (!$row) {\n return $this->createDefaults($userId);\n }\n\n return $row;\n }\n\n public function update(int $userId, array $data): void\n {\n \/\/ KRITISCH: JSON-Validierung vor Speicherung\n $this->validateJsonFields($data);\n\n \/\/ Existenz-Prüfung für Referenzen\n $this->validateReferences($data);\n\n \/\/ UPDATE user_preferences SET ... WHERE user_id = ?\n $this->db->update('user_preferences', $data, ['user_id' => $userId]);\n }\n\n \/**\n * Validiert alle JSON-Felder vor Speicherung\n * @throws ValidationException\n *\/\n private function validateJsonFields(array $data): void\n {\n foreach (self::JSON_FIELDS as $field) {\n if (!isset($data[$field])) {\n continue;\n }\n\n $value = $data[$field];\n\n \/\/ Muss gültiges JSON sein\n if (is_string($value)) {\n $decoded = json_decode($value, true);\n if (json_last_error() !== JSON_ERROR_NONE) {\n throw new ValidationException(\"$field: Invalid JSON\");\n }\n $value = $decoded;\n }\n\n \/\/ Muss Array sein\n if (!is_array($value)) {\n throw new ValidationException(\"$field: Must be array\");\n }\n\n \/\/ Keine leeren Strings im Array\n foreach ($value as $item) {\n if ($item === '' || $item === null) {\n throw new ValidationException(\"$field: Empty values not allowed\");\n }\n }\n }\n }\n\n \/**\n * Prüft ob referenzierte Entities existieren\n * @throws ValidationException\n *\/\n private function validateReferences(array $data): void\n {\n \/\/ Model existiert?\n if (isset($data['default_model_id']) && $data['default_model_id']) {\n if (!$this->modelRepo->exists($data['default_model_id'])) {\n throw new ValidationException(\"Model not found: {$data['default_model_id']}\");\n }\n }\n\n \/\/ Collections existieren?\n if (isset($data['default_collections'])) {\n $ids = is_string($data['default_collections'])\n ? json_decode($data['default_collections'], true)\n : $data['default_collections'];\n\n foreach ($ids as $id) {\n if (!$this->collectionRepo->isActive($id)) {\n throw new ValidationException(\"Collection not active: $id\");\n }\n }\n }\n\n \/\/ Contracts existieren?\n if (isset($data['default_contracts'])) {\n $ids = is_string($data['default_contracts'])\n ? json_decode($data['default_contracts'], true)\n : $data['default_contracts'];\n\n foreach ($ids as $id) {\n if (!$this->configRepo->exists($id, 'contract')) {\n throw new ValidationException(\"Contract not found: $id\");\n }\n }\n }\n }\n\n private function createDefaults(int $userId): array\n {\n $defaults = $this->getDefaults();\n $this->db->insert('user_preferences', ['user_id' => $userId] + $defaults);\n return ['user_id' => $userId] + $defaults;\n }\n\n private function getDefaults(): array\n {\n return [\n 'default_model_id' => null,\n 'default_preset_id' => 2, \/\/ \"balanced\"\n 'default_temperature' => 0.70,\n 'default_max_tokens' => 4096,\n 'default_collections' => '[\"documents\"]',\n 'default_contracts' => '[]',\n 'default_structures' => '[]',\n 'default_context_limit' => 5,\n ];\n }\n}",
"originalFile": "# Plan: Einheitliche Form-Komponenten (Chat & Content Studio)\n\n## Status: PLANUNG\n**Erstellt:** 2025-12-21\n**Ziel:** DRY, KISS, SRP - Shared Partials für alle wiederverwendbaren Form-Elemente\n\n---\n\n## Projekt-Kontext (für externe Supervision)\n\n### Was ist das System?\n\n**Campus.systemische-tools.de** ist ein KI-gestütztes Content-Management-System mit zwei Hauptmodulen:\n\n| Modul | Beschreibung | Hauptfunktionen |\n|-------|--------------|-----------------|\n| **Chat-Interface** | RAG-basierte Konversation mit verschiedenen LLMs | Session-Management, Multi-Collection-Suche, Streaming-Responses |\n| **Content Studio** | Automatisierte Content-Generierung mit Qualitätssicherung | Briefing → Generierung → Kritik → Revision → Freigabe |\n\n### Warum dieses Refactoring?\n\n**Problem:**\n- Chat und Content Studio wurden unabhängig entwickelt\n- Gleiche UI-Elemente (Modell-Dropdown, Collections, etc.) existieren in unterschiedlichen Implementierungen\n- Inkonsistente UX: Modell-Dropdown mit\/ohne Optgroups, Collections als Multi-Select\/Checkboxes\/Single-Select\n\n**Symptome:**\n- Doppelter Code in Views\n- Unterschiedliche Variablennamen (`$profiles` vs `$authorProfiles`)\n- Keine zentrale Verwaltung für LLM-Modelle und Collections\n- Keine persistenten User-Präferenzen\n\n**Ziel:**\n- Einheitliche Partials für alle Form-Elemente\n- Zentrale Admin-Seiten für LLM-Modelle und Collections\n- User-Präferenzen mit 3-stufiger Werte-Hierarchie\n- Contracts und Structures in beiden Systemen nutzbar (Multi-Select)\n\n### Technologie-Stack\n\n| Schicht | Technologie | Details |\n|---------|-------------|---------|\n| **Backend** | PHP 8.2 | MVC-Pattern in `\/src\/` |\n| **Frontend** | HTML + HTMX | Reactive ohne SPA-Framework |\n| **Datenbank** | MariaDB 10.11 | Zwei Datenbanken (siehe unten) |\n| **Vector-DB** | Qdrant | RAG-Embeddings, Collections |\n| **LLM-APIs** | Anthropic Claude, Ollama | Cloud + lokal |\n| **Pipeline** | Python 3.11 | Content-Generierung, Embedding |\n| **Styling** | CSS Custom Properties | Theme-Support |\n\n### Datenbank-Architektur\n\n```\n┌─────────────────────────────────────────────────────────────────┐\n│ MariaDB │\n├─────────────────────────────┬───────────────────────────────────┤\n│ ki_dev │ ki_content │\n│ (Infrastruktur\/Config) │ (Laufzeitdaten) │\n├─────────────────────────────┼───────────────────────────────────┤\n│ • llm_models [NEU] │ • chat_sessions [ERWEITERT] │\n│ • llm_presets [NEU] │ • chat_messages │\n│ • rag_collections [NEU] │ • content_orders [MIGRIERT] │\n│ • user_preferences [NEU] │ • content_versions │\n│ • content_config │ • content_critiques │\n│ • tasks │ • content_sources │\n│ • contracts │ │\n│ • dokumentation │ │\n└─────────────────────────────┴───────────────────────────────────┘\n```\n\n### Externe Abhängigkeiten\n\n| Dienst | Verwendung | Ausfallverhalten |\n|--------|------------|------------------|\n| **Anthropic API** | Claude-Modelle, Chat-Completion | Fallback auf Ollama |\n| **Ollama (lokal)** | Lokale Modelle, Embeddings | Pflichtkomponente |\n| **Qdrant (lokal)** | Vektor-Suche, Collection-Metadaten | Pflichtkomponente |\n\n### Architektur-Prinzipien (angewendet)\n\n| Prinzip | Anwendung in diesem Plan |\n|---------|--------------------------|\n| **DRY** | Partials als Single Source für Form-Elemente |\n| **SRP** | Jedes Partial = eine Aufgabe |\n| **KISS** | Context Limit hardcoded, keine Over-Engineering |\n| **YAGNI** | Section 8 definiert klare Grenzen |\n| **MVC** | Controller → View (Partials) → Repository |\n\n### Wichtige Konventionen\n\n1. **MCP-Server:** Alle DB-Zugriffe via MCP-Tools (kein direktes SQL)\n2. **Kein Git:** Server ohne Versionskontrolle\n3. **Dev-First:** Entwicklung auf dev.campus, dann Sync zu prod\n4. **Quality-Gate:** `\/opt\/scripts\/php-check.sh` muss vor Sync bestehen\n\n---\n\n## 0. LLM-Verwaltung (Grundlage für Modell-Dropdown)\n\n### 0.1 Architektur-Entscheidung\n\n**Gewählt: Variante B - Dedizierte LLM-Verwaltung**\n\nStatt dynamischer API-Abfrage bei jedem Seitenaufruf:\n- Zentrale Admin-Seite `\/ressourcen\/llm`\n- Datenbank-Tabelle als Single Source of Truth\n- Sync-Buttons für Provider (Anthropic, Ollama, weitere)\n- Sprechende Namen und Zusatzmetadaten\n\n### 0.2 Datenbank-Tabelle `llm_models`\n\n```sql\nCREATE TABLE llm_models (\n id INT AUTO_INCREMENT PRIMARY KEY,\n provider ENUM('anthropic', 'ollama', 'openai', 'google', 'mistral', 'custom') NOT NULL,\n model_id VARCHAR(100) NOT NULL, -- API-ID: \"claude-opus-4-5-20251101\"\n display_name VARCHAR(100) NOT NULL, -- Anzeige: \"Claude Opus 4.5\"\n description TEXT, -- Kurzbeschreibung\n context_window INT, -- Max. Tokens Input: 200000\n max_output_tokens INT, -- Max. Tokens Output: 8192\n input_price_per_mtok DECIMAL(10,4), -- Preis Input $\/MTok\n output_price_per_mtok DECIMAL(10,4), -- Preis Output $\/MTok\n capabilities JSON, -- {\"vision\": true, \"function_calling\": true}\n is_local BOOLEAN DEFAULT FALSE, -- Lokal (Ollama) vs. Cloud\n is_active BOOLEAN DEFAULT TRUE, -- In Dropdowns anzeigen?\n sort_order INT DEFAULT 0, -- Reihenfolge in Dropdowns\n last_synced_at DATETIME, -- Letzte Synchronisation\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,\n UNIQUE KEY unique_provider_model (provider, model_id)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;\n```\n\n### 0.3 Admin-Seite `\/ressourcen\/llm`\n\n**URL:** `\/ressourcen\/llm`\n**Controller:** `RessourcenController::llmIndex()`\n\n**Funktionen:**\n\n| Button | Aktion |\n|--------|--------|\n| \"Anthropic synchronisieren\" | `GET api.anthropic.com\/v1\/models` → DB aktualisieren |\n| \"Ollama synchronisieren\" | `ollama list` → DB aktualisieren |\n| \"Neuer Provider\" | Manuell weiteren Provider hinzufügen |\n\n**Tabellen-Ansicht:**\n\n| Provider | Model-ID | Display-Name | Context | Preis In\/Out | Lokal | Aktiv | Aktionen |\n|----------|----------|--------------|---------|--------------|-------|-------|----------|\n| Anthropic | claude-opus-4-5-20251101 | Claude Opus 4.5 | 200k | $15\/$75 | - | ✓ | Bearbeiten |\n| Ollama | mistral:latest | Mistral 7B | 32k | - | ✓ | ✓ | Bearbeiten |\n\n**Bearbeiten-Dialog:**\n- Display-Name ändern\n- Beschreibung hinzufügen\n- Context-Window \/ Max-Output korrigieren\n- Preise eintragen (für Kostenberechnung)\n- Aktivieren\/Deaktivieren\n- Sortierung ändern\n\n### 0.4 Sync-Logik\n\n**Anthropic Sync:**\n```php\n\/\/ GET https:\/\/api.anthropic.com\/v1\/models\n\/\/ Response: {\"data\": [{\"id\": \"claude-opus-4-5-20251101\", ...}]}\n\nforeach ($apiModels as $model) {\n \/\/ INSERT ... ON DUPLICATE KEY UPDATE\n \/\/ Neue Modelle: is_active = true, display_name = model_id (initial)\n \/\/ Existierende: last_synced_at aktualisieren\n \/\/ Fehlende: NICHT löschen, nur last_synced_at bleibt alt\n}\n```\n\n**Ollama Sync:**\n```php\n\/\/ $ ollama list\n\/\/ NAME ID SIZE MODIFIED\n\/\/ mistral:latest abc123... 4.1 GB 2 days ago\n\n$output = shell_exec('ollama list');\n\/\/ Parsen und in DB einfügen\n```\n\n### 0.5 Dropdown-Query\n\n```php\n\/\/ ModelService::getActiveModels()\npublic function getActiveModels(): array\n{\n return $this->db->query(\"\n SELECT model_id, display_name, provider, is_local, context_window\n FROM llm_models\n WHERE is_active = 1\n ORDER BY is_local ASC, sort_order ASC, display_name ASC\n \")->fetchAll();\n}\n```\n\n### 0.6 Partial nutzt DB-Daten\n\n```php\n\/\/ \/src\/View\/partials\/form\/model-select.php\n<?php\n$models = $models ?? [];\n$selected = $selected ?? '';\n$variant = $variant ?? 'default';\n$class = $variant === 'inline' ? 'form-select--inline' : 'form-select';\n?>\n<select name=\"model\" id=\"model\" class=\"<?= $class ?>\">\n <optgroup label=\"Cloud\">\n <?php foreach ($models as $m): ?>\n <?php if (!$m['is_local']): ?>\n <option value=\"<?= $m['model_id'] ?>\" <?= $selected === $m['model_id'] ? 'selected' : '' ?>>\n <?= htmlspecialchars($m['display_name']) ?>\n <\/option>\n <?php endif; ?>\n <?php endforeach; ?>\n <\/optgroup>\n <optgroup label=\"Lokal\">\n <?php foreach ($models as $m): ?>\n <?php if ($m['is_local']): ?>\n <option value=\"<?= $m['model_id'] ?>\" <?= $selected === $m['model_id'] ? 'selected' : '' ?>>\n <?= htmlspecialchars($m['display_name']) ?>\n <\/option>\n <?php endif; ?>\n <?php endforeach; ?>\n <\/optgroup>\n<\/select>\n```\n\n### 0.7 Migrations-Schritte (LLM-Verwaltung)\n\n1. [ ] Tabelle `llm_models` in `ki_dev` erstellen\n2. [ ] `LlmModelRepository` erstellen\n3. [ ] `LlmSyncService` erstellen (Anthropic + Ollama)\n4. [ ] Route `\/ressourcen\/llm` anlegen\n5. [ ] `RessourcenController::llmIndex()` implementieren\n6. [ ] View `\/ressourcen\/llm\/index.php` erstellen\n7. [ ] Sync-Buttons implementieren\n8. [ ] Bearbeiten-Funktionalität\n9. [ ] Initial-Sync durchführen (bestehende Modelle importieren)\n10. [ ] `ModelConfig.php` durch `LlmModelRepository` ersetzen\n11. [ ] Partial `model-select.php` erstellen\n12. [ ] Chat und Content auf Partial umstellen\n\n---\n\n## 0b. Collection-Verwaltung (Grundlage für Collection-Dropdown)\n\n### 0b.1 Architektur-Entscheidung\n\n**Gewählt: DB-Tabelle analog zu LLMs**\n\n- Zentrale Admin-Seite `\/ressourcen\/collections`\n- Datenbank-Tabelle als Single Source of Truth\n- Sync mit Qdrant (Metadaten abrufen)\n- Sprechende Namen und Beschreibungen\n- **Multi-Select** als einheitliche Darstellung\n\n### 0b.2 Datenbank-Tabelle `rag_collections`\n\n```sql\nCREATE TABLE rag_collections (\n id INT AUTO_INCREMENT PRIMARY KEY,\n collection_id VARCHAR(100) NOT NULL UNIQUE, -- Qdrant-Name: \"documents\"\n display_name VARCHAR(100) NOT NULL, -- ... [TRUNCATED-735f23f6818d2c78]",
"structuredPatch": [
{
"oldStart": 565,
"oldLines": 29,
"newStart": 565,
"newLines": 134,
"lines": [
" \/\/ \/src\/Infrastructure\/Persistence\/UserPreferencesRepository.php",
" class UserPreferencesRepository",
" {",
"+ \/\/ JSON-Felder die validiert werden müssen",
"+ private const JSON_FIELDS = [",
"+ 'default_collections',",
"+ 'default_contracts',",
"+ 'default_structures',",
"+ ];",
"+",
" public function getForUser(int $userId = 1): array",
" {",
" $stmt = $this->db->prepare(\"",
" SELECT * FROM user_preferences WHERE user_id = ?",
" \");",
" $stmt->execute([$userId]);",
"- return $stmt->fetch() ?: $this->getDefaults();",
"+ $row = $stmt->fetch();",
"+",
"+ if (!$row) {",
"+ return $this->createDefaults($userId);",
"+ }",
"+",
"+ return $row;",
" }",
" ",
" public function update(int $userId, array $data): void",
" {",
"+ \/\/ KRITISCH: JSON-Validierung vor Speicherung",
"+ $this->validateJsonFields($data);",
"+",
"+ \/\/ Existenz-Prüfung für Referenzen",
"+ $this->validateReferences($data);",
"+",
" \/\/ UPDATE user_preferences SET ... WHERE user_id = ?",
"+ $this->db->update('user_preferences', $data, ['user_id' => $userId]);",
" }",
" ",
"+ \/**",
"+ * Validiert alle JSON-Felder vor Speicherung",
"+ * @throws ValidationException",
"+ *\/",
"+ private function validateJsonFields(array $data): void",
"+ {",
"+ foreach (self::JSON_FIELDS as $field) {",
"+ if (!isset($data[$field])) {",
"+ continue;",
"+ }",
"+",
"+ $value = $data[$field];",
"+",
"+ \/\/ Muss gültiges JSON sein",
"+ if (is_string($value)) {",
"+ $decoded = json_decode($value, true);",
"+ if (json_last_error() !== JSON_ERROR_NONE) {",
"+ throw new ValidationException(\"$field: Invalid JSON\");",
"+ }",
"+ $value = $decoded;",
"+ }",
"+",
"+ \/\/ Muss Array sein",
"+ if (!is_array($value)) {",
"+ throw new ValidationException(\"$field: Must be array\");",
"+ }",
"+",
"+ \/\/ Keine leeren Strings im Array",
"+ foreach ($value as $item) {",
"+ if ($item === '' || $item === null) {",
"+ throw new ValidationException(\"$field: Empty values not allowed\");",
"+ }",
"+ }",
"+ }",
"+ }",
"+",
"+ \/**",
"+ * Prüft ob referenzierte Entities existieren",
"+ * @throws ValidationException",
"+ *\/",
"+ private function validateReferences(array $data): void",
"+ {",
"+ \/\/ Model existiert?",
"+ if (isset($data['default_model_id']) && $data['default_model_id']) {",
"+ if (!$this->modelRepo->exists($data['default_model_id'])) {",
"+ throw new ValidationException(\"Model not found: {$data['default_model_id']}\");",
"+ }",
"+ }",
"+",
"+ \/\/ Collections existieren?",
"+ if (isset($data['default_collections'])) {",
"+ $ids = is_string($data['default_collections'])",
"+ ? json_decode($data['default_collections'], true)",
"+ : $data['default_collections'];",
"+",
"+ foreach ($ids as $id) {",
"+ if (!$this->collectionRepo->isActive($id)) {",
"+ throw new ValidationException(\"Collection not active: $id\");",
"+ }",
"+ }",
"+ }",
"+",
"+ \/\/ Contracts existieren?",
"+ if (isset($data['default_contracts'])) {",
"+ $ids = is_string($data['default_contracts'])",
"+ ? json_decode($data['default_contracts'], true)",
"+ : $data['default_contracts'];",
"+",
"+ foreach ($ids as $id) {",
"+ if (!$this->configRepo->exists($id, 'contract')) {",
"+ throw new ValidationException(\"Contract not found: $id\");",
"+ }",
"+ }",
"+ }",
"+ }",
"+",
"+ private function createDefaults(int $userId): array",
"+ {",
"+ $defaults = $this->getDefaults();",
"+ $this->db->insert('user_preferences', ['user_id' => $userId] + $defaults);",
"+ return ['user_id' => $userId] + $defaults;",
"+ }",
"+",
" private function getDefaults(): array",
" {",
" return [",
" 'default_model_id' => null,",
"+ 'default_preset_id' => 2, \/\/ \"balanced\"",
" 'default_temperature' => 0.70,",
" 'default_max_tokens' => 4096,",
" 'default_collections' => '[\"documents\"]',",
"+ 'default_contracts' => '[]',",
"+ 'default_structures' => '[]',",
" 'default_context_limit' => 5,",
"- \/\/ ...",
" ];",
" }",
" }"
]
}
],
"userModified": false,
"replaceAll": false
}
}