{
"event": "PreToolUse",
"tool_name": "Read",
"tool_input": {
"file_path": "\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/ContentOrderRepository.php",
"limit": 100
}
}
{
"tool_response": {
"type": "text",
"file": {
"filePath": "\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/ContentOrderRepository.php",
"content": "<?php\n\ndeclare(strict_types=1);\n\nnamespace Infrastructure\\Persistence;\n\n\/\/ @responsibility: Persistenz für Content-Orders\n\nuse Domain\\Repository\\ContentOrderRepositoryInterface;\nuse Infrastructure\\Traits\\JsonDecodeTrait;\n\nclass ContentOrderRepository implements ContentOrderRepositoryInterface\n{\n use JsonDecodeTrait;\n\n private \\PDO $pdo;\n\n public function __construct(\\PDO $pdo)\n {\n $this->pdo = $pdo;\n }\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 \/**\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,",
"numLines": 100,
"startLine": 1,
"totalLines": 224
}
}
}