{{-- study/import.blade.php — Phase 5.7 --}}
@extends('layouts.app')

@section('content')
<TABLE border=0 cellspacing=2 width=95%>
    <TR class="TR1">
        <TD CLASS=Menu COLSPAN=6 ALIGN=LEFT>
            <FONT SIZE=+1><i>Import Excel — {{ $study->Code }} — {{ $study->Name }}</i></FONT>
        </TD>
    </TR>

    @if(session('success'))<TR>
        <TD CLASS=green COLSPAN=6>{{ session('success') }}</TD>
    </TR>@endif
    @if($errors->any())
    <TR>
        <TD CLASS=red COLSPAN=6>
            @foreach($errors->all() as $e)<B>{{ $e }}</B><BR>@endforeach
        </TD>
    </TR>
    @endif

    <TR class="TR2">
        <TD COLSPAN=6 CLASS=Sel>
            <A HREF="{{ route('kms.study.input', $study->Id) }}">Input</A> |
            <B class="Menu">Import</B>
        </TD>
    </TR>

    {{-- Upload form --}}
    @if(!$preview && !$result)
    <TR class="TR1">
        <TD COLSPAN=6 CLASS=Menu>1. Téléverser le fichier XLS/XLSX/CSV</TD>
    </TR>
    <TR class="TR2">
        <TD COLSPAN=6>
            <FORM METHOD=POST ACTION="{{ route('kms.study.input.import.preview', $study->Id) }}" ENCTYPE="multipart/form-data">
                @csrf
                <INPUT TYPE=FILE NAME="file" ACCEPT=".xls,.xlsx,.csv" REQUIRED>
                <INPUT TYPE=SUBMIT VALUE="Prévisualiser">
            </FORM>
            <br><i>En-tête attendu : <code>Global_PRENOM, Global_SEXE, Global_AGE, Global_LIEU, PrdIdXXXX_NOTE, PrdIdXXXX_ADJ_1..10, PrdIdXXXX_Quan_01..22, PrdIdXXXX_PORTRAIT_L..S, PrdIdXXXX_CHIN_C..E, PrdIdXXXX_COT_X_Y</code></i>
        </TD>
    </TR>
    @endif

    {{-- Preview --}}
    @if($preview)
    <TR class="TR1">
        <TD COLSPAN=6 CLASS=Menu>2. Prévisualisation — colonnes détectées</TD>
    </TR>
    <TR class="TR2">
        <TD COLSPAN=6>
            <TABLE border=1 cellspacing=0 cellpadding=3>
                <TR class="TR1">
                    <TH>#</TH>
                    <TH>En-tête Excel</TH>
                    <TH>Cible</TH>
                </TR>
                @foreach($preview['headers'] as $i => $header)
                <TR class="TR{{ $i % 2 + 1 }}">
                    <TD ALIGN=RIGHT>{{ $i + 1 }}</TD>
                    <TD><B>{{ $header }}</B></TD>
                    <TD>
                        @php $m = $preview['mapping'][$i] ?? null; @endphp
                        @if($m)
                        <span style="color:green">
                            {{ $m['kind'] }}
                            @if(!empty($m['product_id'])) · product={{ $m['product_id'] }} @endif
                            @if(!empty($m['field'])) · field={{ $m['field'] }} @endif
                            @if(!empty($m['code'])) · code={{ $m['code'] }} @endif
                            @if(!empty($m['sub'])) · {{ $m['sub'] }} @endif
                            @if(!empty($m['cot_type'])) · cotType={{ $m['cot_type'] }} @endif
                        </span>
                        @else
                        <span style="color:red">ignorée</span>
                        @endif
                    </TD>
                </TR>
                @endforeach
            </TABLE>

            @if(!empty($preview['unknown']))
            <br><B style="color:red">En-têtes non reconnus :</B>
            <UL>@foreach($preview['unknown'] as $u)<LI>{{ $u }}</LI>@endforeach</UL>
            @endif

            <br>
            <B>Aperçu des {{ count($preview['rows']) }} premières lignes :</B>
            <TABLE border=1 cellspacing=0 cellpadding=2>
                <TR class="TR1">
                    @foreach($preview['headers'] as $h)<TH>{{ $h }}</TH>@endforeach
                </TR>
                @foreach($preview['rows'] as $row)
                <TR class="TR{{ $loop->index % 2 + 1 }}">
                    @foreach($preview['headers'] as $i => $h)
                    <TD>{{ $row[$i] ?? '' }}</TD>
                    @endforeach
                </TR>
                @endforeach
            </TABLE>
        </TD>
    </TR>

    <TR class="TR1">
        <TD COLSPAN=6 CLASS=Menu>3. Confirmer et importer</TD>
    </TR>
    <TR class="TR2">
        <TD COLSPAN=6>
            <FORM METHOD=POST ACTION="{{ route('kms.study.input.import.execute', $study->Id) }}"
                onsubmit="return confirm('Lancer l\'import définitif ?');">
                @csrf
                <INPUT TYPE=HIDDEN NAME="token" VALUE="{{ $token }}">
                <INPUT TYPE=SUBMIT VALUE="Lancer l'import">
                <A HREF="{{ route('kms.study.input.import', $study->Id) }}">Annuler</A>
            </FORM>
        </TD>
    </TR>
    @endif

    {{-- Result --}}
    @if($result)
    <TR class="TR1">
        <TD COLSPAN=6 CLASS=Menu>Résultat</TD>
    </TR>
    <TR class="TR2">
        <TD COLSPAN=6>
            <B style="color:green">{{ $result['imported'] }} interview(s) importée(s).</B>
            @if(!empty($result['errors']))
            <br><B style="color:red">Erreurs :</B>
            <UL>@foreach($result['errors'] as $e)<LI>{{ $e }}</LI>@endforeach</UL>
            @endif
            <br><A HREF="{{ route('kms.study.input', $study->Id) }}">&laquo; Retour Input</A>
        </TD>
    </TR>
    @endif
</TABLE>
@endsection