@extends('layouts.app')

@section('title', 'Mapear colunas XLSX')

@section('content')
@php($opts = $dataImport->options ?? [])
<div class="page-header">
    <div>
        <h1>Mapear colunas</h1>
        <p class="muted"><strong>{{ $dataImport->original_name }}</strong> · {{ $preview['total_rows'] }} linha(s) de dados · {{ $preview['total_columns'] }} coluna(s)</p>
    </div>
    <div class="actions">
        <a class="btn btn-secondary" href="{{ route('imports.show', $dataImport) }}">Detalhes</a>
        <a class="btn btn-secondary" href="{{ route('imports.index') }}">Importações</a>
    </div>
</div>

<div class="grid grid-2" style="margin-bottom:18px">
    <div class="card">
        <h3>Folha e cabeçalho</h3>
        <form method="get" action="{{ route('imports.mapping', $dataImport) }}" class="form-row">
            <label>Folha
                <select name="sheet">
                    @foreach($sheets as $sheet)
                        <option value="{{ $sheet['name'] }}" @selected($sheetName === $sheet['name'])>{{ $sheet['name'] }} — {{ $sheet['totalRows'] }} linhas × {{ $sheet['totalColumns'] }} colunas</option>
                    @endforeach
                </select>
            </label>
            <label>Linha do cabeçalho
                <input type="number" min="1" max="200" name="header_row" value="{{ $headerRow }}">
            </label>
            <div><button class="btn btn-secondary" type="submit">Reanalisar</button></div>
        </form>
    </div>
    <div class="card">
        <h3>Aplicar template</h3>
        @if($templates->isEmpty())
            <p class="muted">Ainda não existem templates para este tipo de dados.</p>
        @else
            <form method="post" id="template-form" class="form-grid">
                @csrf
                <input type="hidden" name="sheet_name" value="{{ $sheetName }}">
                <input type="hidden" name="header_row" value="{{ $headerRow }}">
                <label>Template
                    <select id="template-select" required>
                        <option value="">Selecionar…</option>
                        @foreach($templates as $template)
                            <option value="{{ route('imports.templates.apply', [$dataImport, $template]) }}">{{ $template->name }}</option>
                        @endforeach
                    </select>
                </label>
                <div><button class="btn btn-secondary" type="submit">Aplicar e rever</button></div>
            </form>
        @endif
    </div>
</div>

<form method="post" action="{{ route('imports.configure', $dataImport) }}" class="card">
    @csrf @method('put')
    <input type="hidden" name="sheet_name" value="{{ $sheetName }}">
    <input type="hidden" name="header_row" value="{{ $headerRow }}">

    <div class="page-header">
        <div>
            <h2>Correspondência de colunas</h2>
            <p class="muted">Pode selecionar vários destinos na mesma coluna. Também pode mapear várias colunas para o mesmo destino; os textos serão unidos pelo separador indicado.</p>
        </div>
    </div>
    <div class="table-wrap">
        <table class="mapping-table">
            <thead><tr><th>Coluna</th><th>Cabeçalho e amostra</th><th>Campos de destino</th><th>Conversão</th><th>Regras</th></tr></thead>
            <tbody>
            @foreach($preview['headers'] as $column => $header)
                @php
                    $current = old('columns.'.$column, $columnMappings[$column] ?? ['targets'=>[], 'transform'=>'auto', 'required'=>false, 'separator'=>' ']);
                    $selectedTargets = (array)($current['targets'] ?? []);
                    $samples = [];
                    foreach($preview['rows'] as $row) {
                        $value = $row[$column] ?? null;
                        if($value !== null && $value !== '' && count($samples) < 3) $samples[] = $value;
                    }
                @endphp
                <tr>
                    <td><span class="badge">{{ $column }}</span></td>
                    <td>
                        <div class="source-header">{{ $header }}</div>
                        @if($samples)
                            <ul class="sample-list">
                                @foreach($samples as $sample)<li>{{ \Illuminate\Support\Str::limit((string)$sample, 90) }}</li>@endforeach
                            </ul>
                        @else
                            <span class="muted">Sem valores na amostra</span>
                        @endif
                    </td>
                    <td>
                        <select class="mapping-targets" multiple name="columns[{{ $column }}][targets][]">
                            @foreach($groups as $group => $fields)
                                <optgroup label="{{ $group }}">
                                    @foreach($fields as $key => $field)
                                        <option value="{{ $key }}" @selected(in_array($key, $selectedTargets, true))>{{ $field['label'] }}</option>
                                    @endforeach
                                </optgroup>
                            @endforeach
                        </select>
                        <div class="muted" style="font-size:12px;margin-top:5px">Ctrl/Cmd + clique para selecionar vários.</div>
                    </td>
                    <td>
                        <select name="columns[{{ $column }}][transform]">
                            @foreach($transforms as $transform)
                                <option value="{{ $transform }}" @selected(($current['transform'] ?? 'auto') === $transform)>{{ $transform }}</option>
                            @endforeach
                        </select>
                    </td>
                    <td>
                        <label class="checkbox"><input type="checkbox" name="columns[{{ $column }}][required]" value="1" @checked((bool)($current['required'] ?? false))> Obrigatória</label>
                        <label style="margin-top:10px">Separador
                            <input type="text" maxlength="10" name="columns[{{ $column }}][separator]" value="{{ $current['separator'] ?? ' ' }}">
                        </label>
                    </td>
                </tr>
            @endforeach
            </tbody>
        </table>
    </div>

    <h2 style="margin-top:26px">Valores fixos</h2>
    <p class="muted">Use-os para preencher um campo com o mesmo valor em todas as linhas, por exemplo o ano letivo.</p>
    <div class="table-wrap">
        <table>
            <thead><tr><th>Campo</th><th>Valor</th><th>Conversão</th></tr></thead>
            <tbody>
            @foreach($constants as $index => $constant)
                @php($constant = old('constants.'.$index, $constant))
                <tr>
                    <td>
                        <select name="constants[{{ $index }}][target]">
                            <option value="">Não utilizar</option>
                            @foreach($groups as $group => $fields)
                                <optgroup label="{{ $group }}">
                                    @foreach($fields as $key => $field)
                                        <option value="{{ $key }}" @selected(($constant['target'] ?? '') === $key)>{{ $field['label'] }}</option>
                                    @endforeach
                                </optgroup>
                            @endforeach
                        </select>
                    </td>
                    <td><input type="text" name="constants[{{ $index }}][value]" value="{{ $constant['constant'] ?? $constant['value'] ?? '' }}"></td>
                    <td>
                        <select name="constants[{{ $index }}][transform]">
                            @foreach($transforms as $transform)<option value="{{ $transform }}" @selected(($constant['transform'] ?? 'auto') === $transform)>{{ $transform }}</option>@endforeach
                        </select>
                    </td>
                </tr>
            @endforeach
            </tbody>
        </table>
    </div>

    <h2 style="margin-top:26px">Regras da importação</h2>
    <div class="form-grid">
        <div class="form-row">
            <label>Operação
                <select name="operation">
                    <option value="upsert" @selected(old('operation',$dataImport->operation) === 'upsert')>Criar em falta e atualizar existentes</option>
                    <option value="insert" @selected(old('operation',$dataImport->operation) === 'insert')>Criar apenas novos</option>
                    <option value="update" @selected(old('operation',$dataImport->operation) === 'update')>Atualizar apenas existentes</option>
                </select>
            </label>
            <label>Identificador principal
                <select name="identifier_field">
                    <option value="student.student_number" @selected(old('identifier_field',$dataImport->identifier_field) === 'student.student_number')>Nº Utente</option>
                    <option value="dossier.external_reference" @selected(old('identifier_field',$dataImport->identifier_field) === 'dossier.external_reference')>Referência externa do dossiê</option>
                </select>
            </label>
        </div>
        <div class="form-row">
            <label>Identificador repetido ou conflito
                <select name="duplicate_strategy">
                    <option value="error" @selected(old('duplicate_strategy',$dataImport->duplicate_strategy) === 'error')>Registar erro</option>
                    <option value="skip" @selected(old('duplicate_strategy',$dataImport->duplicate_strategy) === 'skip')>Ignorar a linha</option>
                </select>
            </label>
            <label>Campos vazios ao atualizar
                <select name="empty_value_policy">
                    <option value="preserve" @selected(old('empty_value_policy',$opts['empty_value_policy'] ?? 'preserve') === 'preserve')>Manter o valor atual</option>
                    <option value="clear" @selected(old('empty_value_policy',$opts['empty_value_policy'] ?? 'preserve') === 'clear')>Limpar o valor atual</option>
                </select>
            </label>
        </div>
        <div class="form-row">
            <label>Valor inválido opcional
                <select name="invalid_value_policy">
                    <option value="warn_skip" @selected(old('invalid_value_policy',$opts['invalid_value_policy'] ?? 'warn_skip') === 'warn_skip')>Ignorar o campo e avisar</option>
                    <option value="error" @selected(old('invalid_value_policy',$opts['invalid_value_policy'] ?? 'warn_skip') === 'error')>Invalidar a linha</option>
                </select>
            </label>
            <label>Máximo de linhas nesta execução
                <input type="number" min="1" max="{{ config('imports.max_rows') }}" name="max_rows" value="{{ old('max_rows', min($preview['total_rows'], config('imports.max_rows'))) }}">
            </label>
        </div>
        <div class="form-row">
            <label>Sala forçada
                <select name="forced_room_id">
                    <option value="">Usar a sala indicada em cada linha</option>
                    @foreach($rooms as $room)
                        <option value="{{ $room->id }}" @selected((string)old('forced_room_id',$opts['forced_room_id'] ?? '') === (string)$room->id)>[{{ $room->code ?: '—' }}] {{ $room->name }} — {{ $room->school_year }}</option>
                    @endforeach
                </select>
            </label>
            <label>Ano letivo por defeito
                <input type="text" name="forced_school_year" maxlength="20" placeholder="2026/2027" value="{{ old('forced_school_year',$opts['forced_school_year'] ?? '') }}">
            </label>
        </div>
        <div class="actions">
            <input type="hidden" name="create_rooms" value="0"><label class="checkbox"><input type="checkbox" name="create_rooms" value="1" @checked((bool)old('create_rooms',$opts['create_rooms'] ?? true))> Criar salas em falta</label>
            <input type="hidden" name="uppercase_names" value="0"><label class="checkbox"><input type="checkbox" name="uppercase_names" value="1" @checked((bool)old('uppercase_names',$opts['uppercase_names'] ?? true))> Uniformizar nomes em MAIÚSCULAS</label>
        </div>
    </div>

    <h2 style="margin-top:26px">Template reutilizável</h2>
    <div class="form-row">
        <label class="checkbox"><input type="checkbox" name="save_template" value="1" @checked(old('save_template'))> Guardar este mapeamento e estas regras</label>
        <label>Nome do template<input type="text" name="template_name" maxlength="190" value="{{ old('template_name') }}" placeholder="Ex.: Importação anual de utentes"></label>
    </div>

    <div class="sticky-actions actions">
        <button class="btn btn-secondary" type="submit" name="action_mode" value="validate">Validar sem gravar</button>
        <button class="btn btn-primary" type="submit" name="action_mode" value="import" onclick="return confirm('Confirmar a importação? Recomenda-se validar primeiro e manter uma cópia de segurança.')">Executar importação</button>
    </div>
</form>
@endsection

@push('scripts')
<script>
(() => {
    const form = document.getElementById('template-form');
    const select = document.getElementById('template-select');
    if (form && select) {
        form.addEventListener('submit', event => {
            if (!select.value) { event.preventDefault(); return; }
            form.action = select.value;
        });
    }
})();
</script>
@endpush