ikan Uploader :
Directory : /home/ni05r7l36tus/www/poojajewellersbbsr.com/admin/
Upload File : |
| Current File : //home/ni05r7l36tus/www/poojajewellersbbsr.com/admin/payment.php |
<?php include "common/header.php"; ?>
<!-- ==================================================== -->
<!-- Start right Content here -->
<!-- ==================================================== -->
<div class="page-content">
<!-- Start Container Fluid -->
<div class="container-xxl">
<div class="row d-none">
<div class="col-lg-12">
<div class="card bg-light-subtle">
<div class="card-header border-0">
<div class="row justify-content-between">
<div class="col-lg-6">
<div class="row align-items-center">
<div class="col-lg-6">
<form class="app-search d-none d-md-block me-auto">
<div class="position-relative">
<input type="search" class="form-control" placeholder="Search Coupons and Code" autocomplete="off" value="">
<iconify-icon icon="solar:magnifer-broken" class="search-widget-icon"></iconify-icon>
</div>
</form>
</div>
<div class="col-lg-4">
<h5 class="text-dark fw-medium mb-0">5,786 <span class="text-muted">Items</span></h5>
</div>
</div>
</div>
<div class="col-lg-6">
<div class="text-md-end mt-3 mt-md-0">
<button type="button" class="btn btn-outline-secondary me-1"><i class="bx bx-cog me-1"></i>More Setting</button>
<button type="button" class="btn btn-outline-secondary me-1"><i class="bx bx-filter-alt me-1"></i> Filters</button>
<button type="button" class="btn btn-success me-1"><i class="bx bx-plus"></i> New Coupons</button>
</div>
</div><!-- end col-->
</div>
</div>
</div>
</div>
</div>
<!-- Payment Table Section -->
<div class="row">
<div class="col-xl-12">
<div class="card">
<div class="table-responsive">
<?php
include 'connection/config.php';
// Fetch payment details joined with customer name
try {
$stmt = $pdo->query("
SELECT
p.payment_id,
p.allorder_id,
p.payment_method,
p.payment_status,
p.amount,
p.transaction_id,
p.created_at,
CONCAT(c.first_name, ' ', c.last_name) AS customer_name
FROM payments p
INNER JOIN customers c ON p.customer_id = c.customer_id
ORDER BY p.created_at DESC
");
$payments = $stmt->fetchAll();
} catch (PDOException $e) {
die("Error fetching payment data: " . $e->getMessage());
}
?>
<!-- HTML Table -->
<table class="table align-middle mb-0 table-hover table-centered">
<thead class="bg-light-subtle">
<tr>
<th>Payment ID</th>
<th>Customer Name</th>
<th>Order ID</th>
<th>Payment Method</th>
<th>Payment Status</th>
<th>Amount</th>
<th>Transaction ID</th>
<th>Created At</th>
</tr>
</thead>
<tbody>
<?php if (!empty($payments)): ?>
<?php foreach ($payments as $payment): ?>
<tr>
<td><?= htmlspecialchars($payment['payment_id']); ?></td>
<td><?= htmlspecialchars($payment['customer_name']); ?></td>
<td><?= htmlspecialchars($payment['allorder_id']); ?></td>
<td><?= htmlspecialchars(ucfirst($payment['payment_method'])); ?></td>
<td>
<?php
$status = htmlspecialchars($payment['payment_status']);
$badgeClass = match ($status) {
'completed' => 'bg-success',
'pending' => 'bg-warning',
'failed' => 'bg-danger',
default => 'bg-secondary',
};
?>
<span class="badge <?= $badgeClass; ?>">
<?= ucfirst($status); ?>
</span>
</td>
<td>₹<?= htmlspecialchars($payment['amount']); ?></td>
<td><?= !empty($payment['transaction_id']) ? htmlspecialchars($payment['transaction_id']) : 'N/A'; ?></td>
<td><?= date('d M Y', strtotime($payment['created_at'])); ?></td>
</tr>
<?php endforeach; ?>
<?php else: ?>
<tr><td colspan="8" class="text-center">No payments found</td></tr>
<?php endif; ?>
</tbody>
</table>
</div><!-- table-responsive -->
<div class="card-footer border-top">
<nav aria-label="Page navigation example">
<ul class="pagination justify-content-end mb-0">
<li class="page-item"><a class="page-link" href="#">Previous</a></li>
<li class="page-item active"><a class="page-link" href="#">1</a></li>
<li class="page-item"><a class="page-link" href="#">2</a></li>
<li class="page-item"><a class="page-link" href="#">3</a></li>
<li class="page-item"><a class="page-link" href="#">Next</a></li>
</ul>
</nav>
</div>
</div><!-- card -->
</div><!-- col -->
</div><!-- row -->
</div><!-- container-xxl -->
<!-- ========== Footer Start ========== -->
<?php include "common/footer.php"; ?>
<!-- ========== Footer End ========== -->
</div><!-- page-content -->
<!-- Vendor Javascript -->
<script src="assets/js/vendor.js"></script>
<!-- App Javascript -->
<script src="assets/js/app.js"></script>
</body>
</html>
........