@php
    $locale = app()->getLocale();
    $footerKategori = \Illuminate\Support\Facades\DB::table('mst_kategori')
        ->join('mst_kategori_lang', 'mst_kategori.idkategori', '=', 'mst_kategori_lang.idkategori')
        ->where('mst_kategori.isactive', 1)
        ->where('mst_kategori_lang.locale', $locale)
        ->orderBy('mst_kategori.urutan')
        ->select('mst_kategori.idkategori', 'mst_kategori_lang.nama')
        ->take(4)
        ->get();

    $footerKontak = \Illuminate\Support\Facades\DB::table('mst_kontak')->where('isactive', 1)->first();
    $cleanWa = $footerKontak ? preg_replace('/[^0-9]/', '', $footerKontak->whatsapp ?? '') : '';
    $waUrl = $cleanWa ? "https://wa.me/{$cleanWa}" : url('/kontak');
    $emailUrl = ($footerKontak && $footerKontak->email) ? "mailto:{$footerKontak->email}" : url('/kontak');
@endphp

<footer class="footer-section">
    <div class="container-fluid container-narrow">
        <div class="row gy-4">
            {{-- Brand & Social Icons --}}
            <div class="col-md-3">
                <p class="footer-brand mb-3">
                    <a href="{{ url('/') }}" class="text-decoration-none fw-bold fs-4 footer-brand">Intisolve</a>
                </p>
                <div class="d-flex gap-2">
                    <a href="{{ $waUrl }}" target="_blank" rel="noopener noreferrer" class="footer-social-icon" title="WhatsApp"><i class="fab fa-whatsapp"></i></a>
                    <a href="{{ $emailUrl }}" class="footer-social-icon" title="Email"><i class="far fa-envelope"></i></a>
                    <a href="{{ url('/kontak') }}" class="footer-social-icon" title="Alamat Kontak"><i class="fas fa-map-marker-alt"></i></a>
                </div>
            </div>

            {{-- Kolom Kategori Produk --}}
            <div class="col-md-3">
                <h6>{{ __('footer.kategori produk') }}</h6>
                <ul class="list-unstyled small">
                    @forelse($footerKategori as $kat)
                        <li class="mb-2">
                            <a href="{{ url('/kategori?kategori=' . $kat->idkategori) }}" class="text-decoration-none">
                                {{ $kat->nama }}
                            </a>
                        </li>
                    @empty
                        <li class="mb-2"><a href="{{ url('/kategori') }}" class="text-decoration-none">FloodLock</a></li>
                        <li class="mb-2"><a href="{{ url('/kategori') }}" class="text-decoration-none">Absorbent</a></li>
                        <li class="mb-2"><a href="{{ url('/kategori') }}" class="text-decoration-none">Agriculture</a></li>
                    @endforelse
                </ul>
            </div>

            {{-- Kolom Informasi --}}
            <div class="col-md-3">
                <h6>{{ __('footer.informasi') }}</h6>
                <ul class="list-unstyled small">
                    <li class="mb-2"><a href="{{ url('/solusi') }}" class="text-decoration-none">{{ __('footer.artikel') }}</a></li>
                    <li class="mb-2"><a href="{{ url('/download') }}" class="text-decoration-none">{{ __('footer.catalog') }}</a></li>
                    <li class="mb-2"><a href="{{ url('/tentang-kami') }}" class="text-decoration-none">{{ __('footer.tentang') }}</a></li>
                </ul>
            </div>

            {{-- Kolom Bantuan --}}
            <div class="col-md-3">
                <h6>{{ __('footer.bantuan') }}</h6>
                <ul class="list-unstyled small">
                    <li class="mb-2"><a href="{{ url('/kontak') }}" class="text-decoration-none">{{ __('nav.kontak') }}</a></li>
                    <li class="mb-2"><a href="{{ url('/faq') }}" class="text-decoration-none">{{ __('nav.faq') }}</a></li>
                </ul>
            </div>

        <p class="footer-copyright text-center mb-0">&copy; {{ date('Y') }} Intisolve. {{ __('footer.copyright') }}</p>
    </div>
</footer>