@extends('admin.layouts.app')
@section('title','Bulk Uploads')
@section('page-title','Bulk Uploads')
@section('page-subtitle','Import participants, voters, committee members, payments, and paper records')
@section('bulk-active','active')
@section('content')

@if(session('success'))<div class="alert alert-success">{{ session('success') }}</div>@endif
@if($errors->any())<div class="alert alert-danger"><ul class="mb-0">@foreach($errors->all() as $e)<li>{{ $e }}</li>@endforeach</ul></div>@endif

<form method="GET" class="mb-3">
    <div class="col-md-4">
        <select name="conference_id" class="form-select" onchange="this.form.submit()">
            <option value="">All Conferences</option>
            @foreach($conferences as $conf)
                <option value="{{ $conf->id }}" @selected($conferenceId == $conf->id)>{{ $conf->name }}</option>
            @endforeach
        </select>
    </div>
</form>

<div class="cardx p-4 mb-4">
    <h6 class="mb-3">Download Templates</h6>
    <div class="row g-2">
        @foreach($templateTypes as $key => $template)
            <div class="col-md-4 col-lg-3">
                <a href="{{ route('admin.bulk-uploads.template', $key) }}" class="btn btn-outline-green w-100">
                    <i class="fa fa-download me-1"></i>{{ $template['label'] }}
                </a>
            </div>
        @endforeach
    </div>
    <p class="small text-muted mt-3 mb-0">
        <strong>Eligible Voters</strong> — one row per voter; links to user accounts; feeds election OTP/voting.<br>
        <strong>Committee Members</strong> — creates committees by name if needed; updates existing members matched by email or name.<br>
        <strong>Payments</strong> — records offline/manual payments; auto-confirms successful rows and updates registration payment status.<br>
        <strong>Legacy / Structured Papers</strong> — see template headers for author and paper grouping rules.
    </p>
</div>

<div class='cardx p-4 mb-4'>
    <h6>Upload File</h6>
    <form method="POST" action="{{ route('admin.bulk-uploads.store') }}" enctype="multipart/form-data">
        @csrf
        <div class="row g-3 align-items-end">
            <div class="col-md-3">
                <label class="form-label">Upload Type</label>
                <select name="upload_type" class="form-select" required id="bulk-upload-type">
                    @foreach(['eligible_voters','participants','committee_members','payments','legacy_presentation_papers','structured_papers'] as $type)
                        <option value="{{ $type }}" @selected(old('upload_type', $preselectedUploadType ?? '') === $type)>{{ str_replace('_', ' ', ucfirst($type)) }}</option>
                    @endforeach
                </select>
            </div>
            <div class="col-md-3">
                <label class="form-label">Conference <span class="text-danger conference-required-star d-none">*</span></label>
                <select name="conference_id" class="form-select" id="bulk-conference-id">
                    <option value="">Select conference</option>
                    @foreach($conferences as $conf)
                        <option value="{{ $conf->id }}" @selected(old('conference_id', $conferenceId) == $conf->id)>{{ $conf->name }}</option>
                    @endforeach
                </select>
            </div>
            <div class="col-md-3" id="election-field-wrap">
                <label class="form-label">Election <span class="text-danger">*</span></label>
                <select name="election_id" class="form-select" id="bulk-election-id">
                    <option value="">Select election</option>
                    @foreach($elections as $election)
                        <option value="{{ $election->id }}" data-conference-id="{{ $election->conference_id }}" @selected(old('election_id', $preselectedElectionId ?? '') == $election->id)>
                            {{ $election->title }} ({{ $election->election_year }})
                        </option>
                    @endforeach
                </select>
                <div class="form-text">Required for eligible voter uploads.</div>
            </div>
            <div class="col-md-3">
                <label class="form-label">File (CSV / Excel)</label>
                <input type="file" name="file" class="form-control" accept=".csv,.txt,.xlsx,.xls" required>
            </div>
            <div class="col-md-3">
                <div class="form-check mb-2" id="generate-certificates-wrap">
                    <input type="checkbox" name="generate_certificates" value="1" class="form-check-input" id="generate_certificates">
                    <label class="form-check-label" for="generate_certificates">Generate presentation certificates</label>
                </div>
                <button type="submit" class="btn btn-green w-100">Upload</button>
            </div>
        </div>
    </form>
</div>

<div class='cardx p-4'>
    <h6>Upload History</h6>
    <div class="table-responsive">
        <table class='table'>
            <thead><tr><th>Date</th><th>Type</th><th>Conference</th><th>Uploaded By</th><th>Total</th><th>Success</th><th>Failed</th><th>Status</th></tr></thead>
            <tbody>
                @forelse($uploads as $upload)
                    <tr>
                        <td>{{ $upload->created_at->format('M d, Y H:i') }}</td>
                        <td>{{ str_replace('_', ' ', ucfirst($upload->upload_type)) }}</td>
                        <td>{{ $upload->conference?->name ?? '—' }}</td>
                        <td>{{ $upload->uploader?->name ?? '—' }}</td>
                        <td>{{ $upload->total_rows }}</td>
                        <td class="text-success">{{ $upload->successful_rows }}</td>
                        <td class="text-danger">{{ $upload->failed_rows }}</td>
                        <td><span class="badge badge-soft">{{ ucfirst($upload->status) }}</span></td>
                    </tr>
                @empty
                    <tr><td colspan="8" class="text-muted">No bulk uploads yet.</td></tr>
                @endforelse
            </tbody>
        </table>
    </div>
    {{ $uploads->links() }}
</div>

@push('scripts')
<script>
(function () {
    const typeSelect = document.getElementById('bulk-upload-type');
    const electionWrap = document.getElementById('election-field-wrap');
    const electionSelect = document.getElementById('bulk-election-id');
    const conferenceSelect = document.getElementById('bulk-conference-id');
    const certWrap = document.getElementById('generate-certificates-wrap');
    const conferenceStar = document.querySelector('.conference-required-star');

    const conferenceRequired = new Set([
        'participants', 'committee_members', 'payments',
        'legacy_presentation_papers', 'structured_papers'
    ]);

    function filterElections() {
        const conferenceId = conferenceSelect?.value || '';
        electionSelect?.querySelectorAll('option').forEach(function (opt) {
            if (!opt.value) return;
            const match = !conferenceId || opt.dataset.conferenceId === conferenceId;
            opt.hidden = !match;
            if (!match && opt.selected) {
                electionSelect.value = '';
            }
        });
    }

    function syncFields() {
        const type = typeSelect?.value;
        const isVoters = type === 'eligible_voters';
        const isLegacy = type === 'legacy_presentation_papers';
        const needsConference = conferenceRequired.has(type);

        electionWrap?.classList.toggle('d-none', !isVoters);
        electionSelect && (electionSelect.required = isVoters);
        certWrap?.classList.toggle('d-none', !isLegacy);
        conferenceStar?.classList.toggle('d-none', !needsConference);
        conferenceSelect && (conferenceSelect.required = needsConference || isVoters);

        if (isVoters) {
            filterElections();
        }
    }

    typeSelect?.addEventListener('change', syncFields);
    conferenceSelect?.addEventListener('change', filterElections);
    syncFields();
})();
</script>
@endpush
@endsection