{{-- normes/synthesis.blade.php — Phase 6.4 (aggregate synthesis) --}}
@extends('layouts.app')

@section('content')
<TABLE border=0 cellspacing=2>
    <TR class="TR1">
        <TD CLASS=Menu COLSPAN=6 NOWRAP ALIGN=LEFT>
            <FONT SIZE=+1><i>Synthèse Norme : {{ $norme->Name }}</i></FONT>
        </TD>
    </TR>

    {{-- Aggregate summary --}}
    <TR class="TR2">
        <TH>Total panel</TH>
        <TH>Hommes</TH>
        <TH>Femmes</TH>
        <TH>Note Moy.</TH>
        <TH>Note Min</TH>
        <TH>Note Max</TH>
    </TR>
    <TR class="TR1">
        <TD ALIGN=RIGHT><B>{{ $synthesis['total_sample'] }}</B></TD>
        <TD ALIGN=RIGHT>{{ $synthesis['sex']['H'] }}</TD>
        <TD ALIGN=RIGHT>{{ $synthesis['sex']['F'] }}</TD>
        <TD ALIGN=RIGHT>{{ $synthesis['note_avg'] !== null ? number_format($synthesis['note_avg'], 2) : '-' }}</TD>
        <TD ALIGN=RIGHT>{{ $synthesis['note_min'] ?? '-' }}</TD>
        <TD ALIGN=RIGHT>{{ $synthesis['note_max'] ?? '-' }}</TD>
    </TR>

    {{-- Per-study breakdown --}}
    <TR class="TR1">
        <TD CLASS=Menu COLSPAN=6>Détail par étude</TD>
    </TR>
    <TR class="TR2">
        <TH>Étude</TH>
        <TH ALIGN=RIGHT>N</TH>
        <TH ALIGN=RIGHT>H</TH>
        <TH ALIGN=RIGHT>F</TH>
        <TH ALIGN=RIGHT>Produits notés</TH>
        <TH ALIGN=RIGHT>Moy. notes</TH>
    </TR>
    @foreach($synthesis['per_study'] as $studyId => $row)
    @php
    $s = $row['study'];
    $sample = $row['sample'];
    $notes = $row['notes'];
    $prodCount = count($notes['products'] ?? []);
    $weightedSum = 0.0; $weightedN = 0;
    foreach ($notes['products'] ?? [] as $p) {
    if (($p['n'] ?? 0) > 0 && $p['avg'] !== null) {
    $weightedSum += (float)$p['avg'] * (int)$p['n'];
    $weightedN += (int)$p['n'];
    }
    }
    $avg = $weightedN > 0 ? $weightedSum / $weightedN : null;
    @endphp
    <TR class="TR{{ $loop->index % 2 + 1 }}">
        <TD>{{ $s->Code }} — {{ $s->Name }}</TD>
        <TD ALIGN=RIGHT>{{ $sample['total'] }}</TD>
        <TD ALIGN=RIGHT>{{ $sample['sex']['H'] }}</TD>
        <TD ALIGN=RIGHT>{{ $sample['sex']['F'] }}</TD>
        <TD ALIGN=RIGHT>{{ $prodCount }}</TD>
        <TD ALIGN=RIGHT>{{ $avg !== null ? number_format($avg, 2) : '-' }}</TD>
    </TR>
    @endforeach

    @if(count($synthesis['per_study']) === 0)
    <TR class="TR2">
        <TD COLSPAN=6><i>Aucune étude IN dans cette norme.</i></TD>
    </TR>
    @endif

    <TR class="TR2">
        <TD COLSPAN=6 CLASS=Sel>
            <A HREF="{{ route('data.normes.show', $norme->Id) }}">&laquo; Retour au détail</A>
        </TD>
    </TR>
</TABLE>
@endsection