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.31 TB

🔧 Quick Actions

✏️ Editing: manage-volunteers.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'] === 'update_status') {
            $volunteerId = (int)$_POST['volunteer_id'];
            $status = mysqli_real_escape_string($conn, $_POST['status']);
            $adminNotes = mysqli_real_escape_string($conn, $_POST['admin_notes']);
            
            // Fixed: Removed updated_at column
            $updateSql = "UPDATE volunteer_registrations SET status = ?, admin_notes = ? WHERE id = ?";
            $stmt = mysqli_prepare($conn, $updateSql);
            mysqli_stmt_bind_param($stmt, 'ssi', $status, $adminNotes, $volunteerId);
            
            if (mysqli_stmt_execute($stmt)) {
                $successMsg = "Volunteer status updated successfully!";
            } else {
                $errorMsg = "Error updating volunteer: " . mysqli_error($conn);
            }
            mysqli_stmt_close($stmt);
            
        } elseif ($_POST['action'] === 'delete_volunteer') {
            $volunteerId = (int)$_POST['volunteer_id'];
            
            $deleteSql = "DELETE FROM volunteer_registrations WHERE id = ?";
            $stmt = mysqli_prepare($conn, $deleteSql);
            mysqli_stmt_bind_param($stmt, 'i', $volunteerId);
            
            if (mysqli_stmt_execute($stmt)) {
                $successMsg = "Volunteer deleted successfully!";
            } else {
                $errorMsg = "Error deleting volunteer: " . mysqli_error($conn);
            }
            mysqli_stmt_close($stmt);
        }
    }
}

// Fetch volunteers with search and filter
$search = isset($_GET['search']) ? mysqli_real_escape_string($conn, $_GET['search']) : '';
$statusFilter = isset($_GET['status']) ? mysqli_real_escape_string($conn, $_GET['status']) : '';
$bloodDonationFilter = isset($_GET['blood_donation']) ? mysqli_real_escape_string($conn, $_GET['blood_donation']) : '';

$whereConditions = [];
$params = [];
$types = '';

if (!empty($search)) {
    $whereConditions[] = "(full_name LIKE ? OR email LIKE ? OR phone LIKE ? OR skills LIKE ?)";
    $params[] = "%$search%";
    $params[] = "%$search%";
    $params[] = "%$search%";
    $params[] = "%$search%";
    $types .= 'ssss';
}

if (!empty($statusFilter)) {
    $whereConditions[] = "status = ?";
    $params[] = $statusFilter;
    $types .= 's';
}

if (!empty($bloodDonationFilter)) {
    $whereConditions[] = "blood_donation_interest = ?";
    $params[] = $bloodDonationFilter;
    $types .= 's';
}

$whereClause = '';
if (!empty($whereConditions)) {
    $whereClause = "WHERE " . implode(" AND ", $whereConditions);
}

$volunteersSql = "SELECT * FROM volunteer_registrations $whereClause ORDER BY created_at DESC";
$stmt = mysqli_prepare($conn, $volunteersSql);

if (!empty($params)) {
    mysqli_stmt_bind_param($stmt, $types, ...$params);
}

mysqli_stmt_execute($stmt);
$volunteersResult = mysqli_stmt_get_result($stmt);
$volunteers = [];
if ($volunteersResult && mysqli_num_rows($volunteersResult) > 0) {
    while ($row = mysqli_fetch_assoc($volunteersResult)) {
        $volunteers[] = $row;
    }
}
mysqli_stmt_close($stmt);

// Count statistics
$totalVolunteers = count($volunteers);
$pendingVolunteers = count(array_filter($volunteers, function($volunteer) {
    return $volunteer['status'] === 'pending';
}));
$approvedVolunteers = count(array_filter($volunteers, function($volunteer) {
    return $volunteer['status'] === 'approved';
}));
$rejectedVolunteers = count(array_filter($volunteers, function($volunteer) {
    return $volunteer['status'] === 'rejected';
}));

// Blood donation statistics
$bloodDonors = count(array_filter($volunteers, function($volunteer) {
    return $volunteer['blood_donation_interest'] === 'yes';
}));
?>
<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">Volunteer Management</h4>
                            <div class="d-flex gap-2">
                                <button type="button" class="btn btn-success" onclick="exportToExcel()">
                                    <i class="fas fa-file-excel me-2"></i>Export to Excel
                                </button>
                                <button type="button" class="btn btn-info" onclick="printVolunteers()">
                                    <i class="fas fa-print me-2"></i>Print
                                </button>
                            </div>
                        </div>
                    </div>
                </div>

<?php if (isset($successMsg)): ?>
                    <div class="alert alert-success alert-dismissible fade show" role="alert">
                        <?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">
                        <?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="mb-2 card-body text-muted">
                                <h3 class="text-primary mt-2"><?php echo $totalVolunteers; ?></h3> Total Volunteers
                            </div>
                        </div>
                    </div>
                    <div class="col-md-3 col-sm-6">
                        <div class="card text-center">
                            <div class="mb-2 card-body text-muted">
                                <h3 class="text-warning mt-2"><?php echo $pendingVolunteers; ?></h3> Pending
                            </div>
                        </div>
                    </div>
                    <div class="col-md-3 col-sm-6">
                        <div class="card text-center">
                            <div class="mb-2 card-body text-muted">
                                <h3 class="text-success mt-2"><?php echo $approvedVolunteers; ?></h3> Approved
                            </div>
                        </div>
                    </div>
                    <div class="col-md-3 col-sm-6">
                        <div class="card text-center">
                            <div class="mb-2 card-body text-muted">
                                <h3 class="text-danger mt-2"><?php echo $bloodDonors; ?></h3> Blood Donors
                            </div>
                        </div>
                    </div>
                </div>

<div class="row">
                    <div class="col-12">
                        <div class="card">
                            <div class="card-body">
                                <form method="GET" class="row g-3">
                                    <div class="col-md-4">
                                        <label for="search" class="form-label">Search Volunteers</label>
                                        <input type="text" class="form-control" id="search" name="search" 
                                               value="<?php echo htmlspecialchars($search); ?>" 
                                               placeholder="Search by name, email, phone, or skills...">
                                    </div>
                                    <div class="col-md-3">
                                        <label for="status" class="form-label">Filter by Status</label>
                                        <select class="form-select" id="status1" name="status">
                                            <option value="">All Status</option>
                                            <option value="pending" <?php echo $statusFilter === 'pending' ? 'selected' : ''; ?>>Pending</option>
                                            <option value="approved" <?php echo $statusFilter === 'approved' ? 'selected' : ''; ?>>Approved</option>
                                            <option value="rejected" <?php echo $statusFilter === 'rejected' ? 'selected' : ''; ?>>Rejected</option>
                                        </select>
                                    </div>
                                    <div class="col-md-3">
                                        <label for="blood_donation" class="form-label">Blood Donation</label>
                                        <select class="form-select" id="blood_donation" name="blood_donation">
                                            <option value="">All</option>
                                            <option value="yes" <?php echo $bloodDonationFilter === 'yes' ? 'selected' : ''; ?>>Blood Donors Only</option>
                                            <option value="no" <?php echo $bloodDonationFilter === 'no' ? 'selected' : ''; ?>>Non-Donors Only</option>
                                        </select>
                                    </div>
                                    <div class="col-md-2 d-flex align-items-end">
                                        <button type="submit" class="btn btn-primary w-100">
                                            <i class="fas fa-search me-2"></i>Filter
                                        </button>
                                    </div>
                                </form>
                            </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 Volunteer Registrations</h4>
                                    <div class="text-muted">
                                        Showing <?php echo $totalVolunteers; ?> volunteer(s)
                                    </div>
                                </div>

<?php if (empty($volunteers)): ?>
                                    <div class="text-center py-5">
                                        <i class="fas fa-users fa-3x text-muted mb-3"></i>
                                        <h5>No Volunteers Found</h5>
                                        <p class="text-muted">No volunteer registrations match your search criteria.</p>
                                        <?php if (!empty($search) || !empty($statusFilter) || !empty($bloodDonationFilter)): ?>
                                            <a href="manage-volunteers.php" class="btn btn-primary mt-2">
                                                <i class="fas fa-times me-2"></i>Clear Filters
                                            </a>
                                        <?php endif; ?>
                                    </div>
                                <?php else: ?>
                                    <div class="table-responsive">
                                        <table class="table table-hover table-centered mb-0" id="volunteersTable">
                                            <thead class="table-light">
                                                <tr>
                                                    <th>#</th>
                                                    <th>Personal Info</th>
                                                    <th>Contact & Education</th>
                                                    <th>Skills & Availability</th>
                                                    <th>Blood Donation</th>
                                                    <th>Status</th>
                                                    <th>Registered</th>
                                                    <th>Actions</th>
                                                </tr>
                                            </thead>
                                            <tbody>
                                                <?php foreach ($volunteers as $index => $volunteer): 
                                                    $statusClass = [
                                                        'pending' => 'warning',
                                                        'approved' => 'success',
                                                        'rejected' => 'danger'
                                                    ][$volunteer['status']] ?? 'secondary';
                                                    
                                                    $bloodDonationClass = $volunteer['blood_donation_interest'] === 'yes' ? 'success' : 'secondary';
                                                ?>
                                                    <tr>
                                                        <td><?php echo $index + 1; ?></td>
                                                        <td>
                                                            <div class="d-flex align-items-start">
                                                                <div class="flex-grow-1">
                                                                    <h6 class="mb-1"><?php echo htmlspecialchars($volunteer['full_name']); ?></h6>
                                                                    <small class="text-muted">
                                                                        <i class="fas fa-venus-mars me-1"></i>
                                                                        <?php echo htmlspecialchars(ucfirst($volunteer['gender'])); ?>
                                                                    </small>
                                                                    <br>
                                                                    <small class="text-muted">
                                                                        <i class="fas fa-birthday-cake me-1"></i>
                                                                        <?php echo date('M j, Y', strtotime($volunteer['date_of_birth'])); ?>
                                                                    </small>
                                                                </div>
                                                            </div>
                                                        </td>
                                                        <td>
                                                            <small>
                                                                <div><i class="fas fa-phone me-1"></i><?php echo htmlspecialchars($volunteer['phone']); ?></div>
                                                                <div><i class="fas fa-envelope me-1"></i><?php echo htmlspecialchars($volunteer['email']); ?></div>
                                                                <div><i class="fas fa-graduation-cap me-1"></i><?php echo htmlspecialchars(ucfirst(str_replace('_', ' ', $volunteer['education_level']))); ?></div>
                                                                <?php if ($volunteer['profession']): ?>
                                                                    <div><i class="fas fa-briefcase me-1"></i><?php echo htmlspecialchars($volunteer['profession']); ?></div>
                                                                <?php endif; ?>
                                                            </small>
                                                        </td>
                                                        <td>
                                                            <small>
                                                                <div class="text-truncate" style="max-width: 200px;" title="<?php echo htmlspecialchars($volunteer['skills']); ?>">
                                                                    <strong>Skills:</strong> <?php echo htmlspecialchars(substr($volunteer['skills'], 0, 50)); ?>...
                                                                </div>
                                                                <div><strong>Availability:</strong> <?php echo htmlspecialchars($volunteer['hours_per_week']); ?> hrs/week</div>
                                                                <div><strong>Time:</strong> <?php echo htmlspecialchars(ucfirst($volunteer['time_preference'])); ?></div>
                                                            </small>
                                                        </td>
                                                        <td>
                                                            <span class="badge bg-<?php echo $bloodDonationClass; ?>">
                                                                <?php echo $volunteer['blood_donation_interest'] === 'yes' ? 'Yes' : 'No'; ?>
                                                            </span>
                                                            <?php if ($volunteer['blood_donation_interest'] === 'yes' && $volunteer['blood_group']): ?>
                                                                <br>
                                                                <small class="text-danger mt-1">
                                                                    <strong><?php echo htmlspecialchars($volunteer['blood_group']); ?></strong>
                                                                </small>
                                                            <?php endif; ?>
                                                        </td>
                                                        <td>
                                                            <span class="badge bg-<?php echo $statusClass; ?>">
                                                                <?php echo ucfirst($volunteer['status']); ?>
                                                            </span>
                                                            <?php if ($volunteer['admin_notes']): ?>
                                                                <br>
                                                                <small class="text-muted" title="<?php echo htmlspecialchars($volunteer['admin_notes']); ?>">
                                                                    <i class="fas fa-sticky-note me-1"></i>Has notes
                                                                </small>
                                                            <?php endif; ?>
                                                        </td>
                                                        <td>
                                                            <small>
                                                                <?php echo date('M j, Y', strtotime($volunteer['created_at'])); ?><br>
                                                                <span class="text-muted"><?php echo date('g:i A', strtotime($volunteer['created_at'])); ?></span>
                                                            </small>
                                                        </td>
                                                        <td>
                                                            <div class="btn-group btn-group-sm">
                                                                <button type="button" class="btn btn-primary view-volunteer" 
                                                                        data-bs-toggle="modal" 
                                                                        data-bs-target="#viewVolunteerModal"
                                                                        data-volunteer='<?php echo json_encode($volunteer); ?>'>
                                                                    <i class="fas fa-eye"></i>
                                                                </button>
                                                                <button type="button" class="btn btn-warning edit-status" 
                                                                        data-bs-toggle="modal" 
                                                                        data-bs-target="#editStatusModal"
                                                                        data-volunteer-id="<?php echo $volunteer['id']; ?>"
                                                                        data-current-status="<?php echo $volunteer['status']; ?>"
                                                                        data-current-notes="<?php echo htmlspecialchars($volunteer['admin_notes']); ?>">
                                                                    <i class="fas fa-edit"></i>
                                                                </button>
                                                                <form method="post" class="d-inline" onsubmit="return confirm('Are you sure you want to delete this volunteer?')">
                                                                    <input type="hidden" name="action" value="delete_volunteer">
                                                                    <input type="hidden" name="volunteer_id" value="<?php echo $volunteer['id']; ?>">
                                                                    <button type="submit" class="btn btn-danger">
                                                                        <i class="fas fa-trash"></i>
                                                                    </button>
                                                                </form>
                                                            </div>
                                                        </td>
                                                    </tr>
                                                <?php endforeach; ?>
                                            </tbody>
                                        </table>
                                    </div>
                                <?php endif; ?>
                            </div>
                        </div>
                    </div>
                </div>
                
            </div>
            
        </div>
        
        <?php include('includes/footer.php')?>
    </div>
    
</div>

<div class="modal fade" id="viewVolunteerModal" tabindex="-1" aria-labelledby="viewVolunteerModalLabel" aria-hidden="true">
    <div class="modal-dialog modal-lg">
        <div class="modal-content">
            <div class="modal-header">
                <h5 class="modal-title" id="viewVolunteerModalLabel">Volunteer Details</h5>
                <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
            </div>
            <div class="modal-body" id="volunteerDetails">
                
            </div>
            <div class="modal-footer">
                <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Close</button>
            </div>
        </div>
    </div>
</div>

<div class="modal fade" id="editStatusModal" tabindex="-1" aria-labelledby="editStatusModalLabel" aria-hidden="true">
    <div class="modal-dialog">
        <div class="modal-content">
            <div class="modal-header">
                <h5 class="modal-title" id="editStatusModalLabel">Update Volunteer Status</h5>
                <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
            </div>
            <form method="post">
                <div class="modal-body">
                    <input type="hidden" name="action" value="update_status">
                    <input type="hidden" name="volunteer_id" id="editVolunteerId">
                    
                    <div class="mb-3">
                        <label for="status" class="form-label">Status</label>
                        <select class="form-select" id="status1" name="status" required>
                            <option value="pending">Pending</option>
                            <option value="approved">Approved</option>
                            <option value="rejected">Rejected</option>
                        </select>
                    </div>
                    
                    <div class="mb-3">
                        <label for="admin_notes" class="form-label">Admin Notes</label>
                        <textarea class="form-control" id="admin_notes" name="admin_notes" rows="4" 
                                  placeholder="Add any notes or comments about this volunteer..."></textarea>
                    </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 Status</button>
                </div>
            </form>
        </div>
    </div>
</div>

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

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

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

// Print function
function printVolunteers() {
    const printContent = document.getElementById('volunteersTable').cloneNode(true);
    const printWindow = window.open('', '_blank');
    
    printWindow.document.write(`
        <html>
            <head>
                <title>Volunteers - ${new Date().toLocaleDateString()}</title>
                <style>
                    body { font-family: Arial, sans-serif; margin: 20px; }
                    table { width: 100%; border-collapse: collapse; }
                    th, td { border: 1px solid #ddd; padding: 8px; text-align: left; }
                    th { background-color: #f8f9fa; }
                    .badge { padding: 4px 8px; border-radius: 4px; color: white; }
                    .bg-warning { background-color: #ffc107; }
                    .bg-success { background-color: #198754; }
                    .bg-danger { background-color: #dc3545; }
                    .bg-secondary { background-color: #6c757d; }
                </style>
            </head>
            <body>
                <h2>Volunteers List - ${new Date().toLocaleDateString()}</h2>
                ${printContent.outerHTML}
            </body>
        </html>
    `);
    
    printWindow.document.close();
    printWindow.print();
}
</script>
</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: manage-volunteers.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation