Region 38 Jobboerse fuer lokale Betriebe

Finde deinen Traumjob in der Region

Entdecke offene Stellen von regionalen Firmen aus Gifhorn, Wolfsburg, Braunschweig, Peine, Salzgitter und Helmstedt.

Jobs in Gifhorn Jobs in Wolfsburg Jobs in Braunschweig Jobs in Peine Jobs in Salzgitter Jobs in Helmstedt
Direktbewerbung ohne Umwege Lokale Arbeitgeber aus der Region Ausbildung, Vollzeit und Teilzeit

0 Jobs gefunden

Regionale Stellenangebote mit direkter Bewerbung bei Betrieben aus Gifhorn, Wolfsburg, Braunschweig, Peine, Salzgitter, Helmstedt und Umgebung.

Filter zuruecksetzen
?

Keine passenden Jobs gefunden

Aendere den Ort, entferne einen Filter oder starte mit einer beliebten Suche in der Region 38.

Gifhorn Wolfsburg Braunschweig Ausbildung Alle Filter loeschen
$pdo = new PDO( "mysql:host={$config['db']['host']};dbname={$config['db']['name']};charset={$config['db']['charset']}", $config['db']['user'], $config['db']['pass'], [PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION] ); } catch (PDOException $e) { die("Datenbankfehler: " . $e->getMessage()); } $MAIN_DOMAIN = "https://www.machmal38.de"; $JOB_DOMAIN = "https://job.machmal38.de"; $baseUrl = $MAIN_DOMAIN; $jobsPublicationSql = PackagePublicationAccess::jobsSql('c', 'sp'); function h($value) { return htmlspecialchars((string) $value, ENT_QUOTES, 'UTF-8'); } function job_portal_url(array $params = []): string { $clean = []; foreach ($params as $key => $value) { if ($value !== '' && $value !== null && $value !== 0 && $value !== '0') { $clean[$key] = $value; } } return '/index.php' . ($clean ? '?' . http_build_query($clean) : ''); } function job_detail_url($slug) { return '/job_detail.php?slug=' . rawurlencode($slug); } // Filters $typeFilter = $_GET['type'] ?? ''; $regionFilter = $_GET['region'] ?? ''; $searchQuery = trim($_GET['q'] ?? ''); $categoryFilter = (int)($_GET['category'] ?? 0); $companyFilter = trim($_GET['company'] ?? ''); // Build SQL $whereParams = []; $whereSql = ["j.status = 'active'", $jobsPublicationSql]; if ($typeFilter) { $whereSql[] = "j.job_type = ?"; $whereParams[] = $typeFilter; } if ($regionFilter) { $whereSql[] = "j.location_city = ?"; $whereParams[] = $regionFilter; } if ($searchQuery) { $whereSql[] = "(j.title LIKE ? OR j.description LIKE ?)"; $whereParams[] = "%{$searchQuery}%"; $whereParams[] = "%{$searchQuery}%"; } if ($categoryFilter > 0) { $whereSql[] = "j.category_id = ?"; $whereParams[] = $categoryFilter; } if ($companyFilter !== '') { $whereSql[] = "c.slug = ?"; $whereParams[] = $companyFilter; } $whereClause = implode(' AND ', $whereSql); // Fetch Jobs $stmt = $pdo->prepare(" SELECT j.*, c.name as company_name, c.logo, cat.name as category_name FROM job_postings j JOIN companies c ON c.id = j.company_id JOIN site_packages sp ON sp.id = c.package_id LEFT JOIN categories cat ON cat.id = j.category_id WHERE {$whereClause} ORDER BY j.published_at DESC "); $stmt->execute($whereParams); $jobs = $stmt->fetchAll(PDO::FETCH_ASSOC); // Fetch Categories for Sidebar $stmtCat = $pdo->query(" SELECT cat.id, cat.name, COUNT(j.id) as count FROM categories cat JOIN job_postings j ON j.category_id = cat.id JOIN companies c ON c.id = j.company_id JOIN site_packages sp ON sp.id = c.package_id WHERE j.status = 'active' AND $jobsPublicationSql GROUP BY cat.id ORDER BY count DESC "); $categories = $stmtCat->fetchAll(PDO::FETCH_ASSOC); $selectedCategory = null; foreach ($categories as $cat) { if ((int) $cat['id'] === $categoryFilter) { $selectedCategory = $cat; break; } } $filterParts = []; if ($searchQuery !== '') { $filterParts[] = $searchQuery; } if ($typeFilter !== '') { $filterParts[] = $typeFilter; } if ($selectedCategory) { $filterParts[] = (string) $selectedCategory['name']; } if ($companyFilter !== '' && !empty($jobs[0]['company_name'])) { $filterParts[] = (string) $jobs[0]['company_name']; } if ($regionFilter !== '') { $filterParts[] = $regionFilter; } $pageTitle = $filterParts ? 'Jobs fuer ' . implode(' in ', $filterParts) . ' | MachMal Job' : 'Jobs in Gifhorn, Wolfsburg, Braunschweig, Peine, Salzgitter, Helmstedt | MachMal Job'; $metaDescription = $filterParts ? 'Aktuelle Stellenangebote fuer ' . implode(', ', $filterParts) . ' in der Region 38 finden. Direkt bei geprueften Betrieben bewerben.' : 'Aktuelle Jobs, Ausbildungsplaetze und Stellenangebote in Gifhorn, Wolfsburg, Braunschweig, Peine, Salzgitter, Helmstedt und der Region 38 finden.'; $canonicalParams = []; if ($typeFilter !== '') { $canonicalParams['type'] = $typeFilter; } if ($regionFilter !== '') { $canonicalParams['region'] = $regionFilter; } if ($searchQuery !== '') { $canonicalParams['q'] = $searchQuery; } if ($categoryFilter > 0) { $canonicalParams['category'] = $categoryFilter; } if ($companyFilter !== '') { $canonicalParams['company'] = $companyFilter; } $canonicalUrl = $JOB_DOMAIN . '/' . ($canonicalParams ? '?' . http_build_query($canonicalParams) : ''); $itemList = []; foreach (array_slice($jobs, 0, 20) as $index => $jobItem) { $itemList[] = [ '@type' => 'ListItem', 'position' => $index + 1, 'url' => $JOB_DOMAIN . '/' . job_detail_url((string) $jobItem['slug']), 'name' => (string) $jobItem['title'], ]; } $websiteSchema = [ '@context' => 'https://schema.org', '@type' => 'WebSite', 'name' => 'MachMal Job', 'url' => $JOB_DOMAIN . '/', 'potentialAction' => [ '@type' => 'SearchAction', 'target' => $JOB_DOMAIN . '/?q={search_term_string}', 'query-input' => 'required name=search_term_string', ], ]; $listSchema = [ '@context' => 'https://schema.org', '@type' => 'ItemList', 'name' => 'Stellenangebote in der Region 38', 'description' => $metaDescription, 'numberOfItems' => count($jobs), 'itemListElement' => $itemList, ]; ?> Jobs fuer Freelancer in Gifhorn | MachMal Job
Region 38 Jobboerse fuer lokale Betriebe

Finde deinen Traumjob in der Region

Entdecke offene Stellen von regionalen Firmen aus Gifhorn, Wolfsburg, Braunschweig, Peine, Salzgitter und Helmstedt.

Jobs in Gifhorn Jobs in Wolfsburg Jobs in Braunschweig Jobs in Peine Jobs in Salzgitter Jobs in Helmstedt
Direktbewerbung ohne Umwege Lokale Arbeitgeber aus der Region Ausbildung, Vollzeit und Teilzeit

0 Jobs gefunden

Regionale Stellenangebote mit direkter Bewerbung bei Betrieben aus Gifhorn, Wolfsburg, Braunschweig, Peine, Salzgitter, Helmstedt und Umgebung.

Filter zuruecksetzen
?

Keine passenden Jobs gefunden

Aendere den Ort, entferne einen Filter oder starte mit einer beliebten Suche in der Region 38.

Gifhorn Wolfsburg Braunschweig Ausbildung Alle Filter loeschen