🤩 File Manager - Mr.X
PHP:
8.3.33
Server:
Apache
OS:
Linux 5.14.0-611.49.1.el9_7.x86_64
User:
websparkit
Navigate
Upload:
Upload
New File
New Folder
Editing:manage-candidates.php
<?php require_once '../includes/db.php'; require_once '../includes/auth.php'; checkAdmin(); if (isset($_GET['action']) && isset($_GET['id'])) { $action = $_GET['action']; $can_id = $_GET['id']; if ($action == 'approve_cv') { query("UPDATE candidates SET cv_status = 'approved' WHERE id = ?", [$can_id]); } elseif ($action == 'reject_cv') { query("UPDATE candidates SET cv_status = 'rejected' WHERE id = ?", [$can_id]); } elseif ($action == 'delete') { $candidate = fetchOne("SELECT cv_path FROM candidates WHERE id = ?", [$can_id]); if ($candidate && $candidate['cv_path'] && file_exists("../uploads/cvs/" . $candidate['cv_path'])) { unlink("../uploads/cvs/" . $candidate['cv_path']); } query("DELETE FROM candidates WHERE id = ?", [$can_id]); } header("Location: manage-candidates.php"); exit; } $candidates = fetchAll("SELECT * FROM candidates ORDER BY created_at DESC"); $page_title = "Manage Candidates"; ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title><?php echo $page_title; ?> | Admin</title> <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css" rel="stylesheet"> <link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap-icons@1.10.0/font/bootstrap-icons.css"> <link rel="stylesheet" href="../assets/css/style.css"> </head> <body class="bg-light"> <nav class="navbar navbar-expand-lg dashboard-nav sticky-top shadow-sm"> <div class="container-fluid px-4"> <a class="navbar-brand fw-bold" href="dashboard.php">jobly.lk Admin</a> <div class="ms-auto"> <a href="../logout.php" class="btn btn-sm btn-outline-light">Logout</a> </div> </div> </nav> <div class="container-fluid py-4 px-4"> <h2 class="fw-bold mb-4">Manage Candidates</h2> <div class="card border-0 shadow-sm"> <div class="card-body p-0"> <div class="table-responsive"> <table class="table table-hover align-middle mb-0"> <thead class="bg-light"> <tr> <th class="ps-4">Name</th> <th>Email</th> <th>Contact</th> <th>CV Status</th> <th>CV File</th> <th>Registered</th> <th class="text-end pe-4">Actions</th> </tr> </thead> <tbody> <?php foreach($candidates as $can): ?> <tr> <td class="ps-4"> <div class="fw-bold"><?php echo htmlspecialchars($can['full_name']); ?></div> </td> <td><?php echo htmlspecialchars($can['email']); ?></td> <td><?php echo htmlspecialchars($can['contact_no'] ?: '-'); ?></td> <td> <?php if ($can['cv_status'] == 'approved'): ?> <span class="badge bg-success">Approved</span> <?php elseif ($can['cv_status'] == 'rejected'): ?> <span class="badge bg-danger">Rejected</span> <?php elseif ($can['cv_status'] == 'pending'): ?> <span class="badge bg-warning text-dark">Pending</span> <?php else: ?> <span class="badge bg-secondary">None</span> <?php endif; ?> </td> <td> <?php if ($can['cv_path']): ?> <a href="../uploads/cvs/<?php echo $can['cv_path']; ?>" class="btn btn-sm btn-outline-primary" download><i class="bi bi-download"></i> Download</a> <?php else: ?> <span class="text-muted">-</span> <?php endif; ?> </td> <td><?php echo date('M d, Y', strtotime($can['created_at'])); ?></td> <td class="text-end pe-4"> <?php if ($can['cv_status'] == 'pending'): ?> <a href="?action=approve_cv&id=<?php echo $can['id']; ?>" class="btn btn-sm btn-success">Approve CV</a> <a href="?action=reject_cv&id=<?php echo $can['id']; ?>" class="btn btn-sm btn-danger" onclick="return confirm('Reject this CV?')">Reject CV</a> <?php elseif ($can['cv_status'] == 'approved'): ?> <a href="?action=reject_cv&id=<?php echo $can['id']; ?>" class="btn btn-sm btn-outline-danger">Reject CV</a> <?php elseif ($can['cv_status'] == 'rejected'): ?> <a href="?action=approve_cv&id=<?php echo $can['id']; ?>" class="btn btn-sm btn-outline-success">Approve CV</a> <?php endif; ?> <a href="?action=delete&id=<?php echo $can['id']; ?>" class="btn btn-sm btn-outline-secondary" onclick="return confirm('Delete this candidate?')">Delete</a> </td> </tr> <?php endforeach; ?> <?php if (empty($candidates)): ?> <tr><td colspan="7" class="text-center py-4 text-muted">No candidates registered yet.</td></tr> <?php endif; ?> </tbody> </table> </div> </div> </div> </div> <script src="https://code.jquery.com/jquery-3.6.0.min.js"></script> <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/js/bootstrap.bundle.min.js"></script> </body> </html>
Save Changes
Cancel
Create New File
Create New Folder