@extends('layouts.app')

@section('title', 'Finance Statistics')
@section('page_title', 'Finance Statistics')

@section('content')
<div class="mb-8">
    <!-- Filters -->
    <div class="bg-white dark:bg-gray-800 rounded-xl border border-gray-200 dark:border-gray-700 p-6 shadow-sm mb-8">
        <form method="GET" action="{{ route('finances.statistics') }}" class="grid grid-cols-1 md:grid-cols-4 gap-4">
            <div>
                <label class="block text-sm font-medium text-gray-700 dark:text-gray-300 mb-2">Period</label>
                <select name="period" class="w-full px-4 py-2 border border-gray-300 dark:border-gray-600 rounded-lg bg-white dark:bg-gray-700 text-gray-900 dark:text-white">
                    <option value="year" {{ $period === 'year' ? 'selected' : '' }}>Yearly</option>
                    <option value="quarter" {{ $period === 'quarter' ? 'selected' : '' }}>Quarterly</option>
                    <option value="custom" {{ $period === 'custom' ? 'selected' : '' }}>Custom</option>
                </select>
            </div>

            <div>
                <label class="block text-sm font-medium text-gray-700 dark:text-gray-300 mb-2">Year</label>
                <input type="number" name="year" value="{{ $year }}" class="w-full px-4 py-2 border border-gray-300 dark:border-gray-600 rounded-lg bg-white dark:bg-gray-700 text-gray-900 dark:text-white">
            </div>

            <div>
                <label class="block text-sm font-medium text-gray-700 dark:text-gray-300 mb-2">Month</label>
                <select name="month" class="w-full px-4 py-2 border border-gray-300 dark:border-gray-600 rounded-lg bg-white dark:bg-gray-700 text-gray-900 dark:text-white">
                    @for ($m = 1; $m <= 12; $m++)
                        <option value="{{ $m }}" {{ $month === $m ? 'selected' : '' }}>{{ \Carbon\Carbon::create(2000, $m, 1)->format('F') }}</option>
                    @endfor
                </select>
            </div>

            <div class="flex items-end">
                <button type="submit" class="w-full px-4 py-2 bg-blue-600 hover:bg-blue-700 text-white font-medium rounded-lg transition">
                    Generate Report
                </button>
            </div>
        </form>
    </div>

    <!-- Summary Cards -->
    <div class="grid grid-cols-1 md:grid-cols-3 gap-6 mb-8">
        <!-- Total Income -->
        <div class="bg-gradient-to-br from-green-50 to-green-100 dark:from-green-900/20 dark:to-green-900/10 rounded-xl border border-green-200 dark:border-green-800 p-6 shadow-sm">
            <div class="flex items-center justify-between mb-4">
                <h3 class="text-lg font-bold text-green-900 dark:text-green-100">Total Income</h3>
                <svg class="w-8 h-8 text-green-600" fill="none" stroke="currentColor" viewBox="0 0 24 24">
                    <path stroke-linecap="round" stroke-linejoin="round" stroke-width="2" d="M12 8c-1.657 0-3 .895-3 2s1.343 2 3 2 3 .895 3 2-1.343 2-3 2m0-8c1.11 0 2.08.402 2.599 1M12 8V7m0 1v8m0 0v1m0-1c-1.11 0-2.08-.402-2.599-1M21 12a9 9 0 11-18 0 9 9 0 0118 0z" />
                </svg>
            </div>
            <div class="text-3xl font-bold text-green-600 dark:text-green-400 mb-2">{{ number_format($totalIncome, 2) }}</div>
            <p class="text-sm text-green-700 dark:text-green-300">{{ $stats['income']['count'] }} entries</p>
        </div>

        <!-- Total Expenses -->
        <div class="bg-gradient-to-br from-red-50 to-red-100 dark:from-red-900/20 dark:to-red-900/10 rounded-xl border border-red-200 dark:border-red-800 p-6 shadow-sm">
            <div class="flex items-center justify-between mb-4">
                <h3 class="text-lg font-bold text-red-900 dark:text-red-100">Total Expenses</h3>
                <svg class="w-8 h-8 text-red-600" fill="none" stroke="currentColor" viewBox="0 0 24 24">
                    <path stroke-linecap="round" stroke-linejoin="round" stroke-width="2" d="M13 10V3L4 14h7v7l9-11h-7z" />
                </svg>
            </div>
            <div class="text-3xl font-bold text-red-600 dark:text-red-400 mb-2">{{ number_format($totalExpenses, 2) }}</div>
            <p class="text-sm text-red-700 dark:text-red-300">{{ $stats['fixed_cost']['count'] + $stats['variable_cost']['count'] }} entries</p>
        </div>

        <!-- Net Result -->
        <div class="bg-gradient-to-br {{ $netResult >= 0 ? 'from-blue-50 to-blue-100 dark:from-blue-900/20 dark:to-blue-900/10' : 'from-orange-50 to-orange-100 dark:from-orange-900/20 dark:to-orange-900/10' }} rounded-xl border {{ $netResult >= 0 ? 'border-blue-200 dark:border-blue-800' : 'border-orange-200 dark:border-orange-800' }} p-6 shadow-sm">
            <div class="flex items-center justify-between mb-4">
                <h3 class="text-lg font-bold {{ $netResult >= 0 ? 'text-blue-900 dark:text-blue-100' : 'text-orange-900 dark:text-orange-100' }}">NET Result</h3>
                <svg class="w-8 h-8 {{ $netResult >= 0 ? 'text-blue-600' : 'text-orange-600' }}" fill="none" stroke="currentColor" viewBox="0 0 24 24">
                    <path stroke-linecap="round" stroke-linejoin="round" stroke-width="2" d="M9 19v-6a2 2 0 00-2-2H5a2 2 0 00-2 2v6a2 2 0 002 2h2a2 2 0 002-2zm0 0V9a2 2 0 012-2h2a2 2 0 012 2v10m-6 0a2 2 0 002 2h2a2 2 0 002-2m0 0V5a2 2 0 012-2h2a2 2 0 012 2v14a2 2 0 01-2 2h-2a2 2 0 01-2-2z" />
                </svg>
            </div>
            <div class="text-3xl font-bold {{ $netResult >= 0 ? 'text-blue-600 dark:text-blue-400' : 'text-orange-600 dark:text-orange-400' }} mb-2">{{ $netResult >= 0 ? '+' : '' }}{{ number_format($netResult, 2) }}</div>
            <p class="text-sm {{ $netResult >= 0 ? 'text-blue-700 dark:text-blue-300' : 'text-orange-700 dark:text-orange-300' }}">{{ $title }}</p>
        </div>
    </div>

    <!-- Detailed Statistics -->
    <div class="grid grid-cols-1 lg:grid-cols-3 gap-6 mb-8">
        <!-- Income Details -->
        <div class="bg-white dark:bg-gray-800 rounded-xl border border-green-200 dark:border-green-800 p-6 shadow-sm">
            <h3 class="text-lg font-bold text-green-900 dark:text-green-100 mb-4">Income Analysis</h3>
            
            <div class="space-y-4">
                <div>
                    <p class="text-sm text-gray-600 dark:text-gray-400 mb-1">Total</p>
                    <p class="text-2xl font-bold text-green-600 dark:text-green-400">{{ number_format($stats['income']['total'], 2) }}</p>
                </div>
                <div class="border-t border-gray-200 dark:border-gray-700 pt-4">
                    <p class="text-sm text-gray-600 dark:text-gray-400 mb-1">Average per Entry</p>
                    <p class="text-xl font-semibold text-green-600 dark:text-green-400">{{ number_format($stats['income']['average'], 2) }}</p>
                </div>
                <div class="border-t border-gray-200 dark:border-gray-700 pt-4">
                    <p class="text-sm text-gray-600 dark:text-gray-400 mb-1">Number of Entries</p>
                    <p class="text-xl font-semibold text-green-600 dark:text-green-400">{{ $stats['income']['count'] }}</p>
                </div>
            </div>
        </div>

        <!-- Fixed Costs Details -->
        <div class="bg-white dark:bg-gray-800 rounded-xl border border-red-200 dark:border-red-800 p-6 shadow-sm">
            <h3 class="text-lg font-bold text-red-900 dark:text-red-100 mb-4">Fixed Costs</h3>
            
            <div class="space-y-4">
                <div>
                    <p class="text-sm text-gray-600 dark:text-gray-400 mb-1">Total</p>
                    <p class="text-2xl font-bold text-red-600 dark:text-red-400">{{ number_format($stats['fixed_cost']['total'], 2) }}</p>
                </div>
                <div class="border-t border-gray-200 dark:border-gray-700 pt-4">
                    <p class="text-sm text-gray-600 dark:text-gray-400 mb-1">Average per Entry</p>
                    <p class="text-xl font-semibold text-red-600 dark:text-red-400">{{ number_format($stats['fixed_cost']['average'], 2) }}</p>
                </div>
                <div class="border-t border-gray-200 dark:border-gray-700 pt-4">
                    <p class="text-sm text-gray-600 dark:text-gray-400 mb-1">Number of Entries</p>
                    <p class="text-xl font-semibold text-red-600 dark:text-red-400">{{ $stats['fixed_cost']['count'] }}</p>
                </div>
            </div>
        </div>

        <!-- Variable Costs Details -->
        <div class="bg-white dark:bg-gray-800 rounded-xl border border-amber-200 dark:border-amber-800 p-6 shadow-sm">
            <h3 class="text-lg font-bold text-amber-900 dark:text-amber-100 mb-4">Variable Costs</h3>
            
            <div class="space-y-4">
                <div>
                    <p class="text-sm text-gray-600 dark:text-gray-400 mb-1">Total</p>
                    <p class="text-2xl font-bold text-amber-600 dark:text-amber-400">{{ number_format($stats['variable_cost']['total'], 2) }}</p>
                </div>
                <div class="border-t border-gray-200 dark:border-gray-700 pt-4">
                    <p class="text-sm text-gray-600 dark:text-gray-400 mb-1">Average per Entry</p>
                    <p class="text-xl font-semibold text-amber-600 dark:text-amber-400">{{ number_format($stats['variable_cost']['average'], 2) }}</p>
                </div>
                <div class="border-t border-gray-200 dark:border-gray-700 pt-4">
                    <p class="text-sm text-gray-600 dark:text-gray-400 mb-1">Number of Entries</p>
                    <p class="text-xl font-semibold text-amber-600 dark:text-amber-400">{{ $stats['variable_cost']['count'] }}</p>
                </div>
            </div>
        </div>
    </div>

    <!-- Recurring Expenses -->
    @if(count($recurring) > 0)
    <div class="bg-white dark:bg-gray-800 rounded-xl border border-gray-200 dark:border-gray-700 p-6 shadow-sm">
        <h3 class="text-lg font-bold text-gray-900 dark:text-white mb-4">Recurring Expenses</h3>
        <p class="text-sm text-gray-600 dark:text-gray-400 mb-6">Expenses that appear multiple times in this period</p>
        
        <div class="overflow-x-auto">
            <table class="w-full text-sm">
                <thead>
                    <tr class="border-b border-gray-200 dark:border-gray-700">
                        <th class="text-left py-3 px-4 text-gray-700 dark:text-gray-300 font-semibold">Description</th>
                        <th class="text-left py-3 px-4 text-gray-700 dark:text-gray-300 font-semibold">Category</th>
                        <th class="text-center py-3 px-4 text-gray-700 dark:text-gray-300 font-semibold">Occurrences</th>
                        <th class="text-right py-3 px-4 text-gray-700 dark:text-gray-300 font-semibold">Average</th>
                        <th class="text-right py-3 px-4 text-gray-700 dark:text-gray-300 font-semibold">Total</th>
                    </tr>
                </thead>
                <tbody class="divide-y divide-gray-200 dark:divide-gray-700">
                    @foreach($recurring as $expense)
                    <tr class="hover:bg-gray-50 dark:hover:bg-gray-700/50">
                        <td class="py-3 px-4 text-gray-900 dark:text-gray-100 font-medium">{{ $expense['description'] }}</td>
                        <td class="py-3 px-4">
                            <span class="px-2 py-1 rounded text-xs font-semibold 
                                {{ $expense['category'] === 'fixed_cost' ? 'bg-red-100 dark:bg-red-900/30 text-red-700 dark:text-red-300' : 'bg-amber-100 dark:bg-amber-900/30 text-amber-700 dark:text-amber-300' }}">
                                {{ $expense['category'] === 'fixed_cost' ? 'Fixed' : 'Variable' }}
                            </span>
                        </td>
                        <td class="py-3 px-4 text-center text-gray-700 dark:text-gray-300">{{ $expense['occurrences'] }}x</td>
                        <td class="py-3 px-4 text-right font-semibold text-gray-900 dark:text-gray-100">{{ number_format($expense['average'], 2) }}</td>
                        <td class="py-3 px-4 text-right font-bold {{ $expense['category'] === 'fixed_cost' ? 'text-red-600 dark:text-red-400' : 'text-amber-600 dark:text-amber-400' }}">
                            {{ number_format($expense['total'], 2) }}
                        </td>
                    </tr>
                    @endforeach
                </tbody>
            </table>
        </div>
    </div>
    @endif
</div>

<a href="{{ route('finances.index') }}" class="text-blue-600 dark:text-blue-400 hover:text-blue-700 dark:hover:text-blue-300 font-semibold">← Back to Finances</a>

@endsection