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

Free Space:

10.28 TB

🔧 Quick Actions

✏️ Editing: print-invoice.php

<?php
// print-invoice.php
session_start();
require_once 'includes/db.php';

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

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

// Get order details
$order_sql = "SELECT b.*, c.name as customer_name, c.address 
              FROM bills b 
              LEFT JOIN customers c ON b.customer_id = c.id 
              WHERE b.id = ?";
$order_stmt = mysqli_prepare($conn, $order_sql);
mysqli_stmt_bind_param($order_stmt, "i", $order_id);
mysqli_stmt_execute($order_stmt);
$order_result = mysqli_stmt_get_result($order_stmt);
$order = mysqli_fetch_assoc($order_result);

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

// Get order products
$products_sql = "SELECT bp.*, p.name as product_name, p.unit, p.quantity_unit 
                 FROM bill_products bp 
                 JOIN products p ON bp.product_id = p.id 
                 WHERE bp.bill_id = ? 
                 ORDER BY bp.id";
$products_stmt = mysqli_prepare($conn, $products_sql);
mysqli_stmt_bind_param($products_stmt, "i", $order_id);
mysqli_stmt_execute($products_stmt);
$products_result = mysqli_stmt_get_result($products_stmt);

// Your company details
$company_name = "Venus Digital Printers";
$company_address = "Paparapatti, Palacode to Pennagaram Main Road";
$company_location = "Subramaiya Siva Mandabam Opposite";
$company_email = "veenusppt@gmail.com";
$company_phone = "+91 98421 69814";

// Get referrer URL for fallback
$referrer = $_SERVER['HTTP_REFERER'] ?? 'new-bill.php';
?>
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Invoice #<?php echo $order['id']; ?> - Venus Digital Printers</title>
    <style>
        @media print {
            @page {
                size: A4;
                margin: 0;
            }
            body {
                margin: 0;
                padding: 0;
                -webkit-print-color-adjust: exact;
                print-color-adjust: exact;
            }
            .invoice-page {
                height: 297mm;
                page-break-inside: avoid;
            }
            .no-print {
                display: none !important;
            }
        }
        
        * {
            margin: 0;
            padding: 0;
            box-sizing: border-box;
        }
        
        body {
            font-family: 'Arial', sans-serif;
            font-size: 12px;
            line-height: 1.4;
            background: #f8f9fa;
            margin: 0;
            padding: 0;
        }
        
        .invoice-page {
            width: 210mm;
            height: 297mm;
            background: white;
            position: relative;
            margin: 0 auto;
            overflow: hidden;
        }
        
        .bill-section {
            width: 105mm;
            height: 297mm;
            padding: 10mm;
            float: left;
            border-right: 2px dashed #ccc;
        }
        
        .right-section {
            width: 105mm;
            height: 297mm;
            float: left;
            /* Empty right side */
        }
        
        .header {
            text-align: center;
            border-bottom: 2px solid #333;
            padding-bottom: 8px;
            margin-bottom: 12px;
        }
        
        .company-name {
            font-size: 18px;
            font-weight: bold;
            color: #2c3e50;
            margin-bottom: 4px;
        }
        
        .company-details {
            font-size: 10px;
            color: #666;
            line-height: 1.4;
        }
        
        .invoice-title {
            text-align: center;
            font-size: 16px;
            font-weight: bold;
            margin: 12px 0;
            color: #2c3e50;
            text-transform: uppercase;
        }
        
        .invoice-details {
            display: flex;
            justify-content: space-between;
            margin-bottom: 12px;
            font-size: 10px;
        }
        
        .customer-info, .invoice-info {
            flex: 1;
        }
        
        .info-label {
            font-weight: bold;
            color: #333;
            min-width: 70px;
            display: inline-block;
        }
        
        .products-table {
            width: 100%;
            border-collapse: collapse;
            margin: 12px 0;
            font-size: 9px;
        }
        
        .products-table th {
            background: #f8f9fa;
            border: 1px solid #ddd;
            padding: 5px 3px;
            text-align: left;
            font-weight: bold;
        }
        
        .products-table td {
            border: 1px solid #ddd;
            padding: 4px 3px;
            vertical-align: top;
        }
        
        .amount-section {
            margin-top: 15px;
            font-size: 10px;
            width: 60%;
            margin-left: auto;
        }
        
        .amount-row {
            display: flex;
            justify-content: space-between;
            margin-bottom: 3px;
            padding: 2px 0;
        }
        
        .total-row {
            border-top: 2px solid #333;
            padding-top: 4px;
            font-weight: bold;
            font-size: 11px;
            margin-top: 4px;
        }
        
        .action-buttons {
            position: fixed;
            top: 20px;
            right: 20px;
            z-index: 1000;
            display: flex;
            gap: 10px;
        }
        
        .action-btn {
            padding: 10px 15px;
            background: #007bff;
            color: white;
            border: none;
            border-radius: 5px;
            cursor: pointer;
            text-decoration: none;
            display: inline-flex;
            align-items: center;
            gap: 5px;
            font-size: 14px;
        }
        
        .action-btn:hover {
            background: #0056b3;
        }
        
        .action-btn.back {
            background: #6c757d;
        }
        
        .action-btn.back:hover {
            background: #545b62;
        }
        
        .status-badge {
            display: inline-block;
            padding: 2px 6px;
            border-radius: 3px;
            font-size: 9px;
            font-weight: bold;
        }
        
        .status-paid { background: #d4edda; color: #155724; }
        .status-pending { background: #fff3cd; color: #856404; }
        .status-overdue { background: #f8d7da; color: #721c24; }
        .status-cancelled { background: #e2e3e5; color: #383d41; }
        
        .payment-instructions {
            background: #f8f9fa;
            border: 1px solid #ddd;
            padding: 8px;
            margin: 10px 0;
            border-radius: 3px;
            font-size: 9px;
        }
        
        .notes-section {
            margin: 10px 0;
            padding: 8px;
            background: #fff3cd;
            border: 1px solid #ffeaa7;
            border-radius: 3px;
            font-size: 9px;
        }
        
        .thank-you {
            text-align: center;
            margin-top: 15px;
            padding: 8px;
            background: #e8f5e8;
            border: 1px solid #c3e6c3;
            border-radius: 3px;
            font-size: 10px;
            font-weight: bold;
        }
        
        .footer {
            position: absolute;
            bottom: 10mm;
            left: 10mm;
            right: 10mm;
            text-align: center;
            font-size: 9px;
            color: #666;
            border-top: 1px solid #ddd;
            padding-top: 5px;
        }
        
        .print-message {
            position: fixed;
            top: 80px;
            right: 20px;
            background: #fff3cd;
            border: 1px solid #ffeaa7;
            padding: 10px;
            border-radius: 5px;
            font-size: 12px;
            z-index: 999;
            max-width: 250px;
        }
        
        .auto-close-notice {
            position: fixed;
            bottom: 20px;
            left: 50%;
            transform: translateX(-50%);
            background: #d4edda;
            border: 1px solid #c3e6c3;
            padding: 10px 20px;
            border-radius: 5px;
            font-size: 12px;
            z-index: 999;
        }
    </style>
</head>
<body>
    
    <div class="action-buttons no-print">
        <button class="action-btn" onclick="window.print()">
            <i class="fas fa-print"></i> Print Invoice
        </button>
        <a href="<?php echo htmlspecialchars($referrer); ?>" class="action-btn back">
            <i class="fas fa-arrow-left"></i> Back
        </a>
    </div>

<div class="print-message no-print">
        <strong>Printing Instructions:</strong><br>
        • Invoice will auto-print<br>
        • Use A4 paper<br>
        • Page will auto-close after printing<br>
        • Or click Back to return now
    </div>

<div class="auto-close-notice no-print">
        <i class="fas fa-info-circle"></i> This page will automatically close after printing
    </div>

<div class="invoice-page">
        
        <div class="bill-section">
            
            <div class="header">
                <div class="company-name"><?php echo $company_name; ?></div>
                <div class="company-details">
                    <?php echo $company_address; ?><br>
                    <?php echo $company_location; ?><br>
                    <?php echo $company_email; ?> | <?php echo $company_phone; ?>
                </div>
            </div>
            
            
            <div class="invoice-title">TAX INVOICE</div>
            
            
            <div class="invoice-details">
                <div class="customer-info">
                    <div><span class="info-label">Customer:</span> <?php echo htmlspecialchars($order['customer_name']); ?></div>
                    <div><span class="info-label">Phone:</span> <?php echo htmlspecialchars($order['customer_phone']); ?></div>
                    <?php if (!empty($order['address'])): ?>
                    <div><span class="info-label">Address:</span> <?php echo htmlspecialchars($order['address']); ?></div>
                    <?php endif; ?>
                </div>
                <div class="invoice-info">
                    <div><span class="info-label">Invoice No:</span> #<?php echo $order['id']; ?></div>
                    <div><span class="info-label">Date:</span> <?php echo date('d/m/Y', strtotime($order['bill_date'])); ?></div>
                    <div><span class="info-label">Due Date:</span> <?php echo date('d/m/Y', strtotime($order['due_date'])); ?></div>
                    <div>
                        <span class="info-label">Status:</span> 
                        <span class="status-badge status-<?php echo $order['status']; ?>">
                            <?php echo strtoupper($order['status']); ?>
                        </span>
                    </div>
                </div>
            </div>
            
            
            <div class="payment-instructions">
                <strong>Payment Instructions:</strong><br>
                • Please make payment by due date<br>
                • Cash/UPI/Bank Transfer accepted<br>
                • Contact: <?php echo $company_phone; ?>
            </div>
            
            
            <table class="products-table">
                <thead>
                    <tr>
                        <th width="5%">#</th>
                        <th width="30%">Product Description</th>
                        <th width="12%">Dimensions</th>
                        <th width="8%">Qty</th>
                        <th width="10%">Area</th>
                        <th width="15%">Unit Price</th>
                        <th width="15%">Amount</th>
                    </tr>
                </thead>
                <tbody>
                    <?php if (mysqli_num_rows($products_result) > 0): ?>
                        <?php 
                        $counter = 1;
                        $total_items = 0;
                        ?>
                        <?php while ($product = mysqli_fetch_assoc($products_result)): ?>
                            <?php
                            $show_dimensions = ($product['unit'] === 'sqft' || $product['unit'] === 'ft');
                            $size_text = $show_dimensions ? $product['height'].'×'.$product['width'].' ft' : '-';
                            $total_items += $product['quantity'];
                            ?>
                            <tr>
                                <td style="text-align: center;"><?php echo $counter++; ?></td>
                                <td><?php echo htmlspecialchars($product['product_name']); ?>
                                    <?php if (!empty($product['notes'])): ?>
                                        <br><small style="color: #666;"><?php echo htmlspecialchars($product['notes']); ?></small>
                                    <?php endif; ?>
                                </td>
                                <td style="text-align: center;"><?php echo $size_text; ?></td>
                                <td style="text-align: center;"><?php echo $product['quantity']; ?></td>
                                <td style="text-align: right;"><?php echo $product['area']; ?> <?php echo $product['unit']; ?></td>
                                <td style="text-align: right;">₹<?php echo $product['unit_price']; ?></td>
                                <td style="text-align: right;">₹<?php echo $product['total_amount']; ?></td>
                            </tr>
                        <?php endwhile; ?>
                        <tr>
                            <td colspan="3" style="text-align: right; font-weight: bold;">Total Items:</td>
                            <td style="text-align: center; font-weight: bold;"><?php echo $total_items; ?></td>
                            <td colspan="3"></td>
                        </tr>
                    <?php else: ?>
                        <tr>
                            <td colspan="7" style="text-align: center; padding: 15px;">No products found</td>
                        </tr>
                    <?php endif; ?>
                </tbody>
            </table>
            
            
            <div class="amount-section">
                <div class="amount-row">
                    <span>Subtotal:</span>
                    <span>₹<?php echo $order['subtotal']; ?></span>
                </div>
                <?php if ($order['discount'] > 0): ?>
                <div class="amount-row">
                    <span>Discount:</span>
                    <span>-₹<?php echo $order['discount']; ?></span>
                </div>
                <?php endif; ?>
                <div class="amount-row total-row">
                    <span>Total Amount:</span>
                    <span>₹<?php echo $order['total_amount']; ?></span>
                </div>
            </div>

<div class="thank-you">
                Thank you for your business!
            </div>

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

</div>
        
        
        <div class="right-section">
            
        </div>
    </div>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: print-invoice.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation