{
"event": "PreToolUse",
"tool_name": "Grep",
"tool_input": {
"pattern": "ORDER BY|findAll",
"path": "\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/FileAnalysisRepository.php",
"output_mode": "content",
"-C": 3,
"-n": true
}
}
{
"tool_response": {
"mode": "content",
"numFiles": 0,
"filenames": [],
"content": "23- * @param array<string, mixed> $filters\n24- * @return array<array<string, mixed>>\n25- *\/\n26: public function findAll(array $filters = [], int $limit = Constants::DEFAULT_LIMIT, int $offset = 0): array\n27- {\n28- $sql = '\n29- SELECT ca.*,\n--\n78- $sql .= ' AND cq.issues_count > 0';\n79- }\n80-\n81: $sql .= ' ORDER BY ca.directory, ca.file_name LIMIT :limit OFFSET :offset';\n82-\n83- $stmt = $this->pdo->prepare($sql);\n84- foreach ($params as $key => $value) {\n--\n222-\n223- public function getLatestScanId(): ?string\n224- {\n225: $stmt = $this->pdo->query('SELECT scan_id FROM code_analysis ORDER BY scanned_at DESC LIMIT 1');\n226- $result = $stmt->fetchColumn();\n227-\n228- return $result ?: null;\n--\n234- public function findByScanId(string $scanId): array\n235- {\n236- $stmt = $this->pdo->prepare('\n237: SELECT * FROM code_analysis WHERE scan_id = :scan_id ORDER BY file_path\n238- ');\n239- $stmt->execute(['scan_id' => $scanId]);\n240-\n--\n290- *\/\n291- public function getDistinctDirectories(): array\n292- {\n293: $stmt = $this->pdo->query('SELECT DISTINCT directory FROM code_analysis ORDER BY directory');\n294-\n295- return $stmt->fetchAll(PDO::FETCH_COLUMN);\n296- }\n--\n300- *\/\n301- public function getDistinctNamespaces(): array\n302- {\n303: $stmt = $this->pdo->query('SELECT DISTINCT namespace FROM code_analysis WHERE namespace IS NOT NULL ORDER BY namespace');\n304-\n305- return $stmt->fetchAll(PDO::FETCH_COLUMN);\n306- }\n--\n310- *\/\n311- public function getConfiguredDirectories(): array\n312- {\n313: $stmt = $this->pdo->query('SELECT * FROM code_scan_config WHERE enabled = 1 ORDER BY label');\n314-\n315- return $stmt->fetchAll(PDO::FETCH_ASSOC);\n316- }",
"numLines": 55
}
}