Protokoll #11807

{
    "event": "PreToolUse",
    "tool_name": "Edit",
    "tool_input": {
        "file_path": "\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/CodeAnalysisRepository.php",
        "old_string": "        \/\/ Stats\n        $stats = [\n            'nodes' => count($nodes),\n            'links' => count($links),\n            'namespaces' => count(array_unique(array_column($nodes, 'namespace'))),\n        ];\n\n        return [\n            'nodes' => $nodes,\n            'links' => $links,\n            'stats' => $stats,\n        ];\n    }\n}",
        "new_string": "        \/\/ Stats\n        $stats = [\n            'nodes' => count($nodes),\n            'links' => count($links),\n            'namespaces' => count(array_unique(array_column($nodes, 'namespace'))),\n        ];\n\n        return [\n            'nodes' => $nodes,\n            'links' => $links,\n            'stats' => $stats,\n        ];\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}"
    }
}

{
    "tool_response": {
        "filePath": "\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/CodeAnalysisRepository.php",
        "oldString": "        \/\/ Stats\n        $stats = [\n            'nodes' => count($nodes),\n            'links' => count($links),\n            'namespaces' => count(array_unique(array_column($nodes, 'namespace'))),\n        ];\n\n        return [\n            'nodes' => $nodes,\n            'links' => $links,\n            'stats' => $stats,\n        ];\n    }\n}",
        "newString": "        \/\/ Stats\n        $stats = [\n            'nodes' => count($nodes),\n            'links' => count($links),\n            'namespaces' => count(array_unique(array_column($nodes, 'namespace'))),\n        ];\n\n        return [\n            'nodes' => $nodes,\n            'links' => $links,\n            'stats' => $stats,\n        ];\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}",
        "originalFile": "<?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 = 'SELECT * FROM code_analysis WHERE 1=1';\n        $params = [];\n\n        if (!empty($filters['scan_id'])) {\n            $sql .= ' AND scan_id = :scan_id';\n            $params['scan_id'] = $filters['scan_id'];\n        }\n\n        if (!empty($filters['directory'])) {\n            $sql .= ' AND directory = :directory';\n            $params['directory'] = $filters['directory'];\n        }\n\n        if (!empty($filters['namespace'])) {\n            $sql .= ' AND namespace = :namespace';\n            $params['namespace'] = $filters['namespace'];\n        }\n\n        if (!empty($filters['extension'])) {\n            $sql .= ' AND extension = :extension';\n            $params['extension'] = $filters['extension'];\n        }\n\n        if (!empty($filters['search'])) {\n            $sql .= ' AND (file_name LIKE :search OR 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 classes IS NOT NULL AND classes != '[]'\";\n            } else {\n                $sql .= \" AND (classes IS NULL OR classes = '[]')\";\n            }\n        }\n\n        if (isset($filters['has_error']) && $filters['has_error'] === '1') {\n            $sql .= ' AND parse_error IS NOT NULL';\n        }\n\n        $sql .= ' ORDER BY directory, 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     *\/\n    public function findById(int $id): ?array\n    {\n        $stmt = $this->pdo->prepare('SELECT * FROM code_analysis WHERE id = :id');\n        $stmt->execute(['id' => $id]);\n        $result = $stmt->fetch(PDO::FETCH_ASSOC);\n\n        return $result ?: null;\n    }\n\n    \/**\n     * @param array<array<string, mixed>> $items\n     *\/\n    public function saveBatch(array $items, string $scanId): int\n    {\n        if (empty($items)) {\n            return 0;\n        }\n\n        $this->pdo->beginTransaction();\n\n        try {\n            $analysisStmt = $this->pdo->prepare('\n                INSERT INTO code_analysis\n                (scan_id, file_path, file_name, extension, directory, file_size, line_count,\n                 modified_at, namespace, classes, functions, uses, extends_class,\n                 implements_interfaces, traits_used, constructor_deps, parse_error, triggered_by)\n                VALUES\n                (:scan_id, :file_path, :file_name, :extension, :directory, :file_size, :line_count,\n                 :modified_at, :namespace, :classes, :functions, :uses, :extends_class,\n                 :implements_interfaces, :traits_used, :constructor_deps, :parse_error, :triggered_by)\n            ');\n\n            $depStmt = $this->pdo->prepare('\n                INSERT INTO code_dependencies (analysis_id, dependency_type, target_fqcn)\n                VALUES (:analysis_id, :dep_type, :target_fqcn)\n            ');\n\n            $count = 0;\n            foreach ($items as $item) {\n                $analysisStmt->execute([\n                    'scan_id' => $scanId,\n                    'file_path' => $item['file_path'],\n                    'file_name' => $item['file_name'],\n                    'extension' => $item['extension'],\n                    'directory' => $item['directory'],\n                    'file_size' => $item['file_size'],\n                    'line_count' => $item['line_count'],\n                    'modified_at' => $item['modified_at'],\n                    'namespace' => $item['namespace'],\n                    'classes' => json_encode($item['classes'] ?? [], JSON_UNESCAPED_UNICODE),\n                    'functions' => json_encode($item['functions'] ?? [], JSON_UNESCAPED_UNICODE),\n                    'uses' => json_encode($item['uses'] ?? [], JSON_UNESCAPED_UNICODE),\n                    'extends_class' => $item['extends_class'],\n                    'implements_interfaces' => json_encode($item['implements_interfaces'] ?? [], JSON_UNESCAPED_UNICODE),\n                    'traits_used' => json_encode($item['traits_used'] ?? [], JSON_UNESCAPED_UNICODE),\n                    'constructor_deps' => json_encode($item['constructor_deps'] ?? [], JSON_UNESCAPED_UNICODE),\n                    'parse_error' => $item['parse_error'],\n                    'triggered_by' => $item['triggered_by'] ?? 'web',\n                ]);\n\n                $analysisId = (int) $this->pdo->lastInsertId();\n\n                \/\/ Save dependencies to normalized table\n                $this->saveDependencies($depStmt, $analysisId, $item);\n\n                $count++;\n            }\n\n            $this->pdo->commit();\n\n            return $count;\n        } catch (\\Throwable $e) {\n            $this->pdo->rollBack();\n\n            throw $e;\n        }\n    }\n\n    \/**\n     * @param array<string, mixed> $item\n     *\/\n    private function saveDependencies(\\PDOStatement $stmt, int $analysisId, array $item): void\n    {\n        \/\/ Use statements\n        foreach ($item['uses'] ?? [] as $fqcn) {\n            $stmt->execute(['analysis_id' => $analysisId, 'dep_type' => 'use', 'target_fqcn' => $fqcn]);\n        }\n\n        \/\/ Extends\n        if (!empty($item['extends_class'])) {\n            $stmt->execute(['analysis_id' => $analysisId, 'dep_type' => 'extends', 'target_fqcn' => $item['extends_class']]);\n        }\n\n        \/\/ Implements\n        foreach ($item['implements_interfaces'] ?? [] as $fqcn) {\n            $stmt->execute(['analysis_id' => $analysisId, 'dep_type' => 'implements', 'target_fqcn' => $fqcn]);\n        }\n\n        \/\/ Traits\n        foreach ($item['traits_used'] ?? [] as $fqcn) {\n            $stmt->execute(['analysis_id' => $analysisId, 'dep_type' => 'trait', 'target_fqcn' => $fqcn]);\n        }\n\n        \/\/ Constructor dependencies\n        foreach ($item['constructor_deps'] ?? [] as $fqcn) {\n            $stmt->execute(['analysis_id' => $analysisId, 'dep_type' => 'constructor', 'target_fqcn' => $fqcn]);\n        }\n    }\n\n    public function deleteByNotScanId(string $currentScanId): int\n    {\n        $stmt = $this->pdo->prepare('DELETE FROM code_analysis WHERE scan_id != :scan_id');\n        $stmt->execute(['scan_id' => $currentScanId]);\n\n        return $stmt->rowCount();\n    }\n\n    public function getLatestScanId(): ?string\n    {\n        $stmt = $this->pdo->query('SELECT scan_id FROM code_analysis ORDER BY scanned_at DESC LIMIT 1');\n        $result = $stmt->fetchColumn();\n\n        return $result ?: null;\n    }\n\n    \/**\n     * @return array<string, mixed>\n     *\/\n    public function getStatistics(?string $scanId = null): array\n    {\n        $where = $scanId ? 'WHERE scan_id = :scan_id' : '';\n        $params = $scanId ? ['scan_id' => $scanId] : [];\n\n        $stmt = $this->pdo->prepare(\"\n            SELECT\n                COUNT(*) as total_files,\n                SUM(line_count) as total_lines,\n                SUM(file_size) as total_size,\n                COUNT(CASE WHEN parse_error IS NOT NULL THEN 1 END) as files_with_errors,\n                MAX(scanned_at) as last_scan\n            FROM code_analysis {$where}\n        \");\n        $stmt->execute($params);\n        $stats = $stmt->fetch(PDO::FETCH_ASSOC);\n\n        $stmt = $this->pdo->prepare(\"SELECT classes, functions FROM code_analysis {$where}\");\n        $stmt->execute($params);\n        $rows = $stmt->fetchAll(PDO::FETCH_ASSOC);\n\n        $totalClasses = 0;\n        $totalFunctions = 0;\n        foreach ($rows as $row) {\n            $classes = json_decode($row['classes'] ?? '[]', true);\n            $functions = json_decode($row['functions'] ?? '[]', true);\n            $totalClasses += count($classes);\n            $totalFunctions += count($functions);\n        }\n\n        return [\n            'total_files' => (int) ($stats['total_files'] ?? 0),\n            'total_lines' => (int) ($stats['total_lines'] ?? 0),\n            'total_size' => (int) ($stats['total_size'] ?? 0),\n            'total_classes' => $totalClasses,\n            'total_functions' => $totalFunctions,\n            'files_with_errors' => (int) ($stats['files_with_errors'] ?? 0),\n            'last_scan' => $stats['last_scan'],\n        ];\n    }\n\n    \/**\n     * @return array<string>\n     *\/\n    public function getDistinctDirectories(): array\n    {\n        $stmt = $this->pdo->query('SELECT DISTINCT directory FROM code_analysis ORDER BY directory');\n\n        return $stmt->fetchAll(PDO::FETCH_COLUMN);\n    }\n\n    \/**\n     * @return array<string>\n     *\/\n    public function getDistinctNamespaces(): array\n    {\n        $stmt = $this->pdo->query('SELECT DISTINCT namespace FROM code_analysis WHERE namespace IS NOT NULL ORDER BY namespace');\n\n        return $stmt->fetchAll(PDO::FETCH_COLUMN);\n    }\n\n    \/**\n     * @return array<array<string, mixed>>\n     *\/\n    public function getConfiguredDirectories(): array\n    {\n        $stmt = $this->pdo->query('SELECT * FROM code_scan_config WHERE enabled = 1 ORDER BY label');\n\n        return $stmt->fetchAll(PDO::FETCH_ASSOC);\n    }\n\n    \/**\n     * Find all files that depend on a g... [TRUNCATED-3206a3cd1f0230d3]",
        "structuredPatch": [
            {
                "oldStart": 450,
                "oldLines": 4,
                "newStart": 450,
                "newLines": 114,
                "lines": [
                    "             'stats' => $stats,",
                    "         ];",
                    "     }",
                    "+",
                    "+    \/**",
                    "+     * Speichert Quality-Daten für eine Analyse.",
                    "+     *",
                    "+     * @param array<string, mixed> $qualityData",
                    "+     *\/",
                    "+    public function saveQuality(int $analysisId, array $qualityData): void",
                    "+    {",
                    "+        \/\/ Delete existing quality data",
                    "+        $this->pdo->prepare('DELETE FROM code_quality WHERE analysis_id = ?')->execute([$analysisId]);",
                    "+",
                    "+        $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",
                    "+            ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)",
                    "+        ');",
                    "+",
                    "+        $stmt->execute([",
                    "+            $analysisId,",
                    "+            $qualityData['complexity_score'] ?? 0,",
                    "+            $qualityData['loc_score'] ?? 0,",
                    "+            $qualityData['dependency_score'] ?? 0,",
                    "+            $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.",
                    "+     *",
                    "+     * @param array<string, mixed> $filters",
                    "+     * @return array<array<string, mixed>>",
                    "+     *\/",
                    "+    public function findAllWithQuality(array $filters = [], int $limit = 100, int $offset = 0): array",
                    "+    {",
                    "+        $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",
                    "+            FROM code_analysis ca",
                    "+            LEFT JOIN code_quality cq ON ca.id = cq.analysis_id",
                    "+            WHERE 1=1",
                    "+        ';",
                    "+        $params = [];",
                    "+",
                    "+        if (!empty($filters['extension'])) {",
                    "+            $sql .= ' AND ca.extension = :extension';",
                    "+            $params['extension'] = $filters['extension'];",
                    "+        }",
                    "+",
                    "+        if (!empty($filters['namespace'])) {",
                    "+            $sql .= ' AND ca.namespace = :namespace';",
                    "+            $params['namespace'] = $filters['namespace'];",
                    "+        }",
                    "+",
                    "+        if (!empty($filters['search'])) {",
                    "+            $sql .= ' AND (ca.file_name LIKE :search OR ca.namespace LIKE :search)';",
                    "+            $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['has_issues'])) {",
                    "+            $sql .= ' AND cq.issues_count > 0';",
                    "+        }",
                    "+",
                    "+        $sql .= ' ORDER BY ca.namespace, ca.file_name LIMIT :limit OFFSET :offset';",
                    "+",
                    "+        $stmt = $this->pdo->prepare($sql);",
                    "+        foreach ($params as $key => $value) {",
                    "+            $stmt->bindValue(':' . $key, $value);",
                    "+        }",
                    "+        $stmt->bindValue(':limit', $limit, PDO::PARAM_INT);",
                    "+        $stmt->bindValue(':offset', $offset, PDO::PARAM_INT);",
                    "+        $stmt->execute();",
                    "+",
                    "+        return $stmt->fetchAll(PDO::FETCH_ASSOC);",
                    "+    }",
                    "+",
                    "+    \/**",
                    "+     * Holt Quality-Statistiken.",
                    "+     *",
                    "+     * @return array<string, mixed>",
                    "+     *\/",
                    "+    public function getQualityStats(): array",
                    "+    {",
                    "+        $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(issues_count) as total_issues,",
                    "+                SUM(hardcoded_count) as total_hardcoded,",
                    "+                AVG(complexity_score) as avg_complexity",
                    "+            FROM code_quality",
                    "+        ');",
                    "+",
                    "+        return $stmt->fetch(PDO::FETCH_ASSOC) ?: [];",
                    "+    }",
                    " }"
                ]
            }
        ],
        "userModified": false,
        "replaceAll": false
    }
}