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-new.php

<!doctype html>
<html lang="en">
<?php
// ---------- server bootstrap ----------
include('includes/head.php');
include('includes/db.php');
if (session_status() === PHP_SESSION_NONE) session_start();

// Define order statuses
$orderStatuses = ['pending', 'confirmed', 'shipped', 'delivered', 'cancelled'];

// 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 = ? 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';
                
                // Add status update timestamp
                $timestampSql = "UPDATE orders SET updated_at = NOW() WHERE id = ?";
                $stmt2 = mysqli_prepare($conn, $timestampSql);
                if ($stmt2) {
                    mysqli_stmt_bind_param($stmt2, 'i', $orderId);
                    mysqli_stmt_execute($stmt2);
                    mysqli_stmt_close($stmt2);
                }
            } else {
                $flashMsg = 'Failed to update order status.';
                $flashType = 'danger';
            }
            mysqli_stmt_close($stmt);
        }
    }
}

// Fetch all orders with customer information and items count
$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
        FROM orders o
        LEFT JOIN order_items oi ON o.id = oi.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 summary
$statusCounts = [
    'pending' => 0,
    'confirmed' => 0,
    'shipped' => 0,
    'delivered' => 0,
    'cancelled' => 0,
    'total' => count($orders)
];

foreach ($orders as $order) {
    if (isset($statusCounts[$order['order_status']])) {
        $statusCounts[$order['order_status']]++;
    }
}
?>

<?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">
          <h4 class="mb-0">Manage Orders</h4>
          <div class="d-flex gap-2">
            <button id="exportBtn" class="btn btn-outline-secondary">
              <i class="fas fa-download me-2"></i>Export Orders
            </button>
          </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['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-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>

<div class="card mb-4">
          <div class="card-body">
            <h6 class="card-title mb-3">Filter by Status:</h6>
            <div class="d-flex flex-wrap gap-2">
              <button class="btn btn-outline-primary status-filter-btn" data-status="all">
                All Orders (<?php echo $statusCounts['total']; ?>)
              </button>
              <button class="btn btn-outline-warning status-filter-btn" data-status="pending">
                Pending (<?php echo $statusCounts['pending']; ?>)
              </button>
              <button class="btn btn-outline-info status-filter-btn" data-status="confirmed">
                Confirmed (<?php echo $statusCounts['confirmed']; ?>)
              </button>
              <button class="btn btn-outline-secondary status-filter-btn" data-status="shipped">
                Shipped (<?php echo $statusCounts['shipped']; ?>)
              </button>
              <button class="btn btn-outline-success status-filter-btn" data-status="delivered">
                Delivered (<?php echo $statusCounts['delivered']; ?>)
              </button>
              <button class="btn btn-outline-danger status-filter-btn" data-status="cancelled">
                Cancelled (<?php echo $statusCounts['cancelled']; ?>)
              </button>
            </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</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 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>Payment</th>
                  <th>Status</th>
                  <th>Created</th>
                  <th>Updated</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>
                        </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="badge bg-light text-dark">
                          <?php echo strtoupper(h($order['payment_method'])); ?>
                        </span>
                      </td>
                      <td>
                        <span class="order-status status-<?php echo h($order['order_status']); ?>">
                          <?php echo ucfirst(h($order['order_status'])); ?>
                        </span>
                      </td>
                      <td>
                        <div class="small">
                          <?php 
                          $created = $order['created_at'];
                          if ($ts = strtotime($created)) {
                            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="small">
                          <?php 
                          $updated = $order['updated_at'];
                          if ($ts = strtotime($updated)) {
                            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">
                              <?php foreach ($orderStatuses as $status): ?>
                                <?php if ($status !== $order['order_status']): ?>
                                  <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="<?php echo $status; ?>">
                                      <button type="submit" class="dropdown-item" 
                                              onclick="return confirm('Change order status to <?php echo ucfirst($status); ?>?')">
                                        <span class="status-<?php echo $status; ?> me-2">●</span>
                                        Mark as <?php echo ucfirst($status); ?>
                                      </button>
                                    </form>
                                  </li>
                                <?php endif; ?>
                              <?php endforeach; ?>
                            </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="10" 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>
                      </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: 25,
    order: [[0, 'asc']],
    columnDefs: [
      { orderable: false, targets: [1, 2, 9] }, // Order details, customer, and actions not sortable
      { searchable: false, targets: [0, 4, 5, 6, 7, 8, 9] } // Some columns not searchable
    ],
    language: {
      search: "Search 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 !== 9) {
          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', 'orders_' + new Date().toISOString().split('T')[0] + '.csv');
    document.body.appendChild(a);
    a.click();
    document.body.removeChild(a);
  });

// Status filter buttons
  $('.status-filter-btn').on('click', function() {
    let status = $(this).data('status');
    
    // Remove active class from all buttons
    $('.status-filter-btn').removeClass('btn-primary').addClass('btn-outline-primary');
    $('.status-filter-btn').removeClass('btn-warning').addClass('btn-outline-warning');
    $('.status-filter-btn').removeClass('btn-info').addClass('btn-outline-info');
    $('.status-filter-btn').removeClass('btn-secondary').addClass('btn-outline-secondary');
    $('.status-filter-btn').removeClass('btn-success').addClass('btn-outline-success');
    $('.status-filter-btn').removeClass('btn-danger').addClass('btn-outline-danger');
    
    // Add active class to clicked button
    $(this).removeClass('btn-outline-primary btn-outline-warning btn-outline-info btn-outline-secondary btn-outline-success btn-outline-danger');
    
    if (status === 'all') {
      $(this).addClass('btn-primary');
      table.column(6).search('').draw();
    } else if (status === 'pending') {
      $(this).addClass('btn-warning');
      table.column(6).search('^' + status + '$', true, false).draw();
    } else if (status === 'confirmed') {
      $(this).addClass('btn-info');
      table.column(6).search('^' + status + '$', true, false).draw();
    } else if (status === 'shipped') {
      $(this).addClass('btn-secondary');
      table.column(6).search('^' + status + '$', true, false).draw();
    } else if (status === 'delivered') {
      $(this).addClass('btn-success');
      table.column(6).search('^' + status + '$', true, false).draw();
    } else if (status === 'cancelled') {
      $(this).addClass('btn-danger');
      table.column(6).search('^' + status + '$', true, false).draw();
    }
  });
});
</script>

</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: orders-new.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation