prepare("SELECT * FROM vessels WHERE id = ?");
$stmt->execute([$vesselId]);
$vessel = $stmt->fetch(PDO::FETCH_ASSOC);
if (!$vessel) {
throw new RuntimeException('Vessel nicht gefunden.');
}
if (empty($vessel['vessel_key'])) {
throw new RuntimeException('Kein vessel_key vorhanden.');
}
$baseDir = __DIR__ . '/../../public/generated_sites/' . $vessel['vessel_key'];
$assetDir = $baseDir . '/assets';
self::ensureDirectory($assetDir);
file_put_contents($assetDir . '/site.css', self::renderCss());
foreach (self::LANGUAGES as $lang) {
$langDir = $baseDir . '/' . $lang;
self::ensureDirectory($langDir);
file_put_contents(
$langDir . '/index.html',
self::renderIndex($vessel, $lang)
);
file_put_contents(
$langDir . '/ship.html',
self::renderShip($vessel, $lang)
);
file_put_contents(
$langDir . '/journey.html',
self::renderJourney($vessel, $lang)
);
file_put_contents(
$langDir . '/gallery.html',
self::renderGallery($vessel, $lang)
);
file_put_contents(
$langDir . '/contact.html',
self::renderContact($vessel, $lang)
);
}
}
private static function ensureDirectory(string $dir): void
{
if (!is_dir($dir)) {
if (!mkdir($dir, 0775, true) && !is_dir($dir)) {
throw new RuntimeException('Verzeichnis konnte nicht erstellt werden: ' . $dir);
}
}
}
private static function h($value): string
{
return htmlspecialchars((string)$value, ENT_QUOTES, 'UTF-8');
}
private static function localized(array $v, string $baseField, string $lang): string
{
$lang = strtolower(trim($lang));
$field = $baseField . '_' . $lang;
$value = trim((string)($v[$field] ?? ''));
if ($value !== '') {
return $value;
}
return trim((string)($v[$baseField . '_de'] ?? ''));
}
private static function nl($value): string
{
return nl2br(self::h($value));
}
private static function value(array $v, string $key, string $fallback = '—'): string
{
$value = trim((string)($v[$key] ?? ''));
return $value !== '' ? self::h($value) : self::h($fallback);
}
private static function pageTitle(array $v, string $fallback = ''): string
{
$title = trim((string)($v['website_title_de'] ?? ''));
if ($title !== '') {
return self::h($title);
}
$name = trim((string)($v['vessel_name'] ?? ''));
if ($name !== '') {
return self::h($name);
}
return self::h($fallback !== '' ? $fallback : 'Yachtmemory Schiff');
}
private static function normalizeUrl(string $url): string
{
$url = trim($url);
if ($url === '') {
return '';
}
if (!preg_match('#^https?://#i', $url)) {
$url = 'https://' . $url;
}
return $url;
}
private static function layout(
string $title,
string $content,
array $v,
string $lang,
string $page
): string
{
$safeTitle = self::h($title);
$siteTitle = self::pageTitle($v);
$nav = self::renderNav($lang);
$langNav = self::renderLanguageNav($lang, $page);
$cssVersion = time();
return <<
{$safeTitle}
{$content}
HTML;
}
private static function renderNav(string $lang): string
{
$labels = [
'de' => [
'home' => 'Start',
'ship' => 'Schiff & Technik',
'journey' => 'Reise',
'gallery' => 'Galerie',
'contact' => 'Kontakt',
],
'en' => [
'home' => 'Home',
'ship' => 'Vessel & Technology',
'journey' => 'Journey',
'gallery' => 'Gallery',
'contact' => 'Contact',
],
'it' => [
'home' => 'Home',
'ship' => 'Barca & Tecnica',
'journey' => 'Viaggio',
'gallery' => 'Galleria',
'contact' => 'Contatto',
],
'fr' => [
'home' => 'Accueil',
'ship' => 'Navire & Technique',
'journey' => 'Voyage',
'gallery' => 'Galerie',
'contact' => 'Contact',
],
];
$l = $labels[$lang] ?? $labels['de'];
return <<
{$l['home']}
{$l['ship']}
{$l['journey']}
{$l['gallery']}
{$l['contact']}
HTML;
}
private static function renderLanguageNav(string $currentLang, string $page): string
{
$items = [];
foreach (self::LANGUAGES as $lang) {
$class = $lang === $currentLang
? 'class="active-language"'
: '';
$items[] =
''
. strtoupper($lang)
. '';
}
return '' . implode('', $items) . '
';
}
private static function getHeroImage(array $v): ?string
{
$db = platform_db();
if (!empty($v['website_hero_image_id'])) {
$stmt = $db->prepare("
SELECT filename
FROM vessel_website_images
WHERE id = ?
AND vessel_id = ?
AND is_active = 1
LIMIT 1
");
$stmt->execute([(int)$v['website_hero_image_id'], (int)$v['id']]);
} else {
$stmt = $db->prepare("
SELECT filename
FROM vessel_website_images
WHERE vessel_id = ?
AND is_active = 1
ORDER BY sort_order, id
LIMIT 1
");
$stmt->execute([(int)$v['id']]);
}
$row = $stmt->fetch(PDO::FETCH_ASSOC);
if (!$row || empty($row['filename'])) {
return null;
}
return '/uploads/vessels/'
. rawurlencode((string)$v['vessel_key'])
. '/website/web/'
. rawurlencode((string)$row['filename']);
}
private static function heroPosition(array $v): string
{
$heroPosition = trim((string)($v['website_hero_position'] ?? 'center center'));
$allowed = [
'center center',
'left center',
'right center',
'center top',
'center bottom',
'left top',
'right top',
'left bottom',
'right bottom',
];
return in_array($heroPosition, $allowed, true) ? $heroPosition : 'center center';
}
private static function renderIndex(array $v, string $lang): string
{
$titleRaw = self::localized($v, 'website_title', $lang);
if ($titleRaw === '') {
$titleRaw = (string)($v['vessel_name'] ?? 'Yachtmemory');
}
$title = self::h($titleRaw);
$introRaw = self::localized($v, 'website_intro', $lang);
$intro = self::nl($introRaw);
$texts = [
'de' => [
'welcome' => 'Willkommen',
'fallback_intro' => 'Willkommen auf der Webseite dieses Yachtmemory-Schiffs.',
'about_title' => 'Über dieses Schiff',
'about_text' => 'Diese Webseite stellt das Schiff, seine Technik und ausgewählte Reiseinformationen vor.',
'journey_button' => 'Live-Daten und Reise ansehen',
'blog_button' => 'Blog / Logbuch öffnen',
],
'en' => [
'welcome' => 'Welcome',
'fallback_intro' => 'Welcome to the website of this Yachtmemory vessel.',
'about_title' => 'About this vessel',
'about_text' => 'This website presents the vessel, its technology and selected journey information.',
'journey_button' => 'View live data and journey',
'blog_button' => 'Open blog / logbook',
],
'it' => [
'welcome' => 'Benvenuti',
'fallback_intro' => 'Benvenuti sul sito web di questa imbarcazione Yachtmemory.',
'about_title' => 'Informazioni sulla barca',
'about_text' => 'Questo sito presenta la barca, la sua tecnologia e informazioni selezionate sul viaggio.',
'journey_button' => 'Visualizza dati live e viaggio',
'blog_button' => 'Apri blog / diario',
],
'fr' => [
'welcome' => 'Bienvenue',
'fallback_intro' => 'Bienvenue sur le site web de ce navire Yachtmemory.',
'about_title' => 'À propos du navire',
'about_text' => 'Ce site présente le navire, sa technologie et certaines informations de voyage.',
'journey_button' => 'Voir les données live et le voyage',
'blog_button' => 'Ouvrir le blog / journal',
],
];
$t = $texts[$lang] ?? $texts['de'];
$vesselName = self::value($v, 'vessel_name');
$heroImage = self::getHeroImage($v);
$heroPosition = self::heroPosition($v);
$heroStyle = $heroImage
? ' style="background-image: linear-gradient(rgba(0,0,0,.38), rgba(0,0,0,.38)), url(' . self::h($heroImage) . '); background-position: ' . self::h($heroPosition) . ';"'
: '';
$blogUrl = self::normalizeUrl((string)($v['website_blog_url'] ?? ''));
$blogButton = $blogUrl !== ''
? 'Blog / Logbuch öffnen
'
: '';
$content = <<
{$title}
{$vesselName}
Willkommen
{$intro}
{$blogButton}
HTML;
return self::layout(strip_tags($title), $content, $v);
}
private static function renderShip(array $v): string
{
$vesselName = self::value($v, 'vessel_name');
$hullType = self::labelHullType($v['hull_type'] ?? '');
$category = self::labelVesselCategory($v['vessel_category'] ?? '');
$propulsion = self::labelPropulsion($v['propulsion_type'] ?? '');
$engineCount = self::value($v, 'engine_count');
$enginePower = self::value($v, 'engine_power_kw');
$battery = self::value($v, 'battery_capacity_kwh');
$solar = self::value($v, 'solar_power_kw');
$generator = self::value($v, 'generator_power_kw');
$homePort = self::value($v, 'website_home_port');
$yearBuilt = self::value($v, 'website_year_built');
$content = <<
Schiff & Technik
{$vesselName}
Schiffsdaten
Rumpfform{$hullType}
Schiffskategorie{$category}
Antrieb{$propulsion}
Heimathafen{$homePort}
Baujahr{$yearBuilt}
Antrieb & Energie
Anzahl Motoren{$engineCount}
Leistung je Maschine{$enginePower} kW
Batteriekapazität{$battery} kWh
Solarleistung{$solar} kW
Generatorleistung{$generator} kW
HTML;
return self::layout('Schiff & Technik', $content, $v);
}
private static function renderJourney(array $v): string
{
$vesselName = self::value($v, 'vessel_name');
$publicDashboardUrl =
'https://app.yachtmemory.net/v/' .
rawurlencode((string)$v['vessel_key']) .
'?embed=1';
$content = <<
Reise
{$vesselName}
HTML;
return self::layout('Reise', $content, $v);
}
private static function renderGallery(array $v): string
{
$db = platform_db();
$stmt = $db->prepare("
SELECT *
FROM vessel_website_images
WHERE vessel_id = ?
AND is_active = 1
ORDER BY sort_order, id
");
$stmt->execute([(int)$v['id']]);
$images = $stmt->fetchAll(PDO::FETCH_ASSOC);
$vesselKey = rawurlencode((string)$v['vessel_key']);
$items = '';
foreach ($images as $img) {
$filename = rawurlencode((string)($img['filename'] ?? ''));
$caption = self::h($img['caption_de'] ?? '');
$thumb = '/uploads/vessels/' . $vesselKey . '/website/thumb/' . $filename;
$web = '/uploads/vessels/' . $vesselKey . '/website/web/' . $filename;
$alt = $caption !== '' ? $caption : 'Galeriebild';
$items .= <<
{$caption}
HTML;
}
if ($items === '') {
$items = 'Für diese Galerie wurden noch keine Bilder hinterlegt.
';
}
$content = <<
Galerie
HTML;
return self::layout('Galerie', $content, $v);
}
private static function renderContact(array $v): string
{
$owner = self::value($v, 'website_owner_name');
$emailRaw = trim((string)($v['website_contact_email'] ?? ''));
$email = $emailRaw !== ''
? '' . self::h($emailRaw) . ''
: '—';
$phone = self::value($v, 'website_contact_phone');
$imprint = self::nl($v['website_imprint'] ?? '');
$privacy = self::nl($v['website_privacy'] ?? '');
if (trim(strip_tags($imprint)) === '') {
$imprint = 'Impressumsangaben wurden noch nicht hinterlegt.
';
}
if (trim(strip_tags($privacy)) === '') {
$privacy = 'Datenschutzhinweise wurden noch nicht hinterlegt.
';
}
$content = <<
Kontakt
Kontakt
Name{$owner}
E-Mail{$email}
Telefon{$phone}
HTML;
return self::layout('Kontakt', $content, $v);
}
private static function labelHullType(?string $value): string
{
return match ((string)$value) {
'monohull' => 'Monohull',
'catamaran' => 'Katamaran',
default => '—',
};
}
private static function labelVesselCategory(?string $value): string
{
return match ((string)$value) {
'sailing' => 'Segelschiff',
'motor' => 'Motorschiff',
default => '—',
};
}
private static function labelPropulsion(?string $value): string
{
return match ((string)$value) {
'diesel' => 'Diesel',
'electric' => 'Elektro',
'hybrid' => 'Hybrid',
'other' => 'Sonstige',
default => '—',
};
}
private static function renderCss(): string
{
return <<