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

Free Space:

10.3 TB

🔧 Quick Actions

✏️ Editing: test-foreclosure.php

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

// Test foreclosure data
$finance_id = 1;

echo "<h3>Testing Foreclosure Data</h3>";

// Check foreclosures
$sql = "SELECT COUNT(*) as count, SUM(total_amount) as total FROM foreclosures WHERE finance_id = ? AND status = 'paid'";
$stmt = $conn->prepare($sql);
$stmt->bind_param("i", $finance_id);
$stmt->execute();
$result = $stmt->get_result();
$row = $result->fetch_assoc();
echo "Foreclosures Count: " . $row['count'] . "<br>";
echo "Foreclosures Total: " . $row['total'] . "<br>";
$stmt->close();

// Check EMI data
$sql2 = "SELECT COUNT(*) as count, SUM(emi_amount) as total FROM emi_schedule WHERE finance_id = ? AND status = 'paid'";
$stmt2 = $conn->prepare($sql2);
$stmt2->bind_param("i", $finance_id);
$stmt2->execute();
$result2 = $stmt2->get_result();
$row2 = $result2->fetch_assoc();
echo "EMI Count: " . $row2['count'] . "<br>";
echo "EMI Total: " . $row2['total'] . "<br>";
$stmt2->close();

// Combined total
$combined_total = ($row['total'] ?? 0) + ($row2['total'] ?? 0);
echo "<h4>Combined Total (EMI + Foreclosure): " . $combined_total . "</h4>";

// Show recent foreclosures
echo "<h4>Recent Foreclosures:</h4>";
$sql3 = "SELECT f.*, c.customer_name FROM foreclosures f 
         JOIN customers c ON f.customer_id = c.id 
         WHERE f.finance_id = ? 
         ORDER BY f.id DESC LIMIT 10";
$stmt3 = $conn->prepare($sql3);
$stmt3->bind_param("i", $finance_id);
$stmt3->execute();
$result3 = $stmt3->get_result();

echo "<table border='1'>";
echo "<tr><th>ID</th><th>Customer</th><th>Total Amount</th><th>Paid Date</th><th>Status</th></tr>";
while ($row3 = $result3->fetch_assoc()) {
    echo "<tr>";
    echo "<td>" . $row3['id'] . "</td>";
    echo "<td>" . $row3['customer_name'] . "</td>";
    echo "<td>" . $row3['total_amount'] . "</td>";
    echo "<td>" . $row3['paid_date'] . "</td>";
    echo "<td>" . $row3['status'] . "</td>";
    echo "</tr>";
}
echo "</table>";
$stmt3->close();
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: test-foreclosure.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation