File Manager

Editing:payments.php

<?php define('PAGE_TITLE', 'Payments'); require_once 'includes/header.php';
$payments = $conn->query("SELECT p.*, b.booking_id as booking_no, cu.name as cname, cu.email as cemail FROM payments p JOIN bookings b ON p.booking_id=b.id JOIN customers cu ON p.customer_id=cu.id ORDER BY p.created_at DESC")->fetch_all(MYSQLI_ASSOC);
?>
<div class="d-flex justify-content-between align-items-center mb-4">
  <h4 class="fw-bold text-navy mb-0"><i class="bi bi-credit-card text-warning me-2"></i>Payments</h4>
</div>
<div class="premium-card p-4">
  <table class="table table-hover datatable">
    <thead><tr><th>ID</th><th>Booking</th><th>Customer</th><th>Amount</th><th>Type</th><th>Method</th><th>Date</th><th>Status</th><th>Action</th></tr></thead>
    <tbody><?php foreach ($payments as $p): ?>
      <tr><td><?= $p['id'] ?></td><td><?= $p['booking_no'] ?></td><td><?= htmlspecialchars($p['cname']) ?><br><small><?= $p['cemail'] ?></small></td>
      <td><?= formatPrice($p['amount']) ?></td><td><span class="badge bg-info"><?= $p['payment_type'] ?></span></td>
      <td><?= $p['payment_method'] ?: '-' ?></td><td><?= date('d M Y', strtotime($p['created_at'])) ?></td>
      <td><?= getStatusBadge($p['status']) ?></td>
      <td><a href="payment-verify.php?id=<?= $p['id'] ?>" class="btn btn-sm btn-outline-premium"><i class="bi bi-eye"></i></a></td></tr>
    <?php endforeach; ?></tbody>
  </table>
</div>
<?php require_once 'includes/footer.php'; ?>

Cancel

🤩 File Manager - Mr.X

Editing:payments.php