<?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>
<div class="row">
<div class="col-xl-12">
<div class="card">
<div>
<div class="table-responsive">
<?php
include "connection/config.php"; // Your PDO connection
// Fetch product return details
$stmtReturns = $pdo->prepare("
SELECT
r.return_id,
r.allorder_id,
r.customer_id,
r.customer_name,
r.return_date,
r.customer_notes,
r.status,
r.created_at
FROM product_returns r
ORDER BY r.created_at DESC
");
$stmtReturns->execute();
$returns = $stmtReturns->fetchAll(PDO::FETCH_ASSOC);
?>
<!-- ========================= HTML TABLE ========================= -->
<div class="container mt-4">
<h4 class="mb-3">Product Return Requests</h4>
<div class="table-responsive">
<table class="table align-middle mb-0 table-hover table-centered">
<thead class="bg-light-subtle">
<tr>
<th>Return ID</th>
<th>Order ID</th>
<th>Customer Name</th>
<th>Reason / Notes</th>
<th>Status</th>
<th>Return Date</th>
<th>Requested At</th>
</tr>
</thead>
<tbody>
<?php if (!empty($returns)) : ?>
<?php foreach ($returns as $row) : ?>
<tr>
<td>RFD<?php echo str_pad($row['return_id'], 3, '0', STR_PAD_LEFT); ?></td>
<td><?php echo htmlspecialchars($row['allorder_id']); ?></td>
<td><?php echo htmlspecialchars($row['customer_name']); ?></td>
<td><?php echo htmlspecialchars($row['customer_notes'] ?: 'N/A'); ?></td>
<td>
<?php
$badgeClass = [
'Pending' => 'bg-warning',
'Approved' => 'bg-success',
'Rejected' => 'bg-danger',
'Refunded' => 'bg-info'
][$row['status']] ?? 'bg-secondary';
?>
<span class="badge <?php echo $badgeClass; ?>">
<?php echo htmlspecialchars($row['status']); ?>
</span>
</td>
<td><?php echo htmlspecialchars($row['return_date']); ?></td>
<td><?php echo date("d M Y", strtotime($row['created_at'])); ?></td>
</tr>
<?php endforeach; ?>
<?php else : ?>
<tr>
<td colspan="8" class="text-center text-muted">No product returns found.</td>
</tr>
<?php endif; ?>
</tbody>
</table>
</div>
</div>
</div>
</div>
<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="javascript:void(0);">Previous</a></li>
<li class="page-item active"><a class="page-link" href="javascript:void(0);">1</a></li>
<li class="page-item"><a class="page-link" href="javascript:void(0);">2</a></li>
<li class="page-item"><a class="page-link" href="javascript:void(0);">3</a></li>
<li class="page-item"><a class="page-link" href="javascript:void(0);">Next</a></li>
</ul>
</nav>
</div>
</div>
</div>
</div>
</div>
<!-- End Container Fluid -->
<!-- ========== Footer Start ========== -->
<?php include "common/footer.php" ?>
<!-- ========== Footer End ========== -->
</div>
<!-- ==================================================== -->
<!-- End Page Content -->
<!-- ==================================================== -->
</div>
<!-- END Wrapper -->
<!-- Vendor Javascript (Require in all Page) -->
<script src="assets/js/vendor.js"></script>
<!-- App Javascript (Require in all Page) -->
<script src="assets/js/app.js"></script>
</body>
<!-- Mirrored from techzaa.in/larkon/admin/coupons-list.html by HTTrack Website Copier/3.x [XR&CO'2014], Mon, 18 Aug 2025 09:05:18 GMT -->
</html>