Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-503.34.1.el9_5.x86_64

PHP Version:

8.2.30

User:

u329947844

Directory:

/home/u329947844/domains/pennagaram.org/public_html/admin

Free Space:

10.27 TB

🔧 Quick Actions

✏️ Editing: manage-jobs.php

<!doctype html>
<html lang="en">
<?php
include('includes/head.php');
include('includes/db.php');

// Handle form submissions
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    if (isset($_POST['action'])) {
        if ($_POST['action'] === 'delete_job') {
            $jobId = (int)$_POST['job_id'];
           
            // Get image path before deletion
            $getJobSql = "SELECT image_path FROM jobs WHERE id = ?";
            $stmt = mysqli_prepare($conn, $getJobSql);
            mysqli_stmt_bind_param($stmt, 'i', $jobId);
            mysqli_stmt_execute($stmt);
            mysqli_stmt_bind_result($stmt, $imagePath);
            mysqli_stmt_fetch($stmt);
            mysqli_stmt_close($stmt);
           
            // Delete image file if it exists
            if (!empty($imagePath)) {
                // Try multiple possible locations
                $possiblePaths = [
                    $imagePath,
                    '../' . $imagePath,
                    '../../' . $imagePath
                ];
                
                foreach ($possiblePaths as $path) {
                    if (file_exists($path)) {
                        unlink($path);
                        break;
                    }
                }
            }
           
            // Delete job from database
            $deleteSql = "DELETE FROM jobs WHERE id = ?";
            $stmt = mysqli_prepare($conn, $deleteSql);
            mysqli_stmt_bind_param($stmt, 'i', $jobId);
            mysqli_stmt_execute($stmt);
            mysqli_stmt_close($stmt);
           
            $successMsg = "Job deleted successfully!";
        }
    }
}

// Fetch jobs with image_path
$jobsSql = "SELECT id, poster, image_path, title, contact, expiry_date, created_at FROM jobs ORDER BY created_at DESC";
$jobsResult = mysqli_query($conn, $jobsSql);
$jobs = [];
if ($jobsResult && mysqli_num_rows($jobsResult) > 0) {
    while ($row = mysqli_fetch_assoc($jobsResult)) {
        $jobs[] = $row;
    }
}

// Count statistics
$totalJobs = count($jobs);

// Count active jobs (not expired)
$activeJobsQuery = "SELECT COUNT(*) as active_count FROM jobs WHERE expiry_date >= CURDATE()";
$activeResult = mysqli_query($conn, $activeJobsQuery);
$activeJobs = mysqli_fetch_assoc($activeResult)['active_count'];

// Count expired jobs
$expiredJobsQuery = "SELECT COUNT(*) as expired_count FROM jobs WHERE expiry_date < CURDATE()";
$expiredResult = mysqli_query($conn, $expiredJobsQuery);
$expiredJobs = mysqli_fetch_assoc($expiredResult)['expired_count'];
?>
<body data-sidebar="dark">

<div id="layout-wrapper">
<?php include('includes/topbar.php')?>
    
    <div class="vertical-menu">
        <div data-simplebar class="h-100">
            
            <?php include('includes/sidebar.php')?>
            
        </div>
    </div>
    
    
    
    
    <div class="main-content">
        <div class="page-content">
          
            <div class="container-fluid">
                
                <div class="row">
                    <div class="col-12">
                        <div class="page-title-box d-flex align-items-center justify-content-between">
                            <h4 class="mb-0">Manage Jobs</h4>
                            <a href="post-job.php" class="btn btn-primary">
                                <i class="fas fa-plus me-2"></i>Post New Job
                            </a>
                        </div>
                    </div>
                </div>
                <?php if (isset($successMsg)): ?>
                    <div class="alert alert-success alert-dismissible fade show" role="alert">
                        <i class="fas fa-check-circle me-2"></i>
                        <?php echo $successMsg; ?>
                        <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                    </div>
                <?php endif; ?>
                <?php if (isset($errorMsg)): ?>
                    <div class="alert alert-danger alert-dismissible fade show" role="alert">
                        <i class="fas fa-exclamation-triangle me-2"></i>
                        <?php echo $errorMsg; ?>
                        <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                    </div>
                <?php endif; ?>
                
                <div class="row">
                    <div class="col-md-3 col-sm-6">
                        <div class="card text-center">
                            <div class="card-body">
                                <h3 class="text-primary mt-2"><?php echo $totalJobs; ?></h3>
                                <p class="text-muted mb-0">Total Jobs</p>
                            </div>
                        </div>
                    </div>
                    <div class="col-md-3 col-sm-6">
                        <div class="card text-center">
                            <div class="card-body">
                                <h3 class="text-success mt-2"><?php echo $activeJobs; ?></h3>
                                <p class="text-muted mb-0">Active Jobs</p>
                            </div>
                        </div>
                    </div>
                    <div class="col-md-3 col-sm-6">
                        <div class="card text-center">
                            <div class="card-body">
                                <h3 class="text-warning mt-2"><?php echo $expiredJobs; ?></h3>
                                <p class="text-muted mb-0">Expired Jobs</p>
                            </div>
                        </div>
                    </div>
                    <div class="col-md-3 col-sm-6">
                        <div class="card text-center">
                            <div class="card-body">
                                <h3 class="text-info mt-2"><?php echo date('M Y'); ?></h3>
                                <p class="text-muted mb-0">Current Month</p>
                            </div>
                        </div>
                    </div>
                </div>
                
                
                <div class="row">
                    <div class="col-12">
                        <div class="card">
                            <div class="card-body">
                                <h4 class="card-title mb-4">Jobs List</h4>
                                <?php if (empty($jobs)): ?>
                                    <div class="text-center py-5">
                                        <i class="fas fa-briefcase fa-3x text-muted mb-3"></i>
                                        <h5>No Jobs Posted Yet</h5>
                                        <p class="text-muted">Start by posting your first job opportunity.</p>
                                        <a href="post-job.php" class="btn btn-primary mt-2">
                                            <i class="fas fa-plus me-2"></i>Post First Job
                                        </a>
                                    </div>
                                <?php else: ?>
                                    <div class="row">
                                        <?php foreach ($jobs as $job): 
                                            // Determine image source with proper path resolution
                                            $imageSrc = '';
                                            if (!empty($job['image_path'])) {
                                                // Try multiple possible locations for the image
                                                $possiblePaths = [
                                                    $job['image_path'],          // Direct path from database
                                                    '../' . $job['image_path'],  // One level up
                                                    '../../' . $job['image_path'] // Two levels up
                                                ];
                                                
                                                foreach ($possiblePaths as $path) {
                                                    if (file_exists($path)) {
                                                        $imageSrc = $path;
                                                        break;
                                                    }
                                                }
                                                
                                                // If no file found, use the path from database anyway (might be accessible via URL)
                                                if (empty($imageSrc)) {
                                                    $imageSrc = $job['image_path'];
                                                }
                                            }
                                            
                                            // Check if job is expired
                                            $isExpired = strtotime($job['expiry_date']) < time();
                                            $isExpiringSoon = !$isExpired && (strtotime($job['expiry_date']) - time()) < (3 * 24 * 60 * 60);
                                        ?>
                                            <div class="col-xl-4 col-md-6 mb-4">
                                                <div class="card job-card <?php echo $isExpired ? 'border-danger' : ($isExpiringSoon ? 'border-warning' : ''); ?>">
                                                    <div class="job-image-container">
                                                        <img src="<?php echo !empty($imageSrc) ? htmlspecialchars($imageSrc) : 'https://via.placeholder.com/300x200/2E8B57/FFFFFF?text=Job+Poster'; ?>"
                                                             class="card-img-top job-img"
                                                             alt="<?php echo htmlspecialchars($job['title']); ?>"
                                                             onerror="this.src='https://via.placeholder.com/300x200/6c757d/FFFFFF?text=Image+Not+Found'">
                                                        <div class="job-overlay">
                                                            <div class="job-actions">
                                                                <a href="edit-job.php?id=<?php echo $job['id']; ?>" class="btn btn-primary btn-sm" title="Edit Job">
                                                                    <i class="fas fa-edit"></i>
                                                                </a>
                                                                <form method="post" class="d-inline" onsubmit="return confirm('Are you sure you want to delete this job? This action cannot be undone.')">
                                                                    <input type="hidden" name="action" value="delete_job">
                                                                    <input type="hidden" name="job_id" value="<?php echo $job['id']; ?>">
                                                                    <button type="submit" class="btn btn-danger btn-sm" title="Delete Job">
                                                                        <i class="fas fa-trash"></i>
                                                                    </button>
                                                                </form>
                                                            </div>
                                                        </div>
                                                        <?php if ($isExpired): ?>
                                                            <div class="position-absolute top-0 start-0 m-2">
                                                                <span class="badge bg-danger">Expired</span>
                                                            </div>
                                                        <?php elseif ($isExpiringSoon): ?>
                                                            <div class="position-absolute top-0 start-0 m-2">
                                                                <span class="badge bg-warning text-dark">Expiring Soon</span>
                                                            </div>
                                                        <?php endif; ?>
                                                    </div>
                                                    <div class="card-body">
                                                        <h6 class="card-title text-truncate" title="<?php echo htmlspecialchars($job['title']); ?>">
                                                            <?php echo htmlspecialchars($job['title']); ?>
                                                        </h6>
                                                        <p class="card-text small text-muted mb-1">
                                                            <i class="fas fa-building me-1"></i> 
                                                            <?php echo htmlspecialchars($job['poster']); ?>
                                                        </p>
                                                        <p class="card-text small text-muted mb-1">
                                                            <i class="fas fa-phone me-1"></i> 
                                                            <?php echo htmlspecialchars($job['contact']); ?>
                                                        </p>
                                                        <p class="card-text small mb-1 <?php echo $isExpired ? 'text-danger' : ($isExpiringSoon ? 'text-warning' : 'text-muted'); ?>">
                                                            <i class="fas fa-clock me-1"></i> 
                                                            Expiry: <?php echo date('M j, Y', strtotime($job['expiry_date'])); ?>
                                                        </p>
                                                        <p class="card-text small text-muted">
                                                            <i class="fas fa-calendar me-1"></i> 
                                                            Added: <?php echo date('M j, Y', strtotime($job['created_at'])); ?>
                                                        </p>
                                                    </div>
                                                </div>
                                            </div>
                                        <?php endforeach; ?>
                                    </div>
                                <?php endif; ?>
                            </div>
                        </div>
                    </div>
                </div>
                
            </div>
            
        </div>
        
        <?php include('includes/footer.php')?>
    </div>
    
</div>


<?php include('includes/rightbar.php')?>


<?php include('includes/scripts.php')?>
<style>
.job-card {
    transition: transform 0.2s ease-in-out, box-shadow 0.2s ease-in-out;
    border: 1px solid #e9ecef;
    height: 100%;
}
.job-card:hover {
    transform: translateY(-5px);
    box-shadow: 0 4px 15px rgba(0,0,0,0.1);
}
.job-image-container {
    position: relative;
    overflow: hidden;
    height: 200px;
}
.job-img {
    height: 100%;
    width: 100%;
    object-fit: cover;
    transition: transform 0.3s ease;
}
.job-overlay {
    position: absolute;
    top: 0;
    left: 0;
    right: 0;
    bottom: 0;
    background: rgba(0,0,0,0.7);
    display: flex;
    align-items: center;
    justify-content: center;
    opacity: 0;
    transition: opacity 0.3s ease;
}
.job-image-container:hover .job-overlay {
    opacity: 1;
}
.job-image-container:hover .job-img {
    transform: scale(1.05);
}
.job-actions {
    display: flex;
    gap: 10px;
}
.job-actions .btn {
    border-radius: 50%;
    width: 40px;
    height: 40px;
    display: flex;
    align-items: center;
    justify-content: center;
    transition: transform 0.2s ease;
}
.job-actions .btn:hover {
    transform: scale(1.1);
}
.card-title {
    font-size: 0.9rem;
    font-weight: 600;
    margin-bottom: 0.5rem;
}
.card-body {
    padding: 1rem;
}
.badge {
    font-size: 0.7rem;
    padding: 0.25rem 0.5rem;
}
.text-truncate {
    overflow: hidden;
    text-overflow: ellipsis;
    white-space: nowrap;
}
</style>
</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: manage-jobs.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation