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/bakery/warehouse

Free Space:

10.24 TB

🔧 Quick Actions

✏️ Editing: pending_preorders.php

<?php
session_start();
require_once 'config/db_config.php';
if (!isset($_SESSION['user_id'])) { header("Location: ../login.php"); exit(); }

$branch_id = $_SESSION['branch_id'] ?? null;
$preorders = [];

$query = "SELECT po.*, b.branch_name FROM pre_orders po LEFT JOIN branches b ON po.branch_id = b.branch_id 
          WHERE po.status IN ('pending', 'confirmed', 'preparing', 'ready')";
$params = [];

if ($branch_id) {
    $query .= " AND po.branch_id = ?";
    $params[] = $branch_id;
}
$query .= " ORDER BY 
    CASE po.status WHEN 'ready' THEN 1 WHEN 'preparing' THEN 2 WHEN 'confirmed' THEN 3 ELSE 4 END,
    po.expected_date ASC, po.expected_time ASC";

$stmt = $pdo->prepare($query);
$stmt->execute($params);
$preorders = $stmt->fetchAll(PDO::FETCH_ASSOC);

$total_pending = count($preorders);

include './partials/layouts/layoutTop.php';
?>

<div class="dashboard-main-body">
    
    <div class="d-flex flex-wrap align-items-center justify-content-between gap-2 mb-16">
        <h6 class="fw-semibold mb-0 text-md text-warning">
            Pending & In-Progress Orders
        </h6>
        <ul class="d-flex align-items-center gap-1">
            <li class="fw-medium text-sm"><a href="preorders.php" class="hover-text-primary">Pre-Orders</a></li>
            <li>-</li>
            <li class="fw-medium text-sm text-warning">Pending</li>
        </ul>
    </div>

<div class="row mb-16">
        <div class="col-md-4">
            <div class="card summary-card">
                <div class="card-body text-center p-3">
                    <h6 class="card-title mb-1 text-warning">Total Pending</h6>
                    <h4 class="mb-0 text-warning"><?= $total_pending ?></h4>
                </div>
            </div>
        </div>
        <div class="col-md-4">
            <div class="card summary-card">
                <div class="card-body text-center p-3">
                    <h6 class="card-title mb-1 text-success">Ready for Delivery</h6>
                    <h4 class="mb-0 text-success">
                        <?= count(array_filter($preorders, fn($o) => $o['status'] === 'ready')) ?>
                    </h4>
                </div>
            </div>
        </div>
        <div class="col-md-4">
            <div class="card summary-card">
                <div class="card-body text-center p-3">
                    <h6 class="card-title mb-1 text-info">Today's Orders</h6>
                    <h4 class="mb-0 text-info">
                        <?= count(array_filter($preorders, fn($o) => $o['expected_date'] === date('Y-m-d'))) ?>
                    </h4>
                </div>
            </div>
        </div>
    </div>

<div class="card">
        <div class="card-header">
            <h5 class="section-title card-title mb-0 text-md">
                Pending Orders List
                <span class="badge bg-warning text-dark ms-2"><?= $total_pending ?></span>
            </h5>
        </div>
        <div class="card-body">
            <?php if (empty($preorders)): ?>
                <div class="text-center py-5">
                    <i class="fas fa-thumbs-up fa-3x text-success mb-3"></i>
                    <h6 class="text-success">All caught up!</h6>
                </div>
            <?php else: ?>
                <div class="order-grid">
                    <?php foreach ($preorders as $order): 
                        $status_class = 'status-' . $order['status'];
                        $badge = [
                            'pending' => ['bg-secondary', 'Pending'],
                            'confirmed' => ['bg-primary', 'Confirmed'],
                            'preparing' => ['bg-warning text-dark', 'Preparing'],
                            'ready' => ['bg-success', 'Ready']
                        ][$order['status']];

$today = date('Y-m-d');
                        $is_today = $order['expected_date'] === $today;
                        $is_overdue = $order['expected_date'] < $today;
                        $card_class = $is_overdue ? 'urgent-order' : ($is_today ? 'today-order' : '');
                    ?>
                        <div class="card order-card <?= $status_class . ' ' . $card_class ?>">
                            <div class="card-body">
                                <div class="d-flex justify-content-between align-items-start mb-3">
                                    <div>
                                        <h6 class="card-title mb-0 text-sm fw-bold">
                                            #<?= $order['id'] ?> - <?= htmlspecialchars($order['customer_name']) ?>
                                        </h6>
                                        <small class="text-muted">
                                            <i class="fas fa-phone me-1"></i><?= htmlspecialchars($order['customer_phone']) ?>
                                        </small>
                                    </div>
                                    <span class="badge status-badge <?= $badge[0] ?>">
                                        <?= $badge[1] ?>
                                    </span>
                                </div>

<div class="mb-3 p-2 bg-light rounded">
                                    <div class="row text-center">
                                        <div class="col-4">
                                            <small class="text-muted d-block">Total</small>
                                            <strong class="text-primary">₹<?= number_format($order['total_amount'], 2) ?></strong>
                                        </div>
                                        <div class="col-4">
                                            <small class="text-muted d-block">Advance</small>
                                            <strong class="text-success">₹<?= number_format($order['advance_amount'], 2) ?></strong>
                                        </div>
                                        <div class="col-4">
                                            <small class="text-muted d-block">Balance</small>
                                            <strong class="text-danger">₹<?= number_format($order['balance_amount'], 2) ?></strong>
                                        </div>
                                    </div>
                                </div>

<div class="mb-3">
                                    <div class="text-sm">
                                        <i class="fas fa-calendar me-2"></i>
                                        <strong>Delivery:</strong>
                                        <?= date('M j, Y', strtotime($order['expected_date'])) ?>
                                        at <?= date('g:i A', strtotime($order['expected_time'])) ?>
                                    </div>
                                    <?php if (!empty($order['occasion'])): ?>
                                        <div class="text-sm">
                                            <i class="fas fa-gift me-2"></i>
                                            <strong>Occasion:</strong> <?= htmlspecialchars($order['occasion']) ?>
                                        </div>
                                    <?php endif; ?>
                                </div>

<div class="modal fade" id="updateStatusModal" tabindex="-1">
    <div class="modal-dialog modal-sm">
        <form method="POST" action="preorders.php">
            <div class="modal-content">
                <div class="modal-header">
                    <h5 class="modal-title text-md">Update Order Status</h5>
                    <button type="button" class="btn-close btn-sm" data-bs-dismiss="modal"></button>
                </div>
                <div class="modal-body">
                    <input type="hidden" name="order_id" id="update_order_id">
                    <select class="form-select" name="status" id="status" required>
                        <option value="pending">Pending</option>
                        <option value="confirmed">Confirmed</option>
                        <option value="preparing">Preparing</option>
                        <option value="ready">Ready</option>
                        <option value="delivered">Delivered</option>
                        <option value="completed">Completed</option>
                    </select>
                </div>
                <div class="modal-footer">
                    <button type="submit" name="update_status" class="btn btn-primary btn-sm">
                        Update Status
                    </button>
                </div>
            </div>
        </form>
    </div>
</div>

<?php include './partials/layouts/layoutBottom.php'; ?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: pending_preorders.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation