互联网行业任务协作平台搭建方案：敏捷项目管理（迭代任务 / 需求变更）适配方法

// 迭代任务状态管理示例
class IterationTask {
  constructor(id, title, estimate, priority) {
    this.id = id;
    this.title = title;
    this.estimate = estimate; // 预估工时
    this.priority = priority; // 任务优先级
    this.status = 'todo'; // 初始状态：待办
  }
  
  // 更新任务状态
  updateStatus(newStatus) {
    const validStatuses = ['todo', 'inProgress', 'review', 'done'];
    if (validStatuses.includes(newStatus)) {
      this.status = newStatus;
      this.logStatusChange();
    }
  }
  
  // 记录状态变更日志
  logStatusChange() {
    console.log(`任务 ${this.id} 状态变更为: ${this.status}`);
  }
}

// 创建迭代任务实例
const task = new IterationTask('TASK-001', '用户登录功能开发', 8, 'high');
task.updateStatus('inProgress');

// 需求变更处理示例
public class RequirementChangeProcessor
{
    public ChangeResponse EvaluateChangeImpact(ChangeRequest request, CurrentIteration iteration)
    {
        // 评估变更对当前迭代的影响
        var impact = new ChangeImpact();
        impact.EstimatedDelay = CalculateDelay(request, iteration);
        impact.ResourceAdjustment = CalculateResourceAdjustment(request, iteration);
        impact.PriorityConflict = CheckPriorityConflicts(request, iteration);
        
        // 生成变更响应建议
        var response = new ChangeResponse();
        response.ImpactAssessment = impact;
        response.Recommendation = impact.EstimatedDelay > 2 ? "DelayToNextIteration" : "AdjustCurrentIteration";
        
        return response;
    }
    
    private double CalculateDelay(ChangeRequest request, CurrentIteration iteration)
    {
        // 计算变更导致的预计延迟（人天）
        // 实际实现中会根据团队速度和任务依赖关系进行复杂计算
        return request.EstimatedEffort / iteration.TeamVelocity;
    }
}

-- 迭代进度查询示例
SELECT 
    i.iteration_name,
    COUNT(t.task_id) as total_tasks,
    SUM(CASE WHEN t.status = 'done' THEN 1 ELSE 0 END) as completed_tasks,
    ROUND(SUM(CASE WHEN t.status = 'done' THEN 1 ELSE 0 END) * 100.0 / COUNT(t.task_id), 2) as completion_rate,
    SUM(t.estimate_hours) as total_estimated_hours,
    SUM(CASE WHEN t.status = 'done' THEN t.actual_hours ELSE 0 END) as total_actual_hours
FROM 
    iterations i
LEFT JOIN 
    tasks t ON i.iteration_id = t.iteration_id
WHERE 
    i.project_id = @project_id
    AND i.start_date >= @start_date
GROUP BY 
    i.iteration_id, i.iteration_name
ORDER BY 
    i.start_date DESC;