@extends('layouts.admin')
@section('title', __('excel.preview_title'))
@section('content')
<div class="page-header"><div><h1>{{ __('excel.preview_title') }} #{{ $batch->id }}</h1><p>{{ data_get($batch->metadata, 'filename') }}</p></div><a class="button" href="{{ route('admin.excel.index') }}">{{ __('excel.new_import') }}</a></div>
<div class="stats-grid">
    <div class="stat-card"><span>{{ __('excel.entities') }}</span><strong>{{ $batch->candidates_created }}</strong></div>
    <div class="stat-card"><span>{{ __('excel.imported') }}</span><strong>{{ $batch->candidates_resolved }}</strong></div>
    <div class="stat-card"><span>{{ __('excel.fields_to_review') }}</span><strong>{{ count($fieldIssues) }}</strong></div>
    <div class="stat-card"><span>{{ __('excel.sheets') }}</span><strong>{{ count(data_get($batch->metadata, 'sheets', [])) }}</strong></div>
</div>
@if(! data_get($batch->metadata, 'applied_at'))<div class="alert">{{ __('excel.preview_only') }}</div>@endif
<section class="panel">
    <div class="panel-header"><div><h2>{{ __('excel.entities') }}</h2><p class="panel-hint">{{ __('excel.entities_help') }}</p></div></div>
    <div class="table-wrap table-wrap-inner"><table><thead><tr><th>{{ __('admin.labels.name') }}</th><th>{{ __('admin.labels.type') }}</th><th>{{ __('excel.planned_action') }}</th><th>{{ __('excel.fields') }}</th></tr></thead><tbody>
    @foreach($batch->candidates as $candidate)
        @php($disposition = $dispositions[$candidate->id])
        <tr><td><a href="{{ route('admin.ingestion.candidates.show', $candidate) }}">{{ $candidate->name }}</a>@if(data_get($candidate->normalized_payload, 'excel.implicit_parent'))<small>{{ __('excel.minimal_parent') }}</small>@endif</td><td>{{ __('excel.types.'.$candidate->entity_type) }}</td><td>{{ __('excel.actions.'.$disposition['action']) }}<small>{{ __('excel.reasons.'.$disposition['reason']) }}</small></td><td>{{ $candidate->values->count() }}</td></tr>
    @endforeach
    </tbody></table></div>
    @if(auth()->user()->role !== 'reader')
    <form method="post" action="{{ route('admin.excel.apply', $batch) }}" class="form-stack detail-extra">
        @csrf
        <label class="check-option"><input type="checkbox" name="confirm" value="1" required><span>{{ __('excel.confirm') }}</span></label>
        <div class="button-row"><button class="button button-primary" type="submit">{{ data_get($batch->metadata, 'applied_at') ? __('excel.resume') : __('excel.import') }}</button><a class="button" href="{{ route('admin.ingestion.batches.show', $batch) }}">{{ __('excel.open_batch') }}</a></div>
    </form>
    @endif
</section>
@if(count($fieldIssues) || count(data_get($batch->metadata, 'issues', [])) || count(data_get($batch->metadata, 'identifier_issues', [])) || collect($dispositions)->contains(fn ($entry) => $entry['action'] === 'review'))
<section class="panel detail-extra">
    <div class="panel-header"><div><h2>{{ __('excel.exceptions') }}</h2><p class="panel-hint">{{ __('excel.exceptions_help') }}</p></div></div>
    <div class="table-wrap table-wrap-inner"><table><thead><tr><th>{{ __('excel.entity') }}</th><th>{{ __('excel.field') }}</th><th>{{ __('excel.reason') }}</th><th>{{ __('excel.origin') }}</th></tr></thead><tbody>
    @foreach($batch->candidates as $candidate)
        @if($dispositions[$candidate->id]['action'] === 'review')<tr><td><a href="{{ route('admin.ingestion.candidates.show', $candidate) }}">{{ $candidate->name }}</a></td><td>—</td><td>{{ __('excel.reasons.'.$dispositions[$candidate->id]['reason']) }}</td><td>—</td></tr>@endif
    @endforeach
    @foreach(data_get($batch->metadata, 'identifier_issues', []) as $issue)<tr><td><a href="{{ route('admin.ingestion.candidates.show', $issue['candidate_id']) }}">{{ $issue['name'] }}</a></td><td>{{ $issue['provider'] }} · {{ $issue['id'] }}</td><td>{{ __('excel.reasons.'.$issue['reason']) }}</td><td>—</td></tr>@endforeach
    @foreach($fieldIssues as $issue)<tr><td><a href="{{ route('admin.ingestion.candidates.show', $issue['candidate']) }}">{{ $issue['candidate']->name }}</a></td><td>{{ data_get($issue['value']->metadata, 'label', $issue['value']->field_key) }}</td><td>{{ __('excel.reasons.'.$issue['reason']) }}</td><td>{{ data_get($issue['value']->metadata, 'sheet') }}{{ data_get($issue['value']->metadata, 'row') ? ' · '.data_get($issue['value']->metadata, 'row') : '' }}</td></tr>@endforeach
    @foreach(data_get($batch->metadata, 'issues', []) as $issue)<tr><td>—</td><td>{{ $issue['label'] ?? '—' }}</td><td>{{ __('excel.issues.'.$issue['code']) }}</td><td>{{ $issue['sheet'] }}{{ $issue['row'] ? ' · '.$issue['row'] : '' }}</td></tr>@endforeach
    </tbody></table></div>
    <div class="button-row detail-extra"><a class="button" href="{{ route('admin.review.index') }}">{{ __('workspace.review') }}</a></div>
</section>
@endif
<section class="panel detail-extra excel-records">
    <div class="panel-header"><div><h2>{{ __('excel.details') }}</h2><p class="panel-hint">{{ __('excel.sources_help') }}</p></div></div>
    @foreach($batch->candidates as $candidate)
    <details><summary>{{ $candidate->name }} · {{ $candidate->values->count() }} {{ __('excel.fields') }}</summary>
        <div class="table-wrap table-wrap-inner"><table><thead><tr><th>{{ __('excel.field') }}</th><th>{{ __('excel.value') }}</th><th>{{ __('excel.origin') }}</th><th>{{ __('excel.sources') }}</th></tr></thead><tbody>
        @foreach($candidate->values as $value)
            @php($decoded = $value->normalizedValue())
            <tr><td>{{ data_get($value->metadata, 'label', $value->field_key) }}<small><code>{{ $value->field_key }}</code></small></td><td class="excel-value">{{ is_scalar($decoded) ? (is_bool($decoded) ? ($decoded ? __('admin.common.yes') : __('admin.common.no')) : $decoded) : json_encode($decoded, JSON_UNESCAPED_UNICODE | JSON_UNESCAPED_SLASHES) }}</td><td>{{ data_get($value->metadata, 'sheet') }}{{ data_get($value->metadata, 'row') ? ' · '.data_get($value->metadata, 'row') : '' }}</td><td class="excel-value">{{ data_get($value->metadata, 'source_text') }}@foreach(data_get($value->metadata, 'source_urls', []) as $url)<small><a href="{{ $url }}" target="_blank" rel="noopener noreferrer">{{ parse_url($url, PHP_URL_HOST) }}</a></small>@endforeach</td></tr>
        @endforeach
        </tbody></table></div>
    </details>
    @endforeach
</section>
@endsection