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: pay-emi.php

<?php
// Database connection
include 'includes/db.php';  // Make sure this file contains your database connection logic

// Fetch the EMI ID from the URL query string
$emi_id = isset($_GET['emi_id']) ? $_GET['emi_id'] : 0;

// Check if the EMI ID is provided
if ($emi_id == 0) {
    die("Error: EMI ID is missing.");
}

// Fetch the EMI details from the database
$sql = "SELECT e.customer_id, e.emi_amount, e.emi_due_date, e.status, c.customer_name
        FROM emi_schedule e
        JOIN customers c ON e.customer_id = c.id
        WHERE e.id = $emi_id";

$result = mysqli_query($conn, $sql);

// Check if the query is successful
if (!$result) {
    die("Error fetching EMI data: " . mysqli_error($conn));
}

// If no records are found
if (mysqli_num_rows($result) == 0) {
    die("No EMI schedule found for this EMI ID.");
}

$emi = mysqli_fetch_assoc($result);

// Check if EMI is already paid
if ($emi['status'] == 'paid') {
    die("This EMI has already been paid.");
}

// Calculate overdue charges if any
$current_date = date('Y-m-d');
$overdue_charges = 0;

// If the EMI is overdue
if ($emi['emi_due_date'] < $current_date) {
    // Calculate overdue charges (₹1000 per day)
    $date_diff = (strtotime($current_date) - strtotime($emi['emi_due_date'])) / (60 * 60 * 24);
    $overdue_charges = $date_diff * 1000; // ₹1000 per day
}

// Handle the payment process (update the status of the EMI as paid)
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    // Get the modified overdue charges value
    $overdue_charges = $_POST['overdue_charges'];

// Mark the EMI as paid
    $update_sql = "UPDATE emi_schedule SET status = 'paid', paid_date = '$current_date', overdue_charges = '$overdue_charges' WHERE id = $emi_id";
    if (mysqli_query($conn, $update_sql)) {
        // Redirect back to EMI schedule page with success message
        header("Location: emi-schedule.php?customer_id=" . $emi['customer_id'] . "&msg=EMI Paid successfully");
        exit();
    } else {
        die("Error updating EMI payment status: " . mysqli_error($conn));
    }
}

mysqli_close($conn);
?>

<!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">
    <div class="brand">
      <a href="index.php" class="logo">
        <span>
          <img src="assets/images/logo-sm.png" alt="logo-small" class="logo-sm">
        </span>
        <span class="">
          <img src="assets/images/logo-light.png" alt="logo-large" class="logo-lg logo-light">
          <img src="assets/images/logo-dark.png" alt="logo-large" class="logo-lg logo-dark">
        </span>
      </a>
    </div>
    <?php include 'includes/leftbar.php'; ?>
    <div class="startbar-overlay d-print-none"></div>

<div class="row align-items-center mb-3">
            <div class="col">
              <h3 class="mb-0">Pay EMI for <?php echo htmlspecialchars($emi['customer_name']); ?></h3>
              <small class="text-muted">Make payment for the selected EMI.</small>
            </div>
            <div class="col-auto">
              <a href="emi-schedule.php?customer_id=<?php echo $emi['customer_id']; ?>" class="btn btn-light">Back to EMI Schedule</a>
            </div>
          </div>

<div class="card">
            <div class="card-header">
              <h4 class="card-title mb-0">EMI Payment Details</h4>
            </div>
            <div class="card-body">
              <form action="pay-emi.php?emi_id=<?php echo $emi_id; ?>" method="POST" novalidate>
                <div class="row g-3">
                  
                  <div class="col-md-6">
                    <label for="emi_amount" class="form-label">EMI Amount (₹)</label>
                    <input type="text" class="form-control" id="emi_amount" value="<?php echo number_format($emi['emi_amount'], 2); ?>" readonly>
                  </div>

<div class="col-md-6">
                    <label for="emi_due_date" class="form-label">EMI Due Date</label>
                    <input type="text" class="form-control" id="emi_due_date" value="<?php echo $emi['emi_due_date']; ?>" readonly>
                  </div>

<div class="col-md-6">
                    <label for="overdue_charges" class="form-label">Overdue Charges (₹)</label>
                    <input type="number" class="form-control" id="overdue_charges" name="overdue_charges" value="<?php echo number_format($overdue_charges, 2); ?>" step="0.01" required>
                  </div>

<div class="col-12 pt-3">
                    <button type="submit" class="btn btn-success">Confirm Payment</button>
                  </div>
                </div>
              </form>
            </div>
          </div>
        </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: pay-emi.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation