File Manager

Editing:my-payments.php

<?php require_once __DIR__ . '/../config/config.php'; require_once __DIR__ . '/../includes/functions.php';
if (!isLoggedIn()) redirect(SITE_URL . 'customer/login.php');
global $conn;
$stmt = $conn->prepare("SELECT p.*, b.booking_id as booking_no, b.package_id, pk.name as package_name FROM payments p JOIN bookings b ON p.booking_id = b.id JOIN packages pk ON b.package_id = pk.id WHERE p.customer_id = ? ORDER BY p.created_at DESC");
$stmt->bind_param("i", $_SESSION['customer_id']); $stmt->execute();
$payments = $stmt->get_result()->fetch_all(MYSQLI_ASSOC);
define('PAGE_TITLE', 'My Payments');
include 'dashboard-header.php'; ?>
<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>My Payments</h4>
</div>
<div class="premium-card p-4">
  <div class="table-responsive">
    <table class="table table-hover datatable">
      <thead><tr><th>Booking</th><th>Amount</th><th>Type</th><th>Date</th><th>Status</th><th>Receipt</th></tr></thead>
      <tbody><?php foreach ($payments as $p): ?>
        <tr><td><?= $p['booking_no'] ?> (<?= $p['package_name'] ?>)</td><td><?= formatPrice($p['amount']) ?></td>
        <td><span class="badge bg-info"><?= $p['payment_type'] ?></span></td><td><?= date('d M Y', strtotime($p['created_at'])) ?></td>
        <td><?= getStatusBadge($p['status']) ?></td>
        <td><?= $p['receipt_image'] ? '<a href="'.SITE_URL.'uploads/payments/'.$p['receipt_image'].'" target="_blank" class="btn btn-sm btn-outline-premium"><i class="bi bi-eye"></i></a>' : '-' ?></td></tr>
      <?php endforeach; ?></tbody>
    </table>
  </div>
</div>
<?php include 'dashboard-footer.php'; ?>

Cancel

🤩 File Manager - Mr.X

Editing:my-payments.php