Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-503.34.1.el9_5.x86_64

PHP Version:

8.2.30

User:

u329947844

Directory:

/home/u329947844/domains/spmodern.in/public_html/admin

Free Space:

10.3 TB

🔧 Quick Actions

✏️ Editing: orders-all.php

<?php
// ---------- server bootstrap ----------
include('includes/head.php');
include('includes/db.php');
if (session_status() === PHP_SESSION_NONE) session_start();

// Handle order actions (status change)
$flashMsg = null; $flashType = 'info';
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['action'])) {
    if ($_POST['action'] === 'update_status') {
        $orderId = (int)$_POST['order_id'];
        $status = mysqli_real_escape_string($conn, $_POST['status']);
        
        $updateSql = "UPDATE orders SET order_status = ?, updated_at = NOW() WHERE id = ?";
        $stmt = mysqli_prepare($conn, $updateSql);
        if ($stmt) {
            mysqli_stmt_bind_param($stmt, 'si', $status, $orderId);
            if (mysqli_stmt_execute($stmt)) {
                $flashMsg = 'Order status updated successfully!';
                $flashType = 'success';
            } else {
                $flashMsg = 'Failed to update order status.';
                $flashType = 'danger';
            }
            mysqli_stmt_close($stmt);
        }
    }
}

// Fetch all orders with customer information, items count, and tracking info
$sql = "SELECT 
            o.id,
            o.order_id,
            o.customer_name,
            o.customer_email,
            o.customer_phone,
            o.total_amount,
            o.order_status,
            o.payment_method,
            o.created_at,
            o.updated_at,
            COUNT(oi.id) as items_count,
            SUM(oi.quantity) as total_quantity,
            ot.tracking_number,
            ot.courier_service
        FROM orders o
        LEFT JOIN order_items oi ON o.id = oi.order_id
        LEFT JOIN order_tracking ot ON o.id = ot.order_id
        GROUP BY o.id
        ORDER BY o.created_at DESC";

$result = mysqli_query($conn, $sql);
$orders = [];

if ($result && mysqli_num_rows($result) > 0) {
    while ($row = mysqli_fetch_assoc($result)) {
        $orders[] = $row;
    }
}

function h($v){ return htmlspecialchars((string)$v, ENT_QUOTES, 'UTF-8'); }

// Get status counts for navigation
$statusCounts = [
    'pending' => 0,
    'confirmed' => 0,
    'shipped' => 0,
    'delivered' => 0,
    'cancelled' => 0,
    'total' => count($orders)
];

// Get counts for each status
foreach ($statusCounts as $status => $count) {
    if ($status !== 'total') {
        $countSql = "SELECT COUNT(*) as count FROM orders WHERE order_status = ?";
        $stmt = mysqli_prepare($conn, $countSql);
        mysqli_stmt_bind_param($stmt, 's', $status);
        mysqli_stmt_execute($stmt);
        $countResult = mysqli_stmt_get_result($stmt);
        $countRow = mysqli_fetch_assoc($countResult);
        $statusCounts[$status] = $countRow['count'];
        mysqli_stmt_close($stmt);
    }
}

// Calculate today's orders
$todaySql = "SELECT COUNT(*) as count FROM orders WHERE DATE(created_at) = CURDATE()";
$todayResult = mysqli_query($conn, $todaySql);
$todayCount = mysqli_fetch_assoc($todayResult)['count'];

// Calculate this week's orders
$weekSql = "SELECT COUNT(*) as count FROM orders WHERE YEARWEEK(created_at) = YEARWEEK(CURDATE())";
$weekResult = mysqli_query($conn, $weekSql);
$weekCount = mysqli_fetch_assoc($weekResult)['count'];

// Calculate this month's orders
$monthSql = "SELECT COUNT(*) as count FROM orders WHERE MONTH(created_at) = MONTH(CURDATE()) AND YEAR(created_at) = YEAR(CURDATE())";
$monthResult = mysqli_query($conn, $monthSql);
$monthCount = mysqli_fetch_assoc($monthResult)['count'];

// Calculate total revenue
$revenueSql = "SELECT SUM(total_amount) as total_revenue FROM orders WHERE order_status != 'cancelled'";
$revenueResult = mysqli_query($conn, $revenueSql);
$totalRevenue = mysqli_fetch_assoc($revenueResult)['total_revenue'] ?? 0;

// Courier services list for display
$courierServices = [
    'delhivery' => 'Delhivery',
    'bluedart' => 'Blue Dart',
    'dtdc' => 'DTDC',
    'fedex' => 'FedEx',
    'xpressbees' => 'XpressBees',
    'ekart' => 'Ekart',
    'shadowfax' => 'ShadowFax',
    'pickrr' => 'Pickrr',
    'shiprocket' => 'Shiprocket',
    'other' => 'Other'
];
?>

<?php if (!empty($flashMsg)): ?>
          <div class="alert alert-<?php echo htmlspecialchars($flashType); ?> alert-dismissible fade show" role="alert">
            <?php echo htmlspecialchars($flashMsg); ?>
            <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
          </div>
        <?php endif; ?>

<div class="d-flex align-items-center justify-content-between mb-4">
          <div>
            <h4 class="mb-1">All Orders</h4>
            <p class="text-muted mb-0">Complete overview of all customer orders</p>
          </div>
          <div class="d-flex gap-2">
            <button id="exportBtn" class="btn btn-outline-primary">
              <i class="fas fa-download me-2"></i>Export All
            </button>
          </div>
        </div>

<div class="row mb-4">
          <div class="col-md-3">
            <div class="card revenue-card">
              <div class="card-body">
                <div class="d-flex align-items-center">
                  <div class="flex-grow-1">
                    <h3 class="text-white mb-0">₹<?php echo number_format($totalRevenue, 2); ?></h3>
                    <span class="text-white-50">Total Revenue</span>
                  </div>
                  <div class="flex-shrink-0">
                    <i class="fas fa-rupee-sign fa-2x text-white-50"></i>
                  </div>
                </div>
              </div>
            </div>
          </div>
          <div class="col-md-3">
            <div class="card stats-card">
              <div class="card-body">
                <div class="d-flex align-items-center">
                  <div class="flex-grow-1">
                    <h4 class="mb-0"><?php echo $statusCounts['total']; ?></h4>
                    <span class="text-muted">Total Orders</span>
                  </div>
                  <div class="flex-shrink-0">
                    <div class="avatar-sm">
                      <span class="avatar-title bg-primary rounded-circle">
                        <i class="fas fa-shopping-bag fs-4"></i>
                      </span>
                    </div>
                  </div>
                </div>
              </div>
            </div>
          </div>
          <div class="col-md-3">
            <div class="card stats-card">
              <div class="card-body">
                <div class="d-flex align-items-center">
                  <div class="flex-grow-1">
                    <h4 class="mb-0"><?php echo $todayCount; ?></h4>
                    <span class="text-muted">Today's Orders</span>
                  </div>
                  <div class="flex-shrink-0">
                    <div class="avatar-sm">
                      <span class="avatar-title bg-success rounded-circle">
                        <i class="fas fa-calendar-day fs-4"></i>
                      </span>
                    </div>
                  </div>
                </div>
              </div>
            </div>
          </div>
          <div class="col-md-3">
            <div class="card stats-card">
              <div class="card-body">
                <div class="d-flex align-items-center">
                  <div class="flex-grow-1">
                    <h4 class="mb-0"><?php echo $monthCount; ?></h4>
                    <span class="text-muted">This Month</span>
                  </div>
                  <div class="flex-shrink-0">
                    <div class="avatar-sm">
                      <span class="avatar-title bg-info rounded-circle">
                        <i class="fas fa-calendar-alt fs-4"></i>
                      </span>
                    </div>
                  </div>
                </div>
              </div>
            </div>
          </div>
        </div>

