@extends('layouts.mainlayout')
@section('fullwidth', true)
@section('content')
@php
    $farms = [
        '2' => 'Ahus',
        '9' => 'Trelleborg',
        '6' => 'Bastad',
        '10' => 'Vellinge',
        '14' => 'Skottorp',
    ];
    $activeFarmName = $farms[(string) $f_id] ?? 'Farm';

    $latestIds = DB::table('a_stat')
        ->where('f_id', $f_id)
        ->select(DB::raw('MAX(id) AS id'))
        ->groupBy('year', 'name')
        ->pluck('id');

    $statsByYear = DB::table('a_stat')
        ->whereIn('id', $latestIds)
        ->orderByDesc('year')
        ->get()
        ->groupBy('year');

    $currentYear = (string) ($statsByYear->keys()->first() ?? date('Y'));
    $currentRows = $statsByYear->get($currentYear, collect());
    $rowByName = $currentRows->keyBy('name');
    $totalRow = $rowByName->get('Totat');
    $totalContracts = (int) ($totalRow->cr ?? 0);
    $totalDays = (int) ($totalRow->days ?? 0);
    $averageDays = $totalContracts > 0 ? round($totalDays / $totalContracts, 1) : 0;

    $labels = [
        'New' => 'New contracts',
        'Returning' => 'Returning contracts',
        'Older' => 'Older contracts',
        'Totat' => 'Total',
        'Total 1- 30' => '1–30 days',
        'Total 31-60' => '31–60 days',
        'Total 61- 90' => '61–90 days',
        'Total 91-120' => '91–120 days',
        'Total 121+' => '121+ days',
    ];

    $relationshipNames = ['New', 'Returning', 'Older'];
    $durationNames = ['Total 1- 30', 'Total 31-60', 'Total 61- 90', 'Total 91-120', 'Total 121+'];
    $trendYears = $statsByYear->keys()->sort()->values();
    $trendContracts = $trendYears->map(function ($statYear) use ($statsByYear) {
        $total = $statsByYear->get($statYear)->firstWhere('name', 'Totat');
        return (int) ($total->cr ?? 0);
    });
    $trendAverage = $trendYears->map(function ($statYear) use ($statsByYear) {
        $total = $statsByYear->get($statYear)->firstWhere('name', 'Totat');
        $contracts = (int) ($total->cr ?? 0);
        return $contracts > 0 ? round(((int) $total->days) / $contracts, 1) : 0;
    });

    $chartData = [
        'relationship' => [
            'labels' => collect($relationshipNames)->map(fn ($name) => $labels[$name])->values(),
            'series' => collect($relationshipNames)->map(fn ($name) => (int) optional($rowByName->get($name))->cr)->values(),
        ],
        'duration' => [
            'categories' => collect($durationNames)->map(fn ($name) => $labels[$name])->values(),
            'contracts' => collect($durationNames)->map(fn ($name) => (int) optional($rowByName->get($name))->cr)->values(),
        ],
        'trend' => [
            'years' => $trendYears,
            'contracts' => $trendContracts,
            'averageDays' => $trendAverage,
        ],
    ];
@endphp

<div class="smarthr-farm-stat">
    <header class="farm-stat-heading smarthr-demo-page-breadcrumb smarthr-module-page-header">
        <div>
            <h2>Farm statistics</h2>
            <ol><li><a href="/home"><i class="fas fa-home"></i></a></li><li>Statistics</li><li class="active">{{ $activeFarmName }}</li></ol>
        </div>
        <a href="{{ route('farm_days_stat.csv', ['f_id' => $f_id]) }}" class="farm-stat-export">
            <i class="fas fa-download"></i><span>Download CSV</span>
        </a>
    </header>

    <nav class="farm-stat-tabs" aria-label="Choose farm">
        @foreach($farms as $farmId => $farmName)
            <a href="/farm_days_stat/{{ $farmId }}" class="{{ (string) $f_id === $farmId ? 'active' : '' }}">
                <i class="fas fa-seedling"></i>{{ $farmName }}
            </a>
        @endforeach
    </nav>

    <section class="farm-stat-kpis" aria-label="{{ $currentYear }} summary">
        <article class="farm-stat-kpi orange">
            <span class="farm-stat-kpi-icon"><i class="fas fa-file-signature"></i></span>
            <div><span>Total contracts</span><strong>{{ number_format($totalContracts) }}</strong><small>{{ $currentYear }}</small></div>
        </article>
        <article class="farm-stat-kpi navy">
            <span class="farm-stat-kpi-icon"><i class="far fa-calendar-check"></i></span>
            <div><span>Total work days</span><strong>{{ number_format($totalDays) }}</strong><small>{{ $currentYear }}</small></div>
        </article>
        <article class="farm-stat-kpi green">
            <span class="farm-stat-kpi-icon"><i class="fas fa-chart-line"></i></span>
            <div><span>Average duration</span><strong>{{ number_format($averageDays, 1) }}</strong><small>days per contract</small></div>
        </article>
        <article class="farm-stat-kpi purple">
            <span class="farm-stat-kpi-icon"><i class="fas fa-history"></i></span>
            <div><span>History available</span><strong>{{ $statsByYear->count() }}</strong><small>years tracked</small></div>
        </article>
    </section>

    @if($statsByYear->isEmpty())
        <section class="farm-stat-empty">
            <i class="far fa-chart-bar"></i>
            <h2>No statistics available</h2>
            <p>There are no contract statistics for {{ $activeFarmName }} yet.</p>
        </section>
    @else
        <section class="farm-stat-chart-grid">
            <article class="farm-stat-card">
                <div class="farm-stat-card-head"><div><span>Contract mix</span><h2>Workforce relationship</h2></div><em>{{ $currentYear }}</em></div>
                <div id="farm-stat-relationship-chart" class="farm-stat-chart"></div>
            </article>
            <article class="farm-stat-card">
                <div class="farm-stat-card-head"><div><span>Contract length</span><h2>Duration distribution</h2></div><em>{{ $currentYear }}</em></div>
                <div id="farm-stat-duration-chart" class="farm-stat-chart"></div>
            </article>
            <article class="farm-stat-card farm-stat-trend-card">
                <div class="farm-stat-card-head"><div><span>Historical view</span><h2>Contracts and average duration</h2></div><em>{{ $trendYears->first() }}–{{ $trendYears->last() }}</em></div>
                <div id="farm-stat-trend-chart" class="farm-stat-chart"></div>
            </article>
        </section>

        <section class="farm-stat-history">
            <div class="farm-stat-section-head">
                <div><span>Detailed statistics</span><h2>Yearly breakdown</h2></div>
                <p>Contracts, total days, and average days per contract.</p>
            </div>
            <div class="farm-stat-year-grid">
                @foreach($statsByYear as $statYear => $rows)
                    <article class="farm-stat-year-card {{ (string) $statYear === $currentYear ? 'current' : '' }}">
                        <div class="farm-stat-year-head">
                            <h3>{{ $statYear }}</h3>
                            @if((string) $statYear === $currentYear)<span>Latest</span>@endif
                        </div>
                        <div class="farm-stat-table-wrap">
                            <table>
                                <thead><tr><th>Category</th><th>Contracts</th><th>Days</th><th>Avg.</th></tr></thead>
                                <tbody>
                                @foreach($rows as $row)
                                    @php $avg = (int) $row->cr > 0 ? round((int) $row->days / (int) $row->cr, 1) : 0; @endphp
                                    <tr class="{{ $row->name === 'Totat' ? 'total' : '' }}">
                                        <td>{{ $labels[$row->name] ?? $row->name }}</td>
                                        <td>{{ number_format((int) $row->cr) }}</td>
                                        <td>{{ number_format((int) $row->days) }}</td>
                                        <td>{{ number_format($avg, 1) }}</td>
                                    </tr>
                                @endforeach
                                </tbody>
                            </table>
                        </div>
                    </article>
                @endforeach
            </div>
        </section>
    @endif
</div>

<script id="farm-stat-chart-data" type="application/json">@json($chartData)</script>
<script src="/vendor/apexcharts/apexcharts.min.js?v=0.4.0"></script>
<script src="/js/smarthr-farm-stat.js?v=0.4.0"></script>
@endsection