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/seller

Free Space:

10.3 TB

🔧 Quick Actions

✏️ Editing: user_bill.php

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

$order_id = isset($_GET['order_id']) ? (int)$_GET['order_id'] : 0;

if (!$order_id) {
    die("Invalid order ID");
}

$errors = [];
$order = null;
$order_items = [];
$branch = [];
$cgst_rate = $sgst_rate = 0;

// Get order details
try {
    $stmt = $pdo->prepare("
        SELECT o.*, b.branch_name, b.address, b.city, b.state, b.country
        FROM orders o
        JOIN branches b ON o.branch_id = b.branch_id
        WHERE o.order_id = :order_id
    ");
    $stmt->execute(['order_id' => $order_id]);
    $order = $stmt->fetch(PDO::FETCH_ASSOC);
    
    if (!$order) {
        die("Order not found");
    }
} catch (PDOException $e) {
    die("Error fetching order details");
}

// Get order items
try {
    $stmt = $pdo->prepare("
        SELECT oi.food_id, oi.quantity, oi.price, oi.subtotal, f.food_name
        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";
}

// Get 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' => $order['branch_id'],
        'order_date' => $order['order_date']
    ]);
    $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) {
    // Use default tax rates
    $cgst_rate = 0;
    $sgst_rate = 0;
}

// Calculations
$subtotal = array_sum(array_column($order_items, 'subtotal'));
$cgst_amount = $subtotal * ($cgst_rate / 100);
$sgst_amount = $subtotal * ($sgst_rate / 100);
$total_amount = $subtotal + $cgst_amount + $sgst_amount;
?>
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Bill - Order #<?php echo $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">
    <script src="https://cdnjs.cloudflare.com/ajax/libs/html2canvas/1.4.1/html2canvas.min.js"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/jspdf/2.5.1/jspdf.umd.min.js"></script>
    <style>
        body {
            background: linear-gradient(135deg, #667eea 0%, #764ba2 100%);
            min-height: 100vh;
            padding: 20px 0;
        }
        .bill-container {
            background: white;
            border-radius: 15px;
            box-shadow: 0 10px 30px rgba(0,0,0,0.3);
            overflow: hidden;
            max-width: 800px;
            margin: 0 auto;
        }
        .bill-header {
            background: linear-gradient(45deg, #2c3e50, #34495e);
            color: white;
            padding: 30px;
            text-align: center;
        }
        .bill-body {
            padding: 30px;
        }
        .bill-item {
            border-bottom: 1px solid #eee;
            padding: 15px 0;
        }
        .bill-totals {
            background: #f8f9fa;
            border-radius: 10px;
            padding: 20px;
            margin-top: 20px;
        }
        .download-btn {
            background: linear-gradient(45deg, #25D366, #128C7E);
            border: none;
            border-radius: 25px;
            padding: 12px 30px;
            font-weight: 600;
            transition: all 0.3s ease;
        }
        .download-btn:hover {
            transform: translateY(-2px);
            box-shadow: 0 5px 15px rgba(37, 211, 102, 0.4);
        }
        .whatsapp-btn {
            background: linear-gradient(45deg, #25D366, #128C7E);
            border: none;
            border-radius: 25px;
            padding: 12px 30px;
            font-weight: 600;
            transition: all 0.3s ease;
        }
        .whatsapp-btn:hover {
            transform: translateY(-2px);
            box-shadow: 0 5px 15px rgba(37, 211, 102, 0.4);
        }
        .print-btn {
            background: linear-gradient(45deg, #667eea, #764ba2);
            border: none;
            border-radius: 25px;
            padding: 12px 30px;
            font-weight: 600;
            transition: all 0.3s ease;
        }
        .print-btn:hover {
            transform: translateY(-2px);
            box-shadow: 0 5px 15px rgba(102, 126, 234, 0.4);
        }
        .bill-footer {
            background: #2c3e50;
            color: white;
            padding: 20px;
            text-align: center;
            margin-top: 30px;
        }
        .qr-code {
            max-width: 150px;
            margin: 20px auto;
        }
    </style>
</head>
<body>
    <div class="bill-container" id="billContent">
        
        <div class="bill-header">
            <h1 class="display-5 fw-bold"><?php echo htmlspecialchars($order['branch_name']); ?></h1>
            <p class="lead mb-1"><?php echo htmlspecialchars($order['address']); ?></p>
            <p class="mb-0"><?php echo htmlspecialchars($order['city'] . ', ' . $order['state'] . ', ' . $order['country']); ?></p>
        </div>

<div class="bill-body">
            
            <div class="row mb-4">
                <div class="col-md-6">
                    <h5 class="fw-bold text-primary">Order Information</h5>
                    <p class="mb-1"><strong>Order ID:</strong> #<?php echo $order_id; ?></p>
                    <p class="mb-1"><strong>Date:</strong> <?php echo date('d M Y, h:i A', strtotime($order['order_date'])); ?></p>
                    <p class="mb-1"><strong>Customer:</strong> <?php echo htmlspecialchars($order['customer_name'] ?: 'Walk-in Customer'); ?></p>
                    <p class="mb-0"><strong>Contact:</strong> <?php echo htmlspecialchars($order['customer_contact']); ?></p>
                </div>
                <div class="col-md-6">
                    <h5 class="fw-bold text-primary">Payment Details</h5>
                    <p class="mb-1"><strong>Status:</strong> 
                        <span class="badge bg-<?php 
                            switch($order['status']) {
                                case 'completed': echo 'success'; break;
                                case 'processing': echo 'warning'; break;
                                case 'pending': echo 'secondary'; break;
                                case 'cancelled': echo 'danger'; break;
                                default: echo 'secondary';
                            }
                        ?>"><?php echo ucfirst($order['status']); ?></span>
                    </p>
                    <p class="mb-1"><strong>Payment Method:</strong> <?php echo $order['payment_method'] ?: 'Not Specified'; ?></p>
                    <p class="mb-0"><strong>GST:</strong> 
                        <span class="badge <?php echo $order['is_gst_active'] === '1' ? 'bg-success' : 'bg-secondary'; ?>">
                            <?php echo $order['is_gst_active'] === '1' ? 'GST Applied' : 'No GST'; ?>
                        </span>
                    </p>
                </div>
            </div>

<h5 class="fw-bold text-primary mb-3">Order Items</h5>
            <div class="table-responsive">
                <table class="table table-striped">
                    <thead class="table-dark">
                        <tr>
                            <th>Item</th>
                            <th class="text-center">Qty</th>
                            <th class="text-end">Price</th>
                            <th class="text-end">Subtotal</th>
                        </tr>
                    </thead>
                    <tbody>
                        <?php foreach ($order_items as $item): ?>
                        <tr>
                            <td><?php echo htmlspecialchars($item['food_name']); ?></td>
                            <td class="text-center"><?php echo $item['quantity']; ?></td>
                            <td class="text-end">₹<?php echo number_format($item['price'], 2); ?></td>
                            <td class="text-end">₹<?php echo number_format($item['subtotal'], 2); ?></td>
                        </tr>
                        <?php endforeach; ?>
                    </tbody>
                </table>
            </div>

<div class="bill-totals">
                <div class="row">
                    <div class="col-md-6 offset-md-6">
                        <div class="d-flex justify-content-between mb-2">
                            <span>Subtotal:</span>
                            <strong>₹<?php echo number_format($subtotal, 2); ?></strong>
                        </div>
                        <?php if ($order['is_gst_active'] === '1'): ?>
                        <div class="d-flex justify-content-between mb-2">
                            <span>CGST (<?php echo number_format($cgst_rate, 2); ?>%):</span>
                            <strong>₹<?php echo number_format($cgst_amount, 2); ?></strong>
                        </div>
                        <div class="d-flex justify-content-between mb-2">
                            <span>SGST (<?php echo number_format($sgst_rate, 2); ?>%):</span>
                            <strong>₹<?php echo number_format($sgst_amount, 2); ?></strong>
                        </div>
                        <?php endif; ?>
                        <div class="d-flex justify-content-between mb-2 total-amount">
                            <span class="fw-bold">Total Amount:</span>
                            <strong class="text-success">₹<?php echo number_format($total_amount, 2); ?></strong>
                        </div>
                    </div>
                </div>
            </div>

<?php if (!empty($order['notes'])): ?>
            <div class="alert alert-info mt-3">
                <strong>Notes:</strong> <?php echo htmlspecialchars($order['notes']); ?>
            </div>
            <?php endif; ?>
        </div>

<div class="bill-footer">
            <p class="mb-2">Thank you for your business!</p>
            <p class="mb-0">For queries, contact: <?php echo htmlspecialchars($order['branch_name']); ?></p>
        </div>
    </div>

<div class="text-center mt-4">
        <button onclick="downloadAsPDF()" class="btn download-btn text-white me-3">
            <i class="fas fa-download me-2"></i>Download PDF
        </button>
        <button onclick="shareOnWhatsApp()" class="btn whatsapp-btn text-white me-3">
            <i class="fab fa-whatsapp me-2"></i>Share via WhatsApp
        </button>
        <button onclick="window.print()" class="btn print-btn text-white">
            <i class="fas fa-print me-2"></i>Print Bill
        </button>
    </div>

pdf.addImage(imgData, 'PNG', 0, position, imgWidth, imgHeight);
                heightLeft -= pageHeight;

while (heightLeft >= 0) {
                    position = heightLeft - imgHeight;
                    pdf.addPage();
                    pdf.addImage(imgData, 'PNG', 0, position, imgWidth, imgHeight);
                    heightLeft -= pageHeight;
                }

pdf.save('Bill_Order_<?php echo $order_id; ?>.pdf');
            });
        }

function shareOnWhatsApp() {
            const currentUrl = window.location.href;
            const message = "Check out my bill from <?php echo htmlspecialchars($order['branch_name']); ?>:\n" + currentUrl;
            const whatsappUrl = "https://wa.me/?text=" + encodeURIComponent(message);
            window.open(whatsappUrl, '_blank');
        }

// Auto-hide buttons when printing
        window.addEventListener('beforeprint', function() {
            document.querySelector('.text-center.mt-4').style.display = 'none';
        });

window.addEventListener('afterprint', function() {
            document.querySelector('.text-center.mt-4').style.display = 'block';
        });
    </script>
</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: user_bill.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation