reservations.php 8.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212
  1. <?php
  2. require_once __DIR__ . '/../config.php';
  3. require_once __DIR__ . '/../includes/functions.php';
  4. // Check admin login
  5. if (!isset($_SESSION['admin_logged_in']) || !$_SESSION['admin_logged_in']) {
  6. header('Location: login.php');
  7. exit;
  8. }
  9. $pageTitle = 'Reservierungen verwalten';
  10. // Expire old reservations
  11. expireOldReservations();
  12. // Handle mark as picked up
  13. if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['mark_picked_up'])) {
  14. $reservationId = sanitize($_POST['reservation_id']);
  15. markReservationPickedUp($reservationId);
  16. $message = 'Reservierung als abgeholt markiert.';
  17. $messageType = 'success';
  18. }
  19. $reservations = getReservations();
  20. $filter = isset($_GET['filter']) ? sanitize($_GET['filter']) : 'all';
  21. $searchOrderNumber = isset($_GET['order_number']) ? sanitize($_GET['order_number']) : '';
  22. // Exclude backorders
  23. $reservations = array_filter($reservations, function($r) {
  24. return !isset($r['type']) || $r['type'] !== 'backorder';
  25. });
  26. // Filter reservations
  27. if ($searchOrderNumber) {
  28. $reservations = array_filter($reservations, function($r) use ($searchOrderNumber) {
  29. return stripos($r['id'], $searchOrderNumber) !== false;
  30. });
  31. } else {
  32. switch ($filter) {
  33. case 'open':
  34. $reservations = array_filter($reservations, function($r) {
  35. return $r['status'] === 'open' && !$r['picked_up'];
  36. });
  37. break;
  38. case 'picked_up':
  39. $reservations = array_filter($reservations, function($r) {
  40. return $r['picked_up'];
  41. });
  42. break;
  43. case 'expired':
  44. $reservations = array_filter($reservations, function($r) {
  45. return $r['status'] === 'expired';
  46. });
  47. break;
  48. }
  49. }
  50. $reservations = array_reverse($reservations); // Newest first
  51. $bodyClass = 'admin-page';
  52. include __DIR__ . '/../includes/header.php';
  53. ?>
  54. <div class="admin-header">
  55. <h2>Reservierungen verwalten</h2>
  56. <div>
  57. <a href="index.php" class="btn btn-secondary">Zurück zum Dashboard</a>
  58. </div>
  59. </div>
  60. <?php if (isset($message)): ?>
  61. <div class="alert alert-<?php echo $messageType; ?>">
  62. <?php echo htmlspecialchars($message); ?>
  63. </div>
  64. <?php endif; ?>
  65. <div class="panel">
  66. <form method="GET" style="display: flex; gap: 1rem; align-items: end; flex-wrap: wrap;">
  67. <div style="flex: 1; min-width: 200px;">
  68. <label for="order_number">Bestellnummer suchen:</label>
  69. <input type="text" id="order_number" name="order_number" value="<?php echo htmlspecialchars($searchOrderNumber); ?>" placeholder="Bestellnummer">
  70. </div>
  71. <div>
  72. <label for="filter">Filter:</label>
  73. <select id="filter" name="filter">
  74. <option value="all" <?php echo $filter === 'all' ? 'selected' : ''; ?>>Alle</option>
  75. <option value="open" <?php echo $filter === 'open' ? 'selected' : ''; ?>>Offen</option>
  76. <option value="picked_up" <?php echo $filter === 'picked_up' ? 'selected' : ''; ?>>Abgeholt</option>
  77. <option value="expired" <?php echo $filter === 'expired' ? 'selected' : ''; ?>>Abgelaufen</option>
  78. </select>
  79. </div>
  80. <div>
  81. <button type="submit" class="btn">Filtern</button>
  82. <a href="reservations.php" class="btn btn-secondary">Zurücksetzen</a>
  83. </div>
  84. </form>
  85. </div>
  86. <?php if (empty($reservations)): ?>
  87. <div class="alert alert-info">
  88. <p>Keine Reservierungen gefunden.</p>
  89. </div>
  90. <?php else: ?>
  91. <div class="table-responsive">
  92. <table>
  93. <thead>
  94. <tr>
  95. <th>Bestellnummer</th>
  96. <th>Kunde</th>
  97. <th>E-Mail</th>
  98. <th>Artikel</th>
  99. <th>Erstellt</th>
  100. <th>Gültig bis</th>
  101. <th>Status</th>
  102. <th>Aktionen</th>
  103. </tr>
  104. </thead>
  105. <tbody>
  106. <?php foreach ($reservations as $reservation): ?>
  107. <tr>
  108. <td><strong><?php echo htmlspecialchars($reservation['id']); ?></strong></td>
  109. <td><?php echo htmlspecialchars($reservation['customer_name']); ?></td>
  110. <td><?php echo htmlspecialchars($reservation['customer_email']); ?></td>
  111. <td>
  112. <?php
  113. $itemCount = 0;
  114. foreach ($reservation['items'] as $item) {
  115. $itemCount += $item['quantity'];
  116. }
  117. echo $itemCount . ' Artikel';
  118. ?>
  119. </td>
  120. <td><?php echo formatDate($reservation['created']); ?></td>
  121. <td><?php echo formatDate($reservation['expires']); ?></td>
  122. <td>
  123. <?php
  124. if ($reservation['picked_up']) {
  125. echo '<span class="status status-picked">Abgeholt</span>';
  126. } elseif ($reservation['status'] === 'expired') {
  127. echo '<span class="status status-expired">Abgelaufen</span>';
  128. } else {
  129. echo '<span class="status status-open">Offen</span>';
  130. }
  131. ?>
  132. </td>
  133. <td>
  134. <?php if (!$reservation['picked_up'] && $reservation['status'] === 'open'): ?>
  135. <form method="POST" style="display: inline;" onsubmit="return confirm('Reservierung als abgeholt markieren?');">
  136. <input type="hidden" name="reservation_id" value="<?php echo htmlspecialchars($reservation['id']); ?>">
  137. <button type="submit" name="mark_picked_up" class="btn btn-small">Als abgeholt markieren</button>
  138. </form>
  139. <?php endif; ?>
  140. <button onclick="showDetails('<?php echo htmlspecialchars($reservation['id']); ?>')" class="btn btn-secondary btn-small">Details</button>
  141. </td>
  142. </tr>
  143. <?php endforeach; ?>
  144. </tbody>
  145. </table>
  146. </div>
  147. <?php endif; ?>
  148. <!-- Details Modal -->
  149. <div id="detailsModal" class="modal">
  150. <div class="modal-content">
  151. <button onclick="closeDetails()" class="btn btn-small modal-close">Schließen</button>
  152. <div id="detailsContent"></div>
  153. </div>
  154. </div>
  155. <script>
  156. function showDetails(reservationId) {
  157. const reservations = <?php echo json_encode(getReservations()); ?>;
  158. const reservation = reservations.find(r => r.id === reservationId);
  159. if (!reservation) return;
  160. let itemsHtml = '<h3>Artikel:</h3><ul>';
  161. reservation.items.forEach(item => {
  162. const product = <?php echo json_encode(getProducts()); ?>.find(p => p.id == item.product_id);
  163. if (product) {
  164. let sizeInfo = '';
  165. if (item.size && item.size !== '') {
  166. sizeInfo = ` - Größe: ${item.size}`;
  167. }
  168. itemsHtml += `<li>${product.name}${sizeInfo} - Menge: ${item.quantity}</li>`;
  169. }
  170. });
  171. itemsHtml += '</ul>';
  172. const statusText = reservation.picked_up ? 'Abgeholt' : (reservation.status === 'expired' ? 'Abgelaufen' : 'Offen');
  173. const statusClass = reservation.picked_up ? 'status-picked' : (reservation.status === 'expired' ? 'status-expired' : 'status-open');
  174. const html = `
  175. <h2>Reservierungsdetails</h2>
  176. <p><strong>Bestellnummer:</strong> <strong class="order-highlight">${reservation.id}</strong></p>
  177. <p><strong>Kunde:</strong> ${reservation.customer_name}</p>
  178. <p><strong>E-Mail:</strong> ${reservation.customer_email}</p>
  179. <p><strong>Erstellt:</strong> ${reservation.created}</p>
  180. <p><strong>Gültig bis:</strong> ${reservation.expires}</p>
  181. <p><strong>Status:</strong> <span class="status ${statusClass}">${statusText}</span></p>
  182. ${itemsHtml}
  183. `;
  184. document.getElementById('detailsContent').innerHTML = html;
  185. document.getElementById('detailsModal').style.display = 'flex';
  186. }
  187. function closeDetails() {
  188. document.getElementById('detailsModal').style.display = 'none';
  189. }
  190. </script>
  191. <?php include __DIR__ . '/../includes/footer.php'; ?>