7. Xây Dựng Executive Dashboard & Báo Cáo Sức Khỏe Dự Án Thời Gian Thực

# TÍNH TOÁN TIẾN ĐỘ DỰ ÁN THEO TRỌNG SỐ TỰ ĐỘNG
def calculate_project_health(project_id):
    tasks = get_tasks_by_project(project_id)
    total_tasks = len(tasks)
    if total_tasks == 0:
        return {'progress': 0, 'status': 'empty'}
    
    completed_tasks = len([t for t in tasks if t.status == 'done'])
    overdue_tasks = len([t for t in tasks if t.due_date < now() and t.status != 'done'])
    progress_pct = round((completed_tasks / total_tasks) * 100, 1)
    
    return {
        'progress_pct': progress_pct,
        'completed': completed_tasks,
        'total': total_tasks,
        'overdue_count': overdue_tasks,
        'health_badge': 'Healthy' if overdue_tasks == 0 else 'At Risk'
    }