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/ecommer.in/public_html/billing/printing

Free Space:

10.16 TB

🔧 Quick Actions

✏️ Editing: manage-orders.php

<?php
// manage-orders.php
session_start();
require_once 'includes/db.php';

// Handle status update
if (isset($_POST['update_status'])) {
    $bill_id = intval($_POST['bill_id']);
    $status = $_POST['status'];
    
    $update_sql = "UPDATE bills SET status = ?, updated_at = NOW() WHERE id = ?";
    $update_stmt = mysqli_prepare($conn, $update_sql);
    mysqli_stmt_bind_param($update_stmt, "si", $status, $bill_id);
    
    if (mysqli_stmt_execute($update_stmt)) {
        $_SESSION['message'] = '<div class="alert alert-success">Order status updated successfully!</div>';
    } else {
        $_SESSION['message'] = '<div class="alert alert-danger">Error updating order status: ' . mysqli_error($conn) . '</div>';
    }
    
    header('Location: manage-orders.php');
    exit();
}

// Handle order deletion
if (isset($_GET['delete_id'])) {
    $delete_id = intval($_GET['delete_id']);
    
    mysqli_begin_transaction($conn);
    
    try {
        // First, get bill products to restore stock
        $products_sql = "SELECT bp.product_id, bp.quantity, bp.area, p.unit 
                        FROM bill_products bp 
                        JOIN products p ON bp.product_id = p.id 
                        WHERE bp.bill_id = ?";
        $products_stmt = mysqli_prepare($conn, $products_sql);
        mysqli_stmt_bind_param($products_stmt, "i", $delete_id);
        mysqli_stmt_execute($products_stmt);
        $products_result = mysqli_stmt_get_result($products_stmt);
        
        // Restore stock for each product
        while ($product = mysqli_fetch_assoc($products_result)) {
            if ($product['unit'] === 'sqft' || $product['unit'] === 'ft') {
                // For measurement products, restore by area
                $restore_sql = "UPDATE products SET total_quantity = total_quantity + ? WHERE id = ?";
                $restore_stmt = mysqli_prepare($conn, $restore_sql);
                mysqli_stmt_bind_param($restore_stmt, "di", $product['area'], $product['product_id']);
            } else {
                // For piece-based products, restore by quantity
                $restore_sql = "UPDATE products SET total_quantity = total_quantity + ? WHERE id = ?";
                $restore_stmt = mysqli_prepare($conn, $restore_sql);
                mysqli_stmt_bind_param($restore_stmt, "di", $product['quantity'], $product['product_id']);
            }
            mysqli_stmt_execute($restore_stmt);
        }
        
        // Delete bill products
        $delete_products_sql = "DELETE FROM bill_products WHERE bill_id = ?";
        $delete_products_stmt = mysqli_prepare($conn, $delete_products_sql);
        mysqli_stmt_bind_param($delete_products_stmt, "i", $delete_id);
        mysqli_stmt_execute($delete_products_stmt);
        
        // Delete bill
        $delete_bill_sql = "DELETE FROM bills WHERE id = ?";
        $delete_bill_stmt = mysqli_prepare($conn, $delete_bill_sql);
        mysqli_stmt_bind_param($delete_bill_stmt, "i", $delete_id);
        mysqli_stmt_execute($delete_bill_stmt);
        
        mysqli_commit($conn);
        $_SESSION['message'] = '<div class="alert alert-success">Order deleted successfully!</div>';
        
    } catch (Exception $e) {
        mysqli_rollback($conn);
        $_SESSION['message'] = '<div class="alert alert-danger">Error deleting order: ' . $e->getMessage() . '</div>';
    }
    
    header('Location: manage-orders.php');
    exit();
}

// Get filter parameters
$status_filter = isset($_GET['status']) ? $_GET['status'] : 'all';
$date_from = isset($_GET['date_from']) ? $_GET['date_from'] : '';
$date_to = isset($_GET['date_to']) ? $_GET['date_to'] : '';
$search_query = isset($_GET['search']) ? trim($_GET['search']) : '';

// Build WHERE conditions
$where_conditions = [];
$params = [];
$types = '';

if ($status_filter !== 'all') {
    $where_conditions[] = "b.status = ?";
    $params[] = $status_filter;
    $types .= 's';
}

if (!empty($date_from)) {
    $where_conditions[] = "b.bill_date >= ?";
    $params[] = $date_from;
    $types .= 's';
}

if (!empty($date_to)) {
    $where_conditions[] = "b.bill_date <= ?";
    $params[] = $date_to;
    $types .= 's';
}

if (!empty($search_query)) {
    $where_conditions[] = "(b.customer_name LIKE ? OR b.customer_phone LIKE ? OR b.id = ?)";
    $params[] = "%$search_query%";
    $params[] = "%$search_query%";
    $params[] = $search_query;
    $types .= 'sss';
}

$where_clause = !empty($where_conditions) ? "WHERE " . implode(" AND ", $where_conditions) : "";

// Get orders with pagination
$page = isset($_GET['page']) ? max(1, intval($_GET['page'])) : 1;
$per_page = 10;
$offset = ($page - 1) * $per_page;

// Count total orders
$count_sql = "SELECT COUNT(*) as total FROM bills b $where_clause";
$count_stmt = mysqli_prepare($conn, $count_sql);
if (!empty($params)) {
    mysqli_stmt_bind_param($count_stmt, $types, ...$params);
}
mysqli_stmt_execute($count_stmt);
$count_result = mysqli_stmt_get_result($count_stmt);
$total_orders = mysqli_fetch_assoc($count_result)['total'];
$total_pages = ceil($total_orders / $per_page);

// Get orders
$sql = "SELECT b.*, 
               (SELECT COUNT(*) FROM bill_products WHERE bill_id = b.id) as product_count,
               c.name as customer_name
        FROM bills b 
        LEFT JOIN customers c ON b.customer_id = c.id 
        $where_clause 
        ORDER BY b.created_at DESC 
        LIMIT $per_page OFFSET $offset";

$stmt = mysqli_prepare($conn, $sql);
if (!empty($params)) {
    mysqli_stmt_bind_param($stmt, $types, ...$params);
}
mysqli_stmt_execute($stmt);
$result = mysqli_stmt_get_result($stmt);

// Get order statistics
$stats_sql = "SELECT 
                COUNT(*) as total_orders,
                SUM(CASE WHEN status = 'pending' THEN 1 ELSE 0 END) as pending_orders,
                SUM(CASE WHEN status = 'paid' THEN 1 ELSE 0 END) as paid_orders,
                SUM(CASE WHEN status = 'overdue' THEN 1 ELSE 0 END) as overdue_orders,
                SUM(CASE WHEN status = 'cancelled' THEN 1 ELSE 0 END) as cancelled_orders,
                SUM(total_amount) as total_revenue
              FROM bills";
$stats_result = mysqli_query($conn, $stats_sql);
$stats = mysqli_fetch_assoc($stats_result);

// Display message if exists
$message = '';
if (isset($_SESSION['message'])) {
    $message = $_SESSION['message'];
    unset($_SESSION['message']);
}
?>
<!doctype html>
<html lang="en">
<?php include('includes/head.php')?>
<body data-sidebar="dark">
<?php include('includes/pre-loader.php')?>
<div id="layout-wrapper">
    <?php include('includes/topbar.php')?>
    <div class="vertical-menu">
        <div data-simplebar class="h-100">
            <?php include('includes/sidebar.php')?>
        </div>
    </div>

<div class="row align-items-center mb-3">
                    <div class="col-12 d-flex justify-content-between align-items-center flex-wrap gap-2">
                        <h4 class="mb-0">Orders / Manage Orders</h4>
                        <div class="d-flex flex-wrap gap-2">
                            <a href="new-bill.php" class="btn btn-primary btn-sm">
                                <i class="fas fa-plus me-1"></i>New Bill
                            </a>
                            <a href="manage-customers.php" class="btn btn-success btn-sm">Manage Customers</a>
                        </div>
                    </div>
                </div>

<div class="row mb-4">
                    <div class="col-md-2">
                        <div class="card bg-primary text-white">
                            <div class="card-body text-center p-3">
                                <h4 class="mb-0"><?php echo $stats['total_orders']; ?></h4>
                                <small>Total Orders</small>
                            </div>
                        </div>
                    </div>
                    <div class="col-md-2">
                        <div class="card bg-warning text-white">
                            <div class="card-body text-center p-3">
                                <h4 class="mb-0"><?php echo $stats['pending_orders']; ?></h4>
                                <small>Pending</small>
                            </div>
                        </div>
                    </div>
                    <div class="col-md-2">
                        <div class="card bg-success text-white">
                            <div class="card-body text-center p-3">
                                <h4 class="mb-0"><?php echo $stats['paid_orders']; ?></h4>
                                <small>Paid</small>
                            </div>
                        </div>
                    </div>
                    <div class="col-md-2">
                        <div class="card bg-danger text-white">
                            <div class="card-body text-center p-3">
                                <h4 class="mb-0"><?php echo $stats['overdue_orders']; ?></h4>
                                <small>Overdue</small>
                            </div>
                        </div>
                    </div>
                    <div class="col-md-2">
                        <div class="card bg-secondary text-white">
                            <div class="card-body text-center p-3">
                                <h4 class="mb-0"><?php echo $stats['cancelled_orders']; ?></h4>
                                <small>Cancelled</small>
                            </div>
                        </div>
                    </div>
                    <div class="col-md-2">
                        <div class="card bg-info text-white">
                            <div class="card-body text-center p-3">
                                <h4 class="mb-0">₹<?php echo number_format($stats['total_revenue'], 2); ?></h4>
                                <small>Total Revenue</small>
                            </div>
                        </div>
                    </div>
                </div>

<div class="card mb-4">
                    <div class="card-body">
                        <form method="GET" class="row g-3">
                            <div class="col-md-2">
                                <label class="form-label">Status</label>
                                <select name="status" class="form-select">
                                    <option value="all" <?php echo $status_filter == 'all' ? 'selected' : ''; ?>>All Status</option>
                                    <option value="pending" <?php echo $status_filter == 'pending' ? 'selected' : ''; ?>>Pending</option>
                                    <option value="paid" <?php echo $status_filter == 'paid' ? 'selected' : ''; ?>>Paid</option>
                                    <option value="overdue" <?php echo $status_filter == 'overdue' ? 'selected' : ''; ?>>Overdue</option>
                                    <option value="cancelled" <?php echo $status_filter == 'cancelled' ? 'selected' : ''; ?>>Cancelled</option>
                                </select>
                            </div>
                            <div class="col-md-2">
                                <label class="form-label">From Date</label>
                                <input type="date" name="date_from" class="form-control" value="<?php echo $date_from; ?>">
                            </div>
                            <div class="col-md-2">
                                <label class="form-label">To Date</label>
                                <input type="date" name="date_to" class="form-control" value="<?php echo $date_to; ?>">
                            </div>
                            <div class="col-md-4">
                                <label class="form-label">Search</label>
                                <input type="text" name="search" class="form-control" 
                                       value="<?php echo htmlspecialchars($search_query); ?>" 
                                       placeholder="Search by customer name, phone, or order ID...">
                            </div>
                            <div class="col-md-2 d-flex align-items-end">
                                <button type="submit" class="btn btn-primary w-100">Filter</button>
                            </div>
                        </form>
                    </div>
                </div>

<div class="card">
                    <div class="card-header bg-light d-flex justify-content-between align-items-center">
                        <h5 class="card-title mb-0">Orders List</h5>
                        <div>
                            <span class="text-muted">Total: <?php echo $total_orders; ?> orders</span>
                        </div>
                    </div>
                    <div class="card-body">
                        <?php echo $message; ?>
                        
                        <div class="table-responsive">
                            <table class="table table-bordered table-hover">
                                <thead class="table-light">
                                    <tr>
                                        <th>#</th>
                                        <th>Order ID</th>
                                        <th>Customer</th>
                                        <th>Phone</th>
                                        <th>Bill Date</th>
                                        <th>Due Date</th>
                                        <th>Products</th>
                                        <th>Amount</th>
                                        <th>Status</th>
                                        <th>Created</th>
                                        <th>Actions</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    <?php if (mysqli_num_rows($result) > 0): ?>
                                        <?php $counter = ($page - 1) * $per_page + 1; ?>
                                        <?php while ($order = mysqli_fetch_assoc($result)): ?>
                                            <?php
                                            $status_class = '';
                                            switch ($order['status']) {
                                                case 'paid':
                                                    $status_class = 'success';
                                                    break;
                                                case 'pending':
                                                    $status_class = 'warning';
                                                    break;
                                                case 'overdue':
                                                    $status_class = 'danger';
                                                    break;
                                                case 'cancelled':
                                                    $status_class = 'secondary';
                                                    break;
                                                default:
                                                    $status_class = 'primary';
                                            }
                                            
                                            // Check if overdue
                                            $is_overdue = ($order['status'] == 'pending' && strtotime($order['due_date']) < time());
                                            if ($is_overdue) {
                                                $status_class = 'danger';
                                            }
                                            ?>
                                            <tr class="<?php echo $is_overdue ? 'table-danger' : ''; ?>">
                                                <td><?php echo $counter++; ?></td>
                                                <td>
                                                    <strong>#<?php echo $order['id']; ?></strong>
                                                </td>
                                                <td>
                                                    <div class="fw-semibold"><?php echo htmlspecialchars($order['customer_name']); ?></div>
                                                </td>
                                                <td><?php echo htmlspecialchars($order['customer_phone']); ?></td>
                                                <td>
                                                    <small><?php echo date('M j, Y', strtotime($order['bill_date'])); ?></small>
                                                </td>
                                                <td>
                                                    <small class="<?php echo $is_overdue ? 'text-danger fw-bold' : ''; ?>">
                                                        <?php echo date('M j, Y', strtotime($order['due_date'])); ?>
                                                        <?php echo $is_overdue ? ' (Overdue)' : ''; ?>
                                                    </small>
                                                </td>
                                                <td>
                                                    <span class="badge bg-light text-dark"><?php echo $order['product_count']; ?> items</span>
                                                </td>
                                                <td>
                                                    <div class="fw-semibold text-success">₹<?php echo number_format($order['total_amount'], 2); ?></div>
                                                </td>
                                                <td>
                                                    <form method="POST" class="d-inline">
                                                        <input type="hidden" name="bill_id" value="<?php echo $order['id']; ?>">
                                                        <select name="status" class="form-select form-select-sm" onchange="this.form.submit()">
                                                            <option value="pending" <?php echo $order['status'] == 'pending' ? 'selected' : ''; ?>>Pending</option>
                                                            <option value="paid" <?php echo $order['status'] == 'paid' ? 'selected' : ''; ?>>Paid</option>
                                                            <option value="cancelled" <?php echo $order['status'] == 'cancelled' ? 'selected' : ''; ?>>Cancelled</option>
                                                        </select>
                                                        <input type="hidden" name="update_status" value="1">
                                                    </form>
                                                </td>
                                                <td>
                                                    <small><?php echo date('M j, Y', strtotime($order['created_at'])); ?></small>
                                                </td>
                                                <td>
                                                    <div class="btn-group btn-group-sm">
                                                        <a href="view-order.php?id=<?php echo $order['id']; ?>" class="btn btn-info" title="View Order">
                                                            <i class="fas fa-eye"></i>
                                                        </a>
                                                        <a href="print-invoice.php?id=<?php echo $order['id']; ?>" class="btn btn-secondary" title="Print Invoice">
                                                            <i class="fas fa-print"></i>
                                                        </a>
                                                        <button type="button" class="btn btn-danger" 
                                                                onclick="confirmDelete(<?php echo $order['id']; ?>, 'Order #<?php echo $order['id']; ?>')"
                                                                title="Delete Order">
                                                            <i class="fas fa-trash"></i>
                                                        </button>
                                                    </div>
                                                </td>
                                            </tr>
                                        <?php endwhile; ?>
                                    <?php else: ?>
                                        <tr>
                                            <td colspan="11" class="text-center py-4">
                                                <div class="text-muted">
                                                    <i class="fas fa-receipt fa-3x mb-3"></i>
                                                    <h5>No orders found</h5>
                                                    <p>No orders match your current filters.</p>
                                                    <a href="manage-orders.php" class="btn btn-primary">Clear Filters</a>
                                                    <a href="new-bill.php" class="btn btn-success">Create New Order</a>
                                                </div>
                                            </td>
                                        </tr>
                                    <?php endif; ?>
                                </tbody>
                            </table>
                        </div>

<?php if ($total_pages > 1): ?>
                        <nav aria-label="Page navigation">
                            <ul class="pagination justify-content-center">
                                <li class="page-item <?php echo $page <= 1 ? 'disabled' : ''; ?>">
                                    <a class="page-link" href="?<?php echo http_build_query(array_merge($_GET, ['page' => $page - 1])); ?>">Previous</a>
                                </li>
                                
                                <?php for ($i = 1; $i <= $total_pages; $i++): ?>
                                    <li class="page-item <?php echo $i == $page ? 'active' : ''; ?>">
                                        <a class="page-link" href="?<?php echo http_build_query(array_merge($_GET, ['page' => $i])); ?>"><?php echo $i; ?></a>
                                    </li>
                                <?php endfor; ?>
                                
                                <li class="page-item <?php echo $page >= $total_pages ? 'disabled' : ''; ?>">
                                    <a class="page-link" href="?<?php echo http_build_query(array_merge($_GET, ['page' => $page + 1])); ?>">Next</a>
                                </li>
                            </ul>
                        </nav>
                        <?php endif; ?>
                    </div>
                </div>

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

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

// Auto-close alerts after 5 seconds
document.addEventListener('DOMContentLoaded', function() {
    const alerts = document.querySelectorAll('.alert');
    alerts.forEach(alert => {
        setTimeout(() => {
            alert.remove();
        }, 5000);
    });
    
    // Highlight overdue orders
    const overdueRows = document.querySelectorAll('tr.table-danger');
    overdueRows.forEach(row => {
        row.style.animation = 'pulse 2s infinite';
    });
});

// Add some CSS for pulsing animation
const style = document.createElement('style');
style.textContent = `
    @keyframes pulse {
        0% { background-color: rgba(220, 53, 69, 0.1); }
        50% { background-color: rgba(220, 53, 69, 0.3); }
        100% { background-color: rgba(220, 53, 69, 0.1); }
    }
`;
document.head.appendChild(style);
</script>
</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: manage-orders.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation