Protokoll #14288

{
    "event": "PreToolUse",
    "tool_name": "Edit",
    "tool_input": {
        "file_path": "\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/TaskRepository.php",
        "old_string": "    public function __construct(?\\PDO $pdo = null)\n    {\n        $this->pdo = $pdo ?? DatabaseFactory::dev();\n    }",
        "new_string": "    public function __construct(\\PDO $pdo)\n    {\n        $this->pdo = $pdo;\n    }"
    }
}

{
    "tool_response": {
        "filePath": "\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/TaskRepository.php",
        "oldString": "    public function __construct(?\\PDO $pdo = null)\n    {\n        $this->pdo = $pdo ?? DatabaseFactory::dev();\n    }",
        "newString": "    public function __construct(\\PDO $pdo)\n    {\n        $this->pdo = $pdo;\n    }",
        "originalFile": "<?php\n\ndeclare(strict_types=1);\n\nnamespace Infrastructure\\Persistence;\n\n\/\/ @responsibility: Persistenz für Tasks (CRUD, Suche, Pagination)\n\nuse Domain\\Entity\\Task;\nuse Domain\\Repository\\TaskRepositoryInterface;\n\nclass TaskRepository implements TaskRepositoryInterface\n{\n    private \\PDO $pdo;\n\n    public function __construct(?\\PDO $pdo = null)\n    {\n        $this->pdo = $pdo ?? DatabaseFactory::dev();\n    }\n\n    public function find(int $id): ?Task\n    {\n        $stmt = $this->pdo->prepare('SELECT * FROM tasks WHERE id = :id');\n        $stmt->execute(['id' => $id]);\n        $row = $stmt->fetch();\n\n        return $row !== false ? Task::fromArray($row) : null;\n    }\n\n    public function findById(int $id): ?Task\n    {\n        return $this->find($id);\n    }\n\n    public function findByUuid(string $uuid): ?Task\n    {\n        $stmt = $this->pdo->prepare('SELECT * FROM tasks WHERE uuid = :uuid');\n        $stmt->execute(['uuid' => $uuid]);\n        $row = $stmt->fetch();\n\n        return $row !== false ? Task::fromArray($row) : null;\n    }\n\n    public function findAll(array $filters = [], int $limit = 50, int $offset = 0): array\n    {\n        $where = [];\n        $params = [];\n\n        if (isset($filters['status']) && $filters['status'] !== '') {\n            $where[] = 'status = :status';\n            $params['status'] = $filters['status'];\n        }\n        if (isset($filters['type']) && $filters['type'] !== '') {\n            $where[] = 'type = :type';\n            $params['type'] = $filters['type'];\n        }\n        if (isset($filters['created_by']) && $filters['created_by'] !== '') {\n            $where[] = 'created_by = :created_by';\n            $params['created_by'] = $filters['created_by'];\n        }\n        if (isset($filters['search']) && $filters['search'] !== '') {\n            $where[] = '(title LIKE :search OR description LIKE :search)';\n            $params['search'] = '%' . $filters['search'] . '%';\n        }\n\n        $whereClause = count($where) > 0 ? 'WHERE ' . implode(' AND ', $where) : '';\n\n        $sql = \"SELECT * FROM tasks {$whereClause} ORDER BY created_at DESC 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        $tasks = [];\n        while ($row = $stmt->fetch()) {\n            $tasks[] = Task::fromArray($row);\n        }\n\n        return $tasks;\n    }\n\n    public function findByStatus(string $status, int $limit = 50): array\n    {\n        return $this->findAll(['status' => $status], $limit);\n    }\n\n    public function findByAssignee(string $assignee, int $limit = 50): array\n    {\n        $sql = 'SELECT t.* FROM tasks t\n                INNER JOIN task_assignments ta ON t.id = ta.task_id\n                WHERE ta.assignee = :assignee\n                ORDER BY t.created_at DESC\n                LIMIT :limit';\n\n        $stmt = $this->pdo->prepare($sql);\n        $stmt->bindValue(':assignee', $assignee);\n        $stmt->bindValue(':limit', $limit, \\PDO::PARAM_INT);\n        $stmt->execute();\n\n        $tasks = [];\n        while ($row = $stmt->fetch()) {\n            $tasks[] = Task::fromArray($row);\n        }\n\n        return $tasks;\n    }\n\n    public function findByCreator(string $createdBy, int $limit = 50): array\n    {\n        return $this->findAll(['created_by' => $createdBy], $limit);\n    }\n\n    public function findSubtasks(int $parentTaskId): array\n    {\n        $stmt = $this->pdo->prepare(\n            'SELECT * FROM tasks WHERE parent_task_id = :parent_id ORDER BY created_at ASC'\n        );\n        $stmt->execute(['parent_id' => $parentTaskId]);\n\n        $tasks = [];\n        while ($row = $stmt->fetch()) {\n            $tasks[] = Task::fromArray($row);\n        }\n\n        return $tasks;\n    }\n\n    public function save(Task $task): int\n    {\n        $sql = 'INSERT INTO tasks (\n            uuid, title, description, type, status,\n            created_by, created_by_type, parent_task_id, due_date,\n            created_at, updated_at, completed_at, metadata\n        ) VALUES (\n            :uuid, :title, :description, :type, :status,\n            :created_by, :created_by_type, :parent_task_id, :due_date,\n            :created_at, :updated_at, :completed_at, :metadata\n        )';\n\n        $stmt = $this->pdo->prepare($sql);\n        $data = $task->toArray();\n\n        $stmt->execute([\n            'uuid' => $data['uuid'],\n            'title' => $data['title'],\n            'description' => $data['description'],\n            'type' => $data['type'],\n            'status' => $data['status'],\n            'created_by' => $data['created_by'],\n            'created_by_type' => $data['created_by_type'],\n            'parent_task_id' => $data['parent_task_id'],\n            'due_date' => $data['due_date'],\n            'created_at' => $data['created_at'],\n            'updated_at' => $data['updated_at'],\n            'completed_at' => $data['completed_at'],\n            'metadata' => json_encode($data['metadata']),\n        ]);\n\n        return (int) $this->pdo->lastInsertId();\n    }\n\n    public function update(Task $task): bool\n    {\n        $sql = 'UPDATE tasks SET\n            title = :title,\n            description = :description,\n            type = :type,\n            status = :status,\n            parent_task_id = :parent_task_id,\n            due_date = :due_date,\n            updated_at = :updated_at,\n            completed_at = :completed_at,\n            metadata = :metadata\n        WHERE id = :id';\n\n        $stmt = $this->pdo->prepare($sql);\n        $data = $task->toArray();\n\n        return $stmt->execute([\n            'id' => $data['id'],\n            'title' => $data['title'],\n            'description' => $data['description'],\n            'type' => $data['type'],\n            'status' => $data['status'],\n            'parent_task_id' => $data['parent_task_id'],\n            'due_date' => $data['due_date'],\n            'updated_at' => $data['updated_at'],\n            'completed_at' => $data['completed_at'],\n            'metadata' => json_encode($data['metadata']),\n        ]);\n    }\n\n    public function delete(int $id): bool\n    {\n        $stmt = $this->pdo->prepare('DELETE FROM tasks WHERE id = :id');\n\n        return $stmt->execute(['id' => $id]);\n    }\n\n    public function count(array $filters = []): int\n    {\n        $where = [];\n        $params = [];\n\n        if (isset($filters['status']) && $filters['status'] !== '') {\n            $where[] = 'status = :status';\n            $params['status'] = $filters['status'];\n        }\n        if (isset($filters['type']) && $filters['type'] !== '') {\n            $where[] = 'type = :type';\n            $params['type'] = $filters['type'];\n        }\n\n        $whereClause = count($where) > 0 ? 'WHERE ' . implode(' AND ', $where) : '';\n\n        $stmt = $this->pdo->prepare(\"SELECT COUNT(*) FROM tasks {$whereClause}\");\n        $stmt->execute($params);\n\n        return (int) $stmt->fetchColumn();\n    }\n\n    public function getStatistics(): array\n    {\n        $sql = \"SELECT\n            COUNT(*) as total,\n            SUM(CASE WHEN status = 'pending' THEN 1 ELSE 0 END) as pending,\n            SUM(CASE WHEN status = 'in_progress' THEN 1 ELSE 0 END) as in_progress,\n            SUM(CASE WHEN status = 'completed' THEN 1 ELSE 0 END) as completed,\n            SUM(CASE WHEN status = 'failed' THEN 1 ELSE 0 END) as failed,\n            SUM(CASE WHEN status = 'cancelled' THEN 1 ELSE 0 END) as cancelled,\n            SUM(CASE WHEN type = 'human_task' THEN 1 ELSE 0 END) as human_tasks,\n            SUM(CASE WHEN type = 'ai_task' THEN 1 ELSE 0 END) as ai_tasks,\n            SUM(CASE WHEN type = 'mixed' THEN 1 ELSE 0 END) as mixed_tasks\n        FROM tasks\";\n\n        $stmt = $this->pdo->query($sql);\n\n        return $stmt->fetch();\n    }\n}\n",
        "structuredPatch": [
            {
                "oldStart": 13,
                "oldLines": 9,
                "newStart": 13,
                "newLines": 9,
                "lines": [
                    " {",
                    "     private \\PDO $pdo;",
                    " ",
                    "-    public function __construct(?\\PDO $pdo = null)",
                    "+    public function __construct(\\PDO $pdo)",
                    "     {",
                    "-        $this->pdo = $pdo ?? DatabaseFactory::dev();",
                    "+        $this->pdo = $pdo;",
                    "     }",
                    " ",
                    "     public function find(int $id): ?Task"
                ]
            }
        ],
        "userModified": false,
        "replaceAll": false
    }
}