ASA (After-School Activities)

<?php
$config = [
    'db' => [
        'dsn' => 'mysql:host=localhost;dbname=schoolkit;charset=utf8mb4',
        'user' => 'your_username',
        'pass' => 'your_password'
    ],
    'storage_path' => __DIR__ . '/storage'
];

$schoolKit = SchoolKit::start($config);
$asa = $schoolKit->asa();

// ASA module is now ready for activity management
echo "ASA module initialized successfully";
?>

<?php
$config = [
    'db' => [
        'dsn' => 'mysql:host=localhost;dbname=schoolkit;charset=utf8mb4',
        'user' => 'your_username',
        'pass' => 'your_password'
    ],
    'storage_path' => __DIR__ . '/storage'
];

$schoolKit = SchoolKit::start($config);
$asa = $schoolKit->asa();

$activityId = $asa->createActivity([
    'title' => 'Basketball Club',
    'season' => 'winter',
    'day_of_week' => 1, // Monday (0=Sunday, 1=Monday, etc.)
    'start_time' => '15:30:00',
    'end_time' => '17:00:00',
    'capacity' => 20,
    'fee' => 50.00,
    'location' => 'Gymnasium'
]);

echo "Activity created with ID: $activityId";
?>

<?php
$updated = $asa->updateActivity($activityId, [
    'title' => 'Advanced Basketball Club',
    'capacity' => 25,
    'fee' => 60.00
]);

if ($updated) {
    echo "Activity updated successfully";
}
?>

<?php
if ($asa->archiveActivity($activityId)) {
    echo "Activity archived successfully";
}
?>

<?php
// Get all winter activities
$winterActivities = $asa->listActivities(['season' => 'winter']);

// Get non-archived activities
$activeActivities = $asa->listActivities(['archived' => 0]);

// Get all activities sorted by title
$allActivities = $asa->listActivities([], ['order' => ['title' => 'ASC']]);

foreach ($winterActivities as $activity) {
    echo $activity['title'] . " - " . $activity['day_of_week'] . "\n";
}
?>

<?php
// Assign a head coach
$asa->assignStaff($activityId, $staffId, 'head_coach');

// Assign an assistant coach
$asa->assignStaff($activityId, $assistantStaffId, 'assistant_coach');

// Default role is 'coach'
$asa->assignStaff($activityId, $coachStaffId);
?>

<?php
$staff = $asa->listActivityStaff($activityId);

foreach ($staff as $member) {
    echo $member['first_name'] . " " . $member['last_name'];
    echo " (" . $member['activity_role'] . ")\n";
}
?>

<?php
if ($asa->removeStaff($activityId, $staffId)) {
    echo "Staff member removed from activity";
}
?>

<?php
$result = $asa->register($activityId, $studentId);

if ($result['status'] === 'confirmed') {
    echo "Successfully registered for activity!";
} elseif ($result['status'] === 'waitlisted') {
    echo "Added to waitlist (position: " . $result['waitlist_position'] . ")";
}
?>

<?php
if ($asa->cancelRegistration($registrationId)) {
    echo "Registration cancelled successfully";
}
?>

<?php
// Get all confirmed registrations
$confirmedRegistrations = $asa->registrations($activityId, ['status' => 'confirmed']);

// Get waitlisted students
$waitlist = $asa->registrations($activityId, ['status' => 'waitlisted']);

foreach ($confirmedRegistrations as $reg) {
    echo $reg['first_name'] . " " . $reg['last_name'] . "\n";
}
?>

<?php
if ($asa->isFull($activityId)) {
    echo "Activity is full - new registrations will be waitlisted";
} else {
    echo "Spots available for registration";
}
?>

<?php
// Promote next student in waitlist order
$promotedRegistrationId = $asa->promoteFromWaitlist($activityId);

if ($promotedRegistrationId) {
    echo "Registration ID $promotedRegistrationId promoted from waitlist";
} else {
    echo "No students on waitlist or activity is full";
}

// Promote specific student
$specificRegistrationId = $asa->promoteFromWaitlist($activityId, $studentId);
?>

<?php
// Mark student present
$asa->markAttendance($activityId, '2024-03-15', $studentId, true);

// Mark student absent
$asa->markAttendance($activityId, '2024-03-15', $absentStudentId, false);
?>

<?php
$attendance = $asa->attendanceSheet($activityId, '2024-03-15');

foreach ($attendance as $record) {
    $status = $record['present'] ? 'Present' : 'Absent';
    echo $record['first_name'] . " " . $record['last_name'] . ": " . $status . "\n";
}
?>

<?php
// Record full payment
$paymentRecorded = $asa->recordPayment($registrationId, 50.00);

if ($paymentRecorded) {
    echo "Payment recorded successfully";
}
?>

<?php
$csvFilePath = $asa->exportRosterCSV($activityId);

// Output the CSV file
header('Content-Type: text/csv');
header('Content-Disposition: attachment; filename="activity-roster.csv"');
readfile($csvFilePath);

// Optional: Clean up file after download
unlink($csvFilePath);
?>

<?php
$csvFilePath = $asa->exportAttendanceCSV(
    $activityId, 
    '2024-03-01', 
    '2024-03-31'
);

// Output the CSV file
header('Content-Type: text/csv');
header('Content-Disposition: attachment; filename="attendance-report.csv"');
readfile($csvFilePath);

// Optional: Clean up file after download
unlink($csvFilePath);
?>