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.27 TB

🔧 Quick Actions

✏️ Editing: quo-modern.php

<?php
// quotation-modern-clean.php
// DOMPDF version - Modern Minimalist Layout / Different UI & Colors
// Clean corporate look with soft blues, grays, better spacing

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

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 (same as before) ─────────────────────────────────────────────────
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); }

// ── Input & Data Fetching (same logic) ───────────────────────────────────────
if (!isset($_GET['id']) || !is_numeric($_GET['id'])) {
    http_response_code(400);
    die("Quotation ID is required.");
}
$quotation_id = (int) $_GET['id'];

$quotation = null;
$sql = "SELECT q.*, c.name AS customer_name, c.phone AS customer_phone, q.created_at
        FROM quotations q
        LEFT JOIN customers c ON q.customer_id = c.id
        WHERE q.id = ?";
if ($stmt = mysqli_prepare($conn, $sql)) {
    mysqli_stmt_bind_param($stmt, "i", $quotation_id);
    mysqli_stmt_execute($stmt);
    $res = mysqli_stmt_get_result($stmt);
    $quotation = mysqli_fetch_assoc($res) ?: null;
    mysqli_stmt_close($stmt);
}
if (!$quotation) {
    http_response_code(404);
    die("Quotation not found.");
}

$gst_table = find_table($conn, ['gst_details','gst_DETAILS','gst','gstinfo','gst_detail']);
$business_gst = null;
if ($gst_table && !empty($quotation['business_id'])) {
    $bid = (int)$quotation['business_id'];
    $r = @mysqli_query($conn, "SELECT * FROM `{$gst_table}` WHERE id = {$bid} LIMIT 1");
    if ($r) $business_gst = mysqli_fetch_assoc($r);
}

$items = [];
if ($stmt = mysqli_prepare($conn, "SELECT * FROM quotation_items WHERE quotation_id = ? ORDER BY id")) {
    mysqli_stmt_bind_param($stmt, "i", $quotation_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 = [];
$qkeys = "('shop_name','shop_addr1','shop_addr2','shop_phone','owner_name','shop_gst')";
$qr = @mysqli_query($conn, "SELECT * FROM shop_settings WHERE setting_key IN $qkeys");
if ($qr) while ($r = mysqli_fetch_assoc($qr)) $shop_settings[$r['setting_key']] = $r['setting_value'];

$customer_address = '';
$customer_company = '';
if (!empty($quotation['customer_id'])) {
    $cust_sql = "SELECT address, company_name FROM customers WHERE id = " . (int)$quotation['customer_id'];
    $cust_res = @mysqli_query($conn, $cust_sql);
    if ($cust_res && $cust_row = mysqli_fetch_assoc($cust_res)) {
        $customer_address = $cust_row['address'] ?? '';
        $customer_company = $cust_row['company_name'] ?? '';
    }
}

$subtotal     = isset($quotation['subtotal'])    ? (float)$quotation['subtotal']    : 0.00;
$total_gst    = isset($quotation['total_gst'])   ? (float)$quotation['total_gst']   : 0.00;
$grand_total  = isset($quotation['grand_total']) ? (float)$quotation['grand_total'] : ($subtotal + $total_gst);
$created_date = !empty($quotation['created_at']) ? date('d/m/Y', strtotime($quotation['created_at'])) : date('d/m/Y');
$valid_until  = !empty($quotation['created_at']) ? date('d/m/Y', strtotime('+30 days', strtotime($quotation['created_at']))) : date('d/m/Y', strtotime('+30 days'));

// ── Start HTML buffer for DOMPDF ─────────────────────────────────────────────
ob_start();
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Quotation <?= esc($quotation['quotation_number'] ?? '—') ?></title>
<style>
@page {
    size: A4 portrait;
    margin: 1.5cm 1.5cm 1.8cm 1.5cm;
}

body {
    font-family: 'Helvetica', 'Arial', sans-serif;
    font-size: 10.5pt;
    color: #2d3748;
    line-height: 1.45;
    margin: 0;
}

h1, h2, h3, h4 { margin: 0; padding: 0; }

.container {
    max-width: 100%;
}

/* ── Header Table Layout ───────────────────────────────────────────────────── */
.header-table {
    width: 100%;
    border-collapse: collapse;
    margin-bottom: 20px;
    border-bottom: 3px solid #4f46e5;
    padding-bottom: 10px;
}

.header-left {
    text-align: left;
    vertical-align: top;
    width: 60%;
}

.header-right {
    text-align: right;
    vertical-align: top;
    width: 40%;
}

.company-name {
    font-size: 24px;
    font-weight: 700;
    color: #4f46e5;
    letter-spacing: -0.5px;
    margin-bottom: 5px;
}

.company-details {
    font-size: 9pt;
    color: #4b5563;
    line-height: 1.5;
}

.quotation-title {
    font-size: 22px;
    font-weight: 700;
    color: #1e293b;
    margin-bottom: 5px;
}

.quotation-meta {
    font-size: 9.5pt;
    color: #64748b;
}

.quotation-meta strong {
    color: #1e293b;
}

/* ── Section Titles ────────────────────────────────────────────────────────── */
.section-title {
    font-size: 12.5pt;
    font-weight: 700;
    color: #1e293b;
    margin: 25px 0 10px;
    padding-bottom: 5px;
    border-bottom: 1px solid #e2e8f0;
}

/* ── Bill & Supply Table Layout ────────────────────────────────────────────── */
.info-table {
    width: 100%;
    border-collapse: collapse;
    margin-bottom: 20px;
}

.info-table td {
    width: 50%;
    vertical-align: top;
    padding: 0;
}

.info-box {
    background: #f8fafc;
    border: 1px solid #e2e8f0;
    border-radius: 6px;
    padding: 12px 14px;
    margin-right: 10px;
}

.info-box.right-box {
    margin-right: 0;
    margin-left: 10px;
}

.info-box strong {
    display: block;
    font-size: 10pt;
    color: #1e293b;
    margin-bottom: 6px;
}

.info-box p {
    margin: 3px 0;
    font-size: 10pt;
    color: #475569;
}

/* ── Items Table ───────────────────────────────────────────────────────────── */
.items-table {
    width: 100%;
    border-collapse: collapse;
    margin: 12px 0 18px;
    font-size: 9.5pt;
}

.items-table thead th {
    background: #4f46e5;
    color: white;
    font-weight: 600;
    padding: 8px 6px;
    text-align: left;
    border-bottom: 2px solid #4338ca;
}

.items-table tbody td {
    padding: 8px 6px;
    border-bottom: 1px solid #e2e8f0;
    vertical-align: top;
}

.items-table .num { text-align: center; width: 5%; }
.items-table .desc { width: 40%; }
.items-table .hsn  { text-align: center; width: 8%; }
.items-table .qty  { text-align: center; width: 7%; }
.items-table .rate { text-align: right; width: 12%; }
.items-table .gst  { text-align: center; width: 7%; }
.items-table .amt  { text-align: right; width: 21%; }

.items-table .item-title {
    font-weight: 600;
    color: #1e293b;
}

.items-table .item-subtitle {
    color: #64748b;
    font-size: 8.5pt;
    margin-top: 2px;
}

/* ── Totals ────────────────────────────────────────────────────────────────── */
.totals-box {
    width: 300px;
    margin-left: auto;
    background: #f8fafc;
    border: 1px solid #cbd5e1;
    border-radius: 6px;
    padding: 12px 16px;
}

.totals-box table {
    width: 100%;
}

.totals-box td {
    padding: 5px 0;
    font-size: 10pt;
}

.totals-box .label {
    color: #475569;
}

.totals-box .value {
    text-align: right;
    font-weight: 600;
}

.totals-box .grand-total-row .label {
    font-size: 13pt;
    font-weight: 700;
    color: #4f46e5;
    border-top: 2px solid #e2e8f0;
    padding-top: 8px;
    margin-top: 4px;
}

.totals-box .grand-total-row .value {
    font-size: 13pt;
    font-weight: 700;
    color: #4f46e5;
    border-top: 2px solid #e2e8f0;
    padding-top: 8px;
    margin-top: 4px;
    text-align: right;
}

/* ── Amount in Words ───────────────────────────────────────────────────────── */
.amount-words {
    margin: 15px 0 20px;
    padding: 10px 15px;
    background: #f1f5f9;
    border-left: 4px solid #6366f1;
    font-style: italic;
    color: #334155;
    font-size: 10pt;
}

/* ── Notes ─────────────────────────────────────────────────────────────────── */
.notes {
    background: #fefce8;
    border: 1px solid #fef08a;
    border-radius: 6px;
    padding: 12px 16px;
    font-size: 9pt;
    color: #713f12;
    line-height: 1.5;
}

.notes strong {
    color: #854d0e;
}

/* ── Signatures ────────────────────────────────────────────────────────────── */
.signatures {
    margin-top: 35px;
    width: 100%;
    table-layout: fixed;
}

.signature-td {
    text-align: center;
    width: 50%;
}

.signature-line {
    border-top: 1px solid #1e293b;
    height: 1px;
    margin: 40px auto 8px;
    width: 180px;
}

.signature-label {
    font-size: 9pt;
    color: #475569;
}

/* ── Footer ────────────────────────────────────────────────────────────────── */
.footer {
    position: fixed;
    bottom: 12mm;
    left: 0;
    right: 0;
    text-align: center;
    font-size: 8pt;
    color: #94a3b8;
    border-top: 1px solid #e2e8f0;
    padding-top: 6px;
}

.page-number:before {
    content: "Page " counter(page);
}
</style>
</head>
<body>

<table class="header-table">
        <tr>
            <td class="header-left">
                <div class="company-name"><?= esc($quotation['business_name'] ?? $shop_settings['shop_name'] ?? 'Your Company') ?></div>
                <div class="company-details">
                    <?php
                    $addr = !empty($quotation['business_address']) ? $quotation['business_address'] :
                            ($shop_settings['shop_addr1'] ?? 'Address Line 1') . ', ' . ($shop_settings['shop_addr2'] ?? '');
                    echo esc($addr);
                    ?><br>
                    Email: <?= esc($quotation['business_email'] ?? 'contact@yourcompany.com') ?><br>
                    GSTIN: <?= esc($business_gst['gst_num'] ?? $shop_settings['shop_gst'] ?? '—') ?>
                </div>
            </td>
            <td class="header-right">
                <div class="quotation-title">QUOTATION</div>
                <div class="quotation-meta">
                    <strong>Quote No:</strong> <?= esc($quotation['quotation_number'] ?? 'Q-'.date('ymd')) ?><br>
                    <strong>Date:</strong> <?= esc($created_date) ?><br>
                    <strong>Valid Until:</strong> <?= esc($valid_until) ?>
                </div>
            </td>
        </tr>
    </table>

<div class="section-title">Bill & Supply Information</div>
    <table class="info-table">
        <tr>
            <td>
                <div class="info-box">
                    <strong>Bill To</strong>
                    <p><strong><?= esc($quotation['customer_name'] ?? 'Walk-in-Customer') ?></strong></p>
                    <?php if ($customer_company): ?>
                    <p><?= esc($customer_company) ?></p>
                    <?php endif; ?>
                    <?php if ($customer_address): ?>
                    <p><?= nl2br(esc($customer_address)) ?></p>
                    <?php endif; ?>
                </div>
            </td>
            <td>
                <div class="info-box right-box">
                    <strong>Supply Terms</strong>
                    <p><strong>Payment Terms:</strong> Net 30 Days</p>
                    <p><strong>Delivery Time:</strong> 7–10 Days</p>
                    <p><strong>Place of Supply:</strong> Tamil Nadu</p>
                </div>
            </td>
        </tr>
    </table>

<div class="section-title">Quotation Items</div>
    <table class="items-table">
        <thead>
            <tr>
                <th class="num">#</th>
                <th class="desc">Description</th>
                <th class="hsn">HSN</th>
                <th class="qty">Qty</th>
                <th class="rate">Rate</th>
                <th class="gst">GST %</th>
                <th class="amt">Amount</th>
            </tr>
        </thead>
        <tbody>
        <?php if (empty($items)): ?>
            <tr><td colspan="7" style="text-align:center; padding:30px 0;">No items in this quotation</td></tr>
        <?php else: $i = 0; foreach($items as $it): $i++;
            $qty = (float)($it['quantity'] ?? 0);
            $rate = (float)($it['unit_price'] ?? 0);
            $amt = $qty * $rate;
        ?>
            <tr>
                <td class="num"><?= $i ?></td>
                <td class="desc">
                    <div class="item-title"><?= esc($it['item_name']) ?></div>
                    <?php if (!empty($it['description'])): ?>
                    <div class="item-subtitle"><?= esc($it['description']) ?></div>
                    <?php endif; ?>
                </td>
                <td class="hsn"><?= esc($it['hsn_code'] ?? '—') ?></td>
                <td class="qty"><?= fmtNum($qty) ?></td>
                <td class="rate"><?= number_format($rate, 2) ?></td>
                <td class="gst"><?= !empty($it['gst_percentage']) ? fmtNum($it['gst_percentage']) . '%' : '—' ?></td>
                <td class="amt"><?= number_format($amt, 2) ?></td>
            </tr>
        <?php endforeach; endif; ?>
        </tbody>
    </table>

<div class="totals-box">
        <table>
            <tr><td class="label">Subtotal</td><td class="value"><?= money($subtotal) ?></td></tr>
            <?php if ($total_gst > 0): ?>
            <tr><td class="label">GST <?= !empty($quotation['gst_percentage']) ? '(' . fmtNum($quotation['gst_percentage']) . '%)' : '' ?></td>
                <td class="value"><?= money($total_gst) ?></td></tr>
            <?php endif; ?>
            <?php if (!empty($quotation['total_discount']) && $quotation['total_discount'] > 0): ?>
            <tr><td class="label">Discount</td><td class="value">-<?= money($quotation['total_discount']) ?></td></tr>
            <?php endif; ?>
            <tr class="grand-total-row">
                <td class="label">Grand Total</td>
                <td class="value"><?= money($grand_total) ?></td>
            </tr>
        </table>
    </div>

<div class="amount-words">
        <strong>Amount Chargeable (in words) :</strong> <?= esc(numberToWords($grand_total)) ?> Only
    </div>

<div class="notes">
        <strong>Terms & Conditions:</strong><br>
        • This quotation is valid for 30 days from the date of issue.<br>
        • 50% advance payment required to confirm the order.<br>
        • Once production/material approval is given, no changes or cancellations will be accepted.<br>
        <?php if (!empty($quotation['notes'])): ?>
        • <?= nl2br(esc($quotation['notes'])) ?><br>
        <?php endif; ?>
        • GST invoice will be issued only upon submission of valid GST certificate.<br>
        • This is a computer-generated document — no signature required.
    </div>

<table class="signatures">
        <tr>
            <td class="signature-td">
                <div class="signature-line"></div>
                <div class="signature-label">Customer / Recipient</div>
            </td>
            <td class="signature-td">
                <div class="signature-line"></div>
                <div class="signature-label">Authorized Signatory<br><?= esc($quotation['business_name'] ?? $shop_settings['shop_name'] ?? 'Company') ?></div>
            </td>
        </tr>
    </table>

</div>

<div class="footer">
    <span class="page-number"></span> | Thank you for your business
</div>

</body>
</html>
<?php
$html = ob_get_clean();

// ── DOMPDF Configuration ─────────────────────────────────────────────────────
$options = new Options();
$options->set('isRemoteEnabled', true);
$options->set('isHtml5ParserEnabled', true);
$options->set('defaultFont', 'Helvetica');
$options->set('chroot', realpath(''));

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

$filename = 'Quotation_' . ($quotation['quotation_number'] ?? $quotation_id) . '.pdf';
$filename = preg_replace('/[^a-zA-Z0-9_\-\.]/', '_', $filename);

$dompdf->stream($filename, ["Attachment" => true]);

exit;

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: quo-modern.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation