@extends('layouts.admin')
@section('title','Import Students')
@section('breadcrumb')
<li class="breadcrumb-item"><a href="{{ route('admin.students.index') }}">Students</a></li>
<li class="breadcrumb-item active">Import CSV</li>
@endsection
@section('admin-content')

@php
use App\Models\{Institute, Course, AcademicSession, StudentAdvisor};
$institutes = Institute::where('is_active',true)->get();
$courses    = Course::where('is_active',true)->get();
$sessions   = AcademicSession::latest()->get();
$advisors   = StudentAdvisor::where('is_active',true)->get();
@endphp

<div class="row g-4">
<div class="col-xl-7">

<div class="card">
<div class="card-header">
    <h5 class="mb-0 fw-bold"><i class="fas fa-file-csv me-2 text-success"></i>Import Students from CSV</h5>
</div>
<div class="card-body">

{{-- INFO --}}
<div class="alert alert-info py-2 small mb-4">
    <strong>Each row = one student with individual fees &amp; assignment.</strong><br>
    Required columns: <code>name</code>, <code>email</code>, <code>institute</code>, <code>course</code>, <code>session</code>, <code>total_course_fee</code>, <code>institution_fee</code>.<br>
    Optional: <code>phone</code>, <code>father_name</code>, <code>gender</code>, <code>dob</code>, <code>aadhar_no</code>, <code>address</code>, <code>city</code>, <code>state</code>, <code>pincode</code>, <code>advisor</code>, <code>advisor_fee</code>, <code>fee_type</code>.<br>
    Use exact <strong>names or codes</strong> from the reference tables on the right.<br>
    <strong>Password</strong> = first 4 letters of name (UPPER) + last 4 digits of phone. E.g. <code>RAHU3210</code>.
</div>

{{-- COLUMNS TABLE --}}
<div class="table-responsive mb-4">
<table class="table table-sm table-bordered small mb-0">
<thead class="table-dark"><tr><th>Column</th><th>Required</th><th>Notes</th></tr></thead>
<tbody>
<tr><td><code>name</code></td><td><span class="badge bg-danger">Yes</span></td><td>Full name</td></tr>
<tr><td><code>email</code></td><td><span class="badge bg-danger">Yes</span></td><td>Unique login email</td></tr>
<tr><td><code>phone</code></td><td><span class="badge bg-secondary">No</span></td><td>Also accepted as <code>mobile</code></td></tr>
<tr><td><code>father_name</code></td><td><span class="badge bg-secondary">No</span></td><td>Also accepted as <code>father</code></td></tr>
<tr><td><code>gender</code></td><td><span class="badge bg-secondary">No</span></td><td>Male / Female / Other</td></tr>
<tr><td><code>dob</code></td><td><span class="badge bg-secondary">No</span></td><td>YYYY-MM-DD</td></tr>
<tr><td><code>aadhar_no</code></td><td><span class="badge bg-secondary">No</span></td><td></td></tr>
<tr><td><code>address</code>, <code>city</code>, <code>state</code>, <code>pincode</code></td><td><span class="badge bg-secondary">No</span></td><td></td></tr>
<tr><td><code>institute</code></td><td><span class="badge bg-danger">Yes</span></td><td>Name or Code from reference</td></tr>
<tr><td><code>course</code></td><td><span class="badge bg-danger">Yes</span></td><td>Name or Code from reference</td></tr>
<tr><td><code>session</code></td><td><span class="badge bg-danger">Yes</span></td><td>Session name from reference</td></tr>
<tr><td><code>advisor</code></td><td><span class="badge bg-secondary">No</span></td><td>Advisor name or code</td></tr>
<tr><td><code>total_course_fee</code></td><td><span class="badge bg-danger">Yes</span></td><td>Numeric e.g. 50000</td></tr>
<tr><td><code>institution_fee</code></td><td><span class="badge bg-danger">Yes</span></td><td>Numeric e.g. 45000</td></tr>
<tr><td><code>advisor_fee</code></td><td><span class="badge bg-secondary">No</span></td><td>Numeric, default 0</td></tr>
<tr><td><code>fee_type</code></td><td><span class="badge bg-secondary">No</span></td><td><code>one-time</code> or <code>semester-wise</code></td></tr>
</tbody>
</table>
</div>

{{-- DOWNLOAD SAMPLE --}}
<div class="mb-4">
    <button type="button" class="btn btn-outline-success btn-sm" onclick="downloadSample()">
        <i class="fas fa-download me-1"></i>Download Sample CSV
    </button>
</div>

{{-- UPLOAD FORM --}}
<form method="POST" action="{{ route('admin.students.import') }}" enctype="multipart/form-data">
@csrf
@if(session('success'))
<div class="alert alert-success small py-2">{{ session('success') }}</div>
@endif
<div class="mb-3">
    <label class="form-label fw-semibold">Select CSV File *</label>
    <input type="file" name="csv_file" class="form-control @error('csv_file') is-invalid @enderror" accept=".csv,.txt" required>
    @error('csv_file')<div class="invalid-feedback">{{ $message }}</div>@enderror
</div>
<div class="d-flex gap-2">
    <button type="submit" class="btn btn-success"><i class="fas fa-upload me-1"></i>Import Students</button>
    <a href="{{ route('admin.students.index') }}" class="btn btn-light">Cancel</a>
</div>
</form>

</div>
</div>

</div>
{{-- REFERENCE TABLES --}}
<div class="col-xl-5">

<div class="card mb-3">
<div class="card-header py-2 fw-semibold small"><i class="fas fa-university me-1 text-primary"></i>Institutes (use name or code)</div>
<div class="card-body p-0"><div class="table-responsive">
<table class="table table-sm mb-0 small">
<thead class="table-light"><tr><th>Name</th><th>Code</th></tr></thead>
<tbody>
@foreach($institutes as $i)
<tr><td>{{ $i->name }}</td><td><code>{{ $i->code }}</code></td></tr>
@endforeach
</tbody>
</table>
</div></div>
</div>

<div class="card mb-3">
<div class="card-header py-2 fw-semibold small"><i class="fas fa-book me-1 text-success"></i>Courses (use name or code)</div>
<div class="card-body p-0"><div class="table-responsive">
<table class="table table-sm mb-0 small">
<thead class="table-light"><tr><th>Name</th><th>Code</th></tr></thead>
<tbody>
@foreach($courses as $c)
<tr><td>{{ $c->name }}</td><td><code>{{ $c->code }}</code></td></tr>
@endforeach
</tbody>
</table>
</div></div>
</div>

<div class="card mb-3">
<div class="card-header py-2 fw-semibold small"><i class="fas fa-calendar me-1 text-warning"></i>Academic Sessions</div>
<div class="card-body p-0"><div class="table-responsive">
<table class="table table-sm mb-0 small">
<thead class="table-light"><tr><th>Name (use exact)</th></tr></thead>
<tbody>
@foreach($sessions as $s)
<tr><td>{{ $s->name }}</td></tr>
@endforeach
</tbody>
</table>
</div></div>
</div>

<div class="card">
<div class="card-header py-2 fw-semibold small"><i class="fas fa-user-tie me-1 text-violet"></i>Student Advisors (use name or code)</div>
<div class="card-body p-0"><div class="table-responsive">
<table class="table table-sm mb-0 small">
<thead class="table-light"><tr><th>Name</th><th>Code</th></tr></thead>
<tbody>
@foreach($advisors as $a)
<tr><td>{{ $a->name }}</td><td><code>{{ $a->advisor_code }}</code></td></tr>
@endforeach
</tbody>
</table>
</div></div>
</div>

</div>
</div>

<script>
function downloadSample() {
    var institutes = @json($institutes->pluck('name')->first() ?? 'Institute Name');
    var courses    = @json($courses->pluck('name')->first() ?? 'Course Name');
    var sessions   = @json($sessions->pluck('name')->first() ?? '2025-26');
    var advisors   = @json($advisors->pluck('name')->first() ?? '');

    var firstInst = @json(optional($institutes->first())->name ?? 'City College');
    var firstCourse = @json(optional($courses->first())->name ?? 'BCA');
    var firstSession = @json(optional($sessions->first())->name ?? '2025-26');
    var firstAdvisor = @json(optional($advisors->first())->name ?? '');

    var csv = "name,email,phone,father_name,gender,dob,aadhar_no,address,city,state,pincode,institute,course,session,advisor,total_course_fee,institution_fee,advisor_fee,fee_type\n";
    csv += "Rahul Sharma,rahul@example.com,9876543210,Ram Sharma,Male,2000-05-15,123456789012,123 Main St,Delhi,Delhi,110001,"
        + firstInst + "," + firstCourse + "," + firstSession + "," + firstAdvisor + ",50000,45000,2000,one-time\n";
    csv += "Priya Singh,priya@example.com,9123456789,Mohan Singh,Female,2001-08-22,987654321098,456 Park Ave,Mumbai,Maharashtra,400001,"
        + firstInst + "," + firstCourse + "," + firstSession + "," + firstAdvisor + ",60000,54000,3000,semester-wise\n";

    var blob = new Blob([csv], { type: 'text/csv' });
    var a = document.createElement('a');
    a.href = URL.createObjectURL(blob);
    a.download = 'students_import_sample.csv';
    a.click();
}
</script>
@endsection