{
"event": "PreToolUse",
"tool_name": "Read",
"tool_input": {
"file_path": "\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/CodeAnalysisRepository.php",
"offset": 1,
"limit": 100
}
}
{
"tool_response": {
"type": "text",
"file": {
"filePath": "\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/CodeAnalysisRepository.php",
"content": "<?php\n\ndeclare(strict_types=1);\n\nnamespace Infrastructure\\Persistence;\n\n\/\/ @responsibility: Persistenz für Code-Analyse-Ergebnisse\n\nuse Domain\\Repository\\CodeAnalysisRepositoryInterface;\nuse PDO;\n\nclass CodeAnalysisRepository implements CodeAnalysisRepositoryInterface\n{\n private PDO $pdo;\n\n public function __construct(PDO $pdo)\n {\n $this->pdo = $pdo;\n }\n\n \/**\n * @param array<string, mixed> $filters\n * @return array<array<string, mixed>>\n *\/\n public function findAll(array $filters = [], int $limit = 100, int $offset = 0): array\n {\n $sql = '\n SELECT ca.*,\n cq.complexity_score, cq.loc_score, cq.dependency_score,\n cq.hardcoded_count, cq.issues_count, cq.warnings_count,\n cq.quality_grade, cq.issues_json\n FROM code_analysis ca\n LEFT JOIN code_quality cq ON ca.id = cq.analysis_id\n WHERE 1=1\n ';\n $params = [];\n\n if (!empty($filters['scan_id'])) {\n $sql .= ' AND ca.scan_id = :scan_id';\n $params['scan_id'] = $filters['scan_id'];\n }\n\n if (!empty($filters['directory'])) {\n $sql .= ' AND ca.directory = :directory';\n $params['directory'] = $filters['directory'];\n }\n\n if (!empty($filters['namespace'])) {\n $sql .= ' AND ca.namespace = :namespace';\n $params['namespace'] = $filters['namespace'];\n }\n\n if (!empty($filters['extension'])) {\n $sql .= ' AND ca.extension = :extension';\n $params['extension'] = $filters['extension'];\n }\n\n if (!empty($filters['search'])) {\n $sql .= ' AND (ca.file_name LIKE :search OR ca.namespace LIKE :search2)';\n $params['search'] = '%' . $filters['search'] . '%';\n $params['search2'] = '%' . $filters['search'] . '%';\n }\n\n if (isset($filters['has_classes']) && $filters['has_classes'] !== '') {\n if ($filters['has_classes'] === '1') {\n $sql .= \" AND ca.classes IS NOT NULL AND ca.classes != '[]'\";\n } else {\n $sql .= \" AND (ca.classes IS NULL OR ca.classes = '[]')\";\n }\n }\n\n if (isset($filters['has_error']) && $filters['has_error'] === '1') {\n $sql .= ' AND ca.parse_error IS NOT NULL';\n }\n\n if (!empty($filters['quality_grade'])) {\n $sql .= ' AND cq.quality_grade = :quality_grade';\n $params['quality_grade'] = $filters['quality_grade'];\n }\n\n if (!empty($filters['has_issues'])) {\n $sql .= ' AND cq.issues_count > 0';\n }\n\n $sql .= ' ORDER BY ca.directory, ca.file_name 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(PDO::FETCH_ASSOC);\n }\n\n \/**\n * @return array<string, mixed>|null\n *\/",
"numLines": 100,
"startLine": 1,
"totalLines": 605
}
}
}