Protokoll #24601

{
    "event": "PreToolUse",
    "tool_name": "Edit",
    "tool_input": {
        "file_path": "\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/EntityTaxonomyRepository.php",
        "old_string": "public function getUnvalidatedMappings(int $limit = 100): array",
        "new_string": "public function getUnvalidatedMappings(int $limit = Constants::DEFAULT_LIMIT): array"
    }
}

{
    "tool_response": {
        "filePath": "\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/EntityTaxonomyRepository.php",
        "oldString": "public function getUnvalidatedMappings(int $limit = 100): array",
        "newString": "public function getUnvalidatedMappings(int $limit = Constants::DEFAULT_LIMIT): array",
        "originalFile": "<?php\n\ndeclare(strict_types=1);\n\nnamespace Infrastructure\\Persistence;\n\n\/\/ @responsibility: CRUD-Operationen für Entity-Taxonomie-Mappings\n\nuse Domain\\Constants;\nuse Domain\\Entity\\EntityTaxonomyMapping;\nuse Domain\\Repository\\EntityTaxonomyRepositoryInterface;\nuse PDO;\n\nfinal class EntityTaxonomyRepository implements EntityTaxonomyRepositoryInterface\n{\n    private PDO $db;\n\n    public function __construct(PDO $pdo)\n    {\n        $this->db = $pdo;\n    }\n\n    \/**\n     * {@inheritDoc}\n     *\/\n    public function findByEntityId(int $entityId): array\n    {\n        $stmt = $this->db->prepare(\n            'SELECT * FROM entity_taxonomy_mapping WHERE entity_id = :entity_id ORDER BY relevance DESC'\n        );\n        $stmt->execute(['entity_id' => $entityId]);\n\n        $mappings = [];\n        foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $row) {\n            $mappings[] = EntityTaxonomyMapping::fromArray($row);\n        }\n\n        return $mappings;\n    }\n\n    \/**\n     * {@inheritDoc}\n     *\/\n    public function findByTaxonomyTermId(int $termId): array\n    {\n        $stmt = $this->db->prepare(\n            'SELECT entity_id, relevance, validated\n             FROM entity_taxonomy_mapping\n             WHERE taxonomy_term_id = :term_id\n             ORDER BY relevance DESC'\n        );\n        $stmt->execute(['term_id' => $termId]);\n\n        return $stmt->fetchAll(PDO::FETCH_ASSOC);\n    }\n\n    \/**\n     * {@inheritDoc}\n     *\/\n    public function save(EntityTaxonomyMapping $mapping): int\n    {\n        if ($mapping->getId() !== null) {\n            \/\/ Update\n            $stmt = $this->db->prepare(\n                'UPDATE entity_taxonomy_mapping\n                 SET entity_id = :entity_id,\n                     taxonomy_term_id = :term_id,\n                     relevance = :relevance,\n                     validated = :validated,\n                     updated_at = NOW()\n                 WHERE id = :id'\n            );\n            $stmt->execute([\n                'id' => $mapping->getId(),\n                'entity_id' => $mapping->getEntityId(),\n                'term_id' => $mapping->getTaxonomyTermId(),\n                'relevance' => $mapping->getRelevance()->value(),\n                'validated' => $mapping->isValidated() ? 1 : 0,\n            ]);\n\n            return $mapping->getId();\n        }\n\n        \/\/ Insert\n        $stmt = $this->db->prepare(\n            'INSERT INTO entity_taxonomy_mapping (entity_id, taxonomy_term_id, relevance, validated, created_at)\n             VALUES (:entity_id, :term_id, :relevance, :validated, :created_at)'\n        );\n        $stmt->execute([\n            'entity_id' => $mapping->getEntityId(),\n            'term_id' => $mapping->getTaxonomyTermId(),\n            'relevance' => $mapping->getRelevance()->value(),\n            'validated' => $mapping->isValidated() ? 1 : 0,\n            'created_at' => $mapping->getCreatedAt()->format('Y-m-d H:i:s'),\n        ]);\n\n        return (int) $this->db->lastInsertId();\n    }\n\n    \/**\n     * {@inheritDoc}\n     *\/\n    public function delete(int $id): bool\n    {\n        $stmt = $this->db->prepare('DELETE FROM entity_taxonomy_mapping WHERE id = :id');\n\n        return $stmt->execute(['id' => $id]);\n    }\n\n    \/**\n     * {@inheritDoc}\n     *\/\n    public function deleteByEntityId(int $entityId): int\n    {\n        $stmt = $this->db->prepare('DELETE FROM entity_taxonomy_mapping WHERE entity_id = :entity_id');\n        $stmt->execute(['entity_id' => $entityId]);\n\n        return $stmt->rowCount();\n    }\n\n    \/**\n     * {@inheritDoc}\n     *\/\n    public function getUnvalidatedMappings(int $limit = 100): array\n    {\n        $stmt = $this->db->prepare(\n            'SELECT * FROM entity_taxonomy_mapping\n             WHERE validated = 0\n             ORDER BY relevance DESC\n             LIMIT :limit'\n        );\n        $stmt->bindValue('limit', $limit, PDO::PARAM_INT);\n        $stmt->execute();\n\n        $mappings = [];\n        foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $row) {\n            $mappings[] = EntityTaxonomyMapping::fromArray($row);\n        }\n\n        return $mappings;\n    }\n\n    \/**\n     * {@inheritDoc}\n     *\/\n    public function markAsValidated(int $id): bool\n    {\n        $stmt = $this->db->prepare(\n            'UPDATE entity_taxonomy_mapping SET validated = 1, updated_at = NOW() WHERE id = :id'\n        );\n\n        return $stmt->execute(['id' => $id]);\n    }\n\n    \/**\n     * {@inheritDoc}\n     *\/\n    public function exists(int $entityId, int $taxonomyTermId): bool\n    {\n        $stmt = $this->db->prepare(\n            'SELECT COUNT(*) FROM entity_taxonomy_mapping\n             WHERE entity_id = :entity_id AND taxonomy_term_id = :term_id'\n        );\n        $stmt->execute([\n            'entity_id' => $entityId,\n            'term_id' => $taxonomyTermId,\n        ]);\n\n        return (int) $stmt->fetchColumn() > 0;\n    }\n\n    \/**\n     * {@inheritDoc}\n     *\/\n    public function getValidationStats(): array\n    {\n        $result = $this->db->query(\n            'SELECT\n                COUNT(*) as total,\n                SUM(CASE WHEN validated = 1 THEN 1 ELSE 0 END) as validated,\n                SUM(CASE WHEN validated = 0 THEN 1 ELSE 0 END) as pending\n             FROM entity_taxonomy_mapping'\n        )->fetch(PDO::FETCH_ASSOC);\n\n        return $result !== false ? [\n            'total' => (int) $result['total'],\n            'validated' => (int) $result['validated'],\n            'pending' => (int) $result['pending'],\n        ] : [\n            'total' => 0,\n            'validated' => 0,\n            'pending' => 0,\n        ];\n    }\n}\n",
        "structuredPatch": [
            {
                "oldStart": 121,
                "oldLines": 7,
                "newStart": 121,
                "newLines": 7,
                "lines": [
                    "     \/**",
                    "      * {@inheritDoc}",
                    "      *\/",
                    "-    public function getUnvalidatedMappings(int $limit = 100): array",
                    "+    public function getUnvalidatedMappings(int $limit = Constants::DEFAULT_LIMIT): array",
                    "     {",
                    "         $stmt = $this->db->prepare(",
                    "             'SELECT * FROM entity_taxonomy_mapping"
                ]
            }
        ],
        "userModified": false,
        "replaceAll": false
    }
}