{
"event": "PreToolUse",
"tool_name": "Grep",
"tool_input": {
"pattern": "author_profiles|content_structures",
"path": "\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/ContentRepository.php",
"output_mode": "content",
"-C": 3,
"-n": true
}
}
{
"tool_response": {
"mode": "content",
"numFiles": 0,
"filenames": [],
"content": "23- cs.name as structure_name,\n24- (SELECT COUNT(*) FROM content_versions WHERE order_id = co.id) as version_count\n25- FROM content_orders co\n26: LEFT JOIN author_profiles ap ON co.author_profile_id = ap.id\n27- LEFT JOIN content_contracts cc ON co.contract_id = cc.id\n28: LEFT JOIN content_structures cs ON co.structure_id = cs.id\n29- WHERE 1=1';\n30-\n31- $params = [];\n--\n61- cc.name as contract_name, cc.config as contract_config,\n62- cs.name as structure_name, cs.config as structure_config\n63- FROM content_orders co\n64: LEFT JOIN author_profiles ap ON co.author_profile_id = ap.id\n65- LEFT JOIN content_contracts cc ON co.contract_id = cc.id\n66: LEFT JOIN content_structures cs ON co.structure_id = cs.id\n67- WHERE co.id = :id\n68- ');\n69- $stmt->execute(['id' => $id]);\n--\n209- public function findAllProfiles(): array\n210- {\n211- $stmt = $this->pdo->query('\n212: SELECT * FROM author_profiles WHERE is_active = 1 ORDER BY name\n213- ');\n214-\n215- return $stmt->fetchAll();\n--\n231- public function findAllStructures(): array\n232- {\n233- $stmt = $this->pdo->query('\n234: SELECT * FROM content_structures WHERE is_active = 1 ORDER BY name\n235- ');\n236-\n237- return $stmt->fetchAll();",
"numLines": 35
}
}