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: interviews.php

<?php
require_once '../includes/config.php';
requireLogin();
requirePermission('interviews');

$conn = getDBConnection();

// Handle schedule interview
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['action'])) {
    if ($_POST['action'] === 'schedule') {
        $application_number = sanitize($_POST['application_number']);
        $interview_date = sanitize($_POST['interview_date']);
        $interview_venue = sanitize($_POST['interview_venue']);
        $notes = sanitize($_POST['notes']);
        
        $stmt = $conn->prepare("INSERT INTO interviews (application_number, interview_date, interview_venue, notes, status, created_by, created_at) VALUES (?, ?, ?, ?, 'scheduled', ?, NOW())");
        $stmt->bind_param('ssssi', $application_number, $interview_date, $interview_venue, $notes, $_SESSION['admin_id']);
        
        if ($stmt->execute()) {
            $stmt = $conn->prepare("UPDATE applications_exact SET interview_date = ?, interview_venue = ?, interview_status = 'scheduled', status = 'interview_scheduled' WHERE application_number = ?");
            $stmt->bind_param('sss', $interview_date, $interview_venue, $application_number);
            $stmt->execute();
            
            setFlashMessage('Interview scheduled successfully.', 'success');
            logActivity('interview_scheduled', 'Scheduled interview for ' . $application_number);
        } else {
            setFlashMessage('Failed to schedule interview.', 'error');
        }
        $stmt->close();
        header('Location: interviews.php');
        exit;
    }
    
    if ($_POST['action'] === 'update_status') {
        $interview_id = intval($_POST['interview_id']);
        $status = sanitize($_POST['status']);
        $score = sanitize($_POST['score']);
        $feedback = sanitize($_POST['feedback']);
        
        $stmt = $conn->prepare("UPDATE interviews SET status = ?, score = ?, feedback = ? WHERE id = ?");
        $stmt->bind_param('sssi', $status, $score, $feedback, $interview_id);
        
        if ($stmt->execute()) {
            $stmt = $conn->prepare("SELECT application_number FROM interviews WHERE id = ?");
            $stmt->bind_param('i', $interview_id);
            $stmt->execute();
            $app_number = $stmt->get_result()->fetch_assoc()['application_number'];
            
            $stmt = $conn->prepare("UPDATE applications_exact SET interview_status = ? WHERE application_number = ?");
            $stmt->bind_param('ss', $status, $app_number);
            $stmt->execute();
            
            setFlashMessage('Interview status updated successfully.', 'success');
            logActivity('interview_updated', 'Updated interview status for ID: ' . $interview_id);
        } else {
            setFlashMessage('Failed to update interview status.', 'error');
        }
        $stmt->close();
        header('Location: interviews.php');
        exit;
    }
}

// Get all interviews
$result = $conn->query("SELECT i.*, a.title, a.first_name, a.last_name, a.email, a.mobile, a.preferred_course FROM interviews i JOIN applications_exact a ON i.application_number = a.application_number ORDER BY i.interview_date DESC");
$interviews = $result->fetch_all(MYSQLI_ASSOC);

// Get eligible applicants
$result = $conn->query("SELECT application_number, title, first_name, last_name, preferred_course FROM applications_exact WHERE payment_status = 'completed' AND (interview_status IS NULL OR interview_status = '') ORDER BY created_at DESC");
$eligible_applicants = $result->fetch_all(MYSQLI_ASSOC);

$conn->close();
?>
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Interviews - 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"><span class="icon">&#128196;</span> Applications</a>
                <a href="interviews.php" class="active"><span class="icon">&#128197;</span> Interviews</a>
                <a href="merit_list.php"><span class="icon">&#127942;</span> Merit List</a>
                <a href="admin_users.php"><span class="icon">&#128100;</span> Admin Users</a>
                <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>Interview Management</h1>
            </header>
            
            <?php showFlashMessage(); ?>
            
            
            <div class="content-card">
                <div class="card-header">
                    <h3>Schedule New Interview</h3>
                </div>
                <form method="POST" action="" style="padding: 20px;">
                    <input type="hidden" name="action" value="schedule">
                    <div class="form-row">
                        <div class="form-group">
                            <label>Select Applicant <span class="required">*</span></label>
                            <select name="application_number" required>
                                <option value="">Select Applicant</option>
                                <?php foreach ($eligible_applicants as $app): ?>
                                <option value="<?php echo $app['application_number']; ?>">
                                    <?php echo $app['application_number'] . ' - ' . $app['title'] . ' ' . $app['first_name'] . ' ' . $app['last_name'] . ' (' . $app['preferred_course'] . ')'; ?>
                                </option>
                                <?php endforeach; ?>
                            </select>
                        </div>
                        <div class="form-group">
                            <label>Interview Date & Time <span class="required">*</span></label>
                            <input type="datetime-local" name="interview_date" required>
                        </div>
                        <div class="form-group">
                            <label>Venue <span class="required">*</span></label>
                            <input type="text" name="interview_venue" placeholder="e.g., IHM Aurangabad Campus" required>
                        </div>
                    </div>
                    <div class="form-row">
                        <div class="form-group full-width">
                            <label>Notes/Instructions</label>
                            <textarea name="notes" rows="3" placeholder="Any special instructions for the candidate..."></textarea>
                        </div>
                    </div>
                    <button type="submit" class="btn btn-success">Schedule Interview</button>
                </form>
            </div>
            
            
            <div class="content-card">
                <div class="card-header">
                    <h3>Scheduled Interviews</h3>
                </div>
                <div class="table-responsive">
                    <table class="data-table">
                        <thead>
                            <tr>
                                <th>App. No.</th>
                                <th>Name</th>
                                <th>Course</th>
                                <th>Date & Time</th>
                                <th>Venue</th>
                                <th>Status</th>
                                <th>Score</th>
                                <th>Actions</th>
                            </tr>
                        </thead>
                        <tbody>
                            <?php foreach ($interviews as $interview): ?>
                            <tr>
                                <td><?php echo htmlspecialchars($interview['application_number']); ?></td>
                                <td><?php echo htmlspecialchars($interview['title'] . ' ' . $interview['first_name'] . ' ' . $interview['last_name']); ?></td>
                                <td><?php echo htmlspecialchars($interview['preferred_course']); ?></td>
                                <td><?php echo formatDateTime($interview['interview_date']); ?></td>
                                <td><?php echo htmlspecialchars($interview['interview_venue']); ?></td>
                                <td><span class="status-badge status-<?php echo $interview['status']; ?>"><?php echo ucfirst($interview['status']); ?></span></td>
                                <td><?php echo $interview['score'] ? $interview['score'] : '-'; ?></td>
                                <td>
                                    <button class="action-btn btn-primary" onclick="updateInterview(<?php echo $interview['id']; ?>)">Update</button>
                                </td>
                            </tr>
                            <?php endforeach; ?>
                            <?php if (empty($interviews)): ?>
                            <tr><td colspan="8" style="text-align: center;">No interviews scheduled yet</td></tr>
                            <?php endif; ?>
                        </tbody>
                    </table>
                </div>
            </div>
        </main>
    </div>
    
    
    <div id="updateModal" class="modal">
        <div class="modal-content">
            <div class="modal-header">
                <h3>Update Interview Status</h3>
                <button class="close-modal" onclick="closeModal('updateModal')">&times;</button>
            </div>
            <form method="POST" action="">
                <input type="hidden" name="action" value="update_status">
                <input type="hidden" name="interview_id" id="update_interview_id">
                <div class="modal-body">
                    <div class="form-group">
                        <label>Status</label>
                        <select name="status" required>
                            <option value="scheduled">Scheduled</option>
                            <option value="completed">Completed</option>
                            <option value="cancelled">Cancelled</option>
                            <option value="no_show">No Show</option>
                        </select>
                    </div>
                    <div class="form-group">
                        <label>Score (out of 100)</label>
                        <input type="number" name="score" min="0" max="100" step="0.01">
                    </div>
                    <div class="form-group">
                        <label>Feedback</label>
                        <textarea name="feedback" rows="4"></textarea>
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn" onclick="closeModal('updateModal')">Cancel</button>
                    <button type="submit" class="btn btn-success">Update</button>
                </div>
            </form>
        </div>
    </div>
    
    <script>
        function updateInterview(id) {
            document.getElementById('update_interview_id').value = id;
            document.getElementById('updateModal').classList.add('active');
        }
        
        function closeModal(modalId) {
            document.getElementById(modalId).classList.remove('active');
        }
        
        window.onclick = function(event) {
            if (event.target.classList.contains('modal')) {
                event.target.classList.remove('active');
            }
        }
    </script>
</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: interviews.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation