). * * B) 0009-FE Punkt 7: vitec_ctabanner auf Market-/Solution-Seiten haben * Labels ("Contact our team" / "Request a demo"), aber keine Links. * Leere primary_cta mit Contact-Label -> /contact, leere secondary_cta * mit Demo-Label -> /contact/request-a-demo (als t3://page?uid=...). * Gefuellte Links werden NIE angefasst. * * Plain PDO (Muster migrations/check_bg.php). * * Usage: php migrations/ticket_quickwins_20261028.php (inspect) * php migrations/ticket_quickwins_20261028.php --apply */ error_reporting(E_ALL); ini_set('display_errors', '1'); const REQUEST_ACCESS_UID = 11489; const ANCHOR = 'form-helpdesk'; $apply = in_array('--apply', $argv, true); $root = null; $dir = __DIR__; for ($i = 0; $i < 5; $i++) { if (is_file($dir . '/config/system/settings.php')) { $root = $dir; break; } $dir = dirname($dir); } if ($root === null) { exit("Could not locate project root above " . __DIR__ . "\n"); } $settings = require $root . '/config/system/settings.php'; $db = $settings['DB']['Connections']['Default']; $pdo = new PDO( sprintf('mysql:host=%s;port=%s;dbname=%s;charset=utf8mb4', $db['host'] ?? 'localhost', $db['port'] ?? 3306, $db['dbname'] ?? ''), $db['user'] ?? '', $db['password'] ?? '', [PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION] ); echo ($apply ? 'APPLY' : 'INSPECT') . "\n"; function pageUidBySlug(PDO $pdo, string $slug): int { $stmt = $pdo->prepare('SELECT uid FROM pages WHERE deleted = 0 AND slug = ? AND sys_language_uid IN (0,-1)'); $stmt->execute([$slug]); return (int)$stmt->fetchColumn(); } // --- A) Request-access-Karte -> Anker --------------------------------------- echo "\n--- A) Request access -> #" . ANCHOR . " ---\n"; $stmt = $pdo->prepare('SELECT uid, header, vitec_primary_cta FROM tt_content WHERE deleted = 0 AND uid = ?'); $stmt->execute([REQUEST_ACCESS_UID]); $card = $stmt->fetch(PDO::FETCH_ASSOC); if (!$card) { echo "Karte #" . REQUEST_ACCESS_UID . " nicht gefunden - uebersprungen.\n"; } elseif (stripos((string)$card['header'], 'request access') === false) { echo "Karte #" . REQUEST_ACCESS_UID . " heisst \"" . $card['header'] . "\" (erwartet: Request access) - NICHT angefasst.\n"; } else { $cta = (string)$card['vitec_primary_cta']; if (str_contains($cta, '#' . ANCHOR)) { echo "Karte #" . REQUEST_ACCESS_UID . ": Anker bereits gesetzt ($cta) - nichts zu tun.\n"; } elseif ($cta === '') { echo "Karte #" . REQUEST_ACCESS_UID . ": primary_cta ist LEER - erst klaeren, nicht angefasst.\n"; } else { $new = $cta . '#' . ANCHOR; echo "Karte #" . REQUEST_ACCESS_UID . " (\"" . $card['header'] . "\"): \"$cta\" -> \"$new\"\n"; if ($apply) { $pdo->prepare('UPDATE tt_content SET vitec_primary_cta = ?, tstamp = UNIX_TIMESTAMP() WHERE uid = ?') ->execute([$new, REQUEST_ACCESS_UID]); echo " geschrieben.\n"; } } } // --- B) CTA-Banner-Defaults auf Market-/Solution-Seiten ---------------------- echo "\n--- B) ctabanner-Links auf /markets + /solutions ---\n"; $contactUid = pageUidBySlug($pdo, '/contact'); $demoUid = pageUidBySlug($pdo, '/contact/request-a-demo'); $solutionsUid = pageUidBySlug($pdo, '/solutions'); if ($contactUid === 0 || $demoUid === 0 || $solutionsUid === 0) { exit("Zielseiten nicht aufloesbar (/contact=#$contactUid, request-a-demo=#$demoUid, /solutions=#$solutionsUid) - Abbruch.\n"); } echo "Ziele: /contact=#$contactUid, request-a-demo=#$demoUid, /solutions=#$solutionsUid\n"; $rows = $pdo->query( "SELECT c.uid, p.slug, c.vitec_primary_cta, c.vitec_primary_cta_label, c.vitec_secondary_cta, c.vitec_secondary_cta_label FROM tt_content c JOIN pages p ON p.uid = c.pid AND p.deleted = 0 WHERE c.deleted = 0 AND c.CType = 'vitec_ctabanner' AND (p.slug = '/markets' OR p.slug LIKE '/markets/%' OR p.slug = '/solutions' OR p.slug LIKE '/solutions/%') ORDER BY p.slug" )->fetchAll(PDO::FETCH_ASSOC); $setPrimary = 0; $setSecondary = 0; foreach ($rows as $row) { $actions = []; $pLabel = (string)$row['vitec_primary_cta_label']; $sLabel = (string)$row['vitec_secondary_cta_label']; // Sub-Solution-Variante: "Contact our team" / "Request a demo"; // Market-Variante (Fund 28.10.): "Talk to our team" / "Explore solutions" if ((string)$row['vitec_primary_cta'] === '' && (stripos($pLabel, 'contact') !== false || stripos($pLabel, 'talk') !== false)) { $actions['vitec_primary_cta'] = 't3://page?uid=' . $contactUid; $setPrimary++; } if ((string)$row['vitec_secondary_cta'] === '') { if (stripos($sLabel, 'demo') !== false) { $actions['vitec_secondary_cta'] = 't3://page?uid=' . $demoUid; $setSecondary++; } elseif (stripos($sLabel, 'solution') !== false) { $actions['vitec_secondary_cta'] = 't3://page?uid=' . $solutionsUid; $setSecondary++; } } if ($actions === []) { continue; } echo "#" . $row['uid'] . " " . $row['slug'] . ": " . implode(', ', array_map( static fn(string $field, string $value): string => $field . ' = ' . $value, array_keys($actions), $actions )) . "\n"; if ($apply) { $set = implode(', ', array_map(static fn(string $f): string => "$f = ?", array_keys($actions))); $pdo->prepare("UPDATE tt_content SET $set, tstamp = UNIX_TIMESTAMP() WHERE uid = ?") ->execute([...array_values($actions), (int)$row['uid']]); } } echo "\n" . count($rows) . " Banner geprueft · $setPrimary primary + $setSecondary secondary " . ($apply ? 'gesetzt' : 'zu setzen') . ".\n"; if (!$apply) { echo "Inspect only - mit --apply schreiben.\n"; } else { echo "Danach: vendor/bin/typo3 cache:flush\n"; }