check_person_report
Verify weekly report submission status for a specific individual. Input a name to track reporting compliance and ensure timely updates.
Instructions
Check if a specific person has submitted their weekly report
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| name | Yes |
Implementation Reference
- mcp_server/weekly_report_server.py:82-94 (handler)The handler function decorated with @mcp.tool(), implementing the core logic to check a specific person's weekly report status by fetching data from Google Sheets and returning formatted status message.@mcp.tool() def check_person_report(name: str) -> str: """Check if a specific person has submitted their weekly report""" report_data = get_report_data() if name not in report_data: return f"找不到 {name} 的資料。請確認名字是否正確。" if report_data[name]["submitted"]: return f"{name} 已於 {report_data[name]['timestamp']} 提交週報（{report_data[name]['days_ago']} 天前）。\n內容摘要：{report_data[name]['content'][:100]}..." else: return f"{name} 尚未提交本週週報。"
- Critical helper function that loads weekly report data from a Google Sheet named '週報', processes timestamps, and determines submission status for each team member within the last ~6.5 days.def get_report_data() -> Dict[str, Dict]: """Helper function to get report data from Google Sheets""" # Connect to Google Sheets sa = gspread.service_account(filename=SERVICE_ACCOUNT_FILE) sh = sa.open("週報") wks = sh.worksheet("週報") # Get current time current_time = datetime.datetime.now() # Dictionary to store report data for each person report_data = {name: { "submitted": False, "timestamp": None, "content": None, "days_ago": None } for name in NAME_LIST} # Check each row in the sheet for i in range(2, 15): # Assuming data starts from row 2 and goes to row 14 try: row = wks.get(f"A{i}:F{i}") if not row or not row[0][0]: # Skip empty rows continue # Parse the timestamp from the sheet item_time = datetime.datetime.strptime(row[0][0], '%m/%d/%Y %H:%M:%S') name = row[0][2] # Assuming name is in column C # Skip if the name is not in our list if name not in report_data: continue # Calculate days ago delta_sec = (current_time - item_time).total_seconds() days_ago = delta_sec / 86400 # Convert seconds to days # Check if the report was submitted within the last 6 days (518400 seconds + 12 hours buffer) if delta_sec < (518400 + 43200): report_data[name] = { "submitted": True, "timestamp": item_time.strftime('%Y-%m-%d %H:%M:%S'), "content": row[0][3] if len(row[0]) > 3 else "No content", # Assuming content is in column D "days_ago": round(days_ago, 1) } except Exception: continue return report_data
- Hardcoded list of team members whose reports are monitored by the tool.# Define the name lists NAME_LIST = ["陳冠宇", "林柏志", "潘班", "董屹煊", "王宇軒", "許圃瑄", "陳冠言", "黃祈緯", "黃渝凌"]
- mcp_server/weekly_report_server.py:82-82 (registration)The @mcp.tool() decorator registers the check_person_report function as an MCP tool.@mcp.tool()