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

2 Jobs gefunden

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

Filter zuruecksetzen

Versicherungsprofi (m/w/d) für den Vertrieb

ERGO Versicherungsagentur Sascha Leiste-Röhrig

Standort: Wolfsburg Art: Vollzeit Erfahrung: Mit Berufserfahrung Kategorie: Finanzen & Versicherung

Quereinsteiger (m/w/d) für den Versicherungsvertrieb

ERGO Versicherungsagentur Sascha Leiste-Röhrig

Standort: Wolfsburg Art: Vollzeit Erfahrung: Ohne Berufserfahrung Kategorie: Finanzen & Versicherung

$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 Wolfsburg | MachMal Job