Generate Timesheet Reports from Daily Logs in Python

import json
from pathlib import Path
from collections import defaultdict

def generate_timesheet_report(daily_logs: list[dict]) -> str:
    """
    Generate a timesheet report from daily log entries.
    
    Args:
        daily_logs: List of dicts with 'date', 'project', 'hours', 'task' keys
    
    Returns:
        Formatted timesheet report string
    """
    # Aggregate hours by project
    project_hours = defaultdict(float)
    project_details = defaultdict(list)
    
    for entry in daily_logs:
        project = entry['project']
        project_hours[project] += entry['hours']
        project_details[project].append(entry)
    
    # Build report
    lines = ["Timesheet Report", "=" * 40, ""]
    total_hours = 0.0
    
    for project in sorted(project_hours.keys()):
        lines.append(f"Project: {project}")
        lines.append(f"Total Hours: {project_hours[project]:.1f}")
        lines.append("Details:")
        for entry in project_details[project]:
            lines.append(f"  {entry['date']} - {entry['task']} ({entry['hours']}h)")
        lines.append("")
        total_hours += project_hours[project]
    
    lines.append("=" * 40)
    lines.append(f"Grand Total: {total_hours:.1f} hours")
    
    return "\n".join(lines)

if __name__ == "__main__":
    sample_logs = [
        {"date": "2024-01-15", "project": "Alpha", "hours": 4.0, "task": "Feature X"},
        {"date": "2024-01-15", "project": "Beta", "hours": 3.5, "task": "Bug fix"},
        {"date": "2024-01-16", "project": "Alpha", "hours": 5.0, "task": "Deploy"},
        {"date": "2024-01-16", "project": "Gamma", "hours": 2.0, "task": "Review"}
    ]
    
    report = generate_timesheet_report(sample_logs)
    print(report)