import json
import sys
from datetime import datetime, timezone

# 读取数据
with open('/home/multica/.claude/projects/-home-multica-multica-workspaces-b5fdce19-2a82-455d-b644-5b83da2b3078-096a13b0-workdir/60943bd8-f20f-4049-ac1d-30a3882b3c59/tool-results/b2mzo0ssq.txt', 'r') as f:
    data = json.load(f)

# 当前时间
now = datetime(2026, 6, 18, 0, 0, 0, tzinfo=timezone.utc)

# 筛选需要检查的任务
issues_to_check = []
for issue in data['issues']:
    status = issue['status']
    # 排除已完成、已取消、积压的任务
    if status not in ['done', 'cancelled', 'backlog']:
        issues_to_check.append(issue)

print(f"总任务数: {len(data['issues'])}")
print(f"需要检查的任务数: {len(issues_to_check)}")
print(f"\n需要检查的任务列表:")
print("-" * 100)

for issue in issues_to_check:
    updated_at = datetime.fromisoformat(issue['updated_at'].replace('Z', '+00:00'))
    hours_since_update = (now - updated_at).total_seconds() / 3600
    
    print(f"\n{issue['identifier']}: {issue['title']}")
    print(f"  状态: {issue['status']}")
    print(f"  负责人: {issue.get('assignee_id', 'null')} ({issue.get('assignee_type', 'null')})")
    print(f"  最后更新: {issue['updated_at']} ({hours_since_update:.1f}小时前)")
    print(f"  优先级: {issue['priority']}")