@php // PAUTAN BERKAITAN — data dari modul Content Application (kategori RELATED_LINKS). $frtLang = ($lang ?? session('locale', 'ms')) === 'en' ? 'en' : 'ms'; $frtRows = DB::table('content_applications') ->where('application_cat', 'RELATED_LINKS') ->where('application_status', 'ACTIVE') ->orderBy('application_sort') ->orderBy('application_id') ->get(); $frtIds = $frtRows->pluck('application_id')->all(); $frtTr = $frtIds ? DB::table('content_application_translations') ->whereIn('application_translation_parent_id', $frtIds) ->get() ->groupBy('application_translation_parent_id') : collect(); $frtLinks = []; foreach ($frtRows as $frtRow) { $rows = $frtTr[$frtRow->application_id] ?? collect(); $tr = $rows->firstWhere('application_translation_language', $frtLang) ?? $rows->firstWhere('application_translation_main', 1) ?? $rows->first(); $title = trim((string) ($tr->application_translation_title ?? '')); if ($title === '') { continue; } $frtLinks[] = [ 'title' => $title, 'url' => trim((string) $frtRow->application_url), ]; } @endphp