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.26 TB

🔧 Quick Actions

✏️ Editing: view-order.php

<?php
// view-order.php
session_start();
require_once 'includes/db.php';

// Check if order ID is provided
if (!isset($_GET['id']) || empty($_GET['id'])) {
    header('Location: manage-orders.php');
    exit();
}

$order_id = intval($_GET['id']);

// Get order details - removed email column
$order_sql = "SELECT b.*, c.name as customer_name, c.address 
              FROM bills b 
              LEFT JOIN customers c ON b.customer_id = c.id 
              WHERE b.id = ?";
$order_stmt = mysqli_prepare($conn, $order_sql);
mysqli_stmt_bind_param($order_stmt, "i", $order_id);
mysqli_stmt_execute($order_stmt);
$order_result = mysqli_stmt_get_result($order_stmt);
$order = mysqli_fetch_assoc($order_result);

if (!$order) {
    $_SESSION['message'] = '<div class="alert alert-danger">Order not found!</div>';
    header('Location: manage-orders.php');
    exit();
}

// Get order products
$products_sql = "SELECT bp.*, p.name as product_name, p.unit, p.quantity_unit 
                 FROM bill_products bp 
                 JOIN products p ON bp.product_id = p.id 
                 WHERE bp.bill_id = ? 
                 ORDER BY bp.id";
$products_stmt = mysqli_prepare($conn, $products_sql);
mysqli_stmt_bind_param($products_stmt, "i", $order_id);
mysqli_stmt_execute($products_stmt);
$products_result = mysqli_stmt_get_result($products_stmt);

// Calculate product statistics
$total_items = 0;
$total_quantity = 0;
$products_data = [];
while ($product = mysqli_fetch_assoc($products_result)) {
    $total_items++;
    $total_quantity += $product['quantity'];
    $products_data[] = $product;
}

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

// Calculate amounts
$discount_amount = ($order['subtotal'] * $order['discount']) / 100;
$taxable_amount = $order['subtotal'] - $discount_amount;

// Calculate status badge class
$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';
}

// 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 / View Order #<?php echo $order['id']; ?></h4>
                        <div class="d-flex flex-wrap gap-2">
                            <a href="manage-orders.php" class="btn btn-secondary btn-sm">
                                <i class="fas fa-arrow-left me-1"></i>Back to Orders
                            </a>
                            <a href="print-invoice.php?id=<?php echo $order['id']; ?>" class="btn btn-primary btn-sm" target="_blank">
                                <i class="fas fa-print me-1"></i>Print Invoice
                            </a>
                            <a href="new-bill.php?customer_phone=<?php echo urlencode($order['customer_phone']); ?>" class="btn btn-success btn-sm">New Bill for Customer</a>
                        </div>
                    </div>
                </div>

<?php echo $message; ?>

<div class="row">
                    
                    <div class="col-lg-8">
                        
                        <div class="card mb-4">
                            <div class="card-header bg-light">
                                <h5 class="card-title mb-0">Order & Customer Information</h5>
                            </div>
                            <div class="card-body">
                                <div class="row">
                                    <div class="col-md-6">
                                        <h6>Customer Details</h6>
                                        <table class="table table-sm table-borderless">
                                            <tr>
                                                <td class="fw-bold" width="120">Name:</td>
                                                <td><?php echo htmlspecialchars($order['customer_name']); ?></td>
                                            </tr>
                                            <tr>
                                                <td class="fw-bold">Phone:</td>
                                                <td><?php echo htmlspecialchars($order['customer_phone']); ?></td>
                                            </tr>
                                            <?php if (!empty($order['address'])): ?>
                                            <tr>
                                                <td class="fw-bold">Address:</td>
                                                <td><?php echo htmlspecialchars($order['address']); ?></td>
                                            </tr>
                                            <?php endif; ?>
                                        </table>
                                    </div>
                                    <div class="col-md-6">
                                        <h6>Order Details</h6>
                                        <table class="table table-sm table-borderless">
                                            <tr>
                                                <td class="fw-bold" width="120">Order ID:</td>
                                                <td>#<?php echo $order['id']; ?></td>
                                            </tr>
                                            <tr>
                                                <td class="fw-bold">Bill Date:</td>
                                                <td><?php echo date('M j, Y', strtotime($order['bill_date'])); ?></td>
                                            </tr>
                                            <tr>
                                                <td class="fw-bold">Due Date:</td>
                                                <td class="<?php echo $is_overdue ? 'text-danger fw-bold' : ''; ?>">
                                                    <?php echo date('M j, Y', strtotime($order['due_date'])); ?>
                                                    <?php echo $is_overdue ? ' (Overdue)' : ''; ?>
                                                </td>
                                            </tr>
                                            <tr>
                                                <td class="fw-bold">Status:</td>
                                                <td>
                                                    <span class="badge bg-<?php echo $status_class; ?>">
                                                        <?php echo ucfirst($order['status']); ?>
                                                        <?php echo $is_overdue ? ' - Overdue' : ''; ?>
                                                    </span>
                                                </td>
                                            </tr>
                                            <tr>
                                                <td class="fw-bold">Created:</td>
                                                <td><?php echo date('M j, Y g:i A', strtotime($order['created_at'])); ?></td>
                                            </tr>
                                            <?php if (!empty($order['updated_at'])): ?>
                                            <tr>
                                                <td class="fw-bold">Last Updated:</td>
                                                <td><?php echo date('M j, Y g:i A', strtotime($order['updated_at'])); ?></td>
                                            </tr>
                                            <?php endif; ?>
                                        </table>
                                    </div>
                                </div>
                                
                                <?php if (!empty($order['notes'])): ?>
                                <div class="row mt-3">
                                    <div class="col-12">
                                        <h6>Order Notes:</h6>
                                        <div class="alert alert-info p-3">
                                            <?php echo nl2br(htmlspecialchars($order['notes'])); ?>
                                        </div>
                                    </div>
                                </div>
                                <?php endif; ?>
                            </div>
                        </div>

<div class="card">
                            <div class="card-header bg-light">
                                <h5 class="card-title mb-0">Order Items</h5>
                            </div>
                            <div class="card-body">
                                <div class="table-responsive">
                                    <table class="table table-bordered">
                                        <thead class="table-light">
                                            <tr>
                                                <th>#</th>
                                                <th>Product</th>
                                                <th>Dimensions</th>
                                                <th>Quantity</th>
                                                <th>Area/Size</th>
                                                <th>Unit Price</th>
                                                <th>Amount</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <?php if (count($products_data) > 0): ?>
                                                <?php $counter = 1; ?>
                                                <?php foreach ($products_data as $product): ?>
                                                    <?php
                                                    $show_dimensions = ($product['unit'] === 'sqft' || $product['unit'] === 'ft');
                                                    ?>
                                                    <tr>
                                                        <td><?php echo $counter++; ?></td>
                                                        <td>
                                                            <strong><?php echo htmlspecialchars($product['product_name']); ?></strong>
                                                            <br><small class="text-muted">Unit: <?php echo $product['unit']; ?></small>
                                                        </td>
                                                        <td>
                                                            <?php if ($show_dimensions): ?>
                                                                <?php echo $product['height']; ?>ft × <?php echo $product['width']; ?>ft
                                                            <?php else: ?>
                                                                <span class="text-muted">-</span>
                                                            <?php endif; ?>
                                                        </td>
                                                        <td>
                                                            <?php echo $product['quantity']; ?>
                                                            <br><small class="text-muted"><?php echo $product['quantity_unit']; ?></small>
                                                        </td>
                                                        <td>
                                                            <?php echo number_format($product['area'], 2); ?> 
                                                            <?php echo $product['unit']; ?>
                                                        </td>
                                                        <td>
                                                            ₹<?php echo number_format($product['unit_price'], 2); ?>
                                                            <br><small class="text-muted">/<?php echo $product['unit']; ?></small>
                                                        </td>
                                                        <td class="fw-semibold text-success">
                                                            ₹<?php echo number_format($product['total_amount'], 2); ?>
                                                        </td>
                                                    </tr>
                                                <?php endforeach; ?>
                                            <?php else: ?>
                                                <tr>
                                                    <td colspan="7" class="text-center text-muted py-4">
                                                        <i class="fas fa-box-open fa-2x mb-2"></i>
                                                        <p>No products found for this order</p>
                                                    </td>
                                                </tr>
                                            <?php endif; ?>
                                        </tbody>
                                    </table>
                                </div>
                                
                                
                                <div class="row mt-3">
                                    <div class="col-md-6">
                                        <small class="text-muted">
                                            <i class="fas fa-cube me-1"></i>
                                            <?php echo $total_items; ?> items, <?php echo $total_quantity; ?> total quantity
                                        </small>
                                    </div>
                                    <div class="col-md-6 text-end">
                                        <small class="text-muted">
                                            <i class="fas fa-calculator me-1"></i>
                                            Subtotal: ₹<?php echo number_format($order['subtotal'], 2); ?>
                                        </small>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>

<div class="col-lg-4">
                        
                        <div class="card mb-4">
                            <div class="card-header bg-light">
                                <h5 class="card-title mb-0">Order Summary</h5>
                            </div>
                            <div class="card-body">
                                <table class="table table-sm table-borderless">
                                    <tr>
                                        <td>Subtotal:</td>
                                        <td class="text-end">₹<?php echo number_format($order['subtotal'], 2); ?></td>
                                    </tr>
                                    <?php if ($order['discount'] > 0): ?>
                                    <tr>
                                        <td>Discount (<?php echo $order['discount']; ?>%):</td>
                                        <td class="text-end text-danger">-₹<?php echo number_format($discount_amount, 2); ?></td>
                                    </tr>
                                    <?php endif; ?>
                                    <tr class="border-top">
                                        <td><strong>Total Amount:</strong></td>
                                        <td class="text-end"><strong class="text-success">₹<?php echo number_format($order['total_amount'], 2); ?></strong></td>
                                    </tr>
                                </table>
                                
                                
                                <div class="mt-3 p-3 rounded" style="background: #f8f9fa;">
                                    <h6 class="mb-2">Payment Status</h6>
                                    <div class="d-flex justify-content-between align-items-center">
                                        <span class="fw-semibold">Amount Due:</span>
                                        <span class="fw-bold text-<?php echo $order['status'] === 'paid' ? 'success' : 'danger'; ?>">
                                            ₹<?php echo number_format($order['status'] === 'paid' ? 0 : $order['total_amount'], 2); ?>
                                        </span>
                                    </div>
                                    <?php if ($order['status'] === 'paid'): ?>
                                        <div class="text-success text-center mt-2">
                                            <i class="fas fa-check-circle me-1"></i>
                                            Payment Completed
                                        </div>
                                    <?php elseif ($is_overdue): ?>
                                        <div class="text-danger text-center mt-2">
                                            <i class="fas fa-exclamation-triangle me-1"></i>
                                            Payment Overdue
                                        </div>
                                    <?php else: ?>
                                        <div class="text-warning text-center mt-2">
                                            <i class="fas fa-clock me-1"></i>
                                            Payment Pending
                                        </div>
                                    <?php endif; ?>
                                </div>
                            </div>
                        </div>

<div class="card mb-4">
                            <div class="card-header bg-light">
                                <h5 class="card-title mb-0">Update Status</h5>
                            </div>
                            <div class="card-body">
                                <form method="POST">
                                    <div class="mb-3">
                                        <label class="form-label">Status</label>
                                        <select name="status" class="form-select" required>
                                            <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>
                                    </div>
                                    <div class="mb-3">
                                        <label class="form-label">Notes</label>
                                        <textarea name="notes" class="form-control" rows="3" 
                                                  placeholder="Add any notes about this order..."><?php echo htmlspecialchars($order['notes'] ?? ''); ?></textarea>
                                    </div>
                                    <button type="submit" name="update_status" value="1" class="btn btn-primary w-100">
                                        <i class="fas fa-save me-1"></i>Update Status
                                    </button>
                                </form>
                            </div>
                        </div>

<div class="card">
                            <div class="card-header bg-light">
                                <h5 class="card-title mb-0">Quick Actions</h5>
                            </div>
                            <div class="card-body">
                                <div class="d-grid gap-2">
                                    <a href="print-invoice.php?id=<?php echo $order['id']; ?>" class="btn btn-outline-primary" target="_blank">
                                        <i class="fas fa-print me-2"></i>Print Invoice
                                    </a>
                                    <a href="edit-order.php?id=<?php echo $order['id']; ?>" class="btn btn-outline-warning">
                                        <i class="fas fa-edit me-2"></i>Edit Order
                                    </a>
                                    <a href="new-bill.php?customer_phone=<?php echo urlencode($order['customer_phone']); ?>" class="btn btn-outline-success">
                                        <i class="fas fa-plus me-2"></i>New Bill for Customer
                                    </a>
                                    <a href="manage-customers.php?search=<?php echo urlencode($order['customer_phone']); ?>" class="btn btn-outline-info">
                                        <i class="fas fa-user me-2"></i>View Customer
                                    </a>
                                    <button type="button" class="btn btn-outline-danger" 
                                            onclick="confirmDelete(<?php echo $order['id']; ?>, 'Order #<?php echo $order['id']; ?>')">
                                        <i class="fas fa-trash me-2"></i>Delete Order
                                    </button>
                                </div>
                            </div>
                        </div>

<div class="card mt-4">
                            <div class="card-header bg-light">
                                <h5 class="card-title mb-0">Order Timeline</h5>
                            </div>
                            <div class="card-body">
                                <div class="timeline">
                                    <div class="timeline-item">
                                        <div class="timeline-marker bg-success"></div>
                                        <div class="timeline-content">
                                            <small class="text-muted">Order Created</small>
                                            <div><?php echo date('M j, Y g:i A', strtotime($order['created_at'])); ?></div>
                                        </div>
                                    </div>
                                    <?php if (!empty($order['updated_at']) && $order['updated_at'] != $order['created_at']): ?>
                                    <div class="timeline-item">
                                        <div class="timeline-marker bg-info"></div>
                                        <div class="timeline-content">
                                            <small class="text-muted">Last Updated</small>
                                            <div><?php echo date('M j, Y g:i A', strtotime($order['updated_at'])); ?></div>
                                        </div>
                                    </div>
                                    <?php endif; ?>
                                    <div class="timeline-item">
                                        <div class="timeline-marker bg-<?php echo $is_overdue ? 'danger' : 'primary'; ?>"></div>
                                        <div class="timeline-content">
                                            <small class="text-muted">Due Date</small>
                                            <div class="<?php echo $is_overdue ? 'text-danger fw-bold' : ''; ?>">
                                                <?php echo date('M j, Y', strtotime($order['due_date'])); ?>
                                                <?php echo $is_overdue ? ' (Overdue)' : ''; ?>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </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
    <?php if ($is_overdue): ?>
    const statusBadge = document.querySelector('.badge.bg-danger');
    if (statusBadge) {
        statusBadge.style.animation = 'pulse 2s infinite';
    }
    <?php endif; ?>
});

// Add some CSS for pulsing animation and timeline
const style = document.createElement('style');
style.textContent = `
    @keyframes pulse {
        0% { opacity: 1; }
        50% { opacity: 0.5; }
        100% { opacity: 1; }
    }
    .timeline {
        position: relative;
        padding-left: 20px;
    }
    .timeline-item {
        position: relative;
        margin-bottom: 15px;
    }
    .timeline-marker {
        position: absolute;
        left: -20px;
        top: 5px;
        width: 12px;
        height: 12px;
        border-radius: 50%;
        background: #007bff;
    }
    .timeline-content {
        margin-left: 0;
    }
`;
document.head.appendChild(style);
</script>
</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: view-order.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation