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: overdue-customers.php

<?php
// Enable error reporting for debugging
ini_set('display_errors', 1);
error_reporting(E_ALL);

// Database connection
include 'includes/db.php'; // Ensure this file contains your database connection logic

// Query to fetch overdue EMI data along with customer and loan details
$sql = "SELECT customers.id AS customer_id, customers.customer_name, customers.customer_number, 
               loans.loan_name, emi_schedule.emi_amount, emi_schedule.emi_due_date, emi_schedule.overdue_charges
        FROM emi_schedule
        LEFT JOIN customers ON emi_schedule.customer_id = customers.id
        LEFT JOIN loans ON customers.loan_id = loans.id
        WHERE emi_schedule.status = 'overdue' OR emi_schedule.overdue_charges > 0";

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

// Debug query results
if (!$result) {
    error_log("Error fetching overdue data: " . mysqli_error($conn));
    echo "<pre>Error fetching overdue data: " . mysqli_error($conn) . "</pre>";
    die();
}

$rows = mysqli_num_rows($result);
echo "";

<!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="page-wrapper">
      
      <div class="page-content">
        <div class="container-fluid">
          
          <?php
          $page_title = "Overdue Customers";
          $breadcrumb_active = "Overdue Customers";
          ?>
          <div class="row">
            <div class="col-sm-12">
              <div class="page-title-box d-md-flex justify-content-md-between align-items-center">
                <h4 class="page-title"><?php echo $page_title; ?></h4>
                <div class="">
                  <ol class="breadcrumb mb-0">
                    <li class="breadcrumb-item"><a href="index.php">Dashboard</a></li>
                    <li class="breadcrumb-item active"><?php echo $breadcrumb_active; ?></li>
                  </ol>
                </div>                            
              </div>
            </div>
          </div>

<div class="row align-items-center mb-3">
            <div class="col">
              <h3 class="mb-0">Overdue Customers</h3>
              <small class="text-muted">View customers with overdue EMI payments.</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">Overdue EMI List</h4>
            </div>
            <div class="card-body">
              <div class="table-responsive">
                <table id="tblOverdueCustomers" class="table table-striped table-bordered align-middle w-100">
                  <thead class="table-light">
                    <tr>
                      <th>#Customer ID</th>
                      <th>Customer Name</th>
                      <th>Customer Number</th>
                      <th>EMI Amount (₹)</th>
                      <th>EMI Due Date</th>
                      <th>Overdue Charges (₹)</th>
                      <th class="text-end">Action</th>
                    </tr>
                  </thead>
                  <tbody>
                    <?php if (mysqli_num_rows($result) > 0) { ?>
                      <?php while ($row = mysqli_fetch_assoc($result)) { ?>
                        <tr>
                          <td>
                            <a href="#" class="customer-id" data-customer-id="<?php echo $row['customer_id']; ?>" data-bs-toggle="modal" data-bs-target="#customerDetailsModal">
                              <?php echo "CUST-" . $row['customer_id']; ?>
                            </a>
                          </td>
                          <td>
                            <a href="#" class="customer-name" data-customer-id="<?php echo $row['customer_id']; ?>" data-bs-toggle="modal" data-bs-target="#customerDetailsModal">
                              <?php echo htmlspecialchars($row['customer_name']); ?>
                            </a>
                          </td>
                          <td><?php echo htmlspecialchars($row['customer_number']); ?></td>
                          <td><?php echo number_format($row['emi_amount'], 2); ?></td>
                          <td><?php echo $row['emi_due_date']; ?></td>
                          <td><?php echo $row['overdue_charges'] > 0 ? number_format($row['overdue_charges'], 2) : '-'; ?></td>
                          <td class="text-end">
                            <button class="btn btn-sm btn-info" onclick="showEMISchedule(<?php echo $row['customer_id']; ?>)">Show EMI Schedule</button>
                            <a href="edit-customer.php?id=<?php echo $row['customer_id']; ?>" class="btn btn-sm btn-soft-primary">
                              <i class="las la-edit"></i>
                            </a>
                            <a href="delete-customer.php?id=<?php echo $row['customer_id']; ?>" class="btn btn-sm btn-soft-danger" onclick="return confirm('Are you sure you want to delete this customer?')">
                              <i class="las la-trash"></i>
                            </a>
                          </td>
                        </tr>
                      <?php } ?>
                    <?php } else { ?>
                      <tr>
                        <td></td>
                        <td></td>
                        <td></td>
                        <td class="text-center">No overdue EMIs found.</td>
                        <td></td>
                        <td></td>
                        <td></td>
                      </tr>
                    <?php } ?>
                  </tbody>
                </table>
              </div>
            </div>
          </div>
        </div>

<div class="modal fade" id="customerDetailsModal" tabindex="-1" aria-labelledby="customerDetailsModalLabel" aria-hidden="true">
          <div class="modal-dialog modal-lg">
            <div class="modal-content">
              <div class="modal-header">
                <h5 class="modal-title" id="customerDetailsModalLabel">Customer Details</h5>
                <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
              </div>
              <div class="modal-body">
                <div id="customerDetailsContent">
                  <p>Loading customer details...</p>
                </div>
              </div>
              <div class="modal-footer">
                <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Close</button>
              </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>

// Log DataTables errors to console
      $('#tblOverdueCustomers').on('error.dt', function(e, settings, techNote, message) {
        console.error('DataTables error: ', message);
      });

// Initialize DataTable
      $(document).ready(function() {
        $('#tblOverdueCustomers').DataTable({
          pageLength: 10,
          order: [[0, 'desc']], // Sort by Customer ID
        });

// Handle click on customer name or ID to fetch details via AJAX
        $('.customer-name, .customer-id').on('click', function(e) {
          e.preventDefault();
          var customerId = $(this).data('customer-id');
          
          $.ajax({
            url: 'get-customer-details.php',
            type: 'GET',
            data: { customer_id: customerId },
            dataType: 'html',
            beforeSend: function() {
              $('#customerDetailsContent').html('<p>Loading customer details...</p>');
              console.log('Sending AJAX request for customer ID: ' + customerId);
            },
            success: function(response) {
              $('#customerDetailsContent').html(response);
              // Initialize DataTable for customer details
              $('#customerDetailsTable').DataTable({
                pageLength: 10,
                searching: false,
                paging: false,
                info: false
              });
              console.log('AJAX request successful for customer ID: ' + customerId);
            },
            error: function(xhr, status, error) {
              $('#customerDetailsContent').html('<p class="text-danger">Error loading customer details: ' + error + '</p>');
              console.log('AJAX Error Details:');
              console.log('Status: ' + status);
              console.log('Error: ' + error);
              console.log('Response Text: ' + xhr.responseText);
              console.log('Status Code: ' + xhr.status);
              console.log('Status Text: ' + xhr.statusText);
              console.log('URL: ' + this.url);
            }
          });
        });
      });

// Function to show EMI schedule
      function showEMISchedule(customerId) {
        window.location.href = 'emi-schedule.php?customer_id=' + customerId;
      }
    </script>
</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: overdue-customers.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation