{
"event": "PreToolUse",
"tool_name": "Read",
"tool_input": {
"file_path": "\/var\/www\/dev.campus.systemische-tools.de\/src\/Controller\/ProtokollController.php",
"offset": 38,
"limit": 80
}
}
{
"tool_response": {
"type": "text",
"file": {
"filePath": "\/var\/www\/dev.campus.systemische-tools.de\/src\/Controller\/ProtokollController.php",
"content": " )->fetch();\n\n \/\/ Einträge mit Pagination\n $page = $this->getPage();\n $limit = 50;\n $offset = ($page - 1) * $limit;\n\n $search = $this->getString('search');\n $status = $this->getString('status');\n $model = $this->getString('model');\n\n $sql = 'SELECT id, timestamp, client_name, model_name, status, tokens_total, duration_ms,\n LEFT(request, 200) as request_preview\n FROM protokoll WHERE 1=1';\n $countSql = 'SELECT COUNT(*) FROM protokoll WHERE 1=1';\n $params = [];\n\n if ($search !== '') {\n $sql .= ' AND (request LIKE :search OR response LIKE :search2 OR client_name LIKE :search3)';\n $countSql .= ' AND (request LIKE :search OR response LIKE :search2 OR client_name LIKE :search3)';\n $params['search'] = '%' . $search . '%';\n $params['search2'] = '%' . $search . '%';\n $params['search3'] = '%' . $search . '%';\n }\n\n if ($status !== '') {\n $sql .= ' AND status = :status';\n $countSql .= ' AND status = :status';\n $params['status'] = $status;\n }\n\n if ($model !== '') {\n $sql .= ' AND model_name = :model';\n $countSql .= ' AND model_name = :model';\n $params['model'] = $model;\n }\n\n \/\/ Total count\n $countStmt = $this->db->prepare($countSql);\n $countStmt->execute($params);\n $totalCount = (int) $countStmt->fetchColumn();\n\n \/\/ Fetch entries\n $sql .= ' ORDER BY timestamp DESC LIMIT :limit OFFSET :offset';\n $stmt = $this->db->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 $entries = $stmt->fetchAll();\n\n \/\/ Modelle für Filter\n $models = $this->db->query(\n 'SELECT DISTINCT model_name FROM protokoll WHERE model_name IS NOT NULL ORDER BY model_name'\n )->fetchAll(\\PDO::FETCH_COLUMN);\n\n $this->view('protokoll.index', [\n 'title' => 'KI-Protokoll',\n 'stats' => $stats,\n 'entries' => $entries,\n 'models' => $models,\n 'currentSearch' => $search,\n 'currentStatus' => $status,\n 'currentModel' => $model,\n 'currentPage' => $page,\n 'totalCount' => $totalCount,\n 'totalPages' => ceil($totalCount \/ $limit),\n ]);\n }\n\n \/**\n * GET \/protokoll\/{id}\n * Detail-Ansicht eines Eintrags\n *\/\n public function show(string $id): void\n {\n $stmt = $this->db->prepare('SELECT * FROM protokoll WHERE id = :id');\n $stmt->execute(['id' => (int) $id]);",
"numLines": 80,
"startLine": 38,
"totalLines": 162
}
}
}