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/subdrop.in/public_html/admin

Free Space:

8.3 TB

🔧 Quick Actions

✏️ Editing: view_application.php

<?php
/**
 * View Application - Admin Panel
 */

require_once '../includes/config.php';
requireLogin();

$id = isset($_GET['id']) ? intval($_GET['id']) : 0;

if ($id <= 0) {
    header('Location: applications.php');
    exit;
}

$conn = getDBConnection();

// Get application details
$stmt = $conn->prepare("SELECT * FROM applications_exact WHERE id = ?");
$stmt->bind_param('i', $id);
$stmt->execute();
$result = $stmt->get_result();

if ($result->num_rows === 0) {
    header('Location: applications.php');
    exit;
}

$app = $result->fetch_assoc();
$stmt->close();

// Get payment details
$stmt = $conn->prepare("SELECT * FROM payment_transactions_exact WHERE application_number = ? ORDER BY created_at DESC LIMIT 1");
$stmt->bind_param('s', $app['application_number']);
$stmt->execute();
$payment = $stmt->get_result()->fetch_assoc();
$stmt->close();

// Get status history
$stmt = $conn->prepare("SELECT h.*, a.name as changed_by_name FROM application_status_history_exact h LEFT JOIN admin_users a ON h.changed_by = a.id WHERE h.application_number = ? ORDER BY h.created_at DESC");
$stmt->bind_param('s', $app['application_number']);
$stmt->execute();
$status_history = $stmt->get_result()->fetch_all(MYSQLI_ASSOC);
$stmt->close();

// Handle status update
if ($_SERVER['REQUEST_METHOD'] === 'POST' && hasPermission('edit_application')) {
    $new_status = sanitize($_POST['status'] ?? '');
    $remarks = sanitize($_POST['remarks'] ?? '');
    
    if (!empty($new_status)) {
        // Update status
        $stmt = $conn->prepare("UPDATE applications_exact SET status = ?, remarks = ? WHERE id = ?");
        $stmt->bind_param('ssi', $new_status, $remarks, $id);
        $stmt->execute();
        $stmt->close();
        
        // Log status change
        $stmt = $conn->prepare("INSERT INTO application_status_history_exact (application_number, status_from, status_to, changed_by, remarks, created_at) VALUES (?, ?, ?, ?, ?, NOW())");
        $stmt->bind_param('sssis', $app['application_number'], $app['status'], $new_status, $_SESSION['admin_id'], $remarks);
        $stmt->execute();
        $stmt->close();
        
        setFlashMessage('Application status updated successfully.', 'success');
        logActivity('status_update', 'Updated status for ' . $app['application_number'] . ' to ' . $new_status);
        
        header('Location: view_application.php?id=' . $id);
        exit;
    }
}

// Handle PDF generation and download
if (isset($_GET['action']) && $_GET['action'] === 'generate_pdf') {
    require_once '../includes/pdf_generator.php';
    $receipt_number = $payment['receipt_number'] ?? '';
    $pdf_path = generateApplicationPDF($app['application_number'], $receipt_number);
    
    if ($pdf_path && file_exists($pdf_path)) {
        header('Content-Type: text/html');
        header('Content-Disposition: attachment; filename="Application_' . $app['application_number'] . '.html"');
        readfile($pdf_path);
        exit;
    } else {
        setFlashMessage('PDF generation failed. Please try again.', 'error');
        header('Location: view_application.php?id=' . $id);
        exit;
    }
}

// Handle PDF generation and send email
if (isset($_GET['action']) && $_GET['action'] === 'send_pdf_email') {
    require_once '../includes/pdf_generator.php';
    $receipt_number = $payment['receipt_number'] ?? '';
    
    if (sendApplicationPDFByEmail($app['application_number'], $receipt_number)) {
        setFlashMessage('Application PDF sent to student email successfully.', 'success');
        logActivity('pdf_email_sent', 'Sent PDF to ' . $app['email'] . ' for ' . $app['application_number']);
    } else {
        setFlashMessage('Failed to send PDF email. Please check SMTP settings.', 'error');
    }
    
    header('Location: view_application.php?id=' . $id);
    exit;
}

$conn->close();

$statuses = ['pending', 'payment_completed', 'under_review', 'interview_scheduled', 'interview_completed', 'selected', 'rejected', 'waitlisted'];

// Helper function to safely get value
function getValue($array, $key, $default = '-') {
    return isset($array[$key]) && !empty($array[$key]) ? $array[$key] : $default;
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>View Application - IHM Aurangabad Admin</title>
    <link rel="stylesheet" href="../assets/css/admin.css">
</head>
<body>
    <div class="admin-wrapper">
        
        <aside class="sidebar">
            <div class="sidebar-header">
                <h2>IHM Aurangabad</h2>
                <p>Admin Portal</p>
            </div>
            
            <nav class="sidebar-nav">
                <a href="dashboard.php"><span class="icon">&#127968;</span> Dashboard</a>
                <a href="applications.php" class="active"><span class="icon">&#128196;</span> Applications</a>
                <?php if (hasPermission('reports')): ?>
                <a href="reports.php"><span class="icon">&#128202;</span> Reports</a>
                <?php endif; ?>
                <?php if (hasPermission('admin_users')): ?>
                <a href="admin_users.php"><span class="icon">&#128100;</span> Admin Users</a>
                <?php endif; ?>
                <?php if (hasPermission('settings')): ?>
                <a href="settings.php"><span class="icon">&#9881;</span> Settings</a>
                <?php endif; ?>
                <a href="guide.php"><span class="icon">&#128214;</span> User Guide</a>
                <a href="logout.php"><span class="icon">&#128682;</span> Logout</a>
            </nav>
        </aside>
        
        
        <main class="main-content">
            <header class="header">
                <h1>Application Details</h1>
                <div class="user-info">
                    <a href="applications.php" class="btn">Back to List</a>
                </div>
            </header>
            
            <?php showFlashMessage(); ?>
            
            
            <div class="content-card">
                <div class="card-header">
                    <div>
                        <h2><?php echo htmlspecialchars($app['application_number']); ?></h2>
                        <p>Submitted on <?php echo formatDateTime($app['created_at']); ?></p>
                    </div>
                    <div>
                        <?php echo getStatusBadge($app['status']); ?>
                        <span class="status-badge status-<?php echo $app['payment_status']; ?>" style="margin-left: 10px;"><?php echo ucfirst($app['payment_status']); ?></span>
                    </div>
                </div>
            </div>
            
            
            <div class="tabs">
                <div class="tab active" onclick="showTab('details')">Application Details</div>
                <div class="tab" onclick="showTab('payment')">Payment Info</div>
                <div class="tab" onclick="showTab('history')">Status History</div>
                <?php if (hasPermission('edit_application')): ?>
                <div class="tab" onclick="showTab('actions')">Actions</div>
                <?php endif; ?>
            </div>
            
            
            <div id="details" class="tab-content active">
                <div class="application-view">
                    
                    <div class="view-section">
                        <h4>Applicant Details</h4>
                        <div class="view-row">
                            <div class="view-label">Full Name</div>
                            <div class="view-value"><?php echo htmlspecialchars($app['title'] . ' ' . $app['first_name'] . ' ' . $app['middle_name'] . ' ' . $app['last_name']); ?></div>
                        </div>
                        <div class="view-row">
                            <div class="view-label">Course Applied</div>
                            <div class="view-value"><?php echo htmlspecialchars($app['preferred_course']); ?></div>
                        </div>
                        <div class="view-row">
                            <div class="view-label">Test Centre</div>
                            <div class="view-value"><?php echo htmlspecialchars($app['test_centre']); ?></div>
                        </div>
                        <div class="view-row">
                            <div class="view-label">Date of Birth</div>
                            <div class="view-value"><?php echo formatDate($app['date_of_birth']); ?></div>
                        </div>
                        <div class="view-row">
                            <div class="view-label">Height</div>
                            <div class="view-value"><?php echo getValue($app, 'height', '-'); ?> cm</div>
                        </div>
                        <div class="view-row">
                            <div class="view-label">Weight</div>
                            <div class="view-value"><?php echo getValue($app, 'weight', '-'); ?> kg</div>
                        </div>
                        <div class="view-row">
                            <div class="view-label">Faith/Religion</div>
                            <div class="view-value"><?php echo getValue($app, 'faith', '-'); ?></div>
                        </div>
                        <div class="view-row">
                            <div class="view-label">Mother Tongue</div>
                            <div class="view-value"><?php echo getValue($app, 'mother_tongue', '-'); ?></div>
                        </div>
                        <div class="view-row">
                            <div class="view-label">Nationality</div>
                            <div class="view-value"><?php echo getValue($app, 'nationality', '-'); ?></div>
                        </div>
                        <div class="view-row">
                            <div class="view-label">State of Domicile</div>
                            <div class="view-value"><?php echo getValue($app, 'state_of_domicile', '-'); ?></div>
                        </div>
                        <div class="view-row">
                            <div class="view-label">Email</div>
                            <div class="view-value"><?php echo getValue($app, 'email', '-'); ?></div>
                        </div>
                        <div class="view-row">
                            <div class="view-label">Mobile</div>
                            <div class="view-value"><?php echo getValue($app, 'mobile', '-'); ?></div>
                        </div>
                        <div class="view-row">
                            <div class="view-label">Phone (Home)</div>
                            <div class="view-value"><?php echo getValue($app, 'phone_home', '-'); ?></div>
                        </div>
                        <div class="view-row">
                            <div class="view-label">Address</div>
                            <div class="view-value">
                                <?php echo nl2br(htmlspecialchars($app['address_line1'] . "\n" . $app['address_line2'])); ?><br>
                                <?php echo htmlspecialchars($app['city'] . ', ' . $app['state'] . ' - ' . $app['pincode']); ?>
                            </div>
                        </div>
                    </div>
                    
                    
                    <div class="view-section">
                        <h4>Family Details</h4>
                        <div class="view-row">
                            <div class="view-label">Father's Name</div>
                            <div class="view-value"><?php echo htmlspecialchars(getValue($app, 'father_first_name', '') . ' ' . getValue($app, 'father_middle_name', '') . ' ' . getValue($app, 'father_last_name', '')); ?></div>
                        </div>
                        <div class="view-row">
                            <div class="view-label">Father's Age</div>
                            <div class="view-value"><?php echo getValue($app, 'father_age', '-'); ?></div>
                        </div>
                        <div class="view-row">
                            <div class="view-label">Father's Occupation</div>
                            <div class="view-value"><?php echo getValue($app, 'father_occupation', '-'); ?></div>
                        </div>
                        <div class="view-row">
                            <div class="view-label">Father's Email</div>
                            <div class="view-value"><?php echo getValue($app, 'father_email', '-'); ?></div>
                        </div>
                        <div class="view-row">
                            <div class="view-label">Father's Phone</div>
                            <div class="view-value"><?php echo getValue($app, 'father_phone', '-'); ?></div>
                        </div>
                        <div class="view-row">
                            <div class="view-label">Father's Address</div>
                            <div class="view-value">
                                <?php echo nl2br(htmlspecialchars(getValue($app, 'father_address_line1', '') . "\n" . getValue($app, 'father_address_line2', ''))); ?><br>
                                <?php echo htmlspecialchars(getValue($app, 'father_city', '') . ', ' . getValue($app, 'father_state', '') . ' - ' . getValue($app, 'father_pincode', '')); ?>
                            </div>
                        </div>
                        <div class="view-row">
                            <div class="view-label">Mother's Name</div>
                            <div class="view-value"><?php echo htmlspecialchars(getValue($app, 'mother_first_name', '') . ' ' . getValue($app, 'mother_middle_name', '') . ' ' . getValue($app, 'mother_last_name', '')); ?></div>
                        </div>
                        <div class="view-row">
                            <div class="view-label">Mother's Age</div>
                            <div class="view-value"><?php echo getValue($app, 'mother_age', '-'); ?></div>
                        </div>
                        <div class="view-row">
                            <div class="view-label">Mother's Occupation</div>
                            <div class="view-value"><?php echo getValue($app, 'mother_occupation', '-'); ?></div>
                        </div>
                        <div class="view-row">
                            <div class="view-label">Mother's Phone</div>
                            <div class="view-value"><?php echo getValue($app, 'mother_phone', '-'); ?></div>
                        </div>
                    </div>
                    
                    
                    <div class="view-section">
                        <h4>Educational Details</h4>
                        <div class="view-row">
                            <div class="view-label">10th Standard</div>
                            <div class="view-value">
                                School: <?php echo getValue($app, 'edu_x_school', '-'); ?><br>
                                Year: <?php echo getValue($app, 'edu_x_year', '-'); ?><br>
                                Marks: <?php echo getValue($app, 'edu_x_marks', '-'); ?>%<br>
                                Subjects: <?php echo getValue($app, 'edu_x_subjects', '-'); ?>
                            </div>
                        </div>
                        <div class="view-row">
                            <div class="view-label">12th Standard</div>
                            <div class="view-value">
                                School: <?php echo getValue($app, 'edu_xii_school', '-'); ?><br>
                                Year: <?php echo getValue($app, 'edu_xii_year', '-'); ?><br>
                                Marks: <?php echo getValue($app, 'edu_xii_marks', '-'); ?>%<br>
                                Subjects: <?php echo getValue($app, 'edu_xii_subjects', '-'); ?>
                            </div>
                        </div>
                    </div>
                    
                    
                    <div class="view-section">
                        <h4>References</h4>
                        <div class="view-row">
                            <div class="view-label">Reference 1</div>
                            <div class="view-value">
                                Name: <?php echo getValue($app, 'ref1_name', '-'); ?><br>
                                Occupation: <?php echo getValue($app, 'ref1_occupation', '-'); ?><br>
                                Designation: <?php echo getValue($app, 'ref1_designation', '-'); ?><br>
                                Years Known: <?php echo getValue($app, 'ref1_known_years', '-'); ?><br>
                                Address: <?php echo getValue($app, 'ref1_address', '-'); ?>
                            </div>
                        </div>
                        <div class="view-row">
                            <div class="view-label">Reference 2</div>
                            <div class="view-value">
                                Name: <?php echo getValue($app, 'ref2_name', '-'); ?><br>
                                Occupation: <?php echo getValue($app, 'ref2_occupation', '-'); ?><br>
                                Designation: <?php echo getValue($app, 'ref2_designation', '-'); ?><br>
                                Years Known: <?php echo getValue($app, 'ref2_known_years', '-'); ?><br>
                                Address: <?php echo getValue($app, 'ref2_address', '-'); ?>
                            </div>
                        </div>
                    </div>
                    
                    
                    <div class="view-section">
                        <h4>Documents</h4>
                        <div class="view-row">
                            <div class="view-label">Applicant Photo</div>
                            <div class="view-value">
                                <?php if (!empty($app['applicant_photo']) && file_exists('../' . $app['applicant_photo'])): ?>
                                <img src="../<?php echo $app['applicant_photo']; ?>" alt="Photo" style="max-width: 150px; border: 1px solid #ddd;">
                                <?php else: ?>
                                <span class="text-muted">Not uploaded</span>
                                <?php endif; ?>
                            </div>
                        </div>
                        <div class="view-row">
                            <div class="view-label">Applicant Signature</div>
                            <div class="view-value">
                                <?php if (!empty($app['applicant_signature']) && file_exists('../' . $app['applicant_signature'])): ?>
                                <img src="../<?php echo $app['applicant_signature']; ?>" alt="Signature" style="max-width: 250px; border: 1px solid #ddd;">
                                <?php else: ?>
                                <span class="text-muted">Not uploaded</span>
                                <?php endif; ?>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
            
            
            <div id="payment" class="tab-content">
                <div class="content-card">
                    <div class="card-header">
                        <h3>Payment Information</h3>
                    </div>
                    <?php if ($payment): ?>
                    <div class="view-section">
                        <div class="view-row">
                            <div class="view-label">Order ID</div>
                            <div class="view-value"><?php echo htmlspecialchars($payment['order_id']); ?></div>
                        </div>
                        <div class="view-row">
                            <div class="view-label">Receipt Number</div>
                            <div class="view-value"><?php echo htmlspecialchars($payment['receipt_number'] ?? 'N/A'); ?></div>
                        </div>
                        <div class="view-row">
                            <div class="view-label">Transaction ID</div>
                            <div class="view-value"><?php echo htmlspecialchars($payment['transaction_id'] ?? 'N/A'); ?></div>
                        </div>
                        <div class="view-row">
                            <div class="view-label">Amount</div>
                            <div class="view-value">&#8377; <?php echo number_format($payment['amount'], 2); ?></div>
                        </div>
                        <div class="view-row">
                            <div class="view-label">Payment Mode</div>
                            <div class="view-value"><?php echo htmlspecialchars($payment['payment_mode'] ?? 'N/A'); ?></div>
                        </div>
                        <div class="view-row">
                            <div class="view-label">Status</div>
                            <div class="view-value"><span class="status-badge status-<?php echo $payment['status']; ?>"><?php echo ucfirst($payment['status']); ?></span></div>
                        </div>
                        <div class="view-row">
                            <div class="view-label">Payment Date</div>
                            <div class="view-value"><?php echo formatDateTime($payment['created_at']); ?></div>
                        </div>
                    </div>
                    <?php else: ?>
                    <p style="padding: 20px;">No payment information available.</p>
                    <?php endif; ?>
                </div>
            </div>
            
            
            <div id="history" class="tab-content">
                <div class="content-card">
                    <div class="card-header">
                        <h3>Status History</h3>
                    </div>
                    <div class="table-responsive">
                        <table class="data-table">
                            <thead>
                                <tr>
                                    <th>Date</th>
                                    <th>From Status</th>
                                    <th>To Status</th>
                                    <th>Changed By</th>
                                    <th>Remarks</th>
                                </tr>
                            </thead>
                            <tbody>
                                <?php foreach ($status_history as $history): ?>
                                <tr>
                                    <td><?php echo formatDateTime($history['created_at']); ?></td>
                                    <td><?php echo ucfirst(str_replace('_', ' ', $history['status_from'])); ?></td>
                                    <td><?php echo ucfirst(str_replace('_', ' ', $history['status_to'])); ?></td>
                                    <td><?php echo htmlspecialchars($history['changed_by_name'] ?? 'System'); ?></td>
                                    <td><?php echo htmlspecialchars($history['remarks'] ?? '-'); ?></td>
                                </tr>
                                <?php endforeach; ?>
                                <?php if (empty($status_history)): ?>
                                <tr><td colspan="5" style="text-align: center;">No history available</td></tr>
                                <?php endif; ?>
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>
            
            
            <?php if (hasPermission('edit_application')): ?>
            <div id="actions" class="tab-content">
                <div class="content-card">
                    <div class="card-header">
                        <h3>Update Status</h3>
                    </div>
                    <form method="POST" action="" style="padding: 20px;">
                        <div class="form-row">
                            <div class="form-group">
                                <label>Status</label>
                                <select name="status" required>
                                    <option value="">Select Status</option>
                                    <?php foreach ($statuses as $status): ?>
                                    <option value="<?php echo $status; ?>" <?php echo $app['status'] === $status ? 'selected' : ''; ?>><?php echo ucfirst(str_replace('_', ' ', $status)); ?></option>
                                    <?php endforeach; ?>
                                </select>
                            </div>
                        </div>
                        <div class="form-row">
                            <div class="form-group">
                                <label>Remarks</label>
                                <textarea name="remarks" rows="4" placeholder="Add any remarks about this status change..."></textarea>
                            </div>
                        </div>
                        <button type="submit" class="btn btn-success">Update Status</button>
                    </form>
                </div>
                
                
                <div class="content-card" style="margin-top: 20px;">
                    <div class="card-header">
                        <h3>Generate Application PDF</h3>
                    </div>
                    <div style="padding: 20px;">
                        <p>Download the application form as a PDF document.</p>
                        <a href="view_application.php?id=<?php echo $id; ?>&action=generate_pdf" class="btn btn-primary" style="margin-top: 10px;">
                            <span class="icon">&#128196;</span> Download PDF
                        </a>
                    </div>
                </div>
                
                
                <div class="content-card" style="margin-top: 20px;">
                    <div class="card-header">
                        <h3>Send PDF to Student</h3>
                    </div>
                    <div style="padding: 20px;">
                        <p>Send the application form PDF to student's registered email address.</p>
                        <p><strong>Student Email:</strong> <?php echo htmlspecialchars($app['email']); ?></p>
                        <a href="view_application.php?id=<?php echo $id; ?>&action=send_pdf_email" class="btn btn-success" style="margin-top: 10px;" onclick="return confirm('Are you sure you want to send the PDF to <?php echo htmlspecialchars($app['email']); ?>?');">
                            <span class="icon">&#9993;</span> Send PDF via Email
                        </a>
                    </div>
                </div>
            </div>
            <?php endif; ?>
        </main>
    </div>
    
    <script>
        function showTab(tabId) {
            // Hide all tabs
            document.querySelectorAll('.tab-content').forEach(tab => {
                tab.classList.remove('active');
            });
            document.querySelectorAll('.tab').forEach(tab => {
                tab.classList.remove('active');
            });
            
            // Show selected tab
            document.getElementById(tabId).classList.add('active');
            event.target.classList.add('active');
        }
    </script>
</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: view_application.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation