@extends('layouts.app')

@section('title', 'Export Data - SIAKAD')
@section('page-title', 'Export Data ke Excel')

@section('content')
<div class="row">
    {{-- Mahasiswa --}}
    <div class="col-lg-6">
        <div class="card">
            <div class="card-header">
                <h5 class="mb-0"><i class="bi bi-mortarboard me-2"></i>Export Mahasiswa</h5>
            </div>
            <div class="card-body">
                <p class="text-muted">Export semua data mahasiswa ke file Excel.</p>

                <form action="{{ route('admin.export.mahasiswa') }}" method="GET" target="_blank">
                    <div class="row mb-3">
                        <div class="col-md-6">
                            <label class="form-label">Program Studi</label>
                            <select name="prodi_id" class="form-select">
                                <option value="">Semua Prodi</option>
                                @foreach(App\Models\Prodi::all() as $prodi)
                                    <option value="{{ $prodi->id }}">{{ $prodi->jenjang }} - {{ $prodi->nama }}</option>
                                @endforeach
                            </select>
                        </div>
                        <div class="col-md-6">
                            <label class="form-label">Status</label>
                            <select name="status" class="form-select">
                                <option value="">Semua Status</option>
                                <option value="aktif">Aktif</option>
                                <option value="nonaktif">Nonaktif</option>
                                <option value="cuti">Cuti</option>
                                <option value="lulus">Lulus</option>
                                <option value="do">Drop Out</option>
                            </select>
                        </div>
                    </div>
                    <button type="submit" class="btn btn-success w-100">
                        <i class="bi bi-download me-1"></i>Export ke Excel
                    </button>
                </form>
            </div>
        </div>
    </div>

    {{-- Dosen --}}
    <div class="col-lg-6">
        <div class="card">
            <div class="card-header">
                <h5 class="mb-0"><i class="bi bi-person-badge me-2"></i>Export Dosen</h5>
            </div>
            <div class="card-body">
                <p class="text-muted">Export semua data dosen ke file Excel.</p>

                <form action="{{ route('admin.export.dosen') }}" method="GET" target="_blank">
                    <div class="row mb-3">
                        <div class="col-md-12">
                            <label class="form-label">Status</label>
                            <select name="status" class="form-select">
                                <option value="">Semua Status</option>
                                <option value="aktif">Aktif</option>
                                <option value="nonaktif">Nonaktif</option>
                            </select>
                        </div>
                    </div>
                    <button type="submit" class="btn btn-success w-100">
                        <i class="bi bi-download me-1"></i>Export ke Excel
                    </button>
                </form>
            </div>
        </div>
    </div>
</div>

<div class="row mt-4">
    {{-- Mata Kuliah --}}
    <div class="col-lg-6">
        <div class="card">
            <div class="card-header">
                <h5 class="mb-0"><i class="bi bi-book me-2"></i>Export Mata Kuliah</h5>
            </div>
            <div class="card-body">
                <p class="text-muted">Export semua data mata kuliah ke file Excel.</p>

                <form action="{{ route('admin.export.matakuliah') }}" method="GET" target="_blank">
                    <div class="row mb-3">
                        <div class="col-md-12">
                            <label class="form-label">Program Studi</label>
                            <select name="prodi_id" class="form-select">
                                <option value="">Semua Prodi</option>
                                @foreach(App\Models\Prodi::all() as $prodi)
                                    <option value="{{ $prodi->id }}">{{ $prodi->jenjang }} - {{ $prodi->nama }}</option>
                                @endforeach
                            </select>
                        </div>
                    </div>
                    <button type="submit" class="btn btn-success w-100">
                        <i class="bi bi-download me-1"></i>Export ke Excel
                    </button>
                </form>
            </div>
        </div>
    </div>

    {{-- Nilai --}}
    <div class="col-lg-6">
        <div class="card">
            <div class="card-header">
                <h5 class="mb-0"><i class="bi bi-award me-2"></i>Export Nilai</h5>
            </div>
            <div class="card-body">
                <p class="text-muted">Export semua data nilai mahasiswa ke file Excel.</p>

                <form action="{{ route('admin.export.nilai') }}" method="GET" target="_blank">
                    <div class="row mb-3">
                        <div class="col-md-4">
                            <label class="form-label">Program Studi</label>
                            <select name="prodi_id" class="form-select">
                                <option value="">Semua Prodi</option>
                                @foreach(App\Models\Prodi::all() as $prodi)
                                    <option value="{{ $prodi->id }}">{{ $prodi->jenjang }} - {{ $prodi->nama }}</option>
                                @endforeach
                            </select>
                        </div>
                        <div class="col-md-4">
                            <label class="form-label">Tahun Akademik</label>
                            <select name="tahun_akademik_id" class="form-select">
                                <option value="">Semua</option>
                                @foreach(App\Models\TahunAkademik::orderBy('tahun', 'desc')->get() as $ta)
                                    <option value="{{ $ta->id }}">{{ $ta->tahun }} - {{ $ta->semester }}</option>
                                @endforeach
                            </select>
                        </div>
                        <div class="col-md-4">
                            <label class="form-label">Semester</label>
                            <select name="semester" class="form-select">
                                <option value="">Semua</option>
                                @for($i = 1; $i <= 14; $i++)
                                    <option value="{{ $i }}">Semester {{ $i }}</option>
                                @endfor
                            </select>
                        </div>
                    </div>
                    <button type="submit" class="btn btn-success w-100">
                        <i class="bi bi-download me-1"></i>Export ke Excel
                    </button>
                </form>
            </div>
        </div>
    </div>
</div>

<div class="row mt-4">
    {{-- KRS --}}
    <div class="col-lg-6">
        <div class="card">
            <div class="card-header">
                <h5 class="mb-0"><i class="bi bi-card-checklist me-2"></i>Export KRS</h5>
            </div>
            <div class="card-body">
                <p class="text-muted">Export semua data KRS ke file Excel.</p>

                <form action="{{ route('admin.export.krs') }}" method="GET" target="_blank">
                    <div class="row mb-3">
                        <div class="col-md-4">
                            <label class="form-label">Program Studi</label>
                            <select name="prodi_id" class="form-select">
                                <option value="">Semua Prodi</option>
                                @foreach(App\Models\Prodi::all() as $prodi)
                                    <option value="{{ $prodi->id }}">{{ $prodi->jenjang }} - {{ $prodi->nama }}</option>
                                @endforeach
                            </select>
                        </div>
                        <div class="col-md-4">
                            <label class="form-label">Tahun Akademik</label>
                            <select name="tahun_akademik_id" class="form-select">
                                <option value="">Semua</option>
                                @foreach(App\Models\TahunAkademik::orderBy('tahun', 'desc')->get() as $ta)
                                    <option value="{{ $ta->id }}">{{ $ta->tahun }} - {{ $ta->semester }}</option>
                                @endforeach
                            </select>
                        </div>
                        <div class="col-md-4">
                            <label class="form-label">Status</label>
                            <select name="status" class="form-select">
                                <option value="">Semua</option>
                                <option value="pending">Pending</option>
                                <option value="disetujui">Disetujui</option>
                                <option value="ditolak">Ditolak</option>
                            </select>
                        </div>
                    </div>
                    <button type="submit" class="btn btn-success w-100">
                        <i class="bi bi-download me-1"></i>Export ke Excel
                    </button>
                </form>
            </div>
        </div>
    </div>

    {{-- Info --}}
    <div class="col-lg-6">
        <div class="card border-primary">
            <div class="card-header bg-primary text-white">
                <h5 class="mb-0"><i class="bi bi-info-circle me-2"></i>Informasi Export</h5>
            </div>
            <div class="card-body">
                <ul class="mb-0">
                    <li class="mb-2">File export berformat <strong>.xlsx</strong> (Excel 2007+)</li>
                    <li class="mb-2">Gunakan filter untuk membatasi data yang di-export</li>
                    <li class="mb-2">Data dapat langsung dibuka di Microsoft Excel atau Google Sheets</li>
                    <li>Jika data kosong, pastikan filter yang dipilih memiliki data</li>
                </ul>
            </div>
        </div>
    </div>
</div>
@endsection