{
"event": "PreToolUse",
"tool_name": "Read",
"tool_input": {
"file_path": "\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/ContentRepository.php",
"offset": 95
}
}
{
"tool_response": {
"type": "text",
"file": {
"filePath": "\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/ContentRepository.php",
"content": " public function findSourcesByOrder(int $orderId): array\n {\n return $this->sourceRepository->findSourcesByOrder($orderId);\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",
"numLines": 80,
"startLine": 95,
"totalLines": 174
}
}
}