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

🔧 Quick Actions

✏️ Editing: view-application.php

<?php
/**
 * View Application Details Page
 */

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

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

$pageTitle = 'View Application';

// Get application ID
$studentId = isset($_GET['id']) ? intval($_GET['id']) : 0;

if (!$studentId) {
    setFlashMessage('error', 'Invalid application ID.');
    redirect('applications.php');
}

try {
    $db = getDB();
    
    // Get student details
    $stmt = $db->prepare("SELECT * FROM students WHERE id = ?");
    $stmt->execute([$studentId]);
    $student = $stmt->fetch();
    
    if (!$student) {
        setFlashMessage('error', 'Application not found.');
        redirect('applications.php');
    }
    
    // Get family details
    $stmt = $db->prepare("SELECT * FROM family_details WHERE student_id = ?");
    $stmt->execute([$studentId]);
    $familyMembers = $stmt->fetchAll();
    
    $father = null;
    $mother = null;
    foreach ($familyMembers as $member) {
        if ($member['relation_type'] === 'father') {
            $father = $member;
        } elseif ($member['relation_type'] === 'mother') {
            $mother = $member;
        }
    }
    
    // Get siblings
    $stmt = $db->prepare("SELECT * FROM siblings WHERE student_id = ?");
    $stmt->execute([$studentId]);
    $siblings = $stmt->fetchAll();
    
    // Get education details
    $stmt = $db->prepare("SELECT * FROM education_details WHERE student_id = ?");
    $stmt->execute([$studentId]);
    $education = $stmt->fetchAll();
    
    // Get employment details
    $stmt = $db->prepare("SELECT * FROM employment_details WHERE student_id = ?");
    $stmt->execute([$studentId]);
    $employment = $stmt->fetchAll();
    
    // Get extra curricular
    $stmt = $db->prepare("SELECT * FROM extracurricular_activities WHERE student_id = ?");
    $stmt->execute([$studentId]);
    $activities = $stmt->fetchAll();
    
    // Get hobbies
    $stmt = $db->prepare("SELECT * FROM student_hobbies WHERE student_id = ?");
    $stmt->execute([$studentId]);
    $hobbies = $stmt->fetch();
    
    // Get languages
    $stmt = $db->prepare("SELECT * FROM languages_known WHERE student_id = ?");
    $stmt->execute([$studentId]);
    $languages = $stmt->fetchAll();
    
    // Get references
    $stmt = $db->prepare("SELECT * FROM references_info WHERE student_id = ?");
    $stmt->execute([$studentId]);
    $references = $stmt->fetchAll();
    
    // Get declaration
    $stmt = $db->prepare("SELECT * FROM parent_declarations WHERE student_id = ?");
    $stmt->execute([$studentId]);
    $declaration = $stmt->fetch();
    
    // Get payment details
    $stmt = $db->prepare("SELECT * FROM payments WHERE student_id = ? ORDER BY created_at DESC LIMIT 1");
    $stmt->execute([$studentId]);
    $payment = $stmt->fetch();
    
    // Get status history
    $stmt = $db->prepare("SELECT h.*, a.name as changed_by_name 
                          FROM application_status_history h 
                          LEFT JOIN admin_users a ON h.changed_by = a.id 
                          WHERE h.student_id = ? 
                          ORDER BY h.created_at DESC");
    $stmt->execute([$studentId]);
    $statusHistory = $stmt->fetchAll();
    
} catch (PDOException $e) {
    error_log("View Application Error: " . $e->getMessage());
    setFlashMessage('error', 'An error occurred while loading application.');
    redirect('applications.php');
}

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> Application Details
        </h1>
        <div class="breadcrumb">
            <a href="index.php">Home</a> / <a href="applications.php">Applications</a> / <span>View</span>
        </div>
    </div>
    
    
    <div class="card">
        <div class="card-header" style="display: flex; justify-content: space-between; align-items: center;">
            <h3><i class="fas fa-info-circle"></i> Application Summary</h3>
            <div style="display: flex; gap: 10px;">
                <a href="../receipt.php?id=<?php echo $student['application_id']; ?>" class="btn btn-sm btn-primary" target="_blank">
                    <i class="fas fa-file-invoice"></i> View Receipt (Fees)
                </a>
                <a href="../print-application.php?id=<?php echo $student['application_id']; ?>" class="btn btn-sm btn-success" target="_blank">
                    <i class="fas fa-file-pdf"></i> Print Application
                </a>
                <a href="applications.php" class="btn btn-sm btn-secondary">
                    <i class="fas fa-arrow-left"></i> Back
                </a>
            </div>
        </div>
        <div class="card-body">
            <div class="stats-grid" style="grid-template-columns: repeat(auto-fit, minmax(200px, 1fr));">
                <div style="background: var(--bg-light); padding: 20px; border-radius: 8px;">
                    <p style="color: var(--text-light); font-size: 12px; margin-bottom: 5px;">Application ID</p>
                    <p style="font-weight: 700; font-size: 18px; color: var(--primary-color);"><?php echo $student['application_id']; ?></p>
                </div>
                <div style="background: var(--bg-light); padding: 20px; border-radius: 8px;">
                    <p style="color: var(--text-light); font-size: 12px; margin-bottom: 5px;">Status</p>
                    <span class="status-badge status-<?php echo $student['application_status']; ?>">
                        <?php echo ucwords(str_replace('_', ' ', $student['application_status'])); ?>
                    </span>
                </div>
                <div style="background: var(--bg-light); padding: 20px; border-radius: 8px;">
                    <p style="color: var(--text-light); font-size: 12px; margin-bottom: 5px;">Payment Status</p>
                    <span class="badge badge-<?php echo $student['payment_status'] === 'completed' ? 'success' : ($student['payment_status'] === 'failed' ? 'danger' : 'warning'); ?>">
                        <?php echo ucfirst($student['payment_status']); ?>
                    </span>
                </div>
                <div style="background: var(--bg-light); padding: 20px; border-radius: 8px;">
                    <p style="color: var(--text-light); font-size: 12px; margin-bottom: 5px;">Submitted On</p>
                    <p style="font-weight: 600;"><?php echo date('d-m-Y h:i A', strtotime($student['submitted_at'])); ?></p>
                </div>
            </div>
        </div>
    </div>
    
    
    <div class="card">
        <div class="card-header">
            <h3><i class="fas fa-user"></i> Applicant Details</h3>
        </div>
        <div class="card-body">
            <div class="stats-grid" style="grid-template-columns: repeat(auto-fit, minmax(250px, 1fr));">
                <div>
                    <p style="color: var(--text-light); font-size: 12px; margin-bottom: 5px;">Full Name</p>
                    <p style="font-weight: 600;"><?php echo htmlspecialchars($student['title'] . ' ' . $student['first_name'] . ' ' . $student['middle_name'] . ' ' . $student['last_name']); ?></p>
                </div>
                <div>
                    <p style="color: var(--text-light); font-size: 12px; margin-bottom: 5px;">Course Applied</p>
                    <p style="font-weight: 600;"><?php echo htmlspecialchars($student['course']); ?></p>
                </div>
                <div>
                    <p style="color: var(--text-light); font-size: 12px; margin-bottom: 5px;">Date of Birth</p>
                    <p style="font-weight: 600;"><?php echo date('d-m-Y', strtotime($student['date_of_birth'])); ?></p>
                </div>
                <div>
                    <p style="color: var(--text-light); font-size: 12px; margin-bottom: 5px;">Email</p>
                    <p style="font-weight: 600;"><?php echo htmlspecialchars($student['email']); ?></p>
                </div>
                <div>
                    <p style="color: var(--text-light); font-size: 12px; margin-bottom: 5px;">Mobile</p>
                    <p style="font-weight: 600;"><?php echo htmlspecialchars($student['mobile']); ?></p>
                </div>
                <div>
                    <p style="color: var(--text-light); font-size: 12px; margin-bottom: 5px;">Nationality</p>
                    <p style="font-weight: 600;"><?php echo htmlspecialchars($student['nationality']); ?></p>
                </div>
                <div>
                    <p style="color: var(--text-light); font-size: 12px; margin-bottom: 5px;">State of Domicile</p>
                    <p style="font-weight: 600;"><?php echo htmlspecialchars($student['state_domicile']); ?></p>
                </div>
                <div>
                    <p style="color: var(--text-light); font-size: 12px; margin-bottom: 5px;">Mother Tongue</p>
                    <p style="font-weight: 600;"><?php echo htmlspecialchars($student['mother_tongue']); ?></p>
                </div>
            </div>
            
            <div style="margin-top: 20px;">
                <p style="color: var(--text-light); font-size: 12px; margin-bottom: 5px;">Address</p>
                <p style="font-weight: 600;">
                    <?php echo htmlspecialchars($student['address_line1']); ?><br>
                    <?php if ($student['address_line2']) echo htmlspecialchars($student['address_line2']) . '<br>'; ?>
                    <?php echo htmlspecialchars($student['city'] . ', ' . $student['state'] . ' - ' . $student['pincode']); ?>
                </p>
            </div>
            
            <?php if ($student['photo_path']): ?>
            <div style="margin-top: 20px;">
                <p style="color: var(--text-light); font-size: 12px; margin-bottom: 10px;">Photo</p>
                <img src="../assets/uploads/<?php echo $student['photo_path']; ?>" alt="Applicant Photo" style="max-width: 150px; border: 1px solid var(--border-color); border-radius: 8px;">
            </div>
            <?php endif; ?>
        </div>
    </div>
    
    
    <div class="card">
        <div class="card-header">
            <h3><i class="fas fa-users"></i> Family Details</h3>
        </div>
        <div class="card-body">
            <?php if ($father): ?>
            <h4 style="margin-bottom: 15px; color: var(--primary-color);">Father's Details</h4>
            <div class="stats-grid" style="grid-template-columns: repeat(auto-fit, minmax(200px, 1fr)); margin-bottom: 20px;">
                <div>
                    <p style="color: var(--text-light); font-size: 12px; margin-bottom: 5px;">Name</p>
                    <p style="font-weight: 600;"><?php echo htmlspecialchars($father['first_name'] . ' ' . $father['middle_name'] . ' ' . $father['last_name']); ?></p>
                </div>
                <div>
                    <p style="color: var(--text-light); font-size: 12px; margin-bottom: 5px;">Age</p>
                    <p style="font-weight: 600;"><?php echo $father['age']; ?></p>
                </div>
                <div>
                    <p style="color: var(--text-light); font-size: 12px; margin-bottom: 5px;">Occupation</p>
                    <p style="font-weight: 600;"><?php echo htmlspecialchars($father['occupation']); ?></p>
                </div>
                <div>
                    <p style="color: var(--text-light); font-size: 12px; margin-bottom: 5px;">Mobile</p>
                    <p style="font-weight: 600;"><?php echo htmlspecialchars($father['mobile']); ?></p>
                </div>
            </div>
            <?php endif; ?>
            
            <?php if ($mother): ?>
            <h4 style="margin-bottom: 15px; color: var(--primary-color);">Mother's Details</h4>
            <div class="stats-grid" style="grid-template-columns: repeat(auto-fit, minmax(200px, 1fr)); margin-bottom: 20px;">
                <div>
                    <p style="color: var(--text-light); font-size: 12px; margin-bottom: 5px;">Name</p>
                    <p style="font-weight: 600;"><?php echo htmlspecialchars($mother['first_name'] . ' ' . $mother['middle_name'] . ' ' . $mother['last_name']); ?></p>
                </div>
                <div>
                    <p style="color: var(--text-light); font-size: 12px; margin-bottom: 5px;">Age</p>
                    <p style="font-weight: 600;"><?php echo $mother['age']; ?></p>
                </div>
                <div>
                    <p style="color: var(--text-light); font-size: 12px; margin-bottom: 5px;">Occupation</p>
                    <p style="font-weight: 600;"><?php echo htmlspecialchars($mother['occupation']); ?></p>
                </div>
            </div>
            <?php endif; ?>
            
            <?php if (!empty($siblings)): ?>
            <h4 style="margin-bottom: 15px; color: var(--primary-color);">Siblings</h4>
            <table class="data-table">
                <thead>
                    <tr>
                        <th>Name</th>
                        <th>Age</th>
                        <th>Occupation</th>
                    </tr>
                </thead>
                <tbody>
                    <?php foreach ($siblings as $sibling): ?>
                    <tr>
                        <td><?php echo htmlspecialchars($sibling['full_name']); ?></td>
                        <td><?php echo $sibling['age']; ?></td>
                        <td><?php echo htmlspecialchars($sibling['occupation']); ?></td>
                    </tr>
                    <?php endforeach; ?>
                </tbody>
            </table>
            <?php endif; ?>
        </div>
    </div>
    
    
    <div class="card">
        <div class="card-header">
            <h3><i class="fas fa-graduation-cap"></i> Educational Details</h3>
        </div>
        <div class="card-body" style="padding: 0;">
            <table class="data-table">
                <thead>
                    <tr>
                        <th>Examination</th>
                        <th>School/College</th>
                        <th>Year</th>
                        <th>Marks (%)</th>
                        <th>Major Subjects</th>
                    </tr>
                </thead>
                <tbody>
                    <?php foreach ($education as $edu): ?>
                    <tr>
                        <td><?php echo htmlspecialchars($edu['examination']); ?></td>
                        <td><?php echo htmlspecialchars($edu['school_college']); ?></td>
                        <td><?php echo $edu['year']; ?></td>
                        <td><?php echo $edu['marks_percentage']; ?></td>
                        <td><?php echo htmlspecialchars($edu['major_subjects']); ?></td>
                    </tr>
                    <?php endforeach; ?>
                </tbody>
            </table>
        </div>
    </div>
    
    
    <?php if ($payment): ?>
    <div class="card">
        <div class="card-header">
            <h3><i class="fas fa-credit-card"></i> Payment Details</h3>
        </div>
        <div class="card-body">
            <div class="stats-grid" style="grid-template-columns: repeat(auto-fit, minmax(200px, 1fr));">
                <div>
                    <p style="color: var(--text-light); font-size: 12px; margin-bottom: 5px;">Order ID</p>
                    <p style="font-weight: 600;"><?php echo $payment['order_id']; ?></p>
                </div>
                <div>
                    <p style="color: var(--text-light); font-size: 12px; margin-bottom: 5px;">Transaction ID</p>
                    <p style="font-weight: 600;"><?php echo $payment['tracking_id']; ?></p>
                </div>
                <div>
                    <p style="color: var(--text-light); font-size: 12px; margin-bottom: 5px;">Amount</p>
                    <p style="font-weight: 600;">₹<?php echo number_format($payment['amount'], 2); ?></p>
                </div>
                <div>
                    <p style="color: var(--text-light); font-size: 12px; margin-bottom: 5px;">Payment Mode</p>
                    <p style="font-weight: 600;"><?php echo htmlspecialchars($payment['payment_mode']); ?></p>
                </div>
                <div>
                    <p style="color: var(--text-light); font-size: 12px; margin-bottom: 5px;">Status</p>
                    <span class="badge badge-<?php echo $payment['status'] === 'success' ? 'success' : 'danger'; ?>">
                        <?php echo ucfirst($payment['status']); ?>
                    </span>
                </div>
                <div>
                    <p style="color: var(--text-light); font-size: 12px; margin-bottom: 5px;">Payment Date</p>
                    <p style="font-weight: 600;"><?php echo $payment['paid_at'] ? date('d-m-Y h:i A', strtotime($payment['paid_at'])) : 'N/A'; ?></p>
                </div>
            </div>
        </div>
    </div>
    <?php endif; ?>
    
    
    <div class="card">
        <div class="card-header">
            <h3><i class="fas fa-edit"></i> Update Application Status</h3>
        </div>
        <div class="card-body">
            <form method="POST" action="">
                <input type="hidden" name="student_id" value="<?php echo $studentId; ?>">
                
                <div style="display: grid; grid-template-columns: 1fr 2fr; gap: 20px;">
                    <div class="form-group">
                        <label class="form-label">New Status</label>
                        <select name="status" class="form-control" required>
                            <option value="submitted" <?php echo $student['application_status'] == 'submitted' ? 'selected' : ''; ?>>Submitted</option>
                            <option value="under_review" <?php echo $student['application_status'] == 'under_review' ? 'selected' : ''; ?>>Under Review</option>
                            <option value="verified" <?php echo $student['application_status'] == 'verified' ? 'selected' : ''; ?>>Verified</option>
                            <option value="shortlisted" <?php echo $student['application_status'] == 'shortlisted' ? 'selected' : ''; ?>>Shortlisted</option>
                            <option value="rejected" <?php echo $student['application_status'] == 'rejected' ? 'selected' : ''; ?>>Rejected</option>
                            <option value="waitlisted" <?php echo $student['application_status'] == 'waitlisted' ? 'selected' : ''; ?>>Waitlisted</option>
                            <option value="admitted" <?php echo $student['application_status'] == 'admitted' ? 'selected' : ''; ?>>Admitted</option>
                        </select>
                    </div>
                    <div class="form-group">
                        <label class="form-label">Remarks</label>
                        <textarea name="remarks" class="form-control" rows="3" placeholder="Enter remarks (optional)"><?php echo htmlspecialchars($student['remarks']); ?></textarea>
                    </div>
                </div>
                
                <div style="margin-top: 20px;">
                    <button type="submit" name="update_status" class="btn btn-primary">
                        <i class="fas fa-save"></i> Update Status
                    </button>
                </div>
            </form>
        </div>
    </div>
    
    
    <?php if (!empty($statusHistory)): ?>
    <div class="card">
        <div class="card-header">
            <h3><i class="fas fa-history"></i> Status History</h3>
        </div>
        <div class="card-body" style="padding: 0;">
            <table class="data-table">
                <thead>
                    <tr>
                        <th>Date</th>
                        <th>Old Status</th>
                        <th>New Status</th>
                        <th>Changed By</th>
                        <th>Remarks</th>
                    </tr>
                </thead>
                <tbody>
                    <?php foreach ($statusHistory as $history): ?>
                    <tr>
                        <td><?php echo date('d-m-Y h:i A', strtotime($history['created_at'])); ?></td>
                        <td><?php echo ucwords(str_replace('_', ' ', $history['old_status'])); ?></td>
                        <td><?php echo ucwords(str_replace('_', ' ', $history['new_status'])); ?></td>
                        <td><?php echo htmlspecialchars($history['changed_by_name'] ?? 'System'); ?></td>
                        <td><?php echo htmlspecialchars($history['remarks']); ?></td>
                    </tr>
                    <?php endforeach; ?>
                </tbody>
            </table>
        </div>
    </div>
    <?php endif; ?>
</div>

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

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: view-application.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation