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/.trash

Free Space:

10.3 TB

🔧 Quick Actions

✏️ Editing: print_receipt.php

<?php
session_start();
require_once 'config/db_config.php';

// Validate session
if (!isset($_SESSION['user_id']) || !isset($_SESSION['role']) || $_SESSION['role'] !== 'staff' || !isset($_SESSION['branch_id'])) {
    error_log("Unauthorized access attempt. Session data: " . json_encode($_SESSION));
    header("Location: login.php");
    exit();
}

echo '<script>localStorage.removeItem("currentOrder");</script>';

$branch_id = (int)$_SESSION['branch_id'];
$order_id = isset($_GET['order_id']) ? (int)$_GET['order_id'] : 0;
$print_type = isset($_GET['print']) ? $_GET['print'] : 'both';
$is_reprint = isset($_GET['reprint']) && $_GET['reprint'] === '1';
$errors = [];
$order = null;
$order_items = [];
$branch = [];
$tax = [];
$cgst_rate = 0;
$sgst_rate = 0;

// Fetch printer settings - Set default to 80mm thermal
$default_printer_type = 'Thermal';
$default_paper_size = 'A4';
$default_thermal_paper_size = '80mm';
try {
    $stmt = $pdo->prepare("SELECT default_printer_type, default_paper_size, default_thermal_paper_size FROM printer_settings WHERE branch_id = :branch_id");
    $stmt->execute(['branch_id' => $branch_id]);
    $printer_settings = $stmt->fetch(PDO::FETCH_ASSOC);
    if ($printer_settings) {
        $default_printer_type = $printer_settings['default_printer_type'] ?? 'Thermal';
        $default_paper_size = $printer_settings['default_paper_size'] ?? 'A4';
        $default_thermal_paper_size = $printer_settings['default_thermal_paper_size'] ?? '80mm';
    }
} catch (PDOException $e) {
    $errors[] = "Error fetching printer settings: " . htmlspecialchars($e->getMessage());
    error_log("Printer settings query failed: " . $e->getMessage());
}

// Fetch branch details
try {
    $stmt = $pdo->prepare("SELECT branch_name, address, city, state, country FROM branches WHERE branch_id = :branch_id");
    $stmt->execute(['branch_id' => $branch_id]);
    $branch = $stmt->fetch(PDO::FETCH_ASSOC);
    if (!$branch) {
        $errors[] = "Branch not found.";
        error_log("Branch not found for branch_id: $branch_id");
    }
} catch (PDOException $e) {
    $errors[] = "Error fetching branch details: " . htmlspecialchars($e->getMessage());
    error_log("Branch query failed: " . $e->getMessage());
}

// Fetch order details
try {
    $stmt = $pdo->prepare("
        SELECT order_id, customer_name, customer_contact, order_date, total_amount, status, notes, payment_method, order_type, table_number, coupon_code, coupon_discount, is_gst_active, cgst_amount, sgst_amount, extra_charge
        FROM orders 
        WHERE order_id = :order_id AND branch_id = :branch_id
    ");
    $stmt->execute(['order_id' => $order_id, 'branch_id' => $branch_id]);
    $order = $stmt->fetch(PDO::FETCH_ASSOC);
    if (!$order) {
        $errors[] = "Order not found.";
        error_log("Order not found for order_id: $order_id, branch_id: $branch_id");
    }
} catch (PDOException $e) {
    $errors[] = "Error fetching order: " . htmlspecialchars($e->getMessage());
    error_log("Order query failed: " . $e->getMessage());
}

// Fetch order items
if ($order) {
    try {
        $stmt = $pdo->prepare("
            SELECT oi.food_id, oi.quantity, oi.price, oi.subtotal, f.food_name, f.image_url
            FROM order_items oi
            JOIN foods f ON oi.food_id = f.food_id
            WHERE oi.order_id = :order_id
        ");
        $stmt->execute(['order_id' => $order_id]);
        $order_items = $stmt->fetchAll(PDO::FETCH_ASSOC) ?: [];
    } catch (PDOException $e) {
        $errors[] = "Error fetching order items: " . htmlspecialchars($e->getMessage());
        error_log("Order items query failed: " . $e->getMessage());
    }
}

// Fetch tax rates
try {
    $stmt = $pdo->prepare("
        SELECT cgst_rate, sgst_rate 
        FROM taxes 
        WHERE branch_id = :branch_id 
        AND effective_date <= :order_date
        ORDER BY effective_date DESC 
        LIMIT 1
    ");
    $stmt->execute([
        'branch_id' => $branch_id,
        'order_date' => $order ? $order['order_date'] : date('Y-m-d H:i:s')
    ]);
    $tax = $stmt->fetch(PDO::FETCH_ASSOC);
    $cgst_rate = $tax ? (float)$tax['cgst_rate'] : 0;
    $sgst_rate = $tax ? (float)$tax['sgst_rate'] : 0;
} catch (PDOException $e) {
    $errors[] = "Error fetching tax rates: " . htmlspecialchars($e->getMessage());
    error_log("Tax query failed: " . $e->getMessage());
}

// Calculate amounts
$subtotal = $order ? array_sum(array_column($order_items, 'subtotal')) : 0;
$cgst_amount = $order && $order['is_gst_active'] === '1' ? (float)$order['cgst_amount'] : ($is_reprint ? $subtotal * ($cgst_rate / 100) : 0);
$sgst_amount = $order && $order['is_gst_active'] === '1' ? (float)$order['sgst_amount'] : ($is_reprint ? $subtotal * ($sgst_rate / 100) : 0);
$coupon_discount = $order ? (float)$order['coupon_discount'] : 0;
$extra_charge = $order ? (float)$order['extra_charge'] : 0;
$total_amount = $is_reprint ? $subtotal : ($order ? (float)$order['total_amount'] : 0);

// Determine what to print based on print_type
$print_bill = ($print_type === 'bill' || $print_type === 'both');
$print_kot = ($print_type === 'kot' || $print_type === 'both');

// Determine redirect URL
$redirect_url = $is_reprint ? 'orders.php' : 'create_order.php';
?>

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Print Receipt - Order #<?php echo htmlspecialchars($order_id); ?></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>
        /* ======= 80mm THERMAL RECEIPT - ULTRA BOLD ======= */
        @page {
            size: 80mm auto !important;
            margin: 0mm !important;
        }
        
        body {
            font-family: 'Courier New', Courier, monospace !important;
            background-color: #fff !important;
            color: #000 !important;
            margin: 0 auto !important;
            padding: 2mm 2mm !important;
            font-size: 12px !important;
            line-height: 1.2 !important;
            font-weight: 900 !important;
            width: 80mm !important;
            max-width: 80mm !important;
            box-sizing: border-box !important;
            letter-spacing: 0.3px !important;
        }

/* Print containers optimized for 80mm */
        .receipt-container, .kot-container {
            width: 76mm !important;
            margin: 0 auto !important;
            padding: 2mm 2mm 5mm 2mm !important;
            box-sizing: border-box !important;
            background: #fff !important;
            page-break-after: always !important;
            position: relative !important;
        }

.kot-container {
            border-top: 2px dashed #dc3545 !important;
            border-bottom: 2px dashed #dc3545 !important;
            background-color: #fff8f8 !important;
        }

.kot-header {
            text-align: center !important;
            margin-bottom: 3mm !important;
            color: #dc3545 !important;
            font-weight: 900 !important;
        }

.receipt-header {
            text-align: center !important;
            margin-bottom: 3mm !important;
        }

.receipt-header h2 {
            font-size: 18px !important;
            margin: 2px 0 !important;
            font-weight: 900 !important;
            text-transform: uppercase !important;
            letter-spacing: 1px !important;
        }

.kot-header h2 {
            font-size: 18px !important;
            margin: 2px 0 !important;
            color: #dc3545 !important;
            font-weight: 900 !important;
            text-transform: uppercase !important;
            letter-spacing: 1px !important;
        }

.receipt-header p, .kot-header p {
            margin: 2px 0 !important;
            font-size: 11px !important;
            font-weight: 900 !important;
        }

.table {
            width: 100% !important;
            border-collapse: collapse !important;
            margin-bottom: 3px !important;
            font-size: 11px !important;
        }

.table th, .table td {
            padding: 2px 1px !important;
            text-align: left !important;
            border-bottom: 1px dashed #000 !important;
            font-size: 11px !important;
            font-weight: 900 !important;
        }

.kot-table th, .kot-table td {
            border-bottom: 1px dashed #dc3545 !important;
            font-size: 11px !important;
            font-weight: 900 !important;
        }

.table th {
            font-weight: 900 !important;
            font-size: 12px !important;
            text-transform: uppercase !important;
        }

.kot-table th {
            color: #dc3545 !important;
            font-weight: 900 !important;
            font-size: 12px !important;
            text-transform: uppercase !important;
        }

.total-row {
            font-weight: 900 !important;
            font-size: 13px !important;
            border-top: 2px solid #000 !important;
        }

.kot-total-row {
            border-top: 2px solid #dc3545 !important;
        }

.text-center {
            text-align: center !important;
        }

.text-right {
            text-align: right !important;
        }

.divider {
            border-top: 1px dashed #000 !important;
            margin: 3px 0 !important;
            height: 1px !important;
        }

.kot-divider {
            border-top: 1px dashed #dc3545 !important;
            margin: 3px 0 !important;
            height: 1px !important;
        }

/* Hide print buttons in print mode */
        .btn-print {
            display: none !important;
        }

.notes-section {
            margin-top: 2px !important;
            font-size: 10px !important;
            word-wrap: break-word !important;
            font-weight: 900 !important;
            background: #f8f9fa !important;
            padding: 2px !important;
            border-radius: 2px !important;
        }

.kot-notes {
            color: #dc3545 !important;
            font-weight: 900 !important;
            background: #fff3f3 !important;
            border-left: 2px solid #dc3545 !important;
        }

.print-status, .redirect-status {
            display: none !important;
        }

.kot-badge {
            background-color: #dc3545 !important;
            color: white !important;
            padding: 2px 4px !important;
            border-radius: 2px !important;
            font-size: 10px !important;
            font-weight: 900 !important;
            margin-left: 3px !important;
            text-transform: uppercase !important;
        }

.print-watermark {
            opacity: 0.1 !important;
            position: absolute !important;
            top: 50% !important;
            left: 50% !important;
            transform: translate(-50%, -50%) rotate(-45deg) !important;
            font-size: 24px !important;
            font-weight: 900 !important;
            pointer-events: none !important;
            color: #000 !important;
            z-index: 1000 !important;
        }

/* Important text styles */
        .important-text {
            font-weight: 900 !important;
            font-size: 12px !important;
        }

.total-amount {
            font-weight: 900 !important;
            font-size: 14px !important;
            color: #000 !important;
        }

.item-name {
            font-weight: 900 !important;
            font-size: 11px !important;
        }

.header-title {
            font-weight: 900 !important;
            font-size: 18px !important;
        }

.amount-section {
            background: #f8f9fa !important;
            padding: 2px !important;
            border-radius: 2px !important;
            margin: 3px 0 !important;
        }

.kot-amount-section {
            background: #fff3f3 !important;
            padding: 2px !important;
            border-radius: 2px !important;
            margin: 3px 0 !important;
            border-left: 2px solid #dc3545 !important;
        }

/* 80mm column widths */
        .col-item {
            width: 45% !important;
        }
        
        .col-qty {
            width: 15% !important;
            text-align: center !important;
        }
        
        .col-price {
            width: 20% !important;
            text-align: right !important;
        }
        
        .col-total {
            width: 20% !important;
            text-align: right !important;
        }

.col-notes {
            width: 40% !important;
            text-align: left !important;
            font-size: 10px !important;
        }

/* Thermal printer optimization for print */
        @media print {
            @page {
                size: 80mm auto !important;
                margin: 0mm !important;
            }
            
            body {
                margin: 0 !important;
                padding: 2mm 2mm !important;
                width: 80mm !important;
                max-width: 80mm !important;
                background: white !important;
                font-weight: 900 !important;
            }
            
            .receipt-container, .kot-container {
                page-break-after: always !important;
                page-break-inside: avoid !important;
                width: 76mm !important;
                margin: 0 auto !important;
                padding: 1mm 2mm 3mm 2mm !important;
            }
            
            .btn-print, .print-status, .redirect-status, #manualControls {
                display: none !important;
            }
            
            /* Optimize for thermal printing */
            * {
                font-weight: 900 !important;
                -webkit-print-color-adjust: exact !important;
                print-color-adjust: exact !important;
                color: #000 !important;
                background: transparent !important;
            }
            
            /* Remove backgrounds to save ink */
            .amount-section, .kot-amount-section, .notes-section, .kot-notes {
                background: none !important;
            }
            
            .kot-badge {
                background-color: #dc3545 !important;
                color: white !important;
                -webkit-print-color-adjust: exact !important;
                print-color-adjust: exact !important;
            }
        }

/* Separate print jobs for KOT and Bill */
        <?php if ($print_type === 'both'): ?>
            .kot-container {
                page-break-after: always !important;
            }
            .receipt-container {
                page-break-after: always !important;
            }
        <?php endif; ?>

/* Hide unnecessary elements */
        #manualControls, .btn-print {
            display: none !important;
        }

/* Thermal bold enhancement */
        .thermal-bold {
            font-weight: 900 !important;
            -webkit-text-stroke: 0.3px black !important;
            text-stroke: 0.3px black !important;
        }

/* Fix decimal alignment */
        .decimal-fix {
            letter-spacing: -0.5px !important;
        }
    </style>
</head>
<body>
    <?php if (!empty($errors)): ?>
        <div class="alert alert-danger mb-3">
            <ul class="mb-0">
                <?php foreach ($errors as $error): ?>
                    <li><?php echo htmlspecialchars($error); ?></li>
                <?php endforeach; ?>
            </ul>
        </div>
        <a href="<?php echo $redirect_url; ?>" class="btn btn-primary">Back</a>
    <?php else: ?>
        
        <?php if ($print_kot): ?>
            <div class="kot-container">
                
                <?php if ($is_reprint): ?>
                    <div class="print-watermark">REPRINT</div>
                <?php endif; ?>
                
                <div class="kot-header">
                    <h2 class="header-title thermal-bold">KOT <span class="kot-badge">KITCHEN</span></h2>
                    <p class="thermal-bold"><?php echo htmlspecialchars($branch['branch_name']); ?></p>
                    <p class="important-text thermal-bold">Order #<?php echo htmlspecialchars($order_id); ?></p>
                    <p class="thermal-bold">Date: <?php echo date('d-m-Y H:i', strtotime($order['order_date'])); ?></p>
                    <?php if ($order['order_type'] === 'Dine In' && !empty($order['table_number'])): ?>
                        <p class="thermal-bold">Table: <?php echo htmlspecialchars($order['table_number']); ?></p>
                    <?php else: ?>
                        <p class="thermal-bold">Type: <?php echo htmlspecialchars($order['order_type']); ?></p>
                    <?php endif; ?>
                    <p class="thermal-bold">Customer: <?php echo htmlspecialchars($order['customer_name'] ?: 'Walk-in'); ?></p>
                    <?php if (!empty($order['notes'])): ?>
                        <p class="notes-section kot-notes thermal-bold">Special: <?php echo htmlspecialchars($order['notes']); ?></p>
                    <?php endif; ?>
                </div>
                <div class="kot-divider"></div>
                <table class="table kot-table">
                    <thead>
                        <tr>
                            <th class="col-item thermal-bold">Item</th>
                            <th class="col-qty thermal-bold">Qty</th>
                        </tr>
                    </thead>
                    <tbody>
                        <?php foreach ($order_items as $item): ?>
                            <tr>
                                <td class="item-name thermal-bold"><?php echo htmlspecialchars($item['food_name']); ?></td>
                                <td class="col-qty thermal-bold"><?php echo htmlspecialchars($item['quantity']); ?></td>
                            </tr>
                        <?php endforeach; ?>
                    </tbody>
                </table>
                <div class="kot-divider"></div>
                <div class="text-center">
                    <p class="important-text thermal-bold">Time: <?php echo date('H:i', strtotime($order['order_date'])); ?></p>
                    <?php if ($is_reprint): ?>
                        <p class="important-text thermal-bold">*** REPRINT ***</p>
                    <?php endif; ?>
                    <p class="important-text thermal-bold">KITCHEN COPY</p>
                </div>
            </div>
        <?php endif; ?>

<?php if ($print_bill): ?>
            
            <div class="receipt-container">
                
                <?php if ($is_reprint): ?>
                    <div class="print-watermark">REPRINT</div>
                <?php endif; ?>
                
                <div class="receipt-header">
                    <h2 class="header-title thermal-bold"><?php echo htmlspecialchars($branch['branch_name']); ?></h2>
                    <p class="thermal-bold"><?php echo htmlspecialchars($branch['address']); ?></p>
                    <p class="thermal-bold"><?php echo htmlspecialchars($branch['city'] . ', ' . $branch['state']); ?></p>
                    <div class="divider"></div>
                    <p class="important-text thermal-bold">Order #<?php echo htmlspecialchars($order_id); ?></p>
                    <p class="thermal-bold">Date: <?php echo date('d-m-Y H:i', strtotime($order['order_date'])); ?></p>
                    <p class="thermal-bold">Customer: <?php echo htmlspecialchars($order['customer_name'] ?: 'Walk-in'); ?></p>
                    <?php if (!empty($order['customer_contact'])): ?>
                        <p class="thermal-bold">Contact: <?php echo htmlspecialchars($order['customer_contact']); ?></p>
                    <?php endif; ?>
                    <p class="thermal-bold">Table: <?php echo htmlspecialchars($order['table_number'] ?: 'Takeaway'); ?></p>
                    <?php if (!empty($order['notes'])): ?>
                        <p class="notes-section thermal-bold">Notes: <?php echo htmlspecialchars($order['notes']); ?></p>
                    <?php endif; ?>
                </div>
                
                <div class="divider"></div>
                
                <table class="table">
                    <thead>
                        <tr>
                            <th class="col-item thermal-bold">Item</th>
                            <th class="col-qty thermal-bold">Qty</th>
                            <th class="col-price thermal-bold">Price</th>
                            <th class="col-total thermal-bold">Total</th>
                        </tr>
                    </thead>
                    <tbody>
                        <?php foreach ($order_items as $item): ?>
                            <tr>
                                <td class="item-name thermal-bold"><?php echo htmlspecialchars($item['food_name']); ?></td>
                                <td class="col-qty thermal-bold"><?php echo htmlspecialchars($item['quantity']); ?></td>
                                <td class="col-price decimal-fix thermal-bold">₹<?php echo number_format($item['price'], 2); ?></td>
                                <td class="col-total decimal-fix thermal-bold">₹<?php echo number_format($item['subtotal'], 2); ?></td>
                            </tr>
                        <?php endforeach; ?>
                    </tbody>
                </table>
                
                <div class="divider"></div>
                
                <table class="table">
                    <tbody>
                        <tr>
                            <td class="thermal-bold">Subtotal</td>
                            <td class="text-right decimal-fix thermal-bold">₹<?php echo number_format($subtotal, 2); ?></td>
                        </tr>
                        
                        <?php if ($coupon_discount > 0): ?>
                            <tr>
                                <td class="thermal-bold">Discount (<?php echo htmlspecialchars($order['coupon_code']); ?>)</td>
                                <td class="text-right decimal-fix thermal-bold">-₹<?php echo number_format($coupon_discount, 2); ?></td>
                            </tr>
                        <?php endif; ?>
                        
                        <?php if ($extra_charge > 0): ?>
                            <tr>
                                <td class="thermal-bold">Extra Charge</td>
                                <td class="text-right decimal-fix thermal-bold">₹<?php echo number_format($extra_charge, 2); ?></td>
                            </tr>
                        <?php endif; ?>
                        
                        <tr class="total-row">
                            <td class="thermal-bold">TOTAL</td>
                            <td class="text-right total-amount decimal-fix thermal-bold">₹<?php echo number_format($total_amount, 2); ?></td>
                        </tr>
                        
                        <?php if ($order['payment_method']): ?>
                            <tr>
                                <td class="thermal-bold">Payment</td>
                                <td class="text-right thermal-bold"><?php echo htmlspecialchars($order['payment_method']); ?></td>
                            </tr>
                        <?php endif; ?>
                    </tbody>
                </table>
                
                <div class="divider"></div>
                
                <div class="text-center">
                    <?php if ($is_reprint): ?>
                        <p class="important-text thermal-bold">*** REPRINTED ***</p>
                    <?php endif; ?>
                    <p class="important-text thermal-bold">Thank you! Visit again</p>
                </div>
            </div>
        <?php endif; ?>
    <?php endif; ?>

// Handle print completion and redirect
        window.onafterprint = function() {
            <?php if ($print_type === 'both'): ?>
                setTimeout(function() {
                    window.location.href = '<?php echo $redirect_url; ?>';
                }, 1000);
            <?php else: ?>
                window.location.href = '<?php echo $redirect_url; ?>';
            <?php endif; ?>
        };

// Alternative for browsers that don't support onafterprint
        if (window.matchMedia) {
            var mediaQueryList = window.matchMedia('print');
            mediaQueryList.addListener(function(mql) {
                if (!mql.matches) {
                    setTimeout(function() {
                        window.location.href = '<?php echo $redirect_url; ?>';
                    }, 1000);
                }
            });
        }
    </script>
</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: print_receipt.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation