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: completed_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 ('completed', 'delivered')";

$params = [];
if ($branch_id) {
    $query .= " AND po.branch_id = ?";
    $params[] = $branch_id;
}
$query .= " ORDER BY po.updated_at DESC";

try {
    $stmt = $pdo->prepare($query);
    $stmt->execute($params);
    $preorders = $stmt->fetchAll(PDO::FETCH_ASSOC);
} catch (Exception $e) {
    die("Error: " . $e->getMessage());
}

$total = 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-success text-lg">
            Completed & Delivered Orders
        </h6>
        <ul class="d-flex align-items-center gap-1 small">
            <li class="fw-medium"><a href="index.php" class="d-flex align-items-center gap-1 hover-text-primary text-sm"><i class="fas fa-home fa-icon"></i> Dashboard</a></li>
            <li>-</li>
            <li class="fw-medium text-sm"><a href="pre_orders.php" class="hover-text-primary">Pre-Orders</a></li>
            <li>-</li>
            <li class="fw-medium text-success text-sm">Completed</li>
        </ul>
    </div>

<div class="row mb-24">
        <div class="col-md-4">
            <div class="card shadow-none border bg-gradient-start-2 h-100">
                <div class="card-body text-center">
                    <div class="d-flex justify-content-center align-items-center gap-3">
                        <div class="w-60-px h-60-px bg-success rounded-circle d-flex justify-content-center align-items-center">
                            <i class="fas fa-check-double text-white fa-2x"></i>
                        </div>
                        <div>
                            <h4 class="mb-0 text-success"><?= $total ?></h4>
                            <p class="mb-0 text-success fw-medium">Total Completed Orders</p>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>

<div class="card basic-data-table">
        <div class="card-header">
            <div class="d-flex flex-wrap align-items-center justify-content-between">
                <h5 class="section-title card-title mb-0 text-md">
                    Completed Pre-Orders List
                    
                </h5><span class="badge bg-success  ms-2" style="color:white !important"><?= $total ?></span>
            </div>
        </div>
        <div class="card-body p-16">
            
            <div class="d-none d-lg-block">
                <div class="table-responsive">
                    <table class="table bordered-table sm-table mb-0" id="dataTable">
                        <thead>
                            <tr>
                                <th>Order ID</th>
                                <th>Customer</th>
                                <th>Date & Time</th>
                                <th>Items</th>
                                <th class="amount-col">Price Details</th>
                                <th>Status</th>
                                <th>Delivery</th>
                                <th>Actions</th>
                            </tr>
                        </thead>
                        <tbody>
                            <?php if (empty($preorders)): ?>
                                <tr>
                                    <td colspan="8" class="text-center py-4">
                                        <i class="fas fa-check-circle text-3xl text-success mb-2 d-block"></i>
                                        <span>No completed orders found</span>
                                    </td>
                                </tr>
                            <?php else: ?>
                                <?php foreach ($preorders as $order):
                                    $status_badge = $order['status'] === 'completed' 
                                        ? 'bg-purple text-white' : 'bg-info text-white';
                                ?>
                                    <tr>
                                        <td><strong class="text-sm">#<?= $order['id'] ?></strong></td>
                                        <td>
                                            <div class="flex-grow-1">
                                                <h6 class="text-sm mb-0 fw-medium"><?= htmlspecialchars($order['customer_name']) ?></h6>
                                                <span class="text-xs text-secondary-light fw-medium"><?= htmlspecialchars($order['customer_phone']) ?></span>
                                            </div>
                                        </td>
                                        <td class="text-sm">
                                            <?= date('d M Y', strtotime($order['expected_date'])) ?><br>
                                            <small class="text-secondary"><?= date('h:i A', strtotime($order['expected_time'])) ?></small>
                                        </td>
                                        <td><span class="badge bg-secondary text-white"><?= $order['quantity'] ?> <?= ucfirst($order['unit']) ?></span></td>
                                        <td class="amount-col">
                                            <div class="price-breakdown">
                                                <div class="text-sm">
                                                    <strong class="total-amount">₹<?= number_format($order['total_amount'], 2) ?></strong>
                                                    <small class="text-muted d-block">Total</small>
                                                </div>
                                                <div class="text-sm mt-1">
                                                    <span class="text-success">₹<?= number_format($order['advance_amount'], 2) ?></span>
                                                    <small class="text-muted d-block">Paid</small>
                                                </div>
                                                <div class="text-sm mt-1">
                                                    <span class="text-danger">₹<?= number_format($order['balance_amount'], 2) ?></span>
                                                    <small class="text-muted d-block">Balance</small>
                                                </div>
                                            </div>
                                        </td>
                                        <td>
                                            <span class="badge <?= $status_badge ?> status-badge">
                                                <?= ucfirst($order['status']) ?>
                                            </span>
                                        </td>
                                        <td class="text-sm">
                                            <?= date('d M Y', strtotime($order['updated_at'])) ?><br>
                                            <small class="text-secondary"><?= date('h:i A', strtotime($order['updated_at'])) ?></small>
                                        </td>
                                        <td>
                                            <div class="d-flex gap-1">
                                                <a href="#" class="w-32-px h-32-px bg-primary-light text-primary-600 rounded-circle d-inline-flex align-items-center justify-content-center"
                                                   data-bs-toggle="modal" data-bs-target="#orderModal<?= $order['id'] ?>">
                                                    <i class="fas fa-eye"></i>
                                                </a>
                                            </div>
                                        </td>
                                    </tr>
                                <?php endforeach; ?>
                            <?php endif; ?>
                        </tbody>
                    </table>
                </div>
            </div>

<div class="d-block d-lg-none">
                <?php if (empty($preorders)): ?>
                    <div class="text-center py-4">
                        <i class="fas fa-check-circle text-3xl text-success mb-2 d-block"></i>
                        <span>No completed orders found</span>
                    </div>
                <?php else: ?>
                    <div class="row g-3">
                        <?php foreach ($preorders as $order):
                            $status_class = $order['status'] === 'completed' ? 'bg-purple' : 'bg-info';
                        ?>
                            <div class="col-12">
                                <div class="card shadow-sm">
                                    <div class="card-body">
                                        <div class="d-flex justify-content-between align-items-start mb-2">
                                            <h6 class="card-title mb-0 text-sm fw-bold">#<?= $order['id'] ?></h6>
                                            <span class="badge <?= $status_class ?> text-white px-2 py-1 text-xs">
                                                <?= ucfirst($order['status']) ?>
                                            </span>
                                        </div>
                                        <p class="mb-1 text-sm"><strong><i class="fas fa-user fa-icon"></i></strong> <?= htmlspecialchars($order['customer_name']) ?></p>
                                        <p class="mb-1 text-sm"><strong><i class="fas fa-phone fa-icon"></i></strong> <?= htmlspecialchars($order['customer_phone']) ?></p>
                                        
                                        <div class="row mb-2">
                                            <div class="col-6"><small class="text-muted"><strong>Delivery:</strong><br><?= date('d M Y', strtotime($order['expected_date'])) ?></small></div>
                                            <div class="col-6"><small class="text-muted"><strong>Time:</strong><br><?= date('h:i A', strtotime($order['expected_time'])) ?></small></div>
                                        </div>

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

<div class="text-center">
                                            <button class="btn btn-sm btn-outline-primary" data-bs-toggle="modal" data-bs-target="#orderModal<?= $order['id'] ?>">
                                                <i class="fas fa-eye fa-icon"></i> View Details
                                            </button>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        <?php endforeach; ?>
                    </div>
                <?php endif; ?>
            </div>
        </div>
    </div>
</div>

<?php foreach ($preorders as $order): ?>
<div class="modal fade" id="orderModal<?= $order['id'] ?>" tabindex="-1">
    <div class="modal-dialog modal-lg">
        <div class="modal-content">
            <div class="modal-header">
                <h5 class="modal-title"><i class="fas fa-receipt fa-icon"></i> Pre-Order #<?= $order['id'] ?> - Completed</h5>
                <button type="button" class="btn-close" data-bs-dismiss="modal"></button>
            </div>
            <div class="modal-body">
                <div class="row">
                    <div class="col-md-6">
                        <p class="mb-2"><strong>Customer:</strong> <?= htmlspecialchars($order['customer_name']) ?></p>
                        <p class="mb-2"><strong>Phone:</strong> <?= htmlspecialchars($order['customer_phone']) ?></p>
                        <?php if ($order['customer_address']): ?>
                            <p class="mb-2"><strong>Address:</strong> <?= htmlspecialchars($order['customer_address']) ?></p>
                        <?php endif; ?>
                    </div>
                    <div class="col-md-6">
                        <p class="mb-2"><strong>Delivery Date:</strong> <?= date('d M Y', strtotime($order['expected_date'])) ?></p>
                        <p class="mb-2"><strong>Time:</strong> <?= date('h:i A', strtotime($order['expected_time'])) ?></p>
                        <p class="mb-2"><strong>Status:</strong> 
                            <span class="badge <?= $order['status']==='completed'?'bg-purple':'bg-info' ?> text-white">
                                <?= ucfirst($order['status']) ?>
                            </span>
                        </p>
                    </div>
                </div>
                <hr>
                <h6>Product Details</h6>
                <p><strong><?= htmlspecialchars($order['food_name']) ?></strong> - <?= $order['quantity'] ?> <?= ucfirst($order['unit']) ?></p>
                <div class="row mt-3">
                    <div class="col-4 text-center">
                        <strong class="text-primary fs-5">₹<?= number_format($order['total_amount'],2) ?></strong><br><small>Total</small>
                    </div>
                    <div class="col-4 text-center">
                        <strong class="text-success fs-5">₹<?= number_format($order['advance_amount'],2) ?></strong><br><small>Paid</small>
                    </div>
                    <div class="col-4 text-center">
                        <strong class="text-danger fs-5">₹<?= number_format($order['balance_amount'],2) ?></strong><br><small>Balance</small>
                    </div>
                </div>
                <?php if ($order['occasion']): ?>
                    <p class="mt-3"><strong>Occasion:</strong> <?= htmlspecialchars($order['occasion']) ?></p>
                <?php endif; ?>
                <?php if ($order['special_notes']): ?>
                    <div class="alert alert-info mt-3">
                        <strong>Special Note:</strong><br><?= nl2br(htmlspecialchars($order['special_notes'])) ?>
                    </div>
                <?php endif; ?>
                <div class="text-center mt-3 text-muted small">
                    Completed on: <?= date('d M Y, h:i A', strtotime($order['updated_at'])) ?>
                </div>
            </div>
        </div>
    </div>
</div>
<?php endforeach; ?>

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

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: completed_preorders.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation