<?php
include "connection/config.php";
// Handle status update (AJAX or form POST)
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['order_id'], $_POST['order_status'])) {
$stmtUpdate = $pdo->prepare("UPDATE allorders SET order_status = ? WHERE allorder_id = ?");
$stmtUpdate->execute([$_POST['order_status'], $_POST['order_id']]);
header("Location: ".$_SERVER['PHP_SELF']);
exit;
}
// Fetch all orders with customer details
$stmtOrders = $pdo->prepare("
SELECT o.*, c.first_name, c.last_name, c.email, c.phone
FROM allorders o
JOIN customers c ON o.customer_id = c.customer_id
ORDER BY o.created_at DESC
");
$stmtOrders->execute();
$orders = $stmtOrders->fetchAll();
include "common/header.php";
?>
<!-- ==================================================== -->
<!-- Start right Content here -->
<!-- ==================================================== -->
<div>
<div class="page-content">
<div class="container-xxl">
<!-- Stats Row -->
<div class="row">
<div class="row">
<div class="col-md-6 col-xl-3">
<div class="card">
<div class="card-body">
<div class="d-flex align-items-center justify-content-between">
<div>
<h4 class="card-title mb-2">Payment Refund</h4>
<p class="text-muted fw-medium fs-22 mb-0">₹490</p>
</div>
<div>
<div class="avatar-md bg-primary bg-opacity-10 rounded">
<iconify-icon icon="solar:chat-round-money-broken" class="fs-32 text-primary avatar-title"></iconify-icon>
</div>
</div>
</div>
</div>
</div>
</div>
<div class="col-md-6 col-xl-3">
<div class="card">
<div class="card-body">
<div class="d-flex align-items-center justify-content-between">
<div>
<h4 class="card-title mb-2">Order Cancel</h4>
<p class="text-muted fw-medium fs-22 mb-0">₹241</p>
</div>
<div>
<div class="avatar-md bg-primary bg-opacity-10 rounded">
<iconify-icon icon="solar:cart-cross-broken" class="fs-32 text-primary avatar-title"></iconify-icon>
</div>
</div>
</div>
</div>
</div>
</div>
<div class="col-md-6 col-xl-3">
<div class="card">
<div class="card-body">
<div class="d-flex align-items-center justify-content-between">
<div>
<h4 class="card-title mb-2">Order Shipped</h4>
<p class="text-muted fw-medium fs-22 mb-0">₹630</p>
</div>
<div>
<div class="avatar-md bg-primary bg-opacity-10 rounded">
<iconify-icon icon="solar:box-broken" class="fs-32 text-primary avatar-title"></iconify-icon>
</div>
</div>
</div>
</div>
</div>
</div>
<div class="col-md-6 col-xl-3">
<div class="card">
<div class="card-body">
<div class="d-flex align-items-center justify-content-between">
<div>
<h4 class="card-title mb-2">Order Delivering</h4>
<p class="text-muted fw-medium fs-22 mb-0">₹170</p>
</div>
<div>
<div class="avatar-md bg-primary bg-opacity-10 rounded">
<iconify-icon icon="solar:tram-broken" class="fs-32 text-primary avatar-title"></iconify-icon>
</div>
</div>
</div>
</div>
</div>
</div>
<div class="col-md-6 col-xl-3">
<div class="card">
<div class="card-body">
<div class="d-flex align-items-center justify-content-between">
<div>
<h4 class="card-title mb-2">Pending Review</h4>
<p class="text-muted fw-medium fs-22 mb-0">₹210</p>
</div>
<div>
<div class="avatar-md bg-primary bg-opacity-10 rounded">
<iconify-icon icon="solar:clipboard-remove-broken" class="fs-32 text-primary avatar-title"></iconify-icon>
</div>
</div>
</div>
</div>
</div>
</div>
<div class="col-md-6 col-xl-3">
<div class="card">
<div class="card-body">
<div class="d-flex align-items-center justify-content-between">
<div>
<h4 class="card-title mb-2">Pending Payment</h4>
<p class="text-muted fw-medium fs-22 mb-0">₹608</p>
</div>
<div>
<div class="avatar-md bg-primary bg-opacity-10 rounded">
<iconify-icon icon="solar:clock-circle-broken" class="fs-32 text-primary avatar-title"></iconify-icon>
</div>
</div>
</div>
</div>
</div>
</div>
<div class="col-md-6 col-xl-3">
<div class="card">
<div class="card-body">
<div class="d-flex align-items-center justify-content-between">
<div>
<h4 class="card-title mb-2">Delivered</h4>
<p class="text-muted fw-medium fs-22 mb-0">₹200</p>
</div>
<div>
<div class="avatar-md bg-primary bg-opacity-10 rounded">
<iconify-icon icon="solar:clipboard-check-broken" class="fs-32 text-primary avatar-title"></iconify-icon>
</div>
</div>
</div>
</div>
</div>
</div>
<div class="col-md-6 col-xl-3">
<div class="card">
<div class="card-body">
<div class="d-flex align-items-center justify-content-between">
<div>
<h4 class="card-title mb-2">In Progress</h4>
<p class="text-muted fw-medium fs-22 mb-0">₹656</p>
</div>
<div>
<div class="avatar-md bg-primary bg-opacity-10 rounded">
<iconify-icon icon="solar:inbox-line-broken" class="fs-32 text-primary avatar-title"></iconify-icon>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<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>Order ID</th>
<th>Customer Name</th>
<th>Status</th>
<th>Total Amount</th>
<th>No. of Items</th>
<th>Payment Status</th>
<th>Payment Method</th>
<th>Action</th>
</tr>
</thead>
<tbody>
<tbody>
<?php foreach ($orders as $orderIndex => $order): ?>
<?php
// Count items from order_json (since no order_items table is tied to allorders)
$orderItems = json_decode($order['order_json'], true);
$itemCount = is_array($orderItems) ? count($orderItems) : 0;
// Payment info
$stmtPayment = $pdo->prepare("SELECT * FROM payments WHERE allorder_id = ?");
$stmtPayment->execute([$order['allorder_id']]);
$payment = $stmtPayment->fetch();
$paymentStatus = $payment ? ucfirst($payment['payment_status']) : 'No Payment';
$paymentMethod = $payment ? ucfirst($payment['payment_method']) : 'Cash';
?>
<tr>
<td><?php echo $orderIndex + 1; ?></td>
<td><?php echo $order['allorder_id']; ?></td>
<td><?php echo htmlspecialchars($order['first_name'] . ' ' . $order['last_name']); ?></td>
<td>
<form method="post" style="display:inline;">
<input type="hidden" name="order_id" value="<?php echo $order['allorder_id']; ?>">
<select name="order_status" class="form-select form-select-sm" onchange="this.form.submit()">
<?php
$statuses = ['pending','confirmed','shipped','delivered','cancelled','active','returned','overdue'];
foreach ($statuses as $status): ?>
<option value="<?php echo $status; ?>" <?php if ($order['order_status'] === $status) echo 'selected'; ?>>
<?php echo ucfirst($status); ?>
</option>
<?php endforeach; ?>
</select>
</form>
</td>
<td>₹<?php echo number_format($order['final_amount'], 2); ?></td>
<td><?php echo $itemCount; ?></td>
<td><?php echo $paymentStatus; ?></td>
<td><?php echo $paymentMethod; ?></td>
<td>
<a href="orderdetail.php?allorder=<?php echo $order['allorder_id']; ?>">
<button type="button" class="btn btn-primary btn-sm">
View Order Details
</button>
</a>
</td>
</tr>
<?php endforeach; ?>
</tbody>
</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>
<?php include "common/footer.php" ?>
</div>
</div>
<script src="assets/js/vendor.js"></script>
<script src="assets/js/app.js"></script>
</body>
</html>