<?php
require_once 'config/database.php';

try {
    // Insert a sample holiday
    $stmt = $pdo->prepare('INSERT INTO academic_calendar (title, description, event_date, end_date, event_type, status) VALUES (?, ?, ?, ?, ?, ?)');
    $stmt->execute([
        'ঈদ উল আজহা', 
        'ঈদ উল আজহা ছুটি', 
        '2025-12-25', 
        '2025-12-30', 
        'holiday', 
        'active'
    ]);
    
    echo "Sample holiday added successfully!\n";
    
    // Also add a non-holiday event to test differentiation
    $stmt = $pdo->prepare('INSERT INTO academic_calendar (title, description, event_date, event_type, status) VALUES (?, ?, ?, ?, ?)');
    $stmt->execute([
        'বার্ষিক ক্রীড়া প্রতিযোগিতা', 
        'বার্ষিক ক্রীড়া প্রতিযোগিতা', 
        '2025-12-20', 
        'event', 
        'active'
    ]);
    
    echo "Sample event added successfully!\n";
} catch (Exception $e) {
    echo "Error: " . $e->getMessage() . "\n";
}