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

Free Space:

10.3 TB

🔧 Quick Actions

✏️ Editing: delete-loan.php

<?php
// Enable error logging instead of displaying errors
ini_set('display_errors', 0);
ini_set('log_errors', 1);
ini_set('error_log', '/home/u329947844/domains/hifi11.in/public_html/finance/error_log');

// Start session
session_start();

// Include database connection
include 'includes/db.php';

// Check if loan ID is provided
if (!isset($_GET['id']) || empty($_GET['id'])) {
    $_SESSION['error'] = "Loan ID is required.";
    header("Location: manage-loans.php");
    exit;
}

$loan_id = intval($_GET['id']);

// Check if loan exists and get loan details
$sql_check = "SELECT l.*, f.finance_name FROM loans l 
              LEFT JOIN finance f ON l.finance_id = f.id 
              WHERE l.id = ?";
$stmt_check = $conn->prepare($sql_check);
$stmt_check->bind_param("i", $loan_id);
$stmt_check->execute();
$result_check = $stmt_check->get_result();

if ($result_check->num_rows === 0) {
    $_SESSION['error'] = "Loan not found.";
    header("Location: manage-loans.php");
    exit;
}

$loan = $result_check->fetch_assoc();
$stmt_check->close();

// Check if there are any customers using this loan
$sql_check_customers = "SELECT COUNT(*) as customer_count FROM customers WHERE loan_id = ?";
$stmt_check_customers = $conn->prepare($sql_check_customers);
$stmt_check_customers->bind_param("i", $loan_id);
$stmt_check_customers->execute();
$result_customers = $stmt_check_customers->get_result();
$customer_data = $result_customers->fetch_assoc();
$customer_count = $customer_data['customer_count'];
$stmt_check_customers->close();

// Handle form submission for deletion
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    if (isset($_POST['confirm_delete'])) {
        
        // If there are customers using this loan, we cannot delete it
        if ($customer_count > 0) {
            $_SESSION['error'] = "Cannot delete this loan. There are $customer_count customer(s) associated with this loan. Please reassign or delete those customers first.";
            header("Location: manage-loans.php");
            exit;
        }
        
        // Proceed with deletion
        $sql_delete = "DELETE FROM loans WHERE id = ?";
        $stmt_delete = $conn->prepare($sql_delete);
        $stmt_delete->bind_param("i", $loan_id);
        
        if ($stmt_delete->execute()) {
            $_SESSION['success'] = "Loan deleted successfully!";
            $stmt_delete->close();
            mysqli_close($conn);
            header("Location: manage-loans.php");
            exit;
        } else {
            $_SESSION['error'] = "Error deleting loan: " . $conn->error;
            $stmt_delete->close();
            mysqli_close($conn);
            header("Location: manage-loans.php");
            exit;
        }
    } else {
        // User cancelled the deletion
        $_SESSION['info'] = "Loan deletion cancelled.";
        header("Location: manage-loans.php");
        exit;
    }
}

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">
        <?php include 'includes/leftbar-tab-menu.php'; ?> 
        <?php include 'includes/leftbar.php'; ?>
        <div class="startbar-overlay d-print-none"></div>

<?php if (isset($_SESSION['error'])): ?>
                        <div class="alert alert-danger alert-dismissible fade show" role="alert">
                            <strong>Error!</strong> <?php echo $_SESSION['error']; ?>
                            <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                        </div>
                        <?php unset($_SESSION['error']); ?>
                    <?php endif; ?>

<div class="row justify-content-center">
                        <div class="col-md-8 col-lg-6">
                            <div class="card">
                                <div class="card-header bg-danger text-white">
                                    <h4 class="card-title mb-0">Confirm Loan Deletion</h4>
                                </div>
                                <div class="card-body">
                                    <?php if ($customer_count > 0): ?>
                                        <div class="alert alert-warning" role="alert">
                                            <h5 class="alert-heading">
                                                <i class="fas fa-exclamation-triangle me-2"></i>
                                                Cannot Delete Loan
                                            </h5>
                                            <p class="mb-2">This loan cannot be deleted because it is currently being used by <strong><?php echo $customer_count; ?> customer(s)</strong>.</p>
                                            <p class="mb-0">Please reassign these customers to a different loan or delete them first before deleting this loan.</p>
                                        </div>
                                        
                                        <div class="loan-details mt-4">
                                            <h6 class="text-muted mb-3">Loan Details:</h6>
                                            <div class="row">
                                                <div class="col-md-6">
                                                    <p><strong>Loan Name:</strong> <?php echo htmlspecialchars($loan['loan_name']); ?></p>
                                                    <p><strong>Finance:</strong> <?php echo htmlspecialchars($loan['finance_name'] ?? 'N/A'); ?></p>
                                                    <p><strong>Loan Amount:</strong> ₹<?php echo number_format($loan['loan_amount'], 2); ?></p>
                                                </div>
                                                <div class="col-md-6">
                                                    <p><strong>Interest Rate:</strong> <?php echo $loan['interest_rate']; ?>%</p>
                                                    <p><strong>Tenure:</strong> <?php echo $loan['loan_tenure']; ?> months</p>
                                                    <p><strong>Created:</strong> <?php echo date('M j, Y', strtotime($loan['created_at'])); ?></p>
                                                </div>
                                            </div>
                                        </div>
                                        
                                        <div class="mt-4">
                                            <a href="manage-loans.php" class="btn btn-secondary">
                                                <i class="iconoir-arrow-left me-1"></i> Back to Loans
                                            </a>
                                            <a href="manage-customers.php?loan_id=<?php echo $loan_id; ?>" class="btn btn-primary ms-2">
                                                <i class="iconoir-group me-1"></i> View Associated Customers
                                            </a>
                                        </div>
                                    <?php else: ?>
                                        <div class="alert alert-danger" role="alert">
                                            <h5 class="alert-heading">
                                                <i class="fas fa-exclamation-triangle me-2"></i>
                                                Warning: This action cannot be undone!
                                            </h5>
                                            <p class="mb-0">You are about to permanently delete this loan. This action cannot be reversed.</p>
                                        </div>
                                        
                                        <div class="loan-details mt-4">
                                            <h6 class="text-muted mb-3">Loan Details to be Deleted:</h6>
                                            <div class="row">
                                                <div class="col-md-6">
                                                    <p><strong>Loan ID:</strong> LN-<?php echo $loan['id']; ?></p>
                                                    <p><strong>Loan Name:</strong> <?php echo htmlspecialchars($loan['loan_name']); ?></p>
                                                    <p><strong>Finance:</strong> <?php echo htmlspecialchars($loan['finance_name'] ?? 'N/A'); ?></p>
                                                </div>
                                                <div class="col-md-6">
                                                    <p><strong>Loan Amount:</strong> ₹<?php echo number_format($loan['loan_amount'], 2); ?></p>
                                                    <p><strong>Interest Rate:</strong> <?php echo $loan['interest_rate']; ?>%</p>
                                                    <p><strong>Tenure:</strong> <?php echo $loan['loan_tenure']; ?> months</p>
                                                </div>
                                            </div>
                                            <?php if (!empty($loan['loan_purpose']) && $loan['loan_purpose'] !== 'N/A'): ?>
                                                <p class="mt-2"><strong>Purpose:</strong> <?php echo htmlspecialchars($loan['loan_purpose']); ?></p>
                                            <?php endif; ?>
                                            <p class="mt-2"><strong>Documents Required:</strong> <?php echo htmlspecialchars($loan['loan_documents']); ?></p>
                                        </div>
                                        
                                        <form method="POST" class="mt-4">
                                            <div class="d-flex justify-content-between">
                                                <a href="manage-loans.php" class="btn btn-secondary">
                                                    <i class="iconoir-arrow-left me-1"></i> Cancel
                                                </a>
                                                <button type="submit" name="confirm_delete" value="1" class="btn btn-danger">
                                                    <i class="iconoir-trash me-1"></i> Confirm Delete
                                                </button>
                                            </div>
                                        </form>
                                    <?php endif; ?>
                                </div>
                            </div>
                        </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: delete-loan.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation