{
"tool_response": {
"type": "text",
"file": {
"filePath": "\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/TaskRepository.php",
"content": "<?php\n\nnamespace Infrastructure\\Persistence;\n\nuse Domain\\Entity\\Task;\nuse Domain\\Repository\\TaskRepositoryInterface;\n\nclass TaskRepository implements TaskRepositoryInterface\n{\n private \\PDO $pdo;\n\n public function __construct()\n {\n $this->pdo = new \\PDO(\n 'mysql:host=' . KI_DEV_DB_HOST . ';dbname=' . KI_DEV_DB_NAME . ';charset=utf8mb4',\n KI_DEV_DB_USER,\n KI_DEV_DB_PASS,\n [\n \\PDO::ATTR_ERRMODE => \\PDO::ERRMODE_EXCEPTION,\n \\PDO::ATTR_DEFAULT_FETCH_MODE => \\PDO::FETCH_ASSOC,\n ]\n );\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",
"numLines": 249,
"startLine": 1,
"totalLines": 249
}
}
}