Tul xxx Tul

Viewing: rsvp.php

<?php
$db = getDB();
$rsvps = $db->query('SELECT * FROM rsvp_confirmations ORDER BY created_at DESC')->fetchAll();
$total = count($rsvps);
$confirmed = 0;
$totalGuests = 0;
foreach ($rsvps as $r) {
    if (strpos($r['status'], 'asistiremos') !== false && strpos($r['status'], 'No') === false) {
        $confirmed++;
        $totalGuests += $r['guests_count'];
    }
}
?>

<div class="stats-grid">
    <div class="stat-card">
        <div class="stat-icon purple"><i class="ph-fill ph-envelope-open"></i></div>
        <div class="stat-info">
            <div class="stat-label">Total Respuestas</div>
            <div class="stat-number"><?= $total ?></div>
        </div>
    </div>
    <div class="stat-card">
        <div class="stat-icon green"><i class="ph-fill ph-check-circle"></i></div>
        <div class="stat-info">
            <div class="stat-label">Confirmados</div>
            <div class="stat-number"><?= $confirmed ?></div>
        </div>
    </div>
    <div class="stat-card">
        <div class="stat-icon gold"><i class="ph-fill ph-users"></i></div>
        <div class="stat-info">
            <div class="stat-label">Total Invitados</div>
            <div class="stat-number"><?= $totalGuests ?></div>
        </div>
    </div>
</div>

<div class="admin-card">
    <div class="card-header">
        <div class="card-title"><i class="ph-fill ph-list-checks"></i> Listado de Confirmaciones</div>
    </div>
    <?php if (empty($rsvps)): ?>
        <div class="empty-state">
            <i class="ph-fill ph-envelope-simple"></i>
            <p>No hay confirmaciones registradas</p>
        </div>
    <?php else: ?>
        <table class="admin-table">
            <thead>
                <tr><th>Nombres</th><th>Invitados</th><th>Estado</th><th>Fecha</th><th>Acciones</th></tr>
            </thead>
            <tbody>
                <?php foreach ($rsvps as $r): ?>
                <tr>
                    <td style="font-weight:600;"><?= htmlspecialchars($r['names'] ?: '—') ?></td>
                    <td><span class="badge badge-info"><?= $r['guests_count'] ?></span></td>
                    <td>
                        <span class="badge <?= (strpos($r['status'], 'asistiremos') !== false && strpos($r['status'], 'No') === false) ? 'badge-success' : 'badge-danger' ?>">
                            <?= htmlspecialchars($r['status']) ?>
                        </span>
                    </td>
                    <td style="color:var(--admin-text-muted);font-size:.82rem;"><?= date('d/m/Y H:i', strtotime($r['created_at'])) ?></td>
                    <td>
                        <button class="btn-icon danger" onclick="confirmDelete('confirmación',<?= $r['id'] ?>, deleteRsvp)">
                            <i class="ph-bold ph-trash"></i>
                        </button>
                    </td>
                </tr>
                <?php endforeach; ?>
            </tbody>
        </table>
    <?php endif; ?>
</div>

<script>
async function deleteRsvp(id) {
    const result = await adminFetch('delete_rsvp', { id });
    if (result.success) setTimeout(() => location.reload(), 500);
}
</script>
User / IP	: 216.73.216.159
Host / Server	: 45.84.207.204 / aircan.me
System	: Linux lt-bnk-web1726.main-hosting.eu 5.14.0-611.36.1.el9_7.x86_64 #1 SMP PREEMPT_DYNAMIC Tue Mar 3 11:23:52 EST 2026 x86_64