Protokoll #24594

{
    "event": "PreToolUse",
    "tool_name": "Edit",
    "tool_input": {
        "file_path": "\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/CodeQualityRepository.php",
        "old_string": "namespace Infrastructure\\Persistence;\n\n\/\/ @responsibility: Persistenz für Code-Hygiene-Metriken (code_quality Tabelle)\n\nuse Domain\\Repository\\CodeQualityRepositoryInterface;",
        "new_string": "namespace Infrastructure\\Persistence;\n\n\/\/ @responsibility: Persistenz für Code-Hygiene-Metriken (code_quality Tabelle)\n\nuse Domain\\Constants;\nuse Domain\\Repository\\CodeQualityRepositoryInterface;"
    }
}

{
    "tool_response": {
        "filePath": "\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/CodeQualityRepository.php",
        "oldString": "namespace Infrastructure\\Persistence;\n\n\/\/ @responsibility: Persistenz für Code-Hygiene-Metriken (code_quality Tabelle)\n\nuse Domain\\Repository\\CodeQualityRepositoryInterface;",
        "newString": "namespace Infrastructure\\Persistence;\n\n\/\/ @responsibility: Persistenz für Code-Hygiene-Metriken (code_quality Tabelle)\n\nuse Domain\\Constants;\nuse Domain\\Repository\\CodeQualityRepositoryInterface;",
        "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,\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        ]);\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,\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['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(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": 6,
                "oldLines": 6,
                "newStart": 6,
                "newLines": 7,
                "lines": [
                    " ",
                    " \/\/ @responsibility: Persistenz für Code-Hygiene-Metriken (code_quality Tabelle)",
                    " ",
                    "+use Domain\\Constants;",
                    " use Domain\\Repository\\CodeQualityRepositoryInterface;",
                    " use PDO;",
                    " "
                ]
            }
        ],
        "userModified": false,
        "replaceAll": false
    }
}