@php
    use App\Models\Donation;
    use App\Models\Elderly;
    use App\Models\User;
    use App\Models\SystemSetting;
    use App\Services\CurrencyService;
    
    // Get real data from the database
    $elderlyCount = Elderly::where('status', 'approved')->count();
    $totalDonations = Donation::where('payment_status', 'completed')->sum('amount');
    $organizationCount = User::where('account_type', 'organization')->count();
    $countriesReached = Donation::where('payment_status', 'completed')
        ->join('users', 'donations.donor_id', '=', 'users.id')
        ->whereNotNull('users.country')
        ->distinct('users.country')
        ->count('users.country');
    
    // Check if global currency override is enabled
    $globalOverrideEnabled = SystemSetting::isGlobalCurrencyOverrideEnabled();
    $currencyCode = null;
    
    if ($globalOverrideEnabled) {
        $currencyCode = SystemSetting::getDefaultCurrency();
    }
    
    // Format the donation amount with the appropriate currency (respecting admin override if set)
    $formattedDonations = CurrencyService::formatAmount($totalDonations, $currencyCode);
    
    // Create stats array with real data
    $stats = [
        ['value' => number_format($elderlyCount) . '+', 'label' => 'Elderly Supported'],
        ['value' => $formattedDonations, 'label' => 'Donations Raised'],
        ['value' => number_format($organizationCount) . '+', 'label' => 'Partner Organizations'],
        ['value' => number_format($countriesReached), 'label' => 'Countries Reached'],
    ];
    
    $testimonialImage = 'https://images.unsplash.com/photo-1442458370899-ae20e367c5d8?q=80&w=2874&auto=format&fit=crop';
@endphp

<section class="py-16 md:py-24 bg-primary text-white">
    <div class="container mx-auto px-4 md:px-6">
        <div class="max-w-3xl mx-auto text-center mb-12">
            <h2 class="text-3xl font-bold tracking-tight">Our Impact</h2>
            <p class="mt-4 opacity-90">
                Together, we're making a significant difference in the lives of elderly individuals worldwide.
            </p>
        </div>
        
        <div class="grid grid-cols-2 md:grid-cols-4 gap-8">
            @foreach($stats as $index => $stat)
                <div 
                    class="text-center animate-fade-in-up"
                    style="animation-delay: {{ $index * 0.1 }}s"
                >
                    <p class="text-4xl font-bold">{{ $stat['value'] }}</p>
                    <p class="opacity-90 mt-2">{{ $stat['label'] }}</p>
                </div>
            @endforeach
        </div>
        
        <div class="mt-16 max-w-3xl mx-auto">
            <div class="bg-white/10 border border-white/20 rounded-lg p-6 backdrop-blur-sm">
                <p class="italic text-lg text-center">
                    "The support I received through Elderly Care Connect has been life-changing. I now have access to medical care and don't have to worry about my daily needs."
                </p>
                <div class="mt-4 flex items-center justify-center">
                    <div class="w-12 h-12 rounded-full overflow-hidden mr-4">
                        <img 
                            src="{{ $testimonialImage }}" 
                            alt="Martha Williams testimonial" 
                            class="w-full h-full object-cover"
                            width="48"
                            height="48"
                            loading="lazy"
                        />
                    </div>
                    <div>
                        <p class="font-medium">Martha Williams, 82</p>
                        <p class="opacity-80 text-sm">Received support in 2023</p>
                    </div>
                </div>
            </div>
        </div>
    </div>
</section>