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

Free Space:

10.3 TB

🔧 Quick Actions

✏️ Editing: invotest.php

<?php
// invoice_print.php — PDF Generation (A4 Size)
include('includes/db.php');

// Include Dompdf
require_once 'dom/vendor/autoload.php';
use Dompdf\Dompdf;
use Dompdf\Options;

/* ================================
   COMPANY DETAILS FROM DATABASE
   ================================ */
$SHOP_NAME = $SHOP_ADDR1 = $SHOP_ADDR2 = $SHOP_PHONE = $OWNER_NAME = '';

$settings_sql = "SELECT setting_key, setting_value FROM shop_settings 
                 WHERE setting_key IN ('shop_name', 'shop_addr1', 'shop_addr2', 'shop_phone', 'owner_name')";
$result = mysqli_query($conn, $settings_sql);

if ($result && mysqli_num_rows($result) > 0) {
    while ($row = mysqli_fetch_assoc($result)) {
        switch ($row['setting_key']) {
            case 'shop_name':
                $SHOP_NAME = $row['setting_value'];
                break;
            case 'shop_addr1':
                $SHOP_ADDR1 = $row['setting_value'];
                break;
            case 'shop_addr2':
                $SHOP_ADDR2 = $row['setting_value'];
                break;
            case 'shop_phone':
                $SHOP_PHONE = $row['setting_value'];
                break;
            case 'owner_name':
                $OWNER_NAME = $row['setting_value'];
                break;
        }
    }
}

// Set default values if not found in database
if (empty($SHOP_NAME)) $SHOP_NAME = 'POORVA SHARPTRONICS';
if (empty($SHOP_ADDR1)) $SHOP_ADDR1 = '2/252, Poorva Sharptronics, Sitlkarampatti Vill';
if (empty($SHOP_ADDR2)) $SHOP_ADDR2 = 'Pennagaram Tk, O G Halli, Dharmapuri, Tamil Nadu';
if (empty($SHOP_PHONE)) $SHOP_PHONE = '8883889127';
if (empty($OWNER_NAME)) $OWNER_NAME = 'Hari';

/* ================================
   INPUT / LOAD DATA
   ================================ */
$invoiceNumber = isset($_GET['invoice_id']) ? trim($_GET['invoice_id']) : '';
$autoPrint     = isset($_GET['auto']);

if ($invoiceNumber === '') { 
    http_response_code(400); 
    echo 'Missing invoice_id'; 
    exit; 
}

// Invoice + customer
$stmt = mysqli_prepare(
  $conn,
  "SELECT i.id, i.invoice_number, i.customer_id, i.subtotal, i.discount, i.discount_type,
          i.total, i.cash_received, i.change_given, i.payment_method, i.created_at,
          c.name AS customer_name, c.phone AS customer_phone
   FROM invoices i
   LEFT JOIN customers c ON c.id = i.customer_id
   WHERE i.invoice_number = ?
   LIMIT 1"
);
mysqli_stmt_bind_param($stmt, 's', $invoiceNumber);
mysqli_stmt_execute($stmt);
$res = mysqli_stmt_get_result($stmt);
$inv = ($res && mysqli_num_rows($res) === 1) ? mysqli_fetch_assoc($res) : null;
mysqli_stmt_close($stmt);
if (!$inv) { 
    http_response_code(404); 
    echo 'Invoice not found'; 
    exit; 
}

// Items
$items = [];
$stmt2 = mysqli_prepare(
  $conn,
  "SELECT product_name, quantity, unit_price, total_price, product_category 
   FROM invoice_items WHERE invoice_id = ? ORDER BY id ASC"
);
mysqli_stmt_bind_param($stmt2, 'i', $inv['id']);
mysqli_stmt_execute($stmt2);
$res2 = mysqli_stmt_get_result($stmt2);
while ($row = mysqli_fetch_assoc($res2)) { 
    $items[] = $row; 
}
mysqli_stmt_close($stmt2);

/* ================================
   HELPERS
   ================================ */
function nf($n){ return number_format((float)$n, 2); }

/* ================================
   DERIVED FIELDS
   ================================ */
// Convert UTC → Asia/Kolkata
if ($inv['created_at']) {
    $dt = new DateTime($inv['created_at'], new DateTimeZone('UTC'));
    $dt->setTimezone(new DateTimeZone('Asia/Kolkata'));
    $dateStr = $dt->format('d M Y, h:i A');
    $dateOnly = $dt->format('d M Y');
} else {
    $dateStr = date('d M Y, h:i A');
    $dateOnly = date('d M Y');
}

$invNo    = $inv['invoice_number'];
$custName = $inv['customer_name'] ?: 'Walk-in';
$custPh   = $inv['customer_phone'] ?: '-';
$payMode  = strtoupper($inv['payment_method']);
$amountWords = toIndianCurrencyWords(round($inv['total'])) . ' Only';

/* ================================
   GENERATE PDF
   ================================ */
$html = '
<!DOCTYPE html>
<html>
<head>
    <meta charset="UTF-8">
    <title>Invoice ' . $invNo . '</title>
    <style>
        body { 
            font-family: DejaVu Sans, Arial, sans-serif; 
            margin: 0;
            padding: 15mm;
            color: #000;
            font-size: 12px;
        }
        .invoice-container {
            max-width: 100%;
            margin: 0 auto;
        }
        .header {
            display: flex; 
            justify-content: space-between; 
            align-items: flex-start; 
            gap: 16px;
            border-bottom: 2px solid #000;
            padding-bottom: 10px;
            margin-bottom: 15px;
        }
        .inv-brand h2 {
            margin: 0;
            font-size: 20px;
            font-weight: 800;
            text-transform: uppercase;
        }
        .inv-brand .muted {
            font-size: 11px;
            line-height: 1.4;
        }
        .inv-meta {
            text-align: right;
            font-size: 11px;
        }
        .inv-meta div { margin-bottom: 3px; }
        
        .inv-parties {
            display: grid; 
            grid-template-columns: 1fr 1fr; 
            gap: 16px; 
            margin: 15px 0;
            border-bottom: 1px dashed #999;
            padding-bottom: 10px;
        }
        .inv-box {
            border: 1px solid #ddd;
            border-radius: 4px;
            padding: 8px;
        }
        .inv-box h6 {
            margin: 0 0 6px 0;
            font-size: 12px;
            font-weight: 700;
        }
        .inv-box div { font-size: 11px; line-height: 1.4; }
        
        .inv-table {
            width: 100%;
            border-collapse: collapse;
            margin: 15px 0;
            font-size: 11px;
        }
        .inv-table th, .inv-table td {
            border: 1px solid #000;
            padding: 6px 8px;
        }
        .inv-table th { 
            background: #f2f2f2; 
            font-weight: bold;
        }
        .text-right { text-align: right; }
        .text-center { text-align: center; }
        
        .inv-totals {
            width: 100%;
            display: grid;
            grid-template-columns: 1fr 240px;
            gap: 16px;
            margin-top: 15px;
        }
        .total-box {
            border: 1px solid #ddd;
            border-radius: 4px;
            padding: 8px;
        }
        .total-grid {
            display: grid; 
            grid-template-columns: 1fr 100px;
            row-gap: 4px; 
            column-gap: 8px;
            font-size: 11px;
        }
        .total-grid div { padding: 1px 0; }
        .total-grid .label { text-align: left; }
        .total-grid .value { text-align: right; font-weight: 600; }
        .grand {
            border-top: 2px solid #000; 
            margin-top: 4px; 
            padding-top: 4px; 
            font-weight: 800;
        }
        
        .amount-words {
            margin-top: 6px;
            font-size: 11px;
            font-style: italic;
        }
        
        .inv-footer {
            display: grid; 
            grid-template-columns: 1fr 1fr; 
            gap: 16px; 
            margin-top: 20px;
        }
        .sign-box {
            border-top: 1px dashed #999;
            padding-top: 15px;
            text-align: right;
            font-size: 11px;
        }
        .notes-box {
            font-size: 10px;
            color: #333;
        }
        .notes-box ul { 
            margin: 4px 0 0 15px;
            padding: 0;
        }
        .notes-box li {
            margin-bottom: 2px;
        }
    </style>
</head>
<body>
    <div class="invoice-container">
        
        
        <div class="header">
            <div class="inv-brand">
                <h2>' . htmlspecialchars($SHOP_NAME) . '</h2>
                <div class="muted">
                    ' . htmlspecialchars($SHOP_ADDR1) . '<br>
                    ' . htmlspecialchars($SHOP_ADDR2) . '
                </div>
                <div class="muted">
                    Ph: ' . htmlspecialchars($SHOP_PHONE) . ' | Prop: ' . htmlspecialchars($OWNER_NAME) . '
                </div>
            </div>
            <div class="inv-meta">
                <div><strong>TAX INVOICE</strong></div>
                <div>Invoice No: ' . htmlspecialchars($invNo) . '</div>
                <div>Date: ' . htmlspecialchars($dateOnly) . '</div>
                <div>Payment: ' . htmlspecialchars($payMode) . '</div>
            </div>
        </div>
        
        
        <div class="inv-parties">
            <div class="inv-box">
                <h6>Billed To</h6>
                <div>Name: ' . htmlspecialchars($custName) . '</div>
                <div>Phone: ' . htmlspecialchars($custPh) . '</div>
            </div>
            <div class="inv-box">
                <h6>From</h6>
                <div>' . htmlspecialchars($SHOP_NAME) . '</div>
                <div>' . htmlspecialchars($SHOP_ADDR1) . '</div>
                <div>' . htmlspecialchars($SHOP_ADDR2) . '</div>
            </div>
        </div>
        
        
        <table class="inv-table">
            <thead>
                <tr>
                    <th style="width:40px;">#</th>
                    <th>Description</th>
                    <th style="width:80px;" class="text-center">Qty</th>
                    <th style="width:90px;" class="text-right">Rate (₹)</th>
                    <th style="width:100px;" class="text-right">Amount (₹)</th>
                </tr>
            </thead>
            <tbody>';

// Add items to table
$counter = 1;
foreach($items as $item) {
    $html .= '
                <tr>
                    <td>' . $counter . '</td>
                    <td>' . htmlspecialchars($item['product_name']) . '</td>
                    <td class="text-center">' . (int)$item['quantity'] . '</td>
                    <td class="text-right">' . nf($item['unit_price']) . '</td>
                    <td class="text-right">' . nf($item['total_price']) . '</td>
                </tr>';
    $counter++;
}

$html .= '
            </tbody>
        </table>
        
        
        <div class="inv-totals">
            <div class="total-box">
                <strong>Notes</strong>
                <div class="notes-box">
                    <ul>
                        <li>Prices are inclusive of applicable taxes unless specified.</li>
                        <li>Goods once sold will not be taken back.</li>
                        <li>Warranty as per manufacturer terms (if applicable).</li>
                    </ul>
                </div>
                <div class="amount-words">Amount in words: ' . htmlspecialchars($amountWords) . '</div>
            </div>
            
            <div class="total-box">
                <div class="total-grid">
                    <div class="label">Subtotal</div>
                    <div class="value">' . nf($inv['subtotal']) . '</div>
                    
                    <div class="label">Discount</div>
                    <div class="value">' . nf($inv['discount']) . '</div>
                    
                    <div class="label">Tax</div>
                    <div class="value">0.00</div>
                    
                    <div class="label grand">Grand Total</div>
                    <div class="value grand">' . nf($inv['total']) . '</div>
                    
                    <div class="label">Cash Received</div>
                    <div class="value">' . nf($inv['cash_received']) . '</div>
                    
                    <div class="label">Change</div>
                    <div class="value">' . nf($inv['change_given']) . '</div>
                </div>
            </div>
        </div>
        
        
        <div class="inv-footer">
            <div class="notes-box">
                Thank you for your business!
            </div>
            <div class="sign-box">
                For ' . htmlspecialchars($SHOP_NAME) . '<br><br><br>
                Authorized Signature
            </div>
        </div>
        
    </div>
</body>
</html>';

// Configure PDF options
$options = new Options();
$options->set('isHtml5ParserEnabled', true);
$options->set('isRemoteEnabled', true);
$options->set('defaultFont', 'DejaVu Sans');

$dompdf = new Dompdf($options);
$dompdf->loadHtml($html);
$dompdf->setPaper('A4', 'portrait');
$dompdf->render();

// Output PDF to browser
$dompdf->stream("invoice-{$invNo}.pdf", [
    "Attachment" => false // true to download, false to preview
]);

exit;
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: invotest.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation