<?php
/**
 * @var string $startDate
 * @var string $endDate
 * @var array $appointments
 */
?>
<div class="page-title mb-4">
    <h5><i class="fas fa-calendar-check me-2 text-gold"></i>Appointment Analysis Report</h5>
</div>

<div class="glass-card p-3 mb-4">
    <form class="row g-3 align-items-end" method="GET" action="<?= url('reports/appointments') ?>">
        <div class="col-md-3">
            <label class="form-label">Start Date</label>
            <input type="date" name="start_date" class="form-control" value="<?= e($startDate) ?>">
        </div>
        <div class="col-md-3">
            <label class="form-label">End Date</label>
            <input type="date" name="end_date" class="form-control" value="<?= e($endDate) ?>">
        </div>
        <div class="col-md-2">
            <label class="form-label">Status</label>
            <select name="status" class="form-select">
                <option value="">All</option>
                <?php foreach (appointmentStatuses() as $key => $label): ?>
                    <option value="<?= $key ?>" <?= ($_GET['status'] ?? '') === $key ? 'selected' : '' ?>><?= e($label) ?></option>
                <?php endforeach; ?>
            </select>
        </div>
        <div class="col-md-4">
            <button type="submit" class="btn btn-gold"><i class="fas fa-search me-1"></i>Generate</button>
            <a href="<?= url('reports/export/appointments?start_date=' . $startDate . '&end_date=' . $endDate . '&status=' . ($_GET['status'] ?? '')) ?>" class="btn btn-outline-gold ms-2">
                <i class="fas fa-download me-1"></i>CSV
            </a>
        </div>
    </form>
</div>

<?php
$totalAppointments = count($appointments);
$totalRevenue = array_sum(array_column($appointments, 'total'));
$completedCount = count(array_filter($appointments, fn($a) => $a->status === 'completed'));
$cancelledCount = count(array_filter($appointments, fn($a) => $a->status === 'cancelled'));
?>
<div class="row g-4 mb-4">
    <div class="col-md-3">
        <div class="glass-card stats-card">
            <div class="stats-icon" style="background:rgba(13,202,240,0.15);border-color:rgba(13,202,240,0.3);color:#0dcaf0;"><i class="fas fa-calendar-day"></i></div>
            <div class="stats-info">
                <span class="stats-label">Total Appointments</span>
                <span class="stats-value"><?= $totalAppointments ?></span>
            </div>
        </div>
    </div>
    <div class="col-md-3">
        <div class="glass-card stats-card">
            <div class="stats-icon" style="background:rgba(25,135,84,0.15);border-color:rgba(25,135,84,0.3);color:#198754;"><i class="fas fa-check-circle"></i></div>
            <div class="stats-info">
                <span class="stats-label">Completed</span>
                <span class="stats-value"><?= $completedCount ?></span>
            </div>
        </div>
    </div>
    <div class="col-md-3">
        <div class="glass-card stats-card">
            <div class="stats-icon" style="background:rgba(220,53,69,0.15);border-color:rgba(220,53,69,0.3);color:#dc3545;"><i class="fas fa-times-circle"></i></div>
            <div class="stats-info">
                <span class="stats-label">Cancelled</span>
                <span class="stats-value"><?= $cancelledCount ?></span>
            </div>
        </div>
    </div>
    <div class="col-md-3">
        <div class="glass-card stats-card">
            <div class="stats-icon" style="background:rgba(200,164,78,0.15);border-color:rgba(200,164,78,0.3);color:var(--gold-primary);"><i class="fas fa-dollar-sign"></i></div>
            <div class="stats-info">
                <span class="stats-label">Total Revenue</span>
                <span class="stats-value"><?= currency($totalRevenue) ?></span>
            </div>
        </div>
    </div>
</div>

<div class="glass-card p-0">
    <div class="card-header">
        <div class="card-header-left">
            <i class="fas fa-list card-icon"></i>
            <h6 class="card-title">Appointment Details</h6>
        </div>
    </div>
    <div class="table-responsive">
        <table class="table table-dark table-hover mb-0">
            <thead>
                <tr>
                    <th>Date</th>
                    <th>Time</th>
                    <th>Customer</th>
                    <th>Service</th>
                    <th>Employee</th>
                    <th class="text-end">Total</th>
                    <th>Status</th>
                </tr>
            </thead>
            <tbody>
                <?php if (empty($appointments)): ?>
                    <tr><td colspan="7" class="text-center text-muted py-4">No appointments found</td></tr>
                <?php else: ?>
                    <?php foreach ($appointments as $a): ?>
                        <tr>
                            <td><?= formatDate($a->start_time ?? '') ?></td>
                            <td><?= $a->start_time ? formatTime($a->start_time) : '-' ?></td>
                            <td><?= e(($a->customer_first_name ?? '') . ' ' . ($a->customer_last_name ?? '')) ?></td>
                            <td><?= e($a->service_name ?? '-') ?></td>
                            <td><?= e(($a->employee_first_name ?? '') . ' ' . ($a->employee_last_name ?? '')) ?></td>
                            <td class="text-end"><?= currency($a->total ?? 0) ?></td>
                            <td><span class="badge bg-<?= statusBadge($a->status ?? '') ?>"><?= e(ucwords(str_replace('_', ' ', $a->status ?? ''))) ?></span></td>
                        </tr>
                    <?php endforeach; ?>
                <?php endif; ?>
            </tbody>
        </table>
    </div>
</div>
