Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 4.18.0-553.84.1.lve.el8.x86_64

PHP Version:

8.2.30

User:

u176134211

Directory:

/home/u176134211/domains/cheapsubs.shop/public_html/admin

Free Space:

8.26 TB

🔧 Quick Actions

✏️ Editing: applications.php

<?php
/**
 * Applications Management Page
 */

require_once __DIR__ . '/../includes/config.php';

// Check if admin is logged in
if (!isAdminLoggedIn()) {
    redirect('login.php');
}

$pageTitle = 'Applications';

// Handle status update
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['update_status'])) {
    $studentId = intval($_POST['student_id']);
    $newStatus = sanitizeInput($_POST['status']);
    $remarks = sanitizeInput($_POST['remarks']);
    
    try {
        $db = getDB();
        
        // Get current status
        $stmt = $db->prepare("SELECT application_status FROM students WHERE id = ?");
        $stmt->execute([$studentId]);
        $oldStatus = $stmt->fetch()['application_status'];
        
        // Update status
        $stmt = $db->prepare("UPDATE students SET application_status = ?, remarks = ? WHERE id = ?");
        $stmt->execute([$newStatus, $remarks, $studentId]);
        
        // Log status change
        $stmt = $db->prepare("INSERT INTO application_status_history (student_id, old_status, new_status, changed_by, remarks) VALUES (?, ?, ?, ?, ?)");
        $stmt->execute([$studentId, $oldStatus, $newStatus, $_SESSION['admin_id'], $remarks]);
        
        // Log activity
        logActivity($_SESSION['admin_id'], 'admin', 'Status Updated', "Student ID: $studentId, Status: $newStatus");
        
        // Send email notification
        require_once __DIR__ . '/../includes/email.php';
        $stmt = $db->prepare("SELECT * FROM students WHERE id = ?");
        $stmt->execute([$studentId]);
        $student = $stmt->fetch();
        
        if ($newStatus === 'admitted') {
            sendApplicationApprovedEmail($student);
        } elseif ($newStatus === 'rejected') {
            sendApplicationRejectedEmail($student, $remarks);
        }
        
        setFlashMessage('success', 'Application status updated successfully.');
        
    } catch (PDOException $e) {
        error_log("Status Update Error: " . $e->getMessage());
        setFlashMessage('error', 'An error occurred while updating status.');
    }
    
    redirect('applications.php');
}

// Pagination
$page = isset($_GET['page']) ? intval($_GET['page']) : 1;
$limit = 20;
$offset = ($page - 1) * $limit;

// Filters
$statusFilter = isset($_GET['status']) ? sanitizeInput($_GET['status']) : '';
$paymentFilter = isset($_GET['payment']) ? sanitizeInput($_GET['payment']) : '';
$search = isset($_GET['search']) ? sanitizeInput($_GET['search']) : '';

// Build query
$whereClause = [];
$params = [];

if ($statusFilter) {
    $whereClause[] = "s.application_status = ?";
    $params[] = $statusFilter;
}

if ($paymentFilter) {
    $whereClause[] = "s.payment_status = ?";
    $params[] = $paymentFilter;
}

if ($search) {
    $whereClause[] = "(s.application_id LIKE ? OR s.first_name LIKE ? OR s.last_name LIKE ? OR s.email LIKE ?)";
    $params[] = "%$search%";
    $params[] = "%$search%";
    $params[] = "%$search%";
    $params[] = "%$search%";
}

$whereSQL = !empty($whereClause) ? 'WHERE ' . implode(' AND ', $whereClause) : '';

try {
    $db = getDB();
    
    // Get total count
    $countSQL = "SELECT COUNT(*) as total FROM students s $whereSQL";
    $stmt = $db->prepare($countSQL);
    $stmt->execute($params);
    $totalRecords = $stmt->fetch()['total'];
    $totalPages = ceil($totalRecords / $limit);
    
    // Get applications
    $sql = "SELECT s.*, p.tracking_id, p.status as payment_status_text 
            FROM students s 
            LEFT JOIN payments p ON s.id = p.student_id 
            $whereSQL 
            ORDER BY s.submitted_at DESC 
            LIMIT $limit OFFSET $offset";
    
    $stmt = $db->prepare($sql);
    $stmt->execute($params);
    $applications = $stmt->fetchAll();
    
} catch (PDOException $e) {
    error_log("Applications Error: " . $e->getMessage());
    $error = 'An error occurred while loading applications.';
}

include __DIR__ . '/includes/admin-header.php';
?>

<div class="dashboard-content">
    
    <div class="page-header">
        <h1 class="page-title">
            <i class="fas fa-file-alt"></i> Applications
        </h1>
        <div class="breadcrumb">
            <a href="index.php">Home</a> / <span>Applications</span>
        </div>
    </div>
    
    
    <div class="card">
        <div class="card-body">
            <form method="GET" action="" style="display: flex; gap: 15px; flex-wrap: wrap;">
                <div style="flex: 1; min-width: 200px;">
                    <input type="text" name="search" class="form-control" placeholder="Search by ID, Name, or Email" value="<?php echo htmlspecialchars($search); ?>">
                </div>
                <div style="min-width: 150px;">
                    <select name="status" class="form-control">
                        <option value="">All Status</option>
                        <option value="submitted" <?php echo $statusFilter == 'submitted' ? 'selected' : ''; ?>>Submitted</option>
                        <option value="under_review" <?php echo $statusFilter == 'under_review' ? 'selected' : ''; ?>>Under Review</option>
                        <option value="verified" <?php echo $statusFilter == 'verified' ? 'selected' : ''; ?>>Verified</option>
                        <option value="shortlisted" <?php echo $statusFilter == 'shortlisted' ? 'selected' : ''; ?>>Shortlisted</option>
                        <option value="rejected" <?php echo $statusFilter == 'rejected' ? 'selected' : ''; ?>>Rejected</option>
                        <option value="waitlisted" <?php echo $statusFilter == 'waitlisted' ? 'selected' : ''; ?>>Waitlisted</option>
                        <option value="admitted" <?php echo $statusFilter == 'admitted' ? 'selected' : ''; ?>>Admitted</option>
                    </select>
                </div>
                <div style="min-width: 150px;">
                    <select name="payment" class="form-control">
                        <option value="">All Payments</option>
                        <option value="pending" <?php echo $paymentFilter == 'pending' ? 'selected' : ''; ?>>Pending</option>
                        <option value="completed" <?php echo $paymentFilter == 'completed' ? 'selected' : ''; ?>>Completed</option>
                        <option value="failed" <?php echo $paymentFilter == 'failed' ? 'selected' : ''; ?>>Failed</option>
                    </select>
                </div>
                <button type="submit" class="btn btn-primary">
                    <i class="fas fa-filter"></i> Filter
                </button>
                <a href="applications.php" class="btn btn-secondary">
                    <i class="fas fa-undo"></i> Reset
                </a>
            </form>
        </div>
    </div>
    
    
    <div class="card">
        <div class="card-header" style="display: flex; justify-content: space-between; align-items: center;">
            <h3><i class="fas fa-list"></i> All Applications (<?php echo $totalRecords; ?>)</h3>
            <button type="button" class="btn btn-sm btn-success" onclick="exportToCSV('applicationsTable', 'applications')">
                <i class="fas fa-download"></i> Export CSV
            </button>
        </div>
        <div class="card-body" style="padding: 0;">
            <table class="data-table" id="applicationsTable">
                <thead>
                    <tr>
                        <th>Application ID</th>
                        <th>Applicant Name</th>
                        <th>Course</th>
                        <th>Email</th>
                        <th>Status</th>
                        <th>Payment</th>
                        <th>Date</th>
                        <th>Actions</th>
                    </tr>
                </thead>
                <tbody>
                    <?php foreach ($applications as $app): ?>
                    <tr>
                        <td><strong><?php echo $app['application_id']; ?></strong></td>
                        <td><?php echo htmlspecialchars($app['first_name'] . ' ' . $app['last_name']); ?></td>
                        <td><?php echo htmlspecialchars($app['course']); ?></td>
                        <td><?php echo htmlspecialchars($app['email']); ?></td>
                        <td>
                            <span class="status-badge status-<?php echo $app['application_status']; ?>">
                                <?php echo ucwords(str_replace('_', ' ', $app['application_status'])); ?>
                            </span>
                        </td>
                        <td>
                            <span class="badge badge-<?php echo $app['payment_status'] === 'completed' ? 'success' : ($app['payment_status'] === 'failed' ? 'danger' : 'warning'); ?>">
                                <?php echo ucfirst($app['payment_status']); ?>
                            </span>
                        </td>
                        <td><?php echo date('d-m-Y', strtotime($app['submitted_at'])); ?></td>
                        <td>
                            <a href="view-application.php?id=<?php echo $app['id']; ?>" class="btn btn-sm btn-primary" title="View">
                                <i class="fas fa-eye"></i>
                            </a>
                        </td>
                    </tr>
                    <?php endforeach; ?>
                    
                    <?php if (empty($applications)): ?>
                    <tr>
                        <td colspan="8" style="text-align: center; padding: 40px;">
                            <i class="fas fa-inbox" style="font-size: 50px; color: var(--text-light); margin-bottom: 15px;"></i>
                            <p>No applications found</p>
                        </td>
                    </tr>
                    <?php endif; ?>
                </tbody>
            </table>
            
            
            <?php if ($totalPages > 1): ?>
            <div class="pagination">
                <?php if ($page > 1): ?>
                <a href="?page=<?php echo $page - 1; ?>&status=<?php echo $statusFilter; ?>&payment=<?php echo $paymentFilter; ?>&search=<?php echo $search; ?>">
                    <i class="fas fa-chevron-left"></i>
                </a>
                <?php endif; ?>
                
                <?php for ($i = 1; $i <= $totalPages; $i++): ?>
                <?php if ($i == $page): ?>
                <span class="active"><?php echo $i; ?></span>
                <?php else: ?>
                <a href="?page=<?php echo $i; ?>&status=<?php echo $statusFilter; ?>&payment=<?php echo $paymentFilter; ?>&search=<?php echo $search; ?>"><?php echo $i; ?></a>
                <?php endif; ?>
                <?php endfor; ?>
                
                <?php if ($page < $totalPages): ?>
                <a href="?page=<?php echo $page + 1; ?>&status=<?php echo $statusFilter; ?>&payment=<?php echo $paymentFilter; ?>&search=<?php echo $search; ?>">
                    <i class="fas fa-chevron-right"></i>
                </a>
                <?php endif; ?>
            </div>
            <?php endif; ?>
        </div>
    </div>
</div>

<?php include __DIR__ . '/includes/admin-footer.php'; ?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: applications.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation