prepare($countSql); $countStmt->execute($params); $totalJobs = $countStmt->fetchColumn(); $perPage = 12; $page = max(1, (int)($_GET['page'] ?? 1)); $totalPages = max(1, ceil($totalJobs / $perPage)); $page = min($page, $totalPages); $offset = ($page - 1) * $perPage; $sql = "SELECT jobs.*, factories.factory_name, factories.status AS factory_status, factories.premium_status, (SELECT COUNT(*) FROM jobs j2 WHERE j2.factory_id = factories.id AND j2.status = 'open') AS factory_open_jobs, (SELECT AVG(rating) FROM factory_reviews WHERE factory_reviews.factory_id = factories.id) AS avg_rating, (SELECT COUNT(*) FROM factory_reviews WHERE factory_reviews.factory_id = factories.id) AS review_count"; $distanceParams = []; if ($nearMe) { $sql .= ", (6371 * ACOS( COS(RADIANS(?)) * COS(RADIANS(factories.latitude)) * COS(RADIANS(factories.longitude) - RADIANS(?)) + SIN(RADIANS(?)) * SIN(RADIANS(factories.latitude)) )) AS distance_km"; $distanceParams = [$userLat, $userLng, $userLat]; } $sql .= " FROM jobs JOIN factories ON jobs.factory_id = factories.id $where"; if ($nearMe) { $sql .= " ORDER BY (factories.latitude IS NULL) ASC, distance_km ASC"; } else { $sql .= " ORDER BY jobs.is_featured DESC, jobs.created_at DESC"; } $sql .= " LIMIT $perPage OFFSET $offset"; $stmt = $pdo->prepare($sql); $stmt->execute(array_merge($distanceParams, $params)); $jobs = $stmt->fetchAll(); $savedJobIds = []; if (isEmployeeLoggedIn()) { $s = $pdo->prepare("SELECT job_id FROM saved_jobs WHERE employee_id = ?"); $s->execute([$_SESSION['employee_id']]); $savedJobIds = array_column($s->fetchAll(), 'job_id'); } // quick-filter chips: most common areas among open jobs $areaChips = $pdo->query("SELECT area, COUNT(*) AS cnt FROM jobs WHERE status = 'open' AND area IS NOT NULL AND area != '' GROUP BY area ORDER BY cnt DESC LIMIT 8")->fetchAll(); $showDashChrome = isEmployeeLoggedIn(); $isDashboardPage = $showDashChrome; require_once __DIR__ . '/../includes/header.php'; ?>

Browse Jobs

Find factory jobs near your area

Clear location filter
0): ?>
()

job(s) found 1 ? " — page $page of $totalPages" : ""; ?>

No jobs match your search. Try different keywords.

0): ?>
🏭 📍 km away 📍 🕐 Shift 👥 openings
View
1): ?>