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

<?php
// inv-modern.php
// Database integrated invoice with modern design - AUTO DOWNLOAD VERSION (NO ₹ SYMBOL)
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); } // Removed ₹ symbol
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'];

// ---------- 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 Details from GST Details with Logo & Signature ----------
$business_address = '';
$gst_number = '';
$business_logo = '';
$business_signature = '';
$signatory_name = '';
$signatory_designation = '';
$account_name = '';
$account_number = '';
$bank_name = '';
$branch_name = '';
$ifsc_code = '';

if (!empty($invoice['business_id'])) {
    $sql_business = "SELECT * 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'] ?? '';
            $business_logo = $business_row['logo_path'] ?? '';
            $business_signature = $business_row['signature_path'] ?? '';
            $signatory_name = $business_row['signatory_name'] ?? '';
            $signatory_designation = $business_row['signatory_designation'] ?? '';
            $account_name = $business_row['account_name'] ?? $business_row['bank_account_name'] ?? '';
            $account_number = $business_row['account_number'] ?? $business_row['bank_account_number'] ?? '';
            $bank_name = $business_row['bank_name'] ?? '';
            $branch_name = $business_row['branch_name'] ?? '';
            $ifsc_code = $business_row['ifsc_code'] ?? '';
        }
        mysqli_stmt_close($stmt);
    }
}

// If no business details found, try to get active GST
if (empty($business_address) && empty($gst_number)) {
    $gst_sql = "SELECT * FROM gst_details WHERE gst_status = 1 ORDER BY id DESC LIMIT 1";
    $gst_res = mysqli_query($conn, $gst_sql);
    if ($gst_res && mysqli_num_rows($gst_res) > 0) {
        $business_row = mysqli_fetch_assoc($gst_res);
        $business_address = $business_row['business_address'] ?? '';
        $gst_number = $business_row['gst_num'] ?? '';
        $business_logo = $business_row['logo_path'] ?? '';
        $business_signature = $business_row['signature_path'] ?? '';
        $signatory_name = $business_row['signatory_name'] ?? '';
        $signatory_designation = $business_row['signatory_designation'] ?? '';
        $account_name = $business_row['account_name'] ?? $business_row['bank_account_name'] ?? '';
        $account_number = $business_row['account_number'] ?? $business_row['bank_account_number'] ?? '';
        $bank_name = $business_row['bank_name'] ?? '';
        $branch_name = $business_row['branch_name'] ?? '';
        $ifsc_code = $business_row['ifsc_code'] ?? '';
    }
}

// Check if logo file exists
if (!empty($business_logo) && !file_exists($business_logo)) {
    $business_logo = '';
}
if (!empty($business_signature) && !file_exists($business_signature)) {
    $business_signature = '';
}

// ---------- 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);
$item_discount = (float)($invoice['total_item_discount'] ?? 0);
$total_discount = $item_discount + $discount;
$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');

// ---------- CREATE PDF CLASS FOR MODERN DESIGN ----------
class ModernInvoicePDF extends FPDF
{
    private $business_name = '';
    private $business_address = '';
    private $gst_number = '';
    private $shop_phone = '';
    private $invoice_number = '';
    private $invoice_date = '';
    private $payment_method = '';
    private $customer_name = '';
    private $customer_phone = '';
    private $items = [];
    private $subtotal = 0;
    private $discount = 0;
    private $item_discount = 0;
    private $total_gst = 0;
    private $grand_total = 0;
    private $cash_received = 0;
    private $change_given = 0;
    private $invoice = [];
    private $service_type = '';
    private $service_date = '';
    private $offer_discount = 0;
    private $total_item_discount = 0;
    private $total_cgst = 0;
    private $total_sgst = 0;
    private $logo_path = '';
    private $signature_path = '';
    private $signatory_name = '';
    private $signatory_designation = '';
    private $account_name = '';
    private $account_number = '';
    private $bank_name = '';
    private $branch_name = '';
    private $ifsc_code = '';
    
    public function setBusinessDetails($name, $address, $gst, $phone, $logo = '', $signature = '', $signatory = '', $designation = '') {
        $this->business_name = $name;
        $this->business_address = $address;
        $this->gst_number = $gst;
        $this->shop_phone = $phone;
        $this->logo_path = $logo;
        $this->signature_path = $signature;
        $this->signatory_name = $signatory;
        $this->signatory_designation = $designation;
    }
    
    public function setBankDetails($account_name, $account_number, $bank_name, $branch_name, $ifsc_code) {
        $this->account_name = $account_name;
        $this->account_number = $account_number;
        $this->bank_name = $bank_name;
        $this->branch_name = $branch_name;
        $this->ifsc_code = $ifsc_code;
    }
    
    public function setInvoiceDetails($number, $date, $payment_method, $service_type = '', $service_date = '') {
        $this->invoice_number = $number;
        $this->invoice_date = $date;
        $this->payment_method = $payment_method;
        $this->service_type = $service_type;
        $this->service_date = $service_date;
    }
    
    public function setCustomerDetails($name, $phone) {
        $this->customer_name = $name;
        $this->customer_phone = $phone;
    }
    
    public function setItems($items) {
        $this->items = $items;
    }
    
    public function setTotals($subtotal, $discount, $item_discount, $total_gst, $grand_total, $cash_received, $change_given, $invoice) {
        $this->subtotal = $subtotal;
        $this->discount = $discount;
        $this->item_discount = $item_discount;
        $this->total_gst = $total_gst;
        $this->grand_total = $grand_total;
        $this->cash_received = $cash_received;
        $this->change_given = $change_given;
        $this->invoice = $invoice;
        $this->offer_discount = (float)($invoice['offer_discount'] ?? 0);
        $this->total_item_discount = (float)($invoice['total_item_discount'] ?? 0);
        $this->total_cgst = (float)($invoice['total_cgst'] ?? 0);
        $this->total_sgst = (float)($invoice['total_sgst'] ?? 0);
    }
    
    function Header()
    {
        // Accent bar
        $this->SetFillColor(37, 99, 235); // #2563eb
        $this->Rect(0, 0, 210, 6, 'F');
        
        $this->SetY(12);
        
        // Logo on left side
        $logo_width = 0;
        if (!empty($this->logo_path) && file_exists($this->logo_path)) {
            $image_info = @getimagesize($this->logo_path);
            if ($image_info) {
                // Calculate logo dimensions
                $width_px = $image_info[0];
                $height_px = $image_info[1];
                
                $width_mm = $width_px * 25.4 / 72;
                $height_mm = $height_px * 25.4 / 72;
                
                // Scale to fit height 15mm
                $target_height = 15;
                if ($height_mm > $target_height) {
                    $scale = $target_height / $height_mm;
                    $logo_width = $width_mm * $scale;
                    $logo_height = $target_height;
                } else {
                    $logo_width = $width_mm;
                    $logo_height = $height_mm;
                }
                
                // Position logo at left
                $this->Image($this->logo_path, 10, 8, $logo_width, $logo_height);
            }
        }
        
        // Company Info - adjust X based on logo presence
        $info_x = ($logo_width > 0) ? 10 + $logo_width + 5 : 10;
        $this->SetX($info_x);
        
        $this->SetFont('Helvetica', 'B', 16);
        $this->SetTextColor(30, 41, 59); // #1e293b
        $this->Cell(0, 8, $this->business_name, 0, 1);
        
        $this->SetX($info_x);
        $this->SetFont('Helvetica', '', 8);
        $this->SetTextColor(85, 85, 85);
        
        // Address
        $address_lines = explode("\n", $this->business_address);
        foreach ($address_lines as $line) {
            if (trim($line)) {
                $this->SetX($info_x);
                $this->Cell(0, 4, trim($line), 0, 1);
            }
        }
        
        if (!empty($this->shop_phone)) {
            $this->SetX($info_x);
            $this->Cell(0, 4, 'Phone: ' . $this->shop_phone, 0, 1);
        }
        
        if (!empty($this->gst_number)) {
            $this->SetX($info_x);
            $this->Cell(0, 4, 'GST: ' . $this->gst_number, 0, 1);
        }
        
        // Invoice Title (right aligned)
        $this->SetXY(120, 15);
        $this->SetFont('Helvetica', 'B', 14);
        $this->SetTextColor(30, 41, 59);
        $this->Cell(0, 8, 'TAX INVOICE', 0, 1, 'R');
        
        $this->SetX(120);
        $this->SetFont('Helvetica', '', 8);
        $this->SetTextColor(85, 85, 85);
        $this->Cell(0, 4, 'Invoice #: ' . $this->invoice_number, 0, 1, 'R');
        $this->SetX(120);
        $this->Cell(0, 4, 'Date: ' . $this->invoice_date, 0, 1, 'R');
        $this->SetX(120);
        $this->Cell(0, 4, 'Payment: ' . strtoupper($this->payment_method), 0, 1, 'R');
        
        if ($this->service_type == 'service') {
            $this->SetX(120);
            $this->Cell(0, 4, 'Service Type: SERVICE INVOICE', 0, 1, 'R');
        }
        
        $this->Ln(5);
        
        // Customer & Invoice Info boxes
        $this->SetFillColor(250, 250, 250);
        $this->SetDrawColor(229, 231, 235); // #e5e7eb
        
        // Customer box
        $this->Rect(10, $this->GetY(), 90, 35, 'D');
        $this->SetXY(12, $this->GetY() + 2);
        $this->SetFont('Helvetica', 'B', 9);
        $this->SetTextColor(37, 99, 235); // #2563eb
        $this->Cell(0, 5, 'Bill To', 0, 1);
        
        $this->SetFont('Helvetica', '', 8);
        $this->SetTextColor(0, 0, 0);
        $this->SetX(12);
        $this->Cell(0, 4, $this->customer_name ?? 'Walk-in Customer', 0, 1);
        
        if (!empty($this->customer_phone)) {
            $this->SetX(12);
            $this->Cell(0, 4, 'Phone: ' . $this->customer_phone, 0, 1);
        }
        
        // Invoice Details box
        $this->SetXY(110, $this->GetY() - 35);
        $this->Rect(110, $this->GetY(), 90, 35, 'D');
        $this->SetXY(112, $this->GetY() + 2);
        $this->SetFont('Helvetica', 'B', 9);
        $this->SetTextColor(37, 99, 235);
        $this->Cell(0, 5, 'Invoice Details', 0, 1);
        
        $this->SetFont('Helvetica', '', 8);
        $this->SetTextColor(0, 0, 0);
        $this->SetX(112);
        $this->Cell(0, 4, 'Invoice #: ' . $this->invoice_number, 0, 1);
        $this->SetX(112);
        $this->Cell(0, 4, 'Invoice Date: ' . $this->invoice_date, 0, 1);
        $this->SetX(112);
        $this->Cell(0, 4, 'Payment Terms: Immediate Payment', 0, 1);
        
        if ($this->service_type == 'service' && !empty($this->service_date)) {
            $this->SetX(112);
            $this->Cell(0, 4, 'Service Date: ' . $this->service_date, 0, 1);
        }
        
        $this->Ln(20);
    }
    
    function Footer()
    {
        $this->SetY(-20);
        $this->SetFont('Helvetica', 'I', 8);
        $this->SetTextColor(102, 102, 102);
        $this->Cell(0, 10, 'Thank you for your business · This is a system-generated invoice', 0, 0, 'C');
    }
    
    function GenerateContent()
    {
        // Items Table - WITH DISCOUNT COLUMN
        $this->SetFillColor(241, 245, 249); // #f1f5f9
        $this->SetDrawColor(229, 231, 235); // #e5e7eb
        $this->SetLineWidth(0.1);
        
        // Table header - 8 columns including discount
        $col_widths = array(
            8,    // #
            68,   // Description - reduced to accommodate discount
            18,   // HSN
            12,   // Qty
            20,   // Rate
            12,   // DISC% - NEW COLUMN
            15,   // GST%
            25    // Amount
        );
        
        $this->SetFont('Helvetica', 'B', 8);
        $this->SetTextColor(55, 65, 81); // #374151
        
        $this->Cell($col_widths[0], 7, '#', 1, 0, 'C', true);
        $this->Cell($col_widths[1], 7, 'Description', 1, 0, 'L', true);
        $this->Cell($col_widths[2], 7, 'HSN', 1, 0, 'C', true);
        $this->Cell($col_widths[3], 7, 'Qty', 1, 0, 'C', true);
        $this->Cell($col_widths[4], 7, 'Rate', 1, 0, 'R', true);
        $this->Cell($col_widths[5], 7, 'Disc%', 1, 0, 'C', true); // NEW COLUMN
        $this->Cell($col_widths[6], 7, 'GST%', 1, 0, 'C', true);
        $this->Cell($col_widths[7], 7, 'Amount', 1, 1, 'R', true);
        
        // Table content
        $this->SetFont('Helvetica', '', 7);
        $this->SetTextColor(0, 0, 0);
        $fill = false;
        
        if (empty($this->items)) {
            $this->Cell(array_sum($col_widths), 15, 'No items found for this invoice.', 1, 1, 'C');
        } else {
            $i = 0;
            foreach ($this->items as $it) {
                $i++;
                $qty = (float)($it['quantity'] ?? 0);
                $original_price = (float)($it['original_price'] ?? 0);
                $discount_percent = (float)($it['discount_percentage'] ?? 0);
                $item_discount_amt = (float)($it['item_discount'] ?? 0);
                
                // Calculate discount percentage if needed
                if ($discount_percent == 0 && $item_discount_amt > 0 && $original_price > 0) {
                    $discount_percent = round(($item_discount_amt / ($original_price * $qty)) * 100, 1);
                }
                
                $gst_percent = (float)($it['gst_percentage'] ?? 0);
                
                // Calculate amount after discount
                $item_total = $original_price * $qty;
                $discount_amount = $item_discount_amt > 0 ? $item_discount_amt : ($item_total * $discount_percent / 100);
                $amount = $item_total - $discount_amount;
                
                // Description with optional details
                $desc = $it['product_name'];
                if (!empty($it['product_category'])) {
                    $desc .= "\n" . $it['product_category'];
                }
                if (!empty($it['description'])) {
                    $desc .= "\n" . $it['description'];
                }
                if (!empty($it['duration'])) {
                    $desc .= "\nDuration: " . $it['duration'];
                }
                
                // Calculate height based on lines
                $lines = substr_count($desc, "\n") + 1;
                $row_height = max(6, $lines * 3.5);
                
                // Row
                $x = $this->GetX();
                $y = $this->GetY();
                
                // Cell 1: #
                $this->MultiCell($col_widths[0], $row_height, (string)$i, 1, 'C', $fill);
                
                // Cell 2: Description
                $this->SetXY($x + $col_widths[0], $y);
                $this->MultiCell($col_widths[1], 4, $desc, 1, 'L', $fill);
                
                // Get new Y position after MultiCell
                $newY = $this->GetY();
                $row_height = max($row_height, $newY - $y);
                
                // Reset position for remaining cells
                $this->SetXY($x + $col_widths[0] + $col_widths[1], $y);
                
                // Remaining cells
                $this->Cell($col_widths[2], $row_height, $it['hsn_code'] ?? '-', 1, 0, 'C', $fill);
                $this->Cell($col_widths[3], $row_height, fmtNum($qty), 1, 0, 'C', $fill);
                $this->Cell($col_widths[4], $row_height, money($original_price), 1, 0, 'R', $fill);
                $this->Cell($col_widths[5], $row_height, $discount_percent > 0 ? fmtNum($discount_percent) . '%' : '-', 1, 0, 'C', $fill);
                $this->Cell($col_widths[6], $row_height, $gst_percent > 0 ? fmtNum($gst_percent) . '%' : '-', 1, 0, 'C', $fill);
                $this->Cell($col_widths[7], $row_height, money($amount), 1, 1, 'R', $fill);
                
                $fill = !$fill;
            }
        }
        
        $this->Ln(5);
        
        // Bank Details if available
        if (!empty($this->account_number) || !empty($this->bank_name)) {
            $this->SetFont('Helvetica', 'B', 7);
            $this->SetTextColor(37, 99, 235);
            $this->Cell(0, 4, 'Bank Details:', 0, 1);
            
            $this->SetFont('Helvetica', '', 7);
            $this->SetTextColor(80, 80, 80);
            
            $bank_parts = [];
            if (!empty($this->account_name)) $bank_parts[] = $this->account_name;
            if (!empty($this->account_number)) $bank_parts[] = 'A/C: ' . $this->account_number;
            if (!empty($this->bank_name)) $bank_parts[] = $this->bank_name;
            if (!empty($this->branch_name)) $bank_parts[] = $this->branch_name;
            if (!empty($this->ifsc_code)) $bank_parts[] = 'IFSC: ' . $this->ifsc_code;
            
            $this->MultiCell(0, 3, implode(' | ', $bank_parts));
            $this->Ln(3);
        }
        
        // Totals Section
        $total_width = 70;
        $start_x = 210 - 25 - $total_width;
        
        $this->SetXY($start_x, $this->GetY());
        
        // Totals box
        $this->SetFillColor(250, 250, 250);
        $this->SetDrawColor(229, 231, 235);
        $this->Rect($start_x - 2, $this->GetY() - 2, $total_width + 4, 80, 'D');
        
        // Subtotal
        $this->SetFont('Helvetica', '', 8);
        $this->Cell(40, 5, 'Subtotal:', 0, 0, 'L');
        $this->Cell(30, 5, money($this->subtotal), 0, 1, 'R');
        
        // Item Discount
        if ($this->item_discount > 0) {
            $this->Cell(40, 5, 'Item Discount:', 0, 0, 'L');
            $this->Cell(30, 5, '-' . money($this->item_discount), 0, 1, 'R');
        }
        
        // Bill Discount
        if ($this->discount > 0) {
            $this->Cell(40, 5, 'Bill Discount:', 0, 0, 'L');
            $this->Cell(30, 5, '-' . money($this->discount), 0, 1, 'R');
        }
        
        // Total Discount
        $total_discount = $this->item_discount + $this->discount;
        if ($total_discount > 0) {
            $this->SetFont('Helvetica', 'B', 8);
            $this->Cell(40, 5, 'Total Discount:', 0, 0, 'L');
            $this->Cell(30, 5, '-' . money($total_discount), 0, 1, 'R');
            $this->SetFont('Helvetica', '', 8);
        }
        
        // GST
        if ($this->total_gst > 0) {
            $this->Cell(40, 5, 'GST:', 0, 0, 'L');
            $this->Cell(30, 5, money($this->total_gst), 0, 1, 'R');
            
            if ($this->total_cgst > 0 && $this->total_sgst > 0) {
                $this->SetX($start_x + 10);
                $this->Cell(30, 4, 'CGST:', 0, 0, 'L');
                $this->Cell(30, 4, money($this->total_cgst), 0, 1, 'R');
                
                $this->SetX($start_x + 10);
                $this->Cell(30, 4, 'SGST:', 0, 0, 'L');
                $this->Cell(30, 4, money($this->total_sgst), 0, 1, 'R');
            }
        }
        
        // Separator
        $this->Line($start_x, $this->GetY(), $start_x + $total_width, $this->GetY());
        $this->Ln(2);
        
        // Grand Total
        $this->SetFont('Helvetica', 'B', 10);
        $this->SetTextColor(22, 163, 74); // #16a34a
        $this->Cell(40, 6, 'GRAND TOTAL:', 0, 0, 'L');
        $this->Cell(30, 6, money($this->grand_total), 0, 1, 'R');
        
        $this->Ln(2);
        
        // Amount in words
        $this->SetFont('Helvetica', 'I', 7);
        $this->SetTextColor(75, 85, 99); // #4b5563
        $words = numberToWords($this->grand_total);
        $this->MultiCell($total_width, 3, 'Amount in words: ' . $words . ' Only', 0, 'L');
        
        $this->Ln(3);
        
        // Payment Info
        if ($this->cash_received > 0) {
            $this->SetFillColor(240, 253, 244); // #f0fdf4
            $this->SetDrawColor(187, 247, 208); // #bbf7d0
            $this->Rect($start_x - 2, $this->GetY() - 2, $total_width + 4, 28, 'DF');
            
            $this->SetXY($start_x, $this->GetY());
            $this->SetFont('Helvetica', 'B', 8);
            $this->SetTextColor(0, 0, 0);
            $this->Cell(0, 4, 'Payment Details:', 0, 1);
            
            $this->SetFont('Helvetica', '', 8);
            $this->Cell(40, 4, 'Cash Received:', 0, 0, 'L');
            $this->Cell(30, 4, money($this->cash_received), 0, 1, 'R');
            
            $this->Cell(40, 4, 'Change Given:', 0, 0, 'L');
            $this->Cell(30, 4, money($this->change_given), 0, 1, 'R');
            
            if ($this->cash_received >= $this->grand_total) {
                $this->SetTextColor(5, 150, 105);
                $this->Cell(0, 3, '✓ Payment Complete', 0, 1);
            } else {
                $this->SetTextColor(220, 38, 38);
                $pending = $this->grand_total - $this->cash_received;
                $this->Cell(0, 3, '● Payment Pending: ' . money($pending), 0, 1);
            }
            
            $this->Ln(3);
        }
        
        $this->Ln(3);
        
        // Terms & Conditions
        $this->SetFont('Helvetica', 'B', 8);
        $this->SetTextColor(37, 99, 235);
        $this->Cell(0, 4, 'Terms & Conditions', 0, 1);
        
        $this->SetFont('Helvetica', '', 7);
        $this->SetTextColor(0, 0, 0);
        $terms = "1. Goods once sold will not be taken back.\n" .
                 "2. All disputes subject to local jurisdiction only.\n" .
                 "3. Please check all items at the time of purchase.\n" .
                 "4. Warranty as per manufacturer terms and conditions.\n" .
                 "5. This is a computer generated invoice.";
        $this->MultiCell(0, 3, $terms);
        
        $this->Ln(5);
        
        // Signatures with uploaded signature
        $this->SetFont('Helvetica', 'B', 8);
        $this->Cell(80, 4, 'Customer Signature', 0, 0, 'L');
        $this->Cell(80, 4, $this->business_name, 0, 1, 'R');
        
        // Signature image if exists
        if (!empty($this->signature_path) && file_exists($this->signature_path)) {
            $image_info = @getimagesize($this->signature_path);
            if ($image_info) {
                // Calculate signature dimensions
                $width_px = $image_info[0];
                $height_px = $image_info[1];
                
                $width_mm = $width_px * 25.4 / 72;
                $height_mm = $height_px * 25.4 / 72;
                
                // Scale to fit height 8mm
                $target_height = 8;
                if ($height_mm > $target_height) {
                    $scale = $target_height / $height_mm;
                    $display_width = $width_mm * $scale;
                    $display_height = $target_height;
                } else {
                    $display_width = $width_mm;
                    $display_height = $height_mm;
                }
                
                // Position signature
                $sig_x = 120 + (80 - $display_width) / 2;
                $sig_y = $this->GetY() - 10;
                
                $this->Image($this->signature_path, $sig_x, $sig_y, $display_width, $display_height);
            }
        }
        
        $this->Ln(12);
        
        // Signature lines
        $this->SetDrawColor(150, 150, 150);
        $this->SetLineWidth(0.2);
        $this->Line(10, $this->GetY(), 90, $this->GetY());
        $this->Line(120, $this->GetY(), 200, $this->GetY());
        
        $this->SetY($this->GetY() + 2);
        $this->SetFont('Helvetica', '', 7);
        $this->SetTextColor(107, 114, 128);
        $this->Cell(80, 3, '', 0, 0, 'L');
        $this->Cell(80, 3, 'Authorized Signatory', 0, 1, 'R');
        
        // Signatory name if exists
        if (!empty($this->signatory_name)) {
            $this->SetY($this->GetY() + 2);
            $this->SetX(120);
            $this->SetFont('Helvetica', 'B', 7);
            $this->SetTextColor(80, 80, 80);
            $this->Cell(80, 3, $this->signatory_name, 0, 1, 'R');
        }
        
        // Signatory designation if exists
        if (!empty($this->signatory_designation)) {
            $this->SetY($this->GetY() + 2);
            $this->SetX(120);
            $this->SetFont('Helvetica', '', 6);
            $this->SetTextColor(100, 100, 100);
            $this->Cell(80, 3, '(' . $this->signatory_designation . ')', 0, 1, 'R');
        }
    }
}

// ---------- CREATE PDF ----------
// Create PDF instance
$pdf = new ModernInvoicePDF('P', 'mm', 'A4');
$pdf->SetMargins(10, 10, 10);
$pdf->SetAutoPageBreak(true, 30);

// Get business details
$business_name = $invoice['business_name'] ?? $shop_settings['shop_name'] ?? 'ABC COMPANY';
$shop_phone = $shop_settings['shop_phone'] ?? '';

$pdf->setBusinessDetails(
    $business_name,
    $business_address ?: ($shop_settings['shop_addr1'] ?? '') . "\n" . ($shop_settings['shop_addr2'] ?? ''),
    $gst_number ?? $invoice['gst_number'] ?? $shop_settings['shop_gst'] ?? '12ABCDE1234F1Z5',
    $shop_phone,
    $business_logo,
    $business_signature,
    $signatory_name,
    $signatory_designation
);

$pdf->setBankDetails(
    $account_name,
    $account_number,
    $bank_name,
    $branch_name,
    $ifsc_code
);

$service_date = !empty($invoice['service_date']) ? date('d/m/Y', strtotime($invoice['service_date'])) : '';
$pdf->setInvoiceDetails(
    $invoice['invoice_number'] ?? 'INV-' . date('YmdHis'),
    $invoice_date . ' | ' . $invoice_time,
    $invoice['payment_method'] ?? 'CASH',
    $invoice['service_type'] ?? '',
    $service_date
);

$pdf->setCustomerDetails(
    $invoice['customer_name'] ?? 'Walk-in Customer',
    $invoice['customer_phone'] ?? ''
);

$pdf->setItems($items);
$pdf->setTotals($subtotal, $discount, $item_discount, $total_gst, $grand_total, $cash_received, $change_given, $invoice);

$pdf->AddPage();
$pdf->GenerateContent();

// ---------- FORCED DOWNLOAD OUTPUT ----------
$filename = 'Invoice_' . ($invoice['invoice_number'] ?? $invoice_id) . '.pdf';

// Set headers for forced download
header('Content-Type: application/pdf');
header('Content-Disposition: attachment; filename="' . $filename . '"');
header('Cache-Control: private, max-age=0, must-revalidate');
header('Pragma: public');
header('Content-Length: ' . $pdf->Output('S', $filename, true));

// Output PDF for download (FORCED DOWNLOAD)
$pdf->Output('D', $filename);
exit;
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: inv-classic.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation