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/spmodern.in/public_html/admin

Free Space:

10.3 TB

🔧 Quick Actions

✏️ Editing: order-invoice.php

<?php
// ---------- server bootstrap ----------
include('includes/head.php');
include('includes/db.php');
if (session_status() === PHP_SESSION_NONE) session_start();

// Check if order ID is provided
if (!isset($_GET['id']) || empty($_GET['id'])) {
    die('Order ID not provided');
}

$order_id = (int)$_GET['id'];

// Fetch order details
$orderSql = "SELECT * FROM orders WHERE id = ?";
$stmt = mysqli_prepare($conn, $orderSql);
mysqli_stmt_bind_param($stmt, 'i', $order_id);
mysqli_stmt_execute($stmt);
$orderResult = mysqli_stmt_get_result($stmt);
$order = mysqli_fetch_assoc($orderResult);
mysqli_stmt_close($stmt);

if (!$order) {
    die('Order not found');
}

// Fetch order items
$itemsSql = "SELECT * FROM order_items WHERE order_id = ?";
$stmt = mysqli_prepare($conn, $itemsSql);
mysqli_stmt_bind_param($stmt, 'i', $order_id);
mysqli_stmt_execute($stmt);
$itemsResult = mysqli_stmt_get_result($stmt);
$orderItems = [];
while ($item = mysqli_fetch_assoc($itemsResult)) {
    $orderItems[] = $item;
}
mysqli_stmt_close($stmt);

// Calculate totals
$subtotal = 0;
foreach ($orderItems as $item) {
    $subtotal += $item['total_price'];
}

$tax_amount = $order['tax_amount'] ?? 0;
$shipping_cost = $order['shipping_cost'] ?? 0;
$total_amount = $order['total_amount'];

/* Product name styling */
        .product-name {
            font-weight: bold;
            font-size: 11px;
        }

/* Amount highlighting */
        .amount {
            font-weight: bold;
            font-size: 12px;
        }

/* Grand total special styling */
        .grand-total {
            font-weight: bold;
            font-size: 14px;
            background: #000;
            color: white;
            padding: 2mm;
            text-align: center;
        }
    </style>
</head>
<body>
    
    <button class="print-btn no-print" onclick="window.print()">
        🖨️ Print Invoice
    </button>

<div class="invoice">
        
        <div class="header text-center">
            <div class="company-name">SP MODERN MAJESTY</div>
            <div class="company-address">
                ADURU VILLAGE, BIDARAHALLI MAIN ROAD<br>
                BENGALURU, KARNATAKA<br>
                +91 6381 606 793
            </div>
            
            <div class="invoice-title">TAX INVOICE</div>
            
            <div class="order-info">
                <table width="100%">
                    <tr>
                        <td class="text-left"><strong>ORDER ID:</strong></td>
                        <td class="text-right">#<?php echo h($order['order_id']); ?></td>
                    </tr>
                    <tr>
                        <td class="text-left"><strong>DATE:</strong></td>
                        <td class="text-right"><?php echo formatDate($order['created_at']); ?></td>
                    </tr>

</table>
            </div>
        </div>

<div class="customer-info">
            <div class="text-bold">CUSTOMER DETAILS:</div>
            <div class="text-strong"><?php echo h($order['customer_name']); ?></div>
            <div>PH: <?php echo h($order['customer_phone']); ?></div>
            <div class="text-bold mt-1">SHIPPING ADDRESS:</div>
            <div><?php echo h($order['shipping_address']); ?></div>
            <?php if (!empty($order['landmark'])): ?>
                <div>LANDMARK: <?php echo h($order['landmark']); ?></div>
            <?php endif; ?>
            <div><?php echo h($order['city']); ?>, <?php echo h($order['state']); ?> - <?php echo h($order['zip_code']); ?></div>
        </div>

<table class="items-table">
            <thead>
                <tr>
                    <th class="text-left">ITEM</th>
                    <th class="text-right">QTY</th>
                    <th class="text-right">PRICE</th>
                    <th class="text-right">TOTAL</th>
                </tr>
            </thead>
            <tbody>
                <?php foreach ($orderItems as $item): ?>
                <tr>
                    <td class="text-left">
                        <div class="product-name"><?php echo h($item['product_name']); ?></div>
                        <?php if (!empty($item['product_id'])): ?>
                            <div style="font-size: 9px;">SKU: <?php echo h($item['product_id']); ?></div>
                        <?php endif; ?>
                    </td>
                    <td class="text-right"><?php echo h($item['quantity']); ?></td>
                    <td class="text-right amount">₹<?php echo number_format($item['unit_price'], 2); ?></td>
                    <td class="text-right amount">₹<?php echo number_format($item['total_price'], 2); ?></td>
                </tr>
                <?php endforeach; ?>
            </tbody>
        </table>

<table class="summary-table">
            <tr>
                <td class="text-left">SUBTOTAL:</td>
                <td class="text-right amount">₹<?php echo number_format($subtotal, 2); ?></td>
            </tr>
            <?php if ($tax_amount > 0): ?>
            <tr>
                <td class="text-left">TAX (GST):</td>
                <td class="text-right amount">₹<?php echo number_format($tax_amount, 2); ?></td>
            </tr>
            <?php endif; ?>
            <?php if ($shipping_cost > 0): ?>
            <tr>
                <td class="text-left">SHIPPING:</td>
                <td class="text-right amount">₹<?php echo number_format($shipping_cost, 2); ?></td>
            </tr>
            <?php else: ?>
            <tr>
                <td class="text-left">SHIPPING:</td>
                <td class="text-right">FREE</td>
            </tr>
            <?php endif; ?>
            <tr class="total-row">
                <td class="text-left">GRAND TOTAL:</td>
                <td class="text-right amount">₹<?php echo number_format($total_amount, 2); ?></td>
            </tr>
            <tr>
                <td class="text-left">PAYMENT METHOD:</td>
                <td class="text-right text-uppercase text-bold"><?php echo h($order['payment_method']); ?></td>
            </tr>
        </table>

<div class="text-center">
            <div class="thank-you">THANK YOU FOR YOUR BUSINESS!</div>
            
            <div class="barcode-area">
                || <?php echo h($order['order_id']); ?> ||
            </div>
            
            <div class="terms">
                <strong>TERMS & CONDITIONS:</strong><br>
                • GOODS ONCE SOLD WILL NOT BE TAKEN BACK<br>
                • SUBJECT TO BENGALURU JURISDICTION<br>
                • E. & O.E.<br>
                • THIS IS A COMPUTER GENERATED INVOICE
            </div>
            
            <div class="mt-2">
                <strong>SP MODERN MAJESTY</strong><br>
                +91 6381 606 793
            </div>
        </div>
    </div>

// Manual print button handler
    document.querySelector('.print-btn').addEventListener('click', function() {
        window.print();
    });
    </script>
</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: order-invoice.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation