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/rutzotech.com/public_html/bill

Free Space:

10.24 TB

🔧 Quick Actions

✏️ Editing: print_bill.php

<?php
session_start();
require_once 'db_connection.php';

$bill_id = isset($_GET['bill_id']) ? intval($_GET['bill_id']) : 0;

if ($bill_id > 0) {
    // Fetch bill details
    $bill_query = $conn->prepare("
        SELECT b.*, u.name as salesperson_name, s.shop_name, s.address as shop_address, s.phone as shop_phone, s.gst_number
        FROM bills b
        LEFT JOIN users u ON b.user_id = u.id
        LEFT JOIN shops s ON b.shop_id = s.id
        WHERE b.id = ?
    ");
    $bill_query->bind_param("i", $bill_id);
    $bill_query->execute();
    $bill = $bill_query->get_result()->fetch_assoc();
    $bill_query->close();

// Fetch bill items
    $items_query = $conn->prepare("
        SELECT bi.*, p.product_name, p.barcode, p.sku
        FROM bill_items bi
        JOIN products p ON bi.product_id = p.id
        WHERE bi.bill_id = ?
    ");
    $items_query->bind_param("i", $bill_id);
    $items_query->execute();
    $items = $items_query->get_result()->fetch_all(MYSQLI_ASSOC);
    $items_query->close();
} else {
    die("Invalid bill ID");
}
?>
<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Bill <?php echo $bill['bill_no']; ?></title>
    <style>
        @media print {
            @page {
                size: 80mm 100mm;
                margin: 0;
            }

body {
                margin: 0;
                padding: 10px;
                font-size: 12px;
                font-family: 'Courier New', monospace;
            }

.no-print {
                display: none !important;
            }
        }

body {
            font-family: 'Courier New', monospace;
            font-size: 12px;
            width: 80mm;
            margin: 0 auto;
            padding: 10px;
        }

.header {
            text-align: center;
            border-bottom: 1px dashed #000;
            padding-bottom: 10px;
            margin-bottom: 10px;
        }

.shop-name {
            font-weight: bold;
            font-size: 14px;
        }

.bill-info {
            margin: 10px 0;
            border-bottom: 1px dashed #000;
            padding-bottom: 10px;
        }

.bill-row {
            display: flex;
            justify-content: space-between;
            margin: 3px 0;
        }

.items-table {
            width: 100%;
            border-collapse: collapse;
            margin: 10px 0;
        }

.items-table th {
            border-bottom: 1px dashed #000;
            padding: 5px 0;
            text-align: left;
        }

.items-table td {
            padding: 3px 0;
            border-bottom: 1px dashed #ccc;
        }

.total-section {
            border-top: 2px solid #000;
            margin-top: 10px;
            padding-top: 10px;
        }

.footer {
            text-align: center;
            margin-top: 20px;
            font-size: 10px;
            border-top: 1px dashed #000;
            padding-top: 10px;
        }

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

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

.print-btn {
            text-align: center;
            margin: 20px 0;
        }

button {
            padding: 10px 20px;
            background: #27ae60;
            color: white;
            border: none;
            border-radius: 4px;
            cursor: pointer;
        }

button:hover {
            background: #219653;
        }
    </style>
</head>

<body>
    <div class="header">
        <div class="shop-name"><?php echo htmlspecialchars($bill['shop_name']); ?></div>
        <div><?php echo htmlspecialchars($bill['shop_address']); ?></div>
        <div>Phone: <?php echo htmlspecialchars($bill['shop_phone']); ?></div>
        <div>GST: <?php echo htmlspecialchars($bill['gst_number']); ?></div>
    </div>

<div class="bill-info">
        <div class="bill-row">
            <span>Bill No:</span>
            <span><?php echo htmlspecialchars($bill['bill_no']); ?></span>
        </div>
        <div class="bill-row">
            <span>Date:</span>
            <span><?php echo date('d/m/Y h:i A', strtotime($bill['created_at'])); ?></span>
        </div>
        <div class="bill-row">
            <span>Salesperson:</span>
            <span><?php echo htmlspecialchars($bill['salesperson_name']); ?></span>
        </div>
        <?php if ($bill['customer_name']): ?>
            <div class="bill-row">
                <span>Customer:</span>
                <span><?php echo htmlspecialchars($bill['customer_name']); ?></span>
            </div>
        <?php endif; ?>
        <?php if ($bill['customer_mobile']): ?>
            <div class="bill-row">
                <span>Mobile:</span>
                <span><?php echo htmlspecialchars($bill['customer_mobile']); ?></span>
            </div>
        <?php endif; ?>
    </div>

<table class="items-table">
        <thead>
            <tr>
                <th>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 ($items as $item): ?>
                <tr>
                    <td><?php echo htmlspecialchars($item['product_name']); ?></td>
                    <td class="text-right"><?php echo $item['quantity']; ?></td>
                    <td class="text-right">₹<?php echo number_format($item['price'], 2); ?></td>
                    <td class="text-right">₹<?php echo number_format($item['total'], 2); ?></td>
                </tr>
            <?php endforeach; ?>
        </tbody>
    </table>

<div class="total-section">
        <div class="bill-row">
            <span>Subtotal:</span>
            <span>₹<?php echo number_format($bill['subtotal'], 2); ?></span>
        </div>
        <?php if ($bill['discount_amount'] > 0): ?>
            <div class="bill-row">
                <span>Discount:</span>
                <span>-₹<?php echo number_format($bill['discount_amount'], 2); ?></span>
            </div>
        <?php endif; ?>
        <?php if ($bill['gst_amount'] > 0): ?>
            <div class="bill-row">
                <span>GST (<?php echo ($bill['tax_percent'] ?? 0); ?>%):</span>
                <span>₹<?php echo number_format($bill['gst_amount'], 2); ?></span>
            </div>
        <?php endif; ?>
        <div class="bill-row" style="font-weight: bold;">
            <span>Total:</span>
            <span>₹<?php echo number_format($bill['total_amount'], 2); ?></span>
        </div>
        <div class="bill-row">
            <span>Payment Mode:</span>
            <span style="text-transform: uppercase;"><?php echo htmlspecialchars($bill['payment_mode']); ?></span>
        </div>
    </div>

<div class="footer">
        <div>Thank you for your purchase!</div>
        <div>Please visit again</div>
        <div>Software by DK BILLING</div>
    </div>

<div class="print-btn no-print">
        <button onclick="window.print()">Print Bill</button>
        <button onclick="window.close()" style="background: #e74c3c; margin-left: 10px;">Close</button>
    </div>

</html>
<?php
$conn->close();
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: print_bill.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation