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

<?php
// inv-wave-singlecolor-white-header-footer.php
// Database integrated invoice with wave design - AUTO DOWNLOAD VERSION
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'];

// ---------- 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);

// Calculate CGST and SGST (assuming equal split)
$cgst_amount = $total_gst / 2;
$sgst_amount = $total_gst / 2;

// ---------- 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 ----------
class InvoicePDF extends FPDF
{
    private $business_name = '';
    private $business_address = '';
    private $gst_number = '';
    private $shop_phone = '';
    private $invoice_number = '';
    private $invoice_date = '';
    private $payment_method = '';
    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) {
        $this->invoice_number = $number;
        $this->invoice_date = $date;
        $this->payment_method = $payment_method;
    }
    
    // Full page header with logo
    function Header()
    {
        // Professional color #2c3e50
        $primary = array(44, 62, 80);
        $accent = array(52, 152, 219);
        
        // Full width header with subtle gradient - increased height for logo
        $this->SetFillColor($primary[0], $primary[1], $primary[2]);
        $this->Rect(0, 0, 210, 45, 'F');
        
        // Logo on left side
        $logo_y = 5;
        if (!empty($this->logo_path) && file_exists($this->logo_path)) {
            // Get image dimensions
            $image_info = @getimagesize($this->logo_path);
            if ($image_info) {
                // Calculate logo dimensions - max height 25mm, max width 45mm
                $logo_width = $image_info[0];
                $logo_height = $image_info[1];
                
                // Convert pixels to mm (assuming 72 DPI)
                $width_mm = $logo_width * 25.4 / 72;
                $height_mm = $logo_height * 25.4 / 72;
                
                // Scale logo to fit in 25mm height
                if ($height_mm > 25) {
                    $scale = 25 / $height_mm;
                    $display_width = $width_mm * $scale;
                    $display_height = 25;
                } else {
                    $display_width = $width_mm;
                    $display_height = $height_mm;
                }
                
                // Ensure width doesn't exceed 45mm
                if ($display_width > 45) {
                    $scale = 45 / $display_width;
                    $display_width = 45;
                    $display_height = $display_height * $scale;
                }
                
                // Position logo
                $this->Image($this->logo_path, 10, $logo_y, $display_width, $display_height);
                
                // Company info (Right side of logo)
                $this->SetY(8);
                $this->SetX(60);
            } else {
                // No valid image, show text
                $this->SetY(8);
                $this->SetX(15);
            }
        } else {
            // No logo, show company info at left
            $this->SetY(8);
            $this->SetX(15);
        }
        
        // Company name
        $this->SetFont('Helvetica', 'B', 16);
        $this->SetTextColor(255, 255, 255);
        $this->Cell(0, 6, $this->business_name, 0, 1);
        
        // Company address
        $this->SetFont('Helvetica', '', 7);
        $this->SetTextColor(220, 220, 220);
        
        // Business address
        $address_lines = explode("\n", $this->business_address);
        foreach ($address_lines as $line) {
            if (trim($line)) {
                if (!empty($this->logo_path)) {
                    $this->SetX(60);
                } else {
                    $this->SetX(15);
                }
                $this->Cell(0, 3, trim($line), 0, 1);
            }
        }
        
        if (!empty($this->shop_phone)) {
            if (!empty($this->logo_path)) {
                $this->SetX(60);
            } else {
                $this->SetX(15);
            }
            $this->Cell(0, 3, 'Phone: ' . $this->shop_phone, 0, 1);
        }
        
        if (!empty($this->gst_number)) {
            if (!empty($this->logo_path)) {
                $this->SetX(60);
            } else {
                $this->SetX(15);
            }
            $this->Cell(0, 3, 'GSTIN: ' . $this->gst_number, 0, 1);
        }
        
        // Invoice title right side
        $this->SetXY(120, 8);
        $this->SetFont('Helvetica', 'B', 20);
        $this->SetTextColor(255, 255, 255);
        $this->Cell(0, 8, 'TAX INVOICE', 0, 1, 'R');
        
        $this->SetFont('Helvetica', '', 8);
        $this->SetTextColor(220, 220, 220);
        
        $this->SetX(120);
        $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');
        
        // Accent line separator
        $this->SetY(43);
        $this->SetDrawColor($accent[0], $accent[1], $accent[2]);
        $this->SetLineWidth(0.8);
        $this->Line(10, 43, 200, 43);
    }
    
    // Footer with signature section matching the image
    function Footer()
    {
        $primary = array(44, 62, 80);
        $accent = array(52, 152, 219);
        
        $this->SetY(-70);
        
        // Bank Details
        if (!empty($this->account_number) || !empty($this->bank_name)) {
            $this->SetFont('Helvetica', 'B', 8);
            $this->SetTextColor($primary[0], $primary[1], $primary[2]);
            $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(2);
        }
        
        // Terms & Conditions
        $this->SetFont('Helvetica', 'B', 8);
        $this->SetTextColor($primary[0], $primary[1], $primary[2]);
        $this->Cell(0, 4, 'Terms & Conditions:', 0, 1);
        $this->SetFont('Helvetica', '', 7);
        $this->SetTextColor(80, 80, 80);
        $terms = "1. Goods once sold will not be taken back.\n" .
                 "2. All disputes subject to local jurisdiction only.\n" .
                 "3. This is a computer generated invoice.";
        $this->MultiCell(0, 3, $terms);
        
        // Signature section - MATCHING THE IMAGE: Signature on top, Business name middle, Authorized Signatory bottom
        $this->SetY(-40);
        
        // Left side - Customer Signature
        $this->SetFont('Helvetica', '', 8);
        $this->SetTextColor(80, 80, 80);
        $this->SetX(20);
        $this->Cell(70, 4, 'Customer Signature', 0, 0, 'L');
        
        // Right side - Company Signature Section - Centered
        $center_x = 155; // Center of right side (120 + 70/2 = 155)
        $right_start_x = 120;
        $right_width = 70;
        
        // 1. SIGNATURE IMAGE (TOP)
        if (!empty($this->signature_path) && file_exists($this->signature_path)) {
            $image_info = @getimagesize($this->signature_path);
            if ($image_info) {
                // Calculate signature dimensions
                $sig_width = $image_info[0];
                $sig_height = $image_info[1];
                
                $width_mm = $sig_width * 25.4 / 72;
                $height_mm = $sig_height * 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;
                }
                
                // Calculate X position to center signature
                $sig_x = $center_x - ($display_width / 2);
                $sig_y = $this->GetY() - 2; // Position at current Y
                
                $this->Image($this->signature_path, $sig_x, $sig_y, $display_width, $display_height);
                
                // Move Y position down after signature
                $this->SetY($sig_y + $display_height + 2);
            }
        } else {
            // If no signature, just move down
            $this->SetY($this->GetY() + 6);
        }
        
        // 2. BUSINESS NAME (MIDDLE)
        $this->SetX($right_start_x);
        $this->SetFont('Helvetica', 'B', 9);
        $this->SetTextColor(44, 62, 80);
        $this->Cell($right_width, 5, $this->business_name, 0, 1, 'C');
        
        // 3. AUTHORIZED SIGNATORY (BOTTOM)
        $this->SetX($right_start_x);
        $this->SetFont('Helvetica', '', 8);
        $this->SetTextColor(100, 100, 100);
        $this->Cell($right_width, 4, 'Authorized Signatory', 0, 1, 'C');
        
        // Signatory Name (if exists)
        if (!empty($this->signatory_name)) {
            $this->SetX($right_start_x);
            $this->SetFont('Helvetica', '', 7);
            $this->SetTextColor(80, 80, 80);
            $this->Cell($right_width, 3, $this->signatory_name, 0, 1, 'C');
        }
        
        // Signatory Designation (if exists)
        if (!empty($this->signatory_designation)) {
            $this->SetX($right_start_x);
            $this->SetFont('Helvetica', '', 6);
            $this->SetTextColor(100, 100, 100);
            $this->Cell($right_width, 3, '(' . $this->signatory_designation . ')', 0, 1, 'C');
        }
        
        // Customer signature line (left side only)
        $line_y = $this->GetY() + 2;
        $this->SetY($line_y);
        $this->SetX(20);
        $this->SetDrawColor(150, 150, 150);
        $this->SetLineWidth(0.2);
        $this->Cell(70, 0, '', 'T', 0, 'L');
        
        // Footer line and page number
        $this->SetY(-5);
        $this->SetDrawColor($accent[0], $accent[1], $accent[2]);
        $this->Line(10, $this->GetY(), 200, $this->GetY());
        
        $this->SetY(-3);
        $this->SetFont('Helvetica', 'I', 6);
        $this->SetTextColor(150, 150, 150);
        $this->Cell(0, 3, 'Page ' . $this->PageNo(), 0, 0, 'R');
    }
    
    // Professional table row with perfect alignment - Updated for 9 columns
    function TableRow($col1, $col2, $col3, $col4, $col5, $col6, $col7, $col8, $col9, $col_widths, $fill = false)
    {
        // Set fill color for alternating rows
        if($fill) {
            $this->SetFillColor(245, 248, 250);
        } else {
            $this->SetFillColor(255, 255, 255);
        }
        
        $x = $this->GetX();
        $y = $this->GetY();
        
        // Store current position
        $startX = $x;
        $startY = $y;
        
        // Calculate height needed for column 2 (description)
        $this->SetFont('Helvetica', '', 7);
        $lines = substr_count($col2, "\n") + 1;
        $desc_height = max(6, $lines * 3.5); // Professional spacing
        
        // Draw all cells with same height for perfect alignment
        $cellHeight = $desc_height;
        
        // Column 1: #
        $this->SetXY($startX, $startY);
        $this->Cell($col_widths[0], $cellHeight, $col1, 1, 0, 'C', $fill);
        
        // Column 2: Description (MultiCell for proper line breaks)
        $this->SetXY($startX + $col_widths[0], $startY);
        $this->MultiCell($col_widths[1], 6, $col2, 1, 'L', $fill);
        
        // Get the height after MultiCell
        $newY = $this->GetY();
        $actualHeight = $newY - $startY;
        
        // If MultiCell created a different height, adjust
        if($actualHeight > $cellHeight) {
            $cellHeight = $actualHeight;
        }
        
        // Reset position for remaining columns
        $this->SetXY($startX + $col_widths[0] + $col_widths[1], $startY);
        
        // Remaining columns - all with same height
        $this->Cell($col_widths[2], $cellHeight, $col3, 1, 0, 'C', $fill);
        $this->Cell($col_widths[3], $cellHeight, $col4, 1, 0, 'C', $fill);
        $this->Cell($col_widths[4], $cellHeight, $col5, 1, 0, 'R', $fill);
        $this->Cell($col_widths[5], $cellHeight, $col6, 1, 0, 'C', $fill);
        $this->Cell($col_widths[6], $cellHeight, $col7, 1, 0, 'C', $fill);
        $this->Cell($col_widths[7], $cellHeight, $col8, 1, 0, 'C', $fill);
        $this->Cell($col_widths[8], $cellHeight, $col9, 1, 1, 'C', $fill);
        
        // Move to next row position
        $this->SetY($startY + $cellHeight);
    }
}

// Create PDF
$pdf = new InvoicePDF('P', 'mm', 'A4');
$pdf->SetMargins(10, 10, 10);

// 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
);

$pdf->setInvoiceDetails(
    $invoice['invoice_number'] ?? 'INV-' . date('YmdHis'),
    $invoice_date . ' | ' . $invoice_time,
    $invoice['payment_method'] ?? 'CASH'
);

$pdf->AddPage();
$pdf->SetAutoPageBreak(true, 70); // Increased for proper footer

// ---------- PDF CONTENT ----------
$pdf->SetY(47);

// Customer & Invoice Details - Professional layout
$pdf->SetFont('Helvetica', 'B', 9);
$pdf->SetTextColor(44, 62, 80);
$pdf->Cell(95, 5, 'BILL TO:', 0, 0);
$pdf->Cell(95, 5, 'INVOICE DETAILS', 0, 1, 'R');

$pdf->SetFont('Helvetica', '', 8);
$pdf->SetTextColor(80, 80, 80);
$pdf->Cell(95, 4, ($invoice['customer_name'] ?? 'Walk-in Customer'), 0, 0);
$pdf->SetFont('Helvetica', '', 8);
$pdf->Cell(95, 4, 'Invoice #: ' . ($invoice['invoice_number'] ?? 'N/A'), 0, 1, 'R');

if (!empty($invoice['customer_phone'])) {
    $pdf->Cell(95, 4, 'Phone: ' . $invoice['customer_phone'], 0, 0);
}

$pdf->Cell(95, 4, 'Date: ' . $invoice_date, 0, 1, 'R');
$pdf->SetY($pdf->GetY() + 5);

// Invoice Items Table - With Discount Column (9 columns)
$total_width = 190; // 210mm - 10mm margins each side
$col_widths = array(
    8,    // # 
    70,   // Description - Reduced to accommodate discount
    18,   // HSN 
    10,   // Qty 
    16,   // Rate 
    12,   // DISC% - NEW DISCOUNT COLUMN
    12,   // GST% 
    12,   // CGST% 
    12    // SGST% 
);

// Verify total width
$calculated_width = array_sum($col_widths);

// Table header
$pdf->SetFillColor(44, 62, 80);
$pdf->SetDrawColor(44, 62, 80);
$pdf->SetLineWidth(0.2);
$pdf->SetFont('Helvetica', 'B', 7);
$pdf->SetTextColor(255, 255, 255);

$pdf->Cell($col_widths[0], 7, '#', 1, 0, 'C', true);
$pdf->Cell($col_widths[1], 7, 'DESCRIPTION', 1, 0, 'L', true);
$pdf->Cell($col_widths[2], 7, 'HSN', 1, 0, 'C', true);
$pdf->Cell($col_widths[3], 7, 'QTY', 1, 0, 'C', true);
$pdf->Cell($col_widths[4], 7, 'RATE', 1, 0, 'C', true);
$pdf->Cell($col_widths[5], 7, 'DISC%', 1, 0, 'C', true); // NEW COLUMN
$pdf->Cell($col_widths[6], 7, 'GST%', 1, 0, 'C', true);
$pdf->Cell($col_widths[7], 7, 'CGST%', 1, 0, 'C', true);
$pdf->Cell($col_widths[8], 7, 'SGST%', 1, 1, 'C', true);

// Table content
$pdf->SetFont('Helvetica', '', 7);
$pdf->SetTextColor(80, 80, 80);
$fill = false;

if (empty($items)) {
    $pdf->Cell(array_sum($col_widths), 15, 'No items found for this invoice.', 1, 1, 'C');
} else {
    $item_count = 0;
    foreach ($items as $it) {
        $item_count++;
        $qty = (float)($it['quantity'] ?? 0);
        $original_price = (float)($it['original_price'] ?? 0);
        $discounted_price = (float)($it['discounted_price'] ?? $original_price);
        $item_discount_amt = (float)($it['item_discount'] ?? 0);
        $discount_percent = (float)($it['discount_percentage'] ?? 0);
        
        // Calculate discount percentage if not set
        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);
        $cgst_percent = $gst_percent / 2;
        $sgst_percent = $gst_percent / 2;
        
        // Prepare description
        $desc = $it['product_name'];
        if (!empty($it['product_category'])) {
            $desc .= " (" . $it['product_category'] . ")";
        }
        if (!empty($it['description'])) {
            $desc .= "\n" . $it['description'];
        }
        if (!empty($it['duration'])) {
            $desc .= "\nDuration: " . $it['duration'];
        }
        if (!empty($it['technician'])) {
            $desc .= "\nTech: " . $it['technician'];
        }
        
        // Use TableRow with perfect alignment
        $pdf->TableRow(
            (string)$item_count,
            $desc,
            $it['hsn_code'] ?? '-',
            fmtNum($qty),
            number_format($original_price, 2),
            $discount_percent > 0 ? fmtNum($discount_percent) . '%' : '-', // Discount column
            $gst_percent > 0 ? fmtNum($gst_percent) . '%' : '-',
            $cgst_percent > 0 ? fmtNum($cgst_percent) . '%' : '-',
            $sgst_percent > 0 ? fmtNum($sgst_percent) . '%' : '-',
            $col_widths,
            $fill
        );
        
        $fill = !$fill;
        
        // Check page break
        if($pdf->GetY() > 200) {
            break;
        }
    }
}

// Leave space after table
$pdf->SetY($pdf->GetY() + 5);

// ---------- TOTALS SECTION - With Discount Breakdown ----------
$table_right_edge = 10 + array_sum($col_widths);
$totals_width = 65;
$total_box_x = $table_right_edge - $totals_width;

$total_y = $pdf->GetY();

// Subtotal
$pdf->SetXY($total_box_x, $total_y);
$pdf->SetFont('Helvetica', '', 9);
$pdf->SetTextColor(80, 80, 80);
$pdf->Cell(45, 6, 'Subtotal:', 0, 0, 'L');
$pdf->SetFont('Helvetica', '', 9);
$pdf->Cell(20, 6, number_format($subtotal, 2), 0, 1, 'R');
$total_y += 7;

// Item Discount (if any)
if ($item_discount > 0) {
    $pdf->SetXY($total_box_x, $total_y);
    $pdf->Cell(45, 6, 'Item Discount:', 0, 0, 'L');
    $pdf->Cell(20, 6, '-' . number_format($item_discount, 2), 0, 1, 'R');
    $total_y += 7;
}

// Bill Discount (if any)
if ($discount > 0) {
    $pdf->SetXY($total_box_x, $total_y);
    $pdf->Cell(45, 6, 'Bill Discount:', 0, 0, 'L');
    $pdf->Cell(20, 6, '-' . number_format($discount, 2), 0, 1, 'R');
    $total_y += 7;
}

// Total Discount (combined)
if ($total_discount > 0) {
    $pdf->SetXY($total_box_x, $total_y);
    $pdf->SetFont('Helvetica', 'B', 9);
    $pdf->Cell(45, 6, 'Total Discount:', 0, 0, 'L');
    $pdf->Cell(20, 6, '-' . number_format($total_discount, 2), 0, 1, 'R');
    $pdf->SetFont('Helvetica', '', 9);
    $total_y += 7;
}

// CGST Amount
if ($cgst_amount > 0) {
    $pdf->SetXY($total_box_x, $total_y);
    $pdf->Cell(45, 6, 'CGST:', 0, 0, 'L');
    $pdf->Cell(20, 6, number_format($cgst_amount, 2), 0, 1, 'R');
    $total_y += 7;
}

// SGST Amount
if ($sgst_amount > 0) {
    $pdf->SetXY($total_box_x, $total_y);
    $pdf->Cell(45, 6, 'SGST:', 0, 0, 'L');
    $pdf->Cell(20, 6, number_format($sgst_amount, 2), 0, 1, 'R');
    $total_y += 7;
}

// Separator line
$pdf->SetXY($total_box_x, $total_y);
$pdf->SetDrawColor(52, 152, 219);
$pdf->SetLineWidth(0.5);
$pdf->Cell($totals_width, 0, '', 'T', 1);
$total_y += 5;

// Grand Total
$pdf->SetXY($total_box_x, $total_y);
$pdf->SetFont('Helvetica', 'B', 11);
$pdf->SetTextColor(44, 62, 80);
$pdf->Cell(45, 8, 'GRAND TOTAL:', 0, 0, 'L');
$pdf->SetFont('Helvetica', 'B', 11);
$pdf->SetTextColor(52, 152, 219);
$pdf->Cell(20, 8, number_format($grand_total, 2), 0, 1, 'R');

// Amount in words - BOLD
$pdf->SetY($total_y + 10);
$pdf->SetFont('Helvetica', 'B', 9);
$pdf->SetTextColor(44, 62, 80);
$words = numberToWords($grand_total);
$pdf->MultiCell(0, 5, 'Amount in words: ' . $words . ' Only', 0, 'L');

$pdf->SetY($pdf->GetY() + 5);

// Payment info if any
if ($cash_received > 0) {
    $pdf->SetFont('Helvetica', '', 8);
    $pdf->SetTextColor(80, 80, 80);
    $pdf->Cell(0, 4, 'Cash Received: ' . number_format($cash_received, 2), 0, 1);
    $pdf->Cell(0, 4, 'Change Given: ' . number_format($change_given, 2), 0, 1);
    
    if ($cash_received >= $grand_total) {
        $pdf->SetFont('Helvetica', 'B', 8);
        $pdf->SetTextColor(39, 174, 96);
        $pdf->Cell(0, 4, '✓ Payment Complete', 0, 1);
    } else {
        $pdf->SetFont('Helvetica', 'B', 8);
        $pdf->SetTextColor(231, 76, 60);
        $pdf->Cell(0, 4, '● Payment Pending: ' . number_format($grand_total - $cash_received, 2), 0, 1);
    }
}

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

// Set headers for forced download (attachment instead of inline)
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)); // Get size for header

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

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: inv-ribbon.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation