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

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

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

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

// Fetch the customer details and their EMI schedule
$sql = "SELECT c.customer_name, c.customer_number, c.emi_date, 
               e.emi_amount, e.principal_amount, e.interest_amount, e.emi_due_date, e.id AS emi_id, e.status, e.overdue_charges
        FROM emi_schedule e
        JOIN customers c ON e.customer_id = c.id
        WHERE e.customer_id = $customer_id
        ORDER BY e.emi_due_date";

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

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

// Fetch the customer details (we'll use this for the page header)
$customer = mysqli_fetch_assoc($result);
mysqli_data_seek($result, 0); // Reset result pointer to fetch all EMI records

if (mysqli_num_rows($result) == 0) {
    die("No EMI schedule found for this customer.");
}

// Calculate totals for outstanding amounts
$total_outstanding_principal = 0;
$total_outstanding_interest = 0;
$total_outstanding_amount = 0;
$total_overdue_charges = 0;
mysqli_data_seek($result, 0);
while ($row = mysqli_fetch_assoc($result)) {
    if ($row['status'] !== 'paid') {
        $emi_due_date = $row['emi_due_date'];
        $emi_amount = $row['emi_amount'];
        $principal_amount = $row['principal_amount'];
        $interest_amount = $row['interest_amount'];
        $current_date = date('Y-m-d');
        $overdue_days = 0;
        $overdue_charges = 0;
        if ($emi_due_date < $current_date) {
            $date_diff = (strtotime($current_date) - strtotime($emi_due_date)) / (60 * 60 * 24);
            $overdue_days = $date_diff;
            $overdue_charges = ($emi_amount / 1000) * 2 * $date_diff; // ₹2 per ₹1000 per day
        }
        $total_outstanding_principal += $principal_amount;
        $total_outstanding_interest += $interest_amount;
        $total_outstanding_amount += $emi_amount;
        $total_overdue_charges += $overdue_charges;
    }
}
$foreclosure_charge = $total_outstanding_principal * 0.02; // Default 2% of principal
$total_foreclosure_amount = $total_outstanding_principal + $total_outstanding_interest + $total_overdue_charges + $foreclosure_charge;

mysqli_data_seek($result, 0); // Reset result pointer again for table/card rendering
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">EMI Schedule for <?php echo htmlspecialchars($customer['customer_name']); ?></h3>
              <small class="text-muted">Manage and mark the EMI payments or foreclose the loan.</small>
            </div>
            <div class="col-auto">
              <a href="manage-customers.php" class="btn btn-light">Back to Customers</a>
              <button type="button" class="btn btn-primary" data-bs-toggle="modal" data-bs-target="#foreclosureModal">Foreclose Loan</button>
            </div>
          </div>

<div class="card mb-3">
            <div class="card-body">
              <div class="row">
                <div class="col-md-4">
                  <h5>Total Outstanding Principal: ₹<?php echo number_format($total_outstanding_principal, 2); ?></h5>
                </div>
                <div class="col-md-4">
                  <h5>Total Outstanding Interest: ₹<?php echo number_format($total_outstanding_interest, 2); ?></h5>
                </div>
                <div class="col-md-4">
                  <h5>Total Outstanding Amount: ₹<?php echo number_format($total_outstanding_amount, 2); ?></h5>
                </div>
              </div>
            </div>
          </div>

<?php if (isset($_GET['msg'])) { ?>
            <div class="alert alert-success" role="alert">
              <?php echo htmlspecialchars($_GET['msg']); ?>
            </div>
          <?php } elseif (isset($_GET['error'])) { ?>
            <div class="alert alert-danger" role="alert">
              <?php echo htmlspecialchars($_GET['error']); ?>
            </div>
          <?php } ?>

<div class="card d-none d-md-block">
            <div class="card-header">
              <h4 class="card-title mb-0">EMI Payment Schedule</h4>
            </div>
            <div class="card-body">
              <div class="table-responsive">
                <table id="tblEMISchedule" class="table table-striped table-bordered align-middle w-100">
                  <thead class="table-light">
                    <tr>
                      <th>#EMI ID</th>
                      <th>Principal Amount (₹)</th>
                      <th>Interest Amount (₹)</th>
                      <th>EMI Amount (₹)</th>
                      <th>Due Date</th>
                      <th>Overdue Days</th>
                      <th>Overdue Charges (₹)</th>
                      <th>Status</th>
                      <th>Action</th>
                    </tr>
                  </thead>
                  <tbody>
                    <?php
                    // Fetch all EMI details for the selected customer
                    while ($row = mysqli_fetch_assoc($result)) {
                      $emi_id = $row['emi_id'];
                      $principal_amount = $row['principal_amount'];
                      $interest_amount = $row['interest_amount'];
                      $emi_amount = $row['emi_amount'];
                      $emi_due_date = $row['emi_due_date'];
                      $overdue_charges = $row['overdue_charges'];

// Calculate overdue days
                      $current_date = date('Y-m-d');
                      $overdue_days = 0;
                      if ($emi_due_date < $current_date) {
                        $date_diff = (strtotime($current_date) - strtotime($emi_due_date)) / (60 * 60 * 24);
                        $overdue_days = $date_diff;
                        $overdue_charges = ($emi_amount / 1000) * 2 * $date_diff; // ₹2 per ₹1000 per day
                      }

// Get EMI status: Paid or Pending
                      $status = $row['status'];
                      $status_display = $status === 'paid' ? 'Paid' : ($status === 'overdue' ? 'Overdue' : 'Pending');

// Display EMI details
                      echo "<tr>
                            <td>EMI-$emi_id</td>
                            <td>" . number_format($principal_amount, 2) . "</td>
                            <td>" . number_format($interest_amount, 2) . "</td>
                            <td>" . number_format($emi_amount, 2) . "</td>
                            <td>$emi_due_date</td>
                            <td>$overdue_days</td>
                            <td>" . ($overdue_charges > 0 ? number_format($overdue_charges, 2) : '-') . "</td>
                            <td><span class='badge bg-" . ($status === 'paid' ? 'success' : ($status === 'overdue' ? 'danger' : 'warning')) . "'>$status_display</span></td>
                            <td class='text-end'>";

// If EMI is paid, show the Undo button
                            if ($status === 'paid') {
                              echo "<a href='undo-payment.php?emi_id=$emi_id' class='btn btn-sm btn-soft-danger' onclick='return confirm(\"Are you sure you want to undo this payment?\")'>Undo Payment</a>";
                            } else {
                              // If EMI is not paid, show the Mark as Paid button
                              echo "<a href='pay-emi.php?emi_id=$emi_id' class='btn btn-sm btn-soft-success' onclick='return confirm(\"Are you sure you want to mark this EMI as paid?\")'>Mark as Paid</a>";
                            }

// If the EMI is overdue, highlight overdue charges
                            if ($overdue_charges > 0 && $status !== 'paid') {
                              echo "<br><small class='text-danger'>Overdue Charges: ₹" . number_format($overdue_charges, 2) . "</small>";
                            }
                      echo "</td>
                          </tr>";
                    }
                    ?>
                  </tbody>
                </table>
              </div>
            </div>
          </div>

<div class="d-md-none">
            <?php
            // Fetch all EMI details for the selected customer
            mysqli_data_seek($result, 0);
            while ($row = mysqli_fetch_assoc($result)) {
              $emi_id = $row['emi_id'];
              $principal_amount = $row['principal_amount'];
              $interest_amount = $row['interest_amount'];
              $emi_amount = $row['emi_amount'];
              $emi_due_date = $row['emi_due_date'];
              $overdue_charges = $row['overdue_charges'];

// Calculate overdue days
              $current_date = date('Y-m-d');
              $overdue_days = 0;
              if ($emi_due_date < $current_date) {
                $date_diff = (strtotime($current_date) - strtotime($emi_due_date)) / (60 * 60 * 24);
                $overdue_days = $date_diff;
                $overdue_charges = ($emi_amount / 1000) * 2 * $date_diff; // ₹2 per ₹1000 per day
              }

// Get EMI status: Paid or Pending
              $status = $row['status'];
              $status_display = $status === 'paid' ? 'Paid' : ($status === 'overdue' ? 'Overdue' : 'Pending');
            ?>

<div class="card mb-3">
              <div class="card-body">
                <h5 class="card-title">EMI-<?php echo $emi_id; ?></h5>
                <p><strong>Principal Amount:</strong> ₹<?php echo number_format($principal_amount, 2); ?></p>
                <p><strong>Interest Amount:</strong> ₹<?php echo number_format($interest_amount, 2); ?></p>
                <p><strong>EMI Amount:</strong> ₹<?php echo number_format($emi_amount, 2); ?></p>
                <p><strong>Due Date:</strong> <?php echo $emi_due_date; ?></p>
                <p><strong>Overdue Days:</strong> <?php echo $overdue_days; ?></p>
                <p><strong>Overdue Charges:</strong> ₹<?php echo ($overdue_charges > 0 ? number_format($overdue_charges, 2) : '-'); ?></p>
                <p><strong>Status:</strong> <span class="badge bg-<?php echo ($status === 'paid' ? 'success' : ($status === 'overdue' ? 'danger' : 'warning')); ?>"><?php echo $status_display; ?></span></p>
                <div class="d-flex justify-content-end">
                  <?php
                  // If EMI is paid, show the Undo button
                  if ($status === 'paid') {
                    echo "<a href='undo-payment.php?emi_id=$emi_id' class='btn btn-sm btn-soft-danger' onclick='return confirm(\"Are you sure you want to undo this payment?\")'>Undo Payment</a>";
                  } else {
                    // If EMI is not paid, show the Mark as Paid button
                    echo "<a href='pay-emi.php?emi_id=$emi_id' class='btn btn-sm btn-soft-success' onclick='return confirm(\"Are you sure you want to mark this EMI as paid?\")'>Mark as Paid</a>";
                  }
                  ?>
                </div>
              </div>
            </div>

<?php } ?>
          </div>

<div class="modal fade" id="foreclosureModal" tabindex="-1" aria-labelledby="foreclosureModalLabel" aria-hidden="true">
            <div class="modal-dialog">
              <div class="modal-content">
                <div class="modal-header">
                  <h5 class="modal-title" id="foreclosureModalLabel">Confirm Loan Foreclosure</h5>
                  <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
                </div>
                <form action="foreclose-loan.php" method="POST">
                  <div class="modal-body">
                    <input type="hidden" name="customer_id" value="<?php echo $customer_id; ?>">
                    <p><strong>Customer:</strong> <?php echo htmlspecialchars($customer['customer_name']); ?></p>
                    <div class="mb-3">
                      <label for="principal_amount" class="form-label"><strong>Total Outstanding Principal (₹):</strong></label>
                      <input type="number" step="0.01" class="form-control" id="principal_amount" name="principal_amount" value="<?php echo number_format($total_outstanding_principal, 2, '.', ''); ?>" required>
                    </div>
                    <div class="mb-3">
                      <label for="interest_amount" class="form-label"><strong>Total Outstanding Interest (₹):</strong></label>
                      <input type="number" step="0.01" class="form-control" id="interest_amount" name="interest_amount" value="<?php echo number_format($total_outstanding_interest, 2, '.', ''); ?>" required>
                    </div>
                    <div class="mb-3">
                      <label for="overdue_charges" class="form-label"><strong>Total Overdue Charges (₹):</strong></label>
                      <input type="number" step="0.01" class="form-control" id="overdue_charges" name="overdue_charges" value="<?php echo number_format($total_overdue_charges, 2, '.', ''); ?>" readonly>
                    </div>
                    <div class="mb-3">
                      <label for="foreclosure_charge" class="form-label"><strong>Foreclosure Charge (₹):</strong></label>
                      <input type="number" step="0.01" class="form-control" id="foreclosure_charge" name="foreclosure_charge" value="<?php echo number_format($foreclosure_charge, 2, '.', ''); ?>" required>
                    </div>
                    <div class="mb-3">
                      <label for="total_amount" class="form-label"><strong>Total Amount to Pay (₹):</strong></label>
                      <input type="number" step="0.01" class="form-control" id="total_amount" name="total_amount" value="<?php echo number_format($total_foreclosure_amount, 2, '.', ''); ?>" readonly>
                    </div>
                    <p>Are you sure you want to foreclose this loan? This will mark all remaining EMIs as paid and close the loan.</p>
                  </div>
                  <div class="modal-footer">
                    <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Cancel</button>
                    <button type="submit" class="btn btn-primary" onclick="return confirm('Are you sure you want to foreclose the loan for ₹' + document.getElementById('total_amount').value + '?')">Confirm Foreclosure</button>
                  </div>
                </form>
              </div>
            </div>
          </div>

</div>

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

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

<link rel="stylesheet" href="https://cdn.datatables.net/1.13.8/css/dataTables.bootstrap5.min.css">
    <script src="https://code.jquery.com/jquery-3.7.1.min.js"></script>
    <script src="https://cdn.datatables.net/1.13.8/js/jquery.dataTables.min.js"></script>
    <script src="https://cdn.datatables.net/1.13.8/js/dataTables.bootstrap5.min.js"></script>

// Dynamically update total amount when principal, interest, or foreclosure charge changes
        $('#principal_amount, #interest_amount, #foreclosure_charge').on('input', function() {
          let principal = parseFloat($('#principal_amount').val()) || 0;
          let interest = parseFloat($('#interest_amount').val()) || 0;
          let overdue = parseFloat($('#overdue_charges').val()) || 0;
          let foreclosure = parseFloat($('#foreclosure_charge').val()) || 0;
          let total = principal + interest + overdue + foreclosure;
          $('#total_amount').val(total.toFixed(2));
        });
      });
    </script>

</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: emi-schedule.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation