{
"event": "PreToolUse",
"tool_name": "Write",
"tool_input": {
"file_path": "\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/CodeQualityRepository.php",
"content": "<?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"
}
}
{
"tool_response": {
"type": "update",
"filePath": "\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/CodeQualityRepository.php",
"content": "<?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": 4,
"oldLines": 7,
"newStart": 4,
"newLines": 7,
"lines": [
" ",
" namespace Infrastructure\\Persistence;",
" ",
"-\/\/ @responsibility: Persistenz für Code-Quality-Metriken (code_quality Tabelle)",
"+\/\/ @responsibility: Persistenz für Code-Hygiene-Metriken (code_quality Tabelle)",
" ",
" use Domain\\Repository\\CodeQualityRepositoryInterface;",
" use PDO;"
]
},
{
"oldStart": 19,
"oldLines": 7,
"newStart": 19,
"newLines": 7,
"lines": [
" }",
" ",
" \/**",
"- * Speichert Quality-Daten für eine Analyse.",
"+ * Speichert Hygiene-Daten für eine Analyse.",
" *",
" * @param array<string, mixed> $qualityData",
" *\/"
]
},
{
"oldStart": 30,
"oldLines": 26,
"newStart": 30,
"newLines": 28,
"lines": [
" ",
" $stmt = $this->pdo->prepare('",
" INSERT INTO code_quality (",
"- analysis_id, complexity_score, loc_score, dependency_score,",
"- hardcoded_count, issues_count, warnings_count, quality_grade, issues_json",
"+ analysis_id, dependency_score, hygiene_score, hygiene_status,",
"+ factor_scores, hardcoded_count, issues_count, warnings_count, issues_json",
" ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)",
" ');",
" ",
"+ $factorScores = $qualityData['factor_scores'] ?? [];",
"+",
" $stmt->execute([",
" $analysisId,",
"- $qualityData['complexity_score'] ?? 0,",
"- $qualityData['loc_score'] ?? 0,",
"- $qualityData['dependency_score'] ?? 0,",
"+ $factorScores['dependencies'] ?? 0,",
"+ $qualityData['hygiene_score'] ?? 50,",
"+ $qualityData['hygiene_status'] ?? 'Vernachlässigt',",
"+ json_encode($factorScores),",
" $qualityData['hardcoded_count'] ?? 0,",
" $qualityData['issues_count'] ?? 0,",
" $qualityData['warnings_count'] ?? 0,",
"- $qualityData['quality_grade'] ?? 'C',",
" $qualityData['issues_json'] ?? '[]',",
" ]);",
" }",
" ",
" \/**",
"- * Holt alle Analysen mit Quality-Daten.",
"+ * Holt alle Analysen mit Hygiene-Daten.",
" *",
" * @param array<string, mixed> $filters",
" * @return array<array<string, mixed>>"
]
},
{
"oldStart": 58,
"oldLines": 9,
"newStart": 60,
"newLines": 9,
"lines": [
" {",
" $sql = '",
" SELECT ca.*,",
"- cq.complexity_score, cq.loc_score, cq.dependency_score,",
"- cq.hardcoded_count, cq.issues_count, cq.warnings_count,",
"- cq.quality_grade, cq.issues_json",
"+ cq.dependency_score, cq.hygiene_score, cq.hygiene_status,",
"+ cq.factor_scores, cq.hardcoded_count, cq.issues_count,",
"+ cq.warnings_count, cq.issues_json",
" FROM code_analysis ca",
" LEFT JOIN code_quality cq ON ca.id = cq.analysis_id",
" WHERE 1=1"
]
},
{
"oldStart": 82,
"oldLines": 15,
"newStart": 84,
"newLines": 25,
"lines": [
" $params['search'] = '%' . $filters['search'] . '%';",
" }",
" ",
"- if (!empty($filters['quality_grade'])) {",
"- $sql .= ' AND cq.quality_grade = :quality_grade';",
"- $params['quality_grade'] = $filters['quality_grade'];",
"+ if (!empty($filters['hygiene_status'])) {",
"+ $sql .= ' AND cq.hygiene_status = :hygiene_status';",
"+ $params['hygiene_status'] = $filters['hygiene_status'];",
" }",
" ",
" if (!empty($filters['has_issues'])) {",
" $sql .= ' AND cq.issues_count > 0';",
" }",
" ",
"+ if (!empty($filters['min_score'])) {",
"+ $sql .= ' AND cq.hygiene_score >= :min_score';",
"+ $params['min_score'] = (int) $filters['min_score'];",
"+ }",
"+",
"+ if (!empty($filters['max_score'])) {",
"+ $sql .= ' AND cq.hygiene_score <= :max_score';",
"+ $params['max_score'] = (int) $filters['max_score'];",
"+ }",
"+",
" $sql .= ' ORDER BY ca.namespace, ca.file_name LIMIT :limit OFFSET :offset';",
" ",
" $stmt = $this->pdo->prepare($sql);"
]
},
{
"oldStart": 105,
"oldLines": 7,
"newStart": 117,
"newLines": 7,
"lines": [
" }",
" ",
" \/**",
"- * Holt Quality-Statistiken.",
"+ * Holt Hygiene-Statistiken.",
" *",
" * @return array<string, mixed>",
" *\/"
]
},
{
"oldStart": 114,
"oldLines": 14,
"newStart": 126,
"newLines": 16,
"lines": [
" $stmt = $this->pdo->query('",
" SELECT",
" COUNT(*) as total_files,",
"- SUM(CASE WHEN quality_grade = \"A\" THEN 1 ELSE 0 END) as grade_a,",
"- SUM(CASE WHEN quality_grade = \"B\" THEN 1 ELSE 0 END) as grade_b,",
"- SUM(CASE WHEN quality_grade = \"C\" THEN 1 ELSE 0 END) as grade_c,",
"- SUM(CASE WHEN quality_grade = \"D\" THEN 1 ELSE 0 END) as grade_d,",
"- SUM(CASE WHEN quality_grade = \"F\" THEN 1 ELSE 0 END) as grade_f,",
"+ SUM(CASE WHEN hygiene_status = \"Sauber\" THEN 1 ELSE 0 END) as status_sauber,",
"+ SUM(CASE WHEN hygiene_status = \"Gepflegt\" THEN 1 ELSE 0 END) as status_gepflegt,",
"+ SUM(CASE WHEN hygiene_status = \"Vernachlässigt\" THEN 1 ELSE 0 END) as status_vernachlaessigt,",
"+ SUM(CASE WHEN hygiene_status = \"Verschmutzt\" THEN 1 ELSE 0 END) as status_verschmutzt,",
"+ SUM(CASE WHEN hygiene_status = \"Kritisch\" THEN 1 ELSE 0 END) as status_kritisch,",
" SUM(issues_count) as total_issues,",
" SUM(hardcoded_count) as total_hardcoded,",
"- AVG(complexity_score) as avg_complexity",
"+ AVG(hygiene_score) as avg_hygiene_score,",
"+ MIN(hygiene_score) as min_hygiene_score,",
"+ MAX(hygiene_score) as max_hygiene_score",
" FROM code_quality",
" ');",
" "
]
}
],
"originalFile": "<?php\n\ndeclare(strict_types=1);\n\nnamespace Infrastructure\\Persistence;\n\n\/\/ @responsibility: Persistenz für Code-Quality-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 Quality-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, complexity_score, loc_score, dependency_score,\n hardcoded_count, issues_count, warnings_count, quality_grade, issues_json\n ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)\n ');\n\n $stmt->execute([\n $analysisId,\n $qualityData['complexity_score'] ?? 0,\n $qualityData['loc_score'] ?? 0,\n $qualityData['dependency_score'] ?? 0,\n $qualityData['hardcoded_count'] ?? 0,\n $qualityData['issues_count'] ?? 0,\n $qualityData['warnings_count'] ?? 0,\n $qualityData['quality_grade'] ?? 'C',\n $qualityData['issues_json'] ?? '[]',\n ]);\n }\n\n \/**\n * Holt alle Analysen mit Quality-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.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['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['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.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 Quality-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 quality_grade = \"A\" THEN 1 ELSE 0 END) as grade_a,\n SUM(CASE WHEN quality_grade = \"B\" THEN 1 ELSE 0 END) as grade_b,\n SUM(CASE WHEN quality_grade = \"C\" THEN 1 ELSE 0 END) as grade_c,\n SUM(CASE WHEN quality_grade = \"D\" THEN 1 ELSE 0 END) as grade_d,\n SUM(CASE WHEN quality_grade = \"F\" THEN 1 ELSE 0 END) as grade_f,\n SUM(issues_count) as total_issues,\n SUM(hardcoded_count) as total_hardcoded,\n AVG(complexity_score) as avg_complexity\n FROM code_quality\n ');\n\n return $stmt->fetch(PDO::FETCH_ASSOC) ?: [];\n }\n}\n"
}
}