@extends('layouts.main')

@section('isi')
<div id="kt_app_content_container" class="app-container  container-fluid ">
    <div class="card mb-10">
        <div class="card-header">
            <div class="card-title fs-3 fw-bold">Download Nilai Akhir</div>
        </div>

        <form id="my-form">
            <div class="card-body pt-9 pb-0">
                
                <div class="fv-row mb-7">
                    <div class="col-xl-3">
                        <div class="fs-6 fw-semibold mt-2 mb-3">Tahun Akademik</div>
                    </div>
                
                    <div class="col-xl-4">
                        <select class="form-select form-select-light" required name="thakad" id="thakad">
                            <option value="">Pilih Tahun Akademik</option>
                            @forelse ($tahunakademik as $item)
                                <option value="{{ $item->kodeta }}">{{ $item->thakad.' '.$item->semester }}</option>
                            @empty
                                <option value="">Tidak ada data</option>
                            @endforelse
                        </select>
                    </div>
                </div>

                <div class="fv-row mb-7">
                    <div class="col-xl-3">
                        <div class="fs-6 fw-semibold mt-2 mb-3">Status Pelatihan</div>
                    </div>
    
                    <div class="col-xl-4">
                        <select class="form-select form-select-light" required name="stspel" id="stspel">
                            <option value="">Pilih Status Pelatihan</option>
                            <option value="Reguler">Reguler</option>
                            <option value="Intensif">Intensif</option>
                        </select>
                    </div>
                </div>
    
                <div class="fv-row mb-7">
                    <div class="col-xl-3">
                        <div class="fs-6 fw-semibold mt-2 mb-3">Program Studi</div>
                    </div>
                    <div class="col-xl-4">
                        <select class="form-select form-select-light" required name="kode_dikti" id="kode_dikti">
                            <option value="">Pilih Program Studi</option>
                            @forelse ($programstudi as $item)
                                <option value="{{ $item->kdpst_dikti }}">{{ $item->jenjang . ' - ' . $item->prodi }}</option>
                            @empty
                                <option value="">Tidak ada data</option>
                            @endforelse
                        </select>
                    </div>
                </div>

                <div class="fv-row mb-7">
                    <div class="col-xl-3">
                        <div class="fs-6 fw-semibold mt-2 mb-3">Nama Pelatihan</div>
                    </div>
                    <div class="col-xl-5">
                        <select class="form-select form-select-light" required name="pelatihan_name" id="pelatihan_id">
                           
                        </select>
                    </div>
                    <span class="badge badge-light-danger">Ket : Kode Pelatihan - Nama Pelatihan - Kelas - Kurikulum</span>
                </div>
               

            </div>
    
            <div class="card-footer d-flex justify-content-start py-6 gap-5">
                <button type="button" id="downloadButton" class="btn btn-sm btn-primary">Download Excel</button>
            </div>
        </form>
    </div>

    <div id="content"></div>
</div>
@endsection

@push('js-page')
    <script type="text/javascript">
        $(document).ready(function() {
            $('#kode_dikti').on('change', function() {
                var thakad = $('#thakad').val();
                var stspel = $('#stspel').val();
                var kode_dikti = $('#kode_dikti').val();

                var urlPelatihan = "{{ route('downloadnilaiakhir.fetchListPelatihan') }}" ;

                $.ajax({
                    url: urlPelatihan,
                    type: "GET",

                    data: {
                        "_token": "{{ csrf_token() }}",
                        thakad: thakad,
                        stspel: stspel,
                        kode_dikti: kode_dikti
                    },
                    dataType: "json",
                    success: function(data) {
                        console.log('data');
                        $('#pelatihan_id').empty();
                        $('#pelatihan_id').append(
                            '<option value="">-- Pilih Pelatihan --</option>');
                        $.each(data, function(key, value) {
                            $('#pelatihan_id').append('<option value="' + value.id_jadwal + '">' 
                                + value.kd_mppel + ' - ' + value.matakuliahpelatihan.nmpel + ' - Kelas ' + value.kelas + ' - ' + value.matakuliahpelatihan.kurikulum + '</option>');
                        });
                        $('#pelatihan_id').trigger('change');
                    },
                    error: function(data) {
                        console.log('data error');
                        console.log(data);
                    }
                });
            });


            $('#downloadButton').click(function() {
                var thakad = $('#thakad').val();
                var stspel = $('#stspel').val();
                var kode_dikti = $('#kode_dikti').val();
                var pelatihan_id = $('#pelatihan_id').val();
               
                if (thakad == '') {
                    Swal.fire({
                        icon: 'error',
                        title: 'Oops...',
                        text: 'Tahun Akademik harus dipilih!',
                    });
                    return;
                }

                if (kode_dikti == '') {
                    Swal.fire({
                        icon: 'error',
                        title: 'Oops...',
                        text: 'Program Studi harus dipilih!',
                    });
                    return;
                }
               
                if (pelatihan_id == '') {
                    Swal.fire({
                        icon: 'error',
                        title: 'Oops...',
                        text: 'Pelatihan harus dipilih!',
                    });
                    return;
                }

                $.ajax({
                    url: '{{ route('downloadnilaiakhir.exportExcel') }}',
                    type: 'GET',
                    data: {
                        thakad:thakad,
                        stspel: stspel,
                        kode_dikti: kode_dikti,
                        pelatihan_id: pelatihan_id,
                    },

                    xhrFields: {
                        responseType: 'blob'
                    },
                    cache: false,
                    // Tambahkan parameter xhr untuk bisa membaca header
                    success: function(response, status, xhr) {
                        var blob = new Blob([response], {
                            type: 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'
                        });

                         // Ambil nama file dari header 'Content-Disposition' yang dikirim Laravel
                        let filename = "nilai_akhir.xlsx"; // Nama default
                        const disposition = xhr.getResponseHeader('Content-Disposition');
                        if (disposition && disposition.indexOf('attachment') !== -1) {
                            const filenameRegex = /filename[^;=\n]*=((['"]).*?\2|[^;\n]*)/;
                            const matches = filenameRegex.exec(disposition);
                            if (matches != null && matches[1]) {
                                filename = matches[1].replace(/['"]/g, '');
                            }
                        }

                        if (window.navigator && window.navigator.msSaveOrOpenBlob) {
                            window.navigator.msSaveOrOpenBlob(blob, 'file_name.pdf');
                        } else {
                            // Untuk browser modern (Chrome, Firefox, Safari)
                            const link = document.createElement('a');
                            link.href = window.URL.createObjectURL(blob);
                            // Gunakan timestamp di nama file
                            link.download = filename; 
                            link.click();
                        }

                        Swal.fire({
                            icon: 'success',
                            title: 'Berhasil',
                            text: 'Nilai Akhir berhasil diunduh!',
                        });
                    },
                    error: function(xhr) {
                        console.log(xhr);

                        Swal.fire({
                            icon: 'error',
                            title: 'Oops...',
                            text: 'Terjadi kesalahan saat mengunduh Nilai Akhir!',
                        });
                    }
                });
            });

            

            

        });   
    </script>
@endpush