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

🔧 Quick Actions

✏️ Editing: add-customer.php

<?php
// Enable error logging instead of displaying errors
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();

// Include database connection
include 'includes/db.php';

// Check if editing an existing customer
$edit_mode = isset($_GET['edit']) && is_numeric($_GET['edit']);
$edit_customer_id = $edit_mode ? intval($_GET['edit']) : 0;

// Fetch finance records
$sql_finance = "SELECT id, finance_name FROM finance ORDER BY finance_name ASC";
$result_finance = $conn->query($sql_finance);
$finances = [];
if ($result_finance) {
    while ($row = $result_finance->fetch_assoc()) {
        $finances[] = $row;
    }
    $result_finance->free();
} else {
    $_SESSION['error'] = "Error fetching finance data: " . $conn->error;
}

// Get selected finance_id from session, form, or edit mode
$finance_id = isset($_POST['finance_id']) ? intval($_POST['finance_id']) : (isset($_SESSION['finance_id']) ? intval($_SESSION['finance_id']) : 0);

// Fetch loans based on selected finance
$loans = [];
if ($finance_id > 0) {
    $sql_loans = "SELECT id, loan_name, loan_amount, interest_rate, loan_tenure FROM loans WHERE finance_id = ? ORDER BY loan_name ASC";
    $stmt_loans = $conn->prepare($sql_loans);
    $stmt_loans->bind_param("i", $finance_id);
    $stmt_loans->execute();
    $result_loans = $stmt_loans->get_result();
    while ($row = $result_loans->fetch_assoc()) {
        $loans[] = $row;
    }
    $result_loans->free();
    $stmt_loans->close();
}

// Fetch customer data for edit mode
$customer_data = [];
$emi_schedule = [];
if ($edit_mode) {
    $sql_customer = "SELECT * FROM customers WHERE id = ?";
    $stmt_customer = $conn->prepare($sql_customer);
    $stmt_customer->bind_param("i", $edit_customer_id);
    $stmt_customer->execute();
    $result_customer = $stmt_customer->get_result();
    if ($result_customer->num_rows > 0) {
        $customer_data = $result_customer->fetch_assoc();
        $finance_id = $customer_data['finance_id'];
        // Fetch EMI schedule
        $sql_emi = "SELECT id, emi_amount, principal_amount, interest_amount, emi_due_date, status FROM emi_schedule WHERE customer_id = ? ORDER BY emi_due_date ASC";
        $stmt_emi = $conn->prepare($sql_emi);
        $stmt_emi->bind_param("i", $edit_customer_id);
        $stmt_emi->execute();
        $result_emi = $stmt_emi->get_result();
        while ($row = $result_emi->fetch_assoc()) {
            $emi_schedule[] = $row;
        }
        $result_emi->free();
        $stmt_emi->close();
    } else {
        $_SESSION['error'] = "Customer not found.";
        header("Location: manage-customers.php");
        exit;
    }
    $stmt_customer->close();
}

// Handle form submission (add or update)
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    // Get and sanitize form data
    $finance_id = intval($_POST['finance_id'] ?? 0);
    $agreement_number = trim($_POST['agreement_number'] ?? '');
    $customer_name = trim($_POST['customer_name'] ?? '');
    $customer_number = trim($_POST['customer_number'] ?? '');
    $customer_number2 = trim($_POST['customer_number2'] ?? ''); // New alternate phone number
    $nominee_name = trim($_POST['nominee_name'] ?? '');
    $nominee_number = trim($_POST['nominee_number'] ?? '');
    $customer_aadhar = trim($_POST['customer_aadhar'] ?? '');
    $nominee_aadhar = trim($_POST['nominee_aadhar'] ?? '');
    $customer_address = trim($_POST['customer_address'] ?? '');
    $loan_id = intval($_POST['loan_id'] ?? 0);
    $loan_amount = floatval($_POST['loan_amount'] ?? 0);
    $interest_rate = floatval($_POST['interest_rate'] ?? 0);
    $loan_tenure = intval($_POST['loan_tenure'] ?? 0);
    $document_charge = floatval($_POST['document_charge'] ?? 0);
    $emi_date = trim($_POST['emi_date'] ?? '');
    $first_emi_date = trim($_POST['first_emi_date'] ?? '');
    $rc_number = trim($_POST['rc_number'] ?? '');
    $vehicle_type = trim($_POST['vehicle_type'] ?? '');
    $vehicle_number = trim($_POST['vehicle_number'] ?? '');
    $vehicle_model = trim($_POST['vehicle_model'] ?? ''); // NEW: Vehicle model
    $emi_dates = isset($_POST['emi_due_dates']) ? $_POST['emi_due_dates'] : [];

// Validate EMI due dates
    if ($edit_mode && !empty($emi_dates)) {
        $previous_date = $first_emi_date;
        foreach ($emi_dates as $index => $emi_due_date) {
            if (empty($emi_due_date)) {
                $_SESSION['error'] = "EMI due date #" . ($index + 1) . " is required.";
                header("Location: add-customer.php?edit=$edit_customer_id");
                exit;
            }
            // First EMI date must be on or after first_emi_date
            if ($index == 0 && strtotime($emi_due_date) < strtotime($first_emi_date)) {
                $_SESSION['error'] = "EMI due date #1 must be on or after the first EMI date.";
                header("Location: add-customer.php?edit=$edit_customer_id");
                exit;
            }
            // Subsequent EMI dates must be after the previous date
            if ($index > 0 && strtotime($emi_due_date) <= strtotime($previous_date)) {
                $_SESSION['error'] = "EMI due date #" . ($index + 1) . " must be after the previous EMI date.";
                header("Location: add-customer.php?edit=$edit_customer_id");
                exit;
            }
            $previous_date = $emi_due_date;
        }
    }

// Handle file uploads
    $customer_photo = $edit_mode ? $customer_data['customer_photo'] : null;
    $aadhar_photo = $edit_mode ? $customer_data['aadhar_photo'] : null;
    $target_dir = "Uploads/";

// Create uploads directory if it doesn't exist
    if (!is_dir($target_dir)) {
        if (!mkdir($target_dir, 0755, true)) {
            $_SESSION['error'] = "Failed to create uploads directory.";
            header("Location: add-customer.php" . ($edit_mode ? "?edit=$edit_customer_id" : ""));
            exit;
        }
    }

// Check directory permissions
    if (!is_writable($target_dir)) {
        $_SESSION['error'] = "Uploads directory is not writable. Please check permissions.";
        header("Location: add-customer.php" . ($edit_mode ? "?edit=$edit_customer_id" : ""));
        exit;
    }

// Handle customer photo upload
    if (isset($_FILES['customer_photo']) && $_FILES['customer_photo']['error'] === UPLOAD_ERR_OK) {
        $file_ext = strtolower(pathinfo($_FILES['customer_photo']['name'], PATHINFO_EXTENSION));
        $allowed_ext = ['jpg', 'jpeg', 'png', 'gif'];
        if (!in_array($file_ext, $allowed_ext)) {
            $_SESSION['error'] = "Invalid customer photo format. Only JPG, JPEG, PNG, or GIF allowed.";
            header("Location: add-customer.php" . ($edit_mode ? "?edit=$edit_customer_id" : ""));
            exit;
        }
        if ($_FILES['customer_photo']['size'] > 5 * 1024 * 1024) {
            $_SESSION['error'] = "Customer photo size exceeds 5MB limit.";
            header("Location: add-customer.php" . ($edit_mode ? "?edit=$edit_customer_id" : ""));
            exit;
        }
        $customer_photo = $target_dir . 'customer_' . time() . '_' . uniqid() . '.' . $file_ext;
        if (!move_uploaded_file($_FILES['customer_photo']['tmp_name'], $customer_photo)) {
            $_SESSION['error'] = "Failed to upload customer photo. Please try again.";
            header("Location: add-customer.php" . ($edit_mode ? "?edit=$edit_customer_id" : ""));
            exit;
        }
    } elseif ($_FILES['customer_photo']['error'] !== UPLOAD_ERR_NO_FILE) {
        $_SESSION['error'] = "Error with customer photo upload: " . $_FILES['customer_photo']['error'];
        header("Location: add-customer.php" . ($edit_mode ? "?edit=$edit_customer_id" : ""));
        exit;
    }

// Handle Aadhar photo upload
    if (isset($_FILES['aadhar_photo']) && $_FILES['aadhar_photo']['error'] === UPLOAD_ERR_OK) {
        $file_ext = strtolower(pathinfo($_FILES['aadhar_photo']['name'], PATHINFO_EXTENSION));
        $allowed_ext = ['jpg', 'jpeg', 'png', 'gif'];
        if (!in_array($file_ext, $allowed_ext)) {
            $_SESSION['error'] = "Invalid Aadhar photo format. Only JPG, JPEG, PNG, or GIF allowed.";
            header("Location: add-customer.php" . ($edit_mode ? "?edit=$edit_customer_id" : ""));
            exit;
        }
        if ($_FILES['aadhar_photo']['size'] > 5 * 1024 * 1024) {
            $_SESSION['error'] = "Aadhar photo size exceeds 5MB limit.";
            header("Location: add-customer.php" . ($edit_mode ? "?edit=$edit_customer_id" : ""));
            exit;
        }
        $aadhar_photo = $target_dir . 'aadhar_' . time() . '_' . uniqid() . '.' . $file_ext;
        if (!move_uploaded_file($_FILES['aadhar_photo']['tmp_name'], $aadhar_photo)) {
            $_SESSION['error'] = "Failed to upload Aadhar photo. Please try again.";
            header("Location: add-customer.php" . ($edit_mode ? "?edit=$edit_customer_id" : ""));
            exit;
        }
    } elseif ($_FILES['aadhar_photo']['error'] !== UPLOAD_ERR_NO_FILE) {
        $_SESSION['error'] = "Error with Aadhar photo upload: " . $_FILES['aadhar_photo']['error'];
        header("Location: add-customer.php" . ($edit_mode ? "?edit=$edit_customer_id" : ""));
        exit;
    }

// Validate required fields
    if ($finance_id <= 0) {
        $_SESSION['error'] = "Please select a finance.";
        header("Location: add-customer.php" . ($edit_mode ? "?edit=$edit_customer_id" : ""));
        exit;
    }
    if (empty($agreement_number) || empty($customer_name) || empty($customer_number) || empty($nominee_name) || empty($nominee_number) ||
        $loan_id <= 0 || $loan_amount <= 0 || $interest_rate < 0 || $loan_tenure <= 0 || $document_charge < 0 || empty($emi_date) || empty($first_emi_date)) {
        $_SESSION['error'] = "All required fields must be filled.";
        header("Location: add-customer.php" . ($edit_mode ? "?edit=$edit_customer_id" : ""));
        exit;
    }

// Validate Aadhar numbers
    if ($customer_aadhar && !preg_match('/^\d{12}$/', $customer_aadhar)) {
        $_SESSION['error'] = "Customer Aadhar number must be 12 digits.";
        header("Location: add-customer.php" . ($edit_mode ? "?edit=$edit_customer_id" : ""));
        exit;
    }
    if ($nominee_aadhar && !preg_match('/^\d{12}$/', $nominee_aadhar)) {
        $_SESSION['error'] = "Nominee Aadhar number must be 12 digits.";
        header("Location: add-customer.php" . ($edit_mode ? "?edit=$edit_customer_id" : ""));
        exit;
    }

// Validate phone numbers
    if (!preg_match('/^\d{10}$/', $customer_number)) {
        $_SESSION['error'] = "Customer number must be 10 digits.";
        header("Location: add-customer.php" . ($edit_mode ? "?edit=$edit_customer_id" : ""));
        exit;
    }
    
    // Validate alternate phone number (optional)
    if ($customer_number2 && !preg_match('/^\d{10}$/', $customer_number2)) {
        $_SESSION['error'] = "Alternate customer number must be 10 digits.";
        header("Location: add-customer.php" . ($edit_mode ? "?edit=$edit_customer_id" : ""));
        exit;
    }
    
    if (!preg_match('/^\d{10}$/', $nominee_number)) {
        $_SESSION['error'] = "Nominee number must be 10 digits.";
        header("Location: add-customer.php" . ($edit_mode ? "?edit=$edit_customer_id" : ""));
        exit;
    }

// Validate finance_id
    $finance_exists = false;
    foreach ($finances as $finance) {
        if ($finance['id'] == $finance_id) {
            $finance_exists = true;
            break;
        }
    }
    if (!$finance_exists) {
        $_SESSION['error'] = "Invalid finance selected.";
        header("Location: add-customer.php" . ($edit_mode ? "?edit=$edit_customer_id" : ""));
        exit;
    }

// Check loan_id
    $loan_exists = false;
    $is_vehicle_loan = false;
    $selected_loan_name = '';
    $sql_check_loan = "SELECT loan_name FROM loans WHERE id = ? AND finance_id = ?";
    $stmt_check = $conn->prepare($sql_check_loan);
    $stmt_check->bind_param("ii", $loan_id, $finance_id);
    $stmt_check->execute();
    $result_check = $stmt_check->get_result();
    if ($result_check->num_rows > 0) {
        $loan_exists = true;
        $loan_data = $result_check->fetch_assoc();
        $selected_loan_name = $loan_data['loan_name'];
        $is_vehicle_loan = (stripos($selected_loan_name, 'vehicle') !== false);
    }
    $result_check->free();
    $stmt_check->close();
    if (!$loan_exists) {
        $_SESSION['error'] = "Invalid loan selected for the chosen finance.";
        header("Location: add-customer.php" . ($edit_mode ? "?edit=$edit_customer_id" : ""));
        exit;
    }

// Validate vehicle fields - Make them optional even for Vehicle Loan
    $valid_vehicle_types = ['Two-Wheeler', 'Car', 'Truck', 'Others'];
    if ($is_vehicle_loan) {
        // Vehicle fields are now optional
        if ($vehicle_type && !in_array($vehicle_type, $valid_vehicle_types)) {
            $_SESSION['error'] = "Invalid Vehicle Type selected.";
            header("Location: add-customer.php" . ($edit_mode ? "?edit=$edit_customer_id" : ""));
            exit;
        }
    }

// Validate dates
    if (strtotime($first_emi_date) < strtotime($emi_date)) {
        $_SESSION['error'] = "First EMI date must be on or after the agreement date.";
        header("Location: add-customer.php" . ($edit_mode ? "?edit=$edit_customer_id" : ""));
        exit;
    }

// Calculate EMI
    $principal_per_month = $loan_amount / $loan_tenure;
    $monthly_interest = $loan_amount * ($interest_rate / 100);
    $emi = round($principal_per_month + $monthly_interest);
    $total_principal = $loan_amount;
    $total_interest = $monthly_interest * $loan_tenure;

// Assign nullable fields
    $bind_customer_aadhar = $customer_aadhar ?: null;
    $bind_nominee_aadhar = $nominee_aadhar ?: null;
    $bind_customer_address = $customer_address ?: null;
    $bind_customer_number2 = $customer_number2 ?: null;
    $bind_vehicle_number = $vehicle_number ?: null;
    $bind_rc_number = $rc_number ?: null;
    $bind_vehicle_type = $vehicle_type ?: null;
    $bind_vehicle_model = $vehicle_model ?: null; // NEW: Vehicle model
    $bind_customer_photo = $customer_photo;
    $bind_aadhar_photo = $aadhar_photo;

if ($edit_mode) {
        // Update customer
        $sql = "UPDATE customers SET 
                agreement_number = ?, customer_name = ?, customer_number = ?, customer_number2 = ?, nominee_name = ?, nominee_number = ?, 
                customer_aadhar = ?, nominee_aadhar = ?, customer_address = ?, vehicle_number = ?, loan_id = ?, 
                loan_amount = ?, principal_amount = ?, interest_amount = ?, interest_rate = ?, loan_tenure = ?, 
                document_charge = ?, emi = ?, emi_date = ?, rc_number = ?, vehicle_type = ?, vehicle_model = ?, 
                customer_photo = ?, aadhar_photo = ?, finance_id = ?
                WHERE id = ?";
        $stmt_update = $conn->prepare($sql);
        if (!$stmt_update) {
            $_SESSION['error'] = "Prepare failed: " . $conn->error;
            header("Location: add-customer.php?edit=$edit_customer_id");
            exit;
        }
        $stmt_update->bind_param(
            "ssssssssssiddddiddssssssii",
            $agreement_number,
            $customer_name,
            $customer_number,
            $bind_customer_number2,
            $nominee_name,
            $nominee_number,
            $bind_customer_aadhar,
            $bind_nominee_aadhar,
            $bind_customer_address,
            $bind_vehicle_number,
            $loan_id,
            $loan_amount,
            $total_principal,
            $total_interest,
            $interest_rate,
            $loan_tenure,
            $document_charge,
            $emi,
            $emi_date,
            $bind_rc_number,
            $bind_vehicle_type,
            $bind_vehicle_model,
            $bind_customer_photo,
            $bind_aadhar_photo,
            $finance_id,
            $edit_customer_id
        );
        if ($stmt_update->execute()) {
            // Update EMI schedule
            $sql_delete_emi = "DELETE FROM emi_schedule WHERE customer_id = ? AND status = 'unpaid'";
            $stmt_delete_emi = $conn->prepare($sql_delete_emi);
            $stmt_delete_emi->bind_param("i", $edit_customer_id);
            $stmt_delete_emi->execute();
            $stmt_delete_emi->close();

$sql_emi = "INSERT INTO emi_schedule 
                        (customer_id, finance_id, emi_amount, principal_amount, interest_amount, emi_due_date, status) 
                        VALUES (?, ?, ?, ?, ?, ?, 'unpaid')";
            $stmt_emi = $conn->prepare($sql_emi);
            if (!$stmt_emi) {
                $_SESSION['error'] = "EMI Prepare failed: " . $conn->error;
                header("Location: add-customer.php?edit=$edit_customer_id");
                exit;
            }
            for ($i = 0; $i < $loan_tenure; $i++) {
                $emi_due_date = isset($emi_dates[$i]) ? $emi_dates[$i] : date('Y-m-d', strtotime($first_emi_date . " +$i months"));
                if (!empty($emi_due_date)) {
                    $stmt_emi->bind_param("iiddds", $edit_customer_id, $finance_id, $emi, $principal_per_month, $monthly_interest, $emi_due_date);
                    $stmt_emi->execute();
                }
            }
            $stmt_emi->close();

$_SESSION['success'] = "Customer updated successfully!";
            header("Location: manage-customers.php");
            exit;
        } else {
            $_SESSION['error'] = "Error: " . $stmt_update->error;
            header("Location: add-customer.php?edit=$edit_customer_id");
            exit;
        }
        $stmt_update->close();
    } else {
        // Insert new customer
        $sql = "INSERT INTO customers 
                (agreement_number, customer_name, customer_number, customer_number2, nominee_name, nominee_number, 
                 customer_aadhar, nominee_aadhar, customer_address, vehicle_number, loan_id, 
                 loan_amount, principal_amount, interest_amount, interest_rate, loan_tenure, 
                 document_charge, emi, emi_date, rc_number, vehicle_type, vehicle_model, customer_photo, aadhar_photo, finance_id)
                VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
        $stmt_insert = $conn->prepare($sql);
        if (!$stmt_insert) {
            $_SESSION['error'] = "Prepare failed: " . $conn->error;
            header("Location: add-customer.php");
            exit;
        }
        $stmt_insert->bind_param(
            "ssssssssssiddddiddssssssi",
            $agreement_number,
            $customer_name,
            $customer_number,
            $bind_customer_number2,
            $nominee_name,
            $nominee_number,
            $bind_customer_aadhar,
            $bind_nominee_aadhar,
            $bind_customer_address,
            $bind_vehicle_number,
            $loan_id,
            $loan_amount,
            $total_principal,
            $total_interest,
            $interest_rate,
            $loan_tenure,
            $document_charge,
            $emi,
            $emi_date,
            $bind_rc_number,
            $bind_vehicle_type,
            $bind_vehicle_model,
            $bind_customer_photo,
            $bind_aadhar_photo,
            $finance_id
        );
        if ($stmt_insert->execute()) {
            $customer_id = $conn->insert_id;

// Update session
            $_SESSION['finance_id'] = $finance_id;

// Build EMI schedule
            $sql_emi = "INSERT INTO emi_schedule 
                        (customer_id, finance_id, emi_amount, principal_amount, interest_amount, emi_due_date, status) 
                        VALUES (?, ?, ?, ?, ?, ?, 'unpaid')";
            $stmt_emi = $conn->prepare($sql_emi);
            if (!$stmt_emi) {
                $_SESSION['error'] = "EMI Prepare failed: " . $conn->error;
                header("Location: add-customer.php");
                exit;
            }
            for ($i = 0; $i < $loan_tenure; $i++) {
                $emi_due_date = isset($emi_dates[$i]) ? $emi_dates[$i] : date('Y-m-d', strtotime($first_emi_date . " +$i months"));
                if (!empty($emi_due_date)) {
                    $stmt_emi->bind_param("iiddds", $customer_id, $finance_id, $emi, $principal_per_month, $monthly_interest, $emi_due_date);
                    $stmt_emi->execute();
                }
            }
            $stmt_emi->close();

$_SESSION['success'] = "Customer added successfully!";
            header("Location: manage-customers.php");
            exit;
        } else {
            $_SESSION['error'] = "Error: " . $stmt_insert->error;
            header("Location: add-customer.php");
            exit;
        }
        $stmt_insert->close();
    }
    $conn->close();
}
?>

<!DOCTYPE html>
<html lang="en" dir="ltr" data-startbar="dark" data-bs-theme="light">
<?php include 'includes/head.php'; ?>

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

<?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; ?>

<div class="row align-items-center mb-3">
                        <div class="col">
                            <h3 class="mb-0"><?php echo $edit_mode ? 'Edit Customer' : 'Add Customer'; ?></h3>
                            <small class="text-muted"><?php echo $edit_mode ? 'Edit customer details and EMI schedule' : 'Add customer details along with loan information'; ?><?php echo $finance_id > 0 ? " for selected finance" : ""; ?>.</small>
                        </div>
                        <div class="col-auto">
                            <a href="manage-customers.php" class="btn btn-light">Back to Customers</a>
                        </div>
                    </div>

<div class="card">
                        <div class="card-header">
                            <h4 class="card-title mb-0"><?php echo $edit_mode ? 'Edit Customer Details' : 'Customer Details'; ?></h4>
                        </div>
                        <div class="card-body">
                            <form id="customerForm" action="add-customer.php<?php echo $edit_mode ? '?edit=' . $edit_customer_id : ''; ?>" method="POST" enctype="multipart/form-data" novalidate>
                                
                                <div class="row g-3 mb-4">
                                    
                                    <div class="col-md-6">
                                        <h5 class="mb-3">Customer Information</h5>
                                        
                                        <div class="mb-3">
                                            <label for="customer_name" class="form-label" style="font-weight: bold; font-size: 1rem;">Customer Name <span class="text-danger">*</span></label>
                                            <input type="text" class="form-control" id="customer_name" name="customer_name" value="<?php echo $edit_mode ? htmlspecialchars($customer_data['customer_name']) : (isset($_POST['customer_name']) ? htmlspecialchars($_POST['customer_name']) : ''); ?>" required>
                                            <div class="invalid-feedback">Customer name is required.</div>
                                        </div>
                                        
                                        <div class="mb-3">
                                            <label for="customer_number" class="form-label" style="font-weight: bold; font-size: 1rem;">Customer Number <span class="text-danger">*</span></label>
                                            <input type="text" class="form-control" id="customer_number" name="customer_number" value="<?php echo $edit_mode ? htmlspecialchars($customer_data['customer_number']) : (isset($_POST['customer_number']) ? htmlspecialchars($_POST['customer_number']) : ''); ?>" required pattern="\d{10}" maxlength="10">
                                            <div class="invalid-feedback">Customer number must be 10 digits.</div>
                                        </div>
                                        
                                        <div class="mb-3">
                                            <label for="customer_number2" class="form-label" style="font-weight: bold; font-size: 1rem;">Alternate Customer Number <span class="text-muted">(optional)</span></label>
                                            <input type="text" class="form-control" id="customer_number2" name="customer_number2" value="<?php echo $edit_mode ? htmlspecialchars($customer_data['customer_number2']) : (isset($_POST['customer_number2']) ? htmlspecialchars($_POST['customer_number2']) : ''); ?>" pattern="\d{10}" maxlength="10">
                                            <div class="invalid-feedback">Alternate number must be 10 digits.</div>
                                        </div>
                                        
                                        <div class="mb-3">
                                            <label for="customer_aadhar" class="form-label" style="font-weight: bold; font-size: 1rem;">Customer Aadhar Number <span class="text-muted">(optional)</span></label>
                                            <input type="text" class="form-control" id="customer_aadhar" name="customer_aadhar" value="<?php echo $edit_mode ? htmlspecialchars($customer_data['customer_aadhar']) : (isset($_POST['customer_aadhar']) ? htmlspecialchars($_POST['customer_aadhar']) : ''); ?>" pattern="\d{12}" maxlength="12">
                                            <div class="invalid-feedback">Aadhar number must be 12 digits.</div>
                                        </div>
                                        
                                        <div class="mb-3">
                                            <label for="customer_address" class="form-label" style="font-weight: bold; font-size: 1rem;">Customer Address <span class="text-muted">(optional)</span></label>
                                            <textarea class="form-control" id="customer_address" name="customer_address" rows="3"><?php echo $edit_mode ? htmlspecialchars($customer_data['customer_address']) : (isset($_POST['customer_address']) ? htmlspecialchars($_POST['customer_address']) : ''); ?></textarea>
                                        </div>
                                        
                                        <div class="mb-3">
                                            <label for="customer_photo" class="form-label" style="font-weight: bold; font-size: 1rem;">Customer Photo <span class="text-muted">(optional)</span></label>
                                            <div class="d-flex gap-2 mb-2">
                                                
                                                <button type="button" class="btn btn-outline-primary btn-sm" id="captureCustomerPhoto">
                                                    <i class="fas fa-camera me-1"></i> Take Photo
                                                </button>
                                                
                                                <button type="button" class="btn btn-outline-secondary btn-sm" id="uploadCustomerPhoto">
                                                    <i class="fas fa-upload me-1"></i> Upload File
                                                </button>
                                            </div>
                                            
                                            <input type="file" class="form-control d-none" id="customer_photo" name="customer_photo" accept="image/*">
                                            
                                            <div class="camera-preview mb-2 d-none" id="customerCameraPreview">
                                                <video id="customerVideo" width="100%" height="200" autoplay muted class="rounded border"></video>
                                                <canvas id="customerCanvas" class="d-none"></canvas>
                                                <div class="mt-2">
                                                    <button type="button" class="btn btn-success btn-sm" id="captureCustomerBtn">
                                                        <i class="fas fa-camera me-1"></i> Capture
                                                    </button>
                                                    <button type="button" class="btn btn-secondary btn-sm" id="retakeCustomerBtn">
                                                        <i class="fas fa-redo me-1"></i> Retake
                                                    </button>
                                                </div>
                                            </div>
                                            
                                            <div class="image-preview mb-2" id="customerImagePreview"></div>
                                            <div class="invalid-feedback">Please upload a valid image (JPG, JPEG, PNG, GIF, max 5MB).</div>
                                            <?php if ($edit_mode && $customer_data['customer_photo']): ?>
                                                <small class="text-muted mt-1 d-block">Current: <a href="<?php echo $customer_data['customer_photo']; ?>" target="_blank">View Photo</a></small>
                                            <?php endif; ?>
                                        </div>
                                    </div>
                                    
                                    <div class="col-md-6">
                                        <h5 class="mb-3">Nominee Information</h5>
                                        
                                        <div class="mb-3">
                                            <label for="nominee_name" class="form-label" style="font-weight: bold; font-size: 1rem;">Nominee Name <span class="text-danger">*</span></label>
                                            <input type="text" class="form-control" id="nominee_name" name="nominee_name" value="<?php echo $edit_mode ? htmlspecialchars($customer_data['nominee_name']) : (isset($_POST['nominee_name']) ? htmlspecialchars($_POST['nominee_name']) : ''); ?>" required>
                                            <div class="invalid-feedback">Nominee name is required.</div>
                                        </div>
                                        
                                        <div class="mb-3">
                                            <label for="nominee_number" class="form-label" style="font-weight: bold; font-size: 1rem;">Nominee Number <span class="text-danger">*</span></label>
                                            <input type="text" class="form-control" id="nominee_number" name="nominee_number" value="<?php echo $edit_mode ? htmlspecialchars($customer_data['nominee_number']) : (isset($_POST['nominee_number']) ? htmlspecialchars($_POST['nominee_number']) : ''); ?>" required pattern="\d{10}" maxlength="10">
                                            <div class="invalid-feedback">Nominee number must be 10 digits.</div>
                                        </div>
                                        
                                        <div class="mb-3">
                                            <label for="nominee_aadhar" class="form-label" style="font-weight: bold; font-size: 1rem;">Nominee Aadhar Number <span class="text-muted">(optional)</span></label>
                                            <input type="text" class="form-control" id="nominee_aadhar" name="nominee_aadhar" value="<?php echo $edit_mode ? htmlspecialchars($customer_data['nominee_aadhar']) : (isset($_POST['nominee_aadhar']) ? htmlspecialchars($_POST['nominee_aadhar']) : ''); ?>" pattern="\d{12}" maxlength="12">
                                            <div class="invalid-feedback">Aadhar number must be 12 digits.</div>
                                        </div>
                                        
                                        <div class="mb-3">
                                            <label for="aadhar_photo" class="form-label" style="font-weight: bold; font-size: 1rem;">Aadhar Photo <span class="text-muted">(optional)</span></label>
                                            <div class="d-flex gap-2 mb-2">
                                                
                                                <button type="button" class="btn btn-outline-primary btn-sm" id="captureAadharPhoto">
                                                    <i class="fas fa-camera me-1"></i> Take Photo
                                                </button>
                                                
                                                <button type="button" class="btn btn-outline-secondary btn-sm" id="uploadAadharPhoto">
                                                    <i class="fas fa-upload me-1"></i> Upload File
                                                </button>
                                            </div>
                                            
                                            <input type="file" class="form-control d-none" id="aadhar_photo" name="aadhar_photo" accept="image/*">
                                            
                                            <div class="camera-preview mb-2 d-none" id="aadharCameraPreview">
                                                <video id="aadharVideo" width="100%" height="200" autoplay muted class="rounded border"></video>
                                                <canvas id="aadharCanvas" class="d-none"></canvas>
                                                <div class="mt-2">
                                                    <button type="button" class="btn btn-success btn-sm" id="captureAadharBtn">
                                                        <i class="fas fa-camera me-1"></i> Capture
                                                    </button>
                                                    <button type="button" class="btn btn-secondary btn-sm" id="retakeAadharBtn">
                                                        <i class="fas fa-redo me-1"></i> Retake
                                                    </button>
                                                </div>
                                            </div>
                                            
                                            <div class="image-preview mb-2" id="aadharImagePreview"></div>
                                            <div class="invalid-feedback">Please upload a valid image (JPG, JPEG, PNG, GIF, max 5MB).</div>
                                            <?php if ($edit_mode && $customer_data['aadhar_photo']): ?>
                                                <small class="text-muted mt-1 d-block">Current: <a href="<?php echo $customer_data['aadhar_photo']; ?>" target="_blank">View Photo</a></small>
                                            <?php endif; ?>
                                        </div>
                                    </div>
                                </div>

<h5 class="mb-3">Loan and Agreement Details</h5>
                                <div class="row g-3">
                                    
                                    <div class="col-md-6">
                                        <label for="finance_id" class="form-label" style="font-weight: bold; font-size: 1rem;">Select Finance <span class="text-danger">*</span></label>
                                        <select class="form-control" id="finance_id" name="finance_id" required>
                                            <option value="" disabled <?php echo $finance_id == 0 ? 'selected' : ''; ?>>Choose Finance</option>
                                            <?php foreach ($finances as $finance): ?>
                                                <option value="<?php echo $finance['id']; ?>" <?php echo ($finance_id == $finance['id'] || ($edit_mode && $customer_data['finance_id'] == $finance['id'])) ? 'selected' : ''; ?>>
                                                    <?php echo htmlspecialchars($finance['finance_name']); ?>
                                                </option>
                                            <?php endforeach; ?>
                                        </select>
                                        <div class="invalid-feedback">Please select a finance.</div>
                                    </div>
                                    
                                    <div class="col-md-6">
                                        <label for="agreement_number" class="form-label" style="font-weight: bold; font-size: 1rem;">Agreement Number <span class="text-danger">*</span></label>
                                        <input type="text" class="form-control" id="agreement_number" name="agreement_number" value="<?php echo $edit_mode ? htmlspecialchars($customer_data['agreement_number']) : (isset($_POST['agreement_number']) ? htmlspecialchars($_POST['agreement_number']) : ''); ?>" required>
                                        <div class="invalid-feedback">Agreement number is required.</div>
                                    </div>
                                    
                                    <div class="col-md-6">
                                        <label for="loan_id" class="form-label" style="font-weight: bold; font-size: 1rem;">Select Loan <span class="text-danger">*</span></label>
                                        <select class="form-control" id="loan_id" name="loan_id" required <?php echo empty($loans) ? 'disabled' : ''; ?>>
                                            <option value="" disabled selected>Choose Loan</option>
                                            <?php if (!empty($loans)): ?>
                                                <?php foreach ($loans as $loan): ?>
                                                    <option value="<?php echo $loan['id']; ?>" 
                                                            data-amount="<?php echo $loan['loan_amount']; ?>"
                                                            data-interest="<?php echo $loan['interest_rate']; ?>"
                                                            data-tenure="<?php echo $loan['loan_tenure']; ?>"
                                                            data-is-vehicle="<?php echo stripos($loan['loan_name'], 'vehicle') !== false ? 'true' : 'false'; ?>"
                                                            <?php echo ($edit_mode && $customer_data['loan_id'] == $loan['id']) ? 'selected' : ''; ?>>
                                                        <?php echo htmlspecialchars($loan['loan_name']); ?>
                                                    </option>
                                                <?php endforeach; ?>
                                            <?php else: ?>
                                                <option value="" disabled>No loans available for selected finance</option>
                                            <?php endif; ?>
                                        </select>
                                        <div class="invalid-feedback">Please select a loan.</div>
                                        <?php if (empty($loans) && $finance_id > 0): ?>
                                            <small class="text-warning">No loans found for this finance. Please add loans first.</small>
                                        <?php endif; ?>
                                    </div>
                                    
                                    <div class="col-md-6">
                                        <label for="loan_amount" class="form-label" style="font-weight: bold; font-size: 1rem;">Loan Amount (₹) <span class="text-danger">*</span></label>
                                        <input type="number" class="form-control" id="loan_amount" name="loan_amount" min="0" step="0.01" value="<?php echo $edit_mode ? htmlspecialchars($customer_data['loan_amount']) : (isset($_POST['loan_amount']) ? htmlspecialchars($_POST['loan_amount']) : ''); ?>" required>
                                        <div class="invalid-feedback">Please enter a valid loan amount.</div>
                                    </div>
                                    
                                    <div class="col-md-6">
                                        <label for="interest_rate" class="form-label" style="font-weight: bold; font-size: 1rem;">Interest Rate (% per month) <span class="text-danger">*</span></label>
                                        <input type="number" class="form-control" id="interest_rate" name="interest_rate" min="0" step="0.01" value="<?php echo $edit_mode ? htmlspecialchars($customer_data['interest_rate']) : (isset($_POST['interest_rate']) ? htmlspecialchars($_POST['interest_rate']) : ''); ?>" required>
                                        <div class="invalid-feedback">Please enter a valid interest rate.</div>
                                    </div>
                                    
                                    <div class="col-md-6">
                                        <label for="loan_tenure" class="form-label" style="font-weight: bold; font-size: 1rem;">Loan Tenure (Months) <span class="text-danger">*</span></label>
                                        <input type="number" class="form-control" id="loan_tenure" name="loan_tenure" min="1" value="<?php echo $edit_mode ? htmlspecialchars($customer_data['loan_tenure']) : (isset($_POST['loan_tenure']) ? htmlspecialchars($_POST['loan_tenure']) : ''); ?>" required>
                                        <div class="invalid-feedback">Please enter a valid loan tenure.</div>
                                    </div>
                                    
                                    <div class="col-md-6">
                                        <label for="document_charge" class="form-label" style="font-weight: bold; font-size: 1rem;">Document Charge (₹) <span class="text-danger">*</span></label>
                                        <input type="number" class="form-control" id="document_charge" name="document_charge" min="0" step="0.01" value="<?php echo $edit_mode ? htmlspecialchars($customer_data['document_charge']) : (isset($_POST['document_charge']) ? htmlspecialchars($_POST['document_charge']) : '0'); ?>" required>
                                        <div class="invalid-feedback">Please enter a valid document charge.</div>
                                    </div>
                                    
                                    <div class="col-md-6">
                                        <label for="emi_date" class="form-label" style="font-weight: bold; font-size: 1rem;">Agreement Date (Base) <span class="text-danger">*</span></label>
                                        <input type="date" class="form-control" id="emi_date" name="emi_date" value="<?php echo $edit_mode ? htmlspecialchars($customer_data['emi_date']) : (isset($_POST['emi_date']) ? htmlspecialchars($_POST['emi_date']) : ''); ?>" required>
                                        <div class="invalid-feedback">Please select a valid agreement date.</div>
                                        <small class="text-muted">The agreement date for the loan.</small>
                                    </div>
                                    
                                    <div class="col-md-6">
                                        <label for="first_emi_date" class="form-label" style="font-weight: bold; font-size: 1rem;">First EMI Date <span class="text-danger">*</span></label>
                                        <input type="date" class="form-control" id="first_emi_date" name="first_emi_date" value="<?php echo $edit_mode && !empty($emi_schedule) ? htmlspecialchars($emi_schedule[0]['emi_due_date']) : (isset($_POST['first_emi_date']) ? htmlspecialchars($_POST['first_emi_date']) : ''); ?>" required>
                                        <div class="invalid-feedback">Please select a valid first EMI date (on or after agreement date).</div>
                                    </div>
                                    
                                    <div class="col-md-6" id="rc_number_field" style="display: none;">
                                        <label for="rc_number" class="form-label" style="font-weight: bold; font-size: 1rem;">RC Number <span class="text-muted">(optional)</span></label>
                                        <input type="text" class="form-control" id="rc_number" name="rc_number" value="<?php echo $edit_mode ? htmlspecialchars($customer_data['rc_number']) : (isset($_POST['rc_number']) ? htmlspecialchars($_POST['rc_number']) : ''); ?>" placeholder="e.g., TN-1234-AB-5678">
                                    </div>
                                    
                                    <div class="col-md-6" id="vehicle_type_field" style="display: none;">
                                        <label for="vehicle_type" class="form-label" style="font-weight: bold; font-size: 1rem;">Vehicle Type <span class="text-muted">(optional)</span></label>
                                        <select class="form-control" id="vehicle_type" name="vehicle_type">
                                            <option value="" selected>Select Vehicle Type (Optional)</option>
                                            <option value="Two-Wheeler" <?php echo ($edit_mode && $customer_data['vehicle_type'] === 'Two-Wheeler') || (isset($_POST['vehicle_type']) && $_POST['vehicle_type'] === 'Two-Wheeler') ? 'selected' : ''; ?>>Two-Wheeler</option>
                                            <option value="Car" <?php echo ($edit_mode && $customer_data['vehicle_type'] === 'Car') || (isset($_POST['vehicle_type']) && $_POST['vehicle_type'] === 'Car') ? 'selected' : ''; ?>>Car</option>
                                            <option value="Truck" <?php echo ($edit_mode && $customer_data['vehicle_type'] === 'Truck') || (isset($_POST['vehicle_type']) && $_POST['vehicle_type'] === 'Truck') ? 'selected' : ''; ?>>Truck</option>
                                            <option value="Others" <?php echo ($edit_mode && $customer_data['vehicle_type'] === 'Others') || (isset($_POST['vehicle_type']) && $_POST['vehicle_type'] === 'Others') ? 'selected' : ''; ?>>Others</option>
                                        </select>
                                    </div>
                                    
                                    <div class="col-md-6" id="vehicle_number_field" style="display: none;">
                                        <label for="vehicle_number" class="form-label" style="font-weight: bold; font-size: 1rem;">Vehicle Number <span class="text-muted">(optional)</span></label>
                                        <input type="text" class="form-control" id="vehicle_number" name="vehicle_number" value="<?php echo $edit_mode ? htmlspecialchars($customer_data['vehicle_number']) : (isset($_POST['vehicle_number']) ? htmlspecialchars($_POST['vehicle_number']) : ''); ?>" placeholder="Enter Vehicle Number">
                                    </div>
                                    
                                    <div class="col-md-6" id="vehicle_model_field" style="display: none;">
                                        <label for="vehicle_model" class="form-label" style="font-weight: bold; font-size: 1rem;">Vehicle Model <span class="text-muted">(optional)</span></label>
                                        <input type="text" class="form-control" id="vehicle_model" name="vehicle_model" value="<?php echo $edit_mode ? htmlspecialchars($customer_data['vehicle_model'] ?? '') : (isset($_POST['vehicle_model']) ? htmlspecialchars($_POST['vehicle_model']) : ''); ?>" placeholder="e.g., Pulsar 150, Activa, Swift Dzire">
                                    </div>
                                    
                                    <div class="col-md-6">
                                        <label for="principal_amount" class="form-label" style="font-weight: bold; font-size: 1rem;">Monthly Principal Amount (₹)</label>
                                        <input type="text" class="form-control" id="principal_amount" readonly value="<?php echo $edit_mode ? number_format($customer_data['principal_amount'] / $customer_data['loan_tenure'], 2) : ''; ?>">
                                    </div>
                                    
                                    <div class="col-md-6">
                                        <label for="interest_amount" class="form-label" style="font-weight: bold; font-size: 1rem;">Monthly Interest Amount (₹)</label>
                                        <input type="text" class="form-control" id="interest_amount" readonly value="<?php echo $edit_mode ? number_format($customer_data['interest_amount'] / $customer_data['loan_tenure'], 2) : ''; ?>">
                                    </div>
                                    
                                    <div class="col-md-6">
                                        <label for="estimated_emi" class="form-label" style="font-weight: bold; font-size: 1rem;">Estimated Monthly EMI (₹)</label>
                                        <input type="text" class="form-control" id="estimated_emi" readonly value="<?php echo $edit_mode ? number_format($customer_data['emi'], 2) : ''; ?>">
                                    </div>
                                    
                                    <div class="col-md-6">
                                        <label for="handover_amount" class="form-label" style="font-weight: bold; font-size: 1rem;">Handover Amount (₹)</label>
                                        <input type="text" class="form-control" id="handover_amount" readonly value="<?php echo $edit_mode ? number_format($customer_data['loan_amount'] - $customer_data['document_charge'], 2) : ''; ?>">
                                    </div>
                                    
                                    <div class="col-12 pt-3">
                                        <button type="submit" class="btn btn-primary"><?php echo $edit_mode ? 'Update Customer' : 'Save Customer'; ?></button>
                                        <a href="manage-customers.php" class="btn btn-light">Cancel</a>
                                    </div>
                                </div>
                            </form>
                        </div>
                    </div>

<?php if ($edit_mode && !empty($emi_schedule)): ?>
                        <div class="card mt-4">
                            <div class="card-header">
                                <h4 class="card-title mb-0">EMI Schedule</h4>
                                <small class="text-muted">Edit the due dates for each EMI if needed. Dates must be in sequence and on or after the first EMI date.</small>
                            </div>
                            <div class="card-body">
                                <div class="table-responsive">
                                    <table class="table table-bordered table-hover">
                                        <thead class="table-light">
                                            <tr>
                                                <th>#</th>
                                                <th>EMI Amount (₹)</th>
                                                <th>Principal Amount (₹)</th>
                                                <th>Interest Amount (₹)</th>
                                                <th>Due Date</th>
                                                <th>Status</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <?php foreach ($emi_schedule as $index => $emi): ?>
                                                <tr>
                                                    <td><?php echo $index + 1; ?></td>
                                                    <td><?php echo number_format($emi['emi_amount'], 2); ?></td>
                                                    <td><?php echo number_format($emi['principal_amount'], 2); ?></td>
                                                    <td><?php echo number_format($emi['interest_amount'], 2); ?></td>
                                                    <td>
                                                        <input type="date" class="form-control emi-due-date" name="emi_due_dates[]" value="<?php echo htmlspecialchars($emi['emi_due_date']); ?>" <?php echo $emi['status'] === 'paid' ? 'readonly' : ''; ?> data-index="<?php echo $index; ?>" required>
                                                        <div class="invalid-feedback"></div>
                                                    </td>
                                                    <td><?php echo htmlspecialchars($emi['status']); ?></td>
                                                </tr>
                                            <?php endforeach; ?>
                                        </tbody>
                                    </table>
                                </div>
                            </div>
                        </div>
                    <?php endif; ?>
                </div>

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

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

// Aadhar photo elements
                const aadharPhotoInput = document.getElementById('aadhar_photo');
                const captureAadharBtn = document.getElementById('captureAadharPhoto');
                const uploadAadharBtn = document.getElementById('uploadAadharPhoto');
                const aadharCameraPreview = document.getElementById('aadharCameraPreview');
                const aadharVideo = document.getElementById('aadharVideo');
                const aadharCanvas = document.getElementById('aadharCanvas');
                const captureAadharPhotoBtn = document.getElementById('captureAadharBtn');
                const retakeAadharBtn = document.getElementById('retakeAadharBtn');
                const aadharImagePreview = document.getElementById('aadharImagePreview');

let customerStream = null;
                let aadharStream = null;

// Customer Photo - Camera Capture
                captureCustomerBtn.addEventListener('click', function() {
                    startCamera(customerVideo, customerCameraPreview, function(stream) {
                        customerStream = stream;
                    });
                });

// Customer Photo - File Upload
                uploadCustomerBtn.addEventListener('click', function() {
                    customerPhotoInput.click();
                });

customerPhotoInput.addEventListener('change', function(e) {
                    handleFileSelect(e, customerImagePreview);
                });

// Customer Photo - Capture from camera
                captureCustomerPhotoBtn.addEventListener('click', function() {
                    capturePhoto(customerVideo, customerCanvas, customerImagePreview, customerCameraPreview);
                });

// Customer Photo - Retake
                retakeCustomerBtn.addEventListener('click', function() {
                    retakePhoto(customerCameraPreview, customerImagePreview, customerVideo);
                });

// Aadhar Photo - Camera Capture
                captureAadharBtn.addEventListener('click', function() {
                    startCamera(aadharVideo, aadharCameraPreview, function(stream) {
                        aadharStream = stream;
                    });
                });

// Aadhar Photo - File Upload
                uploadAadharBtn.addEventListener('click', function() {
                    aadharPhotoInput.click();
                });

aadharPhotoInput.addEventListener('change', function(e) {
                    handleFileSelect(e, aadharImagePreview);
                });

// Aadhar Photo - Capture from camera
                captureAadharPhotoBtn.addEventListener('click', function() {
                    capturePhoto(aadharVideo, aadharCanvas, aadharImagePreview, aadharCameraPreview);
                });

// Aadhar Photo - Retake
                retakeAadharBtn.addEventListener('click', function() {
                    retakePhoto(aadharCameraPreview, aadharImagePreview, aadharVideo);
                });

// Start camera function
                function startCamera(videoElement, previewElement, callback) {
                    if (navigator.mediaDevices && navigator.mediaDevices.getUserMedia) {
                        navigator.mediaDevices.getUserMedia({ video: true })
                            .then(function(stream) {
                                videoElement.srcObject = stream;
                                previewElement.classList.remove('d-none');
                                callback(stream);
                            })
                            .catch(function(error) {
                                console.error('Camera error:', error);
                                alert('Unable to access camera. Please check permissions or try uploading a file instead.');
                            });
                    } else {
                        alert('Your browser does not support camera access. Please upload a file instead.');
                    }
                }

// Capture photo function
                function capturePhoto(videoElement, canvasElement, previewElement, cameraPreview) {
                    const context = canvasElement.getContext('2d');
                    canvasElement.width = videoElement.videoWidth;
                    canvasElement.height = videoElement.videoHeight;
                    context.drawImage(videoElement, 0, 0, canvasElement.width, canvasElement.height);
                    
                    // Convert canvas to blob and create file
                    canvasElement.toBlob(function(blob) {
                        const file = new File([blob], 'captured_photo.jpg', { type: 'image/jpeg' });
                        const dataTransfer = new DataTransfer();
                        dataTransfer.items.add(file);
                        
                        // Set the file to the corresponding input
                        if (videoElement.id === 'customerVideo') {
                            customerPhotoInput.files = dataTransfer.files;
                        } else {
                            aadharPhotoInput.files = dataTransfer.files;
                        }
                        
                        // Show preview
                        const url = URL.createObjectURL(blob);
                        previewElement.innerHTML = `
                            <div class="border rounded p-2">
                                <img src="${url}" class="img-fluid rounded" style="max-height: 200px;">
                                <small class="text-muted d-block mt-1">Captured photo preview</small>
                            </div>
                        `;
                        
                        // Hide camera and stop stream
                        cameraPreview.classList.add('d-none');
                        stopCamera(videoElement);
                    }, 'image/jpeg', 0.8);
                }

// Retake photo function
                function retakePhoto(cameraPreview, imagePreview, videoElement) {
                    imagePreview.innerHTML = '';
                    cameraPreview.classList.remove('d-none');
                    startCamera(videoElement, cameraPreview, function(stream) {
                        if (videoElement.id === 'customerVideo') {
                            customerStream = stream;
                        } else {
                            aadharStream = stream;
                        }
                    });
                }

// Handle file selection
                function handleFileSelect(event, previewElement) {
                    const file = event.target.files[0];
                    if (file) {
                        const reader = new FileReader();
                        reader.onload = function(e) {
                            previewElement.innerHTML = `
                                <div class="border rounded p-2">
                                    <img src="${e.target.result}" class="img-fluid rounded" style="max-height: 200px;">
                                    <small class="text-muted d-block mt-1">${file.name}</small>
                                </div>
                            `;
                        };
                        reader.readAsDataURL(file);
                    }
                }

// Stop camera stream
                function stopCamera(videoElement) {
                    if (videoElement.srcObject) {
                        videoElement.srcObject.getTracks().forEach(track => track.stop());
                        videoElement.srcObject = null;
                    }
                }

// Stop cameras when leaving page
                window.addEventListener('beforeunload', function() {
                    if (customerStream) {
                        customerStream.getTracks().forEach(track => track.stop());
                    }
                    if (aadharStream) {
                        aadharStream.getTracks().forEach(track => track.stop());
                    }
                });
            });

// Bootstrap client-side validation and EMI date validation
            (function () {
                'use strict';
                const form = document.getElementById('customerForm');
                form.addEventListener('submit', function (event) {
                    let isValid = true;
                    const emiDate = document.getElementById('emi_date').value;
                    const firstEmiDate = document.getElementById('first_emi_date').value;
                    const emiDueDates = document.querySelectorAll('.emi-due-date');

// Validate agreement date vs first EMI date
                    if (emiDate && firstEmiDate && new Date(firstEmiDate) < new Date(emiDate)) {
                        document.getElementById('first_emi_date').classList.add('is-invalid');
                        document.getElementById('first_emi_date').nextElementSibling.textContent = 'First EMI date must be on or after the agreement date.';
                        isValid = false;
                    } else {
                        document.getElementById('first_emi_date').classList.remove('is-invalid');
                    }

// Validate EMI due dates
                    let previousDate = firstEmiDate;
                    emiDueDates.forEach((input, index) => {
                        const currentDate = input.value;
                        if (!currentDate) {
                            input.classList.add('is-invalid');
                            input.nextElementSibling.textContent = `EMI due date #${index + 1} is required.`;
                            isValid = false;
                        } else if (index === 0 && new Date(currentDate) < new Date(firstEmiDate)) {
                            input.classList.add('is-invalid');
                            input.nextElementSibling.textContent = `EMI due date #1 must be on or after the first EMI date.`;
                            isValid = false;
                        } else if (index > 0 && previousDate && new Date(currentDate) <= new Date(previousDate)) {
                            input.classList.add('is-invalid');
                            input.nextElementSibling.textContent = `EMI due date #${index + 1} must be after the previous EMI date.`;
                            isValid = false;
                        } else {
                            input.classList.remove('is-invalid');
                        }
                        previousDate = currentDate;
                    });

// Validate photo uploads
                    ['customer_photo', 'aadhar_photo'].forEach(id => {
                        const input = document.getElementById(id);
                        if (input.files.length > 0) {
                            const file = input.files[0];
                            const allowedExt = ['image/jpeg', 'image/jpg', 'image/png', 'image/gif'];
                            const maxSize = 5 * 1024 * 1024; // 5MB
                            
                            if (!allowedExt.includes(file.type)) {
                                input.classList.add('is-invalid');
                                isValid = false;
                            } else if (file.size > maxSize) {
                                input.classList.add('is-invalid');
                                isValid = false;
                            } else {
                                input.classList.remove('is-invalid');
                            }
                        }
                    });

if (!form.checkValidity() || !isValid) {
                        event.preventDefault();
                        event.stopPropagation();
                    }
                    form.classList.add('was-validated');
                }, false);

// Real-time validation for EMI due dates
                document.querySelectorAll('.emi-due-date').forEach(input => {
                    input.addEventListener('change', function () {
                        const index = parseInt(this.getAttribute('data-index'));
                        const firstEmiDate = document.getElementById('first_emi_date').value;
                        const previousInput = index > 0 ? document.querySelector(`.emi-due-date[data-index="${index - 1}"]`) : null;
                        const previousDate = previousInput ? previousInput.value : firstEmiDate;

if (!this.value) {
                            this.classList.add('is-invalid');
                            this.nextElementSibling.textContent = `EMI due date #${index + 1} is required.`;
                        } else if (index === 0 && firstEmiDate && new Date(this.value) < new Date(firstEmiDate)) {
                            this.classList.add('is-invalid');
                            this.nextElementSibling.textContent = `EMI due date #1 must be on or after the first EMI date.`;
                        } else if (index > 0 && previousDate && new Date(this.value) <= new Date(previousDate)) {
                            this.classList.add('is-invalid');
                            this.nextElementSibling.textContent = `EMI due date #${index + 1} must be after the previous EMI date.`;
                        } else {
                            this.classList.remove('is-invalid');
                        }
                    });
                });
            })();

// Default calculations on load
            document.addEventListener('DOMContentLoaded', function () {
                calculateEMI();
                toggleVehicleFields();
            });

// Auto-submit form when finance changes to reload loans
            document.getElementById('finance_id').addEventListener('change', function() {
                this.form.submit();
            });

// Auto-fill loan details when loan is selected
            document.getElementById('loan_id').addEventListener('change', function() {
                const selectedOption = this.options[this.selectedIndex];
                if (selectedOption && selectedOption.value) {
                    document.getElementById('loan_amount').value = selectedOption.getAttribute('data-amount') || '';
                    document.getElementById('interest_rate').value = selectedOption.getAttribute('data-interest') || '';
                    document.getElementById('loan_tenure').value = selectedOption.getAttribute('data-tenure') || '';
                    toggleVehicleFields();
                    calculateEMI();
                }
            });

// Recalculate EMI and handover amount
            ['loan_amount', 'interest_rate', 'loan_tenure', 'document_charge'].forEach(id => {
                document.getElementById(id).addEventListener('input', calculateEMI);
            });

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: add-customer.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation