@extends('layouts.app')

@section('title', 'Ürün & Finansal')

@section('content')
<div class="px-4 sm:px-6 lg:px-8">
    <div class="sm:flex sm:items-center sm:justify-between">
        <div class="sm:flex-auto">
            <h1 class="text-3xl font-semibold text-gray-900 dark:text-gray-100">Ürün & Finansal</h1>
            <p class="mt-2 text-sm text-gray-700 dark:text-gray-300">
                Ürün ve finansal yönetim paneli
            </p>
        </div>
        <div class="mt-4 sm:mt-0">
            <a href="{{ route('management-panel.index') }}" class="inline-flex items-center gap-2 px-4 py-2 text-sm font-semibold text-gray-700 dark:text-gray-300 bg-white dark:bg-gray-800 border border-gray-300 dark:border-gray-600 rounded-md hover:bg-gray-50 dark:hover:bg-gray-700 transition">
                <i class="fas fa-arrow-left"></i>
                Geri Dön
            </a>
        </div>
    </div>

    <!-- İstatistik Kartları -->
    <div class="mt-6 grid grid-cols-1 md:grid-cols-2 lg:grid-cols-4 gap-6">
        <!-- Toplam Ürün -->
        <div class="bg-white dark:bg-gray-800 rounded-lg shadow p-6 border border-gray-200 dark:border-gray-700">
            <div class="flex items-center justify-between">
                <div>
                    <p class="text-sm font-medium text-gray-500 dark:text-gray-400">Toplam Ürün</p>
                    <p class="mt-2 text-3xl font-semibold text-gray-900 dark:text-gray-100">{{ number_format($totalProducts) }}</p>
                </div>
                <div class="flex-shrink-0 w-12 h-12 rounded-lg bg-blue-100 dark:bg-blue-900/30 flex items-center justify-center">
                    <i class="fas fa-box text-blue-600 dark:text-blue-400 text-xl"></i>
                </div>
            </div>
        </div>

        <!-- Master Ürünler -->
        <div class="bg-white dark:bg-gray-800 rounded-lg shadow p-6 border border-gray-200 dark:border-gray-700">
            <div class="flex items-center justify-between">
                <div>
                    <p class="text-sm font-medium text-gray-500 dark:text-gray-400">Master Ürünler</p>
                    <p class="mt-2 text-3xl font-semibold text-gray-900 dark:text-gray-100">{{ number_format($masterProducts) }}</p>
                </div>
                <div class="flex-shrink-0 w-12 h-12 rounded-lg bg-purple-100 dark:bg-purple-900/30 flex items-center justify-center">
                    <i class="fas fa-star text-purple-600 dark:text-purple-400 text-xl"></i>
                </div>
            </div>
        </div>

        <!-- WordPress'e Senkronize -->
        <div class="bg-white dark:bg-gray-800 rounded-lg shadow p-6 border border-gray-200 dark:border-gray-700">
            <div class="flex items-center justify-between">
                <div>
                    <p class="text-sm font-medium text-gray-500 dark:text-gray-400">Senkronize Ürünler</p>
                    <p class="mt-2 text-3xl font-semibold text-gray-900 dark:text-gray-100">{{ number_format($syncedProducts) }}</p>
                    <p class="mt-1 text-xs text-gray-500 dark:text-gray-400">
                        {{ $totalProducts > 0 ? number_format(($syncedProducts / $totalProducts) * 100, 1) : 0 }}%
                    </p>
                </div>
                <div class="flex-shrink-0 w-12 h-12 rounded-lg bg-green-100 dark:bg-green-900/30 flex items-center justify-center">
                    <i class="fas fa-sync text-green-600 dark:text-green-400 text-xl"></i>
                </div>
            </div>
        </div>

        <!-- Maliyet Bilgisi Olan -->
        <div class="bg-white dark:bg-gray-800 rounded-lg shadow p-6 border border-gray-200 dark:border-gray-700">
            <div class="flex items-center justify-between">
                <div>
                    <p class="text-sm font-medium text-gray-500 dark:text-gray-400">Maliyet Bilgisi</p>
                    <p class="mt-2 text-3xl font-semibold text-gray-900 dark:text-gray-100">{{ number_format($productsWithCost) }}</p>
                    <p class="mt-1 text-xs text-gray-500 dark:text-gray-400">
                        {{ $totalProducts > 0 ? number_format(($productsWithCost / $totalProducts) * 100, 1) : 0 }}%
                    </p>
                </div>
                <div class="flex-shrink-0 w-12 h-12 rounded-lg bg-orange-100 dark:bg-orange-900/30 flex items-center justify-center">
                    <i class="fas fa-dollar-sign text-orange-600 dark:text-orange-400 text-xl"></i>
                </div>
            </div>
        </div>
    </div>

    <!-- Fiyat İstatistikleri -->
    <div class="mt-6 grid grid-cols-1 lg:grid-cols-2 gap-6">
        <!-- Fiyat Özeti -->
        <div class="bg-white dark:bg-gray-800 rounded-lg shadow border border-gray-200 dark:border-gray-700">
            <div class="px-6 py-4 border-b border-gray-200 dark:border-gray-700">
                <h2 class="text-lg font-semibold text-gray-900 dark:text-gray-100">
                    <i class="fas fa-chart-line text-blue-500 dark:text-blue-400 mr-2"></i>
                    Fiyat İstatistikleri
                </h2>
            </div>
            <div class="p-6">
                <div class="space-y-4">
                    <div class="flex justify-between items-center">
                        <span class="text-sm text-gray-600 dark:text-gray-400">Ortalama Normal Fiyat</span>
                        <span class="text-lg font-semibold text-gray-900 dark:text-gray-100">
                            {{ $priceStats['avg_regular_price'] ? number_format($priceStats['avg_regular_price'], 2) . ' €' : '-' }}
                        </span>
                    </div>
                    <div class="flex justify-between items-center">
                        <span class="text-sm text-gray-600 dark:text-gray-400">Ortalama İndirimli Fiyat</span>
                        <span class="text-lg font-semibold text-gray-900 dark:text-gray-100">
                            {{ $priceStats['avg_sale_price'] ? number_format($priceStats['avg_sale_price'], 2) . ' €' : '-' }}
                        </span>
                    </div>
                    <div class="flex justify-between items-center">
                        <span class="text-sm text-gray-600 dark:text-gray-400">Ortalama Maliyet</span>
                        <span class="text-lg font-semibold text-gray-900 dark:text-gray-100">
                            {{ $priceStats['avg_cost_price'] ? number_format($priceStats['avg_cost_price'], 2) . ' €' : '-' }}
                        </span>
                    </div>
                    <div class="pt-4 border-t border-gray-200 dark:border-gray-700">
                        <div class="flex justify-between items-center">
                            <span class="text-sm font-medium text-gray-700 dark:text-gray-300">Toplam Normal Fiyat</span>
                            <span class="text-xl font-bold text-blue-600 dark:text-blue-400">
                                {{ $priceStats['total_regular_price'] ? number_format($priceStats['total_regular_price'], 2) . ' €' : '-' }}
                            </span>
                        </div>
                        <div class="flex justify-between items-center mt-2">
                            <span class="text-sm font-medium text-gray-700 dark:text-gray-300">Toplam İndirimli Fiyat</span>
                            <span class="text-xl font-bold text-green-600 dark:text-green-400">
                                {{ $priceStats['total_sale_price'] ? number_format($priceStats['total_sale_price'], 2) . ' €' : '-' }}
                            </span>
                        </div>
                        <div class="flex justify-between items-center mt-2">
                            <span class="text-sm font-medium text-gray-700 dark:text-gray-300">Toplam Maliyet</span>
                            <span class="text-xl font-bold text-orange-600 dark:text-orange-400">
                                {{ $priceStats['total_cost_price'] ? number_format($priceStats['total_cost_price'], 2) . ' €' : '-' }}
                            </span>
                        </div>
                    </div>
                </div>
            </div>
        </div>

        <!-- Kar Marjı Analizi -->
        <div class="bg-white dark:bg-gray-800 rounded-lg shadow border border-gray-200 dark:border-gray-700">
            <div class="px-6 py-4 border-b border-gray-200 dark:border-gray-700">
                <h2 class="text-lg font-semibold text-gray-900 dark:text-gray-100">
                    <i class="fas fa-percentage text-green-500 dark:text-green-400 mr-2"></i>
                    Kar Marjı Analizi
                </h2>
            </div>
            <div class="p-6">
                <div class="space-y-4">
                    <div class="flex justify-between items-center">
                        <span class="text-sm text-gray-600 dark:text-gray-400">Toplam Ürün</span>
                        <span class="text-lg font-semibold text-gray-900 dark:text-gray-100">
                            {{ number_format($marginAnalysis->total ?? 0) }}
                        </span>
                    </div>
                    <div class="flex justify-between items-center">
                        <span class="text-sm text-gray-600 dark:text-gray-400">Marj Bilgisi Olan</span>
                        <span class="text-lg font-semibold text-gray-900 dark:text-gray-100">
                            {{ number_format($marginAnalysis->with_margin ?? 0) }}
                        </span>
                    </div>
                    <div class="pt-4 border-t border-gray-200 dark:border-gray-700">
                        <div class="flex justify-between items-center">
                            <span class="text-sm font-medium text-gray-700 dark:text-gray-300">Ortalama Kar Marjı</span>
                            <span class="text-2xl font-bold text-green-600 dark:text-green-400">
                                {{ $marginAnalysis->avg_margin_percent ? number_format($marginAnalysis->avg_margin_percent, 2) . '%' : '-' }}
                            </span>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>

    <!-- Para Birimi Dağılımı -->
    @if($currencyDistribution->count() > 0)
    <div class="mt-6 bg-white dark:bg-gray-800 rounded-lg shadow border border-gray-200 dark:border-gray-700">
        <div class="px-6 py-4 border-b border-gray-200 dark:border-gray-700">
            <h2 class="text-lg font-semibold text-gray-900 dark:text-gray-100">
                <i class="fas fa-coins text-yellow-500 dark:text-yellow-400 mr-2"></i>
                Para Birimi Dağılımı
            </h2>
        </div>
        <div class="p-6">
            <div class="grid grid-cols-2 md:grid-cols-4 lg:grid-cols-6 gap-4">
                @foreach($currencyDistribution as $currency)
                <div class="text-center p-4 bg-gray-50 dark:bg-gray-700 rounded-lg">
                    <p class="text-2xl font-bold text-gray-900 dark:text-gray-100">{{ $currency->currency }}</p>
                    <p class="text-sm text-gray-500 dark:text-gray-400 mt-1">{{ $currency->total }} Site</p>
                </div>
                @endforeach
            </div>
        </div>
    </div>
    @endif

    <!-- Site Bazlı Ürün Dağılımı -->
    @if($productsBySite->count() > 0)
    <div class="mt-6 bg-white dark:bg-gray-800 rounded-lg shadow border border-gray-200 dark:border-gray-700">
        <div class="px-6 py-4 border-b border-gray-200 dark:border-gray-700">
            <h2 class="text-lg font-semibold text-gray-900 dark:text-gray-100">
                <i class="fas fa-sitemap text-purple-500 dark:text-purple-400 mr-2"></i>
                Site Bazlı Ürün Dağılımı
            </h2>
        </div>
        <div class="overflow-x-auto">
            <table class="min-w-full divide-y divide-gray-200 dark:divide-gray-700">
                <thead class="bg-gray-50 dark:bg-gray-700">
                    <tr>
                        <th class="px-6 py-3 text-left text-xs font-medium text-gray-500 dark:text-gray-300 uppercase tracking-wider">Site</th>
                        <th class="px-6 py-3 text-left text-xs font-medium text-gray-500 dark:text-gray-300 uppercase tracking-wider">Ürün Sayısı</th>
                        <th class="px-6 py-3 text-left text-xs font-medium text-gray-500 dark:text-gray-300 uppercase tracking-wider">Para Birimi</th>
                    </tr>
                </thead>
                <tbody class="bg-white dark:bg-gray-800 divide-y divide-gray-200 dark:divide-gray-700">
                    @foreach($productsBySite->take(10) as $item)
                    <tr>
                        <td class="px-6 py-4 whitespace-nowrap text-sm font-medium text-gray-900 dark:text-gray-100">
                            {{ $item->site->name ?? 'Bilinmeyen Site' }}
                        </td>
                        <td class="px-6 py-4 whitespace-nowrap text-sm text-gray-500 dark:text-gray-400">
                            {{ number_format($item->total) }}
                        </td>
                        <td class="px-6 py-4 whitespace-nowrap text-sm text-gray-500 dark:text-gray-400">
                            {{ $item->site->currency ?? '-' }}
                        </td>
                    </tr>
                    @endforeach
                </tbody>
            </table>
        </div>
    </div>
    @endif

    <!-- Son Eklenen Ürünler -->
    @if($recentProducts->count() > 0)
    <div class="mt-6 bg-white dark:bg-gray-800 rounded-lg shadow border border-gray-200 dark:border-gray-700">
        <div class="px-6 py-4 border-b border-gray-200 dark:border-gray-700">
            <h2 class="text-lg font-semibold text-gray-900 dark:text-gray-100">
                <i class="fas fa-clock text-indigo-500 dark:text-indigo-400 mr-2"></i>
                Son Eklenen Ürünler
            </h2>
        </div>
        <div class="overflow-x-auto">
            <table class="min-w-full divide-y divide-gray-200 dark:divide-gray-700">
                <thead class="bg-gray-50 dark:bg-gray-700">
                    <tr>
                        <th class="px-6 py-3 text-left text-xs font-medium text-gray-500 dark:text-gray-300 uppercase tracking-wider">Ürün Adı</th>
                        <th class="px-6 py-3 text-left text-xs font-medium text-gray-500 dark:text-gray-300 uppercase tracking-wider">Site</th>
                        <th class="px-6 py-3 text-left text-xs font-medium text-gray-500 dark:text-gray-300 uppercase tracking-wider">Normal Fiyat</th>
                        <th class="px-6 py-3 text-left text-xs font-medium text-gray-500 dark:text-gray-300 uppercase tracking-wider">İndirimli Fiyat</th>
                        <th class="px-6 py-3 text-left text-xs font-medium text-gray-500 dark:text-gray-300 uppercase tracking-wider">Durum</th>
                    </tr>
                </thead>
                <tbody class="bg-white dark:bg-gray-800 divide-y divide-gray-200 dark:divide-gray-700">
                    @foreach($recentProducts as $product)
                    <tr>
                        <td class="px-6 py-4 whitespace-nowrap text-sm font-medium text-gray-900 dark:text-gray-100">
                            {{ $product->name }}
                        </td>
                        <td class="px-6 py-4 whitespace-nowrap text-sm text-gray-500 dark:text-gray-400">
                            {{ $product->site->name ?? '-' }}
                        </td>
                        <td class="px-6 py-4 whitespace-nowrap text-sm text-gray-500 dark:text-gray-400">
                            {{ $product->regular_price ? number_format($product->regular_price, 2) . ' €' : '-' }}
                        </td>
                        <td class="px-6 py-4 whitespace-nowrap text-sm text-gray-500 dark:text-gray-400">
                            {{ $product->sale_price ? number_format($product->sale_price, 2) . ' €' : '-' }}
                        </td>
                        <td class="px-6 py-4 whitespace-nowrap">
                            @if($product->isSyncedToWordPress())
                            <span class="px-2 py-1 text-xs font-medium rounded-full bg-green-100 dark:bg-green-900/30 text-green-800 dark:text-green-300">
                                Senkronize
                            </span>
                            @else
                            <span class="px-2 py-1 text-xs font-medium rounded-full bg-gray-100 dark:bg-gray-700 text-gray-800 dark:text-gray-300">
                                Beklemede
                            </span>
                            @endif
                        </td>
                    </tr>
                    @endforeach
                </tbody>
            </table>
        </div>
    </div>
    @endif
</div>
@endsection