#!/usr/bin/env python3
"""
Extract December 2026 events from the calendar image
"""

import pandas as pd
from datetime import datetime
import os

def extract_december_2026_events():
    """
    Extract December 2026 events from the calendar image
    """
    
    # December 2026 events - extracted from the calendar image
    december_events = {
        '2026-12-02': 'CANADA CUP (HYBRID DRAW)',
        '2026-12-04': 'EPIC LADIES MEN EPIC XMAS PARTY',
        '2026-12-05': 'MENS 60 TEES LADIES 52\'S',
        '2026-12-06': 'SCRAMBLE',
        '2026-12-07': 'EPIC LADIES Pairs Scramble Draw (a.m) MEN - Q (p.m)',
        '2026-12-09': 'TEAM SCRAMBLE (DRAW FOR PARTNERS)',
        '2026-12-11': 'EPIC LADIES - Q MEN',
        '2026-12-12': 'MENS 60 TEES LADIES 52\'S',
        '2026-12-13': 'SCRAMBLE',
        '2026-12-14': 'EPIC LADIES (p.m) AMAM MEN (a.m)',
        '2026-12-16': 'MEDAL STABLEFORD 9-HOLE QUALIFIERS',
        '2026-12-18': 'EPIC LADIES MEN',
        '2026-12-19': 'MENS 60 TEES LADIES 52\'S',
        '2026-12-20': 'SCRAMBLE',
        '2026-12-21': 'EPIC - Q LADIES - Q (a.m) MEN (p.m)',
        '2026-12-23': 'GREENSOMES (OWN PARTNER)',
        '2026-12-24': 'XMAS EVE SCRAMBLE. SHOTGUN START 10 AM',
        '2026-12-25': 'XMAS DAY',
        '2026-12-26': 'JOINT CAPTAINS VS VICE CAPTAINS MATCHPLAY',
        '2026-12-27': 'SCRAMBLE',
        '2026-12-28': 'EPIC LADIES (a.m) Pairs Scramble (Draw) MEN (p.m)',
        '2026-12-30': 'PAIRS BETTERBALL (HYBRID DRAW)',
    }
    
    return december_events

def categorize_december_events():
    """
    Categorize December events by type
    """
    event_types = {}
    
    december_events = extract_december_2026_events()
    
    for date, event_name in december_events.items():
        if 'SCRAMBLE' in event_name:
            event_types[date] = 'Regular Event'
        elif 'EPIC' in event_name:
            event_types[date] = 'Regular Event'
        elif 'MENS' in event_name and 'LADIES' in event_name:
            event_types[date] = 'Regular Event'
        elif 'CANADA CUP' in event_name:
            event_types[date] = 'Tournament'
        elif 'XMAS' in event_name or 'CHRISTMAS' in event_name:
            event_types[date] = 'Holiday Event'
        elif 'STABLEFORD' in event_name or 'QUALIFIER' in event_name:
            event_types[date] = 'Qualifier'
        elif 'AMAM' in event_name or 'TEAM' in event_name:
            event_types[date] = 'Team Event'
        elif 'PAIRS' in event_name or 'BETTERBALL' in event_name:
            event_types[date] = 'Team Event'
        elif 'GREENSOMES' in event_name:
            event_types[date] = 'Team Event'
        elif 'MATCHPLAY' in event_name:
            event_types[date] = 'Match Play'
        else:
            event_types[date] = 'Regular Event'
    
    return event_types

def update_calendar_with_december():
    """
    Update the calendar with December events
    """
    
    # Get December events and types
    december_events = extract_december_2026_events()
    december_types = categorize_december_events()
    
    # Read existing calendar
    calendar_file = '/var/www/html/wordpress6/wordpress/EP/2026_CALENDAR_WITH_NOVEMBER.xlsx'
    
    try:
        # Read the main calendar sheet
        df = pd.read_excel(calendar_file, sheet_name='Full Calendar')
        
        # Update with December events
        for date, event_name in december_events.items():
            mask = df['Date'] == date
            df.loc[mask, 'Event Name'] = event_name
            if date in december_types:
                df.loc[mask, 'Event Type'] = december_types[date]
        
        # Save updated calendar
        output_file = '/var/www/html/wordpress6/wordpress/EP/2026_COMPLETE_CALENDAR_FINAL.xlsx'
        
        with pd.ExcelWriter(output_file, engine='openpyxl') as writer:
            # Main calendar sheet
            df.to_excel(writer, sheet_name='Full Calendar', index=False)
            
            # Create individual month sheets
            months = ['January', 'February', 'March', 'April', 'May', 'June',
                     'July', 'August', 'September', 'October', 'November', 'December']
            
            for month in months:
                month_data = df[df['Month'] == month].copy()
                month_data.to_excel(writer, sheet_name=month, index=False)
            
            # Create summary sheet
            summary_data = []
            for month in months:
                month_events = df[df['Month'] == month]
                events_count = len(month_events[month_events['Event Name'] != ''])
                summary_data.append({
                    'Month': month,
                    'Total Days': len(month_events),
                    'Events Scheduled': events_count,
                    'Days Available': len(month_events) - events_count,
                    'Event Percentage': f"{(events_count/len(month_events)*100):.1f}%"
                })
            
            summary_df = pd.DataFrame(summary_data)
            summary_df.to_excel(writer, sheet_name='Summary', index=False)
        
        print(f"Calendar updated with December events: {output_file}")
        print(f"December events added: {len(december_events)}")
        
        return output_file
        
    except Exception as e:
        print(f"Error updating calendar: {e}")
        return None

if __name__ == "__main__":
    print("Extracting December 2026 events...")
    
    # Extract December events
    december_events = extract_december_2026_events()
    print(f"December events extracted: {len(december_events)}")
    
    # Update calendar
    updated_file = update_calendar_with_december()
    
    if updated_file:
        print(f"\n✅ SUCCESS!")
        print(f"Updated calendar: {updated_file}")
        print("\nDecember 2026 events added:")
        for date, event in december_events.items():
            print(f"  {date}: {event}")
        
        print(f"\nTotal December events: {len(december_events)}")
        print("\n🎉 COMPLETE 2026 CALENDAR FINISHED! 🎉")
    else:
        print("❌ Error updating calendar")