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-styled.php

<?php
// inv-elegant-colored.php
// Database integrated invoice with elegant colored 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>

:root{
    --primary: #1e3a8a;
    --secondary: #3b82f6;
}

body {
    margin: 0;
    font-family: "Segoe UI", Arial, sans-serif;
    font-size: 12px;
    color: #111;
    background: #fff;
}

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

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

/* ===== HEADER ===== */
.header {
    background: linear-gradient(135deg, var(--primary), var(--secondary));
    color: #fff;
    padding: 28px 40px 45px;
    position: relative;
}

.header::after {
    content: "";
    position: absolute;
    bottom: -25px;
    left: 0;
    right: 0;
    height: 50px;
    background: #fff;
    border-top-left-radius: 40px;
    border-top-right-radius: 40px;
}

.header-inner {
    display: flex;
    justify-content: space-between;
    align-items: flex-start;
    position: relative;
    z-index: 2;
}

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

.company p {
    margin: 6px 0 0;
    font-size: 11px;
    line-height: 1.6;
    opacity: 0.95;
}

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

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

.invoice-box p {
    margin: 6px 0 0;
    font-size: 11px;
}

/* ===== CONTENT ===== */
.content {
    padding: 60px 40px 90px;
}

/* Section title */
.section-title {
    font-size: 11px;
    font-weight: bold;
    text-transform: uppercase;
    margin-bottom: 6px;
    color: var(--primary);
}

/* Info */
.info {
    display: flex;
    justify-content: space-between;
    margin-bottom: 22px;
}

.info div {
    width: 48%;
}

/* Table */
table {
    width: 100%;
    border-collapse: collapse;
}

thead th {
    background: #f1f5f9;
    font-size: 11px;
    padding: 8px;
    text-align: left;
    border-bottom: 2px solid var(--primary);
}

tbody 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 {
    margin-top: 15px;
    width: 300px;
    margin-left: auto;
}

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

.grand {
    font-size: 15px;
    font-weight: bold;
    color: var(--primary);
}

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

/* Notes */
.notes {
    margin-top: 25px;
    font-size: 11px;
}

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

.sign {
    width: 45%;
}

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

/* ===== FOOTER ===== */
.footer {
    position: fixed;
    bottom: 0;
    left: 0;
    right: 0;
    background: linear-gradient(90deg, var(--primary), var(--secondary));
    color: #e0e7ff;
    text-align: center;
    font-size: 10px;
    padding: 12px 20px;
}

/* 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="header-inner">
        <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-box">
            <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>

<div class="content">

<div class="section-title">Customer & Invoice Details</div>
    <div class="info">
        <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']) ?><br>
            <?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 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 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 class="grand">
                <td><strong>GRAND TOTAL:</strong></td>
                <td class="text-right"><strong><?= money($grand_total) ?></strong></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 class="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-styled.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation