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/hifi11.in/public_html/vsenthur

Free Space:

10.26 TB

🔧 Quick Actions

✏️ Editing: order_success.php

<?php
// config/db_config.php
try {
    $dsn = "mysql:host=localhost;dbname=u329947844_vsenthur;charset=utf8mb4";
    $username = "u329947844_vsenthur";
    $password = "Vsenthur@25";
    $conn = new PDO($dsn, $username, $password);
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    $conn->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
} catch (PDOException $e) {
    die("Connection failed: " . $e->getMessage());
}

session_start();

// Check if there's a last order in session
if (!isset($_SESSION['last_order'])) {
    header('Location: index.php');
    exit;
}
$order = $_SESSION['last_order'];

// Get branch_id and table_id from URL
$branch_id = isset($_GET['branch_id']) ? (int)$_GET['branch_id'] : 0;
$table_id = isset($_GET['table_id']) ? (int)$_GET['table_id'] : 0;

// Validate branch_id
if ($branch_id <= 0) {
    header('Location: index.php');
    exit;
}

// Function to get all versions of an order chain with KOT information
function getAllOrderVersions($conn, $order_id) {
    $versions = [];
    
    // First, find the latest order in the chain (the one with no followed_order_id pointing to it as the latest)
    $stmt = $conn->prepare("
        WITH RECURSIVE order_chain AS (
            -- Start from the given order_id
            SELECT order_id, followed_order_id, order_version, total_amount, customer_name, 
                   customer_contact, order_date, status, table_number, 1 as level
            FROM orders
            WHERE order_id = :order_id
            
            UNION ALL
            
            -- Follow the chain backwards to get previous versions
            SELECT o.order_id, o.followed_order_id, o.order_version, o.total_amount, 
                   o.customer_name, o.customer_contact, o.order_date, o.status, o.table_number, oc.level + 1
            FROM orders o
            INNER JOIN order_chain oc ON o.order_id = oc.followed_order_id
        )
        SELECT * FROM order_chain
        ORDER BY level DESC
    ");
    $stmt->execute(['order_id' => $order_id]);
    $versions = $stmt->fetchAll();
    
    // Get items and KOT information for each version
    foreach ($versions as &$version) {
        // Get items for this version
        $stmt = $conn->prepare("
            SELECT oi.*, f.food_name, k.kot_number, k.status as kot_status
            FROM order_items oi
            JOIN foods f ON oi.food_id = f.food_id
            LEFT JOIN kots k ON oi.kot_id = k.kot_id
            WHERE oi.order_id = :order_id AND oi.order_version = :order_version
            ORDER BY oi.item_id
        ");
        $stmt->execute([
            'order_id' => $version['order_id'],
            'order_version' => $version['order_version']
        ]);
        $version['items'] = $stmt->fetchAll();
        
        // Get KOTs for this version
        $stmt = $conn->prepare("
            SELECT k.*, 
                   (SELECT COUNT(*) FROM order_items WHERE kot_id = k.kot_id) as item_count
            FROM kots k
            WHERE k.order_id = :order_id
            ORDER BY k.kot_number
        ");
        $stmt->execute(['order_id' => $version['order_id']]);
        $version['kots'] = $stmt->fetchAll();
    }
    
    return $versions;
}

// Function to calculate cumulative total across all versions
function calculateCumulativeTotal($versions) {
    $total = 0;
    foreach ($versions as $version) {
        $total += floatval($version['total_amount']);
    }
    return $total;
}

// Get branch name
$stmt = $conn->prepare("SELECT branch_name FROM branches WHERE branch_id = :branch_id");
$stmt->execute(['branch_id' => $branch_id]);
$branch = $stmt->fetch();
$branch_name = $branch['branch_name'] ?? 'Elite Dhaba';

// Get all versions of this order
$order_versions = getAllOrderVersions($conn, $order['order_id']);
$cumulative_total = calculateCumulativeTotal($order_versions);

// The latest version is the first one in the array
$latest_version = !empty($order_versions) ? $order_versions[0] : null;

$is_update = count($order_versions) > 1;

// Get KOT info from session if available
$kot_id = $_SESSION['last_order']['kot_id'] ?? null;
$kot_number = $_SESSION['last_order']['kot_number'] ?? null;

unset($_SESSION['last_order']); // Clear after displaying

// Status colors for KOT
$kot_status_colors = [
    'pending' => '#ffc107',
    'preparing' => '#17a2b8',
    'ready' => '#28a745',
    'served' => '#6c757d'
];
?>

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title><?php echo $is_update ? 'Order Updated' : 'Order Successful'; ?> - <?php echo htmlspecialchars($branch_name); ?></title>
    
    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css" rel="stylesheet">
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.4.0/css/all.min.css">
    <style>
        :root {
            --primary: #F99F1E;
            --secondary: #F16823;
            --dark: #202544;
        }
        body {
            background: linear-gradient(135deg, var(--primary) 0%, var(--secondary) 100%);
            font-family: 'Segoe UI', Tahoma, Geneva, Verdana, sans-serif;
            min-height: 100vh;
            display: flex;
            align-items: center;
            justify-content: center;
            padding: 20px;
        }
        .success-card {
            max-width: 700px;
            width: 100%;
            background: white;
            border-radius: 20px;
            box-shadow: 0 20px 40px rgba(0,0,0,0.1);
            overflow: hidden;
        }
        .success-header {
            background: <?php echo $is_update ? 'linear-gradient(135deg, #3b82f6 0%, #2563eb 100%)' : 'linear-gradient(135deg, #10b981 0%, #059669 100%)'; ?>;
            color: white;
            padding: 2rem;
            text-align: center;
        }
        .version-tabs {
            display: flex;
            gap: 8px;
            overflow-x: auto;
            padding: 12px;
            background: #f8f9fa;
            border-bottom: 1px solid #dee2e6;
        }
        .version-tab {
            padding: 8px 16px;
            border-radius: 20px;
            font-size: 12px;
            font-weight: 600;
            background: white;
            border: 1px solid #dee2e6;
            color: #6c757d;
            cursor: pointer;
            white-space: nowrap;
            transition: all 0.3s ease;
            display: flex;
            align-items: center;
            gap: 4px;
        }
        .version-tab.active {
            background: linear-gradient(135deg, var(--primary) 0%, var(--secondary) 100%);
            border-color: var(--primary);
            color: white;
        }
        .version-tab:not(.active):hover {
            background: #e9ecef;
        }
        .version-content {
            display: none;
        }
        .version-content.active {
            display: block;
        }
        .version-badge {
            background: linear-gradient(135deg, #6366f1 0%, #4f46e5 100%);
            color: white;
            font-size: 10px;
            padding: 2px 8px;
            border-radius: 12px;
            margin-left: 8px;
        }
        .kot-badge {
            background: linear-gradient(135deg, #6c5ce7 0%, #5849c2 100%);
            color: white;
            font-size: 10px;
            padding: 2px 6px;
            border-radius: 4px;
            margin-left: 5px;
            display: inline-block;
        }
        .kot-status {
            display: inline-block;
            width: 8px;
            height: 8px;
            border-radius: 50%;
            margin-right: 4px;
        }
        .kot-status.pending { background-color: #ffc107; }
        .kot-status.preparing { background-color: #17a2b8; }
        .kot-status.ready { background-color: #28a745; }
        .kot-status.served { background-color: #6c757d; }
        .order-items-container {
            max-height: 300px;
            overflow-y: auto;
            padding-right: 8px;
        }
        .order-items-container::-webkit-scrollbar {
            width: 6px;
        }
        .order-items-container::-webkit-scrollbar-track {
            background: #f1f1f1;
            border-radius: 10px;
        }
        .order-items-container::-webkit-scrollbar-thumb {
            background: var(--primary);
            border-radius: 10px;
        }
        .btn-primary-custom {
            background: linear-gradient(135deg, var(--primary) 0%, var(--secondary) 100%);
            border: none;
            color: white;
            font-weight: 600;
            padding: 12px 24px;
        }
        .btn-primary-custom:hover {
            background: linear-gradient(135deg, #e88f1a 0%, #d85c1f 100%);
            color: white;
        }
        .btn-edit-custom {
            background: linear-gradient(135deg, #3b82f6 0%, #2563eb 100%);
            border: none;
            color: white;
            font-weight: 600;
            padding: 12px 24px;
        }
        .btn-edit-custom:hover {
            background: linear-gradient(135deg, #2563eb 0%, #1d4ed8 100%);
            color: white;
        }
        .btn-kot-custom {
            background: linear-gradient(135deg, #6c5ce7 0%, #5849c2 100%);
            border: none;
            color: white;
            font-weight: 600;
            padding: 12px 24px;
        }
        .btn-kot-custom:hover {
            background: linear-gradient(135deg, #5849c2 0%, #4338ca 100%);
            color: white;
        }
        .status-badge {
            display: inline-block;
            padding: 4px 12px;
            border-radius: 20px;
            font-size: 12px;
            font-weight: 600;
            text-transform: uppercase;
        }
        .status-pending {
            background: #fef3c7;
            color: #92400e;
        }
        .status-processing {
            background: #dbeafe;
            color: #1e40af;
        }
        .status-completed {
            background: #d1fae5;
            color: #065f46;
        }
        .status-cancelled {
            background: #fee2e2;
            color: #991b1b;
        }
        .cumulative-total {
            background: linear-gradient(135deg, #10b981 0%, #059669 100%);
            color: white;
            padding: 12px;
            border-radius: 8px;
            margin-top: 12px;
        }
        .version-total {
            font-size: 14px;
            color: #6c757d;
        }
        .kot-section {
            background: #f8f9fa;
            border-radius: 8px;
            padding: 12px;
            margin-bottom: 12px;
        }
        .kot-number {
            font-weight: 600;
            color: #6c5ce7;
        }
        .item-kot-badge {
            background: #e9ecef;
            color: #495057;
            font-size: 10px;
            padding: 2px 6px;
            border-radius: 4px;
            margin-left: 8px;
        }
        .whatsapp-btn {
            background-color: #25D366;
            color: white;
            border: none;
            padding: 8px 16px;
            border-radius: 8px;
            font-size: 14px;
            font-weight: 600;
            cursor: pointer;
            transition: background-color 0.3s;
        }
        .whatsapp-btn:hover {
            background-color: #128C7E;
        }
        .whatsapp-btn i {
            margin-right: 8px;
        }
    </style>
</head>
<body>
    <div class="success-card">
        
        <div class="success-header">
            <div class="mb-3">
                <i class="fas <?php echo $is_update ? 'fa-check-double' : 'fa-check-circle'; ?> fa-4x text-white"></i>
            </div>
            <h1 class="h2 fw-bold mb-2"><?php echo $is_update ? 'Order Updated!' : 'Order Successful!'; ?></h1>
            <p class="mb-0 opacity-90"><?php echo $is_update ? 'Your order has been updated successfully' : 'Thank you for your order'; ?></p>
        </div>
        
        
        <div class="p-4">
            
            <div class="card border-0 shadow-sm mb-4">
                <div class="card-body">
                    <div class="d-flex justify-content-between align-items-center mb-3">
                        <h6 class="fw-bold text-dark mb-0">Order Summary</h6>
                        <span class="status-badge status-<?php echo strtolower($latest_version['status'] ?? 'pending'); ?>">
                            <?php echo ucfirst($latest_version['status'] ?? 'Pending'); ?>
                        </span>
                    </div>
                    <div class="row g-3">
                        <div class="col-6">
                            <small class="text-muted d-block">Order ID</small>
                            <strong class="text-dark">#<?php echo htmlspecialchars($order['order_id']); ?></strong>
                            <?php if (count($order_versions) > 1): ?>
                                <span class="version-badge"><?php echo count($order_versions); ?> versions</span>
                            <?php endif; ?>
                        </div>
                        <div class="col-6">
                            <small class="text-muted d-block">Branch</small>
                            <strong class="text-dark"><?php echo htmlspecialchars($branch_name); ?></strong>
                        </div>
                        <div class="col-6">
                            <small class="text-muted d-block">Customer</small>
                            <strong class="text-dark"><?php echo htmlspecialchars($latest_version['customer_name'] ?? $order['customer_name']); ?></strong>
                        </div>
                        <?php if (!empty($latest_version['customer_contact']) && $latest_version['customer_contact'] != '0000000000'): ?>
                        <div class="col-6">
                            <small class="text-muted d-block">Contact</small>
                            <strong class="text-dark"><?php echo htmlspecialchars($latest_version['customer_contact']); ?></strong>
                        </div>
                        <?php endif; ?>
                        <?php if ($latest_version['table_number'] ?? $order['table_number']): ?>
                        <div class="col-6">
                            <small class="text-muted d-block">Table Number</small>
                            <strong class="text-dark"><?php echo htmlspecialchars($latest_version['table_number'] ?? $order['table_number']); ?></strong>
                        </div>
                        <?php endif; ?>
                        <?php if ($kot_number): ?>
                        <div class="col-6">
                            <small class="text-muted d-block">KOT Number</small>
                            <strong class="text-dark kot-number">#<?php echo str_pad($kot_number, 3, '0', STR_PAD_LEFT); ?></strong>
                        </div>
                        <?php endif; ?>
                        <?php if (isset($latest_version['order_date'])): ?>
                        <div class="col-12">
                            <small class="text-muted d-block">Last Updated</small>
                            <strong class="text-dark"><?php echo date('d M Y, h:i A', strtotime($latest_version['order_date'])); ?></strong>
                        </div>
                        <?php endif; ?>
                    </div>
                </div>
            </div>

<?php if (count($order_versions) > 1): ?>
            
            <div class="version-tabs mb-3">
                <?php foreach ($order_versions as $index => $version): ?>
                    <div class="version-tab <?php echo $index === 0 ? 'active' : ''; ?>" 
                         onclick="showVersion(<?php echo $index; ?>)">
                        <i class="fas fa-code-branch"></i>
                        v<?php echo $version['order_version']; ?>
                        <small>(₹<?php echo number_format($version['total_amount'], 0); ?>)</small>
                        <?php if (!empty($version['kots'])): ?>
                            <span class="kot-badge"><?php echo count($version['kots']); ?> KOTs</span>
                        <?php endif; ?>
                    </div>
                <?php endforeach; ?>
            </div>
            <?php endif; ?>

<?php foreach ($order_versions as $index => $version): ?>
            <div id="version-<?php echo $index; ?>" class="version-content <?php echo $index === 0 ? 'active' : ''; ?>">
                <div class="d-flex justify-content-between align-items-center mb-2">
                    <h5 class="fw-semibold text-dark mb-0">
                        Version <?php echo $version['order_version']; ?> Items
                        <?php if (!empty($version['kots'])): ?>
                            <span class="kot-badge"><?php echo count($version['kots']); ?> KOTs</span>
                        <?php endif; ?>
                    </h5>
                    <span class="version-total">Total: ₹<?php echo number_format($version['total_amount'], 2); ?></span>
                </div>
                
                
                <?php if (!empty($version['kots'])): ?>
                    <div class="kot-section">
                        <small class="text-muted d-block mb-2">Kitchen Order Tickets:</small>
                        <div class="d-flex flex-wrap gap-2">
                            <?php foreach ($version['kots'] as $kot): ?>
                                <span class="badge" style="background: <?php echo $kot_status_colors[$kot['status']] ?? '#6c757d'; ?>; color: white;">
                                    <span class="kot-status <?php echo $kot['status']; ?>"></span>
                                    KOT #<?php echo str_pad($kot['kot_number'], 3, '0', STR_PAD_LEFT); ?>
                                    <span class="badge bg-white text-dark ms-1"><?php echo $kot['item_count']; ?> items</span>
                                </span>
                            <?php endforeach; ?>
                        </div>
                    </div>
                <?php endif; ?>
                
                
                <div class="order-items-container mb-3">
                    <?php if (!empty($version['items'])): ?>
                        <?php foreach ($version['items'] as $item): ?>
                            <div class="d-flex justify-content-between align-items-center py-2 border-bottom">
                                <div class="flex-grow-1">
                                    <div class="d-flex align-items-center">
                                        <h6 class="fw-semibold text-dark mb-1"><?php echo htmlspecialchars($item['food_name']); ?></h6>
                                        <?php if (!empty($item['kot_number'])): ?>
                                            <span class="item-kot-badge">
                                                <i class="fas fa-print me-1"></i>KOT #<?php echo str_pad($item['kot_number'], 3, '0', STR_PAD_LEFT); ?>
                                            </span>
                                        <?php endif; ?>
                                    </div>
                                    <small class="text-muted">
                                        Qty: <?php echo htmlspecialchars($item['quantity']); ?> × ₹<?php echo number_format($item['price'], 2); ?>
                                    </small>
                                </div>
                                <div class="text-end">
                                    <strong class="text-dark">₹<?php echo number_format($item['subtotal'], 2); ?></strong>
                                </div>
                            </div>
                        <?php endforeach; ?>
                    <?php else: ?>
                        <div class="text-center py-3 text-muted">
                            <p class="mb-0">No items in this version</p>
                        </div>
                    <?php endif; ?>
                </div>
                
                
                <small class="text-muted d-block text-end">
                    <i class="far fa-clock me-1"></i>
                    Added on <?php echo date('d M Y, h:i A', strtotime($version['order_date'])); ?>
                </small>
            </div>
            <?php endforeach; ?>

<?php if (count($order_versions) > 1): ?>
            <div class="cumulative-total mt-4">
                <div class="d-flex justify-content-between align-items-center">
                    <span class="fw-semibold">Complete Order Total (All Versions):</span>
                    <span class="fw-bold fs-5">₹<?php echo number_format($cumulative_total, 2); ?></span>
                </div>
                <small class="text-white-50 d-block mt-1">* Includes all items from all versions</small>
            </div>
            <?php endif; ?>

<?php if (count($order_versions) <= 1): ?>
            <div class="border-top pt-3 mt-4">
                <div class="d-flex justify-content-between align-items-center">
                    <span class="fw-bold text-dark fs-5">Total Bill:</span>
                    <span class="fw-bold text-success fs-5">₹<?php echo number_format($order['total_amount'], 2); ?></span>
                </div>
                <small class="text-muted text-center d-block mt-2">* GST not included</small>
            </div>
            <?php endif; ?>
        </div>

<div class="p-4 bg-light">
            <div class="row g-2">
                <?php if ($kot_number): ?>
                <div class="col-12">
                    <button class="btn-kot-custom w-100 py-3 rounded-2 fw-semibold mb-2" onclick="printKOT(<?php echo $order['order_id']; ?>, <?php echo $kot_number; ?>)">
                        <i class="fas fa-print me-2"></i>Print KOT #<?php echo str_pad($kot_number, 3, '0', STR_PAD_LEFT); ?>
                    </button>
                </div>
                <?php endif; ?>
                
                <?php if ($is_update): ?>
                    <div class="col-12">
                        <a href="menu.php?branch_id=<?php echo htmlspecialchars($branch_id); ?><?php echo $table_id ? '&table_id=' . htmlspecialchars($table_id) : ''; ?>" 
                           class="btn btn-primary-custom w-100 py-3 rounded-2 fw-semibold mb-2">
                            <i class="fas fa-utensils me-2"></i>Add More Items
                        </a>
                    </div>
                    <div class="col-12">
                        <a href="menu.php?branch_id=<?php echo htmlspecialchars($branch_id); ?><?php echo $table_id ? '&table_id=' . htmlspecialchars($table_id) : ''; ?>&new_order=1" 
                           class="btn btn-outline-secondary w-100 py-3 rounded-2 fw-semibold">
                            <i class="fas fa-plus-circle me-2"></i>Start New Order
                        </a>
                    </div>
                <?php else: ?>
                    <div class="col-md-6">
                        <a href="menu.php?branch_id=<?php echo htmlspecialchars($branch_id); ?><?php echo $table_id ? '&table_id=' . htmlspecialchars($table_id) : ''; ?>&edit_order=<?php echo $order['order_id']; ?>" 
                           class="btn btn-edit-custom w-100 py-3 rounded-2 fw-semibold">
                            <i class="fas fa-edit me-2"></i>Edit Order
                        </a>
                    </div>
                    <div class="col-md-6">
                        <a href="menu.php?branch_id=<?php echo htmlspecialchars($branch_id); ?><?php echo $table_id ? '&table_id=' . htmlspecialchars($table_id) : ''; ?>" 
                           class="btn btn-primary-custom w-100 py-3 rounded-2 fw-semibold">
                            <i class="fas fa-utensils me-2"></i>New Order
                        </a>
                    </div>
                    <?php if (!empty($latest_version['customer_contact']) && $latest_version['customer_contact'] != '0000000000'): ?>
                    <div class="col-12 mt-2">
                        <button class="whatsapp-btn w-100 py-3 rounded-2 fw-semibold" onclick="sendWhatsApp(<?php echo $order['order_id']; ?>, '<?php echo $latest_version['customer_contact']; ?>')">
                            <i class="fab fa-whatsapp"></i>Send Invoice via WhatsApp
                        </button>
                    </div>
                    <?php endif; ?>
                <?php endif; ?>
            </div>
        </div>
    </div>

<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: order_success.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation