@push('styles') @endpush @php $sidebarLocale = app()->getLocale(); // Deteksi menu_key aktif via RouteTranslator — bekerja untuk slug apapun per bahasa $currentPath = '/' . ltrim(request()->path(), '/'); $sidebarRouteKey = \App\Helpers\RouteTranslator::detectKey($currentPath); // route_key investor selalu 'investor-{menu_key}' $sidebarActiveKey = $sidebarRouteKey && str_starts_with($sidebarRouteKey, 'investor-') ? substr($sidebarRouteKey, strlen('investor-')) : null; // Kolom label yang dipakai berdasarkan locale aktif $sidebarLabelCol = match ($sidebarLocale) { 'id' => 'mi.label_id', 'ja' => 'mi.label_jp', default => 'mi.label_en', }; // Ambil menu dari mst_investor — label per bahasa dengan fallback ke sys_enum.name $sidebarMenus = \Illuminate\Support\Facades\DB::table('mst_investor as mi') ->join('sys_enum as se', function ($join) { $join->on('se.value', '=', 'mi.menu_key')->where('se.idenum', '=', 'investor_menu'); }) ->where('mi.isactive', 1) ->orderBy('mi.urut') ->selectRaw("mi.menu_key, COALESCE(NULLIF({$sidebarLabelCol}, ''), se.name) as label") ->get(); @endphp