ikan Uploader :
Directory : /home/ni05r7l36tus/www/poojajewellersbbsr.com/admin/
Upload File : |
| Current File : //home/ni05r7l36tus/www/poojajewellersbbsr.com/admin/allreturn.php |
<?php
include "connection/config.php";
// Handle status update (return status)
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['return_id'], $_POST['return_status'])) {
$stmtUpdate = $pdo->prepare("UPDATE product_returns SET status = ? WHERE return_id = ?");
$stmtUpdate->execute([$_POST['return_status'], $_POST['return_id']]);
header("Location: ".$_SERVER['PHP_SELF']);
exit;
}
// Fetch all product returns with customer details
$stmtReturns = $pdo->prepare("
SELECT r.*, c.first_name, c.last_name, c.email, c.phone
FROM product_returns r
JOIN customers c ON r.customer_id = c.customer_id
ORDER BY r.created_at DESC
");
$stmtReturns->execute();
$returns = $stmtReturns->fetchAll();
include "common/header.php";
?>
<!-- ==================================================== -->
<!-- Start right Content here -->
<!-- ==================================================== -->
<div>
<div class="page-content">
<div class="container-xxl">
<div class="row">
<div class="col-xl-12">
<div class="card">
<div class="d-flex card-header justify-content-between align-items-center">
<div>
<h4 class="card-title">All Order List</h4>
</div>
<div class="dropdown">
<a href="#" class="dropdown-toggle btn btn-sm btn-outline-light rounded" data-bs-toggle="dropdown" aria-expanded="false">
This Month
</a>
<div class="dropdown-menu dropdown-menu-end">
<a href="#!" class="dropdown-item">Download</a>
<a href="#!" class="dropdown-item">Export</a>
<a href="#!" class="dropdown-item">Import</a>
</div>
</div>
</div>
<div class="card mb-3">
<div class="card-body">
<div class="table-responsive">
<table class="table align-middle mb-0 table-hover table-centered">
<thead class="bg-light-subtle border-bottom">
<tr>
<th>SL.No.</th>
<th>Return ID</th>
<th>Order ID</th>
<th>Customer</th>
<th>Return Date</th>
<th>Status</th>
<th>Bank Details</th>
<th>Notes</th>
<th>Return PDF</th>
<th>Action</th>
</tr>
</thead>
<tbody>
<?php foreach ($returns as $index => $ret): ?>
<?php
$items = json_decode($ret['items_json'], true);
$itemsCount = is_array($items) ? count($items) : 0;
?>
<tr>
<td><?= $index + 1; ?></td>
<td><?= $ret['return_id']; ?></td>
<td><?= $ret['allorder_id']; ?></td>
<td>
<?= htmlspecialchars($ret['first_name'] . ' ' . $ret['last_name']); ?><br>
<small><?= $ret['email']; ?> | <?= $ret['phone']; ?></small>
</td>
<td><?= $ret['return_date']; ?></td>
<td>
<form method="post" style="display:inline;">
<input type="hidden" name="return_id" value="<?= $ret['return_id']; ?>">
<select name="return_status" class="form-select form-select-sm" onchange="this.form.submit()">
<?php
$statuses = ['Pending','Approved','Rejected','Refunded'];
foreach ($statuses as $status): ?>
<option value="<?= $status; ?>" <?php if ($ret['status'] === $status) echo 'selected'; ?>>
<?= $status; ?>
</option>
<?php endforeach; ?>
</select>
</form>
</td>
<td>
<?= htmlspecialchars($ret['bank_account_name']); ?><br>
<?= $ret['bank_account_number']; ?> (<?= $ret['ifsc_code']; ?>)<br>
<?= $ret['bank_name']; ?>, <?= $ret['bank_branch']; ?>
</td>
<td><?= nl2br(htmlspecialchars($ret['customer_notes'])); ?></td>
<td>
<?php if ($ret['return_pdf']): ?>
<a href="../<?= $ret['return_pdf']; ?>" target="_blank">Download PDF</a>
<?php else: ?>
No PDF
<?php endif; ?>
</td>
<td>
<button type="button" class="btn btn-primary" data-bs-toggle="modal" data-bs-target="#exampleModal<?= $ret['return_id']; ?>">View</button>
</td>
</tr>
<?php endforeach; ?>
</tbody>
</table>
</div>
</div>
</div>
<?php foreach ($returns as $index => $ret): ?>
<!-- Modal -->
<div class="modal fade" id="exampleModal<?= $ret['return_id']; ?>" tabindex="-1" aria-labelledby="exampleModalLabel<?= $ret['return_id']; ?>" aria-hidden="true">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<h5 class="modal-title" id="exampleModalLabel"><?= htmlspecialchars($ret['first_name'] . ' ' . $ret['last_name']); ?><br>
<small><?= $ret['email']; ?> | <?= $ret['phone']; ?></small></h5>
<button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
</div>
<div class="modal-body">
<table class="table table-bordered table-hover">
<thead class="table-light">
<tr>
<th>SL.No.</th>
<th>Product</th>
<th>Price</th>
</tr>
</thead>
<tbody>
<?php
$items = json_decode($ret['items_json'], true) ?: []; // Decode JSON
foreach ($items as $i => $item):
// Fetch product details
$stmtProduct = $pdo->prepare("SELECT product_name, thumbnail_image FROM products WHERE product_id = ?");
$stmtProduct->execute([$item['product_id']]);
$product = $stmtProduct->fetch(PDO::FETCH_ASSOC);
?>
<tr>
<td><?= $i + 1; ?></td>
<td>
<?php if ($product): ?>
<img src="../<?= htmlspecialchars($product['thumbnail_image'] ?? 'placeholder.png'); ?>"
alt="<?= htmlspecialchars($product['product_name'] ?? 'Product'); ?>"
style="width:50px; height:50px; margin-right:5px;">
<?= htmlspecialchars($product['product_name'] ?? 'Product'); ?>
<?php else: ?>
Product not found
<?php endif; ?>
</td>
<td>₹<?= htmlspecialchars($item['price'] ?? '0'); ?></td>
</tr>
<?php endforeach; ?>
</tbody>
</table>
</div>
<div class="modal-footer">
<button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Close</button>
<button type="button" class="btn btn-primary">Save changes</button>
</div>
</div>
</div>
</div>
<?php endforeach; ?>
</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>
<?php include "common/footer.php" ?>
</div>
</div>
<script src="assets/js/vendor.js"></script>
<script src="assets/js/app.js"></script>
</body>
</html>
........