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: overallreport.php

<?php
// Start session
session_start();

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

// Database connection
include 'includes/db.php';

// Include FPDF for PDF generation
$fpdf_path = 'includes/fpdf.php';
if (file_exists($fpdf_path) && is_readable($fpdf_path)) {
    require_once $fpdf_path;
} else {
    error_log("FPDF library not found at $fpdf_path");
}

// Get selected finance_id from session
$finance_id = isset($_SESSION['finance_id']) ? intval($_SESSION['finance_id']) : 0;

// Get current month, year, and date
$current_month = date('m');
$current_year = date('Y');
$current_date = date('Y-m-d');

// Handle filter from GET parameters
$selected_month = isset($_GET['month']) && $_GET['month'] !== '' ? intval($_GET['month']) : null;
$selected_year = isset($_GET['year']) && $_GET['year'] !== '' ? intval($_GET['year']) : null;
$start_date = isset($_GET['start_date']) ? $_GET['start_date'] : '';
$end_date = isset($_GET['end_date']) ? $_GET['end_date'] : '';
$filter_active = (!is_null($selected_month) && !is_null($selected_year)) || ($start_date && $end_date);

// Validate selected month and year if provided
if ($selected_month && ($selected_month < 1 || $selected_month > 12)) {
    $selected_month = $current_month;
}
if ($selected_year && ($selected_year < 2000 || $selected_year > date('Y') + 1)) {
    $selected_year = $current_year;
}

// Validate date range
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 = '';
        $filter_active = !is_null($selected_month) && !is_null($selected_year);
    }
}

// Set breadcrumb title based on filter
if ($start_date && $end_date) {
    $breadcrumb_active = "Overall Report for " . (new DateTime($start_date))->format('d M Y') . " - " . (new DateTime($end_date))->format('d M Y');
} elseif ($filter_active) {
    $breadcrumb_active = "Overall Report for " . date('F Y', mktime(0, 0, 0, $selected_month, 1, $selected_year));
} else {
    $breadcrumb_active = "Overall Report (All Time)";
}

// Check if finance is selected
$finance_selected = $finance_id > 0;

// Update overdue charges and status for unpaid/overdue EMIs (only if finance selected)
if ($finance_selected) {
    $update_current_date = date('Y-m-d');
    $fetch_sql = "SELECT id, emi_amount, emi_due_date, status FROM emi_schedule WHERE status != 'paid' AND emi_due_date < ? AND finance_id = ?";
    $stmt_fetch = $conn->prepare($fetch_sql);
    $stmt_fetch->bind_param("si", $update_current_date, $finance_id);
    $stmt_fetch->execute();
    $result = $stmt_fetch->get_result();
    
    while ($row = $result->fetch_assoc()) {
        $emi_id = $row['id'];
        $emi_amount = $row['emi_amount'];
        $due_date = $row['emi_due_date'];
        $date_diff = floor((strtotime($update_current_date) - strtotime($due_date)) / (60 * 60 * 24));
        
        $new_overdue = ($emi_amount / 1000) * 2 * $date_diff;
        $new_status = ($date_diff > 0) ? 'overdue' : 'unpaid';
        if ($new_status === 'unpaid') {
            $new_overdue = 0.00;
        }
        
        $update_sql = "UPDATE emi_schedule SET overdue_charges = ?, status = ? WHERE id = ?";
        $stmt_update = $conn->prepare($update_sql);
        $stmt_update->bind_param("dsi", $new_overdue, $new_status, $emi_id);
        $stmt_update->execute();
        $stmt_update->close();
    }
    
    $result->free();
    $stmt_fetch->close();
}

// Build WHERE clauses with finance filtering
$where_investments = "";
$where_customers = "";
$where_emi = "";
$where_expenses = "";
$where_transactions = "";
$where_initial_investment = "";

$params_investments = [];
$types_investments = "";
$params_customers = [];
$types_customers = "";
$params_emi = [];
$types_emi = "";
$params_expenses = [];
$types_expenses = "";
$params_transactions = [];
$types_transactions = "";
$params_initial_investment = [];
$types_initial_investment = "";

if ($finance_selected) {
    $where_investments = " AND finance_id = ?";
    $where_customers = " AND finance_id = ?";
    $where_emi = " AND e.finance_id = ?";
    $where_expenses = " AND finance_id = ?";
    $where_transactions = " AND finance_id = ?";
    $where_initial_investment = " AND finance_id = ?";
    
    $params_investments[] = $finance_id;
    $types_investments .= "i";
    $params_customers[] = $finance_id;
    $types_customers .= "i";
    $params_emi[] = $finance_id;
    $types_emi .= "i";
    $params_expenses[] = $finance_id;
    $types_expenses .= "i";
    $params_transactions[] = $finance_id;
    $types_transactions .= "i";
    $params_initial_investment[] = $finance_id;
    $types_initial_investment .= "i";
}

// Fetch total initial investment
if ($start_date && $end_date) {
    $sql_initial_investment = "SELECT SUM(amount) AS total_investment FROM initial_investment WHERE investment_date BETWEEN ? AND ?" . $where_initial_investment;
    $stmt_initial_investment = $conn->prepare($sql_initial_investment);
    $stmt_initial_investment->bind_param("ss", $start_date, $end_date);
    $stmt_initial_investment->execute();
    $result_initial_investment = $stmt_initial_investment->get_result();
    $total_investment = $result_initial_investment->fetch_assoc()['total_investment'] ?: 0;
    $stmt_initial_investment->close();
} elseif ($filter_active) {
    $sql_initial_investment = "SELECT SUM(amount) AS total_investment FROM initial_investment WHERE MONTH(investment_date) = ? AND YEAR(investment_date) = ?" . $where_initial_investment;
    $stmt_initial_investment = $conn->prepare($sql_initial_investment);
    $stmt_initial_investment->bind_param("ii", $selected_month, $selected_year);
    $stmt_initial_investment->execute();
    $result_initial_investment = $stmt_initial_investment->get_result();
    $total_investment = $result_initial_investment->fetch_assoc()['total_investment'] ?: 0;
    $stmt_initial_investment->close();
} else {
    $sql_initial_investment = "SELECT SUM(amount) AS total_investment FROM initial_investment WHERE 1=1" . $where_initial_investment;
    $stmt_initial_investment = $conn->prepare($sql_initial_investment);
    $stmt_initial_investment->execute();
    $result_initial_investment = $stmt_initial_investment->get_result();
    $total_investment = $result_initial_investment->fetch_assoc()['total_investment'] ?: 0;
    $stmt_initial_investment->close();
}

// Fetch total investments from investments table
if ($start_date && $end_date) {
    $sql_investments = "SELECT SUM(amount) AS total_investments FROM investments WHERE investment_date BETWEEN ? AND ?" . $where_investments;
    $stmt_investments = $conn->prepare($sql_investments);
    $stmt_investments->bind_param("ss", $start_date, $end_date);
    $stmt_investments->execute();
    $result_investments = $stmt_investments->get_result();
    $total_investments = $result_investments->fetch_assoc()['total_investments'] ?: 0;
    $stmt_investments->close();
} elseif ($filter_active) {
    $sql_investments = "SELECT SUM(amount) AS total_investments FROM investments WHERE MONTH(investment_date) = ? AND YEAR(investment_date) = ?" . $where_investments;
    $stmt_investments = $conn->prepare($sql_investments);
    $stmt_investments->bind_param("ii", $selected_month, $selected_year);
    $stmt_investments->execute();
    $result_investments = $stmt_investments->get_result();
    $total_investments = $result_investments->fetch_assoc()['total_investments'] ?: 0;
    $stmt_investments->close();
} else {
    $sql_investments = "SELECT SUM(amount) AS total_investments FROM investments WHERE 1=1" . $where_investments;
    $stmt_investments = $conn->prepare($sql_investments);
    $stmt_investments->execute();
    $result_investments = $stmt_investments->get_result();
    $total_investments = $result_investments->fetch_assoc()['total_investments'] ?: 0;
    $stmt_investments->close();
}

// Fetch total loan amount issued
if ($start_date && $end_date) {
    $sql_loan = "SELECT SUM(loan_amount) AS total_loan FROM customers WHERE emi_date BETWEEN ? AND ?" . $where_customers;
    $stmt_loan = $conn->prepare($sql_loan);
    $stmt_loan->bind_param("ss", $start_date, $end_date);
    $stmt_loan->execute();
    $result_loan = $stmt_loan->get_result();
    $total_loan = $result_loan->fetch_assoc()['total_loan'] ?: 0;
    $stmt_loan->close();
} elseif ($filter_active) {
    $sql_loan = "SELECT SUM(loan_amount) AS total_loan FROM customers WHERE MONTH(emi_date) = ? AND YEAR(emi_date) = ?" . $where_customers;
    $stmt_loan = $conn->prepare($sql_loan);
    $stmt_loan->bind_param("ii", $selected_month, $selected_year);
    $stmt_loan->execute();
    $result_loan = $stmt_loan->get_result();
    $total_loan = $result_loan->fetch_assoc()['total_loan'] ?: 0;
    $stmt_loan->close();
} else {
    $sql_loan = "SELECT SUM(loan_amount) AS total_loan FROM customers WHERE 1=1" . $where_customers;
    $stmt_loan = $conn->prepare($sql_loan);
    $stmt_loan->execute();
    $result_loan = $stmt_loan->get_result();
    $total_loan = $result_loan->fetch_assoc()['total_loan'] ?: 0;
    $stmt_loan->close();
}

// Fetch total document charge
if ($start_date && $end_date) {
    $sql_doc_charge = "SELECT SUM(document_charge) AS total_doc_charge FROM customers WHERE emi_date BETWEEN ? AND ?" . $where_customers;
    $stmt_doc_charge = $conn->prepare($sql_doc_charge);
    $stmt_doc_charge->bind_param("ss", $start_date, $end_date);
    $stmt_doc_charge->execute();
    $result_doc_charge = $stmt_doc_charge->get_result();
    $total_doc_charge = $result_doc_charge->fetch_assoc()['total_doc_charge'] ?: 0;
    $stmt_doc_charge->close();
} elseif ($filter_active) {
    $sql_doc_charge = "SELECT SUM(document_charge) AS total_doc_charge FROM customers WHERE MONTH(emi_date) = ? AND YEAR(emi_date) = ?" . $where_customers;
    $stmt_doc_charge = $conn->prepare($sql_doc_charge);
    $stmt_doc_charge->bind_param("ii", $selected_month, $selected_year);
    $stmt_doc_charge->execute();
    $result_doc_charge = $stmt_doc_charge->get_result();
    $total_doc_charge = $result_doc_charge->fetch_assoc()['total_doc_charge'] ?: 0;
    $stmt_doc_charge->close();
} else {
    $sql_doc_charge = "SELECT SUM(document_charge) AS total_doc_charge FROM customers WHERE 1=1" . $where_customers;
    $stmt_doc_charge = $conn->prepare($sql_doc_charge);
    $stmt_doc_charge->execute();
    $result_doc_charge = $stmt_doc_charge->get_result();
    $total_doc_charge = $result_doc_charge->fetch_assoc()['total_doc_charge'] ?: 0;
    $stmt_doc_charge->close();
}

// Fetch total EMI and overdue paid
if ($start_date && $end_date) {
    $sql_emi_paid = "SELECT SUM(emi_amount + overdue_charges) AS total_paid, SUM(overdue_charges) AS total_overdue_paid
                     FROM emi_schedule e
                     WHERE status = 'paid' AND paid_date BETWEEN ? AND ?" . $where_emi;
    $stmt_emi_paid = $conn->prepare($sql_emi_paid);
    $stmt_emi_paid->bind_param("ss", $start_date, $end_date);
    $stmt_emi_paid->execute();
    $result_emi_paid = $stmt_emi_paid->get_result();
    $row = $result_emi_paid->fetch_assoc();
    $total_emi_paid = $row['total_paid'] ?: 0;
    $total_overdue_paid = $row['total_overdue_paid'] ?: 0;
    $stmt_emi_paid->close();
} elseif ($filter_active) {
    $sql_emi_paid = "SELECT SUM(emi_amount + overdue_charges) AS total_paid, SUM(overdue_charges) AS total_overdue_paid
                     FROM emi_schedule e
                     WHERE status = 'paid' AND MONTH(paid_date) = ? AND YEAR(paid_date) = ?" . $where_emi;
    $stmt_emi_paid = $conn->prepare($sql_emi_paid);
    $stmt_emi_paid->bind_param("ii", $selected_month, $selected_year);
    $stmt_emi_paid->execute();
    $result_emi_paid = $stmt_emi_paid->get_result();
    $row = $result_emi_paid->fetch_assoc();
    $total_emi_paid = $row['total_paid'] ?: 0;
    $total_overdue_paid = $row['total_overdue_paid'] ?: 0;
    $stmt_emi_paid->close();
} else {
    $sql_emi_paid = "SELECT SUM(emi_amount + overdue_charges) AS total_paid, SUM(overdue_charges) AS total_overdue_paid
                     FROM emi_schedule e
                     WHERE status = 'paid'" . $where_emi;
    $stmt_emi_paid = $conn->prepare($sql_emi_paid);
    $stmt_emi_paid->execute();
    $result_emi_paid = $stmt_emi_paid->get_result();
    $row = $result_emi_paid->fetch_assoc();
    $total_emi_paid = $row['total_paid'] ?: 0;
    $total_overdue_paid = $row['total_overdue_paid'] ?: 0;
    $stmt_emi_paid->close();
}

// Fetch total expenses
if ($start_date && $end_date) {
    $sql_expenses = "SELECT SUM(amount) AS total_expenses FROM expenses WHERE expense_date BETWEEN ? AND ?" . $where_expenses;
    $stmt_expenses = $conn->prepare($sql_expenses);
    $stmt_expenses->bind_param("ss", $start_date, $end_date);
    $stmt_expenses->execute();
    $result_expenses = $stmt_expenses->get_result();
    $total_expenses = $result_expenses->fetch_assoc()['total_expenses'] ?: 0;
    $stmt_expenses->close();
} elseif ($filter_active) {
    $sql_expenses = "SELECT SUM(amount) AS total_expenses FROM expenses WHERE MONTH(expense_date) = ? AND YEAR(expense_date) = ?" . $where_expenses;
    $stmt_expenses = $conn->prepare($sql_expenses);
    $stmt_expenses->bind_param("ii", $selected_month, $selected_year);
    $stmt_expenses->execute();
    $result_expenses = $stmt_expenses->get_result();
    $total_expenses = $result_expenses->fetch_assoc()['total_expenses'] ?: 0;
    $stmt_expenses->close();
} else {
    $sql_expenses = "SELECT SUM(amount) AS total_expenses FROM expenses WHERE 1=1" . $where_expenses;
    $stmt_expenses = $conn->prepare($sql_expenses);
    $stmt_expenses->execute();
    $result_expenses = $stmt_expenses->get_result();
    $total_expenses = $result_expenses->fetch_assoc()['total_expenses'] ?: 0;
    $stmt_expenses->close();
}

// Fetch total overdue amount for non-paid EMIs
$total_overdue = 0;
if ($start_date && $end_date) {
    $sql_overdue = "SELECT overdue_charges FROM emi_schedule e WHERE status != 'paid' AND emi_due_date BETWEEN ? AND ?" . $where_emi;
    $stmt_overdue = $conn->prepare($sql_overdue);
    $stmt_overdue->bind_param("ss", $start_date, $end_date);
    $stmt_overdue->execute();
    $result_overdue = $stmt_overdue->get_result();
    while ($row = $result_overdue->fetch_assoc()) {
        $total_overdue += $row['overdue_charges'];
    }
    $stmt_overdue->close();
} elseif ($filter_active) {
    $sql_overdue = "SELECT overdue_charges FROM emi_schedule e WHERE status != 'paid' AND MONTH(emi_due_date) = ? AND YEAR(emi_due_date) = ?" . $where_emi;
    $stmt_overdue = $conn->prepare($sql_overdue);
    $stmt_overdue->bind_param("ii", $selected_month, $selected_year);
    $stmt_overdue->execute();
    $result_overdue = $stmt_overdue->get_result();
    while ($row = $result_overdue->fetch_assoc()) {
        $total_overdue += $row['overdue_charges'];
    }
    $stmt_overdue->close();
} else {
    $sql_overdue = "SELECT overdue_charges FROM emi_schedule e WHERE status != 'paid'" . $where_emi;
    $stmt_overdue = $conn->prepare($sql_overdue);
    $stmt_overdue->execute();
    $result_overdue = $stmt_overdue->get_result();
    while ($row = $result_overdue->fetch_assoc()) {
        $total_overdue += $row['overdue_charges'];
    }
    $stmt_overdue->close();
}

// Calculate DYNAMIC current balance
$current_balance = $total_investment + $total_emi_paid + $total_doc_charge + $total_investments - $total_loan - $total_expenses;

// Calculate profit/loss
$profit_loss = $total_emi_paid - $total_expenses;

// Fetch transaction history
if ($start_date && $end_date) {
    $sql_transactions = "SELECT transaction_type, amount, balance, description, transaction_date
                         FROM total_balance
                         WHERE transaction_date BETWEEN ? AND ?" . $where_transactions . "
                         ORDER BY transaction_date DESC";
    $stmt_transactions = $conn->prepare($sql_transactions);
    $transactions = false;
    if ($stmt_transactions) {
        $params = array_merge([$start_date, $end_date], $params_transactions);
        $types = "ss" . $types_transactions;
        $stmt_transactions->bind_param($types, ...$params);
        $stmt_transactions->execute();
        $transactions = $stmt_transactions->get_result();
    } else {
        error_log("Error preparing transactions query: " . $conn->error);
    }
} elseif ($filter_active) {
    $sql_transactions = "SELECT transaction_type, amount, balance, description, transaction_date
                         FROM total_balance
                         WHERE MONTH(transaction_date) = ? AND YEAR(transaction_date) = ?" . $where_transactions . "
                         ORDER BY transaction_date DESC";
    $stmt_transactions = $conn->prepare($sql_transactions);
    $transactions = false;
    if ($stmt_transactions) {
        $params = array_merge([$selected_month, $selected_year], $params_transactions);
        $types = "ii" . $types_transactions;
        $stmt_transactions->bind_param($types, ...$params);
        $stmt_transactions->execute();
        $transactions = $stmt_transactions->get_result();
    } else {
        error_log("Error preparing transactions query: " . $conn->error);
    }
} else {
    $sql_transactions = "SELECT transaction_type, amount, balance, description, transaction_date
                         FROM total_balance
                         WHERE 1=1" . $where_transactions . "
                         ORDER BY transaction_date DESC";
    $stmt_transactions = $conn->prepare($sql_transactions);
    $transactions = false;
    if ($stmt_transactions) {
        if (!empty($params_transactions)) {
            $stmt_transactions->bind_param($types_transactions, ...$params_transactions);
        }
        $stmt_transactions->execute();
        $transactions = $stmt_transactions->get_result();
    } else {
        error_log("Error preparing transactions query: " . $conn->error);
    }
}

// Fetch new customers count
if ($start_date && $end_date) {
    $sql_new_customers = "SELECT COUNT(id) AS new_customers FROM customers WHERE emi_date BETWEEN ? AND ?" . $where_customers;
    $stmt_new_customers = $conn->prepare($sql_new_customers);
    $new_customers = 0;
    if ($stmt_new_customers) {
        $params = array_merge([$start_date, $end_date], $params_customers);
        $types = "ss" . $types_customers;
        $stmt_new_customers->bind_param($types, ...$params);
        $stmt_new_customers->execute();
        $result_new_customers = $stmt_new_customers->get_result();
        $new_customers = $result_new_customers->fetch_assoc()['new_customers'] ?: 0;
        $stmt_new_customers->close();
    } else {
        error_log("Error preparing new_customers query: " . $conn->error);
    }
} elseif ($filter_active) {
    $sql_new_customers = "SELECT COUNT(id) AS new_customers FROM customers WHERE MONTH(emi_date) = ? AND YEAR(emi_date) = ?" . $where_customers;
    $stmt_new_customers = $conn->prepare($sql_new_customers);
    $new_customers = 0;
    if ($stmt_new_customers) {
        $params = array_merge([$selected_month, $selected_year], $params_customers);
        $types = "ii" . $types_customers;
        $stmt_new_customers->bind_param($types, ...$params);
        $stmt_new_customers->execute();
        $result_new_customers = $stmt_new_customers->get_result();
        $new_customers = $result_new_customers->fetch_assoc()['new_customers'] ?: 0;
        $stmt_new_customers->close();
    } else {
        error_log("Error preparing new_customers query: " . $conn->error);
    }
} else {
    $sql_new_customers = "SELECT COUNT(id) AS new_customers FROM customers WHERE 1=1" . $where_customers;
    $stmt_new_customers = $conn->prepare($sql_new_customers);
    $new_customers = 0;
    if ($stmt_new_customers) {
        if (!empty($params_customers)) {
            $stmt_new_customers->bind_param($types_customers, ...$params_customers);
        }
        $stmt_new_customers->execute();
        $result_new_customers = $stmt_new_customers->get_result();
        $new_customers = $result_new_customers->fetch_assoc()['new_customers'] ?: 0;
        $stmt_new_customers->close();
    } else {
        error_log("Error preparing new_customers query: " . $conn->error);
    }
}

// Fetch EMI collection list
if ($start_date && $end_date) {
    $sql_emi_list = "SELECT e.emi_amount, e.overdue_charges, e.paid_date, c.customer_name
                     FROM emi_schedule e
                     JOIN customers c ON e.customer_id = c.id
                     WHERE e.status = 'paid' AND e.paid_date BETWEEN ? AND ?" . $where_emi . "
                     ORDER BY e.paid_date DESC";
    $stmt_emi_list = $conn->prepare($sql_emi_list);
    $emi_list = [];
    if ($stmt_emi_list) {
        $params = array_merge([$start_date, $end_date], $params_emi);
        $types = "ss" . $types_emi;
        $stmt_emi_list->bind_param($types, ...$params);
        $stmt_emi_list->execute();
        $result_emi_list = $stmt_emi_list->get_result();
        while ($row = $result_emi_list->fetch_assoc()) {
            $emi_list[] = $row;
        }
        $stmt_emi_list->close();
    } else {
        error_log("Error preparing emi_list query: " . $conn->error);
    }
} elseif ($filter_active) {
    $sql_emi_list = "SELECT e.emi_amount, e.overdue_charges, e.paid_date, c.customer_name
                     FROM emi_schedule e
                     JOIN customers c ON e.customer_id = c.id
                     WHERE e.status = 'paid' AND MONTH(e.paid_date) = ? AND YEAR(e.paid_date) = ?" . $where_emi . "
                     ORDER BY e.paid_date DESC";
    $stmt_emi_list = $conn->prepare($sql_emi_list);
    $emi_list = [];
    if ($stmt_emi_list) {
        $params = array_merge([$selected_month, $selected_year], $params_emi);
        $types = "ii" . $types_emi;
        $stmt_emi_list->bind_param($types, ...$params);
        $stmt_emi_list->execute();
        $result_emi_list = $stmt_emi_list->get_result();
        while ($row = $result_emi_list->fetch_assoc()) {
            $emi_list[] = $row;
        }
        $stmt_emi_list->close();
    } else {
        error_log("Error preparing emi_list query: " . $conn->error);
    }
} else {
    $sql_emi_list = "SELECT e.emi_amount, e.overdue_charges, e.paid_date, c.customer_name
                     FROM emi_schedule e
                     JOIN customers c ON e.customer_id = c.id
                     WHERE e.status = 'paid'" . $where_emi . "
                     ORDER BY e.paid_date DESC";
    $stmt_emi_list = $conn->prepare($sql_emi_list);
    $emi_list = [];
    if ($stmt_emi_list) {
        if (!empty($params_emi)) {
            $stmt_emi_list->bind_param($types_emi, ...$params_emi);
        }
        $stmt_emi_list->execute();
        $result_emi_list = $stmt_emi_list->get_result();
        while ($row = $result_emi_list->fetch_assoc()) {
            $emi_list[] = $row;
        }
        $stmt_emi_list->close();
    } else {
        error_log("Error preparing emi_list query: " . $conn->error);
    }
}

// Fetch new customers list
if ($start_date && $end_date) {
    $sql_new_customers_list = "SELECT customer_name, customer_number, loan_amount, emi_date
                               FROM customers
                               WHERE emi_date BETWEEN ? AND ?" . $where_customers . "
                               ORDER BY emi_date DESC";
    $stmt_new_customers_list = $conn->prepare($sql_new_customers_list);
    $new_customers_list = [];
    if ($stmt_new_customers_list) {
        $params = array_merge([$start_date, $end_date], $params_customers);
        $types = "ss" . $types_customers;
        $stmt_new_customers_list->bind_param($types, ...$params);
        $stmt_new_customers_list->execute();
        $result_new_customers_list = $stmt_new_customers_list->get_result();
        while ($row = $result_new_customers_list->fetch_assoc()) {
            $new_customers_list[] = $row;
        }
        $stmt_new_customers_list->close();
    } else {
        error_log("Error preparing new_customers_list query: " . $conn->error);
    }
} elseif ($filter_active) {
    $sql_new_customers_list = "SELECT customer_name, customer_number, loan_amount, emi_date
                               FROM customers
                               WHERE MONTH(emi_date) = ? AND YEAR(emi_date) = ?" . $where_customers . "
                               ORDER BY emi_date DESC";
    $stmt_new_customers_list = $conn->prepare($sql_new_customers_list);
    $new_customers_list = [];
    if ($stmt_new_customers_list) {
        $params = array_merge([$selected_month, $selected_year], $params_customers);
        $types = "ii" . $types_customers;
        $stmt_new_customers_list->bind_param($types, ...$params);
        $stmt_new_customers_list->execute();
        $result_new_customers_list = $stmt_new_customers_list->get_result();
        while ($row = $result_new_customers_list->fetch_assoc()) {
            $new_customers_list[] = $row;
        }
        $stmt_new_customers_list->close();
    } else {
        error_log("Error preparing new_customers_list query: " . $conn->error);
    }
} else {
    $sql_new_customers_list = "SELECT customer_name, customer_number, loan_amount, emi_date
                               FROM customers
                               WHERE 1=1" . $where_customers . "
                               ORDER BY emi_date DESC";
    $stmt_new_customers_list = $conn->prepare($sql_new_customers_list);
    $new_customers_list = [];
    if ($stmt_new_customers_list) {
        if (!empty($params_customers)) {
            $stmt_new_customers_list->bind_param($types_customers, ...$params_customers);
        }
        $stmt_new_customers_list->execute();
        $result_new_customers_list = $stmt_new_customers_list->get_result();
        while ($row = $result_new_customers_list->fetch_assoc()) {
            $new_customers_list[] = $row;
        }
        $stmt_new_customers_list->close();
    } else {
        error_log("Error preparing new_customers_list query: " . $conn->error);
    }
}

// Fetch principal and interest collection
$total_principal_collection = 0;
$total_interest_collection = 0;
if ($start_date && $end_date) {
    $sql_principal_interest = "SELECT SUM(principal_amount) AS total_principal, SUM(interest_amount) AS total_interest
                               FROM emi_schedule
                               WHERE status = 'paid' AND paid_date BETWEEN ? AND ?" . $where_emi;
    $stmt_principal_interest = $conn->prepare($sql_principal_interest);
    $stmt_principal_interest->bind_param("ss", $start_date, $end_date);
    $stmt_principal_interest->execute();
    $result_principal_interest = $stmt_principal_interest->get_result();
    $row = $result_principal_interest->fetch_assoc();
    $total_principal_collection = $row['total_principal'] ?: 0;
    $total_interest_collection = $row['total_interest'] ?: 0;
    $stmt_principal_interest->close();
} elseif ($filter_active) {
    $sql_principal_interest = "SELECT SUM(principal_amount) AS total_principal, SUM(interest_amount) AS total_interest
                               FROM emi_schedule
                               WHERE status = 'paid' AND MONTH(paid_date) = ? AND YEAR(paid_date) = ?" . $where_emi;
    $stmt_principal_interest = $conn->prepare($sql_principal_interest);
    $stmt_principal_interest->bind_param("ii", $selected_month, $selected_year);
    $stmt_principal_interest->execute();
    $result_principal_interest = $stmt_principal_interest->get_result();
    $row = $result_principal_interest->fetch_assoc();
    $total_principal_collection = $row['total_principal'] ?: 0;
    $total_interest_collection = $row['total_interest'] ?: 0;
    $stmt_principal_interest->close();
} else {
    $sql_principal_interest = "SELECT SUM(principal_amount) AS total_principal, SUM(interest_amount) AS total_interest
                               FROM emi_schedule
                               WHERE status = 'paid'" . $where_emi;
    $stmt_principal_interest = $conn->prepare($sql_principal_interest);
    $stmt_principal_interest->execute();
    $result_principal_interest = $stmt_principal_interest->get_result();
    $row = $result_principal_interest->fetch_assoc();
    $total_principal_collection = $row['total_principal'] ?: 0;
    $total_interest_collection = $row['total_interest'] ?: 0;
    $stmt_principal_interest->close();
}

// Fetch pending amount (total expected EMI - collected EMI)
$pending_amount = $total_overdue;
// Handle PDF export
if (isset($_GET['export']) && $_GET['export'] == 'pdf') {
    if (file_exists($fpdf_path) && is_readable($fpdf_path)) {
        // Create PDF object
        $pdf = new FPDF();
        $pdf->AddPage();
        $pdf->SetFont('Arial', 'B', 16);

// Title in English and Tamil
        $pdf->Cell(0, 10, 'Profit & Loss Report - ' . $breadcrumb_active, 0, 1, 'C');
        $pdf->SetFont('Arial', '', 12);
        $pdf->Cell(0, 10, ' (English)', 0, 1, 'C');
        $pdf->Ln(5);

// Summary Section in English
        $pdf->SetFont('Arial', 'B', 12);
        $pdf->Cell(0, 10, 'Summary', 0, 1);
        $pdf->SetFont('Arial', '', 10);
        $pdf->Cell(0, 7, 'Total Investment: Rs ' . number_format($total_investment, 2), 0, 1);
        $pdf->Cell(0, 7, 'Total Loan Issued: Rs ' . number_format($total_loan, 2), 0, 1);
        $pdf->Cell(0, 7, 'Total EMI Received: Rs ' . number_format($total_emi_paid, 2), 0, 1);
        $pdf->Cell(0, 7, 'Total Overdue Paid: Rs ' . number_format($total_overdue_paid, 2), 0, 1);
        $pdf->Cell(0, 7, 'Total Document Charges: Rs ' . number_format($total_doc_charge, 2), 0, 1);
        $pdf->Cell(0, 7, 'Total Expenses: Rs ' . number_format($total_expenses, 2), 0, 1);
        $pdf->Cell(0, 7, 'Profit/Loss: Rs ' . number_format($profit_loss, 2), 0, 1);
        $pdf->Cell(0, 7, 'Current Balance: Rs ' . number_format($current_balance, 2), 0, 1);
        $pdf->Cell(0, 7, 'Pending Amount: Rs ' . number_format($pending_amount, 2), 0, 1);
        $pdf->Cell(0, 7, 'New Customers: ' . $new_customers, 0, 1);
        $pdf->Cell(0, 7, 'Principal Collection: Rs ' . number_format($total_principal_collection, 2), 0, 1);
        $pdf->Cell(0, 7, 'Interest Collection: Rs ' . number_format($total_interest_collection, 2), 0, 1);
        $pdf->Ln(10);

// EMI Collection List in English
        $pdf->SetFont('Arial', 'B', 12);
        $pdf->Cell(0, 10, 'EMI Collection List', 0, 1);
        $pdf->SetFont('Arial', '', 10);
        $pdf->Cell(80, 7, 'Customer Name', 1);
        $pdf->Cell(40, 7, 'EMI Amount', 1);
        $pdf->Cell(40, 7, 'Overdue Charges', 1);
        $pdf->Cell(30, 7, 'Paid Date', 1);
        $pdf->Ln();
        foreach ($emi_list as $emi) {
            $pdf->Cell(80, 7, $emi['customer_name'], 1);
            $pdf->Cell(40, 7, 'Rs ' . number_format($emi['emi_amount'], 2), 1);
            $pdf->Cell(40, 7, 'Rs ' . number_format($emi['overdue_charges'], 2), 1);
            $pdf->Cell(30, 7, date('d M Y', strtotime($emi['paid_date'])), 1);
            $pdf->Ln();
        }
        $pdf->Ln(10);

// New Customers List in English
        $pdf->SetFont('Arial', 'B', 12);
        $pdf->Cell(0, 10, 'New Customers List', 0, 1);
        $pdf->SetFont('Arial', '', 10);
        $pdf->Cell(80, 7, 'Customer Name', 1);
        $pdf->Cell(40, 7, 'Phone Number', 1);
        $pdf->Cell(40, 7, 'Loan Amount', 1);
        $pdf->Cell(30, 7, 'EMI Date', 1);
        $pdf->Ln();
        foreach ($new_customers_list as $cust) {
            $pdf->Cell(80, 7, $cust['customer_name'], 1);
            $pdf->Cell(40, 7, $cust['customer_number'], 1);
            $pdf->Cell(40, 7, 'Rs ' . number_format($cust['loan_amount'], 2), 1);
            $pdf->Cell(30, 7, date('d M Y', strtotime($cust['emi_date'])), 1);
            $pdf->Ln();
        }
        $pdf->Ln(10);

// Expenses List
        $pdf->SetFont('Arial', 'B', 12);
        $pdf->Cell(0, 10, 'Expenses List', 0, 1);
        $pdf->SetFont('Arial', '', 10);
        $pdf->Cell(80, 7, 'Description', 1);
        $pdf->Cell(40, 7, 'Amount', 1);
        $pdf->Cell(30, 7, 'Date', 1);
        $pdf->Ln();
        foreach ($expenses_list as $exp) {
            $pdf->Cell(80, 7, $exp['description'], 1);
            $pdf->Cell(40, 7, 'Rs ' . number_format($exp['amount'], 2), 1);
            $pdf->Cell(30, 7, date('d M Y', strtotime($exp['expense_date'])), 1);
            $pdf->Ln();
        }
        $pdf->Ln(10);

// Investments List
        $pdf->SetFont('Arial', 'B', 12);
        $pdf->Cell(0, 10, 'Investments List', 0, 1);
        $pdf->SetFont('Arial', '', 10);
        $pdf->Cell(80, 7, 'Name', 1);
        $pdf->Cell(40, 7, 'Amount', 1);
        $pdf->Cell(30, 7, 'Date', 1);
        $pdf->Ln();
        foreach ($investments_list as $inv) {
            $pdf->Cell(80, 7, $inv['name'], 1);
            $pdf->Cell(40, 7, 'Rs ' . number_format($inv['amount'], 2), 1);
            $pdf->Cell(30, 7, date('d M Y', strtotime($inv['investment_date'])), 1);
            $pdf->Ln();
        }
        $pdf->Ln(10);

// Tamil Version
        $pdf->AddPage();
        $pdf->SetFont('Arial', 'B', 16);
        $pdf->Cell(0, 10, iconv('UTF-8', 'windows-1252', 'இலாபம் & இழப்பு அறிக்கை - ' . $breadcrumb_active), 0, 1, 'C');
        $pdf->SetFont('Arial', '', 12);
        $pdf->Cell(0, 10, iconv('UTF-8', 'windows-1252', ' (தமிழ்)'), 0, 1, 'C');
        $pdf->Ln(5);

// Summary in Tamil
        $pdf->SetFont('Arial', 'B', 12);
        $pdf->Cell(0, 10, iconv('UTF-8', 'windows-1252', 'சுருக்கம்'), 0, 1);
        $pdf->SetFont('Arial', '', 10);
        $pdf->Cell(0, 7, iconv('UTF-8', 'windows-1252', 'மொத்த முதலீடு: ரூ ' . number_format($total_investment, 2)), 0, 1);
        $pdf->Cell(0, 7, iconv('UTF-8', 'windows-1252', 'மொத்த கடன் வழங்கப்பட்டது: ரூ ' . number_format($total_loan, 2)), 0, 1);
        $pdf->Cell(0, 7, iconv('UTF-8', 'windows-1252', 'மொத்த EMI பெறப்பட்டது: ரூ ' . number_format($total_emi_paid, 2)), 0, 1);
        $pdf->Cell(0, 7, iconv('UTF-8', 'windows-1252', 'மொத்த தாமதக் கட்டணம் பெறப்பட்டது: ரூ ' . number_format($total_overdue_paid, 2)), 0, 1);
        $pdf->Cell(0, 7, iconv('UTF-8', 'windows-1252', 'மொத்த ஆவண கட்டணம்: ரூ ' . number_format($total_doc_charge, 2)), 0, 1);
        $pdf->Cell(0, 7, iconv('UTF-8', 'windows-1252', 'மொத்த செலவுகள்: ரூ ' . number_format($total_expenses, 2)), 0, 1);
        $pdf->Cell(0, 7, iconv('UTF-8', 'windows-1252', 'இலாபம்/இழப்பு: ரூ ' . number_format($profit_loss, 2)), 0, 1);
        $pdf->Cell(0, 7, iconv('UTF-8', 'windows-1252', 'நடப்பு இருப்பு: ரூ ' . number_format($current_balance, 2)), 0, 1);
        $pdf->Cell(0, 7, iconv('UTF-8', 'windows-1252', 'பாக்கி தொகை: ரூ ' . number_format($pending_amount, 2)), 0, 1);
        $pdf->Cell(0, 7, iconv('UTF-8', 'windows-1252', 'புதிய வாடிக்கையாளர்கள்: ' . $new_customers), 0, 1);
        $pdf->Cell(0, 7, iconv('UTF-8', 'windows-1252', 'முதலீட்டு சேகரிப்பு: ரூ ' . number_format($total_principal_collection, 2)), 0, 1);
        $pdf->Cell(0, 7, iconv('UTF-8', 'windows-1252', 'வட்டி சேகரிப்பு: ரூ ' . number_format($total_interest_collection, 2)), 0, 1);
        $pdf->Ln(10);

// EMI Collection List in Tamil
        $pdf->SetFont('Arial', 'B', 12);
        $pdf->Cell(0, 10, iconv('UTF-8', 'windows-1252', 'EMI சேகரிப்பு பட்டியல்'), 0, 1);
        $pdf->SetFont('Arial', '', 10);
        $pdf->Cell(80, 7, iconv('UTF-8', 'windows-1252', 'வாடிக்கையாளர் பெயர்'), 1);
        $pdf->Cell(40, 7, iconv('UTF-8', 'windows-1252', 'EMI தொகை'), 1);
        $pdf->Cell(40, 7, iconv('UTF-8', 'windows-1252', 'தாமதக் கட்டணம்'), 1);
        $pdf->Cell(30, 7, iconv('UTF-8', 'windows-1252', 'செலுத்தப்பட்ட தேதி'), 1);
        $pdf->Ln();
        foreach ($emi_list as $emi) {
            $pdf->Cell(80, 7, iconv('UTF-8', 'windows-1252', $emi['customer_name']), 1);
            $pdf->Cell(40, 7, iconv('UTF-8', 'windows-1252', 'ரூ ' . number_format($emi['emi_amount'], 2)), 1);
            $pdf->Cell(40, 7, iconv('UTF-8', 'windows-1252', 'ரூ ' . number_format($emi['overdue_charges'], 2)), 1);
            $pdf->Cell(30, 7, date('d M Y', strtotime($emi['paid_date'])), 1);
            $pdf->Ln();
        }
        $pdf->Ln(10);

// New Customers List in Tamil
        $pdf->SetFont('Arial', 'B', 12);
        $pdf->Cell(0, 10, iconv('UTF-8', 'windows-1252', 'புதிய வாடிக்கையாளர்கள் பட்டியல்'), 0, 1);
        $pdf->SetFont('Arial', '', 10);
        $pdf->Cell(80, 7, iconv('UTF-8', 'windows-1252', 'வாடிக்கையாளர் பெயர்'), 1);
        $pdf->Cell(40, 7, iconv('UTF-8', 'windows-1252', 'தொலைபேசி எண்'), 1);
        $pdf->Cell(40, 7, iconv('UTF-8', 'windows-1252', 'கடன் தொகை'), 1);
        $pdf->Cell(30, 7, iconv('UTF-8', 'windows-1252', 'EMI தேதி'), 1);
        $pdf->Ln();
        foreach ($new_customers_list as $cust) {
            $pdf->Cell(80, 7, iconv('UTF-8', 'windows-1252', $cust['customer_name']), 1);
            $pdf->Cell(40, 7, $cust['customer_number'], 1);
            $pdf->Cell(40, 7, iconv('UTF-8', 'windows-1252', 'ரூ ' . number_format($cust['loan_amount'], 2)), 1);
            $pdf->Cell(30, 7, date('d M Y', strtotime($cust['emi_date'])), 1);
            $pdf->Ln();
        }
        $pdf->Ln(10);

// Expenses List
        $pdf->SetFont('Arial', 'B', 12);
        $pdf->Cell(0, 10, iconv('UTF-8', 'windows-1252', 'செலவுகள் பட்டியல்'), 0, 1);
        $pdf->SetFont('Arial', '', 10);
        $pdf->Cell(80, 7, iconv('UTF-8', 'windows-1252', 'விளக்கம்'), 1);
        $pdf->Cell(40, 7, iconv('UTF-8', 'windows-1252', 'தொகை'), 1);
        $pdf->Cell(30, 7, iconv('UTF-8', 'windows-1252', 'தேதி'), 1);
        $pdf->Ln();
        foreach ($expenses_list as $exp) {
            $pdf->Cell(80, 7, iconv('UTF-8', 'windows-1252', $exp['description']), 1);
            $pdf->Cell(40, 7, iconv('UTF-8', 'windows-1252', 'ரூ ' . number_format($exp['amount'], 2)), 1);
            $pdf->Cell(30, 7, date('d M Y', strtotime($exp['expense_date'])), 1);
            $pdf->Ln();
        }
        $pdf->Ln(10);

// Investments List
        $pdf->SetFont('Arial', 'B', 12);
        $pdf->Cell(0, 10, iconv('UTF-8', 'windows-1252', 'முதலீடுகள் பட்டியல்'), 0, 1);
        $pdf->SetFont('Arial', '', 10);
        $pdf->Cell(80, 7, iconv('UTF-8', 'windows-1252', 'பெயர்'), 1);
        $pdf->Cell(40, 7, iconv('UTF-8', 'windows-1252', 'தொகை'), 1);
        $pdf->Cell(30, 7, iconv('UTF-8', 'windows-1252', 'தேதி'), 1);
        $pdf->Ln();
        foreach ($investments_list as $inv) {
            $pdf->Cell(80, 7, iconv('UTF-8', 'windows-1252', $inv['name']), 1);
            $pdf->Cell(40, 7, iconv('UTF-8', 'windows-1252', 'ரூ ' . number_format($inv['amount'], 2)), 1);
            $pdf->Cell(30, 7, date('d M Y', strtotime($inv['investment_date'])), 1);
            $pdf->Ln();
        }
        $pdf->Ln(10);

// Output PDF
        $pdf_filename = 'profit_loss_report_' . date('Y-m-d') . '.pdf';
        $pdf->Output('D', $pdf_filename);
        exit;
    } else {
        // Log the error and display a user-friendly message
        error_log("FPDF library not found at $fpdf_path");
        $_SESSION['error'] = "PDF generation failed: Required library is missing. Please contact the administrator.";
        header("Location: overallreport.php");
        exit;
    }
}
?>

<!DOCTYPE html>
<html lang="en" dir="ltr" data-startbar="dark" data-bs-theme="light">
<head>
    <?php include 'includes/head.php'; ?>
    <style>
        body {
            background-color: #f8fafc;
            font-size: 16px;
        }
        .card {
            border: none;
            border-radius: 10px;
            box-shadow: 0 2px 8px rgba(0, 0, 0, 0.1);
            margin-bottom: 1.5rem;
            transition: transform 0.3s, box-shadow 0.3s;
        }
        .card:hover {
            transform: translateY(-4px);
            box-shadow: 0 4px 12px rgba(0, 0, 0, 0.15);
        }
        .metric-card {
            border-radius: 8px;
            padding: 1rem;
            text-align: center;
            background-color: #ffffff;
            box-shadow: 0 2px 6px rgba(0, 0, 0, 0.08);
            position: relative;
            min-height: 120px;
        }
        .metric-card h5 {
            font-size: calc(0.9rem + 0.2vw);
            font-weight: 500;
            color: #374151;
            margin-bottom: 0.5rem;
        }
        .metric-card p {
            font-size: calc(1.2rem + 0.3vw);
            font-weight: 600;
            color: #1f2937;
            margin-bottom: 0.25rem;
        }
        .metric-card small, .metric-card .breakdown {
            font-size: calc(0.7rem + 0.1vw);
            color: #6b7280;
        }
        .btn-primary {
            background: linear-gradient(to right, #2563eb, #3b82f6);
            border: none;
            border-radius: 6px;
            padding: 0.5rem 1.25rem;
            font-size: calc(0.85rem + 0.1vw);
            min-height: 44px;
            transition: background 0.3s, transform 0.3s;
        }
        .btn-primary:hover {
            background: linear-gradient(to right, #1d4ed8, #2563eb);
            transform: translateY(-2px);
        }
        .alert-warning {
            background-color: #fef3c7;
            border-color: #f59e0b;
            color: #92400e;
        }
        .quick-action-form {
            background: #f8fafc;
            padding: 1rem;
            border-radius: 8px;
            margin-bottom: 1rem;
            border: 1px solid #e5e7eb;
        }
        @media (max-width: 767px) {
            .metric-card {
                margin-bottom: 1rem;
                text-align: left;
            }
            .metric-card p {
                font-size: 1.1rem;
            }
        }
    </style>
</head>

<div class="startbar d-print-none">
        <?php include 'includes/leftbar-tab-menu.php'; ?> 
        <?php include 'includes/leftbar.php'; ?>
        <div class="startbar-overlay d-print-none"></div>
    </div>

<div class="page-wrapper">
        
        <div class="page-content">
            <div class="container-fluid">
                
                <?php
                $page_title = "Profit & Loss";
                ?>
                <div class="row">
                    <div class="col-sm-12">
                        <div class="page-title-box d-md-flex justify-content-md-between align-items-center">
                            <h4 class="page-title"><?php echo $page_title; ?> <?php echo $breadcrumb_active; ?></h4>
                            <div>
                                <ol class="breadcrumb mb-0">
                                    <li class="breadcrumb-item"><a href="index.php">Dashboard</a></li>
                                    <li class="breadcrumb-item active"><?php echo $breadcrumb_active; ?></li>
                                </ol>
                            </div>
                        </div>
                    </div>
                </div>

<?php if (isset($_SESSION['success'])): ?>
                    <div class="alert alert-success alert-dismissible fade show" role="alert">
                        <strong>Success!</strong> <?php echo $_SESSION['success']; ?>
                        <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                    </div>
                    <?php unset($_SESSION['success']); ?>
                <?php endif; ?>
                <?php if (isset($_SESSION['error'])): ?>
                    <div class="alert alert-danger alert-dismissible fade show" role="alert">
                        <strong>Error!</strong> <?php echo $_SESSION['error']; ?>
                        <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                    </div>
                    <?php unset($_SESSION['error']); ?>
                <?php endif; ?>

<?php if (!$finance_selected): ?>
                    <div class="alert alert-warning" role="alert">
                        <i class="fas fa-exclamation-triangle me-2"></i>
                        <strong>No Finance Selected:</strong> Please select a finance from the topbar dropdown to view profit & loss reports. Data is filtered by selected finance.
                        <div class="mt-2">
                            <form action="set-finance-session.php" method="post" id="financeSelectForm" class="d-inline">
                                <select class="form-control d-inline-block w-auto me-2" name="finance_id" onchange="this.form.submit()">
                                    <option value="0">Select Finance</option>
                                    <?php
                                    $sql_finance = "SELECT id, finance_name FROM finance ORDER BY finance_name";
                                    $result_finance = $conn->query($sql_finance);
                                    while ($finance = $result_finance->fetch_assoc()) {
                                        echo "<option value='{$finance['id']}'" . ($finance_id == $finance['id'] ? ' selected' : '') . ">{$finance['finance_name']}</option>";
                                    }
                                    $result_finance->free();
                                    ?>
                                </select>
                            </form>
                            <a href="#" class="btn btn-outline-primary btn-sm" onclick="document.getElementById('financeSelectForm').submit();">
                                <i class="iconoir-arrow-left me-1"></i> Select Finance
                            </a>
                        </div>
                    </div>
                <?php else: ?>
                    
                    <h4 class="mb-3">Balance Summary</h4>
                    <div class="card mb-4">
                        <div class="card-body">
                            <div class="row g-3">
                                <div class="col-12 col-md-4 col-lg-3">
                                    <div class="metric-card">
                                        <h5>Total Investment</h5>
                                        <p>₹<?php echo number_format($total_investment, 2); ?></p>
                                        <small class="text-muted"><?php echo $start_date && $end_date ? (new DateTime($start_date))->format('d M Y') . ' - ' . (new DateTime($end_date))->format('d M Y') : ($filter_active ? date('F Y', mktime(0, 0, 0, $selected_month, 1, $selected_year)) : 'Overall'); ?></small>
                                    </div>
                                </div>
                                <div class="col-12 col-md-4 col-lg-3">
                                    <div class="metric-card">
                                        <h5>Current Balance</h5>
                                        <p>₹<?php echo number_format($current_balance, 2); ?></p>
                                        <div class="breakdown">
                                            <small>EMI: ₹<?php echo number_format($total_emi_paid - $total_overdue_paid, 2); ?></small><br>
                                            <small>Overdue: ₹<?php echo number_format($total_overdue_paid, 2); ?></small><br>
                                            <small>Doc Charge: ₹<?php echo number_format($total_doc_charge, 2); ?></small>
                                        </div>
                                    </div>
                                </div>
                                <div class="col-12 col-md-4 col-lg-3">
                                    <div class="metric-card">
                                        <h5>Total Loan Issued (-)</h5>
                                        <p class="text-danger">₹<?php echo number_format($total_loan, 2); ?></p>
                                        <small class="text-muted"><?php echo $start_date && $end_date ? (new DateTime($start_date))->format('d M Y') . ' - ' . (new DateTime($end_date))->format('d M Y') : ($filter_active ? date('F Y', mktime(0, 0, 0, $selected_month, 1, $selected_year)) : 'Overall'); ?></small>
                                    </div>
                                </div>
                                <div class="col-12 col-md-4 col-lg-3">
                                    <div class="metric-card">
                                        <h5>EMI Received (+)</h5>
                                        <p class="text-success">₹<?php echo number_format($total_emi_paid, 2); ?></p>
                                        <small class="text-muted"><?php echo $start_date && $end_date ? (new DateTime($start_date))->format('d M Y') . ' - ' . (new DateTime($end_date))->format('d M Y') : ($filter_active ? date('F Y', mktime(0, 0, 0, $selected_month, 1, $selected_year)) : 'Overall'); ?></small>
                                    </div>
                                </div>
                                <div class="col-12 col-md-4 col-lg-3">
                                    <div class="metric-card">
                                        <h5>Document Charges (+)</h5>
                                        <p class="text-success">₹<?php echo number_format($total_doc_charge, 2); ?></p>
                                        <small class="text-muted"><?php echo $start_date && $end_date ? (new DateTime($start_date))->format('d M Y') . ' - ' . (new DateTime($end_date))->format('d M Y') : ($filter_active ? date('F Y', mktime(0, 0, 0, $selected_month, 1, $selected_year)) : 'Overall'); ?></small>
                                    </div>
                                </div>
                                <div class="col-12 col-md-4 col-lg-3">
                                    <div class="metric-card">
                                        <h5>Total Expenses (-)</h5>
                                        <p class="text-danger">₹<?php echo number_format($total_expenses, 2); ?></p>
                                        <small class="text-muted"><?php echo $start_date && $end_date ? (new DateTime($start_date))->format('d M Y') . ' - ' . (new DateTime($end_date))->format('d M Y') : ($filter_active ? date('F Y', mktime(0, 0, 0, $selected_month, 1, $selected_year)) : 'Overall'); ?></small>
                                    </div>
                                </div>
                                <div class="col-12 col-md-4 col-lg-3">
                                    <div class="metric-card">
                                        <h5>Profit/Loss</h5>
                                        <p class="<?php echo $profit_loss >= 0 ? 'text-success' : 'text-danger'; ?>">₹<?php echo number_format($profit_loss, 2); ?></p>
                                        <small class="text-muted"><?php echo $start_date && $end_date ? (new DateTime($start_date))->format('d M Y') . ' - ' . (new DateTime($end_date))->format('d M Y') : ($filter_active ? date('F Y', mktime(0, 0, 0, $selected_month, 1, $selected_year)) : 'Overall'); ?></small>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                <?php endif; ?>

</div>

<?php include 'includes/rightbar.php'; ?>
            <?php include 'includes/footer.php'; ?>
        </div>
        
    </div>

<?php include 'includes/scripts.php'; ?>
</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: overallreport.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation