员工 任务 监控 代理

import pandas as pd
from datetime import datetime

def task_health():
    tasks = pd.read_sql("SELECT * FROM tasks WHERE status != 'Completed'")
    now = datetime.now()
    for _, task in tasks.iterrows():
        days_left = (task['deadline'] - now).days
        if days_left < 0: task['health'] = 'Overdue'
        elif days_left < 3: task['health'] = 'At Risk'
        elif days_left < 7: task['health'] = 'Warning'
        else: task['health'] = 'On Track'
    return tasks