@extends('layouts.app')

@section('content')
<div class="container">
    <div class="row">
        <div class="col-12">
            <div class="d-flex justify-content-between align-items-center mb-4">
                <h1 class="h3 mb-0">
                    <i class="fas fa-chart-bar me-2"></i>Statistici Prezență și Cheltuieli
                </h1>
                <a href="{{ route('attendance.index') }}" class="btn btn-outline-primary">
                    <i class="fas fa-arrow-left me-1"></i>Înapoi la Prezență
                </a>
            </div>
        </div>
    </div>

    <!-- Month/Year Selector -->
    <div class="row mb-4">
        <div class="col-md-6">
            <div class="card">
                <div class="card-body">
                    <form method="GET" action="{{ route('attendance.statistics') }}">
                        <div class="row align-items-end">
                            <div class="col-md-4">
                                <label for="month" class="form-label">Luna:</label>
                                <select class="form-select" id="month" name="month">
                                    @for($i = 1; $i <= 12; $i++)
                                        <option value="{{ $i }}" {{ $month == $i ? 'selected' : '' }}>
                                            {{ \Carbon\Carbon::create()->month($i)->format('F') }}
                                        </option>
                                    @endfor
                                </select>
                            </div>
                            <div class="col-md-4">
                                <label for="year" class="form-label">Anul:</label>
                                <select class="form-select" id="year" name="year">
                                    @for($i = now()->year - 2; $i <= now()->year + 1; $i++)
                                        <option value="{{ $i }}" {{ $year == $i ? 'selected' : '' }}>
                                            {{ $i }}
                                        </option>
                                    @endfor
                                </select>
                            </div>
                            <div class="col-md-4">
                                <button type="submit" class="btn btn-primary">
                                    <i class="fas fa-search me-1"></i>Filtrează
                                </button>
                            </div>
                        </div>
                    </form>
                </div>
            </div>
        </div>
        <div class="col-md-6">
            <div class="card">
                <div class="card-body">
                    <h6 class="card-title">Informații</h6>
                    <p class="card-text mb-1">
                        <strong>Perioada:</strong> {{ \Carbon\Carbon::create()->month($month)->format('F') }} {{ $year }}
                    </p>
                    <p class="card-text mb-1">
                        <strong>Tarif zilnic:</strong> {{ $currentRate ? $currentRate->value . ' RON' : 'Nu este setat' }}
                    </p>
                    <p class="card-text mb-0">
                        <strong>Total copii:</strong> {{ count($statistics) }}
                    </p>
                </div>
            </div>
        </div>
    </div>

    @if(count($statistics) > 0)
        <div class="row">
            @foreach($statistics as $stat)
                <div class="col-md-6 col-lg-4 mb-4">
                    <div class="card h-100">
                        <div class="card-body">
                            <div class="d-flex justify-content-between align-items-start mb-3">
                                <div>
                                    <h5 class="card-title mb-1">{{ $stat['child']->full_name }}</h5>
                                    <p class="text-muted small mb-0">
                                        <i class="fas fa-users me-1"></i>{{ $stat['child']->group->name ?? 'Fără grup' }}
                                    </p>
                                </div>
                                <span class="badge bg-primary">{{ $stat['child']->age }} ani</span>
                            </div>

                            <div class="row text-center mb-3">
                                <div class="col-4">
                                    <div class="border rounded p-2">
                                        <div class="h5 mb-0 text-success">{{ $stat['present_days'] }}</div>
                                        <small class="text-muted">Prezențe</small>
                                    </div>
                                </div>
                                <div class="col-4">
                                    <div class="border rounded p-2">
                                        <div class="h5 mb-0 text-danger">{{ $stat['absent_days'] }}</div>
                                        <small class="text-muted">Absențe</small>
                                    </div>
                                </div>
                                <div class="col-4">
                                    <div class="border rounded p-2">
                                        <div class="h5 mb-0 text-info">{{ $stat['total_days'] }}</div>
                                        <small class="text-muted">Total</small>
                                    </div>
                                </div>
                            </div>

                            <div class="mb-3">
                                <div class="progress mb-2" style="height: 8px;">
                                    <div class="progress-bar bg-success" 
                                         style="width: {{ $stat['total_days'] > 0 ? ($stat['present_days'] / $stat['total_days']) * 100 : 0 }}%"></div>
                                </div>
                                <small class="text-muted">
                                    Prezență: {{ $stat['total_days'] > 0 ? round(($stat['present_days'] / $stat['total_days']) * 100, 1) : 0 }}%
                                </small>
                            </div>

                            <div class="card bg-light">
                                <div class="card-body py-2">
                                    <div class="d-flex justify-content-between align-items-center">
                                        <span class="small text-muted">Cheltuială totală:</span>
                                        <strong class="text-primary">{{ $stat['total_cost'] }} RON</strong>
                                    </div>
                                    <div class="d-flex justify-content-between align-items-center">
                                        <span class="small text-muted">Tarif zilnic:</span>
                                        <span class="small">{{ $stat['daily_cost'] }} RON</span>
                                    </div>
                                </div>
                            </div>

                            <div class="mt-3">
                                <a href="{{ route('attendance.show', $stat['child']) }}" class="btn btn-outline-primary btn-sm w-100">
                                    <i class="fas fa-eye me-1"></i>Vezi Istoric
                                </a>
                            </div>
                        </div>
                    </div>
                </div>
            @endforeach
        </div>

        <!-- Summary Card -->
        <div class="row mt-4">
            <div class="col-12">
                <div class="card">
                    <div class="card-header">
                        <h5 class="mb-0">Rezumat {{ \Carbon\Carbon::create()->month($month)->format('F') }} {{ $year }}</h5>
                    </div>
                    <div class="card-body">
                        <div class="row text-center">
                            <div class="col-md-3">
                                <div class="border rounded p-3">
                                    <div class="h4 mb-0 text-success">{{ collect($statistics)->sum('present_days') }}</div>
                                    <small class="text-muted">Total Prezențe</small>
                                </div>
                            </div>
                            <div class="col-md-3">
                                <div class="border rounded p-3">
                                    <div class="h4 mb-0 text-danger">{{ collect($statistics)->sum('absent_days') }}</div>
                                    <small class="text-muted">Total Absențe</small>
                                </div>
                            </div>
                            <div class="col-md-3">
                                <div class="border rounded p-3">
                                    <div class="h4 mb-0 text-info">{{ collect($statistics)->sum('total_days') }}</div>
                                    <small class="text-muted">Total Zile</small>
                                </div>
                            </div>
                            <div class="col-md-3">
                                <div class="border rounded p-3">
                                    <div class="h4 mb-0 text-primary">{{ collect($statistics)->sum('total_cost') }} RON</div>
                                    <small class="text-muted">Total Cheltuieli</small>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    @else
        <div class="row">
            <div class="col-12">
                <div class="text-center py-5">
                    <i class="fas fa-chart-bar fa-3x text-muted mb-3"></i>
                    <h4 class="text-muted">Nu există date pentru această perioadă</h4>
                    <p class="text-muted">Nu aveți copii aprobați sau nu există înregistrări de prezență pentru perioada selectată.</p>
                </div>
            </div>
        </div>
    @endif
</div>
@endsection