<div class="row mb-4">
          <div class="col-md-2">
            <div class="card">
              <div class="card-body">
                <div class="d-flex align-items-center">
                  <div class="flex-grow-1">
                    <h4 class="mb-0"><?php echo $statusCounts['pending']; ?></h4>
                    <span class="text-muted">Pending</span>
                  </div>
                  <div class="flex-shrink-0">
                    <div class="avatar-sm">
                      <span class="avatar-title bg-warning rounded-circle">
                        <i class="fas fa-clock fs-4"></i>
                      </span>
                    </div>
                  </div>
                </div>
              </div>
            </div>
          </div>
          <div class="col-md-2">
            <div class="card">
              <div class="card-body">
                <div class="d-flex align-items-center">
                  <div class="flex-grow-1">
                    <h4 class="mb-0"><?php echo $statusCounts['confirmed']; ?></h4>
                    <span class="text-muted">Confirmed</span>
                  </div>
                  <div class="flex-shrink-0">
                    <div class="avatar-sm">
                      <span class="avatar-title bg-info rounded-circle">
                        <i class="fas fa-check-circle fs-4"></i>
                      </span>
                    </div>
                  </div>
                </div>
              </div>
            </div>
          </div>
          <div class="col-md-2">
            <div class="card">
              <div class="card-body">
                <div class="d-flex align-items-center">
                  <div class="flex-grow-1">
                    <h4 class="mb-0"><?php echo $statusCounts['shipped']; ?></h4>
                    <span class="text-muted">Shipped</span>
                  </div>
                  <div class="flex-shrink-0">
                    <div class="avatar-sm">
                      <span class="avatar-title bg-secondary rounded-circle">
                        <i class="fas fa-shipping-fast fs-4"></i>
                      </span>
                    </div>
                  </div>
                </div>
              </div>
            </div>
          </div>
          <div class="col-md-2">
            <div class="card">
              <div class="card-body">
                <div class="d-flex align-items-center">
                  <div class="flex-grow-1">
                    <h4 class="mb-0"><?php echo $statusCounts['delivered']; ?></h4>
                    <span class="text-muted">Delivered</span>
                  </div>
                  <div class="flex-shrink-0">
                    <div class="avatar-sm">
                      <span class="avatar-title bg-success rounded-circle">
                        <i class="fas fa-box-open fs-4"></i>
                      </span>
                    </div>
                  </div>
                </div>
              </div>
            </div>
          </div>
          <div class="col-md-2">
            <div class="card">
              <div class="card-body">
                <div class="d-flex align-items-center">
                  <div class="flex-grow-1">
                    <h4 class="mb-0"><?php echo $statusCounts['cancelled']; ?></h4>
                    <span class="text-muted">Cancelled</span>
                  </div>
                  <div class="flex-shrink-0">
                    <div class="avatar-sm">
                      <span class="avatar-title bg-danger rounded-circle">
                        <i class="fas fa-times-circle fs-4"></i>
                      </span>
                    </div>
                  </div>
                </div>
              </div>
            </div>
          </div>
          <div class="col-md-2">
            <div class="card">
              <div class="card-body">
                <div class="d-flex align-items-center">
                  <div class="flex-grow-1">
                    <h4 class="mb-0"><?php echo $weekCount; ?></h4>
                    <span class="text-muted">This Week</span>
                  </div>
                  <div class="flex-shrink-0">
                    <div class="avatar-sm">
                      <span class="avatar-title bg-primary rounded-circle">
                        <i class="fas fa-calendar-week fs-4"></i>
                      </span>
                    </div>
                  </div>
                </div>
              </div>
            </div>
          </div>
        </div>

<div class="card mb-4">
          <div class="card-body">
            <h6 class="card-title mb-3">Quick Navigation:</h6>
            <div class="d-flex flex-wrap gap-2">
              <a href="orders-all.php" class="btn btn-primary status-nav-btn page-active">
                All Orders (<?php echo $statusCounts['total']; ?>)
              </a>
              <a href="orders-pending.php" class="btn btn-outline-warning status-nav-btn">
                Pending (<?php echo $statusCounts['pending']; ?>)
              </a>
              <a href="orders-confirmed.php" class="btn btn-outline-info status-nav-btn">
                Confirmed (<?php echo $statusCounts['confirmed']; ?>)
              </a>
              <a href="orders-shipped.php" class="btn btn-outline-secondary status-nav-btn">
                Shipped (<?php echo $statusCounts['shipped']; ?>)
              </a>
              <a href="orders-delivered.php" class="btn btn-outline-success status-nav-btn">
                Delivered (<?php echo $statusCounts['delivered']; ?>)
              </a>
              <a href="orders-cancelled.php" class="btn btn-outline-danger status-nav-btn">
                Cancelled (<?php echo $statusCounts['cancelled']; ?>)
              </a>
            </div>
          </div>
        </div>

<div class="card">
          <div class="card-body">
            <div class="d-flex justify-content-between align-items-center mb-3">
              <h5 class="mb-0">All Orders (<?php echo count($orders); ?>)</h5>
              <div class="d-flex gap-2">
                <div class="input-group input-group-sm" style="width: 250px;">
                  <input type="text" id="searchInput" class="form-control" placeholder="Search all orders...">
                  <button class="btn btn-outline-secondary" type="button">
                    <i class="fas fa-search"></i>
                  </button>
                </div>
              </div>
            </div>

<table id="ordersTable" class="table table-bordered table-striped" style="width:100%">
              <thead>
                <tr>
                  <th>#</th>
                  <th>Order Details</th>
                  <th>Customer</th>
                  <th>Amount</th>
                  <th>Items</th>
                  <th>Status</th>
                  <th>Payment</th>
                  <th>Order Date</th>
                  <th>Actions</th>
                </tr>
              </thead>
              <tbody>
                <?php if (!empty($orders)): ?>
                  <?php $i = 1; ?>
                  <?php foreach ($orders as $order): ?>
                    <tr>
                      <td><?php echo $i++; ?></td>
                      <td>
                        <div>
                          <strong class="order-id">#<?php echo h($order['order_id']); ?></strong>
                          <div class="text-muted small mt-1">
                            ID: <?php echo $order['id']; ?>
                          </div>
                          <?php if (!empty($order['tracking_number'])): ?>
                            <div class="text-muted small">
                              Tracking: <?php echo h($order['tracking_number']); ?>
                            </div>
                          <?php endif; ?>
                        </div>
                      </td>
                      <td>
                        <div class="customer-info">
                          <strong><?php echo h($order['customer_name']); ?></strong>
                          <div class="text-muted small">
                            <?php echo h($order['customer_email']); ?>
                          </div>
                          <div class="text-muted small">
                            <?php echo h($order['customer_phone']); ?>
                          </div>
                        </div>
                      </td>
                      <td>
                        <strong class="text-success">₹<?php echo number_format($order['total_amount'], 2); ?></strong>
                      </td>
                      <td>
                        <div class="d-flex gap-1">
                          <span class="badge badge-items"><?php echo (int)$order['items_count']; ?> items</span>
                          <span class="badge badge-quantity"><?php echo (int)$order['total_quantity']; ?> qty</span>
                        </div>
                      </td>
                      <td>
                        <span class="order-status status-<?php echo h($order['order_status']); ?>">
                          <?php echo ucfirst(h($order['order_status'])); ?>
                        </span>
                      </td>
                      <td>
                        <span class="badge bg-light text-dark">
                          <?php echo strtoupper(h($order['payment_method'])); ?>
                        </span>
                      </td>
                      <td>
                        <div class="small">
                          <?php 
                          if ($ts = strtotime($order['created_at'])) {
                            echo date("M j, Y", $ts) . '<br><small class="text-muted">' . date("g:i A", $ts) . '</small>';
                          } else {
                            echo 'N/A';
                          }
                          ?>
                        </div>
                      </td>
                      <td>
                        <div class="action-buttons d-flex gap-1">
                          
                          <a href="order-view.php?id=<?php echo $order['id']; ?>" 
                             class="btn btn-sm btn-outline-primary" 
                             title="View Order">
                            <i class="fas fa-eye"></i>
                          </a>
                          
                          
                          <div class="dropdown">
                            <button class="btn btn-sm btn-outline-secondary dropdown-toggle" 
                                    type="button" 
                                    data-bs-toggle="dropdown" 
                                    title="Update Status">
                              <i class="fas fa-sync-alt"></i>
                            </button>
                            <ul class="dropdown-menu">
                              <li>
                                <form method="post" class="d-inline">
                                  <input type="hidden" name="action" value="update_status">
                                  <input type="hidden" name="order_id" value="<?php echo $order['id']; ?>">
                                  <input type="hidden" name="status" value="pending">
                                  <button type="submit" class="dropdown-item" 
                                          onclick="return confirm('Mark order as Pending?')">
                                    <span class="status-pending me-2">●</span>
                                    Mark as Pending
                                  </button>
                                </form>
                              </li>
                              <li>
                                <form method="post" class="d-inline">
                                  <input type="hidden" name="action" value="update_status">
                                  <input type="hidden" name="order_id" value="<?php echo $order['id']; ?>">
                                  <input type="hidden" name="status" value="confirmed">
                                  <button type="submit" class="dropdown-item" 
                                          onclick="return confirm('Mark order as Confirmed?')">
                                    <span class="status-confirmed me-2">●</span>
                                    Mark as Confirmed
                                  </button>
                                </form>
                              </li>
                              <li>
                                <form method="post" class="d-inline">
                                  <input type="hidden" name="action" value="update_status">
                                  <input type="hidden" name="order_id" value="<?php echo $order['id']; ?>">
                                  <input type="hidden" name="status" value="shipped">
                                  <button type="submit" class="dropdown-item" 
                                          onclick="return confirm('Mark order as Shipped?')">
                                    <span class="status-shipped me-2">●</span>
                                    Mark as Shipped
                                  </button>
                                </form>
                              </li>
                              <li>
                                <form method="post" class="d-inline">
                                  <input type="hidden" name="action" value="update_status">
                                  <input type="hidden" name="order_id" value="<?php echo $order['id']; ?>">
                                  <input type="hidden" name="status" value="delivered">
                                  <button type="submit" class="dropdown-item" 
                                          onclick="return confirm('Mark order as Delivered?')">
                                    <span class="status-delivered me-2">●</span>
                                    Mark as Delivered
                                  </button>
                                </form>
                              </li>
                              <li><hr class="dropdown-divider"></li>
                              <li>
                                <form method="post" class="d-inline">
                                  <input type="hidden" name="action" value="update_status">
                                  <input type="hidden" name="order_id" value="<?php echo $order['id']; ?>">
                                  <input type="hidden" name="status" value="cancelled">
                                  <button type="submit" class="dropdown-item text-danger" 
                                          onclick="return confirm('Cancel this order? This action cannot be undone.')">
                                    <span class="status-cancelled me-2">●</span>
                                    Cancel Order
                                  </button>
                                </form>
                              </li>
                            </ul>
                          </div>
                          
                          
                          <a href="order-invoice.php?id=<?php echo $order['id']; ?>" 
                             class="btn btn-sm btn-outline-info" 
                             title="Print Invoice" target="_blank">
                            <i class="fas fa-print"></i>
                          </a>
                        </div>
                      </td>
                    </tr>
                  <?php endforeach; ?>
                <?php else: ?>
                  <tr>
                    <td colspan="9" class="text-center py-4">
                      <div class="text-muted">
                        <i class="fas fa-shopping-bag fa-3x mb-3"></i>
                        <h5>No Orders Found</h5>
                        <p>No orders have been placed yet.</p>
                        <a href="products.php" class="btn btn-primary">
                          <i class="fas fa-plus me-2"></i>Add Products
                        </a>
                      </div>
                    </td>
                  </tr>
                <?php endif; ?>
              </tbody>
            </table>

</div>
        </div>

</div>
    </div>

<?php include('includes/footer.php'); ?>
  </div>
</div>

<?php include('includes/rightbar.php'); ?>
<?php include('includes/scripts.php'); ?>

<script src="https://code.jquery.com/jquery-3.7.1.min.js"></script>
<script src="https://cdn.datatables.net/1.13.7/js/jquery.dataTables.min.js"></script>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script>
<script>
$(document).ready(function () {
  var table = $('#ordersTable').DataTable({
    pageLength: 50,
    order: [[0, 'asc']],
    columnDefs: [
      { orderable: false, targets: [1, 2, 8] }, // Order details, customer, and actions not sortable
      { searchable: false, targets: [0, 3, 4, 5, 6, 7, 8] } // Some columns not searchable
    ],
    language: {
      search: "Search all orders:",
      lengthMenu: "Show _MENU_ orders per page",
      info: "Showing _START_ to _END_ of _TOTAL_ orders",
      infoEmpty: "No orders available",
      infoFiltered: "(filtered from _MAX_ total orders)"
    }
  });

// Search input
  $('#searchInput').on('keyup', function() {
    table.search(this.value).draw();
  });

// Export button functionality
  $('#exportBtn').on('click', function() {
    let csv = [];
    let rows = document.querySelectorAll('#ordersTable tr');
    
    for (let i = 0; i < rows.length; i++) {
      let row = [], cols = rows[i].querySelectorAll('td, th');
      
      for (let j = 0; j < cols.length; j++) {
        // Skip actions column
        if (j !== 8) {
          let text = cols[j].innerText.replace(/(\r\n|\n|\r)/gm, "").replace(/(\s\s)/gm, " ");
          row.push('"' + text + '"');
        }
      }
      
      csv.push(row.join(","));
    }

let csvString = csv.join('\n');
    let blob = new Blob([csvString], { type: 'text/csv' });
    let url = window.URL.createObjectURL(blob);
    let a = document.createElement('a');
    
    a.setAttribute('hidden', '');
    a.setAttribute('href', url);
    a.setAttribute('download', 'all_orders_' + new Date().toISOString().split('T')[0] + '.csv');
    document.body.appendChild(a);
    a.click();
    document.body.removeChild(a);
  });

// Status filter in search
  $('.status-filter').on('click', function() {
    const status = $(this).data('status');
    table.column(5).search(status).draw();
  });
});
</script>

</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: orders-all.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation