@extends('layouts.admin')

@section('content')
<h2>Daftar Peserta Bergelar</h2>

<!-- Upload File Excel-->
    <div class="card">
        <div class="card-header h4">
            Upload File Excel
        </div>
        <div class="card-body">
            <form action="{{ route('admin.daftar-peserta-bergelar.submit-excel') }}" method="POST" enctype="multipart/form-data" class="form-data">
                @csrf
                <div class="form-group">
                    <input type="file" name="file-upload" class="form-control-file">
                </div>
                <div class="form-check">
                    <input type="checkbox" name="has-header" value="true" checked="checked" class="form-check-input"> 
                    <label for="has-header" class="form-check-label">Mengandung header</label> 
                </div>
                <br>
                <div class="form-group">
                    <input type="submit" name="submit" value="Upload" class="btn btn-default">
                </div>
            </form>

            @if (Session::has('key'))
            
                <h5><b>Tabel Hasil Upload</b></h5>
                <table>
                    <tr>
                        <th>No</th>
                        <th>NIM</th>
                        <th>Nama</th>
                        <th>Jenis Sertifikasi</th>
                        <th>Tahun Sertifikasi</th>
                    </tr>
            @if (Session::get('daftar-peserta-bergelar-column') !== null)
                @foreach (Session::get('daftar-peserta-bergelar-column') as $items)
                <tr>
                    @for ($i = 0; $i <=4; $i++)
                        @if ($i === 3)
                            <td>{{$items[5]}}</td>
                        @else
                            <td>{{$items[$i]}}</td>
                        @endif
                        
                    @endfor
                </tr>
                @endforeach 
            @endif
                </table>
                <form action="{{ route('admin.daftar-peserta-bergelar.store-data') }}" method="POST" class="form-data">
                    @csrf
                    <div class="form-group">
                        <input type="submit" name="submit" value="submit" class="btn btn-default">
                    </div>
                </form>
            
            @endif
        </div>
        <div class="card-footer text-muted">
            <div>
                <i>Upload File Excel (*.xlsx), preview kolom, lalu submit untuk impor ke database.</i>
            </div>
            <div>
                <i>Jika kolom tidak sesuai, ubah posisi kolom di Pengaturan.</i>
            </div>
        </div>
    </div>


<!-- Ambil Data menurut angkatan, jurusan, program-->
<div class="card">
    <div class="card-header h4">
        Ambil data
    </div>
    <div class="card-body">
        <form action="{{ route('admin.daftar-peserta-bergelar.get-data') }}" method="POST" class="form-data">
            @csrf
            <div class="form-group">
                <label for="angkatan">Angkatan</label>
                <input type="number" name="angkatan" min="2013" max="{{ date('Y') }}" value="2018" class="form-control" style="max-width : 120px;">
            </div>

            <div class="form-check">
                <input type="checkbox" name="semua-angkatan" value="true" class="form-check-input">
                <label for="semua-angkatan" class="form-check-label">Semua Angkatan</label>
            </div>
            <br>
            <div class="form-group">
                <label for="jurusan">Jurusan</label>
                <select name="jurusan" class="form-control">
                    <option value="">Semua Jurusan</option>
                    <option value="11">S1 Teknik Elektro</option>
                    <option value="21">S1 Teknik Sipil</option>
                    <option value="31">S1 Teknik Informatika</option>
                    <option value="71">D3 Teknik Elektro</option>
                    <option value="72">D3 Teknik Mesin</option>
                </select>
            </div>
            
            <div class="form-group">
                <label for="program">Program Sertifikasi</label>
                <select name="program" class="form-control">
                    <option value="">Semua Program</option>
                    @foreach ($results as $result)
                    <option value="{{ $result->kode_sertifikasi }}"> {{ $result->sertifikasi }} </option>
                    @endforeach
                </select>
            </div>

            <div class="form-group">
                <input type="submit" name="submit" value="submit" class="btn btn-default">
            </div>
            
        </form>

        @if (Session::get('daftar-peserta-bergelar-get-data') !== null)
            <h5 style="display : inline;"><b>Tabel daftar peserta bergelar</b></h5>

            <span class="btn btn-default" >
                <a href="{{ route('admin.daftar-peserta-bergelar.clear-data-view') }}" style="text-decoration:none;">Clear</a>
            </span> 

            <table>
                <tr>
                    <th>No</th>
                    <th>NIM</th>
                    <th>Nama</th>
                    <th>Jenis Sertifikasi</th>
                    <th>Tahun Sertifikasi</th>
                </tr>
                @foreach (Session::get('daftar-peserta-bergelar-get-data') as $item)
                    <tr>
                        <td>{{ $item->no }}</td>
                        <td>{{ $item->nim }}</td>
                        <td>{{ $item->nama }}</td>
                        <td>{{ $item->sertifikasi }}</td>
                        <td>{{ $item->tahun_sertifikasi }}</td>
                    </tr>
                @endforeach
            </table>
            <form action="{{ route('admin.daftar-peserta-bergelar.export-data') }}" method="POST" class="form-data">
                @csrf
                <div class="form-group">
                    <input type="submit" name="export" value="export" class="btn btn-default">
                </div>
                
            </form>
        @endif
    </div>

    <div class="card-footer text-muted">
        <div>
            <i>Lihat data untuk mahasiswa menurut angkatan, jurusan, maupun program.</i>
        </div>
        <div>
            <i>Untuk melihat data semua angkatan, centang "Semua Angkatan".</i>
        </div>
    </div>
</div>

@endsection