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

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

// Define order status for this page
$pageStatus = 'delivered';

// 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 delivered 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 as delivered_date,
            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
        WHERE o.order_status = ?
        GROUP BY o.id
        ORDER BY o.updated_at DESC";

$stmt = mysqli_prepare($conn, $sql);
mysqli_stmt_bind_param($stmt, 's', $pageStatus);
mysqli_stmt_execute($stmt);
$result = mysqli_stmt_get_result($stmt);
$orders = [];

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

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

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

// Get counts for other statuses
$otherStatuses = ['pending', 'confirmed', 'shipped', 'cancelled'];
foreach ($otherStatuses as $status) {
    $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 delivery performance
$totalOrders = array_sum($statusCounts);
$deliveryRate = $totalOrders > 0 ? round(($statusCounts['delivered'] / $totalOrders) * 100, 1) : 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">Delivered Orders</h4>
            <p class="text-muted mb-0">Successfully delivered orders and delivery performance</p>
          </div>
          <div class="d-flex gap-2">
            <a href="orders-new.php" class="btn btn-outline-secondary">
              <i class="fas fa-arrow-left me-2"></i>All Orders
            </a>
            <button id="exportBtn" class="btn btn-outline-primary">
              <i class="fas fa-download me-2"></i>Export
            </button>
          </div>
        </div>

<div class="row mb-4">
          <div class="col-md-8">
            <div class="delivery-stats">
              <div class="row align-items-center">
                <div class="col-md-6">
                  <h3 class="text-white mb-2">Delivery Performance</h3>
                  <p class="text-white-50 mb-0">Successfully delivered orders to customers</p>
                </div>
                <div class="col-md-6 text-center">
                  <div class="delivery-rate"><?php echo $deliveryRate; ?>%</div>
                  <p class="text-white-50 mb-0">Delivery Success Rate</p>
                </div>
              </div>
            </div>
          </div>
          <div class="col-md-4">
            <div class="card h-100">
              <div class="card-body text-center">
                <div class="text-success mb-2">
                  <i class="fas fa-check-circle fa-3x"></i>
                </div>
                <h3 class="text-success"><?php echo $statusCounts['delivered']; ?></h3>
                <p class="text-muted mb-0">Orders Delivered</p>
                <small class="text-muted">Successfully completed</small>
              </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['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['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['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 array_sum($statusCounts); ?></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>

<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-new.php" class="btn btn-outline-primary status-nav-btn">
                All Orders (<?php echo array_sum($statusCounts); ?>)
              </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-success status-nav-btn page-active">
                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">Delivered 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 delivered 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>Tracking Info</th>
                  <th>Delivered Date</th>
                  <th>Status</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 class="text-muted small">
                            Payment: <?php echo strtoupper(h($order['payment_method'])); ?>
                          </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>
                        <?php if (!empty($order['tracking_number'])): ?>
                          <div class="tracking-info">
                            <div class="mb-1">
                              <span class="tracking-badge"><?php echo h($order['tracking_number']); ?></span>
                            </div>
                            <?php if (!empty($order['courier_service'])): ?>
                              <div class="mb-1">
                                <span class="courier-badge"><?php echo h($courierServices[$order['courier_service']] ?? $order['courier_service']); ?></span>
                              </div>
                            <?php endif; ?>
                          </div>
                        <?php else: ?>
                          <span class="text-muted small">No tracking info</span>
                        <?php endif; ?>
                      </td>
                      <td>
                        <div class="small">
                          <?php 
                          if ($ts = strtotime($order['delivered_date'])) {
                            echo date("M j, Y", $ts) . '<br><small class="text-muted">' . date("g:i A", $ts) . '</small>';
                          } else {
                            echo 'N/A';
                          }
                          ?>
                        </div>
                      </td>
                      <td>
                        <span class="success-badge">
                          <i class="fas fa-check me-1"></i>Delivered
                        </span>
                      </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-warning 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="shipped">
                                  <button type="submit" class="dropdown-item" 
                                          onclick="return confirm('Move order back to Shipped?')">
                                    <span class="status-shipped me-2">●</span>
                                    Back to 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="confirmed">
                                  <button type="submit" class="dropdown-item" 
                                          onclick="return confirm('Move order back to Confirmed?')">
                                    <span class="status-confirmed me-2">●</span>
                                    Back to Confirmed
                                  </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 will mark it as cancelled.')">
                                    <span class="status-cancelled me-2">●</span>
                                    Mark as Cancelled
                                  </button>
                                </form>
                              </li>
                            </ul>
                          </div>
                          
                          
                          <a href="order-invoice.php?id=<?php echo $order['id']; ?>" 
                             class="btn btn-sm btn-outline-secondary" 
                             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-box-open fa-3x mb-3 text-success"></i>
                        <h5>No Delivered Orders</h5>
                        <p>No orders have been marked as delivered yet.</p>
                        <div class="d-flex gap-2 justify-content-center">
                          <a href="orders-shipped.php" class="btn btn-secondary">
                            <i class="fas fa-shipping-fast me-2"></i>View Shipped Orders
                          </a>
                          <a href="orders-confirmed.php" class="btn btn-info">
                            <i class="fas fa-check-circle me-2"></i>View Confirmed Orders
                          </a>
                        </div>
                      </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, 5, 8] }, // Order details, customer, tracking, and actions not sortable
      { searchable: false, targets: [0, 3, 4, 6, 7, 8] } // Some columns not searchable
    ],
    language: {
      search: "Search delivered orders:",
      lengthMenu: "Show _MENU_ orders per page",
      info: "Showing _START_ to _END_ of _TOTAL_ delivered orders",
      infoEmpty: "No delivered orders available",
      infoFiltered: "(filtered from _MAX_ total delivered 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', 'delivered_orders_' + new Date().toISOString().split('T')[0] + '.csv');
    document.body.appendChild(a);
    a.click();
    document.body.removeChild(a);
  });
});
</script>

</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: orders-delivered.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation