@extends('layouts.admin')

@section('title', 'Member CSV Import')
@section('header_title', 'CSV Member Import Workflow')

@section('header_badge')
    <span class="text-xs font-semibold px-2.5 py-1 rounded-full bg-slate-100 text-slate-700 border border-slate-200">
        Bulk Member Ingestion
    </span>
@endsection

@section('content')
<div class="space-y-8">

    <!-- Import Steps Guidance -->
    <div class="bg-white p-6 rounded-2xl border border-slate-200/80 shadow-sm">
        <h3 class="text-base font-bold text-slate-800 mb-4">Complete 7-Step Import Protocol</h3>
        
        <div class="grid grid-cols-1 md:grid-cols-4 gap-4 text-xs">
            <div class="p-3.5 rounded-xl bg-slate-50 border border-slate-200/70 space-y-1">
                <span class="w-6 h-6 rounded-full bg-teal-600 text-white font-bold inline-flex items-center justify-center text-[11px] mb-1">A</span>
                <h4 class="font-bold text-slate-900">Download Template</h4>
                <p class="text-slate-500">Get pre-formatted CSV template with sample duplicate names & shared numbers.</p>
            </div>

            <div class="p-3.5 rounded-xl bg-slate-50 border border-slate-200/70 space-y-1">
                <span class="w-6 h-6 rounded-full bg-teal-600 text-white font-bold inline-flex items-center justify-center text-[11px] mb-1">B</span>
                <h4 class="font-bold text-slate-900">Upload CSV File</h4>
                <p class="text-slate-500">Select source roster file. Supports up to 10MB CSV data files.</p>
            </div>

            <div class="p-3.5 rounded-xl bg-slate-50 border border-slate-200/70 space-y-1">
                <span class="w-6 h-6 rounded-full bg-teal-600 text-white font-bold inline-flex items-center justify-center text-[11px] mb-1">C</span>
                <h4 class="font-bold text-slate-900">Preview & Validate</h4>
                <p class="text-slate-500">System inspects missing fields, invalid formats, and detects existing records.</p>
            </div>

            <div class="p-3.5 rounded-xl bg-slate-50 border border-slate-200/70 space-y-1">
                <span class="w-6 h-6 rounded-full bg-teal-600 text-white font-bold inline-flex items-center justify-center text-[11px] mb-1">D</span>
                <h4 class="font-bold text-slate-900">Confirm & Ingest</h4>
                <p class="text-slate-500">Atomic database insertion, Member Code generation, zero silent overwrites.</p>
            </div>
        </div>
    </div>

    <!-- Upload Card & Template Download Card -->
    <div class="grid grid-cols-1 lg:grid-cols-3 gap-6">
        
        <!-- Left 2 cols: Upload Form -->
        <div class="lg:col-span-2 bg-white p-6 rounded-2xl border border-slate-200/80 shadow-sm space-y-5">
            <h4 class="text-sm font-bold text-slate-800 border-b border-slate-100 pb-3">Step B: Upload Member CSV File</h4>

            <form method="POST" action="{{ route('admin.import.preview') }}" enctype="multipart/form-data" class="space-y-4">
                @csrf

                <div class="border-2 border-dashed border-slate-300 hover:border-teal-500 rounded-2xl p-8 text-center bg-slate-50/50 hover:bg-teal-50/30 transition cursor-pointer relative group">
                    <input type="file" name="csv_file" required accept=".csv,.txt" class="absolute inset-0 w-full h-full opacity-0 cursor-pointer">
                    <div class="space-y-2 pointer-events-none">
                        <div class="w-12 h-12 rounded-xl bg-teal-100 text-teal-700 flex items-center justify-center mx-auto text-xl shadow-xs group-hover:scale-110 transition">
                            <i class="fa-solid fa-cloud-arrow-up"></i>
                        </div>
                        <p class="text-xs font-bold text-slate-700">Click or drag & drop CSV file to upload</p>
                        <p class="text-[11px] text-slate-400">Accepted: Standard .CSV files up to 10MB</p>
                    </div>
                </div>

                <div class="flex items-center justify-between pt-2">
                    <span class="text-xs text-slate-500">File will be validated and shown in preview before ingestion.</span>
                    <button type="submit" class="px-5 py-2.5 rounded-xl text-xs font-bold text-white bg-teal-600 hover:bg-teal-700 transition shadow-md shadow-teal-500/20">
                        Upload & Preview Rows →
                    </button>
                </div>
            </form>
        </div>

        <!-- Right 1 col: Template Card -->
        <div class="bg-gradient-to-br from-navy-900 to-navy-950 text-white p-6 rounded-2xl shadow-sm space-y-4 flex flex-col justify-between">
            <div class="space-y-2">
                <span class="text-[10px] font-bold uppercase tracking-wider text-teal-400 bg-teal-950/80 px-2 py-0.5 rounded border border-teal-800/80">Step A: Master Template</span>
                <h4 class="text-base font-extrabold text-white">Download Standard CSV Template</h4>
                <p class="text-xs text-slate-300 leading-relaxed">
                    Includes all 17 supported column headers with sample records showing same-name members and shared family telephone numbers.
                </p>
            </div>

            <div class="space-y-2.5 pt-4">
                <a href="{{ route('admin.import.template') }}" class="w-full inline-flex items-center justify-center gap-2 py-2.5 px-4 rounded-xl text-xs font-bold bg-teal-500 hover:bg-teal-400 text-slate-950 transition shadow-md shadow-teal-500/20">
                    <i class="fa-solid fa-file-arrow-down"></i>
                    <span>Download CSV Template (.csv)</span>
                </a>
                <p class="text-[10px] text-slate-400 text-center">Ready-to-populate CSV format with sample data</p>
            </div>
        </div>

    </div>

    <!-- Past Import Batches Table -->
    <div class="bg-white rounded-2xl border border-slate-200/80 shadow-sm overflow-hidden">
        <div class="p-5 border-b border-slate-200 flex items-center justify-between">
            <div>
                <h4 class="text-base font-bold text-slate-800">CSV Import History</h4>
                <p class="text-xs text-slate-500">Audit history of completed and processed batches</p>
            </div>
        </div>

        <div class="overflow-x-auto">
            <table class="w-full text-left border-collapse text-sm">
                <thead>
                    <tr class="bg-slate-50 text-[11px] font-semibold text-slate-500 uppercase tracking-wider border-b border-slate-200">
                        <th class="py-3 px-5">Batch ID</th>
                        <th class="py-3 px-5">File Name</th>
                        <th class="py-3 px-5">Total Rows</th>
                        <th class="py-3 px-5">Success (New)</th>
                        <th class="py-3 px-5">Updated</th>
                        <th class="py-3 px-5">Skipped / Duplicates</th>
                        <th class="py-3 px-5">Imported By</th>
                        <th class="py-3 px-5">Date</th>
                        <th class="py-3 px-5 text-right">Action</th>
                    </tr>
                </thead>
                <tbody class="divide-y divide-slate-100 text-xs">
                    @forelse($batches as $b)
                        <tr class="hover:bg-slate-50/80">
                            <td class="py-3.5 px-5 font-mono font-bold text-slate-800">#{{ $b->id }}</td>
                            <td class="py-3.5 px-5 font-semibold text-slate-800">{{ $b->original_filename }}</td>
                            <td class="py-3.5 px-5 text-slate-600 font-bold">{{ $b->total_rows }}</td>
                            <td class="py-3.5 px-5 text-emerald-700 font-bold">{{ $b->successful_rows }}</td>
                            <td class="py-3.5 px-5 text-blue-700 font-medium">{{ $b->updated_rows }}</td>
                            <td class="py-3.5 px-5 text-amber-700 font-medium">{{ $b->skipped_rows }} ({{ $b->duplicate_rows }} dupes)</td>
                            <td class="py-3.5 px-5 text-slate-600">{{ $b->importedBy?->name ?? 'System' }}</td>
                            <td class="py-3.5 px-5 text-slate-500">{{ $b->created_at->format('M d, Y H:i') }}</td>
                            <td class="py-3.5 px-5 text-right">
                                <a href="{{ route('admin.import.show', $b) }}" class="text-teal-600 hover:text-teal-800 font-bold">
                                    View Batch →
                                </a>
                            </td>
                        </tr>
                    @empty
                        <tr>
                            <td colspan="9" class="py-8 text-center text-slate-400">
                                No previous import batches found. Upload your first CSV above.
                            </td>
                        </tr>
                    @endforelse
                </tbody>
            </table>
        </div>

        @if($batches->hasPages())
            <div class="px-6 py-4 border-t border-slate-200">
                {{ $batches->links() }}
            </div>
        @endif
    </div>

</div>
@endsection