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-collections.php

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

// Get current month, year, and date
$current_month = date('m');
$current_year = date('Y');
$current_date = date('Y-m-d');

// Handle filter from GET parameters
$selected_month = isset($_GET['month']) ? intval($_GET['month']) : $current_month;
$selected_year = isset($_GET['year']) ? intval($_GET['year']) : $current_year;

// Validate selected month and year
if ($selected_month < 1 || $selected_month > 12) {
    $selected_month = $current_month;
}
if ($selected_year < 2000 || $selected_year > date('Y') + 1) {
    $selected_year = $current_year;
}

// Fetch all EMI schedules for the selected month/year
$sql_emi = "SELECT e.id AS emi_id, c.id AS customer_id, c.customer_name, c.customer_number, 
                   e.principal_amount, e.interest_amount, e.emi_amount, e.emi_due_date, 
                   e.status, e.paid_date, e.overdue_charges,
                   l.loan_name
            FROM emi_schedule e
            JOIN customers c ON e.customer_id = c.id
            JOIN loans l ON c.loan_id = l.id
            WHERE MONTH(e.emi_due_date) = ?
            AND YEAR(e.emi_due_date) = ?
            ORDER BY e.emi_due_date ASC";
$stmt_emi = $conn->prepare($sql_emi);
if (!$stmt_emi) {
    die("Error preparing EMI query: " . $conn->error);
}
$stmt_emi->bind_param("ii", $selected_month, $selected_year);
$stmt_emi->execute();
$emi_data = $stmt_emi->get_result();

if (!$emi_data) {
    die("Error fetching EMI data: " . $conn->error);
}

// Calculate totals
$total_principal = 0;
$total_interest = 0;
$total_overdue = 0;
$total_expected = 0;

while ($row = $emi_data->fetch_assoc()) {
    $emi_due_date = $row['emi_due_date'];
    $emi_amount = $row['emi_amount'];
    $overdue_charges = $row['overdue_charges'];

// Calculate overdue charges for unpaid EMIs past due
    if ($row['status'] == 'unpaid' && $emi_due_date < $current_date) {
        $date_diff = (strtotime($current_date) - strtotime($emi_due_date)) / (60 * 60 * 24);
        $overdue_charges = ($emi_amount / 1000) * 2 * $date_diff; // ₹2 per ₹1000 per day
    } else {
        $overdue_charges = $overdue_charges ?: 0; // Use stored value or 0
    }

$total_principal += $row['principal_amount'];
    $total_interest += $row['interest_amount'];
    $total_overdue += $overdue_charges;
    $total_expected += $row['emi_amount'] + $overdue_charges;
}
mysqli_data_seek($emi_data, 0); // Reset for display

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="page-wrapper">
      
      <div class="page-content">
        <div class="container-fluid">
          
          <nav aria-label="breadcrumb">
            <ol class="breadcrumb">
              <li class="breadcrumb-item"><a href="index.php">Home</a></li>
              <li class="breadcrumb-item"><a href="reports.php">Reports</a></li>
              <li class="breadcrumb-item active" aria-current="page">EMI Schedule</li>
            </ol>
          </nav>

<div class="row align-items-center mb-3">
            <div class="col">
              <h3 class="mb-0">EMI Schedule for <?php echo date('F Y', mktime(0, 0, 0, $selected_month, 1, $selected_year)); ?></h3>
              <small class="text-muted">View all EMI schedules for the selected month and year.</small>
            </div>
            <div class="col-auto">
              <a href="reports.php" class="btn btn-light">Back to Reports</a>
              <a href="calendar.php" class="btn btn-light">View Calendar</a>
            </div>
          </div>

<div class="card mb-3">
            <div class="card-body">
              <form method="GET" action="overdue-collections.php">
                <div class="row g-3">
                  <div class="col-md-4">
                    <label for="month" class="form-label">Select Month</label>
                    <select class="form-control" id="month" name="month">
                      <?php for ($m = 1; $m <= 12; $m++) { ?>
                        <option value="<?php echo $m; ?>" <?php echo ($m == $selected_month) ? 'selected' : ''; ?>><?php echo date('F', mktime(0, 0, 0, $m, 1)); ?></option>
                      <?php } ?>
                    </select>
                  </div>
                  <div class="col-md-4">
                    <label for="year" class="form-label">Select Year</label>
                    <select class="form-control" id="year" name="year">
                      <?php for ($y = 2020; $y <= date('Y') + 1; $y++) { ?>
                        <option value="<?php echo $y; ?>" <?php echo ($y == $selected_year) ? 'selected' : ''; ?>><?php echo $y; ?></option>
                      <?php } ?>
                    </select>
                  </div>
                  <div class="col-md-4 d-flex align-items-end">
                    <button type="submit" class="btn btn-primary">Filter</button>
                  </div>
                </div>
              </form>
            </div>
          </div>

<?php if ($emi_data->num_rows > 0) { ?>
            
            <div class="card mb-3">
              <div class="card-body">
                <div class="row">
                  <div class="col-md-3">
                    <h5>Total Principal: ₹<?php echo number_format($total_principal, 2); ?></h5>
                  </div>
                  <div class="col-md-3">
                    <h5>Total Interest: ₹<?php echo number_format($total_interest, 2); ?></h5>
                  </div>
                  <div class="col-md-3">
                    <h5>Total Overdue: ₹<?php echo number_format($total_overdue, 2); ?></h5>
                  </div>
                  <div class="col-md-3">
                    <h5>Total Expected: ₹<?php echo number_format($total_expected, 2); ?></h5>
                  </div>
                </div>
              </div>
            </div>

<div class="card d-none d-md-block mb-5">
              <div class="card-header">
                <h4 class="card-title mb-0">EMI 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>Customer Name</th>
                        <th>Customer Number</th>
                        <th>Loan Name</th>
                        <th>Principal (₹)</th>
                        <th>Interest (₹)</th>
                        <th>EMI (₹)</th>
                        <th>Overdue (₹)</th>
                        <th>Due Date</th>
                        <th>Status</th>
                        <th>Paid Date</th>
                        <th>Action</th>
                      </tr>
                    </thead>
                    <tbody>
                      <?php while ($row = $emi_data->fetch_assoc()) { 
                        $emi_due_date = $row['emi_due_date'];
                        $emi_amount = $row['emi_amount'];
                        $overdue_charges = $row['overdue_charges'];
                        if ($row['status'] == 'unpaid' && $emi_due_date < $current_date) {
                            $date_diff = (strtotime($current_date) - strtotime($emi_due_date)) / (60 * 60 * 24);
                            $overdue_charges = ($emi_amount / 1000) * 2 * $date_diff; // ₹2 per ₹1000 per day
                        } else {
                            $overdue_charges = $overdue_charges ?: 0;
                        }
                      ?>
                        <tr>
                          <td>EMI-<?php echo $row['emi_id']; ?></td>
                          <td><?php echo htmlspecialchars($row['customer_name']); ?></td>
                          <td><?php echo htmlspecialchars($row['customer_number']); ?></td>
                          <td><?php echo htmlspecialchars($row['loan_name']); ?></td>
                          <td><?php echo number_format($row['principal_amount'], 2); ?></td>
                          <td><?php echo number_format($row['interest_amount'], 2); ?></td>
                          <td><?php echo number_format($row['emi_amount'], 2); ?></td>
                          <td><?php echo ($overdue_charges > 0 ? number_format($overdue_charges, 2) : '-'); ?></td>
                          <td><?php echo $row['emi_due_date']; ?></td>
                          <td><?php echo ucfirst($row['status']); ?></td>
                          <td><?php echo $row['paid_date'] ?: '-'; ?></td>
                          <td>
                            <?php if ($row['status'] == 'unpaid') { ?>
                              <a href="emi-schedule.php?customer_id=<?php echo $row['customer_id']; ?>&emi_id=<?php echo $row['emi_id']; ?>" class="btn btn-sm btn-success">Pay</a>
                            <?php } else { ?>
                              <span class="text-muted">Paid</span>
                            <?php } ?>
                          </td>
                        </tr>
                      <?php } ?>
                    </tbody>
                  </table>
                </div>
              </div>
            </div>

<div class="d-md-none mb-5">
              <?php
              mysqli_data_seek($emi_data, 0);
              while ($row = $emi_data->fetch_assoc()) {
                $emi_due_date = $row['emi_due_date'];
                $emi_amount = $row['emi_amount'];
                $overdue_charges = $row['overdue_charges'];
                if ($row['status'] == 'unpaid' && $emi_due_date < $current_date) {
                    $date_diff = (strtotime($current_date) - strtotime($emi_due_date)) / (60 * 60 * 24);
                    $overdue_charges = ($emi_amount / 1000) * 2 * $date_diff; // ₹2 per ₹1000 per day
                } else {
                    $overdue_charges = $overdue_charges ?: 0;
                }
              ?>
                <div class="card mb-3">
                  <div class="card-body">
                    <h5 class="card-title">EMI-<?php echo $row['emi_id']; ?></h5>
                    <p><strong>Customer:</strong> <?php echo htmlspecialchars($row['customer_name']); ?></p>
                    <p><strong>Customer Number:</strong> <?php echo htmlspecialchars($row['customer_number']); ?></p>
                    <p><strong>Loan Name:</strong> <?php echo htmlspecialchars($row['loan_name']); ?></p>
                    <p><strong>Principal:</strong> ₹<?php echo number_format($row['principal_amount'], 2); ?></p>
                    <p><strong>Interest:</strong> ₹<?php echo number_format($row['interest_amount'], 2); ?></p>
                    <p><strong>EMI:</strong> ₹<?php echo number_format($row['emi_amount'], 2); ?></p>
                    <p><strong>Overdue:</strong> ₹<?php echo ($overdue_charges > 0 ? number_format($overdue_charges, 2) : '-'); ?></p>
                    <p><strong>Due Date:</strong> <?php echo $row['emi_due_date']; ?></p>
                    <p><strong>Status:</strong> <?php echo ucfirst($row['status']); ?></p>
                    <p><strong>Paid Date:</strong> <?php echo $row['paid_date'] ?: '-'; ?></p>
                    <?php if ($row['status'] == 'unpaid') { ?>
                      <a href="emi-schedule.php?customer_id=<?php echo $row['customer_id']; ?>&emi_id=<?php echo $row['emi_id']; ?>" class="btn btn-sm btn-success">Pay</a>
                    <?php } else { ?>
                      <span class="text-muted">Paid</span>
                    <?php } ?>
                  </div>
                </div>
              <?php } ?>
            </div>

<?php } else { ?>
            <div class="alert alert-info" role="alert">
              No EMI records found for the selected month and year.
            </div>
          <?php } ?>

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

</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: overdue-collections.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation