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: inv-daimond.php

<?php
// inv-left-panel-header.php
// Database integrated version with left panel 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); } // 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');

// ---------- PDF Generation ----------
// Create PDF object
class InvoicePDF extends FPDF {
    private $business_name;
    private $business_address;
    private $business_logo;
    private $business_signature;
    private $signatory_name;
    private $signatory_designation;
    private $gst_number;
    private $invoice_number;
    private $invoice_date;
    private $customer_name;
    private $customer_phone;
    private $items;
    private $subtotal;
    private $discount;
    private $item_discount;
    private $total_gst;
    private $grand_total;
    private $shop_settings;
    
    public function setInvoiceData($data) {
        $this->business_name = $data['business_name'] ?? 'ABC COMPANY';
        $this->business_address = $data['business_address'] ?? '';
        $this->business_logo = $data['business_logo'] ?? '';
        $this->business_signature = $data['business_signature'] ?? '';
        $this->signatory_name = $data['signatory_name'] ?? '';
        $this->signatory_designation = $data['signatory_designation'] ?? '';
        $this->gst_number = $data['gst_number'] ?? '';
        $this->invoice_number = $data['invoice_number'] ?? '';
        $this->invoice_date = $data['invoice_date'] ?? '';
        $this->customer_name = $data['customer_name'] ?? '';
        $this->customer_phone = $data['customer_phone'] ?? '';
        $this->items = $data['items'] ?? [];
        $this->subtotal = $data['subtotal'] ?? 0;
        $this->discount = $data['discount'] ?? 0;
        $this->item_discount = $data['item_discount'] ?? 0;
        $this->total_gst = $data['total_gst'] ?? 0;
        $this->grand_total = $data['grand_total'] ?? 0;
        $this->shop_settings = $data['shop_settings'] ?? [];
    }
    
    // Add custom function to format amount without rupee symbol
    function FormatAmount($amount) {
        return number_format($amount, 2);
    }
    
    function Header() {
        // Company Logo - Reduced size from 25 to 20
        if (!empty($this->business_logo) && file_exists($this->business_logo)) {
            $this->Image($this->business_logo, 10, 8, 20);
        }
        
        // Company Name
        $this->SetFont('Arial', 'B', 16);
        $this->SetTextColor(33, 37, 41);
        $this->Cell(0, 8, $this->business_name, 0, 1, 'R');
        
        // Company Address
        $this->SetFont('Arial', '', 9);
        $this->SetTextColor(108, 117, 125);
        $this->Cell(0, 5, $this->business_address, 0, 1, 'R');
        
        // GST Number
        $this->Cell(0, 5, 'GST: ' . $this->gst_number, 0, 1, 'R');
        
        // Line
        $this->SetDrawColor(14, 165, 233);
        $this->SetLineWidth(0.5);
        $this->Line(10, $this->GetY() + 2, 200, $this->GetY() + 2);
        $this->Ln(8);
    }
    
    function Footer() {
        $this->SetY(-15);
        $this->SetFont('Arial', 'I', 8);
        $this->SetTextColor(128);
        $this->Cell(0, 10, 'Page ' . $this->PageNo() . ' / {nb}', 0, 0, 'C');
    }
    
    function ChapterTitle($label) {
        $this->SetFont('Arial', 'B', 12);
        $this->SetFillColor(240, 249, 255);
        $this->SetTextColor(14, 165, 233);
        $this->Cell(0, 10, $label, 0, 1, 'L', true);
        $this->Ln(2);
    }
    
    function AddInvoiceDetails() {
        // Invoice Header
        $this->SetFont('Arial', 'B', 18);
        $this->SetTextColor(14, 165, 233);
        $this->Cell(95, 10, 'TAX INVOICE', 0, 0, 'L');
        
        $this->SetFont('Arial', 'B', 14);
        $this->SetTextColor(33, 37, 41);
        $this->Cell(95, 10, 'INVOICE #' . $this->invoice_number, 0, 1, 'R');
        
        $this->SetFont('Arial', '', 10);
        $this->Cell(95, 6, 'Date: ' . $this->invoice_date, 0, 0, 'L');
        $this->Cell(95, 6, 'Bill To: ' . $this->customer_name, 0, 1, 'R');
        
        if (!empty($this->customer_phone)) {
            $this->Cell(95, 6, '', 0, 0, 'L');
            $this->Cell(95, 6, 'Phone: ' . $this->customer_phone, 0, 1, 'R');
        }
        
        $this->Ln(10);
    }
    
    function AddItemsTable() {
        // Table Header - WITH DISCOUNT COLUMN
        $this->SetFillColor(14, 165, 233);
        $this->SetTextColor(255);
        $this->SetFont('Arial', 'B', 9); // Slightly smaller font to accommodate more columns
        
        // Adjusted column widths to include discount column
        $this->Cell(8, 8, '#', 1, 0, 'C', true);
        $this->Cell(65, 8, 'Description', 1, 0, 'C', true);
        $this->Cell(15, 8, 'HSN', 1, 0, 'C', true);
        $this->Cell(18, 8, 'Qty', 1, 0, 'C', true);
        $this->Cell(22, 8, 'Rate', 1, 0, 'C', true);
        $this->Cell(15, 8, 'Disc%', 1, 0, 'C', true); // NEW DISCOUNT COLUMN
        $this->Cell(15, 8, 'GST%', 1, 0, 'C', true);
        $this->Cell(27, 8, 'Amount', 1, 1, 'C', true);
        
        // Table Content
        $this->SetFillColor(255);
        $this->SetTextColor(0);
        $this->SetFont('Arial', '', 8);
        
        $i = 1;
        $fill = false;
        
        foreach ($this->items as $item) {
            $qty = isset($item['quantity']) ? (float)$item['quantity'] : 0;
            $original_price = (float)($item['original_price'] ?? 0);
            $discount_percent = (float)($item['discount_percentage'] ?? 0);
            $item_discount_amt = (float)($item['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)($item['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;
            
            // Alternate row background
            if ($fill) {
                $this->SetFillColor(245, 245, 245);
            } else {
                $this->SetFillColor(255, 255, 255);
            }
            $fill = !$fill;
            
            $this->Cell(8, 7, $i, 1, 0, 'C', true);
            $this->Cell(65, 7, substr($item['product_name'] ?? '', 0, 35), 1, 0, 'L', true);
            $this->Cell(15, 7, $item['hsn_code'] ?? '-', 1, 0, 'C', true);
            $this->Cell(18, 7, number_format($qty, 2), 1, 0, 'C', true);
            $this->Cell(22, 7, $this->FormatAmount($original_price), 1, 0, 'R', true);
            $this->Cell(15, 7, $discount_percent > 0 ? $discount_percent . '%' : '-', 1, 0, 'C', true);
            $this->Cell(15, 7, $gst_percent > 0 ? $gst_percent . '%' : '-', 1, 0, 'C', true);
            $this->Cell(27, 7, $this->FormatAmount($amount), 1, 1, 'R', true);
            $i++;
        }
        
        $this->Ln(5);
    }
    
    function AddTotals() {
        $this->SetFont('Arial', '', 10);
        $this->SetTextColor(0);
        
        $total_discount = $this->item_discount + $this->discount;
        
        // Subtotal
        $this->Cell(140, 8, 'Subtotal:', 0, 0, 'R');
        $this->Cell(50, 8, $this->FormatAmount($this->subtotal), 0, 1, 'R');
        
        // Item Discount (if any)
        if ($this->item_discount > 0) {
            $this->Cell(140, 8, 'Item Discount:', 0, 0, 'R');
            $this->Cell(50, 8, '-' . $this->FormatAmount($this->item_discount), 0, 1, 'R');
        }
        
        // Bill Discount (if any)
        if ($this->discount > 0) {
            $this->Cell(140, 8, 'Bill Discount:', 0, 0, 'R');
            $this->Cell(50, 8, '-' . $this->FormatAmount($this->discount), 0, 1, 'R');
        }
        
        // Total Discount (if any)
        if ($total_discount > 0) {
            $this->SetFont('Arial', 'B', 10);
            $this->Cell(140, 8, 'Total Discount:', 0, 0, 'R');
            $this->Cell(50, 8, '-' . $this->FormatAmount($total_discount), 0, 1, 'R');
            $this->SetFont('Arial', '', 10);
        }
        
        // GST
        if ($this->total_gst > 0) {
            $this->Cell(140, 8, 'GST Amount:', 0, 0, 'R');
            $this->Cell(50, 8, $this->FormatAmount($this->total_gst), 0, 1, 'R');
        }
        
        // Grand Total
        $this->SetFont('Arial', 'B', 12);
        $this->SetTextColor(14, 165, 233);
        $this->Cell(140, 10, 'GRAND TOTAL:', 0, 0, 'R');
        $this->Cell(50, 10, $this->FormatAmount($this->grand_total), 0, 1, 'R');
        
        $this->Ln(5);
    }
    
    function AddFooterNotes() {
        $this->SetFont('Arial', 'I', 8);
        $this->SetTextColor(108, 117, 125);
        $this->MultiCell(0, 5, "Terms & Conditions:\n1. Goods once sold will not be taken back.\n2. All disputes subject to local jurisdiction only.\n3. Please check all items at the time of purchase.\n4. This is a computer generated invoice.", 0, 'L');
        
        $this->Ln(8);
        
        // ============================================
        // SIGNATURES - EXACTLY LIKE UPLOADED IMAGE
        // ============================================
        $this->SetFont('Arial', '', 9);
        $this->SetTextColor(0);
        
        // Left side - Customer Signature label
        $this->Cell(95, 5, 'Customer Signature', 0, 0, 'L');
        
        // Right side - Company Signature (NO LINES)
        $this->Cell(95, 5, '', 0, 1, 'R');
        
        // Customer signature line (only line on left side)
        $this->SetDrawColor(150, 150, 150);
        $this->SetLineWidth(0.2);
        $this->Line(10, $this->GetY() + 2, 100, $this->GetY() + 2);
        
        // Store current Y position
        $sig_y = $this->GetY();
        
        // 1. SIGNATURE IMAGE (TOP) - like the "M" in your image
        if (!empty($this->business_signature) && file_exists($this->business_signature)) {
            $image_info = @getimagesize($this->business_signature);
            if ($image_info) {
                // Calculate signature dimensions
                $width_px = $image_info[0];
                $height_px = $image_info[1];
                
                $width_mm = $width_px * 30 / 72;
                $height_mm = $height_px * 30 / 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 on right side (centered)
                $sig_x = 120 + (70 - $display_width) / 2;
                $sig_y_pos = $sig_y - $display_height - 4;
                
                $this->Image($this->business_signature, $sig_x, $sig_y_pos, $display_width, $display_height);
            }
        }
        
        // 2. BUSINESS NAME (MIDDLE) - like "Hifill technologies" in your image
        $this->SetY($sig_y + 6);
        $this->SetX(110);
        $this->SetFont('Arial', 'B', 10);
        $this->SetTextColor(14, 165, 233);
        $this->Cell(90, 4, $this->business_name, 0, 1, 'C');
        
        // 3. AUTHORIZED SIGNATORY (BOTTOM)
        $this->SetY($this->GetY() + 2);
        $this->SetX(110);
        $this->SetFont('Arial', '', 9);
        $this->SetTextColor(100, 100, 100);
        $this->Cell(90, 4, 'Authorized Signatory', 0, 1, 'C');
        
        // 4. Signatory name (if exists)
        if (!empty($this->signatory_name)) {
            $this->SetY($this->GetY() + 2);
            $this->SetX(110);
            $this->SetFont('Arial', 'B', 8);
            $this->SetTextColor(80, 80, 80);
            $this->Cell(90, 3, $this->signatory_name, 0, 1, 'C');
        }
        
        // 5. Signatory designation (if exists)
        if (!empty($this->signatory_designation)) {
            $this->SetY($this->GetY() + 2);
            $this->SetX(110);
            $this->SetFont('Arial', '', 7);
            $this->SetTextColor(100, 100, 100);
            $this->Cell(90, 3, '(' . $this->signatory_designation . ')', 0, 1, 'C');
        }
    }
}

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

// Set invoice data
$pdf_data = [
    'business_name' => $invoice['business_name'] ?? $shop_settings['shop_name'] ?? 'ABC COMPANY',
    'business_address' => $business_address ?: ($shop_settings['shop_addr1'] ?? '') . "\n" . ($shop_settings['shop_addr2'] ?? ''),
    'business_logo' => $business_logo,
    'business_signature' => $business_signature,
    'signatory_name' => $signatory_name,
    'signatory_designation' => $signatory_designation,
    'gst_number' => $gst_number ?? $invoice['gst_number'] ?? $shop_settings['shop_gst'] ?? '12ABCDE1234F1Z5',
    'invoice_number' => $invoice['invoice_number'] ?? 'INV-' . date('YmdHis'),
    'invoice_date' => $invoice_date,
    'customer_name' => $invoice['customer_name'] ?? 'Walk-in Customer',
    'customer_phone' => $invoice['customer_phone'] ?? '',
    'items' => $items,
    'subtotal' => $subtotal,
    'discount' => $discount,
    'item_discount' => $item_discount,
    'total_gst' => $total_gst,
    'grand_total' => $grand_total,
    'shop_settings' => $shop_settings
];

$pdf->setInvoiceData($pdf_data);
$pdf->AddPage();

// Add content to PDF
$pdf->AddInvoiceDetails();
$pdf->AddItemsTable();
$pdf->AddTotals();
$pdf->AddFooterNotes();

// ---------- 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-daimond.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation