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/pennagaram.org/public_html/admin

Free Space:

10.24 TB

🔧 Quick Actions

✏️ Editing: manage-villages.php

<!doctype html>
<html lang="en">
<?php
include('includes/head.php');
include('includes/db.php');

// Handle form submissions
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    if (isset($_POST['action'])) {
        if ($_POST['action'] === 'edit_village') {
            $village_id = (int)$_POST['village_id'];
            $name = mysqli_real_escape_string($conn, $_POST['name']);
            $panchayat_id = mysqli_real_escape_string($conn, $_POST['panchayat_id']);
            $pincode = mysqli_real_escape_string($conn, $_POST['pincode']);
            $status = mysqli_real_escape_string($conn, $_POST['status']);
            
            // Check if village name already exists (excluding current village)
            $checkSql = "SELECT id FROM villages WHERE name = ? AND id != ?";
            $stmt = mysqli_prepare($conn, $checkSql);
            mysqli_stmt_bind_param($stmt, 'si', $name, $village_id);
            mysqli_stmt_execute($stmt);
            mysqli_stmt_store_result($stmt);
            
            if (mysqli_stmt_num_rows($stmt) > 0) {
                $errorMsg = "Village with this name already exists!";
            } else {
                // Update village with all fields
                $updateSql = "UPDATE villages SET name = ?, panchayat_id = ?, pincode = ?, status = ? WHERE id = ?";
                $stmt = mysqli_prepare($conn, $updateSql);
                mysqli_stmt_bind_param($stmt, 'sissi', $name, $panchayat_id, $pincode, $status, $village_id);
                
                if (mysqli_stmt_execute($stmt)) {
                    $successMsg = "Village updated successfully!";
                } else {
                    $errorMsg = "Error updating village: " . mysqli_error($conn);
                }
            }
            mysqli_stmt_close($stmt);
            
        } elseif ($_POST['action'] === 'delete_village') {
            $village_id = (int)$_POST['village_id'];
            
            // Delete village
            $deleteSql = "DELETE FROM villages WHERE id = ?";
            $stmt = mysqli_prepare($conn, $deleteSql);
            mysqli_stmt_bind_param($stmt, 'i', $village_id);
            
            if (mysqli_stmt_execute($stmt)) {
                $successMsg = "Village deleted successfully!";
            } else {
                $errorMsg = "Error deleting village: " . mysqli_error($conn);
            }
            mysqli_stmt_close($stmt);
        }
    }
}

// Fetch panchayats for dropdown
$panchayatsSql = "SELECT id, name, block_name FROM panchayats WHERE status = 'active' ORDER BY name";
$panchayatsResult = mysqli_query($conn, $panchayatsSql);
$panchayats = [];
if ($panchayatsResult && mysqli_num_rows($panchayatsResult) > 0) {
    while ($row = mysqli_fetch_assoc($panchayatsResult)) {
        $panchayats[] = $row;
    }
}

// Fetch existing villages with panchayat information
$villagesSql = "SELECT v.id, v.name, v.panchayat_id, v.pincode, v.status, v.created_at, 
                       p.name as panchayat_name, p.block_name 
                FROM villages v 
                LEFT JOIN panchayats p ON v.panchayat_id = p.id 
                ORDER BY v.created_at DESC";
$villagesResult = mysqli_query($conn, $villagesSql);
$villages = [];
if ($villagesResult && mysqli_num_rows($villagesResult) > 0) {
    while ($row = mysqli_fetch_assoc($villagesResult)) {
        $villages[] = $row;
    }
}

// Count statistics
$totalVillages = count($villages);
$activeVillages = 0;
$inactiveVillages = 0;

foreach ($villages as $village) {
    if ($village['status'] === 'active') {
        $activeVillages++;
    } else {
        $inactiveVillages++;
    }
}
?>
<body data-sidebar="dark">

<?php include('includes/pre-loader.php')?>

<div id="layout-wrapper">
<?php include('includes/topbar.php')?>
    
    <div class="vertical-menu">
        <div data-simplebar class="h-100">
            
            <?php include('includes/sidebar.php')?>
            
        </div>
    </div>
    
    
    
    
    <div class="main-content">
        <div class="page-content">
            <div class="container-fluid">
                
                <div class="row">
                    <div class="col-12">
                        <div class="page-title-box d-flex align-items-center justify-content-between">
                            <h4 class="mb-0">Manage Villages</h4>
                            <div>
                                <a href="add-village.php" class="btn btn-primary">
                                    <i class="fas fa-plus me-2"></i>Add New Village
                                </a>
                            </div>
                        </div>
                    </div>
                </div>

<?php if (isset($successMsg)): ?>
                    <div class="alert alert-success alert-dismissible fade show" role="alert">
                        <i class="fas fa-check-circle me-2"></i>
                        <?php echo $successMsg; ?>
                        <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                    </div>
                <?php endif; ?>
                
                <?php if (isset($errorMsg)): ?>
                    <div class="alert alert-danger alert-dismissible fade show" role="alert">
                        <i class="fas fa-exclamation-triangle me-2"></i>
                        <?php echo $errorMsg; ?>
                        <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                    </div>
                <?php endif; ?>

<div class="row">
                    <div class="col-md-3 col-sm-6">
                        <div class="card text-center">
                            <div class="card-body">
                                <h3 class="text-primary mt-2"><?php echo $totalVillages; ?></h3>
                                <p class="text-muted mb-0">Total Villages</p>
                            </div>
                        </div>
                    </div>
                    <div class="col-md-3 col-sm-6">
                        <div class="card text-center">
                            <div class="card-body">
                                <h3 class="text-success mt-2"><?php echo $activeVillages; ?></h3>
                                <p class="text-muted mb-0">Active Villages</p>
                            </div>
                        </div>
                    </div>
                    <div class="col-md-3 col-sm-6">
                        <div class="card text-center">
                            <div class="card-body">
                                <h3 class="text-warning mt-2"><?php echo $inactiveVillages; ?></h3>
                                <p class="text-muted mb-0">Inactive Villages</p>
                            </div>
                        </div>
                    </div>
                    <div class="col-md-3 col-sm-6">
                        <div class="card text-center">
                            <div class="card-body">
                                <h3 class="text-info mt-2"><?php echo count($panchayats); ?></h3>
                                <p class="text-muted mb-0">Panchayats</p>
                            </div>
                        </div>
                    </div>
                </div>

<div class="row">
                    <div class="col-12">
                        <div class="card">
                            <div class="card-body">
                                <div class="d-flex justify-content-between align-items-center mb-4">
                                    <h4 class="card-title mb-0">All Villages</h4>
                                    <div class="d-flex gap-2">
                                        <button type="button" class="btn btn-outline-primary btn-sm" onclick="exportToExcel()">
                                            <i class="fas fa-download me-1"></i>Export
                                        </button>
                                        <button type="button" class="btn btn-outline-success btn-sm" onclick="printTable()">
                                            <i class="fas fa-print me-1"></i>Print
                                        </button>
                                    </div>
                                </div>
                                
                                <?php if (empty($villages)): ?>
                                    <div class="text-center py-5">
                                        <i class="fas fa-home fa-3x text-muted mb-3"></i>
                                        <h5>No Villages Found</h5>
                                        <p class="text-muted mb-4">There are no villages in the system yet.</p>
                                        <a href="add-village.php" class="btn btn-primary">
                                            <i class="fas fa-plus me-2"></i>Add First Village
                                        </a>
                                    </div>
                                <?php else: ?>
                                    <div class="table-responsive">
                                        <table class="table table-hover table-centered mb-0" id="villagesTable">
                                            <thead class="table-light">
                                                <tr>
                                                    <th>#</th>
                                                    <th>Village Name</th>
                                                    <th>Panchayat</th>
                                                    <th>Block</th>
                                                    <th>Pincode</th>
                                                    <th>Status</th>
                                                    <th>Created Date</th>
                                                    <th>Actions</th>
                                                </tr>
                                            </thead>
                                            <tbody>
                                                <?php foreach ($villages as $index => $village): ?>
                                                    <tr>
                                                        <td><?php echo $index + 1; ?></td>
                                                        <td>
                                                            <h6 class="m-0 fw-semibold"><?php echo htmlspecialchars($village['name']); ?></h6>
                                                        </td>
                                                        <td>
                                                            <span class="text-muted"><?php echo htmlspecialchars($village['panchayat_name'] ?? 'N/A'); ?></span>
                                                        </td>
                                                        <td>
                                                            <span class="text-muted"><?php echo htmlspecialchars($village['block_name'] ?? 'N/A'); ?></span>
                                                        </td>
                                                        <td>
                                                            <span class="badge bg-light text-dark"><?php echo htmlspecialchars($village['pincode'] ?? 'N/A'); ?></span>
                                                        </td>
                                                        <td>
                                                            <span class="badge bg-<?php echo $village['status'] === 'active' ? 'success' : 'warning'; ?>">
                                                                <i class="fas fa-circle me-1" style="font-size: 6px;"></i>
                                                                <?php echo ucfirst($village['status']); ?>
                                                            </span>
                                                        </td>
                                                        <td>
                                                            <small class="text-muted">
                                                                <i class="far fa-calendar me-1"></i>
                                                                <?php echo date('M j, Y', strtotime($village['created_at'])); ?>
                                                            </small>
                                                        </td>
                                                        <td>
                                                            <div class="btn-group">
                                                                <button type="button" class="btn btn-sm btn-outline-primary" 
                                                                        data-bs-toggle="modal" 
                                                                        data-bs-target="#editVillageModal"
                                                                        data-id="<?php echo $village['id']; ?>"
                                                                        data-name="<?php echo htmlspecialchars($village['name']); ?>"
                                                                        data-panchayat="<?php echo $village['panchayat_id']; ?>"
                                                                        data-pincode="<?php echo htmlspecialchars($village['pincode']); ?>"
                                                                        data-status="<?php echo $village['status']; ?>">
                                                                    <i class="fas fa-edit"></i> Edit
                                                                </button>
                                                                <form method="post" class="d-inline" onsubmit="return confirm('Are you sure you want to delete this village? This action cannot be undone.')">
                                                                    <input type="hidden" name="action" value="delete_village">
                                                                    <input type="hidden" name="village_id" value="<?php echo $village['id']; ?>">
                                                                    <button type="submit" class="btn btn-sm btn-outline-danger">
                                                                        <i class="fas fa-trash"></i> Delete
                                                                    </button>
                                                                </form>
                                                            </div>
                                                        </td>
                                                    </tr>
                                                <?php endforeach; ?>
                                            </tbody>
                                        </table>
                                    </div>
                                    
                                    
                                    <div class="row mt-3">
                                        <div class="col-sm-12">
                                            <div class="text-muted">
                                                Showing <strong><?php echo count($villages); ?></strong> of <strong><?php echo count($villages); ?></strong> villages
                                            </div>
                                        </div>
                                    </div>
                                <?php endif; ?>
                            </div>
                        </div>
                    </div>
                </div>
                
            </div>
            
        </div>
        
        <?php include('includes/footer.php')?>
    </div>
    
</div>

<div class="modal fade" id="editVillageModal" tabindex="-1" aria-labelledby="editVillageModalLabel" aria-hidden="true">
    <div class="modal-dialog">
        <div class="modal-content">
            <div class="modal-header">
                <h5 class="modal-title" id="editVillageModalLabel">Edit Village</h5>
                <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
            </div>
            <form method="post" id="editVillageForm">
                <div class="modal-body">
                    <input type="hidden" name="action" value="edit_village">
                    <input type="hidden" name="village_id" id="edit_village_id">
                    
                    <div class="mb-3">
                        <label for="edit_name" class="form-label">Village Name <span class="text-danger">*</span></label>
                        <input type="text" class="form-control" id="edit_name" name="name" required
                               placeholder="Enter village name" maxlength="255">
                    </div>
                    
                    <div class="mb-3">
                        <label for="edit_panchayat_id" class="form-label">Panchayat <span class="text-danger">*</span></label>
                        <select class="form-select" id="edit_panchayat_id" name="panchayat_id" required>
                            <option value="">Select Panchayat</option>
                            <?php foreach ($panchayats as $panchayat): ?>
                                <option value="<?php echo $panchayat['id']; ?>">
                                    <?php echo htmlspecialchars($panchayat['name']); ?> (<?php echo htmlspecialchars($panchayat['block_name']); ?>)
                                </option>
                            <?php endforeach; ?>
                        </select>
                    </div>
                    
                    <div class="mb-3">
                        <label for="edit_pincode" class="form-label">Pincode</label>
                        <input type="text" class="form-control" id="edit_pincode" name="pincode"
                               placeholder="Enter pincode" maxlength="10">
                    </div>
                    
                    <div class="mb-3">
                        <label for="edit_status" class="form-label">Status <span class="text-danger">*</span></label>
                        <select class="form-select" id="edit_status" name="status" required>
                            <option value="active">Active</option>
                            <option value="inactive">Inactive</option>
                        </select>
                        <div class="form-text">Active villages will be visible in the frontend.</div>
                    </div>
                </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">Update Village</button>
                </div>
            </form>
        </div>
    </div>
</div>

<?php include('includes/rightbar.php')?>

<?php include('includes/scripts.php')?>

// Form validation
    document.getElementById('editVillageForm').addEventListener('submit', function(e) {
        const name = document.getElementById('edit_name').value.trim();
        const panchayat = document.getElementById('edit_panchayat_id').value;
        
        if (!name) {
            e.preventDefault();
            alert('Please enter village name');
            return;
        }
        
        if (!panchayat) {
            e.preventDefault();
            alert('Please select panchayat');
            return;
        }
        
        // Show loading state
        const submitBtn = this.querySelector('button[type="submit"]');
        submitBtn.innerHTML = '<i class="fas fa-spinner fa-spin me-2"></i>Updating...';
        submitBtn.disabled = true;
    });

// Auto-focus on name field when modal opens
    const editModal = document.getElementById('editVillageModal');
    editModal.addEventListener('shown.bs.modal', function () {
        document.getElementById('edit_name').focus();
        document.getElementById('edit_name').select();
    });
});

// Export to Excel function
function exportToExcel() {
    const table = document.getElementById('villagesTable');
    const html = table.outerHTML;
    const url = 'data:application/vnd.ms-excel;charset=utf-8,' + encodeURIComponent(html);
    const link = document.createElement('a');
    link.download = 'villages-list-' + new Date().toISOString().split('T')[0] + '.xls';
    link.href = url;
    link.click();
}

// Print function
function printTable() {
    const printContent = document.getElementById('villagesTable').outerHTML;
    const originalContent = document.body.innerHTML;
    
    document.body.innerHTML = `
        <html>
            <head>
                <title>Villages List - <?php echo date('Y-m-d'); ?></title>
                <style>
                    body { font-family: Arial, sans-serif; margin: 20px; }
                    table { width: 100%; border-collapse: collapse; margin-top: 10px; }
                    th, td { border: 1px solid #ddd; padding: 8px; text-align: left; }
                    th { background-color: #f8f9fa; font-weight: bold; }
                    .badge { padding: 4px 8px; border-radius: 4px; font-size: 12px; }
                    .bg-success { background-color: #28a745 !important; color: white; }
                    .bg-warning { background-color: #ffc107 !important; color: black; }
                    .bg-light { background-color: #f8f9fa !important; color: black; }
                    h2 { color: #333; margin-bottom: 10px; }
                </style>
            </head>
            <body>
                <h2>Villages List - Pennagaram</h2>
                <p>Generated on: <?php echo date('F j, Y'); ?></p>
                ${printContent}
            </body>
        </html>
    `;
    
    window.print();
    document.body.innerHTML = originalContent;
    location.reload();
}
</script>

<?php
// Close database connection
if (isset($conn)) {
    mysqli_close($conn);
}

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: manage-villages.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation