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/sp/admin

Free Space:

10.28 TB

🔧 Quick Actions

✏️ Editing: foreclose-loan.php

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

$customer_id = isset($_POST['customer_id']) ? intval($_POST['customer_id']) : 0;
$principal_amount = isset($_POST['principal_amount']) ? floatval($_POST['principal_amount']) : 0;
$interest_amount = isset($_POST['interest_amount']) ? floatval($_POST['interest_amount']) : 0;
$foreclosure_charge = isset($_POST['foreclosure_charge']) ? floatval($_POST['foreclosure_charge']) : 0;

if ($customer_id == 0) {
    header("Location: emi-schedule.php?customer_id=$customer_id&error=" . urlencode("Invalid customer ID."));
    exit();
}

// Validate inputs
if ($principal_amount <= 0 || $interest_amount < 0 || $foreclosure_charge < 0) {
    header("Location: emi-schedule.php?customer_id=$customer_id&error=" . urlencode("Invalid principal, interest, or foreclosure charge."));
    exit();
}

// Start transaction
mysqli_begin_transaction($conn);

try {
    // Update all unpaid EMIs to 'paid' and set paid_date
    $sql = "UPDATE emi_schedule 
            SET status = 'paid', paid_date = CURDATE() 
            WHERE customer_id = $customer_id AND status != 'paid'";
    if (!mysqli_query($conn, $sql)) {
        throw new Exception("Error updating EMI status: " . mysqli_error($conn));
    }

// Insert foreclosure charge into total_investment table
    $investment_type = 'Foreclosure Charge';
    $sql_investment = "INSERT INTO total_investment (customer_id, investment_type, amount, investment_date) 
                       VALUES ('$customer_id', '$investment_type', '$foreclosure_charge', CURDATE())";
    if (!mysqli_query($conn, $sql_investment)) {
        throw new Exception("Error logging foreclosure charge: " . mysqli_error($conn));
    }

// Commit transaction
    mysqli_commit($conn);
    header("Location: emi-schedule.php?customer_id=$customer_id&msg=" . urlencode("Loan foreclosed successfully for Principal ₹$principal_amount, Interest ₹$interest_amount, and Foreclosure Charge ₹$foreclosure_charge."));
} catch (Exception $e) {
    // Rollback transaction on error
    mysqli_rollback($conn);
    header("Location: emi-schedule.php?customer_id=$customer_id&error=" . urlencode($e->getMessage()));
}

mysqli_close($conn);
exit();
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: foreclose-loan.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation