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/selvaganapathi

Free Space:

10.29 TB

🔧 Quick Actions

✏️ Editing: export-pdf.php

<?php
// Enable error logging and display for debugging
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);
ini_set('log_errors', 1);
ini_set('error_log', '/home/u329947844/domains/hifi11.in/public_html/finance/error_log');

// Start session
session_start();

// Database connection with error handling
include 'includes/db.php';
if (!$conn) {
    die("Database connection failed: " . mysqli_connect_error());
}

// Include FPDF library with error handling
if (!file_exists('includes/fpdf.php')) {
    die("FPDF library not found. Please install it in the 'includes' directory.");
}
require 'includes/fpdf.php';

// Get filter parameters from GET
$finance_id = isset($_GET['finance_id']) ? intval($_GET['finance_id']) : 0;
$selected_month = isset($_GET['month']) ? $_GET['month'] : date('m');
$selected_year = isset($_GET['year']) ? intval($_GET['year']) : date('Y');
$start_date = isset($_GET['start_date']) ? $_GET['start_date'] : '';
$end_date = isset($_GET['end_date']) ? $_GET['end_date'] : '';

// Current date for filename
$current_date = date('Y-m-d_H-i-s');

// Validate filter parameters
if ($selected_month !== 'all' && ($selected_month < 1 || $selected_month > 12)) {
    $selected_month = date('m');
}
if ($selected_year < 2000 || $selected_year > date('Y') + 1) {
    $selected_year = date('Y');
}
if ($start_date && $end_date) {
    $start_date_obj = DateTime::createFromFormat('Y-m-d', $start_date);
    $end_date_obj = DateTime::createFromFormat('Y-m-d', $end_date);
    $max_date = (new DateTime())->modify('+1 year')->format('Y-m-d');
    if (!$start_date_obj || !$end_date_obj || $start_date > $end_date || $end_date > $max_date) {
        $start_date = '';
        $end_date = '';
    }
}

// Function to calculate overdue charges
function calculateOverdueCharges($emi_amount, $due_date, $current_date) {
    if ($due_date >= $current_date) {
        return 0;
    }
    $date_diff = (strtotime($current_date) - strtotime($due_date)) / (60 * 60 * 24);
    $date_diff = max(0, $date_diff);
    $overdue_charges = ($emi_amount / 1000) * 2 * $date_diff;
    return round($overdue_charges, 2);
}

// Fetch EMI data
$sql_emi = "SELECT e.id AS emi_id, c.id AS customer_id, c.customer_name, c.customer_number, c.agreement_number, 
                   e.principal_amount, e.interest_amount, e.emi_amount, e.emi_due_date, 
                   e.status, e.paid_date, e.overdue_charges,
                   l.loan_name, c.finance_id
            FROM emi_schedule e
            JOIN customers c ON e.customer_id = c.id
            JOIN loans l ON c.loan_id = l.id
            WHERE 1=1";
$params_emi = [];
$types_emi = "";
if ($start_date && $end_date) {
    $sql_emi .= " AND e.emi_due_date BETWEEN ? AND ?";
    $params_emi[] = $start_date;
    $params_emi[] = $end_date;
    $types_emi .= "ss";
} elseif ($selected_month === 'all') {
    $sql_emi .= " AND YEAR(e.emi_due_date) = ?";
    $params_emi[] = $selected_year;
    $types_emi .= "i";
} else {
    $sql_emi .= " AND MONTH(e.emi_due_date) = ? AND YEAR(e.emi_due_date) = ?";
    $params_emi[] = $selected_month;
    $params_emi[] = $selected_year;
    $types_emi .= "ii";
}
if ($finance_id > 0) {
    $sql_emi .= " AND c.finance_id = ?";
    $params_emi[] = $finance_id;
    $types_emi .= "i";
}
$sql_emi .= " ORDER BY e.emi_due_date ASC";

$stmt_emi = $conn->prepare($sql_emi);
if (!empty($params_emi)) {
    $stmt_emi->bind_param($types_emi, ...$params_emi);
}
$stmt_emi->execute();
$emi_result = $stmt_emi->get_result();

$emis = [];
$total_principal = 0;
$total_interest = 0;
$total_overdue_paid = 0;
$total_overdue_pending = 0;
$total_collected = 0;
$total_expected = 0;
$total_emi_amount = 0;

if ($emi_result) {
    while ($row = $emi_result->fetch_assoc()) {
        $emi_due_date = $row['emi_due_date'];
        $emi_amount = $row['emi_amount'];
        $calculated_overdue = $row['overdue_charges'] ?: 0;
        if ($row['status'] !== 'paid' && $emi_due_date < date('Y-m-d')) {
            $calculated_overdue = calculateOverdueCharges($emi_amount, $emi_due_date, date('Y-m-d'));
            if ($calculated_overdue != $row['overdue_charges']) {
                $update_sql = "UPDATE emi_schedule SET overdue_charges = ? WHERE id = ?";
                $update_stmt = $conn->prepare($update_sql);
                $update_stmt->bind_param("di", $calculated_overdue, $row['emi_id']);
                $update_stmt->execute();
                $update_stmt->close();
                $row['overdue_charges'] = $calculated_overdue;
            }
        }
        $overdue_charges = $row['overdue_charges'] ?: 0;

$emis[] = $row;
        $total_emi_amount += $emi_amount;
        
        if ($row['status'] === 'paid') {
            $total_principal += $row['principal_amount'];
            $total_interest += $row['interest_amount'];
            $total_collected += $emi_amount + $overdue_charges;
            $total_overdue_paid += $overdue_charges;
        } else {
            $total_principal += $row['principal_amount'];
            $total_interest += $row['interest_amount'];
            $total_overdue_pending += $overdue_charges;
            $total_expected += $emi_amount + $overdue_charges;
        }
    }
    $emi_result->free();
}
$stmt_emi->close();

// Fetch expenses data
$sql_expenses = "SELECT id, remark, amount, expense_date, category, finance_id 
                 FROM expenses 
                 WHERE 1=1";
$params_exp = [];
$types_exp = "";
if ($start_date && $end_date) {
    $sql_expenses .= " AND expense_date BETWEEN ? AND ?";
    $params_exp[] = $start_date;
    $params_exp[] = $end_date;
    $types_exp .= "ss";
} elseif ($selected_month === 'all') {
    $sql_expenses .= " AND YEAR(expense_date) = ?";
    $params_exp[] = $selected_year;
    $types_exp .= "i";
} else {
    $sql_expenses .= " AND MONTH(expense_date) = ? AND YEAR(expense_date) = ?";
    $params_exp[] = $selected_month;
    $params_exp[] = $selected_year;
    $types_exp .= "ii";
}
if ($finance_id > 0) {
    $sql_expenses .= " AND finance_id = ?";
    $params_exp[] = $finance_id;
    $types_exp .= "i";
}
$sql_expenses .= " ORDER BY expense_date ASC";

$stmt_expenses = $conn->prepare($sql_expenses);
if (!empty($params_exp)) {
    $stmt_expenses->bind_param($types_exp, ...$params_exp);
}
$stmt_expenses->execute();
$expenses_result = $stmt_expenses->get_result();

$expenses = [];
$total_expenses = 0;
if ($expenses_result) {
    while ($row = $expenses_result->fetch_assoc()) {
        $expenses[] = $row;
        $total_expenses += $row['amount'];
    }
    $expenses_result->free();
}
$stmt_expenses->close();

// Fetch investments data
$sql_investments = "SELECT id, investment_name, amount, investment_date, category, remark, finance_id 
                    FROM investments 
                    WHERE 1=1";
$params_inv = [];
$types_inv = "";
if ($start_date && $end_date) {
    $sql_investments .= " AND investment_date BETWEEN ? AND ?";
    $params_inv[] = $start_date;
    $params_inv[] = $end_date;
    $types_inv .= "ss";
} elseif ($selected_month === 'all') {
    $sql_investments .= " AND YEAR(investment_date) = ?";
    $params_inv[] = $selected_year;
    $types_inv .= "i";
} else {
    $sql_investments .= " AND MONTH(investment_date) = ? AND YEAR(investment_date) = ?";
    $params_inv[] = $selected_month;
    $params_inv[] = $selected_year;
    $types_inv .= "ii";
}
if ($finance_id > 0) {
    $sql_investments .= " AND finance_id = ?";
    $params_inv[] = $finance_id;
    $types_inv .= "i";
}
$sql_investments .= " ORDER BY investment_date ASC";

$stmt_investments = $conn->prepare($sql_investments);
if (!empty($params_inv)) {
    $stmt_investments->bind_param($types_inv, ...$params_inv);
}
$stmt_investments->execute();
$investments_result = $stmt_investments->get_result();

$investments = [];
$total_investments = 0;
if ($investments_result) {
    while ($row = $investments_result->fetch_assoc()) {
        $investments[] = $row;
        $total_investments += $row['amount'];
    }
    $investments_result->free();
}
$stmt_investments->close();

mysqli_close($conn);

// Create PDF
class PDF extends FPDF {
    function Header() {
        $this->SetFont('Arial', 'B', 16);
        $this->Cell(0, 10, 'Financial Report - ' . date('d M Y'), 0, 1, 'C');
        $this->SetFont('Arial', '', 10);
        $this->Cell(0, 5, 'Generated on: ' . date('d M Y h:i A'), 0, 1, 'C');
        $this->Ln(10);
    }

function Footer() {
        $this->SetY(-15);
        $this->SetFont('Arial', 'I', 8);
        $this->Cell(0, 10, 'Page ' . $this->PageNo() . '/{nb}', 0, 0, 'C');
    }

function ChapterTitle($title) {
        $this->SetFont('Arial', 'B', 12);
        $this->Cell(0, 10, $title, 0, 1, 'L');
        $this->Ln(5);
    }

$pdf = new PDF();
$pdf->AliasNbPages();
$pdf->AddPage();
$pdf->SetFont('Arial', '', 10);

// Summary
$pdf->ChapterTitle('Financial Summary');
$data = [
    ['EMI Collected', '₹' . number_format($total_collected, 2)],
    ['EMI Expected', '₹' . number_format($total_expected, 2)],
    ['Total Expenses', '₹' . number_format($total_expenses, 2)],
    ['Total Investments', '₹' . number_format($total_investments, 2)],
    ['Total Overdue Charges', '₹' . number_format($total_overdue_paid + $total_overdue_pending, 2)],
    ['Total Receivable', '₹' . number_format($total_collected + $total_expected, 2)],
    ['Total EMI Amount', '₹' . number_format($total_emi_amount, 2)]
];
$pdf->DataTable(['Description', 'Amount'], $data);
$pdf->Ln(10);

// EMI Details
if (!empty($emis)) {
    $pdf->ChapterTitle('EMI Schedule Details');
    $header = ['Ag.No', 'Customer Name', 'EMI (₹)', 'Due Date', 'Status'];
    $data = [];
    foreach ($emis as $row) {
        $status = $row['status'] === 'paid' ? 'Paid' : ($row['overdue_charges'] > 0 ? 'Overdue' : 'Pending');
        $data[] = [
            $row['agreement_number'],
            $row['customer_name'],
            '₹' . number_format($row['emi_amount'], 2),
            (new DateTime($row['emi_due_date']))->format('d M Y'),
            $status
        ];
    }
    $pdf->DataTable($header, $data);
    $pdf->Ln(10);
}

// Expenses Details
if (!empty($expenses)) {
    $pdf->ChapterTitle('Expenses Details');
    $header = ['#ID', 'Category', 'Amount (₹)', 'Date'];
    $data = [];
    foreach ($expenses as $row) {
        $data[] = [
            'EXP-' . $row['id'],
            $row['category'],
            '₹' . number_format($row['amount'], 2),
            (new DateTime($row['expense_date']))->format('d M Y')
        ];
    }
    $pdf->DataTable($header, $data);
    $pdf->Ln(10);
}

// Investments Details
if (!empty($investments)) {
    $pdf->ChapterTitle('Investments Details');
    $header = ['#ID', 'Investment Name

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: export-pdf.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation