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.3 TB

🔧 Quick Actions

✏️ Editing: edit-emi.php

<?php
// 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');

// Start session
session_start();

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

// Fetch EMI ID, customer ID, and form data
$emi_id = isset($_POST['emi_id']) ? intval($_POST['emi_id']) : 0;
$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;
$emi_amount = isset($_POST['emi_amount']) ? floatval($_POST['emi_amount']) : 0;
$emi_due_date = isset($_POST['emi_due_date']) ? $_POST['emi_due_date'] : '';
$overdue_charges = isset($_POST['overdue_charges']) ? floatval($_POST['overdue_charges']) : 0;
$finance_id = isset($_SESSION['finance_id']) ? intval($_SESSION['finance_id']) : 0;

// Validate inputs
if ($emi_id <= 0 || $customer_id <= 0) {
    $_SESSION['error'] = "Error: Invalid EMI ID or Customer ID.";
    error_log("Invalid EMI ID ($emi_id) or Customer ID ($customer_id) in edit-emi.php");
    header("Location: emi-schedule.php?customer_id=" . $customer_id);
    exit;
}

if ($principal_amount <= 0 || $interest_amount < 0 || $emi_amount <= 0) {
    $_SESSION['error'] = "Error: Invalid principal, interest, or EMI amount.";
    error_log("Invalid amounts: principal=$principal_amount, interest=$interest_amount, emi=$emi_amount in edit-emi.php");
    header("Location: emi-schedule.php?customer_id=" . $customer_id);
    exit;
}

if (abs($emi_amount - ($principal_amount + $interest_amount)) > 0.01) {
    $_SESSION['error'] = "Error: Total EMI amount must equal Principal + Interest.";
    error_log("EMI amount mismatch: emi_amount=$emi_amount, principal=$principal_amount, interest=$interest_amount in edit-emi.php");
    header("Location: emi-schedule.php?customer_id=" . $customer_id);
    exit;
}

if (empty($emi_due_date) || !strtotime($emi_due_date)) {
    $_SESSION['error'] = "Error: Invalid due date.";
    error_log("Invalid due date ($emi_due_date) in edit-emi.php");
    header("Location: emi-schedule.php?customer_id=" . $customer_id);
    exit;
}

// Fetch EMI details to verify status and finance
$sql = "SELECT status, customer_id, finance_id FROM emi_schedule WHERE id = ? AND customer_id = ?";
$params = ["ii", $emi_id, $customer_id];
if ($finance_id > 0) {
    $sql .= " AND finance_id = ?";
    $params[0] .= "i";
    $params[] = $finance_id;
}
$stmt = $conn->prepare($sql);
if (!$stmt) {
    $_SESSION['error'] = "Error: Database prepare failed.";
    error_log("Prepare failed for EMI ID $emi_id in edit-emi.php: " . $conn->error);
    header("Location: emi-schedule.php?customer_id=" . $customer_id);
    exit;
}
$stmt->bind_param(...$params);
$stmt->execute();
$result = $stmt->get_result();

if ($result->num_rows === 0) {
    $_SESSION['error'] = "Error: EMI not found or does not belong to this customer" . ($finance_id > 0 ? " or finance." : ".");
    error_log("EMI ID $emi_id not found for customer ID $customer_id" . ($finance_id > 0 ? " and finance ID $finance_id" : "") . " in edit-emi.php");
    header("Location: emi-schedule.php?customer_id=" . $customer_id);
    exit;
}

$emi = $result->fetch_assoc();
$stmt->close();

// Prevent editing paid EMIs for certain fields
if ($emi['status'] === 'paid' && ($principal_amount != $emi['principal_amount'] || $interest_amount != $emi['interest_amount'] || $emi_amount != $emi['emi_amount'] || $overdue_charges != $emi['overdue_charges'])) {
    $_SESSION['error'] = "Error: Cannot edit principal, interest, EMI amount, or overdue charges for paid EMIs.";
    error_log("Attempt to edit paid EMI ID $emi_id in edit-emi.php");
    header("Location: emi-schedule.php?customer_id=" . $customer_id);
    exit;
}

// Update EMI details
$conn->begin_transaction();
try {
    $sql_update = "UPDATE emi_schedule 
                   SET principal_amount = ?, interest_amount = ?, emi_amount = ?, emi_due_date = ?, overdue_charges = ?
                   WHERE id = ? AND customer_id = ?";
    $params_update = ["dddssii", $principal_amount, $interest_amount, $emi_amount, $emi_due_date, $overdue_charges, $emi_id, $customer_id];
    if ($finance_id > 0) {
        $sql_update .= " AND finance_id = ?";
        $params_update[0] .= "i";
        $params_update[] = $finance_id;
    }
    $stmt = $conn->prepare($sql_update);
    if (!$stmt) {
        throw new Exception("Prepare failed for update: " . $conn->error);
    }
    $stmt->bind_param(...$params_update);
    if (!$stmt->execute()) {
        throw new Exception("Failed to update EMI: " . $stmt->error);
    }
    $affected_rows = $stmt->affected_rows;
    $stmt->close();

if ($affected_rows === 0) {
        throw new Exception("No rows updated for EMI ID $emi_id.");
    }

$conn->commit();
    $_SESSION['success'] = "EMI updated successfully.";
    header("Location: emi-schedule.php?customer_id=" . $customer_id);
    exit;
} catch (Exception $e) {
    $conn->rollback();
    $_SESSION['error'] = "Error updating EMI: " . $e->getMessage();
    error_log("Error updating EMI ID $emi_id for customer ID $customer_id: " . $e->getMessage());
    header("Location: emi-schedule.php?customer_id=" . $customer_id);
    exit;
} finally {
    $conn->close();
}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: edit-emi.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation