@extends('layouts.app')
@section('title', $pageTitle ?? __('Manual ADP Import'))

@section('contents')
<section class="content">
    <div class="container-fluid">
        @if (session('status'))
            <div class="alert alert-success">{{ session('status') }}</div>
        @endif
        @if (session('warning'))
            <div class="alert alert-warning">{{ session('warning') }}</div>
        @endif

        <div class="row">
            <div class="col-lg-10">
                <div class="card card-outline card-primary">
                    <div class="card-header">
                        <h3 class="card-title mb-0">{{ __('Manual ADP / Financial Year Import') }}</h3>
                    </div>
                    <div class="card-body">
                        <p class="text-muted">
                            {{ __('Temporary tool for super admins. Upload the filled export workbook (.xlsx) or CSV to set ADP No. and Financial Year on') }}
                            <code>mec_reports</code>, {{ __('report payload (cover / Part A), and saved publish letter HTML for reports whose visit plan is before FY July 2026–June 2027. Re-importing updates rows that already have ADP/FY. Reports on or after that FY are skipped (BMS snapshot).') }}
                        </p>
                        <p class="text-muted mb-3">
                            {{ __('Required columns (row 1):') }}
                            <strong>Report ID</strong>,
                            <strong>ADP No. (fill)</strong>,
                            <strong>Financial Year (fill)</strong>.
                            {{ __('Export a fresh list with') }}
                            <code>php artisan mec-reports:export-manual-adp-list --pending-only</code>.
                        </p>

                        <form method="post" action="{{ route('reports.manual-adp-import.diagnose') }}" enctype="multipart/form-data">
                            @csrf
                            <div class="form-group">
                                <label for="import_file">{{ __('Excel file') }}</label>
                                <input type="file" name="file" id="import_file" accept=".xlsx,.xls,.csv" required class="form-control-file" />
                                @error('file')<p class="text-danger small mb-0">{{ $message }}</p>@enderror
                            </div>
                            <button type="submit" class="btn btn-primary">{{ __('Diagnose file') }}</button>
                        </form>
                    </div>
                </div>

                @if ($diagnosis)
                    @php
                        $summary = $diagnosis['summary'] ?? ['total' => 0, 'ready' => 0, 'skipped' => 0, 'errors' => 0];
                        $rows = $diagnosis['rows'] ?? [];
                    @endphp
                    <div class="card card-outline card-info mt-3">
                        <div class="card-header d-flex justify-content-between align-items-center">
                            <h3 class="card-title mb-0">{{ __('Diagnosis') }}</h3>
                            <span class="badge badge-light">
                                {{ __(':ready ready · :skipped skipped · :errors errors · :total rows', [
                                    'ready' => $summary['ready'],
                                    'skipped' => $summary['skipped'],
                                    'errors' => $summary['errors'],
                                    'total' => $summary['total'],
                                ]) }}
                            </span>
                        </div>
                        <div class="card-body p-0">
                            <div class="table-responsive" style="max-height: 420px;">
                                <table class="table table-sm table-striped mb-0">
                                    <thead class="thead-light">
                                        <tr>
                                            <th>{{ __('Row') }}</th>
                                            <th>{{ __('Report ID') }}</th>
                                            <th>{{ __('ADP (file)') }}</th>
                                            <th>{{ __('FY (file)') }}</th>
                                            <th>{{ __('Status') }}</th>
                                            <th>{{ __('Message') }}</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        @forelse ($rows as $row)
                                            @php
                                                $status = $row['status'] ?? 'error';
                                                $badge = match ($status) {
                                                    'ready' => 'success',
                                                    'skipped' => 'secondary',
                                                    default => 'danger',
                                                };
                                            @endphp
                                            <tr>
                                                <td>{{ $row['excel_row'] ?? '' }}</td>
                                                <td>{{ $row['report_id'] ?? '' }}</td>
                                                <td>{{ $row['adp_raw'] ?? '' }}</td>
                                                <td>{{ $row['financial_year_raw'] ?? '' }}</td>
                                                <td><span class="badge badge-{{ $badge }}">{{ $status }}</span></td>
                                                <td class="small">{{ $row['message'] ?? '' }}</td>
                                            </tr>
                                        @empty
                                            <tr><td colspan="6" class="text-muted text-center py-3">{{ __('No data rows in file.') }}</td></tr>
                                        @endforelse
                                    </tbody>
                                </table>
                            </div>
                        </div>
                        @if (($summary['ready'] ?? 0) > 0)
                            <div class="card-footer">
                                <form method="post" action="{{ route('reports.manual-adp-import.apply') }}" onsubmit="return confirm(@json(__('Apply :count update(s) to mec_reports?', ['count' => $summary['ready']])))">
                                    @csrf
                                    <button type="submit" class="btn btn-success">{{ __('Apply :count update(s)', ['count' => $summary['ready']]) }}</button>
                                </form>
                                @error('apply')<p class="text-danger small mb-0 mt-2">{{ $message }}</p>@enderror
                            </div>
                        @endif
                    </div>
                @endif

                @if (! empty(session('import_apply_errors')))
                    <div class="card card-outline card-warning mt-3">
                        <div class="card-header">
                            <h3 class="card-title mb-0">{{ __('Apply errors') }}</h3>
                        </div>
                        <div class="card-body">
                            <ul class="pl-3 mb-0 small">
                                @foreach (session('import_apply_errors') as $line)
                                    <li>{{ $line }}</li>
                                @endforeach
                            </ul>
                        </div>
                    </div>
                @endif
            </div>
        </div>
    </div>
</section>
@endsection