🤩 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-jobs.php
<?php require_once '../includes/db.php'; require_once '../includes/auth.php'; checkAdmin(); $status = isset($_GET['status']) ? $_GET['status'] : ''; $where = ""; $params = []; if ($status) { $where = "WHERE j.status = ?"; $params[] = $status; } $jobs = fetchAll("SELECT j.*, e.company_name, c.name as category_name FROM jobs j LEFT JOIN employers e ON j.employer_id = e.id LEFT JOIN categories c ON j.category_id = c.id $where ORDER BY j.created_at DESC", $params); $page_title = "Manage Jobs"; ?> <!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="dashboard.php" class="btn btn-sm btn-outline-light me-2">Dashboard</a> <a href="../logout.php" class="btn btn-sm btn-light">Logout</a> </div> </div> </nav> <div class="container-fluid"> <div class="row"> <!-- Sidebar ... (truncated for brevity, using same sidebar as dashboard) --> <main class="col-md-12 px-md-4 py-4"> <div class="d-flex justify-content-between align-items-center mb-4"> <h2 class="mb-0">Manage All Jobs</h2> <div class="d-flex align-items-center gap-3"> <a href="post-job.php" class="btn btn-primary btn-sm"><i class="bi bi-plus-circle me-1"></i> Post New Job</a> <div class="btn-group"> <a href="manage-jobs.php" class="btn btn-outline-secondary btn-sm <?php echo !$status ? 'active' : ''; ?>">All</a> <a href="manage-jobs.php?status=active" class="btn btn-outline-secondary btn-sm <?php echo $status == 'active' ? 'active' : ''; ?>">Active</a> <a href="manage-jobs.php?status=pending" class="btn btn-outline-secondary btn-sm <?php echo $status == 'pending' ? 'active' : ''; ?>">Pending</a> </div> </div> </div> <?php if(isset($_SESSION['success'])): ?> <div class="alert alert-success"><?php echo $_SESSION['success']; unset($_SESSION['success']); ?></div> <?php endif; ?> <div class="card border-0 shadow-sm"> <div class="card-body"> <div class="table-responsive"> <table class="table table-hover align-middle"> <thead class="bg-light"> <tr> <th>Job Title</th> <th>Company</th> <th>Category</th> <th>Status</th> <th>Date</th> <th>Actions</th> </tr> </thead> <tbody> <?php foreach($jobs as $job): ?> <tr> <td><span class="fw-bold"><?php echo $job['title']; ?></span></td> <td><?php echo $job['company_name']; ?></td> <td><?php echo $job['category_name']; ?></td> <td> <?php $s_class = [ 'active' => 'bg-success', 'pending' => 'bg-warning text-dark', 'rejected' => 'bg-danger', 'expired' => 'bg-secondary' ][$job['status']]; ?> <span class="badge <?php echo $s_class; ?>"><?php echo ucfirst($job['status']); ?></span> </td> <td><?php echo date('M d, Y', strtotime($job['created_at'])); ?></td> <td> <?php if($job['status'] == 'pending'): ?> <a href="approve-job.php?id=<?php echo $job['id']; ?>" class="btn btn-sm btn-success">Approve</a> <?php endif; ?> <a href="delete-job.php?id=<?php echo $job['id']; ?>" class="btn btn-sm btn-outline-danger" onclick="return confirm('Delete this job?')"><i class="bi bi-trash"></i></a> </td> </tr> <?php endforeach; ?> </tbody> </table> </div> </div> </div> </main> </div> </div> </body> </html>
Save Changes
Cancel
Create New File
Create New Folder