@php
    // Ana menü öğeleri (sahipid = 0)
    $mainMenu = \Illuminate\Support\Facades\DB::table('sayfalar')
        ->where('menu', 1)
        ->where('durum', 1)
        ->where('sahipid', 0)
        ->orderBy('sira')
        ->get();
    
    // Alt menüler - sayfa ID'lerine göre
    $subMenus = [];
    $subMenus[217] = \Illuminate\Support\Facades\DB::table('sayfalar')
        ->where('menu', 1)
        ->where('durum', 1)
        ->where('sahipid', 217)
        ->orderBy('sira')
        ->get();
    
    $subMenus[228] = \Illuminate\Support\Facades\DB::table('sayfalar')
        ->where('menu', 1)
        ->where('durum', 1)
        ->where('sahipid', 228)
        ->orderBy('sira')
        ->get();
    
    // Site ayarları (iletişim bilgileri)
    $settings = \Illuminate\Support\Facades\DB::table('site_settings')->first();
@endphp

<footer class="main-footer sec-pad">
    <div class="container">
        <div class="row">
          <div class="col-md-3 col-sm-6 col-xs-12 footer-colmun">
              <div class="service-widget footer-widget">
                  <div class="footer-title"><h4>Ürün Gruplarımız</h4></div>
                  <ul class="list">
                    @if(isset($subMenus[217]) && $subMenus[217]->count() > 0)
                        @foreach ($subMenus[217] as $subpage)
                            <li><a href="{{ url('page/'.$subpage->seo_url) }}">{{ $subpage->baslik }}</a></li>
                        @endforeach
                    @else
                        <li><a href="#">Henüz menü eklenmemiş</a></li>
                    @endif
                  </ul>
              </div>
          </div>
          <div class="col-md-3 col-sm-6 col-xs-12 footer-colmun">
              <div class="service-widget footer-widget">
                  <div class="footer-title"><h4>Spor Ekipmanlari</h4></div>
                  <ul class="list">
                    @if(isset($subMenus[228]) && $subMenus[228]->count() > 0)
                        @foreach ($subMenus[228] as $subpage)
                            <li><a href="{{ url('page/'.$subpage->seo_url) }}">{{ $subpage->baslik }}</a></li>
                        @endforeach
                    @else
                        <li><a href="#">Henüz menü eklenmemiş</a></li>
                    @endif
                  </ul>
              </div>
          </div>

            <div class="col-md-2 col-sm-6 col-xs-12 footer-colmun">
                <div class="link-widget footer-widget">
                    <div class="footer-title"><h4>Hızlı Menü</h4></div>
                    <ul class="list">
                      @if($mainMenu->count() > 0)
                        @foreach ($mainMenu as $page)
                            <li><a href="{{ url('page/'.$page->seo_url) }}">{{$page->baslik}}</a></li>
                        @endforeach
                      @else
                        <li><a href="#">Henüz menü eklenmemiş</a></li>
                      @endif
                    </ul>
                </div>
            </div>
            <div class="col-md-3 col-sm-6 col-xs-12 footer-colmun">
                <div class="subscribe-widget footer-widget">
                    <div class="footer-title"><h4>Bize Ulaşın</h4></div>
                    <ul class="flat-infomation">
                        <div class="text">
                            <p><i class="fa fa-map-marker"></i> {{ $settings->address ?? 'İvedik Organize Sanayi Bölgesi Melih Gökçek Bulvarı 1485. Cadde 1363. Sokak No:78-79-81 Yenimahalle / Ankara' }}</p>
                        </div>
                        <div class="text">
                            <p><i class="fa fa-phone"></i> {{ $settings->phone1 ?? '+90 312 395 10 35' }}</p>
                        </div>
                        @if(!empty($settings->phone2))
                        <div class="text">
                            <p><i class="fa fa-phone"></i> {{ $settings->phone2 }}</p>
                        </div>
                        @endif
                        <div class="text">
                            <p><i class="fa fa-envelope"></i> {{ $settings->email ?? 'info@prosportas.com.tr' }}</p>
                        </div>
                    </ul>
                    @if(!empty($settings->facebook_url) || !empty($settings->twitter_url) || !empty($settings->instagram_url) || !empty($settings->linkedin_url) || !empty($settings->youtube_url))
                    <div class="social-links" style="margin-top: 20px;">
                        <ul class="social-top" style="display: flex; gap: 10px; list-style: none; padding: 0;">
                            @if(!empty($settings->facebook_url))
                            <li><a href="{{ $settings->facebook_url }}" target="_blank" rel="noopener noreferrer" style="color: #3b5998;"><i class="fa fa-facebook"></i></a></li>
                            @endif
                            @if(!empty($settings->twitter_url))
                            <li><a href="{{ $settings->twitter_url }}" target="_blank" rel="noopener noreferrer" style="color: #1da1f2;"><i class="fa fa-twitter"></i></a></li>
                            @endif
                            @if(!empty($settings->instagram_url))
                            <li><a href="{{ $settings->instagram_url }}" target="_blank" rel="noopener noreferrer" style="color: #e4405f;"><i class="fa fa-instagram"></i></a></li>
                            @endif
                            @if(!empty($settings->linkedin_url))
                            <li><a href="{{ $settings->linkedin_url }}" target="_blank" rel="noopener noreferrer" style="color: #0077b5;"><i class="fa fa-linkedin"></i></a></li>
                            @endif
                            @if(!empty($settings->youtube_url))
                            <li><a href="{{ $settings->youtube_url }}" target="_blank" rel="noopener noreferrer" style="color: #ff0000;"><i class="fa fa-youtube"></i></a></li>
                            @endif
                        </ul>
                    </div>
                    @endif
                </div>
            </div>
        </div>
    </div>
</footer>