{
"event": "PreToolUse",
"tool_name": "Edit",
"tool_input": {
"file_path": "\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/CodeQualityRepository.php",
"old_string": " $stmt = $this->pdo->prepare('\n INSERT INTO code_quality (\n analysis_id, dependency_score, hygiene_score, hygiene_status,\n factor_scores, hardcoded_count, issues_count, warnings_count, issues_json\n ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)\n ');\n\n $factorScores = $qualityData['factor_scores'] ?? [];\n\n $stmt->execute([\n $analysisId,\n $factorScores['dependencies'] ?? 0,\n $qualityData['hygiene_score'] ?? 50,\n $qualityData['hygiene_status'] ?? 'Vernachlässigt',\n json_encode($factorScores),\n $qualityData['hardcoded_count'] ?? 0,\n $qualityData['issues_count'] ?? 0,\n $qualityData['warnings_count'] ?? 0,\n $qualityData['issues_json'] ?? '[]',\n ]);",
"new_string": " $stmt = $this->pdo->prepare('\n INSERT INTO code_quality (\n analysis_id, dependency_score, hygiene_score,\n factor_scores, hardcoded_count, issues_count, warnings_count, issues_json\n ) VALUES (?, ?, ?, ?, ?, ?, ?, ?)\n ');\n\n $factorScores = $qualityData['factor_scores'] ?? [];\n\n $stmt->execute([\n $analysisId,\n $factorScores['dependencies'] ?? 0,\n $qualityData['hygiene_score'] ?? 50,\n json_encode($factorScores),\n $qualityData['hardcoded_count'] ?? 0,\n $qualityData['issues_count'] ?? 0,\n $qualityData['warnings_count'] ?? 0,\n $qualityData['issues_json'] ?? '[]',\n ]);"
}
}
{
"tool_response": {
"filePath": "\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/CodeQualityRepository.php",
"oldString": " $stmt = $this->pdo->prepare('\n INSERT INTO code_quality (\n analysis_id, dependency_score, hygiene_score, hygiene_status,\n factor_scores, hardcoded_count, issues_count, warnings_count, issues_json\n ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)\n ');\n\n $factorScores = $qualityData['factor_scores'] ?? [];\n\n $stmt->execute([\n $analysisId,\n $factorScores['dependencies'] ?? 0,\n $qualityData['hygiene_score'] ?? 50,\n $qualityData['hygiene_status'] ?? 'Vernachlässigt',\n json_encode($factorScores),\n $qualityData['hardcoded_count'] ?? 0,\n $qualityData['issues_count'] ?? 0,\n $qualityData['warnings_count'] ?? 0,\n $qualityData['issues_json'] ?? '[]',\n ]);",
"newString": " $stmt = $this->pdo->prepare('\n INSERT INTO code_quality (\n analysis_id, dependency_score, hygiene_score,\n factor_scores, hardcoded_count, issues_count, warnings_count, issues_json\n ) VALUES (?, ?, ?, ?, ?, ?, ?, ?)\n ');\n\n $factorScores = $qualityData['factor_scores'] ?? [];\n\n $stmt->execute([\n $analysisId,\n $factorScores['dependencies'] ?? 0,\n $qualityData['hygiene_score'] ?? 50,\n json_encode($factorScores),\n $qualityData['hardcoded_count'] ?? 0,\n $qualityData['issues_count'] ?? 0,\n $qualityData['warnings_count'] ?? 0,\n $qualityData['issues_json'] ?? '[]',\n ]);",
"originalFile": "<?php\n\ndeclare(strict_types=1);\n\nnamespace Infrastructure\\Persistence;\n\n\/\/ @responsibility: Persistenz für Code-Hygiene-Metriken (code_quality Tabelle)\n\nuse Domain\\Repository\\CodeQualityRepositoryInterface;\nuse PDO;\n\nclass CodeQualityRepository implements CodeQualityRepositoryInterface\n{\n private PDO $pdo;\n\n public function __construct(PDO $pdo)\n {\n $this->pdo = $pdo;\n }\n\n \/**\n * Speichert Hygiene-Daten für eine Analyse.\n *\n * @param array<string, mixed> $qualityData\n *\/\n public function saveQuality(int $analysisId, array $qualityData): void\n {\n \/\/ Delete existing quality data\n $this->pdo->prepare('DELETE FROM code_quality WHERE analysis_id = ?')->execute([$analysisId]);\n\n $stmt = $this->pdo->prepare('\n INSERT INTO code_quality (\n analysis_id, dependency_score, hygiene_score, hygiene_status,\n factor_scores, hardcoded_count, issues_count, warnings_count, issues_json\n ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)\n ');\n\n $factorScores = $qualityData['factor_scores'] ?? [];\n\n $stmt->execute([\n $analysisId,\n $factorScores['dependencies'] ?? 0,\n $qualityData['hygiene_score'] ?? 50,\n $qualityData['hygiene_status'] ?? 'Vernachlässigt',\n json_encode($factorScores),\n $qualityData['hardcoded_count'] ?? 0,\n $qualityData['issues_count'] ?? 0,\n $qualityData['warnings_count'] ?? 0,\n $qualityData['issues_json'] ?? '[]',\n ]);\n }\n\n \/**\n * Holt alle Analysen mit Hygiene-Daten.\n *\n * @param array<string, mixed> $filters\n * @return array<array<string, mixed>>\n *\/\n public function findAllWithQuality(array $filters = [], int $limit = 100, int $offset = 0): array\n {\n $sql = '\n SELECT ca.*,\n cq.dependency_score, cq.hygiene_score, cq.hygiene_status,\n cq.factor_scores, cq.hardcoded_count, cq.issues_count,\n cq.warnings_count, 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['extension'])) {\n $sql .= ' AND ca.extension = :extension';\n $params['extension'] = $filters['extension'];\n }\n\n if (!empty($filters['namespace'])) {\n $sql .= ' AND ca.namespace = :namespace';\n $params['namespace'] = $filters['namespace'];\n }\n\n if (!empty($filters['search'])) {\n $sql .= ' AND (ca.file_name LIKE :search OR ca.namespace LIKE :search)';\n $params['search'] = '%' . $filters['search'] . '%';\n }\n\n if (!empty($filters['hygiene_status'])) {\n $sql .= ' AND cq.hygiene_status = :hygiene_status';\n $params['hygiene_status'] = $filters['hygiene_status'];\n }\n\n if (!empty($filters['has_issues'])) {\n $sql .= ' AND cq.issues_count > 0';\n }\n\n if (!empty($filters['min_score'])) {\n $sql .= ' AND cq.hygiene_score >= :min_score';\n $params['min_score'] = (int) $filters['min_score'];\n }\n\n if (!empty($filters['max_score'])) {\n $sql .= ' AND cq.hygiene_score <= :max_score';\n $params['max_score'] = (int) $filters['max_score'];\n }\n\n $sql .= ' ORDER BY ca.namespace, 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 * Holt Hygiene-Statistiken.\n *\n * @return array<string, mixed>\n *\/\n public function getQualityStats(): array\n {\n $stmt = $this->pdo->query('\n SELECT\n COUNT(*) as total_files,\n SUM(CASE WHEN hygiene_status = \"Sauber\" THEN 1 ELSE 0 END) as status_sauber,\n SUM(CASE WHEN hygiene_status = \"Gepflegt\" THEN 1 ELSE 0 END) as status_gepflegt,\n SUM(CASE WHEN hygiene_status = \"Vernachlässigt\" THEN 1 ELSE 0 END) as status_vernachlaessigt,\n SUM(CASE WHEN hygiene_status = \"Verschmutzt\" THEN 1 ELSE 0 END) as status_verschmutzt,\n SUM(CASE WHEN hygiene_status = \"Kritisch\" THEN 1 ELSE 0 END) as status_kritisch,\n SUM(issues_count) as total_issues,\n SUM(hardcoded_count) as total_hardcoded,\n AVG(hygiene_score) as avg_hygiene_score,\n MIN(hygiene_score) as min_hygiene_score,\n MAX(hygiene_score) as max_hygiene_score\n FROM code_quality\n ');\n\n return $stmt->fetch(PDO::FETCH_ASSOC) ?: [];\n }\n}\n",
"structuredPatch": [
{
"oldStart": 30,
"oldLines": 9,
"newStart": 30,
"newLines": 9,
"lines": [
" ",
" $stmt = $this->pdo->prepare('",
" INSERT INTO code_quality (",
"- analysis_id, dependency_score, hygiene_score, hygiene_status,",
"+ analysis_id, dependency_score, hygiene_score,",
" factor_scores, hardcoded_count, issues_count, warnings_count, issues_json",
"- ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)",
"+ ) VALUES (?, ?, ?, ?, ?, ?, ?, ?)",
" ');",
" ",
" $factorScores = $qualityData['factor_scores'] ?? [];"
]
},
{
"oldStart": 41,
"oldLines": 7,
"newStart": 41,
"newLines": 6,
"lines": [
" $analysisId,",
" $factorScores['dependencies'] ?? 0,",
" $qualityData['hygiene_score'] ?? 50,",
"- $qualityData['hygiene_status'] ?? 'Vernachlässigt',",
" json_encode($factorScores),",
" $qualityData['hardcoded_count'] ?? 0,",
" $qualityData['issues_count'] ?? 0,"
]
}
],
"userModified": false,
"replaceAll": false
}
}