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/hifi11.in/public_html/finance

Free Space:

10.28 TB

🔧 Quick Actions

✏️ Editing: get_receipt.php

<?php
// get_receipt.php
session_start();
include 'includes/db.php';

// Enable error logging for debugging
ini_set('display_errors', 0);
ini_set('log_errors', 1);
ini_set('error_log', '/home/u329947844/domains/hifi11.in/public_html/finance/error_log');

if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $customer_id = intval($_POST['customer_id']);
    $emi_id = intval($_POST['emi_id']);
    $is_paid = $_POST['is_paid'] === 'true';
    
    // Fetch EMI and customer details
    $sql = "SELECT e.*, c.customer_name, c.customer_number, c.agreement_number, c.finance_id
            FROM emi_schedule e 
            JOIN customers c ON e.customer_id = c.id 
            WHERE e.id = ? AND c.id = ?";
    $stmt = $conn->prepare($sql);
    $stmt->bind_param("ii", $emi_id, $customer_id);
    $stmt->execute();
    $result = $stmt->get_result();
    
    if ($result->num_rows > 0) {
        $row = $result->fetch_assoc();
        
        // Calculate overdue charges if unpaid
        $overdue_charges = 0;
        if (!$is_paid && $row['emi_due_date'] < date('Y-m-d')) {
            $date_diff = (strtotime(date('Y-m-d')) - strtotime($row['emi_due_date'])) / (60 * 60 * 24);
            $date_diff = max(0, $date_diff);
            $overdue_charges = ($row['emi_amount'] / 1000) * 2 * $date_diff;
            $overdue_charges = round($overdue_charges, 2);
        } else {
            $overdue_charges = $row['overdue_charges'];
        }
        
        // Generate PDF receipt
        $pdf_url = generateReceiptPDF($row, $is_paid, $overdue_charges);
        
        // Generate receipt HTML
        echo '
        <div class="receipt-header text-center">
            <h4 class="mb-1">SRI Sabarivasa Finance</h4>
            <p class="mb-1">EMI Receipt</p>
            <p class="mb-0 text-muted">Generated on: ' . date('d M Y, h:i A') . '</p>
        </div>
        
        <div class="receipt-details">
            <div class="row">
                <div class="col-md-6">
                    <p><strong>Customer Name:</strong> ' . htmlspecialchars($row['customer_name']) . '</p>
                    <p><strong>Agreement No:</strong> ' . htmlspecialchars($row['agreement_number']) . '</p>
                    <p><strong>Bill No:</strong> ' . htmlspecialchars($row['emi_bill_number']) . '</p>
                </div>
                <div class="col-md-6">
                    <p><strong>Customer Number:</strong> ' . htmlspecialchars($row['customer_number']) . '</p>';
        
        if ($is_paid) {
            echo '<p><strong>Payment Date:</strong> ' . date('d M Y', strtotime($row['paid_date'])) . '</p>';
        } else {
            echo '<p><strong>Due Date:</strong> ' . date('d M Y', strtotime($row['emi_due_date'])) . '</p>';
        }
                    
        echo '</div>
            </div>
        </div>
        
        <div class="receipt-amounts">
            <div class="amount-row">
                <span>Principal Amount:</span>
                <span>₹' . number_format($row['principal_amount'], 2) . '</span>
            </div>
            <div class="amount-row">
                <span>Interest Amount:</span>
                <span>₹' . number_format($row['interest_amount'], 2) . '</span>
            </div>
            <div class="amount-row">
                <span>EMI Amount:</span>
                <span>₹' . number_format($row['emi_amount'], 2) . '</span>
            </div>';
            
        if ($overdue_charges > 0) {
            echo '
            <div class="amount-row">
                <span>Overdue Charges:</span>
                <span>₹' . number_format($overdue_charges, 2) . '</span>
            </div>';
        }
            
        echo '
            <div class="amount-row amount-total">
                <span>' . ($is_paid ? 'Total Paid:' : 'Total Payable:') . '</span>
                <span>₹' . number_format($row['emi_amount'] + $overdue_charges, 2) . '</span>
            </div>
        </div>';
        
        // Add PDF download section
        if ($pdf_url) {
            echo '
            <div class="receipt-pdf-section mt-4 p-3 bg-light rounded">
                <h6 class="mb-2"><i class="fas fa-file-pdf text-danger me-2"></i>PDF Receipt Generated Successfully</h6>
                <p class="mb-2 text-muted">Download the detailed receipt in PDF format:</p>
                <a href="' . $pdf_url . '" class="btn btn-sm btn-outline-primary me-2" target="_blank">
                    <i class="fas fa-download me-1"></i>Download PDF
                </a>
                <small class="text-muted d-block mt-2">PDF Link: ' . $pdf_url . '</small>
            </div>';
        } 
        echo '
        <div class="receipt-footer mt-4">
            <p class="mb-0">Thank you for your business!</p>
            <p class="mb-0">SRI Sabarivasa Finance</p>
        </div>';
        
        // Store PDF URL and customer number in hidden fields for JavaScript
        echo '
        <div id="receiptData" 
             data-pdf-url="' . ($pdf_url ? $pdf_url : '') . '" 
             data-customer-number="' . htmlspecialchars($row['customer_number']) . '"
             data-customer-name="' . htmlspecialchars($row['customer_name']) . '"
             data-agreement-number="' . htmlspecialchars($row['agreement_number']) . '"
             data-emi-amount="' . number_format($row['emi_amount'], 2) . '"
             data-overdue-charges="' . number_format($overdue_charges, 2) . '"
             data-total-amount="' . number_format($row['emi_amount'] + $overdue_charges, 2) . '"
             data-is-paid="' . ($is_paid ? 'true' : 'false') . '"
             style="display: none;">
        </div>';
        
    } else {
        echo '<div class="alert alert-danger">Receipt data not found.</div>';
    }
    
    $stmt->close();
    mysqli_close($conn);
    exit;
}

// Function to generate PDF receipt
function generateReceiptPDF($row, $is_paid, $overdue_charges) {
    // Check if FPDF is available
    $fpdf_path = $_SERVER['DOCUMENT_ROOT'] . '/finance/includes/fpdf.php';
    
    if (!file_exists($fpdf_path)) {
        error_log("FPDF not found at: " . $fpdf_path);
        return '';
    }
    
    // Include FPDF
    require_once $fpdf_path;
    
    if (!class_exists('FPDF')) {
        error_log("FPDF class not found after inclusion");
        return '';
    }

try {
        // Create PDF instance
        $pdf = new FPDF();
        $pdf->AddPage();
        
        // Set font
        $pdf->SetFont('Arial', 'B', 16);
        
        // Header
        $pdf->Cell(0, 10, 'SRI Sabarivasa Finance', 0, 1, 'C');
        $pdf->SetFont('Arial', '', 12);
        $pdf->Cell(0, 8, 'EMI Receipt', 0, 1, 'C');
        $pdf->Cell(0, 6, 'Date: ' . date('d/m/Y H:i:s'), 0, 1, 'C');
        $pdf->Ln(10);
        
        // Customer Details
        $pdf->SetFont('Arial', 'B', 12);
        $pdf->Cell(0, 8, 'Customer Details:', 0, 1);
        $pdf->SetFont('Arial', '', 11);
        $pdf->Cell(0, 6, 'Name: ' . $row['customer_name'], 0, 1);
        $pdf->Cell(0, 6, 'Agreement No: ' . $row['agreement_number'], 0, 1);
        $pdf->Cell(0, 6, 'Bill No: ' . $row['emi_bill_number'], 0, 1);
        $pdf->Cell(0, 6, 'Phone: ' . $row['customer_number'], 0, 1);
        $pdf->Ln(5);
        
        // Payment Details
        $pdf->SetFont('Arial', 'B', 12);
        $pdf->Cell(0, 8, 'Payment Details:', 0, 1);
        $pdf->SetFont('Arial', '', 11);
        
        if ($is_paid) {
            $pdf->Cell(0, 6, 'Payment Date: ' . date('d/m/Y', strtotime($row['paid_date'])), 0, 1);
        } else {
            $pdf->Cell(0, 6, 'Due Date: ' . date('d/m/Y', strtotime($row['emi_due_date'])), 0, 1);
        }
        $pdf->Ln(5);
        
        // Amount Details
        $pdf->SetFont('Arial', 'B', 12);
        $pdf->Cell(0, 8, 'Amount Breakdown:', 0, 1);
        $pdf->SetFont('Arial', '', 11);
        
        $pdf->Cell(100, 6, 'Principal Amount:', 0, 0);
        $pdf->Cell(0, 6, '₹' . number_format($row['principal_amount'], 2), 0, 1, 'R');
        
        $pdf->Cell(100, 6, 'Interest Amount:', 0, 0);
        $pdf->Cell(0, 6, '₹' . number_format($row['interest_amount'], 2), 0, 1, 'R');
        
        $pdf->Cell(100, 6, 'EMI Amount:', 0, 0);
        $pdf->Cell(0, 6, '₹' . number_format($row['emi_amount'], 2), 0, 1, 'R');
        
        if ($overdue_charges > 0) {
            $pdf->Cell(100, 6, 'Overdue Charges:', 0, 0);
            $pdf->Cell(0, 6, '₹' . number_format($overdue_charges, 2), 0, 1, 'R');
        }
        
        $pdf->SetFont('Arial', 'B', 12);
        $pdf->Cell(100, 8, ($is_paid ? 'Total Paid:' : 'Total Payable:'), 0, 0);
        $pdf->Cell(0, 8, '₹' . number_format($row['emi_amount'] + $overdue_charges, 2), 0, 1, 'R');
        
        $pdf->Ln(10);
        
        // Footer
        $pdf->SetFont('Arial', 'I', 10);
        $pdf->Cell(0, 6, 'Thank you for your business!', 0, 1, 'C');
        $pdf->Cell(0, 6, 'SRI Sabarivasa Finance | Contact: 9500595040', 0, 1, 'C');
        
        // Generate filename
        $filename = 'receipt_' . $row['emi_id'] . '_' . time() . '.pdf';
        $pdf_dir = $_SERVER['DOCUMENT_ROOT'] . '/finance/pdfs/';
        $filepath = $pdf_dir . $filename;
        
        // Ensure directory exists
        if (!file_exists($pdf_dir)) {
            if (!mkdir($pdf_dir, 0755, true)) {
                error_log("Failed to create PDF directory: " . $pdf_dir);
                return '';
            }
        }
        
        // Check if directory is writable
        if (!is_writable($pdf_dir)) {
            error_log("PDF directory not writable: " . $pdf_dir);
            return '';
        }
        
        // Save PDF
        $pdf->Output('F', $filepath);
        
        // Verify PDF was created
        if (!file_exists($filepath)) {
            error_log("PDF file not created: " . $filepath);
            return '';
        }
        
        // Check file size to ensure it's not empty
        if (filesize($filepath) == 0) {
            error_log("PDF file is empty: " . $filepath);
            unlink($filepath); // Remove empty file
            return '';
        }
        
        // Return public URL
        $pdf_url = 'https://hifi11.in/finance/pdfs/' . $filename;
        error_log("PDF generated successfully: " . $pdf_url . " (Size: " . filesize($filepath) . " bytes)");
        
        return $pdf_url;
        
    } catch (Exception $e) {
        error_log("PDF generation exception: " . $e->getMessage());
        return '';
    }
}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: get_receipt.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation