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

Free Space:

10.26 TB

🔧 Quick Actions

✏️ Editing: inv-modern.php

<?php
// inv-fixed-header-footer.php
// Database integrated invoice with fixed header/footer design
require_once('pdf/fpdf.php');

require_once('includes/db.php');
// Turn off mysqli exceptions so missing tables won't fatal
if (function_exists('mysqli_report')) mysqli_report(MYSQLI_REPORT_OFF);

// ---------- Helpers ----------
function esc($v){ return htmlspecialchars($v ?? '', ENT_QUOTES, 'UTF-8'); }
function money($v){ return '₹' . number_format((float)$v, 2); }
function fmtNum($n){ $n = (float)$n; return ($n == floor($n)) ? number_format($n, 0) : number_format($n, 2); }
function numberToWords($num){
    $ones=[0=>"Zero",1=>"One",2=>"Two",3=>"Three",4=>"Four",5=>"Five",6=>"Six",7=>"Seven",8=>"Eight",9=>"Nine",
           10=>"Ten",11=>"Eleven",12=>"Twelve",13=>"Thirteen",14=>"Fourteen",15=>"Fifteen",16=>"Sixteen",
           17=>"Seventeen",18=>"Eighteen",19=>"Nineteen"];
    $tens=[2=>"Twenty",3=>"Thirty",4=>"Forty",5=>"Fifty",6=>"Sixty",7=>"Seventy",8=>"Eighty",9=>"Ninety"];
    $num = round((float)$num,2);
    if ($num == 0) return "Zero Rupees";
    $whole = (int)floor($num);
    $fraction = (int)round(($num - $whole) * 100);
    $parts = [];
    if ($whole >= 10000000) { $c=(int)floor($whole/10000000); $parts[] = numberToWords($c)." Crore"; $whole %= 10000000; }
    if ($whole >= 100000)   { $l=(int)floor($whole/100000); $parts[] = numberToWords($l)." Lakh"; $whole %= 100000; }
    if ($whole >= 1000)     { $t=(int)floor($whole/1000); $parts[] = numberToWords($t)." Thousand"; $whole %= 1000; }
    if ($whole >= 100)      { $h=(int)floor($whole/100); $parts[] = ($ones[$h] ?? '')." Hundred"; $whole %= 100; }
    if ($whole > 0) {
        if ($whole < 20) $parts[] = $ones[$whole];
        else { $tt=(int)floor($whole/10); $r=$whole%10; $parts[] = ($tens[$tt] ?? '') . ($r ? " " . ($ones[$r] ?? '') : ''); }
    }
    $res = trim(implode(' ', array_filter($parts)));
    if ($res !== '') $res .= " Rupees";
    if ($fraction > 0) $res .= " and " . numberToWords($fraction) . " Paise";
    return $res;
}

// ---------- Input validation ----------
if (!isset($_GET['invoice_id']) || !is_numeric($_GET['invoice_id'])) {
    http_response_code(400);
    die("Invoice ID is required.");
}
$invoice_id = (int) $_GET['invoice_id'];
$auto_print = isset($_GET['auto']) && $_GET['auto'] == '1';

// ---------- Fetch invoice ----------
$invoice = null;
$sql = "SELECT i.*, c.name AS customer_name, c.phone AS customer_phone
        FROM invoices i
        LEFT JOIN customers c ON i.customer_id = c.id
        WHERE i.id = ?";
if ($stmt = mysqli_prepare($conn, $sql)) {
    mysqli_stmt_bind_param($stmt, "i", $invoice_id);
    mysqli_stmt_execute($stmt);
    $res = mysqli_stmt_get_result($stmt);
    $invoice = mysqli_fetch_assoc($res) ?: null;
    mysqli_stmt_close($stmt);
}
if (!$invoice) {
    http_response_code(404);
    die("Invoice not found.");
}

// ---------- Get Business Address from GST Details ----------
$business_address = '';
$gst_number = '';
if (!empty($invoice['business_id'])) {
    $sql_business = "SELECT business_address, gst_num FROM gst_details WHERE id = ?";
    if ($stmt = mysqli_prepare($conn, $sql_business)) {
        mysqli_stmt_bind_param($stmt, "i", $invoice['business_id']);
        mysqli_stmt_execute($stmt);
        $res_business = mysqli_stmt_get_result($stmt);
        if ($business_row = mysqli_fetch_assoc($res_business)) {
            $business_address = $business_row['business_address'] ?? '';
            $gst_number = $business_row['gst_num'] ?? '';
        }
        mysqli_stmt_close($stmt);
    }
}

// ---------- Fetch invoice items ----------
$items = [];
$sql_items = "SELECT * FROM invoice_items WHERE invoice_id = ? ORDER BY id";
if ($stmt = mysqli_prepare($conn, $sql_items)) {
    mysqli_stmt_bind_param($stmt, "i", $invoice_id);
    mysqli_stmt_execute($stmt);
    $res = mysqli_stmt_get_result($stmt);
    while ($row = mysqli_fetch_assoc($res)) $items[] = $row;
    mysqli_stmt_close($stmt);
}

// ---------- Shop settings ----------
$shop_settings = [];
$sql_settings = "SELECT setting_key, setting_value FROM shop_settings";
$res_settings = mysqli_query($conn, $sql_settings);
if ($res_settings) {
    while ($row = mysqli_fetch_assoc($res_settings)) {
        $shop_settings[$row['setting_key']] = $row['setting_value'];
    }
}

// ---------- Calculate Totals ----------
$subtotal = (float)($invoice['subtotal'] ?? 0);
$discount = (float)($invoice['discount'] ?? 0);
$total_gst = (float)($invoice['total_gst'] ?? 0);
$grand_total = (float)($invoice['total'] ?? 0);
$cash_received = (float)($invoice['cash_received'] ?? 0);
$change_given = (float)($invoice['change_given'] ?? 0);

// ---------- Date Formatting ----------
$invoice_date = !empty($invoice['created_at']) ? date('d/m/Y', strtotime($invoice['created_at'])) : date('d/m/Y');
$invoice_time = !empty($invoice['created_at']) ? date('h:i A', strtotime($invoice['created_at'])) : date('h:i A');
?>

<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Invoice #<?= esc($invoice['invoice_number'] ?? 'N/A') ?></title>

/* Body */
body {
    margin: 0;
    font-family: Arial, Helvetica, sans-serif;
    font-size: 12px;
    color: #111;
    background: #fff;
}

/* Print button */
.print-btn {
    position: fixed;
    top: 15px;
    right: 15px;
    background: #1e3a8a;
    color: #fff;
    padding: 8px 16px;
    border: none;
    border-radius: 4px;
    cursor: pointer;
    z-index: 9999;
}

@media print {
    .print-btn { display: none; }
}

/* ===== FIXED HEADER ===== */
.header {
    position: fixed;
    top: 0;
    left: 0;
    right: 0;
    height: 140px;
    padding: 20px 30px;
    background: linear-gradient(90deg, #1e3a8a, #2563eb);
    color: #fff;
    display: flex;
    justify-content: space-between;
    align-items: flex-start;
    box-sizing: border-box;
}

.company h2 {
    margin: 0;
    font-size: 22px;
}

.company p {
    margin: 6px 0 0;
    font-size: 11px;
    line-height: 1.6;
    color: #e0e7ff;
}

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

.invoice-meta h1 {
    margin: 0;
    font-size: 26px;
    letter-spacing: 1px;
}

.invoice-meta p {
    margin: 6px 0 0;
    font-size: 12px;
    color: #e0e7ff;
}

/* ===== FIXED FOOTER ===== */
.footer {
    position: fixed;
    bottom: 0;
    left: 0;
    right: 0;
    height: 45px;
    background: #1e3a8a;
    color: #e0e7ff;
    text-align: center;
    font-size: 10px;
    line-height: 45px;
}

/* ===== CONTENT AREA ===== */
.content {
    padding: 160px 30px 80px;
}

/* Sections */
.section {
    margin-bottom: 20px;
}

.section-title {
    font-weight: bold;
    font-size: 11px;
    text-transform: uppercase;
    margin-bottom: 8px;
    color: #1e3a8a;
}

/* Customer box */
.customer-box {
    display: flex;
    gap: 20px;
}

.customer-box div {
    flex: 1;
    border: 1px solid #d1d5db;
    padding: 12px;
}

/* Table */
table {
    width: 100%;
    border-collapse: collapse;
    margin-top: 10px;
}

th {
    background: #f1f5f9;
    padding: 8px;
    font-size: 11px;
    text-align: left;
}

td {
    padding: 8px;
    border-bottom: 1px solid #e5e7eb;
}

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

/* For multi-page printing */
thead { display: table-header-group; }
tr { page-break-inside: avoid; }

/* Amount in words */
.amount-words {
    margin-top: 10px;
    padding: 8px;
    background: #f8fafc;
    border: 1px solid #e2e8f0;
    font-size: 11px;
    font-style: italic;
}

/* Totals */
.total-box {
    width: 320px;
    margin-left: auto;
    border: 2px solid #1e3a8a;
    padding: 12px;
}

.total-box table td {
    padding: 6px 0;
}

.grand {
    font-size: 16px;
    font-weight: bold;
    color: #1e3a8a;
}

/* Payment info */
.payment-info {
    margin-top: 15px;
    padding: 10px;
    background: #f0fdf4;
    border-radius: 6px;
    border: 1px solid #bbf7d0;
    font-size: 11px;
}

/* Notes */
.notes {
    border: 1px dashed #9ca3af;
    padding: 12px;
    font-size: 11px;
}

/* Signatures */
.sign-row {
    display: flex;
    justify-content: space-between;
    margin-top: 40px;
}

.sign {
    width: 45%;
}

.sign-line {
    margin-top: 35px;
    border-top: 1px solid #000;
    width: 200px;
}

/* Utility Classes */
.no-print { display: block; }
@media print {
    .no-print { display: none !important; }
}
</style>
</head>

<body>

<?php if (!$auto_print): ?><button class="print-btn no-print" onclick="window.print()">Print Invoice</button><?php endif; ?>

<div class="header">
    <div class="company">
        <h2><?= esc($invoice['business_name'] ?? $shop_settings['shop_name'] ?? 'ABC COMPANY') ?></h2>
        <p>
            <?php 
            // Display business address
            if (!empty($business_address)) {
                echo nl2br(esc($business_address));
            } elseif (!empty($shop_settings['shop_addr1'])) {
                echo esc($shop_settings['shop_addr1']);
                if (!empty($shop_settings['shop_addr2'])) {
                    echo '<br>' . esc($shop_settings['shop_addr2']);
                }
            } else {
                echo '123 Main Street, City';
            }
            ?><br>
            <?php if (!empty($shop_settings['shop_phone'])): ?>
            Phone: <?= esc($shop_settings['shop_phone']) ?><br>
            <?php endif; ?>
            GST: <?= esc($gst_number ?? $invoice['gst_number'] ?? $shop_settings['shop_gst'] ?? '12ABCDE1234F1Z5') ?>
        </p>
    </div>

<div class="invoice-meta">
        <h1>TAX INVOICE</h1>
        <p>
            Invoice #: <?= esc($invoice['invoice_number'] ?? 'INV-' . date('YmdHis')) ?><br>
            Date: <?= esc($invoice_date) ?> | <?= esc($invoice_time) ?><br>
            Payment: <?= strtoupper(esc($invoice['payment_method'] ?? 'CASH')) ?>
            <?php if (!empty($invoice['service_type']) && $invoice['service_type'] == 'service'): ?><br>
            Service Type: SERVICE INVOICE
            <?php endif; ?>
        </p>
    </div>
</div>

<div class="content">

<div class="section">
        <div class="section-title">Customer & Invoice Details</div>
        <div class="customer-box">
            <div>
                <strong>Bill To</strong><br>
                <?= esc($invoice['customer_name'] ?? 'Walk-in Customer') ?><br>
                <?php if (!empty($invoice['customer_phone'])): ?>
                Phone: <?= esc($invoice['customer_phone']) ?>
                <?php endif; ?>
            </div>
            <div>
                <strong>Invoice Details</strong><br>
                Invoice #: <?= esc($invoice['invoice_number'] ?? 'N/A') ?><br>
                Invoice Date: <?= esc($invoice_date) ?><br>
                Payment Terms: Immediate Payment<br>
                <?php if (!empty($invoice['service_type']) && $invoice['service_type'] == 'service'): ?>
                Service Date: <?= !empty($invoice['service_date']) ? date('d/m/Y', strtotime($invoice['service_date'])) : esc($invoice_date) ?><br>
                <?php if (!empty($invoice['technician'])): ?>
                Technician: <?= esc($invoice['technician']) ?>
                <?php endif; ?>
                <?php endif; ?>
            </div>
        </div>
    </div>

<div class="section">
        <div class="section-title">Invoice Items</div>
        <table>
            <thead>
                <tr>
                    <th>#</th>
                    <th>Description</th>
                    <th class="text-center">HSN</th>
                    <th class="text-center">Qty</th>
                    <th class="text-right">Rate</th>
                    <th class="text-center">GST %</th>
                    <th class="text-right">Amount</th>
                </tr>
            </thead>
            <tbody>
                <?php if (empty($items)): ?>
                    <tr><td colspan="7" class="text-center" style="padding: 18px;">No items found for this invoice.</td></tr>
                <?php else:
                    $i = 0;
                    $total_items = 0;
                    $total_qty = 0;
                    foreach ($items as $it):
                        $i++;
                        $qty = isset($it['quantity']) ? (float)$it['quantity'] : 0;
                        $unit_price = (float)($it['discounted_price'] ?? $it['original_price'] ?? 0);
                        $amount = $qty * $unit_price;
                        $gst_percent = (float)($it['gst_percentage'] ?? 0);
                        
                        $total_items++;
                        $total_qty += $qty;
                ?>
                <tr>
                    <td class="text-center"><?= $i ?></td>
                    <td>
                        <strong><?= esc($it['product_name']) ?></strong>
                        <?php if (!empty($it['product_category'])): ?>
                        <div style="color: #6b7280; margin-top: 4px; font-size: 10px;">
                            Category: <?= esc($it['product_category']) ?>
                        </div>
                        <?php endif; ?>
                        <?php if (!empty($it['description'])): ?>
                        <div style="color: #6b7280; margin-top: 2px; font-size: 10px;">
                            <?= esc($it['description']) ?>
                        </div>
                        <?php endif; ?>
                        <?php if (!empty($it['duration'])): ?>
                        <div style="color: #6b7280; margin-top: 2px; font-size: 10px;">
                            Duration: <?= esc($it['duration']) ?>
                        </div>
                        <?php endif; ?>
                    </td>
                    <td class="text-center"><?= esc($it['hsn_code'] ?? '-') ?></td>
                    <td class="text-center"><?= fmtNum($qty) ?></td>
                    <td class="text-right"><?= money($unit_price) ?></td>
                    <td class="text-center"><?= $gst_percent > 0 ? fmtNum($gst_percent) . '%' : '-' ?></td>
                    <td class="text-right"><?= money($amount) ?></td>
                </tr>
                <?php endforeach; endif; ?>
            </tbody>
        </table>
    </div>

<div class="section">
        <div class="total-box">
            <table>
                <tr>
                    <td>Subtotal:</td>
                    <td class="text-right"><?= money($subtotal) ?></td>
                </tr>
                
                <?php if ($discount > 0): ?>
                <tr>
                    <td>Discount:</td>
                    <td class="text-right">-<?= money($discount) ?></td>
                </tr>
                <?php endif; ?>
                
                <?php if (!empty($invoice['offer_discount']) && $invoice['offer_discount'] > 0): ?>
                <tr>
                    <td>Offer Discount:</td>
                    <td class="text-right">-<?= money($invoice['offer_discount']) ?></td>
                </tr>
                <?php endif; ?>
                
                <?php if (!empty($invoice['total_item_discount']) && $invoice['total_item_discount'] > 0): ?>
                <tr>
                    <td>Item Discounts:</td>
                    <td class="text-right">-<?= money($invoice['total_item_discount']) ?></td>
                </tr>
                <?php endif; ?>
                
                <?php if ($total_gst > 0): ?>
                <tr>
                    <td>GST Amount:</td>
                    <td class="text-right"><?= money($total_gst) ?></td>
                </tr>
                
                <?php if (!empty($invoice['total_cgst']) && !empty($invoice['total_sgst'])): ?>
                <tr>
                    <td style="padding-left: 20px;">CGST:</td>
                    <td class="text-right"><?= money($invoice['total_cgst']) ?></td>
                </tr>
                <tr>
                    <td style="padding-left: 20px;">SGST:</td>
                    <td class="text-right"><?= money($invoice['total_sgst']) ?></td>
                </tr>
                <?php endif; ?>
                
                <?php endif; ?>
                
                <tr>
                    <td class="grand">GRAND TOTAL:</td>
                    <td class="text-right grand"><?= money($grand_total) ?></td>
                </tr>
            </table>
            <div class="amount-words">
                <strong>Amount in words:</strong> <?= esc(numberToWords($grand_total)) ?> Only
            </div>
            
            <?php if ($cash_received > 0): ?>
            <div class="payment-info">
                <p><strong>Payment Details:</strong></p>
                <p>Cash Received: <?= money($cash_received) ?></p>
                <p>Change Given: <?= money($change_given) ?></p>
                <?php if ($cash_received >= $grand_total): ?>
                <p style="color: #059669; font-weight: bold;">✓ Payment Complete</p>
                <?php else: ?>
                <p style="color: #dc2626; font-weight: bold;">● Payment Pending: <?= money($grand_total - $cash_received) ?></p>
                <?php endif; ?>
            </div>
            <?php endif; ?>
        </div>
    </div>

<div class="section notes">
        <strong>Terms & Conditions:</strong><br>
        1. Goods once sold will not be taken back.<br>
        2. All disputes subject to local jurisdiction only.<br>
        3. Please check all items at the time of purchase.<br>
        4. Warranty as per manufacturer terms and conditions.<br>
        5. This is a computer generated invoice, no signature required.
    </div>

<div class="sign-row">
        <div class="sign">
            Customer Signature
            <div class="sign-line"></div>
        </div>
        <div class="sign" style="text-align:right;">
            For <?= esc($invoice['business_name'] ?? $shop_settings['shop_name'] ?? 'Company') ?>
            <div class="sign-line" style="margin-left:auto;"></div>
            <div style="font-size: 10px; color: #6b7280; margin-top: 4px;">Authorized Signatory</div>
        </div>
    </div>

</div>

<div class="footer">
    This is a computer-generated invoice | Thank you for your business
</div>

<?php if ($auto_print): ?>
<script>
window.onload = function(){
    setTimeout(function(){ 
        window.print(); 
        setTimeout(function(){ window.close(); }, 800);
    }, 300);
};
</script>
<?php endif; ?>

</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: inv-modern.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation