feuerwehr-vereinsshop/admin/reservations.php

<?php
require_once __DIR__ . '/../config.php';
require_once __DIR__ . '/../includes/functions.php';

// Check admin login
if (!isset($_SESSION['admin_logged_in']) || !$_SESSION['admin_logged_in']) {
    header('Location: login.php');
    exit;
}

$pageTitle = 'Reservierungen verwalten';

// Expire old reservations
expireOldReservations();

// Handle mark as picked up
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['mark_picked_up'])) {
    $reservationId = sanitize($_POST['reservation_id']);
    markReservationPickedUp($reservationId);
    $message = 'Reservierung als abgeholt markiert.';
    $messageType = 'success';
}
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['mark_hidden'])) {
    $reservationId = sanitize($_POST['reservation_id']);
    $result = markReservationHidden($reservationId);
    $message = $result['success'] ? 'Reservierung als Spam/Gelöscht markiert und ausgeblendet.' : $result['message'];
    $messageType = $result['success'] ? 'success' : 'error';
}

$reservations = getReservations();
$filter = isset($_GET['filter']) ? sanitize($_GET['filter']) : 'open';
$searchOrderNumber = isset($_GET['order_number']) ? sanitize($_GET['order_number']) : '';
$showAll = $filter === 'all';

// Exclude backorders
$reservations = array_filter($reservations, function($r) {
    return !isset($r['type']) || $r['type'] !== 'backorder';
});

if (!$showAll) {
    $reservations = array_filter($reservations, function($r) {
        return !isReservationHidden($r);
    });
}

// Filter reservations
if ($searchOrderNumber) {
    $reservations = array_filter($reservations, function($r) use ($searchOrderNumber) {
        return stripos($r['id'], $searchOrderNumber) !== false;
    });
} else {
    switch ($filter) {
        case 'open':
            $reservations = array_filter($reservations, function($r) {
                return $r['status'] === 'open' && !$r['picked_up'];
            });
            break;
        case 'picked_up':
            $reservations = array_filter($reservations, function($r) {
                return $r['picked_up'];
            });
            break;
        case 'expired':
            $reservations = array_filter($reservations, function($r) {
                return $r['status'] === 'expired';
            });
            break;
    }
}

$reservations = array_reverse($reservations); // Newest first

$bodyClass = 'admin-page';
include __DIR__ . '/../includes/header.php';
?>

<div class="admin-header">
    <h2>Reservierungen verwalten</h2>
    <div>
        <a href="index.php" class="btn btn-secondary">Zurück zum Dashboard</a>
    </div>
</div>

<?php if (isset($message)): ?>
    <div class="alert alert-<?php echo $messageType; ?>">
        <?php echo htmlspecialchars($message); ?>
    </div>
<?php endif; ?>

<div class="panel">
    <form method="GET" style="display: flex; gap: 1rem; align-items: end; flex-wrap: wrap;">
        <div style="flex: 1; min-width: 200px;">
            <label for="order_number">Bestellnummer suchen:</label>
            <input type="text" id="order_number" name="order_number" value="<?php echo htmlspecialchars($searchOrderNumber); ?>" placeholder="Bestellnummer">
        </div>
        <div>
            <label for="filter">Filter:</label>
            <select id="filter" name="filter">
                <option value="all" <?php echo $filter === 'all' ? 'selected' : ''; ?>>Alle</option>
                <option value="open" <?php echo $filter === 'open' ? 'selected' : ''; ?>>Offen</option>
                <option value="picked_up" <?php echo $filter === 'picked_up' ? 'selected' : ''; ?>>Abgeholt</option>
                <option value="expired" <?php echo $filter === 'expired' ? 'selected' : ''; ?>>Abgelaufen</option>
            </select>
        </div>
        <div>
            <button type="submit" class="btn">Filtern</button>
            <a href="reservations.php" class="btn btn-secondary">Zurücksetzen</a>
        </div>
    </form>
</div>

<?php if (empty($reservations)): ?>
    <div class="alert alert-info">
        <p>Keine Reservierungen gefunden.</p>
    </div>
<?php else: ?>
    <div class="table-responsive">
        <table class="responsive-table">
            <thead>
                <tr>
                    <th>Bestellnummer</th>
                    <th>Kunde</th>
                    <th>Artikel</th>
                    <th>Erstellt</th>
                    <th>Status</th>
                    <th>Aktionen</th>
                </tr>
            </thead>
            <tbody>
            <?php foreach ($reservations as $reservation): ?>
                <tr>
                    <td data-label="Bestellnummer"><strong><?php echo htmlspecialchars($reservation['id']); ?></strong></td>
                    <td data-label="Kunde"><?php echo htmlspecialchars($reservation['customer_name']); ?></td>
                    <td data-label="Artikel">
                        <?php
                        $itemCount = 0;
                        foreach ($reservation['items'] as $item) {
                            $itemCount += $item['quantity'];
                        }
                        echo $itemCount . ' Artikel';
                        ?>
                    </td>
                    <td data-label="Erstellt"><?php echo formatDate($reservation['created']); ?></td>
                    <td data-label="Status">
                        <?php
                        if (isReservationHidden($reservation)) {
                            echo '<span class="status status-hidden">Spam/Gelöscht</span>';
                        } elseif ($reservation['picked_up']) {
                            echo '<span class="status status-picked">Abgeholt</span>';
                        } elseif ($reservation['status'] === 'expired') {
                            echo '<span class="status status-expired">Abgelaufen</span>';
                        } else {
                            echo '<span class="status status-open">Offen</span>';
                        }
                        ?>
                    </td>
                    <td data-label="Aktionen">
                        <?php if (!isReservationHidden($reservation) && !$reservation['picked_up'] && $reservation['status'] === 'open'): ?>
                            <form method="POST" style="display: inline;" onsubmit="return confirm('Reservierung als abgeholt markieren?');">
                                <input type="hidden" name="reservation_id" value="<?php echo htmlspecialchars($reservation['id']); ?>">
                                <button type="submit" name="mark_picked_up" class="btn btn-small">Als abgeholt markieren</button>
                            </form>
                        <?php endif; ?>
                        <?php if (!isReservationHidden($reservation)): ?>
                            <form method="POST" style="display: inline;" onsubmit="return confirm('Reservierung als Spam/Gelöscht markieren? Die Reservierung wird überall ausgeblendet.');">
                                <input type="hidden" name="reservation_id" value="<?php echo htmlspecialchars($reservation['id']); ?>">
                                <button type="submit" name="mark_hidden" class="btn btn-secondary btn-small">Spam/Gelöscht</button>
                            </form>
                        <?php endif; ?>
                        <button onclick="showDetails('<?php echo htmlspecialchars($reservation['id']); ?>')" class="btn btn-secondary btn-small">Details</button>
                    </td>
                </tr>
            <?php endforeach; ?>
            </tbody>
        </table>
    </div>
<?php endif; ?>

<!-- Details Modal -->
<div id="detailsModal" class="modal">
    <div class="modal-content">
        <button onclick="closeDetails()" class="btn btn-small modal-close">Schließen</button>
        <div id="detailsContent"></div>
    </div>
</div>

<script>
function showDetails(reservationId) {
    const reservations = <?php echo json_encode(getReservations()); ?>;
    const reservation = reservations.find(r => r.id === reservationId);
    
    if (!reservation) return;
    
    let itemsHtml = '<h3>Artikel:</h3><ul>';
    reservation.items.forEach(item => {
        const product = <?php echo json_encode(getProducts()); ?>.find(p => p.id == item.product_id);
        if (product) {
            let sizeInfo = '';
            if (item.size && item.size !== '') {
                sizeInfo = ` - Größe: ${item.size}`;
            }
            itemsHtml += `<li>${product.name}${sizeInfo} - Menge: ${item.quantity}</li>`;
        }
    });
    itemsHtml += '</ul>';
    
    const isHidden = reservation.is_hidden === true;
    const statusText = isHidden ? 'Spam/Gelöscht' : (reservation.picked_up ? 'Abgeholt' : (reservation.status === 'expired' ? 'Abgelaufen' : 'Offen'));
    const statusClass = isHidden ? 'status-hidden' : (reservation.picked_up ? 'status-picked' : (reservation.status === 'expired' ? 'status-expired' : 'status-open'));
    const html = `
        <h2>Reservierungsdetails</h2>
        <p><strong>Bestellnummer:</strong> <strong class="order-highlight">${reservation.id}</strong></p>
        <p><strong>Kunde:</strong> ${reservation.customer_name}</p>
        <p><strong>E-Mail:</strong> ${reservation.customer_email}</p>
        <p><strong>Erstellt:</strong> ${reservation.created}</p>
        <p><strong>Gültig bis:</strong> ${reservation.expires}</p>
        <p><strong>Status:</strong> <span class="status ${statusClass}">${statusText}</span></p>
        ${itemsHtml}
    `;
    
    document.getElementById('detailsContent').innerHTML = html;
    document.getElementById('detailsModal').style.display = 'flex';
}

function closeDetails() {
    document.getElementById('detailsModal').style.display = 'none';
}
</script>

<?php include __DIR__ . '/../includes/footer.php'; ?>